ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
168 rows where deaths = 92 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Potter 35
- Clarion 19
- Snyder 15
- Greene 14
- Pike 14
- Wyoming 12
- Montour 10
- Tioga 6
- Union 5
- Beaver 4
- Venango 4
- Bradford 3
- Warren 3
- Butler 2
- Crawford 2
- Huntingdon 2
- Jefferson 2
- Mifflin 2
- Adams 1
- Bedford 1
- Blair 1
- Carbon 1
- Clinton 1
- Columbia 1
- Juniata 1
- Lawrence 1
- Lebanon 1
- Luzerne 1
- Northumberland 1
- Perry 1
- …
state 1
- Pennsylvania · 168 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501899 | 2501899 | 2022-05-13 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2498641 | 2498641 | 2022-05-12 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2495383 | 2495383 | 2022-05-11 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2492125 | 2492125 | 2022-05-10 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2488867 | 2488867 | 2022-05-09 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2485610 | 2485610 | 2022-05-08 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2482352 | 2482352 | 2022-05-07 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2479094 | 2479094 | 2022-05-06 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2475836 | 2475836 | 2022-05-05 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2472579 | 2472579 | 2022-05-04 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2469323 | 2469323 | 2022-05-03 | Potter | Pennsylvania | 42105 | 3219 | 92 |
2466067 | 2466067 | 2022-05-02 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2462812 | 2462812 | 2022-05-01 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2459556 | 2459556 | 2022-04-30 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2456300 | 2456300 | 2022-04-29 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2453044 | 2453044 | 2022-04-28 | Potter | Pennsylvania | 42105 | 3217 | 92 |
2449788 | 2449788 | 2022-04-27 | Potter | Pennsylvania | 42105 | 3213 | 92 |
2446531 | 2446531 | 2022-04-26 | Potter | Pennsylvania | 42105 | 3212 | 92 |
2443276 | 2443276 | 2022-04-25 | Potter | Pennsylvania | 42105 | 3211 | 92 |
2440020 | 2440020 | 2022-04-24 | Potter | Pennsylvania | 42105 | 3210 | 92 |
2436764 | 2436764 | 2022-04-23 | Potter | Pennsylvania | 42105 | 3210 | 92 |
2433508 | 2433508 | 2022-04-22 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2430252 | 2430252 | 2022-04-21 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2426996 | 2426996 | 2022-04-20 | Potter | Pennsylvania | 42105 | 3206 | 92 |
2423740 | 2423740 | 2022-04-19 | Potter | Pennsylvania | 42105 | 3204 | 92 |
2420484 | 2420484 | 2022-04-18 | Potter | Pennsylvania | 42105 | 3204 | 92 |
2417228 | 2417228 | 2022-04-17 | Potter | Pennsylvania | 42105 | 3203 | 92 |
2413972 | 2413972 | 2022-04-16 | Potter | Pennsylvania | 42105 | 3203 | 92 |
2410716 | 2410716 | 2022-04-15 | Potter | Pennsylvania | 42105 | 3200 | 92 |
2407460 | 2407460 | 2022-04-14 | Potter | Pennsylvania | 42105 | 3199 | 92 |
2404204 | 2404204 | 2022-04-13 | Potter | Pennsylvania | 42105 | 3197 | 92 |
2400949 | 2400949 | 2022-04-12 | Potter | Pennsylvania | 42105 | 3194 | 92 |
2397694 | 2397694 | 2022-04-11 | Potter | Pennsylvania | 42105 | 3190 | 92 |
2394439 | 2394439 | 2022-04-10 | Potter | Pennsylvania | 42105 | 3190 | 92 |
2391183 | 2391183 | 2022-04-09 | Potter | Pennsylvania | 42105 | 3189 | 92 |
2342372 | 2342372 | 2022-03-25 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2339119 | 2339119 | 2022-03-24 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2335865 | 2335865 | 2022-03-23 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2332611 | 2332611 | 2022-03-22 | Montour | Pennsylvania | 42093 | 4502 | 92 |
2329358 | 2329358 | 2022-03-21 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2326106 | 2326106 | 2022-03-20 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2322853 | 2322853 | 2022-03-19 | Montour | Pennsylvania | 42093 | 4503 | 92 |
2319599 | 2319599 | 2022-03-18 | Montour | Pennsylvania | 42093 | 4500 | 92 |
2316345 | 2316345 | 2022-03-17 | Montour | Pennsylvania | 42093 | 4499 | 92 |
2313092 | 2313092 | 2022-03-16 | Montour | Pennsylvania | 42093 | 4499 | 92 |
2287080 | 2287080 | 2022-03-08 | Pike | Pennsylvania | 42103 | 9922 | 92 |
2283828 | 2283828 | 2022-03-07 | Pike | Pennsylvania | 42103 | 9912 | 92 |
2280576 | 2280576 | 2022-03-06 | Pike | Pennsylvania | 42103 | 9912 | 92 |
2277323 | 2277323 | 2022-03-05 | Pike | Pennsylvania | 42103 | 9907 | 92 |
2274070 | 2274070 | 2022-03-04 | Pike | Pennsylvania | 42103 | 9902 | 92 |
2270817 | 2270817 | 2022-03-03 | Pike | Pennsylvania | 42103 | 9898 | 92 |
2267565 | 2267565 | 2022-03-02 | Pike | Pennsylvania | 42103 | 9888 | 92 |
2264312 | 2264312 | 2022-03-01 | Pike | Pennsylvania | 42103 | 9882 | 92 |
2261062 | 2261062 | 2022-02-28 | Pike | Pennsylvania | 42103 | 9868 | 92 |
2257811 | 2257811 | 2022-02-27 | Pike | Pennsylvania | 42103 | 9867 | 92 |
2254560 | 2254560 | 2022-02-26 | Pike | Pennsylvania | 42103 | 9861 | 92 |
2251309 | 2251309 | 2022-02-25 | Pike | Pennsylvania | 42103 | 9852 | 92 |
2248058 | 2248058 | 2022-02-24 | Pike | Pennsylvania | 42103 | 9841 | 92 |
2244807 | 2244807 | 2022-02-23 | Pike | Pennsylvania | 42103 | 9823 | 92 |
2192754 | 2192754 | 2022-02-07 | Greene | Pennsylvania | 42059 | 8113 | 92 |
2189500 | 2189500 | 2022-02-06 | Greene | Pennsylvania | 42059 | 8048 | 92 |
2186247 | 2186247 | 2022-02-05 | Greene | Pennsylvania | 42059 | 8040 | 92 |
2182995 | 2182995 | 2022-02-04 | Greene | Pennsylvania | 42059 | 8002 | 92 |
2179743 | 2179743 | 2022-02-03 | Greene | Pennsylvania | 42059 | 7952 | 92 |
2176492 | 2176492 | 2022-02-02 | Greene | Pennsylvania | 42059 | 7917 | 92 |
2173238 | 2173238 | 2022-02-01 | Greene | Pennsylvania | 42059 | 7899 | 92 |
2169986 | 2169986 | 2022-01-31 | Greene | Pennsylvania | 42059 | 7867 | 92 |
2166732 | 2166732 | 2022-01-30 | Greene | Pennsylvania | 42059 | 7847 | 92 |
2163477 | 2163477 | 2022-01-29 | Greene | Pennsylvania | 42059 | 7819 | 92 |
2160222 | 2160222 | 2022-01-28 | Greene | Pennsylvania | 42059 | 7776 | 92 |
2156966 | 2156966 | 2022-01-27 | Greene | Pennsylvania | 42059 | 7706 | 92 |
2153713 | 2153713 | 2022-01-26 | Greene | Pennsylvania | 42059 | 7632 | 92 |
2150461 | 2150461 | 2022-01-25 | Greene | Pennsylvania | 42059 | 7591 | 92 |
2130974 | 2130974 | 2022-01-19 | Wyoming | Pennsylvania | 42131 | 4482 | 92 |
2127720 | 2127720 | 2022-01-18 | Wyoming | Pennsylvania | 42131 | 4463 | 92 |
2124468 | 2124468 | 2022-01-17 | Wyoming | Pennsylvania | 42131 | 4446 | 92 |
2121216 | 2121216 | 2022-01-16 | Wyoming | Pennsylvania | 42131 | 4432 | 92 |
2117964 | 2117964 | 2022-01-15 | Wyoming | Pennsylvania | 42131 | 4345 | 92 |
2114713 | 2114713 | 2022-01-14 | Wyoming | Pennsylvania | 42131 | 4317 | 92 |
2111461 | 2111461 | 2022-01-13 | Wyoming | Pennsylvania | 42131 | 4273 | 92 |
2108209 | 2108209 | 2022-01-12 | Wyoming | Pennsylvania | 42131 | 4238 | 92 |
2104958 | 2104958 | 2022-01-11 | Wyoming | Pennsylvania | 42131 | 4192 | 92 |
2101707 | 2101707 | 2022-01-10 | Wyoming | Pennsylvania | 42131 | 4170 | 92 |
2098456 | 2098456 | 2022-01-09 | Wyoming | Pennsylvania | 42131 | 4126 | 92 |
2095204 | 2095204 | 2022-01-08 | Wyoming | Pennsylvania | 42131 | 4093 | 92 |
1971636 | 1971636 | 2021-12-01 | Clinton | Pennsylvania | 42035 | 6048 | 92 |
1770195 | 1770195 | 2021-09-30 | Snyder | Pennsylvania | 42109 | 4323 | 92 |
1766946 | 1766946 | 2021-09-29 | Snyder | Pennsylvania | 42109 | 4301 | 92 |
1763697 | 1763697 | 2021-09-28 | Snyder | Pennsylvania | 42109 | 4282 | 92 |
1760448 | 1760448 | 2021-09-27 | Snyder | Pennsylvania | 42109 | 4262 | 92 |
1757200 | 1757200 | 2021-09-26 | Snyder | Pennsylvania | 42109 | 4241 | 92 |
1753952 | 1753952 | 2021-09-25 | Snyder | Pennsylvania | 42109 | 4233 | 92 |
1750704 | 1750704 | 2021-09-24 | Snyder | Pennsylvania | 42109 | 4220 | 92 |
1747455 | 1747455 | 2021-09-23 | Snyder | Pennsylvania | 42109 | 4199 | 92 |
1744205 | 1744205 | 2021-09-22 | Snyder | Pennsylvania | 42109 | 4175 | 92 |
1740956 | 1740956 | 2021-09-21 | Snyder | Pennsylvania | 42109 | 4156 | 92 |
1737707 | 1737707 | 2021-09-20 | Snyder | Pennsylvania | 42109 | 4135 | 92 |
1737712 | 1737712 | 2021-09-20 | Union | Pennsylvania | 42119 | 6663 | 92 |
1734457 | 1734457 | 2021-09-19 | Snyder | Pennsylvania | 42109 | 4127 | 92 |
1734462 | 1734462 | 2021-09-19 | Union | Pennsylvania | 42119 | 6655 | 92 |
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);