ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 42045 799
- 42127 799
- 42091 798
- 42089 796
- 42101 795
- 42017 794
- 42095 793
- 42103 793
- 42029 792
- 42041 792
- 42125 792
- 42003 791
- 42077 790
- 42079 790
- 42007 788
- 42001 787
- 42011 787
- 42069 787
- 42133 787
- 42071 786
- 42075 786
- 42129 786
- 42027 785
- 42049 785
- 42055 785
- 42105 785
- 42019 784
- 42093 784
- 42037 783
- 42043 783
- …
county >30
- Delaware 799
- Wayne 799
- Montgomery 798
- Monroe 796
- Philadelphia 795
- Bucks 794
- Northampton 793
- Pike 793
- Chester 792
- Cumberland 792
- Washington 792
- Allegheny 791
- Lehigh 790
- Luzerne 790
- Beaver 788
- Adams 787
- Berks 787
- Lackawanna 787
- York 787
- Lancaster 786
- Lebanon 786
- Westmoreland 786
- Centre 785
- Erie 785
- Franklin 785
- Potter 785
- Butler 784
- Montour 784
- Columbia 783
- Dauphin 783
- …
state 1
- Pennsylvania · 52,441 ✖
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
23342 | 23342 | 2020-03-31 | Unknown | Pennsylvania | 0 | 1 | |
30147 | 30147 | 2020-04-03 | Unknown | Pennsylvania | 18 | 0 | |
4256 | 4256 | 2020-03-18 | York | Pennsylvania | 42133 | 2 | 0 |
4998 | 4998 | 2020-03-19 | York | Pennsylvania | 42133 | 2 | 0 |
5871 | 5871 | 2020-03-20 | York | Pennsylvania | 42133 | 6 | 0 |
6875 | 6875 | 2020-03-21 | York | Pennsylvania | 42133 | 9 | 0 |
7995 | 7995 | 2020-03-22 | York | Pennsylvania | 42133 | 10 | 0 |
9206 | 9206 | 2020-03-23 | York | Pennsylvania | 42133 | 10 | 0 |
10531 | 10531 | 2020-03-24 | York | Pennsylvania | 42133 | 18 | 0 |
11997 | 11997 | 2020-03-25 | York | Pennsylvania | 42133 | 20 | 0 |
13619 | 13619 | 2020-03-26 | York | Pennsylvania | 42133 | 21 | 0 |
15366 | 15366 | 2020-03-27 | York | Pennsylvania | 42133 | 29 | 0 |
17220 | 17220 | 2020-03-28 | York | Pennsylvania | 42133 | 37 | 0 |
19160 | 19160 | 2020-03-29 | York | Pennsylvania | 42133 | 43 | 0 |
21211 | 21211 | 2020-03-30 | York | Pennsylvania | 42133 | 54 | 0 |
23348 | 23348 | 2020-03-31 | York | Pennsylvania | 42133 | 66 | 0 |
25545 | 25545 | 2020-04-01 | York | Pennsylvania | 42133 | 66 | 0 |
27818 | 27818 | 2020-04-02 | York | Pennsylvania | 42133 | 102 | 1 |
30153 | 30153 | 2020-04-03 | York | Pennsylvania | 42133 | 102 | 1 |
32544 | 32544 | 2020-04-04 | York | Pennsylvania | 42133 | 144 | 1 |
34980 | 34980 | 2020-04-05 | York | Pennsylvania | 42133 | 171 | 1 |
37455 | 37455 | 2020-04-06 | York | Pennsylvania | 42133 | 189 | 1 |
39978 | 39978 | 2020-04-07 | York | Pennsylvania | 42133 | 218 | 2 |
42538 | 42538 | 2020-04-08 | York | Pennsylvania | 42133 | 233 | 2 |
45124 | 45124 | 2020-04-09 | York | Pennsylvania | 42133 | 250 | 3 |
47741 | 47741 | 2020-04-10 | York | Pennsylvania | 42133 | 283 | 3 |
50398 | 50398 | 2020-04-11 | York | Pennsylvania | 42133 | 293 | 3 |
53071 | 53071 | 2020-04-12 | York | Pennsylvania | 42133 | 307 | 3 |
55756 | 55756 | 2020-04-13 | York | Pennsylvania | 42133 | 331 | 3 |
58459 | 58459 | 2020-04-14 | York | Pennsylvania | 42133 | 371 | 3 |
61174 | 61174 | 2020-04-15 | York | Pennsylvania | 42133 | 381 | 4 |
63900 | 63900 | 2020-04-16 | York | Pennsylvania | 42133 | 393 | 4 |
66646 | 66646 | 2020-04-17 | York | Pennsylvania | 42133 | 443 | 4 |
69404 | 69404 | 2020-04-18 | York | Pennsylvania | 42133 | 463 | 4 |
72171 | 72171 | 2020-04-19 | York | Pennsylvania | 42133 | 481 | 6 |
74946 | 74946 | 2020-04-20 | York | Pennsylvania | 42133 | 493 | 6 |
77728 | 77728 | 2020-04-21 | York | Pennsylvania | 42133 | 517 | 13 |
80518 | 80518 | 2020-04-22 | York | Pennsylvania | 42133 | 531 | 14 |
83317 | 83317 | 2020-04-23 | York | Pennsylvania | 42133 | 546 | 13 |
86121 | 86121 | 2020-04-24 | York | Pennsylvania | 42133 | 563 | 13 |
88935 | 88935 | 2020-04-25 | York | Pennsylvania | 42133 | 578 | 13 |
91751 | 91751 | 2020-04-26 | York | Pennsylvania | 42133 | 593 | 13 |
94578 | 94578 | 2020-04-27 | York | Pennsylvania | 42133 | 606 | 13 |
97417 | 97417 | 2020-04-28 | York | Pennsylvania | 42133 | 614 | 13 |
100266 | 100266 | 2020-04-29 | York | Pennsylvania | 42133 | 624 | 13 |
103119 | 103119 | 2020-04-30 | York | Pennsylvania | 42133 | 641 | 13 |
105982 | 105982 | 2020-05-01 | York | Pennsylvania | 42133 | 651 | 13 |
108849 | 108849 | 2020-05-02 | York | Pennsylvania | 42133 | 664 | 13 |
111723 | 111723 | 2020-05-03 | York | Pennsylvania | 42133 | 679 | 13 |
114605 | 114605 | 2020-05-04 | York | Pennsylvania | 42133 | 702 | 13 |
117486 | 117486 | 2020-05-05 | York | Pennsylvania | 42133 | 716 | 13 |
120448 | 120448 | 2020-05-06 | York | Pennsylvania | 42133 | 722 | 13 |
123425 | 123425 | 2020-05-07 | York | Pennsylvania | 42133 | 740 | 13 |
126408 | 126408 | 2020-05-08 | York | Pennsylvania | 42133 | 753 | 13 |
129397 | 129397 | 2020-05-09 | York | Pennsylvania | 42133 | 767 | 13 |
132386 | 132386 | 2020-05-10 | York | Pennsylvania | 42133 | 773 | 13 |
135377 | 135377 | 2020-05-11 | York | Pennsylvania | 42133 | 784 | 13 |
138367 | 138367 | 2020-05-12 | York | Pennsylvania | 42133 | 793 | 14 |
141363 | 141363 | 2020-05-13 | York | Pennsylvania | 42133 | 803 | 14 |
144359 | 144359 | 2020-05-14 | York | Pennsylvania | 42133 | 817 | 15 |
147360 | 147360 | 2020-05-15 | York | Pennsylvania | 42133 | 828 | 16 |
150367 | 150367 | 2020-05-16 | York | Pennsylvania | 42133 | 835 | 15 |
153378 | 153378 | 2020-05-17 | York | Pennsylvania | 42133 | 851 | 16 |
156395 | 156395 | 2020-05-18 | York | Pennsylvania | 42133 | 857 | 18 |
159416 | 159416 | 2020-05-19 | York | Pennsylvania | 42133 | 866 | 18 |
162443 | 162443 | 2020-05-20 | York | Pennsylvania | 42133 | 872 | 19 |
165472 | 165472 | 2020-05-21 | York | Pennsylvania | 42133 | 883 | 21 |
168508 | 168508 | 2020-05-22 | York | Pennsylvania | 42133 | 895 | 22 |
171547 | 171547 | 2020-05-23 | York | Pennsylvania | 42133 | 904 | 22 |
174589 | 174589 | 2020-05-24 | York | Pennsylvania | 42133 | 924 | 22 |
177633 | 177633 | 2020-05-25 | York | Pennsylvania | 42133 | 930 | 22 |
180676 | 180676 | 2020-05-26 | York | Pennsylvania | 42133 | 943 | 22 |
183726 | 183726 | 2020-05-27 | York | Pennsylvania | 42133 | 956 | 22 |
186783 | 186783 | 2020-05-28 | York | Pennsylvania | 42133 | 970 | 25 |
189844 | 189844 | 2020-05-29 | York | Pennsylvania | 42133 | 991 | 26 |
192909 | 192909 | 2020-05-30 | York | Pennsylvania | 42133 | 1000 | 26 |
195978 | 195978 | 2020-05-31 | York | Pennsylvania | 42133 | 1007 | 26 |
199051 | 199051 | 2020-06-01 | York | Pennsylvania | 42133 | 1013 | 26 |
202126 | 202126 | 2020-06-02 | York | Pennsylvania | 42133 | 1028 | 26 |
205203 | 205203 | 2020-06-03 | York | Pennsylvania | 42133 | 1037 | 27 |
208284 | 208284 | 2020-06-04 | York | Pennsylvania | 42133 | 1038 | 28 |
211366 | 211366 | 2020-06-05 | York | Pennsylvania | 42133 | 1040 | 28 |
214452 | 214452 | 2020-06-06 | York | Pennsylvania | 42133 | 1049 | 29 |
217542 | 217542 | 2020-06-07 | York | Pennsylvania | 42133 | 1082 | 29 |
220634 | 220634 | 2020-06-08 | York | Pennsylvania | 42133 | 1086 | 29 |
223729 | 223729 | 2020-06-09 | York | Pennsylvania | 42133 | 1094 | 30 |
226829 | 226829 | 2020-06-10 | York | Pennsylvania | 42133 | 1102 | 30 |
229933 | 229933 | 2020-06-11 | York | Pennsylvania | 42133 | 1117 | 31 |
233038 | 233038 | 2020-06-12 | York | Pennsylvania | 42133 | 1141 | 31 |
236143 | 236143 | 2020-06-13 | York | Pennsylvania | 42133 | 1157 | 31 |
239251 | 239251 | 2020-06-14 | York | Pennsylvania | 42133 | 1162 | 31 |
242360 | 242360 | 2020-06-15 | York | Pennsylvania | 42133 | 1169 | 32 |
245472 | 245472 | 2020-06-16 | York | Pennsylvania | 42133 | 1183 | 32 |
248585 | 248585 | 2020-06-17 | York | Pennsylvania | 42133 | 1195 | 34 |
251700 | 251700 | 2020-06-18 | York | Pennsylvania | 42133 | 1209 | 35 |
254815 | 254815 | 2020-06-19 | York | Pennsylvania | 42133 | 1229 | 35 |
257941 | 257941 | 2020-06-20 | York | Pennsylvania | 42133 | 1255 | 36 |
261068 | 261068 | 2020-06-21 | York | Pennsylvania | 42133 | 1296 | 36 |
264196 | 264196 | 2020-06-22 | York | Pennsylvania | 42133 | 1351 | 36 |
267324 | 267324 | 2020-06-23 | York | Pennsylvania | 42133 | 1381 | 39 |
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);