ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 145 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222058 | 2222058 | 2022-02-16 | Union | Pennsylvania | 42119 | 11415 | 145 |
2218807 | 2218807 | 2022-02-15 | Union | Pennsylvania | 42119 | 11397 | 145 |
2173263 | 2173263 | 2022-02-01 | Snyder | Pennsylvania | 42109 | 7716 | 145 |
2170011 | 2170011 | 2022-01-31 | Snyder | Pennsylvania | 42109 | 7687 | 145 |
2111459 | 2111459 | 2022-01-13 | Wayne | Pennsylvania | 42127 | 8594 | 145 |
2062659 | 2062659 | 2021-12-29 | Juniata | Pennsylvania | 42067 | 3768 | 145 |
2033428 | 2033428 | 2021-12-20 | Perry | Pennsylvania | 42099 | 6538 | 145 |
2030178 | 2030178 | 2021-12-19 | Perry | Pennsylvania | 42099 | 6526 | 145 |
2026927 | 2026927 | 2021-12-18 | Perry | Pennsylvania | 42099 | 6507 | 145 |
2013882 | 2013882 | 2021-12-14 | Bradford | Pennsylvania | 42015 | 9948 | 145 |
2010631 | 2010631 | 2021-12-13 | Bradford | Pennsylvania | 42015 | 9902 | 145 |
2007380 | 2007380 | 2021-12-12 | Bradford | Pennsylvania | 42015 | 9885 | 145 |
2004129 | 2004129 | 2021-12-11 | Bradford | Pennsylvania | 42015 | 9833 | 145 |
1945669 | 1945669 | 2021-11-23 | Tioga | Pennsylvania | 42117 | 5367 | 145 |
1926170 | 1926170 | 2021-11-17 | Warren | Pennsylvania | 42123 | 4706 | 145 |
1896922 | 1896922 | 2021-11-08 | Venango | Pennsylvania | 42121 | 6747 | 145 |
1893672 | 1893672 | 2021-11-07 | Venango | Pennsylvania | 42121 | 6729 | 145 |
1890422 | 1890422 | 2021-11-06 | Venango | Pennsylvania | 42121 | 6706 | 145 |
1887172 | 1887172 | 2021-11-05 | Venango | Pennsylvania | 42121 | 6655 | 145 |
1883922 | 1883922 | 2021-11-04 | Venango | Pennsylvania | 42121 | 6604 | 145 |
1880673 | 1880673 | 2021-11-03 | Venango | Pennsylvania | 42121 | 6553 | 145 |
1773421 | 1773421 | 2021-10-01 | Huntingdon | Pennsylvania | 42061 | 6200 | 145 |
1770171 | 1770171 | 2021-09-30 | Huntingdon | Pennsylvania | 42061 | 6172 | 145 |
1718161 | 1718161 | 2021-09-14 | Bedford | Pennsylvania | 42009 | 5332 | 145 |
1714913 | 1714913 | 2021-09-13 | Bedford | Pennsylvania | 42009 | 5311 | 145 |
1711667 | 1711667 | 2021-09-12 | Bedford | Pennsylvania | 42009 | 5270 | 145 |
1708420 | 1708420 | 2021-09-11 | Bedford | Pennsylvania | 42009 | 5247 | 145 |
1705173 | 1705173 | 2021-09-10 | Bedford | Pennsylvania | 42009 | 5212 | 145 |
1701923 | 1701923 | 2021-09-09 | Bedford | Pennsylvania | 42009 | 5175 | 145 |
1698674 | 1698674 | 2021-09-08 | Bedford | Pennsylvania | 42009 | 5134 | 145 |
1695426 | 1695426 | 2021-09-07 | Bedford | Pennsylvania | 42009 | 5107 | 145 |
1692178 | 1692178 | 2021-09-06 | Bedford | Pennsylvania | 42009 | 5106 | 145 |
1688929 | 1688929 | 2021-09-05 | Bedford | Pennsylvania | 42009 | 5091 | 145 |
1685679 | 1685679 | 2021-09-04 | Bedford | Pennsylvania | 42009 | 5078 | 145 |
1390184 | 1390184 | 2021-06-05 | Armstrong | Pennsylvania | 42005 | 5985 | 145 |
1386939 | 1386939 | 2021-06-04 | Armstrong | Pennsylvania | 42005 | 5984 | 145 |
1383694 | 1383694 | 2021-06-03 | Armstrong | Pennsylvania | 42005 | 5981 | 145 |
1331766 | 1331766 | 2021-05-18 | Clearfield | Pennsylvania | 42033 | 8480 | 145 |
1218129 | 1218129 | 2021-04-13 | Crawford | Pennsylvania | 42039 | 6798 | 145 |
1214881 | 1214881 | 2021-04-12 | Crawford | Pennsylvania | 42039 | 6787 | 145 |
1211634 | 1211634 | 2021-04-11 | Crawford | Pennsylvania | 42039 | 6773 | 145 |
1208385 | 1208385 | 2021-04-10 | Crawford | Pennsylvania | 42039 | 6759 | 145 |
1205137 | 1205137 | 2021-04-09 | Crawford | Pennsylvania | 42039 | 6750 | 145 |
1046040 | 1046040 | 2021-02-19 | Carbon | Pennsylvania | 42025 | 4781 | 145 |
1023310 | 1023310 | 2021-02-12 | Adams | Pennsylvania | 42001 | 6895 | 145 |
1013575 | 1013575 | 2021-02-09 | Adams | Pennsylvania | 42001 | 6821 | 145 |
964920 | 964920 | 2021-01-25 | Indiana | Pennsylvania | 42063 | 4681 | 145 |
961675 | 961675 | 2021-01-24 | Indiana | Pennsylvania | 42063 | 4662 | 145 |
958430 | 958430 | 2021-01-23 | Indiana | Pennsylvania | 42063 | 4652 | 145 |
896751 | 896751 | 2021-01-04 | Centre | Pennsylvania | 42027 | 9205 | 145 |
893505 | 893505 | 2021-01-03 | Centre | Pennsylvania | 42027 | 9171 | 145 |
893534 | 893534 | 2021-01-03 | Mercer | Pennsylvania | 42085 | 6182 | 145 |
861076 | 861076 | 2020-12-24 | Lebanon | Pennsylvania | 42075 | 8111 | 145 |
851310 | 851310 | 2020-12-21 | Blair | Pennsylvania | 42013 | 7086 | 145 |
789659 | 789659 | 2020-12-02 | Cumberland | Pennsylvania | 42041 | 5421 | 145 |
753944 | 753944 | 2020-11-21 | Beaver | Pennsylvania | 42007 | 3243 | 145 |
750698 | 750698 | 2020-11-20 | Beaver | Pennsylvania | 42007 | 3154 | 145 |
747452 | 747452 | 2020-11-19 | Beaver | Pennsylvania | 42007 | 3102 | 145 |
159351 | 159351 | 2020-05-19 | Allegheny | Pennsylvania | 42003 | 1658 | 145 |
94534 | 94534 | 2020-04-27 | Delaware | Pennsylvania | 42045 | 3405 | 145 |
91720 | 91720 | 2020-04-26 | Lancaster | Pennsylvania | 42071 | 1577 | 145 |
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);