ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 406 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 19
county 19
- Cambria 8
- Somerset 6
- Washington 4
- Butler 3
- Lackawanna 2
- Lancaster 2
- Lawrence 2
- Schuylkill 2
- Allegheny 1
- Beaver 1
- Berks 1
- Chester 1
- Dauphin 1
- Franklin 1
- Lebanon 1
- Luzerne 1
- Mercer 1
- Northampton 1
- Northumberland 1
state 1
- Pennsylvania · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449791 | 2449791 | 2022-04-27 | Somerset | Pennsylvania | 42111 | 18761 | 406 |
2446534 | 2446534 | 2022-04-26 | Somerset | Pennsylvania | 42111 | 18759 | 406 |
2443279 | 2443279 | 2022-04-25 | Somerset | Pennsylvania | 42111 | 18755 | 406 |
2440023 | 2440023 | 2022-04-24 | Somerset | Pennsylvania | 42111 | 18754 | 406 |
2436767 | 2436767 | 2022-04-23 | Somerset | Pennsylvania | 42111 | 18753 | 406 |
2433511 | 2433511 | 2022-04-22 | Somerset | Pennsylvania | 42111 | 18750 | 406 |
2270802 | 2270802 | 2022-03-03 | Lawrence | Pennsylvania | 42073 | 18771 | 406 |
2267550 | 2267550 | 2022-03-02 | Lawrence | Pennsylvania | 42073 | 18761 | 406 |
2085421 | 2085421 | 2022-01-05 | Lebanon | Pennsylvania | 42075 | 28765 | 406 |
2036671 | 2036671 | 2021-12-21 | Mercer | Pennsylvania | 42085 | 17525 | 406 |
1913172 | 1913172 | 2021-11-13 | Washington | Pennsylvania | 42125 | 27578 | 406 |
1909922 | 1909922 | 2021-11-12 | Washington | Pennsylvania | 42125 | 27163 | 406 |
1906673 | 1906673 | 2021-11-11 | Washington | Pennsylvania | 42125 | 26988 | 406 |
1903424 | 1903424 | 2021-11-10 | Washington | Pennsylvania | 42125 | 26877 | 406 |
1880661 | 1880661 | 2021-11-03 | Northumberland | Pennsylvania | 42097 | 13013 | 406 |
1750677 | 1750677 | 2021-09-24 | Franklin | Pennsylvania | 42055 | 19192 | 406 |
1679177 | 1679177 | 2021-09-02 | Beaver | Pennsylvania | 42007 | 17059 | 406 |
1357779 | 1357779 | 2021-05-26 | Schuylkill | Pennsylvania | 42107 | 14675 | 406 |
1354533 | 1354533 | 2021-05-25 | Schuylkill | Pennsylvania | 42107 | 14660 | 406 |
1283063 | 1283063 | 2021-05-03 | Butler | Pennsylvania | 42019 | 16860 | 406 |
1279816 | 1279816 | 2021-05-02 | Butler | Pennsylvania | 42019 | 16840 | 406 |
1276569 | 1276569 | 2021-05-01 | Butler | Pennsylvania | 42019 | 16801 | 406 |
1201880 | 1201880 | 2021-04-08 | Cambria | Pennsylvania | 42021 | 12546 | 406 |
1198631 | 1198631 | 2021-04-07 | Cambria | Pennsylvania | 42021 | 12510 | 406 |
1195382 | 1195382 | 2021-04-06 | Cambria | Pennsylvania | 42021 | 12473 | 406 |
1192134 | 1192134 | 2021-04-05 | Cambria | Pennsylvania | 42021 | 12433 | 406 |
1188885 | 1188885 | 2021-04-04 | Cambria | Pennsylvania | 42021 | 12426 | 406 |
1185638 | 1185638 | 2021-04-03 | Cambria | Pennsylvania | 42021 | 12400 | 406 |
1182391 | 1182391 | 2021-04-02 | Cambria | Pennsylvania | 42021 | 12325 | 406 |
1179144 | 1179144 | 2021-04-01 | Cambria | Pennsylvania | 42021 | 12296 | 406 |
1049309 | 1049309 | 2021-02-20 | Lackawanna | Pennsylvania | 42069 | 13563 | 406 |
1046062 | 1046062 | 2021-02-19 | Lackawanna | Pennsylvania | 42069 | 13507 | 406 |
951929 | 951929 | 2021-01-21 | Dauphin | Pennsylvania | 42043 | 16903 | 406 |
867576 | 867576 | 2020-12-26 | Northampton | Pennsylvania | 42095 | 15679 | 406 |
851343 | 851343 | 2020-12-21 | Luzerne | Pennsylvania | 42079 | 15340 | 406 |
789653 | 789653 | 2020-12-02 | Chester | Pennsylvania | 42029 | 12654 | 406 |
650131 | 650131 | 2020-10-20 | Allegheny | Pennsylvania | 42003 | 14277 | 406 |
617688 | 617688 | 2020-10-10 | Berks | Pennsylvania | 42011 | 7726 | 406 |
388212 | 388212 | 2020-07-31 | Lancaster | Pennsylvania | 42071 | 5525 | 406 |
384995 | 384995 | 2020-07-30 | Lancaster | Pennsylvania | 42071 | 5488 | 406 |
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);