johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 24196 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 31
- Japan 1
- Mexico 1
- North Macedonia 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2012095 | 2012095 | 2022-08-04 | US | Virginia | Roanoke | 51161 | 24196 | 290 | 0 | 37.26865804 | -80.06396753 | 2022-08-05 04:20:52 | Roanoke, Virginia, US | |
1488258 | 1488258 | 2022-07-26 | US | Connecticut | Tolland | 9013 | 24196 | 287 | 0 | 41.85853803 | -72.3308481 | 2022-07-27 04:21:04 | Tolland, Connecticut, US | |
3969245 | 3969245 | 2022-07-05 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-06 04:20:58 | Northumberland, Pennsylvania, US | |
3080756 | 3080756 | 2022-07-04 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-05 04:20:45 | Northumberland, Pennsylvania, US | |
1770038 | 1770038 | 2022-07-03 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-04 04:20:54 | Northumberland, Pennsylvania, US | |
3368024 | 3368024 | 2022-07-02 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-03 04:20:59 | Northumberland, Pennsylvania, US | |
596353 | 596353 | 2022-07-01 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-02 04:21:16 | Northumberland, Pennsylvania, US | |
3942754 | 3942754 | 2022-06-30 | US | Pennsylvania | Northumberland | 42097 | 24196 | 545 | 0 | 40.84785433 | -76.70798222 | 2022-07-01 04:21:10 | Northumberland, Pennsylvania, US | |
3985297 | 3985297 | 2022-06-15 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-16 04:20:55 | Mercer, Pennsylvania, US | |
949538 | 949538 | 2022-06-14 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-15 04:20:54 | Mercer, Pennsylvania, US | |
2981946 | 2981946 | 2022-06-13 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-14 04:20:52 | Mercer, Pennsylvania, US | |
2238072 | 2238072 | 2022-06-12 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-13 04:21:14 | Mercer, Pennsylvania, US | |
3144270 | 3144270 | 2022-06-11 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-12 04:20:53 | Mercer, Pennsylvania, US | |
1947186 | 1947186 | 2022-06-10 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-11 04:21:01 | Mercer, Pennsylvania, US | |
3160325 | 3160325 | 2022-06-09 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-10 04:20:55 | Mercer, Pennsylvania, US | |
1423792 | 1423792 | 2022-06-08 | US | Pennsylvania | Mercer | 42085 | 24196 | 503 | 0 | 41.30248872 | -80.25816981 | 2022-06-09 04:20:54 | Mercer, Pennsylvania, US | |
3897840 | 3897840 | 2022-05-19 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-20 04:20:57 | Buchanan, Missouri, US | |
1186624 | 1186624 | 2022-05-18 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-19 04:20:54 | Buchanan, Missouri, US | |
3584521 | 3584521 | 2022-05-17 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-18 04:20:50 | Buchanan, Missouri, US | |
1505478 | 1505478 | 2022-05-16 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-17 04:20:59 | Buchanan, Missouri, US | |
2085837 | 2085837 | 2022-05-15 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-16 04:20:47 | Buchanan, Missouri, US | |
3356547 | 3356547 | 2022-05-14 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-15 04:20:53 | Buchanan, Missouri, US | |
660192 | 660192 | 2022-05-13 | US | Missouri | Buchanan | 29021 | 24196 | 318 | 0 | 39.65816401 | -94.80138942 | 2022-05-14 04:20:48 | Buchanan, Missouri, US | |
2253772 | 2253772 | 2022-04-19 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-20 04:20:45 | Moore, North Carolina, US | |
1848322 | 1848322 | 2022-04-18 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-19 04:21:00 | Moore, North Carolina, US | |
3419266 | 3419266 | 2022-04-17 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-18 04:21:12 | Moore, North Carolina, US | |
306215 | 306215 | 2022-04-16 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-17 04:20:59 | Moore, North Carolina, US | |
2672160 | 2672160 | 2022-04-15 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-16 04:20:48 | Moore, North Carolina, US | |
1225945 | 1225945 | 2022-04-14 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-15 04:20:57 | Moore, North Carolina, US | |
2445103 | 2445103 | 2022-04-13 | US | North Carolina | Moore | 37125 | 24196 | 318 | 0 | 35.30885257 | -79.48474178 | 2022-04-13 23:21:06 | Moore, North Carolina, US | |
3401626 | 3401626 | 2021-11-30 | Russia | Adygea Republic | 24196 | 664 | 0 | 44.6939006 | 40.1520421 | 2021-12-01 04:22:29 | Adygea Republic, Russia | |||
1274286 | 1274286 | 2021-10-03 | Japan | Ibaraki | 24196 | 216 | 0 | 36.303588 | 140.319591 | 2021-10-04 04:21:31 | Ibaraki, Japan | |||
2568120 | 2568120 | 2021-01-25 | US | Arkansas | Benton | 5007 | 24196 | 328 | 0 | 23868 | 36.33644656 | -94.25680817 | 2021-01-26 05:22:02 | Benton, Arkansas, US |
3440890 | 3440890 | 2020-11-11 | Mexico | Baja California | 24196 | 4026 | 18915 | 1255 | 30.8406 | -115.2838 | 2020-11-12 05:25:55 | Baja California, Mexico | ||
3990744 | 3990744 | 2020-10-20 | North Macedonia | 24196 | 850 | 17673 | 5673 | 41.6086 | 21.7453 | 2020-10-21 04:24:14 | North Macedonia |
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]);