ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 42043 and state = "Pennsylvania" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7973 | 7973 | 2020-03-22 | Dauphin | Pennsylvania | 42043 | 1 | 0 |
9184 | 9184 | 2020-03-23 | Dauphin | Pennsylvania | 42043 | 1 | 0 |
10507 | 10507 | 2020-03-24 | Dauphin | Pennsylvania | 42043 | 4 | 0 |
11969 | 11969 | 2020-03-25 | Dauphin | Pennsylvania | 42043 | 10 | 0 |
13589 | 13589 | 2020-03-26 | Dauphin | Pennsylvania | 42043 | 13 | 0 |
15335 | 15335 | 2020-03-27 | Dauphin | Pennsylvania | 42043 | 18 | 0 |
17184 | 17184 | 2020-03-28 | Dauphin | Pennsylvania | 42043 | 23 | 0 |
19122 | 19122 | 2020-03-29 | Dauphin | Pennsylvania | 42043 | 35 | 0 |
21172 | 21172 | 2020-03-30 | Dauphin | Pennsylvania | 42043 | 36 | 0 |
23308 | 23308 | 2020-03-31 | Dauphin | Pennsylvania | 42043 | 45 | 1 |
25506 | 25506 | 2020-04-01 | Dauphin | Pennsylvania | 42043 | 59 | 1 |
27778 | 27778 | 2020-04-02 | Dauphin | Pennsylvania | 42043 | 67 | 1 |
30112 | 30112 | 2020-04-03 | Dauphin | Pennsylvania | 42043 | 79 | 1 |
32502 | 32502 | 2020-04-04 | Dauphin | Pennsylvania | 42043 | 99 | 1 |
34937 | 34937 | 2020-04-05 | Dauphin | Pennsylvania | 42043 | 118 | 1 |
37412 | 37412 | 2020-04-06 | Dauphin | Pennsylvania | 42043 | 132 | 1 |
39933 | 39933 | 2020-04-07 | Dauphin | Pennsylvania | 42043 | 155 | 1 |
42493 | 42493 | 2020-04-08 | Dauphin | Pennsylvania | 42043 | 168 | 2 |
45079 | 45079 | 2020-04-09 | Dauphin | Pennsylvania | 42043 | 180 | 2 |
47696 | 47696 | 2020-04-10 | Dauphin | Pennsylvania | 42043 | 199 | 2 |
50353 | 50353 | 2020-04-11 | Dauphin | Pennsylvania | 42043 | 213 | 3 |
53026 | 53026 | 2020-04-12 | Dauphin | Pennsylvania | 42043 | 229 | 4 |
55711 | 55711 | 2020-04-13 | Dauphin | Pennsylvania | 42043 | 240 | 4 |
58414 | 58414 | 2020-04-14 | Dauphin | Pennsylvania | 42043 | 249 | 5 |
61129 | 61129 | 2020-04-15 | Dauphin | Pennsylvania | 42043 | 271 | 5 |
63855 | 63855 | 2020-04-16 | Dauphin | Pennsylvania | 42043 | 287 | 7 |
66601 | 66601 | 2020-04-17 | Dauphin | Pennsylvania | 42043 | 311 | 7 |
69359 | 69359 | 2020-04-18 | Dauphin | Pennsylvania | 42043 | 343 | 9 |
72126 | 72126 | 2020-04-19 | Dauphin | Pennsylvania | 42043 | 368 | 9 |
74901 | 74901 | 2020-04-20 | Dauphin | Pennsylvania | 42043 | 386 | 9 |
77683 | 77683 | 2020-04-21 | Dauphin | Pennsylvania | 42043 | 400 | 11 |
80473 | 80473 | 2020-04-22 | Dauphin | Pennsylvania | 42043 | 422 | 13 |
83272 | 83272 | 2020-04-23 | Dauphin | Pennsylvania | 42043 | 445 | 16 |
86076 | 86076 | 2020-04-24 | Dauphin | Pennsylvania | 42043 | 468 | 19 |
88890 | 88890 | 2020-04-25 | Dauphin | Pennsylvania | 42043 | 492 | 18 |
91706 | 91706 | 2020-04-26 | Dauphin | Pennsylvania | 42043 | 519 | 18 |
94533 | 94533 | 2020-04-27 | Dauphin | Pennsylvania | 42043 | 529 | 21 |
97372 | 97372 | 2020-04-28 | Dauphin | Pennsylvania | 42043 | 553 | 20 |
100221 | 100221 | 2020-04-29 | Dauphin | Pennsylvania | 42043 | 558 | 21 |
103074 | 103074 | 2020-04-30 | Dauphin | Pennsylvania | 42043 | 584 | 25 |
105937 | 105937 | 2020-05-01 | Dauphin | Pennsylvania | 42043 | 601 | 25 |
108804 | 108804 | 2020-05-02 | Dauphin | Pennsylvania | 42043 | 617 | 25 |
111678 | 111678 | 2020-05-03 | Dauphin | Pennsylvania | 42043 | 634 | 28 |
114560 | 114560 | 2020-05-04 | Dauphin | Pennsylvania | 42043 | 652 | 28 |
117441 | 117441 | 2020-05-05 | Dauphin | Pennsylvania | 42043 | 695 | 29 |
120403 | 120403 | 2020-05-06 | Dauphin | Pennsylvania | 42043 | 711 | 29 |
123380 | 123380 | 2020-05-07 | Dauphin | Pennsylvania | 42043 | 735 | 33 |
126363 | 126363 | 2020-05-08 | Dauphin | Pennsylvania | 42043 | 764 | 37 |
129352 | 129352 | 2020-05-09 | Dauphin | Pennsylvania | 42043 | 797 | 36 |
132341 | 132341 | 2020-05-10 | Dauphin | Pennsylvania | 42043 | 823 | 36 |
135332 | 135332 | 2020-05-11 | Dauphin | Pennsylvania | 42043 | 830 | 36 |
138322 | 138322 | 2020-05-12 | Dauphin | Pennsylvania | 42043 | 851 | 38 |
141318 | 141318 | 2020-05-13 | Dauphin | Pennsylvania | 42043 | 871 | 39 |
144314 | 144314 | 2020-05-14 | Dauphin | Pennsylvania | 42043 | 895 | 40 |
147315 | 147315 | 2020-05-15 | Dauphin | Pennsylvania | 42043 | 912 | 41 |
150322 | 150322 | 2020-05-16 | Dauphin | Pennsylvania | 42043 | 938 | 39 |
153333 | 153333 | 2020-05-17 | Dauphin | Pennsylvania | 42043 | 963 | 39 |
156350 | 156350 | 2020-05-18 | Dauphin | Pennsylvania | 42043 | 978 | 50 |
159371 | 159371 | 2020-05-19 | Dauphin | Pennsylvania | 42043 | 989 | 50 |
162398 | 162398 | 2020-05-20 | Dauphin | Pennsylvania | 42043 | 1012 | 51 |
165427 | 165427 | 2020-05-21 | Dauphin | Pennsylvania | 42043 | 1034 | 52 |
168463 | 168463 | 2020-05-22 | Dauphin | Pennsylvania | 42043 | 1049 | 57 |
171502 | 171502 | 2020-05-23 | Dauphin | Pennsylvania | 42043 | 1061 | 62 |
174544 | 174544 | 2020-05-24 | Dauphin | Pennsylvania | 42043 | 1099 | 63 |
177588 | 177588 | 2020-05-25 | Dauphin | Pennsylvania | 42043 | 1123 | 63 |
180631 | 180631 | 2020-05-26 | Dauphin | Pennsylvania | 42043 | 1137 | 63 |
183681 | 183681 | 2020-05-27 | Dauphin | Pennsylvania | 42043 | 1174 | 66 |
186738 | 186738 | 2020-05-28 | Dauphin | Pennsylvania | 42043 | 1212 | 71 |
189799 | 189799 | 2020-05-29 | Dauphin | Pennsylvania | 42043 | 1231 | 72 |
192864 | 192864 | 2020-05-30 | Dauphin | Pennsylvania | 42043 | 1258 | 73 |
195933 | 195933 | 2020-05-31 | Dauphin | Pennsylvania | 42043 | 1277 | 73 |
199006 | 199006 | 2020-06-01 | Dauphin | Pennsylvania | 42043 | 1303 | 74 |
202081 | 202081 | 2020-06-02 | Dauphin | Pennsylvania | 42043 | 1359 | 77 |
205158 | 205158 | 2020-06-03 | Dauphin | Pennsylvania | 42043 | 1385 | 85 |
208239 | 208239 | 2020-06-04 | Dauphin | Pennsylvania | 42043 | 1404 | 87 |
211321 | 211321 | 2020-06-05 | Dauphin | Pennsylvania | 42043 | 1434 | 88 |
214407 | 214407 | 2020-06-06 | Dauphin | Pennsylvania | 42043 | 1451 | 90 |
217497 | 217497 | 2020-06-07 | Dauphin | Pennsylvania | 42043 | 1481 | 91 |
220589 | 220589 | 2020-06-08 | Dauphin | Pennsylvania | 42043 | 1499 | 91 |
223684 | 223684 | 2020-06-09 | Dauphin | Pennsylvania | 42043 | 1525 | 96 |
226784 | 226784 | 2020-06-10 | Dauphin | Pennsylvania | 42043 | 1541 | 101 |
229888 | 229888 | 2020-06-11 | Dauphin | Pennsylvania | 42043 | 1561 | 104 |
232993 | 232993 | 2020-06-12 | Dauphin | Pennsylvania | 42043 | 1587 | 107 |
236098 | 236098 | 2020-06-13 | Dauphin | Pennsylvania | 42043 | 1606 | 107 |
239206 | 239206 | 2020-06-14 | Dauphin | Pennsylvania | 42043 | 1634 | 107 |
242315 | 242315 | 2020-06-15 | Dauphin | Pennsylvania | 42043 | 1655 | 107 |
245427 | 245427 | 2020-06-16 | Dauphin | Pennsylvania | 42043 | 1674 | 108 |
248540 | 248540 | 2020-06-17 | Dauphin | Pennsylvania | 42043 | 1693 | 111 |
251655 | 251655 | 2020-06-18 | Dauphin | Pennsylvania | 42043 | 1708 | 116 |
254770 | 254770 | 2020-06-19 | Dauphin | Pennsylvania | 42043 | 1725 | 118 |
257896 | 257896 | 2020-06-20 | Dauphin | Pennsylvania | 42043 | 1745 | 120 |
261023 | 261023 | 2020-06-21 | Dauphin | Pennsylvania | 42043 | 1762 | 120 |
264151 | 264151 | 2020-06-22 | Dauphin | Pennsylvania | 42043 | 1810 | 120 |
267279 | 267279 | 2020-06-23 | Dauphin | Pennsylvania | 42043 | 1851 | 122 |
270413 | 270413 | 2020-06-24 | Dauphin | Pennsylvania | 42043 | 1864 | 127 |
273552 | 273552 | 2020-06-25 | Dauphin | Pennsylvania | 42043 | 1893 | 131 |
276699 | 276699 | 2020-06-26 | Dauphin | Pennsylvania | 42043 | 1917 | 132 |
279847 | 279847 | 2020-06-27 | Dauphin | Pennsylvania | 42043 | 1932 | 132 |
282993 | 282993 | 2020-06-28 | Dauphin | Pennsylvania | 42043 | 1942 | 132 |
286138 | 286138 | 2020-06-29 | Dauphin | Pennsylvania | 42043 | 1971 | 133 |
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);