johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where country_or_region = "US" and deaths = 1894 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 9
- Pennsylvania 15
- New Jersey 11
- Georgia 7
- Florida 6
- Indiana 5
- New York 4
- California 3
- Massachusetts 1
- Ohio 1
country_or_region 1
- US · 53 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132921 | 132921 | 2022-10-04 | US | New Jersey | Camden | 34007 | 153717 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-10-05 04:23:06 | Camden, New Jersey, US | |
2687868 | 2687868 | 2022-10-03 | US | New Jersey | Camden | 34007 | 153607 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-10-04 04:22:55 | Camden, New Jersey, US | |
2261935 | 2261935 | 2022-10-02 | US | New Jersey | Camden | 34007 | 153535 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-10-03 04:23:11 | Camden, New Jersey, US | |
2997461 | 2997461 | 2022-10-01 | US | New Jersey | Camden | 34007 | 153463 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-10-02 04:21:23 | Camden, New Jersey, US | |
855787 | 855787 | 2022-09-30 | US | New Jersey | Camden | 34007 | 153346 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-10-01 04:23:01 | Camden, New Jersey, US | |
2017838 | 2017838 | 2022-09-20 | US | Indiana | Lake | 18089 | 124044 | 1894 | 0 | 41.41874274 | -87.38277575 | 2022-09-21 04:23:22 | Lake, Indiana, US | |
3571711 | 3571711 | 2022-09-19 | US | Indiana | Lake | 18089 | 124044 | 1894 | 0 | 41.41874274 | -87.38277575 | 2022-09-20 04:22:48 | Lake, Indiana, US | |
420450 | 420450 | 2022-09-18 | US | Indiana | Lake | 18089 | 123921 | 1894 | 0 | 41.41874274 | -87.38277575 | 2022-09-19 04:21:49 | Lake, Indiana, US | |
3374474 | 3374474 | 2022-09-17 | US | Indiana | Lake | 18089 | 123921 | 1894 | 0 | 41.41874274 | -87.38277575 | 2022-09-18 04:22:50 | Lake, Indiana, US | |
2356582 | 2356582 | 2022-09-16 | US | Indiana | Lake | 18089 | 123921 | 1894 | 0 | 41.41874274 | -87.38277575 | 2022-09-17 04:20:19 | Lake, Indiana, US | |
2357639 | 2357639 | 2022-09-16 | US | New Jersey | Camden | 34007 | 151435 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-09-17 04:20:19 | Camden, New Jersey, US | |
1891313 | 1891313 | 2022-09-14 | US | New Jersey | Camden | 34007 | 151139 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-09-15 04:21:02 | Camden, New Jersey, US | |
374368 | 374368 | 2022-09-13 | US | New Jersey | Camden | 34007 | 151012 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-09-14 04:20:44 | Camden, New Jersey, US | |
3768048 | 3768048 | 2022-09-11 | US | New Jersey | Camden | 34007 | 150840 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-09-12 04:20:58 | Camden, New Jersey, US | |
3826623 | 3826623 | 2022-09-10 | US | New Jersey | Camden | 34007 | 150745 | 1894 | 0 | 39.80343818 | -74.96388753 | 2022-09-11 04:20:50 | Camden, New Jersey, US | |
2492686 | 2492686 | 2022-06-29 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-30 04:21:01 | Delaware, Pennsylvania, US | |
2242068 | 2242068 | 2022-06-28 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-29 04:20:59 | Delaware, Pennsylvania, US | |
2150310 | 2150310 | 2022-06-27 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-28 04:20:58 | Delaware, Pennsylvania, US | |
478111 | 478111 | 2022-06-26 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-27 04:21:00 | Delaware, Pennsylvania, US | |
941486 | 941486 | 2022-06-25 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-26 04:21:02 | Delaware, Pennsylvania, US | |
3349306 | 3349306 | 2022-06-24 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-25 04:20:57 | Delaware, Pennsylvania, US | |
1651047 | 1651047 | 2022-06-23 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-24 04:20:58 | Delaware, Pennsylvania, US | |
2190282 | 2190282 | 2022-06-22 | US | Pennsylvania | Delaware | 42045 | 120156 | 1894 | 0 | 39.91680171 | -75.40243663 | 2022-06-23 04:20:55 | Delaware, Pennsylvania, US | |
166859 | 166859 | 2022-06-21 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-22 04:20:54 | Gwinnett, Georgia, US | |
1764142 | 1764142 | 2022-06-20 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-21 04:20:56 | Gwinnett, Georgia, US | |
3270328 | 3270328 | 2022-06-19 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-20 04:21:01 | Gwinnett, Georgia, US | |
3398240 | 3398240 | 2022-06-18 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-19 04:20:51 | Gwinnett, Georgia, US | |
2312117 | 2312117 | 2022-06-17 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-18 04:21:10 | Gwinnett, Georgia, US | |
559621 | 559621 | 2022-06-16 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-17 04:20:56 | Gwinnett, Georgia, US | |
3983423 | 3983423 | 2022-06-15 | US | Georgia | Gwinnett | 13135 | 217991 | 1894 | 0 | 33.96044201 | -84.02137802 | 2022-06-16 04:20:55 | Gwinnett, Georgia, US | |
3001987 | 3001987 | 2022-05-24 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-25 04:20:56 | Lancaster, Pennsylvania, US | |
3595708 | 3595708 | 2022-05-23 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-24 04:20:57 | Lancaster, Pennsylvania, US | |
1112256 | 1112256 | 2022-05-21 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-22 04:20:52 | Lancaster, Pennsylvania, US | |
1171880 | 1171880 | 2022-05-20 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-21 04:20:58 | Lancaster, Pennsylvania, US | |
3898643 | 3898643 | 2022-05-19 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-20 04:20:57 | Lancaster, Pennsylvania, US | |
1187427 | 1187427 | 2022-05-18 | US | Pennsylvania | Lancaster | 42071 | 123647 | 1894 | 0 | 40.03904563 | -76.24770128 | 2022-05-19 04:20:54 | Lancaster, Pennsylvania, US | |
3267102 | 3267102 | 2022-05-04 | US | Massachusetts | Norfolk | 25021 | 137846 | 1894 | 0 | 42.16073095 | -71.20530408 | 2022-05-05 04:20:55 | Norfolk, Massachusetts, US | |
186754 | 186754 | 2022-02-13 | US | Florida | Brevard | 12009 | 130820 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-14 04:20:51 | Brevard, Florida, US | |
316600 | 316600 | 2022-02-12 | US | Florida | Brevard | 12009 | 130820 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-13 04:21:00 | Brevard, Florida, US | |
233926 | 233926 | 2022-02-11 | US | Florida | Brevard | 12009 | 130820 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-12 04:21:06 | Brevard, Florida, US | |
1464768 | 1464768 | 2022-02-10 | US | Florida | Brevard | 12009 | 127432 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-11 04:21:09 | Brevard, Florida, US | |
3074729 | 3074729 | 2022-02-09 | US | Florida | Brevard | 12009 | 127432 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-10 04:21:14 | Brevard, Florida, US | |
1363036 | 1363036 | 2022-02-08 | US | Florida | Brevard | 12009 | 127432 | 1894 | 0 | 28.29409504 | -80.73091022 | 2022-02-09 04:21:04 | Brevard, Florida, US | |
3228628 | 3228628 | 2022-01-19 | US | New Jersey | Monmouth | 34025 | 151317 | 1894 | 0 | 40.26549699 | -74.22240686 | 2022-01-20 04:21:07 | Monmouth, New Jersey, US | |
1016798 | 1016798 | 2021-11-21 | US | Ohio | Franklin | 39049 | 173422 | 1894 | 0 | 39.96995815 | -83.01115755 | 2021-11-22 04:22:20 | Franklin, Ohio, US | |
2001242 | 2001242 | 2021-11-07 | US | California | Santa Clara | 6085 | 148409 | 1894 | 0 | 37.23104908 | -121.6970462 | 2021-11-08 04:21:43 | Santa Clara, California, US | |
496233 | 496233 | 2021-11-06 | US | California | Santa Clara | 6085 | 147869 | 1894 | 0 | 37.23104908 | -121.6970462 | 2021-11-07 04:21:53 | Santa Clara, California, US | |
3122088 | 3122088 | 2021-11-05 | US | California | Santa Clara | 6085 | 147868 | 1894 | 0 | 37.23104908 | -121.6970462 | 2021-11-06 04:21:51 | Santa Clara, California, US | |
1237878 | 1237878 | 2021-09-27 | US | New York | Erie | 36029 | 100356 | 1894 | 0 | 42.76249024 | -78.73063652 | 2021-09-28 04:21:28 | Erie, New York, US | |
3451102 | 3451102 | 2021-09-10 | US | New York | Richmond | 36085 | 83921 | 1894 | 0 | 40.58582155 | -74.14808598 | 2021-09-11 04:21:30 | Richmond, New York, US | |
1265048 | 1265048 | 2021-09-09 | US | New York | Richmond | 36085 | 83723 | 1894 | 0 | 40.58582155 | -74.14808598 | 2021-09-10 04:21:20 | Richmond, New York, US | |
1638954 | 1638954 | 2021-04-29 | US | Pennsylvania | Allegheny | 42003 | 97387 | 1894 | 0 | 40.46809875 | -79.98167747 | 2021-04-30 04:21:03 | Allegheny, Pennsylvania, US | |
2213938 | 2213938 | 2021-01-30 | US | New York | Westchester | 36119 | 93585 | 1894 | 0 | 91691 | 41.16278376 | -73.75741653 | 2021-01-31 05:22:42 | Westchester, 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]);