johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 12456 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306470 | 1306470 | 2021-07-27 | Sweden | Jamtland Harjedalen | 12577 | 121 | 0 | 12456 | 63.1712 | 14.9592 | 2021-07-28 04:21:39 | Jamtland Harjedalen, Sweden | ||
1527639 | 1527639 | 2021-02-09 | Brazil | Para | 342482 | 7864 | 320740 | 12456 | -1.9981 | -54.9306 | 2021-02-10 05:22:41 | Para, Brazil | ||
1461972 | 1461972 | 2021-01-31 | US | New York | Broome | 36007 | 12748 | 292 | 0 | 12456 | 42.15903158 | -75.81326086 | 2021-02-01 05:22:53 | Broome, New York, US |
910945 | 910945 | 2021-01-19 | US | Puerto Rico | San Juan | 72127 | 12456 | 0 | 0 | 12456 | 18.386933 | -66.061128 | 2021-01-20 05:21:54 | San Juan, Puerto Rico, US |
1013317 | 1013317 | 2020-12-30 | US | Texas | Bell | 48027 | 14917 | 165 | 0 | 12456 | 31.03736027 | -97.4785025 | 2020-12-31 05:22:49 | Bell, Texas, US |
2121578 | 2121578 | 2020-12-20 | US | Missouri | Boone | 29019 | 12492 | 36 | 0 | 12456 | 38.99186229 | -92.30723575 | 2020-12-21 05:27:58 | Boone, Missouri, US |
3169583 | 3169583 | 2020-11-16 | India | Gujarat | 189236 | 3808 | 172972 | 12456 | 22.694884 | 71.590923 | 2020-11-17 05:25:54 | Gujarat, India | ||
272101 | 272101 | 2020-11-10 | India | Gujarat | 182557 | 3770 | 166331 | 12456 | 22.694884 | 71.590923 | 2020-11-11 05:25:30 | Gujarat, India | ||
2080084 | 2080084 | 2020-10-31 | Peru | Ayacucho | 13228 | 772 | 0 | 12456 | -14.091648 | -74.08344 | 2020-11-01 04:36:19 | Ayacucho, Peru | ||
2869362 | 2869362 | 2020-09-13 | US | Connecticut | Hartford | 9003 | 13886 | 1430 | 0 | 12456 | 41.80283011 | -72.73103891 | 2020-09-14 04:26:00 | Hartford, Connecticut, US |
547401 | 547401 | 2020-09-12 | US | Connecticut | Hartford | 9003 | 13886 | 1430 | 0 | 12456 | 41.80283011 | -72.73103891 | 2020-09-13 04:30:52 | Hartford, Connecticut, US |
1445230 | 1445230 | 2020-09-11 | US | Connecticut | Hartford | 9003 | 13886 | 1430 | 0 | 12456 | 41.80283011 | -72.73103891 | 2020-09-12 04:25:05 | Hartford, Connecticut, US |
1354487 | 1354487 | 2020-09-03 | Peru | Ucayali | 13846 | 1390 | 0 | 12456 | -9.621718 | -73.444929 | 2020-09-04 04:28:26 | Ucayali, Peru | ||
609850 | 609850 | 2020-08-29 | Peru | Loreto | 15056 | 2600 | 0 | 12456 | -4.124847 | -74.424115 | 2020-08-30 04:28:22 | Loreto, Peru | ||
2712575 | 2712575 | 2020-05-28 | South Africa | 27403 | 577 | 14370 | 12456 | -30.5595 | 22.9375 | 2020-05-29 02:32:50 | South Africa |
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]);