johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 19159 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3553231 | 3553231 | 2022-11-27 | US | Maryland | Cecil | 24015 | 19159 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-11-28 04:21:02 | Cecil, Maryland, US | |
2101711 | 2101711 | 2022-11-26 | US | Maryland | Cecil | 24015 | 19159 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-11-27 04:21:05 | Cecil, Maryland, US | |
489202 | 489202 | 2022-11-25 | US | Maryland | Cecil | 24015 | 19159 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-11-26 04:21:11 | Cecil, Maryland, US | |
3525031 | 3525031 | 2022-11-24 | US | Maryland | Cecil | 24015 | 19159 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-11-25 04:21:06 | Cecil, Maryland, US | |
3313814 | 3313814 | 2022-11-23 | US | Maryland | Cecil | 24015 | 19159 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-11-24 04:21:09 | Cecil, Maryland, US | |
898758 | 898758 | 2022-07-24 | US | Oregon | Benton | 41003 | 19159 | 74 | 0 | 44.49167306 | -123.4316987 | 2022-07-25 04:20:51 | Benton, Oregon, US | |
93752 | 93752 | 2022-07-23 | US | Oregon | Benton | 41003 | 19159 | 74 | 0 | 44.49167306 | -123.4316987 | 2022-07-24 04:20:47 | Benton, Oregon, US | |
902774 | 902774 | 2022-07-22 | US | Oregon | Benton | 41003 | 19159 | 74 | 0 | 44.49167306 | -123.4316987 | 2022-07-23 04:20:53 | Benton, Oregon, US | |
3630157 | 3630157 | 2022-03-13 | US | New Mexico | Lea | 35025 | 19159 | 317 | 0 | 32.79215361 | -103.4123733 | 2022-03-14 04:20:46 | Lea, New Mexico, US | |
953376 | 953376 | 2022-03-12 | US | Ohio | Ross | 39141 | 19159 | 298 | 0 | 39.33705391 | -83.06000914 | 2022-03-13 04:20:49 | Ross, Ohio, US | |
953065 | 953065 | 2022-03-12 | US | New Mexico | Lea | 35025 | 19159 | 317 | 0 | 32.79215361 | -103.4123733 | 2022-03-13 04:20:49 | Lea, New Mexico, US | |
358837 | 358837 | 2022-03-11 | US | Ohio | Ross | 39141 | 19159 | 298 | 0 | 39.33705391 | -83.06000914 | 2022-03-12 04:20:50 | Ross, Ohio, US | |
358526 | 358526 | 2022-03-11 | US | New Mexico | Lea | 35025 | 19159 | 317 | 0 | 32.79215361 | -103.4123733 | 2022-03-12 04:20:50 | Lea, New Mexico, US | |
1229176 | 1229176 | 2022-01-24 | US | Maine | Penobscot | 23019 | 19159 | 248 | 0 | 45.40194593 | -68.65020455 | 2022-01-25 04:21:05 | Penobscot, Maine, US | |
1660345 | 1660345 | 2021-12-12 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-13 04:22:02 | Iceland | ||||
1664361 | 1664361 | 2021-12-11 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-12 04:22:12 | Iceland | ||||
3655513 | 3655513 | 2021-12-10 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-11 04:22:45 | Iceland | ||||
162205 | 162205 | 2021-11-19 | Peru | Tumbes | 19159 | 1571 | 0 | -3.857496 | -80.54525500000003 | 2021-11-20 04:22:17 | Tumbes, Peru | |||
3289092 | 3289092 | 2021-11-18 | Peru | Tumbes | 19159 | 1571 | 0 | -3.857496 | -80.54525500000003 | 2021-11-19 04:21:40 | Tumbes, Peru | |||
447548 | 447548 | 2021-11-17 | Peru | Tumbes | 19159 | 1571 | 0 | -3.857496 | -80.54525500000003 | 2021-11-18 04:21:33 | Tumbes, Peru | |||
3640627 | 3640627 | 2021-11-08 | US | Indiana | Clark | 18019 | 19159 | 264 | 0 | 38.48015445 | -85.70510334 | 2021-11-09 04:21:36 | Clark, Indiana, US | |
3105654 | 3105654 | 2021-08-24 | Russia | Ingushetia Republic | 19159 | 269 | 0 | 43.11542075 | 45.01713552 | 2021-08-25 04:21:41 | Ingushetia Republic, Russia | |||
1090280 | 1090280 | 2021-03-03 | Russia | Karachay-Cherkess Republic | 19159 | 63 | 17426 | 1670 | 43.7368326 | 41.7267991 | 2021-03-04 05:24:24 | Karachay-Cherkess Republic, Russia | ||
3899828 | 3899828 | 2021-01-09 | Congo (Kinshasa) | 19159 | 611 | 14743 | 3805 | -4.0383 | 21.7587 | 2021-01-10 05:22:12 | Congo (Kinshasa) | |||
2229413 | 2229413 | 2021-01-02 | US | Missouri | Greene | 29077 | 19159 | 278 | 0 | 18881 | 37.2575872 | -93.34230916 | 2021-01-03 05:22:52 | Greene, Missouri, US |
3169633 | 3169633 | 2020-11-16 | Italy | Umbria | 19159 | 262 | 7658 | 11239 | 43.10675841 | 12.38824698 | 2020-11-17 05:25:54 | Umbria, Italy | ||
3409633 | 3409633 | 2020-11-01 | Russia | Chelyabinsk Oblast | 19159 | 163 | 14874 | 4122 | 54.4223954 | 61.1865846 | 2020-11-02 05:25:04 | Chelyabinsk Oblast, Russia | ||
2172195 | 2172195 | 2020-09-09 | US | Connecticut | Fairfield | 9001 | 19159 | 1417 | 0 | 17742 | 41.26809896 | -73.3881171 | 2020-09-10 04:29:01 | Fairfield, Connecticut, 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]);