daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where confirmed = 13019 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-13 | US | New Mexico | Rio Arriba | 35039 | 13019 | 158 | 0 | 36.51072137 | -106.6931674 | 2022-12-14 04:21:04 | Rio Arriba, New Mexico, US | |
2022-11-09 | US | New York | Columbia | 36021 | 13019 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-10 04:21:16 | Columbia, New York, US | |
2022-10-01 | US | New York | Tioga | 36107 | 13019 | 88 | 0 | 42.16852837 | -76.30835812 | 2022-10-02 04:21:23 | Tioga, New York, US | |
2022-08-16 | US | Illinois | Clinton | 17027 | 13019 | 115 | 0 | 38.60704876 | -89.42385254 | 2022-08-17 04:20:59 | Clinton, Illinois, US | |
2022-08-03 | US | Wisconsin | Douglas | 55031 | 13019 | 81 | 0 | 46.43222285 | -91.91595768 | 2022-08-04 04:20:58 | Douglas, Wisconsin, US | |
2022-03-22 | US | West Virginia | Fayette | 54019 | 13019 | 191 | 0 | 38.02974928 | -81.08286634 | 2022-03-23 04:20:48 | Fayette, West Virginia, US | |
2022-02-16 | US | Texas | Atascosa | 48013 | 13019 | 223 | 0 | 28.89333001 | -98.52730485 | 2022-02-17 04:20:56 | Atascosa, Texas, US | |
2022-01-21 | US | Alabama | Autauga | 1001 | 13019 | 163 | 0 | 32.53952745 | -86.64408227 | 2022-01-22 04:21:13 | Autauga, Alabama, US | |
2022-01-16 | US | Nebraska | Hall | 31079 | 13019 | 117 | 0 | 40.87257079 | -98.50218293 | 2022-01-17 04:21:08 | Hall, Nebraska, US | |
2022-01-15 | US | Nebraska | Hall | 31079 | 13019 | 117 | 0 | 40.87257079 | -98.50218293 | 2022-01-16 04:21:12 | Hall, Nebraska, US | |
2022-01-14 | US | Nebraska | Hall | 31079 | 13019 | 117 | 0 | 40.87257079 | -98.50218293 | 2022-01-15 04:21:07 | Hall, Nebraska, US | |
2022-01-05 | US | South Carolina | Laurens | 45059 | 13019 | 247 | 0 | 34.48244419 | -82.00490796 | 2022-01-06 04:22:09 | Laurens, South Carolina, US | |
2021-12-19 | US | Michigan | Midland | 26111 | 13019 | 175 | 0 | 43.64330771 | -84.38804374 | 2021-12-20 04:21:43 | Midland, Michigan, US | |
2021-12-18 | US | Michigan | Midland | 26111 | 13019 | 175 | 0 | 43.64330771 | -84.38804374 | 2021-12-19 04:21:11 | Midland, Michigan, US | |
2021-12-17 | US | Michigan | Midland | 26111 | 13019 | 175 | 0 | 43.64330771 | -84.38804374 | 2021-12-18 02:22:20 | Midland, Michigan, US | |
2021-11-02 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-11-03 06:22:09 | Story, Iowa, US | |
2021-11-01 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-11-02 04:22:03 | Story, Iowa, US | |
2021-10-31 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-11-01 04:22:01 | Story, Iowa, US | |
2021-10-30 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-10-31 04:22:08 | Story, Iowa, US | |
2021-10-29 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-10-30 04:22:03 | Story, Iowa, US | |
2021-10-28 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-10-29 04:22:03 | Story, Iowa, US | |
2021-10-27 | US | Iowa | Story | 19169 | 13019 | 53 | 0 | 42.03621213 | -93.46499005 | 2021-10-28 04:22:08 | Story, Iowa, US | |
2021-10-17 | US | North Carolina | Wilson | 37195 | 13019 | 226 | 0 | 35.70625477 | -77.917978 | 2021-10-18 04:21:10 | Wilson, North Carolina, US | |
2021-10-16 | US | North Carolina | Wilson | 37195 | 13019 | 226 | 0 | 35.70625477 | -77.917978 | 2021-10-17 04:21:29 | Wilson, North Carolina, US | |
2021-10-15 | US | North Carolina | Wilson | 37195 | 13019 | 226 | 0 | 35.70625477 | -77.917978 | 2021-10-16 04:21:15 | Wilson, North Carolina, US | |
2021-09-27 | US | Ohio | Muskingum | 39119 | 13019 | 169 | 0 | 39.96575964 | -81.94363275 | 2021-09-28 04:21:28 | Muskingum, Ohio, US | |
2021-08-29 | US | Mississippi | Lee | 28081 | 13019 | 192 | 0 | 34.291877500000005 | -88.68149954 | 2021-08-30 04:21:23 | Lee, Mississippi, US | |
2021-08-28 | US | Mississippi | Lee | 28081 | 13019 | 192 | 0 | 34.291877500000005 | -88.68149954 | 2021-08-29 04:21:14 | Lee, Mississippi, US | |
2021-08-27 | US | Mississippi | Lee | 28081 | 13019 | 192 | 0 | 34.291877500000005 | -88.68149954 | 2021-08-28 04:21:28 | Lee, Mississippi, US | |
2021-08-02 | US | Illinois | LaSalle | 17099 | 13019 | 254 | 0 | 41.34426129999999 | -88.88633881 | 2021-08-03 04:21:39 | LaSalle, Illinois, US | |
2021-07-27 | US | West Virginia | Berkeley | 54003 | 13019 | 137 | 0 | 39.46704621 | -78.02414609 | 2021-07-28 04:21:39 | Berkeley, West Virginia, US | |
2021-07-27 | US | Connecticut | Middlesex | 9007 | 13019 | 374 | 0 | 41.45949668 | -72.53714864 | 2021-07-28 04:21:39 | Middlesex, Connecticut, US | |
2021-04-23 | US | Michigan | Calhoun | 26025 | 13019 | 266 | 0 | 42.24633834 | -85.00493569 | 2021-04-24 04:20:38 | Calhoun, Michigan, US | |
2021-04-02 | US | Pennsylvania | Schuylkill | 42107 | 13019 | 383 | 0 | 40.70497338 | -76.2150785 | 2021-04-03 04:20:44 | Schuylkill, Pennsylvania, US | |
2021-03-30 | Colombia | Casanare | 13019 | 303 | 12451 | 265 | 5.7589 | -71.5724 | 2021-03-31 04:26:25 | Casanare, Colombia | ||
2021-03-21 | US | Arkansas | Craighead | 5031 | 13019 | 171 | 0 | 35.83018283 | -90.63235729 | 2021-03-22 05:25:43 | Craighead, Arkansas, US | |
2021-03-20 | US | Arkansas | Craighead | 5031 | 13019 | 171 | 0 | 35.83018283 | -90.63235729 | 2021-03-21 05:25:44 | Craighead, Arkansas, US | |
2021-01-24 | US | Tennessee | Sullivan | 47163 | 13019 | 220 | 0 | 12741 | 36.51240691 | -82.30412917 | 2021-01-25 05:22:16 | Sullivan, Tennessee, US |
2020-12-14 | Russia | Kalmykia Republic | 13019 | 169 | 10660 | 2190 | 46.2313018 | 45.3275745 | 2020-12-15 05:26:38 | Kalmykia Republic, Russia | ||
2020-12-02 | Estonia | 13019 | 122 | 7608 | 5289 | 58.5953 | 25.0136 | 2020-12-03 05:28:22 | Estonia | |||
2020-11-11 | Russia | Yaroslavl Oblast | 13019 | 68 | 11747 | 1204 | 57.77819760000001 | 39.0021095 | 2020-11-12 05:25:55 | Yaroslavl Oblast, Russia | ||
2020-10-30 | Peru | Tacna | 13019 | 751 | 0 | 12268 | -17.644160999999997 | -70.27756 | 2020-10-31 04:24:44 | Tacna, Peru | ||
2020-10-12 | Mexico | Chihuahua | 13019 | 1483 | 10204 | 1332 | 28.633000000000006 | -106.0691 | 2020-10-13 04:24:02 | Chihuahua, Mexico | ||
2020-08-23 | Russia | Yamalo-Nenets Autonomous Okrug | 13019 | 87 | 12467 | 465 | 67.1471631 | 74.3415488 | 2020-08-24 04:27:56 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2020-08-21 | Russia | Chelyabinsk Oblast | 13019 | 102 | 8682 | 4235 | 54.4223954 | 61.1865846 | 2020-08-22 04:27:49 | Chelyabinsk Oblast, Russia | ||
2020-07-24 | US | Massachusetts | Worcester | 25027 | 13019 | 977 | 0 | 12042 | 42.35026951 | -71.90493363 | 2020-07-25 04:47:39 | Worcester, Massachusetts, US |
2020-07-18 | US | Florida | Pinellas | 12103 | 13019 | 310 | 0 | 12709 | 27.93130349 | -82.72239666 | 2020-07-19 04:34:58 | Pinellas, Florida, US |
2020-05-26 | US | New York | Rockland | 36087 | 13019 | 492 | 0 | 12527 | 41.15027894 | -74.02560498 | 2020-05-27 02:32:31 | Rockland, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;