johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
136 rows where confirmed = 6736 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954303 | 2954303 | 2022-12-20 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-21 04:21:03 | Yankton, South Dakota, US | |
3176705 | 3176705 | 2022-12-19 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-20 04:21:04 | Yankton, South Dakota, US | |
1631222 | 1631222 | 2022-12-18 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-19 04:21:03 | Yankton, South Dakota, US | |
506601 | 506601 | 2022-12-17 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-18 04:21:03 | Yankton, South Dakota, US | |
3327173 | 3327173 | 2022-12-16 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-17 04:21:04 | Yankton, South Dakota, US | |
545685 | 545685 | 2022-12-15 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-16 04:21:01 | Yankton, South Dakota, US | |
544337 | 544337 | 2022-12-15 | US | Maine | Sagadahoc | 23023 | 6736 | 42 | 0 | 43.95415864 | -69.85074999 | 2022-12-16 04:21:01 | Sagadahoc, Maine, US | |
351213 | 351213 | 2022-12-14 | US | South Dakota | Yankton | 46135 | 6736 | 60 | 0 | 43.00924485 | -97.39467635 | 2022-12-15 04:20:58 | Yankton, South Dakota, US | |
1985293 | 1985293 | 2022-12-07 | US | Colorado | Morgan | 8087 | 6736 | 141 | 0 | 40.2627981 | -103.8093302 | 2022-12-08 04:21:07 | Morgan, Colorado, US | |
2100330 | 2100330 | 2022-11-26 | Russia | Chukotka Autonomous Okrug | 6736 | 44 | 0 | 66.0006475 | 169.4900869 | 2022-11-27 04:21:05 | Chukotka Autonomous Okrug, Russia | |||
3598980 | 3598980 | 2022-11-14 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-15 04:21:16 | Miller, Missouri, US | |
313838 | 313838 | 2022-11-13 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-14 04:21:09 | Miller, Missouri, US | |
64999 | 64999 | 2022-11-12 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-13 04:21:14 | Miller, Missouri, US | |
2929161 | 2929161 | 2022-11-11 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-12 04:20:41 | Miller, Missouri, US | |
2507997 | 2507997 | 2022-11-10 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-11 04:21:22 | Miller, Missouri, US | |
2432872 | 2432872 | 2022-11-09 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-10 04:21:16 | Miller, Missouri, US | |
481528 | 481528 | 2022-11-08 | US | Missouri | Miller | 29131 | 6736 | 126 | 0 | 38.21450288 | -92.42610898 | 2022-11-09 04:21:22 | Miller, Missouri, US | |
481176 | 481176 | 2022-11-08 | US | Maryland | Garrett | 24023 | 6736 | 119 | 0 | 39.52786077 | -79.27355126 | 2022-11-09 04:21:22 | Garrett, Maryland, US | |
2440326 | 2440326 | 2022-11-07 | US | Maryland | Garrett | 24023 | 6736 | 119 | 0 | 39.52786077 | -79.27355126 | 2022-11-08 04:21:21 | Garrett, Maryland, US | |
852542 | 852542 | 2022-11-02 | US | Tennessee | Fentress | 47049 | 6736 | 136 | 0 | 36.38128818 | -84.92870012 | 2022-11-03 04:22:05 | Fentress, Tennessee, US | |
2273518 | 2273518 | 2022-10-20 | US | Maryland | Talbot | 24041 | 6736 | 102 | 0 | 38.76618159 | -76.10882561 | 2022-10-21 04:22:23 | Talbot, Maryland, US | |
3251320 | 3251320 | 2022-10-11 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-12 04:22:51 | Buena Vista, Iowa, US | |
2968579 | 2968579 | 2022-10-10 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-11 04:23:05 | Buena Vista, Iowa, US | |
3098615 | 3098615 | 2022-10-09 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-10 04:22:32 | Buena Vista, Iowa, US | |
4003840 | 4003840 | 2022-10-08 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-09 04:21:16 | Buena Vista, Iowa, US | |
397437 | 397437 | 2022-10-07 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-08 04:22:56 | Buena Vista, Iowa, US | |
2530554 | 2530554 | 2022-10-06 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-07 04:23:08 | Buena Vista, Iowa, US | |
1811948 | 1811948 | 2022-10-05 | US | Iowa | Buena Vista | 19021 | 6736 | 61 | 0 | 42.73545875 | -95.15100162 | 2022-10-06 04:21:22 | Buena Vista, Iowa, US | |
3996474 | 3996474 | 2022-09-27 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-28 04:23:01 | Newton, Mississippi, US | |
2770802 | 2770802 | 2022-09-26 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-27 04:23:01 | Newton, Mississippi, US | |
1978455 | 1978455 | 2022-09-25 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-26 04:20:52 | Newton, Mississippi, US | |
2651622 | 2651622 | 2022-09-24 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-25 04:23:31 | Newton, Mississippi, US | |
386062 | 386062 | 2022-09-23 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-24 04:21:40 | Newton, Mississippi, US | |
1626128 | 1626128 | 2022-09-22 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-23 04:23:13 | Newton, Mississippi, US | |
1373828 | 1373828 | 2022-09-21 | US | Virginia | Dinwiddie | 51053 | 6736 | 101 | 0 | 37.07544585 | -77.63451754 | 2022-09-22 04:22:56 | Dinwiddie, Virginia, US | |
1372332 | 1372332 | 2022-09-21 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-22 04:22:56 | Newton, Mississippi, US | |
2018562 | 2018562 | 2022-09-20 | US | Mississippi | Newton | 28101 | 6736 | 100 | 0 | 32.40021118 | -89.11843336 | 2022-09-21 04:23:22 | Newton, Mississippi, US | |
2635171 | 2635171 | 2022-09-05 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-06 04:21:02 | Meade, Kentucky, US | |
2988735 | 2988735 | 2022-09-04 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-05 04:21:01 | Meade, Kentucky, US | |
2714420 | 2714420 | 2022-09-03 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-04 04:21:22 | Meade, Kentucky, US | |
1395125 | 1395125 | 2022-09-02 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-03 04:21:04 | Meade, Kentucky, US | |
3548954 | 3548954 | 2022-09-01 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-02 04:21:07 | Meade, Kentucky, US | |
2344874 | 2344874 | 2022-08-31 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-09-01 04:21:03 | Meade, Kentucky, US | |
3775354 | 3775354 | 2022-08-30 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-08-31 04:20:57 | Meade, Kentucky, US | |
3775176 | 3775176 | 2022-08-30 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-31 04:20:57 | Cherokee, Kansas, US | |
1681950 | 1681950 | 2022-08-29 | US | Kentucky | Meade | 21163 | 6736 | 67 | 0 | 37.96163597 | -86.21028219 | 2022-08-30 04:21:03 | Meade, Kentucky, US | |
1681772 | 1681772 | 2022-08-29 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-30 04:21:03 | Cherokee, Kansas, US | |
1878256 | 1878256 | 2022-08-28 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-29 04:21:06 | Cherokee, Kansas, US | |
2097383 | 2097383 | 2022-08-27 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-28 04:21:02 | Cherokee, Kansas, US | |
1533198 | 1533198 | 2022-08-26 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-27 04:20:57 | Cherokee, Kansas, US | |
2830085 | 2830085 | 2022-08-25 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-26 04:21:02 | Cherokee, Kansas, US | |
2324618 | 2324618 | 2022-08-24 | US | Kansas | Cherokee | 20021 | 6736 | 89 | 0 | 37.16928494 | -94.8462897 | 2022-08-25 04:21:13 | Cherokee, Kansas, US | |
882517 | 882517 | 2022-08-05 | US | New York | Essex | 36031 | 6736 | 65 | 0 | 44.11630765 | -73.77297842 | 2022-08-06 04:20:56 | Essex, New York, US | |
2338331 | 2338331 | 2022-07-27 | US | Tennessee | DeKalb | 47041 | 6736 | 103 | 0 | 35.97616272 | -85.83689361 | 2022-07-28 04:20:56 | DeKalb, Tennessee, US | |
1488850 | 1488850 | 2022-07-26 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-27 04:21:04 | Barton, Kansas, US | |
2595296 | 2595296 | 2022-07-25 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-26 04:20:58 | Barton, Kansas, US | |
897411 | 897411 | 2022-07-24 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-25 04:20:51 | Barton, Kansas, US | |
92405 | 92405 | 2022-07-23 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-24 04:20:47 | Barton, Kansas, US | |
901427 | 901427 | 2022-07-22 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-23 04:20:53 | Barton, Kansas, US | |
671563 | 671563 | 2022-07-21 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-22 04:21:15 | Barton, Kansas, US | |
1609526 | 1609526 | 2022-07-20 | US | Kansas | Barton | 20009 | 6736 | 107 | 0 | 38.47889676 | -98.75636726 | 2022-07-21 04:21:10 | Barton, Kansas, US | |
3081659 | 3081659 | 2022-07-04 | US | Wisconsin | Waushara | 55137 | 6736 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-07-05 04:20:45 | Waushara, Wisconsin, US | |
560679 | 560679 | 2022-06-16 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-17 04:20:56 | Barry, Missouri, US | |
560543 | 560543 | 2022-06-16 | US | Minnesota | Le Sueur | 27079 | 6736 | 51 | 0 | 44.37136597 | -93.72844721 | 2022-06-17 04:20:56 | Le Sueur, Minnesota, US | |
3984481 | 3984481 | 2022-06-15 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-16 04:20:55 | Barry, Missouri, US | |
948722 | 948722 | 2022-06-14 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-15 04:20:54 | Barry, Missouri, US | |
2981130 | 2981130 | 2022-06-13 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-14 04:20:52 | Barry, Missouri, US | |
2237256 | 2237256 | 2022-06-12 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-13 04:21:14 | Barry, Missouri, US | |
3143454 | 3143454 | 2022-06-11 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-12 04:20:53 | Barry, Missouri, US | |
1946370 | 1946370 | 2022-06-10 | US | Missouri | Barry | 29009 | 6736 | 142 | 0 | 36.70978521 | -93.82919888 | 2022-06-11 04:21:01 | Barry, Missouri, US | |
2535593 | 2535593 | 2022-05-12 | US | New Mexico | Grant | 35017 | 6736 | 90 | 0 | 32.73911281 | -108.3827845 | 2022-05-13 04:20:51 | Grant, New Mexico, US | |
1699702 | 1699702 | 2022-04-28 | US | Virginia | Louisa | 51109 | 6736 | 84 | 0 | 37.97850256 | -77.96274807 | 2022-04-29 04:20:59 | Louisa, Virginia, US | |
1950176 | 1950176 | 2022-04-12 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-13 04:21:03 | Mason, Michigan, US | |
3207929 | 3207929 | 2022-04-11 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-12 04:20:49 | Mason, Michigan, US | |
1577815 | 1577815 | 2022-04-10 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-11 04:21:02 | Mason, Michigan, US | |
1654057 | 1654057 | 2022-04-09 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-10 04:20:52 | Mason, Michigan, US | |
2117379 | 2117379 | 2022-04-08 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-09 04:20:42 | Mason, Michigan, US | |
3321903 | 3321903 | 2022-04-07 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-08 04:20:48 | Mason, Michigan, US | |
2802439 | 2802439 | 2022-04-06 | US | Michigan | Mason | 26105 | 6736 | 91 | 0 | 43.99509218 | -86.24988902 | 2022-04-07 04:20:53 | Mason, Michigan, US | |
698003 | 698003 | 2022-03-17 | US | Wyoming | Park | 56029 | 6736 | 140 | 0 | 44.52157546 | -109.58528249999999 | 2022-03-18 04:20:55 | Park, Wyoming, US | |
2322946 | 2322946 | 2022-03-16 | US | Wyoming | Park | 56029 | 6736 | 140 | 0 | 44.52157546 | -109.58528249999999 | 2022-03-17 04:20:56 | Park, Wyoming, US | |
265146 | 265146 | 2022-03-15 | US | Wyoming | Park | 56029 | 6736 | 140 | 0 | 44.52157546 | -109.58528249999999 | 2022-03-16 04:20:50 | Park, Wyoming, US | |
1060792 | 1060792 | 2022-02-23 | US | Tennessee | Grainger | 47057 | 6736 | 102 | 0 | 36.27469206 | -83.51254721 | 2022-02-24 04:21:14 | Grainger, Tennessee, US | |
187146 | 187146 | 2022-02-13 | US | Indiana | Clay | 18021 | 6736 | 79 | 0 | 39.39561833 | -87.11723506 | 2022-02-14 04:20:51 | Clay, Indiana, US | |
186859 | 186859 | 2022-02-13 | US | Georgia | Dawson | 13085 | 6736 | 93 | 0 | 34.44244079 | -84.16964071 | 2022-02-14 04:20:51 | Dawson, Georgia, US | |
316992 | 316992 | 2022-02-12 | US | Indiana | Clay | 18021 | 6736 | 79 | 0 | 39.39561833 | -87.11723506 | 2022-02-13 04:21:00 | Clay, Indiana, US | |
316705 | 316705 | 2022-02-12 | US | Georgia | Dawson | 13085 | 6736 | 93 | 0 | 34.44244079 | -84.16964071 | 2022-02-13 04:21:00 | Dawson, Georgia, US | |
234318 | 234318 | 2022-02-11 | US | Indiana | Clay | 18021 | 6736 | 79 | 0 | 39.39561833 | -87.11723506 | 2022-02-12 04:21:06 | Clay, Indiana, US | |
234031 | 234031 | 2022-02-11 | US | Georgia | Dawson | 13085 | 6736 | 93 | 0 | 34.44244079 | -84.16964071 | 2022-02-12 04:21:06 | Dawson, Georgia, US | |
1365127 | 1365127 | 2022-02-08 | US | Puerto Rico | Rio Grande | 72119 | 6736 | 0 | 0 | 18.346329 | -65.813742 | 2022-02-09 04:21:04 | Rio Grande, Puerto Rico, US | |
3300737 | 3300737 | 2022-01-30 | US | Arkansas | St. Francis | 5123 | 6736 | 75 | 0 | 35.02201976 | -90.74828138 | 2022-01-31 04:21:09 | St. Francis, Arkansas, US | |
3062528 | 3062528 | 2022-01-29 | US | Arkansas | St. Francis | 5123 | 6736 | 75 | 0 | 35.02201976 | -90.74828138 | 2022-01-30 04:21:26 | St. Francis, Arkansas, US | |
3810462 | 3810462 | 2022-01-28 | US | Arkansas | St. Francis | 5123 | 6736 | 75 | 0 | 35.02201976 | -90.74828138 | 2022-01-29 04:21:10 | St. Francis, Arkansas, US | |
3690184 | 3690184 | 2022-01-13 | US | Pennsylvania | Tioga | 42117 | 6736 | 176 | 0 | 41.77255149 | -77.25433032 | 2022-01-14 04:21:54 | Tioga, Pennsylvania, US | |
152297 | 152297 | 2021-11-29 | US | North Carolina | Davie | 37059 | 6736 | 81 | 0 | 35.93099927 | -80.54496571 | 2021-11-30 04:22:53 | Davie, North Carolina, US | |
3072184 | 3072184 | 2021-11-23 | US | New Hampshire | Cheshire | 33005 | 6736 | 55 | 0 | 42.92015988 | -72.25311043 | 2021-11-24 04:22:14 | Cheshire, New Hampshire, US | |
699495 | 699495 | 2021-11-04 | US | Indiana | Gibson | 18051 | 6736 | 115 | 0 | 38.30393723 | -87.58054938 | 2021-11-05 04:21:54 | Gibson, Indiana, US | |
278420 | 278420 | 2021-11-03 | US | New York | Fulton | 36035 | 6736 | 104 | 0 | 43.11363907 | -74.41798804 | 2021-11-04 04:22:20 | Fulton, New York, US | |
3494013 | 3494013 | 2021-10-26 | US | Mississippi | Pontotoc | 28115 | 6736 | 104 | 0 | 34.226046000000004 | -89.03636807 | 2021-10-27 04:22:32 | Pontotoc, Mississippi, US | |
2460261 | 2460261 | 2021-10-06 | US | Kentucky | Shelby | 21211 | 6736 | 98 | 0 | 38.21476019 | -85.194223 | 2021-10-07 04:21:36 | Shelby, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);