ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 196 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 23
county 23
- Dauphin 9
- Adams 5
- Armstrong 5
- Carbon 5
- Bradford 3
- Clearfield 3
- Columbia 3
- Schuylkill 3
- Somerset 3
- Allegheny 2
- Lebanon 2
- Luzerne 2
- Lycoming 2
- Northampton 2
- Northumberland 2
- Bedford 1
- Berks 1
- Blair 1
- Indiana 1
- Lackawanna 1
- Mercer 1
- Warren 1
- York 1
state 1
- Pennsylvania · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2306547 | 2306547 | 2022-03-14 | Bradford | Pennsylvania | 42015 | 14945 | 196 |
2303296 | 2303296 | 2022-03-13 | Bradford | Pennsylvania | 42015 | 14944 | 196 |
2300044 | 2300044 | 2022-03-12 | Bradford | Pennsylvania | 42015 | 14940 | 196 |
2173270 | 2173270 | 2022-02-01 | Warren | Pennsylvania | 42123 | 6891 | 196 |
2098409 | 2098409 | 2022-01-09 | Columbia | Pennsylvania | 42037 | 11834 | 196 |
2095157 | 2095157 | 2022-01-08 | Columbia | Pennsylvania | 42037 | 11695 | 196 |
2091905 | 2091905 | 2022-01-07 | Columbia | Pennsylvania | 42037 | 11586 | 196 |
1981372 | 1981372 | 2021-12-04 | Bedford | Pennsylvania | 42009 | 7919 | 196 |
1874131 | 1874131 | 2021-11-01 | Clearfield | Pennsylvania | 42033 | 11316 | 196 |
1870882 | 1870882 | 2021-10-31 | Clearfield | Pennsylvania | 42033 | 11316 | 196 |
1867633 | 1867633 | 2021-10-30 | Clearfield | Pennsylvania | 42033 | 11296 | 196 |
1854623 | 1854623 | 2021-10-26 | Armstrong | Pennsylvania | 42005 | 8708 | 196 |
1851374 | 1851374 | 2021-10-25 | Armstrong | Pennsylvania | 42005 | 8677 | 196 |
1848124 | 1848124 | 2021-10-24 | Armstrong | Pennsylvania | 42005 | 8663 | 196 |
1844874 | 1844874 | 2021-10-23 | Armstrong | Pennsylvania | 42005 | 8645 | 196 |
1841624 | 1841624 | 2021-10-22 | Armstrong | Pennsylvania | 42005 | 8612 | 196 |
1831887 | 1831887 | 2021-10-19 | Carbon | Pennsylvania | 42025 | 8614 | 196 |
1828638 | 1828638 | 2021-10-18 | Carbon | Pennsylvania | 42025 | 8584 | 196 |
1825389 | 1825389 | 2021-10-17 | Carbon | Pennsylvania | 42025 | 8576 | 196 |
1822140 | 1822140 | 2021-10-16 | Carbon | Pennsylvania | 42025 | 8563 | 196 |
1818891 | 1818891 | 2021-10-15 | Carbon | Pennsylvania | 42025 | 8497 | 196 |
1773422 | 1773422 | 2021-10-01 | Indiana | Pennsylvania | 42063 | 8045 | 196 |
1753898 | 1753898 | 2021-09-25 | Adams | Pennsylvania | 42001 | 11752 | 196 |
1750650 | 1750650 | 2021-09-24 | Adams | Pennsylvania | 42001 | 11713 | 196 |
1747401 | 1747401 | 2021-09-23 | Adams | Pennsylvania | 42001 | 11666 | 196 |
1744151 | 1744151 | 2021-09-22 | Adams | Pennsylvania | 42001 | 11629 | 196 |
1740902 | 1740902 | 2021-09-21 | Adams | Pennsylvania | 42001 | 11571 | 196 |
1260380 | 1260380 | 2021-04-26 | Somerset | Pennsylvania | 42111 | 7444 | 196 |
1257133 | 1257133 | 2021-04-25 | Somerset | Pennsylvania | 42111 | 7437 | 196 |
1253886 | 1253886 | 2021-04-24 | Somerset | Pennsylvania | 42111 | 7416 | 196 |
961684 | 961684 | 2021-01-24 | Lycoming | Pennsylvania | 42081 | 7760 | 196 |
958439 | 958439 | 2021-01-23 | Lycoming | Pennsylvania | 42081 | 7710 | 196 |
945454 | 945454 | 2021-01-19 | Lebanon | Pennsylvania | 42075 | 10873 | 196 |
945459 | 945459 | 2021-01-19 | Mercer | Pennsylvania | 42085 | 7059 | 196 |
942207 | 942207 | 2021-01-18 | Lebanon | Pennsylvania | 42075 | 10780 | 196 |
925951 | 925951 | 2021-01-13 | Blair | Pennsylvania | 42013 | 9026 | 196 |
851352 | 851352 | 2020-12-21 | Northumberland | Pennsylvania | 42097 | 4244 | 196 |
848107 | 848107 | 2020-12-20 | Northumberland | Pennsylvania | 42097 | 4151 | 196 |
805917 | 805917 | 2020-12-07 | Schuylkill | Pennsylvania | 42107 | 4788 | 196 |
802672 | 802672 | 2020-12-06 | Schuylkill | Pennsylvania | 42107 | 4716 | 196 |
799427 | 799427 | 2020-12-05 | Schuylkill | Pennsylvania | 42107 | 4641 | 196 |
705293 | 705293 | 2020-11-06 | Dauphin | Pennsylvania | 42043 | 5367 | 196 |
702050 | 702050 | 2020-11-05 | Dauphin | Pennsylvania | 42043 | 5268 | 196 |
698806 | 698806 | 2020-11-04 | Dauphin | Pennsylvania | 42043 | 5213 | 196 |
695563 | 695563 | 2020-11-03 | Dauphin | Pennsylvania | 42043 | 5119 | 196 |
692321 | 692321 | 2020-11-02 | Dauphin | Pennsylvania | 42043 | 5036 | 196 |
689077 | 689077 | 2020-11-01 | Dauphin | Pennsylvania | 42043 | 4998 | 196 |
685832 | 685832 | 2020-10-31 | Dauphin | Pennsylvania | 42043 | 4960 | 196 |
682589 | 682589 | 2020-10-30 | Dauphin | Pennsylvania | 42043 | 4898 | 196 |
679346 | 679346 | 2020-10-29 | Dauphin | Pennsylvania | 42043 | 4852 | 196 |
666392 | 666392 | 2020-10-25 | Luzerne | Pennsylvania | 42079 | 5141 | 196 |
663147 | 663147 | 2020-10-24 | Luzerne | Pennsylvania | 42079 | 5052 | 196 |
653441 | 653441 | 2020-10-21 | York | Pennsylvania | 42133 | 6013 | 196 |
317744 | 317744 | 2020-07-09 | Allegheny | Pennsylvania | 42003 | 4367 | 196 |
314571 | 314571 | 2020-07-08 | Allegheny | Pennsylvania | 42003 | 4209 | 196 |
242328 | 242328 | 2020-06-15 | Lackawanna | Pennsylvania | 42069 | 1602 | 196 |
150348 | 150348 | 2020-05-16 | Northampton | Pennsylvania | 42095 | 2659 | 196 |
147341 | 147341 | 2020-05-15 | Northampton | Pennsylvania | 42095 | 2600 | 196 |
144298 | 144298 | 2020-05-14 | Berks | Pennsylvania | 42011 | 3530 | 196 |
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);