ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 149 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2241559 | 2241559 | 2022-02-22 | Snyder | Pennsylvania | 42109 | 7997 | 149 |
2238308 | 2238308 | 2022-02-21 | Snyder | Pennsylvania | 42109 | 7992 | 149 |
2235057 | 2235057 | 2022-02-20 | Snyder | Pennsylvania | 42109 | 7992 | 149 |
2231806 | 2231806 | 2022-02-19 | Snyder | Pennsylvania | 42109 | 7992 | 149 |
2228555 | 2228555 | 2022-02-18 | Snyder | Pennsylvania | 42109 | 7986 | 149 |
2059425 | 2059425 | 2021-12-28 | Perry | Pennsylvania | 42099 | 6726 | 149 |
2056176 | 2056176 | 2021-12-27 | Perry | Pennsylvania | 42099 | 6688 | 149 |
2052927 | 2052927 | 2021-12-26 | Perry | Pennsylvania | 42099 | 6675 | 149 |
2049677 | 2049677 | 2021-12-25 | Perry | Pennsylvania | 42099 | 6662 | 149 |
2046427 | 2046427 | 2021-12-24 | Perry | Pennsylvania | 42099 | 6641 | 149 |
2043177 | 2043177 | 2021-12-23 | Perry | Pennsylvania | 42099 | 6611 | 149 |
2039886 | 2039886 | 2021-12-22 | Bradford | Pennsylvania | 42015 | 10292 | 149 |
2036636 | 2036636 | 2021-12-21 | Bradford | Pennsylvania | 42015 | 10250 | 149 |
1948923 | 1948923 | 2021-11-24 | Warren | Pennsylvania | 42123 | 4961 | 149 |
1945672 | 1945672 | 2021-11-23 | Warren | Pennsylvania | 42123 | 4936 | 149 |
1825395 | 1825395 | 2021-10-17 | Columbia | Pennsylvania | 42037 | 7541 | 149 |
1822146 | 1822146 | 2021-10-16 | Columbia | Pennsylvania | 42037 | 7506 | 149 |
1818897 | 1818897 | 2021-10-15 | Columbia | Pennsylvania | 42037 | 7479 | 149 |
1789667 | 1789667 | 2021-10-06 | Huntingdon | Pennsylvania | 42061 | 6320 | 149 |
1747405 | 1747405 | 2021-09-23 | Bedford | Pennsylvania | 42009 | 5689 | 149 |
1744155 | 1744155 | 2021-09-22 | Bedford | Pennsylvania | 42009 | 5648 | 149 |
1740906 | 1740906 | 2021-09-21 | Bedford | Pennsylvania | 42009 | 5624 | 149 |
1737657 | 1737657 | 2021-09-20 | Bedford | Pennsylvania | 42009 | 5593 | 149 |
1734407 | 1734407 | 2021-09-19 | Bedford | Pennsylvania | 42009 | 5563 | 149 |
1731157 | 1731157 | 2021-09-18 | Bedford | Pennsylvania | 42009 | 5520 | 149 |
1653194 | 1653194 | 2021-08-25 | Armstrong | Pennsylvania | 42005 | 6278 | 149 |
1357745 | 1357745 | 2021-05-26 | Crawford | Pennsylvania | 42039 | 7392 | 149 |
1354499 | 1354499 | 2021-05-25 | Crawford | Pennsylvania | 42039 | 7365 | 149 |
1351253 | 1351253 | 2021-05-24 | Crawford | Pennsylvania | 42039 | 7356 | 149 |
1348007 | 1348007 | 2021-05-23 | Crawford | Pennsylvania | 42039 | 7350 | 149 |
1344759 | 1344759 | 2021-05-22 | Crawford | Pennsylvania | 42039 | 7331 | 149 |
1341511 | 1341511 | 2021-05-21 | Crawford | Pennsylvania | 42039 | 7331 | 149 |
1338263 | 1338263 | 2021-05-20 | Crawford | Pennsylvania | 42039 | 7326 | 149 |
1335016 | 1335016 | 2021-05-19 | Crawford | Pennsylvania | 42039 | 7309 | 149 |
1331769 | 1331769 | 2021-05-18 | Crawford | Pennsylvania | 42039 | 7296 | 149 |
1328522 | 1328522 | 2021-05-17 | Crawford | Pennsylvania | 42039 | 7280 | 149 |
1325276 | 1325276 | 2021-05-16 | Crawford | Pennsylvania | 42039 | 7268 | 149 |
1322030 | 1322030 | 2021-05-15 | Crawford | Pennsylvania | 42039 | 7258 | 149 |
1318784 | 1318784 | 2021-05-14 | Crawford | Pennsylvania | 42039 | 7237 | 149 |
1315536 | 1315536 | 2021-05-13 | Crawford | Pennsylvania | 42039 | 7221 | 149 |
1312290 | 1312290 | 2021-05-12 | Crawford | Pennsylvania | 42039 | 7204 | 149 |
1309043 | 1309043 | 2021-05-11 | Crawford | Pennsylvania | 42039 | 7193 | 149 |
1305797 | 1305797 | 2021-05-10 | Crawford | Pennsylvania | 42039 | 7175 | 149 |
1302551 | 1302551 | 2021-05-09 | Crawford | Pennsylvania | 42039 | 7152 | 149 |
1299304 | 1299304 | 2021-05-08 | Crawford | Pennsylvania | 42039 | 7145 | 149 |
1296057 | 1296057 | 2021-05-07 | Crawford | Pennsylvania | 42039 | 7132 | 149 |
1292811 | 1292811 | 2021-05-06 | Crawford | Pennsylvania | 42039 | 7118 | 149 |
1059026 | 1059026 | 2021-02-23 | Carbon | Pennsylvania | 42025 | 4818 | 149 |
981145 | 981145 | 2021-01-30 | Indiana | Pennsylvania | 42063 | 4759 | 149 |
938961 | 938961 | 2021-01-17 | Lawrence | Pennsylvania | 42073 | 5065 | 149 |
900025 | 900025 | 2021-01-05 | Mercer | Pennsylvania | 42085 | 6278 | 149 |
812380 | 812380 | 2020-12-09 | Franklin | Pennsylvania | 42055 | 5899 | 149 |
760436 | 760436 | 2020-11-23 | Beaver | Pennsylvania | 42007 | 3366 | 149 |
750748 | 750748 | 2020-11-20 | Schuylkill | Pennsylvania | 42107 | 3240 | 149 |
562642 | 562642 | 2020-09-23 | York | Pennsylvania | 42133 | 4606 | 149 |
336879 | 336879 | 2020-07-15 | Dauphin | Pennsylvania | 42043 | 2325 | 149 |
333685 | 333685 | 2020-07-14 | Dauphin | Pennsylvania | 42043 | 2309 | 149 |
330493 | 330493 | 2020-07-13 | Dauphin | Pennsylvania | 42043 | 2296 | 149 |
327307 | 327307 | 2020-07-12 | Dauphin | Pennsylvania | 42043 | 2290 | 149 |
324122 | 324122 | 2020-07-11 | Dauphin | Pennsylvania | 42043 | 2279 | 149 |
320942 | 320942 | 2020-07-10 | Dauphin | Pennsylvania | 42043 | 2268 | 149 |
199024 | 199024 | 2020-06-01 | Luzerne | Pennsylvania | 42079 | 2739 | 149 |
195951 | 195951 | 2020-05-31 | Luzerne | Pennsylvania | 42079 | 2736 | 149 |
153346 | 153346 | 2020-05-17 | Lackawanna | Pennsylvania | 42069 | 1344 | 149 |
117434 | 117434 | 2020-05-05 | Chester | Pennsylvania | 42029 | 1647 | 149 |
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);