ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42029 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388191 | 388191 | 2020-07-31 | Chester | Pennsylvania | 42029 | 4885 | 349 |
384974 | 384974 | 2020-07-30 | Chester | Pennsylvania | 42029 | 4836 | 346 |
381756 | 381756 | 2020-07-29 | Chester | Pennsylvania | 42029 | 4796 | 346 |
378539 | 378539 | 2020-07-28 | Chester | Pennsylvania | 42029 | 4780 | 343 |
375323 | 375323 | 2020-07-27 | Chester | Pennsylvania | 42029 | 4709 | 343 |
372110 | 372110 | 2020-07-26 | Chester | Pennsylvania | 42029 | 4608 | 343 |
368898 | 368898 | 2020-07-25 | Chester | Pennsylvania | 42029 | 4586 | 343 |
365689 | 365689 | 2020-07-24 | Chester | Pennsylvania | 42029 | 4580 | 343 |
362483 | 362483 | 2020-07-23 | Chester | Pennsylvania | 42029 | 4517 | 342 |
359277 | 359277 | 2020-07-22 | Chester | Pennsylvania | 42029 | 4459 | 342 |
356073 | 356073 | 2020-07-21 | Chester | Pennsylvania | 42029 | 4422 | 341 |
352870 | 352870 | 2020-07-20 | Chester | Pennsylvania | 42029 | 4372 | 341 |
349667 | 349667 | 2020-07-19 | Chester | Pennsylvania | 42029 | 4295 | 339 |
346467 | 346467 | 2020-07-18 | Chester | Pennsylvania | 42029 | 4245 | 339 |
343267 | 343267 | 2020-07-17 | Chester | Pennsylvania | 42029 | 4243 | 339 |
340069 | 340069 | 2020-07-16 | Chester | Pennsylvania | 42029 | 4175 | 337 |
336872 | 336872 | 2020-07-15 | Chester | Pennsylvania | 42029 | 4153 | 337 |
333678 | 333678 | 2020-07-14 | Chester | Pennsylvania | 42029 | 4103 | 335 |
330486 | 330486 | 2020-07-13 | Chester | Pennsylvania | 42029 | 4064 | 335 |
327300 | 327300 | 2020-07-12 | Chester | Pennsylvania | 42029 | 4012 | 335 |
324115 | 324115 | 2020-07-11 | Chester | Pennsylvania | 42029 | 3998 | 335 |
320935 | 320935 | 2020-07-10 | Chester | Pennsylvania | 42029 | 3998 | 335 |
317757 | 317757 | 2020-07-09 | Chester | Pennsylvania | 42029 | 3961 | 333 |
314584 | 314584 | 2020-07-08 | Chester | Pennsylvania | 42029 | 3936 | 333 |
311412 | 311412 | 2020-07-07 | Chester | Pennsylvania | 42029 | 3906 | 330 |
308243 | 308243 | 2020-07-06 | Chester | Pennsylvania | 42029 | 3882 | 329 |
305076 | 305076 | 2020-07-05 | Chester | Pennsylvania | 42029 | 3831 | 329 |
301913 | 301913 | 2020-07-04 | Chester | Pennsylvania | 42029 | 3800 | 329 |
298749 | 298749 | 2020-07-03 | Chester | Pennsylvania | 42029 | 3796 | 329 |
295590 | 295590 | 2020-07-02 | Chester | Pennsylvania | 42029 | 3796 | 328 |
292434 | 292434 | 2020-07-01 | Chester | Pennsylvania | 42029 | 3775 | 324 |
289282 | 289282 | 2020-06-30 | Chester | Pennsylvania | 42029 | 3751 | 324 |
286131 | 286131 | 2020-06-29 | Chester | Pennsylvania | 42029 | 3718 | 323 |
282986 | 282986 | 2020-06-28 | Chester | Pennsylvania | 42029 | 3658 | 323 |
279840 | 279840 | 2020-06-27 | Chester | Pennsylvania | 42029 | 3649 | 323 |
276692 | 276692 | 2020-06-26 | Chester | Pennsylvania | 42029 | 3649 | 323 |
273545 | 273545 | 2020-06-25 | Chester | Pennsylvania | 42029 | 3620 | 321 |
270406 | 270406 | 2020-06-24 | Chester | Pennsylvania | 42029 | 3601 | 319 |
267272 | 267272 | 2020-06-23 | Chester | Pennsylvania | 42029 | 3580 | 317 |
264144 | 264144 | 2020-06-22 | Chester | Pennsylvania | 42029 | 3557 | 316 |
261016 | 261016 | 2020-06-21 | Chester | Pennsylvania | 42029 | 3529 | 316 |
257889 | 257889 | 2020-06-20 | Chester | Pennsylvania | 42029 | 3499 | 315 |
254763 | 254763 | 2020-06-19 | Chester | Pennsylvania | 42029 | 3479 | 313 |
251648 | 251648 | 2020-06-18 | Chester | Pennsylvania | 42029 | 3438 | 312 |
248533 | 248533 | 2020-06-17 | Chester | Pennsylvania | 42029 | 3411 | 311 |
245420 | 245420 | 2020-06-16 | Chester | Pennsylvania | 42029 | 3387 | 309 |
242308 | 242308 | 2020-06-15 | Chester | Pennsylvania | 42029 | 3356 | 307 |
239199 | 239199 | 2020-06-14 | Chester | Pennsylvania | 42029 | 3337 | 307 |
236091 | 236091 | 2020-06-13 | Chester | Pennsylvania | 42029 | 3287 | 307 |
232986 | 232986 | 2020-06-12 | Chester | Pennsylvania | 42029 | 3287 | 306 |
229881 | 229881 | 2020-06-11 | Chester | Pennsylvania | 42029 | 3227 | 304 |
226777 | 226777 | 2020-06-10 | Chester | Pennsylvania | 42029 | 3198 | 304 |
223677 | 223677 | 2020-06-09 | Chester | Pennsylvania | 42029 | 3172 | 303 |
220582 | 220582 | 2020-06-08 | Chester | Pennsylvania | 42029 | 3139 | 298 |
217490 | 217490 | 2020-06-07 | Chester | Pennsylvania | 42029 | 3091 | 297 |
214400 | 214400 | 2020-06-06 | Chester | Pennsylvania | 42029 | 3014 | 297 |
211314 | 211314 | 2020-06-05 | Chester | Pennsylvania | 42029 | 2999 | 296 |
208232 | 208232 | 2020-06-04 | Chester | Pennsylvania | 42029 | 2943 | 294 |
205151 | 205151 | 2020-06-03 | Chester | Pennsylvania | 42029 | 2902 | 287 |
202074 | 202074 | 2020-06-02 | Chester | Pennsylvania | 42029 | 2864 | 284 |
198999 | 198999 | 2020-06-01 | Chester | Pennsylvania | 42029 | 2824 | 281 |
195926 | 195926 | 2020-05-31 | Chester | Pennsylvania | 42029 | 2769 | 281 |
192857 | 192857 | 2020-05-30 | Chester | Pennsylvania | 42029 | 2708 | 280 |
189792 | 189792 | 2020-05-29 | Chester | Pennsylvania | 42029 | 2647 | 277 |
186731 | 186731 | 2020-05-28 | Chester | Pennsylvania | 42029 | 2595 | 270 |
183674 | 183674 | 2020-05-27 | Chester | Pennsylvania | 42029 | 2545 | 260 |
180624 | 180624 | 2020-05-26 | Chester | Pennsylvania | 42029 | 2497 | 252 |
177581 | 177581 | 2020-05-25 | Chester | Pennsylvania | 42029 | 2428 | 251 |
174537 | 174537 | 2020-05-24 | Chester | Pennsylvania | 42029 | 2428 | 248 |
171495 | 171495 | 2020-05-23 | Chester | Pennsylvania | 42029 | 2403 | 245 |
168456 | 168456 | 2020-05-22 | Chester | Pennsylvania | 42029 | 2363 | 242 |
165420 | 165420 | 2020-05-21 | Chester | Pennsylvania | 42029 | 2267 | 238 |
162391 | 162391 | 2020-05-20 | Chester | Pennsylvania | 42029 | 2242 | 235 |
159364 | 159364 | 2020-05-19 | Chester | Pennsylvania | 42029 | 2242 | 230 |
156343 | 156343 | 2020-05-18 | Chester | Pennsylvania | 42029 | 2163 | 227 |
153326 | 153326 | 2020-05-17 | Chester | Pennsylvania | 42029 | 2163 | 220 |
150315 | 150315 | 2020-05-16 | Chester | Pennsylvania | 42029 | 2143 | 222 |
147308 | 147308 | 2020-05-15 | Chester | Pennsylvania | 42029 | 2102 | 218 |
144307 | 144307 | 2020-05-14 | Chester | Pennsylvania | 42029 | 2008 | 213 |
141311 | 141311 | 2020-05-13 | Chester | Pennsylvania | 42029 | 1996 | 197 |
138315 | 138315 | 2020-05-12 | Chester | Pennsylvania | 42029 | 1973 | 189 |
135325 | 135325 | 2020-05-11 | Chester | Pennsylvania | 42029 | 1926 | 187 |
132334 | 132334 | 2020-05-10 | Chester | Pennsylvania | 42029 | 1906 | 184 |
129345 | 129345 | 2020-05-09 | Chester | Pennsylvania | 42029 | 1816 | 183 |
126356 | 126356 | 2020-05-08 | Chester | Pennsylvania | 42029 | 1770 | 176 |
123373 | 123373 | 2020-05-07 | Chester | Pennsylvania | 42029 | 1716 | 167 |
120396 | 120396 | 2020-05-06 | Chester | Pennsylvania | 42029 | 1677 | 156 |
117434 | 117434 | 2020-05-05 | Chester | Pennsylvania | 42029 | 1647 | 149 |
114553 | 114553 | 2020-05-04 | Chester | Pennsylvania | 42029 | 1605 | 118 |
111671 | 111671 | 2020-05-03 | Chester | Pennsylvania | 42029 | 1546 | 117 |
108797 | 108797 | 2020-05-02 | Chester | Pennsylvania | 42029 | 1514 | 117 |
105930 | 105930 | 2020-05-01 | Chester | Pennsylvania | 42029 | 1470 | 112 |
103067 | 103067 | 2020-04-30 | Chester | Pennsylvania | 42029 | 1412 | 111 |
100214 | 100214 | 2020-04-29 | Chester | Pennsylvania | 42029 | 1339 | 102 |
97365 | 97365 | 2020-04-28 | Chester | Pennsylvania | 42029 | 1289 | 85 |
94526 | 94526 | 2020-04-27 | Chester | Pennsylvania | 42029 | 1251 | 81 |
91699 | 91699 | 2020-04-26 | Chester | Pennsylvania | 42029 | 1217 | 82 |
88883 | 88883 | 2020-04-25 | Chester | Pennsylvania | 42029 | 1174 | 82 |
86069 | 86069 | 2020-04-24 | Chester | Pennsylvania | 42029 | 1102 | 77 |
83265 | 83265 | 2020-04-23 | Chester | Pennsylvania | 42029 | 1017 | 64 |
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);