johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 25536 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417702 | 2417702 | 2022-12-05 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-06 04:21:03 | Greenwood, South Carolina, US | |
721310 | 721310 | 2022-12-04 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-05 04:20:58 | Greenwood, South Carolina, US | |
2819599 | 2819599 | 2022-12-03 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-04 04:20:56 | Greenwood, South Carolina, US | |
836455 | 836455 | 2022-12-02 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-03 04:21:02 | Greenwood, South Carolina, US | |
2138985 | 2138985 | 2022-12-01 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-02 04:21:07 | Greenwood, South Carolina, US | |
1967401 | 1967401 | 2022-11-30 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-12-01 04:21:03 | Greenwood, South Carolina, US | |
2559415 | 2559415 | 2022-11-29 | US | South Carolina | Greenwood | 45047 | 25536 | 320 | 0 | 34.15272415 | -82.12715789 | 2022-11-30 04:21:07 | Greenwood, South Carolina, US | |
2688644 | 2688644 | 2022-10-03 | US | Tennessee | Greene | 47059 | 25536 | 395 | 0 | 36.17470125 | -82.84691273 | 2022-10-04 04:22:55 | Greene, Tennessee, US | |
3856365 | 3856365 | 2022-02-18 | US | Arkansas | Unassigned | 90005 | 25536 | 0 | 0 | 36.38177105 | 0.0 | 2022-02-19 04:21:11 | Unassigned, Arkansas, US | |
3809870 | 3809870 | 2022-01-28 | India | Ladakh | 25536 | 223 | 0 | 34.1526 | 77.5771 | 2022-01-29 04:21:10 | Ladakh, India | |||
247072 | 247072 | 2021-08-17 | US | Mississippi | Harrison | 28047 | 25536 | 349 | 0 | 30.51359752 | -89.12467576 | 2021-08-18 04:21:35 | Harrison, Mississippi, US | |
1310363 | 1310363 | 2021-05-26 | Russia | Chuvashia Republic | 25536 | 1416 | 23313 | 807 | 55.4259922 | 47.0849429 | 2021-05-27 04:20:59 | Chuvashia Republic, Russia | ||
3455018 | 3455018 | 2021-03-18 | US | New Jersey | Gloucester | 34015 | 25536 | 566 | 0 | 39.71581067 | -75.13995546 | 2021-03-19 05:26:09 | Gloucester, New Jersey, US | |
55879 | 55879 | 2021-03-07 | US | Indiana | Elkhart | 18039 | 25536 | 420 | 0 | 41.59761169 | -85.85875695 | 2021-03-08 05:24:48 | Elkhart, Indiana, US | |
75046 | 75046 | 2020-12-03 | India | Manipur | 25536 | 294 | 22172 | 3070 | 24.738975 | 93.882541 | 2020-12-04 05:27:27 | Manipur, India | ||
2919751 | 2919751 | 2020-11-04 | US | California | Santa Clara | 6085 | 25536 | 393 | 0 | 25128 | 37.23104908 | -121.6970462 | 2020-11-05 06:05:03 | Santa Clara, California, US |
415501 | 415501 | 2020-07-05 | Russia | Saint Petersburg | 25536 | 1345 | 19994 | 4197 | 59.9606739 | 30.158655100000004 | 2020-07-06 04:33:57 | Saint Petersburg, 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]);