daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
204 rows where confirmed = 3873 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-11-20 | US | Colorado | Gunnison | 8051 | 3873 | 16 | 0 | 38.66611652 | -107.0320729 | 2022-11-21 04:21:05 | Gunnison, Colorado, US | |
2022-11-19 | US | Colorado | Gunnison | 8051 | 3873 | 16 | 0 | 38.66611652 | -107.0320729 | 2022-11-20 04:21:08 | Gunnison, Colorado, US | |
2022-11-18 | US | Colorado | Gunnison | 8051 | 3873 | 16 | 0 | 38.66611652 | -107.0320729 | 2022-11-19 04:21:14 | Gunnison, Colorado, US | |
2022-10-18 | US | Louisiana | Claiborne | 22027 | 3873 | 81 | 0 | 32.82308512 | -92.99526883 | 2022-10-19 04:22:26 | Claiborne, Louisiana, US | |
2022-10-17 | US | Louisiana | Claiborne | 22027 | 3873 | 81 | 0 | 32.82308512 | -92.99526883 | 2022-10-18 04:22:42 | Claiborne, Louisiana, US | |
2022-10-16 | US | Louisiana | Claiborne | 22027 | 3873 | 81 | 0 | 32.82308512 | -92.99526883 | 2022-10-17 04:20:31 | Claiborne, Louisiana, US | |
2022-10-15 | US | Louisiana | Claiborne | 22027 | 3873 | 81 | 0 | 32.82308512 | -92.99526883 | 2022-10-16 04:22:39 | Claiborne, Louisiana, US | |
2022-10-14 | US | Louisiana | Claiborne | 22027 | 3873 | 81 | 0 | 32.82308512 | -92.99526883 | 2022-10-15 04:22:00 | Claiborne, Louisiana, US | |
2022-10-11 | US | North Dakota | Walsh | 38099 | 3873 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-12 04:22:51 | Walsh, North Dakota, US | |
2022-10-09 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-10 04:22:32 | Grand, Colorado, US | |
2022-10-08 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-09 04:21:16 | Grand, Colorado, US | |
2022-10-07 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-08 04:22:56 | Grand, Colorado, US | |
2022-10-06 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-07 04:23:08 | Grand, Colorado, US | |
2022-10-05 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-06 04:21:22 | Grand, Colorado, US | |
2022-10-04 | US | Colorado | Grand | 8049 | 3873 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-05 04:23:06 | Grand, Colorado, US | |
2022-10-03 | US | Illinois | Washington | 17189 | 3873 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-10-04 04:22:55 | Washington, Illinois, US | |
2022-09-11 | US | Texas | Comanche | 48093 | 3873 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-09-12 04:20:58 | Comanche, Texas, US | |
2022-09-10 | US | Texas | Comanche | 48093 | 3873 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-09-11 04:20:50 | Comanche, Texas, US | |
2022-09-09 | US | Texas | Comanche | 48093 | 3873 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-09-10 04:21:10 | Comanche, Texas, US | |
2022-08-31 | US | West Virginia | Roane | 54087 | 3873 | 41 | 0 | 38.71622686 | -81.35243568 | 2022-09-01 04:21:03 | Roane, West Virginia, US | |
2022-08-21 | US | Virginia | Dickenson | 51051 | 3873 | 53 | 0 | 37.12560977 | -82.35124171 | 2022-08-22 04:20:38 | Dickenson, Virginia, US | |
2022-08-20 | US | Virginia | Dickenson | 51051 | 3873 | 53 | 0 | 37.12560977 | -82.35124171 | 2022-08-21 04:20:44 | Dickenson, Virginia, US | |
2022-08-19 | US | Virginia | Dickenson | 51051 | 3873 | 53 | 0 | 37.12560977 | -82.35124171 | 2022-08-20 04:21:01 | Dickenson, Virginia, US | |
2022-08-01 | US | Illinois | Greene | 17061 | 3873 | 46 | 0 | 39.35907414 | -90.388865 | 2022-08-02 04:20:53 | Greene, Illinois, US | |
2022-07-21 | US | Colorado | Las Animas | 8071 | 3873 | 45 | 0 | 37.3153406 | -104.0376458 | 2022-07-22 04:21:15 | Las Animas, Colorado, US | |
2022-07-14 | US | Puerto Rico | Ciales | 72039 | 3873 | 0 | 0 | 18.28885 | -66.516475 | 2022-07-15 04:20:53 | Ciales, Puerto Rico, US | |
2022-07-13 | US | New York | Yates | 36123 | 3873 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-14 04:20:57 | Yates, New York, US | |
2022-07-10 | US | Oregon | Curry | 41015 | 3873 | 59 | 0 | 42.45911325 | -124.157282 | 2022-07-11 04:20:46 | Curry, Oregon, US | |
2022-07-09 | US | Oregon | Curry | 41015 | 3873 | 59 | 0 | 42.45911325 | -124.157282 | 2022-07-10 04:20:54 | Curry, Oregon, US | |
2022-07-08 | US | Oregon | Curry | 41015 | 3873 | 59 | 0 | 42.45911325 | -124.157282 | 2022-07-09 04:20:59 | Curry, Oregon, US | |
2022-07-05 | US | Alabama | Washington | 1129 | 3873 | 59 | 0 | 31.4092794 | -88.20689944 | 2022-07-06 04:20:58 | Washington, Alabama, US | |
2022-07-04 | US | Texas | Falls | 48145 | 3873 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-07-05 04:20:45 | Falls, Texas, US | |
2022-07-04 | US | Tennessee | Decatur | 47039 | 3873 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-07-05 04:20:45 | Decatur, Tennessee, US | |
2022-07-04 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-07-05 04:20:45 | Green, Kentucky, US | |
2022-07-04 | US | Illinois | Wabash | 17185 | 3873 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-07-05 04:20:45 | Wabash, Illinois, US | |
2022-07-03 | US | Texas | Falls | 48145 | 3873 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-07-04 04:20:54 | Falls, Texas, US | |
2022-07-03 | US | Tennessee | Decatur | 47039 | 3873 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-07-04 04:20:54 | Decatur, Tennessee, US | |
2022-07-03 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-07-04 04:20:54 | Green, Kentucky, US | |
2022-07-03 | US | Illinois | Wabash | 17185 | 3873 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-07-04 04:20:54 | Wabash, Illinois, US | |
2022-07-02 | US | Texas | Falls | 48145 | 3873 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-07-03 04:20:59 | Falls, Texas, US | |
2022-07-02 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-07-03 04:20:59 | Green, Kentucky, US | |
2022-07-02 | US | Illinois | Wabash | 17185 | 3873 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-07-03 04:20:59 | Wabash, Illinois, US | |
2022-07-01 | US | Texas | Falls | 48145 | 3873 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-07-02 04:21:16 | Falls, Texas, US | |
2022-07-01 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-07-02 04:21:16 | Green, Kentucky, US | |
2022-07-01 | US | Illinois | Wabash | 17185 | 3873 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-07-02 04:21:16 | Wabash, Illinois, US | |
2022-06-30 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-07-01 04:21:10 | Green, Kentucky, US | |
2022-06-29 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-06-30 04:21:01 | Green, Kentucky, US | |
2022-06-28 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-29 04:20:59 | Swain, North Carolina, US | |
2022-06-28 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-06-29 04:20:59 | Green, Kentucky, US | |
2022-06-27 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-28 04:20:58 | Swain, North Carolina, US | |
2022-06-27 | US | Kentucky | Green | 21087 | 3873 | 45 | 0 | 37.26484328 | -85.5540745 | 2022-06-28 04:20:58 | Green, Kentucky, US | |
2022-06-26 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-27 04:21:00 | Swain, North Carolina, US | |
2022-06-25 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-26 04:21:02 | Swain, North Carolina, US | |
2022-06-25 | US | New York | Schuyler | 36097 | 3873 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-06-26 04:21:02 | Schuyler, New York, US | |
2022-06-24 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-25 04:20:57 | Swain, North Carolina, US | |
2022-06-23 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-24 04:20:58 | Swain, North Carolina, US | |
2022-06-22 | US | North Carolina | Swain | 37173 | 3873 | 46 | 0 | 35.48665845 | -83.48748932 | 2022-06-23 04:20:55 | Swain, North Carolina, US | |
2022-06-21 | US | Minnesota | Renville | 27129 | 3873 | 56 | 0 | 44.72836381 | -94.94553734 | 2022-06-22 04:20:54 | Renville, Minnesota, US | |
2022-06-18 | US | Texas | Colorado | 48089 | 3873 | 66 | 0 | 29.622098 | -96.5273805 | 2022-06-19 04:20:51 | Colorado, Texas, US | |
2022-06-13 | US | Texas | Andrews | 48003 | 3873 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-14 04:20:52 | Andrews, Texas, US | |
2022-06-12 | US | Texas | Andrews | 48003 | 3873 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-13 04:21:14 | Andrews, Texas, US | |
2022-06-11 | US | Texas | Andrews | 48003 | 3873 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-12 04:20:53 | Andrews, Texas, US | |
2022-05-18 | US | Oregon | Tillamook | 41057 | 3873 | 63 | 0 | 45.46248721 | -123.712066 | 2022-05-19 04:20:54 | Tillamook, Oregon, US | |
2022-05-15 | US | Wisconsin | Marquette | 55077 | 3873 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-16 04:20:47 | Marquette, Wisconsin, US | |
2022-05-14 | US | Wisconsin | Marquette | 55077 | 3873 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-15 04:20:53 | Marquette, Wisconsin, US | |
2022-05-13 | US | Wisconsin | Marquette | 55077 | 3873 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-14 04:20:48 | Marquette, Wisconsin, US | |
2022-04-24 | US | Illinois | Massac | 17127 | 3873 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-04-25 04:20:56 | Massac, Illinois, US | |
2022-04-23 | US | Illinois | Massac | 17127 | 3873 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-04-24 04:20:56 | Massac, Illinois, US | |
2022-04-22 | US | Illinois | Massac | 17127 | 3873 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-04-23 04:20:50 | Massac, Illinois, US | |
2022-04-21 | US | Illinois | Massac | 17127 | 3873 | 68 | 0 | 37.22078441 | -88.71036614 | 2022-04-22 04:20:45 | Massac, Illinois, US | |
2022-03-15 | US | Minnesota | Redwood | 27127 | 3873 | 53 | 0 | 44.40555844 | -95.25207021 | 2022-03-16 04:20:50 | Redwood, Minnesota, US | |
2022-03-10 | US | Arkansas | Izard | 5065 | 3873 | 65 | 0 | 36.09604046 | -91.90847954 | 2022-03-11 04:20:50 | Izard, Arkansas, US | |
2022-03-08 | US | Kansas | Jackson | 20085 | 3873 | 27 | 0 | 39.41673394 | -95.79356799 | 2022-03-09 04:20:59 | Jackson, Kansas, US | |
2022-03-07 | US | Kansas | Jackson | 20085 | 3873 | 27 | 0 | 39.41673394 | -95.79356799 | 2022-03-08 04:20:54 | Jackson, Kansas, US | |
2022-03-05 | US | Arkansas | Madison | 5087 | 3873 | 59 | 0 | 36.01038185 | -93.72524943 | 2022-03-06 04:20:49 | Madison, Arkansas, US | |
2022-02-11 | US | Puerto Rico | Yabucoa | 72151 | 3873 | 0 | 0 | 18.070399 | -65.896289 | 2022-02-12 04:21:06 | Yabucoa, Puerto Rico, US | |
2022-02-01 | US | Illinois | Carroll | 17015 | 3873 | 45 | 0 | 42.06823429 | -89.93395545 | 2022-02-02 04:21:09 | Carroll, Illinois, US | |
2022-01-31 | US | Kentucky | Lawrence | 21127 | 3873 | 53 | 0 | 38.07136018 | -82.72882223 | 2022-02-01 04:21:11 | Lawrence, Kentucky, US | |
2022-01-25 | US | Michigan | Ogemaw | 26129 | 3873 | 87 | 0 | 44.33481032 | -84.12725175 | 2022-01-26 04:21:07 | Ogemaw, Michigan, US | |
2022-01-24 | US | Michigan | Ogemaw | 26129 | 3873 | 87 | 0 | 44.33481032 | -84.12725175 | 2022-01-25 04:21:05 | Ogemaw, Michigan, US | |
2022-01-21 | US | Maine | Knox | 23013 | 3873 | 21 | 0 | 44.11486325 | -69.10529169 | 2022-01-22 04:21:13 | Knox, Maine, US | |
2022-01-20 | US | Virginia | Prince Edward | 51147 | 3873 | 54 | 0 | 37.22554789 | -78.43597949 | 2022-01-21 04:21:09 | Prince Edward, Virginia, US | |
2022-01-13 | US | Georgia | Putnam | 13237 | 3873 | 91 | 0 | 33.32056115 | -83.37552891 | 2022-01-14 04:21:54 | Putnam, Georgia, US | |
2022-01-09 | US | New Mexico | Lincoln | 35027 | 3873 | 49 | 0 | 33.74526079 | -105.4586166 | 2022-01-10 04:22:07 | Lincoln, New Mexico, US | |
2022-01-08 | US | Tennessee | Union | 47173 | 3873 | 62 | 0 | 36.28590426 | -83.83651902 | 2022-01-09 04:21:46 | Union, Tennessee, US | |
2022-01-08 | US | New Mexico | Lincoln | 35027 | 3873 | 49 | 0 | 33.74526079 | -105.4586166 | 2022-01-09 04:21:46 | Lincoln, New Mexico, US | |
2022-01-07 | US | New Mexico | Lincoln | 35027 | 3873 | 49 | 0 | 33.74526079 | -105.4586166 | 2022-01-08 04:21:53 | Lincoln, New Mexico, US | |
2022-01-06 | US | Alabama | Randolph | 1111 | 3873 | 67 | 0 | 33.29526734 | -85.45708831 | 2022-01-07 04:22:09 | Randolph, Alabama, US | |
2022-01-04 | US | Colorado | Teller | 8119 | 3873 | 54 | 0 | 38.88133511 | -105.16148929999999 | 2022-01-05 04:21:59 | Teller, Colorado, US | |
2021-12-28 | US | California | Del Norte | 6015 | 3873 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2021-12-29 03:21:43 | Del Norte, California, US | |
2021-12-19 | US | Minnesota | Dodge | 27039 | 3873 | 13 | 0 | 44.02238415 | -92.86244324 | 2021-12-20 04:21:43 | Dodge, Minnesota, US | |
2021-12-18 | US | Minnesota | Dodge | 27039 | 3873 | 13 | 0 | 44.02238415 | -92.86244324 | 2021-12-19 04:21:11 | Dodge, Minnesota, US | |
2021-12-17 | US | Minnesota | Dodge | 27039 | 3873 | 13 | 0 | 44.02238415 | -92.86244324 | 2021-12-18 02:22:20 | Dodge, Minnesota, US | |
2021-12-13 | US | Maine | Hancock | 23009 | 3873 | 56 | 0 | 44.59816444 | -68.38401854 | 2021-12-14 04:22:38 | Hancock, Maine, US | |
2021-12-12 | US | Maine | Hancock | 23009 | 3873 | 56 | 0 | 44.59816444 | -68.38401854 | 2021-12-13 04:22:02 | Hancock, Maine, US | |
2021-12-11 | US | West Virginia | Hampshire | 54027 | 3873 | 54 | 0 | 39.32103553 | -78.60826476 | 2021-12-12 04:22:12 | Hampshire, West Virginia, US | |
2021-12-11 | US | Maine | Hancock | 23009 | 3873 | 56 | 0 | 44.59816444 | -68.38401854 | 2021-12-12 04:22:12 | Hancock, Maine, US | |
2021-12-03 | US | Texas | Limestone | 48293 | 3873 | 111 | 0 | 31.5454767 | -96.58095444 | 2021-12-04 04:22:18 | Limestone, Texas, US | |
2021-12-01 | US | Illinois | Shelby | 17173 | 3873 | 53 | 0 | 39.39133527 | -88.80611122 | 2021-12-02 04:22:37 | Shelby, Illinois, US | |
2021-11-29 | US | Georgia | Pike | 13231 | 3873 | 71 | 0 | 33.09310242 | -84.38790389 | 2021-11-30 04:22:53 | Pike, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;