ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 129 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2192766 | 2192766 | 2022-02-07 | McKean | Pennsylvania | 42083 | 7830 | 129 |
2189512 | 2189512 | 2022-02-06 | McKean | Pennsylvania | 42083 | 7808 | 129 |
2082186 | 2082186 | 2022-01-04 | Snyder | Pennsylvania | 42109 | 6380 | 129 |
2059435 | 2059435 | 2021-12-28 | Union | Pennsylvania | 42119 | 8885 | 129 |
2056186 | 2056186 | 2021-12-27 | Union | Pennsylvania | 42119 | 8855 | 129 |
2052937 | 2052937 | 2021-12-26 | Union | Pennsylvania | 42119 | 8851 | 129 |
2049687 | 2049687 | 2021-12-25 | Union | Pennsylvania | 42119 | 8827 | 129 |
2046437 | 2046437 | 2021-12-24 | Union | Pennsylvania | 42119 | 8816 | 129 |
2013938 | 2013938 | 2021-12-14 | Wayne | Pennsylvania | 42127 | 7008 | 129 |
2010687 | 2010687 | 2021-12-13 | Wayne | Pennsylvania | 42127 | 6948 | 129 |
2007436 | 2007436 | 2021-12-12 | Wayne | Pennsylvania | 42127 | 6929 | 129 |
2004185 | 2004185 | 2021-12-11 | Wayne | Pennsylvania | 42127 | 6893 | 129 |
2000934 | 2000934 | 2021-12-10 | Wayne | Pennsylvania | 42127 | 6856 | 129 |
1903411 | 1903411 | 2021-11-10 | Perry | Pennsylvania | 42099 | 5460 | 129 |
1900127 | 1900127 | 2021-11-09 | Clarion | Pennsylvania | 42031 | 5127 | 129 |
1896877 | 1896877 | 2021-11-08 | Clarion | Pennsylvania | 42031 | 5111 | 129 |
1896894 | 1896894 | 2021-11-08 | Jefferson | Pennsylvania | 42065 | 5365 | 129 |
1893627 | 1893627 | 2021-11-07 | Clarion | Pennsylvania | 42031 | 5102 | 129 |
1890377 | 1890377 | 2021-11-06 | Clarion | Pennsylvania | 42031 | 5067 | 129 |
1887127 | 1887127 | 2021-11-05 | Clarion | Pennsylvania | 42031 | 5027 | 129 |
1854679 | 1854679 | 2021-10-26 | Tioga | Pennsylvania | 42117 | 4487 | 129 |
1851430 | 1851430 | 2021-10-25 | Tioga | Pennsylvania | 42117 | 4477 | 129 |
1848180 | 1848180 | 2021-10-24 | Tioga | Pennsylvania | 42117 | 4450 | 129 |
1844930 | 1844930 | 2021-10-23 | Tioga | Pennsylvania | 42117 | 4438 | 129 |
1841680 | 1841680 | 2021-10-22 | Tioga | Pennsylvania | 42117 | 4408 | 129 |
1838431 | 1838431 | 2021-10-21 | Tioga | Pennsylvania | 42117 | 4376 | 129 |
1835182 | 1835182 | 2021-10-20 | Tioga | Pennsylvania | 42117 | 4356 | 129 |
1322041 | 1322041 | 2021-05-15 | Huntingdon | Pennsylvania | 42061 | 5047 | 129 |
1318795 | 1318795 | 2021-05-14 | Huntingdon | Pennsylvania | 42061 | 5045 | 129 |
1315547 | 1315547 | 2021-05-13 | Huntingdon | Pennsylvania | 42061 | 5040 | 129 |
1312301 | 1312301 | 2021-05-12 | Huntingdon | Pennsylvania | 42061 | 5024 | 129 |
1309054 | 1309054 | 2021-05-11 | Huntingdon | Pennsylvania | 42061 | 5017 | 129 |
1296068 | 1296068 | 2021-05-07 | Huntingdon | Pennsylvania | 42061 | 4983 | 129 |
1292822 | 1292822 | 2021-05-06 | Huntingdon | Pennsylvania | 42061 | 4973 | 129 |
1289576 | 1289576 | 2021-05-05 | Huntingdon | Pennsylvania | 42061 | 4954 | 129 |
1286330 | 1286330 | 2021-05-04 | Huntingdon | Pennsylvania | 42061 | 4929 | 129 |
1218128 | 1218128 | 2021-04-13 | Columbia | Pennsylvania | 42037 | 5126 | 129 |
1214880 | 1214880 | 2021-04-12 | Columbia | Pennsylvania | 42037 | 5094 | 129 |
1211633 | 1211633 | 2021-04-11 | Columbia | Pennsylvania | 42037 | 5094 | 129 |
1208384 | 1208384 | 2021-04-10 | Columbia | Pennsylvania | 42037 | 5083 | 129 |
1205136 | 1205136 | 2021-04-09 | Columbia | Pennsylvania | 42037 | 5064 | 129 |
1201888 | 1201888 | 2021-04-08 | Columbia | Pennsylvania | 42037 | 5048 | 129 |
1198639 | 1198639 | 2021-04-07 | Columbia | Pennsylvania | 42037 | 5031 | 129 |
1195390 | 1195390 | 2021-04-06 | Columbia | Pennsylvania | 42037 | 5016 | 129 |
1185644 | 1185644 | 2021-04-03 | Clearfield | Pennsylvania | 42033 | 7319 | 129 |
1182397 | 1182397 | 2021-04-02 | Clearfield | Pennsylvania | 42033 | 7276 | 129 |
1179150 | 1179150 | 2021-04-01 | Clearfield | Pennsylvania | 42033 | 7230 | 129 |
1133678 | 1133678 | 2021-03-18 | Bedford | Pennsylvania | 42009 | 3895 | 129 |
1130430 | 1130430 | 2021-03-17 | Bedford | Pennsylvania | 42009 | 3892 | 129 |
1127183 | 1127183 | 2021-03-16 | Bedford | Pennsylvania | 42009 | 3890 | 129 |
1123937 | 1123937 | 2021-03-15 | Bedford | Pennsylvania | 42009 | 3879 | 129 |
1120691 | 1120691 | 2021-03-14 | Bedford | Pennsylvania | 42009 | 3878 | 129 |
1117444 | 1117444 | 2021-03-13 | Bedford | Pennsylvania | 42009 | 3876 | 129 |
1114197 | 1114197 | 2021-03-12 | Bedford | Pennsylvania | 42009 | 3868 | 129 |
1110951 | 1110951 | 2021-03-11 | Bedford | Pennsylvania | 42009 | 3856 | 129 |
1107705 | 1107705 | 2021-03-10 | Bedford | Pennsylvania | 42009 | 3854 | 129 |
1104459 | 1104459 | 2021-03-09 | Bedford | Pennsylvania | 42009 | 3847 | 129 |
1101213 | 1101213 | 2021-03-08 | Bedford | Pennsylvania | 42009 | 3844 | 129 |
1097967 | 1097967 | 2021-03-07 | Bedford | Pennsylvania | 42009 | 3843 | 129 |
1094719 | 1094719 | 2021-03-06 | Bedford | Pennsylvania | 42009 | 3839 | 129 |
1091473 | 1091473 | 2021-03-05 | Bedford | Pennsylvania | 42009 | 3831 | 129 |
1088227 | 1088227 | 2021-03-04 | Bedford | Pennsylvania | 42009 | 3820 | 129 |
1084982 | 1084982 | 2021-03-03 | Bedford | Pennsylvania | 42009 | 3817 | 129 |
1081736 | 1081736 | 2021-03-02 | Bedford | Pennsylvania | 42009 | 3814 | 129 |
1078490 | 1078490 | 2021-03-01 | Bedford | Pennsylvania | 42009 | 3807 | 129 |
1075245 | 1075245 | 2021-02-28 | Bedford | Pennsylvania | 42009 | 3804 | 129 |
1071999 | 1071999 | 2021-02-27 | Bedford | Pennsylvania | 42009 | 3802 | 129 |
1068753 | 1068753 | 2021-02-26 | Bedford | Pennsylvania | 42009 | 3793 | 129 |
1065508 | 1065508 | 2021-02-25 | Bedford | Pennsylvania | 42009 | 3790 | 129 |
1062263 | 1062263 | 2021-02-24 | Bedford | Pennsylvania | 42009 | 3788 | 129 |
987627 | 987627 | 2021-02-01 | Crawford | Pennsylvania | 42039 | 5953 | 129 |
919497 | 919497 | 2021-01-11 | Mifflin | Pennsylvania | 42087 | 3798 | 129 |
893528 | 893528 | 2021-01-03 | Lawrence | Pennsylvania | 42073 | 4390 | 129 |
890282 | 890282 | 2021-01-02 | Lawrence | Pennsylvania | 42073 | 4361 | 129 |
887035 | 887035 | 2021-01-01 | Lawrence | Pennsylvania | 42073 | 4286 | 129 |
877306 | 877306 | 2020-12-29 | Mercer | Pennsylvania | 42085 | 5808 | 129 |
822128 | 822128 | 2020-12-12 | Lebanon | Pennsylvania | 42075 | 6736 | 129 |
728029 | 728029 | 2020-11-13 | Schuylkill | Pennsylvania | 42107 | 2762 | 129 |
724785 | 724785 | 2020-11-12 | Schuylkill | Pennsylvania | 42107 | 2697 | 129 |
721553 | 721553 | 2020-11-11 | Westmoreland | Pennsylvania | 42129 | 5431 | 129 |
601476 | 601476 | 2020-10-05 | Beaver | Pennsylvania | 42007 | 1973 | 129 |
552909 | 552909 | 2020-09-20 | Monroe | Pennsylvania | 42089 | 1773 | 129 |
549670 | 549670 | 2020-09-19 | Monroe | Pennsylvania | 42089 | 1772 | 129 |
546431 | 546431 | 2020-09-18 | Monroe | Pennsylvania | 42089 | 1771 | 129 |
543194 | 543194 | 2020-09-17 | Monroe | Pennsylvania | 42089 | 1770 | 129 |
539958 | 539958 | 2020-09-16 | Monroe | Pennsylvania | 42089 | 1767 | 129 |
536721 | 536721 | 2020-09-15 | Monroe | Pennsylvania | 42089 | 1766 | 129 |
533485 | 533485 | 2020-09-14 | Monroe | Pennsylvania | 42089 | 1759 | 129 |
530250 | 530250 | 2020-09-13 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
527013 | 527013 | 2020-09-12 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
523777 | 523777 | 2020-09-11 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
520541 | 520541 | 2020-09-10 | Monroe | Pennsylvania | 42089 | 1750 | 129 |
517305 | 517305 | 2020-09-09 | Monroe | Pennsylvania | 42089 | 1747 | 129 |
514070 | 514070 | 2020-09-08 | Monroe | Pennsylvania | 42089 | 1742 | 129 |
510837 | 510837 | 2020-09-07 | Monroe | Pennsylvania | 42089 | 1739 | 129 |
507604 | 507604 | 2020-09-06 | Monroe | Pennsylvania | 42089 | 1737 | 129 |
504372 | 504372 | 2020-09-05 | Monroe | Pennsylvania | 42089 | 1735 | 129 |
501138 | 501138 | 2020-09-04 | Monroe | Pennsylvania | 42089 | 1731 | 129 |
497904 | 497904 | 2020-09-03 | Monroe | Pennsylvania | 42089 | 1730 | 129 |
494671 | 494671 | 2020-09-02 | Monroe | Pennsylvania | 42089 | 1720 | 129 |
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);