ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where deaths = 396 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Somerset 14
- Erie 6
- Cambria 5
- Northumberland 5
- Fayette 4
- Monroe 4
- Beaver 3
- Berks 1
- Blair 1
- Franklin 1
- Luzerne 1
- Mercer 1
- Schuylkill 1
- Washington 1
state 1
- Pennsylvania · 48 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2306595 | 2306595 | 2022-03-14 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2303344 | 2303344 | 2022-03-13 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2300092 | 2300092 | 2022-03-12 | Somerset | Pennsylvania | 42111 | 18638 | 396 |
2296840 | 2296840 | 2022-03-11 | Somerset | Pennsylvania | 42111 | 18634 | 396 |
2293588 | 2293588 | 2022-03-10 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2290336 | 2290336 | 2022-03-09 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2287084 | 2287084 | 2022-03-08 | Somerset | Pennsylvania | 42111 | 18625 | 396 |
2283832 | 2283832 | 2022-03-07 | Somerset | Pennsylvania | 42111 | 18621 | 396 |
2280580 | 2280580 | 2022-03-06 | Somerset | Pennsylvania | 42111 | 18618 | 396 |
2277327 | 2277327 | 2022-03-05 | Somerset | Pennsylvania | 42111 | 18615 | 396 |
2274074 | 2274074 | 2022-03-04 | Somerset | Pennsylvania | 42111 | 18616 | 396 |
2270821 | 2270821 | 2022-03-03 | Somerset | Pennsylvania | 42111 | 18609 | 396 |
2267569 | 2267569 | 2022-03-02 | Somerset | Pennsylvania | 42111 | 18600 | 396 |
2264316 | 2264316 | 2022-03-01 | Somerset | Pennsylvania | 42111 | 18588 | 396 |
2023669 | 2023669 | 2021-12-17 | Mercer | Pennsylvania | 42085 | 17234 | 396 |
2013919 | 2013919 | 2021-12-14 | Monroe | Pennsylvania | 42089 | 23447 | 396 |
2010668 | 2010668 | 2021-12-13 | Monroe | Pennsylvania | 42089 | 23312 | 396 |
2007417 | 2007417 | 2021-12-12 | Monroe | Pennsylvania | 42089 | 23219 | 396 |
2004166 | 2004166 | 2021-12-11 | Monroe | Pennsylvania | 42089 | 23091 | 396 |
1883868 | 1883868 | 2021-11-04 | Blair | Pennsylvania | 42013 | 17937 | 396 |
1867679 | 1867679 | 2021-10-30 | Washington | Pennsylvania | 42125 | 25749 | 396 |
1851397 | 1851397 | 2021-10-25 | Fayette | Pennsylvania | 42051 | 17561 | 396 |
1848147 | 1848147 | 2021-10-24 | Fayette | Pennsylvania | 42051 | 17525 | 396 |
1844897 | 1844897 | 2021-10-23 | Fayette | Pennsylvania | 42051 | 17485 | 396 |
1841647 | 1841647 | 2021-10-22 | Fayette | Pennsylvania | 42051 | 17410 | 396 |
1831923 | 1831923 | 2021-10-19 | Northumberland | Pennsylvania | 42097 | 12313 | 396 |
1828674 | 1828674 | 2021-10-18 | Northumberland | Pennsylvania | 42097 | 12296 | 396 |
1825425 | 1825425 | 2021-10-17 | Northumberland | Pennsylvania | 42097 | 12263 | 396 |
1822176 | 1822176 | 2021-10-16 | Northumberland | Pennsylvania | 42097 | 12219 | 396 |
1818927 | 1818927 | 2021-10-15 | Northumberland | Pennsylvania | 42097 | 12167 | 396 |
1727930 | 1727930 | 2021-09-17 | Franklin | Pennsylvania | 42055 | 18479 | 396 |
1646699 | 1646699 | 2021-08-23 | Beaver | Pennsylvania | 42007 | 16456 | 396 |
1643450 | 1643450 | 2021-08-22 | Beaver | Pennsylvania | 42007 | 16437 | 396 |
1640200 | 1640200 | 2021-08-21 | Beaver | Pennsylvania | 42007 | 16402 | 396 |
1299338 | 1299338 | 2021-05-08 | Schuylkill | Pennsylvania | 42107 | 14353 | 396 |
1201894 | 1201894 | 2021-04-08 | Erie | Pennsylvania | 42049 | 19009 | 396 |
1198645 | 1198645 | 2021-04-07 | Erie | Pennsylvania | 42049 | 18957 | 396 |
1195396 | 1195396 | 2021-04-06 | Erie | Pennsylvania | 42049 | 18926 | 396 |
1192148 | 1192148 | 2021-04-05 | Erie | Pennsylvania | 42049 | 18870 | 396 |
1188899 | 1188899 | 2021-04-04 | Erie | Pennsylvania | 42049 | 18846 | 396 |
1185652 | 1185652 | 2021-04-03 | Erie | Pennsylvania | 42049 | 18822 | 396 |
1104465 | 1104465 | 2021-03-09 | Cambria | Pennsylvania | 42021 | 11875 | 396 |
1101219 | 1101219 | 2021-03-08 | Cambria | Pennsylvania | 42021 | 11826 | 396 |
1097973 | 1097973 | 2021-03-07 | Cambria | Pennsylvania | 42021 | 11819 | 396 |
1094725 | 1094725 | 2021-03-06 | Cambria | Pennsylvania | 42021 | 11799 | 396 |
1091479 | 1091479 | 2021-03-05 | Cambria | Pennsylvania | 42021 | 11780 | 396 |
841607 | 841607 | 2020-12-18 | Luzerne | Pennsylvania | 42079 | 14716 | 396 |
591751 | 591751 | 2020-10-02 | Berks | Pennsylvania | 42011 | 7258 | 396 |
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);