johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where active = 13300 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50668 | 50668 | 2021-05-29 | Denmark | 279434 | 2516 | 263618 | 13300 | 56.2639 | 9.5018 | 2021-05-30 04:20:55 | Denmark | |||
2542046 | 2542046 | 2021-01-07 | US | Colorado | Pueblo | 8101 | 14789 | 350 | 0 | 13300 | 38.17359144 | -104.5127437 | 2021-01-08 05:22:42 | Pueblo, Colorado, US |
1586345 | 1586345 | 2020-11-30 | US | New Mexico | Dona Ana | 35013 | 13487 | 187 | 0 | 13300 | 32.35275771 | -106.8329387 | 2020-12-01 05:26:18 | Dona Ana, New Mexico, US |
865310 | 865310 | 2020-11-12 | US | California | Imperial | 6025 | 13647 | 341 | 0 | 13300 | 33.0393082 | -115.3669042 | 2020-11-13 05:25:30 | Imperial, California, US |
8496 | 8496 | 2020-10-25 | Peru | Moquegua | 14109 | 809 | 0 | 13300 | -16.860271 | -70.839046 | 2020-10-26 04:25:02 | Moquegua, Peru | ||
3391549 | 3391549 | 2020-10-02 | US | New Jersey | Ocean | 34029 | 14350 | 1050 | 0 | 13300 | 39.8895449 | -74.28089251 | 2020-10-03 04:23:40 | Ocean, New Jersey, US |
2454696 | 2454696 | 2020-09-19 | Greece | 14978 | 331 | 1347 | 13300 | 39.0742 | 21.8243 | 2020-09-20 04:22:00 | Greece | |||
1706519 | 1706519 | 2020-07-21 | US | New York | Rockland | 36087 | 13806 | 506 | 0 | 13300 | 41.15027894 | -74.02560498 | 2020-07-22 04:34:42 | Rockland, New York, US |
2625325 | 2625325 | 2020-06-25 | Sweden | Vastra Gotaland | 14013 | 713 | 0 | 13300 | 58.2528 | 13.0596 | 2020-06-26 04:33:43 | Vastra Gotaland, Sweden | ||
1791597 | 1791597 | 2020-05-31 | US | Massachusetts | Essex | 25009 | 14225 | 925 | 0 | 13300 | 42.6687626 | -70.94687179 | 2020-06-01 02:32:46 | Essex, 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]);