daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
242 rows where confirmed = 3302 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-27 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Washington, US | |
2022-12-26 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Washington, US | |
2022-12-25 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Washington, US | |
2022-12-24 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Washington, US | |
2022-12-23 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Washington, US | |
2022-12-22 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-23 04:21:04 | Unassigned, Washington, US | |
2022-12-21 | US | Washington | Unassigned | 90053 | 3302 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Washington, US | |
2022-12-20 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-21 04:21:03 | Pamlico, North Carolina, US | |
2022-12-19 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-20 04:21:04 | Pamlico, North Carolina, US | |
2022-12-18 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-19 04:21:03 | Pamlico, North Carolina, US | |
2022-12-17 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-18 04:21:03 | Pamlico, North Carolina, US | |
2022-12-16 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-17 04:21:04 | Pamlico, North Carolina, US | |
2022-12-15 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-16 04:21:01 | Pamlico, North Carolina, US | |
2022-12-14 | US | North Carolina | Pamlico | 37137 | 3302 | 36 | 0 | 35.15253315 | -76.66559823 | 2022-12-15 04:20:58 | Pamlico, North Carolina, US | |
2022-11-08 | US | Illinois | Marshall | 17123 | 3302 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-11-09 04:21:22 | Marshall, Illinois, US | |
2022-11-07 | US | Illinois | Marshall | 17123 | 3302 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-11-08 04:21:21 | Marshall, Illinois, US | |
2022-10-18 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-19 04:22:26 | Dewey, South Dakota, US | |
2022-10-17 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-18 04:22:42 | Dewey, South Dakota, US | |
2022-10-16 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-17 04:20:31 | Dewey, South Dakota, US | |
2022-10-15 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-16 04:22:39 | Dewey, South Dakota, US | |
2022-10-14 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-15 04:22:00 | Dewey, South Dakota, US | |
2022-10-13 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-14 04:22:28 | Dewey, South Dakota, US | |
2022-10-12 | US | South Dakota | Dewey | 46041 | 3302 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-13 04:22:39 | Dewey, South Dakota, US | |
2022-09-18 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-19 04:21:49 | Metcalfe, Kentucky, US | |
2022-09-17 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-18 04:22:50 | Metcalfe, Kentucky, US | |
2022-09-16 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-17 04:20:19 | Metcalfe, Kentucky, US | |
2022-09-15 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-16 04:21:19 | Metcalfe, Kentucky, US | |
2022-09-14 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-15 04:21:02 | Metcalfe, Kentucky, US | |
2022-09-13 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-14 04:20:44 | Metcalfe, Kentucky, US | |
2022-09-12 | US | Kentucky | Metcalfe | 21169 | 3302 | 71 | 0 | 36.99459295 | -85.63123699 | 2022-09-13 04:20:57 | Metcalfe, Kentucky, US | |
2022-09-03 | China | Henan | 3302 | 22 | 0 | 33.882 | 113.614 | 2022-09-04 04:21:22 | Henan, China | |||
2022-09-01 | US | Colorado | Rio Grande | 8105 | 3302 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-09-02 04:21:07 | Rio Grande, Colorado, US | |
2022-08-17 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-18 04:21:11 | Aitkin, Minnesota, US | |
2022-08-16 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-17 04:20:59 | Aitkin, Minnesota, US | |
2022-08-15 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-16 04:20:58 | Aitkin, Minnesota, US | |
2022-08-14 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-15 04:20:59 | Aitkin, Minnesota, US | |
2022-08-13 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-14 04:20:55 | Aitkin, Minnesota, US | |
2022-08-12 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-13 04:20:52 | Aitkin, Minnesota, US | |
2022-08-11 | US | Minnesota | Aitkin | 27001 | 3302 | 63 | 0 | 46.60962049 | -93.4116826 | 2022-08-12 04:20:54 | Aitkin, Minnesota, US | |
2022-07-18 | US | Maine | Piscataquis | 23021 | 3302 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-19 04:20:58 | Piscataquis, Maine, US | |
2022-07-17 | US | Maine | Piscataquis | 23021 | 3302 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-18 04:20:59 | Piscataquis, Maine, US | |
2022-07-16 | US | Maine | Piscataquis | 23021 | 3302 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-17 04:21:15 | Piscataquis, Maine, US | |
2022-07-05 | US | California | Mono | 6051 | 3302 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-07-06 04:20:58 | Mono, California, US | |
2022-06-21 | US | Minnesota | Cottonwood | 27033 | 3302 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-22 04:20:54 | Cottonwood, Minnesota, US | |
2022-06-20 | US | Minnesota | Cottonwood | 27033 | 3302 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-21 04:20:56 | Cottonwood, Minnesota, US | |
2022-06-19 | US | Minnesota | Cottonwood | 27033 | 3302 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-20 04:21:01 | Cottonwood, Minnesota, US | |
2022-06-18 | US | Minnesota | Cottonwood | 27033 | 3302 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-19 04:20:51 | Cottonwood, Minnesota, US | |
2022-06-17 | US | Minnesota | Cottonwood | 27033 | 3302 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-18 04:21:10 | Cottonwood, Minnesota, US | |
2022-06-15 | China | Shaanxi | 3302 | 3 | 0 | 35.1917 | 108.8701 | 2022-06-16 04:20:55 | Shaanxi, China | |||
2022-06-14 | China | Shaanxi | 3302 | 3 | 0 | 35.1917 | 108.8701 | 2022-06-15 04:20:54 | Shaanxi, China | |||
2022-06-09 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-10 04:20:55 | Dent, Missouri, US | |
2022-06-08 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-09 04:20:54 | Dent, Missouri, US | |
2022-06-07 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-08 04:20:55 | Dent, Missouri, US | |
2022-06-06 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-07 04:21:08 | Dent, Missouri, US | |
2022-06-06 | China | Fujian | 3302 | 1 | 0 | 26.0789 | 117.9874 | 2022-06-07 04:21:08 | Fujian, China | |||
2022-06-05 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-06 04:20:57 | Dent, Missouri, US | |
2022-06-04 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-05 04:20:55 | Dent, Missouri, US | |
2022-06-03 | US | Missouri | Dent | 29065 | 3302 | 84 | 0 | 37.60663134 | -91.50790473 | 2022-06-04 04:20:58 | Dent, Missouri, US | |
2022-05-31 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-06-01 04:20:55 | Arenac, Michigan, US | |
2022-05-30 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-31 04:20:51 | Arenac, Michigan, US | |
2022-05-29 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-30 04:20:50 | Arenac, Michigan, US | |
2022-05-28 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-29 04:20:53 | Arenac, Michigan, US | |
2022-05-27 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-28 04:21:07 | Arenac, Michigan, US | |
2022-05-26 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-27 04:20:56 | Arenac, Michigan, US | |
2022-05-25 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-26 04:20:50 | Arenac, Michigan, US | |
2022-05-22 | US | Michigan | Arenac | 26011 | 3302 | 68 | 0 | 44.0636262 | -83.89277559 | 2022-05-26 04:20:50 | Arenac, Michigan, US | |
2022-05-21 | US | Virginia | Brunswick | 51025 | 3302 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-05-22 04:20:52 | Brunswick, Virginia, US | |
2022-05-20 | US | Virginia | Brunswick | 51025 | 3302 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-05-21 04:20:58 | Brunswick, Virginia, US | |
2022-05-18 | US | Virginia | Westmoreland | 51193 | 3302 | 52 | 0 | 38.11021557 | -76.80213247 | 2022-05-19 04:20:54 | Westmoreland, Virginia, US | |
2022-05-12 | US | Tennessee | Stewart | 47161 | 3302 | 59 | 0 | 36.50235092 | -87.83920548 | 2022-05-13 04:20:51 | Stewart, Tennessee, US | |
2022-04-20 | US | Wisconsin | Ashland | 55003 | 3302 | 36 | 0 | 46.31956891 | -90.67837132 | 2022-04-21 04:20:46 | Ashland, Wisconsin, US | |
2022-04-17 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-18 04:21:12 | Martin, Kentucky, US | |
2022-04-16 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-17 04:20:59 | Martin, Kentucky, US | |
2022-04-15 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-16 04:20:48 | Martin, Kentucky, US | |
2022-04-14 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-15 04:20:57 | Martin, Kentucky, US | |
2022-04-13 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-13 23:21:06 | Martin, Kentucky, US | |
2022-04-12 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-13 04:21:03 | Martin, Kentucky, US | |
2022-04-11 | US | Kentucky | Martin | 21159 | 3302 | 49 | 0 | 37.79990579 | -82.51247478 | 2022-04-12 04:20:49 | Martin, Kentucky, US | |
2022-03-17 | US | Puerto Rico | Lares | 72081 | 3302 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-03-18 04:20:55 | Lares, Puerto Rico, US | |
2022-02-27 | US | Georgia | Bleckley | 13023 | 3302 | 91 | 0 | 32.43829035 | -83.33035166 | 2022-02-28 04:21:05 | Bleckley, Georgia, US | |
2022-02-27 | US | Arkansas | Marion | 5089 | 3302 | 83 | 0 | 36.26844485 | -92.68451899 | 2022-02-28 04:21:05 | Marion, Arkansas, US | |
2022-02-26 | US | Georgia | Bleckley | 13023 | 3302 | 91 | 0 | 32.43829035 | -83.33035166 | 2022-02-27 04:21:04 | Bleckley, Georgia, US | |
2022-02-25 | US | Georgia | Bleckley | 13023 | 3302 | 91 | 0 | 32.43829035 | -83.33035166 | 2022-02-26 04:21:12 | Bleckley, Georgia, US | |
2022-02-13 | Canada | Yukon | 3302 | 20 | 0 | 64.2823 | -135.0 | 2022-02-14 04:20:51 | Yukon, Canada | |||
2022-02-12 | Canada | Yukon | 3302 | 20 | 0 | 64.2823 | -135.0 | 2022-02-13 04:21:00 | Yukon, Canada | |||
2022-02-11 | Canada | Yukon | 3302 | 20 | 0 | 64.2823 | -135.0 | 2022-02-12 04:21:06 | Yukon, Canada | |||
2022-02-09 | US | Colorado | Crowley | 8025 | 3302 | 29 | 0 | 38.32608609 | -103.7844965 | 2022-02-10 04:21:14 | Crowley, Colorado, US | |
2022-02-07 | US | Oregon | Hood River | 41027 | 3302 | 41 | 0 | 45.51872811 | -121.65520359999998 | 2022-02-08 04:21:15 | Hood River, Oregon, US | |
2022-02-02 | US | Minnesota | Kanabec | 27065 | 3302 | 53 | 0 | 45.9459309 | -93.29275192 | 2022-02-03 04:21:21 | Kanabec, Minnesota, US | |
2022-02-01 | US | North Dakota | Ramsey | 38071 | 3302 | 47 | 0 | 48.26886249 | -98.72223879 | 2022-02-02 04:21:09 | Ramsey, North Dakota, US | |
2022-02-01 | US | Illinois | Washington | 17189 | 3302 | 33 | 0 | 38.35309213 | -89.40982703 | 2022-02-02 04:21:09 | Washington, Illinois, US | |
2022-01-20 | US | Georgia | Jefferson | 13163 | 3302 | 98 | 0 | 33.05867328 | -82.41609057 | 2022-01-21 04:21:09 | Jefferson, Georgia, US | |
2022-01-14 | US | Texas | Madison | 48313 | 3302 | 47 | 0 | 30.96694679 | -95.93003775 | 2022-01-15 04:21:07 | Madison, Texas, US | |
2022-01-11 | US | Georgia | Brantley | 13025 | 3302 | 92 | 0 | 31.19576557 | -81.97743999 | 2022-01-12 04:21:44 | Brantley, Georgia, US | |
2022-01-10 | US | Kentucky | Lawrence | 21127 | 3302 | 50 | 0 | 38.07136018 | -82.72882223 | 2022-01-11 04:22:01 | Lawrence, Kentucky, US | |
2022-01-01 | US | Texas | Lavaca | 48285 | 3302 | 100 | 0 | 29.38508402 | -96.93186692 | 2022-01-02 04:20:52 | Lavaca, Texas, US | |
2022-01-01 | US | Ohio | Meigs | 39105 | 3302 | 73 | 0 | 39.09224872 | -82.0305041 | 2022-01-02 04:20:52 | Meigs, Ohio, US | |
2021-12-31 | US | Ohio | Meigs | 39105 | 3302 | 71 | 0 | 39.09224872 | -82.0305041 | 2022-01-01 04:22:14 | Meigs, Ohio, US | |
2021-12-26 | US | New York | Schoharie | 36095 | 3302 | 29 | 0 | 42.58831742 | -74.44339029999998 | 2021-12-27 04:21:58 | Schoharie, New York, US | |
2021-12-26 | US | Alabama | Cherokee | 1019 | 3302 | 65 | 0 | 34.17805983 | -85.60638968 | 2021-12-27 04:21:58 | Cherokee, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;