ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
338 rows where deaths = 20 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sullivan 105
- Lycoming 55
- Cameron 42
- Pike 31
- Potter 17
- Adams 13
- Fulton 11
- Forest 9
- Snyder 9
- Armstrong 6
- Susquehanna 5
- Mercer 4
- Centre 2
- Lackawanna 2
- Lawrence 2
- Northumberland 2
- Tioga 2
- Berks 1
- Blair 1
- Bradford 1
- Bucks 1
- Chester 1
- Clinton 1
- Columbia 1
- Dauphin 1
- Delaware 1
- Greene 1
- Huntingdon 1
- Indiana 1
- Jefferson 1
- …
state 1
- Pennsylvania · 338 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466026 | 2466026 | 2022-05-02 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2462771 | 2462771 | 2022-05-01 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2459515 | 2459515 | 2022-04-30 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2456259 | 2456259 | 2022-04-29 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2453003 | 2453003 | 2022-04-28 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2449747 | 2449747 | 2022-04-27 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2446490 | 2446490 | 2022-04-26 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2443235 | 2443235 | 2022-04-25 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2439979 | 2439979 | 2022-04-24 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2436723 | 2436723 | 2022-04-23 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2433467 | 2433467 | 2022-04-22 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2430211 | 2430211 | 2022-04-21 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2426955 | 2426955 | 2022-04-20 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2423699 | 2423699 | 2022-04-19 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2420443 | 2420443 | 2022-04-18 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2417187 | 2417187 | 2022-04-17 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2413931 | 2413931 | 2022-04-16 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2410675 | 2410675 | 2022-04-15 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2407419 | 2407419 | 2022-04-14 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2404163 | 2404163 | 2022-04-13 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2400908 | 2400908 | 2022-04-12 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2397653 | 2397653 | 2022-04-11 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2394398 | 2394398 | 2022-04-10 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2391142 | 2391142 | 2022-04-09 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2387886 | 2387886 | 2022-04-08 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2384631 | 2384631 | 2022-04-07 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2381376 | 2381376 | 2022-04-06 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2378121 | 2378121 | 2022-04-05 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2374867 | 2374867 | 2022-04-04 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2371615 | 2371615 | 2022-04-03 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2368362 | 2368362 | 2022-04-02 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2365109 | 2365109 | 2022-04-01 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2361856 | 2361856 | 2022-03-31 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2358602 | 2358602 | 2022-03-30 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2355348 | 2355348 | 2022-03-29 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2352095 | 2352095 | 2022-03-28 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2348843 | 2348843 | 2022-03-27 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2345590 | 2345590 | 2022-03-26 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2342337 | 2342337 | 2022-03-25 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2339084 | 2339084 | 2022-03-24 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2335830 | 2335830 | 2022-03-23 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2332576 | 2332576 | 2022-03-22 | Cameron | Pennsylvania | 42023 | 814 | 20 |
1721433 | 1721433 | 2021-09-15 | Fulton | Pennsylvania | 42057 | 1718 | 20 |
1718185 | 1718185 | 2021-09-14 | Fulton | Pennsylvania | 42057 | 1701 | 20 |
1714937 | 1714937 | 2021-09-13 | Fulton | Pennsylvania | 42057 | 1683 | 20 |
1711691 | 1711691 | 2021-09-12 | Fulton | Pennsylvania | 42057 | 1676 | 20 |
1708444 | 1708444 | 2021-09-11 | Fulton | Pennsylvania | 42057 | 1669 | 20 |
1705197 | 1705197 | 2021-09-10 | Fulton | Pennsylvania | 42057 | 1647 | 20 |
1701947 | 1701947 | 2021-09-09 | Fulton | Pennsylvania | 42057 | 1629 | 20 |
1698698 | 1698698 | 2021-09-08 | Fulton | Pennsylvania | 42057 | 1605 | 20 |
1695450 | 1695450 | 2021-09-07 | Fulton | Pennsylvania | 42057 | 1581 | 20 |
1692202 | 1692202 | 2021-09-06 | Fulton | Pennsylvania | 42057 | 1572 | 20 |
1688953 | 1688953 | 2021-09-05 | Fulton | Pennsylvania | 42057 | 1565 | 20 |
1442170 | 1442170 | 2021-06-21 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1438925 | 1438925 | 2021-06-20 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1435678 | 1435678 | 2021-06-19 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1432431 | 1432431 | 2021-06-18 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1429185 | 1429185 | 2021-06-17 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1425940 | 1425940 | 2021-06-16 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1422693 | 1422693 | 2021-06-15 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1419447 | 1419447 | 2021-06-14 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1416202 | 1416202 | 2021-06-13 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1412956 | 1412956 | 2021-06-12 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1409711 | 1409711 | 2021-06-11 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1406466 | 1406466 | 2021-06-10 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1403220 | 1403220 | 2021-06-09 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1399975 | 1399975 | 2021-06-08 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1396730 | 1396730 | 2021-06-07 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1393483 | 1393483 | 2021-06-06 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1390238 | 1390238 | 2021-06-05 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1386993 | 1386993 | 2021-06-04 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1383748 | 1383748 | 2021-06-03 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1380502 | 1380502 | 2021-06-02 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1377257 | 1377257 | 2021-06-01 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1374011 | 1374011 | 2021-05-31 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1370766 | 1370766 | 2021-05-30 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1367520 | 1367520 | 2021-05-29 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1364274 | 1364274 | 2021-05-28 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1361028 | 1361028 | 2021-05-27 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1357782 | 1357782 | 2021-05-26 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1354536 | 1354536 | 2021-05-25 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1351290 | 1351290 | 2021-05-24 | Sullivan | Pennsylvania | 42113 | 430 | 20 |
1348044 | 1348044 | 2021-05-23 | Sullivan | Pennsylvania | 42113 | 430 | 20 |
1344796 | 1344796 | 2021-05-22 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1341548 | 1341548 | 2021-05-21 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1338300 | 1338300 | 2021-05-20 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1335053 | 1335053 | 2021-05-19 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1331806 | 1331806 | 2021-05-18 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1328559 | 1328559 | 2021-05-17 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1325313 | 1325313 | 2021-05-16 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1322067 | 1322067 | 2021-05-15 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1318821 | 1318821 | 2021-05-14 | Sullivan | Pennsylvania | 42113 | 427 | 20 |
1315573 | 1315573 | 2021-05-13 | Sullivan | Pennsylvania | 42113 | 426 | 20 |
1312327 | 1312327 | 2021-05-12 | Sullivan | Pennsylvania | 42113 | 425 | 20 |
1309080 | 1309080 | 2021-05-11 | Sullivan | Pennsylvania | 42113 | 423 | 20 |
1305834 | 1305834 | 2021-05-10 | Sullivan | Pennsylvania | 42113 | 420 | 20 |
1302588 | 1302588 | 2021-05-09 | Sullivan | Pennsylvania | 42113 | 418 | 20 |
1299341 | 1299341 | 2021-05-08 | Sullivan | Pennsylvania | 42113 | 417 | 20 |
1296094 | 1296094 | 2021-05-07 | Sullivan | Pennsylvania | 42113 | 415 | 20 |
1292848 | 1292848 | 2021-05-06 | Sullivan | Pennsylvania | 42113 | 414 | 20 |
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);