daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 12712 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-11 | US | Tennessee | Cheatham | 47021 | 12712 | 138 | 0 | 36.26136216 | -87.08903581 | 2022-12-12 04:21:01 | Cheatham, Tennessee, US | |
2022-11-19 | US | New York | Otsego | 36077 | 12712 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-20 04:21:08 | Otsego, New York, US | |
2022-09-18 | US | Texas | Burnet | 48053 | 12712 | 174 | 0 | 30.78801353 | -98.181887 | 2022-09-19 04:21:49 | Burnet, Texas, US | |
2022-09-17 | US | Texas | Burnet | 48053 | 12712 | 174 | 0 | 30.78801353 | -98.181887 | 2022-09-18 04:22:50 | Burnet, Texas, US | |
2022-09-16 | US | Texas | Burnet | 48053 | 12712 | 174 | 0 | 30.78801353 | -98.181887 | 2022-09-17 04:20:19 | Burnet, Texas, US | |
2022-08-21 | US | West Virginia | Ohio | 54069 | 12712 | 187 | 0 | 40.0955451 | -80.62203992 | 2022-08-22 04:20:38 | Ohio, West Virginia, US | |
2022-08-20 | US | West Virginia | Ohio | 54069 | 12712 | 187 | 0 | 40.0955451 | -80.62203992 | 2022-08-21 04:20:44 | Ohio, West Virginia, US | |
2022-08-19 | US | West Virginia | Ohio | 54069 | 12712 | 187 | 0 | 40.0955451 | -80.62203992 | 2022-08-20 04:21:01 | Ohio, West Virginia, US | |
2022-08-10 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-11 04:20:49 | Mower, Minnesota, US | |
2022-08-09 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-10 04:20:57 | Mower, Minnesota, US | |
2022-08-08 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-09 04:20:34 | Mower, Minnesota, US | |
2022-08-07 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-08 04:21:08 | Mower, Minnesota, US | |
2022-08-06 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-07 04:20:54 | Mower, Minnesota, US | |
2022-08-05 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-06 04:20:56 | Mower, Minnesota, US | |
2022-08-04 | US | Minnesota | Mower | 27099 | 12712 | 75 | 0 | 43.67142874 | -92.75234549 | 2022-08-05 04:20:52 | Mower, Minnesota, US | |
2022-05-31 | US | Idaho | Madison | 16065 | 12712 | 50 | 0 | 43.78141028 | -111.6538474 | 2022-06-01 04:20:55 | Madison, Idaho, US | |
2022-05-30 | US | Idaho | Madison | 16065 | 12712 | 50 | 0 | 43.78141028 | -111.6538474 | 2022-05-31 04:20:51 | Madison, Idaho, US | |
2022-05-29 | US | Idaho | Madison | 16065 | 12712 | 50 | 0 | 43.78141028 | -111.6538474 | 2022-05-30 04:20:50 | Madison, Idaho, US | |
2022-05-28 | US | Idaho | Madison | 16065 | 12712 | 50 | 0 | 43.78141028 | -111.6538474 | 2022-05-29 04:20:53 | Madison, Idaho, US | |
2022-05-27 | US | Idaho | Madison | 16065 | 12712 | 50 | 0 | 43.78141028 | -111.6538474 | 2022-05-28 04:21:07 | Madison, Idaho, US | |
2022-05-16 | US | Wisconsin | Polk | 55095 | 12712 | 122 | 0 | 45.46130348 | -92.44182875 | 2022-05-17 04:20:59 | Polk, Wisconsin, US | |
2022-04-09 | US | New York | Fulton | 36035 | 12712 | 169 | 0 | 43.11363907 | -74.41798804 | 2022-04-10 04:20:52 | Fulton, New York, US | |
2022-02-13 | US | North Carolina | Carteret | 37031 | 12712 | 84 | 0 | 34.8932941 | -76.54120135 | 2022-02-14 04:20:51 | Carteret, North Carolina, US | |
2022-02-12 | US | North Carolina | Carteret | 37031 | 12712 | 84 | 0 | 34.8932941 | -76.54120135 | 2022-02-13 04:21:00 | Carteret, North Carolina, US | |
2022-02-11 | US | North Carolina | Carteret | 37031 | 12712 | 84 | 0 | 34.8932941 | -76.54120135 | 2022-02-12 04:21:06 | Carteret, North Carolina, US | |
2022-02-04 | US | Ohio | Knox | 39083 | 12712 | 218 | 0 | 40.39830217 | -82.42027563 | 2022-02-05 04:21:05 | Knox, Ohio, US | |
2022-01-02 | US | Washington | Chelan | 53007 | 12712 | 134 | 0 | 47.87046092 | -120.6173956 | 2022-01-03 02:22:25 | Chelan, Washington, US | |
2022-01-01 | US | Washington | Chelan | 53007 | 12712 | 134 | 0 | 47.87046092 | -120.6173956 | 2022-01-02 04:20:52 | Chelan, Washington, US | |
2021-12-31 | US | Washington | Chelan | 53007 | 12712 | 134 | 0 | 47.87046092 | -120.6173956 | 2022-01-01 04:22:14 | Chelan, Washington, US | |
2021-12-30 | US | Washington | Chelan | 53007 | 12712 | 134 | 0 | 47.87046092 | -120.6173956 | 2021-12-31 04:21:50 | Chelan, Washington, US | |
2021-12-12 | US | West Virginia | Harrison | 54033 | 12712 | 190 | 0 | 39.2853852 | -80.37919577 | 2021-12-13 04:22:02 | Harrison, West Virginia, US | |
2021-11-14 | US | Illinois | DeKalb | 17037 | 12712 | 135 | 0 | 41.89373302 | -88.76958483 | 2021-11-15 04:21:36 | DeKalb, Illinois, US | |
2021-11-13 | US | Illinois | DeKalb | 17037 | 12712 | 135 | 0 | 41.89373302 | -88.76958483 | 2021-11-14 04:21:31 | DeKalb, Illinois, US | |
2021-11-12 | US | Illinois | DeKalb | 17037 | 12712 | 135 | 0 | 41.89373302 | -88.76958483 | 2021-11-13 04:21:38 | DeKalb, Illinois, US | |
2021-07-04 | US | Arkansas | Saline | 5125 | 12712 | 173 | 0 | 34.64916145 | -92.67583224 | 2021-07-05 04:21:28 | Saline, Arkansas, US | |
2021-07-03 | US | Arkansas | Saline | 5125 | 12712 | 173 | 0 | 34.64916145 | -92.67583224 | 2021-07-04 04:21:38 | Saline, Arkansas, US | |
2021-07-02 | US | Arkansas | Saline | 5125 | 12712 | 173 | 0 | 34.64916145 | -92.67583224 | 2021-07-03 04:21:37 | Saline, Arkansas, US | |
2021-06-13 | US | Louisiana | Ascension | 22005 | 12712 | 167 | 0 | 30.20406249 | -90.91328409999998 | 2021-06-14 04:22:46 | Ascension, Louisiana, US | |
2021-06-12 | US | Louisiana | Ascension | 22005 | 12712 | 167 | 0 | 30.20406249 | -90.91328409999998 | 2021-06-13 04:22:44 | Ascension, Louisiana, US | |
2021-06-11 | US | Louisiana | Ascension | 22005 | 12712 | 167 | 0 | 30.20406249 | -90.91328409999998 | 2021-06-12 04:22:22 | Ascension, Louisiana, US | |
2021-04-16 | Andorra | 12712 | 123 | 12105 | 484 | 42.5063 | 1.5218 | 2021-04-17 04:20:40 | Andorra | |||
2021-04-11 | US | New York | Ulster | 36111 | 12712 | 241 | 0 | 41.89027881 | -74.26252104 | 2021-04-12 04:21:00 | Ulster, New York, US | |
2021-03-18 | Colombia | Casanare | 12712 | 291 | 12117 | 304 | 5.7589 | -71.5724 | 2021-03-19 05:26:09 | Casanare, Colombia | ||
2021-01-05 | US | Indiana | Johnson | 18081 | 12712 | 275 | 0 | 12437 | 39.48994426 | -86.10149107 | 2021-01-06 05:22:16 | Johnson, Indiana, US |
2020-11-18 | Colombia | Caqueta | 12712 | 440 | 11491 | 781 | 0.8699 | -73.8419 | 2020-11-19 05:25:23 | Caqueta, Colombia | ||
2020-07-15 | Mexico | Sonora | 12712 | 1198 | 10952 | 562 | 29.2972 | -110.3309 | 2020-07-16 04:44:59 | Sonora, Mexico | ||
2020-06-28 | US | Rhode Island | Providence | 44007 | 12712 | 747 | 0 | 11965 | 41.87064746 | -71.57753536 | 2020-06-29 04:33:44 | Providence, Rhode Island, US |
2020-06-27 | US | Rhode Island | Providence | 44007 | 12712 | 747 | 0 | 11965 | 41.87064746 | -71.57753536 | 2020-06-28 04:34:04 | Providence, Rhode Island, US |
2020-06-26 | US | Rhode Island | Providence | 44007 | 12712 | 734 | 0 | 11978 | 41.87064746 | -71.57753536 | 2020-06-27 04:33:35 | Providence, Rhode Island, US |
2020-06-25 | US | Rhode Island | Providence | 44007 | 12712 | 734 | 0 | 11978 | 41.87064746 | -71.57753536 | 2020-06-26 04:33:43 | Providence, Rhode Island, US |
2020-06-24 | US | Rhode Island | Providence | 44007 | 12712 | 734 | 0 | 11978 | 41.87064746 | -71.57753536 | 2020-06-25 05:26:54 | Providence, Rhode Island, US |
2020-06-23 | US | Rhode Island | Providence | 44007 | 12712 | 734 | 0 | 11978 | 41.87064746 | -71.57753536 | 2020-06-24 04:33:28 | Providence, Rhode Island, US |
2020-06-22 | US | Rhode Island | Providence | 44007 | 12712 | 734 | 0 | 11978 | 41.87064746 | -71.57753536 | 2020-06-23 04:33:22 | Providence, Rhode Island, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;