daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
251 rows where confirmed = 3285 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-05 | US | Virginia | Clarke | 51043 | 3285 | 55 | 0 | 39.11271747 | -77.99199425 | 2022-12-06 04:21:03 | Clarke, Virginia, US | |
2022-11-15 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-16 04:21:09 | Appanoose, Iowa, US | |
2022-11-14 | US | Virginia | Amelia | 51007 | 3285 | 61 | 0 | 37.34081025 | -77.98584649 | 2022-11-15 04:21:16 | Amelia, Virginia, US | |
2022-11-14 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-15 04:21:16 | Appanoose, Iowa, US | |
2022-11-13 | US | Virginia | Amelia | 51007 | 3285 | 61 | 0 | 37.34081025 | -77.98584649 | 2022-11-14 04:21:09 | Amelia, Virginia, US | |
2022-11-13 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-14 04:21:09 | Appanoose, Iowa, US | |
2022-11-12 | US | Virginia | Amelia | 51007 | 3285 | 61 | 0 | 37.34081025 | -77.98584649 | 2022-11-13 04:21:14 | Amelia, Virginia, US | |
2022-11-12 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-13 04:21:14 | Appanoose, Iowa, US | |
2022-11-11 | US | Virginia | Amelia | 51007 | 3285 | 61 | 0 | 37.34081025 | -77.98584649 | 2022-11-12 04:20:41 | Amelia, Virginia, US | |
2022-11-11 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-12 04:20:41 | Appanoose, Iowa, US | |
2022-11-10 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-11 04:21:22 | Appanoose, Iowa, US | |
2022-11-09 | US | Iowa | Appanoose | 19007 | 3285 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-11-10 04:21:16 | Appanoose, Iowa, US | |
2022-11-02 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-11-03 04:22:05 | Watonwan, Minnesota, US | |
2022-11-01 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-11-02 04:22:09 | Noxubee, Mississippi, US | |
2022-11-01 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-11-02 04:22:09 | Watonwan, Minnesota, US | |
2022-11-01 | US | Illinois | Marshall | 17123 | 3285 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-11-02 04:22:09 | Marshall, Illinois, US | |
2022-10-31 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-11-01 04:22:36 | Noxubee, Mississippi, US | |
2022-10-31 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-11-01 04:22:36 | Watonwan, Minnesota, US | |
2022-10-30 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-10-31 04:21:36 | Noxubee, Mississippi, US | |
2022-10-30 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-10-31 04:21:36 | Watonwan, Minnesota, US | |
2022-10-29 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-10-30 04:22:14 | Noxubee, Mississippi, US | |
2022-10-29 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-10-30 04:22:14 | Watonwan, Minnesota, US | |
2022-10-28 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-10-29 04:21:13 | Noxubee, Mississippi, US | |
2022-10-28 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-10-29 04:21:13 | Watonwan, Minnesota, US | |
2022-10-27 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-10-28 04:22:31 | Noxubee, Mississippi, US | |
2022-10-27 | US | Minnesota | Watonwan | 27165 | 3285 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-10-28 04:22:31 | Watonwan, Minnesota, US | |
2022-10-26 | US | Mississippi | Noxubee | 28103 | 3285 | 49 | 0 | 33.11009499 | -88.56949061 | 2022-10-27 04:22:01 | Noxubee, Mississippi, US | |
2022-10-20 | US | Virginia | Floyd | 51063 | 3285 | 51 | 0 | 36.9302126 | -80.36738849 | 2022-10-21 04:22:23 | Floyd, Virginia, US | |
2022-10-04 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-05 04:23:06 | Dewey, South Dakota, US | |
2022-10-03 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-04 04:22:55 | Dewey, South Dakota, US | |
2022-10-02 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-03 04:23:11 | Dewey, South Dakota, US | |
2022-10-01 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-02 04:21:23 | Dewey, South Dakota, US | |
2022-09-30 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-10-01 04:23:01 | Dewey, South Dakota, US | |
2022-09-29 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-09-30 04:23:09 | Dewey, South Dakota, US | |
2022-09-28 | US | South Dakota | Dewey | 46041 | 3285 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-09-29 04:22:34 | Dewey, South Dakota, US | |
2022-09-22 | China | Heilongjiang | 3285 | 13 | 0 | 47.862 | 127.7615 | 2022-09-23 04:23:13 | Heilongjiang, China | |||
2022-08-31 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-01 04:21:03 | Noble, Oklahoma, US | |
2022-08-30 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-31 04:20:57 | Noble, Oklahoma, US | |
2022-08-29 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-30 04:21:03 | Noble, Oklahoma, US | |
2022-08-28 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-29 04:21:06 | Noble, Oklahoma, US | |
2022-08-27 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-28 04:21:02 | Noble, Oklahoma, US | |
2022-08-26 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-27 04:20:57 | Noble, Oklahoma, US | |
2022-08-25 | US | Oklahoma | Noble | 40103 | 3285 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-08-26 04:21:02 | Noble, Oklahoma, US | |
2022-08-18 | US | Indiana | Pulaski | 18131 | 3285 | 87 | 0 | 41.04166107 | -86.69890683 | 2022-08-19 04:20:54 | Pulaski, Indiana, US | |
2022-08-17 | US | Indiana | Pulaski | 18131 | 3285 | 87 | 0 | 41.04166107 | -86.69890683 | 2022-08-18 04:21:11 | Pulaski, Indiana, US | |
2022-08-13 | China | Zhejiang | 3285 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-14 04:20:55 | Zhejiang, China | |||
2022-07-05 | US | Maine | Piscataquis | 23021 | 3285 | 33 | 0 | 45.83839062 | -69.2860223 | 2022-07-06 04:20:58 | Piscataquis, Maine, US | |
2022-07-04 | US | Maine | Piscataquis | 23021 | 3285 | 33 | 0 | 45.83839062 | -69.2860223 | 2022-07-05 04:20:45 | Piscataquis, Maine, US | |
2022-07-03 | US | Maine | Piscataquis | 23021 | 3285 | 33 | 0 | 45.83839062 | -69.2860223 | 2022-07-04 04:20:54 | Piscataquis, Maine, US | |
2022-07-02 | US | Maine | Piscataquis | 23021 | 3285 | 33 | 0 | 45.83839062 | -69.2860223 | 2022-07-03 04:20:59 | Piscataquis, Maine, US | |
2022-06-13 | US | Texas | Jackson | 48239 | 3285 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-06-14 04:20:52 | Jackson, Texas, US | |
2022-06-12 | US | Minnesota | Cottonwood | 27033 | 3285 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-13 04:21:14 | Cottonwood, Minnesota, US | |
2022-06-11 | US | Minnesota | Cottonwood | 27033 | 3285 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-12 04:20:53 | Cottonwood, Minnesota, US | |
2022-06-10 | US | Minnesota | Cottonwood | 27033 | 3285 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-06-11 04:21:01 | Cottonwood, Minnesota, US | |
2022-06-05 | US | North Dakota | McKenzie | 38053 | 3285 | 25 | 0 | 47.7413337 | -103.395905 | 2022-06-06 04:20:57 | McKenzie, North Dakota, US | |
2022-06-04 | China | Fujian | 3285 | 1 | 0 | 26.0789 | 117.9874 | 2022-06-05 04:20:55 | Fujian, China | |||
2022-06-03 | China | Fujian | 3285 | 1 | 0 | 26.0789 | 117.9874 | 2022-06-04 04:20:58 | Fujian, China | |||
2022-05-30 | US | Louisiana | Claiborne | 22027 | 3285 | 78 | 0 | 32.82308512 | -92.99526883 | 2022-05-31 04:20:51 | Claiborne, Louisiana, US | |
2022-05-29 | US | Louisiana | Claiborne | 22027 | 3285 | 78 | 0 | 32.82308512 | -92.99526883 | 2022-05-30 04:20:50 | Claiborne, Louisiana, US | |
2022-05-28 | US | Louisiana | Claiborne | 22027 | 3285 | 78 | 0 | 32.82308512 | -92.99526883 | 2022-05-29 04:20:53 | Claiborne, Louisiana, US | |
2022-05-27 | US | Louisiana | Claiborne | 22027 | 3285 | 78 | 0 | 32.82308512 | -92.99526883 | 2022-05-28 04:21:07 | Claiborne, Louisiana, US | |
2022-05-26 | US | Louisiana | Claiborne | 22027 | 3285 | 78 | 0 | 32.82308512 | -92.99526883 | 2022-05-27 04:20:56 | Claiborne, Louisiana, US | |
2022-05-01 | US | Washington | Unassigned | 90053 | 3285 | 6 | 0 | 48.82227976 | 0.0 | 2022-05-02 04:21:10 | Unassigned, Washington, US | |
2022-04-30 | US | Washington | Unassigned | 90053 | 3285 | 6 | 0 | 48.82227976 | 0.0 | 2022-05-01 04:20:57 | Unassigned, Washington, US | |
2022-04-29 | US | Washington | Unassigned | 90053 | 3285 | 6 | 0 | 48.82227976 | 0.0 | 2022-04-30 04:21:05 | Unassigned, Washington, US | |
2022-04-12 | US | Georgia | Dade | 13083 | 3285 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-04-13 04:21:03 | Dade, Georgia, US | |
2022-03-24 | US | Puerto Rico | Anasco | 72011 | 3285 | 0 | 0 | 18.287985 | -67.120611 | 2022-03-25 04:20:46 | Anasco, Puerto Rico, US | |
2022-03-17 | US | Virginia | Southampton | 51175 | 3285 | 89 | 0 | 36.72231125 | -77.10642712 | 2022-03-18 04:20:55 | Southampton, Virginia, US | |
2022-03-09 | US | Puerto Rico | Lares | 72081 | 3285 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-03-10 04:20:48 | Lares, Puerto Rico, US | |
2022-03-06 | US | Puerto Rico | Lares | 72081 | 3285 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-03-07 04:20:47 | Lares, Puerto Rico, US | |
2022-02-24 | US | New York | Yates | 36123 | 3285 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-02-25 04:21:11 | Yates, New York, US | |
2022-02-21 | US | Virginia | Manassas Park | 51685 | 3285 | 23 | 0 | 38.77058531 | -77.44399307 | 2022-02-22 04:21:01 | Manassas Park, Virginia, US | |
2022-02-18 | US | North Dakota | Walsh | 38099 | 3285 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-02-19 04:21:11 | Walsh, North Dakota, US | |
2022-02-02 | US | Kentucky | Fleming | 21069 | 3285 | 44 | 0 | 38.36758311 | -83.69657514 | 2022-02-03 04:21:21 | Fleming, Kentucky, US | |
2022-02-02 | US | Georgia | Brooks | 13027 | 3285 | 77 | 0 | 30.83922642 | -83.58303423 | 2022-02-03 04:21:21 | Brooks, Georgia, US | |
2022-01-31 | US | Virginia | Alleghany | 51005 | 3285 | 90 | 0 | 37.78636074 | -80.00222498 | 2022-02-01 04:21:11 | Alleghany, Virginia, US | |
2022-01-23 | US | Georgia | Rabun | 13241 | 3285 | 83 | 0 | 34.88389445 | -83.40304637 | 2022-01-24 04:21:12 | Rabun, Georgia, US | |
2022-01-22 | US | Georgia | Rabun | 13241 | 3285 | 83 | 0 | 34.88389445 | -83.40304637 | 2022-01-23 04:21:13 | Rabun, Georgia, US | |
2022-01-21 | US | Georgia | Rabun | 13241 | 3285 | 83 | 0 | 34.88389445 | -83.40304637 | 2022-01-22 04:21:13 | Rabun, Georgia, US | |
2022-01-13 | US | Wisconsin | Burnett | 55013 | 3285 | 36 | 0 | 45.86303537 | -92.36711412 | 2022-01-14 04:21:54 | Burnett, Wisconsin, US | |
2022-01-13 | US | Kentucky | Morgan | 21175 | 3285 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-14 04:21:54 | Morgan, Kentucky, US | |
2022-01-11 | US | Texas | Freestone | 48161 | 3285 | 75 | 0 | 31.70422788 | -96.15072516 | 2022-01-12 04:21:44 | Freestone, Texas, US | |
2022-01-02 | US | Indiana | Franklin | 18047 | 3285 | 47 | 0 | 39.4142482 | -85.06062647 | 2022-01-03 02:22:25 | Franklin, Indiana, US | |
2022-01-01 | US | Indiana | Franklin | 18047 | 3285 | 47 | 0 | 39.4142482 | -85.06062647 | 2022-01-02 04:20:52 | Franklin, Indiana, US | |
2021-12-31 | US | Indiana | Franklin | 18047 | 3285 | 47 | 0 | 39.4142482 | -85.06062647 | 2022-01-01 04:22:14 | Franklin, Indiana, US | |
2021-12-30 | US | Indiana | Franklin | 18047 | 3285 | 47 | 0 | 39.4142482 | -85.06062647 | 2021-12-31 04:21:50 | Franklin, Indiana, US | |
2021-12-23 | US | Alabama | Cherokee | 1019 | 3285 | 65 | 0 | 34.17805983 | -85.60638968 | 2021-12-24 04:21:34 | Cherokee, Alabama, US | |
2021-12-15 | US | Arkansas | Phillips | 5107 | 3285 | 79 | 0 | 34.43268455 | -90.84800154 | 2021-12-16 04:22:11 | Phillips, Arkansas, US | |
2021-12-14 | US | Virginia | Fredericksburg | 51630 | 3285 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-12-15 03:22:16 | Fredericksburg, Virginia, US | |
2021-12-14 | US | Hawaii | Kauai | 15007 | 3285 | 13 | 0 | 22.03935037 | -159.5966786 | 2021-12-15 03:22:16 | Kauai, Hawaii, US | |
2021-12-04 | US | Missouri | Ray | 29177 | 3285 | 61 | 0 | 39.353746799999996 | -93.98905745 | 2021-12-05 04:22:25 | Ray, Missouri, US | |
2021-12-02 | US | Colorado | Otero | 8089 | 3285 | 114 | 0 | 37.9014485 | -103.7173385 | 2021-12-03 04:23:05 | Otero, Colorado, US | |
2021-12-02 | US | Arkansas | Conway | 5029 | 3285 | 46 | 0 | 35.26205537 | -92.70506566 | 2021-12-03 04:23:05 | Conway, Arkansas, US | |
2021-11-24 | China | Guangdong | 3285 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-25 04:22:33 | Guangdong, China | |||
2021-11-14 | US | Kentucky | Simpson | 21213 | 3285 | 61 | 0 | 36.74058474 | -86.58047435 | 2021-11-15 04:21:36 | Simpson, Kentucky, US | |
2021-11-09 | US | Nebraska | Saunders | 31155 | 3285 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2021-11-10 04:21:38 | Saunders, Nebraska, US | |
2021-11-08 | US | Maryland | Caroline | 24011 | 3285 | 51 | 0 | 38.87172293 | -75.82904158 | 2021-11-09 04:21:36 | Caroline, Maryland, US | |
2021-11-07 | US | South Carolina | Fairfield | 45039 | 3285 | 93 | 0 | 34.39287073 | -81.1195624 | 2021-11-08 04:21:43 | Fairfield, South Carolina, US | |
2021-11-07 | US | Minnesota | Wabasha | 27157 | 3285 | 8 | 0 | 44.28424356 | -92.23121312 | 2021-11-08 04:21:43 | Wabasha, Minnesota, US | |
2021-11-06 | US | South Carolina | Fairfield | 45039 | 3285 | 93 | 0 | 34.39287073 | -81.1195624 | 2021-11-07 04:21:53 | Fairfield, South Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;