daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 17108 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-20 | US | New Jersey | Salem | 34033 | 17108 | 259 | 0 | 39.58719656 | -75.3469663 | 2022-10-21 04:22:23 | Salem, New Jersey, US | |
2022-07-11 | US | Maryland | Cecil | 24015 | 17108 | 262 | 0 | 39.56647682 | -75.94627411 | 2022-07-12 04:20:51 | Cecil, Maryland, US | |
2022-06-08 | US | Colorado | Eagle | 8037 | 17108 | 35 | 0 | 39.62754308 | -106.6933637 | 2022-06-09 04:20:54 | Eagle, Colorado, US | |
2022-05-05 | US | West Virginia | Mercer | 54055 | 17108 | 265 | 0 | 37.40481169 | -81.11023142 | 2022-05-06 04:21:00 | Mercer, West Virginia, US | |
2022-03-27 | US | New York | Wayne | 36117 | 17108 | 170 | 0 | 43.15494365 | -77.02976528 | 2022-03-28 04:20:33 | Wayne, New York, US | |
2021-09-16 | US | Michigan | Monroe | 26115 | 17108 | 278 | 0 | 41.92734151 | -83.53749864 | 2021-09-17 04:21:46 | Monroe, Michigan, US | |
2021-09-15 | US | Michigan | Monroe | 26115 | 17108 | 278 | 0 | 41.92734151 | -83.53749864 | 2021-09-16 04:22:19 | Monroe, Michigan, US | |
2021-09-01 | US | Pennsylvania | Beaver | 42007 | 17108 | 400 | 0 | 40.6825484 | -80.34921611 | 2021-09-02 04:21:15 | Beaver, Pennsylvania, US | |
2021-08-20 | US | California | Butte | 6007 | 17108 | 211 | 0 | 39.66727762 | -121.6005252 | 2021-08-21 04:21:38 | Butte, California, US | |
2021-08-06 | Russia | Kamchatka Krai | 17108 | 242 | 0 | 57.1914882 | 160.03838190000005 | 2021-08-07 04:21:30 | Kamchatka Krai, Russia | |||
2021-07-06 | US | Missouri | Jasper | 29097 | 17108 | 247 | 0 | 37.20351921 | -94.34050458 | 2021-07-07 04:21:20 | Jasper, Missouri, US | |
2021-06-22 | US | South Carolina | Beaufort | 45013 | 17108 | 210 | 0 | 32.39226291 | -80.72619758 | 2021-06-23 04:21:46 | Beaufort, South Carolina, US | |
2021-06-12 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-13 04:22:44 | Guadeloupe, France | ||
2021-06-11 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-12 04:22:22 | Guadeloupe, France | ||
2021-06-10 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-11 04:23:20 | Guadeloupe, France | ||
2021-06-09 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-10 04:23:17 | Guadeloupe, France | ||
2021-06-08 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-09 04:23:31 | Guadeloupe, France | ||
2021-06-07 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-08 04:22:35 | Guadeloupe, France | ||
2021-06-06 | France | Guadeloupe | 17108 | 260 | 2250 | 14598 | 16.265 | -61.551 | 2021-06-07 04:22:51 | Guadeloupe, France | ||
2021-05-01 | India | Meghalaya | 17108 | 174 | 15275 | 1659 | 25.536934 | 91.278882 | 2021-05-02 04:20:48 | Meghalaya, India | ||
2021-04-13 | US | California | Madera | 6039 | 17108 | 231 | 0 | 37.21513971 | -119.76655890000002 | 2021-04-14 04:20:41 | Madera, California, US | |
2021-02-28 | US | Florida | Santa Rosa | 12113 | 17108 | 262 | 0 | 16846 | 30.693414500000006 | -87.02458128 | 2021-03-01 05:23:01 | Santa Rosa, Florida, US |
2021-02-19 | US | Tennessee | Montgomery | 47125 | 17108 | 203 | 0 | 16860 | 36.49609412 | -87.38550661 | 2021-02-20 05:22:51 | Montgomery, Tennessee, US |
2021-01-02 | US | Virginia | Virginia Beach | 51810 | 17108 | 152 | 0 | 16956 | 36.73285734 | -76.04566934 | 2021-01-03 05:22:52 | Virginia Beach, Virginia, US |
2020-12-19 | US | Pennsylvania | Lehigh | 42077 | 17108 | 443 | 0 | 16665 | 40.6154815 | -75.59435245 | 2020-12-20 05:27:32 | Lehigh, Pennsylvania, US |
2020-12-09 | Russia | Tver Oblast | 17108 | 404 | 11732 | 4972 | 57.1134475 | 35.174442799999994 | 2020-12-10 05:26:19 | Tver Oblast, Russia | ||
2020-11-11 | Russia | Penza Oblast | 17108 | 206 | 12358 | 4544 | 53.1655415 | 44.78791810000001 | 2020-11-12 05:25:55 | Penza Oblast, Russia | ||
2020-06-20 | Brazil | Santa Catarina | 17108 | 237 | 14078 | 2007 | -27.2423 | -50.2189 | 2020-06-21 04:33:19 | Santa Catarina, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;