johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where confirmed = 38909 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199270 | 199270 | 2022-10-19 | US | Illinois | Kendall | 17093 | 38909 | 167 | 0 | 41.59081014 | -88.42869583 | 2022-10-20 04:22:59 | Kendall, Illinois, US | |
2757931 | 2757931 | 2022-10-18 | US | Illinois | Kendall | 17093 | 38909 | 166 | 0 | 41.59081014 | -88.42869583 | 2022-10-19 04:22:26 | Kendall, Illinois, US | |
1231525 | 1231525 | 2021-11-28 | Germany | Bremen | 38909 | 546 | 0 | 53.0793 | 8.8017 | 2021-11-29 04:22:30 | Bremen, Germany | |||
1358232 | 1358232 | 2021-11-27 | Germany | Bremen | 38909 | 546 | 0 | 53.0793 | 8.8017 | 2021-11-28 04:22:43 | Bremen, Germany | |||
758223 | 758223 | 2021-11-26 | Germany | Bremen | 38909 | 546 | 0 | 53.0793 | 8.8017 | 2021-11-27 04:22:45 | Bremen, Germany | |||
1708500 | 1708500 | 2021-06-02 | Russia | Belgorod Oblast | 38909 | 696 | 36424 | 1789 | 50.7080119 | 37.5837615 | 2021-06-03 04:23:32 | Belgorod Oblast, Russia | ||
1619689 | 1619689 | 2021-03-05 | US | Washington | Pierce | 53053 | 38909 | 563 | 0 | 38346 | 47.03892768 | -122.1405958 | 2021-03-06 04:23:41 | Pierce, Washington, US |
1529460 | 1529460 | 2021-02-09 | US | Maryland | Baltimore City | 24510 | 38909 | 843 | 0 | 38066 | 39.30211911 | -76.61151012 | 2021-02-10 05:22:41 | Baltimore City, Maryland, US |
1790229 | 1790229 | 2020-05-29 | Brazil | Amazonas | 38909 | 2011 | 0 | 36898 | -3.4168 | -65.8561 | 2020-05-30 02:32:48 | Amazonas, Brazil |
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]);