ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where deaths = 217 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 22
county 22
- Lackawanna 21
- Carbon 5
- Lawrence 4
- Centre 3
- Somerset 3
- Adams 2
- Allegheny 1
- Beaver 1
- Bucks 1
- Columbia 1
- Crawford 1
- Cumberland 1
- Dauphin 1
- Fayette 1
- Huntingdon 1
- Lebanon 1
- Mercer 1
- Monroe 1
- Montgomery 1
- Schuylkill 1
- Venango 1
- York 1
state 1
- Pennsylvania · 54 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179732 | 2179732 | 2022-02-03 | Columbia | Pennsylvania | 42037 | 14212 | 217 |
2156997 | 2156997 | 2022-01-27 | Venango | Pennsylvania | 42121 | 10580 | 217 |
2137445 | 2137445 | 2022-01-21 | Huntingdon | Pennsylvania | 42061 | 10024 | 217 |
1994382 | 1994382 | 2021-12-08 | Carbon | Pennsylvania | 42025 | 10433 | 217 |
1991131 | 1991131 | 2021-12-07 | Carbon | Pennsylvania | 42025 | 10402 | 217 |
1987880 | 1987880 | 2021-12-06 | Carbon | Pennsylvania | 42025 | 10362 | 217 |
1984630 | 1984630 | 2021-12-05 | Carbon | Pennsylvania | 42025 | 10320 | 217 |
1981380 | 1981380 | 2021-12-04 | Carbon | Pennsylvania | 42025 | 10267 | 217 |
1948881 | 1948881 | 2021-11-24 | Crawford | Pennsylvania | 42039 | 12949 | 217 |
1838373 | 1838373 | 2021-10-21 | Adams | Pennsylvania | 42001 | 12976 | 217 |
1835124 | 1835124 | 2021-10-20 | Adams | Pennsylvania | 42001 | 12934 | 217 |
1559022 | 1559022 | 2021-07-27 | Lawrence | Pennsylvania | 42073 | 7797 | 217 |
1555775 | 1555775 | 2021-07-26 | Lawrence | Pennsylvania | 42073 | 7784 | 217 |
1552528 | 1552528 | 2021-07-25 | Lawrence | Pennsylvania | 42073 | 7768 | 217 |
1549281 | 1549281 | 2021-07-24 | Lawrence | Pennsylvania | 42073 | 7765 | 217 |
1429184 | 1429184 | 2021-06-17 | Somerset | Pennsylvania | 42111 | 8057 | 217 |
1425939 | 1425939 | 2021-06-16 | Somerset | Pennsylvania | 42111 | 8052 | 217 |
1422692 | 1422692 | 2021-06-15 | Somerset | Pennsylvania | 42111 | 8050 | 217 |
1250597 | 1250597 | 2021-04-23 | Centre | Pennsylvania | 42027 | 15992 | 217 |
1247350 | 1247350 | 2021-04-22 | Centre | Pennsylvania | 42027 | 15959 | 217 |
1244103 | 1244103 | 2021-04-21 | Centre | Pennsylvania | 42027 | 15844 | 217 |
974665 | 974665 | 2021-01-28 | Mercer | Pennsylvania | 42085 | 7394 | 217 |
971403 | 971403 | 2021-01-27 | Fayette | Pennsylvania | 42051 | 9525 | 217 |
971415 | 971415 | 2021-01-27 | Lebanon | Pennsylvania | 42075 | 11511 | 217 |
919498 | 919498 | 2021-01-11 | Monroe | Pennsylvania | 42089 | 7163 | 217 |
848062 | 848062 | 2020-12-20 | Beaver | Pennsylvania | 42007 | 7294 | 217 |
838376 | 838376 | 2020-12-17 | Schuylkill | Pennsylvania | 42107 | 6083 | 217 |
828604 | 828604 | 2020-12-14 | Cumberland | Pennsylvania | 42041 | 7882 | 217 |
776680 | 776680 | 2020-11-28 | Dauphin | Pennsylvania | 42043 | 7611 | 217 |
718312 | 718312 | 2020-11-10 | York | Pennsylvania | 42133 | 7477 | 217 |
650164 | 650164 | 2020-10-20 | Lackawanna | Pennsylvania | 42069 | 3356 | 217 |
646920 | 646920 | 2020-10-19 | Lackawanna | Pennsylvania | 42069 | 3314 | 217 |
643674 | 643674 | 2020-10-18 | Lackawanna | Pennsylvania | 42069 | 3290 | 217 |
640426 | 640426 | 2020-10-17 | Lackawanna | Pennsylvania | 42069 | 3244 | 217 |
637180 | 637180 | 2020-10-16 | Lackawanna | Pennsylvania | 42069 | 3197 | 217 |
633934 | 633934 | 2020-10-15 | Lackawanna | Pennsylvania | 42069 | 3125 | 217 |
630689 | 630689 | 2020-10-14 | Lackawanna | Pennsylvania | 42069 | 3065 | 217 |
627445 | 627445 | 2020-10-13 | Lackawanna | Pennsylvania | 42069 | 3022 | 217 |
624203 | 624203 | 2020-10-12 | Lackawanna | Pennsylvania | 42069 | 2974 | 217 |
620960 | 620960 | 2020-10-11 | Lackawanna | Pennsylvania | 42069 | 2936 | 217 |
617717 | 617717 | 2020-10-10 | Lackawanna | Pennsylvania | 42069 | 2908 | 217 |
614475 | 614475 | 2020-10-09 | Lackawanna | Pennsylvania | 42069 | 2844 | 217 |
591780 | 591780 | 2020-10-02 | Lackawanna | Pennsylvania | 42069 | 2656 | 217 |
588539 | 588539 | 2020-10-01 | Lackawanna | Pennsylvania | 42069 | 2619 | 217 |
585299 | 585299 | 2020-09-30 | Lackawanna | Pennsylvania | 42069 | 2594 | 217 |
582059 | 582059 | 2020-09-29 | Lackawanna | Pennsylvania | 42069 | 2579 | 217 |
578819 | 578819 | 2020-09-28 | Lackawanna | Pennsylvania | 42069 | 2555 | 217 |
575578 | 575578 | 2020-09-27 | Lackawanna | Pennsylvania | 42069 | 2541 | 217 |
572334 | 572334 | 2020-09-26 | Lackawanna | Pennsylvania | 42069 | 2505 | 217 |
569092 | 569092 | 2020-09-25 | Lackawanna | Pennsylvania | 42069 | 2459 | 217 |
565851 | 565851 | 2020-09-24 | Lackawanna | Pennsylvania | 42069 | 2424 | 217 |
359264 | 359264 | 2020-07-22 | Allegheny | Pennsylvania | 42003 | 6670 | 217 |
103061 | 103061 | 2020-04-30 | Bucks | Pennsylvania | 42017 | 3070 | 217 |
91730 | 91730 | 2020-04-26 | Montgomery | Pennsylvania | 42091 | 3733 | 217 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);