johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 32228 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3545054 | 3545054 | 2022-08-08 | US | Maine | Penobscot | 23019 | 32228 | 351 | 0 | 45.40194593 | -68.65020455 | 2022-08-09 04:20:34 | Penobscot, Maine, US | |
1071457 | 1071457 | 2022-08-07 | US | Maine | Penobscot | 23019 | 32228 | 351 | 0 | 45.40194593 | -68.65020455 | 2022-08-08 04:21:08 | Penobscot, Maine, US | |
1942045 | 1942045 | 2022-08-06 | US | Maine | Penobscot | 23019 | 32228 | 351 | 0 | 45.40194593 | -68.65020455 | 2022-08-07 04:20:54 | Penobscot, Maine, US | |
1298579 | 1298579 | 2022-02-17 | US | Arkansas | Sebastian | 5131 | 32228 | 470 | 0 | 35.19605503 | -94.27162713 | 2022-02-18 04:21:04 | Sebastian, Arkansas, US | |
2641760 | 2641760 | 2022-02-14 | Japan | Mie | 32228 | 202 | 0 | 34.508018 | 136.376013 | 2022-02-15 04:21:09 | Mie, Japan | |||
1693900 | 1693900 | 2022-01-10 | US | Maryland | Harford | 24025 | 32228 | 441 | 0 | 39.55010644 | -76.30775940000002 | 2022-01-11 04:22:01 | Harford, Maryland, US | |
1692010 | 1692010 | 2022-01-10 | Barbados | 32228 | 266 | 0 | 13.1939 | -59.5432 | 2022-01-11 04:22:01 | Barbados | ||||
1231579 | 1231579 | 2021-11-28 | India | Sikkim | 32228 | 403 | 0 | 27.571671000000002 | 88.472712 | 2021-11-29 04:22:30 | Sikkim, India | |||
2068045 | 2068045 | 2021-08-31 | Pakistan | Azad Jammu and Kashmir | 32228 | 698 | 0 | 34.027401 | 73.947253 | 2021-09-01 04:21:38 | Azad Jammu and Kashmir, Pakistan | |||
3685611 | 3685611 | 2021-08-02 | US | New Jersey | Atlantic | 34001 | 32228 | 698 | 0 | 39.47538693 | -74.65848483 | 2021-08-03 04:21:39 | Atlantic, New Jersey, US | |
2425569 | 2425569 | 2021-06-23 | US | Pennsylvania | Luzerne | 42079 | 32228 | 824 | 0 | 41.17823008 | -75.98447579 | 2021-06-24 04:21:55 | Luzerne, Pennsylvania, US | |
354919 | 354919 | 2021-03-11 | US | Oregon | Multnomah | 41051 | 32228 | 552 | 0 | 45.54747959 | -122.4169351 | 2021-03-12 05:26:50 | Multnomah, Oregon, US | |
927537 | 927537 | 2020-12-21 | Colombia | Cesar | 32228 | 967 | 29494 | 1767 | 9.3373 | -73.6536 | 2020-12-22 05:22:33 | Cesar, Colombia | ||
1754309 | 1754309 | 2020-12-14 | US | Texas | Collin | 48085 | 32228 | 300 | 0 | 35494 | 33.18820114 | -96.57264368 | 2020-12-15 05:26:38 | Collin, Texas, US |
1444852 | 1444852 | 2020-09-11 | Serbia | 32228 | 730 | 0 | 31498 | 44.0165 | 21.0059 | 2020-09-12 04:25:05 | Serbia | |||
442328 | 442328 | 2020-07-26 | India | Assam | 32228 | 79 | 24040 | 8109 | 26.357149 | 92.830441 | 2020-07-27 04:35:02 | Assam, 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]);