johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
283 rows where confirmed = 2061 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 17
- North Carolina 17
- Wisconsin 16
- Kentucky 15
- Michigan 15
- West Virginia 14
- Minnesota 12
- Tennessee 12
- Alabama 11
- Arkansas 11
- Montana 10
- Iowa 9
- Louisiana 9
- Missouri 9
- Virginia 9
- Texas 8
- Alaska 7
- Illinois 7
- Puerto Rico 7
- North Dakota 6
- California 5
- Colorado 5
- Kansas 5
- Mississippi 5
- Ohio 5
- Washington 5
- Nevada 4
- New York 3
- Pennsylvania 3
- South Carolina 3
- …
country_or_region 1
- US · 283 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
851342 | 851342 | 2022-11-02 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-03 04:22:05 | Mahnomen, Minnesota, US | |
712193 | 712193 | 2022-11-01 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-02 04:22:09 | Mahnomen, Minnesota, US | |
3286642 | 3286642 | 2022-10-31 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-01 04:22:36 | Mahnomen, Minnesota, US | |
321675 | 321675 | 2022-10-30 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-10-31 04:21:36 | Mahnomen, Minnesota, US | |
913951 | 913951 | 2022-10-29 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-10-30 04:22:14 | Mahnomen, Minnesota, US | |
1368220 | 1368220 | 2022-10-28 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-10-29 04:21:13 | Mahnomen, Minnesota, US | |
3040075 | 3040075 | 2022-10-27 | US | Minnesota | Mahnomen | 27087 | 2061 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-10-28 04:22:31 | Mahnomen, Minnesota, US | |
2759907 | 2759907 | 2022-10-18 | US | Tennessee | Pickett | 47137 | 2061 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-19 04:22:26 | Pickett, Tennessee, US | |
3252450 | 3252450 | 2022-10-11 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-12 04:22:51 | Camden, North Carolina, US | |
2969709 | 2969709 | 2022-10-10 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-11 04:23:05 | Camden, North Carolina, US | |
3099745 | 3099745 | 2022-10-09 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-10 04:22:32 | Camden, North Carolina, US | |
4004970 | 4004970 | 2022-10-08 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-09 04:21:16 | Camden, North Carolina, US | |
398567 | 398567 | 2022-10-07 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-08 04:22:56 | Camden, North Carolina, US | |
2531684 | 2531684 | 2022-10-06 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-07 04:23:08 | Camden, North Carolina, US | |
1813078 | 1813078 | 2022-10-05 | US | North Carolina | Camden | 37029 | 2061 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-10-06 04:21:22 | Camden, North Carolina, US | |
3550708 | 3550708 | 2022-09-01 | US | Texas | Rains | 48379 | 2061 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-02 04:21:07 | Rains, Texas, US | |
3953801 | 3953801 | 2022-08-17 | US | Virginia | Bland | 51021 | 2061 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-18 04:21:11 | Bland, Virginia, US | |
3649117 | 3649117 | 2022-08-14 | US | Louisiana | St. Helena | 22091 | 2061 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-15 04:20:59 | St. Helena, Louisiana, US | |
1970123 | 1970123 | 2022-08-13 | US | Louisiana | St. Helena | 22091 | 2061 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-14 04:20:55 | St. Helena, Louisiana, US | |
2889932 | 2889932 | 2022-08-12 | US | Louisiana | St. Helena | 22091 | 2061 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-13 04:20:52 | St. Helena, Louisiana, US | |
3909537 | 3909537 | 2022-08-11 | US | Louisiana | St. Helena | 22091 | 2061 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-12 04:20:54 | St. Helena, Louisiana, US | |
1347854 | 1347854 | 2022-08-10 | US | Louisiana | St. Helena | 22091 | 2061 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-11 04:20:49 | St. Helena, Louisiana, US | |
3546855 | 3546855 | 2022-08-08 | US | Virginia | Lancaster | 51103 | 2061 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-08-09 04:20:34 | Lancaster, Virginia, US | |
3546968 | 3546968 | 2022-08-08 | US | West Virginia | Calhoun | 54013 | 2061 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-09 04:20:34 | Calhoun, West Virginia, US | |
1405467 | 1405467 | 2022-08-02 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-08-03 04:20:59 | Dillingham, Alaska, US | |
3617505 | 3617505 | 2022-08-01 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-08-02 04:20:53 | Dillingham, Alaska, US | |
3871985 | 3871985 | 2022-07-31 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-08-01 04:21:03 | Dillingham, Alaska, US | |
674739 | 674739 | 2022-07-30 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-07-31 04:21:02 | Dillingham, Alaska, US | |
1783938 | 1783938 | 2022-07-29 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-07-30 04:20:42 | Dillingham, Alaska, US | |
1784148 | 1784148 | 2022-07-29 | US | Colorado | Lake | 8065 | 2061 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-30 04:20:42 | Lake, Colorado, US | |
1066301 | 1066301 | 2022-07-28 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-07-29 04:20:45 | Dillingham, Alaska, US | |
2335820 | 2335820 | 2022-07-27 | US | Alaska | Dillingham | 2070 | 2061 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-07-28 04:20:56 | Dillingham, Alaska, US | |
2336007 | 2336007 | 2022-07-27 | US | Colorado | Conejos | 8021 | 2061 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-28 04:20:56 | Conejos, Colorado, US | |
2597599 | 2597599 | 2022-07-25 | US | Wisconsin | Menominee | 55078 | 2061 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-26 04:20:58 | Menominee, Wisconsin, US | |
899714 | 899714 | 2022-07-24 | US | Wisconsin | Menominee | 55078 | 2061 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-25 04:20:51 | Menominee, Wisconsin, US | |
94708 | 94708 | 2022-07-23 | US | Wisconsin | Menominee | 55078 | 2061 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-24 04:20:47 | Menominee, Wisconsin, US | |
903730 | 903730 | 2022-07-22 | US | Wisconsin | Menominee | 55078 | 2061 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-23 04:20:53 | Menominee, Wisconsin, US | |
3432472 | 3432472 | 2022-07-14 | US | West Virginia | Pendleton | 54071 | 2061 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-07-15 04:20:53 | Pendleton, West Virginia, US | |
3112992 | 3112992 | 2022-07-13 | US | West Virginia | Pendleton | 54071 | 2061 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-07-14 04:20:57 | Pendleton, West Virginia, US | |
2151215 | 2151215 | 2022-06-27 | US | Wisconsin | Pepin | 55091 | 2061 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-28 04:20:58 | Pepin, Wisconsin, US | |
479016 | 479016 | 2022-06-26 | US | Wisconsin | Pepin | 55091 | 2061 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-27 04:21:00 | Pepin, Wisconsin, US | |
942391 | 942391 | 2022-06-25 | US | Wisconsin | Pepin | 55091 | 2061 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-26 04:21:02 | Pepin, Wisconsin, US | |
3350211 | 3350211 | 2022-06-24 | US | Wisconsin | Pepin | 55091 | 2061 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-25 04:20:57 | Pepin, Wisconsin, US | |
3144530 | 3144530 | 2022-06-11 | US | Tennessee | Hancock | 47067 | 2061 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-12 04:20:53 | Hancock, Tennessee, US | |
3507745 | 3507745 | 2022-06-05 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-06 04:20:57 | Choctaw, Alabama, US | |
3527822 | 3527822 | 2022-06-04 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-05 04:20:55 | Choctaw, Alabama, US | |
3133908 | 3133908 | 2022-06-03 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-04 04:20:58 | Choctaw, Alabama, US | |
3578983 | 3578983 | 2022-06-02 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-03 04:20:58 | Choctaw, Alabama, US | |
971276 | 971276 | 2022-06-01 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-02 05:20:39 | Choctaw, Alabama, US | |
229583 | 229583 | 2022-05-31 | US | Alabama | Choctaw | 1023 | 2061 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-01 04:20:55 | Choctaw, Alabama, US | |
1950196 | 1950196 | 2022-04-12 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-13 04:21:03 | Presque Isle, Michigan, US | |
3207949 | 3207949 | 2022-04-11 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-12 04:20:49 | Presque Isle, Michigan, US | |
1577835 | 1577835 | 2022-04-10 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-11 04:21:02 | Presque Isle, Michigan, US | |
1654077 | 1654077 | 2022-04-09 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-10 04:20:52 | Presque Isle, Michigan, US | |
2117399 | 2117399 | 2022-04-08 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-09 04:20:42 | Presque Isle, Michigan, US | |
3321923 | 3321923 | 2022-04-07 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-08 04:20:48 | Presque Isle, Michigan, US | |
2801626 | 2801626 | 2022-04-06 | US | Georgia | Montgomery | 13209 | 2061 | 53 | 0 | 32.17201038 | -82.53527476 | 2022-04-07 04:20:53 | Montgomery, Georgia, US | |
2802459 | 2802459 | 2022-04-06 | US | Michigan | Presque Isle | 26141 | 2061 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-07 04:20:53 | Presque Isle, Michigan, US | |
3868395 | 3868395 | 2022-04-05 | US | Georgia | Montgomery | 13209 | 2061 | 52 | 0 | 32.17201038 | -82.53527476 | 2022-04-06 04:20:49 | Montgomery, Georgia, US | |
2749737 | 2749737 | 2022-04-04 | US | Georgia | Montgomery | 13209 | 2061 | 52 | 0 | 32.17201038 | -82.53527476 | 2022-04-05 04:20:48 | Montgomery, Georgia, US | |
159695 | 159695 | 2022-03-29 | US | Michigan | Presque Isle | 26141 | 2061 | 57 | 0 | 45.34018577 | -83.91498656 | 2022-03-30 04:20:45 | Presque Isle, Michigan, US | |
1438266 | 1438266 | 2022-03-28 | US | Michigan | Presque Isle | 26141 | 2061 | 57 | 0 | 45.34018577 | -83.91498656 | 2022-03-29 04:20:46 | Presque Isle, Michigan, US | |
879771 | 879771 | 2022-03-27 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-28 04:20:33 | Pleasants, West Virginia, US | |
2167054 | 2167054 | 2022-03-26 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-27 04:20:47 | Pleasants, West Virginia, US | |
1723990 | 1723990 | 2022-03-25 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-26 04:20:23 | Pleasants, West Virginia, US | |
1470087 | 1470087 | 2022-03-24 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-25 04:20:46 | Blaine, Montana, US | |
1471607 | 1471607 | 2022-03-24 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-25 04:20:46 | Pleasants, West Virginia, US | |
3024261 | 3024261 | 2022-03-23 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-24 04:20:43 | Blaine, Montana, US | |
3025781 | 3025781 | 2022-03-23 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-24 04:20:43 | Pleasants, West Virginia, US | |
1907183 | 1907183 | 2022-03-22 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-23 04:20:48 | Blaine, Montana, US | |
3240314 | 3240314 | 2022-03-21 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-22 04:20:54 | Blaine, Montana, US | |
26083 | 26083 | 2022-03-20 | US | Michigan | Presque Isle | 26141 | 2061 | 56 | 0 | 45.34018577 | -83.91498656 | 2022-03-21 04:20:50 | Presque Isle, Michigan, US | |
26387 | 26387 | 2022-03-20 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-21 04:20:50 | Blaine, Montana, US | |
1658093 | 1658093 | 2022-03-19 | US | Michigan | Presque Isle | 26141 | 2061 | 56 | 0 | 45.34018577 | -83.91498656 | 2022-03-20 04:20:45 | Presque Isle, Michigan, US | |
1658397 | 1658397 | 2022-03-19 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-20 04:20:45 | Blaine, Montana, US | |
337619 | 337619 | 2022-03-18 | US | Michigan | Presque Isle | 26141 | 2061 | 56 | 0 | 45.34018577 | -83.91498656 | 2022-03-19 04:20:47 | Presque Isle, Michigan, US | |
337923 | 337923 | 2022-03-18 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-19 04:20:47 | Blaine, Montana, US | |
696376 | 696376 | 2022-03-17 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-18 04:20:55 | Blaine, Montana, US | |
697896 | 697896 | 2022-03-17 | US | West Virginia | Pleasants | 54073 | 2061 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-18 04:20:55 | Pleasants, West Virginia, US | |
2321319 | 2321319 | 2022-03-16 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-17 04:20:56 | Blaine, Montana, US | |
263519 | 263519 | 2022-03-15 | US | Montana | Blaine | 30005 | 2061 | 31 | 0 | 48.43175214 | -108.9582723 | 2022-03-16 04:20:50 | Blaine, Montana, US | |
2142949 | 2142949 | 2022-03-09 | US | Puerto Rico | Sabana Grande | 72121 | 2061 | 0 | 0 | 18.08282 | -66.943758 | 2022-03-10 04:20:48 | Sabana Grande, Puerto Rico, US | |
2526144 | 2526144 | 2022-03-02 | US | Georgia | Clinch | 13065 | 2061 | 38 | 0 | 30.91395822 | -82.70432472 | 2022-03-03 04:21:01 | Clinch, Georgia, US | |
1993811 | 1993811 | 2022-03-01 | US | Indiana | Warren | 18171 | 2061 | 25 | 0 | 40.34728141 | -87.35602659 | 2022-03-02 04:21:07 | Warren, Indiana, US | |
1061330 | 1061330 | 2022-02-23 | US | West Virginia | Gilmer | 54021 | 2061 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-24 04:21:14 | Gilmer, West Virginia, US | |
3673029 | 3673029 | 2022-02-15 | US | Kentucky | Bracken | 21023 | 2061 | 23 | 0 | 38.69158994 | -84.08532444 | 2022-02-16 04:21:10 | Bracken, Kentucky, US | |
3074921 | 3074921 | 2022-02-09 | US | Georgia | Stewart | 13259 | 2061 | 31 | 0 | 32.07996777 | -84.83208037 | 2022-02-10 04:21:14 | Stewart, Georgia, US | |
3075522 | 3075522 | 2022-02-09 | US | Kentucky | Trimble | 21223 | 2061 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-10 04:21:14 | Trimble, Kentucky, US | |
3077061 | 3077061 | 2022-02-09 | US | Texas | Archer | 48009 | 2061 | 26 | 0 | 33.61569967 | -98.68754589 | 2022-02-10 04:21:14 | Archer, Texas, US | |
72995 | 72995 | 2022-02-07 | US | Missouri | Gentry | 29075 | 2061 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-02-08 04:21:15 | Gentry, Missouri, US | |
2329797 | 2329797 | 2022-02-04 | US | North Dakota | Traill | 38097 | 2061 | 22 | 0 | 47.45367788 | -97.16323288 | 2022-02-05 04:21:05 | Traill, North Dakota, US | |
461316 | 461316 | 2022-02-02 | US | Missouri | Monroe | 29137 | 2061 | 38 | 0 | 39.49593978 | -92.00043978 | 2022-02-03 04:21:21 | Monroe, Missouri, US | |
981270 | 981270 | 2022-02-01 | US | North Carolina | Graham | 37075 | 2061 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-02-02 04:21:09 | Graham, North Carolina, US | |
2659702 | 2659702 | 2022-01-31 | US | Missouri | Howard | 29089 | 2061 | 22 | 0 | 39.1435761 | -92.69756691 | 2022-02-01 04:21:11 | Howard, Missouri, US | |
3228389 | 3228389 | 2022-01-19 | US | Missouri | Montgomery | 29139 | 2061 | 36 | 0 | 38.94022054 | -91.47000721 | 2022-01-20 04:21:07 | Montgomery, Missouri, US | |
2611611 | 2611611 | 2022-01-06 | US | Maine | Piscataquis | 23021 | 2061 | 23 | 0 | 45.83839062 | -69.2860223 | 2022-01-07 04:22:09 | Piscataquis, Maine, US | |
2613003 | 2613003 | 2022-01-06 | US | Tennessee | Houston | 47083 | 2061 | 53 | 0 | 36.28872054 | -87.71878828 | 2022-01-07 04:22:09 | Houston, Tennessee, US | |
4002000 | 4002000 | 2021-12-30 | US | Virginia | Greensville | 51081 | 2061 | 30 | 0 | 36.67878901 | -77.56351439 | 2021-12-31 04:21:50 | Greensville, Virginia, US | |
1671419 | 1671419 | 2021-12-29 | US | Tennessee | Lake | 47095 | 2061 | 34 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-30 04:21:25 | Lake, Tennessee, US | |
1671534 | 1671534 | 2021-12-29 | US | Texas | Duval | 48131 | 2061 | 61 | 0 | 27.68184592 | -98.50864568 | 2021-12-30 04:21:25 | Duval, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);