daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94 rows where confirmed = 6912 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-20 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-21 04:21:03 | Pottawatomie, Kansas, US | |
2022-12-19 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-20 04:21:04 | Jasper, South Carolina, US | |
2022-12-19 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-20 04:21:04 | Pottawatomie, Kansas, US | |
2022-12-18 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-19 04:21:03 | Jasper, South Carolina, US | |
2022-12-18 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-19 04:21:03 | Pottawatomie, Kansas, US | |
2022-12-17 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-18 04:21:03 | Jasper, South Carolina, US | |
2022-12-17 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-18 04:21:03 | Pottawatomie, Kansas, US | |
2022-12-16 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-17 04:21:04 | Jasper, South Carolina, US | |
2022-12-16 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-17 04:21:04 | Pottawatomie, Kansas, US | |
2022-12-15 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-16 04:21:01 | Jasper, South Carolina, US | |
2022-12-15 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-16 04:21:01 | Pottawatomie, Kansas, US | |
2022-12-14 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-15 04:20:58 | Jasper, South Carolina, US | |
2022-12-14 | US | Kansas | Pottawatomie | 20149 | 6912 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-15 04:20:58 | Pottawatomie, Kansas, US | |
2022-12-13 | US | South Carolina | Jasper | 45053 | 6912 | 96 | 0 | 32.43171982 | -81.02487495 | 2022-12-14 04:21:04 | Jasper, South Carolina, US | |
2022-11-29 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-30 04:21:07 | Jerome, Idaho, US | |
2022-11-28 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-29 04:21:05 | Jerome, Idaho, US | |
2022-11-27 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-28 04:21:02 | Jerome, Idaho, US | |
2022-11-26 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-27 04:21:05 | Jerome, Idaho, US | |
2022-11-25 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-26 04:21:11 | Jerome, Idaho, US | |
2022-11-24 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-25 04:21:06 | Jerome, Idaho, US | |
2022-11-23 | US | Idaho | Jerome | 16053 | 6912 | 68 | 0 | 42.68891267 | -114.2655033 | 2022-11-24 04:21:09 | Jerome, Idaho, US | |
2022-11-08 | US | Virginia | Dinwiddie | 51053 | 6912 | 103 | 0 | 37.07544585 | -77.63451754 | 2022-11-09 04:21:22 | Dinwiddie, Virginia, US | |
2022-10-25 | US | Maine | Franklin | 23007 | 6912 | 69 | 0 | 44.97330019 | -70.44381045 | 2022-10-26 04:22:19 | Franklin, Maine, US | |
2022-10-13 | US | Idaho | Blaine | 16013 | 6912 | 32 | 0 | 43.4085812 | -113.9752658 | 2022-10-14 04:22:28 | Blaine, Idaho, US | |
2022-10-12 | US | Idaho | Blaine | 16013 | 6912 | 32 | 0 | 43.4085812 | -113.9752658 | 2022-10-13 04:22:39 | Blaine, Idaho, US | |
2022-08-30 | US | Colorado | Montezuma | 8083 | 6912 | 83 | 0 | 37.33859579 | -108.5958857 | 2022-08-31 04:20:57 | Montezuma, Colorado, US | |
2022-08-18 | US | Wisconsin | Vernon | 55123 | 6912 | 104 | 0 | 43.59422667 | -90.8324691 | 2022-08-19 04:20:54 | Vernon, Wisconsin, US | |
2022-08-02 | US | Wisconsin | Waushara | 55137 | 6912 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-08-03 04:20:59 | Waushara, Wisconsin, US | |
2022-07-16 | US | Texas | Hale | 48189 | 6912 | 246 | 0 | 34.07044901 | -101.8268114 | 2022-07-17 04:21:15 | Hale, Texas, US | |
2022-07-13 | US | Puerto Rico | Fajardo | 72053 | 6912 | 0 | 0 | 18.318373 | -65.666866 | 2022-07-14 04:20:57 | Fajardo, Puerto Rico, US | |
2022-07-12 | US | New Mexico | Unassigned | 90035 | 6912 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-07-13 04:20:58 | Unassigned, New Mexico, US | |
2022-06-20 | US | Puerto Rico | Yauco | 72153 | 6912 | 0 | 0 | 18.080374 | -66.858814 | 2022-06-21 04:20:56 | Yauco, Puerto Rico, US | |
2022-05-19 | US | Virginia | Russell | 51167 | 6912 | 115 | 0 | 36.9302832 | -82.10095486 | 2022-05-20 04:20:57 | Russell, Virginia, US | |
2022-05-04 | US | Virginia | Caroline | 51033 | 6912 | 85 | 0 | 38.02679129 | -77.34901405 | 2022-05-05 04:20:55 | Caroline, Virginia, US | |
2022-04-06 | US | Puerto Rico | Rio Grande | 72119 | 6912 | 0 | 0 | 18.346329 | -65.813742 | 2022-04-07 04:20:53 | Rio Grande, Puerto Rico, US | |
2022-03-10 | US | West Virginia | Wyoming | 54109 | 6912 | 102 | 0 | 37.612327 | -81.54511071 | 2022-03-11 04:20:50 | Wyoming, West Virginia, US | |
2022-03-03 | US | Louisiana | Jefferson Davis | 22053 | 6912 | 150 | 0 | 30.26896765 | -92.81210004 | 2022-03-04 04:21:09 | Jefferson Davis, Louisiana, US | |
2022-02-22 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-23 04:21:09 | Garvin, Oklahoma, US | |
2022-02-21 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-22 04:21:01 | Garvin, Oklahoma, US | |
2022-02-20 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-21 04:21:05 | Garvin, Oklahoma, US | |
2022-02-19 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-20 04:21:00 | Garvin, Oklahoma, US | |
2022-02-18 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-19 04:21:11 | Garvin, Oklahoma, US | |
2022-02-17 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-18 04:21:04 | Garvin, Oklahoma, US | |
2022-02-16 | US | Virginia | Pulaski | 51155 | 6912 | 117 | 0 | 37.06474963 | -80.71229738 | 2022-02-17 04:20:56 | Pulaski, Virginia, US | |
2022-02-16 | US | Oklahoma | Garvin | 40049 | 6912 | 124 | 0 | 34.70418038 | -97.30811132 | 2022-02-17 04:20:56 | Garvin, Oklahoma, US | |
2022-01-23 | US | Missouri | Lawrence | 29109 | 6912 | 143 | 0 | 37.10626634 | -93.83293097 | 2022-01-24 04:21:12 | Lawrence, Missouri, US | |
2022-01-18 | US | Vermont | Franklin | 50011 | 6912 | 57 | 0 | 44.85627605 | -72.91249563 | 2022-01-19 04:21:23 | Franklin, Vermont, US | |
2022-01-03 | US | Mississippi | Bolivar | 28011 | 6912 | 154 | 0 | 33.79696941 | -90.87372121 | 2022-01-04 04:22:17 | Bolivar, Mississippi, US | |
2021-12-28 | US | Indiana | Jasper | 18073 | 6912 | 103 | 0 | 41.02078733 | -87.11553319 | 2021-12-29 03:21:43 | Jasper, Indiana, US | |
2021-12-21 | US | Alaska | Bethel | 2050 | 6912 | 28 | 0 | 60.90980451 | -159.8561831 | 2021-12-22 04:21:54 | Bethel, Alaska, US | |
2021-12-20 | US | Alaska | Bethel | 2050 | 6912 | 28 | 0 | 60.90980451 | -159.8561831 | 2021-12-21 03:21:27 | Bethel, Alaska, US | |
2021-12-08 | US | North Carolina | Stokes | 37169 | 6912 | 117 | 0 | 36.4017975 | -80.23893369 | 2021-12-09 04:22:49 | Stokes, North Carolina, US | |
2021-11-25 | US | Utah | Southeast Utah | 6912 | 53 | 0 | 38.99617072 | -110.70139579999999 | 2021-11-26 04:22:33 | Southeast Utah, Utah, US | ||
2021-11-24 | US | Utah | Southeast Utah | 6912 | 53 | 0 | 38.99617072 | -110.70139579999999 | 2021-11-25 04:22:33 | Southeast Utah, Utah, US | ||
2021-11-15 | US | Mississippi | Monroe | 28095 | 6912 | 179 | 0 | 33.89236763 | -88.4808438 | 2021-11-16 04:21:10 | Monroe, Mississippi, US | |
2021-11-13 | US | Alabama | Escambia | 1053 | 6912 | 139 | 0 | 31.1256789 | -87.15918694 | 2021-11-14 04:21:31 | Escambia, Alabama, US | |
2021-11-07 | US | West Virginia | Jefferson | 54037 | 6912 | 88 | 0 | 39.30776166 | -77.86014147 | 2021-11-08 04:21:43 | Jefferson, West Virginia, US | |
2021-10-29 | US | Ohio | Auglaize | 39011 | 6912 | 110 | 0 | 40.55998859 | -84.22421429999999 | 2021-10-30 04:22:03 | Auglaize, Ohio, US | |
2021-10-18 | US | Kentucky | Shelby | 21211 | 6912 | 105 | 0 | 38.21476019 | -85.194223 | 2021-10-19 04:20:54 | Shelby, Kentucky, US | |
2021-10-15 | US | Tennessee | Rhea | 47143 | 6912 | 91 | 0 | 35.60536161 | -84.93076643 | 2021-10-16 04:21:15 | Rhea, Tennessee, US | |
2021-10-05 | US | South Carolina | Chesterfield | 45025 | 6912 | 135 | 0 | 34.64137396 | -80.15640140000002 | 2021-10-06 04:21:33 | Chesterfield, South Carolina, US | |
2021-09-21 | US | Tennessee | Fayette | 47047 | 6912 | 93 | 0 | 35.19615831 | -89.41399032 | 2021-09-22 04:21:45 | Fayette, Tennessee, US | |
2021-09-20 | US | Indiana | Lawrence | 18093 | 6912 | 152 | 0 | 38.84112637 | -86.48361629 | 2021-09-21 04:21:26 | Lawrence, Indiana, US | |
2021-09-09 | US | Mississippi | Hancock | 28045 | 6912 | 103 | 0 | 30.41830223 | -89.48851033 | 2021-09-10 04:21:20 | Hancock, Mississippi, US | |
2021-08-31 | US | Michigan | Shiawassee | 26155 | 6912 | 112 | 0 | 42.95392800000001 | -84.14585902 | 2021-09-01 04:21:38 | Shiawassee, Michigan, US | |
2021-08-30 | US | Michigan | Shiawassee | 26155 | 6912 | 112 | 0 | 42.95392800000001 | -84.14585902 | 2021-08-31 04:21:46 | Shiawassee, Michigan, US | |
2021-08-01 | US | Tennessee | McMinn | 47107 | 6912 | 106 | 0 | 35.42812616 | -84.61520715 | 2021-08-02 04:21:36 | McMinn, Tennessee, US | |
2021-07-29 | US | Minnesota | Crow Wing | 27035 | 6912 | 99 | 0 | 46.48096553 | -94.06755609 | 2021-07-30 04:21:34 | Crow Wing, Minnesota, US | |
2021-06-17 | US | Kentucky | McCracken | 21145 | 6912 | 131 | 0 | 37.05350953 | -88.70445755 | 2021-06-18 04:22:16 | McCracken, Kentucky, US | |
2021-04-27 | India | Dadra and Nagar Haveli and Daman and Diu | 6912 | 4 | 4883 | 2025 | 20.194742 | 73.080901 | 2021-04-28 04:20:32 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-04-17 | US | Kentucky | Bullitt | 21029 | 6912 | 70 | 0 | 37.97162523 | -85.68955617 | 2021-04-18 04:20:41 | Bullitt, Kentucky, US | |
2021-04-07 | US | Puerto Rico | Carolina | 72031 | 6912 | 0 | 0 | 18.374986 | -65.95683100000001 | 2021-04-08 04:21:13 | Carolina, Puerto Rico, US | |
2021-03-14 | US | Maryland | Wicomico | 24045 | 6912 | 146 | 0 | 38.37301947 | -75.62705831 | 2021-03-15 05:25:51 | Wicomico, Maryland, US | |
2021-03-12 | US | Georgia | Rockdale | 13247 | 6912 | 157 | 0 | 33.65145002 | -84.02202167 | 2021-03-13 05:25:15 | Rockdale, Georgia, US | |
2021-03-08 | US | North Carolina | Rockingham | 37157 | 6912 | 61 | 0 | 36.39593137 | -79.77504841 | 2021-03-09 05:28:19 | Rockingham, North Carolina, US | |
2021-03-07 | US | Missouri | Christian | 29043 | 6912 | 80 | 0 | 36.9711783 | -93.18537118 | 2021-03-08 05:24:48 | Christian, Missouri, US | |
2021-02-05 | US | North Carolina | Brunswick | 37019 | 6912 | 105 | 0 | 6807 | 34.070565 | -78.22814204 | 2021-02-06 05:23:55 | Brunswick, North Carolina, US |
2021-01-05 | US | Ohio | Marion | 39101 | 6912 | 116 | 0 | 6796 | 40.58610662 | -83.15736305 | 2021-01-06 05:22:16 | Marion, Ohio, US |
2020-12-26 | US | Ohio | Portage | 39133 | 6912 | 115 | 0 | 6797 | 41.16793482 | -81.19735782 | 2020-12-27 05:22:55 | Portage, Ohio, US |
2020-12-15 | Eswatini | 6912 | 132 | 6476 | 304 | -26.5225 | 31.4659 | 2020-12-16 05:28:04 | Eswatini | |||
2020-12-10 | US | Michigan | Calhoun | 26025 | 6912 | 145 | 0 | 6767 | 42.24633834 | -85.00493569 | 2020-12-11 05:26:59 | Calhoun, Michigan, US |
2020-12-10 | Sweden | Sormland | 6912 | 286 | 0 | 6626 | 59.0336 | 16.7519 | 2020-12-11 05:26:59 | Sormland, Sweden | ||
2020-11-30 | US | Tennessee | Montgomery | 47125 | 6912 | 85 | 0 | 6830 | 36.49609412 | -87.38550661 | 2020-12-01 05:26:18 | Montgomery, Tennessee, US |
2020-11-17 | US | Ohio | Warren | 39165 | 6912 | 87 | 0 | 6825 | 39.42581994 | -84.16557457 | 2020-11-18 05:40:31 | Warren, Ohio, US |
2020-10-15 | US | Alabama | Shelby | 1117 | 6912 | 60 | 0 | 6852 | 33.26879845 | -86.66232561 | 2020-10-16 04:24:01 | Shelby, Alabama, US |
2020-09-22 | US | Oregon | Multnomah | 41051 | 6912 | 133 | 0 | 6779 | 45.54747959 | -122.4169351 | 2020-09-23 04:23:00 | Multnomah, Oregon, US |
2020-09-21 | Mozambique | 6912 | 44 | 3738 | 3130 | -18.665695 | 35.529562 | 2020-09-22 04:23:00 | Mozambique | |||
2020-09-18 | US | Missouri | Jackson | 29095 | 6912 | 92 | 0 | 6820 | 39.01002188 | -94.34724536 | 2020-09-19 04:22:00 | Jackson, Missouri, US |
2020-09-05 | Chile | Arica y Parinacota | 6912 | 115 | 6289 | 508 | -18.594 | -69.4785 | 2020-09-06 04:28:33 | Arica y Parinacota, Chile | ||
2020-08-24 | Maldives | 6912 | 27 | 4297 | 2588 | 3.2028 | 73.2207 | 2020-08-25 04:28:02 | Maldives | |||
2020-08-23 | US | Florida | Brevard | 12009 | 6912 | 195 | 0 | 6717 | 28.29409504 | -80.73091022 | 2020-08-24 04:27:56 | Brevard, Florida, US |
2020-07-15 | Russia | Krasnodar Krai | 6912 | 89 | 5877 | 946 | 45.768401399999995 | 39.0261044 | 2020-07-16 04:44:59 | Krasnodar Krai, Russia | ||
2020-06-28 | Russia | Chelyabinsk Oblast | 6912 | 88 | 3615 | 3209 | 54.4223954 | 61.1865846 | 2020-06-29 04:33:44 | Chelyabinsk Oblast, Russia | ||
2020-06-10 | US | New Jersey | Camden | 34007 | 6912 | 394 | 0 | 6518 | 39.80343818 | -74.96388753 | 2020-06-11 03:33:41 | Camden, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;