johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 30314 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3552326 | 3552326 | 2022-11-27 | US | Connecticut | Windham | 9015 | 30314 | 332 | 0 | 41.82972709 | -71.98182316 | 2022-11-28 04:21:02 | Windham, Connecticut, US | |
1395852 | 1395852 | 2022-09-02 | US | New Jersey | Hunterdon | 34019 | 30314 | 284 | 0 | 40.56335249 | -74.91284156 | 2022-09-03 04:21:04 | Hunterdon, New Jersey, US | |
2236391 | 2236391 | 2022-06-12 | US | Illinois | Kankakee | 17091 | 30314 | 371 | 0 | 41.13746989 | -87.86205334 | 2022-06-13 04:21:14 | Kankakee, Illinois, US | |
3142589 | 3142589 | 2022-06-11 | US | Illinois | Kankakee | 17091 | 30314 | 371 | 0 | 41.13746989 | -87.86205334 | 2022-06-12 04:20:53 | Kankakee, Illinois, US | |
1945505 | 1945505 | 2022-06-10 | US | Illinois | Kankakee | 17091 | 30314 | 371 | 0 | 41.13746989 | -87.86205334 | 2022-06-11 04:21:01 | Kankakee, Illinois, US | |
3870538 | 3870538 | 2022-04-05 | US | Tennessee | Sevier | 47155 | 30314 | 409 | 0 | 35.78077323 | -83.52244332 | 2022-04-06 04:20:49 | Sevier, Tennessee, US | |
1057765 | 1057765 | 2022-02-23 | Haiti | 30314 | 820 | 0 | 18.9712 | -72.2852 | 2022-02-24 04:21:14 | Haiti | ||||
1229613 | 1229613 | 2022-01-24 | US | Montana | Gallatin | 30031 | 30314 | 109 | 0 | 45.54486106 | -111.1692571 | 2022-01-25 04:21:05 | Gallatin, Montana, US | |
511840 | 511840 | 2021-08-19 | Pakistan | Azad Jammu and Kashmir | 30314 | 672 | 0 | 34.027401 | 73.947253 | 2021-08-20 04:21:33 | Azad Jammu and Kashmir, Pakistan | |||
3114494 | 3114494 | 2021-05-06 | US | Illinois | Madison | 17119 | 30314 | 518 | 0 | 38.83042506 | -89.90422563 | 2021-05-07 04:20:40 | Madison, Illinois, US | |
1638992 | 1638992 | 2021-04-29 | US | Pennsylvania | Luzerne | 42079 | 30314 | 794 | 0 | 41.17823008 | -75.98447579 | 2021-04-30 04:21:03 | Luzerne, Pennsylvania, US | |
3440973 | 3440973 | 2020-11-11 | Peru | Ica | 30314 | 3453 | 0 | 26861 | -14.235097 | -75.574821 | 2020-11-12 05:25:55 | Ica, Peru | ||
1612229 | 1612229 | 2020-08-14 | Italy | Emilia-Romagna | 30314 | 4298 | 24150 | 1866 | 44.49436681 | 11.3417208 | 2020-08-15 04:27:31 | Emilia-Romagna, Italy | ||
1041238 | 1041238 | 2020-05-26 | Italy | Piemonte | 30314 | 3812 | 19561 | 6941 | 45.0732745 | 7.680687483 | 2020-05-27 02:32:31 | Piemonte, Italy |
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]);