daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64 rows where country_or_region = "US" and deaths = 1094 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- Idaho 7
- Wisconsin 7
- New York 5
- Ohio 5
- Pennsylvania 5
- Texas 5
- New Jersey 4
- Utah 4
- Washington 4
- Florida 3
- Illinois 3
- California 2
- Kansas 2
- Louisiana 2
- Alabama 1
- Arizona 1
- Colorado 1
- Massachusetts 1
- Oregon 1
- Puerto Rico 1
country_or_region 1
- US · 64 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-15 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-16 04:21:09 | Ada, Idaho, US | |
2022-11-14 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-15 04:21:16 | Ada, Idaho, US | |
2022-11-13 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-14 04:21:09 | Ada, Idaho, US | |
2022-11-12 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-13 04:21:14 | Ada, Idaho, US | |
2022-11-11 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-12 04:20:41 | Ada, Idaho, US | |
2022-11-10 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-11 04:21:22 | Ada, Idaho, US | |
2022-11-09 | US | Idaho | Ada | 16001 | 154421 | 1094 | 0 | 43.4526575 | -116.2415516 | 2022-11-10 04:21:16 | Ada, Idaho, US | |
2022-06-14 | US | Ohio | Mahoning | 39099 | 55709 | 1094 | 0 | 41.01631101 | -80.77287029 | 2022-06-15 04:20:54 | Mahoning, Ohio, US | |
2022-06-13 | US | Ohio | Mahoning | 39099 | 55709 | 1094 | 0 | 41.01631101 | -80.77287029 | 2022-06-14 04:20:52 | Mahoning, Ohio, US | |
2022-06-12 | US | Ohio | Mahoning | 39099 | 55709 | 1094 | 0 | 41.01631101 | -80.77287029 | 2022-06-13 04:21:14 | Mahoning, Ohio, US | |
2022-06-11 | US | Ohio | Mahoning | 39099 | 55709 | 1094 | 0 | 41.01631101 | -80.77287029 | 2022-06-12 04:20:53 | Mahoning, Ohio, US | |
2022-05-24 | US | Wisconsin | Waukesha | 55133 | 117686 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-25 04:20:56 | Waukesha, Wisconsin, US | |
2022-05-23 | US | Wisconsin | Waukesha | 55133 | 117133 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-24 04:20:57 | Waukesha, Wisconsin, US | |
2022-05-21 | US | Wisconsin | Waukesha | 55133 | 117133 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-22 04:20:52 | Waukesha, Wisconsin, US | |
2022-05-20 | US | Wisconsin | Waukesha | 55133 | 117133 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-21 04:20:58 | Waukesha, Wisconsin, US | |
2022-05-19 | US | Wisconsin | Waukesha | 55133 | 116939 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-20 04:20:57 | Waukesha, Wisconsin, US | |
2022-05-18 | US | Wisconsin | Waukesha | 55133 | 116705 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-19 04:20:54 | Waukesha, Wisconsin, US | |
2022-05-17 | US | Wisconsin | Waukesha | 55133 | 116505 | 1094 | 0 | 43.01833055 | -88.30431188 | 2022-05-18 04:20:50 | Waukesha, Wisconsin, US | |
2022-03-17 | US | Washington | Snohomish | 53061 | 148175 | 1094 | 0 | 48.04615983 | -121.7170703 | 2022-03-18 04:20:55 | Snohomish, Washington, US | |
2022-03-10 | US | Oregon | Multnomah | 41051 | 111644 | 1094 | 0 | 45.54747959 | -122.4169351 | 2022-03-11 04:20:50 | Multnomah, Oregon, US | |
2022-02-10 | US | Pennsylvania | Chester | 42029 | 88909 | 1094 | 0 | 39.97291773 | -75.74768357 | 2022-02-11 04:21:09 | Chester, Pennsylvania, US | |
2022-02-04 | US | Ohio | Butler | 39017 | 87841 | 1094 | 0 | 39.44012838 | -84.57388716 | 2022-02-05 04:21:05 | Butler, Ohio, US | |
2022-01-27 | US | Kansas | Johnson | 20091 | 131829 | 1094 | 0 | 38.88548175 | -94.82250877 | 2022-01-28 04:21:09 | Johnson, Kansas, US | |
2022-01-26 | US | Kansas | Johnson | 20091 | 131829 | 1094 | 0 | 38.88548175 | -94.82250877 | 2022-01-27 04:21:19 | Johnson, Kansas, US | |
2022-01-23 | US | Washington | Pierce | 53053 | 153896 | 1094 | 0 | 47.03892768 | -122.14059579999999 | 2022-01-24 04:21:12 | Pierce, Washington, US | |
2022-01-22 | US | Washington | Pierce | 53053 | 153896 | 1094 | 0 | 47.03892768 | -122.14059579999999 | 2022-01-23 04:21:13 | Pierce, Washington, US | |
2022-01-21 | US | Washington | Pierce | 53053 | 153896 | 1094 | 0 | 47.03892768 | -122.14059579999999 | 2022-01-22 04:21:13 | Pierce, Washington, US | |
2022-01-06 | US | Texas | Denton | 48121 | 123430 | 1094 | 0 | 33.20521901 | -97.11691153 | 2022-01-07 04:22:09 | Denton, Texas, US | |
2021-12-11 | US | Arizona | Mohave | 4015 | 37149 | 1094 | 0 | 35.70471703 | -113.7577902 | 2021-12-12 04:22:12 | Mohave, Arizona, US | |
2021-12-01 | US | Colorado | Denver | 8031 | 104498 | 1094 | 0 | 39.76018276 | -104.87256950000001 | 2021-12-02 04:22:37 | Denver, Colorado, US | |
2021-11-14 | US | Texas | Montgomery | 48339 | 89388 | 1094 | 0 | 30.30079133 | -95.50572772 | 2021-11-15 04:21:36 | Montgomery, Texas, US | |
2021-11-13 | US | Texas | Montgomery | 48339 | 89388 | 1094 | 0 | 30.30079133 | -95.50572772 | 2021-11-14 04:21:31 | Montgomery, Texas, US | |
2021-11-02 | US | Illinois | Lake | 17097 | 81496 | 1094 | 0 | 42.3224907 | -88.00367925 | 2021-11-03 06:22:09 | Lake, Illinois, US | |
2021-11-01 | US | Illinois | Lake | 17097 | 81410 | 1094 | 0 | 42.3224907 | -88.00367925 | 2021-11-02 04:22:03 | Lake, Illinois, US | |
2021-10-11 | US | Utah | Salt Lake | 49035 | 186166 | 1094 | 0 | 40.66616532 | -111.92160109999999 | 2021-10-12 04:21:09 | Salt Lake, Utah, US | |
2021-10-10 | US | Utah | Salt Lake | 49035 | 186166 | 1094 | 0 | 40.66616532 | -111.92160109999999 | 2021-10-11 04:21:31 | Salt Lake, Utah, US | |
2021-10-09 | US | Utah | Salt Lake | 49035 | 186166 | 1094 | 0 | 40.66616532 | -111.92160109999999 | 2021-10-10 04:21:38 | Salt Lake, Utah, US | |
2021-10-08 | US | Utah | Salt Lake | 49035 | 186166 | 1094 | 0 | 40.66616532 | -111.92160109999999 | 2021-10-09 04:21:34 | Salt Lake, Utah, US | |
2021-10-05 | US | Pennsylvania | Berks | 42011 | 56028 | 1094 | 0 | 40.41570541 | -75.92457766 | 2021-10-06 04:21:33 | Berks, Pennsylvania, US | |
2021-09-27 | US | Illinois | Will | 17197 | 88020 | 1094 | 0 | 41.44619267 | -87.97862712 | 2021-09-28 04:21:28 | Will, Illinois, US | |
2021-09-21 | US | Louisiana | Jefferson | 22051 | 67871 | 1094 | 0 | 29.74075478 | -90.11115756 | 2021-09-22 04:21:45 | Jefferson, Louisiana, US | |
2021-09-20 | US | Louisiana | East Baton Rouge | 22033 | 61776 | 1094 | 0 | 30.53842039 | -91.09777565 | 2021-09-21 04:21:26 | East Baton Rouge, Louisiana, US | |
2021-05-27 | US | New York | Monroe | 36055 | 68161 | 1094 | 0 | 43.14638895 | -77.69322942 | 2021-05-28 04:20:36 | Monroe, New York, US | |
2021-04-19 | US | Pennsylvania | Lancaster | 42071 | 51591 | 1094 | 0 | 40.03904563 | -76.24770128 | 2021-04-20 04:20:41 | Lancaster, Pennsylvania, US | |
2021-04-18 | US | Pennsylvania | Lancaster | 42071 | 51506 | 1094 | 0 | 40.03904563 | -76.24770128 | 2021-04-19 04:20:57 | Lancaster, Pennsylvania, US | |
2021-04-17 | US | Pennsylvania | Lancaster | 42071 | 51365 | 1094 | 0 | 40.03904563 | -76.24770128 | 2021-04-18 04:20:41 | Lancaster, Pennsylvania, US | |
2021-04-07 | US | Massachusetts | Plymouth | 25023 | 45229 | 1094 | 0 | 41.94070556 | -70.80802823 | 2021-04-08 04:21:13 | Plymouth, Massachusetts, US | |
2021-03-22 | US | California | Kern | 6029 | 105542 | 1094 | 0 | 35.34329425 | -118.7277796 | 2021-03-23 05:26:18 | Kern, California, US | |
2021-02-28 | US | Florida | Orange | 12095 | 114322 | 1094 | 0 | 113228 | 28.51367621 | -81.31799498 | 2021-03-01 05:23:01 | Orange, Florida, US |
2021-02-18 | US | Florida | Polk | 12105 | 55269 | 1094 | 0 | 54175 | 27.95027105 | -81.69732947 | 2021-02-19 05:24:16 | Polk, Florida, US |
2021-02-12 | US | New Jersey | Morris | 34027 | 34879 | 1094 | 0 | 33785 | 40.86095313 | -74.54553709999998 | 2021-02-13 05:22:12 | Morris, New Jersey, US |
2021-02-11 | US | New Jersey | Morris | 34027 | 34659 | 1094 | 0 | 33565 | 40.86095313 | -74.54553709999998 | 2021-02-12 05:23:29 | Morris, New Jersey, US |
2021-01-27 | US | Alabama | Jefferson | 1073 | 65606 | 1094 | 0 | 64512 | 33.55554728 | -86.89506300000002 | 2021-01-28 05:22:24 | Jefferson, Alabama, US |
2021-01-22 | US | California | Sacramento | 6067 | 83861 | 1094 | 0 | 82805 | 38.45106826 | -121.3425374 | 2021-01-23 05:22:03 | Sacramento, California, US |
2020-11-29 | US | Puerto Rico | Unassigned | 72999 | 1369 | 1094 | 0 | 275 | 18.459681 | -67.336525 | 2020-11-30 05:26:13 | Unassigned, Puerto Rico, US |
2020-11-11 | US | Texas | Cameron | 48061 | 26703 | 1094 | 0 | 23731 | 26.14524221 | -97.48140372 | 2020-11-12 05:25:55 | Cameron, Texas, US |
2020-11-10 | US | Texas | Cameron | 48061 | 26671 | 1094 | 0 | 23653 | 26.14524221 | -97.48140372 | 2020-11-11 05:25:30 | Cameron, Texas, US |
2020-10-26 | US | New York | Richmond | 36085 | 17255 | 1094 | 0 | 16161 | 40.58582155 | -74.14808598 | 2020-10-27 04:24:45 | Richmond, New York, US |
2020-10-25 | US | New York | Richmond | 36085 | 17193 | 1094 | 0 | 16099 | 40.58582155 | -74.14808598 | 2020-10-26 04:25:02 | Richmond, New York, US |
2020-10-24 | US | New York | Richmond | 36085 | 17091 | 1094 | 0 | 15997 | 40.58582155 | -74.14808598 | 2020-10-25 04:24:36 | Richmond, New York, US |
2020-10-23 | US | New York | Richmond | 36085 | 17030 | 1094 | 0 | 15936 | 40.58582155 | -74.14808598 | 2020-10-24 04:24:46 | Richmond, New York, US |
2020-08-27 | US | Florida | Palm Beach | 12099 | 41195 | 1094 | 0 | 40101 | 26.64676272 | -80.46536002 | 2020-08-28 04:28:11 | Palm Beach, Florida, US |
2020-06-18 | US | New Jersey | Middlesex | 34023 | 16580 | 1094 | 0 | 15486 | 40.43629879 | -74.41426991 | 2020-06-19 04:33:17 | Middlesex, New Jersey, US |
2020-06-17 | US | New Jersey | Middlesex | 34023 | 16546 | 1094 | 0 | 15452 | 40.43629879 | -74.41426991 | 2020-06-18 04:33:18 | Middlesex, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;