ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,114 rows where deaths = 2 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Elk 119
- Tioga 105
- Clarion 92
- Fulton 89
- McKean 79
- Union 76
- Snyder 74
- Cambria 52
- Bedford 37
- Crawford 25
- Armstrong 23
- Mifflin 23
- Centre 22
- Sullivan 20
- Washington 19
- Montour 17
- Wyoming 17
- Erie 16
- Forest 14
- Jefferson 14
- Butler 13
- Lycoming 13
- Allegheny 11
- Somerset 11
- Lawrence 10
- Mercer 10
- Adams 8
- Cumberland 8
- Blair 7
- Huntingdon 7
- …
state 1
- Pennsylvania · 1,114 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
880565 | 880565 | 2020-12-30 | Sullivan | Pennsylvania | 42113 | 143 | 2 |
877320 | 877320 | 2020-12-29 | Sullivan | Pennsylvania | 42113 | 139 | 2 |
874075 | 874075 | 2020-12-28 | Sullivan | Pennsylvania | 42113 | 139 | 2 |
870830 | 870830 | 2020-12-27 | Sullivan | Pennsylvania | 42113 | 138 | 2 |
867585 | 867585 | 2020-12-26 | Sullivan | Pennsylvania | 42113 | 135 | 2 |
864340 | 864340 | 2020-12-25 | Sullivan | Pennsylvania | 42113 | 133 | 2 |
861095 | 861095 | 2020-12-24 | Sullivan | Pennsylvania | 42113 | 131 | 2 |
857850 | 857850 | 2020-12-23 | Sullivan | Pennsylvania | 42113 | 128 | 2 |
854605 | 854605 | 2020-12-22 | Sullivan | Pennsylvania | 42113 | 126 | 2 |
851330 | 851330 | 2020-12-21 | Forest | Pennsylvania | 42053 | 222 | 2 |
851360 | 851360 | 2020-12-21 | Sullivan | Pennsylvania | 42113 | 123 | 2 |
848085 | 848085 | 2020-12-20 | Forest | Pennsylvania | 42053 | 214 | 2 |
848115 | 848115 | 2020-12-20 | Sullivan | Pennsylvania | 42113 | 120 | 2 |
844840 | 844840 | 2020-12-19 | Forest | Pennsylvania | 42053 | 206 | 2 |
844870 | 844870 | 2020-12-19 | Sullivan | Pennsylvania | 42113 | 119 | 2 |
841594 | 841594 | 2020-12-18 | Forest | Pennsylvania | 42053 | 187 | 2 |
841624 | 841624 | 2020-12-18 | Sullivan | Pennsylvania | 42113 | 117 | 2 |
838349 | 838349 | 2020-12-17 | Forest | Pennsylvania | 42053 | 185 | 2 |
838379 | 838379 | 2020-12-17 | Sullivan | Pennsylvania | 42113 | 115 | 2 |
835103 | 835103 | 2020-12-16 | Forest | Pennsylvania | 42053 | 181 | 2 |
835133 | 835133 | 2020-12-16 | Sullivan | Pennsylvania | 42113 | 113 | 2 |
831857 | 831857 | 2020-12-15 | Forest | Pennsylvania | 42053 | 175 | 2 |
831887 | 831887 | 2020-12-15 | Sullivan | Pennsylvania | 42113 | 112 | 2 |
828610 | 828610 | 2020-12-14 | Forest | Pennsylvania | 42053 | 169 | 2 |
828640 | 828640 | 2020-12-14 | Sullivan | Pennsylvania | 42113 | 109 | 2 |
825364 | 825364 | 2020-12-13 | Forest | Pennsylvania | 42053 | 160 | 2 |
825394 | 825394 | 2020-12-13 | Sullivan | Pennsylvania | 42113 | 107 | 2 |
822117 | 822117 | 2020-12-12 | Forest | Pennsylvania | 42053 | 154 | 2 |
822147 | 822147 | 2020-12-12 | Sullivan | Pennsylvania | 42113 | 106 | 2 |
818871 | 818871 | 2020-12-11 | Forest | Pennsylvania | 42053 | 150 | 2 |
818901 | 818901 | 2020-12-11 | Sullivan | Pennsylvania | 42113 | 104 | 2 |
815625 | 815625 | 2020-12-10 | Forest | Pennsylvania | 42053 | 143 | 2 |
815660 | 815660 | 2020-12-10 | Warren | Pennsylvania | 42123 | 685 | 2 |
812379 | 812379 | 2020-12-09 | Forest | Pennsylvania | 42053 | 141 | 2 |
812414 | 812414 | 2020-12-09 | Warren | Pennsylvania | 42123 | 630 | 2 |
809135 | 809135 | 2020-12-08 | Forest | Pennsylvania | 42053 | 139 | 2 |
809170 | 809170 | 2020-12-08 | Warren | Pennsylvania | 42123 | 568 | 2 |
805925 | 805925 | 2020-12-07 | Warren | Pennsylvania | 42123 | 498 | 2 |
763707 | 763707 | 2020-11-24 | Greene | Pennsylvania | 42059 | 643 | 2 |
760462 | 760462 | 2020-11-23 | Greene | Pennsylvania | 42059 | 614 | 2 |
757217 | 757217 | 2020-11-22 | Greene | Pennsylvania | 42059 | 584 | 2 |
753970 | 753970 | 2020-11-21 | Greene | Pennsylvania | 42059 | 580 | 2 |
744244 | 744244 | 2020-11-18 | McKean | Pennsylvania | 42083 | 302 | 2 |
740997 | 740997 | 2020-11-17 | McKean | Pennsylvania | 42083 | 300 | 2 |
741008 | 741008 | 2020-11-17 | Potter | Pennsylvania | 42105 | 110 | 2 |
737751 | 737751 | 2020-11-16 | McKean | Pennsylvania | 42083 | 282 | 2 |
737762 | 737762 | 2020-11-16 | Potter | Pennsylvania | 42105 | 105 | 2 |
734507 | 734507 | 2020-11-15 | McKean | Pennsylvania | 42083 | 274 | 2 |
734518 | 734518 | 2020-11-15 | Potter | Pennsylvania | 42105 | 103 | 2 |
731261 | 731261 | 2020-11-14 | McKean | Pennsylvania | 42083 | 261 | 2 |
727999 | 727999 | 2020-11-13 | Elk | Pennsylvania | 42047 | 321 | 2 |
728017 | 728017 | 2020-11-13 | McKean | Pennsylvania | 42083 | 245 | 2 |
724755 | 724755 | 2020-11-12 | Elk | Pennsylvania | 42047 | 313 | 2 |
724773 | 724773 | 2020-11-12 | McKean | Pennsylvania | 42083 | 232 | 2 |
721512 | 721512 | 2020-11-11 | Elk | Pennsylvania | 42047 | 304 | 2 |
721530 | 721530 | 2020-11-11 | McKean | Pennsylvania | 42083 | 227 | 2 |
718269 | 718269 | 2020-11-10 | Elk | Pennsylvania | 42047 | 291 | 2 |
718287 | 718287 | 2020-11-10 | McKean | Pennsylvania | 42083 | 219 | 2 |
715026 | 715026 | 2020-11-09 | Elk | Pennsylvania | 42047 | 273 | 2 |
715044 | 715044 | 2020-11-09 | McKean | Pennsylvania | 42083 | 208 | 2 |
711782 | 711782 | 2020-11-08 | Elk | Pennsylvania | 42047 | 270 | 2 |
711800 | 711800 | 2020-11-08 | McKean | Pennsylvania | 42083 | 193 | 2 |
708538 | 708538 | 2020-11-07 | Elk | Pennsylvania | 42047 | 262 | 2 |
708556 | 708556 | 2020-11-07 | McKean | Pennsylvania | 42083 | 191 | 2 |
705295 | 705295 | 2020-11-06 | Elk | Pennsylvania | 42047 | 250 | 2 |
705313 | 705313 | 2020-11-06 | McKean | Pennsylvania | 42083 | 184 | 2 |
702052 | 702052 | 2020-11-05 | Elk | Pennsylvania | 42047 | 235 | 2 |
702070 | 702070 | 2020-11-05 | McKean | Pennsylvania | 42083 | 182 | 2 |
698808 | 698808 | 2020-11-04 | Elk | Pennsylvania | 42047 | 228 | 2 |
698826 | 698826 | 2020-11-04 | McKean | Pennsylvania | 42083 | 175 | 2 |
695565 | 695565 | 2020-11-03 | Elk | Pennsylvania | 42047 | 221 | 2 |
695583 | 695583 | 2020-11-03 | McKean | Pennsylvania | 42083 | 172 | 2 |
692323 | 692323 | 2020-11-02 | Elk | Pennsylvania | 42047 | 203 | 2 |
692341 | 692341 | 2020-11-02 | McKean | Pennsylvania | 42083 | 165 | 2 |
689079 | 689079 | 2020-11-01 | Elk | Pennsylvania | 42047 | 198 | 2 |
689097 | 689097 | 2020-11-01 | McKean | Pennsylvania | 42083 | 162 | 2 |
685834 | 685834 | 2020-10-31 | Elk | Pennsylvania | 42047 | 177 | 2 |
685852 | 685852 | 2020-10-31 | McKean | Pennsylvania | 42083 | 158 | 2 |
682591 | 682591 | 2020-10-30 | Elk | Pennsylvania | 42047 | 177 | 2 |
682609 | 682609 | 2020-10-30 | McKean | Pennsylvania | 42083 | 157 | 2 |
679348 | 679348 | 2020-10-29 | Elk | Pennsylvania | 42047 | 167 | 2 |
679366 | 679366 | 2020-10-29 | McKean | Pennsylvania | 42083 | 148 | 2 |
676105 | 676105 | 2020-10-28 | Elk | Pennsylvania | 42047 | 164 | 2 |
676123 | 676123 | 2020-10-28 | McKean | Pennsylvania | 42083 | 136 | 2 |
672862 | 672862 | 2020-10-27 | Elk | Pennsylvania | 42047 | 160 | 2 |
672880 | 672880 | 2020-10-27 | McKean | Pennsylvania | 42083 | 132 | 2 |
669620 | 669620 | 2020-10-26 | Elk | Pennsylvania | 42047 | 155 | 2 |
669638 | 669638 | 2020-10-26 | McKean | Pennsylvania | 42083 | 129 | 2 |
666376 | 666376 | 2020-10-25 | Elk | Pennsylvania | 42047 | 154 | 2 |
666394 | 666394 | 2020-10-25 | McKean | Pennsylvania | 42083 | 119 | 2 |
663131 | 663131 | 2020-10-24 | Elk | Pennsylvania | 42047 | 151 | 2 |
663149 | 663149 | 2020-10-24 | McKean | Pennsylvania | 42083 | 118 | 2 |
659887 | 659887 | 2020-10-23 | Elk | Pennsylvania | 42047 | 143 | 2 |
659905 | 659905 | 2020-10-23 | McKean | Pennsylvania | 42083 | 112 | 2 |
656643 | 656643 | 2020-10-22 | Elk | Pennsylvania | 42047 | 134 | 2 |
656661 | 656661 | 2020-10-22 | McKean | Pennsylvania | 42083 | 105 | 2 |
653398 | 653398 | 2020-10-21 | Elk | Pennsylvania | 42047 | 127 | 2 |
653416 | 653416 | 2020-10-21 | McKean | Pennsylvania | 42083 | 102 | 2 |
650153 | 650153 | 2020-10-20 | Elk | Pennsylvania | 42047 | 116 | 2 |
650158 | 650158 | 2020-10-20 | Fulton | Pennsylvania | 42057 | 64 | 2 |
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);