johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where country_or_region = "US" and deaths = 2401 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 5
- Pennsylvania 7
- New Jersey 5
- New York 5
- Wisconsin 5
- Maryland 1
country_or_region 1
- US · 23 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295583 | 295583 | 2022-11-15 | US | Wisconsin | Milwaukee | 55079 | 323925 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-16 04:21:09 | Milwaukee, Wisconsin, US | |
3600613 | 3600613 | 2022-11-14 | US | Wisconsin | Milwaukee | 55079 | 323768 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-15 04:21:16 | Milwaukee, Wisconsin, US | |
315471 | 315471 | 2022-11-13 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-14 04:21:09 | Milwaukee, Wisconsin, US | |
66632 | 66632 | 2022-11-12 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-13 04:21:14 | Milwaukee, Wisconsin, US | |
2930794 | 2930794 | 2022-11-11 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-12 04:20:41 | Milwaukee, Wisconsin, US | |
1368661 | 1368661 | 2022-10-28 | US | New Jersey | Passaic | 34031 | 176661 | 2401 | 0 | 41.03238628 | -74.29954144 | 2022-10-29 04:21:13 | Passaic, New Jersey, US | |
1407735 | 1407735 | 2022-08-02 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-03 04:20:59 | Montgomery, Pennsylvania, US | |
3619773 | 3619773 | 2022-08-01 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-02 04:20:53 | Montgomery, Pennsylvania, US | |
3873826 | 3873826 | 2022-07-31 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-08-01 04:21:03 | Richmond, New York, US | |
3874253 | 3874253 | 2022-07-31 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-01 04:21:03 | Montgomery, Pennsylvania, US | |
676580 | 676580 | 2022-07-30 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-31 04:21:02 | Richmond, New York, US | |
677007 | 677007 | 2022-07-30 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-31 04:21:02 | Montgomery, Pennsylvania, US | |
1785779 | 1785779 | 2022-07-29 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-30 04:20:42 | Richmond, New York, US | |
1786206 | 1786206 | 2022-07-29 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-30 04:20:42 | Montgomery, Pennsylvania, US | |
1068142 | 1068142 | 2022-07-28 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-29 04:20:45 | Richmond, New York, US | |
1068569 | 1068569 | 2022-07-28 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-29 04:20:45 | Montgomery, Pennsylvania, US | |
2338088 | 2338088 | 2022-07-27 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-28 04:20:56 | Montgomery, Pennsylvania, US | |
2421076 | 2421076 | 2022-07-15 | US | New Jersey | Union | 34039 | 164551 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-16 04:21:05 | Union, New Jersey, US | |
3431151 | 3431151 | 2022-07-14 | US | New Jersey | Union | 34039 | 164271 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-15 04:20:53 | Union, New Jersey, US | |
3111671 | 3111671 | 2022-07-13 | US | New Jersey | Union | 34039 | 163998 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-14 04:20:57 | Union, New Jersey, US | |
632094 | 632094 | 2022-07-12 | US | New Jersey | Union | 34039 | 163761 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-13 04:20:58 | Union, New Jersey, US | |
1059422 | 1059422 | 2022-02-23 | US | Maryland | Baltimore | 24005 | 130249 | 2401 | 0 | 39.45784712 | -76.62911955 | 2022-02-24 04:21:14 | Baltimore, Maryland, US | |
1139121 | 1139121 | 2021-01-01 | US | New York | Nassau | 36059 | 89460 | 2401 | 0 | 87059 | 40.74066522 | -73.58941873 | 2021-01-02 05:22:33 | Nassau, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);