ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 256 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2192729 | 2192729 | 2022-02-07 | Bedford | Pennsylvania | 42009 | 10579 | 256 |
2189475 | 2189475 | 2022-02-06 | Bedford | Pennsylvania | 42009 | 10573 | 256 |
2186222 | 2186222 | 2022-02-05 | Bedford | Pennsylvania | 42009 | 10559 | 256 |
2182970 | 2182970 | 2022-02-04 | Bedford | Pennsylvania | 42009 | 10489 | 256 |
2173252 | 2173252 | 2022-02-01 | Mifflin | Pennsylvania | 42087 | 11504 | 256 |
2059395 | 2059395 | 2021-12-28 | Crawford | Pennsylvania | 42039 | 14908 | 256 |
2020376 | 2020376 | 2021-12-16 | Adams | Pennsylvania | 42001 | 15816 | 256 |
2017125 | 2017125 | 2021-12-15 | Adams | Pennsylvania | 42001 | 15727 | 256 |
1948875 | 1948875 | 2021-11-24 | Centre | Pennsylvania | 42027 | 22396 | 256 |
1932641 | 1932641 | 2021-11-19 | Indiana | Pennsylvania | 42063 | 10171 | 256 |
1825413 | 1825413 | 2021-10-17 | Lawrence | Pennsylvania | 42073 | 10444 | 256 |
1822164 | 1822164 | 2021-10-16 | Lawrence | Pennsylvania | 42073 | 10419 | 256 |
1818915 | 1818915 | 2021-10-15 | Lawrence | Pennsylvania | 42073 | 10375 | 256 |
1351276 | 1351276 | 2021-05-24 | Mercer | Pennsylvania | 42085 | 9533 | 256 |
1348030 | 1348030 | 2021-05-23 | Mercer | Pennsylvania | 42085 | 9527 | 256 |
1344782 | 1344782 | 2021-05-22 | Mercer | Pennsylvania | 42085 | 9506 | 256 |
1341534 | 1341534 | 2021-05-21 | Mercer | Pennsylvania | 42085 | 9506 | 256 |
1338286 | 1338286 | 2021-05-20 | Mercer | Pennsylvania | 42085 | 9489 | 256 |
1335039 | 1335039 | 2021-05-19 | Mercer | Pennsylvania | 42085 | 9475 | 256 |
1331792 | 1331792 | 2021-05-18 | Mercer | Pennsylvania | 42085 | 9466 | 256 |
1328545 | 1328545 | 2021-05-17 | Mercer | Pennsylvania | 42085 | 9440 | 256 |
1325299 | 1325299 | 2021-05-16 | Mercer | Pennsylvania | 42085 | 9438 | 256 |
1055805 | 1055805 | 2021-02-22 | Lebanon | Pennsylvania | 42075 | 12651 | 256 |
1052559 | 1052559 | 2021-02-21 | Lebanon | Pennsylvania | 42075 | 12643 | 256 |
1052584 | 1052584 | 2021-02-21 | Washington | Pennsylvania | 42125 | 13534 | 256 |
1049312 | 1049312 | 2021-02-20 | Lebanon | Pennsylvania | 42075 | 12623 | 256 |
1039563 | 1039563 | 2021-02-17 | Fayette | Pennsylvania | 42051 | 10202 | 256 |
1039575 | 1039575 | 2021-02-17 | Lebanon | Pennsylvania | 42075 | 12533 | 256 |
1036337 | 1036337 | 2021-02-16 | Monroe | Pennsylvania | 42089 | 9238 | 256 |
1033092 | 1033092 | 2021-02-15 | Monroe | Pennsylvania | 42089 | 9195 | 256 |
1029846 | 1029846 | 2021-02-14 | Monroe | Pennsylvania | 42089 | 9179 | 256 |
987614 | 987614 | 2021-02-01 | Blair | Pennsylvania | 42013 | 9967 | 256 |
984367 | 984367 | 2021-01-31 | Blair | Pennsylvania | 42013 | 9933 | 256 |
922708 | 922708 | 2021-01-12 | Butler | Pennsylvania | 42019 | 11056 | 256 |
887002 | 887002 | 2021-01-01 | Beaver | Pennsylvania | 42007 | 8504 | 256 |
848093 | 848093 | 2020-12-20 | Lackawanna | Pennsylvania | 42069 | 7386 | 256 |
844848 | 844848 | 2020-12-19 | Lackawanna | Pennsylvania | 42069 | 7286 | 256 |
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);