daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
176 rows where confirmed = 3194 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-18 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-19 04:21:03 | McLean, Kentucky, US | |
2022-12-17 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-18 04:21:03 | McLean, Kentucky, US | |
2022-12-16 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-17 04:21:04 | McLean, Kentucky, US | |
2022-12-15 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-16 04:21:01 | McLean, Kentucky, US | |
2022-12-14 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-15 04:20:58 | McLean, Kentucky, US | |
2022-12-13 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-14 04:21:04 | McLean, Kentucky, US | |
2022-12-12 | US | Kentucky | McLean | 21149 | 3194 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-13 04:21:01 | McLean, Kentucky, US | |
2022-11-30 | US | Virginia | Charlotte | 51037 | 3194 | 49 | 0 | 37.01909701 | -78.66314092 | 2022-12-01 04:21:03 | Charlotte, Virginia, US | |
2022-11-29 | US | Virginia | Charlotte | 51037 | 3194 | 49 | 0 | 37.01909701 | -78.66314092 | 2022-11-30 04:21:07 | Charlotte, Virginia, US | |
2022-10-25 | US | Texas | Eastland | 48133 | 3194 | 117 | 0 | 32.32743996 | -98.83243566 | 2022-10-26 04:22:19 | Eastland, Texas, US | |
2022-10-24 | US | Texas | Eastland | 48133 | 3194 | 117 | 0 | 32.32743996 | -98.83243566 | 2022-10-25 04:21:53 | Eastland, Texas, US | |
2022-10-12 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-13 04:22:39 | Haskell, Oklahoma, US | |
2022-10-11 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-12 04:22:51 | Haskell, Oklahoma, US | |
2022-10-10 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-11 04:23:05 | Haskell, Oklahoma, US | |
2022-10-09 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-10 04:22:32 | Haskell, Oklahoma, US | |
2022-10-08 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-09 04:21:16 | Haskell, Oklahoma, US | |
2022-10-07 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-08 04:22:56 | Haskell, Oklahoma, US | |
2022-10-06 | US | Oklahoma | Haskell | 40061 | 3194 | 43 | 0 | 35.222576 | -95.11513306 | 2022-10-07 04:23:08 | Haskell, Oklahoma, US | |
2022-09-04 | US | Arkansas | Lee | 5077 | 3194 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-09-05 04:21:01 | Lee, Arkansas, US | |
2022-08-03 | US | North Dakota | Barnes | 38003 | 3194 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-04 04:20:58 | Barnes, North Dakota, US | |
2022-08-02 | US | Colorado | Archuleta | 8007 | 3194 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-08-03 04:20:59 | Archuleta, Colorado, US | |
2022-08-01 | US | Colorado | Archuleta | 8007 | 3194 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-08-02 04:20:53 | Archuleta, Colorado, US | |
2022-07-24 | China | Zhejiang | 3194 | 1 | 0 | 29.1832 | 120.0934 | 2022-07-25 04:20:51 | Zhejiang, China | |||
2022-07-23 | China | Zhejiang | 3194 | 1 | 0 | 29.1832 | 120.0934 | 2022-07-24 04:20:47 | Zhejiang, China | |||
2022-07-11 | China | Henan | 3194 | 22 | 0 | 33.882 | 113.614 | 2022-07-12 04:20:51 | Henan, China | |||
2022-06-15 | US | Colorado | Moffat | 8081 | 3194 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-06-16 04:20:55 | Moffat, Colorado, US | |
2022-06-05 | US | Puerto Rico | Patillas | 72109 | 3194 | 0 | 0 | 18.03174 | -66.012242 | 2022-06-06 04:20:57 | Patillas, Puerto Rico, US | |
2022-06-03 | US | Puerto Rico | Arroyo | 72015 | 3194 | 0 | 0 | 17.998457 | -66.056546 | 2022-06-04 04:20:58 | Arroyo, Puerto Rico, US | |
2022-05-16 | US | West Virginia | Roane | 54087 | 3194 | 36 | 0 | 38.71622686 | -81.35243568 | 2022-05-17 04:20:59 | Roane, West Virginia, US | |
2022-04-12 | US | Pennsylvania | Potter | 42105 | 3194 | 92 | 0 | 41.74471626 | -77.89559864 | 2022-04-13 04:21:03 | Potter, Pennsylvania, US | |
2022-03-22 | US | Georgia | Dade | 13083 | 3194 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-03-23 04:20:48 | Dade, Georgia, US | |
2022-03-06 | US | Oregon | Baker | 41001 | 3194 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-07 04:20:47 | Baker, Oregon, US | |
2022-03-06 | US | Missouri | Osage | 29151 | 3194 | 40 | 0 | 38.46036182 | -91.8613635 | 2022-03-07 04:20:47 | Osage, Missouri, US | |
2022-03-05 | US | Oregon | Baker | 41001 | 3194 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-06 04:20:49 | Baker, Oregon, US | |
2022-03-05 | US | Missouri | Osage | 29151 | 3194 | 40 | 0 | 38.46036182 | -91.8613635 | 2022-03-06 04:20:49 | Osage, Missouri, US | |
2022-03-04 | US | Oregon | Baker | 41001 | 3194 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-05 04:21:10 | Baker, Oregon, US | |
2022-03-04 | US | Missouri | Osage | 29151 | 3194 | 40 | 0 | 38.46036182 | -91.8613635 | 2022-03-05 04:21:10 | Osage, Missouri, US | |
2022-03-03 | US | Oregon | Baker | 41001 | 3194 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-04 04:21:09 | Baker, Oregon, US | |
2022-02-23 | US | Tennessee | Jackson | 47087 | 3194 | 58 | 0 | 36.36380466 | -85.67239905 | 2022-02-24 04:21:14 | Jackson, Tennessee, US | |
2022-02-17 | US | Missouri | Dent | 29065 | 3194 | 69 | 0 | 37.60663134 | -91.50790473 | 2022-02-18 04:21:04 | Dent, Missouri, US | |
2022-02-07 | US | Louisiana | Madison | 22065 | 3194 | 57 | 0 | 32.36918118 | -91.23973355 | 2022-02-08 04:21:15 | Madison, Louisiana, US | |
2022-01-30 | US | Kentucky | Carroll | 21041 | 3194 | 39 | 0 | 38.66599534 | -85.12601074 | 2022-01-31 04:21:09 | Carroll, Kentucky, US | |
2022-01-29 | US | Kentucky | Carroll | 21041 | 3194 | 39 | 0 | 38.66599534 | -85.12601074 | 2022-01-30 04:21:26 | Carroll, Kentucky, US | |
2022-01-28 | US | Kentucky | Carroll | 21041 | 3194 | 39 | 0 | 38.66599534 | -85.12601074 | 2022-01-29 04:21:10 | Carroll, Kentucky, US | |
2022-01-26 | US | Louisiana | West Carroll | 22123 | 3194 | 53 | 0 | 32.78550125 | -91.461201 | 2022-01-27 04:21:19 | West Carroll, Louisiana, US | |
2022-01-15 | US | Texas | Bosque | 48035 | 3194 | 59 | 0 | 31.89978581 | -97.63613524 | 2022-01-16 04:21:12 | Bosque, Texas, US | |
2022-01-12 | US | North Carolina | Bertie | 37015 | 3194 | 54 | 0 | 36.0688473 | -76.96545943 | 2022-01-13 08:00:09 | Bertie, North Carolina, US | |
2022-01-10 | US | South Carolina | Lee | 45061 | 3194 | 82 | 0 | 34.16393091 | -80.25690731 | 2022-01-11 04:22:01 | Lee, South Carolina, US | |
2022-01-03 | US | Washington | Asotin | 53003 | 3194 | 52 | 0 | 46.18894415 | -117.2022851 | 2022-01-04 04:22:17 | Asotin, Washington, US | |
2021-12-29 | US | Indiana | Perry | 18123 | 3194 | 54 | 0 | 38.07809328 | -86.63741946 | 2021-12-30 04:21:25 | Perry, Indiana, US | |
2021-12-27 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-28 04:21:47 | Currituck, North Carolina, US | |
2021-12-26 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-27 04:21:58 | Currituck, North Carolina, US | |
2021-12-25 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-26 04:21:50 | Currituck, North Carolina, US | |
2021-12-24 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-25 04:21:37 | Currituck, North Carolina, US | |
2021-12-23 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-24 04:21:34 | Currituck, North Carolina, US | |
2021-12-22 | US | North Carolina | Currituck | 37053 | 3194 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-12-23 04:21:21 | Currituck, North Carolina, US | |
2021-12-15 | US | Illinois | Pike | 17149 | 3194 | 58 | 0 | 39.62265059 | -90.8877017 | 2021-12-16 04:22:11 | Pike, Illinois, US | |
2021-12-07 | US | Arkansas | Sharp | 5135 | 3194 | 71 | 0 | 36.16258158 | -91.47819342 | 2021-12-08 04:22:46 | Sharp, Arkansas, US | |
2021-12-05 | US | Alabama | Hale | 1065 | 3194 | 89 | 0 | 32.76039258 | -87.63284988 | 2021-12-06 04:22:34 | Hale, Alabama, US | |
2021-11-13 | US | West Virginia | Brooke | 54009 | 3194 | 74 | 0 | 40.27367263 | -80.57915332 | 2021-11-14 04:21:31 | Brooke, West Virginia, US | |
2021-11-08 | US | Wisconsin | Vilas | 55125 | 3194 | 57 | 0 | 46.05467334 | -89.51719204 | 2021-11-09 04:21:36 | Vilas, Wisconsin, US | |
2021-11-05 | US | Arkansas | Ashley | 5003 | 3194 | 50 | 0 | 33.19153461 | -91.76984709999999 | 2021-11-06 04:21:51 | Ashley, Arkansas, US | |
2021-11-01 | US | Vermont | Franklin | 50011 | 3194 | 50 | 0 | 44.85627605 | -72.91249563 | 2021-11-02 04:22:03 | Franklin, Vermont, US | |
2021-10-29 | US | Arizona | La Paz | 4012 | 3194 | 98 | 0 | 33.72854224 | -113.98100290000001 | 2021-10-30 04:22:03 | La Paz, Arizona, US | |
2021-10-28 | US | North Carolina | Caswell | 37033 | 3194 | 37 | 0 | 36.39312665 | -79.33353281 | 2021-10-29 04:22:03 | Caswell, North Carolina, US | |
2021-10-23 | US | Texas | Panola | 48365 | 3194 | 108 | 0 | 32.163959600000005 | -94.30552481 | 2021-10-24 04:21:22 | Panola, Texas, US | |
2021-10-22 | US | Texas | Panola | 48365 | 3194 | 108 | 0 | 32.163959600000005 | -94.30552481 | 2021-10-23 04:21:32 | Panola, Texas, US | |
2021-10-21 | US | Georgia | Ben Hill | 13017 | 3194 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-10-22 04:21:14 | Ben Hill, Georgia, US | |
2021-10-18 | US | Georgia | Elbert | 13105 | 3194 | 84 | 0 | 34.11302332 | -82.83936148 | 2021-10-19 04:20:54 | Elbert, Georgia, US | |
2021-10-08 | US | Maryland | Somerset | 24039 | 3194 | 48 | 0 | 38.1163542 | -75.75118623 | 2021-10-09 04:21:34 | Somerset, Maryland, US | |
2021-10-05 | US | Kentucky | McCreary | 21147 | 3194 | 45 | 0 | 36.73874143 | -84.48102924 | 2021-10-06 04:21:33 | McCreary, Kentucky, US | |
2021-10-04 | US | Alabama | Randolph | 1111 | 3194 | 58 | 0 | 33.29526734 | -85.45708831 | 2021-10-05 04:21:27 | Randolph, Alabama, US | |
2021-09-30 | US | Mississippi | Jasper | 28061 | 3194 | 62 | 0 | 32.01922104 | -89.11786866 | 2021-10-01 04:21:35 | Jasper, Mississippi, US | |
2021-09-24 | US | Indiana | Fountain | 18045 | 3194 | 55 | 0 | 40.12361933 | -87.24217689 | 2021-09-25 04:21:31 | Fountain, Indiana, US | |
2021-09-21 | US | Virginia | Lee | 51105 | 3194 | 51 | 0 | 36.70586667 | -83.12606515 | 2021-09-22 04:21:45 | Lee, Virginia, US | |
2021-09-06 | US | Arkansas | Ouachita | 5103 | 3194 | 68 | 0 | 33.58839816 | -92.87795984 | 2021-09-07 04:21:35 | Ouachita, Arkansas, US | |
2021-09-02 | US | Washington | Stevens | 53065 | 3194 | 38 | 0 | 48.40035475 | -117.8542701 | 2021-09-03 04:21:20 | Stevens, Washington, US | |
2021-09-02 | US | Virginia | Halifax | 51083 | 3194 | 89 | 0 | 36.76654925 | -78.93512622 | 2021-09-03 04:21:20 | Halifax, Virginia, US | |
2021-08-28 | US | West Virginia | Preston | 54077 | 3194 | 48 | 0 | 39.46770987 | -79.66712803 | 2021-08-29 04:21:14 | Preston, West Virginia, US | |
2021-08-19 | US | Georgia | Pierce | 13229 | 3194 | 65 | 0 | 31.35928155 | -82.21598442 | 2021-08-20 04:21:33 | Pierce, Georgia, US | |
2021-08-06 | US | Puerto Rico | Trujillo Alto | 72139 | 3194 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-08-07 04:21:30 | Trujillo Alto, Puerto Rico, US | |
2021-08-03 | Liechtenstein | 3194 | 58 | 3011 | 125 | 47.14 | 9.55 | 2021-08-04 04:21:25 | Liechtenstein | |||
2021-07-28 | US | New York | Washington | 36115 | 3194 | 55 | 0 | 43.31153794 | -73.43043448 | 2021-07-29 04:21:33 | Washington, New York, US | |
2021-07-28 | US | Georgia | Stephens | 13257 | 3194 | 81 | 0 | 34.55151201 | -83.29405315 | 2021-07-29 04:21:33 | Stephens, Georgia, US | |
2021-07-27 | US | North Carolina | Macon | 37113 | 3194 | 41 | 0 | 35.14867843 | -83.41696617 | 2021-07-28 04:21:39 | Macon, North Carolina, US | |
2021-07-20 | US | South Carolina | Edgefield | 45037 | 3194 | 43 | 0 | 33.77221995 | -81.96231108 | 2021-07-21 04:21:40 | Edgefield, South Carolina, US | |
2021-07-17 | US | Kentucky | Muhlenberg | 21177 | 3194 | 68 | 0 | 37.21425819 | -87.14632053 | 2021-07-18 04:22:07 | Muhlenberg, Kentucky, US | |
2021-07-15 | US | Alabama | Pike | 1109 | 3194 | 78 | 0 | 31.80396383 | -85.9408295 | 2021-07-16 04:21:22 | Pike, Alabama, US | |
2021-07-07 | US | Ohio | Jackson | 39079 | 3194 | 54 | 0 | 39.01914254 | -82.61818559999998 | 2021-07-08 04:21:26 | Jackson, Ohio, US | |
2021-06-07 | US | Illinois | Perry | 17145 | 3194 | 60 | 0 | 38.08510853 | -89.36856219 | 2021-06-08 04:22:35 | Perry, Illinois, US | |
2021-06-06 | US | Illinois | Perry | 17145 | 3194 | 60 | 0 | 38.08510853 | -89.36856219 | 2021-06-07 04:22:51 | Perry, Illinois, US | |
2021-06-05 | US | Illinois | Perry | 17145 | 3194 | 60 | 0 | 38.08510853 | -89.36856219 | 2021-06-06 04:24:03 | Perry, Illinois, US | |
2021-06-01 | US | Tennessee | Marion | 47115 | 3194 | 47 | 0 | 35.12997174 | -85.62265895 | 2021-06-02 04:24:34 | Marion, Tennessee, US | |
2021-05-31 | US | Oregon | Benton | 41003 | 3194 | 22 | 0 | 44.49167306 | -123.4316987 | 2021-06-01 04:23:09 | Benton, Oregon, US | |
2021-05-30 | US | Oregon | Benton | 41003 | 3194 | 22 | 0 | 44.49167306 | -123.4316987 | 2021-05-31 03:08:59 | Benton, Oregon, US | |
2021-05-28 | US | Illinois | Perry | 17145 | 3194 | 60 | 0 | 38.08510853 | -89.36856219 | 2021-05-29 04:20:41 | Perry, Illinois, US | |
2021-05-27 | US | Missouri | Warren | 29219 | 3194 | 23 | 0 | 38.76529479 | -91.16124662 | 2021-05-28 04:20:36 | Warren, Missouri, US | |
2021-05-27 | US | Idaho | Latah | 16057 | 3194 | 10 | 0 | 46.81587887 | -116.7113698 | 2021-05-28 04:20:36 | Latah, Idaho, US | |
2021-05-25 | US | West Virginia | Logan | 54045 | 3194 | 94 | 0 | 37.8299889 | -81.93528571 | 2021-05-26 04:20:35 | Logan, West Virginia, US | |
2021-05-22 | US | Arkansas | Baxter | 5005 | 3194 | 104 | 0 | 36.28784385 | -92.33782872 | 2021-05-23 04:20:51 | Baxter, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;