ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where deaths = 174 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2306573 | 2306573 | 2022-03-14 | Juniata | Pennsylvania | 42067 | 4754 | 174 |
2303322 | 2303322 | 2022-03-13 | Juniata | Pennsylvania | 42067 | 4754 | 174 |
2300070 | 2300070 | 2022-03-12 | Juniata | Pennsylvania | 42067 | 4754 | 174 |
2296818 | 2296818 | 2022-03-11 | Juniata | Pennsylvania | 42067 | 4753 | 174 |
2293566 | 2293566 | 2022-03-10 | Juniata | Pennsylvania | 42067 | 4752 | 174 |
2290314 | 2290314 | 2022-03-09 | Juniata | Pennsylvania | 42067 | 4752 | 174 |
2287062 | 2287062 | 2022-03-08 | Juniata | Pennsylvania | 42067 | 4749 | 174 |
2283810 | 2283810 | 2022-03-07 | Juniata | Pennsylvania | 42067 | 4748 | 174 |
2280558 | 2280558 | 2022-03-06 | Juniata | Pennsylvania | 42067 | 4744 | 174 |
2277305 | 2277305 | 2022-03-05 | Juniata | Pennsylvania | 42067 | 4743 | 174 |
2274052 | 2274052 | 2022-03-04 | Juniata | Pennsylvania | 42067 | 4742 | 174 |
2270799 | 2270799 | 2022-03-03 | Juniata | Pennsylvania | 42067 | 4742 | 174 |
2267547 | 2267547 | 2022-03-02 | Juniata | Pennsylvania | 42067 | 4737 | 174 |
2264294 | 2264294 | 2022-03-01 | Juniata | Pennsylvania | 42067 | 4736 | 174 |
2261044 | 2261044 | 2022-02-28 | Juniata | Pennsylvania | 42067 | 4736 | 174 |
2257793 | 2257793 | 2022-02-27 | Juniata | Pennsylvania | 42067 | 4736 | 174 |
2254542 | 2254542 | 2022-02-26 | Juniata | Pennsylvania | 42067 | 4732 | 174 |
2251291 | 2251291 | 2022-02-25 | Juniata | Pennsylvania | 42067 | 4730 | 174 |
2248040 | 2248040 | 2022-02-24 | Juniata | Pennsylvania | 42067 | 4728 | 174 |
2244789 | 2244789 | 2022-02-23 | Juniata | Pennsylvania | 42067 | 4724 | 174 |
2212295 | 2212295 | 2022-02-13 | Perry | Pennsylvania | 42099 | 8664 | 174 |
2209042 | 2209042 | 2022-02-12 | Perry | Pennsylvania | 42099 | 8652 | 174 |
2205789 | 2205789 | 2022-02-11 | Perry | Pennsylvania | 42099 | 8637 | 174 |
2202536 | 2202536 | 2022-02-10 | Perry | Pennsylvania | 42099 | 8617 | 174 |
2199282 | 2199282 | 2022-02-09 | Perry | Pennsylvania | 42099 | 8605 | 174 |
2192774 | 2192774 | 2022-02-07 | Perry | Pennsylvania | 42099 | 8601 | 174 |
2189520 | 2189520 | 2022-02-06 | Perry | Pennsylvania | 42099 | 8579 | 174 |
2186267 | 2186267 | 2022-02-05 | Perry | Pennsylvania | 42099 | 8566 | 174 |
2183015 | 2183015 | 2022-02-04 | Perry | Pennsylvania | 42099 | 8525 | 174 |
2104951 | 2104951 | 2022-01-11 | Tioga | Pennsylvania | 42117 | 6635 | 174 |
2036690 | 2036690 | 2021-12-21 | Warren | Pennsylvania | 42123 | 5496 | 174 |
2020408 | 2020408 | 2021-12-16 | Jefferson | Pennsylvania | 42065 | 6609 | 174 |
1984678 | 1984678 | 2021-12-05 | Venango | Pennsylvania | 42121 | 8255 | 174 |
1981428 | 1981428 | 2021-12-04 | Venango | Pennsylvania | 42121 | 8227 | 174 |
1932640 | 1932640 | 2021-11-19 | Huntingdon | Pennsylvania | 42061 | 7341 | 174 |
1929389 | 1929389 | 2021-11-18 | Huntingdon | Pennsylvania | 42061 | 7325 | 174 |
1786391 | 1786391 | 2021-10-05 | Armstrong | Pennsylvania | 42005 | 7864 | 174 |
1425896 | 1425896 | 2021-06-16 | Carbon | Pennsylvania | 42025 | 6388 | 174 |
1422649 | 1422649 | 2021-06-15 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1419403 | 1419403 | 2021-06-14 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1416158 | 1416158 | 2021-06-13 | Carbon | Pennsylvania | 42025 | 6387 | 174 |
1412912 | 1412912 | 2021-06-12 | Carbon | Pennsylvania | 42025 | 6386 | 174 |
1409667 | 1409667 | 2021-06-11 | Carbon | Pennsylvania | 42025 | 6385 | 174 |
1331781 | 1331781 | 2021-05-18 | Indiana | Pennsylvania | 42063 | 6214 | 174 |
1289546 | 1289546 | 2021-05-05 | Adams | Pennsylvania | 42001 | 9229 | 174 |
1143456 | 1143456 | 2021-03-21 | Mifflin | Pennsylvania | 42087 | 4702 | 174 |
1140209 | 1140209 | 2021-03-20 | Mifflin | Pennsylvania | 42087 | 4697 | 174 |
1136963 | 1136963 | 2021-03-19 | Mifflin | Pennsylvania | 42087 | 4693 | 174 |
1133717 | 1133717 | 2021-03-18 | Mifflin | Pennsylvania | 42087 | 4686 | 174 |
1130469 | 1130469 | 2021-03-17 | Mifflin | Pennsylvania | 42087 | 4681 | 174 |
1127222 | 1127222 | 2021-03-16 | Mifflin | Pennsylvania | 42087 | 4674 | 174 |
1123976 | 1123976 | 2021-03-15 | Mifflin | Pennsylvania | 42087 | 4670 | 174 |
1010366 | 1010366 | 2021-02-08 | Lawrence | Pennsylvania | 42073 | 5651 | 174 |
1007120 | 1007120 | 2021-02-07 | Lawrence | Pennsylvania | 42073 | 5642 | 174 |
1003874 | 1003874 | 2021-02-06 | Lawrence | Pennsylvania | 42073 | 5612 | 174 |
1000628 | 1000628 | 2021-02-05 | Lawrence | Pennsylvania | 42073 | 5588 | 174 |
932475 | 932475 | 2021-01-15 | Lycoming | Pennsylvania | 42081 | 7233 | 174 |
922741 | 922741 | 2021-01-12 | Mercer | Pennsylvania | 42085 | 6720 | 174 |
874028 | 874028 | 2020-12-28 | Butler | Pennsylvania | 42019 | 8760 | 174 |
870783 | 870783 | 2020-12-27 | Butler | Pennsylvania | 42019 | 8716 | 174 |
828628 | 828628 | 2020-12-14 | Monroe | Pennsylvania | 42089 | 4737 | 174 |
825382 | 825382 | 2020-12-13 | Monroe | Pennsylvania | 42089 | 4646 | 174 |
802639 | 802639 | 2020-12-06 | Cumberland | Pennsylvania | 42041 | 6352 | 174 |
783203 | 783203 | 2020-11-30 | Schuylkill | Pennsylvania | 42107 | 4126 | 174 |
552886 | 552886 | 2020-09-20 | Dauphin | Pennsylvania | 42043 | 3695 | 174 |
273570 | 273570 | 2020-06-25 | Luzerne | Pennsylvania | 42079 | 2883 | 174 |
242295 | 242295 | 2020-06-15 | Allegheny | Pennsylvania | 42003 | 2086 | 174 |
202094 | 202094 | 2020-06-02 | Lackawanna | Pennsylvania | 42069 | 1555 | 174 |
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);