johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where country_or_region = "US" and deaths = 2003 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 8
- Massachusetts 13
- Pennsylvania 9
- New Jersey 5
- California 3
- Indiana 1
- New York 1
- Ohio 1
- Tennessee 1
country_or_region 1
- US · 34 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1622958 | 1622958 | 2022-11-22 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-23 04:21:06 | Lancaster, Pennsylvania, US | |
3462846 | 3462846 | 2022-11-21 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-22 04:20:47 | Lancaster, Pennsylvania, US | |
1643031 | 1643031 | 2022-11-20 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-21 04:21:05 | Lancaster, Pennsylvania, US | |
2066588 | 2066588 | 2022-11-19 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-20 04:21:08 | Lancaster, Pennsylvania, US | |
1757982 | 1757982 | 2022-11-18 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-19 04:21:14 | Lancaster, Pennsylvania, US | |
3028975 | 3028975 | 2022-11-17 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-18 04:21:15 | Lancaster, Pennsylvania, US | |
2488686 | 2488686 | 2022-11-16 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-17 04:21:11 | Lancaster, Pennsylvania, US | |
1288696 | 1288696 | 2022-01-04 | US | Pennsylvania | Montgomery | 42091 | 116669 | 2003 | 0 | 40.21053671 | -75.36652296 | 2022-01-05 04:21:59 | Montgomery, Pennsylvania, US | |
3498653 | 3498653 | 2021-12-15 | US | Ohio | Franklin | 39049 | 186244 | 2003 | 0 | 39.96995815 | -83.01115755 | 2021-12-16 04:22:11 | Franklin, Ohio, US | |
1911390 | 1911390 | 2021-10-17 | US | New Jersey | Passaic | 34031 | 80984 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-18 04:21:10 | Passaic, New Jersey, US | |
936979 | 936979 | 2021-10-16 | US | New Jersey | Passaic | 34031 | 80939 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-17 04:21:29 | Passaic, New Jersey, US | |
2945534 | 2945534 | 2021-10-15 | US | New Jersey | Passaic | 34031 | 80864 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-16 04:21:15 | Passaic, New Jersey, US | |
1236757 | 1236757 | 2021-09-27 | US | Indiana | Marion | 18097 | 129908 | 2003 | 0 | 39.78163624 | -86.13826325 | 2021-09-28 04:21:28 | Marion, Indiana, US | |
812566 | 812566 | 2021-09-20 | US | Tennessee | Shelby | 47157 | 137320 | 2003 | 0 | 35.1864775 | -89.89692423 | 2021-09-21 04:21:26 | Shelby, Tennessee, US | |
69241 | 69241 | 2021-09-01 | US | New Jersey | Union | 34039 | 75633 | 2003 | 0 | 40.65835409 | -74.30680092 | 2021-09-02 04:21:15 | Union, New Jersey, US | |
591223 | 591223 | 2021-08-08 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-09 04:21:24 | Essex, Massachusetts, US | |
2205235 | 2205235 | 2021-08-07 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-08 04:21:33 | Essex, Massachusetts, US | |
1119185 | 1119185 | 2021-08-06 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-07 04:21:30 | Essex, Massachusetts, US | |
1958122 | 1958122 | 2021-08-05 | US | Massachusetts | Essex | 25009 | 99325 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-06 04:21:18 | Essex, Massachusetts, US | |
333501 | 333501 | 2021-08-04 | US | Massachusetts | Essex | 25009 | 99203 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-05 04:21:51 | Essex, Massachusetts, US | |
3469772 | 3469772 | 2021-08-03 | US | Massachusetts | Essex | 25009 | 99113 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-04 04:21:25 | Essex, Massachusetts, US | |
3685046 | 3685046 | 2021-08-02 | US | Massachusetts | Essex | 25009 | 99022 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-03 04:21:39 | Essex, Massachusetts, US | |
3016945 | 3016945 | 2021-08-01 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-02 04:21:36 | Essex, Massachusetts, US | |
3905568 | 3905568 | 2021-07-31 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-01 04:21:50 | Essex, Massachusetts, US | |
3297773 | 3297773 | 2021-07-30 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-31 04:21:35 | Essex, Massachusetts, US | |
3386984 | 3386984 | 2021-07-29 | US | Massachusetts | Essex | 25009 | 98743 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-30 04:21:34 | Essex, Massachusetts, US | |
409889 | 409889 | 2021-07-28 | US | Massachusetts | Essex | 25009 | 98685 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-29 04:21:33 | Essex, Massachusetts, US | |
2342035 | 2342035 | 2021-06-15 | US | Pennsylvania | Allegheny | 42003 | 102345 | 2003 | 0 | 40.46809875 | -79.98167747 | 2021-06-16 04:22:32 | Allegheny, Pennsylvania, US | |
2821344 | 2821344 | 2021-05-10 | US | California | Santa Clara | 6085 | 119556 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-11 04:20:41 | Santa Clara, California, US | |
1425676 | 1425676 | 2021-05-09 | US | California | Santa Clara | 6085 | 119531 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-10 04:20:38 | Santa Clara, California, US | |
1552544 | 1552544 | 2021-05-08 | US | California | Santa Clara | 6085 | 119484 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-09 04:20:35 | Santa Clara, California, US | |
1107806 | 1107806 | 2020-09-02 | US | New York | Suffolk | 36103 | 44940 | 2003 | 0 | 42937 | 40.88320119 | -72.8012172 | 2020-09-03 04:28:22 | Suffolk, New York, US |
3921667 | 3921667 | 2020-08-09 | US | Massachusetts | Middlesex | 25017 | 26420 | 2003 | 0 | 24417 | 42.48607732 | -71.39049229 | 2020-08-10 04:34:55 | Middlesex, Massachusetts, US |
526745 | 526745 | 2020-07-04 | US | New Jersey | Bergen | 34003 | 19732 | 2003 | 0 | 17729 | 40.96010917 | -74.07164325 | 2020-07-05 04:33:46 | Bergen, New Jersey, 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]);