daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
143 rows where confirmed = 3938 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-20 | US | Wisconsin | Price | 55099 | 3938 | 37 | 0 | 45.68051754 | -90.3609888 | 2022-12-21 04:21:03 | Price, Wisconsin, US | |
2022-12-18 | US | Wisconsin | Price | 55099 | 3938 | 36 | 0 | 45.68051754 | -90.3609888 | 2022-12-19 04:21:03 | Price, Wisconsin, US | |
2022-12-17 | US | Wisconsin | Price | 55099 | 3938 | 36 | 0 | 45.68051754 | -90.3609888 | 2022-12-18 04:21:03 | Price, Wisconsin, US | |
2022-12-16 | US | Wisconsin | Price | 55099 | 3938 | 36 | 0 | 45.68051754 | -90.3609888 | 2022-12-17 04:21:04 | Price, Wisconsin, US | |
2022-12-15 | US | Wisconsin | Price | 55099 | 3938 | 36 | 0 | 45.68051754 | -90.3609888 | 2022-12-16 04:21:01 | Price, Wisconsin, US | |
2022-11-29 | US | North Dakota | Walsh | 38099 | 3938 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-11-30 04:21:07 | Walsh, North Dakota, US | |
2022-11-02 | US | Arkansas | Marion | 5089 | 3938 | 94 | 0 | 36.26844485 | -92.68451899 | 2022-11-03 04:22:05 | Marion, Arkansas, US | |
2022-10-08 | US | Tennessee | Lewis | 47101 | 3938 | 65 | 0 | 35.52853208 | -87.49022694 | 2022-10-09 04:21:16 | Lewis, Tennessee, US | |
2022-09-08 | US | Wisconsin | Buffalo | 55011 | 3938 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-09-09 04:21:11 | Buffalo, Wisconsin, US | |
2022-08-09 | US | New York | Yates | 36123 | 3938 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-08-10 04:20:57 | Yates, New York, US | |
2022-08-07 | US | Virginia | Southampton | 51175 | 3938 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-08-08 04:21:08 | Southampton, Virginia, US | |
2022-08-06 | US | Virginia | Southampton | 51175 | 3938 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-08-07 04:20:54 | Southampton, Virginia, US | |
2022-08-05 | US | Virginia | Southampton | 51175 | 3938 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-08-06 04:20:56 | Southampton, Virginia, US | |
2022-08-01 | US | Texas | Bandera | 48019 | 3938 | 78 | 0 | 29.74619598 | -99.24598147 | 2022-08-02 04:20:53 | Bandera, Texas, US | |
2022-07-30 | US | New York | Schuyler | 36097 | 3938 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-07-31 04:21:02 | Schuyler, New York, US | |
2022-07-13 | US | Alabama | Lamar | 1075 | 3938 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-14 04:20:57 | Lamar, Alabama, US | |
2022-06-16 | US | Washington | Pacific | 53049 | 3938 | 60 | 0 | 46.55418369 | -123.7285716 | 2022-06-17 04:20:56 | Pacific, Washington, US | |
2022-06-15 | US | Washington | Pacific | 53049 | 3938 | 60 | 0 | 46.55418369 | -123.7285716 | 2022-06-16 04:20:55 | Pacific, Washington, US | |
2022-06-08 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-09 04:20:54 | Atoka, Oklahoma, US | |
2022-06-07 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-08 04:20:55 | Atoka, Oklahoma, US | |
2022-06-07 | US | New Mexico | Socorro | 35053 | 3938 | 90 | 0 | 34.00715494 | -106.9298354 | 2022-06-08 04:20:55 | Socorro, New Mexico, US | |
2022-06-06 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-07 04:21:08 | Atoka, Oklahoma, US | |
2022-06-05 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-06 04:20:57 | Atoka, Oklahoma, US | |
2022-06-05 | US | Illinois | Massac | 17127 | 3938 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-06-06 04:20:57 | Massac, Illinois, US | |
2022-06-04 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-05 04:20:55 | Atoka, Oklahoma, US | |
2022-06-04 | US | Illinois | Massac | 17127 | 3938 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-06-05 04:20:55 | Massac, Illinois, US | |
2022-06-03 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-04 04:20:58 | Atoka, Oklahoma, US | |
2022-06-03 | US | Illinois | Massac | 17127 | 3938 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-06-04 04:20:58 | Massac, Illinois, US | |
2022-06-02 | US | Oklahoma | Atoka | 40005 | 3938 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-06-03 04:20:58 | Atoka, Oklahoma, US | |
2022-05-28 | US | Puerto Rico | Loiza | 72087 | 3938 | 0 | 0 | 18.425688 | -65.89943 | 2022-05-29 04:20:53 | Loiza, Puerto Rico, US | |
2022-05-18 | US | Texas | Llano | 48299 | 3938 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-05-19 04:20:54 | Llano, Texas, US | |
2022-04-26 | US | Minnesota | Redwood | 27127 | 3938 | 53 | 0 | 44.40555844 | -95.25207021 | 2022-04-27 04:20:52 | Redwood, Minnesota, US | |
2022-02-27 | US | Wisconsin | Washburn | 55129 | 3938 | 44 | 0 | 45.89838588 | -91.79050449 | 2022-02-28 04:21:05 | Washburn, Wisconsin, US | |
2022-02-27 | US | Texas | Houston | 48225 | 3938 | 106 | 0 | 31.31925973 | -95.42226208 | 2022-02-28 04:21:05 | Houston, Texas, US | |
2022-02-27 | US | Kentucky | Caldwell | 21033 | 3938 | 58 | 0 | 37.14749129 | -87.86948214 | 2022-02-28 04:21:05 | Caldwell, Kentucky, US | |
2022-02-26 | US | Wisconsin | Washburn | 55129 | 3938 | 44 | 0 | 45.89838588 | -91.79050449 | 2022-02-27 04:21:04 | Washburn, Wisconsin, US | |
2022-02-26 | US | Kentucky | Caldwell | 21033 | 3938 | 58 | 0 | 37.14749129 | -87.86948214 | 2022-02-27 04:21:04 | Caldwell, Kentucky, US | |
2022-02-25 | US | Wisconsin | Washburn | 55129 | 3938 | 44 | 0 | 45.89838588 | -91.79050449 | 2022-02-26 04:21:12 | Washburn, Wisconsin, US | |
2022-02-25 | US | Kentucky | Caldwell | 21033 | 3938 | 58 | 0 | 37.14749129 | -87.86948214 | 2022-02-26 04:21:12 | Caldwell, Kentucky, US | |
2022-02-17 | US | Illinois | Mercer | 17131 | 3938 | 43 | 0 | 41.20596782 | -90.74290052 | 2022-02-18 04:21:04 | Mercer, Illinois, US | |
2022-02-17 | US | Illinois | Jo Daviess | 17085 | 3938 | 35 | 0 | 42.36542373 | -90.21094405 | 2022-02-18 04:21:04 | Jo Daviess, Illinois, US | |
2022-02-08 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-09 04:21:04 | Hardin, Iowa, US | |
2022-02-07 | US | Pennsylvania | Fulton | 42057 | 3938 | 60 | 0 | 39.92913544 | -78.11163677 | 2022-02-08 04:21:15 | Fulton, Pennsylvania, US | |
2022-02-07 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-08 04:21:15 | Hardin, Iowa, US | |
2022-02-06 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-07 04:21:05 | Hardin, Iowa, US | |
2022-02-05 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-06 04:21:00 | Hardin, Iowa, US | |
2022-02-04 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-05 04:21:05 | Hardin, Iowa, US | |
2022-02-03 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-04 04:21:10 | Hardin, Iowa, US | |
2022-02-02 | US | Iowa | Hardin | 19083 | 3938 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-03 04:21:21 | Hardin, Iowa, US | |
2022-01-20 | US | South Dakota | Hughes | 46065 | 3938 | 58 | 0 | 44.39091534 | -99.99661148 | 2022-01-21 04:21:09 | Hughes, South Dakota, US | |
2022-01-19 | US | West Virginia | McDowell | 54047 | 3938 | 57 | 0 | 37.38002939 | -81.65083669 | 2022-01-20 04:21:07 | McDowell, West Virginia, US | |
2022-01-12 | US | Puerto Rico | Cidra | 72041 | 3938 | 0 | 0 | 18.173559 | -66.161179 | 2022-01-13 08:00:09 | Cidra, Puerto Rico, US | |
2022-01-10 | US | New Mexico | Lincoln | 35027 | 3938 | 50 | 0 | 33.74526079 | -105.4586166 | 2022-01-11 04:22:01 | Lincoln, New Mexico, US | |
2022-01-04 | US | Kentucky | Bourbon | 21017 | 3938 | 44 | 0 | 38.2054607 | -84.21827874 | 2022-01-05 04:21:59 | Bourbon, Kentucky, US | |
2022-01-04 | US | Illinois | Lawrence | 17101 | 3938 | 38 | 0 | 38.71987914 | -87.72884035 | 2022-01-05 04:21:59 | Lawrence, Illinois, US | |
2022-01-03 | US | California | Del Norte | 6015 | 3938 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2022-01-04 04:22:17 | Del Norte, California, US | |
2021-12-22 | US | Texas | Dimmit | 48127 | 3938 | 47 | 0 | 28.42270064 | -99.75645095 | 2021-12-23 04:21:21 | Dimmit, Texas, US | |
2021-12-17 | US | Tennessee | Fentress | 47049 | 3938 | 75 | 0 | 36.38128818 | -84.92870012 | 2021-12-18 02:22:20 | Fentress, Tennessee, US | |
2021-12-02 | US | Michigan | Otsego | 26137 | 3938 | 68 | 0 | 45.02085831 | -84.59898295 | 2021-12-03 04:23:05 | Otsego, Michigan, US | |
2021-12-01 | US | Michigan | Otsego | 26137 | 3938 | 68 | 0 | 45.02085831 | -84.59898295 | 2021-12-02 04:22:37 | Otsego, Michigan, US | |
2021-11-23 | US | Wisconsin | Kewaunee | 55061 | 3938 | 48 | 0 | 44.51727459 | -87.61468386 | 2021-11-24 04:22:14 | Kewaunee, Wisconsin, US | |
2021-11-17 | US | Mississippi | Newton | 28101 | 3938 | 81 | 0 | 32.40021118 | -89.11843336 | 2021-11-18 04:21:33 | Newton, Mississippi, US | |
2021-11-14 | US | Idaho | Cassia | 16031 | 3938 | 41 | 0 | 42.28347888 | -113.6012409 | 2021-11-15 04:21:36 | Cassia, Idaho, US | |
2021-11-13 | US | Idaho | Cassia | 16031 | 3938 | 41 | 0 | 42.28347888 | -113.6012409 | 2021-11-14 04:21:31 | Cassia, Idaho, US | |
2021-11-02 | US | Kentucky | Letcher | 21133 | 3938 | 66 | 0 | 37.12306748 | -82.85346474 | 2021-11-03 06:22:09 | Letcher, Kentucky, US | |
2021-10-31 | US | South Carolina | Jasper | 45053 | 3938 | 81 | 0 | 32.43171982 | -81.02487495 | 2021-11-01 04:22:01 | Jasper, South Carolina, US | |
2021-10-30 | US | South Carolina | Jasper | 45053 | 3938 | 81 | 0 | 32.43171982 | -81.02487495 | 2021-10-31 04:22:08 | Jasper, South Carolina, US | |
2021-10-29 | US | South Carolina | Jasper | 45053 | 3938 | 81 | 0 | 32.43171982 | -81.02487495 | 2021-10-30 04:22:03 | Jasper, South Carolina, US | |
2021-10-13 | US | Louisiana | Union | 22111 | 3938 | 103 | 0 | 32.83121059 | -92.3749373 | 2021-10-14 04:21:29 | Union, Louisiana, US | |
2021-10-12 | US | Texas | Calhoun | 48057 | 3938 | 33 | 0 | 28.47048236 | -96.61633945 | 2021-10-13 04:20:51 | Calhoun, Texas, US | |
2021-10-01 | US | Tennessee | Wayne | 47181 | 3938 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-10-02 04:21:25 | Wayne, Tennessee, US | |
2021-09-27 | US | Puerto Rico | Arecibo | 72013 | 3938 | 0 | 0 | 18.406631 | -66.675077 | 2021-09-28 04:21:28 | Arecibo, Puerto Rico, US | |
2021-09-26 | US | Puerto Rico | Arecibo | 72013 | 3938 | 0 | 0 | 18.406631 | -66.675077 | 2021-09-27 04:21:16 | Arecibo, Puerto Rico, US | |
2021-09-24 | US | Ohio | Morrow | 39117 | 3938 | 54 | 0 | 40.52363560000001 | -82.7892599 | 2021-09-25 04:21:31 | Morrow, Ohio, US | |
2021-09-24 | US | Indiana | Greene | 18055 | 3938 | 92 | 0 | 39.03630547 | -86.96223202 | 2021-09-25 04:21:31 | Greene, Indiana, US | |
2021-09-21 | US | New York | Greene | 36039 | 3938 | 83 | 0 | 42.275797 | -74.12384884 | 2021-09-22 04:21:45 | Greene, New York, US | |
2021-09-21 | US | Illinois | Iroquois | 17075 | 3938 | 72 | 0 | 40.74717633 | -87.82466784 | 2021-09-22 04:21:45 | Iroquois, Illinois, US | |
2021-09-13 | US | Missouri | Dunklin | 29069 | 3938 | 55 | 0 | 36.27167174 | -90.09122243 | 2021-09-14 04:21:41 | Dunklin, Missouri, US | |
2021-09-03 | US | New York | Chenango | 36017 | 3938 | 84 | 0 | 42.49430041 | -75.60887553 | 2021-09-04 04:21:28 | Chenango, New York, US | |
2021-08-16 | US | Maryland | Worcester | 24047 | 3938 | 106 | 0 | 38.21274277 | -75.33200012 | 2021-08-17 04:21:49 | Worcester, Maryland, US | |
2021-08-15 | US | Alabama | Clarke | 1025 | 3938 | 63 | 0 | 31.68099859 | -87.83548597 | 2021-08-16 04:21:31 | Clarke, Alabama, US | |
2021-08-12 | US | Tennessee | White | 47185 | 3938 | 75 | 0 | 35.92929884 | -85.45591799 | 2021-08-13 04:21:24 | White, Tennessee, US | |
2021-08-08 | US | New Mexico | Rio Arriba | 35039 | 3938 | 81 | 0 | 36.51072137 | -106.6931674 | 2021-08-09 04:21:24 | Rio Arriba, New Mexico, US | |
2021-08-07 | US | New Mexico | Rio Arriba | 35039 | 3938 | 81 | 0 | 36.51072137 | -106.6931674 | 2021-08-08 04:21:33 | Rio Arriba, New Mexico, US | |
2021-08-06 | US | New Mexico | Rio Arriba | 35039 | 3938 | 81 | 0 | 36.51072137 | -106.6931674 | 2021-08-07 04:21:30 | Rio Arriba, New Mexico, US | |
2021-08-04 | US | Wyoming | Teton | 56039 | 3938 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-08-05 04:21:51 | Teton, Wyoming, US | |
2021-07-26 | US | Illinois | Christian | 17021 | 3938 | 75 | 0 | 39.54581621 | -89.27780482 | 2021-07-27 04:21:18 | Christian, Illinois, US | |
2021-07-20 | US | Alaska | Bethel | 2050 | 3938 | 22 | 0 | 60.90980451 | -159.8561831 | 2021-07-21 04:21:40 | Bethel, Alaska, US | |
2021-07-19 | US | Alaska | Bethel | 2050 | 3938 | 22 | 0 | 60.90980451 | -159.8561831 | 2021-07-20 04:21:48 | Bethel, Alaska, US | |
2021-07-14 | US | New York | Cortland | 36023 | 3938 | 64 | 0 | 42.59509207 | -76.07048931 | 2021-07-15 04:21:48 | Cortland, New York, US | |
2021-07-10 | US | Virginia | Petersburg | 51730 | 3938 | 88 | 0 | 37.20530399 | -77.39368102 | 2021-07-11 04:21:43 | Petersburg, Virginia, US | |
2021-07-10 | US | Colorado | Montrose | 8085 | 3938 | 73 | 0 | 38.40214114 | -108.26390220000002 | 2021-07-11 04:21:43 | Montrose, Colorado, US | |
2021-07-06 | Peru | Unknown | 3938 | 358 | 2030251 | 0 | 2021-07-07 04:21:20 | Unknown, Peru | ||||
2021-07-03 | US | Puerto Rico | Toa Alta | 72135 | 3938 | 0 | 0 | 18.362406 | -66.246616 | 2021-07-04 04:21:38 | Toa Alta, Puerto Rico, US | |
2021-06-30 | US | Puerto Rico | Toa Alta | 72135 | 3938 | 0 | 0 | 18.362406 | -66.246616 | 2021-07-01 04:21:19 | Toa Alta, Puerto Rico, US | |
2021-06-24 | US | Illinois | Morgan | 17137 | 3938 | 82 | 0 | 39.71654544 | -90.20255104 | 2021-06-25 04:21:33 | Morgan, Illinois, US | |
2021-05-24 | US | Nebraska | Dakota | 31043 | 3938 | 65 | 0 | 42.39040144 | -96.56656425 | 2021-05-25 04:21:08 | Dakota, Nebraska, US | |
2021-05-07 | US | Ohio | Brown | 39015 | 3938 | 57 | 0 | 38.93416837 | -83.86788395 | 2021-05-08 04:21:04 | Brown, Ohio, US | |
2021-04-29 | US | Kansas | Cowley | 20035 | 3938 | 107 | 0 | 37.23781842 | -96.83776647 | 2021-04-30 04:21:03 | Cowley, Kansas, US | |
2021-04-28 | US | Kansas | Cowley | 20035 | 3938 | 107 | 0 | 37.23781842 | -96.83776647 | 2021-04-29 04:20:55 | Cowley, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;