johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 7988 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3003290 | 3003290 | 2021-04-06 | Italy | Liguria | 91954 | 3910 | 80056 | 7988 | 44.41149315 | 8.9326992 | 2021-04-07 04:20:53 | Liguria, Italy | ||
1535763 | 1535763 | 2021-03-28 | Colombia | Atlantico | 145302 | 4388 | 132926 | 7988 | 10.6966 | -74.8741 | 2021-03-29 04:28:35 | Atlantico, Colombia | ||
532231 | 532231 | 2021-02-22 | US | Louisiana | St. Landry | 22097 | 8230 | 242 | 0 | 7988 | 30.59724262 | -92.00135806 | 2021-02-23 05:23:41 | St. Landry, Louisiana, US |
12554 | 12554 | 2021-01-26 | Russia | Krasnodar Krai | 32738 | 1374 | 23376 | 7988 | 45.7684014 | 39.0261044 | 2021-01-27 05:23:41 | Krasnodar Krai, Russia | ||
12389 | 12389 | 2021-01-26 | Jordan | 322241 | 4248 | 310005 | 7988 | 31.24 | 36.51 | 2021-01-27 05:23:41 | Jordan | |||
3761674 | 3761674 | 2020-12-28 | Mexico | Morelos | 9382 | 1394 | 0 | 7988 | 18.6813 | -99.1013 | 2020-12-29 05:22:37 | Morelos, Mexico | ||
3779128 | 3779128 | 2020-12-27 | US | Iowa | Pottawattamie | 19155 | 8078 | 90 | 0 | 7988 | 41.33640314 | -95.53907776 | 2020-12-28 05:22:06 | Pottawattamie, Iowa, US |
848554 | 848554 | 2020-12-12 | US | Tennessee | Sullivan | 47163 | 8188 | 131 | 0 | 7988 | 36.51240691 | -82.30412917 | 2020-12-13 05:27:20 | Sullivan, Tennessee, US |
2978470 | 2978470 | 2020-12-09 | US | Texas | Wichita | 48485 | 4802 | 155 | 0 | 7988 | 33.98842886 | -98.7041034 | 2020-12-10 05:26:19 | Wichita, Texas, US |
2917352 | 2917352 | 2020-11-14 | US | New Jersey | Somerset | 34035 | 8589 | 601 | 0 | 7988 | 40.56465737 | -74.61683016 | 2020-11-15 05:26:53 | Somerset, New Jersey, US |
1988365 | 1988365 | 2020-11-09 | Brazil | Amapa | 53330 | 764 | 44578 | 7988 | 0.902 | -52.003 | 2020-11-10 05:40:07 | Amapa, Brazil | ||
1546124 | 1546124 | 2020-11-07 | US | New Mexico | Dona Ana | 35013 | 8089 | 101 | 0 | 7988 | 32.35275771 | -106.8329387 | 2020-11-08 05:24:56 | Dona Ana, New Mexico, US |
2498781 | 2498781 | 2020-11-03 | US | Georgia | Cherokee | 13057 | 8093 | 105 | 0 | 7988 | 34.24393976 | -84.47431861 | 2020-11-04 05:25:09 | Cherokee, Georgia, US |
814374 | 814374 | 2020-09-05 | US | Georgia | Hall | 13139 | 8118 | 130 | 0 | 7988 | 34.32207823 | -83.81896936 | 2020-09-06 04:28:33 | Hall, Georgia, US |
1134984 | 1134984 | 2020-06-26 | US | Massachusetts | Plymouth | 25023 | 8646 | 658 | 0 | 7988 | 41.94070556 | -70.80802823 | 2020-06-27 04:33:35 | Plymouth, Massachusetts, 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]);