daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
271 rows where confirmed = 2697 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-10-26 | US | Virginia | Northampton | 51131 | 2697 | 72 | 0 | 37.34062933 | -75.87751591 | 2022-10-27 04:22:01 | Northampton, Virginia, US | |
2022-09-07 | US | Virginia | Poquoson | 51735 | 2697 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-09-08 04:21:02 | Poquoson, Virginia, US | |
2022-09-06 | US | Virginia | Poquoson | 51735 | 2697 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-09-07 04:20:59 | Poquoson, Virginia, US | |
2022-08-25 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-26 04:21:02 | Ralls, Missouri, US | |
2022-08-24 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-25 04:21:13 | Ralls, Missouri, US | |
2022-08-23 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-24 04:20:46 | Ralls, Missouri, US | |
2022-08-22 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-23 04:20:56 | Ralls, Missouri, US | |
2022-08-21 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-22 04:20:38 | Ralls, Missouri, US | |
2022-08-20 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-21 04:20:44 | Ralls, Missouri, US | |
2022-08-19 | US | Missouri | Ralls | 29173 | 2697 | 30 | 0 | 39.52817427 | -91.51838643 | 2022-08-20 04:21:01 | Ralls, Missouri, US | |
2022-08-17 | US | Virginia | Sussex | 51183 | 2697 | 44 | 0 | 36.92432914 | -77.25791182 | 2022-08-18 04:21:11 | Sussex, Virginia, US | |
2022-08-14 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-15 04:20:59 | Owen, Kentucky, US | |
2022-08-13 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-14 04:20:55 | Owen, Kentucky, US | |
2022-08-12 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-13 04:20:52 | Owen, Kentucky, US | |
2022-08-11 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-12 04:20:54 | Owen, Kentucky, US | |
2022-08-10 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-11 04:20:49 | Owen, Kentucky, US | |
2022-08-09 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-10 04:20:57 | Owen, Kentucky, US | |
2022-08-08 | US | Kentucky | Owen | 21187 | 2697 | 35 | 0 | 38.51679143 | -84.82404619 | 2022-08-09 04:20:34 | Owen, Kentucky, US | |
2022-08-01 | US | Colorado | Bent | 8011 | 2697 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-02 04:20:53 | Bent, Colorado, US | |
2022-07-31 | US | Colorado | Bent | 8011 | 2697 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-01 04:21:03 | Bent, Colorado, US | |
2022-07-30 | US | Colorado | Bent | 8011 | 2697 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-31 04:21:02 | Bent, Colorado, US | |
2022-07-29 | US | Colorado | Bent | 8011 | 2697 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-30 04:20:42 | Bent, Colorado, US | |
2022-07-28 | US | Colorado | Bent | 8011 | 2697 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-29 04:20:45 | Bent, Colorado, US | |
2022-07-19 | US | Virginia | Richmond | 51159 | 2697 | 25 | 0 | 37.937575 | -76.72920628 | 2022-07-20 04:20:59 | Richmond, Virginia, US | |
2022-07-10 | US | Mississippi | Carroll | 28015 | 2697 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-07-11 04:20:46 | Carroll, Mississippi, US | |
2022-07-09 | US | Mississippi | Carroll | 28015 | 2697 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-07-10 04:20:54 | Carroll, Mississippi, US | |
2022-07-08 | US | Mississippi | Carroll | 28015 | 2697 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-07-09 04:20:59 | Carroll, Mississippi, US | |
2022-07-04 | US | Texas | Blanco | 48031 | 2697 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-05 04:20:45 | Blanco, Texas, US | |
2022-07-03 | US | Texas | Blanco | 48031 | 2697 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-04 04:20:54 | Blanco, Texas, US | |
2022-07-02 | US | Texas | Blanco | 48031 | 2697 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-03 04:20:59 | Blanco, Texas, US | |
2022-07-01 | US | Texas | Blanco | 48031 | 2697 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-02 04:21:16 | Blanco, Texas, US | |
2022-06-30 | US | Virginia | Lunenburg | 51111 | 2697 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-07-01 04:21:10 | Lunenburg, Virginia, US | |
2022-06-30 | US | Alabama | Sumter | 1119 | 2697 | 52 | 0 | 32.59117397 | -88.19916205 | 2022-07-01 04:21:10 | Sumter, Alabama, US | |
2022-06-21 | US | Alabama | Lowndes | 1085 | 2697 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-22 04:20:54 | Lowndes, Alabama, US | |
2022-06-03 | US | Colorado | Prowers | 8099 | 2697 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-06-04 04:20:58 | Prowers, Colorado, US | |
2022-05-24 | US | Nebraska | Colfax | 31037 | 2697 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-25 04:20:56 | Colfax, Nebraska, US | |
2022-05-23 | US | Nebraska | Colfax | 31037 | 2697 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-24 04:20:57 | Colfax, Nebraska, US | |
2022-05-23 | US | Minnesota | Stevens | 27149 | 2697 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-05-24 04:20:57 | Stevens, Minnesota, US | |
2022-05-23 | US | Arkansas | Fulton | 5049 | 2697 | 92 | 0 | 36.38177105 | -91.81729127 | 2022-05-24 04:20:57 | Fulton, Arkansas, US | |
2022-05-21 | US | Arkansas | Fulton | 5049 | 2697 | 90 | 0 | 36.38177105 | -91.81729127 | 2022-05-22 04:20:52 | Fulton, Arkansas, US | |
2022-05-20 | US | Arkansas | Fulton | 5049 | 2697 | 90 | 0 | 36.38177105 | -91.81729127 | 2022-05-21 04:20:58 | Fulton, Arkansas, US | |
2022-05-19 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-20 04:20:57 | Ripley, Missouri, US | |
2022-05-18 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-19 04:20:54 | Ripley, Missouri, US | |
2022-05-17 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-18 04:20:50 | Ripley, Missouri, US | |
2022-05-16 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-17 04:20:59 | Ripley, Missouri, US | |
2022-05-15 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-16 04:20:47 | Ripley, Missouri, US | |
2022-05-14 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-15 04:20:53 | Ripley, Missouri, US | |
2022-05-13 | US | Missouri | Ripley | 29181 | 2697 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-05-14 04:20:48 | Ripley, Missouri, US | |
2022-05-12 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-13 04:20:51 | Trinity, Texas, US | |
2022-05-11 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-12 04:20:54 | Trinity, Texas, US | |
2022-05-10 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-11 04:20:48 | Trinity, Texas, US | |
2022-05-09 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-10 04:20:50 | Trinity, Texas, US | |
2022-05-08 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-09 04:20:54 | Trinity, Texas, US | |
2022-05-07 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-08 04:20:49 | Trinity, Texas, US | |
2022-05-06 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-07 04:21:09 | Trinity, Texas, US | |
2022-05-05 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-06 04:21:00 | Trinity, Texas, US | |
2022-05-04 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-05 04:20:55 | Trinity, Texas, US | |
2022-05-03 | US | Texas | Trinity | 48455 | 2697 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-04 04:20:59 | Trinity, Texas, US | |
2022-03-20 | US | Idaho | Teton | 16081 | 2697 | 8 | 0 | 43.75303583 | -111.2056773 | 2022-03-21 04:20:50 | Teton, Idaho, US | |
2022-03-19 | US | Idaho | Teton | 16081 | 2697 | 8 | 0 | 43.75303583 | -111.2056773 | 2022-03-20 04:20:45 | Teton, Idaho, US | |
2022-03-18 | US | Idaho | Teton | 16081 | 2697 | 8 | 0 | 43.75303583 | -111.2056773 | 2022-03-19 04:20:47 | Teton, Idaho, US | |
2022-02-21 | US | Illinois | Marshall | 17123 | 2697 | 29 | 0 | 41.0327901 | -89.34510444 | 2022-02-22 04:21:01 | Marshall, Illinois, US | |
2022-02-20 | US | Illinois | Marshall | 17123 | 2697 | 29 | 0 | 41.0327901 | -89.34510444 | 2022-02-21 04:21:05 | Marshall, Illinois, US | |
2022-02-19 | US | Illinois | Marshall | 17123 | 2697 | 29 | 0 | 41.0327901 | -89.34510444 | 2022-02-20 04:21:00 | Marshall, Illinois, US | |
2022-02-18 | US | Illinois | Marshall | 17123 | 2697 | 29 | 0 | 41.0327901 | -89.34510444 | 2022-02-19 04:21:11 | Marshall, Illinois, US | |
2022-02-16 | US | South Dakota | Butte | 46019 | 2697 | 44 | 0 | 44.90608745 | -103.5079318 | 2022-02-17 04:20:56 | Butte, South Dakota, US | |
2022-02-14 | US | Mississippi | Noxubee | 28103 | 2697 | 47 | 0 | 33.11009499 | -88.56949061 | 2022-02-15 04:21:09 | Noxubee, Mississippi, US | |
2022-02-06 | US | Texas | Eastland | 48133 | 2697 | 98 | 0 | 32.32743996 | -98.83243566 | 2022-02-07 04:21:05 | Eastland, Texas, US | |
2022-02-03 | US | North Carolina | Alleghany | 37005 | 2697 | 11 | 0 | 36.49360862 | -81.12857041 | 2022-02-04 04:21:10 | Alleghany, North Carolina, US | |
2022-01-27 | US | Idaho | Idaho | 16049 | 2697 | 43 | 0 | 45.84721541 | -115.4634436 | 2022-01-28 04:21:09 | Idaho, Idaho, US | |
2022-01-12 | US | New York | Yates | 36123 | 2697 | 36 | 0 | 42.63505484 | -77.10369919 | 2022-01-13 08:00:09 | Yates, New York, US | |
2022-01-12 | US | Georgia | Oglethorpe | 13221 | 2697 | 44 | 0 | 33.878629600000004 | -83.08278123 | 2022-01-13 08:00:09 | Oglethorpe, Georgia, US | |
2022-01-11 | US | Georgia | Bleckley | 13023 | 2697 | 86 | 0 | 32.43829035 | -83.33035166 | 2022-01-12 04:21:44 | Bleckley, Georgia, US | |
2022-01-03 | US | West Virginia | Monroe | 54063 | 2697 | 31 | 0 | 37.56274716 | -80.54577965 | 2022-01-04 04:22:17 | Monroe, West Virginia, US | |
2022-01-02 | US | West Virginia | Braxton | 54007 | 2697 | 31 | 0 | 38.70036159 | -80.72011184 | 2022-01-03 02:22:25 | Braxton, West Virginia, US | |
2022-01-02 | US | Texas | Bandera | 48019 | 2697 | 64 | 0 | 29.74619598 | -99.24598147 | 2022-01-03 02:22:25 | Bandera, Texas, US | |
2022-01-02 | US | Indiana | Parke | 18121 | 2697 | 34 | 0 | 39.77202286 | -87.20375833 | 2022-01-03 02:22:25 | Parke, Indiana, US | |
2022-01-01 | US | West Virginia | Braxton | 54007 | 2697 | 31 | 0 | 38.70036159 | -80.72011184 | 2022-01-02 04:20:52 | Braxton, West Virginia, US | |
2022-01-01 | US | Texas | Tyler | 48457 | 2697 | 73 | 0 | 30.77031716 | -94.37690895 | 2022-01-02 04:20:52 | Tyler, Texas, US | |
2022-01-01 | US | Indiana | Parke | 18121 | 2697 | 34 | 0 | 39.77202286 | -87.20375833 | 2022-01-02 04:20:52 | Parke, Indiana, US | |
2021-12-31 | US | West Virginia | Braxton | 54007 | 2697 | 31 | 0 | 38.70036159 | -80.72011184 | 2022-01-01 04:22:14 | Braxton, West Virginia, US | |
2021-12-31 | US | Indiana | Parke | 18121 | 2697 | 34 | 0 | 39.77202286 | -87.20375833 | 2022-01-01 04:22:14 | Parke, Indiana, US | |
2021-12-30 | US | West Virginia | Braxton | 54007 | 2697 | 31 | 0 | 38.70036159 | -80.72011184 | 2021-12-31 04:21:50 | Braxton, West Virginia, US | |
2021-12-30 | US | Indiana | Parke | 18121 | 2697 | 34 | 0 | 39.77202286 | -87.20375833 | 2021-12-31 04:21:50 | Parke, Indiana, US | |
2021-12-22 | US | Oklahoma | Unassigned | 90040 | 2697 | 1447 | 0 | 36.83532655 | 0.0 | 2021-12-23 04:21:21 | Unassigned, Oklahoma, US | |
2021-12-21 | US | Wisconsin | Richland | 55103 | 2697 | 35 | 0 | 43.3762778 | -90.43012729 | 2021-12-22 04:21:54 | Richland, Wisconsin, US | |
2021-12-21 | US | Texas | Colorado | 48089 | 2697 | 55 | 0 | 29.622097999999998 | -96.5273805 | 2021-12-22 04:21:54 | Colorado, Texas, US | |
2021-12-21 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-22 04:21:54 | Hamilton, Iowa, US | |
2021-12-21 | US | Georgia | Rabun | 13241 | 2697 | 76 | 0 | 34.88389445 | -83.40304637 | 2021-12-22 04:21:54 | Rabun, Georgia, US | |
2021-12-20 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-21 03:21:27 | Hamilton, Iowa, US | |
2021-12-19 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-20 04:21:43 | Hamilton, Iowa, US | |
2021-12-18 | US | Texas | Andrews | 48003 | 2697 | 65 | 0 | 32.30468633 | -102.63765479999999 | 2021-12-19 04:21:11 | Andrews, Texas, US | |
2021-12-18 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-19 04:21:11 | Hamilton, Iowa, US | |
2021-12-17 | US | Texas | Zavala | 48507 | 2697 | 56 | 0 | 28.86617238 | -99.76050829 | 2021-12-18 02:22:20 | Zavala, Texas, US | |
2021-12-17 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-18 02:22:20 | Hamilton, Iowa, US | |
2021-12-16 | US | Texas | Zavala | 48507 | 2697 | 56 | 0 | 28.86617238 | -99.76050829 | 2021-12-17 04:22:14 | Zavala, Texas, US | |
2021-12-16 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-17 04:22:14 | Hamilton, Iowa, US | |
2021-12-15 | US | Iowa | Hamilton | 19079 | 2697 | 59 | 0 | 42.38382428 | -93.70197703 | 2021-12-16 04:22:11 | Hamilton, Iowa, US | |
2021-12-14 | US | Minnesota | Kanabec | 27065 | 2697 | 40 | 0 | 45.9459309 | -93.29275192 | 2021-12-15 03:22:16 | Kanabec, Minnesota, US | |
2021-12-07 | US | Kansas | Bourbon | 20011 | 2697 | 44 | 0 | 37.85508555 | -94.84865997 | 2021-12-08 04:22:46 | Bourbon, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;