johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
238 rows where active = 1017 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 27
- US 177
- Russia 12
- Colombia 10
- Chile 3
- Italy 3
- Japan 3
- Sweden 3
- Benin 2
- Cabo Verde 2
- Cambodia 2
- Haiti 2
- Iceland 2
- India 2
- Mexico 2
- Brazil 1
- Canada 1
- Cote d'Ivoire 1
- Germany 1
- Kazakhstan 1
- Korea, South 1
- Montenegro 1
- Mozambique 1
- Nepal 1
- Pakistan 1
- Peru 1
- Spain 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683302 | 3683302 | 2021-08-02 | Colombia | Magdalena | 88738 | 3193 | 84528 | 1017 | 10.4113 | -74.4057 | 2021-08-03 04:21:39 | Magdalena, Colombia | ||
3385301 | 3385301 | 2021-07-29 | Germany | Hamburg | 78738 | 1610 | 76200 | 1017 | 53.5511 | 9.9937 | 2021-07-30 04:21:34 | Hamburg, Germany | ||
1330243 | 1330243 | 2021-07-24 | Italy | Umbria | 57594 | 1424 | 55153 | 1017 | 43.10675841 | 12.38824698 | 2021-07-25 04:22:12 | Umbria, Italy | ||
3631917 | 3631917 | 2021-07-14 | India | Nagaland | 26249 | 516 | 24716 | 1017 | 26.06702 | 94.470302 | 2021-07-15 04:21:48 | Nagaland, India | ||
2072173 | 2072173 | 2021-07-02 | Russia | Tyumen Oblast | 39429 | 682 | 37730 | 1017 | 58.8206488 | 70.36588370000001 | 2021-07-03 04:21:37 | Tyumen Oblast, Russia | ||
563159 | 563159 | 2021-06-22 | Russia | Bryansk Oblast | 42461 | 416 | 41028 | 1017 | 52.8873315 | 33.41585300000001 | 2021-06-23 04:21:46 | Bryansk Oblast, Russia | ||
2716984 | 2716984 | 2021-06-10 | Japan | Hyogo | 40398 | 1246 | 38135 | 1017 | 35.039913 | 134.828057 | 2021-06-11 04:23:20 | Hyogo, Japan | ||
1188886 | 1188886 | 2021-05-31 | Pakistan | Azad Jammu and Kashmir | 19250 | 544 | 17689 | 1017 | 34.027401 | 73.947253 | 2021-06-01 04:23:09 | Azad Jammu and Kashmir, Pakistan | ||
1552202 | 1552202 | 2021-05-08 | Russia | Omsk Oblast | 46133 | 1396 | 43720 | 1017 | 56.09352629999999 | 73.5099936 | 2021-05-09 04:20:35 | Omsk Oblast, Russia | ||
888336 | 888336 | 2021-04-26 | Russia | Kurgan Oblast | 20224 | 383 | 18824 | 1017 | 55.7655302 | 64.5632681 | 2021-04-27 04:20:52 | Kurgan Oblast, Russia | ||
1567956 | 1567956 | 2021-04-22 | Colombia | La Guajira | 25778 | 826 | 23935 | 1017 | 11.3548 | -72.5205 | 2021-04-23 04:20:52 | La Guajira, Colombia | ||
2020518 | 2020518 | 2021-04-20 | Chile | Tarapaca | 32186 | 584 | 30585 | 1017 | -19.9232 | -69.5132 | 2021-04-21 04:21:14 | Tarapaca, Chile | ||
387984 | 387984 | 2021-04-04 | Cambodia | 2689 | 19 | 1653 | 1017 | 11.55 | 104.9167 | 2021-04-05 04:20:35 | Cambodia | |||
3709900 | 3709900 | 2021-04-03 | Cambodia | 2689 | 19 | 1653 | 1017 | 11.55 | 104.9167 | 2021-04-04 04:20:49 | Cambodia | |||
1302303 | 1302303 | 2021-04-01 | Russia | Tula Oblast | 36325 | 1556 | 33752 | 1017 | 53.9570701 | 37.3690909 | 2021-04-02 04:20:36 | Tula Oblast, Russia | ||
3643348 | 3643348 | 2021-03-30 | Chile | Tarapaca | 28547 | 509 | 27021 | 1017 | -19.9232 | -69.5132 | 2021-03-31 04:26:25 | Tarapaca, Chile | ||
1203922 | 1203922 | 2021-03-22 | Nepal | 276056 | 3019 | 272020 | 1017 | 28.1667 | 84.25 | 2021-03-23 05:26:18 | Nepal | |||
1203752 | 1203752 | 2021-03-22 | India | Goa | 56708 | 818 | 54873 | 1017 | 15.359682 | 74.057396 | 2021-03-23 05:26:18 | Goa, India | ||
1732699 | 1732699 | 2021-03-14 | Russia | Kamchatka Krai | 13849 | 161 | 12671 | 1017 | 57.1914882 | 160.03838190000005 | 2021-03-15 05:25:51 | Kamchatka Krai, Russia | ||
1580356 | 1580356 | 2021-03-13 | Russia | Kamchatka Krai | 13830 | 157 | 12656 | 1017 | 57.1914882 | 160.03838190000005 | 2021-03-14 05:25:37 | Kamchatka Krai, Russia | ||
1617170 | 1617170 | 2021-03-05 | US | Idaho | Fremont | 16043 | 1031 | 14 | 0 | 1017 | 44.22800938 | -111.4809943 | 2021-03-06 04:23:41 | Fremont, Idaho, US |
1936928 | 1936928 | 2021-02-23 | US | Arkansas | Fulton | 5049 | 1062 | 45 | 0 | 1017 | 36.38177105 | -91.81729127 | 2021-02-24 05:29:16 | Fulton, Arkansas, US |
183653 | 183653 | 2021-02-21 | US | Michigan | Charlevoix | 26029 | 1030 | 13 | 0 | 1017 | 45.37790017 | -85.19614053 | 2021-02-22 05:24:21 | Charlevoix, Michigan, US |
743927 | 743927 | 2021-02-20 | US | Michigan | Charlevoix | 26029 | 1030 | 13 | 0 | 1017 | 45.37790017 | -85.19614053 | 2021-02-21 05:24:33 | Charlevoix, Michigan, US |
473025 | 473025 | 2021-02-19 | US | Michigan | Charlevoix | 26029 | 1030 | 13 | 0 | 1017 | 45.37790017 | -85.19614053 | 2021-02-20 05:22:51 | Charlevoix, Michigan, US |
3604375 | 3604375 | 2021-02-17 | US | Virginia | Giles | 51071 | 1026 | 9 | 0 | 1017 | 37.31234791 | -80.70636931 | 2021-02-18 05:22:58 | Giles, Virginia, US |
3052191 | 3052191 | 2021-02-16 | US | Montana | Richland | 30083 | 1031 | 14 | 0 | 1017 | 47.78668011 | -104.5610786 | 2021-02-17 05:23:10 | Richland, Montana, US |
3049900 | 3049900 | 2021-02-16 | Benin | 5039 | 62 | 3960 | 1017 | 9.3077 | 2.3158 | 2021-02-17 05:23:10 | Benin | |||
1340290 | 1340290 | 2021-02-15 | US | Montana | Richland | 30083 | 1031 | 14 | 0 | 1017 | 47.78668011 | -104.5610786 | 2021-02-16 05:24:38 | Richland, Montana, US |
1337999 | 1337999 | 2021-02-15 | Benin | 5039 | 62 | 3960 | 1017 | 9.3077 | 2.3158 | 2021-02-16 05:24:38 | Benin | |||
2680580 | 2680580 | 2021-02-13 | US | Puerto Rico | Morovis | 72101 | 1017 | 0 | 0 | 1017 | 18.316963 | -66.420383 | 2021-02-14 05:23:43 | Morovis, Puerto Rico, US |
3540857 | 3540857 | 2021-02-12 | US | Kentucky | Green | 21087 | 1030 | 13 | 0 | 1017 | 37.26484328 | -85.5540745 | 2021-02-13 05:22:12 | Green, Kentucky, US |
1530492 | 1530492 | 2021-02-09 | US | Oklahoma | Washita | 40149 | 1024 | 7 | 0 | 1017 | 35.29071824 | -98.99180434 | 2021-02-10 05:22:41 | Washita, Oklahoma, US |
1529881 | 1529881 | 2021-02-09 | US | Montana | Dawson | 30021 | 1045 | 28 | 0 | 1017 | 47.26584855 | -104.89444170000002 | 2021-02-10 05:22:41 | Dawson, Montana, US |
1529749 | 1529749 | 2021-02-09 | US | Mississippi | Webster | 28155 | 1042 | 25 | 0 | 1017 | 33.61300486 | -89.28392912 | 2021-02-10 05:22:41 | Webster, Mississippi, US |
1529225 | 1529225 | 2021-02-09 | US | Kansas | Rice | 20159 | 1024 | 7 | 0 | 1017 | 38.34616184 | -98.19992118 | 2021-02-10 05:22:41 | Rice, Kansas, US |
1528252 | 1528252 | 2021-02-09 | US | Alabama | Conecuh | 1035 | 1040 | 23 | 0 | 1017 | 31.43401703 | -86.99320044 | 2021-02-10 05:22:41 | Conecuh, Alabama, US |
616283 | 616283 | 2021-02-08 | US | Oklahoma | Washita | 40149 | 1024 | 7 | 0 | 1017 | 35.29071824 | -98.99180434 | 2021-02-09 05:23:30 | Washita, Oklahoma, US |
615016 | 615016 | 2021-02-08 | US | Kansas | Rice | 20159 | 1024 | 7 | 0 | 1017 | 38.34616184 | -98.19992118 | 2021-02-09 05:23:30 | Rice, Kansas, US |
1675052 | 1675052 | 2021-02-07 | US | Oklahoma | Washita | 40149 | 1024 | 7 | 0 | 1017 | 35.29071824 | -98.99180434 | 2021-02-08 05:22:39 | Washita, Oklahoma, US |
1673846 | 1673846 | 2021-02-07 | US | Kentucky | Fleming | 21069 | 1030 | 13 | 0 | 1017 | 38.36758311 | -83.69657514 | 2021-02-08 05:22:39 | Fleming, Kentucky, US |
1686075 | 1686075 | 2021-02-02 | US | Maryland | Kent | 24029 | 1053 | 36 | 0 | 1017 | 39.24976208 | -76.04741541 | 2021-02-03 05:22:52 | Kent, Maryland, US |
1679220 | 1679220 | 2021-02-01 | US | Puerto Rico | Manati | 72091 | 1017 | 0 | 0 | 1017 | 18.420473 | -66.490461 | 2021-02-02 05:22:49 | Manati, Puerto Rico, US |
1459604 | 1459604 | 2021-01-31 | Colombia | Cordoba | 33141 | 1717 | 30407 | 1017 | 8.0493 | -75.574 | 2021-02-01 05:22:53 | Cordoba, Colombia | ||
2214368 | 2214368 | 2021-01-30 | US | Pennsylvania | Wyoming | 42131 | 1053 | 36 | 0 | 1017 | 41.51955538 | -76.01074915 | 2021-01-31 05:22:42 | Wyoming, Pennsylvania, US |
1900303 | 1900303 | 2021-01-29 | US | Texas | Live Oak | 48297 | 998 | 17 | 0 | 1017 | 28.35101362 | -98.1246786 | 2021-01-30 05:22:49 | Live Oak, Texas, US |
2485119 | 2485119 | 2021-01-28 | US | Texas | Live Oak | 48297 | 998 | 17 | 0 | 1017 | 28.35101362 | -98.1246786 | 2021-01-29 05:22:23 | Live Oak, Texas, US |
2485112 | 2485112 | 2021-01-28 | US | Texas | Lampasas | 48281 | 1389 | 20 | 0 | 1017 | 31.19531316 | -98.24206613 | 2021-01-29 05:22:23 | Lampasas, Texas, US |
2484633 | 2484633 | 2021-01-28 | US | Pennsylvania | Fulton | 42057 | 1030 | 13 | 0 | 1017 | 39.92913544 | -78.11163677 | 2021-01-29 05:22:23 | Fulton, Pennsylvania, US |
3156754 | 3156754 | 2021-01-27 | US | Texas | Live Oak | 48297 | 998 | 17 | 0 | 1017 | 28.35101362 | -98.1246786 | 2021-01-28 05:22:24 | Live Oak, Texas, US |
3155270 | 3155270 | 2021-01-27 | US | Michigan | Ogemaw | 26129 | 1047 | 30 | 0 | 1017 | 44.33481032 | -84.12725175 | 2021-01-28 05:22:24 | Ogemaw, Michigan, US |
1759716 | 1759716 | 2021-01-24 | US | Alaska | Kodiak Island | 2150 | 1022 | 5 | 0 | 1017 | 57.65529415 | -153.7493579 | 2021-01-25 05:22:16 | Kodiak Island, Alaska, US |
2427323 | 2427323 | 2021-01-23 | US | Alaska | Kodiak Island | 2150 | 1022 | 5 | 0 | 1017 | 57.65529415 | -153.7493579 | 2021-01-24 05:22:35 | Kodiak Island, Alaska, US |
2467329 | 2467329 | 2021-01-22 | US | Arkansas | Van Buren | 5141 | 1029 | 12 | 0 | 1017 | 35.58095779 | -92.51295036 | 2021-01-23 05:22:03 | Van Buren, Arkansas, US |
438706 | 438706 | 2021-01-21 | US | Virginia | King George | 51099 | 1028 | 11 | 0 | 1017 | 38.26818502 | -77.15852768 | 2021-01-22 05:22:10 | King George, Virginia, US |
1096825 | 1096825 | 2021-01-20 | US | Puerto Rico | Humacao | 72069 | 1017 | 0 | 0 | 1017 | 18.145211 | -65.810174 | 2021-01-21 05:22:01 | Humacao, Puerto Rico, US |
910915 | 910915 | 2021-01-19 | US | Puerto Rico | Humacao | 72069 | 1017 | 0 | 0 | 1017 | 18.145211 | -65.810174 | 2021-01-20 05:21:54 | Humacao, Puerto Rico, US |
910903 | 910903 | 2021-01-19 | US | Puerto Rico | Corozal | 72047 | 1017 | 0 | 0 | 1017 | 18.304264 | -66.327738 | 2021-01-20 05:21:54 | Corozal, Puerto Rico, US |
3102979 | 3102979 | 2021-01-16 | US | Louisiana | West Carroll | 22123 | 1052 | 35 | 0 | 1017 | 32.78550125 | -91.461201 | 2021-01-17 05:22:17 | West Carroll, Louisiana, US |
3518600 | 3518600 | 2021-01-15 | US | Texas | Robertson | 48395 | 1538 | 23 | 0 | 1017 | 31.02539637 | -96.51272246 | 2021-01-16 05:22:40 | Robertson, Texas, US |
3517951 | 3517951 | 2021-01-15 | US | Oklahoma | Haskell | 40061 | 1024 | 7 | 0 | 1017 | 35.22257600000001 | -95.11513306 | 2021-01-16 05:22:40 | Haskell, Oklahoma, US |
3516941 | 3516941 | 2021-01-15 | US | Louisiana | West Carroll | 22123 | 1052 | 35 | 0 | 1017 | 32.78550125 | -91.461201 | 2021-01-16 05:22:40 | West Carroll, Louisiana, US |
3309395 | 3309395 | 2021-01-13 | US | Iowa | Humboldt | 19091 | 1036 | 19 | 0 | 1017 | 42.7764426 | -94.20722537 | 2021-01-14 05:22:32 | Humboldt, Iowa, US |
192861 | 192861 | 2021-01-11 | US | South Carolina | Bamberg | 45009 | 1058 | 41 | 0 | 1017 | 33.21927586 | -81.05659969 | 2021-01-12 05:22:15 | Bamberg, South Carolina, US |
2627539 | 2627539 | 2021-01-10 | US | Michigan | Otsego | 26137 | 1042 | 25 | 0 | 1017 | 45.02085831 | -84.59898295 | 2021-01-11 05:21:50 | Otsego, Michigan, US |
2626251 | 2626251 | 2021-01-10 | US | Alabama | Lowndes | 1085 | 1052 | 35 | 0 | 1017 | 32.1597283 | -86.65158371 | 2021-01-11 05:21:50 | Lowndes, Alabama, US |
3902061 | 3902061 | 2021-01-09 | US | Nebraska | Red Willow | 31145 | 1022 | 5 | 0 | 1017 | 40.17556879999999 | -100.476998 | 2021-01-10 05:22:12 | Red Willow, Nebraska, US |
3901627 | 3901627 | 2021-01-09 | US | Michigan | Otsego | 26137 | 1042 | 25 | 0 | 1017 | 45.02085831 | -84.59898295 | 2021-01-10 05:22:12 | Otsego, Michigan, US |
156384 | 156384 | 2021-01-08 | US | North Dakota | Mercer | 38057 | 1017 | 9 | 0 | 1017 | 47.31213126 | -101.8318399 | 2021-01-09 05:22:18 | Mercer, North Dakota, US |
155650 | 155650 | 2021-01-08 | US | Michigan | Otsego | 26137 | 1042 | 25 | 0 | 1017 | 45.02085831 | -84.59898295 | 2021-01-09 05:22:18 | Otsego, Michigan, US |
154827 | 154827 | 2021-01-08 | US | Georgia | Oglethorpe | 13221 | 1032 | 15 | 0 | 1017 | 33.878629600000004 | -83.08278123 | 2021-01-09 05:22:18 | Oglethorpe, Georgia, US |
3037053 | 3037053 | 2021-01-05 | US | Puerto Rico | Mayaguez | 72097 | 1017 | 0 | 0 | 1017 | 18.2013 | -67.1452 | 2021-01-06 05:22:16 | Mayaguez, Puerto Rico, US |
1138651 | 1138651 | 2021-01-01 | US | Minnesota | Watonwan | 27165 | 1024 | 7 | 0 | 1017 | 43.97823903 | -94.61413846 | 2021-01-02 05:22:33 | Watonwan, Minnesota, US |
3697257 | 3697257 | 2020-12-31 | US | Minnesota | Watonwan | 27165 | 1024 | 7 | 0 | 1017 | 43.97823903 | -94.61413846 | 2021-01-01 05:23:07 | Watonwan, Minnesota, US |
767547 | 767547 | 2020-12-29 | US | Iowa | Sac | 19161 | 1031 | 14 | 0 | 1017 | 42.38624071 | -95.10547892 | 2020-12-30 05:22:34 | Sac, Iowa, US |
3765099 | 3765099 | 2020-12-28 | US | Wisconsin | Ashland | 55003 | 1031 | 14 | 0 | 1017 | 46.31956891 | -90.67837132 | 2020-12-29 05:22:37 | Ashland, Wisconsin, US |
3780716 | 3780716 | 2020-12-27 | US | South Carolina | Hampton | 45049 | 1053 | 36 | 0 | 1017 | 32.77419582 | -81.13845571 | 2020-12-28 05:22:06 | Hampton, South Carolina, US |
3779321 | 3779321 | 2020-12-27 | US | Kentucky | Lee | 21129 | 1035 | 18 | 0 | 1017 | 37.59645942 | -83.71513901 | 2020-12-28 05:22:06 | Lee, Kentucky, US |
3694597 | 3694597 | 2020-12-24 | US | Texas | Jackson | 48239 | 1032 | 19 | 0 | 1017 | 28.95472367 | -96.57749563 | 2020-12-25 05:22:48 | Jackson, Texas, US |
2409949 | 2409949 | 2020-12-23 | US | Texas | Jackson | 48239 | 1025 | 19 | 0 | 1017 | 28.95472367 | -96.57749563 | 2020-12-24 05:23:04 | Jackson, Texas, US |
2408775 | 2408775 | 2020-12-23 | US | Missouri | Ray | 29177 | 1024 | 7 | 0 | 1017 | 39.3537468 | -93.98905745 | 2020-12-24 05:23:04 | Ray, Missouri, US |
3770340 | 3770340 | 2020-12-22 | US | Arkansas | Cleburne | 5023 | 1048 | 31 | 0 | 1017 | 35.53864922 | -92.02640019 | 2020-12-23 05:22:03 | Cleburne, Arkansas, US |
929460 | 929460 | 2020-12-21 | US | Minnesota | Watonwan | 27165 | 1022 | 5 | 0 | 1017 | 43.97823903 | -94.61413846 | 2020-12-22 05:22:33 | Watonwan, Minnesota, US |
2120100 | 2120100 | 2020-12-20 | US | Alabama | Monroe | 1099 | 1027 | 10 | 0 | 1017 | 31.56729412 | -87.36995001 | 2020-12-21 05:27:58 | Monroe, Alabama, US |
2129473 | 2129473 | 2020-12-17 | US | Louisiana | Bienville | 22013 | 1057 | 40 | 0 | 1017 | 32.34569994 | -93.05398492 | 2020-12-18 05:28:18 | Bienville, Louisiana, US |
2128973 | 2128973 | 2020-12-17 | US | Illinois | Greene | 17061 | 1047 | 30 | 0 | 1017 | 39.35907414 | -90.388865 | 2020-12-18 05:28:18 | Greene, Illinois, US |
1034220 | 1034220 | 2020-12-15 | Colombia | Cordoba | 28785 | 1659 | 26109 | 1017 | 8.0493 | -75.574 | 2020-12-16 05:28:04 | Cordoba, Colombia | ||
3850633 | 3850633 | 2020-12-13 | US | South Dakota | Charles Mix | 46023 | 1027 | 10 | 0 | 1017 | 43.20660134 | -98.58856175 | 2020-12-14 05:26:27 | Charles Mix, South Dakota, US |
3849704 | 3849704 | 2020-12-13 | US | Missouri | Madison | 29123 | 1027 | 10 | 0 | 1017 | 37.47865134 | -90.3467143 | 2020-12-14 05:26:27 | Madison, Missouri, US |
3849243 | 3849243 | 2020-12-13 | US | Kentucky | Rowan | 21205 | 1019 | 2 | 0 | 1017 | 38.19484205 | -83.42088935 | 2020-12-14 05:26:27 | Rowan, Kentucky, US |
3847719 | 3847719 | 2020-12-13 | Haiti | 9491 | 233 | 8241 | 1017 | 18.9712 | -72.2852 | 2020-12-14 05:26:27 | Haiti | |||
846472 | 846472 | 2020-12-12 | US | Hawaii | Maui | 15009 | 1034 | 17 | 0 | 1017 | 20.86399628 | -156.56890969999995 | 2020-12-13 05:27:20 | Maui, Hawaii, US |
1603303 | 1603303 | 2020-12-10 | US | Texas | Gillespie | 48171 | 1118 | 12 | 0 | 1017 | 30.31824095 | -98.94676915 | 2020-12-11 05:26:59 | Gillespie, Texas, US |
1601692 | 1601692 | 2020-12-10 | US | Kentucky | Woodford | 21239 | 1018 | 1 | 0 | 1017 | 38.04178222 | -84.7417556 | 2020-12-11 05:26:59 | Woodford, Kentucky, US |
1821581 | 1821581 | 2020-12-08 | US | South Carolina | Barnwell | 45011 | 1043 | 26 | 0 | 1017 | 33.26679302 | -81.43584352 | 2020-12-09 05:28:01 | Barnwell, South Carolina, US |
1821063 | 1821063 | 2020-12-08 | US | North Carolina | Anson | 37007 | 1033 | 16 | 0 | 1017 | 34.97403241 | -80.09953279 | 2020-12-09 05:28:01 | Anson, North Carolina, US |
2349977 | 2349977 | 2020-12-07 | US | Oklahoma | Kingfisher | 40073 | 1024 | 7 | 0 | 1017 | 35.94530008 | -97.94193268 | 2020-12-08 05:27:42 | Kingfisher, Oklahoma, US |
2347963 | 2347963 | 2020-12-07 | US | California | Humboldt | 6023 | 1026 | 9 | 0 | 1017 | 40.69923009 | -123.876044 | 2020-12-08 05:27:42 | Humboldt, California, US |
2347436 | 2347436 | 2020-12-07 | Japan | Hyogo | 6542 | 99 | 5426 | 1017 | 35.039913 | 134.828057 | 2020-12-08 05:27:42 | Hyogo, Japan | ||
1007222 | 1007222 | 2020-12-06 | US | Idaho | Gooding | 16047 | 1027 | 10 | 0 | 1017 | 42.96927962 | -114.8108306 | 2020-12-07 05:26:14 | Gooding, Idaho, 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]);