ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where deaths = 189 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283835 | 2283835 | 2022-03-07 | Tioga | Pennsylvania | 42117 | 7888 | 189 |
2280583 | 2280583 | 2022-03-06 | Tioga | Pennsylvania | 42117 | 7888 | 189 |
2277330 | 2277330 | 2022-03-05 | Tioga | Pennsylvania | 42117 | 7886 | 189 |
2274077 | 2274077 | 2022-03-04 | Tioga | Pennsylvania | 42117 | 7883 | 189 |
2270824 | 2270824 | 2022-03-03 | Tioga | Pennsylvania | 42117 | 7880 | 189 |
2267572 | 2267572 | 2022-03-02 | Tioga | Pennsylvania | 42117 | 7874 | 189 |
2202494 | 2202494 | 2022-02-10 | Bradford | Pennsylvania | 42015 | 14499 | 189 |
2199240 | 2199240 | 2022-02-09 | Bradford | Pennsylvania | 42015 | 14454 | 189 |
2195986 | 2195986 | 2022-02-08 | Bradford | Pennsylvania | 42015 | 14401 | 189 |
2062644 | 2062644 | 2021-12-29 | Columbia | Pennsylvania | 42037 | 10834 | 189 |
2033439 | 2033439 | 2021-12-20 | Venango | Pennsylvania | 42121 | 8793 | 189 |
2030189 | 2030189 | 2021-12-19 | Venango | Pennsylvania | 42121 | 8776 | 189 |
2026938 | 2026938 | 2021-12-18 | Venango | Pennsylvania | 42121 | 8762 | 189 |
2023687 | 2023687 | 2021-12-17 | Venango | Pennsylvania | 42121 | 8741 | 189 |
2000901 | 2000901 | 2021-12-10 | Huntingdon | Pennsylvania | 42061 | 7932 | 189 |
1945615 | 1945615 | 2021-11-23 | Bedford | Pennsylvania | 42009 | 7576 | 189 |
1828628 | 1828628 | 2021-10-18 | Armstrong | Pennsylvania | 42005 | 8469 | 189 |
1786401 | 1786401 | 2021-10-05 | Carbon | Pennsylvania | 42025 | 8056 | 189 |
1727934 | 1727934 | 2021-09-17 | Indiana | Pennsylvania | 42063 | 7469 | 189 |
1724685 | 1724685 | 2021-09-16 | Indiana | Pennsylvania | 42063 | 7425 | 189 |
1539503 | 1539503 | 2021-07-21 | Adams | Pennsylvania | 42001 | 9754 | 189 |
1536256 | 1536256 | 2021-07-20 | Adams | Pennsylvania | 42001 | 9740 | 189 |
1533008 | 1533008 | 2021-07-19 | Adams | Pennsylvania | 42001 | 9732 | 189 |
1529761 | 1529761 | 2021-07-18 | Adams | Pennsylvania | 42001 | 9727 | 189 |
1526514 | 1526514 | 2021-07-17 | Adams | Pennsylvania | 42001 | 9722 | 189 |
1523267 | 1523267 | 2021-07-16 | Adams | Pennsylvania | 42001 | 9720 | 189 |
1520019 | 1520019 | 2021-07-15 | Adams | Pennsylvania | 42001 | 9715 | 189 |
1516771 | 1516771 | 2021-07-14 | Adams | Pennsylvania | 42001 | 9713 | 189 |
1513524 | 1513524 | 2021-07-13 | Adams | Pennsylvania | 42001 | 9709 | 189 |
1510278 | 1510278 | 2021-07-12 | Adams | Pennsylvania | 42001 | 9705 | 189 |
1507031 | 1507031 | 2021-07-11 | Adams | Pennsylvania | 42001 | 9705 | 189 |
1503785 | 1503785 | 2021-07-10 | Adams | Pennsylvania | 42001 | 9702 | 189 |
1500539 | 1500539 | 2021-07-09 | Adams | Pennsylvania | 42001 | 9702 | 189 |
1497293 | 1497293 | 2021-07-08 | Adams | Pennsylvania | 42001 | 9697 | 189 |
1494046 | 1494046 | 2021-07-07 | Adams | Pennsylvania | 42001 | 9696 | 189 |
1490799 | 1490799 | 2021-07-06 | Adams | Pennsylvania | 42001 | 9694 | 189 |
1487552 | 1487552 | 2021-07-05 | Adams | Pennsylvania | 42001 | 9690 | 189 |
1484305 | 1484305 | 2021-07-04 | Adams | Pennsylvania | 42001 | 9689 | 189 |
1481059 | 1481059 | 2021-07-03 | Adams | Pennsylvania | 42001 | 9688 | 189 |
1477812 | 1477812 | 2021-07-02 | Adams | Pennsylvania | 42001 | 9685 | 189 |
1474566 | 1474566 | 2021-07-01 | Adams | Pennsylvania | 42001 | 9683 | 189 |
1471320 | 1471320 | 2021-06-30 | Adams | Pennsylvania | 42001 | 9682 | 189 |
1468075 | 1468075 | 2021-06-29 | Adams | Pennsylvania | 42001 | 9677 | 189 |
1464830 | 1464830 | 2021-06-28 | Adams | Pennsylvania | 42001 | 9671 | 189 |
1461585 | 1461585 | 2021-06-27 | Adams | Pennsylvania | 42001 | 9671 | 189 |
1175942 | 1175942 | 2021-03-31 | Somerset | Pennsylvania | 42111 | 6970 | 189 |
1123969 | 1123969 | 2021-03-15 | Lawrence | Pennsylvania | 42073 | 6285 | 189 |
1120723 | 1120723 | 2021-03-14 | Lawrence | Pennsylvania | 42073 | 6277 | 189 |
1117476 | 1117476 | 2021-03-13 | Lawrence | Pennsylvania | 42073 | 6263 | 189 |
1114229 | 1114229 | 2021-03-12 | Lawrence | Pennsylvania | 42073 | 6242 | 189 |
1110983 | 1110983 | 2021-03-11 | Lawrence | Pennsylvania | 42073 | 6225 | 189 |
929227 | 929227 | 2021-01-14 | Lebanon | Pennsylvania | 42075 | 10457 | 189 |
867553 | 867553 | 2020-12-26 | Erie | Pennsylvania | 42049 | 11089 | 189 |
864308 | 864308 | 2020-12-25 | Erie | Pennsylvania | 42049 | 10935 | 189 |
861083 | 861083 | 2020-12-24 | Monroe | Pennsylvania | 42089 | 5552 | 189 |
857838 | 857838 | 2020-12-23 | Monroe | Pennsylvania | 42089 | 5444 | 189 |
851331 | 851331 | 2020-12-21 | Franklin | Pennsylvania | 42055 | 7649 | 189 |
822094 | 822094 | 2020-12-12 | Beaver | Pennsylvania | 42007 | 6052 | 189 |
796182 | 796182 | 2020-12-04 | Schuylkill | Pennsylvania | 42107 | 4487 | 189 |
572339 | 572339 | 2020-09-26 | Luzerne | Pennsylvania | 42079 | 4088 | 189 |
569097 | 569097 | 2020-09-25 | Luzerne | Pennsylvania | 42079 | 4071 | 189 |
565856 | 565856 | 2020-09-24 | Luzerne | Pennsylvania | 42079 | 4060 | 189 |
562615 | 562615 | 2020-09-23 | Luzerne | Pennsylvania | 42079 | 4050 | 189 |
559378 | 559378 | 2020-09-22 | Luzerne | Pennsylvania | 42079 | 4039 | 189 |
556141 | 556141 | 2020-09-21 | Luzerne | Pennsylvania | 42079 | 4027 | 189 |
552904 | 552904 | 2020-09-20 | Luzerne | Pennsylvania | 42079 | 4024 | 189 |
549665 | 549665 | 2020-09-19 | Luzerne | Pennsylvania | 42079 | 4013 | 189 |
546426 | 546426 | 2020-09-18 | Luzerne | Pennsylvania | 42079 | 4000 | 189 |
543189 | 543189 | 2020-09-17 | Luzerne | Pennsylvania | 42079 | 3989 | 189 |
539953 | 539953 | 2020-09-16 | Luzerne | Pennsylvania | 42079 | 3981 | 189 |
536716 | 536716 | 2020-09-15 | Luzerne | Pennsylvania | 42079 | 3966 | 189 |
533480 | 533480 | 2020-09-14 | Luzerne | Pennsylvania | 42079 | 3951 | 189 |
530245 | 530245 | 2020-09-13 | Luzerne | Pennsylvania | 42079 | 3941 | 189 |
527008 | 527008 | 2020-09-12 | Luzerne | Pennsylvania | 42079 | 3941 | 189 |
523772 | 523772 | 2020-09-11 | Luzerne | Pennsylvania | 42079 | 3926 | 189 |
520536 | 520536 | 2020-09-10 | Luzerne | Pennsylvania | 42079 | 3913 | 189 |
517300 | 517300 | 2020-09-09 | Luzerne | Pennsylvania | 42079 | 3910 | 189 |
514065 | 514065 | 2020-09-08 | Luzerne | Pennsylvania | 42079 | 3898 | 189 |
510832 | 510832 | 2020-09-07 | Luzerne | Pennsylvania | 42079 | 3894 | 189 |
507599 | 507599 | 2020-09-06 | Luzerne | Pennsylvania | 42079 | 3882 | 189 |
504367 | 504367 | 2020-09-05 | Luzerne | Pennsylvania | 42079 | 3867 | 189 |
226797 | 226797 | 2020-06-10 | Lackawanna | Pennsylvania | 42069 | 1591 | 189 |
223697 | 223697 | 2020-06-09 | Lackawanna | Pennsylvania | 42069 | 1587 | 189 |
138315 | 138315 | 2020-05-12 | Chester | Pennsylvania | 42029 | 1973 | 189 |
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);