daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
300 rows where confirmed = 2394 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | South Dakota | Fall River | 46047 | 2394 | 44 | 0 | 43.23929297 | -103.5275691 | 2022-12-30 04:21:04 | Fall River, South Dakota, US | |
2022-12-28 | US | South Dakota | Fall River | 46047 | 2394 | 44 | 0 | 43.23929297 | -103.5275691 | 2022-12-29 04:21:01 | Fall River, South Dakota, US | |
2022-12-27 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-28 04:21:04 | Fremont, Idaho, US | |
2022-12-26 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-27 04:21:07 | Fremont, Idaho, US | |
2022-12-25 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-26 04:21:06 | Fremont, Idaho, US | |
2022-12-24 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-25 04:21:04 | Fremont, Idaho, US | |
2022-12-23 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-24 04:21:02 | Fremont, Idaho, US | |
2022-12-22 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-23 04:21:04 | Fremont, Idaho, US | |
2022-12-21 | US | Idaho | Fremont | 16043 | 2394 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-12-22 04:20:56 | Fremont, Idaho, US | |
2022-11-09 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-10 04:21:16 | Marshall, Minnesota, US | |
2022-11-08 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-09 04:21:22 | Marshall, Minnesota, US | |
2022-11-07 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-08 04:21:21 | Marshall, Minnesota, US | |
2022-11-06 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-07 04:21:26 | Marshall, Minnesota, US | |
2022-11-05 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-06 04:21:24 | Marshall, Minnesota, US | |
2022-11-04 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-05 04:21:52 | Marshall, Minnesota, US | |
2022-11-03 | US | Minnesota | Marshall | 27089 | 2394 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-11-04 04:22:11 | Marshall, Minnesota, US | |
2022-10-25 | US | Arkansas | Searcy | 5129 | 2394 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-10-26 04:22:19 | Searcy, Arkansas, US | |
2022-10-02 | US | Virginia | Fairfax City | 51600 | 2394 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-10-03 04:23:11 | Fairfax City, Virginia, US | |
2022-10-01 | US | Virginia | Fairfax City | 51600 | 2394 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-10-02 04:21:23 | Fairfax City, Virginia, US | |
2022-09-30 | US | Virginia | Fairfax City | 51600 | 2394 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-10-01 04:23:01 | Fairfax City, Virginia, US | |
2022-09-29 | US | Virginia | Fairfax City | 51600 | 2394 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-09-30 04:23:09 | Fairfax City, Virginia, US | |
2022-09-28 | US | Virginia | Fairfax City | 51600 | 2394 | 47 | 0 | 38.85157547 | -77.2977964 | 2022-09-29 04:22:34 | Fairfax City, Virginia, US | |
2022-09-27 | China | Yunnan | 2394 | 2 | 0 | 24.974 | 101.487 | 2022-09-28 04:23:01 | Yunnan, China | |||
2022-09-07 | US | West Virginia | Gilmer | 54021 | 2394 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-08 04:21:02 | Gilmer, West Virginia, US | |
2022-08-28 | US | Indiana | Martin | 18101 | 2394 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-08-29 04:21:06 | Martin, Indiana, US | |
2022-08-27 | US | Indiana | Martin | 18101 | 2394 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-08-28 04:21:02 | Martin, Indiana, US | |
2022-08-26 | US | Indiana | Martin | 18101 | 2394 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-08-27 04:20:57 | Martin, Indiana, US | |
2022-08-17 | US | Illinois | Hamilton | 17065 | 2394 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-08-18 04:21:11 | Hamilton, Illinois, US | |
2022-08-06 | US | Tennessee | Moore | 47127 | 2394 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-08-07 04:20:54 | Moore, Tennessee, US | |
2022-07-17 | US | Washington | Lincoln | 53043 | 2394 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-07-18 04:20:59 | Lincoln, Washington, US | |
2022-07-16 | US | Arkansas | Cleveland | 5025 | 2394 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-07-17 04:21:15 | Cleveland, Arkansas, US | |
2022-07-14 | US | Idaho | Clearwater | 16035 | 2394 | 34 | 0 | 46.67459924 | -115.6622393 | 2022-07-15 04:20:53 | Clearwater, Idaho, US | |
2022-07-13 | US | Idaho | Clearwater | 16035 | 2394 | 34 | 0 | 46.67459924 | -115.6622393 | 2022-07-14 04:20:57 | Clearwater, Idaho, US | |
2022-07-11 | China | Sichuan | 2394 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-12 04:20:51 | Sichuan, China | |||
2022-07-07 | US | West Virginia | Webster | 54101 | 2394 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-07-08 04:20:56 | Webster, West Virginia, US | |
2022-06-28 | US | Texas | Parmer | 48369 | 2394 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-06-29 04:20:59 | Parmer, Texas, US | |
2022-06-05 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-06 04:20:57 | Owen, Kentucky, US | |
2022-06-04 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-05 04:20:55 | Owen, Kentucky, US | |
2022-06-03 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-04 04:20:58 | Owen, Kentucky, US | |
2022-06-02 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-03 04:20:58 | Owen, Kentucky, US | |
2022-06-01 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-02 05:20:39 | Owen, Kentucky, US | |
2022-05-31 | US | Kentucky | Owen | 21187 | 2394 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-06-01 04:20:55 | Owen, Kentucky, US | |
2022-05-31 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-06-01 04:20:55 | Towns, Georgia, US | |
2022-05-30 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-31 04:20:51 | Towns, Georgia, US | |
2022-05-29 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-30 04:20:50 | Towns, Georgia, US | |
2022-05-28 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-29 04:20:53 | Towns, Georgia, US | |
2022-05-27 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-28 04:21:07 | Towns, Georgia, US | |
2022-05-26 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-27 04:20:56 | Towns, Georgia, US | |
2022-05-25 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-26 04:20:50 | Towns, Georgia, US | |
2022-05-22 | US | Georgia | Towns | 13281 | 2394 | 116 | 0 | 34.91369188 | -83.7410746 | 2022-05-26 04:20:50 | Towns, Georgia, US | |
2022-05-17 | US | Texas | Runnels | 48399 | 2394 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-05-18 04:20:50 | Runnels, Texas, US | |
2022-05-17 | US | Kansas | Thomas | 20193 | 2394 | 28 | 0 | 39.35107575 | -101.0553705 | 2022-05-18 04:20:50 | Thomas, Kansas, US | |
2022-05-17 | US | Idaho | Washington | 16087 | 2394 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-18 04:20:50 | Washington, Idaho, US | |
2022-05-16 | US | Texas | Runnels | 48399 | 2394 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-05-17 04:20:59 | Runnels, Texas, US | |
2022-05-16 | US | Kansas | Thomas | 20193 | 2394 | 28 | 0 | 39.35107575 | -101.0553705 | 2022-05-17 04:20:59 | Thomas, Kansas, US | |
2022-05-16 | US | Idaho | Washington | 16087 | 2394 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-17 04:20:59 | Washington, Idaho, US | |
2022-05-15 | US | Kansas | Thomas | 20193 | 2394 | 28 | 0 | 39.35107575 | -101.0553705 | 2022-05-16 04:20:47 | Thomas, Kansas, US | |
2022-05-15 | US | Idaho | Washington | 16087 | 2394 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-16 04:20:47 | Washington, Idaho, US | |
2022-05-14 | US | Kansas | Thomas | 20193 | 2394 | 28 | 0 | 39.35107575 | -101.0553705 | 2022-05-15 04:20:53 | Thomas, Kansas, US | |
2022-05-14 | US | Idaho | Washington | 16087 | 2394 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-15 04:20:53 | Washington, Idaho, US | |
2022-05-13 | US | Kansas | Thomas | 20193 | 2394 | 28 | 0 | 39.35107575 | -101.0553705 | 2022-05-14 04:20:48 | Thomas, Kansas, US | |
2022-05-13 | US | Idaho | Washington | 16087 | 2394 | 57 | 0 | 44.45275475 | -116.7847688 | 2022-05-14 04:20:48 | Washington, Idaho, US | |
2022-05-04 | US | Texas | La Salle | 48283 | 2394 | 48 | 0 | 28.34453111 | -99.09908775 | 2022-05-05 04:20:55 | La Salle, Texas, US | |
2022-04-10 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-11 04:21:02 | Benewah, Idaho, US | |
2022-04-09 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-10 04:20:52 | Benewah, Idaho, US | |
2022-04-08 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-09 04:20:42 | Benewah, Idaho, US | |
2022-04-07 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-08 04:20:48 | Benewah, Idaho, US | |
2022-04-06 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-07 04:20:53 | Benewah, Idaho, US | |
2022-04-05 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-06 04:20:49 | Benewah, Idaho, US | |
2022-04-04 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-05 04:20:48 | Benewah, Idaho, US | |
2022-04-03 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-04 04:20:51 | Benewah, Idaho, US | |
2022-04-02 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-03 04:20:48 | Benewah, Idaho, US | |
2022-04-01 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-02 04:20:47 | Benewah, Idaho, US | |
2022-03-31 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-04-01 04:20:28 | Benewah, Idaho, US | |
2022-03-30 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-03-31 04:20:56 | Benewah, Idaho, US | |
2022-03-27 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-03-28 04:20:33 | Benewah, Idaho, US | |
2022-03-26 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-03-27 04:20:47 | Benewah, Idaho, US | |
2022-03-25 | US | Idaho | Benewah | 16009 | 2394 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-03-26 04:20:23 | Benewah, Idaho, US | |
2022-03-13 | US | Illinois | Brown | 17009 | 2394 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-03-14 04:20:46 | Brown, Illinois, US | |
2022-03-12 | US | Illinois | Brown | 17009 | 2394 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-03-13 04:20:49 | Brown, Illinois, US | |
2022-03-11 | US | Illinois | Brown | 17009 | 2394 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-03-12 04:20:50 | Brown, Illinois, US | |
2022-03-06 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-07 04:20:47 | Ritchie, West Virginia, US | |
2022-03-05 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-06 04:20:49 | Ritchie, West Virginia, US | |
2022-03-04 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-05 04:21:10 | Ritchie, West Virginia, US | |
2022-03-03 | US | New Mexico | Colfax | 35007 | 2394 | 64 | 0 | 36.60569702 | -104.64726740000002 | 2022-03-04 04:21:09 | Colfax, New Mexico, US | |
2022-03-02 | US | Missouri | Grundy | 29079 | 2394 | 65 | 0 | 40.11406587 | -93.56509276 | 2022-03-03 04:21:01 | Grundy, Missouri, US | |
2022-03-01 | US | Kansas | Coffey | 20031 | 2394 | 39 | 0 | 38.2365018 | -95.73379515 | 2022-03-02 04:21:07 | Coffey, Kansas, US | |
2022-02-28 | US | Kansas | Coffey | 20031 | 2394 | 39 | 0 | 38.2365018 | -95.73379515 | 2022-03-01 04:21:09 | Coffey, Kansas, US | |
2022-02-22 | US | Virginia | Sussex | 51183 | 2394 | 37 | 0 | 36.92432914 | -77.25791182 | 2022-02-23 04:21:09 | Sussex, Virginia, US | |
2022-02-17 | US | South Dakota | Roberts | 46109 | 2394 | 49 | 0 | 45.62975048 | -96.94672673 | 2022-02-18 04:21:04 | Roberts, South Dakota, US | |
2022-02-15 | US | Missouri | Ralls | 29173 | 2394 | 23 | 0 | 39.52817427 | -91.51838643 | 2022-02-16 04:21:10 | Ralls, Missouri, US | |
2022-02-10 | US | Kentucky | Edmonson | 21061 | 2394 | 37 | 0 | 37.21218923 | -86.23955613 | 2022-02-11 04:21:09 | Edmonson, Kentucky, US | |
2022-02-01 | US | South Dakota | Dewey | 46041 | 2394 | 38 | 0 | 45.15639647 | -100.8709139 | 2022-02-02 04:21:09 | Dewey, South Dakota, US | |
2022-01-31 | US | Indiana | Benton | 18007 | 2394 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-02-01 04:21:11 | Benton, Indiana, US | |
2022-01-30 | US | Virginia | Richmond | 51159 | 2394 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-31 04:21:09 | Richmond, Virginia, US | |
2022-01-30 | US | Georgia | Turner | 13287 | 2394 | 50 | 0 | 31.71612656 | -83.62069378 | 2022-01-31 04:21:09 | Turner, Georgia, US | |
2022-01-29 | US | Virginia | Richmond | 51159 | 2394 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-30 04:21:26 | Richmond, Virginia, US | |
2022-01-29 | US | Georgia | Turner | 13287 | 2394 | 50 | 0 | 31.71612656 | -83.62069378 | 2022-01-30 04:21:26 | Turner, Georgia, US | |
2022-01-28 | US | Virginia | Richmond | 51159 | 2394 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-29 04:21:10 | Richmond, Virginia, US | |
2022-01-28 | US | Georgia | Turner | 13287 | 2394 | 50 | 0 | 31.71612656 | -83.62069378 | 2022-01-29 04:21:10 | Turner, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;