johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where confirmed = 43151 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 9
- Bosnia and Herzegovina 1
- Nigeria 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1548529 | 1548529 | 2022-03-07 | US | California | Madera | 6039 | 43151 | 361 | 0 | 37.21513971 | -119.76655890000002 | 2022-03-08 04:20:54 | Madera, California, US | |
683114 | 683114 | 2021-10-24 | US | Georgia | Cherokee | 13057 | 43151 | 446 | 0 | 34.24393976 | -84.47431861 | 2021-10-25 04:22:31 | Cherokee, Georgia, US | |
771122 | 771122 | 2021-10-23 | US | Georgia | Cherokee | 13057 | 43151 | 446 | 0 | 34.24393976 | -84.47431861 | 2021-10-24 04:21:22 | Cherokee, Georgia, US | |
654769 | 654769 | 2021-10-22 | US | Georgia | Cherokee | 13057 | 43151 | 446 | 0 | 34.24393976 | -84.47431861 | 2021-10-23 04:21:32 | Cherokee, Georgia, US | |
635461 | 635461 | 2021-10-13 | US | Louisiana | St. Tammany | 22103 | 43151 | 707 | 0 | 30.40942847 | -89.95642711 | 2021-10-14 04:21:29 | St. Tammany, Louisiana, US | |
2551813 | 2551813 | 2021-04-15 | US | Tennessee | Hamilton | 47065 | 43151 | 479 | 0 | 35.17670231 | -85.16652245 | 2021-04-16 04:20:46 | Hamilton, Tennessee, US | |
280738 | 280738 | 2021-02-24 | US | California | Monterey | 6053 | 43151 | 320 | 0 | 42923 | 36.21862405 | -121.2413397 | 2021-02-25 05:24:57 | Monterey, California, US |
3603684 | 3603684 | 2021-02-17 | US | Pennsylvania | Bucks | 42017 | 43151 | 1098 | 0 | 42053 | 40.33682119 | -75.10836643 | 2021-02-18 05:22:58 | Bucks, Pennsylvania, US |
340723 | 340723 | 2021-02-03 | US | Arizona | Pinal | 4021 | 43151 | 636 | 0 | 42515 | 32.90525627 | -111.3449483 | 2021-02-04 05:22:26 | Pinal, Arizona, US |
1452316 | 1452316 | 2020-10-27 | Bosnia and Herzegovina | 43151 | 1125 | 26903 | 15123 | 43.9159 | 17.6791 | 2020-10-28 04:24:39 | Bosnia and Herzegovina | |||
3265075 | 3265075 | 2020-07-31 | Nigeria | 43151 | 879 | 19565 | 22707 | 9.082 | 8.6753 | 2020-08-01 04:36:27 | Nigeria |
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]);