daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
209 rows where confirmed = 3174 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-11 | US | Virginia | Lunenburg | 51111 | 3174 | 45 | 0 | 36.94618528 | -78.24133319 | 2022-12-12 04:21:01 | Lunenburg, Virginia, US | |
2022-12-10 | US | Virginia | Lunenburg | 51111 | 3174 | 45 | 0 | 36.94618528 | -78.24133319 | 2022-12-11 04:20:50 | Lunenburg, Virginia, US | |
2022-12-09 | US | Virginia | Lunenburg | 51111 | 3174 | 45 | 0 | 36.94618528 | -78.24133319 | 2022-12-10 04:21:02 | Lunenburg, Virginia, US | |
2022-10-19 | US | Wisconsin | Forest | 55041 | 3174 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-10-20 04:22:59 | Forest, Wisconsin, US | |
2022-10-13 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-14 04:22:28 | Barton, Missouri, US | |
2022-10-12 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-13 04:22:39 | Barton, Missouri, US | |
2022-10-11 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-12 04:22:51 | Barton, Missouri, US | |
2022-10-10 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-11 04:23:05 | Barton, Missouri, US | |
2022-10-09 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-10 04:22:32 | Barton, Missouri, US | |
2022-10-08 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-09 04:21:16 | Barton, Missouri, US | |
2022-10-07 | US | Missouri | Barton | 29011 | 3174 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-10-08 04:22:56 | Barton, Missouri, US | |
2022-09-22 | US | Virginia | Clarke | 51043 | 3174 | 54 | 0 | 39.11271747 | -77.99199425 | 2022-09-23 04:23:13 | Clarke, Virginia, US | |
2022-09-21 | US | Virginia | Clarke | 51043 | 3174 | 54 | 0 | 39.11271747 | -77.99199425 | 2022-09-22 04:22:56 | Clarke, Virginia, US | |
2022-08-22 | US | Arkansas | Lee | 5077 | 3174 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-08-23 04:20:56 | Lee, Arkansas, US | |
2022-08-16 | US | Texas | Camp | 48063 | 3174 | 76 | 0 | 32.97195142 | -94.97790104 | 2022-08-17 04:20:59 | Camp, Texas, US | |
2022-08-04 | US | West Virginia | Summers | 54089 | 3174 | 56 | 0 | 37.65390597 | -80.86009693 | 2022-08-05 04:20:52 | Summers, West Virginia, US | |
2022-08-01 | US | North Dakota | Barnes | 38003 | 3174 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-02 04:20:53 | Barnes, North Dakota, US | |
2022-07-18 | US | Arkansas | Bradley | 5011 | 3174 | 53 | 0 | 33.46755808 | -92.15980837 | 2022-07-19 04:20:58 | Bradley, Arkansas, US | |
2022-07-17 | US | Arkansas | Bradley | 5011 | 3174 | 53 | 0 | 33.46755808 | -92.15980837 | 2022-07-18 04:20:59 | Bradley, Arkansas, US | |
2022-07-16 | US | Arkansas | Bradley | 5011 | 3174 | 53 | 0 | 33.46755808 | -92.15980837 | 2022-07-17 04:21:15 | Bradley, Arkansas, US | |
2022-07-05 | US | Colorado | Park | 8093 | 3174 | 22 | 0 | 39.120926 | -105.7182065 | 2022-07-06 04:20:58 | Park, Colorado, US | |
2022-06-29 | Nauru | 3174 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-06-30 04:21:01 | Nauru | |||
2022-05-31 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-06-01 04:20:55 | Jasper, Georgia, US | |
2022-05-30 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-31 04:20:51 | Jasper, Georgia, US | |
2022-05-29 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-30 04:20:50 | Jasper, Georgia, US | |
2022-05-28 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-29 04:20:53 | Jasper, Georgia, US | |
2022-05-27 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-28 04:21:07 | Jasper, Georgia, US | |
2022-05-26 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-27 04:20:56 | Jasper, Georgia, US | |
2022-05-26 | China | Henan | 3174 | 22 | 0 | 33.882 | 113.614 | 2022-05-27 04:20:56 | Henan, China | |||
2022-05-25 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-26 04:20:50 | Jasper, Georgia, US | |
2022-05-25 | China | Henan | 3174 | 22 | 0 | 33.882 | 113.614 | 2022-05-26 04:20:50 | Henan, China | |||
2022-05-22 | US | Georgia | Jasper | 13159 | 3174 | 73 | 0 | 33.31535543 | -83.68844964 | 2022-05-26 04:20:50 | Jasper, Georgia, US | |
2022-05-22 | China | Henan | 3174 | 22 | 0 | 33.882 | 113.614 | 2022-05-26 04:20:50 | Henan, China | |||
2022-05-13 | US | New Jersey | Unassigned | 90034 | 3174 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-14 04:20:48 | Unassigned, New Jersey, US | |
2022-03-01 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-03-02 04:21:07 | Butler, Iowa, US | |
2022-02-28 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-03-01 04:21:09 | Butler, Iowa, US | |
2022-02-27 | US | Minnesota | Cottonwood | 27033 | 3174 | 40 | 0 | 44.00715262 | -95.18138802 | 2022-02-28 04:21:05 | Cottonwood, Minnesota, US | |
2022-02-27 | US | Kentucky | Martin | 21159 | 3174 | 45 | 0 | 37.79990579 | -82.51247478 | 2022-02-28 04:21:05 | Martin, Kentucky, US | |
2022-02-27 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-02-28 04:21:05 | Butler, Iowa, US | |
2022-02-26 | US | Minnesota | Cottonwood | 27033 | 3174 | 40 | 0 | 44.00715262 | -95.18138802 | 2022-02-27 04:21:04 | Cottonwood, Minnesota, US | |
2022-02-26 | US | Kentucky | Martin | 21159 | 3174 | 45 | 0 | 37.79990579 | -82.51247478 | 2022-02-27 04:21:04 | Martin, Kentucky, US | |
2022-02-26 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-02-27 04:21:04 | Butler, Iowa, US | |
2022-02-25 | US | Minnesota | Cottonwood | 27033 | 3174 | 40 | 0 | 44.00715262 | -95.18138802 | 2022-02-26 04:21:12 | Cottonwood, Minnesota, US | |
2022-02-25 | US | Kentucky | Martin | 21159 | 3174 | 45 | 0 | 37.79990579 | -82.51247478 | 2022-02-26 04:21:12 | Martin, Kentucky, US | |
2022-02-25 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-02-26 04:21:12 | Butler, Iowa, US | |
2022-02-24 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-02-25 04:21:11 | Butler, Iowa, US | |
2022-02-23 | US | Iowa | Butler | 19023 | 3174 | 51 | 0 | 42.73172833 | -92.79015971 | 2022-02-24 04:21:14 | Butler, Iowa, US | |
2022-02-21 | US | Wisconsin | Bayfield | 55007 | 3174 | 38 | 0 | 46.52868768 | -91.19716729 | 2022-02-22 04:21:01 | Bayfield, Wisconsin, US | |
2022-02-14 | US | Mississippi | Amite | 28005 | 3174 | 65 | 0 | 31.17467303 | -90.80501621 | 2022-02-15 04:21:09 | Amite, Mississippi, US | |
2022-02-14 | US | Georgia | Oglethorpe | 13221 | 3174 | 48 | 0 | 33.878629600000004 | -83.08278123 | 2022-02-15 04:21:09 | Oglethorpe, Georgia, US | |
2022-02-13 | US | Ohio | Morgan | 39115 | 3174 | 54 | 0 | 39.62081738 | -81.85308173 | 2022-02-14 04:20:51 | Morgan, Ohio, US | |
2022-02-10 | US | Michigan | Gogebic | 26053 | 3174 | 65 | 0 | 46.40862701 | -89.69377193 | 2022-02-11 04:21:09 | Gogebic, Michigan, US | |
2022-02-09 | US | Michigan | Gogebic | 26053 | 3174 | 65 | 0 | 46.40862701 | -89.69377193 | 2022-02-10 04:21:14 | Gogebic, Michigan, US | |
2022-02-02 | US | Louisiana | Madison | 22065 | 3174 | 57 | 0 | 32.36918118 | -91.23973355 | 2022-02-03 04:21:21 | Madison, Louisiana, US | |
2022-01-31 | US | Minnesota | Pennington | 27113 | 3174 | 35 | 0 | 48.06642577 | -96.0370814 | 2022-02-01 04:21:11 | Pennington, Minnesota, US | |
2022-01-11 | US | Tennessee | Cannon | 47015 | 3174 | 51 | 0 | 35.80990797 | -86.05738983 | 2022-01-12 04:21:44 | Cannon, Tennessee, US | |
2022-01-10 | US | Wisconsin | Burnett | 55013 | 3174 | 36 | 0 | 45.86303537 | -92.36711412 | 2022-01-11 04:22:01 | Burnett, Wisconsin, US | |
2022-01-09 | US | Kansas | Atchison | 20005 | 3174 | 30 | 0 | 39.53185661 | -95.30870026 | 2022-01-10 04:22:07 | Atchison, Kansas, US | |
2022-01-08 | US | Kansas | Atchison | 20005 | 3174 | 30 | 0 | 39.53185661 | -95.30870026 | 2022-01-09 04:21:46 | Atchison, Kansas, US | |
2022-01-07 | US | Kansas | Atchison | 20005 | 3174 | 30 | 0 | 39.53185661 | -95.30870026 | 2022-01-08 04:21:53 | Atchison, Kansas, US | |
2022-01-03 | US | North Carolina | Hertford | 37091 | 3174 | 73 | 0 | 36.3607755 | -76.98104134 | 2022-01-04 04:22:17 | Hertford, North Carolina, US | |
2021-12-26 | US | Tennessee | Sequatchie | 47153 | 3174 | 58 | 0 | 35.36979721 | -85.41022136 | 2021-12-27 04:21:58 | Sequatchie, Tennessee, US | |
2021-12-24 | US | Pennsylvania | Montour | 42093 | 3174 | 81 | 0 | 41.03023987 | -76.66345939 | 2021-12-25 04:21:37 | Montour, Pennsylvania, US | |
2021-12-13 | US | Colorado | Elbert | 8039 | 3174 | 30 | 0 | 39.28656773 | -104.13587209999999 | 2021-12-14 04:22:38 | Elbert, Colorado, US | |
2021-12-03 | US | Hawaii | Kauai | 15007 | 3174 | 13 | 0 | 22.03935037 | -159.5966786 | 2021-12-04 04:22:18 | Kauai, Hawaii, US | |
2021-11-27 | US | Ohio | Paulding | 39125 | 3174 | 53 | 0 | 41.11676341 | -84.5801017 | 2021-11-28 04:22:43 | Paulding, Ohio, US | |
2021-11-24 | US | Alabama | Hale | 1065 | 3174 | 89 | 0 | 32.76039258 | -87.63284988 | 2021-11-25 04:22:33 | Hale, Alabama, US | |
2021-11-21 | US | West Virginia | Lincoln | 54043 | 3174 | 49 | 0 | 38.172154 | -82.07017953 | 2021-11-22 04:22:20 | Lincoln, West Virginia, US | |
2021-11-17 | US | Mississippi | Winston | 28159 | 3174 | 92 | 0 | 33.08747908 | -89.03391385 | 2021-11-18 04:21:33 | Winston, Mississippi, US | |
2021-11-16 | US | Mississippi | Winston | 28159 | 3174 | 92 | 0 | 33.08747908 | -89.03391385 | 2021-11-17 04:21:48 | Winston, Mississippi, US | |
2021-11-12 | US | Alabama | Henry | 1067 | 3174 | 66 | 0 | 31.51148016 | -85.24267944 | 2021-11-13 04:21:38 | Henry, Alabama, US | |
2021-11-10 | US | Alabama | Fayette | 1057 | 3174 | 85 | 0 | 33.72076938 | -87.73886638 | 2021-11-11 04:21:45 | Fayette, Alabama, US | |
2021-11-05 | US | Tennessee | Trousdale | 47169 | 3174 | 26 | 0 | 36.39026213 | -86.16087954 | 2021-11-06 04:21:51 | Trousdale, Tennessee, US | |
2021-10-31 | US | Missouri | Perry | 29157 | 3174 | 33 | 0 | 37.70660776 | -89.82741088 | 2021-11-01 04:22:01 | Perry, Missouri, US | |
2021-10-28 | US | Colorado | Pitkin | 8097 | 3174 | 5 | 0 | 39.21720112 | -106.9310027 | 2021-10-29 04:22:03 | Pitkin, Colorado, US | |
2021-10-27 | US | Arizona | La Paz | 4012 | 3174 | 98 | 0 | 33.72854224 | -113.98100290000001 | 2021-10-28 04:22:08 | La Paz, Arizona, US | |
2021-10-26 | US | Wisconsin | Langlade | 55067 | 3174 | 55 | 0 | 45.26271619 | -89.07483625 | 2021-10-27 04:22:32 | Langlade, Wisconsin, US | |
2021-10-24 | US | Georgia | Morgan | 13211 | 3174 | 41 | 0 | 33.59232073 | -83.49129491 | 2021-10-25 04:22:31 | Morgan, Georgia, US | |
2021-10-23 | US | Georgia | Morgan | 13211 | 3174 | 41 | 0 | 33.59232073 | -83.49129491 | 2021-10-24 04:21:22 | Morgan, Georgia, US | |
2021-10-22 | US | Georgia | Morgan | 13211 | 3174 | 41 | 0 | 33.59232073 | -83.49129491 | 2021-10-23 04:21:32 | Morgan, Georgia, US | |
2021-10-14 | US | Arkansas | Clark | 5019 | 3174 | 54 | 0 | 34.04613432 | -93.17484713 | 2021-10-15 04:21:26 | Clark, Arkansas, US | |
2021-10-11 | US | Georgia | Washington | 13303 | 3174 | 112 | 0 | 32.96711864 | -82.79357039 | 2021-10-12 04:21:09 | Washington, Georgia, US | |
2021-10-10 | US | Georgia | Washington | 13303 | 3174 | 112 | 0 | 32.96711864 | -82.79357039 | 2021-10-11 04:21:31 | Washington, Georgia, US | |
2021-10-09 | US | Georgia | Washington | 13303 | 3174 | 112 | 0 | 32.96711864 | -82.79357039 | 2021-10-10 04:21:38 | Washington, Georgia, US | |
2021-10-08 | US | Georgia | Washington | 13303 | 3174 | 112 | 0 | 32.96711864 | -82.79357039 | 2021-10-09 04:21:34 | Washington, Georgia, US | |
2021-10-05 | US | Illinois | Lawrence | 17101 | 3174 | 32 | 0 | 38.71987914 | -87.72884035 | 2021-10-06 04:21:33 | Lawrence, Illinois, US | |
2021-10-04 | US | South Dakota | Beadle | 46005 | 3174 | 43 | 0 | 44.41464384 | -98.27858469 | 2021-10-05 04:21:27 | Beadle, South Dakota, US | |
2021-10-03 | US | North Carolina | Greene | 37079 | 3174 | 53 | 0 | 35.48544173 | -77.67578087 | 2021-10-04 04:21:31 | Greene, North Carolina, US | |
2021-10-02 | US | North Carolina | Greene | 37079 | 3174 | 53 | 0 | 35.48544173 | -77.67578087 | 2021-10-03 04:21:24 | Greene, North Carolina, US | |
2021-10-01 | US | North Carolina | Greene | 37079 | 3174 | 53 | 0 | 35.48544173 | -77.67578087 | 2021-10-02 04:21:25 | Greene, North Carolina, US | |
2021-09-30 | US | Kentucky | Meade | 21163 | 3174 | 33 | 0 | 37.96163597 | -86.21028219 | 2021-10-01 04:21:35 | Meade, Kentucky, US | |
2021-09-28 | US | Virginia | Staunton | 51790 | 3174 | 77 | 0 | 38.15965544 | -79.05979937 | 2021-09-29 04:21:45 | Staunton, Virginia, US | |
2021-09-28 | US | Michigan | Wexford | 26165 | 3174 | 50 | 0 | 44.33853602 | -85.57712739 | 2021-09-29 04:21:45 | Wexford, Michigan, US | |
2021-09-27 | US | Michigan | Wexford | 26165 | 3174 | 50 | 0 | 44.33853602 | -85.57712739 | 2021-09-28 04:21:28 | Wexford, Michigan, US | |
2021-09-22 | US | Oregon | Jefferson | 41031 | 3174 | 47 | 0 | 44.62806839 | -121.17832 | 2021-09-23 04:21:43 | Jefferson, Oregon, US | |
2021-09-21 | US | Pennsylvania | Warren | 42123 | 3174 | 114 | 0 | 41.81304978 | -79.26969577 | 2021-09-22 04:21:45 | Warren, Pennsylvania, US | |
2021-09-04 | US | Kentucky | Grant | 21081 | 3174 | 25 | 0 | 38.64962758 | -84.62415957 | 2021-09-05 04:21:33 | Grant, Kentucky, US | |
2021-09-01 | US | Arkansas | Cleburne | 5023 | 3174 | 81 | 0 | 35.53864922 | -92.02640019 | 2021-09-02 04:21:15 | Cleburne, Arkansas, US | |
2021-08-30 | US | Idaho | Cassia | 16031 | 3174 | 28 | 0 | 42.28347888 | -113.6012409 | 2021-08-31 04:21:46 | Cassia, Idaho, US | |
2021-08-29 | US | Missouri | Crawford | 29055 | 3174 | 43 | 0 | 37.97663738 | -91.30528104 | 2021-08-30 04:21:23 | Crawford, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;