johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 34323 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377145 | 3377145 | 2022-12-08 | Chile | Aysen | 34323 | 209 | 0 | -45.9864 | -73.7669 | 2022-12-09 04:21:05 | Aysen, Chile | |||
834197 | 834197 | 2022-12-02 | US | California | Napa | 6055 | 34323 | 161 | 0 | 38.50735751 | -122.332839 | 2022-12-03 04:21:02 | Napa, California, US | |
2136727 | 2136727 | 2022-12-01 | US | California | Napa | 6055 | 34323 | 161 | 0 | 38.50735751 | -122.332839 | 2022-12-02 04:21:07 | Napa, California, US | |
1965143 | 1965143 | 2022-11-30 | US | California | Napa | 6055 | 34323 | 161 | 0 | 38.50735751 | -122.332839 | 2022-12-01 04:21:03 | Napa, California, US | |
2557157 | 2557157 | 2022-11-29 | US | California | Napa | 6055 | 34323 | 161 | 0 | 38.50735751 | -122.332839 | 2022-11-30 04:21:07 | Napa, California, US | |
2018889 | 2018889 | 2022-09-20 | US | New Hampshire | Strafford | 33017 | 34323 | 227 | 0 | 43.291833 | -71.02336013 | 2022-09-21 04:23:22 | Strafford, New Hampshire, US | |
1109763 | 1109763 | 2022-05-21 | Russia | Altai Republic | 34323 | 614 | 0 | 50.7114101 | 86.8572186 | 2022-05-22 04:20:52 | Altai Republic, Russia | |||
186094 | 186094 | 2022-02-13 | Japan | Tochigi | 34323 | 139 | 0 | 36.689912 | 139.819213 | 2022-02-14 04:20:51 | Tochigi, Japan | |||
3958626 | 3958626 | 2021-06-26 | Netherlands | Drenthe | 34323 | 353 | 0 | 33928 | 52.862485 | 6.618435000000002 | 2021-06-27 04:21:39 | Drenthe, Netherlands | ||
20438 | 20438 | 2021-05-28 | Malawi | 34323 | 1154 | 32598 | 571 | -13.2543 | 34.3015 | 2021-05-29 04:20:41 | Malawi | |||
3709916 | 3709916 | 2021-04-03 | Canada | Saskatchewan | 34323 | 436 | 31744 | 2143 | 52.9399 | -106.4509 | 2021-04-04 04:20:49 | Saskatchewan, Canada | ||
1301772 | 1301772 | 2021-04-01 | Belgium | Walloon Brabant | 34323 | 0 | 0 | 34323 | 50.4 | 4.35 | 2021-04-02 04:20:36 | Walloon Brabant, Belgium | ||
2626114 | 2626114 | 2021-01-10 | Russia | Samara Oblast | 34323 | 702 | 31531 | 2090 | 53.2128813 | 50.8914633 | 2021-01-11 05:21:50 | Samara Oblast, Russia |
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]);