johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
304 rows where active = 1005 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 24
- US 244
- Russia 17
- Mexico 6
- Colombia 5
- Guinea-Bissau 4
- Chile 3
- India 3
- Malaysia 3
- Sweden 3
- Germany 2
- Cabo Verde 1
- Finland 1
- Guyana 1
- Italy 1
- Jamaica 1
- Korea, South 1
- Luxembourg 1
- Pakistan 1
- Seychelles 1
- Sierra Leone 1
- Slovenia 1
- South Sudan 1
- Ukraine 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903833 | 3903833 | 2021-07-31 | Colombia | Sucre | 57468 | 1555 | 54908 | 1005 | 8.814 | -74.7233 | 2021-08-01 04:21:50 | Sucre, Colombia | ||
1330033 | 1330033 | 2021-07-24 | Chile | Biobio | 147766 | 2479 | 144282 | 1005 | -37.4464 | -72.1416 | 2021-07-25 04:22:12 | Biobio, Chile | ||
2677498 | 2677498 | 2021-07-18 | Malaysia | Terengganu | 12655 | 88 | 11562 | 1005 | 5.3117 | 103.1324 | 2021-07-19 04:21:24 | Terengganu, Malaysia | ||
3741338 | 3741338 | 2021-07-12 | Russia | Tyva Republic | 17921 | 226 | 16690 | 1005 | 51.4017149 | 93.8582593 | 2021-07-13 04:21:18 | Tyva Republic, Russia | ||
1892935 | 1892935 | 2021-06-30 | Chile | OHiggins | 65413 | 1326 | 63082 | 1005 | -34.5755 | -71.0022 | 2021-07-01 04:21:19 | OHiggins, Chile | ||
3125457 | 3125457 | 2021-06-28 | India | Jharkhand | 345430 | 5111 | 339314 | 1005 | 23.654536 | 85.557631 | 2021-06-29 04:21:28 | Jharkhand, India | ||
3385060 | 3385060 | 2021-06-13 | Malaysia | Terengganu | 10569 | 66 | 9498 | 1005 | 5.3117 | 103.1324 | 2021-06-14 04:22:46 | Terengganu, Malaysia | ||
523133 | 523133 | 2021-06-09 | Sierra Leone | 4251 | 82 | 3164 | 1005 | 8.460555000000001 | -11.779889 | 2021-06-10 04:23:17 | Sierra Leone | |||
3145856 | 3145856 | 2021-06-07 | Seychelles | 12383 | 42 | 11336 | 1005 | -4.6796 | 55.492 | 2021-06-08 04:22:35 | Seychelles | |||
825537 | 825537 | 2021-06-06 | India | Lakshadweep | 8737 | 38 | 7694 | 1005 | 13.6999972 | 72.18333259999999 | 2021-06-07 04:22:51 | Lakshadweep, India | ||
2315243 | 2315243 | 2021-06-04 | India | Chandigarh | 60487 | 765 | 58717 | 1005 | 30.733839 | 76.76827800000002 | 2021-06-05 04:23:03 | Chandigarh, India | ||
2939315 | 2939315 | 2021-05-16 | Italy | P.A. Bolzano | 72225 | 1168 | 70052 | 1005 | 46.49933453 | 11.35662422 | 2021-05-17 04:20:34 | P.A. Bolzano, Italy | ||
1873187 | 1873187 | 2021-05-15 | Russia | Omsk Oblast | 46534 | 1406 | 44123 | 1005 | 56.09352629999999 | 73.5099936 | 2021-05-16 04:20:49 | Omsk Oblast, Russia | ||
2020864 | 2020864 | 2021-04-20 | Pakistan | Balochistan | 21127 | 225 | 19897 | 1005 | 28.328492 | 65.898403 | 2021-04-21 04:21:14 | Balochistan, Pakistan | ||
1219498 | 1219498 | 2021-03-27 | Guyana | 10072 | 225 | 8842 | 1005 | 4.860416000000002 | -58.93018000000001 | 2021-03-28 05:28:10 | Guyana | |||
2781191 | 2781191 | 2021-03-24 | Russia | Irkutsk Oblast | 60384 | 1955 | 57424 | 1005 | 56.6370122 | 104.719221 | 2021-03-25 05:27:00 | Irkutsk Oblast, Russia | ||
1204089 | 1204089 | 2021-03-22 | South Sudan | 9890 | 106 | 8779 | 1005 | 6.877000000000002 | 31.307 | 2021-03-23 05:26:18 | South Sudan | |||
3456543 | 3456543 | 2021-03-18 | Malaysia | W.P. Kuala Lumpur | 36698 | 113 | 35580 | 1005 | 3.139 | 101.6869 | 2021-03-19 05:26:09 | W.P. Kuala Lumpur, Malaysia | ||
3668926 | 3668926 | 2021-03-06 | US | Kansas | Marion | 20115 | 1029 | 24 | 0 | 1005 | 38.35855394 | -97.0985251 | 2021-03-07 05:21:54 | Marion, Kansas, US |
1619909 | 1619909 | 2021-03-05 | Zimbabwe | 36248 | 1484 | 33759 | 1005 | -19.015438 | 29.154857 | 2021-03-06 04:23:41 | Zimbabwe | |||
1619581 | 1619581 | 2021-03-05 | US | Virginia | Greene | 51079 | 1014 | 9 | 0 | 1005 | 38.29545894 | -78.46525378 | 2021-03-06 04:23:41 | Greene, Virginia, US |
1619188 | 1619188 | 2021-03-05 | US | Tennessee | Houston | 47083 | 1040 | 32 | 0 | 1005 | 36.28872054 | -87.71878828 | 2021-03-06 04:23:41 | Houston, Tennessee, US |
1617547 | 1617547 | 2021-03-05 | US | Kansas | Marion | 20115 | 1029 | 24 | 0 | 1005 | 38.35855394 | -97.0985251 | 2021-03-06 04:23:41 | Marion, Kansas, US |
2208958 | 2208958 | 2021-03-04 | US | Kansas | Marion | 20115 | 1029 | 24 | 0 | 1005 | 38.35855394 | -97.0985251 | 2021-03-05 05:26:29 | Marion, Kansas, US |
1091379 | 1091379 | 2021-03-03 | US | Kansas | Marion | 20115 | 1029 | 24 | 0 | 1005 | 38.35855394 | -97.0985251 | 2021-03-04 05:24:24 | Marion, Kansas, US |
3257326 | 3257326 | 2021-03-02 | US | Texas | Ochiltree | 48357 | 1181 | 25 | 0 | 1005 | 36.27829105 | -100.8158184 | 2021-03-03 05:23:28 | Ochiltree, Texas, US |
1001411 | 1001411 | 2021-03-01 | US | Tennessee | Perry | 47135 | 1028 | 27 | 0 | 1005 | 35.63708728 | -87.86139634 | 2021-03-02 05:23:30 | Perry, Tennessee, US |
2370469 | 2370469 | 2021-02-28 | US | Tennessee | Perry | 47135 | 1028 | 27 | 0 | 1005 | 35.63708728 | -87.86139634 | 2021-03-01 05:23:01 | Perry, Tennessee, US |
3068971 | 3068971 | 2021-02-27 | US | Tennessee | Perry | 47135 | 1028 | 27 | 0 | 1005 | 35.63708728 | -87.86139634 | 2021-02-28 05:22:20 | Perry, Tennessee, US |
2186353 | 2186353 | 2021-02-26 | US | Puerto Rico | San Sebastian | 72131 | 1005 | 0 | 0 | 1005 | 18.328646 | -66.971214 | 2021-02-27 05:22:28 | San Sebastian, Puerto Rico, US |
1937865 | 1937865 | 2021-02-23 | US | Kentucky | Knott | 21119 | 1020 | 15 | 0 | 1005 | 37.35388197 | -82.94981134 | 2021-02-24 05:29:16 | Knott, Kentucky, US |
743802 | 743802 | 2021-02-20 | US | Louisiana | Catahoula | 22025 | 1038 | 33 | 0 | 1005 | 31.66778967 | -91.84526385 | 2021-02-21 05:24:33 | Catahoula, Louisiana, US |
474310 | 474310 | 2021-02-19 | US | South Dakota | Turner | 46125 | 1057 | 52 | 0 | 1005 | 43.3109081 | -97.14865776 | 2021-02-20 05:22:51 | Turner, South Dakota, US |
472900 | 472900 | 2021-02-19 | US | Louisiana | Catahoula | 22025 | 1038 | 33 | 0 | 1005 | 31.66778967 | -91.84526385 | 2021-02-20 05:22:51 | Catahoula, Louisiana, US |
472532 | 472532 | 2021-02-19 | US | Indiana | Pulaski | 18131 | 1047 | 42 | 0 | 1005 | 41.04166107 | -86.69890683 | 2021-02-20 05:22:51 | Pulaski, Indiana, US |
3603663 | 3603663 | 2021-02-17 | US | Oregon | Morrow | 41049 | 1018 | 13 | 0 | 1005 | 45.41846568 | -119.584546 | 2021-02-18 05:22:58 | Morrow, Oregon, US |
3602161 | 3602161 | 2021-02-17 | US | Indiana | Pulaski | 18131 | 1046 | 41 | 0 | 1005 | 41.04166107 | -86.69890683 | 2021-02-18 05:22:58 | Pulaski, Indiana, US |
1341865 | 1341865 | 2021-02-15 | US | Wyoming | Big Horn | 56003 | 1034 | 29 | 0 | 1005 | 44.52405055 | -107.9960365 | 2021-02-16 05:24:38 | Big Horn, Wyoming, US |
2287016 | 2287016 | 2021-02-14 | US | Wyoming | Big Horn | 56003 | 1034 | 29 | 0 | 1005 | 44.52405055 | -107.9960365 | 2021-02-15 05:24:49 | Big Horn, Wyoming, US |
2285093 | 2285093 | 2021-02-14 | US | Michigan | Osceola | 26133 | 1028 | 23 | 0 | 1005 | 43.98992088 | -85.32566756 | 2021-02-15 05:24:49 | Osceola, Michigan, US |
2679493 | 2679493 | 2021-02-13 | US | Michigan | Osceola | 26133 | 1028 | 23 | 0 | 1005 | 43.98992088 | -85.32566756 | 2021-02-14 05:23:43 | Osceola, Michigan, US |
3542930 | 3542930 | 2021-02-12 | US | West Virginia | Grant | 54023 | 1027 | 22 | 0 | 1005 | 39.10314817 | -79.19440518 | 2021-02-13 05:22:12 | Grant, West Virginia, US |
3542866 | 3542866 | 2021-02-12 | US | Virginia | Sussex | 51183 | 1021 | 16 | 0 | 1005 | 36.92432914 | -77.25791182 | 2021-02-13 05:22:12 | Sussex, Virginia, US |
2640935 | 2640935 | 2021-02-11 | US | Texas | Somervell | 48425 | 1024 | 10 | 0 | 1005 | 32.22236802 | -97.77403489 | 2021-02-12 05:23:29 | Somervell, Texas, US |
2638428 | 2638428 | 2021-02-11 | US | Florida | Liberty | 12077 | 1019 | 14 | 0 | 1005 | 30.23766008 | -84.8829258 | 2021-02-12 05:23:29 | Liberty, Florida, US |
3981790 | 3981790 | 2021-02-10 | US | Texas | Somervell | 48425 | 1024 | 10 | 0 | 1005 | 32.22236802 | -97.77403489 | 2021-02-11 05:23:55 | Somervell, Texas, US |
3980190 | 3980190 | 2021-02-10 | US | Michigan | Charlevoix | 26029 | 1017 | 12 | 0 | 1005 | 45.37790017 | -85.19614053 | 2021-02-11 05:23:55 | Charlevoix, Michigan, US |
3979592 | 3979592 | 2021-02-10 | US | Illinois | Menard | 17129 | 1011 | 6 | 0 | 1005 | 40.02742725 | -89.80246001 | 2021-02-11 05:23:55 | Menard, Illinois, US |
1673922 | 1673922 | 2021-02-07 | US | Kentucky | Trigg | 21221 | 1013 | 8 | 0 | 1005 | 36.80767017 | -87.87333656 | 2021-02-08 05:22:39 | Trigg, Kentucky, US |
1672934 | 1672934 | 2021-02-07 | US | Arkansas | Fulton | 5049 | 1048 | 43 | 0 | 1005 | 36.38177105 | -91.81729127 | 2021-02-08 05:22:39 | Fulton, Arkansas, US |
975395 | 975395 | 2021-02-06 | US | Arkansas | Fulton | 5049 | 1048 | 43 | 0 | 1005 | 36.38177105 | -91.81729127 | 2021-02-07 05:23:00 | Fulton, Arkansas, US |
343021 | 343021 | 2021-02-03 | US | Puerto Rico | Las Piedras | 72085 | 1005 | 0 | 0 | 1005 | 18.187527 | -65.86946800000001 | 2021-02-04 05:22:26 | Las Piedras, Puerto Rico, US |
341993 | 341993 | 2021-02-03 | US | Minnesota | Kanabec | 27065 | 1023 | 18 | 0 | 1005 | 45.9459309 | -93.29275192 | 2021-02-04 05:22:26 | Kanabec, Minnesota, US |
1686485 | 1686485 | 2021-02-02 | US | Montana | Dawson | 30021 | 1033 | 28 | 0 | 1005 | 47.26584855 | -104.89444170000002 | 2021-02-03 05:22:52 | Dawson, Montana, US |
1686219 | 1686219 | 2021-02-02 | US | Minnesota | Kanabec | 27065 | 1023 | 18 | 0 | 1005 | 45.9459309 | -93.29275192 | 2021-02-03 05:22:52 | Kanabec, Minnesota, US |
1685846 | 1685846 | 2021-02-02 | US | Kansas | Thomas | 20193 | 1022 | 17 | 0 | 1005 | 39.35107575 | -101.0553705 | 2021-02-03 05:22:52 | Thomas, Kansas, US |
1685286 | 1685286 | 2021-02-02 | US | Georgia | Early | 13099 | 1049 | 44 | 0 | 1005 | 31.32155345 | -84.90255207 | 2021-02-03 05:22:52 | Early, Georgia, US |
1678848 | 1678848 | 2021-02-01 | US | North Dakota | Benson | 38005 | 1022 | 18 | 0 | 1005 | 48.0683985 | -99.35916363 | 2021-02-02 05:22:49 | Benson, North Dakota, US |
1678455 | 1678455 | 2021-02-01 | US | Montana | Dawson | 30021 | 1033 | 28 | 0 | 1005 | 47.26584855 | -104.89444170000002 | 2021-02-02 05:22:49 | Dawson, Montana, US |
1677816 | 1677816 | 2021-02-01 | US | Kansas | Thomas | 20193 | 1022 | 17 | 0 | 1005 | 39.35107575 | -101.0553705 | 2021-02-02 05:22:49 | Thomas, Kansas, US |
1677397 | 1677397 | 2021-02-01 | US | Idaho | Franklin | 16041 | 1017 | 12 | 0 | 1005 | 42.18332217 | -111.8149666 | 2021-02-02 05:22:49 | Franklin, Idaho, US |
1677256 | 1677256 | 2021-02-01 | US | Georgia | Early | 13099 | 1049 | 44 | 0 | 1005 | 31.32155345 | -84.90255207 | 2021-02-02 05:22:49 | Early, Georgia, US |
1462136 | 1462136 | 2021-01-31 | US | North Dakota | Benson | 38005 | 1022 | 18 | 0 | 1005 | 48.0683985 | -99.35916363 | 2021-02-01 05:22:53 | Benson, North Dakota, US |
1461743 | 1461743 | 2021-01-31 | US | Montana | Dawson | 30021 | 1033 | 28 | 0 | 1005 | 47.26584855 | -104.89444170000002 | 2021-02-01 05:22:53 | Dawson, Montana, US |
2214044 | 2214044 | 2021-01-30 | US | North Dakota | Benson | 38005 | 1022 | 18 | 0 | 1005 | 48.0683985 | -99.35916363 | 2021-01-31 05:22:42 | Benson, North Dakota, US |
1899531 | 1899531 | 2021-01-29 | US | North Dakota | Benson | 38005 | 1022 | 18 | 0 | 1005 | 48.0683985 | -99.35916363 | 2021-01-30 05:22:49 | Benson, North Dakota, US |
2484671 | 2484671 | 2021-01-28 | US | Pennsylvania | Wyoming | 42131 | 1041 | 36 | 0 | 1005 | 41.51955538 | -76.01074915 | 2021-01-29 05:22:23 | Wyoming, Pennsylvania, US |
2482159 | 2482159 | 2021-01-28 | Russia | Bryansk Oblast | 28543 | 239 | 27299 | 1005 | 52.8873315 | 33.41585300000001 | 2021-01-29 05:22:23 | Bryansk Oblast, Russia | ||
3156942 | 3156942 | 2021-01-27 | US | Virginia | Grayson | 51077 | 1031 | 26 | 0 | 1005 | 36.65677234 | -81.23215889 | 2021-01-28 05:22:24 | Grayson, Virginia, US |
15003 | 15003 | 2021-01-26 | US | Pennsylvania | Fulton | 42057 | 1017 | 12 | 0 | 1005 | 39.92913544 | -78.11163677 | 2021-01-27 05:23:41 | Fulton, Pennsylvania, US |
14943 | 14943 | 2021-01-26 | US | Oregon | Coos | 41011 | 1021 | 16 | 0 | 1005 | 43.17406868 | -124.0594514 | 2021-01-27 05:23:41 | Coos, Oregon, US |
2570267 | 2570267 | 2021-01-25 | US | Oregon | Coos | 41011 | 1020 | 15 | 0 | 1005 | 43.17406868 | -124.0594514 | 2021-01-26 05:22:02 | Coos, Oregon, US |
2427246 | 2427246 | 2021-01-23 | US | Alabama | Bullock | 1011 | 1033 | 28 | 0 | 1005 | 32.10030533 | -85.71265535 | 2021-01-24 05:22:35 | Bullock, Alabama, US |
2468812 | 2468812 | 2021-01-22 | US | Montana | Park | 30067 | 1012 | 7 | 0 | 1005 | 45.48965095 | -110.52643940000002 | 2021-01-23 05:22:03 | Park, Montana, US |
2468040 | 2468040 | 2021-01-22 | US | Iowa | Unassigned | 90019 | 1005 | 0 | 0 | 1005 | 43.38107862 | 0.0 | 2021-01-23 05:22:03 | Unassigned, Iowa, US |
435880 | 435880 | 2021-01-21 | US | Arkansas | Van Buren | 5141 | 1017 | 12 | 0 | 1005 | 35.58095779 | -92.51295036 | 2021-01-22 05:22:10 | Van Buren, Arkansas, US |
910381 | 910381 | 2021-01-19 | US | New Mexico | Socorro | 35053 | 1051 | 46 | 0 | 1005 | 34.00715494 | -106.9298354 | 2021-01-20 05:21:54 | Socorro, New Mexico, US |
238426 | 238426 | 2021-01-18 | US | Iowa | Guthrie | 19077 | 1029 | 24 | 0 | 1005 | 41.68378965 | -94.50111014 | 2021-01-19 05:22:15 | Guthrie, Iowa, US |
237660 | 237660 | 2021-01-18 | US | Alaska | Kodiak Island | 2150 | 1007 | 2 | 0 | 1005 | 57.65529415 | -153.7493579 | 2021-01-19 05:22:15 | Kodiak Island, Alaska, US |
237423 | 237423 | 2021-01-18 | Russia | Altai Republic | 14820 | 116 | 13699 | 1005 | 50.7114101 | 86.8572186 | 2021-01-19 05:22:15 | Altai Republic, Russia | ||
3101845 | 3101845 | 2021-01-16 | US | Alabama | Wilcox | 1131 | 1026 | 21 | 0 | 1005 | 31.98773215 | -87.30891118 | 2021-01-17 05:22:17 | Wilcox, Alabama, US |
3883049 | 3883049 | 2021-01-14 | US | West Virginia | Hardy | 54031 | 1017 | 12 | 0 | 1005 | 39.00683177 | -78.85855301 | 2021-01-15 05:22:24 | Hardy, West Virginia, US |
3882521 | 3882521 | 2021-01-14 | US | Tennessee | Jackson | 47087 | 1148 | 20 | 0 | 1005 | 36.36380466 | -85.67239905 | 2021-01-15 05:22:24 | Jackson, Tennessee, US |
3882123 | 3882123 | 2021-01-14 | US | Oklahoma | Haskell | 40061 | 1012 | 7 | 0 | 1005 | 35.22257600000001 | -95.11513306 | 2021-01-15 05:22:24 | Haskell, Oklahoma, US |
3881113 | 3881113 | 2021-01-14 | US | Louisiana | West Carroll | 22123 | 1040 | 35 | 0 | 1005 | 32.78550125 | -91.461201 | 2021-01-15 05:22:24 | West Carroll, Louisiana, US |
193093 | 193093 | 2021-01-11 | US | Texas | Burleson | 48051 | 1449 | 19 | 0 | 1005 | 30.49273808 | -96.62158484 | 2021-01-12 05:22:15 | Burleson, Texas, US |
192326 | 192326 | 2021-01-11 | US | New York | Seneca | 36099 | 1049 | 44 | 0 | 1005 | 42.78081007 | -76.82497064 | 2021-01-12 05:22:15 | Seneca, New York, US |
2628896 | 2628896 | 2021-01-10 | US | Texas | Burleson | 48051 | 1449 | 19 | 0 | 1005 | 30.49273808 | -96.62158484 | 2021-01-11 05:21:50 | Burleson, Texas, US |
3037640 | 3037640 | 2021-01-05 | US | Virginia | Greensville | 51081 | 1022 | 17 | 0 | 1005 | 36.67878901 | -77.56351439 | 2021-01-06 05:22:16 | Greensville, Virginia, US |
1063863 | 1063863 | 2021-01-04 | US | Montana | Rosebud | 30087 | 1033 | 28 | 0 | 1005 | 46.23397237 | -106.72928799999998 | 2021-01-05 05:21:49 | Rosebud, Montana, US |
1063701 | 1063701 | 2021-01-04 | US | Mississippi | Yalobusha | 28161 | 1038 | 33 | 0 | 1005 | 34.02824175 | -89.70762049999998 | 2021-01-05 05:21:49 | Yalobusha, Mississippi, US |
1062496 | 1062496 | 2021-01-04 | US | Colorado | Teller | 8119 | 1085 | 14 | 0 | 1005 | 38.88133511 | -105.1614893 | 2021-01-05 05:21:49 | Teller, Colorado, US |
3232466 | 3232466 | 2021-01-03 | US | Montana | Rosebud | 30087 | 1033 | 28 | 0 | 1005 | 46.23397237 | -106.72928799999998 | 2021-01-04 05:22:02 | Rosebud, Montana, US |
3231770 | 3231770 | 2021-01-03 | US | Kansas | Pawnee | 20145 | 1012 | 7 | 0 | 1005 | 38.18108732 | -99.23692334 | 2021-01-04 05:22:02 | Pawnee, Kansas, US |
3231460 | 3231460 | 2021-01-03 | US | Illinois | Mason | 17125 | 1043 | 38 | 0 | 1005 | 40.23917274 | -89.91824452 | 2021-01-04 05:22:02 | Mason, Illinois, US |
2231039 | 2231039 | 2021-01-02 | US | Wisconsin | Buffalo | 55011 | 1012 | 7 | 0 | 1005 | 44.37835084 | -91.75332578 | 2021-01-03 05:22:52 | Buffalo, Wisconsin, US |
2228980 | 2228980 | 2021-01-02 | US | Kentucky | Spencer | 21215 | 1010 | 5 | 0 | 1005 | 38.03223971 | -85.32749335 | 2021-01-03 05:22:52 | Spencer, Kentucky, US |
2228839 | 2228839 | 2021-01-02 | US | Kansas | Pawnee | 20145 | 1012 | 7 | 0 | 1005 | 38.18108732 | -99.23692334 | 2021-01-03 05:22:52 | Pawnee, Kansas, US |
2227773 | 2227773 | 2021-01-02 | Russia | Tyva Republic | 14804 | 157 | 13642 | 1005 | 51.4017149 | 93.8582593 | 2021-01-03 05:22:52 | Tyva Republic, Russia | ||
1140403 | 1140403 | 2021-01-01 | US | Wisconsin | Buffalo | 55011 | 1012 | 7 | 0 | 1005 | 44.37835084 | -91.75332578 | 2021-01-02 05:22:33 | Buffalo, Wisconsin, 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]);