johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 19009 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1242601 | 1242601 | 2022-11-28 | US | Tennessee | Dickson | 47043 | 19009 | 260 | 0 | 36.14669837 | -87.35891709 | 2022-11-29 04:21:05 | Dickson, Tennessee, US | |
2025757 | 2025757 | 2022-10-17 | US | Illinois | Jackson | 17077 | 19009 | 129 | 0 | 37.78595185 | -89.38232563 | 2022-10-18 04:22:42 | Jackson, Illinois, US | |
1373260 | 1373260 | 2022-09-21 | US | Puerto Rico | Mayaguez | 72097 | 19009 | 0 | 0 | 18.2013 | -67.1452 | 2022-09-22 04:22:56 | Mayaguez, Puerto Rico, US | |
2019490 | 2019490 | 2022-09-20 | US | Puerto Rico | Mayaguez | 72097 | 19009 | 0 | 0 | 18.2013 | -67.1452 | 2022-09-21 04:23:22 | Mayaguez, Puerto Rico, US | |
3573363 | 3573363 | 2022-09-19 | US | Puerto Rico | Mayaguez | 72097 | 19009 | 0 | 0 | 18.2013 | -67.1452 | 2022-09-20 04:22:48 | Mayaguez, Puerto Rico, US | |
422102 | 422102 | 2022-09-18 | US | Puerto Rico | Mayaguez | 72097 | 19009 | 0 | 0 | 18.2013 | -67.1452 | 2022-09-19 04:21:49 | Mayaguez, Puerto Rico, US | |
561088 | 561088 | 2022-06-16 | US | New York | Wayne | 36117 | 19009 | 183 | 0 | 43.15494365 | -77.02976528 | 2022-06-17 04:20:56 | Wayne, New York, US | |
3188212 | 3188212 | 2022-05-30 | US | New Mexico | Valencia | 35061 | 19009 | 280 | 0 | 34.71669834 | -106.8103733 | 2022-05-31 04:20:51 | Valencia, New Mexico, US | |
3200361 | 3200361 | 2022-05-29 | US | New Mexico | Valencia | 35061 | 19009 | 280 | 0 | 34.71669834 | -106.8103733 | 2022-05-30 04:20:50 | Valencia, New Mexico, US | |
2727239 | 2727239 | 2022-05-28 | US | New Mexico | Valencia | 35061 | 19009 | 280 | 0 | 34.71669834 | -106.8103733 | 2022-05-29 04:20:53 | Valencia, New Mexico, US | |
1316420 | 1316420 | 2022-05-27 | US | New Mexico | Valencia | 35061 | 19009 | 280 | 0 | 34.71669834 | -106.8103733 | 2022-05-28 04:21:07 | Valencia, New Mexico, US | |
3436899 | 3436899 | 2022-04-22 | Malaysia | W.P. Putrajaya | 19009 | 42 | 0 | 2.9264 | 101.6964 | 2022-04-23 04:20:50 | W.P. Putrajaya, Malaysia | |||
3048839 | 3048839 | 2022-02-26 | US | Pennsylvania | Clearfield | 42033 | 19009 | 322 | 0 | 41.00110782 | -78.47592663 | 2022-02-27 04:21:04 | Clearfield, Pennsylvania, US | |
1364595 | 1364595 | 2022-02-08 | US | New York | Jefferson | 36045 | 19009 | 126 | 0 | 44.04200959 | -75.94653457 | 2022-02-09 04:21:04 | Jefferson, New York, US | |
2327868 | 2327868 | 2022-02-04 | US | Arkansas | Lonoke | 5085 | 19009 | 205 | 0 | 34.75392199 | -91.88742357 | 2022-02-05 04:21:05 | Lonoke, Arkansas, US | |
2055341 | 2055341 | 2022-01-25 | US | Washington | Skagit | 53057 | 19009 | 160 | 0 | 48.48171488 | -121.766131 | 2022-01-26 04:21:07 | Skagit, Washington, US | |
1231072 | 1231072 | 2022-01-24 | US | Washington | Skagit | 53057 | 19009 | 160 | 0 | 48.48171488 | -121.766131 | 2022-01-25 04:21:05 | Skagit, Washington, US | |
535777 | 535777 | 2021-10-27 | US | Illinois | Rock Island | 17161 | 19009 | 365 | 0 | 41.46613806 | -90.57042164 | 2021-10-28 04:22:08 | Rock Island, Illinois, US | |
470382 | 470382 | 2021-10-07 | US | Tennessee | Maury | 47119 | 19009 | 217 | 0 | 35.618741299999996 | -87.07462444 | 2021-10-08 04:21:25 | Maury, Tennessee, US | |
34179 | 34179 | 2021-08-25 | US | Minnesota | St. Louis | 27137 | 19009 | 324 | 0 | 47.604840700000004 | -92.46879855 | 2021-08-26 04:21:28 | St. Louis, Minnesota, US | |
1709348 | 1709348 | 2021-06-02 | US | Illinois | Sangamon | 17167 | 19009 | 237 | 0 | 39.75836914 | -89.65872023 | 2021-06-03 04:23:32 | Sangamon, Illinois, US | |
3423540 | 3423540 | 2021-03-19 | US | Oregon | Marion | 41047 | 19009 | 295 | 0 | 44.90287942 | -122.5815117 | 2021-03-20 05:25:46 | Marion, Oregon, US | |
1338063 | 1338063 | 2021-02-15 | Chile | Coquimbo | 19009 | 377 | 17797 | 835 | -29.959 | -71.3389 | 2021-02-16 05:24:38 | Coquimbo, Chile | ||
12534 | 12534 | 2021-01-26 | Russia | Chuvashia Republic | 19009 | 819 | 17105 | 1085 | 55.4259922 | 47.0849429 | 2021-01-27 05:23:41 | Chuvashia Republic, Russia | ||
3902640 | 3902640 | 2021-01-09 | US | Pennsylvania | Northampton | 42095 | 19009 | 480 | 0 | 18529 | 40.75182733 | -75.30471829 | 2021-01-10 05:22:12 | Northampton, Pennsylvania, US |
2977540 | 2977540 | 2020-12-09 | US | North Carolina | Guilford | 37081 | 19009 | 272 | 0 | 18737 | 36.07959451 | -79.78824948 | 2020-12-10 05:26:19 | Guilford, North Carolina, US |
3531747 | 3531747 | 2020-08-12 | Spain | Pais Vasco | 19009 | 1553 | 16160 | 1296 | 42.9896 | -2.6189 | 2020-08-13 04:29:15 | Pais Vasco, Spain | ||
1281080 | 1281080 | 2020-06-04 | Spain | Castilla y Leon | 19009 | 1928 | 8716 | 8365 | 41.8357 | -4.3976 | 2020-06-05 02:33:06 | Castilla y Leon, Spain |
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]);