ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Dauphin" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388198 | 388198 | 2020-07-31 | Dauphin | Pennsylvania | 42043 | 2640 | 155 |
384981 | 384981 | 2020-07-30 | Dauphin | Pennsylvania | 42043 | 2628 | 155 |
381763 | 381763 | 2020-07-29 | Dauphin | Pennsylvania | 42043 | 2604 | 155 |
378546 | 378546 | 2020-07-28 | Dauphin | Pennsylvania | 42043 | 2585 | 154 |
375330 | 375330 | 2020-07-27 | Dauphin | Pennsylvania | 42043 | 2559 | 153 |
372117 | 372117 | 2020-07-26 | Dauphin | Pennsylvania | 42043 | 2537 | 153 |
368905 | 368905 | 2020-07-25 | Dauphin | Pennsylvania | 42043 | 2526 | 152 |
365696 | 365696 | 2020-07-24 | Dauphin | Pennsylvania | 42043 | 2499 | 152 |
362490 | 362490 | 2020-07-23 | Dauphin | Pennsylvania | 42043 | 2480 | 152 |
359284 | 359284 | 2020-07-22 | Dauphin | Pennsylvania | 42043 | 2466 | 152 |
356080 | 356080 | 2020-07-21 | Dauphin | Pennsylvania | 42043 | 2446 | 151 |
352877 | 352877 | 2020-07-20 | Dauphin | Pennsylvania | 42043 | 2420 | 150 |
349674 | 349674 | 2020-07-19 | Dauphin | Pennsylvania | 42043 | 2404 | 150 |
346474 | 346474 | 2020-07-18 | Dauphin | Pennsylvania | 42043 | 2400 | 150 |
343274 | 343274 | 2020-07-17 | Dauphin | Pennsylvania | 42043 | 2366 | 150 |
340076 | 340076 | 2020-07-16 | Dauphin | Pennsylvania | 42043 | 2342 | 150 |
336879 | 336879 | 2020-07-15 | Dauphin | Pennsylvania | 42043 | 2325 | 149 |
333685 | 333685 | 2020-07-14 | Dauphin | Pennsylvania | 42043 | 2309 | 149 |
330493 | 330493 | 2020-07-13 | Dauphin | Pennsylvania | 42043 | 2296 | 149 |
327307 | 327307 | 2020-07-12 | Dauphin | Pennsylvania | 42043 | 2290 | 149 |
324122 | 324122 | 2020-07-11 | Dauphin | Pennsylvania | 42043 | 2279 | 149 |
320942 | 320942 | 2020-07-10 | Dauphin | Pennsylvania | 42043 | 2268 | 149 |
317764 | 317764 | 2020-07-09 | Dauphin | Pennsylvania | 42043 | 2247 | 148 |
314591 | 314591 | 2020-07-08 | Dauphin | Pennsylvania | 42043 | 2236 | 143 |
311419 | 311419 | 2020-07-07 | Dauphin | Pennsylvania | 42043 | 2220 | 142 |
308250 | 308250 | 2020-07-06 | Dauphin | Pennsylvania | 42043 | 2198 | 140 |
305083 | 305083 | 2020-07-05 | Dauphin | Pennsylvania | 42043 | 2194 | 140 |
301920 | 301920 | 2020-07-04 | Dauphin | Pennsylvania | 42043 | 2174 | 140 |
298756 | 298756 | 2020-07-03 | Dauphin | Pennsylvania | 42043 | 2161 | 140 |
295597 | 295597 | 2020-07-02 | Dauphin | Pennsylvania | 42043 | 2120 | 136 |
292441 | 292441 | 2020-07-01 | Dauphin | Pennsylvania | 42043 | 2059 | 133 |
289289 | 289289 | 2020-06-30 | Dauphin | Pennsylvania | 42043 | 2045 | 133 |
286138 | 286138 | 2020-06-29 | Dauphin | Pennsylvania | 42043 | 1971 | 133 |
282993 | 282993 | 2020-06-28 | Dauphin | Pennsylvania | 42043 | 1942 | 132 |
279847 | 279847 | 2020-06-27 | Dauphin | Pennsylvania | 42043 | 1932 | 132 |
276699 | 276699 | 2020-06-26 | Dauphin | Pennsylvania | 42043 | 1917 | 132 |
273552 | 273552 | 2020-06-25 | Dauphin | Pennsylvania | 42043 | 1893 | 131 |
270413 | 270413 | 2020-06-24 | Dauphin | Pennsylvania | 42043 | 1864 | 127 |
267279 | 267279 | 2020-06-23 | Dauphin | Pennsylvania | 42043 | 1851 | 122 |
264151 | 264151 | 2020-06-22 | Dauphin | Pennsylvania | 42043 | 1810 | 120 |
261023 | 261023 | 2020-06-21 | Dauphin | Pennsylvania | 42043 | 1762 | 120 |
257896 | 257896 | 2020-06-20 | Dauphin | Pennsylvania | 42043 | 1745 | 120 |
254770 | 254770 | 2020-06-19 | Dauphin | Pennsylvania | 42043 | 1725 | 118 |
251655 | 251655 | 2020-06-18 | Dauphin | Pennsylvania | 42043 | 1708 | 116 |
248540 | 248540 | 2020-06-17 | Dauphin | Pennsylvania | 42043 | 1693 | 111 |
245427 | 245427 | 2020-06-16 | Dauphin | Pennsylvania | 42043 | 1674 | 108 |
242315 | 242315 | 2020-06-15 | Dauphin | Pennsylvania | 42043 | 1655 | 107 |
239206 | 239206 | 2020-06-14 | Dauphin | Pennsylvania | 42043 | 1634 | 107 |
236098 | 236098 | 2020-06-13 | Dauphin | Pennsylvania | 42043 | 1606 | 107 |
232993 | 232993 | 2020-06-12 | Dauphin | Pennsylvania | 42043 | 1587 | 107 |
229888 | 229888 | 2020-06-11 | Dauphin | Pennsylvania | 42043 | 1561 | 104 |
226784 | 226784 | 2020-06-10 | Dauphin | Pennsylvania | 42043 | 1541 | 101 |
223684 | 223684 | 2020-06-09 | Dauphin | Pennsylvania | 42043 | 1525 | 96 |
220589 | 220589 | 2020-06-08 | Dauphin | Pennsylvania | 42043 | 1499 | 91 |
217497 | 217497 | 2020-06-07 | Dauphin | Pennsylvania | 42043 | 1481 | 91 |
214407 | 214407 | 2020-06-06 | Dauphin | Pennsylvania | 42043 | 1451 | 90 |
211321 | 211321 | 2020-06-05 | Dauphin | Pennsylvania | 42043 | 1434 | 88 |
208239 | 208239 | 2020-06-04 | Dauphin | Pennsylvania | 42043 | 1404 | 87 |
205158 | 205158 | 2020-06-03 | Dauphin | Pennsylvania | 42043 | 1385 | 85 |
202081 | 202081 | 2020-06-02 | Dauphin | Pennsylvania | 42043 | 1359 | 77 |
199006 | 199006 | 2020-06-01 | Dauphin | Pennsylvania | 42043 | 1303 | 74 |
195933 | 195933 | 2020-05-31 | Dauphin | Pennsylvania | 42043 | 1277 | 73 |
192864 | 192864 | 2020-05-30 | Dauphin | Pennsylvania | 42043 | 1258 | 73 |
189799 | 189799 | 2020-05-29 | Dauphin | Pennsylvania | 42043 | 1231 | 72 |
186738 | 186738 | 2020-05-28 | Dauphin | Pennsylvania | 42043 | 1212 | 71 |
183681 | 183681 | 2020-05-27 | Dauphin | Pennsylvania | 42043 | 1174 | 66 |
180631 | 180631 | 2020-05-26 | Dauphin | Pennsylvania | 42043 | 1137 | 63 |
177588 | 177588 | 2020-05-25 | Dauphin | Pennsylvania | 42043 | 1123 | 63 |
174544 | 174544 | 2020-05-24 | Dauphin | Pennsylvania | 42043 | 1099 | 63 |
171502 | 171502 | 2020-05-23 | Dauphin | Pennsylvania | 42043 | 1061 | 62 |
168463 | 168463 | 2020-05-22 | Dauphin | Pennsylvania | 42043 | 1049 | 57 |
165427 | 165427 | 2020-05-21 | Dauphin | Pennsylvania | 42043 | 1034 | 52 |
162398 | 162398 | 2020-05-20 | Dauphin | Pennsylvania | 42043 | 1012 | 51 |
159371 | 159371 | 2020-05-19 | Dauphin | Pennsylvania | 42043 | 989 | 50 |
156350 | 156350 | 2020-05-18 | Dauphin | Pennsylvania | 42043 | 978 | 50 |
153333 | 153333 | 2020-05-17 | Dauphin | Pennsylvania | 42043 | 963 | 39 |
150322 | 150322 | 2020-05-16 | Dauphin | Pennsylvania | 42043 | 938 | 39 |
147315 | 147315 | 2020-05-15 | Dauphin | Pennsylvania | 42043 | 912 | 41 |
144314 | 144314 | 2020-05-14 | Dauphin | Pennsylvania | 42043 | 895 | 40 |
141318 | 141318 | 2020-05-13 | Dauphin | Pennsylvania | 42043 | 871 | 39 |
138322 | 138322 | 2020-05-12 | Dauphin | Pennsylvania | 42043 | 851 | 38 |
135332 | 135332 | 2020-05-11 | Dauphin | Pennsylvania | 42043 | 830 | 36 |
132341 | 132341 | 2020-05-10 | Dauphin | Pennsylvania | 42043 | 823 | 36 |
129352 | 129352 | 2020-05-09 | Dauphin | Pennsylvania | 42043 | 797 | 36 |
126363 | 126363 | 2020-05-08 | Dauphin | Pennsylvania | 42043 | 764 | 37 |
123380 | 123380 | 2020-05-07 | Dauphin | Pennsylvania | 42043 | 735 | 33 |
120403 | 120403 | 2020-05-06 | Dauphin | Pennsylvania | 42043 | 711 | 29 |
117441 | 117441 | 2020-05-05 | Dauphin | Pennsylvania | 42043 | 695 | 29 |
114560 | 114560 | 2020-05-04 | Dauphin | Pennsylvania | 42043 | 652 | 28 |
111678 | 111678 | 2020-05-03 | Dauphin | Pennsylvania | 42043 | 634 | 28 |
108804 | 108804 | 2020-05-02 | Dauphin | Pennsylvania | 42043 | 617 | 25 |
105937 | 105937 | 2020-05-01 | Dauphin | Pennsylvania | 42043 | 601 | 25 |
103074 | 103074 | 2020-04-30 | Dauphin | Pennsylvania | 42043 | 584 | 25 |
100221 | 100221 | 2020-04-29 | Dauphin | Pennsylvania | 42043 | 558 | 21 |
97372 | 97372 | 2020-04-28 | Dauphin | Pennsylvania | 42043 | 553 | 20 |
94533 | 94533 | 2020-04-27 | Dauphin | Pennsylvania | 42043 | 529 | 21 |
91706 | 91706 | 2020-04-26 | Dauphin | Pennsylvania | 42043 | 519 | 18 |
88890 | 88890 | 2020-04-25 | Dauphin | Pennsylvania | 42043 | 492 | 18 |
86076 | 86076 | 2020-04-24 | Dauphin | Pennsylvania | 42043 | 468 | 19 |
83272 | 83272 | 2020-04-23 | Dauphin | Pennsylvania | 42043 | 445 | 16 |
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);