ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" and fips = 46071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502079 | 2502079 | 2022-05-13 | Jackson | South Dakota | 46071 | 632 | 21 |
2498821 | 2498821 | 2022-05-12 | Jackson | South Dakota | 46071 | 632 | 21 |
2495563 | 2495563 | 2022-05-11 | Jackson | South Dakota | 46071 | 632 | 21 |
2492305 | 2492305 | 2022-05-10 | Jackson | South Dakota | 46071 | 631 | 21 |
2489047 | 2489047 | 2022-05-09 | Jackson | South Dakota | 46071 | 631 | 21 |
2485790 | 2485790 | 2022-05-08 | Jackson | South Dakota | 46071 | 631 | 21 |
2482532 | 2482532 | 2022-05-07 | Jackson | South Dakota | 46071 | 631 | 21 |
2479274 | 2479274 | 2022-05-06 | Jackson | South Dakota | 46071 | 631 | 21 |
2476016 | 2476016 | 2022-05-05 | Jackson | South Dakota | 46071 | 631 | 21 |
2472759 | 2472759 | 2022-05-04 | Jackson | South Dakota | 46071 | 631 | 21 |
2469503 | 2469503 | 2022-05-03 | Jackson | South Dakota | 46071 | 630 | 21 |
2466247 | 2466247 | 2022-05-02 | Jackson | South Dakota | 46071 | 630 | 21 |
2462992 | 2462992 | 2022-05-01 | Jackson | South Dakota | 46071 | 630 | 21 |
2459736 | 2459736 | 2022-04-30 | Jackson | South Dakota | 46071 | 630 | 21 |
2456480 | 2456480 | 2022-04-29 | Jackson | South Dakota | 46071 | 630 | 21 |
2453224 | 2453224 | 2022-04-28 | Jackson | South Dakota | 46071 | 630 | 21 |
2449968 | 2449968 | 2022-04-27 | Jackson | South Dakota | 46071 | 630 | 21 |
2446711 | 2446711 | 2022-04-26 | Jackson | South Dakota | 46071 | 629 | 21 |
2443456 | 2443456 | 2022-04-25 | Jackson | South Dakota | 46071 | 629 | 21 |
2440200 | 2440200 | 2022-04-24 | Jackson | South Dakota | 46071 | 629 | 21 |
2436944 | 2436944 | 2022-04-23 | Jackson | South Dakota | 46071 | 629 | 21 |
2433688 | 2433688 | 2022-04-22 | Jackson | South Dakota | 46071 | 629 | 21 |
2430432 | 2430432 | 2022-04-21 | Jackson | South Dakota | 46071 | 629 | 21 |
2427176 | 2427176 | 2022-04-20 | Jackson | South Dakota | 46071 | 629 | 21 |
2423920 | 2423920 | 2022-04-19 | Jackson | South Dakota | 46071 | 629 | 21 |
2420664 | 2420664 | 2022-04-18 | Jackson | South Dakota | 46071 | 629 | 21 |
2417408 | 2417408 | 2022-04-17 | Jackson | South Dakota | 46071 | 629 | 21 |
2414152 | 2414152 | 2022-04-16 | Jackson | South Dakota | 46071 | 629 | 21 |
2410896 | 2410896 | 2022-04-15 | Jackson | South Dakota | 46071 | 629 | 21 |
2407640 | 2407640 | 2022-04-14 | Jackson | South Dakota | 46071 | 629 | 21 |
2404384 | 2404384 | 2022-04-13 | Jackson | South Dakota | 46071 | 629 | 21 |
2401129 | 2401129 | 2022-04-12 | Jackson | South Dakota | 46071 | 629 | 21 |
2397874 | 2397874 | 2022-04-11 | Jackson | South Dakota | 46071 | 629 | 21 |
2394619 | 2394619 | 2022-04-10 | Jackson | South Dakota | 46071 | 629 | 21 |
2391363 | 2391363 | 2022-04-09 | Jackson | South Dakota | 46071 | 629 | 21 |
2388107 | 2388107 | 2022-04-08 | Jackson | South Dakota | 46071 | 629 | 21 |
2384852 | 2384852 | 2022-04-07 | Jackson | South Dakota | 46071 | 629 | 21 |
2381597 | 2381597 | 2022-04-06 | Jackson | South Dakota | 46071 | 629 | 21 |
2378342 | 2378342 | 2022-04-05 | Jackson | South Dakota | 46071 | 628 | 21 |
2375088 | 2375088 | 2022-04-04 | Jackson | South Dakota | 46071 | 628 | 21 |
2371836 | 2371836 | 2022-04-03 | Jackson | South Dakota | 46071 | 628 | 21 |
2368583 | 2368583 | 2022-04-02 | Jackson | South Dakota | 46071 | 628 | 21 |
2365330 | 2365330 | 2022-04-01 | Jackson | South Dakota | 46071 | 628 | 21 |
2362077 | 2362077 | 2022-03-31 | Jackson | South Dakota | 46071 | 628 | 21 |
2358823 | 2358823 | 2022-03-30 | Jackson | South Dakota | 46071 | 628 | 21 |
2355569 | 2355569 | 2022-03-29 | Jackson | South Dakota | 46071 | 628 | 21 |
2352316 | 2352316 | 2022-03-28 | Jackson | South Dakota | 46071 | 628 | 21 |
2349064 | 2349064 | 2022-03-27 | Jackson | South Dakota | 46071 | 628 | 21 |
2345811 | 2345811 | 2022-03-26 | Jackson | South Dakota | 46071 | 628 | 21 |
2342558 | 2342558 | 2022-03-25 | Jackson | South Dakota | 46071 | 628 | 21 |
2339305 | 2339305 | 2022-03-24 | Jackson | South Dakota | 46071 | 628 | 21 |
2336051 | 2336051 | 2022-03-23 | Jackson | South Dakota | 46071 | 628 | 21 |
2332797 | 2332797 | 2022-03-22 | Jackson | South Dakota | 46071 | 628 | 21 |
2329544 | 2329544 | 2022-03-21 | Jackson | South Dakota | 46071 | 628 | 21 |
2326292 | 2326292 | 2022-03-20 | Jackson | South Dakota | 46071 | 628 | 21 |
2323039 | 2323039 | 2022-03-19 | Jackson | South Dakota | 46071 | 628 | 21 |
2319785 | 2319785 | 2022-03-18 | Jackson | South Dakota | 46071 | 628 | 21 |
2316531 | 2316531 | 2022-03-17 | Jackson | South Dakota | 46071 | 628 | 21 |
2313278 | 2313278 | 2022-03-16 | Jackson | South Dakota | 46071 | 628 | 21 |
2310025 | 2310025 | 2022-03-15 | Jackson | South Dakota | 46071 | 628 | 21 |
2306772 | 2306772 | 2022-03-14 | Jackson | South Dakota | 46071 | 628 | 21 |
2303521 | 2303521 | 2022-03-13 | Jackson | South Dakota | 46071 | 628 | 21 |
2300269 | 2300269 | 2022-03-12 | Jackson | South Dakota | 46071 | 628 | 21 |
2297017 | 2297017 | 2022-03-11 | Jackson | South Dakota | 46071 | 628 | 21 |
2293765 | 2293765 | 2022-03-10 | Jackson | South Dakota | 46071 | 627 | 21 |
2290513 | 2290513 | 2022-03-09 | Jackson | South Dakota | 46071 | 627 | 21 |
2287261 | 2287261 | 2022-03-08 | Jackson | South Dakota | 46071 | 626 | 21 |
2284009 | 2284009 | 2022-03-07 | Jackson | South Dakota | 46071 | 626 | 21 |
2280757 | 2280757 | 2022-03-06 | Jackson | South Dakota | 46071 | 626 | 21 |
2277504 | 2277504 | 2022-03-05 | Jackson | South Dakota | 46071 | 626 | 21 |
2274251 | 2274251 | 2022-03-04 | Jackson | South Dakota | 46071 | 626 | 21 |
2270998 | 2270998 | 2022-03-03 | Jackson | South Dakota | 46071 | 627 | 21 |
2267746 | 2267746 | 2022-03-02 | Jackson | South Dakota | 46071 | 627 | 21 |
2264493 | 2264493 | 2022-03-01 | Jackson | South Dakota | 46071 | 627 | 21 |
2261243 | 2261243 | 2022-02-28 | Jackson | South Dakota | 46071 | 626 | 21 |
2257992 | 2257992 | 2022-02-27 | Jackson | South Dakota | 46071 | 626 | 21 |
2254741 | 2254741 | 2022-02-26 | Jackson | South Dakota | 46071 | 626 | 21 |
2251490 | 2251490 | 2022-02-25 | Jackson | South Dakota | 46071 | 626 | 21 |
2248239 | 2248239 | 2022-02-24 | Jackson | South Dakota | 46071 | 627 | 21 |
2244988 | 2244988 | 2022-02-23 | Jackson | South Dakota | 46071 | 627 | 21 |
2241737 | 2241737 | 2022-02-22 | Jackson | South Dakota | 46071 | 625 | 21 |
2238486 | 2238486 | 2022-02-21 | Jackson | South Dakota | 46071 | 623 | 21 |
2235235 | 2235235 | 2022-02-20 | Jackson | South Dakota | 46071 | 623 | 21 |
2231984 | 2231984 | 2022-02-19 | Jackson | South Dakota | 46071 | 623 | 21 |
2228733 | 2228733 | 2022-02-18 | Jackson | South Dakota | 46071 | 623 | 21 |
2225482 | 2225482 | 2022-02-17 | Jackson | South Dakota | 46071 | 622 | 21 |
2222231 | 2222231 | 2022-02-16 | Jackson | South Dakota | 46071 | 621 | 21 |
2218980 | 2218980 | 2022-02-15 | Jackson | South Dakota | 46071 | 621 | 21 |
2215729 | 2215729 | 2022-02-14 | Jackson | South Dakota | 46071 | 619 | 21 |
2212478 | 2212478 | 2022-02-13 | Jackson | South Dakota | 46071 | 619 | 21 |
2209225 | 2209225 | 2022-02-12 | Jackson | South Dakota | 46071 | 619 | 21 |
2205972 | 2205972 | 2022-02-11 | Jackson | South Dakota | 46071 | 619 | 21 |
2202719 | 2202719 | 2022-02-10 | Jackson | South Dakota | 46071 | 619 | 21 |
2199465 | 2199465 | 2022-02-09 | Jackson | South Dakota | 46071 | 617 | 20 |
2196211 | 2196211 | 2022-02-08 | Jackson | South Dakota | 46071 | 612 | 20 |
2192957 | 2192957 | 2022-02-07 | Jackson | South Dakota | 46071 | 608 | 20 |
2189703 | 2189703 | 2022-02-06 | Jackson | South Dakota | 46071 | 608 | 20 |
2186450 | 2186450 | 2022-02-05 | Jackson | South Dakota | 46071 | 608 | 20 |
2183198 | 2183198 | 2022-02-04 | Jackson | South Dakota | 46071 | 608 | 20 |
2179946 | 2179946 | 2022-02-03 | Jackson | South Dakota | 46071 | 607 | 20 |
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);