ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Susquehanna" 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 |
---|---|---|---|---|---|---|---|
2501904 | 2501904 | 2022-05-13 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2498646 | 2498646 | 2022-05-12 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2495388 | 2495388 | 2022-05-11 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2492130 | 2492130 | 2022-05-10 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2488872 | 2488872 | 2022-05-09 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2485615 | 2485615 | 2022-05-08 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2482357 | 2482357 | 2022-05-07 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2479099 | 2479099 | 2022-05-06 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2475841 | 2475841 | 2022-05-05 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2472584 | 2472584 | 2022-05-04 | Susquehanna | Pennsylvania | 42115 | 8089 | 109 |
2469328 | 2469328 | 2022-05-03 | Susquehanna | Pennsylvania | 42115 | 8076 | 109 |
2466072 | 2466072 | 2022-05-02 | Susquehanna | Pennsylvania | 42115 | 8055 | 109 |
2462817 | 2462817 | 2022-05-01 | Susquehanna | Pennsylvania | 42115 | 8054 | 109 |
2459561 | 2459561 | 2022-04-30 | Susquehanna | Pennsylvania | 42115 | 8048 | 109 |
2456305 | 2456305 | 2022-04-29 | Susquehanna | Pennsylvania | 42115 | 8025 | 109 |
2453049 | 2453049 | 2022-04-28 | Susquehanna | Pennsylvania | 42115 | 8003 | 109 |
2449793 | 2449793 | 2022-04-27 | Susquehanna | Pennsylvania | 42115 | 7986 | 109 |
2446536 | 2446536 | 2022-04-26 | Susquehanna | Pennsylvania | 42115 | 7976 | 109 |
2443281 | 2443281 | 2022-04-25 | Susquehanna | Pennsylvania | 42115 | 7968 | 108 |
2440025 | 2440025 | 2022-04-24 | Susquehanna | Pennsylvania | 42115 | 7963 | 108 |
2436769 | 2436769 | 2022-04-23 | Susquehanna | Pennsylvania | 42115 | 7957 | 108 |
2433513 | 2433513 | 2022-04-22 | Susquehanna | Pennsylvania | 42115 | 7942 | 109 |
2430257 | 2430257 | 2022-04-21 | Susquehanna | Pennsylvania | 42115 | 7930 | 109 |
2427001 | 2427001 | 2022-04-20 | Susquehanna | Pennsylvania | 42115 | 7918 | 109 |
2423745 | 2423745 | 2022-04-19 | Susquehanna | Pennsylvania | 42115 | 7903 | 108 |
2420489 | 2420489 | 2022-04-18 | Susquehanna | Pennsylvania | 42115 | 7894 | 108 |
2417233 | 2417233 | 2022-04-17 | Susquehanna | Pennsylvania | 42115 | 7889 | 108 |
2413977 | 2413977 | 2022-04-16 | Susquehanna | Pennsylvania | 42115 | 7885 | 108 |
2410721 | 2410721 | 2022-04-15 | Susquehanna | Pennsylvania | 42115 | 7878 | 108 |
2407465 | 2407465 | 2022-04-14 | Susquehanna | Pennsylvania | 42115 | 7867 | 108 |
2404209 | 2404209 | 2022-04-13 | Susquehanna | Pennsylvania | 42115 | 7846 | 108 |
2400954 | 2400954 | 2022-04-12 | Susquehanna | Pennsylvania | 42115 | 7837 | 108 |
2397699 | 2397699 | 2022-04-11 | Susquehanna | Pennsylvania | 42115 | 7829 | 108 |
2394444 | 2394444 | 2022-04-10 | Susquehanna | Pennsylvania | 42115 | 7829 | 108 |
2391188 | 2391188 | 2022-04-09 | Susquehanna | Pennsylvania | 42115 | 7827 | 108 |
2387932 | 2387932 | 2022-04-08 | Susquehanna | Pennsylvania | 42115 | 7818 | 108 |
2384677 | 2384677 | 2022-04-07 | Susquehanna | Pennsylvania | 42115 | 7809 | 108 |
2381422 | 2381422 | 2022-04-06 | Susquehanna | Pennsylvania | 42115 | 7792 | 108 |
2378167 | 2378167 | 2022-04-05 | Susquehanna | Pennsylvania | 42115 | 7782 | 108 |
2374913 | 2374913 | 2022-04-04 | Susquehanna | Pennsylvania | 42115 | 7780 | 107 |
2371661 | 2371661 | 2022-04-03 | Susquehanna | Pennsylvania | 42115 | 7777 | 107 |
2368408 | 2368408 | 2022-04-02 | Susquehanna | Pennsylvania | 42115 | 7777 | 107 |
2365155 | 2365155 | 2022-04-01 | Susquehanna | Pennsylvania | 42115 | 7768 | 107 |
2361902 | 2361902 | 2022-03-31 | Susquehanna | Pennsylvania | 42115 | 7758 | 107 |
2358648 | 2358648 | 2022-03-30 | Susquehanna | Pennsylvania | 42115 | 7754 | 107 |
2355394 | 2355394 | 2022-03-29 | Susquehanna | Pennsylvania | 42115 | 7748 | 107 |
2352141 | 2352141 | 2022-03-28 | Susquehanna | Pennsylvania | 42115 | 7745 | 107 |
2348889 | 2348889 | 2022-03-27 | Susquehanna | Pennsylvania | 42115 | 7745 | 107 |
2345636 | 2345636 | 2022-03-26 | Susquehanna | Pennsylvania | 42115 | 7743 | 107 |
2342383 | 2342383 | 2022-03-25 | Susquehanna | Pennsylvania | 42115 | 7734 | 107 |
2339130 | 2339130 | 2022-03-24 | Susquehanna | Pennsylvania | 42115 | 7724 | 107 |
2335876 | 2335876 | 2022-03-23 | Susquehanna | Pennsylvania | 42115 | 7719 | 107 |
2332622 | 2332622 | 2022-03-22 | Susquehanna | Pennsylvania | 42115 | 7713 | 107 |
2329369 | 2329369 | 2022-03-21 | Susquehanna | Pennsylvania | 42115 | 7710 | 107 |
2326117 | 2326117 | 2022-03-20 | Susquehanna | Pennsylvania | 42115 | 7707 | 107 |
2322864 | 2322864 | 2022-03-19 | Susquehanna | Pennsylvania | 42115 | 7707 | 107 |
2319610 | 2319610 | 2022-03-18 | Susquehanna | Pennsylvania | 42115 | 7703 | 107 |
2316356 | 2316356 | 2022-03-17 | Susquehanna | Pennsylvania | 42115 | 7701 | 107 |
2313103 | 2313103 | 2022-03-16 | Susquehanna | Pennsylvania | 42115 | 7697 | 107 |
2309850 | 2309850 | 2022-03-15 | Susquehanna | Pennsylvania | 42115 | 7691 | 107 |
2306597 | 2306597 | 2022-03-14 | Susquehanna | Pennsylvania | 42115 | 7684 | 107 |
2303346 | 2303346 | 2022-03-13 | Susquehanna | Pennsylvania | 42115 | 7684 | 107 |
2300094 | 2300094 | 2022-03-12 | Susquehanna | Pennsylvania | 42115 | 7681 | 107 |
2296842 | 2296842 | 2022-03-11 | Susquehanna | Pennsylvania | 42115 | 7677 | 107 |
2293590 | 2293590 | 2022-03-10 | Susquehanna | Pennsylvania | 42115 | 7672 | 107 |
2290338 | 2290338 | 2022-03-09 | Susquehanna | Pennsylvania | 42115 | 7668 | 107 |
2287086 | 2287086 | 2022-03-08 | Susquehanna | Pennsylvania | 42115 | 7661 | 106 |
2283834 | 2283834 | 2022-03-07 | Susquehanna | Pennsylvania | 42115 | 7647 | 105 |
2280582 | 2280582 | 2022-03-06 | Susquehanna | Pennsylvania | 42115 | 7645 | 105 |
2277329 | 2277329 | 2022-03-05 | Susquehanna | Pennsylvania | 42115 | 7645 | 105 |
2274076 | 2274076 | 2022-03-04 | Susquehanna | Pennsylvania | 42115 | 7638 | 105 |
2270823 | 2270823 | 2022-03-03 | Susquehanna | Pennsylvania | 42115 | 7629 | 105 |
2267571 | 2267571 | 2022-03-02 | Susquehanna | Pennsylvania | 42115 | 7627 | 105 |
2264318 | 2264318 | 2022-03-01 | Susquehanna | Pennsylvania | 42115 | 7617 | 104 |
2261068 | 2261068 | 2022-02-28 | Susquehanna | Pennsylvania | 42115 | 7612 | 104 |
2257817 | 2257817 | 2022-02-27 | Susquehanna | Pennsylvania | 42115 | 7610 | 104 |
2254566 | 2254566 | 2022-02-26 | Susquehanna | Pennsylvania | 42115 | 7608 | 104 |
2251315 | 2251315 | 2022-02-25 | Susquehanna | Pennsylvania | 42115 | 7597 | 104 |
2248064 | 2248064 | 2022-02-24 | Susquehanna | Pennsylvania | 42115 | 7589 | 104 |
2244813 | 2244813 | 2022-02-23 | Susquehanna | Pennsylvania | 42115 | 7579 | 104 |
2241562 | 2241562 | 2022-02-22 | Susquehanna | Pennsylvania | 42115 | 7566 | 104 |
2238311 | 2238311 | 2022-02-21 | Susquehanna | Pennsylvania | 42115 | 7558 | 104 |
2235060 | 2235060 | 2022-02-20 | Susquehanna | Pennsylvania | 42115 | 7558 | 104 |
2231809 | 2231809 | 2022-02-19 | Susquehanna | Pennsylvania | 42115 | 7555 | 103 |
2228558 | 2228558 | 2022-02-18 | Susquehanna | Pennsylvania | 42115 | 7538 | 103 |
2225307 | 2225307 | 2022-02-17 | Susquehanna | Pennsylvania | 42115 | 7521 | 103 |
2222056 | 2222056 | 2022-02-16 | Susquehanna | Pennsylvania | 42115 | 7513 | 103 |
2218805 | 2218805 | 2022-02-15 | Susquehanna | Pennsylvania | 42115 | 7503 | 103 |
2215554 | 2215554 | 2022-02-14 | Susquehanna | Pennsylvania | 42115 | 7488 | 103 |
2212303 | 2212303 | 2022-02-13 | Susquehanna | Pennsylvania | 42115 | 7481 | 103 |
2209050 | 2209050 | 2022-02-12 | Susquehanna | Pennsylvania | 42115 | 7478 | 103 |
2205797 | 2205797 | 2022-02-11 | Susquehanna | Pennsylvania | 42115 | 7464 | 103 |
2202544 | 2202544 | 2022-02-10 | Susquehanna | Pennsylvania | 42115 | 7452 | 103 |
2199290 | 2199290 | 2022-02-09 | Susquehanna | Pennsylvania | 42115 | 7438 | 103 |
2196036 | 2196036 | 2022-02-08 | Susquehanna | Pennsylvania | 42115 | 7418 | 102 |
2192782 | 2192782 | 2022-02-07 | Susquehanna | Pennsylvania | 42115 | 7416 | 102 |
2189528 | 2189528 | 2022-02-06 | Susquehanna | Pennsylvania | 42115 | 7402 | 101 |
2186275 | 2186275 | 2022-02-05 | Susquehanna | Pennsylvania | 42115 | 7394 | 101 |
2183023 | 2183023 | 2022-02-04 | Susquehanna | Pennsylvania | 42115 | 7379 | 101 |
2179771 | 2179771 | 2022-02-03 | Susquehanna | Pennsylvania | 42115 | 7354 | 101 |
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);