daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where country_or_region = "US" and deaths = 1860 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 14
- Michigan 9
- California 4
- Colorado 3
- Indiana 3
- Massachusetts 3
- Pennsylvania 3
- Florida 2
- Maryland 2
- New Jersey 2
- Illinois 1
- New Mexico 1
- New York 1
- Texas 1
- Wisconsin 1
country_or_region 1
- US · 36 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | Colorado | El Paso | 8041 | 232085 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-16 04:21:01 | El Paso, Colorado, US | |
2022-12-14 | US | Colorado | El Paso | 8041 | 231986 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-15 04:20:58 | El Paso, Colorado, US | |
2022-12-13 | US | Colorado | El Paso | 8041 | 231658 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-14 04:21:04 | El Paso, Colorado, US | |
2022-10-03 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-04 04:22:55 | Genesee, Michigan, US | |
2022-10-02 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-03 04:23:11 | Genesee, Michigan, US | |
2022-10-01 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-02 04:21:23 | Genesee, Michigan, US | |
2022-09-30 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-01 04:23:01 | Genesee, Michigan, US | |
2022-09-29 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-30 04:23:09 | Genesee, Michigan, US | |
2022-09-28 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-29 04:22:34 | Genesee, Michigan, US | |
2022-09-27 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-28 04:23:01 | Genesee, Michigan, US | |
2022-09-12 | US | Maryland | Baltimore City | 24510 | 135153 | 1860 | 0 | 39.30211911 | -76.61151012 | 2022-09-13 04:20:57 | Baltimore City, Maryland, US | |
2022-07-24 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-25 04:20:51 | Lake, Indiana, US | |
2022-07-23 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-24 04:20:47 | Lake, Indiana, US | |
2022-07-22 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-23 04:20:53 | Lake, Indiana, US | |
2022-05-26 | US | California | Alameda | 6001 | 296604 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-27 04:20:56 | Alameda, California, US | |
2022-05-25 | US | California | Alameda | 6001 | 293996 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-26 04:20:50 | Alameda, California, US | |
2022-05-24 | US | California | Alameda | 6001 | 293940 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-25 04:20:56 | Alameda, California, US | |
2022-05-22 | US | California | Alameda | 6001 | 290516 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-26 04:20:50 | Alameda, California, US | |
2022-05-18 | US | New Mexico | Bernalillo | 35001 | 150336 | 1860 | 0 | 35.05163625 | -106.6703554 | 2022-05-19 04:20:54 | Bernalillo, New Mexico, US | |
2022-03-30 | US | Pennsylvania | Delaware | 42045 | 109673 | 1860 | 0 | 39.91680171 | -75.40243663 | 2022-03-31 04:20:56 | Delaware, Pennsylvania, US | |
2022-03-14 | US | Massachusetts | Norfolk | 25021 | 129557 | 1860 | 0 | 42.16073095 | -71.20530408 | 2022-03-15 04:20:47 | Norfolk, Massachusetts, US | |
2022-01-13 | US | Wisconsin | Milwaukee | 55079 | 222069 | 1860 | 0 | 43.00486062 | -87.96733172 | 2022-01-14 04:21:54 | Milwaukee, Wisconsin, US | |
2021-11-09 | US | Maryland | Baltimore | 24005 | 77648 | 1860 | 0 | 39.45784712 | -76.62911955 | 2021-11-10 04:21:38 | Baltimore, Maryland, US | |
2021-09-16 | US | Massachusetts | Worcester | 25027 | 86561 | 1860 | 0 | 42.35026951 | -71.90493363 | 2021-09-17 04:21:46 | Worcester, Massachusetts, US | |
2021-08-11 | US | New York | Richmond | 36085 | 78771 | 1860 | 0 | 40.58582155 | -74.14808598 | 2021-08-12 04:21:25 | Richmond, New York, US | |
2021-04-15 | US | Pennsylvania | Allegheny | 42003 | 93194 | 1860 | 0 | 40.46809875 | -79.98167747 | 2021-04-16 04:20:46 | Allegheny, Pennsylvania, US | |
2021-04-14 | US | Pennsylvania | Allegheny | 42003 | 92778 | 1860 | 0 | 40.46809875 | -79.98167747 | 2021-04-15 04:20:54 | Allegheny, Pennsylvania, US | |
2021-04-01 | US | New Jersey | Union | 34039 | 64600 | 1860 | 0 | 40.65835409 | -74.30680092 | 2021-04-02 04:20:36 | Union, New Jersey, US | |
2021-03-31 | US | New Jersey | Union | 34039 | 64169 | 1860 | 0 | 40.65835409 | -74.30680092 | 2021-04-01 04:27:05 | Union, New Jersey, US | |
2021-03-09 | US | Massachusetts | Essex | 25009 | 84932 | 1860 | 0 | 42.6687626 | -70.94687179 | 2021-03-10 05:24:35 | Essex, Massachusetts, US | |
2021-01-31 | US | Michigan | Macomb | 26099 | 55852 | 1860 | 0 | 53992 | 42.69158356 | -82.92752801 | 2021-02-01 05:22:53 | Macomb, Michigan, US |
2021-01-30 | US | Michigan | Macomb | 26099 | 55852 | 1860 | 0 | 53992 | 42.69158356 | -82.92752801 | 2021-01-31 05:22:42 | Macomb, Michigan, US |
2021-01-18 | US | Illinois | Unassigned | 90017 | 99 | 1860 | 0 | 0 | 42.36542373 | 0.0 | 2021-01-19 05:22:15 | Unassigned, Illinois, US |
2021-01-12 | US | Texas | El Paso | 48141 | 83804 | 1860 | 0 | 102225 | 31.76980765 | -106.2363275 | 2021-01-13 05:22:15 | El Paso, Texas, US |
2020-12-27 | US | Florida | Palm Beach | 12099 | 80239 | 1860 | 0 | 78379 | 26.64676272 | -80.46536002 | 2020-12-28 05:22:06 | Palm Beach, Florida, US |
2020-12-26 | US | Florida | Palm Beach | 12099 | 79830 | 1860 | 0 | 77970 | 26.64676272 | -80.46536002 | 2020-12-27 05:22:55 | Palm Beach, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;