ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where deaths = 91 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Potter 39
- Jefferson 21
- Clarion 17
- Montour 15
- Pike 12
- Union 12
- Venango 11
- Bradford 6
- Greene 4
- Wyoming 4
- McKean 3
- Beaver 2
- Carbon 2
- Dauphin 2
- Adams 1
- Armstrong 1
- Bedford 1
- Berks 1
- Clinton 1
- Columbia 1
- Cumberland 1
- Delaware 1
- Erie 1
- Fayette 1
- Franklin 1
- Huntingdon 1
- Juniata 1
- Lycoming 1
- Mifflin 1
- Montgomery 1
- …
state 1
- Pennsylvania · 170 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2387927 | 2387927 | 2022-04-08 | Potter | Pennsylvania | 42105 | 3187 | 91 |
2384672 | 2384672 | 2022-04-07 | Potter | Pennsylvania | 42105 | 3187 | 91 |
2381417 | 2381417 | 2022-04-06 | Potter | Pennsylvania | 42105 | 3182 | 91 |
2378162 | 2378162 | 2022-04-05 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2374908 | 2374908 | 2022-04-04 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2371656 | 2371656 | 2022-04-03 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2368403 | 2368403 | 2022-04-02 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2365150 | 2365150 | 2022-04-01 | Potter | Pennsylvania | 42105 | 3175 | 91 |
2361897 | 2361897 | 2022-03-31 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2358643 | 2358643 | 2022-03-30 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2355389 | 2355389 | 2022-03-29 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2352136 | 2352136 | 2022-03-28 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2348884 | 2348884 | 2022-03-27 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2345631 | 2345631 | 2022-03-26 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2342378 | 2342378 | 2022-03-25 | Potter | Pennsylvania | 42105 | 3167 | 91 |
2339125 | 2339125 | 2022-03-24 | Potter | Pennsylvania | 42105 | 3165 | 91 |
2335871 | 2335871 | 2022-03-23 | Potter | Pennsylvania | 42105 | 3161 | 91 |
2332617 | 2332617 | 2022-03-22 | Potter | Pennsylvania | 42105 | 3158 | 91 |
2329364 | 2329364 | 2022-03-21 | Potter | Pennsylvania | 42105 | 3157 | 91 |
2326112 | 2326112 | 2022-03-20 | Potter | Pennsylvania | 42105 | 3156 | 91 |
2322859 | 2322859 | 2022-03-19 | Potter | Pennsylvania | 42105 | 3156 | 91 |
2319605 | 2319605 | 2022-03-18 | Potter | Pennsylvania | 42105 | 3154 | 91 |
2316351 | 2316351 | 2022-03-17 | Potter | Pennsylvania | 42105 | 3153 | 91 |
2313098 | 2313098 | 2022-03-16 | Potter | Pennsylvania | 42105 | 3153 | 91 |
2309839 | 2309839 | 2022-03-15 | Montour | Pennsylvania | 42093 | 4500 | 91 |
2309845 | 2309845 | 2022-03-15 | Potter | Pennsylvania | 42105 | 3150 | 91 |
2306586 | 2306586 | 2022-03-14 | Montour | Pennsylvania | 42093 | 4496 | 91 |
2306592 | 2306592 | 2022-03-14 | Potter | Pennsylvania | 42105 | 3146 | 91 |
2303335 | 2303335 | 2022-03-13 | Montour | Pennsylvania | 42093 | 4494 | 91 |
2303341 | 2303341 | 2022-03-13 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2300083 | 2300083 | 2022-03-12 | Montour | Pennsylvania | 42093 | 4492 | 91 |
2300089 | 2300089 | 2022-03-12 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2296831 | 2296831 | 2022-03-11 | Montour | Pennsylvania | 42093 | 4491 | 91 |
2296837 | 2296837 | 2022-03-11 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2293579 | 2293579 | 2022-03-10 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2293585 | 2293585 | 2022-03-10 | Potter | Pennsylvania | 42105 | 3142 | 91 |
2290327 | 2290327 | 2022-03-09 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2290333 | 2290333 | 2022-03-09 | Potter | Pennsylvania | 42105 | 3140 | 91 |
2287075 | 2287075 | 2022-03-08 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2287081 | 2287081 | 2022-03-08 | Potter | Pennsylvania | 42105 | 3137 | 91 |
2283823 | 2283823 | 2022-03-07 | Montour | Pennsylvania | 42093 | 4486 | 91 |
2283829 | 2283829 | 2022-03-07 | Potter | Pennsylvania | 42105 | 3132 | 91 |
2280571 | 2280571 | 2022-03-06 | Montour | Pennsylvania | 42093 | 4484 | 91 |
2280577 | 2280577 | 2022-03-06 | Potter | Pennsylvania | 42105 | 3131 | 91 |
2277318 | 2277318 | 2022-03-05 | Montour | Pennsylvania | 42093 | 4482 | 91 |
2277324 | 2277324 | 2022-03-05 | Potter | Pennsylvania | 42105 | 3131 | 91 |
2274065 | 2274065 | 2022-03-04 | Montour | Pennsylvania | 42093 | 4480 | 91 |
2274071 | 2274071 | 2022-03-04 | Potter | Pennsylvania | 42105 | 3129 | 91 |
2270812 | 2270812 | 2022-03-03 | Montour | Pennsylvania | 42093 | 4477 | 91 |
2270818 | 2270818 | 2022-03-03 | Potter | Pennsylvania | 42105 | 3127 | 91 |
2267560 | 2267560 | 2022-03-02 | Montour | Pennsylvania | 42093 | 4474 | 91 |
2267566 | 2267566 | 2022-03-02 | Potter | Pennsylvania | 42105 | 3123 | 91 |
2264307 | 2264307 | 2022-03-01 | Montour | Pennsylvania | 42093 | 4468 | 91 |
2264313 | 2264313 | 2022-03-01 | Potter | Pennsylvania | 42105 | 3119 | 91 |
2241556 | 2241556 | 2022-02-22 | Pike | Pennsylvania | 42103 | 9797 | 91 |
2238305 | 2238305 | 2022-02-21 | Pike | Pennsylvania | 42103 | 9787 | 91 |
2235054 | 2235054 | 2022-02-20 | Pike | Pennsylvania | 42103 | 9787 | 91 |
2231803 | 2231803 | 2022-02-19 | Pike | Pennsylvania | 42103 | 9781 | 91 |
2228552 | 2228552 | 2022-02-18 | Pike | Pennsylvania | 42103 | 9743 | 91 |
2225301 | 2225301 | 2022-02-17 | Pike | Pennsylvania | 42103 | 9712 | 91 |
2222050 | 2222050 | 2022-02-16 | Pike | Pennsylvania | 42103 | 9695 | 91 |
2218799 | 2218799 | 2022-02-15 | Pike | Pennsylvania | 42103 | 9675 | 91 |
2215548 | 2215548 | 2022-02-14 | Pike | Pennsylvania | 42103 | 9664 | 91 |
2212297 | 2212297 | 2022-02-13 | Pike | Pennsylvania | 42103 | 9655 | 91 |
2209044 | 2209044 | 2022-02-12 | Pike | Pennsylvania | 42103 | 9644 | 91 |
2205791 | 2205791 | 2022-02-11 | Pike | Pennsylvania | 42103 | 9624 | 91 |
2147209 | 2147209 | 2022-01-24 | Greene | Pennsylvania | 42059 | 7540 | 91 |
2143955 | 2143955 | 2022-01-23 | Greene | Pennsylvania | 42059 | 7505 | 91 |
2140700 | 2140700 | 2022-01-22 | Greene | Pennsylvania | 42059 | 7477 | 91 |
2137444 | 2137444 | 2022-01-21 | Greene | Pennsylvania | 42059 | 7383 | 91 |
2091952 | 2091952 | 2022-01-07 | Wyoming | Pennsylvania | 42131 | 4039 | 91 |
2088700 | 2088700 | 2022-01-06 | Wyoming | Pennsylvania | 42131 | 4012 | 91 |
2085449 | 2085449 | 2022-01-05 | Wyoming | Pennsylvania | 42131 | 3961 | 91 |
2082197 | 2082197 | 2022-01-04 | Wyoming | Pennsylvania | 42131 | 3924 | 91 |
1968386 | 1968386 | 2021-11-30 | Clinton | Pennsylvania | 42035 | 6012 | 91 |
1877405 | 1877405 | 2021-11-02 | McKean | Pennsylvania | 42083 | 5230 | 91 |
1874156 | 1874156 | 2021-11-01 | McKean | Pennsylvania | 42083 | 5197 | 91 |
1870907 | 1870907 | 2021-10-31 | McKean | Pennsylvania | 42083 | 5197 | 91 |
1721459 | 1721459 | 2021-09-15 | Snyder | Pennsylvania | 42109 | 4035 | 91 |
1721464 | 1721464 | 2021-09-15 | Union | Pennsylvania | 42119 | 6590 | 91 |
1718216 | 1718216 | 2021-09-14 | Union | Pennsylvania | 42119 | 6568 | 91 |
1714968 | 1714968 | 2021-09-13 | Union | Pennsylvania | 42119 | 6548 | 91 |
1711722 | 1711722 | 2021-09-12 | Union | Pennsylvania | 42119 | 6539 | 91 |
1708475 | 1708475 | 2021-09-11 | Union | Pennsylvania | 42119 | 6525 | 91 |
1705228 | 1705228 | 2021-09-10 | Union | Pennsylvania | 42119 | 6510 | 91 |
1701978 | 1701978 | 2021-09-09 | Union | Pennsylvania | 42119 | 6480 | 91 |
1698729 | 1698729 | 2021-09-08 | Union | Pennsylvania | 42119 | 6452 | 91 |
1695455 | 1695455 | 2021-09-07 | Juniata | Pennsylvania | 42067 | 2358 | 91 |
1695481 | 1695481 | 2021-09-07 | Union | Pennsylvania | 42119 | 6417 | 91 |
1692233 | 1692233 | 2021-09-06 | Union | Pennsylvania | 42119 | 6414 | 91 |
1688984 | 1688984 | 2021-09-05 | Union | Pennsylvania | 42119 | 6410 | 91 |
1685734 | 1685734 | 2021-09-04 | Union | Pennsylvania | 42119 | 6398 | 91 |
1403171 | 1403171 | 2021-06-09 | Bradford | Pennsylvania | 42015 | 6093 | 91 |
1399926 | 1399926 | 2021-06-08 | Bradford | Pennsylvania | 42015 | 6093 | 91 |
1396681 | 1396681 | 2021-06-07 | Bradford | Pennsylvania | 42015 | 6088 | 91 |
1393434 | 1393434 | 2021-06-06 | Bradford | Pennsylvania | 42015 | 6087 | 91 |
1390189 | 1390189 | 2021-06-05 | Bradford | Pennsylvania | 42015 | 6087 | 91 |
1386944 | 1386944 | 2021-06-04 | Bradford | Pennsylvania | 42015 | 6079 | 91 |
1322026 | 1322026 | 2021-05-15 | Clarion | Pennsylvania | 42031 | 3146 | 91 |
1318780 | 1318780 | 2021-05-14 | Clarion | Pennsylvania | 42031 | 3140 | 91 |
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);