daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where confirmed = 12358 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-12-28 | US | Puerto Rico | Juncos | 72077 | 12358 | 0 | 0 | 18.223793 | -65.909109 | 2022-12-29 04:21:01 | Juncos, Puerto Rico, US | |
2022-10-27 | US | Texas | Wilson | 48493 | 12358 | 165 | 0 | 29.1732598 | -98.08693082 | 2022-10-28 04:22:31 | Wilson, Texas, US | |
2022-10-26 | US | Texas | Wilson | 48493 | 12358 | 165 | 0 | 29.1732598 | -98.08693082 | 2022-10-27 04:22:01 | Wilson, Texas, US | |
2022-08-23 | US | Wisconsin | Oconto | 55083 | 12358 | 125 | 0 | 45.02715345 | -88.26807503 | 2022-08-24 04:20:46 | Oconto, Wisconsin, US | |
2022-06-30 | US | Illinois | Marion | 17121 | 12358 | 211 | 0 | 38.64963204 | -88.91899208 | 2022-07-01 04:21:10 | Marion, Illinois, US | |
2022-05-19 | US | Tennessee | Campbell | 47013 | 12358 | 169 | 0 | 36.40355516 | -84.1510856 | 2022-05-20 04:20:57 | Campbell, Tennessee, US | |
2022-05-05 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-06 04:21:00 | Pettis, Missouri, US | |
2022-05-04 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-05 04:20:55 | Pettis, Missouri, US | |
2022-05-03 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-04 04:20:59 | Pettis, Missouri, US | |
2022-05-02 | US | Texas | Nacogdoches | 48347 | 12358 | 258 | 0 | 31.62017125 | -94.61803994 | 2022-05-03 04:21:00 | Nacogdoches, Texas, US | |
2022-05-02 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-03 04:21:00 | Pettis, Missouri, US | |
2022-05-01 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-02 04:21:10 | Pettis, Missouri, US | |
2022-04-30 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-05-01 04:20:57 | Pettis, Missouri, US | |
2022-04-29 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-04-30 04:21:05 | Pettis, Missouri, US | |
2022-04-28 | US | Missouri | Pettis | 29159 | 12358 | 166 | 0 | 38.72798918 | -93.28471706 | 2022-04-29 04:20:59 | Pettis, Missouri, US | |
2022-02-01 | US | New Mexico | Otero | 35035 | 12358 | 158 | 0 | 32.61348406 | -105.7417604 | 2022-02-02 04:21:09 | Otero, New Mexico, US | |
2022-01-13 | US | Nebraska | Hall | 31079 | 12358 | 117 | 0 | 40.87257079 | -98.50218293 | 2022-01-14 04:21:54 | Hall, Nebraska, US | |
2022-01-11 | US | Tennessee | Dickson | 47043 | 12358 | 206 | 0 | 36.14669837 | -87.35891709 | 2022-01-12 04:21:44 | Dickson, Tennessee, US | |
2021-11-30 | US | Wisconsin | Chippewa | 55017 | 12358 | 128 | 0 | 45.06939744 | -91.28068855 | 2021-12-01 04:22:29 | Chippewa, Wisconsin, US | |
2021-11-22 | US | New York | St. Lawrence | 36089 | 12358 | 142 | 0 | 44.4976179 | -75.06550039 | 2021-11-23 04:22:39 | St. Lawrence, New York, US | |
2021-11-04 | US | Arkansas | Jefferson | 5069 | 12358 | 228 | 0 | 34.26767081 | -91.92619839 | 2021-11-05 04:21:54 | Jefferson, Arkansas, US | |
2021-10-14 | US | New York | Putnam | 36079 | 12358 | 96 | 0 | 41.42630093 | -73.74965532 | 2021-10-15 04:21:26 | Putnam, New York, US | |
2021-10-11 | US | Idaho | Bannock | 16005 | 12358 | 158 | 0 | 42.67002716 | -112.2233311 | 2021-10-12 04:21:09 | Bannock, Idaho, US | |
2021-10-10 | US | Idaho | Bannock | 16005 | 12358 | 158 | 0 | 42.67002716 | -112.2233311 | 2021-10-11 04:21:31 | Bannock, Idaho, US | |
2021-08-14 | US | Pennsylvania | Lycoming | 42081 | 12358 | 300 | 0 | 41.34310539 | -77.06629984 | 2021-08-15 04:21:41 | Lycoming, Pennsylvania, US | |
2021-08-05 | US | Georgia | Carroll | 13045 | 12358 | 250 | 0 | 33.58138199 | -85.07976677 | 2021-08-06 04:21:18 | Carroll, Georgia, US | |
2021-06-14 | US | New Mexico | McKinley | 35031 | 12358 | 478 | 0 | 35.58007720000001 | -108.262245 | 2021-06-15 04:22:22 | McKinley, New Mexico, US | |
2021-05-23 | US | Louisiana | Rapides | 22079 | 12358 | 317 | 0 | 31.19778499 | -92.52997303 | 2021-05-24 04:20:53 | Rapides, Louisiana, US | |
2021-05-22 | US | Louisiana | Rapides | 22079 | 12358 | 317 | 0 | 31.19778499 | -92.52997303 | 2021-05-23 04:20:51 | Rapides, Louisiana, US | |
2021-05-21 | US | Louisiana | Rapides | 22079 | 12358 | 317 | 0 | 31.19778499 | -92.52997303 | 2021-05-22 04:20:45 | Rapides, Louisiana, US | |
2021-04-20 | US | Indiana | Madison | 18095 | 12358 | 337 | 0 | 40.16143691 | -85.71964711 | 2021-04-21 04:21:14 | Madison, Indiana, US | |
2021-04-19 | US | Florida | Charlotte | 12015 | 12358 | 404 | 0 | 26.90131002 | -81.92949121 | 2021-04-20 04:20:41 | Charlotte, Florida, US | |
2021-04-14 | US | Georgia | Lowndes | 13185 | 12358 | 202 | 0 | 30.83568832 | -83.27056716 | 2021-04-15 04:20:54 | Lowndes, Georgia, US | |
2021-02-28 | Colombia | Casanare | 12358 | 269 | 11697 | 392 | 5.7589 | -71.5724 | 2021-03-01 05:23:01 | Casanare, Colombia | ||
2021-01-03 | Russia | Ingushetia Republic | 12358 | 142 | 10322 | 1894 | 43.11542075 | 45.01713552 | 2021-01-04 05:22:02 | Ingushetia Republic, Russia | ||
2020-12-05 | US | New York | Onondaga | 36067 | 12358 | 235 | 0 | 12123 | 43.00491923 | -76.19971155 | 2020-12-06 05:26:18 | Onondaga, New York, US |
2020-10-03 | US | Texas | Webb | 48479 | 12358 | 315 | 0 | 13685 | 27.7610369 | -99.33237355 | 2020-10-04 04:23:44 | Webb, Texas, US |
2020-08-16 | Mexico | Oaxaca | 12358 | 1119 | 10461 | 778 | 17.0732 | -96.7266 | 2020-08-17 04:27:20 | Oaxaca, Mexico | ||
2020-06-30 | US | Texas | Bexar | 48029 | 12358 | 109 | 0 | 10688 | 29.44928723 | -98.52019748 | 2020-07-01 04:33:52 | Bexar, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;