ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where deaths = 328 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Fayette 26
- Armstrong 6
- Indiana 6
- Northumberland 6
- Erie 2
- Beaver 1
- Blair 1
- Butler 1
- Centre 1
- Chester 1
- Clearfield 1
- Franklin 1
- Lawrence 1
- Northampton 1
- Somerset 1
state 1
- Pennsylvania · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2267530 | 2267530 | 2022-03-02 | Clearfield | Pennsylvania | 42033 | 19067 | 328 |
2241507 | 2241507 | 2022-02-22 | Armstrong | Pennsylvania | 42005 | 15063 | 328 |
2238256 | 2238256 | 2022-02-21 | Armstrong | Pennsylvania | 42005 | 15048 | 328 |
2235005 | 2235005 | 2022-02-20 | Armstrong | Pennsylvania | 42005 | 15048 | 328 |
2231754 | 2231754 | 2022-02-19 | Armstrong | Pennsylvania | 42005 | 15039 | 328 |
2228503 | 2228503 | 2022-02-18 | Armstrong | Pennsylvania | 42005 | 15009 | 328 |
2225252 | 2225252 | 2022-02-17 | Armstrong | Pennsylvania | 42005 | 14989 | 328 |
2202518 | 2202518 | 2022-02-10 | Indiana | Pennsylvania | 42063 | 16743 | 328 |
2199264 | 2199264 | 2022-02-09 | Indiana | Pennsylvania | 42063 | 16685 | 328 |
2195992 | 2195992 | 2022-02-08 | Centre | Pennsylvania | 42027 | 33921 | 328 |
2196010 | 2196010 | 2022-02-08 | Indiana | Pennsylvania | 42063 | 16627 | 328 |
2192756 | 2192756 | 2022-02-07 | Indiana | Pennsylvania | 42063 | 16638 | 328 |
2189502 | 2189502 | 2022-02-06 | Indiana | Pennsylvania | 42063 | 16590 | 328 |
2186249 | 2186249 | 2022-02-05 | Indiana | Pennsylvania | 42063 | 16542 | 328 |
2065931 | 2065931 | 2021-12-30 | Somerset | Pennsylvania | 42111 | 13975 | 328 |
2059412 | 2059412 | 2021-12-28 | Lawrence | Pennsylvania | 42073 | 14230 | 328 |
1494071 | 1494071 | 2021-07-07 | Fayette | Pennsylvania | 42051 | 13444 | 328 |
1490824 | 1490824 | 2021-07-06 | Fayette | Pennsylvania | 42051 | 13443 | 328 |
1487577 | 1487577 | 2021-07-05 | Fayette | Pennsylvania | 42051 | 13443 | 328 |
1484330 | 1484330 | 2021-07-04 | Fayette | Pennsylvania | 42051 | 13441 | 328 |
1481084 | 1481084 | 2021-07-03 | Fayette | Pennsylvania | 42051 | 13440 | 328 |
1477837 | 1477837 | 2021-07-02 | Fayette | Pennsylvania | 42051 | 13433 | 328 |
1474591 | 1474591 | 2021-07-01 | Fayette | Pennsylvania | 42051 | 13431 | 328 |
1471345 | 1471345 | 2021-06-30 | Fayette | Pennsylvania | 42051 | 13427 | 328 |
1468100 | 1468100 | 2021-06-29 | Fayette | Pennsylvania | 42051 | 13421 | 328 |
1464855 | 1464855 | 2021-06-28 | Fayette | Pennsylvania | 42051 | 13416 | 328 |
1461610 | 1461610 | 2021-06-27 | Fayette | Pennsylvania | 42051 | 13414 | 328 |
1458365 | 1458365 | 2021-06-26 | Fayette | Pennsylvania | 42051 | 13409 | 328 |
1455120 | 1455120 | 2021-06-25 | Fayette | Pennsylvania | 42051 | 13406 | 328 |
1451875 | 1451875 | 2021-06-24 | Fayette | Pennsylvania | 42051 | 13400 | 328 |
1448629 | 1448629 | 2021-06-23 | Fayette | Pennsylvania | 42051 | 13394 | 328 |
1445384 | 1445384 | 2021-06-22 | Fayette | Pennsylvania | 42051 | 13393 | 328 |
1442139 | 1442139 | 2021-06-21 | Fayette | Pennsylvania | 42051 | 13391 | 328 |
1438894 | 1438894 | 2021-06-20 | Fayette | Pennsylvania | 42051 | 13390 | 328 |
1435647 | 1435647 | 2021-06-19 | Fayette | Pennsylvania | 42051 | 13387 | 328 |
1432400 | 1432400 | 2021-06-18 | Fayette | Pennsylvania | 42051 | 13383 | 328 |
1429154 | 1429154 | 2021-06-17 | Fayette | Pennsylvania | 42051 | 13375 | 328 |
1425909 | 1425909 | 2021-06-16 | Fayette | Pennsylvania | 42051 | 13372 | 328 |
1422662 | 1422662 | 2021-06-15 | Fayette | Pennsylvania | 42051 | 13366 | 328 |
1419416 | 1419416 | 2021-06-14 | Fayette | Pennsylvania | 42051 | 13341 | 328 |
1416171 | 1416171 | 2021-06-13 | Fayette | Pennsylvania | 42051 | 13337 | 328 |
1412925 | 1412925 | 2021-06-12 | Fayette | Pennsylvania | 42051 | 13336 | 328 |
1299291 | 1299291 | 2021-05-08 | Blair | Pennsylvania | 42013 | 12877 | 328 |
1130474 | 1130474 | 2021-03-17 | Northumberland | Pennsylvania | 42097 | 8267 | 328 |
1127227 | 1127227 | 2021-03-16 | Northumberland | Pennsylvania | 42097 | 8251 | 328 |
1123981 | 1123981 | 2021-03-15 | Northumberland | Pennsylvania | 42097 | 8227 | 328 |
1120735 | 1120735 | 2021-03-14 | Northumberland | Pennsylvania | 42097 | 8217 | 328 |
1117488 | 1117488 | 2021-03-13 | Northumberland | Pennsylvania | 42097 | 8192 | 328 |
1114241 | 1114241 | 2021-03-12 | Northumberland | Pennsylvania | 42097 | 8174 | 328 |
1104482 | 1104482 | 2021-03-09 | Franklin | Pennsylvania | 42055 | 12725 | 328 |
1000595 | 1000595 | 2021-02-05 | Beaver | Pennsylvania | 42007 | 11239 | 328 |
987617 | 987617 | 2021-02-01 | Butler | Pennsylvania | 42019 | 12773 | 328 |
964913 | 964913 | 2021-01-25 | Erie | Pennsylvania | 42049 | 14893 | 328 |
961668 | 961668 | 2021-01-24 | Erie | Pennsylvania | 42049 | 14796 | 328 |
760480 | 760480 | 2020-11-23 | Northampton | Pennsylvania | 42095 | 7984 | 328 |
295590 | 295590 | 2020-07-02 | Chester | Pennsylvania | 42029 | 3796 | 328 |
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);