ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 216 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2261043 | 2261043 | 2022-02-28 | Jefferson | Pennsylvania | 42065 | 8853 | 216 |
2257792 | 2257792 | 2022-02-27 | Jefferson | Pennsylvania | 42065 | 8849 | 216 |
2254541 | 2254541 | 2022-02-26 | Jefferson | Pennsylvania | 42065 | 8847 | 216 |
2251290 | 2251290 | 2022-02-25 | Jefferson | Pennsylvania | 42065 | 8839 | 216 |
2176481 | 2176481 | 2022-02-02 | Columbia | Pennsylvania | 42037 | 14136 | 216 |
2173227 | 2173227 | 2022-02-01 | Columbia | Pennsylvania | 42037 | 14035 | 216 |
2153744 | 2153744 | 2022-01-26 | Venango | Pennsylvania | 42121 | 10488 | 216 |
1978130 | 1978130 | 2021-12-03 | Carbon | Pennsylvania | 42025 | 10206 | 216 |
1945630 | 1945630 | 2021-11-23 | Crawford | Pennsylvania | 42039 | 12855 | 216 |
1922861 | 1922861 | 2021-11-16 | Armstrong | Pennsylvania | 42005 | 9699 | 216 |
1546034 | 1546034 | 2021-07-23 | Lawrence | Pennsylvania | 42073 | 7759 | 216 |
1542787 | 1542787 | 2021-07-22 | Lawrence | Pennsylvania | 42073 | 7756 | 216 |
1539539 | 1539539 | 2021-07-21 | Lawrence | Pennsylvania | 42073 | 7752 | 216 |
1536292 | 1536292 | 2021-07-20 | Lawrence | Pennsylvania | 42073 | 7746 | 216 |
1533044 | 1533044 | 2021-07-19 | Lawrence | Pennsylvania | 42073 | 7737 | 216 |
1529797 | 1529797 | 2021-07-18 | Lawrence | Pennsylvania | 42073 | 7735 | 216 |
1526550 | 1526550 | 2021-07-17 | Lawrence | Pennsylvania | 42073 | 7735 | 216 |
1523303 | 1523303 | 2021-07-16 | Lawrence | Pennsylvania | 42073 | 7728 | 216 |
1520055 | 1520055 | 2021-07-15 | Lawrence | Pennsylvania | 42073 | 7723 | 216 |
1516807 | 1516807 | 2021-07-14 | Lawrence | Pennsylvania | 42073 | 7719 | 216 |
1513560 | 1513560 | 2021-07-13 | Lawrence | Pennsylvania | 42073 | 7717 | 216 |
1510314 | 1510314 | 2021-07-12 | Lawrence | Pennsylvania | 42073 | 7712 | 216 |
1507067 | 1507067 | 2021-07-11 | Lawrence | Pennsylvania | 42073 | 7711 | 216 |
1503821 | 1503821 | 2021-07-10 | Lawrence | Pennsylvania | 42073 | 7711 | 216 |
1500575 | 1500575 | 2021-07-09 | Lawrence | Pennsylvania | 42073 | 7710 | 216 |
1497329 | 1497329 | 2021-07-08 | Lawrence | Pennsylvania | 42073 | 7708 | 216 |
1494082 | 1494082 | 2021-07-07 | Lawrence | Pennsylvania | 42073 | 7704 | 216 |
1490835 | 1490835 | 2021-07-06 | Lawrence | Pennsylvania | 42073 | 7703 | 216 |
1487588 | 1487588 | 2021-07-05 | Lawrence | Pennsylvania | 42073 | 7701 | 216 |
1484341 | 1484341 | 2021-07-04 | Lawrence | Pennsylvania | 42073 | 7700 | 216 |
1481095 | 1481095 | 2021-07-03 | Lawrence | Pennsylvania | 42073 | 7699 | 216 |
1477848 | 1477848 | 2021-07-02 | Lawrence | Pennsylvania | 42073 | 7695 | 216 |
1474602 | 1474602 | 2021-07-01 | Lawrence | Pennsylvania | 42073 | 7693 | 216 |
1471356 | 1471356 | 2021-06-30 | Lawrence | Pennsylvania | 42073 | 7691 | 216 |
1468111 | 1468111 | 2021-06-29 | Lawrence | Pennsylvania | 42073 | 7688 | 216 |
1464866 | 1464866 | 2021-06-28 | Lawrence | Pennsylvania | 42073 | 7682 | 216 |
1461621 | 1461621 | 2021-06-27 | Lawrence | Pennsylvania | 42073 | 7683 | 216 |
1458376 | 1458376 | 2021-06-26 | Lawrence | Pennsylvania | 42073 | 7680 | 216 |
1455131 | 1455131 | 2021-06-25 | Lawrence | Pennsylvania | 42073 | 7676 | 216 |
1451886 | 1451886 | 2021-06-24 | Lawrence | Pennsylvania | 42073 | 7673 | 216 |
1419446 | 1419446 | 2021-06-14 | Somerset | Pennsylvania | 42111 | 8035 | 216 |
1416201 | 1416201 | 2021-06-13 | Somerset | Pennsylvania | 42111 | 8034 | 216 |
1412955 | 1412955 | 2021-06-12 | Somerset | Pennsylvania | 42111 | 8033 | 216 |
1409710 | 1409710 | 2021-06-11 | Somerset | Pennsylvania | 42111 | 8032 | 216 |
1240856 | 1240856 | 2021-04-20 | Centre | Pennsylvania | 42027 | 15779 | 216 |
997386 | 997386 | 2021-02-04 | Lycoming | Pennsylvania | 42081 | 8249 | 216 |
974685 | 974685 | 2021-01-28 | Washington | Pennsylvania | 42125 | 12348 | 216 |
945423 | 945423 | 2021-01-19 | Blair | Pennsylvania | 42013 | 9414 | 216 |
916253 | 916253 | 2021-01-10 | Monroe | Pennsylvania | 42089 | 7110 | 216 |
903237 | 903237 | 2021-01-06 | Butler | Pennsylvania | 42019 | 10212 | 216 |
718285 | 718285 | 2020-11-10 | Luzerne | Pennsylvania | 42079 | 6339 | 216 |
611234 | 611234 | 2020-10-08 | Lackawanna | Pennsylvania | 42069 | 2799 | 216 |
607992 | 607992 | 2020-10-07 | Lackawanna | Pennsylvania | 42069 | 2769 | 216 |
604749 | 604749 | 2020-10-06 | Lackawanna | Pennsylvania | 42069 | 2747 | 216 |
601507 | 601507 | 2020-10-05 | Lackawanna | Pennsylvania | 42069 | 2731 | 216 |
598264 | 598264 | 2020-10-04 | Lackawanna | Pennsylvania | 42069 | 2713 | 216 |
595021 | 595021 | 2020-10-03 | Lackawanna | Pennsylvania | 42069 | 2656 | 216 |
562610 | 562610 | 2020-09-23 | Lackawanna | Pennsylvania | 42069 | 2417 | 216 |
559373 | 559373 | 2020-09-22 | Lackawanna | Pennsylvania | 42069 | 2410 | 216 |
556136 | 556136 | 2020-09-21 | Lackawanna | Pennsylvania | 42069 | 2401 | 216 |
552899 | 552899 | 2020-09-20 | Lackawanna | Pennsylvania | 42069 | 2396 | 216 |
123394 | 123394 | 2020-05-07 | Lancaster | Pennsylvania | 42071 | 2070 | 216 |
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);