johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
123 rows where confirmed = 6042 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 105
- Russia 4
- New Zealand 3
- Niger 2
- Canada 1
- Colombia 1
- Guinea-Bissau 1
- Guyana 1
- Italy 1
- Jordan 1
- Malaysia 1
- Malta 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
506464 | 506464 | 2022-12-17 | US | Puerto Rico | Sabana Grande | 72121 | 6042 | 0 | 0 | 18.08282 | -66.943758 | 2022-12-18 04:21:03 | Sabana Grande, Puerto Rico, US | |
1150881 | 1150881 | 2022-12-12 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-13 04:21:01 | McDonald, Missouri, US | |
870735 | 870735 | 2022-12-11 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-12 04:21:01 | McDonald, Missouri, US | |
259265 | 259265 | 2022-12-10 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-11 04:20:50 | McDonald, Missouri, US | |
3937979 | 3937979 | 2022-12-09 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-10 04:21:02 | McDonald, Missouri, US | |
3379311 | 3379311 | 2022-12-08 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-09 04:21:05 | McDonald, Missouri, US | |
1986582 | 1986582 | 2022-12-07 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-08 04:21:07 | McDonald, Missouri, US | |
3716105 | 3716105 | 2022-12-06 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-07 04:20:58 | McDonald, Missouri, US | |
294357 | 294357 | 2022-11-15 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-16 04:21:09 | Madison, North Carolina, US | |
292415 | 292415 | 2022-11-15 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-16 04:21:09 | Pickens, Alabama, US | |
3599387 | 3599387 | 2022-11-14 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-15 04:21:16 | Madison, North Carolina, US | |
3597445 | 3597445 | 2022-11-14 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-15 04:21:16 | Pickens, Alabama, US | |
314245 | 314245 | 2022-11-13 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-14 04:21:09 | Madison, North Carolina, US | |
312303 | 312303 | 2022-11-13 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-14 04:21:09 | Pickens, Alabama, US | |
65406 | 65406 | 2022-11-12 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-13 04:21:14 | Madison, North Carolina, US | |
63464 | 63464 | 2022-11-12 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-13 04:21:14 | Pickens, Alabama, US | |
2929568 | 2929568 | 2022-11-11 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-12 04:20:41 | Madison, North Carolina, US | |
2927626 | 2927626 | 2022-11-11 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-12 04:20:41 | Pickens, Alabama, US | |
2508404 | 2508404 | 2022-11-10 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-11 04:21:22 | Madison, North Carolina, US | |
2506462 | 2506462 | 2022-11-10 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-11 04:21:22 | Pickens, Alabama, US | |
2433279 | 2433279 | 2022-11-09 | US | North Carolina | Madison | 37115 | 6042 | 85 | 0 | 35.85402722 | -82.71346418 | 2022-11-10 04:21:16 | Madison, North Carolina, US | |
3252863 | 3252863 | 2022-10-11 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-12 04:22:51 | Wyoming, Pennsylvania, US | |
2970122 | 2970122 | 2022-10-10 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-11 04:23:05 | Wyoming, Pennsylvania, US | |
3100158 | 3100158 | 2022-10-09 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-10 04:22:32 | Wyoming, Pennsylvania, US | |
4005383 | 4005383 | 2022-10-08 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-09 04:21:16 | Wyoming, Pennsylvania, US | |
398980 | 398980 | 2022-10-07 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-08 04:22:56 | Wyoming, Pennsylvania, US | |
2532097 | 2532097 | 2022-10-06 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-07 04:23:08 | Wyoming, Pennsylvania, US | |
1813491 | 1813491 | 2022-10-05 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-06 04:21:22 | Wyoming, Pennsylvania, US | |
2020318 | 2020318 | 2022-09-20 | US | Wisconsin | Vilas | 55125 | 6042 | 99 | 0 | 46.05467334 | -89.51719204 | 2022-09-21 04:23:22 | Vilas, Wisconsin, US | |
115840 | 115840 | 2022-09-06 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-07 04:20:59 | Fountain, Indiana, US | |
2634812 | 2634812 | 2022-09-05 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-06 04:21:02 | Fountain, Indiana, US | |
2634196 | 2634196 | 2022-09-05 | US | Arkansas | Clark | 5019 | 6042 | 86 | 0 | 34.04613432 | -93.17484713 | 2022-09-06 04:21:02 | Clark, Arkansas, US | |
2988376 | 2988376 | 2022-09-04 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-05 04:21:01 | Fountain, Indiana, US | |
2714061 | 2714061 | 2022-09-03 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-04 04:21:22 | Fountain, Indiana, US | |
1394766 | 1394766 | 2022-09-02 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-03 04:21:04 | Fountain, Indiana, US | |
3620089 | 3620089 | 2022-08-01 | US | Tennessee | Wayne | 47181 | 6042 | 74 | 0 | 35.23868267 | -87.78644456 | 2022-08-02 04:20:53 | Wayne, Tennessee, US | |
3871698 | 3871698 | 2022-07-31 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-08-01 04:21:03 | Cook Islands, New Zealand | |||
674452 | 674452 | 2022-07-30 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-31 04:21:02 | Cook Islands, New Zealand | |||
1783651 | 1783651 | 2022-07-29 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-30 04:20:42 | Cook Islands, New Zealand | |||
1067438 | 1067438 | 2022-07-28 | US | Maine | Lincoln | 23015 | 6042 | 38 | 0 | 44.05996956 | -69.54227124 | 2022-07-29 04:20:45 | Lincoln, Maine, US | |
673239 | 673239 | 2022-07-21 | US | Tennessee | Fentress | 47049 | 6042 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-07-22 04:21:15 | Fentress, Tennessee, US | |
3365973 | 3365973 | 2022-07-02 | US | Colorado | Morgan | 8087 | 6042 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-03 04:20:59 | Morgan, Colorado, US | |
2534339 | 2534339 | 2022-05-12 | US | Idaho | Jefferson | 16051 | 6042 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-13 04:20:51 | Jefferson, Idaho, US | |
3445785 | 3445785 | 2022-05-11 | US | Idaho | Jefferson | 16051 | 6042 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-12 04:20:54 | Jefferson, Idaho, US | |
3854554 | 3854554 | 2022-04-27 | US | Puerto Rico | Corozal | 72047 | 6042 | 0 | 0 | 18.304264 | -66.327738 | 2022-04-28 04:20:47 | Corozal, Puerto Rico, US | |
3207834 | 3207834 | 2022-04-11 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-12 04:20:49 | Waldo, Maine, US | |
1577720 | 1577720 | 2022-04-10 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-11 04:21:02 | Waldo, Maine, US | |
1653962 | 1653962 | 2022-04-09 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-10 04:20:52 | Waldo, Maine, US | |
1543334 | 1543334 | 2022-03-31 | US | Virginia | Mecklenburg | 51117 | 6042 | 116 | 0 | 36.67882005 | -78.36131056 | 2022-04-01 04:20:28 | Mecklenburg, Virginia, US | |
2479547 | 2479547 | 2022-03-30 | US | Maryland | Caroline | 24011 | 6042 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-03-31 04:20:56 | Caroline, Maryland, US | |
1468919 | 1468919 | 2022-03-24 | US | Georgia | Harris | 13145 | 6042 | 110 | 0 | 32.73709786 | -84.90538572 | 2022-03-25 04:20:46 | Harris, Georgia, US | |
2266233 | 2266233 | 2022-03-14 | US | North Carolina | Martin | 37117 | 6042 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-03-15 04:20:47 | Martin, North Carolina, US | |
2735396 | 2735396 | 2022-02-27 | US | North Carolina | Transylvania | 37175 | 6042 | 67 | 0 | 35.20383864 | -82.79638423 | 2022-02-28 04:21:05 | Transylvania, North Carolina, US | |
3048549 | 3048549 | 2022-02-26 | US | North Carolina | Transylvania | 37175 | 6042 | 67 | 0 | 35.20383864 | -82.79638423 | 2022-02-27 04:21:04 | Transylvania, North Carolina, US | |
577204 | 577204 | 2022-02-25 | US | North Carolina | Transylvania | 37175 | 6042 | 67 | 0 | 35.20383864 | -82.79638423 | 2022-02-26 04:21:12 | Transylvania, North Carolina, US | |
1299486 | 1299486 | 2022-02-17 | US | Kentucky | Lincoln | 21137 | 6042 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-18 04:21:04 | Lincoln, Kentucky, US | |
186711 | 186711 | 2022-02-13 | US | Colorado | Montezuma | 8083 | 6042 | 73 | 0 | 37.33859579 | -108.59588570000001 | 2022-02-14 04:20:51 | Montezuma, Colorado, US | |
2052380 | 2052380 | 2022-01-25 | US | Arkansas | Johnson | 5071 | 6042 | 65 | 0 | 35.56759135 | -93.46036368 | 2022-01-26 04:21:07 | Johnson, Arkansas, US | |
1475410 | 1475410 | 2022-01-17 | US | Vermont | Windsor | 50027 | 6042 | 46 | 0 | 43.58010937 | -72.58595157 | 2022-01-18 04:21:04 | Windsor, Vermont, US | |
558084 | 558084 | 2022-01-16 | US | Vermont | Windsor | 50027 | 6042 | 46 | 0 | 43.58010937 | -72.58595157 | 2022-01-17 04:21:08 | Windsor, Vermont, US | |
1717035 | 1717035 | 2021-12-16 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-17 04:22:14 | Baker, Florida, US | |
3496869 | 3496869 | 2021-12-15 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-16 04:22:11 | Baker, Florida, US | |
2088654 | 2088654 | 2021-12-14 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-15 03:22:16 | Baker, Florida, US | |
783071 | 783071 | 2021-12-13 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-14 04:22:38 | Baker, Florida, US | |
1661106 | 1661106 | 2021-12-12 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-13 04:22:02 | Baker, Florida, US | |
1667639 | 1667639 | 2021-12-11 | US | Texas | Polk | 48373 | 6042 | 219 | 0 | 30.79472531 | -94.82766240000001 | 2021-12-12 04:22:12 | Polk, Texas, US | |
1665122 | 1665122 | 2021-12-11 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-12 04:22:12 | Baker, Florida, US | |
3656274 | 3656274 | 2021-12-10 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-11 04:22:45 | Baker, Florida, US | |
405747 | 405747 | 2021-12-07 | US | Kentucky | Muhlenberg | 21177 | 6042 | 97 | 0 | 37.21425819 | -87.14632053 | 2021-12-08 04:22:46 | Muhlenberg, Kentucky, US | |
88754 | 88754 | 2021-11-09 | US | Michigan | Delta | 26041 | 6042 | 111 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-10 04:21:38 | Delta, Michigan, US | |
3641182 | 3641182 | 2021-11-08 | US | Michigan | Delta | 26041 | 6042 | 111 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-09 04:21:36 | Delta, Michigan, US | |
497602 | 497602 | 2021-11-06 | US | Missouri | Platte | 29165 | 6042 | 61 | 0 | 39.38154439 | -94.77068479 | 2021-11-07 04:21:53 | Platte, Missouri, US | |
937506 | 937506 | 2021-10-16 | US | Pennsylvania | Venango | 42121 | 6042 | 126 | 0 | 41.40323442 | -79.75845449 | 2021-10-17 04:21:29 | Venango, Pennsylvania, US | |
1494769 | 1494769 | 2021-10-12 | US | Texas | Matagorda | 48321 | 6042 | 151 | 0 | 28.81955746 | -96.01230294 | 2021-10-13 04:20:51 | Matagorda, Texas, US | |
987117 | 987117 | 2021-10-04 | Niger | 6042 | 203 | 0 | 17.607789 | 8.081666 | 2021-10-05 04:21:27 | Niger | ||||
1274427 | 1274427 | 2021-10-03 | Niger | 6042 | 203 | 0 | 17.607789 | 8.081666 | 2021-10-04 04:21:31 | Niger | ||||
2619127 | 2619127 | 2021-09-17 | US | Indiana | Gibson | 18051 | 6042 | 106 | 0 | 38.30393723 | -87.58054938 | 2021-09-18 04:21:24 | Gibson, Indiana, US | |
1375082 | 1375082 | 2021-09-15 | US | California | Tuolumne | 6109 | 6042 | 89 | 0 | 38.02644018 | -119.95250929999999 | 2021-09-16 04:22:19 | Tuolumne, California, US | |
1374422 | 1374422 | 2021-09-15 | Guinea-Bissau | 6042 | 130 | 0 | 11.8037 | -15.1804 | 2021-09-16 04:22:19 | Guinea-Bissau | ||||
3283793 | 3283793 | 2021-09-05 | US | Tennessee | Cocke | 47029 | 6042 | 103 | 0 | 35.9278914 | -83.11828725 | 2021-09-06 04:21:22 | Cocke, Tennessee, US | |
177797 | 177797 | 2021-09-02 | Canada | Nova Scotia | 6042 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-03 04:21:20 | Nova Scotia, Canada | |||
1599461 | 1599461 | 2021-08-26 | US | Texas | Wilson | 48493 | 6042 | 79 | 0 | 29.1732598 | -98.08693082 | 2021-08-27 04:21:37 | Wilson, Texas, US | |
33295 | 33295 | 2021-08-25 | US | Georgia | Thomas | 13275 | 6042 | 137 | 0 | 30.86392347 | -83.91847289 | 2021-08-26 04:21:28 | Thomas, Georgia, US | |
3167076 | 3167076 | 2021-08-23 | US | Kentucky | Nelson | 21179 | 6042 | 64 | 0 | 37.80335779 | -85.4657193 | 2021-08-24 04:21:19 | Nelson, Kentucky, US | |
3558125 | 3558125 | 2021-08-21 | US | Ohio | Jefferson | 39081 | 6042 | 168 | 0 | 40.38614126 | -80.76259514 | 2021-08-22 04:21:29 | Jefferson, Ohio, US | |
1606508 | 1606508 | 2021-08-16 | US | New York | Wayne | 36117 | 6042 | 73 | 0 | 43.15494365 | -77.02976528 | 2021-08-17 04:21:49 | Wayne, New York, US | |
2206820 | 2206820 | 2021-08-07 | US | Texas | Nacogdoches | 48347 | 6042 | 176 | 0 | 31.62017125 | -94.61803994 | 2021-08-08 04:21:33 | Nacogdoches, Texas, US | |
3477769 | 3477769 | 2021-07-22 | US | Kentucky | Pike | 21195 | 6042 | 112 | 0 | 37.47088263 | -82.39487445 | 2021-07-23 04:21:29 | Pike, Kentucky, US | |
565609 | 565609 | 2021-06-22 | US | Pennsylvania | Armstrong | 42005 | 6042 | 148 | 0 | 40.81665618 | -79.46290811 | 2021-06-23 04:21:46 | Armstrong, Pennsylvania, US | |
3576296 | 3576296 | 2021-05-17 | US | Minnesota | Chisago | 27025 | 6042 | 51 | 0 | 45.5021011 | -92.90861945 | 2021-05-18 04:20:33 | Chisago, Minnesota, US | |
2823573 | 2823573 | 2021-05-10 | US | South Carolina | Cherokee | 45021 | 6042 | 154 | 0 | 35.05122251 | -81.61828622 | 2021-05-11 04:20:41 | Cherokee, South Carolina, US | |
3703388 | 3703388 | 2021-04-27 | US | Kansas | Finney | 20055 | 6042 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-04-28 04:20:32 | Finney, Kansas, US | |
889397 | 889397 | 2021-04-26 | US | Kansas | Finney | 20055 | 6042 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-04-27 04:20:52 | Finney, Kansas, US | |
3004380 | 3004380 | 2021-04-06 | US | Indiana | Dubois | 18037 | 6042 | 116 | 0 | 38.36597551 | -86.87924170000002 | 2021-04-07 04:20:53 | Dubois, Indiana, US | |
1291816 | 1291816 | 2021-03-29 | US | Mississippi | Lamar | 28073 | 6042 | 84 | 0 | 31.20572971 | -89.5077704 | 2021-03-30 04:26:23 | Lamar, Mississippi, US | |
3454290 | 3454290 | 2021-03-18 | US | Kentucky | McCracken | 21145 | 6042 | 97 | 0 | 37.05350953 | -88.70445755 | 2021-03-19 05:26:09 | McCracken, Kentucky, US | |
3454190 | 3454190 | 2021-03-18 | US | Kansas | Saline | 20169 | 6042 | 131 | 0 | 38.78369175 | -97.65185177 | 2021-03-19 05:26:09 | Saline, Kansas, US | |
3622414 | 3622414 | 2021-03-17 | US | Kansas | Saline | 20169 | 6042 | 131 | 0 | 38.78369175 | -97.65185177 | 2021-03-18 05:26:22 | Saline, Kansas, US | |
2362073 | 2362073 | 2021-03-08 | US | Oregon | Deschutes | 41017 | 6042 | 65 | 0 | 43.91570171 | -121.2289121 | 2021-03-09 05:28:19 | Deschutes, Oregon, US | |
2187006 | 2187006 | 2021-02-26 | US | Washington | Chelan | 53007 | 6042 | 61 | 0 | 5981 | 47.87046092 | -120.6173956 | 2021-02-27 05:22:28 | Chelan, Washington, 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]);