ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 311 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2332584 | 2332584 | 2022-03-22 | Crawford | Pennsylvania | 42039 | 19723 | 311 |
2329331 | 2329331 | 2022-03-21 | Crawford | Pennsylvania | 42039 | 19720 | 311 |
2326079 | 2326079 | 2022-03-20 | Crawford | Pennsylvania | 42039 | 19717 | 311 |
2322826 | 2322826 | 2022-03-19 | Crawford | Pennsylvania | 42039 | 19716 | 311 |
2319572 | 2319572 | 2022-03-18 | Crawford | Pennsylvania | 42039 | 19714 | 311 |
2316318 | 2316318 | 2022-03-17 | Crawford | Pennsylvania | 42039 | 19712 | 311 |
2313065 | 2313065 | 2022-03-16 | Crawford | Pennsylvania | 42039 | 19709 | 311 |
2309812 | 2309812 | 2022-03-15 | Crawford | Pennsylvania | 42039 | 19706 | 311 |
2293552 | 2293552 | 2022-03-10 | Crawford | Pennsylvania | 42039 | 19690 | 311 |
2290300 | 2290300 | 2022-03-09 | Crawford | Pennsylvania | 42039 | 19684 | 311 |
2287048 | 2287048 | 2022-03-08 | Crawford | Pennsylvania | 42039 | 19678 | 311 |
2104924 | 2104924 | 2022-01-11 | Indiana | Pennsylvania | 42063 | 13583 | 311 |
2039934 | 2039934 | 2021-12-22 | Somerset | Pennsylvania | 42111 | 13556 | 311 |
1997657 | 1997657 | 2021-12-09 | Lawrence | Pennsylvania | 42073 | 13276 | 311 |
1994406 | 1994406 | 2021-12-08 | Lawrence | Pennsylvania | 42073 | 13205 | 311 |
1825419 | 1825419 | 2021-10-17 | Mercer | Pennsylvania | 42085 | 13152 | 311 |
1822170 | 1822170 | 2021-10-16 | Mercer | Pennsylvania | 42085 | 13112 | 311 |
1818921 | 1818921 | 2021-10-15 | Mercer | Pennsylvania | 42085 | 13059 | 311 |
1763680 | 1763680 | 2021-09-28 | Lebanon | Pennsylvania | 42075 | 18887 | 311 |
1760431 | 1760431 | 2021-09-27 | Lebanon | Pennsylvania | 42075 | 18797 | 311 |
1757183 | 1757183 | 2021-09-26 | Lebanon | Pennsylvania | 42075 | 18763 | 311 |
1753935 | 1753935 | 2021-09-25 | Lebanon | Pennsylvania | 42075 | 18732 | 311 |
1721445 | 1721445 | 2021-09-15 | Lycoming | Pennsylvania | 42081 | 13353 | 311 |
1536318 | 1536318 | 2021-07-20 | Washington | Pennsylvania | 42125 | 18019 | 311 |
1315542 | 1315542 | 2021-05-13 | Fayette | Pennsylvania | 42051 | 12820 | 311 |
1312296 | 1312296 | 2021-05-12 | Fayette | Pennsylvania | 42051 | 12798 | 311 |
1309049 | 1309049 | 2021-05-11 | Fayette | Pennsylvania | 42051 | 12764 | 311 |
1153160 | 1153160 | 2021-03-24 | Blair | Pennsylvania | 42013 | 10969 | 311 |
1016847 | 1016847 | 2021-02-10 | Franklin | Pennsylvania | 42055 | 11949 | 311 |
964898 | 964898 | 2021-01-25 | Butler | Pennsylvania | 42019 | 12327 | 311 |
961653 | 961653 | 2021-01-24 | Butler | Pennsylvania | 42019 | 12263 | 311 |
951961 | 951961 | 2021-01-21 | Schuylkill | Pennsylvania | 42107 | 10516 | 311 |
676129 | 676129 | 2020-10-28 | Northampton | Pennsylvania | 42095 | 5393 | 311 |
672886 | 672886 | 2020-10-27 | Northampton | Pennsylvania | 42095 | 5341 | 311 |
669644 | 669644 | 2020-10-26 | Northampton | Pennsylvania | 42095 | 5304 | 311 |
666400 | 666400 | 2020-10-25 | Northampton | Pennsylvania | 42095 | 5269 | 311 |
663155 | 663155 | 2020-10-24 | Northampton | Pennsylvania | 42095 | 5232 | 311 |
659911 | 659911 | 2020-10-23 | Northampton | Pennsylvania | 42095 | 5184 | 311 |
248533 | 248533 | 2020-06-17 | Chester | Pennsylvania | 42029 | 3411 | 311 |
189783 | 189783 | 2020-05-29 | Berks | Pennsylvania | 42011 | 3988 | 311 |
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);