johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 21452 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 14
- San Marino 3
- Ethiopia 1
- Italy 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3277146 | 3277146 | 2022-10-23 | San Marino | 21452 | 119 | 0 | 43.9424 | 12.4578 | 2022-10-24 04:22:29 | San Marino | ||||
2268184 | 2268184 | 2022-10-22 | San Marino | 21452 | 119 | 0 | 43.9424 | 12.4578 | 2022-10-23 04:22:46 | San Marino | ||||
1592484 | 1592484 | 2022-10-21 | San Marino | 21452 | 119 | 0 | 43.9424 | 12.4578 | 2022-10-22 04:22:53 | San Marino | ||||
3214799 | 3214799 | 2022-10-12 | US | Arkansas | Jefferson | 5069 | 21452 | 304 | 0 | 34.26767081 | -91.92619839 | 2022-10-13 04:22:39 | Jefferson, Arkansas, US | |
1609857 | 1609857 | 2022-07-20 | US | Maryland | Wicomico | 24045 | 21452 | 332 | 0 | 38.37301947 | -75.62705831 | 2022-07-21 04:21:10 | Wicomico, Maryland, US | |
1187022 | 1187022 | 2022-05-18 | US | New York | Tompkins | 36109 | 21452 | 86 | 0 | 42.44945765 | -76.47229843 | 2022-05-19 04:20:54 | Tompkins, New York, US | |
1187018 | 1187018 | 2022-05-18 | US | New York | Steuben | 36101 | 21452 | 254 | 0 | 42.2689144 | -77.3829924 | 2022-05-19 04:20:54 | Steuben, New York, US | |
318860 | 318860 | 2022-02-12 | US | Tennessee | Greene | 47059 | 21452 | 333 | 0 | 36.17470125 | -82.84691273 | 2022-02-13 04:21:00 | Greene, Tennessee, US | |
1218804 | 1218804 | 2022-01-08 | US | Texas | Tom Green | 48451 | 21452 | 402 | 0 | 31.40464436 | -100.46244300000001 | 2022-01-09 04:21:46 | Tom Green, Texas, US | |
723870 | 723870 | 2021-11-20 | US | Kentucky | Boone | 21015 | 21452 | 205 | 0 | 38.97065142 | -84.72615357 | 2021-11-21 04:22:13 | Boone, Kentucky, US | |
1334801 | 1334801 | 2021-09-28 | US | Arkansas | Sebastian | 5131 | 21452 | 342 | 0 | 35.19605503 | -94.27162713 | 2021-09-29 04:21:45 | Sebastian, Arkansas, US | |
3893274 | 3893274 | 2021-08-29 | US | Kansas | Shawnee | 20177 | 21452 | 397 | 0 | 39.04100763 | -95.75572640000001 | 2021-08-30 04:21:23 | Shawnee, Kansas, US | |
2794377 | 2794377 | 2021-08-28 | US | Kansas | Shawnee | 20177 | 21452 | 397 | 0 | 39.04100763 | -95.75572640000001 | 2021-08-29 04:21:14 | Shawnee, Kansas, US | |
2924536 | 2924536 | 2021-08-27 | US | Kansas | Shawnee | 20177 | 21452 | 397 | 0 | 39.04100763 | -95.75572640000001 | 2021-08-28 04:21:28 | Shawnee, Kansas, US | |
1841924 | 1841924 | 2021-04-14 | Italy | Basilicata | 21452 | 494 | 15556 | 5402 | 40.63947052 | 15.80514834 | 2021-04-15 04:20:54 | Basilicata, Italy | ||
606485 | 606485 | 2021-04-09 | US | Georgia | Forsyth | 13117 | 21452 | 179 | 0 | 34.22604035 | -84.12315129999998 | 2021-04-10 04:20:59 | Forsyth, Georgia, US | |
998633 | 998633 | 2021-03-01 | Russia | Chuvashia Republic | 21452 | 1040 | 19643 | 769 | 55.4259922 | 47.0849429 | 2021-03-02 05:23:30 | Chuvashia Republic, Russia | ||
2185888 | 2185888 | 2021-02-26 | US | North Carolina | Durham | 37063 | 21452 | 203 | 0 | 21249 | 36.03638492 | -78.87608331 | 2021-02-27 05:22:28 | Durham, North Carolina, US |
744537 | 744537 | 2021-02-20 | US | New York | Dutchess | 36027 | 21452 | 401 | 0 | 21051 | 41.76486060000001 | -73.74356679 | 2021-02-21 05:24:33 | Dutchess, New York, US |
458896 | 458896 | 2020-08-07 | Ethiopia | 21452 | 380 | 9415 | 11657 | 9.145 | 40.4897 | 2020-08-08 04:34:53 | Ethiopia |
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]);