daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
172 rows where confirmed = 4132 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-27 | US | Virginia | Westmoreland | 51193 | 4132 | 58 | 0 | 38.11021557 | -76.80213247 | 2022-12-28 04:21:04 | Westmoreland, Virginia, US | |
2022-12-19 | US | Puerto Rico | Rincon | 72117 | 4132 | 0 | 0 | 18.335443 | -67.23174 | 2022-12-20 04:21:04 | Rincon, Puerto Rico, US | |
2022-11-29 | US | Texas | Madison | 48313 | 4132 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-30 04:21:07 | Madison, Texas, US | |
2022-11-28 | US | Texas | Madison | 48313 | 4132 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-11-29 04:21:05 | Madison, Texas, US | |
2022-11-20 | US | Texas | Bandera | 48019 | 4132 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-11-21 04:21:05 | Bandera, Texas, US | |
2022-11-19 | US | Texas | Bandera | 48019 | 4132 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-11-20 04:21:08 | Bandera, Texas, US | |
2022-11-18 | US | Texas | Bandera | 48019 | 4132 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-11-19 04:21:14 | Bandera, Texas, US | |
2022-11-02 | China | Shaanxi | 4132 | 3 | 0 | 35.1917 | 108.8701 | 2022-11-03 04:22:05 | Shaanxi, China | |||
2022-10-23 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-24 04:22:29 | Plumas, California, US | |
2022-10-22 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-23 04:22:46 | Plumas, California, US | |
2022-10-21 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-22 04:22:53 | Plumas, California, US | |
2022-10-20 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-21 04:22:23 | Plumas, California, US | |
2022-10-19 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-20 04:22:59 | Plumas, California, US | |
2022-10-18 | US | California | Plumas | 6063 | 4132 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-10-19 04:22:26 | Plumas, California, US | |
2022-08-28 | US | Washington | Jefferson | 53031 | 4132 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-29 04:21:06 | Jefferson, Washington, US | |
2022-08-27 | US | Washington | Jefferson | 53031 | 4132 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-28 04:21:02 | Jefferson, Washington, US | |
2022-08-26 | US | Washington | Jefferson | 53031 | 4132 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-27 04:20:57 | Jefferson, Washington, US | |
2022-08-23 | US | Texas | Falls | 48145 | 4132 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-08-24 04:20:46 | Falls, Texas, US | |
2022-08-17 | US | Texas | Colorado | 48089 | 4132 | 67 | 0 | 29.622098 | -96.5273805 | 2022-08-18 04:21:11 | Colorado, Texas, US | |
2022-08-03 | US | Virginia | King William | 51101 | 4132 | 46 | 0 | 37.70965316 | -77.09384941 | 2022-08-04 04:20:58 | King William, Virginia, US | |
2022-08-01 | US | Arkansas | Howard | 5061 | 4132 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-08-02 04:20:53 | Howard, Arkansas, US | |
2022-07-31 | US | Puerto Rico | Luquillo | 72089 | 4132 | 0 | 0 | 18.342114 | -65.725097 | 2022-08-01 04:21:03 | Luquillo, Puerto Rico, US | |
2022-07-14 | US | Puerto Rico | Penuelas | 72111 | 4132 | 0 | 0 | 18.059645 | -66.721572 | 2022-07-15 04:20:53 | Penuelas, Puerto Rico, US | |
2022-07-10 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-11 04:20:46 | Magoffin, Kentucky, US | |
2022-07-09 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-10 04:20:54 | Magoffin, Kentucky, US | |
2022-07-08 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-09 04:20:59 | Magoffin, Kentucky, US | |
2022-07-07 | US | Tennessee | Grundy | 47061 | 4132 | 75 | 0 | 35.38433717 | -85.72142731 | 2022-07-08 04:20:56 | Grundy, Tennessee, US | |
2022-07-07 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-08 04:20:56 | Magoffin, Kentucky, US | |
2022-07-06 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-07 04:20:55 | Magoffin, Kentucky, US | |
2022-07-05 | US | Kentucky | Magoffin | 21153 | 4132 | 53 | 0 | 37.70820545 | -83.0657714 | 2022-07-06 04:20:58 | Magoffin, Kentucky, US | |
2022-07-04 | US | Arkansas | Madison | 5087 | 4132 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-07-05 04:20:45 | Madison, Arkansas, US | |
2022-07-03 | US | Arkansas | Madison | 5087 | 4132 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-07-04 04:20:54 | Madison, Arkansas, US | |
2022-07-02 | US | Arkansas | Madison | 5087 | 4132 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-07-03 04:20:59 | Madison, Arkansas, US | |
2022-06-26 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-27 04:21:00 | Trigg, Kentucky, US | |
2022-06-25 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-26 04:21:02 | Trigg, Kentucky, US | |
2022-06-24 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-25 04:20:57 | Trigg, Kentucky, US | |
2022-06-23 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-24 04:20:58 | Trigg, Kentucky, US | |
2022-06-22 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-23 04:20:55 | Trigg, Kentucky, US | |
2022-06-21 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-22 04:20:54 | Trigg, Kentucky, US | |
2022-06-20 | US | Kentucky | Trigg | 21221 | 4132 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-21 04:20:56 | Trigg, Kentucky, US | |
2022-06-12 | US | Puerto Rico | Lajas | 72079 | 4132 | 0 | 0 | 18.011661 | -67.040585 | 2022-06-13 04:21:14 | Lajas, Puerto Rico, US | |
2022-05-31 | US | Illinois | Moultrie | 17139 | 4132 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-06-01 04:20:55 | Moultrie, Illinois, US | |
2022-05-21 | US | Virginia | Greene | 51079 | 4132 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-05-22 04:20:52 | Greene, Virginia, US | |
2022-05-20 | US | Virginia | Greene | 51079 | 4132 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-05-21 04:20:58 | Greene, Virginia, US | |
2022-05-17 | US | Virginia | Giles | 51071 | 4132 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-05-18 04:20:50 | Giles, Virginia, US | |
2022-05-14 | US | Texas | Bosque | 48035 | 4132 | 70 | 0 | 31.89978581 | -97.63613524 | 2022-05-15 04:20:53 | Bosque, Texas, US | |
2022-05-11 | US | Virginia | Goochland | 51075 | 4132 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-05-12 04:20:54 | Goochland, Virginia, US | |
2022-05-03 | US | Arkansas | Clay | 5021 | 4132 | 93 | 0 | 36.36826212 | -90.4148172 | 2022-05-04 04:20:59 | Clay, Arkansas, US | |
2022-04-27 | US | Texas | Aransas | 48007 | 4132 | 84 | 0 | 28.10556197 | -96.9995047 | 2022-04-28 04:20:47 | Aransas, Texas, US | |
2022-04-27 | US | Pennsylvania | Fulton | 42057 | 4132 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-04-28 04:20:47 | Fulton, Pennsylvania, US | |
2022-04-26 | US | Pennsylvania | Fulton | 42057 | 4132 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-04-27 04:20:52 | Fulton, Pennsylvania, US | |
2022-04-25 | US | Pennsylvania | Fulton | 42057 | 4132 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-04-26 04:20:51 | Fulton, Pennsylvania, US | |
2022-04-24 | US | Pennsylvania | Fulton | 42057 | 4132 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-04-25 04:20:56 | Fulton, Pennsylvania, US | |
2022-03-22 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-23 04:20:48 | Cedar, Iowa, US | |
2022-03-21 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-22 04:20:54 | Cedar, Iowa, US | |
2022-03-20 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-21 04:20:50 | Cedar, Iowa, US | |
2022-03-19 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-20 04:20:45 | Cedar, Iowa, US | |
2022-03-18 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-19 04:20:47 | Cedar, Iowa, US | |
2022-03-17 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-18 04:20:55 | Cedar, Iowa, US | |
2022-03-16 | US | Iowa | Cedar | 19031 | 4132 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-03-17 04:20:56 | Cedar, Iowa, US | |
2022-03-07 | US | Missouri | Cooper | 29053 | 4132 | 74 | 0 | 38.844478 | -92.80896081 | 2022-03-08 04:20:54 | Cooper, Missouri, US | |
2022-03-07 | US | Missouri | Benton | 29015 | 4132 | 91 | 0 | 38.29503305 | -93.28756116 | 2022-03-08 04:20:54 | Benton, Missouri, US | |
2022-02-21 | US | Missouri | Pike | 29163 | 4132 | 57 | 0 | 39.34310674 | -91.16980779 | 2022-02-22 04:21:01 | Pike, Missouri, US | |
2022-02-20 | US | Missouri | Pike | 29163 | 4132 | 57 | 0 | 39.34310674 | -91.16980779 | 2022-02-21 04:21:05 | Pike, Missouri, US | |
2022-02-19 | US | Missouri | Pike | 29163 | 4132 | 57 | 0 | 39.34310674 | -91.16980779 | 2022-02-20 04:21:00 | Pike, Missouri, US | |
2022-02-18 | US | Missouri | Pike | 29163 | 4132 | 57 | 0 | 39.34310674 | -91.16980779 | 2022-02-19 04:21:11 | Pike, Missouri, US | |
2022-02-17 | US | Missouri | Pike | 29163 | 4132 | 57 | 0 | 39.34310674 | -91.16980779 | 2022-02-18 04:21:04 | Pike, Missouri, US | |
2022-02-15 | US | Tennessee | Cannon | 47015 | 4132 | 54 | 0 | 35.80990797 | -86.05738983 | 2022-02-16 04:21:10 | Cannon, Tennessee, US | |
2022-02-15 | US | North Carolina | Warren | 37185 | 4132 | 38 | 0 | 36.39728256 | -78.10652228 | 2022-02-16 04:21:10 | Warren, North Carolina, US | |
2022-02-13 | US | West Virginia | Morgan | 54065 | 4132 | 62 | 0 | 39.55439028 | -78.26311676 | 2022-02-14 04:20:51 | Morgan, West Virginia, US | |
2022-02-10 | US | Kentucky | Morgan | 21175 | 4132 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-02-11 04:21:09 | Morgan, Kentucky, US | |
2022-01-25 | US | Georgia | Meriwether | 13199 | 4132 | 125 | 0 | 33.04163534 | -84.68859732 | 2022-01-26 04:21:07 | Meriwether, Georgia, US | |
2022-01-18 | US | Arkansas | Ashley | 5003 | 4132 | 56 | 0 | 33.19153461 | -91.76984709999999 | 2022-01-19 04:21:23 | Ashley, Arkansas, US | |
2022-01-10 | US | Georgia | Lamar | 13171 | 4132 | 102 | 0 | 33.07841647 | -84.14263877 | 2022-01-11 04:22:01 | Lamar, Georgia, US | |
2022-01-05 | US | Texas | Lampasas | 48281 | 4132 | 71 | 0 | 31.19531316 | -98.24206613 | 2022-01-06 04:22:09 | Lampasas, Texas, US | |
2022-01-05 | US | Texas | Dimmit | 48127 | 4132 | 47 | 0 | 28.42270064 | -99.75645095 | 2022-01-06 04:22:09 | Dimmit, Texas, US | |
2022-01-05 | US | Kentucky | Hart | 21099 | 4132 | 83 | 0 | 37.29943898 | -85.88461055 | 2022-01-06 04:22:09 | Hart, Kentucky, US | |
2021-12-30 | US | Tennessee | Morgan | 47129 | 4132 | 57 | 0 | 36.13248031 | -84.64880098 | 2021-12-31 04:21:50 | Morgan, Tennessee, US | |
2021-12-21 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-22 04:21:54 | Woodward, Oklahoma, US | |
2021-12-20 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-21 03:21:27 | Woodward, Oklahoma, US | |
2021-12-19 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-20 04:21:43 | Woodward, Oklahoma, US | |
2021-12-18 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-19 04:21:11 | Woodward, Oklahoma, US | |
2021-12-17 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-18 02:22:20 | Woodward, Oklahoma, US | |
2021-12-17 | US | Missouri | Randolph | 29175 | 4132 | 82 | 0 | 39.44007257 | -92.49713740000001 | 2021-12-18 02:22:20 | Randolph, Missouri, US | |
2021-12-16 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-17 04:22:14 | Woodward, Oklahoma, US | |
2021-12-15 | US | Oklahoma | Woodward | 40153 | 4132 | 51 | 0 | 36.42316318 | -99.26283045 | 2021-12-16 04:22:11 | Woodward, Oklahoma, US | |
2021-12-04 | US | Puerto Rico | Arecibo | 72013 | 4132 | 0 | 0 | 18.406631 | -66.675077 | 2021-12-05 04:22:25 | Arecibo, Puerto Rico, US | |
2021-11-28 | US | Virginia | Botetourt | 51023 | 4132 | 55 | 0 | 37.55531756 | -79.80982182 | 2021-11-29 04:22:30 | Botetourt, Virginia, US | |
2021-11-27 | US | Virginia | Botetourt | 51023 | 4132 | 55 | 0 | 37.55531756 | -79.80982182 | 2021-11-28 04:22:43 | Botetourt, Virginia, US | |
2021-11-26 | US | Virginia | Botetourt | 51023 | 4132 | 55 | 0 | 37.55531756 | -79.80982182 | 2021-11-27 04:22:45 | Botetourt, Virginia, US | |
2021-11-17 | US | Tennessee | Wayne | 47181 | 4132 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-11-18 04:21:33 | Wayne, Tennessee, US | |
2021-11-15 | US | West Virginia | Jackson | 54035 | 4132 | 88 | 0 | 38.84263974 | -81.68148753 | 2021-11-16 04:21:10 | Jackson, West Virginia, US | |
2021-10-28 | US | Kentucky | Grant | 21081 | 4132 | 32 | 0 | 38.64962758 | -84.62415957 | 2021-10-29 04:22:03 | Grant, Kentucky, US | |
2021-10-09 | US | Tennessee | DeKalb | 47041 | 4132 | 67 | 0 | 35.97616272 | -85.83689361 | 2021-10-10 04:21:38 | DeKalb, Tennessee, US | |
2021-09-29 | US | Alabama | Lawrence | 1079 | 4132 | 108 | 0 | 34.52041498 | -87.31069453 | 2021-09-30 04:21:20 | Lawrence, Alabama, US | |
2021-09-22 | US | Mississippi | Covington | 28031 | 4132 | 92 | 0 | 31.63225413 | -89.55389939 | 2021-09-23 04:21:43 | Covington, Mississippi, US | |
2021-09-18 | US | Ohio | Jackson | 39079 | 4132 | 64 | 0 | 39.01914254 | -82.61818559999998 | 2021-09-19 04:21:34 | Jackson, Ohio, US | |
2021-09-13 | US | Georgia | Gilmer | 13123 | 4132 | 105 | 0 | 34.69316688 | -84.45802506 | 2021-09-14 04:21:41 | Gilmer, Georgia, US | |
2021-09-08 | US | Wisconsin | Clark | 55019 | 4132 | 67 | 0 | 44.73483377 | -90.61207486 | 2021-09-09 04:21:27 | Clark, Wisconsin, US | |
2021-09-06 | US | Indiana | Ripley | 18137 | 4132 | 71 | 0 | 39.10235626 | -85.26212744 | 2021-09-07 04:21:35 | Ripley, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;