johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 31113 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2238353 | 2238353 | 2022-06-12 | US | Tennessee | Madison | 47113 | 31113 | 429 | 0 | 35.61181957 | -88.84076036 | 2022-06-13 04:21:14 | Madison, Tennessee, US | |
2084975 | 2084975 | 2022-05-15 | US | Illinois | Macon | 17115 | 31113 | 344 | 0 | 39.86064913 | -88.96342505 | 2022-05-16 04:20:47 | Macon, Illinois, US | |
3355685 | 3355685 | 2022-05-14 | US | Illinois | Macon | 17115 | 31113 | 344 | 0 | 39.86064913 | -88.96342505 | 2022-05-15 04:20:53 | Macon, Illinois, US | |
659330 | 659330 | 2022-05-13 | US | Illinois | Macon | 17115 | 31113 | 344 | 0 | 39.86064913 | -88.96342505 | 2022-05-14 04:20:48 | Macon, Illinois, US | |
749015 | 749015 | 2022-04-23 | US | Pennsylvania | Fayette | 42051 | 31113 | 670 | 0 | 39.92041012 | -79.64291195 | 2022-04-24 04:20:56 | Fayette, Pennsylvania, US | |
2088183 | 2088183 | 2021-12-14 | Russia | Karachay-Cherkess Republic | 31113 | 896 | 0 | 43.7368326 | 41.7267991 | 2021-12-15 03:22:16 | Karachay-Cherkess Republic, Russia | |||
1147046 | 1147046 | 2021-12-01 | US | Nebraska | Sarpy | 31153 | 31113 | 131 | 0 | 41.11314181 | -96.11156432 | 2021-12-02 04:22:37 | Sarpy, Nebraska, US | |
162606 | 162606 | 2021-11-19 | US | California | San Luis Obispo | 6079 | 31113 | 355 | 0 | 35.38822029 | -120.4039028 | 2021-11-20 04:22:17 | San Luis Obispo, California, US | |
1817258 | 1817258 | 2021-09-19 | US | Ohio | Lorain | 39093 | 31113 | 554 | 0 | 41.29553751 | -82.15083537 | 2021-09-20 04:21:22 | Lorain, Ohio, US | |
2316007 | 2316007 | 2021-06-04 | US | Florida | Lake | 12069 | 31113 | 663 | 0 | 28.76202069 | -81.7125123 | 2021-06-05 04:23:03 | Lake, Florida, US | |
1449292 | 1449292 | 2021-06-03 | US | Florida | Lake | 12069 | 31113 | 663 | 0 | 28.76202069 | -81.7125123 | 2021-06-04 04:23:37 | Lake, Florida, US | |
3695483 | 3695483 | 2020-12-31 | Italy | Sardegna | 31113 | 747 | 13913 | 16453 | 39.21531192 | 9.110616306 | 2021-01-01 05:23:07 | Sardegna, Italy | ||
1121735 | 1121735 | 2020-09-17 | Paraguay | 31113 | 584 | 16313 | 14216 | -23.4425 | -58.4438 | 2020-09-18 05:05:00 | Paraguay |
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]);