daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
310 rows where confirmed = 2341 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-11-26 | China | Liaoning | 2341 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-27 04:21:05 | Liaoning, China | |||
2022-11-22 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-23 04:21:06 | Fall River, South Dakota, US | |
2022-11-21 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-22 04:20:47 | Fall River, South Dakota, US | |
2022-11-21 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-22 04:20:47 | Oregon, Missouri, US | |
2022-11-20 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-21 04:21:05 | Fall River, South Dakota, US | |
2022-11-20 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-21 04:21:05 | Oregon, Missouri, US | |
2022-11-19 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-20 04:21:08 | Fall River, South Dakota, US | |
2022-11-19 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-20 04:21:08 | Oregon, Missouri, US | |
2022-11-18 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-19 04:21:14 | Fall River, South Dakota, US | |
2022-11-18 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-19 04:21:14 | Oregon, Missouri, US | |
2022-11-17 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-18 04:21:15 | Fall River, South Dakota, US | |
2022-11-17 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-18 04:21:15 | Oregon, Missouri, US | |
2022-11-16 | US | South Dakota | Fall River | 46047 | 2341 | 42 | 0 | 43.23929297 | -103.5275691 | 2022-11-17 04:21:11 | Fall River, South Dakota, US | |
2022-11-16 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-17 04:21:11 | Oregon, Missouri, US | |
2022-11-15 | US | Missouri | Oregon | 29149 | 2341 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-16 04:21:09 | Oregon, Missouri, US | |
2022-10-25 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-26 04:22:19 | Fremont, Idaho, US | |
2022-10-24 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-25 04:21:53 | Fremont, Idaho, US | |
2022-10-23 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-24 04:22:29 | Fremont, Idaho, US | |
2022-10-22 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-23 04:22:46 | Fremont, Idaho, US | |
2022-10-21 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-22 04:22:53 | Fremont, Idaho, US | |
2022-10-20 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-21 04:22:23 | Fremont, Idaho, US | |
2022-10-19 | US | Illinois | Schuyler | 17169 | 2341 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-20 04:22:59 | Schuyler, Illinois, US | |
2022-10-19 | US | Idaho | Fremont | 16043 | 2341 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-20 04:22:59 | Fremont, Idaho, US | |
2022-10-19 | China | Guangxi | 2341 | 2 | 0 | 23.8298 | 108.7881 | 2022-10-20 04:22:59 | Guangxi, China | |||
2022-10-18 | US | Illinois | Schuyler | 17169 | 2341 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-19 04:22:26 | Schuyler, Illinois, US | |
2022-10-17 | US | Illinois | Schuyler | 17169 | 2341 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-10-18 04:22:42 | Schuyler, Illinois, US | |
2022-10-04 | US | North Dakota | Traill | 38097 | 2341 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-10-05 04:23:06 | Traill, North Dakota, US | |
2022-10-03 | US | North Dakota | Traill | 38097 | 2341 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-10-04 04:22:55 | Traill, North Dakota, US | |
2022-09-28 | US | New Mexico | Sierra | 35051 | 2341 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-09-29 04:22:34 | Sierra, New Mexico, US | |
2022-09-17 | China | Yunnan | 2341 | 2 | 0 | 24.974 | 101.487 | 2022-09-18 04:22:50 | Yunnan, China | |||
2022-09-15 | US | Texas | Gaines | 48165 | 2341 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-16 04:21:19 | Gaines, Texas, US | |
2022-09-14 | US | Texas | Gaines | 48165 | 2341 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-15 04:21:02 | Gaines, Texas, US | |
2022-09-12 | US | West Virginia | Pocahontas | 54075 | 2341 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-09-13 04:20:57 | Pocahontas, West Virginia, US | |
2022-09-08 | US | Colorado | Lincoln | 8073 | 2341 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-09 04:21:11 | Lincoln, Colorado, US | |
2022-09-04 | US | Arkansas | Searcy | 5129 | 2341 | 51 | 0 | 35.9109364 | -92.69936482 | 2022-09-05 04:21:01 | Searcy, Arkansas, US | |
2022-09-03 | US | Arkansas | Searcy | 5129 | 2341 | 51 | 0 | 35.9109364 | -92.69936482 | 2022-09-04 04:21:22 | Searcy, Arkansas, US | |
2022-08-29 | US | West Virginia | Doddridge | 54017 | 2341 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-08-30 04:21:03 | Doddridge, West Virginia, US | |
2022-08-28 | US | Virginia | Fairfax City | 51600 | 2341 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-08-29 04:21:06 | Fairfax City, Virginia, US | |
2022-08-27 | US | Virginia | Fairfax City | 51600 | 2341 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-08-28 04:21:02 | Fairfax City, Virginia, US | |
2022-08-26 | US | Virginia | Fairfax City | 51600 | 2341 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-08-27 04:20:57 | Fairfax City, Virginia, US | |
2022-08-25 | US | Virginia | Fairfax City | 51600 | 2341 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-08-26 04:21:02 | Fairfax City, Virginia, US | |
2022-08-22 | US | West Virginia | Gilmer | 54021 | 2341 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-23 04:20:56 | Gilmer, West Virginia, US | |
2022-08-14 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-15 04:20:59 | Nicholas, Kentucky, US | |
2022-08-13 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-14 04:20:55 | Nicholas, Kentucky, US | |
2022-08-12 | US | Puerto Rico | Las Marias | 72083 | 2341 | 0 | 0 | 18.23679 | -66.98362 | 2022-08-13 04:20:52 | Las Marias, Puerto Rico, US | |
2022-08-12 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-13 04:20:52 | Nicholas, Kentucky, US | |
2022-08-11 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-12 04:20:54 | Nicholas, Kentucky, US | |
2022-08-10 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-11 04:20:49 | Nicholas, Kentucky, US | |
2022-08-09 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-10 04:20:57 | Nicholas, Kentucky, US | |
2022-08-08 | US | Kentucky | Nicholas | 21181 | 2341 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-08-09 04:20:34 | Nicholas, Kentucky, US | |
2022-07-31 | US | Texas | Franklin | 48159 | 2341 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-08-01 04:21:03 | Franklin, Texas, US | |
2022-07-31 | US | Illinois | Hamilton | 17065 | 2341 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-08-01 04:21:03 | Hamilton, Illinois, US | |
2022-07-30 | US | Texas | Franklin | 48159 | 2341 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-07-31 04:21:02 | Franklin, Texas, US | |
2022-07-30 | US | Illinois | Hamilton | 17065 | 2341 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-07-31 04:21:02 | Hamilton, Illinois, US | |
2022-07-29 | US | Texas | Franklin | 48159 | 2341 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-07-30 04:20:42 | Franklin, Texas, US | |
2022-07-29 | US | Illinois | Hamilton | 17065 | 2341 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-07-30 04:20:42 | Hamilton, Illinois, US | |
2022-07-19 | US | Puerto Rico | Ceiba | 72037 | 2341 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-20 04:20:59 | Ceiba, Puerto Rico, US | |
2022-07-18 | US | Puerto Rico | Ceiba | 72037 | 2341 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-19 04:20:58 | Ceiba, Puerto Rico, US | |
2022-07-17 | US | Virginia | Northumberland | 51133 | 2341 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-07-18 04:20:59 | Northumberland, Virginia, US | |
2022-07-16 | US | Virginia | Northumberland | 51133 | 2341 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-07-17 04:21:15 | Northumberland, Virginia, US | |
2022-07-15 | US | Virginia | Northumberland | 51133 | 2341 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-07-16 04:21:05 | Northumberland, Virginia, US | |
2022-06-19 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-20 04:21:01 | Phelps, Nebraska, US | |
2022-06-18 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-19 04:20:51 | Phelps, Nebraska, US | |
2022-06-17 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-18 04:21:10 | Phelps, Nebraska, US | |
2022-06-16 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-17 04:20:56 | Phelps, Nebraska, US | |
2022-06-15 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-16 04:20:55 | Phelps, Nebraska, US | |
2022-06-14 | US | Nebraska | Phelps | 31137 | 2341 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-15 04:20:54 | Phelps, Nebraska, US | |
2022-06-05 | US | Virginia | Franklin City | 51620 | 2341 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-06 04:20:57 | Franklin City, Virginia, US | |
2022-06-04 | US | Virginia | Franklin City | 51620 | 2341 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-05 04:20:55 | Franklin City, Virginia, US | |
2022-06-03 | US | Virginia | Franklin City | 51620 | 2341 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-06-04 04:20:58 | Franklin City, Virginia, US | |
2022-05-24 | US | Virginia | Falls Church | 51610 | 2341 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-05-25 04:20:56 | Falls Church, Virginia, US | |
2022-05-13 | US | Tennessee | Perry | 47135 | 2341 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-14 04:20:48 | Perry, Tennessee, US | |
2022-05-03 | US | Puerto Rico | Patillas | 72109 | 2341 | 0 | 0 | 18.03174 | -66.012242 | 2022-05-04 04:20:59 | Patillas, Puerto Rico, US | |
2022-04-07 | US | Virginia | Poquoson | 51735 | 2341 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-08 04:20:48 | Poquoson, Virginia, US | |
2022-04-05 | US | West Virginia | Clay | 54015 | 2341 | 40 | 0 | 38.46231092 | -81.07652217 | 2022-04-06 04:20:49 | Clay, West Virginia, US | |
2022-04-05 | US | Virginia | Poquoson | 51735 | 2341 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-04-06 04:20:49 | Poquoson, Virginia, US | |
2022-04-04 | US | West Virginia | Clay | 54015 | 2341 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-04-05 04:20:48 | Clay, West Virginia, US | |
2022-03-27 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-28 04:20:33 | Elliott, Kentucky, US | |
2022-03-26 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-27 04:20:47 | Elliott, Kentucky, US | |
2022-03-25 | US | Texas | La Salle | 48283 | 2341 | 48 | 0 | 28.34453111 | -99.09908775 | 2022-03-26 04:20:23 | La Salle, Texas, US | |
2022-03-25 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-26 04:20:23 | Elliott, Kentucky, US | |
2022-03-24 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-25 04:20:46 | Elliott, Kentucky, US | |
2022-03-23 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-24 04:20:43 | Elliott, Kentucky, US | |
2022-03-22 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-23 04:20:48 | Elliott, Kentucky, US | |
2022-03-21 | US | Kentucky | Elliott | 21063 | 2341 | 18 | 0 | 38.11624059 | -83.09771563 | 2022-03-22 04:20:54 | Elliott, Kentucky, US | |
2022-03-14 | US | Georgia | Evans | 13109 | 2341 | 63 | 0 | 32.15328841 | -81.8870105 | 2022-03-15 04:20:47 | Evans, Georgia, US | |
2022-03-11 | China | Zhejiang | 2341 | 1 | 0 | 29.1832 | 120.0934 | 2022-03-12 04:20:50 | Zhejiang, China | |||
2022-03-08 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-09 04:20:59 | Emmet, Iowa, US | |
2022-03-07 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-08 04:20:54 | Emmet, Iowa, US | |
2022-03-06 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-07 04:20:47 | Emmet, Iowa, US | |
2022-03-05 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-06 04:20:49 | Emmet, Iowa, US | |
2022-03-04 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-05 04:21:10 | Emmet, Iowa, US | |
2022-03-03 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-04 04:21:09 | Emmet, Iowa, US | |
2022-03-02 | US | Iowa | Emmet | 19063 | 2341 | 51 | 0 | 43.37782951 | -94.67858943 | 2022-03-03 04:21:01 | Emmet, Iowa, US | |
2022-02-27 | US | Kentucky | Owen | 21187 | 2341 | 32 | 0 | 38.51679143 | -84.82404619 | 2022-02-28 04:21:05 | Owen, Kentucky, US | |
2022-02-26 | US | Kentucky | Owen | 21187 | 2341 | 32 | 0 | 38.51679143 | -84.82404619 | 2022-02-27 04:21:04 | Owen, Kentucky, US | |
2022-02-25 | US | Kentucky | Owen | 21187 | 2341 | 32 | 0 | 38.51679143 | -84.82404619 | 2022-02-26 04:21:12 | Owen, Kentucky, US | |
2022-02-22 | US | West Virginia | Ritchie | 54085 | 2341 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-23 04:21:09 | Ritchie, West Virginia, US | |
2022-02-17 | Canada | Nunavut | 2341 | 5 | 0 | 70.2998 | -83.1076 | 2022-02-18 04:21:04 | Nunavut, Canada | |||
2022-02-12 | US | Colorado | San Miguel | 8113 | 2341 | 7 | 0 | 38.00450883 | -108.4020725 | 2022-02-13 04:21:00 | San Miguel, Colorado, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;