ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where deaths = 188 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264319 | 2264319 | 2022-03-01 | Tioga | Pennsylvania | 42117 | 7864 | 188 |
2261069 | 2261069 | 2022-02-28 | Tioga | Pennsylvania | 42117 | 7853 | 188 |
2257818 | 2257818 | 2022-02-27 | Tioga | Pennsylvania | 42117 | 7852 | 188 |
2254567 | 2254567 | 2022-02-26 | Tioga | Pennsylvania | 42117 | 7846 | 188 |
2251316 | 2251316 | 2022-02-25 | Tioga | Pennsylvania | 42117 | 7841 | 188 |
2248065 | 2248065 | 2022-02-24 | Tioga | Pennsylvania | 42117 | 7834 | 188 |
2192732 | 2192732 | 2022-02-07 | Bradford | Pennsylvania | 42015 | 14368 | 188 |
2189478 | 2189478 | 2022-02-06 | Bradford | Pennsylvania | 42015 | 14353 | 188 |
2186225 | 2186225 | 2022-02-05 | Bradford | Pennsylvania | 42015 | 14323 | 188 |
2182973 | 2182973 | 2022-02-04 | Bradford | Pennsylvania | 42015 | 14292 | 188 |
2179721 | 2179721 | 2022-02-03 | Bradford | Pennsylvania | 42015 | 14246 | 188 |
2173224 | 2173224 | 2022-02-01 | Clarion | Pennsylvania | 42031 | 7868 | 188 |
2169972 | 2169972 | 2022-01-31 | Clarion | Pennsylvania | 42031 | 7854 | 188 |
2166718 | 2166718 | 2022-01-30 | Clarion | Pennsylvania | 42031 | 7838 | 188 |
2163463 | 2163463 | 2022-01-29 | Clarion | Pennsylvania | 42031 | 7822 | 188 |
2127716 | 2127716 | 2022-01-18 | Warren | Pennsylvania | 42123 | 6295 | 188 |
2124464 | 2124464 | 2022-01-17 | Warren | Pennsylvania | 42123 | 6281 | 188 |
2121212 | 2121212 | 2022-01-16 | Warren | Pennsylvania | 42123 | 6262 | 188 |
2117960 | 2117960 | 2022-01-15 | Warren | Pennsylvania | 42123 | 6228 | 188 |
2114709 | 2114709 | 2022-01-14 | Warren | Pennsylvania | 42123 | 6164 | 188 |
2020436 | 2020436 | 2021-12-16 | Venango | Pennsylvania | 42121 | 8714 | 188 |
1997651 | 1997651 | 2021-12-09 | Huntingdon | Pennsylvania | 42061 | 7887 | 188 |
1857889 | 1857889 | 2021-10-27 | Crawford | Pennsylvania | 42039 | 10880 | 188 |
1854640 | 1854640 | 2021-10-26 | Crawford | Pennsylvania | 42039 | 10830 | 188 |
1828669 | 1828669 | 2021-10-18 | Mifflin | Pennsylvania | 42087 | 6973 | 188 |
1825393 | 1825393 | 2021-10-17 | Clearfield | Pennsylvania | 42033 | 10803 | 188 |
1822144 | 1822144 | 2021-10-16 | Clearfield | Pennsylvania | 42033 | 10767 | 188 |
1818895 | 1818895 | 2021-10-15 | Clearfield | Pennsylvania | 42033 | 10727 | 188 |
1721436 | 1721436 | 2021-09-15 | Indiana | Pennsylvania | 42063 | 7379 | 188 |
1718188 | 1718188 | 2021-09-14 | Indiana | Pennsylvania | 42063 | 7330 | 188 |
1458340 | 1458340 | 2021-06-26 | Adams | Pennsylvania | 42001 | 9671 | 188 |
1455095 | 1455095 | 2021-06-25 | Adams | Pennsylvania | 42001 | 9666 | 188 |
1451850 | 1451850 | 2021-06-24 | Adams | Pennsylvania | 42001 | 9662 | 188 |
1448604 | 1448604 | 2021-06-23 | Adams | Pennsylvania | 42001 | 9660 | 188 |
1445359 | 1445359 | 2021-06-22 | Adams | Pennsylvania | 42001 | 9657 | 188 |
1172695 | 1172695 | 2021-03-30 | Somerset | Pennsylvania | 42111 | 6954 | 188 |
1169448 | 1169448 | 2021-03-29 | Somerset | Pennsylvania | 42111 | 6950 | 188 |
1107737 | 1107737 | 2021-03-10 | Lawrence | Pennsylvania | 42073 | 6215 | 188 |
971391 | 971391 | 2021-01-27 | Centre | Pennsylvania | 42027 | 10848 | 188 |
854593 | 854593 | 2020-12-22 | Monroe | Pennsylvania | 42089 | 5366 | 188 |
841578 | 841578 | 2020-12-18 | Cambria | Pennsylvania | 42021 | 7667 | 188 |
650151 | 650151 | 2020-10-20 | Dauphin | Pennsylvania | 42043 | 4448 | 188 |
640458 | 640458 | 2020-10-17 | York | Pennsylvania | 42133 | 5784 | 188 |
501133 | 501133 | 2020-09-04 | Luzerne | Pennsylvania | 42079 | 3831 | 188 |
497899 | 497899 | 2020-09-03 | Luzerne | Pennsylvania | 42079 | 3818 | 188 |
494666 | 494666 | 2020-09-02 | Luzerne | Pennsylvania | 42079 | 3801 | 188 |
491432 | 491432 | 2020-09-01 | Luzerne | Pennsylvania | 42079 | 3788 | 188 |
488199 | 488199 | 2020-08-31 | Luzerne | Pennsylvania | 42079 | 3778 | 188 |
484966 | 484966 | 2020-08-30 | Luzerne | Pennsylvania | 42079 | 3771 | 188 |
481731 | 481731 | 2020-08-29 | Luzerne | Pennsylvania | 42079 | 3768 | 188 |
478497 | 478497 | 2020-08-28 | Luzerne | Pennsylvania | 42079 | 3753 | 188 |
295577 | 295577 | 2020-07-02 | Allegheny | Pennsylvania | 42003 | 3103 | 188 |
220602 | 220602 | 2020-06-08 | Lackawanna | Pennsylvania | 42069 | 1584 | 188 |
162415 | 162415 | 2020-05-20 | Lehigh | Pennsylvania | 42077 | 3550 | 188 |
108818 | 108818 | 2020-05-02 | Lancaster | Pennsylvania | 42071 | 1904 | 188 |
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);