johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 30671 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3950865 | 3950865 | 2022-08-17 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-18 04:21:11 | Etowah, Alabama, US | |
991367 | 991367 | 2022-08-16 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-17 04:20:59 | Etowah, Alabama, US | |
2494406 | 2494406 | 2022-08-15 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-16 04:20:58 | Etowah, Alabama, US | |
3647956 | 3647956 | 2022-08-14 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-15 04:20:59 | Etowah, Alabama, US | |
1968962 | 1968962 | 2022-08-13 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-14 04:20:55 | Etowah, Alabama, US | |
2888771 | 2888771 | 2022-08-12 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-13 04:20:52 | Etowah, Alabama, US | |
3908376 | 3908376 | 2022-08-11 | US | Alabama | Etowah | 1055 | 30671 | 660 | 0 | 34.04567266 | -86.04051873 | 2022-08-12 04:20:54 | Etowah, Alabama, US | |
2264899 | 2264899 | 2022-03-14 | US | Illinois | Kendall | 17093 | 30671 | 157 | 0 | 41.59081014 | -88.42869583 | 2022-03-15 04:20:47 | Kendall, Illinois, US | |
1215342 | 1215342 | 2022-01-08 | Chile | Magallanes | 30671 | 509 | 0 | -52.368 | -70.9863 | 2022-01-09 04:21:46 | Magallanes, Chile | |||
1236197 | 1236197 | 2021-09-27 | US | California | Kings | 6031 | 30671 | 297 | 0 | 36.07409056 | -119.8159973 | 2021-09-28 04:21:28 | Kings, California, US | |
2518374 | 2518374 | 2021-08-18 | Russia | Chuvashia Republic | 30671 | 1880 | 0 | 55.4259922 | 47.0849429 | 2021-08-19 04:21:15 | Chuvashia Republic, Russia | |||
1913621 | 1913621 | 2021-05-20 | US | Alaska | Anchorage | 2020 | 30671 | 179 | 0 | 61.14998174 | -149.14269860000005 | 2021-05-21 04:20:43 | Anchorage, Alaska, US | |
3861391 | 3861391 | 2020-12-04 | US | Maryland | Baltimore | 24005 | 30671 | 763 | 0 | 29908 | 39.45784712 | -76.62911955 | 2020-12-05 05:27:36 | Baltimore, Maryland, US |
2537923 | 2537923 | 2020-12-01 | US | California | Alameda | 6001 | 30671 | 460 | 0 | 30236 | 37.64629437 | -121.8929271 | 2020-12-02 05:27:41 | Alameda, California, US |
891919 | 891919 | 2020-11-05 | Chile | Valparaiso | 30671 | 1075 | 29167 | 429 | -33.0472 | -71.6127 | 2020-11-06 05:24:55 | Valparaiso, Chile | ||
3307457 | 3307457 | 2020-11-02 | US | Utah | Utah | 49049 | 30671 | 83 | 0 | 30588 | 40.1166722 | -111.6657662 | 2020-11-03 06:00:16 | Utah, Utah, US |
3991144 | 3991144 | 2020-10-20 | US | California | Fresno | 6019 | 30671 | 431 | 0 | 30234 | 36.75733899 | -119.6466953 | 2020-10-21 04:24:14 | Fresno, California, US |
97113 | 97113 | 2020-08-04 | US | Pennsylvania | Philadelphia | 42101 | 30671 | 1695 | 0 | 28976 | 40.00338507 | -75.1379271 | 2020-08-05 04:34:43 | Philadelphia, Pennsylvania, 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]);