ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where deaths = 95 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2436763 | 2436763 | 2022-04-23 | Pike | Pennsylvania | 42103 | 10316 | 95 |
2433507 | 2433507 | 2022-04-22 | Pike | Pennsylvania | 42103 | 10302 | 95 |
2430251 | 2430251 | 2022-04-21 | Pike | Pennsylvania | 42103 | 10288 | 95 |
2426995 | 2426995 | 2022-04-20 | Pike | Pennsylvania | 42103 | 10274 | 95 |
2423739 | 2423739 | 2022-04-19 | Pike | Pennsylvania | 42103 | 10269 | 95 |
2420483 | 2420483 | 2022-04-18 | Pike | Pennsylvania | 42103 | 10263 | 95 |
2417227 | 2417227 | 2022-04-17 | Pike | Pennsylvania | 42103 | 10259 | 95 |
2413971 | 2413971 | 2022-04-16 | Pike | Pennsylvania | 42103 | 10255 | 95 |
2410715 | 2410715 | 2022-04-15 | Pike | Pennsylvania | 42103 | 10251 | 95 |
2407459 | 2407459 | 2022-04-14 | Pike | Pennsylvania | 42103 | 10241 | 95 |
2404203 | 2404203 | 2022-04-13 | Pike | Pennsylvania | 42103 | 10227 | 95 |
2400948 | 2400948 | 2022-04-12 | Pike | Pennsylvania | 42103 | 10213 | 95 |
2397693 | 2397693 | 2022-04-11 | Pike | Pennsylvania | 42103 | 10204 | 95 |
2394438 | 2394438 | 2022-04-10 | Pike | Pennsylvania | 42103 | 10200 | 95 |
2391182 | 2391182 | 2022-04-09 | Pike | Pennsylvania | 42103 | 10194 | 95 |
2387926 | 2387926 | 2022-04-08 | Pike | Pennsylvania | 42103 | 10184 | 95 |
2384671 | 2384671 | 2022-04-07 | Pike | Pennsylvania | 42103 | 10176 | 95 |
2381416 | 2381416 | 2022-04-06 | Pike | Pennsylvania | 42103 | 10146 | 95 |
2378161 | 2378161 | 2022-04-05 | Pike | Pennsylvania | 42103 | 10133 | 95 |
2374907 | 2374907 | 2022-04-04 | Pike | Pennsylvania | 42103 | 10123 | 95 |
2371655 | 2371655 | 2022-04-03 | Pike | Pennsylvania | 42103 | 10119 | 95 |
2368402 | 2368402 | 2022-04-02 | Pike | Pennsylvania | 42103 | 10119 | 95 |
2365149 | 2365149 | 2022-04-01 | Pike | Pennsylvania | 42103 | 10103 | 95 |
2361896 | 2361896 | 2022-03-31 | Pike | Pennsylvania | 42103 | 10090 | 95 |
2358642 | 2358642 | 2022-03-30 | Pike | Pennsylvania | 42103 | 10085 | 95 |
2355388 | 2355388 | 2022-03-29 | Pike | Pennsylvania | 42103 | 10080 | 95 |
2352135 | 2352135 | 2022-03-28 | Pike | Pennsylvania | 42103 | 10074 | 95 |
2348883 | 2348883 | 2022-03-27 | Pike | Pennsylvania | 42103 | 10073 | 95 |
2345630 | 2345630 | 2022-03-26 | Pike | Pennsylvania | 42103 | 10073 | 95 |
2342377 | 2342377 | 2022-03-25 | Pike | Pennsylvania | 42103 | 10059 | 95 |
2339124 | 2339124 | 2022-03-24 | Pike | Pennsylvania | 42103 | 10050 | 95 |
2335870 | 2335870 | 2022-03-23 | Pike | Pennsylvania | 42103 | 10036 | 95 |
2332616 | 2332616 | 2022-03-22 | Pike | Pennsylvania | 42103 | 10021 | 95 |
2329363 | 2329363 | 2022-03-21 | Pike | Pennsylvania | 42103 | 10007 | 95 |
2326111 | 2326111 | 2022-03-20 | Pike | Pennsylvania | 42103 | 10008 | 95 |
2322858 | 2322858 | 2022-03-19 | Pike | Pennsylvania | 42103 | 10005 | 95 |
2319604 | 2319604 | 2022-03-18 | Pike | Pennsylvania | 42103 | 9998 | 95 |
2264284 | 2264284 | 2022-03-01 | Elk | Pennsylvania | 42047 | 7067 | 95 |
2261034 | 2261034 | 2022-02-28 | Elk | Pennsylvania | 42047 | 7064 | 95 |
2257783 | 2257783 | 2022-02-27 | Elk | Pennsylvania | 42047 | 7062 | 95 |
2254532 | 2254532 | 2022-02-26 | Elk | Pennsylvania | 42047 | 7061 | 95 |
2251281 | 2251281 | 2022-02-25 | Elk | Pennsylvania | 42047 | 7054 | 95 |
2248030 | 2248030 | 2022-02-24 | Elk | Pennsylvania | 42047 | 7049 | 95 |
2244779 | 2244779 | 2022-02-23 | Elk | Pennsylvania | 42047 | 7038 | 95 |
2241528 | 2241528 | 2022-02-22 | Elk | Pennsylvania | 42047 | 7036 | 95 |
2238277 | 2238277 | 2022-02-21 | Elk | Pennsylvania | 42047 | 7022 | 95 |
2235026 | 2235026 | 2022-02-20 | Elk | Pennsylvania | 42047 | 7022 | 95 |
2231775 | 2231775 | 2022-02-19 | Elk | Pennsylvania | 42047 | 7019 | 95 |
2228524 | 2228524 | 2022-02-18 | Elk | Pennsylvania | 42047 | 7012 | 95 |
2225273 | 2225273 | 2022-02-17 | Elk | Pennsylvania | 42047 | 7001 | 95 |
2150497 | 2150497 | 2022-01-25 | Wyoming | Pennsylvania | 42131 | 4639 | 95 |
2111453 | 2111453 | 2022-01-13 | Susquehanna | Pennsylvania | 42115 | 6566 | 95 |
2108201 | 2108201 | 2022-01-12 | Susquehanna | Pennsylvania | 42115 | 6494 | 95 |
1994387 | 1994387 | 2021-12-08 | Clinton | Pennsylvania | 42035 | 6270 | 95 |
1991136 | 1991136 | 2021-12-07 | Clinton | Pennsylvania | 42035 | 6240 | 95 |
1987885 | 1987885 | 2021-12-06 | Clinton | Pennsylvania | 42035 | 6226 | 95 |
1984635 | 1984635 | 2021-12-05 | Clinton | Pennsylvania | 42035 | 6212 | 95 |
1896903 | 1896903 | 2021-11-08 | McKean | Pennsylvania | 42083 | 5355 | 95 |
1893653 | 1893653 | 2021-11-07 | McKean | Pennsylvania | 42083 | 5339 | 95 |
1890403 | 1890403 | 2021-11-06 | McKean | Pennsylvania | 42083 | 5323 | 95 |
1887153 | 1887153 | 2021-11-05 | McKean | Pennsylvania | 42083 | 5297 | 95 |
1805937 | 1805937 | 2021-10-11 | Snyder | Pennsylvania | 42109 | 4510 | 95 |
1802687 | 1802687 | 2021-10-10 | Snyder | Pennsylvania | 42109 | 4499 | 95 |
1799438 | 1799438 | 2021-10-09 | Snyder | Pennsylvania | 42109 | 4487 | 95 |
1796189 | 1796189 | 2021-10-08 | Snyder | Pennsylvania | 42109 | 4472 | 95 |
1789696 | 1789696 | 2021-10-06 | Union | Pennsylvania | 42119 | 6944 | 95 |
1786448 | 1786448 | 2021-10-05 | Union | Pennsylvania | 42119 | 6926 | 95 |
1783199 | 1783199 | 2021-10-04 | Union | Pennsylvania | 42119 | 6915 | 95 |
1779950 | 1779950 | 2021-10-03 | Union | Pennsylvania | 42119 | 6900 | 95 |
1776700 | 1776700 | 2021-10-02 | Union | Pennsylvania | 42119 | 6869 | 95 |
1773450 | 1773450 | 2021-10-01 | Union | Pennsylvania | 42119 | 6853 | 95 |
1770200 | 1770200 | 2021-09-30 | Union | Pennsylvania | 42119 | 6831 | 95 |
1714942 | 1714942 | 2021-09-13 | Juniata | Pennsylvania | 42067 | 2410 | 95 |
1711696 | 1711696 | 2021-09-12 | Juniata | Pennsylvania | 42067 | 2405 | 95 |
1708449 | 1708449 | 2021-09-11 | Juniata | Pennsylvania | 42067 | 2397 | 95 |
1458347 | 1458347 | 2021-06-26 | Bradford | Pennsylvania | 42015 | 6130 | 95 |
1435637 | 1435637 | 2021-06-19 | Clarion | Pennsylvania | 42031 | 3203 | 95 |
1432390 | 1432390 | 2021-06-18 | Clarion | Pennsylvania | 42031 | 3203 | 95 |
1429144 | 1429144 | 2021-06-17 | Clarion | Pennsylvania | 42031 | 3203 | 95 |
1425899 | 1425899 | 2021-06-16 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1422652 | 1422652 | 2021-06-15 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1419406 | 1419406 | 2021-06-14 | Clarion | Pennsylvania | 42031 | 3203 | 95 |
1416161 | 1416161 | 2021-06-13 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1412915 | 1412915 | 2021-06-12 | Clarion | Pennsylvania | 42031 | 3200 | 95 |
1409670 | 1409670 | 2021-06-11 | Clarion | Pennsylvania | 42031 | 3198 | 95 |
1341552 | 1341552 | 2021-05-21 | Venango | Pennsylvania | 42121 | 3990 | 95 |
1338304 | 1338304 | 2021-05-20 | Venango | Pennsylvania | 42121 | 3983 | 95 |
1283086 | 1283086 | 2021-05-03 | Jefferson | Pennsylvania | 42065 | 3210 | 95 |
1279839 | 1279839 | 2021-05-02 | Jefferson | Pennsylvania | 42065 | 3208 | 95 |
1276592 | 1276592 | 2021-05-01 | Jefferson | Pennsylvania | 42065 | 3207 | 95 |
1273345 | 1273345 | 2021-04-30 | Jefferson | Pennsylvania | 42065 | 3203 | 95 |
1270098 | 1270098 | 2021-04-29 | Jefferson | Pennsylvania | 42065 | 3197 | 95 |
1266851 | 1266851 | 2021-04-28 | Jefferson | Pennsylvania | 42065 | 3194 | 95 |
1263604 | 1263604 | 2021-04-27 | Jefferson | Pennsylvania | 42065 | 3189 | 95 |
1260357 | 1260357 | 2021-04-26 | Jefferson | Pennsylvania | 42065 | 3189 | 95 |
1257110 | 1257110 | 2021-04-25 | Jefferson | Pennsylvania | 42065 | 3188 | 95 |
1253863 | 1253863 | 2021-04-24 | Jefferson | Pennsylvania | 42065 | 3185 | 95 |
1250616 | 1250616 | 2021-04-23 | Jefferson | Pennsylvania | 42065 | 3177 | 95 |
1240892 | 1240892 | 2021-04-20 | Perry | Pennsylvania | 42099 | 3504 | 95 |
1237645 | 1237645 | 2021-04-19 | Perry | Pennsylvania | 42099 | 3489 | 95 |
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);