ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where deaths = 3 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bradford 132
- Somerset 98
- Tioga 91
- Cambria 76
- Clarion 67
- Crawford 51
- Montour 35
- Jefferson 31
- Clinton 26
- Mifflin 21
- Northumberland 20
- Snyder 18
- Fayette 13
- Potter 13
- Sullivan 13
- Elk 11
- Perry 11
- Forest 10
- Wayne 10
- Armstrong 9
- Blair 8
- Bedford 7
- Columbia 6
- York 6
- Carbon 5
- Erie 4
- Fulton 4
- Cumberland 3
- Lackawanna 3
- Lehigh 3
- …
state 1
- Pennsylvania · 841 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922755 | 922755 | 2021-01-12 | Sullivan | Pennsylvania | 42113 | 188 | 3 |
919510 | 919510 | 2021-01-11 | Sullivan | Pennsylvania | 42113 | 186 | 3 |
916265 | 916265 | 2021-01-10 | Sullivan | Pennsylvania | 42113 | 186 | 3 |
913020 | 913020 | 2021-01-09 | Sullivan | Pennsylvania | 42113 | 184 | 3 |
909775 | 909775 | 2021-01-08 | Sullivan | Pennsylvania | 42113 | 182 | 3 |
906530 | 906530 | 2021-01-07 | Sullivan | Pennsylvania | 42113 | 177 | 3 |
903284 | 903284 | 2021-01-06 | Sullivan | Pennsylvania | 42113 | 170 | 3 |
900039 | 900039 | 2021-01-05 | Sullivan | Pennsylvania | 42113 | 159 | 3 |
896794 | 896794 | 2021-01-04 | Sullivan | Pennsylvania | 42113 | 157 | 3 |
893548 | 893548 | 2021-01-03 | Sullivan | Pennsylvania | 42113 | 156 | 3 |
890302 | 890302 | 2021-01-02 | Sullivan | Pennsylvania | 42113 | 155 | 3 |
887055 | 887055 | 2021-01-01 | Sullivan | Pennsylvania | 42113 | 150 | 3 |
883780 | 883780 | 2020-12-31 | Forest | Pennsylvania | 42053 | 307 | 3 |
883810 | 883810 | 2020-12-31 | Sullivan | Pennsylvania | 42113 | 146 | 3 |
880520 | 880520 | 2020-12-30 | Cameron | Pennsylvania | 42023 | 141 | 3 |
880535 | 880535 | 2020-12-30 | Forest | Pennsylvania | 42053 | 299 | 3 |
877290 | 877290 | 2020-12-29 | Forest | Pennsylvania | 42053 | 295 | 3 |
874045 | 874045 | 2020-12-28 | Forest | Pennsylvania | 42053 | 293 | 3 |
870800 | 870800 | 2020-12-27 | Forest | Pennsylvania | 42053 | 292 | 3 |
867555 | 867555 | 2020-12-26 | Forest | Pennsylvania | 42053 | 281 | 3 |
864310 | 864310 | 2020-12-25 | Forest | Pennsylvania | 42053 | 253 | 3 |
861065 | 861065 | 2020-12-24 | Forest | Pennsylvania | 42053 | 242 | 3 |
857820 | 857820 | 2020-12-23 | Forest | Pennsylvania | 42053 | 231 | 3 |
854575 | 854575 | 2020-12-22 | Forest | Pennsylvania | 42053 | 228 | 3 |
818906 | 818906 | 2020-12-11 | Warren | Pennsylvania | 42123 | 718 | 3 |
783202 | 783202 | 2020-11-30 | Potter | Pennsylvania | 42105 | 219 | 3 |
779957 | 779957 | 2020-11-29 | Potter | Pennsylvania | 42105 | 215 | 3 |
776711 | 776711 | 2020-11-28 | Potter | Pennsylvania | 42105 | 208 | 3 |
773466 | 773466 | 2020-11-27 | Potter | Pennsylvania | 42105 | 199 | 3 |
770221 | 770221 | 2020-11-26 | Potter | Pennsylvania | 42105 | 192 | 3 |
766975 | 766975 | 2020-11-25 | Potter | Pennsylvania | 42105 | 177 | 3 |
763701 | 763701 | 2020-11-24 | Elk | Pennsylvania | 42047 | 454 | 3 |
763730 | 763730 | 2020-11-24 | Potter | Pennsylvania | 42105 | 159 | 3 |
760456 | 760456 | 2020-11-23 | Elk | Pennsylvania | 42047 | 442 | 3 |
760485 | 760485 | 2020-11-23 | Potter | Pennsylvania | 42105 | 152 | 3 |
757211 | 757211 | 2020-11-22 | Elk | Pennsylvania | 42047 | 429 | 3 |
757240 | 757240 | 2020-11-22 | Potter | Pennsylvania | 42105 | 147 | 3 |
753964 | 753964 | 2020-11-21 | Elk | Pennsylvania | 42047 | 419 | 3 |
753982 | 753982 | 2020-11-21 | McKean | Pennsylvania | 42083 | 341 | 3 |
753993 | 753993 | 2020-11-21 | Potter | Pennsylvania | 42105 | 134 | 3 |
750718 | 750718 | 2020-11-20 | Elk | Pennsylvania | 42047 | 407 | 3 |
750736 | 750736 | 2020-11-20 | McKean | Pennsylvania | 42083 | 332 | 3 |
750747 | 750747 | 2020-11-20 | Potter | Pennsylvania | 42105 | 125 | 3 |
747472 | 747472 | 2020-11-19 | Elk | Pennsylvania | 42047 | 393 | 3 |
747490 | 747490 | 2020-11-19 | McKean | Pennsylvania | 42083 | 327 | 3 |
747501 | 747501 | 2020-11-19 | Potter | Pennsylvania | 42105 | 123 | 3 |
744226 | 744226 | 2020-11-18 | Elk | Pennsylvania | 42047 | 383 | 3 |
744255 | 744255 | 2020-11-18 | Potter | Pennsylvania | 42105 | 118 | 3 |
740979 | 740979 | 2020-11-17 | Elk | Pennsylvania | 42047 | 377 | 3 |
737733 | 737733 | 2020-11-16 | Elk | Pennsylvania | 42047 | 368 | 3 |
734489 | 734489 | 2020-11-15 | Elk | Pennsylvania | 42047 | 343 | 3 |
731243 | 731243 | 2020-11-14 | Elk | Pennsylvania | 42047 | 335 | 3 |
715058 | 715058 | 2020-11-09 | Somerset | Pennsylvania | 42111 | 597 | 3 |
711814 | 711814 | 2020-11-08 | Somerset | Pennsylvania | 42111 | 573 | 3 |
708570 | 708570 | 2020-11-07 | Somerset | Pennsylvania | 42111 | 559 | 3 |
705327 | 705327 | 2020-11-06 | Somerset | Pennsylvania | 42111 | 531 | 3 |
702084 | 702084 | 2020-11-05 | Somerset | Pennsylvania | 42111 | 514 | 3 |
698840 | 698840 | 2020-11-04 | Somerset | Pennsylvania | 42111 | 511 | 3 |
695561 | 695561 | 2020-11-03 | Crawford | Pennsylvania | 42039 | 624 | 3 |
695597 | 695597 | 2020-11-03 | Somerset | Pennsylvania | 42111 | 498 | 3 |
692319 | 692319 | 2020-11-02 | Crawford | Pennsylvania | 42039 | 598 | 3 |
692355 | 692355 | 2020-11-02 | Somerset | Pennsylvania | 42111 | 488 | 3 |
692358 | 692358 | 2020-11-02 | Tioga | Pennsylvania | 42117 | 258 | 3 |
689075 | 689075 | 2020-11-01 | Crawford | Pennsylvania | 42039 | 585 | 3 |
689111 | 689111 | 2020-11-01 | Somerset | Pennsylvania | 42111 | 474 | 3 |
689114 | 689114 | 2020-11-01 | Tioga | Pennsylvania | 42117 | 253 | 3 |
685830 | 685830 | 2020-10-31 | Crawford | Pennsylvania | 42039 | 571 | 3 |
685866 | 685866 | 2020-10-31 | Somerset | Pennsylvania | 42111 | 461 | 3 |
685869 | 685869 | 2020-10-31 | Tioga | Pennsylvania | 42117 | 241 | 3 |
682587 | 682587 | 2020-10-30 | Crawford | Pennsylvania | 42039 | 561 | 3 |
682611 | 682611 | 2020-10-30 | Mifflin | Pennsylvania | 42087 | 426 | 3 |
682623 | 682623 | 2020-10-30 | Somerset | Pennsylvania | 42111 | 449 | 3 |
682626 | 682626 | 2020-10-30 | Tioga | Pennsylvania | 42117 | 230 | 3 |
679344 | 679344 | 2020-10-29 | Crawford | Pennsylvania | 42039 | 532 | 3 |
679368 | 679368 | 2020-10-29 | Mifflin | Pennsylvania | 42087 | 411 | 3 |
679380 | 679380 | 2020-10-29 | Somerset | Pennsylvania | 42111 | 434 | 3 |
679383 | 679383 | 2020-10-29 | Tioga | Pennsylvania | 42117 | 215 | 3 |
676101 | 676101 | 2020-10-28 | Crawford | Pennsylvania | 42039 | 523 | 3 |
676125 | 676125 | 2020-10-28 | Mifflin | Pennsylvania | 42087 | 396 | 3 |
676137 | 676137 | 2020-10-28 | Somerset | Pennsylvania | 42111 | 420 | 3 |
676140 | 676140 | 2020-10-28 | Tioga | Pennsylvania | 42117 | 213 | 3 |
672858 | 672858 | 2020-10-27 | Crawford | Pennsylvania | 42039 | 490 | 3 |
672882 | 672882 | 2020-10-27 | Mifflin | Pennsylvania | 42087 | 381 | 3 |
672894 | 672894 | 2020-10-27 | Somerset | Pennsylvania | 42111 | 412 | 3 |
672897 | 672897 | 2020-10-27 | Tioga | Pennsylvania | 42117 | 205 | 3 |
669616 | 669616 | 2020-10-26 | Crawford | Pennsylvania | 42039 | 478 | 3 |
669640 | 669640 | 2020-10-26 | Mifflin | Pennsylvania | 42087 | 374 | 3 |
669652 | 669652 | 2020-10-26 | Somerset | Pennsylvania | 42111 | 398 | 3 |
669655 | 669655 | 2020-10-26 | Tioga | Pennsylvania | 42117 | 199 | 3 |
666372 | 666372 | 2020-10-25 | Crawford | Pennsylvania | 42039 | 461 | 3 |
666396 | 666396 | 2020-10-25 | Mifflin | Pennsylvania | 42087 | 372 | 3 |
666408 | 666408 | 2020-10-25 | Somerset | Pennsylvania | 42111 | 391 | 3 |
666411 | 666411 | 2020-10-25 | Tioga | Pennsylvania | 42117 | 194 | 3 |
663127 | 663127 | 2020-10-24 | Crawford | Pennsylvania | 42039 | 449 | 3 |
663136 | 663136 | 2020-10-24 | Fulton | Pennsylvania | 42057 | 67 | 3 |
663151 | 663151 | 2020-10-24 | Mifflin | Pennsylvania | 42087 | 360 | 3 |
663163 | 663163 | 2020-10-24 | Somerset | Pennsylvania | 42111 | 372 | 3 |
663166 | 663166 | 2020-10-24 | Tioga | Pennsylvania | 42117 | 188 | 3 |
659879 | 659879 | 2020-10-23 | Clarion | Pennsylvania | 42031 | 200 | 3 |
659883 | 659883 | 2020-10-23 | Crawford | Pennsylvania | 42039 | 438 | 3 |
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);