ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
585 rows where deaths = 4 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Fayette 104
- Huntingdon 69
- Bedford 50
- Jefferson 30
- Fulton 27
- Clarion 25
- Indiana 22
- Clinton 18
- Juniata 18
- Erie 16
- McKean 14
- Mifflin 13
- Cameron 12
- Northumberland 12
- Washington 12
- Mercer 11
- Union 10
- Crawford 9
- Susquehanna 9
- Forest 8
- Snyder 8
- Tioga 8
- Armstrong 7
- Cumberland 7
- Lycoming 7
- Adams 6
- Cambria 5
- Wyoming 5
- Lawrence 4
- Montour 4
- …
state 1
- Pennsylvania · 585 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919465 | 919465 | 2021-01-11 | Cameron | Pennsylvania | 42023 | 187 | 4 |
916220 | 916220 | 2021-01-10 | Cameron | Pennsylvania | 42023 | 186 | 4 |
912975 | 912975 | 2021-01-09 | Cameron | Pennsylvania | 42023 | 186 | 4 |
909730 | 909730 | 2021-01-08 | Cameron | Pennsylvania | 42023 | 183 | 4 |
909745 | 909745 | 2021-01-08 | Forest | Pennsylvania | 42053 | 371 | 4 |
906485 | 906485 | 2021-01-07 | Cameron | Pennsylvania | 42023 | 181 | 4 |
906500 | 906500 | 2021-01-07 | Forest | Pennsylvania | 42053 | 354 | 4 |
903239 | 903239 | 2021-01-06 | Cameron | Pennsylvania | 42023 | 173 | 4 |
903254 | 903254 | 2021-01-06 | Forest | Pennsylvania | 42053 | 351 | 4 |
899994 | 899994 | 2021-01-05 | Cameron | Pennsylvania | 42023 | 164 | 4 |
900009 | 900009 | 2021-01-05 | Forest | Pennsylvania | 42053 | 348 | 4 |
896749 | 896749 | 2021-01-04 | Cameron | Pennsylvania | 42023 | 161 | 4 |
896764 | 896764 | 2021-01-04 | Forest | Pennsylvania | 42053 | 340 | 4 |
893503 | 893503 | 2021-01-03 | Cameron | Pennsylvania | 42023 | 159 | 4 |
893518 | 893518 | 2021-01-03 | Forest | Pennsylvania | 42053 | 335 | 4 |
890257 | 890257 | 2021-01-02 | Cameron | Pennsylvania | 42023 | 159 | 4 |
890272 | 890272 | 2021-01-02 | Forest | Pennsylvania | 42053 | 330 | 4 |
887010 | 887010 | 2021-01-01 | Cameron | Pennsylvania | 42023 | 157 | 4 |
887025 | 887025 | 2021-01-01 | Forest | Pennsylvania | 42053 | 313 | 4 |
883765 | 883765 | 2020-12-31 | Cameron | Pennsylvania | 42023 | 147 | 4 |
799415 | 799415 | 2020-12-05 | McKean | Pennsylvania | 42083 | 600 | 4 |
796170 | 796170 | 2020-12-04 | McKean | Pennsylvania | 42083 | 562 | 4 |
792925 | 792925 | 2020-12-03 | McKean | Pennsylvania | 42083 | 535 | 4 |
789680 | 789680 | 2020-12-02 | McKean | Pennsylvania | 42083 | 525 | 4 |
786435 | 786435 | 2020-12-01 | McKean | Pennsylvania | 42083 | 511 | 4 |
783191 | 783191 | 2020-11-30 | McKean | Pennsylvania | 42083 | 477 | 4 |
779946 | 779946 | 2020-11-29 | McKean | Pennsylvania | 42083 | 464 | 4 |
776700 | 776700 | 2020-11-28 | McKean | Pennsylvania | 42083 | 458 | 4 |
773455 | 773455 | 2020-11-27 | McKean | Pennsylvania | 42083 | 444 | 4 |
770210 | 770210 | 2020-11-26 | McKean | Pennsylvania | 42083 | 437 | 4 |
766946 | 766946 | 2020-11-25 | Elk | Pennsylvania | 42047 | 481 | 4 |
766964 | 766964 | 2020-11-25 | McKean | Pennsylvania | 42083 | 422 | 4 |
763719 | 763719 | 2020-11-24 | McKean | Pennsylvania | 42083 | 416 | 4 |
760474 | 760474 | 2020-11-23 | McKean | Pennsylvania | 42083 | 385 | 4 |
757229 | 757229 | 2020-11-22 | McKean | Pennsylvania | 42083 | 373 | 4 |
750723 | 750723 | 2020-11-20 | Fulton | Pennsylvania | 42057 | 198 | 4 |
750727 | 750727 | 2020-11-20 | Jefferson | Pennsylvania | 42065 | 521 | 4 |
747477 | 747477 | 2020-11-19 | Fulton | Pennsylvania | 42057 | 191 | 4 |
747481 | 747481 | 2020-11-19 | Jefferson | Pennsylvania | 42065 | 492 | 4 |
747509 | 747509 | 2020-11-19 | Venango | Pennsylvania | 42121 | 651 | 4 |
744231 | 744231 | 2020-11-18 | Fulton | Pennsylvania | 42057 | 183 | 4 |
744235 | 744235 | 2020-11-18 | Jefferson | Pennsylvania | 42065 | 470 | 4 |
740971 | 740971 | 2020-11-17 | Clarion | Pennsylvania | 42031 | 556 | 4 |
740984 | 740984 | 2020-11-17 | Fulton | Pennsylvania | 42057 | 172 | 4 |
740988 | 740988 | 2020-11-17 | Jefferson | Pennsylvania | 42065 | 446 | 4 |
737725 | 737725 | 2020-11-16 | Clarion | Pennsylvania | 42031 | 536 | 4 |
737738 | 737738 | 2020-11-16 | Fulton | Pennsylvania | 42057 | 152 | 4 |
737742 | 737742 | 2020-11-16 | Jefferson | Pennsylvania | 42065 | 434 | 4 |
734481 | 734481 | 2020-11-15 | Clarion | Pennsylvania | 42031 | 504 | 4 |
734494 | 734494 | 2020-11-15 | Fulton | Pennsylvania | 42057 | 152 | 4 |
734498 | 734498 | 2020-11-15 | Jefferson | Pennsylvania | 42065 | 415 | 4 |
731235 | 731235 | 2020-11-14 | Clarion | Pennsylvania | 42031 | 454 | 4 |
731248 | 731248 | 2020-11-14 | Fulton | Pennsylvania | 42057 | 151 | 4 |
731252 | 731252 | 2020-11-14 | Jefferson | Pennsylvania | 42065 | 379 | 4 |
727991 | 727991 | 2020-11-13 | Clarion | Pennsylvania | 42031 | 435 | 4 |
728004 | 728004 | 2020-11-13 | Fulton | Pennsylvania | 42057 | 142 | 4 |
728008 | 728008 | 2020-11-13 | Jefferson | Pennsylvania | 42065 | 368 | 4 |
724747 | 724747 | 2020-11-12 | Clarion | Pennsylvania | 42031 | 413 | 4 |
724751 | 724751 | 2020-11-12 | Crawford | Pennsylvania | 42039 | 883 | 4 |
724760 | 724760 | 2020-11-12 | Fulton | Pennsylvania | 42057 | 136 | 4 |
724764 | 724764 | 2020-11-12 | Jefferson | Pennsylvania | 42065 | 347 | 4 |
724775 | 724775 | 2020-11-12 | Mifflin | Pennsylvania | 42087 | 783 | 4 |
721504 | 721504 | 2020-11-11 | Clarion | Pennsylvania | 42031 | 386 | 4 |
721508 | 721508 | 2020-11-11 | Crawford | Pennsylvania | 42039 | 813 | 4 |
721517 | 721517 | 2020-11-11 | Fulton | Pennsylvania | 42057 | 132 | 4 |
721521 | 721521 | 2020-11-11 | Jefferson | Pennsylvania | 42065 | 339 | 4 |
721532 | 721532 | 2020-11-11 | Mifflin | Pennsylvania | 42087 | 691 | 4 |
721544 | 721544 | 2020-11-11 | Somerset | Pennsylvania | 42111 | 755 | 4 |
718261 | 718261 | 2020-11-10 | Clarion | Pennsylvania | 42031 | 379 | 4 |
718265 | 718265 | 2020-11-10 | Crawford | Pennsylvania | 42039 | 765 | 4 |
718274 | 718274 | 2020-11-10 | Fulton | Pennsylvania | 42057 | 129 | 4 |
718278 | 718278 | 2020-11-10 | Jefferson | Pennsylvania | 42065 | 322 | 4 |
718289 | 718289 | 2020-11-10 | Mifflin | Pennsylvania | 42087 | 671 | 4 |
718301 | 718301 | 2020-11-10 | Somerset | Pennsylvania | 42111 | 692 | 4 |
718304 | 718304 | 2020-11-10 | Tioga | Pennsylvania | 42117 | 379 | 4 |
715018 | 715018 | 2020-11-09 | Clarion | Pennsylvania | 42031 | 351 | 4 |
715022 | 715022 | 2020-11-09 | Crawford | Pennsylvania | 42039 | 741 | 4 |
715031 | 715031 | 2020-11-09 | Fulton | Pennsylvania | 42057 | 121 | 4 |
715035 | 715035 | 2020-11-09 | Jefferson | Pennsylvania | 42065 | 309 | 4 |
715046 | 715046 | 2020-11-09 | Mifflin | Pennsylvania | 42087 | 644 | 4 |
715061 | 715061 | 2020-11-09 | Tioga | Pennsylvania | 42117 | 360 | 4 |
711774 | 711774 | 2020-11-08 | Clarion | Pennsylvania | 42031 | 334 | 4 |
711778 | 711778 | 2020-11-08 | Crawford | Pennsylvania | 42039 | 730 | 4 |
711787 | 711787 | 2020-11-08 | Fulton | Pennsylvania | 42057 | 120 | 4 |
711791 | 711791 | 2020-11-08 | Jefferson | Pennsylvania | 42065 | 300 | 4 |
711802 | 711802 | 2020-11-08 | Mifflin | Pennsylvania | 42087 | 607 | 4 |
711817 | 711817 | 2020-11-08 | Tioga | Pennsylvania | 42117 | 355 | 4 |
708530 | 708530 | 2020-11-07 | Clarion | Pennsylvania | 42031 | 314 | 4 |
708534 | 708534 | 2020-11-07 | Crawford | Pennsylvania | 42039 | 703 | 4 |
708543 | 708543 | 2020-11-07 | Fulton | Pennsylvania | 42057 | 120 | 4 |
708547 | 708547 | 2020-11-07 | Jefferson | Pennsylvania | 42065 | 287 | 4 |
708558 | 708558 | 2020-11-07 | Mifflin | Pennsylvania | 42087 | 585 | 4 |
708573 | 708573 | 2020-11-07 | Tioga | Pennsylvania | 42117 | 333 | 4 |
705287 | 705287 | 2020-11-06 | Clarion | Pennsylvania | 42031 | 298 | 4 |
705291 | 705291 | 2020-11-06 | Crawford | Pennsylvania | 42039 | 687 | 4 |
705300 | 705300 | 2020-11-06 | Fulton | Pennsylvania | 42057 | 116 | 4 |
705304 | 705304 | 2020-11-06 | Jefferson | Pennsylvania | 42065 | 271 | 4 |
705315 | 705315 | 2020-11-06 | Mifflin | Pennsylvania | 42087 | 562 | 4 |
705330 | 705330 | 2020-11-06 | Tioga | Pennsylvania | 42117 | 308 | 4 |
702044 | 702044 | 2020-11-05 | Clarion | Pennsylvania | 42031 | 287 | 4 |
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);