daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
219 rows where confirmed = 3503 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 209
- Antigua and Barbuda 2
- China 2
- Ukraine 2
- Colombia 1
- Liechtenstein 1
- Malaysia 1
- Russia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | Virginia | Floyd | 51063 | 3503 | 53 | 0 | 36.9302126 | -80.36738849 | 2022-12-16 04:21:01 | Floyd, Virginia, US | |
2022-12-15 | US | Colorado | Rio Grande | 8105 | 3503 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-16 04:21:01 | Rio Grande, Colorado, US | |
2022-11-30 | US | Colorado | Crowley | 8025 | 3503 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-12-01 04:21:03 | Crowley, Colorado, US | |
2022-11-30 | US | Arkansas | Stone | 5137 | 3503 | 75 | 0 | 35.86251946 | -92.15684085 | 2022-12-01 04:21:03 | Stone, Arkansas, US | |
2022-11-29 | US | Colorado | Crowley | 8025 | 3503 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-30 04:21:07 | Crowley, Colorado, US | |
2022-11-28 | US | Colorado | Crowley | 8025 | 3503 | 31 | 0 | 38.32608609 | -103.7844965 | 2022-11-29 04:21:05 | Crowley, Colorado, US | |
2022-11-16 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-17 04:21:11 | Vinton, Ohio, US | |
2022-11-15 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-16 04:21:09 | Vinton, Ohio, US | |
2022-11-14 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-15 04:21:16 | Vinton, Ohio, US | |
2022-11-13 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-14 04:21:09 | Vinton, Ohio, US | |
2022-11-12 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-13 04:21:14 | Vinton, Ohio, US | |
2022-11-11 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-12 04:20:41 | Vinton, Ohio, US | |
2022-11-10 | US | Ohio | Vinton | 39163 | 3503 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-11-11 04:21:22 | Vinton, Ohio, US | |
2022-10-26 | China | Henan | 3503 | 22 | 0 | 33.882 | 113.614 | 2022-10-27 04:22:01 | Henan, China | |||
2022-10-23 | US | Arkansas | Desha | 5041 | 3503 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-24 04:22:29 | Desha, Arkansas, US | |
2022-10-22 | US | Arkansas | Desha | 5041 | 3503 | 43 | 0 | 33.83011025 | -91.25500948 | 2022-10-23 04:22:46 | Desha, Arkansas, US | |
2022-10-10 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-11 04:23:05 | Converse, Wyoming, US | |
2022-10-09 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-10 04:22:32 | Converse, Wyoming, US | |
2022-10-08 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-09 04:21:16 | Converse, Wyoming, US | |
2022-10-07 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-08 04:22:56 | Converse, Wyoming, US | |
2022-10-06 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-07 04:23:08 | Converse, Wyoming, US | |
2022-10-05 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-06 04:21:22 | Converse, Wyoming, US | |
2022-10-05 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-06 04:21:22 | Coosa, Alabama, US | |
2022-10-04 | US | Wyoming | Converse | 56009 | 3503 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-05 04:23:06 | Converse, Wyoming, US | |
2022-10-04 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-05 04:23:06 | Coosa, Alabama, US | |
2022-10-03 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-04 04:22:55 | Coosa, Alabama, US | |
2022-10-02 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-03 04:23:11 | Coosa, Alabama, US | |
2022-10-01 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-02 04:21:23 | Coosa, Alabama, US | |
2022-09-30 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-01 04:23:01 | Coosa, Alabama, US | |
2022-09-29 | US | Alabama | Coosa | 1037 | 3503 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-09-30 04:23:09 | Coosa, Alabama, US | |
2022-09-25 | US | North Dakota | McKenzie | 38053 | 3503 | 25 | 0 | 47.7413337 | -103.395905 | 2022-09-26 04:20:52 | McKenzie, North Dakota, US | |
2022-09-18 | US | Texas | Jim Hogg | 48247 | 3503 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-09-19 04:21:49 | Jim Hogg, Texas, US | |
2022-09-17 | US | Texas | Jim Hogg | 48247 | 3503 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-09-18 04:22:50 | Jim Hogg, Texas, US | |
2022-09-16 | US | Texas | Jim Hogg | 48247 | 3503 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-09-17 04:20:19 | Jim Hogg, Texas, US | |
2022-08-04 | US | Texas | Jackson | 48239 | 3503 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-08-05 04:20:52 | Jackson, Texas, US | |
2022-07-21 | US | Wisconsin | Price | 55099 | 3503 | 34 | 0 | 45.68051754 | -90.3609888 | 2022-07-22 04:21:15 | Price, Wisconsin, US | |
2022-07-10 | US | West Virginia | Roane | 54087 | 3503 | 37 | 0 | 38.71622686 | -81.35243568 | 2022-07-11 04:20:46 | Roane, West Virginia, US | |
2022-07-09 | US | West Virginia | Roane | 54087 | 3503 | 37 | 0 | 38.71622686 | -81.35243568 | 2022-07-10 04:20:54 | Roane, West Virginia, US | |
2022-07-08 | US | West Virginia | Roane | 54087 | 3503 | 37 | 0 | 38.71622686 | -81.35243568 | 2022-07-09 04:20:59 | Roane, West Virginia, US | |
2022-06-14 | US | California | Mariposa | 6043 | 3503 | 35 | 0 | 37.57978556 | -119.9073334 | 2022-06-15 04:20:54 | Mariposa, California, US | |
2022-06-12 | US | Illinois | Washington | 17189 | 3503 | 35 | 0 | 38.35309213 | -89.40982703 | 2022-06-13 04:21:14 | Washington, Illinois, US | |
2022-06-11 | US | Illinois | Washington | 17189 | 3503 | 35 | 0 | 38.35309213 | -89.40982703 | 2022-06-12 04:20:53 | Washington, Illinois, US | |
2022-06-10 | US | Illinois | Washington | 17189 | 3503 | 35 | 0 | 38.35309213 | -89.40982703 | 2022-06-11 04:21:01 | Washington, Illinois, US | |
2022-06-07 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-08 04:20:55 | Hamilton, Iowa, US | |
2022-06-06 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-07 04:21:08 | Hamilton, Iowa, US | |
2022-06-05 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-06 04:20:57 | Hamilton, Iowa, US | |
2022-06-04 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-05 04:20:55 | Hamilton, Iowa, US | |
2022-06-03 | US | Texas | Wilbarger | 48487 | 3503 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-06-04 04:20:58 | Wilbarger, Texas, US | |
2022-06-03 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-04 04:20:58 | Hamilton, Iowa, US | |
2022-06-02 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-03 04:20:58 | Hamilton, Iowa, US | |
2022-06-01 | US | Iowa | Hamilton | 19079 | 3503 | 73 | 0 | 42.38382428 | -93.70197703 | 2022-06-02 05:20:39 | Hamilton, Iowa, US | |
2022-04-22 | US | Puerto Rico | San German | 72125 | 3503 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-04-23 04:20:50 | San German, Puerto Rico, US | |
2022-04-18 | US | Minnesota | Kanabec | 27065 | 3503 | 55 | 0 | 45.9459309 | -93.29275192 | 2022-04-19 04:21:00 | Kanabec, Minnesota, US | |
2022-04-03 | US | Minnesota | Sibley | 27143 | 3503 | 24 | 0 | 44.5796592 | -94.23164924 | 2022-04-04 04:20:51 | Sibley, Minnesota, US | |
2022-04-02 | US | Minnesota | Sibley | 27143 | 3503 | 24 | 0 | 44.5796592 | -94.23164924 | 2022-04-03 04:20:48 | Sibley, Minnesota, US | |
2022-04-01 | US | Minnesota | Sibley | 27143 | 3503 | 24 | 0 | 44.5796592 | -94.23164924 | 2022-04-02 04:20:47 | Sibley, Minnesota, US | |
2022-03-10 | US | Indiana | Tipton | 18159 | 3503 | 81 | 0 | 40.31123252 | -86.05234925 | 2022-03-11 04:20:50 | Tipton, Indiana, US | |
2022-02-24 | US | Texas | Bandera | 48019 | 3503 | 73 | 0 | 29.74619598 | -99.24598147 | 2022-02-25 04:21:11 | Bandera, Texas, US | |
2022-02-20 | US | Texas | Zapata | 48505 | 3503 | 50 | 0 | 27.00156391 | -99.16987152 | 2022-02-21 04:21:05 | Zapata, Texas, US | |
2022-02-13 | US | Louisiana | West Carroll | 22123 | 3503 | 57 | 0 | 32.78550125 | -91.461201 | 2022-02-14 04:20:51 | West Carroll, Louisiana, US | |
2022-02-12 | US | Louisiana | West Carroll | 22123 | 3503 | 57 | 0 | 32.78550125 | -91.461201 | 2022-02-13 04:21:00 | West Carroll, Louisiana, US | |
2022-02-11 | US | Louisiana | West Carroll | 22123 | 3503 | 57 | 0 | 32.78550125 | -91.461201 | 2022-02-12 04:21:06 | West Carroll, Louisiana, US | |
2022-02-02 | US | Kentucky | Casey | 21045 | 3503 | 65 | 0 | 37.32533118 | -84.92726209 | 2022-02-03 04:21:21 | Casey, Kentucky, US | |
2022-01-31 | US | North Carolina | Polk | 37149 | 3503 | 49 | 0 | 35.27820615 | -82.16812354 | 2022-02-01 04:21:11 | Polk, North Carolina, US | |
2022-01-27 | US | Minnesota | Redwood | 27127 | 3503 | 50 | 0 | 44.40555844 | -95.25207021 | 2022-01-28 04:21:09 | Redwood, Minnesota, US | |
2022-01-25 | US | Texas | Llano | 48299 | 3503 | 87 | 0 | 30.70645047 | -98.68475262 | 2022-01-26 04:21:07 | Llano, Texas, US | |
2022-01-20 | US | Puerto Rico | Yabucoa | 72151 | 3503 | 0 | 0 | 18.070399 | -65.896289 | 2022-01-21 04:21:09 | Yabucoa, Puerto Rico, US | |
2022-01-19 | US | Kentucky | Lewis | 21135 | 3503 | 71 | 0 | 38.53184419 | -83.37735618 | 2022-01-20 04:21:07 | Lewis, Kentucky, US | |
2022-01-19 | US | Arkansas | Clay | 5021 | 3503 | 77 | 0 | 36.36826212 | -90.4148172 | 2022-01-20 04:21:07 | Clay, Arkansas, US | |
2022-01-12 | US | Montana | Big Horn | 30003 | 3503 | 86 | 0 | 45.42335905 | -107.492347 | 2022-01-13 08:00:09 | Big Horn, Montana, US | |
2022-01-10 | US | Puerto Rico | Cabo Rojo | 72023 | 3503 | 0 | 0 | 18.040993 | -67.154391 | 2022-01-11 04:22:01 | Cabo Rojo, Puerto Rico, US | |
2022-01-05 | China | Guangdong | 3503 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-06 04:22:09 | Guangdong, China | |||
2022-01-04 | US | Kentucky | Spencer | 21215 | 3503 | 44 | 0 | 38.03223971 | -85.32749335 | 2022-01-05 04:21:59 | Spencer, Kentucky, US | |
2021-12-28 | US | Tennessee | Humphreys | 47085 | 3503 | 59 | 0 | 36.03958805 | -87.77992872 | 2021-12-29 03:21:43 | Humphreys, Tennessee, US | |
2021-12-27 | US | Missouri | Texas | 29215 | 3503 | 71 | 0 | 37.31728859 | -91.96564727 | 2021-12-28 04:21:47 | Texas, Missouri, US | |
2021-12-20 | US | Missouri | New Madrid | 29143 | 3503 | 71 | 0 | 36.59666326 | -89.66070007 | 2021-12-21 03:21:27 | New Madrid, Missouri, US | |
2021-12-19 | US | Missouri | New Madrid | 29143 | 3503 | 71 | 0 | 36.59666326 | -89.66070007 | 2021-12-20 04:21:43 | New Madrid, Missouri, US | |
2021-12-18 | US | Missouri | New Madrid | 29143 | 3503 | 71 | 0 | 36.59666326 | -89.66070007 | 2021-12-19 04:21:11 | New Madrid, Missouri, US | |
2021-12-16 | US | Michigan | Cheboygan | 26031 | 3503 | 79 | 0 | 45.44787015 | -84.50122149 | 2021-12-17 04:22:14 | Cheboygan, Michigan, US | |
2021-12-15 | US | Michigan | Cheboygan | 26031 | 3503 | 79 | 0 | 45.44787015 | -84.50122149 | 2021-12-16 04:22:11 | Cheboygan, Michigan, US | |
2021-12-14 | US | Colorado | Teller | 8119 | 3503 | 51 | 0 | 38.88133511 | -105.16148929999999 | 2021-12-15 03:22:16 | Teller, Colorado, US | |
2021-12-13 | US | Indiana | Jay | 18075 | 3503 | 52 | 0 | 40.43781032 | -85.00576229 | 2021-12-14 04:22:38 | Jay, Indiana, US | |
2021-12-12 | US | West Virginia | Brooke | 54009 | 3503 | 81 | 0 | 40.27367263 | -80.57915332 | 2021-12-13 04:22:02 | Brooke, West Virginia, US | |
2021-12-10 | US | Kentucky | Wayne | 21231 | 3503 | 71 | 0 | 36.80310688 | -84.8251971 | 2021-12-11 04:22:45 | Wayne, Kentucky, US | |
2021-12-09 | US | Pennsylvania | Juniata | 42067 | 3503 | 134 | 0 | 40.53358749 | -77.39975129999998 | 2021-12-10 04:22:28 | Juniata, Pennsylvania, US | |
2021-12-09 | US | Arkansas | Ouachita | 5103 | 3503 | 87 | 0 | 33.58839816 | -92.87795984 | 2021-12-10 04:22:28 | Ouachita, Arkansas, US | |
2021-12-08 | US | Virginia | Dinwiddie | 51053 | 3503 | 60 | 0 | 37.07544585 | -77.63451754 | 2021-12-09 04:22:49 | Dinwiddie, Virginia, US | |
2021-12-06 | US | Arkansas | Randolph | 5121 | 3503 | 64 | 0 | 36.3415714 | -91.02455531 | 2021-12-07 04:22:34 | Randolph, Arkansas, US | |
2021-12-06 | US | Arkansas | Lawrence | 5075 | 3503 | 62 | 0 | 36.04188196 | -91.10867198 | 2021-12-07 04:22:34 | Lawrence, Arkansas, US | |
2021-12-04 | US | Tennessee | Union | 47173 | 3503 | 50 | 0 | 36.28590426 | -83.83651902 | 2021-12-05 04:22:25 | Union, Tennessee, US | |
2021-11-30 | US | Kansas | Sumner | 20191 | 3503 | 62 | 0 | 37.23682549 | -97.47721621 | 2021-12-01 04:22:29 | Sumner, Kansas, US | |
2021-11-29 | US | Kansas | Sumner | 20191 | 3503 | 62 | 0 | 37.23682549 | -97.47721621 | 2021-11-30 04:22:53 | Sumner, Kansas, US | |
2021-11-23 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-24 04:22:14 | Crawford, Iowa, US | |
2021-11-22 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-23 04:22:39 | Crawford, Iowa, US | |
2021-11-21 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-22 04:22:20 | Crawford, Iowa, US | |
2021-11-20 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-21 04:22:13 | Crawford, Iowa, US | |
2021-11-19 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-20 04:22:17 | Crawford, Iowa, US | |
2021-11-18 | US | Virginia | Page | 51139 | 3503 | 84 | 0 | 38.61807452 | -78.48797204 | 2021-11-19 04:21:40 | Page, Virginia, US | |
2021-11-18 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-19 04:21:40 | Crawford, Iowa, US | |
2021-11-17 | US | Iowa | Crawford | 19047 | 3503 | 47 | 0 | 42.03718237 | -95.3819718 | 2021-11-18 04:21:33 | Crawford, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;