johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "US" and deaths = 2911 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3215902 | 3215902 | 2022-10-12 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 23:22:35 | Essex, Massachusetts, US | |
3251751 | 3251751 | 2022-10-11 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 23:22:35 | Essex, Massachusetts, US | |
2969010 | 2969010 | 2022-10-10 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-11 04:23:05 | Essex, Massachusetts, US | |
3099046 | 3099046 | 2022-10-09 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-10 04:22:32 | Essex, Massachusetts, US | |
4004271 | 4004271 | 2022-10-08 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-09 04:21:16 | Essex, Massachusetts, US | |
397868 | 397868 | 2022-10-07 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-08 04:22:56 | Essex, Massachusetts, US | |
2530985 | 2530985 | 2022-10-06 | US | Massachusetts | Essex | 25009 | 239911 | 2911 | 0 | 42.6687626 | -70.94687179 | 2022-10-07 04:23:08 | Essex, Massachusetts, US | |
3619258 | 3619258 | 2022-08-01 | US | New Jersey | Middlesex | 34023 | 233159 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-08-02 04:20:53 | Middlesex, New Jersey, US | |
3873738 | 3873738 | 2022-07-31 | US | New Jersey | Middlesex | 34023 | 233000 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-08-01 04:21:03 | Middlesex, New Jersey, US | |
676492 | 676492 | 2022-07-30 | US | New Jersey | Middlesex | 34023 | 232774 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-07-31 04:21:02 | Middlesex, New Jersey, US | |
1785691 | 1785691 | 2022-07-29 | US | New Jersey | Middlesex | 34023 | 232486 | 2911 | 0 | 40.43629879 | -74.41426991 | 2022-07-30 04:20:42 | Middlesex, New Jersey, US | |
1722662 | 1722662 | 2022-03-25 | US | New Jersey | Ocean | 34029 | 161147 | 2911 | 0 | 39.8895449 | -74.28089251 | 2022-03-26 04:20:23 | Ocean, New Jersey, US | |
450451 | 450451 | 2021-11-17 | US | Texas | El Paso | 48141 | 133981 | 2911 | 0 | 31.76980765 | -106.23632749999999 | 2021-11-18 04:21:33 | El Paso, Texas, US | |
2353598 | 2353598 | 2021-08-10 | US | New Jersey | Bergen | 34003 | 107723 | 2911 | 0 | 40.96010917 | -74.07164325 | 2021-08-11 04:21:58 | Bergen, New Jersey, US | |
652127 | 652127 | 2021-08-09 | US | New Jersey | Bergen | 34003 | 107533 | 2911 | 0 | 40.96010917 | -74.07164325 | 2021-08-10 04:21:27 | Bergen, New Jersey, US | |
1935551 | 1935551 | 2021-07-05 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-06 04:21:32 | Hidalgo, Texas, US | |
1168282 | 1168282 | 2021-07-04 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-05 04:21:28 | Hidalgo, Texas, US | |
1498716 | 1498716 | 2021-07-03 | US | Texas | Hidalgo | 48215 | 100570 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-04 04:21:38 | Hidalgo, Texas, US | |
2075031 | 2075031 | 2021-07-02 | US | Texas | Hidalgo | 48215 | 100510 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-03 04:21:37 | Hidalgo, Texas, US | |
2768047 | 2768047 | 2021-07-01 | US | Texas | Hidalgo | 48215 | 100404 | 2911 | 0 | 26.39418217 | -98.18299696 | 2021-07-02 04:21:47 | Hidalgo, Texas, US | |
342960 | 342960 | 2021-02-03 | US | Pennsylvania | Philadelphia | 42101 | 112145 | 2911 | 0 | 109234 | 40.00338507 | -75.1379271 | 2021-02-04 05:22:26 | Philadelphia, Pennsylvania, 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]);