johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 43019 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199314 | 199314 | 2022-10-19 | US | Illinois | Tazewell | 17179 | 43019 | 490 | 0 | 40.50716185 | -89.51404662 | 2022-10-20 04:22:59 | Tazewell, Illinois, US | |
1348859 | 1348859 | 2022-08-10 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-11 04:20:49 | Canadian, Oklahoma, US | |
1088614 | 1088614 | 2022-08-09 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-10 04:20:57 | Canadian, Oklahoma, US | |
3546029 | 3546029 | 2022-08-08 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-09 04:20:34 | Canadian, Oklahoma, US | |
1072432 | 1072432 | 2022-08-07 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-08 04:21:08 | Canadian, Oklahoma, US | |
1943020 | 1943020 | 2022-08-06 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-07 04:20:54 | Canadian, Oklahoma, US | |
882819 | 882819 | 2022-08-05 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-06 04:20:56 | Canadian, Oklahoma, US | |
2011230 | 2011230 | 2022-08-04 | US | Oklahoma | Canadian | 40017 | 43019 | 394 | 0 | 35.5426055 | -97.98465569 | 2022-08-05 04:20:52 | Canadian, Oklahoma, US | |
2241165 | 2241165 | 2022-06-28 | US | Minnesota | Scott | 27139 | 43019 | 266 | 0 | 44.6490231 | -93.53340251 | 2022-06-29 04:20:59 | Scott, Minnesota, US | |
102566 | 102566 | 2022-01-14 | US | Texas | Unassigned | 90048 | 43019 | 0 | 0 | 36.27829105 | -99.97616148 | 2022-01-15 04:21:07 | Unassigned, Texas, US | |
698526 | 698526 | 2021-11-04 | Netherlands | Drenthe | 43019 | 370 | 0 | 52.862485 | 6.6184350000000025 | 2021-11-05 04:21:54 | Drenthe, Netherlands | |||
3558304 | 3558304 | 2021-08-21 | US | Pennsylvania | Chester | 42029 | 43019 | 830 | 0 | 39.97291773 | -75.74768357 | 2021-08-22 04:21:29 | Chester, Pennsylvania, US | |
3296438 | 3296438 | 2021-07-30 | Russia | Vladimir Oblast | 43019 | 1447 | 39990 | 1582 | 56.0503336 | 40.6561633 | 2021-07-31 04:21:35 | Vladimir Oblast, Russia | ||
1440451 | 1440451 | 2021-07-07 | Congo (Kinshasa) | 43019 | 969 | 28526 | 13524 | -4.0383 | 21.7587 | 2021-07-08 04:21:26 | Congo (Kinshasa) | |||
390539 | 390539 | 2021-04-04 | US | North Carolina | Guilford | 37081 | 43019 | 617 | 0 | 36.07959451 | -79.78824948 | 2021-04-05 04:20:35 | Guilford, North Carolina, US | |
3712455 | 3712455 | 2021-04-03 | US | North Carolina | Guilford | 37081 | 43019 | 617 | 0 | 36.07959451 | -79.78824948 | 2021-04-04 04:20:49 | Guilford, North Carolina, US | |
243571 | 243571 | 2021-04-02 | US | North Carolina | Guilford | 37081 | 43019 | 617 | 0 | 36.07959451 | -79.78824948 | 2021-04-03 04:20:44 | Guilford, North Carolina, US | |
1304366 | 1304366 | 2021-04-01 | US | North Carolina | Guilford | 37081 | 43019 | 617 | 0 | 36.07959451 | -79.78824948 | 2021-04-02 04:20:36 | Guilford, North Carolina, 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]);