ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Schuylkill" 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 |
---|---|---|---|---|---|---|---|
2501900 | 2501900 | 2022-05-13 | Schuylkill | Pennsylvania | 42107 | 34853 | 675 |
2498642 | 2498642 | 2022-05-12 | Schuylkill | Pennsylvania | 42107 | 34853 | 675 |
2495384 | 2495384 | 2022-05-11 | Schuylkill | Pennsylvania | 42107 | 34853 | 675 |
2492126 | 2492126 | 2022-05-10 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2488868 | 2488868 | 2022-05-09 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2485611 | 2485611 | 2022-05-08 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2482353 | 2482353 | 2022-05-07 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2479095 | 2479095 | 2022-05-06 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2475837 | 2475837 | 2022-05-05 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2472580 | 2472580 | 2022-05-04 | Schuylkill | Pennsylvania | 42107 | 34661 | 674 |
2469324 | 2469324 | 2022-05-03 | Schuylkill | Pennsylvania | 42107 | 34646 | 674 |
2466068 | 2466068 | 2022-05-02 | Schuylkill | Pennsylvania | 42107 | 34636 | 674 |
2462813 | 2462813 | 2022-05-01 | Schuylkill | Pennsylvania | 42107 | 34633 | 674 |
2459557 | 2459557 | 2022-04-30 | Schuylkill | Pennsylvania | 42107 | 34615 | 674 |
2456301 | 2456301 | 2022-04-29 | Schuylkill | Pennsylvania | 42107 | 34597 | 674 |
2453045 | 2453045 | 2022-04-28 | Schuylkill | Pennsylvania | 42107 | 34578 | 674 |
2449789 | 2449789 | 2022-04-27 | Schuylkill | Pennsylvania | 42107 | 34564 | 674 |
2446532 | 2446532 | 2022-04-26 | Schuylkill | Pennsylvania | 42107 | 34553 | 674 |
2443277 | 2443277 | 2022-04-25 | Schuylkill | Pennsylvania | 42107 | 34546 | 674 |
2440021 | 2440021 | 2022-04-24 | Schuylkill | Pennsylvania | 42107 | 34539 | 674 |
2436765 | 2436765 | 2022-04-23 | Schuylkill | Pennsylvania | 42107 | 34535 | 674 |
2433509 | 2433509 | 2022-04-22 | Schuylkill | Pennsylvania | 42107 | 34522 | 674 |
2430253 | 2430253 | 2022-04-21 | Schuylkill | Pennsylvania | 42107 | 34509 | 674 |
2426997 | 2426997 | 2022-04-20 | Schuylkill | Pennsylvania | 42107 | 34497 | 675 |
2423741 | 2423741 | 2022-04-19 | Schuylkill | Pennsylvania | 42107 | 34489 | 675 |
2420485 | 2420485 | 2022-04-18 | Schuylkill | Pennsylvania | 42107 | 34484 | 674 |
2417229 | 2417229 | 2022-04-17 | Schuylkill | Pennsylvania | 42107 | 34479 | 674 |
2413973 | 2413973 | 2022-04-16 | Schuylkill | Pennsylvania | 42107 | 34471 | 674 |
2410717 | 2410717 | 2022-04-15 | Schuylkill | Pennsylvania | 42107 | 34461 | 674 |
2407461 | 2407461 | 2022-04-14 | Schuylkill | Pennsylvania | 42107 | 34456 | 674 |
2404205 | 2404205 | 2022-04-13 | Schuylkill | Pennsylvania | 42107 | 34447 | 674 |
2400950 | 2400950 | 2022-04-12 | Schuylkill | Pennsylvania | 42107 | 34435 | 674 |
2397695 | 2397695 | 2022-04-11 | Schuylkill | Pennsylvania | 42107 | 34429 | 674 |
2394440 | 2394440 | 2022-04-10 | Schuylkill | Pennsylvania | 42107 | 34425 | 674 |
2391184 | 2391184 | 2022-04-09 | Schuylkill | Pennsylvania | 42107 | 34420 | 674 |
2387928 | 2387928 | 2022-04-08 | Schuylkill | Pennsylvania | 42107 | 34411 | 674 |
2384673 | 2384673 | 2022-04-07 | Schuylkill | Pennsylvania | 42107 | 34408 | 674 |
2381418 | 2381418 | 2022-04-06 | Schuylkill | Pennsylvania | 42107 | 34403 | 674 |
2378163 | 2378163 | 2022-04-05 | Schuylkill | Pennsylvania | 42107 | 34400 | 674 |
2374909 | 2374909 | 2022-04-04 | Schuylkill | Pennsylvania | 42107 | 34392 | 674 |
2371657 | 2371657 | 2022-04-03 | Schuylkill | Pennsylvania | 42107 | 34390 | 674 |
2368404 | 2368404 | 2022-04-02 | Schuylkill | Pennsylvania | 42107 | 34390 | 674 |
2365151 | 2365151 | 2022-04-01 | Schuylkill | Pennsylvania | 42107 | 34384 | 672 |
2361898 | 2361898 | 2022-03-31 | Schuylkill | Pennsylvania | 42107 | 34382 | 672 |
2358644 | 2358644 | 2022-03-30 | Schuylkill | Pennsylvania | 42107 | 34378 | 672 |
2355390 | 2355390 | 2022-03-29 | Schuylkill | Pennsylvania | 42107 | 34373 | 672 |
2352137 | 2352137 | 2022-03-28 | Schuylkill | Pennsylvania | 42107 | 34370 | 671 |
2348885 | 2348885 | 2022-03-27 | Schuylkill | Pennsylvania | 42107 | 34368 | 671 |
2345632 | 2345632 | 2022-03-26 | Schuylkill | Pennsylvania | 42107 | 34365 | 671 |
2342379 | 2342379 | 2022-03-25 | Schuylkill | Pennsylvania | 42107 | 34360 | 671 |
2339126 | 2339126 | 2022-03-24 | Schuylkill | Pennsylvania | 42107 | 34357 | 671 |
2335872 | 2335872 | 2022-03-23 | Schuylkill | Pennsylvania | 42107 | 34351 | 671 |
2332618 | 2332618 | 2022-03-22 | Schuylkill | Pennsylvania | 42107 | 34349 | 670 |
2329365 | 2329365 | 2022-03-21 | Schuylkill | Pennsylvania | 42107 | 34345 | 670 |
2326113 | 2326113 | 2022-03-20 | Schuylkill | Pennsylvania | 42107 | 34342 | 670 |
2322860 | 2322860 | 2022-03-19 | Schuylkill | Pennsylvania | 42107 | 34339 | 670 |
2319606 | 2319606 | 2022-03-18 | Schuylkill | Pennsylvania | 42107 | 34335 | 670 |
2316352 | 2316352 | 2022-03-17 | Schuylkill | Pennsylvania | 42107 | 34328 | 670 |
2313099 | 2313099 | 2022-03-16 | Schuylkill | Pennsylvania | 42107 | 34319 | 667 |
2309846 | 2309846 | 2022-03-15 | Schuylkill | Pennsylvania | 42107 | 34313 | 665 |
2306593 | 2306593 | 2022-03-14 | Schuylkill | Pennsylvania | 42107 | 34305 | 662 |
2303342 | 2303342 | 2022-03-13 | Schuylkill | Pennsylvania | 42107 | 34305 | 662 |
2300090 | 2300090 | 2022-03-12 | Schuylkill | Pennsylvania | 42107 | 34300 | 662 |
2296838 | 2296838 | 2022-03-11 | Schuylkill | Pennsylvania | 42107 | 34286 | 662 |
2293586 | 2293586 | 2022-03-10 | Schuylkill | Pennsylvania | 42107 | 34268 | 662 |
2290334 | 2290334 | 2022-03-09 | Schuylkill | Pennsylvania | 42107 | 34253 | 662 |
2287082 | 2287082 | 2022-03-08 | Schuylkill | Pennsylvania | 42107 | 34242 | 661 |
2283830 | 2283830 | 2022-03-07 | Schuylkill | Pennsylvania | 42107 | 34219 | 659 |
2280578 | 2280578 | 2022-03-06 | Schuylkill | Pennsylvania | 42107 | 34208 | 659 |
2277325 | 2277325 | 2022-03-05 | Schuylkill | Pennsylvania | 42107 | 34200 | 658 |
2274072 | 2274072 | 2022-03-04 | Schuylkill | Pennsylvania | 42107 | 34185 | 658 |
2270819 | 2270819 | 2022-03-03 | Schuylkill | Pennsylvania | 42107 | 34164 | 658 |
2267567 | 2267567 | 2022-03-02 | Schuylkill | Pennsylvania | 42107 | 34134 | 656 |
2264314 | 2264314 | 2022-03-01 | Schuylkill | Pennsylvania | 42107 | 34124 | 656 |
2261064 | 2261064 | 2022-02-28 | Schuylkill | Pennsylvania | 42107 | 34108 | 656 |
2257813 | 2257813 | 2022-02-27 | Schuylkill | Pennsylvania | 42107 | 34097 | 656 |
2254562 | 2254562 | 2022-02-26 | Schuylkill | Pennsylvania | 42107 | 34084 | 656 |
2251311 | 2251311 | 2022-02-25 | Schuylkill | Pennsylvania | 42107 | 34067 | 656 |
2248060 | 2248060 | 2022-02-24 | Schuylkill | Pennsylvania | 42107 | 34042 | 656 |
2244809 | 2244809 | 2022-02-23 | Schuylkill | Pennsylvania | 42107 | 34017 | 655 |
2241558 | 2241558 | 2022-02-22 | Schuylkill | Pennsylvania | 42107 | 33982 | 654 |
2238307 | 2238307 | 2022-02-21 | Schuylkill | Pennsylvania | 42107 | 33950 | 654 |
2235056 | 2235056 | 2022-02-20 | Schuylkill | Pennsylvania | 42107 | 33950 | 654 |
2231805 | 2231805 | 2022-02-19 | Schuylkill | Pennsylvania | 42107 | 33935 | 653 |
2228554 | 2228554 | 2022-02-18 | Schuylkill | Pennsylvania | 42107 | 33888 | 653 |
2225303 | 2225303 | 2022-02-17 | Schuylkill | Pennsylvania | 42107 | 33851 | 653 |
2222052 | 2222052 | 2022-02-16 | Schuylkill | Pennsylvania | 42107 | 33813 | 653 |
2218801 | 2218801 | 2022-02-15 | Schuylkill | Pennsylvania | 42107 | 33784 | 652 |
2215550 | 2215550 | 2022-02-14 | Schuylkill | Pennsylvania | 42107 | 33766 | 648 |
2212299 | 2212299 | 2022-02-13 | Schuylkill | Pennsylvania | 42107 | 33742 | 647 |
2209046 | 2209046 | 2022-02-12 | Schuylkill | Pennsylvania | 42107 | 33715 | 647 |
2205793 | 2205793 | 2022-02-11 | Schuylkill | Pennsylvania | 42107 | 33674 | 647 |
2202540 | 2202540 | 2022-02-10 | Schuylkill | Pennsylvania | 42107 | 33629 | 646 |
2199286 | 2199286 | 2022-02-09 | Schuylkill | Pennsylvania | 42107 | 33563 | 644 |
2196032 | 2196032 | 2022-02-08 | Schuylkill | Pennsylvania | 42107 | 33505 | 640 |
2192778 | 2192778 | 2022-02-07 | Schuylkill | Pennsylvania | 42107 | 33487 | 636 |
2189524 | 2189524 | 2022-02-06 | Schuylkill | Pennsylvania | 42107 | 33424 | 635 |
2186271 | 2186271 | 2022-02-05 | Schuylkill | Pennsylvania | 42107 | 33372 | 635 |
2183019 | 2183019 | 2022-02-04 | Schuylkill | Pennsylvania | 42107 | 33294 | 634 |
2179767 | 2179767 | 2022-02-03 | Schuylkill | Pennsylvania | 42107 | 33137 | 632 |
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);