johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 21549 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1976823 | 1976823 | 2022-09-25 | Russia | Jewish Autonomous Okrug | 21549 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-09-26 04:20:52 | Jewish Autonomous Okrug, Russia | |||
1849529 | 1849529 | 2022-04-18 | US | Wisconsin | Jefferson | 55055 | 21549 | 240 | 0 | 43.02054068 | -88.77529134 | 2022-04-19 04:21:00 | Jefferson, Wisconsin, US | |
3613037 | 3613037 | 2022-01-12 | Italy | Molise | 21549 | 512 | 0 | 41.55774754 | 14.65916051 | 2022-01-13 08:00:09 | Molise, Italy | |||
1288165 | 1288165 | 2022-01-04 | US | New Hampshire | Merrimack | 33013 | 21549 | 173 | 0 | 43.29662971 | -71.6811573 | 2022-01-05 04:21:59 | Merrimack, New Hampshire, US | |
3519504 | 3519504 | 2022-01-02 | Mali | 21549 | 668 | 0 | 17.570692 | -3.996166000000001 | 2022-01-03 02:22:25 | Mali | ||||
3402967 | 3402967 | 2021-11-30 | US | Louisiana | Rapides | 22079 | 21549 | 475 | 0 | 31.19778499 | -92.52997303 | 2021-12-01 04:22:29 | Rapides, Louisiana, US | |
3402366 | 3402366 | 2021-11-30 | US | Idaho | Bonneville | 16019 | 21549 | 233 | 0 | 43.38713372 | -111.6161537 | 2021-12-01 04:22:29 | Bonneville, Idaho, US | |
3808150 | 3808150 | 2021-09-11 | US | New York | Niagara | 36063 | 21549 | 379 | 0 | 43.19898042 | -78.74777412 | 2021-09-12 04:21:13 | Niagara, New York, US | |
1674127 | 1674127 | 2021-02-07 | US | Michigan | Ottawa | 26139 | 21549 | 338 | 0 | 21211 | 42.95996803 | -85.9969107 | 2021-02-08 05:22:39 | Ottawa, Michigan, US |
976588 | 976588 | 2021-02-06 | US | Michigan | Ottawa | 26139 | 21549 | 338 | 0 | 21211 | 42.95996803 | -85.9969107 | 2021-02-07 05:23:00 | Ottawa, Michigan, US |
2409074 | 2409074 | 2020-12-23 | US | New York | Orange | 36071 | 21549 | 584 | 0 | 20965 | 41.40337468 | -74.30240757 | 2020-12-24 05:23:04 | Orange, New York, US |
529887 | 529887 | 2020-07-04 | India | Karnataka | 21549 | 335 | 9244 | 11970 | 14.705179999999999 | 76.166436 | 2020-07-05 04:33:46 | Karnataka, India | ||
2040048 | 2040048 | 2020-06-27 | India | Uttar Pradesh | 21549 | 649 | 14215 | 6685 | 26.925425 | 80.560982 | 2020-06-28 04:34:04 | Uttar Pradesh, India |
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]);