johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 24361 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2803231 | 2803231 | 2022-04-06 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-07 04:20:53 | Columbiana, Ohio, US | |
3870000 | 3870000 | 2022-04-05 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-06 04:20:49 | Columbiana, Ohio, US | |
2751342 | 2751342 | 2022-04-04 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-05 04:20:48 | Columbiana, Ohio, US | |
3732688 | 3732688 | 2022-04-03 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-04 04:20:51 | Columbiana, Ohio, US | |
502123 | 502123 | 2022-04-02 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-03 04:20:48 | Columbiana, Ohio, US | |
3353108 | 3353108 | 2022-04-01 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-02 04:20:47 | Columbiana, Ohio, US | |
1542413 | 1542413 | 2022-03-31 | US | Ohio | Columbiana | 39029 | 24361 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-01 04:20:28 | Columbiana, Ohio, US | |
71494 | 71494 | 2022-02-07 | US | Alabama | St. Clair | 1115 | 24361 | 381 | 0 | 33.71902176 | -86.31029372 | 2022-02-08 04:21:15 | St. Clair, Alabama, US | |
3498887 | 3498887 | 2021-12-15 | US | Pennsylvania | Schuylkill | 42107 | 24361 | 527 | 0 | 40.70497338 | -76.2150785 | 2021-12-16 04:22:11 | Schuylkill, Pennsylvania, US | |
3497772 | 3497772 | 2021-12-15 | US | Maryland | Howard | 24027 | 24361 | 287 | 0 | 39.25305293 | -76.93126208 | 2021-12-16 04:22:11 | Howard, Maryland, US | |
989338 | 989338 | 2021-10-04 | US | North Carolina | Robeson | 37155 | 24361 | 403 | 0 | 34.64244496 | -79.10250529999998 | 2021-10-05 04:21:27 | Robeson, North Carolina, US | |
642146 | 642146 | 2021-09-07 | Russia | Karachay-Cherkess Republic | 24361 | 494 | 0 | 43.7368326 | 41.7267991 | 2021-09-08 04:21:31 | Karachay-Cherkess Republic, Russia | |||
1204574 | 1204574 | 2021-03-22 | US | Georgia | Clayton | 13063 | 24361 | 417 | 0 | 33.54187245 | -84.35594188 | 2021-03-23 05:26:18 | Clayton, Georgia, US | |
3691668 | 3691668 | 2020-12-24 | Russia | Buryatia Republic | 24361 | 557 | 21671 | 2133 | 52.7182426 | 109.492143 | 2020-12-25 05:22:48 | Buryatia Republic, Russia | ||
1731072 | 1731072 | 2020-11-08 | US | Oklahoma | Tulsa | 40143 | 24361 | 226 | 0 | 24135 | 36.11939621 | -95.94013939 | 2020-11-09 05:25:45 | Tulsa, Oklahoma, US |
2707368 | 2707368 | 2020-07-17 | US | Florida | Palm Beach | 12099 | 24361 | 659 | 0 | 23702 | 26.64676272 | -80.46536002 | 2020-07-18 04:34:45 | Palm Beach, Florida, 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]);