ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 42097 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501895 | 2501895 | 2022-05-13 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2498637 | 2498637 | 2022-05-12 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2495379 | 2495379 | 2022-05-11 | Northumberland | Pennsylvania | 42097 | 23172 | 534 |
2492121 | 2492121 | 2022-05-10 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2488863 | 2488863 | 2022-05-09 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2485606 | 2485606 | 2022-05-08 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2482348 | 2482348 | 2022-05-07 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2479090 | 2479090 | 2022-05-06 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2475832 | 2475832 | 2022-05-05 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2472575 | 2472575 | 2022-05-04 | Northumberland | Pennsylvania | 42097 | 23013 | 534 |
2469319 | 2469319 | 2022-05-03 | Northumberland | Pennsylvania | 42097 | 22985 | 534 |
2466063 | 2466063 | 2022-05-02 | Northumberland | Pennsylvania | 42097 | 22973 | 533 |
2462808 | 2462808 | 2022-05-01 | Northumberland | Pennsylvania | 42097 | 22969 | 533 |
2459552 | 2459552 | 2022-04-30 | Northumberland | Pennsylvania | 42097 | 22964 | 533 |
2456296 | 2456296 | 2022-04-29 | Northumberland | Pennsylvania | 42097 | 22952 | 533 |
2453040 | 2453040 | 2022-04-28 | Northumberland | Pennsylvania | 42097 | 22936 | 533 |
2449784 | 2449784 | 2022-04-27 | Northumberland | Pennsylvania | 42097 | 22919 | 533 |
2446527 | 2446527 | 2022-04-26 | Northumberland | Pennsylvania | 42097 | 22906 | 533 |
2443272 | 2443272 | 2022-04-25 | Northumberland | Pennsylvania | 42097 | 22893 | 533 |
2440016 | 2440016 | 2022-04-24 | Northumberland | Pennsylvania | 42097 | 22892 | 533 |
2436760 | 2436760 | 2022-04-23 | Northumberland | Pennsylvania | 42097 | 22889 | 533 |
2433504 | 2433504 | 2022-04-22 | Northumberland | Pennsylvania | 42097 | 22881 | 533 |
2430248 | 2430248 | 2022-04-21 | Northumberland | Pennsylvania | 42097 | 22877 | 533 |
2426992 | 2426992 | 2022-04-20 | Northumberland | Pennsylvania | 42097 | 22865 | 530 |
2423736 | 2423736 | 2022-04-19 | Northumberland | Pennsylvania | 42097 | 22857 | 530 |
2420480 | 2420480 | 2022-04-18 | Northumberland | Pennsylvania | 42097 | 22851 | 530 |
2417224 | 2417224 | 2022-04-17 | Northumberland | Pennsylvania | 42097 | 22850 | 530 |
2413968 | 2413968 | 2022-04-16 | Northumberland | Pennsylvania | 42097 | 22845 | 530 |
2410712 | 2410712 | 2022-04-15 | Northumberland | Pennsylvania | 42097 | 22842 | 530 |
2407456 | 2407456 | 2022-04-14 | Northumberland | Pennsylvania | 42097 | 22837 | 530 |
2404200 | 2404200 | 2022-04-13 | Northumberland | Pennsylvania | 42097 | 22834 | 530 |
2400945 | 2400945 | 2022-04-12 | Northumberland | Pennsylvania | 42097 | 22829 | 530 |
2397690 | 2397690 | 2022-04-11 | Northumberland | Pennsylvania | 42097 | 22826 | 530 |
2394435 | 2394435 | 2022-04-10 | Northumberland | Pennsylvania | 42097 | 22826 | 530 |
2391179 | 2391179 | 2022-04-09 | Northumberland | Pennsylvania | 42097 | 22821 | 530 |
2387923 | 2387923 | 2022-04-08 | Northumberland | Pennsylvania | 42097 | 22816 | 530 |
2384668 | 2384668 | 2022-04-07 | Northumberland | Pennsylvania | 42097 | 22812 | 529 |
2381413 | 2381413 | 2022-04-06 | Northumberland | Pennsylvania | 42097 | 22808 | 529 |
2378158 | 2378158 | 2022-04-05 | Northumberland | Pennsylvania | 42097 | 22802 | 529 |
2374904 | 2374904 | 2022-04-04 | Northumberland | Pennsylvania | 42097 | 22798 | 529 |
2371652 | 2371652 | 2022-04-03 | Northumberland | Pennsylvania | 42097 | 22794 | 529 |
2368399 | 2368399 | 2022-04-02 | Northumberland | Pennsylvania | 42097 | 22794 | 529 |
2365146 | 2365146 | 2022-04-01 | Northumberland | Pennsylvania | 42097 | 22788 | 529 |
2361893 | 2361893 | 2022-03-31 | Northumberland | Pennsylvania | 42097 | 22782 | 529 |
2358639 | 2358639 | 2022-03-30 | Northumberland | Pennsylvania | 42097 | 22780 | 529 |
2355385 | 2355385 | 2022-03-29 | Northumberland | Pennsylvania | 42097 | 22779 | 529 |
2352132 | 2352132 | 2022-03-28 | Northumberland | Pennsylvania | 42097 | 22773 | 529 |
2348880 | 2348880 | 2022-03-27 | Northumberland | Pennsylvania | 42097 | 22771 | 529 |
2345627 | 2345627 | 2022-03-26 | Northumberland | Pennsylvania | 42097 | 22768 | 529 |
2342374 | 2342374 | 2022-03-25 | Northumberland | Pennsylvania | 42097 | 22766 | 529 |
2339121 | 2339121 | 2022-03-24 | Northumberland | Pennsylvania | 42097 | 22761 | 528 |
2335867 | 2335867 | 2022-03-23 | Northumberland | Pennsylvania | 42097 | 22757 | 527 |
2332613 | 2332613 | 2022-03-22 | Northumberland | Pennsylvania | 42097 | 22751 | 527 |
2329360 | 2329360 | 2022-03-21 | Northumberland | Pennsylvania | 42097 | 22749 | 526 |
2326108 | 2326108 | 2022-03-20 | Northumberland | Pennsylvania | 42097 | 22748 | 526 |
2322855 | 2322855 | 2022-03-19 | Northumberland | Pennsylvania | 42097 | 22747 | 526 |
2319601 | 2319601 | 2022-03-18 | Northumberland | Pennsylvania | 42097 | 22740 | 526 |
2316347 | 2316347 | 2022-03-17 | Northumberland | Pennsylvania | 42097 | 22735 | 526 |
2313094 | 2313094 | 2022-03-16 | Northumberland | Pennsylvania | 42097 | 22729 | 526 |
2309841 | 2309841 | 2022-03-15 | Northumberland | Pennsylvania | 42097 | 22724 | 526 |
2306588 | 2306588 | 2022-03-14 | Northumberland | Pennsylvania | 42097 | 22725 | 526 |
2303337 | 2303337 | 2022-03-13 | Northumberland | Pennsylvania | 42097 | 22724 | 526 |
2300085 | 2300085 | 2022-03-12 | Northumberland | Pennsylvania | 42097 | 22719 | 526 |
2296833 | 2296833 | 2022-03-11 | Northumberland | Pennsylvania | 42097 | 22716 | 526 |
2293581 | 2293581 | 2022-03-10 | Northumberland | Pennsylvania | 42097 | 22708 | 525 |
2290329 | 2290329 | 2022-03-09 | Northumberland | Pennsylvania | 42097 | 22699 | 525 |
2287077 | 2287077 | 2022-03-08 | Northumberland | Pennsylvania | 42097 | 22687 | 525 |
2283825 | 2283825 | 2022-03-07 | Northumberland | Pennsylvania | 42097 | 22681 | 522 |
2280573 | 2280573 | 2022-03-06 | Northumberland | Pennsylvania | 42097 | 22680 | 522 |
2277320 | 2277320 | 2022-03-05 | Northumberland | Pennsylvania | 42097 | 22677 | 521 |
2274067 | 2274067 | 2022-03-04 | Northumberland | Pennsylvania | 42097 | 22672 | 521 |
2270814 | 2270814 | 2022-03-03 | Northumberland | Pennsylvania | 42097 | 22663 | 521 |
2267562 | 2267562 | 2022-03-02 | Northumberland | Pennsylvania | 42097 | 22645 | 521 |
2264309 | 2264309 | 2022-03-01 | Northumberland | Pennsylvania | 42097 | 22632 | 521 |
2261059 | 2261059 | 2022-02-28 | Northumberland | Pennsylvania | 42097 | 22622 | 519 |
2257808 | 2257808 | 2022-02-27 | Northumberland | Pennsylvania | 42097 | 22616 | 519 |
2254557 | 2254557 | 2022-02-26 | Northumberland | Pennsylvania | 42097 | 22609 | 519 |
2251306 | 2251306 | 2022-02-25 | Northumberland | Pennsylvania | 42097 | 22596 | 517 |
2248055 | 2248055 | 2022-02-24 | Northumberland | Pennsylvania | 42097 | 22588 | 515 |
2244804 | 2244804 | 2022-02-23 | Northumberland | Pennsylvania | 42097 | 22575 | 514 |
2241553 | 2241553 | 2022-02-22 | Northumberland | Pennsylvania | 42097 | 22551 | 512 |
2238302 | 2238302 | 2022-02-21 | Northumberland | Pennsylvania | 42097 | 22521 | 512 |
2235051 | 2235051 | 2022-02-20 | Northumberland | Pennsylvania | 42097 | 22521 | 512 |
2231800 | 2231800 | 2022-02-19 | Northumberland | Pennsylvania | 42097 | 22505 | 511 |
2228549 | 2228549 | 2022-02-18 | Northumberland | Pennsylvania | 42097 | 22472 | 511 |
2225298 | 2225298 | 2022-02-17 | Northumberland | Pennsylvania | 42097 | 22445 | 510 |
2222047 | 2222047 | 2022-02-16 | Northumberland | Pennsylvania | 42097 | 22424 | 508 |
2218796 | 2218796 | 2022-02-15 | Northumberland | Pennsylvania | 42097 | 22386 | 504 |
2215545 | 2215545 | 2022-02-14 | Northumberland | Pennsylvania | 42097 | 22357 | 504 |
2212294 | 2212294 | 2022-02-13 | Northumberland | Pennsylvania | 42097 | 22338 | 504 |
2209041 | 2209041 | 2022-02-12 | Northumberland | Pennsylvania | 42097 | 22325 | 504 |
2205788 | 2205788 | 2022-02-11 | Northumberland | Pennsylvania | 42097 | 22294 | 504 |
2202535 | 2202535 | 2022-02-10 | Northumberland | Pennsylvania | 42097 | 22242 | 504 |
2199281 | 2199281 | 2022-02-09 | Northumberland | Pennsylvania | 42097 | 22207 | 504 |
2196027 | 2196027 | 2022-02-08 | Northumberland | Pennsylvania | 42097 | 22140 | 504 |
2192773 | 2192773 | 2022-02-07 | Northumberland | Pennsylvania | 42097 | 22154 | 502 |
2189519 | 2189519 | 2022-02-06 | Northumberland | Pennsylvania | 42097 | 22089 | 501 |
2186266 | 2186266 | 2022-02-05 | Northumberland | Pennsylvania | 42097 | 22067 | 501 |
2183014 | 2183014 | 2022-02-04 | Northumberland | Pennsylvania | 42097 | 21977 | 499 |
2179762 | 2179762 | 2022-02-03 | Northumberland | Pennsylvania | 42097 | 21887 | 498 |
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);