johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where active = 3735 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408557 | 408557 | 2021-07-28 | Russia | Voronezh Oblast | 102564 | 3500 | 95329 | 3735 | 50.9800393 | 40.15065070000001 | 2021-07-29 04:21:33 | Voronezh Oblast, Russia | ||
3741075 | 3741075 | 2021-07-12 | Italy | Sicilia | 233440 | 5992 | 223713 | 3735 | 38.11569725 | 13.362356699999998 | 2021-07-13 04:21:18 | Sicilia, Italy | ||
399958 | 399958 | 2021-06-29 | Armenia | 224967 | 4514 | 216718 | 3735 | 40.0691 | 45.0382 | 2021-06-30 04:21:41 | Armenia | |||
566638 | 566638 | 2021-06-22 | Zimbabwe | 42714 | 1691 | 37288 | 3735 | -19.015438 | 29.154857 | 2021-06-23 04:21:46 | Zimbabwe | |||
2824400 | 2824400 | 2021-05-10 | Ukraine | Luhansk Oblast | 24569 | 788 | 20046 | 3735 | 48.574 | 39.3078 | 2021-05-11 04:20:41 | Luhansk Oblast, Ukraine | ||
1428732 | 1428732 | 2021-05-09 | Ukraine | Luhansk Oblast | 24538 | 786 | 20017 | 3735 | 48.574 | 39.3078 | 2021-05-10 04:20:38 | Luhansk Oblast, Ukraine | ||
1980801 | 1980801 | 2021-03-25 | Russia | Arkhangelsk Oblast | 59205 | 810 | 54660 | 3735 | 63.5589686 | 43.1221646 | 2021-03-26 05:26:55 | Arkhangelsk Oblast, Russia | ||
1092641 | 1092641 | 2021-03-03 | US | Oklahoma | McCurtain | 40089 | 3799 | 64 | 0 | 3735 | 34.11664328 | -94.77222373 | 2021-03-04 05:24:24 | McCurtain, Oklahoma, US |
280531 | 280531 | 2021-02-24 | US | Alabama | Chilton | 1021 | 3831 | 96 | 0 | 3735 | 32.85044126 | -86.7173256 | 2021-02-25 05:24:57 | Chilton, Alabama, US |
3052982 | 3052982 | 2021-02-16 | US | South Carolina | Dillon | 45033 | 3811 | 76 | 0 | 3735 | 34.39007791 | -79.37741872 | 2021-02-17 05:23:10 | Dillon, South Carolina, US |
2286752 | 2286752 | 2021-02-14 | US | Virginia | Fauquier | 51061 | 3772 | 37 | 0 | 3735 | 38.73564842 | -77.80647472 | 2021-02-15 05:24:49 | Fauquier, Virginia, US |
3982141 | 3982141 | 2021-02-10 | US | Wisconsin | Polk | 55095 | 3778 | 43 | 0 | 3735 | 45.46130348 | -92.44182875 | 2021-02-11 05:23:55 | Polk, Wisconsin, US |
1530857 | 1530857 | 2021-02-09 | US | Tennessee | Marshall | 47117 | 3861 | 53 | 0 | 3735 | 35.45798777 | -86.76420988 | 2021-02-10 05:22:41 | Marshall, Tennessee, US |
1760932 | 1760932 | 2021-01-24 | US | Michigan | Isabella | 26073 | 3801 | 66 | 0 | 3735 | 43.64060976 | -84.84664923 | 2021-01-25 05:22:16 | Isabella, Michigan, US |
2428539 | 2428539 | 2021-01-23 | US | Michigan | Isabella | 26073 | 3801 | 66 | 0 | 3735 | 43.64060976 | -84.84664923 | 2021-01-24 05:22:35 | Isabella, Michigan, US |
436862 | 436862 | 2021-01-21 | US | Louisiana | Lincoln | 22061 | 3818 | 83 | 0 | 3735 | 32.6003154 | -92.6659741 | 2021-01-22 05:22:10 | Lincoln, Louisiana, US |
239170 | 239170 | 2021-01-18 | US | Missouri | Newton | 29145 | 3795 | 60 | 0 | 3735 | 36.90519407 | -94.3394104 | 2021-01-19 05:22:15 | Newton, Missouri, US |
3104416 | 3104416 | 2021-01-16 | US | Tennessee | Rhea | 47143 | 3698 | 56 | 0 | 3735 | 35.60536161 | -84.93076643 | 2021-01-17 05:22:17 | Rhea, Tennessee, US |
3308809 | 3308809 | 2021-01-13 | US | Colorado | Eagle | 8037 | 4048 | 17 | 0 | 3735 | 39.62754308 | -106.6933637 | 2021-01-14 05:22:32 | Eagle, Colorado, US |
189847 | 189847 | 2021-01-11 | Canada | Saskatchewan | 18526 | 199 | 14588 | 3735 | 52.9399 | -106.4509 | 2021-01-12 05:22:15 | Saskatchewan, Canada | ||
3764233 | 3764233 | 2020-12-28 | US | Pennsylvania | Clearfield | 42033 | 3777 | 42 | 0 | 3735 | 41.00110782 | -78.47592663 | 2020-12-29 05:22:37 | Clearfield, Pennsylvania, US |
1902239 | 1902239 | 2020-12-18 | US | Indiana | Dubois | 18037 | 3777 | 42 | 0 | 3735 | 38.36597551 | -86.87924170000002 | 2020-12-19 05:27:52 | Dubois, Indiana, US |
3849484 | 3849484 | 2020-12-13 | US | Minnesota | Chisago | 27025 | 3759 | 24 | 0 | 3735 | 45.5021011 | -92.90861945 | 2020-12-14 05:26:27 | Chisago, Minnesota, US |
1601800 | 1601800 | 2020-12-10 | US | Maryland | Wicomico | 24045 | 3796 | 61 | 0 | 3735 | 38.37301947 | -75.62705831 | 2020-12-11 05:26:59 | Wicomico, Maryland, US |
923825 | 923825 | 2020-11-26 | Pakistan | Khyber Pakhtunkhwa | 46281 | 1346 | 41200 | 3735 | 34.485332 | 72.09169 | 2020-11-27 05:26:53 | Khyber Pakhtunkhwa, Pakistan | ||
274602 | 274602 | 2020-11-10 | US | Ohio | Delaware | 39041 | 3763 | 28 | 0 | 3735 | 40.27942393 | -83.00457058 | 2020-11-11 05:25:30 | Delaware, Ohio, US |
3483264 | 3483264 | 2020-10-26 | US | Tennessee | Madison | 47113 | 3784 | 79 | 0 | 3735 | 35.61181957 | -88.84076036 | 2020-10-27 04:24:45 | Madison, Tennessee, US |
3391064 | 3391064 | 2020-10-02 | US | Michigan | Washtenaw | 26161 | 3852 | 117 | 0 | 3735 | 42.253105 | -83.83853204 | 2020-10-03 04:23:40 | Washtenaw, Michigan, US |
2380395 | 2380395 | 2020-10-01 | US | Georgia | Columbia | 13073 | 3796 | 61 | 0 | 3735 | 33.54534185 | -82.263524 | 2020-10-02 04:23:51 | Columbia, Georgia, US |
2617314 | 2617314 | 2020-09-26 | US | Virginia | Alexandria | 51510 | 3804 | 69 | 0 | 3735 | 38.814003 | -77.08183073 | 2020-09-27 04:23:00 | Alexandria, Virginia, US |
2813187 | 2813187 | 2020-09-25 | US | Arizona | Mohave | 4015 | 3957 | 222 | 0 | 3735 | 35.70471703 | -113.7577902 | 2020-09-26 04:23:00 | Mohave, Arizona, US |
3315994 | 3315994 | 2020-09-22 | Canada | Ontario | 49257 | 2832 | 43326 | 3735 | 51.2538 | -85.3232 | 2020-09-23 04:23:00 | Ontario, Canada | ||
3532168 | 3532168 | 2020-08-12 | US | Florida | St. Johns | 12109 | 3774 | 39 | 0 | 3735 | 29.90096506 | -81.43589967 | 2020-08-13 04:29:15 | St. Johns, Florida, US |
1501353 | 1501353 | 2020-07-25 | US | Oregon | Multnomah | 41051 | 3813 | 78 | 0 | 3735 | 45.54747959 | -122.4169351 | 2020-07-26 04:35:00 | Multnomah, Oregon, US |
2562323 | 2562323 | 2020-07-24 | US | Oregon | Multnomah | 41051 | 3813 | 78 | 0 | 3735 | 45.54747959 | -122.4169351 | 2020-07-25 04:47:39 | Multnomah, Oregon, US |
3044947 | 3044947 | 2020-07-02 | US | Arkansas | Washington | 5143 | 3766 | 31 | 0 | 3735 | 35.976844 | -94.21800746 | 2020-07-03 04:33:54 | Washington, Arkansas, US |
1837297 | 1837297 | 2020-06-14 | Brazil | Santa Catarina | 13360 | 195 | 9430 | 3735 | -27.2423 | -50.2189 | 2020-06-15 03:33:14 | Santa Catarina, Brazil | ||
1862640 | 1862640 | 2020-05-22 | US | Georgia | Fulton | 13121 | 3931 | 196 | 0 | 3735 | 33.79216944 | -84.46319413 | 2020-05-23 02:32:42 | Fulton, Georgia, US |
3562178 | 3562178 | 2020-04-08 | Pakistan | 4263 | 61 | 467 | 3735 | 30.3753 | 69.3451 | 2020-04-08 22:51:39 | Pakistan |
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]);