daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
202 rows where confirmed = 3184 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-25 | US | Colorado | Prowers | 8099 | 3184 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-12-26 04:21:06 | Prowers, Colorado, US | |
2022-12-24 | US | Colorado | Prowers | 8099 | 3184 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-12-25 04:21:04 | Prowers, Colorado, US | |
2022-12-23 | US | Colorado | Prowers | 8099 | 3184 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-12-24 04:21:02 | Prowers, Colorado, US | |
2022-09-25 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-26 04:20:52 | Galax, Virginia, US | |
2022-09-24 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-25 04:23:31 | Galax, Virginia, US | |
2022-09-23 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-24 04:21:40 | Galax, Virginia, US | |
2022-08-28 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-29 04:21:06 | Lee, Kentucky, US | |
2022-08-28 | US | Arkansas | Lee | 5077 | 3184 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-08-29 04:21:06 | Lee, Arkansas, US | |
2022-08-27 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-28 04:21:02 | Lee, Kentucky, US | |
2022-08-26 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-27 04:20:57 | Lee, Kentucky, US | |
2022-08-25 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-26 04:21:02 | Lee, Kentucky, US | |
2022-08-24 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-25 04:21:13 | Lee, Kentucky, US | |
2022-08-23 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-24 04:20:46 | Lee, Kentucky, US | |
2022-08-22 | US | Kentucky | Lee | 21129 | 3184 | 56 | 0 | 37.59645942 | -83.71513901 | 2022-08-23 04:20:56 | Lee, Kentucky, US | |
2022-08-18 | US | Texas | Camp | 48063 | 3184 | 76 | 0 | 32.97195142 | -94.97790104 | 2022-08-19 04:20:54 | Camp, Texas, US | |
2022-08-16 | US | Texas | Dawson | 48115 | 3184 | 97 | 0 | 32.74255572 | -101.9477242 | 2022-08-17 04:20:59 | Dawson, Texas, US | |
2022-07-20 | US | Alabama | Coosa | 1037 | 3184 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-21 04:21:10 | Coosa, Alabama, US | |
2022-07-16 | US | Colorado | Rio Grande | 8105 | 3184 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-07-17 04:21:15 | Rio Grande, Colorado, US | |
2022-07-06 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-07 04:20:55 | Aitkin, Minnesota, US | |
2022-07-05 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-06 04:20:58 | Aitkin, Minnesota, US | |
2022-07-05 | China | Henan | 3184 | 22 | 0 | 33.882 | 113.614 | 2022-07-06 04:20:58 | Henan, China | |||
2022-07-04 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-05 04:20:45 | Aitkin, Minnesota, US | |
2022-07-04 | China | Henan | 3184 | 22 | 0 | 33.882 | 113.614 | 2022-07-05 04:20:45 | Henan, China | |||
2022-07-03 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-04 04:20:54 | Aitkin, Minnesota, US | |
2022-07-03 | China | Henan | 3184 | 22 | 0 | 33.882 | 113.614 | 2022-07-04 04:20:54 | Henan, China | |||
2022-07-02 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-03 04:20:59 | Aitkin, Minnesota, US | |
2022-07-01 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-02 04:21:16 | Aitkin, Minnesota, US | |
2022-06-30 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-07-01 04:21:10 | Aitkin, Minnesota, US | |
2022-06-29 | US | Minnesota | Aitkin | 27001 | 3184 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-06-30 04:21:01 | Aitkin, Minnesota, US | |
2022-05-29 | US | Puerto Rico | Luquillo | 72089 | 3184 | 0 | 0 | 18.342114 | -65.725097 | 2022-05-30 04:20:50 | Luquillo, Puerto Rico, US | |
2022-04-03 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-04 04:20:51 | Greene, Mississippi, US | |
2022-04-02 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-03 04:20:48 | Greene, Mississippi, US | |
2022-04-01 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-02 04:20:47 | Greene, Mississippi, US | |
2022-03-31 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-01 04:20:28 | Greene, Mississippi, US | |
2022-03-30 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-31 04:20:56 | Greene, Mississippi, US | |
2022-03-29 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-30 04:20:45 | Greene, Mississippi, US | |
2022-03-28 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-29 04:20:46 | Greene, Mississippi, US | |
2022-03-27 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-28 04:20:33 | Greene, Mississippi, US | |
2022-03-26 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-27 04:20:47 | Greene, Mississippi, US | |
2022-03-25 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-26 04:20:23 | Greene, Mississippi, US | |
2022-03-24 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-25 04:20:46 | Greene, Mississippi, US | |
2022-03-23 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-24 04:20:43 | Greene, Mississippi, US | |
2022-03-22 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-23 04:20:48 | Greene, Mississippi, US | |
2022-03-21 | US | Mississippi | Greene | 28041 | 3184 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-03-22 04:20:54 | Greene, Mississippi, US | |
2022-03-19 | China | Shaanxi | 3184 | 3 | 0 | 35.1917 | 108.8701 | 2022-03-20 04:20:45 | Shaanxi, China | |||
2022-02-28 | US | Georgia | Oglethorpe | 13221 | 3184 | 49 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-01 04:21:09 | Oglethorpe, Georgia, US | |
2022-02-27 | US | Georgia | Oglethorpe | 13221 | 3184 | 49 | 0 | 33.878629600000004 | -83.08278123 | 2022-02-28 04:21:05 | Oglethorpe, Georgia, US | |
2022-02-26 | US | Georgia | Oglethorpe | 13221 | 3184 | 49 | 0 | 33.878629600000004 | -83.08278123 | 2022-02-27 04:21:04 | Oglethorpe, Georgia, US | |
2022-02-25 | US | Georgia | Oglethorpe | 13221 | 3184 | 49 | 0 | 33.878629600000004 | -83.08278123 | 2022-02-26 04:21:12 | Oglethorpe, Georgia, US | |
2022-02-23 | US | Virginia | Rockbridge | 51163 | 3184 | 74 | 0 | 37.81204314 | -79.44605905 | 2022-02-24 04:21:14 | Rockbridge, Virginia, US | |
2022-02-17 | US | Puerto Rico | San German | 72125 | 3184 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-02-18 04:21:04 | San German, Puerto Rico, US | |
2022-02-09 | US | Puerto Rico | Lares | 72081 | 3184 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-02-10 04:21:14 | Lares, Puerto Rico, US | |
2022-02-04 | US | New York | Yates | 36123 | 3184 | 37 | 0 | 42.63505484 | -77.10369919 | 2022-02-05 04:21:05 | Yates, New York, US | |
2022-01-09 | US | Missouri | Benton | 29015 | 3184 | 77 | 0 | 38.29503305 | -93.28756116 | 2022-01-10 04:22:07 | Benton, Missouri, US | |
2022-01-05 | US | Arkansas | Drew | 5043 | 3184 | 57 | 0 | 33.59035001 | -91.71777921 | 2022-01-06 04:22:09 | Drew, Arkansas, US | |
2021-12-28 | US | Nebraska | Unassigned | 90031 | 3184 | 1101 | 0 | 42.8997274 | 0.0 | 2021-12-29 03:21:43 | Unassigned, Nebraska, US | |
2021-12-13 | US | Illinois | Edgar | 17045 | 3184 | 51 | 0 | 39.6809186 | -87.74759563 | 2021-12-14 04:22:38 | Edgar, Illinois, US | |
2021-12-02 | US | Florida | Gilchrist | 12041 | 3184 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-03 04:23:05 | Gilchrist, Florida, US | |
2021-12-01 | US | Florida | Gilchrist | 12041 | 3184 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-02 04:22:37 | Gilchrist, Florida, US | |
2021-11-30 | US | Idaho | Blaine | 16013 | 3184 | 27 | 0 | 43.4085812 | -113.9752658 | 2021-12-01 04:22:29 | Blaine, Idaho, US | |
2021-11-30 | US | Florida | Gilchrist | 12041 | 3184 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-01 04:22:29 | Gilchrist, Florida, US | |
2021-11-30 | US | Alabama | Hale | 1065 | 3184 | 89 | 0 | 32.76039258 | -87.63284988 | 2021-12-01 04:22:29 | Hale, Alabama, US | |
2021-11-29 | US | Virginia | Fredericksburg | 51630 | 3184 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-11-30 04:22:53 | Fredericksburg, Virginia, US | |
2021-11-21 | US | Illinois | Wayne | 17191 | 3184 | 65 | 0 | 38.42955355 | -88.42586459 | 2021-11-22 04:22:20 | Wayne, Illinois, US | |
2021-11-20 | US | Illinois | Wayne | 17191 | 3184 | 65 | 0 | 38.42955355 | -88.42586459 | 2021-11-21 04:22:13 | Wayne, Illinois, US | |
2021-11-19 | US | Illinois | Wayne | 17191 | 3184 | 65 | 0 | 38.42955355 | -88.42586459 | 2021-11-20 04:22:17 | Wayne, Illinois, US | |
2021-11-16 | US | Missouri | Vernon | 29217 | 3184 | 67 | 0 | 37.8457799 | -94.34127305 | 2021-11-17 04:21:48 | Vernon, Missouri, US | |
2021-11-15 | US | Arkansas | Conway | 5029 | 3184 | 46 | 0 | 35.26205537 | -92.70506566 | 2021-11-16 04:21:10 | Conway, Arkansas, US | |
2021-11-10 | US | Texas | Montague | 48337 | 3184 | 94 | 0 | 33.67521893 | -97.72500958 | 2021-11-11 04:21:45 | Montague, Texas, US | |
2021-11-10 | US | North Dakota | Rolette | 38079 | 3184 | 35 | 0 | 48.77245354 | -99.84097493 | 2021-11-11 04:21:45 | Rolette, North Dakota, US | |
2021-10-31 | US | Michigan | Mason | 26105 | 3184 | 47 | 0 | 43.99509218 | -86.24988902 | 2021-11-01 04:22:01 | Mason, Michigan, US | |
2021-10-31 | US | Colorado | Pitkin | 8097 | 3184 | 5 | 0 | 39.21720112 | -106.9310027 | 2021-11-01 04:22:01 | Pitkin, Colorado, US | |
2021-10-30 | US | Michigan | Mason | 26105 | 3184 | 47 | 0 | 43.99509218 | -86.24988902 | 2021-10-31 04:22:08 | Mason, Michigan, US | |
2021-10-29 | US | Michigan | Mason | 26105 | 3184 | 47 | 0 | 43.99509218 | -86.24988902 | 2021-10-30 04:22:03 | Mason, Michigan, US | |
2021-10-28 | US | Tennessee | Polk | 47139 | 3184 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-29 04:22:03 | Polk, Tennessee, US | |
2021-10-21 | US | Oregon | Union | 41061 | 3184 | 49 | 0 | 45.30915495 | -118.0068979 | 2021-10-22 04:21:14 | Union, Oregon, US | |
2021-10-20 | US | Washington | Adams | 53001 | 3184 | 30 | 0 | 46.98299757 | -118.56017340000001 | 2021-10-21 04:21:18 | Adams, Washington, US | |
2021-10-13 | US | Georgia | Putnam | 13237 | 3184 | 80 | 0 | 33.32056115 | -83.37552891 | 2021-10-14 04:21:29 | Putnam, Georgia, US | |
2021-10-05 | US | Virginia | Mecklenburg | 51117 | 3184 | 77 | 0 | 36.67882005 | -78.36131056 | 2021-10-06 04:21:33 | Mecklenburg, Virginia, US | |
2021-09-27 | US | Alabama | Butler | 1013 | 3184 | 90 | 0 | 31.75300095 | -86.68057478 | 2021-09-28 04:21:28 | Butler, Alabama, US | |
2021-09-21 | US | Virginia | Russell | 51167 | 3184 | 46 | 0 | 36.93028320000001 | -82.10095486 | 2021-09-22 04:21:45 | Russell, Virginia, US | |
2021-09-12 | US | Virginia | Gloucester | 51073 | 3184 | 54 | 0 | 37.40809042 | -76.53524337 | 2021-09-13 04:21:15 | Gloucester, Virginia, US | |
2021-09-11 | US | Virginia | Gloucester | 51073 | 3184 | 54 | 0 | 37.40809042 | -76.53524337 | 2021-09-12 04:21:13 | Gloucester, Virginia, US | |
2021-09-11 | US | Ohio | Gallia | 39053 | 3184 | 59 | 0 | 38.82708533 | -82.31647569 | 2021-09-12 04:21:13 | Gallia, Ohio, US | |
2021-09-10 | US | Virginia | Gloucester | 51073 | 3184 | 54 | 0 | 37.40809042 | -76.53524337 | 2021-09-11 04:21:30 | Gloucester, Virginia, US | |
2021-09-10 | US | Missouri | Adair | 29001 | 3184 | 28 | 0 | 40.19058551 | -92.60078167 | 2021-09-11 04:21:30 | Adair, Missouri, US | |
2021-09-07 | US | North Carolina | Dare | 37055 | 3184 | 10 | 0 | 35.66520691 | -75.71767334 | 2021-09-08 04:21:31 | Dare, North Carolina, US | |
2021-09-07 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-08 04:21:31 | Jones, Iowa, US | |
2021-09-06 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-07 04:21:35 | Jones, Iowa, US | |
2021-09-05 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-06 04:21:22 | Jones, Iowa, US | |
2021-09-05 | US | Alabama | Barbour | 1005 | 3184 | 65 | 0 | 31.868263 | -85.3871286 | 2021-09-06 04:21:22 | Barbour, Alabama, US | |
2021-09-04 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-05 04:21:33 | Jones, Iowa, US | |
2021-09-03 | US | Texas | Jones | 48253 | 3184 | 61 | 0 | 32.73997145 | -99.87861576 | 2021-09-04 04:21:28 | Jones, Texas, US | |
2021-09-03 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-04 04:21:28 | Jones, Iowa, US | |
2021-09-02 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-03 04:21:20 | Jones, Iowa, US | |
2021-09-01 | US | Iowa | Jones | 19105 | 3184 | 58 | 0 | 42.12118609 | -91.13139641 | 2021-09-02 04:21:15 | Jones, Iowa, US | |
2021-08-30 | US | Minnesota | Le Sueur | 27079 | 3184 | 30 | 0 | 44.37136597 | -93.72844721 | 2021-08-31 04:21:46 | Le Sueur, Minnesota, US | |
2021-08-26 | US | Missouri | Randolph | 29175 | 3184 | 34 | 0 | 39.44007257 | -92.49713740000001 | 2021-08-27 04:21:37 | Randolph, Missouri, US | |
2021-08-25 | US | Texas | Burleson | 48051 | 3184 | 49 | 0 | 30.49273808 | -96.62158484 | 2021-08-26 04:21:28 | Burleson, Texas, US | |
2021-08-24 | US | Maryland | Dorchester | 24019 | 3184 | 66 | 0 | 38.45413522 | -76.02752426 | 2021-08-25 04:21:41 | Dorchester, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;