johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where active = 5442 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3295882 | 3295882 | 2021-07-30 | Azerbaijan | 343216 | 5022 | 332752 | 5442 | 40.1431 | 47.5769 | 2021-07-31 04:21:35 | Azerbaijan | |||
1892891 | 1892891 | 2021-06-30 | Brazil | Roraima | 112643 | 1747 | 104946 | 5442 | -2.7376 | -62.0751 | 2021-07-01 04:21:19 | Roraima, Brazil | ||
2255716 | 2255716 | 2021-05-19 | Italy | Friuli Venezia Giulia | 106619 | 3773 | 97404 | 5442 | 45.6494354 | 13.76813649 | 2021-05-20 04:21:05 | Friuli Venezia Giulia, Italy | ||
2760615 | 2760615 | 2021-05-03 | Australia | New South Wales | 5496 | 54 | 0 | 5442 | -33.8688 | 151.2093 | 2021-05-04 04:20:34 | New South Wales, Australia | ||
3668692 | 3668692 | 2021-03-06 | US | Indiana | Dearborn | 18029 | 5512 | 70 | 0 | 5442 | 39.14647946 | -84.97333539 | 2021-03-07 05:21:54 | Dearborn, Indiana, US |
616650 | 616650 | 2021-02-08 | US | Tennessee | McMinn | 47107 | 5649 | 85 | 0 | 5442 | 35.42812616 | -84.61520715 | 2021-02-09 05:23:30 | McMinn, Tennessee, US |
791105 | 791105 | 2021-02-04 | US | Florida | Putnam | 12107 | 5545 | 103 | 0 | 5442 | 29.60779729 | -81.74230285 | 2021-02-05 05:22:38 | Putnam, Florida, US |
13092 | 13092 | 2021-01-26 | US | Georgia | Bulloch | 13031 | 5513 | 71 | 0 | 5442 | 32.39577406 | -81.74811421 | 2021-01-27 05:23:41 | Bulloch, Georgia, US |
775147 | 775147 | 2021-01-12 | US | Georgia | Gordon | 13129 | 5514 | 72 | 0 | 5442 | 34.50487351 | -84.87296253 | 2021-01-13 05:22:15 | Gordon, Georgia, US |
3849653 | 3849653 | 2020-12-13 | US | Missouri | Buchanan | 29021 | 5514 | 72 | 0 | 5442 | 39.65816401 | -94.80138942 | 2020-12-14 05:26:27 | Buchanan, Missouri, US |
1008990 | 1008990 | 2020-12-06 | US | Pennsylvania | Washington | 42125 | 5518 | 76 | 0 | 5442 | 40.19208869 | -80.24582867 | 2020-12-07 05:26:14 | Washington, Pennsylvania, US |
1006807 | 1006807 | 2020-12-06 | US | Arkansas | Saline | 5125 | 5504 | 62 | 0 | 5442 | 34.64916145 | -92.67583224 | 2020-12-07 05:26:14 | Saline, Arkansas, US |
3392639 | 3392639 | 2020-10-02 | US | Utah | Davis | 49011 | 5474 | 32 | 0 | 5442 | 40.99001837 | -112.1139997 | 2020-10-03 04:23:40 | Davis, Utah, US |
2608814 | 2608814 | 2020-09-24 | US | South Carolina | Beaufort | 45013 | 5524 | 82 | 0 | 5442 | 32.39226291 | -80.72619758 | 2020-09-25 04:23:00 | Beaufort, South Carolina, US |
2174370 | 2174370 | 2020-09-09 | US | South Carolina | Spartanburg | 45083 | 5617 | 175 | 0 | 5442 | 34.92960077 | -81.99225984 | 2020-09-10 04:29:01 | Spartanburg, South Carolina, US |
61928 | 61928 | 2020-07-23 | Peru | Junin | 6366 | 924 | 0 | 5442 | -11.541783 | -74.876968 | 2020-07-24 05:30:40 | Junin, Peru | ||
3337076 | 3337076 | 2020-04-14 | US | Louisiana | Orleans | 22071 | 5718 | 276 | 0 | 5442 | 30.06971951 | -89.92660315 | 2020-04-14 23:33:31 | Orleans, Louisiana, 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]);