daily_reports (view)
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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2022-12-12 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-13 04:21:01 | McDonald, Missouri, US | |
2022-12-11 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-12 04:21:01 | McDonald, Missouri, US | |
2022-12-10 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-11 04:20:50 | McDonald, Missouri, US | |
2022-12-09 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-10 04:21:02 | McDonald, Missouri, US | |
2022-12-08 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-09 04:21:05 | McDonald, Missouri, US | |
2022-12-07 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-08 04:21:07 | McDonald, Missouri, US | |
2022-12-06 | US | Missouri | McDonald | 29119 | 6042 | 78 | 0 | 36.62869595 | -94.34867205 | 2022-12-07 04:20:58 | McDonald, Missouri, US | |
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 | |
2022-11-15 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-16 04:21:09 | Pickens, Alabama, US | |
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 | |
2022-11-14 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-15 04:21:16 | Pickens, Alabama, US | |
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 | |
2022-11-13 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-14 04:21:09 | Pickens, Alabama, US | |
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 | |
2022-11-12 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-13 04:21:14 | Pickens, Alabama, US | |
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 | |
2022-11-11 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-12 04:20:41 | Pickens, Alabama, US | |
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 | |
2022-11-10 | US | Alabama | Pickens | 1107 | 6042 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-11-11 04:21:22 | Pickens, Alabama, US | |
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 | |
2022-10-11 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-12 04:22:51 | Wyoming, Pennsylvania, US | |
2022-10-10 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-11 04:23:05 | Wyoming, Pennsylvania, US | |
2022-10-09 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-10 04:22:32 | Wyoming, Pennsylvania, US | |
2022-10-08 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-09 04:21:16 | Wyoming, Pennsylvania, US | |
2022-10-07 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-08 04:22:56 | Wyoming, Pennsylvania, US | |
2022-10-06 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-07 04:23:08 | Wyoming, Pennsylvania, US | |
2022-10-05 | US | Pennsylvania | Wyoming | 42131 | 6042 | 115 | 0 | 41.51955538 | -76.01074915 | 2022-10-06 04:21:22 | Wyoming, Pennsylvania, US | |
2022-09-20 | US | Wisconsin | Vilas | 55125 | 6042 | 99 | 0 | 46.05467334 | -89.51719204 | 2022-09-21 04:23:22 | Vilas, Wisconsin, US | |
2022-09-06 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-07 04:20:59 | Fountain, Indiana, US | |
2022-09-05 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-06 04:21:02 | Fountain, Indiana, US | |
2022-09-05 | US | Arkansas | Clark | 5019 | 6042 | 86 | 0 | 34.04613432 | -93.17484713 | 2022-09-06 04:21:02 | Clark, Arkansas, US | |
2022-09-04 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-05 04:21:01 | Fountain, Indiana, US | |
2022-09-03 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-04 04:21:22 | Fountain, Indiana, US | |
2022-09-02 | US | Indiana | Fountain | 18045 | 6042 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-09-03 04:21:04 | Fountain, Indiana, US | |
2022-08-01 | US | Tennessee | Wayne | 47181 | 6042 | 74 | 0 | 35.23868267 | -87.78644456 | 2022-08-02 04:20:53 | Wayne, Tennessee, US | |
2022-07-31 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-08-01 04:21:03 | Cook Islands, New Zealand | |||
2022-07-30 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-31 04:21:02 | Cook Islands, New Zealand | |||
2022-07-29 | New Zealand | Cook Islands | 6042 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-30 04:20:42 | Cook Islands, New Zealand | |||
2022-07-28 | US | Maine | Lincoln | 23015 | 6042 | 38 | 0 | 44.05996956 | -69.54227124 | 2022-07-29 04:20:45 | Lincoln, Maine, US | |
2022-07-21 | US | Tennessee | Fentress | 47049 | 6042 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-07-22 04:21:15 | Fentress, Tennessee, US | |
2022-07-02 | US | Colorado | Morgan | 8087 | 6042 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-03 04:20:59 | Morgan, Colorado, US | |
2022-05-12 | US | Idaho | Jefferson | 16051 | 6042 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-13 04:20:51 | Jefferson, Idaho, US | |
2022-05-11 | US | Idaho | Jefferson | 16051 | 6042 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-05-12 04:20:54 | Jefferson, Idaho, US | |
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 | |
2022-04-11 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-12 04:20:49 | Waldo, Maine, US | |
2022-04-10 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-11 04:21:02 | Waldo, Maine, US | |
2022-04-09 | US | Maine | Waldo | 23027 | 6042 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-10 04:20:52 | Waldo, Maine, US | |
2022-03-31 | US | Virginia | Mecklenburg | 51117 | 6042 | 116 | 0 | 36.67882005 | -78.36131056 | 2022-04-01 04:20:28 | Mecklenburg, Virginia, US | |
2022-03-30 | US | Maryland | Caroline | 24011 | 6042 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-03-31 04:20:56 | Caroline, Maryland, US | |
2022-03-24 | US | Georgia | Harris | 13145 | 6042 | 110 | 0 | 32.73709786 | -84.90538572 | 2022-03-25 04:20:46 | Harris, Georgia, US | |
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 | |
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 | |
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 | |
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 | |
2022-02-17 | US | Kentucky | Lincoln | 21137 | 6042 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-18 04:21:04 | Lincoln, Kentucky, US | |
2022-02-13 | US | Colorado | Montezuma | 8083 | 6042 | 73 | 0 | 37.33859579 | -108.59588570000001 | 2022-02-14 04:20:51 | Montezuma, Colorado, US | |
2022-01-25 | US | Arkansas | Johnson | 5071 | 6042 | 65 | 0 | 35.56759135 | -93.46036368 | 2022-01-26 04:21:07 | Johnson, Arkansas, US | |
2022-01-17 | US | Vermont | Windsor | 50027 | 6042 | 46 | 0 | 43.58010937 | -72.58595157 | 2022-01-18 04:21:04 | Windsor, Vermont, US | |
2022-01-16 | US | Vermont | Windsor | 50027 | 6042 | 46 | 0 | 43.58010937 | -72.58595157 | 2022-01-17 04:21:08 | Windsor, Vermont, US | |
2021-12-16 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-17 04:22:14 | Baker, Florida, US | |
2021-12-15 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-16 04:22:11 | Baker, Florida, US | |
2021-12-14 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-15 03:22:16 | Baker, Florida, US | |
2021-12-13 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-14 04:22:38 | Baker, Florida, US | |
2021-12-12 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-13 04:22:02 | Baker, Florida, US | |
2021-12-11 | US | Texas | Polk | 48373 | 6042 | 219 | 0 | 30.79472531 | -94.82766240000001 | 2021-12-12 04:22:12 | Polk, Texas, US | |
2021-12-11 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-12 04:22:12 | Baker, Florida, US | |
2021-12-10 | US | Florida | Baker | 12003 | 6042 | 62 | 0 | 30.33060121 | -82.28467476 | 2021-12-11 04:22:45 | Baker, Florida, US | |
2021-12-07 | US | Kentucky | Muhlenberg | 21177 | 6042 | 97 | 0 | 37.21425819 | -87.14632053 | 2021-12-08 04:22:46 | Muhlenberg, Kentucky, US | |
2021-11-09 | US | Michigan | Delta | 26041 | 6042 | 111 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-10 04:21:38 | Delta, Michigan, US | |
2021-11-08 | US | Michigan | Delta | 26041 | 6042 | 111 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-09 04:21:36 | Delta, Michigan, US | |
2021-11-06 | US | Missouri | Platte | 29165 | 6042 | 61 | 0 | 39.38154439 | -94.77068479 | 2021-11-07 04:21:53 | Platte, Missouri, US | |
2021-10-16 | US | Pennsylvania | Venango | 42121 | 6042 | 126 | 0 | 41.40323442 | -79.75845449 | 2021-10-17 04:21:29 | Venango, Pennsylvania, US | |
2021-10-12 | US | Texas | Matagorda | 48321 | 6042 | 151 | 0 | 28.81955746 | -96.01230294 | 2021-10-13 04:20:51 | Matagorda, Texas, US | |
2021-10-04 | Niger | 6042 | 203 | 0 | 17.607789 | 8.081666 | 2021-10-05 04:21:27 | Niger | ||||
2021-10-03 | Niger | 6042 | 203 | 0 | 17.607789 | 8.081666 | 2021-10-04 04:21:31 | Niger | ||||
2021-09-17 | US | Indiana | Gibson | 18051 | 6042 | 106 | 0 | 38.30393723 | -87.58054938 | 2021-09-18 04:21:24 | Gibson, Indiana, US | |
2021-09-15 | US | California | Tuolumne | 6109 | 6042 | 89 | 0 | 38.02644018 | -119.95250929999999 | 2021-09-16 04:22:19 | Tuolumne, California, US | |
2021-09-15 | Guinea-Bissau | 6042 | 130 | 0 | 11.8037 | -15.1804 | 2021-09-16 04:22:19 | Guinea-Bissau | ||||
2021-09-05 | US | Tennessee | Cocke | 47029 | 6042 | 103 | 0 | 35.9278914 | -83.11828725 | 2021-09-06 04:21:22 | Cocke, Tennessee, US | |
2021-09-02 | Canada | Nova Scotia | 6042 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-03 04:21:20 | Nova Scotia, Canada | |||
2021-08-26 | US | Texas | Wilson | 48493 | 6042 | 79 | 0 | 29.1732598 | -98.08693082 | 2021-08-27 04:21:37 | Wilson, Texas, US | |
2021-08-25 | US | Georgia | Thomas | 13275 | 6042 | 137 | 0 | 30.86392347 | -83.91847289 | 2021-08-26 04:21:28 | Thomas, Georgia, US | |
2021-08-23 | US | Kentucky | Nelson | 21179 | 6042 | 64 | 0 | 37.80335779 | -85.4657193 | 2021-08-24 04:21:19 | Nelson, Kentucky, US | |
2021-08-21 | US | Ohio | Jefferson | 39081 | 6042 | 168 | 0 | 40.38614126 | -80.76259514 | 2021-08-22 04:21:29 | Jefferson, Ohio, US | |
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 | |
2021-08-07 | US | Texas | Nacogdoches | 48347 | 6042 | 176 | 0 | 31.62017125 | -94.61803994 | 2021-08-08 04:21:33 | Nacogdoches, Texas, US | |
2021-07-22 | US | Kentucky | Pike | 21195 | 6042 | 112 | 0 | 37.47088263 | -82.39487445 | 2021-07-23 04:21:29 | Pike, Kentucky, US | |
2021-06-22 | US | Pennsylvania | Armstrong | 42005 | 6042 | 148 | 0 | 40.81665618 | -79.46290811 | 2021-06-23 04:21:46 | Armstrong, Pennsylvania, US | |
2021-05-17 | US | Minnesota | Chisago | 27025 | 6042 | 51 | 0 | 45.5021011 | -92.90861945 | 2021-05-18 04:20:33 | Chisago, Minnesota, US | |
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 | |
2021-04-27 | US | Kansas | Finney | 20055 | 6042 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-04-28 04:20:32 | Finney, Kansas, US | |
2021-04-26 | US | Kansas | Finney | 20055 | 6042 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-04-27 04:20:52 | Finney, Kansas, US | |
2021-04-06 | US | Indiana | Dubois | 18037 | 6042 | 116 | 0 | 38.36597551 | -86.87924170000002 | 2021-04-07 04:20:53 | Dubois, Indiana, US | |
2021-03-29 | US | Mississippi | Lamar | 28073 | 6042 | 84 | 0 | 31.20572971 | -89.5077704 | 2021-03-30 04:26:23 | Lamar, Mississippi, US | |
2021-03-18 | US | Kentucky | McCracken | 21145 | 6042 | 97 | 0 | 37.05350953 | -88.70445755 | 2021-03-19 05:26:09 | McCracken, Kentucky, US | |
2021-03-18 | US | Kansas | Saline | 20169 | 6042 | 131 | 0 | 38.78369175 | -97.65185177 | 2021-03-19 05:26:09 | Saline, Kansas, US | |
2021-03-17 | US | Kansas | Saline | 20169 | 6042 | 131 | 0 | 38.78369175 | -97.65185177 | 2021-03-18 05:26:22 | Saline, Kansas, US | |
2021-03-08 | US | Oregon | Deschutes | 41017 | 6042 | 65 | 0 | 43.91570171 | -121.2289121 | 2021-03-09 05:28:19 | Deschutes, Oregon, US | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;