daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
163 rows where confirmed = 4613 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-12 | US | West Virginia | Grant | 54023 | 4613 | 61 | 0 | 39.10314817 | -79.19440518 | 2022-12-13 04:21:01 | Grant, West Virginia, US | |
2022-11-27 | US | North Dakota | Richland | 38077 | 4613 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-11-28 04:21:02 | Richland, North Dakota, US | |
2022-11-26 | US | North Dakota | Richland | 38077 | 4613 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-11-27 04:21:05 | Richland, North Dakota, US | |
2022-11-25 | US | North Dakota | Richland | 38077 | 4613 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-11-26 04:21:11 | Richland, North Dakota, US | |
2022-09-13 | US | Indiana | Vermillion | 18165 | 4613 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-09-14 04:20:44 | Vermillion, Indiana, US | |
2022-09-12 | US | Indiana | Vermillion | 18165 | 4613 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-09-13 04:20:57 | Vermillion, Indiana, US | |
2022-09-04 | US | Wisconsin | Burnett | 55013 | 4613 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-05 04:21:01 | Burnett, Wisconsin, US | |
2022-09-03 | US | Wisconsin | Burnett | 55013 | 4613 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-04 04:21:22 | Burnett, Wisconsin, US | |
2022-09-02 | US | Wisconsin | Burnett | 55013 | 4613 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-03 04:21:04 | Burnett, Wisconsin, US | |
2022-08-30 | US | Oregon | Tillamook | 41057 | 4613 | 73 | 0 | 45.46248721 | -123.712066 | 2022-08-31 04:20:57 | Tillamook, Oregon, US | |
2022-08-30 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-31 04:20:57 | Cedar, Iowa, US | |
2022-08-29 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-30 04:21:03 | Cedar, Iowa, US | |
2022-08-28 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-29 04:21:06 | Cedar, Iowa, US | |
2022-08-27 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-28 04:21:02 | Cedar, Iowa, US | |
2022-08-26 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-27 04:20:57 | Cedar, Iowa, US | |
2022-08-25 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-26 04:21:02 | Cedar, Iowa, US | |
2022-08-24 | US | Iowa | Cedar | 19031 | 4613 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-25 04:21:13 | Cedar, Iowa, US | |
2022-08-09 | US | Texas | Lamb | 48279 | 4613 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-08-10 04:20:57 | Lamb, Texas, US | |
2022-08-07 | US | Illinois | Carroll | 17015 | 4613 | 49 | 0 | 42.06823429 | -89.93395545 | 2022-08-08 04:21:08 | Carroll, Illinois, US | |
2022-08-06 | US | Illinois | Carroll | 17015 | 4613 | 49 | 0 | 42.06823429 | -89.93395545 | 2022-08-07 04:20:54 | Carroll, Illinois, US | |
2022-08-05 | US | Illinois | Carroll | 17015 | 4613 | 49 | 0 | 42.06823429 | -89.93395545 | 2022-08-06 04:20:56 | Carroll, Illinois, US | |
2022-07-12 | US | Texas | Shelby | 48419 | 4613 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-07-13 04:20:58 | Shelby, Texas, US | |
2022-07-08 | US | Arkansas | Grant | 5053 | 4613 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-07-09 04:20:59 | Grant, Arkansas, US | |
2022-07-03 | US | Colorado | Otero | 8089 | 4613 | 130 | 0 | 37.9014485 | -103.7173385 | 2022-07-04 04:20:54 | Otero, Colorado, US | |
2022-06-26 | US | Illinois | De Witt | 17039 | 4613 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-06-27 04:21:00 | De Witt, Illinois, US | |
2022-06-25 | US | Illinois | De Witt | 17039 | 4613 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-06-26 04:21:02 | De Witt, Illinois, US | |
2022-06-24 | US | Illinois | De Witt | 17039 | 4613 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-06-25 04:20:57 | De Witt, Illinois, US | |
2022-06-21 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-22 04:20:54 | Putnam, Georgia, US | |
2022-06-20 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-21 04:20:56 | Putnam, Georgia, US | |
2022-06-19 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-20 04:21:01 | Putnam, Georgia, US | |
2022-06-18 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-19 04:20:51 | Putnam, Georgia, US | |
2022-06-17 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-18 04:21:10 | Putnam, Georgia, US | |
2022-06-16 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-17 04:20:56 | Putnam, Georgia, US | |
2022-06-15 | US | Georgia | Putnam | 13237 | 4613 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-06-16 04:20:55 | Putnam, Georgia, US | |
2022-05-19 | US | Puerto Rico | Catano | 72033 | 4613 | 0 | 0 | 18.437269 | -66.143306 | 2022-05-20 04:20:57 | Catano, Puerto Rico, US | |
2022-04-12 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-13 04:21:03 | Roscommon, Michigan, US | |
2022-04-11 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-12 04:20:49 | Roscommon, Michigan, US | |
2022-04-10 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-11 04:21:02 | Roscommon, Michigan, US | |
2022-04-09 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-10 04:20:52 | Roscommon, Michigan, US | |
2022-04-08 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-09 04:20:42 | Roscommon, Michigan, US | |
2022-04-07 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-08 04:20:48 | Roscommon, Michigan, US | |
2022-04-06 | US | Virginia | New Kent | 51127 | 4613 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-04-07 04:20:53 | New Kent, Virginia, US | |
2022-04-06 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-07 04:20:53 | Meigs, Ohio, US | |
2022-04-06 | US | Michigan | Roscommon | 26143 | 4613 | 113 | 0 | 44.33473082 | -84.61067651 | 2022-04-07 04:20:53 | Roscommon, Michigan, US | |
2022-04-05 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-06 04:20:49 | Meigs, Ohio, US | |
2022-04-04 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-05 04:20:48 | Meigs, Ohio, US | |
2022-04-03 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-04 04:20:51 | Meigs, Ohio, US | |
2022-04-02 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-03 04:20:48 | Meigs, Ohio, US | |
2022-04-01 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-02 04:20:47 | Meigs, Ohio, US | |
2022-03-31 | US | Texas | Reeves | 48389 | 4613 | 74 | 0 | 31.32323325 | -103.69038959999999 | 2022-04-01 04:20:28 | Reeves, Texas, US | |
2022-03-31 | US | Ohio | Meigs | 39105 | 4613 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-01 04:20:28 | Meigs, Ohio, US | |
2022-03-24 | US | Wyoming | Carbon | 56007 | 4613 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-03-25 04:20:46 | Carbon, Wyoming, US | |
2022-03-24 | US | Puerto Rico | Cabo Rojo | 72023 | 4613 | 0 | 0 | 18.040993 | -67.154391 | 2022-03-25 04:20:46 | Cabo Rojo, Puerto Rico, US | |
2022-03-23 | US | Wyoming | Carbon | 56007 | 4613 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-03-24 04:20:43 | Carbon, Wyoming, US | |
2022-03-22 | US | Wyoming | Carbon | 56007 | 4613 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-03-23 04:20:48 | Carbon, Wyoming, US | |
2022-03-21 | US | Arkansas | Sharp | 5135 | 4613 | 103 | 0 | 36.16258158 | -91.47819342 | 2022-03-22 04:20:54 | Sharp, Arkansas, US | |
2022-03-20 | US | Wisconsin | Adams | 55001 | 4613 | 57 | 0 | 43.96974651 | -89.76782777 | 2022-03-21 04:20:50 | Adams, Wisconsin, US | |
2022-03-19 | US | Wisconsin | Adams | 55001 | 4613 | 57 | 0 | 43.96974651 | -89.76782777 | 2022-03-20 04:20:45 | Adams, Wisconsin, US | |
2022-03-18 | US | Wisconsin | Adams | 55001 | 4613 | 57 | 0 | 43.96974651 | -89.76782777 | 2022-03-19 04:20:47 | Adams, Wisconsin, US | |
2022-02-27 | US | Indiana | Perry | 18123 | 4613 | 62 | 0 | 38.07809328 | -86.63741946 | 2022-02-28 04:21:05 | Perry, Indiana, US | |
2022-02-26 | US | Indiana | Perry | 18123 | 4613 | 62 | 0 | 38.07809328 | -86.63741946 | 2022-02-27 04:21:04 | Perry, Indiana, US | |
2022-02-25 | US | Indiana | Perry | 18123 | 4613 | 62 | 0 | 38.07809328 | -86.63741946 | 2022-02-26 04:21:12 | Perry, Indiana, US | |
2022-02-22 | US | Montana | Lincoln | 30053 | 4613 | 80 | 0 | 48.54265777 | -115.4046155 | 2022-02-23 04:21:09 | Lincoln, Montana, US | |
2022-02-21 | US | West Virginia | Barbour | 54001 | 4613 | 68 | 0 | 39.1307219 | -80.00350858 | 2022-02-22 04:21:01 | Barbour, West Virginia, US | |
2022-02-07 | US | Alabama | Marengo | 1091 | 4613 | 97 | 0 | 32.24767634 | -87.78796182 | 2022-02-08 04:21:15 | Marengo, Alabama, US | |
2022-01-30 | US | Michigan | Charlevoix | 26029 | 4613 | 55 | 0 | 45.37790017 | -85.19614053 | 2022-01-31 04:21:09 | Charlevoix, Michigan, US | |
2022-01-29 | US | Michigan | Charlevoix | 26029 | 4613 | 55 | 0 | 45.37790017 | -85.19614053 | 2022-01-30 04:21:26 | Charlevoix, Michigan, US | |
2022-01-28 | US | Michigan | Charlevoix | 26029 | 4613 | 55 | 0 | 45.37790017 | -85.19614053 | 2022-01-29 04:21:10 | Charlevoix, Michigan, US | |
2022-01-26 | US | Georgia | Cook | 13075 | 4613 | 65 | 0 | 31.16068491 | -83.42947229 | 2022-01-27 04:21:19 | Cook, Georgia, US | |
2022-01-24 | US | Wisconsin | Green Lake | 55047 | 4613 | 53 | 0 | 43.80025981 | -89.04679553 | 2022-01-25 04:21:05 | Green Lake, Wisconsin, US | |
2022-01-20 | US | Wisconsin | Vilas | 55125 | 4613 | 83 | 0 | 46.05467334 | -89.51719204 | 2022-01-21 04:21:09 | Vilas, Wisconsin, US | |
2022-01-19 | US | Minnesota | Waseca | 27161 | 4613 | 36 | 0 | 44.02211116 | -93.58720034 | 2022-01-20 04:21:07 | Waseca, Minnesota, US | |
2022-01-18 | US | Michigan | Menominee | 26109 | 4613 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-19 04:21:23 | Menominee, Michigan, US | |
2022-01-17 | US | Michigan | Menominee | 26109 | 4613 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-18 04:21:04 | Menominee, Michigan, US | |
2022-01-16 | US | Michigan | Menominee | 26109 | 4613 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-17 04:21:08 | Menominee, Michigan, US | |
2022-01-15 | US | Michigan | Menominee | 26109 | 4613 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-16 04:21:12 | Menominee, Michigan, US | |
2022-01-14 | US | Michigan | Menominee | 26109 | 4613 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-15 04:21:07 | Menominee, Michigan, US | |
2022-01-06 | US | Missouri | Washington | 29221 | 4613 | 106 | 0 | 37.96130078 | -90.87948158 | 2022-01-07 04:22:09 | Washington, Missouri, US | |
2021-12-23 | US | Virginia | Caroline | 51033 | 4613 | 56 | 0 | 38.02679129 | -77.34901405 | 2021-12-24 04:21:34 | Caroline, Virginia, US | |
2021-12-20 | US | Louisiana | Sabine | 22085 | 4613 | 96 | 0 | 31.56388699 | -93.55433981 | 2021-12-21 03:21:27 | Sabine, Louisiana, US | |
2021-12-07 | Netherlands | Sint Maarten | 4613 | 75 | 0 | 18.0425 | -63.0548 | 2021-12-08 04:22:46 | Sint Maarten, Netherlands | |||
2021-12-05 | US | Texas | Hale | 48189 | 4613 | 197 | 0 | 34.07044901 | -101.82681140000001 | 2021-12-06 04:22:34 | Hale, Texas, US | |
2021-11-29 | US | Virginia | Isle of Wight | 51093 | 4613 | 92 | 0 | 36.90579348 | -76.70842863 | 2021-11-30 04:22:53 | Isle of Wight, Virginia, US | |
2021-11-17 | US | Kentucky | Mercer | 21167 | 4613 | 76 | 0 | 37.81474237 | -84.87488475 | 2021-11-18 04:21:33 | Mercer, Kentucky, US | |
2021-11-10 | US | New York | Greene | 36039 | 4613 | 87 | 0 | 42.275797 | -74.12384884 | 2021-11-11 04:21:45 | Greene, New York, US | |
2021-11-03 | US | Alabama | Lawrence | 1079 | 4613 | 120 | 0 | 34.52041498 | -87.31069453 | 2021-11-04 04:22:20 | Lawrence, Alabama, US | |
2021-10-22 | US | Missouri | Lafayette | 29107 | 4613 | 73 | 0 | 39.06986886 | -93.78076396 | 2021-10-23 04:21:32 | Lafayette, Missouri, US | |
2021-10-21 | US | New York | Washington | 36115 | 4613 | 67 | 0 | 43.31153794 | -73.43043448 | 2021-10-22 04:21:14 | Washington, New York, US | |
2021-10-21 | US | Georgia | Unassigned | 90013 | 4613 | 9 | 0 | 34.91369188 | 0.0 | 2021-10-22 04:21:14 | Unassigned, Georgia, US | |
2021-10-21 | US | Georgia | Gilmer | 13123 | 4613 | 133 | 0 | 34.69316688 | -84.45802506 | 2021-10-22 04:21:14 | Gilmer, Georgia, US | |
2021-10-19 | US | Texas | Hutchinson | 48233 | 4613 | 86 | 0 | 35.84006574 | -101.3546643 | 2021-10-20 04:21:00 | Hutchinson, Texas, US | |
2021-10-17 | US | North Carolina | Cherokee | 37039 | 4613 | 74 | 0 | 35.1349263 | -84.05970864 | 2021-10-18 04:21:10 | Cherokee, North Carolina, US | |
2021-10-16 | US | North Carolina | Cherokee | 37039 | 4613 | 74 | 0 | 35.1349263 | -84.05970864 | 2021-10-17 04:21:29 | Cherokee, North Carolina, US | |
2021-10-15 | US | North Carolina | Cherokee | 37039 | 4613 | 74 | 0 | 35.1349263 | -84.05970864 | 2021-10-16 04:21:15 | Cherokee, North Carolina, US | |
2021-10-07 | US | Kansas | Geary | 20061 | 4613 | 54 | 0 | 38.99871131 | -96.7577178 | 2021-10-08 04:21:25 | Geary, Kansas, US | |
2021-10-06 | US | Kansas | Geary | 20061 | 4613 | 54 | 0 | 38.99871131 | -96.7577178 | 2021-10-07 04:21:36 | Geary, Kansas, US | |
2021-09-20 | US | New York | Columbia | 36021 | 4613 | 107 | 0 | 42.24819348 | -73.63089095 | 2021-09-21 04:21:26 | Columbia, New York, US | |
2021-09-02 | US | Texas | Howard | 48227 | 4613 | 107 | 0 | 32.30621324 | -101.4356444 | 2021-09-03 04:21:20 | Howard, Texas, US | |
2021-08-30 | US | Missouri | Pulaski | 29169 | 4613 | 62 | 0 | 37.82462075 | -92.20783203 | 2021-08-31 04:21:46 | Pulaski, Missouri, US | |
2021-08-23 | US | Mississippi | Lincoln | 28085 | 4613 | 121 | 0 | 31.53288662 | -90.45391915 | 2021-08-24 04:21:19 | Lincoln, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;