ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 155 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Snyder 12
- Bedford 9
- Columbia 8
- Adams 6
- Dauphin 6
- Juniata 3
- Armstrong 2
- Carbon 2
- Clearfield 2
- Huntingdon 2
- Jefferson 2
- Blair 1
- Cumberland 1
- Indiana 1
- Lackawanna 1
- Luzerne 1
- Mifflin 1
- Monroe 1
- Tioga 1
state 1
- Pennsylvania · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2371658 | 2371658 | 2022-04-03 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2368405 | 2368405 | 2022-04-02 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2365152 | 2365152 | 2022-04-01 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2361899 | 2361899 | 2022-03-31 | Snyder | Pennsylvania | 42109 | 8095 | 155 |
2358645 | 2358645 | 2022-03-30 | Snyder | Pennsylvania | 42109 | 8093 | 155 |
2355391 | 2355391 | 2022-03-29 | Snyder | Pennsylvania | 42109 | 8090 | 155 |
2352138 | 2352138 | 2022-03-28 | Snyder | Pennsylvania | 42109 | 8089 | 155 |
2348886 | 2348886 | 2022-03-27 | Snyder | Pennsylvania | 42109 | 8089 | 155 |
2345633 | 2345633 | 2022-03-26 | Snyder | Pennsylvania | 42109 | 8089 | 155 |
2342380 | 2342380 | 2022-03-25 | Snyder | Pennsylvania | 42109 | 8089 | 155 |
2339127 | 2339127 | 2022-03-24 | Snyder | Pennsylvania | 42109 | 8089 | 155 |
2335873 | 2335873 | 2022-03-23 | Snyder | Pennsylvania | 42109 | 8088 | 155 |
2114681 | 2114681 | 2022-01-14 | Juniata | Pennsylvania | 42067 | 4093 | 155 |
2111429 | 2111429 | 2022-01-13 | Juniata | Pennsylvania | 42067 | 4069 | 155 |
2108177 | 2108177 | 2022-01-12 | Juniata | Pennsylvania | 42067 | 4037 | 155 |
1987900 | 1987900 | 2021-12-06 | Jefferson | Pennsylvania | 42065 | 6296 | 155 |
1987926 | 1987926 | 2021-12-06 | Tioga | Pennsylvania | 42117 | 5697 | 155 |
1984650 | 1984650 | 2021-12-05 | Jefferson | Pennsylvania | 42065 | 6293 | 155 |
1900130 | 1900130 | 2021-11-09 | Columbia | Pennsylvania | 42037 | 8261 | 155 |
1896880 | 1896880 | 2021-11-08 | Columbia | Pennsylvania | 42037 | 8230 | 155 |
1893630 | 1893630 | 2021-11-07 | Columbia | Pennsylvania | 42037 | 8211 | 155 |
1890380 | 1890380 | 2021-11-06 | Columbia | Pennsylvania | 42037 | 8175 | 155 |
1887130 | 1887130 | 2021-11-05 | Columbia | Pennsylvania | 42037 | 8144 | 155 |
1883880 | 1883880 | 2021-11-04 | Columbia | Pennsylvania | 42037 | 8093 | 155 |
1880631 | 1880631 | 2021-11-03 | Columbia | Pennsylvania | 42037 | 8064 | 155 |
1877382 | 1877382 | 2021-11-02 | Columbia | Pennsylvania | 42037 | 8048 | 155 |
1841652 | 1841652 | 2021-10-22 | Huntingdon | Pennsylvania | 42061 | 6731 | 155 |
1838403 | 1838403 | 2021-10-21 | Huntingdon | Pennsylvania | 42061 | 6703 | 155 |
1805887 | 1805887 | 2021-10-11 | Bedford | Pennsylvania | 42009 | 6342 | 155 |
1802637 | 1802637 | 2021-10-10 | Bedford | Pennsylvania | 42009 | 6334 | 155 |
1799388 | 1799388 | 2021-10-09 | Bedford | Pennsylvania | 42009 | 6317 | 155 |
1796139 | 1796139 | 2021-10-08 | Bedford | Pennsylvania | 42009 | 6287 | 155 |
1792890 | 1792890 | 2021-10-07 | Bedford | Pennsylvania | 42009 | 6243 | 155 |
1789641 | 1789641 | 2021-10-06 | Bedford | Pennsylvania | 42009 | 6203 | 155 |
1786393 | 1786393 | 2021-10-05 | Bedford | Pennsylvania | 42009 | 6169 | 155 |
1783144 | 1783144 | 2021-10-04 | Bedford | Pennsylvania | 42009 | 6130 | 155 |
1779895 | 1779895 | 2021-10-03 | Bedford | Pennsylvania | 42009 | 6106 | 155 |
1721407 | 1721407 | 2021-09-15 | Armstrong | Pennsylvania | 42005 | 6949 | 155 |
1718159 | 1718159 | 2021-09-14 | Armstrong | Pennsylvania | 42005 | 6903 | 155 |
1474582 | 1474582 | 2021-07-01 | Clearfield | Pennsylvania | 42033 | 8648 | 155 |
1471336 | 1471336 | 2021-06-30 | Clearfield | Pennsylvania | 42033 | 8648 | 155 |
1130438 | 1130438 | 2021-03-17 | Carbon | Pennsylvania | 42025 | 5054 | 155 |
1127191 | 1127191 | 2021-03-16 | Carbon | Pennsylvania | 42025 | 5042 | 155 |
1123933 | 1123933 | 2021-03-15 | Adams | Pennsylvania | 42001 | 7614 | 155 |
1120687 | 1120687 | 2021-03-14 | Adams | Pennsylvania | 42001 | 7607 | 155 |
1117440 | 1117440 | 2021-03-13 | Adams | Pennsylvania | 42001 | 7586 | 155 |
1114193 | 1114193 | 2021-03-12 | Adams | Pennsylvania | 42001 | 7564 | 155 |
1110947 | 1110947 | 2021-03-11 | Adams | Pennsylvania | 42001 | 7527 | 155 |
1107701 | 1107701 | 2021-03-10 | Adams | Pennsylvania | 42001 | 7502 | 155 |
1042814 | 1042814 | 2021-02-18 | Indiana | Pennsylvania | 42063 | 4996 | 155 |
990897 | 990897 | 2021-02-02 | Mifflin | Pennsylvania | 42087 | 4328 | 155 |
857800 | 857800 | 2020-12-23 | Blair | Pennsylvania | 42013 | 7277 | 155 |
792904 | 792904 | 2020-12-03 | Cumberland | Pennsylvania | 42041 | 5725 | 155 |
792928 | 792928 | 2020-12-03 | Monroe | Pennsylvania | 42089 | 3663 | 155 |
397848 | 397848 | 2020-08-03 | Dauphin | Pennsylvania | 42043 | 2682 | 155 |
394631 | 394631 | 2020-08-02 | Dauphin | Pennsylvania | 42043 | 2657 | 155 |
391415 | 391415 | 2020-08-01 | Dauphin | Pennsylvania | 42043 | 2649 | 155 |
388198 | 388198 | 2020-07-31 | Dauphin | Pennsylvania | 42043 | 2640 | 155 |
384981 | 384981 | 2020-07-30 | Dauphin | Pennsylvania | 42043 | 2628 | 155 |
381763 | 381763 | 2020-07-29 | Dauphin | Pennsylvania | 42043 | 2604 | 155 |
205176 | 205176 | 2020-06-03 | Luzerne | Pennsylvania | 42079 | 2766 | 155 |
180644 | 180644 | 2020-05-26 | Lackawanna | Pennsylvania | 42069 | 1503 | 155 |
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);