ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 287 ✖
- 6 44
- 0 32
- 2 19
- 651 18
- 652 18
- 30 16
- 28 15
- 312 15
- 5 14
- 313 13
- 4 12
- 10 11
- 304 10
- 271 9
- 11 8
- 29 8
- 34 8
- 298 8
- 300 8
- 307 7
- 310 7
- 302 6
- 303 6
- 314 6
- 27 5
- 32 5
- 37 5
- 257 5
- 276 5
- 284 5
- 288 5
- 293 5
- 305 5
- 309 5
- 321 5
- 325 5
- 500 5
- 616 5
- 638 5
- 649 5
- 1 4
- 22 4
- 31 4
- 41 4
- 70 4
- 246 4
- 258 4
- 268 4
- 274 4
- 294 4
- 315 4
- 343 4
- 368 4
- 403 4
- 406 4
- 420 4
- 513 4
- 535 4
- 582 4
- 637 4
- 639 4
- 644 4
- 647 4
- 12 3
- 13 3
- 17 3
- 44 3
- 50 3
- 273 3
- 275 3
- 279 3
- 317 3
- 336 3
- 378 3
- 386 3
- 398 3
- 425 3
- 484 3
- 542 3
- 548 3
- 606 3
- 645 3
- 654 3
- 7 2
- 21 2
- 24 2
- 35 2
- 63 2
- 71 2
- 73 2
- 75 2
- 110 2
- 120 2
- 121 2
- 122 2
- 138 2
- 156 2
- 168 2
- 199 2
- 240 2
- 242 2
- 265 2
- 266 2
- 277 2
- 290 2
- 295 2
- 296 2
- 297 2
- 306 2
- 319 2
- 331 2
- 335 2
- 352 2
- 382 2
- 407 2
- 466 2
- 565 2
- 596 2
- 599 2
- 632 2
- 643 2
- 9 1
- 14 1
- 16 1
- 20 1
- 25 1
- 26 1
- 40 1
- 42 1
- 49 1
- 53 1
- 56 1
- 58 1
- 62 1
- 67 1
- 69 1
- 76 1
- 77 1
- 80 1
- 81 1
- 85 1
- 88 1
- 92 1
- 93 1
- 95 1
- 100 1
- 103 1
- 106 1
- 108 1
- 112 1
- 116 1
- 119 1
- 128 1
- 131 1
- 135 1
- 136 1
- 137 1
- 144 1
- 148 1
- 152 1
- 157 1
- 164 1
- 165 1
- 166 1
- 170 1
- 171 1
- 172 1
- 178 1
- 181 1
- 190 1
- 197 1
- 204 1
- 207 1
- 216 1
- 222 1
- 223 1
- 225 1
- 226 1
- 228 1
- 234 1
- 235 1
- 237 1
- 238 1
- 244 1
- 245 1
- 248 1
- 249 1
- 250 1
- 254 1
- 256 1
- 260 1
- 261 1
- 262 1
- 264 1
- 280 1
- 282 1
- 283 1
- 285 1
- 286 1
- 291 1
- 292 1
- 311 1
- 320 1
- 324 1
- 334 1
- 338 1
- 339 1
- 341 1
- 346 1
- 349 1
- 350 1
- 351 1
- 356 1
- 358 1
- 362 1
- 372 1
- 375 1
- 377 1
- 379 1
- 380 1
- 384 1
- 387 1
- 389 1
- 390 1
- 394 1
- 396 1
- 400 1
- 401 1
- 402 1
- 408 1
- 414 1
- 415 1
- 419 1
- 421 1
- 426 1
- 428 1
- 432 1
- 435 1
- 437 1
- 441 1
- 444 1
- 445 1
- 448 1
- 454 1
- 460 1
- 461 1
- 463 1
- 465 1
- 469 1
- 474 1
- 476 1
- 477 1
- 493 1
- 497 1
- 503 1
- 512 1
- 514 1
- 519 1
- 521 1
- 530 1
- 540 1
- 549 1
- 553 1
- 557 1
- 562 1
- 564 1
- 569 1
- 572 1
- 579 1
- 586 1
- 587 1
- 588 1
- 591 1
- 597 1
- 604 1
- 605 1
- 609 1
- 610 1
- 613 1
- 624 1
- 626 1
- 629 1
- 631 1
- 636 1
- 640 1
- 646 1
- 648 1
state 1
- Pennsylvania 792
fips 1
- 42125 · 792 ✖
county 1
- Washington 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501909 | 2501909 | 2022-05-13 | Washington | Pennsylvania | 42125 | 51747 | 654 |
2498651 | 2498651 | 2022-05-12 | Washington | Pennsylvania | 42125 | 51747 | 654 |
2495393 | 2495393 | 2022-05-11 | Washington | Pennsylvania | 42125 | 51747 | 654 |
2492135 | 2492135 | 2022-05-10 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2488877 | 2488877 | 2022-05-09 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2485620 | 2485620 | 2022-05-08 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2482362 | 2482362 | 2022-05-07 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2479104 | 2479104 | 2022-05-06 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2475846 | 2475846 | 2022-05-05 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2472589 | 2472589 | 2022-05-04 | Washington | Pennsylvania | 42125 | 51409 | 652 |
2469333 | 2469333 | 2022-05-03 | Washington | Pennsylvania | 42125 | 51369 | 652 |
2466077 | 2466077 | 2022-05-02 | Washington | Pennsylvania | 42125 | 51342 | 652 |
2462822 | 2462822 | 2022-05-01 | Washington | Pennsylvania | 42125 | 51333 | 652 |
2459566 | 2459566 | 2022-04-30 | Washington | Pennsylvania | 42125 | 51295 | 652 |
2456310 | 2456310 | 2022-04-29 | Washington | Pennsylvania | 42125 | 51270 | 652 |
2453054 | 2453054 | 2022-04-28 | Washington | Pennsylvania | 42125 | 51229 | 652 |
2449798 | 2449798 | 2022-04-27 | Washington | Pennsylvania | 42125 | 51185 | 652 |
2446541 | 2446541 | 2022-04-26 | Washington | Pennsylvania | 42125 | 51141 | 652 |
2443286 | 2443286 | 2022-04-25 | Washington | Pennsylvania | 42125 | 51105 | 652 |
2440030 | 2440030 | 2022-04-24 | Washington | Pennsylvania | 42125 | 51087 | 652 |
2436774 | 2436774 | 2022-04-23 | Washington | Pennsylvania | 42125 | 51069 | 652 |
2433518 | 2433518 | 2022-04-22 | Washington | Pennsylvania | 42125 | 51039 | 651 |
2430262 | 2430262 | 2022-04-21 | Washington | Pennsylvania | 42125 | 51023 | 651 |
2427006 | 2427006 | 2022-04-20 | Washington | Pennsylvania | 42125 | 50997 | 651 |
2423750 | 2423750 | 2022-04-19 | Washington | Pennsylvania | 42125 | 50972 | 651 |
2420494 | 2420494 | 2022-04-18 | Washington | Pennsylvania | 42125 | 50955 | 651 |
2417238 | 2417238 | 2022-04-17 | Washington | Pennsylvania | 42125 | 50946 | 651 |
2413982 | 2413982 | 2022-04-16 | Washington | Pennsylvania | 42125 | 50942 | 651 |
2410726 | 2410726 | 2022-04-15 | Washington | Pennsylvania | 42125 | 50914 | 651 |
2407470 | 2407470 | 2022-04-14 | Washington | Pennsylvania | 42125 | 50903 | 651 |
2404214 | 2404214 | 2022-04-13 | Washington | Pennsylvania | 42125 | 50886 | 651 |
2400959 | 2400959 | 2022-04-12 | Washington | Pennsylvania | 42125 | 50872 | 651 |
2397704 | 2397704 | 2022-04-11 | Washington | Pennsylvania | 42125 | 50846 | 651 |
2394449 | 2394449 | 2022-04-10 | Washington | Pennsylvania | 42125 | 50834 | 651 |
2391193 | 2391193 | 2022-04-09 | Washington | Pennsylvania | 42125 | 50828 | 651 |
2387937 | 2387937 | 2022-04-08 | Washington | Pennsylvania | 42125 | 50821 | 651 |
2384682 | 2384682 | 2022-04-07 | Washington | Pennsylvania | 42125 | 50806 | 651 |
2381427 | 2381427 | 2022-04-06 | Washington | Pennsylvania | 42125 | 50796 | 651 |
2378172 | 2378172 | 2022-04-05 | Washington | Pennsylvania | 42125 | 50784 | 651 |
2374918 | 2374918 | 2022-04-04 | Washington | Pennsylvania | 42125 | 50769 | 649 |
2371666 | 2371666 | 2022-04-03 | Washington | Pennsylvania | 42125 | 50762 | 649 |
2368413 | 2368413 | 2022-04-02 | Washington | Pennsylvania | 42125 | 50762 | 649 |
2365160 | 2365160 | 2022-04-01 | Washington | Pennsylvania | 42125 | 50752 | 649 |
2361907 | 2361907 | 2022-03-31 | Washington | Pennsylvania | 42125 | 50735 | 649 |
2358653 | 2358653 | 2022-03-30 | Washington | Pennsylvania | 42125 | 50733 | 648 |
2355399 | 2355399 | 2022-03-29 | Washington | Pennsylvania | 42125 | 50727 | 647 |
2352146 | 2352146 | 2022-03-28 | Washington | Pennsylvania | 42125 | 50710 | 647 |
2348894 | 2348894 | 2022-03-27 | Washington | Pennsylvania | 42125 | 50708 | 647 |
2345641 | 2345641 | 2022-03-26 | Washington | Pennsylvania | 42125 | 50704 | 647 |
2342388 | 2342388 | 2022-03-25 | Washington | Pennsylvania | 42125 | 50699 | 646 |
2339135 | 2339135 | 2022-03-24 | Washington | Pennsylvania | 42125 | 50685 | 645 |
2335881 | 2335881 | 2022-03-23 | Washington | Pennsylvania | 42125 | 50669 | 645 |
2332627 | 2332627 | 2022-03-22 | Washington | Pennsylvania | 42125 | 50653 | 645 |
2329374 | 2329374 | 2022-03-21 | Washington | Pennsylvania | 42125 | 50642 | 644 |
2326122 | 2326122 | 2022-03-20 | Washington | Pennsylvania | 42125 | 50633 | 644 |
2322869 | 2322869 | 2022-03-19 | Washington | Pennsylvania | 42125 | 50630 | 644 |
2319615 | 2319615 | 2022-03-18 | Washington | Pennsylvania | 42125 | 50624 | 644 |
2316361 | 2316361 | 2022-03-17 | Washington | Pennsylvania | 42125 | 50605 | 643 |
2313108 | 2313108 | 2022-03-16 | Washington | Pennsylvania | 42125 | 50593 | 643 |
2309855 | 2309855 | 2022-03-15 | Washington | Pennsylvania | 42125 | 50587 | 640 |
2306602 | 2306602 | 2022-03-14 | Washington | Pennsylvania | 42125 | 50563 | 639 |
2303351 | 2303351 | 2022-03-13 | Washington | Pennsylvania | 42125 | 50560 | 639 |
2300099 | 2300099 | 2022-03-12 | Washington | Pennsylvania | 42125 | 50546 | 639 |
2296847 | 2296847 | 2022-03-11 | Washington | Pennsylvania | 42125 | 50525 | 639 |
2293595 | 2293595 | 2022-03-10 | Washington | Pennsylvania | 42125 | 50507 | 638 |
2290343 | 2290343 | 2022-03-09 | Washington | Pennsylvania | 42125 | 50487 | 638 |
2287091 | 2287091 | 2022-03-08 | Washington | Pennsylvania | 42125 | 50469 | 638 |
2283839 | 2283839 | 2022-03-07 | Washington | Pennsylvania | 42125 | 50448 | 638 |
2280587 | 2280587 | 2022-03-06 | Washington | Pennsylvania | 42125 | 50436 | 638 |
2277334 | 2277334 | 2022-03-05 | Washington | Pennsylvania | 42125 | 50429 | 637 |
2274081 | 2274081 | 2022-03-04 | Washington | Pennsylvania | 42125 | 50406 | 637 |
2270828 | 2270828 | 2022-03-03 | Washington | Pennsylvania | 42125 | 50385 | 637 |
2267576 | 2267576 | 2022-03-02 | Washington | Pennsylvania | 42125 | 50363 | 637 |
2264323 | 2264323 | 2022-03-01 | Washington | Pennsylvania | 42125 | 50333 | 636 |
2261073 | 2261073 | 2022-02-28 | Washington | Pennsylvania | 42125 | 50309 | 632 |
2257822 | 2257822 | 2022-02-27 | Washington | Pennsylvania | 42125 | 50295 | 632 |
2254571 | 2254571 | 2022-02-26 | Washington | Pennsylvania | 42125 | 50289 | 631 |
2251320 | 2251320 | 2022-02-25 | Washington | Pennsylvania | 42125 | 50253 | 629 |
2248069 | 2248069 | 2022-02-24 | Washington | Pennsylvania | 42125 | 50227 | 626 |
2244818 | 2244818 | 2022-02-23 | Washington | Pennsylvania | 42125 | 50193 | 624 |
2241567 | 2241567 | 2022-02-22 | Washington | Pennsylvania | 42125 | 50143 | 616 |
2238316 | 2238316 | 2022-02-21 | Washington | Pennsylvania | 42125 | 50057 | 616 |
2235065 | 2235065 | 2022-02-20 | Washington | Pennsylvania | 42125 | 50057 | 616 |
2231814 | 2231814 | 2022-02-19 | Washington | Pennsylvania | 42125 | 50025 | 616 |
2228563 | 2228563 | 2022-02-18 | Washington | Pennsylvania | 42125 | 49914 | 616 |
2225312 | 2225312 | 2022-02-17 | Washington | Pennsylvania | 42125 | 49867 | 613 |
2222061 | 2222061 | 2022-02-16 | Washington | Pennsylvania | 42125 | 49790 | 610 |
2218810 | 2218810 | 2022-02-15 | Washington | Pennsylvania | 42125 | 49742 | 609 |
2215559 | 2215559 | 2022-02-14 | Washington | Pennsylvania | 42125 | 49676 | 606 |
2212308 | 2212308 | 2022-02-13 | Washington | Pennsylvania | 42125 | 49616 | 606 |
2209055 | 2209055 | 2022-02-12 | Washington | Pennsylvania | 42125 | 49567 | 606 |
2205802 | 2205802 | 2022-02-11 | Washington | Pennsylvania | 42125 | 49495 | 605 |
2202549 | 2202549 | 2022-02-10 | Washington | Pennsylvania | 42125 | 49426 | 604 |
2199295 | 2199295 | 2022-02-09 | Washington | Pennsylvania | 42125 | 49325 | 599 |
2196041 | 2196041 | 2022-02-08 | Washington | Pennsylvania | 42125 | 49256 | 599 |
2192787 | 2192787 | 2022-02-07 | Washington | Pennsylvania | 42125 | 49251 | 597 |
2189533 | 2189533 | 2022-02-06 | Washington | Pennsylvania | 42125 | 49136 | 596 |
2186280 | 2186280 | 2022-02-05 | Washington | Pennsylvania | 42125 | 49091 | 596 |
2183028 | 2183028 | 2022-02-04 | Washington | Pennsylvania | 42125 | 48954 | 591 |
2179776 | 2179776 | 2022-02-03 | Washington | Pennsylvania | 42125 | 48761 | 588 |
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);