ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 42013 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501853 | 2501853 | 2022-05-13 | Blair | Pennsylvania | 42013 | 29924 | 616 |
2498595 | 2498595 | 2022-05-12 | Blair | Pennsylvania | 42013 | 29924 | 616 |
2495337 | 2495337 | 2022-05-11 | Blair | Pennsylvania | 42013 | 29924 | 616 |
2492079 | 2492079 | 2022-05-10 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2488821 | 2488821 | 2022-05-09 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2485564 | 2485564 | 2022-05-08 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2482306 | 2482306 | 2022-05-07 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2479048 | 2479048 | 2022-05-06 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2475790 | 2475790 | 2022-05-05 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2472533 | 2472533 | 2022-05-04 | Blair | Pennsylvania | 42013 | 29807 | 616 |
2469277 | 2469277 | 2022-05-03 | Blair | Pennsylvania | 42013 | 29795 | 616 |
2466021 | 2466021 | 2022-05-02 | Blair | Pennsylvania | 42013 | 29793 | 615 |
2462766 | 2462766 | 2022-05-01 | Blair | Pennsylvania | 42013 | 29790 | 615 |
2459510 | 2459510 | 2022-04-30 | Blair | Pennsylvania | 42013 | 29786 | 615 |
2456254 | 2456254 | 2022-04-29 | Blair | Pennsylvania | 42013 | 29767 | 615 |
2452998 | 2452998 | 2022-04-28 | Blair | Pennsylvania | 42013 | 29761 | 614 |
2449742 | 2449742 | 2022-04-27 | Blair | Pennsylvania | 42013 | 29755 | 614 |
2446485 | 2446485 | 2022-04-26 | Blair | Pennsylvania | 42013 | 29747 | 614 |
2443230 | 2443230 | 2022-04-25 | Blair | Pennsylvania | 42013 | 29743 | 614 |
2439974 | 2439974 | 2022-04-24 | Blair | Pennsylvania | 42013 | 29739 | 614 |
2436718 | 2436718 | 2022-04-23 | Blair | Pennsylvania | 42013 | 29735 | 614 |
2433462 | 2433462 | 2022-04-22 | Blair | Pennsylvania | 42013 | 29729 | 614 |
2430206 | 2430206 | 2022-04-21 | Blair | Pennsylvania | 42013 | 29727 | 614 |
2426950 | 2426950 | 2022-04-20 | Blair | Pennsylvania | 42013 | 29720 | 613 |
2423694 | 2423694 | 2022-04-19 | Blair | Pennsylvania | 42013 | 29712 | 613 |
2420438 | 2420438 | 2022-04-18 | Blair | Pennsylvania | 42013 | 29710 | 612 |
2417182 | 2417182 | 2022-04-17 | Blair | Pennsylvania | 42013 | 29707 | 612 |
2413926 | 2413926 | 2022-04-16 | Blair | Pennsylvania | 42013 | 29703 | 612 |
2410670 | 2410670 | 2022-04-15 | Blair | Pennsylvania | 42013 | 29689 | 611 |
2407414 | 2407414 | 2022-04-14 | Blair | Pennsylvania | 42013 | 29684 | 611 |
2404158 | 2404158 | 2022-04-13 | Blair | Pennsylvania | 42013 | 29671 | 611 |
2400903 | 2400903 | 2022-04-12 | Blair | Pennsylvania | 42013 | 29665 | 611 |
2397648 | 2397648 | 2022-04-11 | Blair | Pennsylvania | 42013 | 29663 | 610 |
2394393 | 2394393 | 2022-04-10 | Blair | Pennsylvania | 42013 | 29660 | 610 |
2391137 | 2391137 | 2022-04-09 | Blair | Pennsylvania | 42013 | 29654 | 610 |
2387881 | 2387881 | 2022-04-08 | Blair | Pennsylvania | 42013 | 29646 | 610 |
2384626 | 2384626 | 2022-04-07 | Blair | Pennsylvania | 42013 | 29638 | 610 |
2381371 | 2381371 | 2022-04-06 | Blair | Pennsylvania | 42013 | 29630 | 610 |
2378116 | 2378116 | 2022-04-05 | Blair | Pennsylvania | 42013 | 29620 | 609 |
2374862 | 2374862 | 2022-04-04 | Blair | Pennsylvania | 42013 | 29617 | 607 |
2371610 | 2371610 | 2022-04-03 | Blair | Pennsylvania | 42013 | 29613 | 607 |
2368357 | 2368357 | 2022-04-02 | Blair | Pennsylvania | 42013 | 29613 | 607 |
2365104 | 2365104 | 2022-04-01 | Blair | Pennsylvania | 42013 | 29607 | 607 |
2361851 | 2361851 | 2022-03-31 | Blair | Pennsylvania | 42013 | 29603 | 607 |
2358597 | 2358597 | 2022-03-30 | Blair | Pennsylvania | 42013 | 29597 | 606 |
2355343 | 2355343 | 2022-03-29 | Blair | Pennsylvania | 42013 | 29595 | 606 |
2352090 | 2352090 | 2022-03-28 | Blair | Pennsylvania | 42013 | 29590 | 606 |
2348838 | 2348838 | 2022-03-27 | Blair | Pennsylvania | 42013 | 29589 | 606 |
2345585 | 2345585 | 2022-03-26 | Blair | Pennsylvania | 42013 | 29587 | 606 |
2342332 | 2342332 | 2022-03-25 | Blair | Pennsylvania | 42013 | 29586 | 606 |
2339079 | 2339079 | 2022-03-24 | Blair | Pennsylvania | 42013 | 29579 | 606 |
2335825 | 2335825 | 2022-03-23 | Blair | Pennsylvania | 42013 | 29574 | 606 |
2332571 | 2332571 | 2022-03-22 | Blair | Pennsylvania | 42013 | 29573 | 605 |
2329318 | 2329318 | 2022-03-21 | Blair | Pennsylvania | 42013 | 29573 | 604 |
2326066 | 2326066 | 2022-03-20 | Blair | Pennsylvania | 42013 | 29567 | 604 |
2322813 | 2322813 | 2022-03-19 | Blair | Pennsylvania | 42013 | 29564 | 604 |
2319559 | 2319559 | 2022-03-18 | Blair | Pennsylvania | 42013 | 29558 | 604 |
2316305 | 2316305 | 2022-03-17 | Blair | Pennsylvania | 42013 | 29549 | 604 |
2313052 | 2313052 | 2022-03-16 | Blair | Pennsylvania | 42013 | 29547 | 604 |
2309799 | 2309799 | 2022-03-15 | Blair | Pennsylvania | 42013 | 29538 | 602 |
2306546 | 2306546 | 2022-03-14 | Blair | Pennsylvania | 42013 | 29531 | 601 |
2303295 | 2303295 | 2022-03-13 | Blair | Pennsylvania | 42013 | 29528 | 601 |
2300043 | 2300043 | 2022-03-12 | Blair | Pennsylvania | 42013 | 29525 | 601 |
2296791 | 2296791 | 2022-03-11 | Blair | Pennsylvania | 42013 | 29513 | 601 |
2293539 | 2293539 | 2022-03-10 | Blair | Pennsylvania | 42013 | 29499 | 600 |
2290287 | 2290287 | 2022-03-09 | Blair | Pennsylvania | 42013 | 29485 | 600 |
2287035 | 2287035 | 2022-03-08 | Blair | Pennsylvania | 42013 | 29474 | 599 |
2283783 | 2283783 | 2022-03-07 | Blair | Pennsylvania | 42013 | 29467 | 598 |
2280531 | 2280531 | 2022-03-06 | Blair | Pennsylvania | 42013 | 29464 | 598 |
2277278 | 2277278 | 2022-03-05 | Blair | Pennsylvania | 42013 | 29456 | 597 |
2274025 | 2274025 | 2022-03-04 | Blair | Pennsylvania | 42013 | 29443 | 597 |
2270772 | 2270772 | 2022-03-03 | Blair | Pennsylvania | 42013 | 29429 | 597 |
2267520 | 2267520 | 2022-03-02 | Blair | Pennsylvania | 42013 | 29409 | 596 |
2264267 | 2264267 | 2022-03-01 | Blair | Pennsylvania | 42013 | 29390 | 594 |
2261017 | 2261017 | 2022-02-28 | Blair | Pennsylvania | 42013 | 29362 | 594 |
2257766 | 2257766 | 2022-02-27 | Blair | Pennsylvania | 42013 | 29358 | 594 |
2254515 | 2254515 | 2022-02-26 | Blair | Pennsylvania | 42013 | 29347 | 594 |
2251264 | 2251264 | 2022-02-25 | Blair | Pennsylvania | 42013 | 29314 | 594 |
2248013 | 2248013 | 2022-02-24 | Blair | Pennsylvania | 42013 | 29296 | 594 |
2244762 | 2244762 | 2022-02-23 | Blair | Pennsylvania | 42013 | 29261 | 592 |
2241511 | 2241511 | 2022-02-22 | Blair | Pennsylvania | 42013 | 29234 | 591 |
2238260 | 2238260 | 2022-02-21 | Blair | Pennsylvania | 42013 | 29188 | 591 |
2235009 | 2235009 | 2022-02-20 | Blair | Pennsylvania | 42013 | 29188 | 591 |
2231758 | 2231758 | 2022-02-19 | Blair | Pennsylvania | 42013 | 29177 | 589 |
2228507 | 2228507 | 2022-02-18 | Blair | Pennsylvania | 42013 | 29142 | 589 |
2225256 | 2225256 | 2022-02-17 | Blair | Pennsylvania | 42013 | 29107 | 589 |
2222005 | 2222005 | 2022-02-16 | Blair | Pennsylvania | 42013 | 29050 | 589 |
2218754 | 2218754 | 2022-02-15 | Blair | Pennsylvania | 42013 | 29021 | 588 |
2215503 | 2215503 | 2022-02-14 | Blair | Pennsylvania | 42013 | 28973 | 584 |
2212252 | 2212252 | 2022-02-13 | Blair | Pennsylvania | 42013 | 28930 | 584 |
2208999 | 2208999 | 2022-02-12 | Blair | Pennsylvania | 42013 | 28901 | 584 |
2205746 | 2205746 | 2022-02-11 | Blair | Pennsylvania | 42013 | 28766 | 584 |
2202493 | 2202493 | 2022-02-10 | Blair | Pennsylvania | 42013 | 28667 | 583 |
2199239 | 2199239 | 2022-02-09 | Blair | Pennsylvania | 42013 | 28571 | 581 |
2195985 | 2195985 | 2022-02-08 | Blair | Pennsylvania | 42013 | 28496 | 580 |
2192731 | 2192731 | 2022-02-07 | Blair | Pennsylvania | 42013 | 28497 | 575 |
2189477 | 2189477 | 2022-02-06 | Blair | Pennsylvania | 42013 | 28415 | 575 |
2186224 | 2186224 | 2022-02-05 | Blair | Pennsylvania | 42013 | 28360 | 575 |
2182972 | 2182972 | 2022-02-04 | Blair | Pennsylvania | 42013 | 28194 | 573 |
2179720 | 2179720 | 2022-02-03 | Blair | Pennsylvania | 42013 | 28085 | 572 |
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);