ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

772 rows where county = "Adams" and fips = 55001 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 55001 · 772 ✖

county 1

  • Adams · 772 ✖
Link rowid date ▲ county state fips cases deaths
2502738 2502738 2022-05-13 Adams Wisconsin 55001 4738 61
2499480 2499480 2022-05-12 Adams Wisconsin 55001 4727 61
2496222 2496222 2022-05-11 Adams Wisconsin 55001 4717 61
2492964 2492964 2022-05-10 Adams Wisconsin 55001 4706 61
2489706 2489706 2022-05-09 Adams Wisconsin 55001 4705 61
2486449 2486449 2022-05-08 Adams Wisconsin 55001 4689 61
2483191 2483191 2022-05-07 Adams Wisconsin 55001 4689 61
2479933 2479933 2022-05-06 Adams Wisconsin 55001 4689 61
2476675 2476675 2022-05-05 Adams Wisconsin 55001 4685 61
2473417 2473417 2022-05-04 Adams Wisconsin 55001 4675 61
2470160 2470160 2022-05-03 Adams Wisconsin 55001 4662 61
2466904 2466904 2022-05-02 Adams Wisconsin 55001 4658 61
2463649 2463649 2022-05-01 Adams Wisconsin 55001 4656 61
2460393 2460393 2022-04-30 Adams Wisconsin 55001 4656 61
2457137 2457137 2022-04-29 Adams Wisconsin 55001 4656 61
2453881 2453881 2022-04-28 Adams Wisconsin 55001 4654 61
2450625 2450625 2022-04-27 Adams Wisconsin 55001 4654 61
2447369 2447369 2022-04-26 Adams Wisconsin 55001 4655 61
2444113 2444113 2022-04-25 Adams Wisconsin 55001 4653 61
2440857 2440857 2022-04-24 Adams Wisconsin 55001 4652 61
2437601 2437601 2022-04-23 Adams Wisconsin 55001 4652 61
2434345 2434345 2022-04-22 Adams Wisconsin 55001 4652 61
2431089 2431089 2022-04-21 Adams Wisconsin 55001 4651 61
2427833 2427833 2022-04-20 Adams Wisconsin 55001 4650 61
2424577 2424577 2022-04-19 Adams Wisconsin 55001 4645 61
2421321 2421321 2022-04-18 Adams Wisconsin 55001 4645 61
2418065 2418065 2022-04-17 Adams Wisconsin 55001 4643 61
2414809 2414809 2022-04-16 Adams Wisconsin 55001 4643 61
2411553 2411553 2022-04-15 Adams Wisconsin 55001 4643 61
2408297 2408297 2022-04-14 Adams Wisconsin 55001 4641 61
2405041 2405041 2022-04-13 Adams Wisconsin 55001 4637 61
2401786 2401786 2022-04-12 Adams Wisconsin 55001 4637 61
2398531 2398531 2022-04-11 Adams Wisconsin 55001 4637 61
2395276 2395276 2022-04-10 Adams Wisconsin 55001 4635 61
2392020 2392020 2022-04-09 Adams Wisconsin 55001 4635 61
2388764 2388764 2022-04-08 Adams Wisconsin 55001 4635 61
2385509 2385509 2022-04-07 Adams Wisconsin 55001 4635 61
2382254 2382254 2022-04-06 Adams Wisconsin 55001 4634 61
2378999 2378999 2022-04-05 Adams Wisconsin 55001 4633 61
2375745 2375745 2022-04-04 Adams Wisconsin 55001 4633 61
2372493 2372493 2022-04-03 Adams Wisconsin 55001 4631 61
2369240 2369240 2022-04-02 Adams Wisconsin 55001 4631 61
2365987 2365987 2022-04-01 Adams Wisconsin 55001 4631 61
2362734 2362734 2022-03-31 Adams Wisconsin 55001 4628 61
2359480 2359480 2022-03-30 Adams Wisconsin 55001 4627 61
2356226 2356226 2022-03-29 Adams Wisconsin 55001 4626 61
2352973 2352973 2022-03-28 Adams Wisconsin 55001 4625 61
2349721 2349721 2022-03-27 Adams Wisconsin 55001 4624 60
2346468 2346468 2022-03-26 Adams Wisconsin 55001 4624 60
2343215 2343215 2022-03-25 Adams Wisconsin 55001 4624 60
2339962 2339962 2022-03-24 Adams Wisconsin 55001 4624 59
2336709 2336709 2022-03-23 Adams Wisconsin 55001 4621 59
2333455 2333455 2022-03-22 Adams Wisconsin 55001 4621 57
2330201 2330201 2022-03-21 Adams Wisconsin 55001 4615 57
2326949 2326949 2022-03-20 Adams Wisconsin 55001 4613 57
2323696 2323696 2022-03-19 Adams Wisconsin 55001 4613 57
2320442 2320442 2022-03-18 Adams Wisconsin 55001 4613 57
2317188 2317188 2022-03-17 Adams Wisconsin 55001 4612 55
2313935 2313935 2022-03-16 Adams Wisconsin 55001 4611 55
2310682 2310682 2022-03-15 Adams Wisconsin 55001 4611 55
2307429 2307429 2022-03-14 Adams Wisconsin 55001 4609 55
2304178 2304178 2022-03-13 Adams Wisconsin 55001 4609 54
2300926 2300926 2022-03-12 Adams Wisconsin 55001 4609 54
2297674 2297674 2022-03-11 Adams Wisconsin 55001 4609 54
2294422 2294422 2022-03-10 Adams Wisconsin 55001 4606 53
2291170 2291170 2022-03-09 Adams Wisconsin 55001 4605 53
2287918 2287918 2022-03-08 Adams Wisconsin 55001 4604 53
2284666 2284666 2022-03-07 Adams Wisconsin 55001 4602 53
2281414 2281414 2022-03-06 Adams Wisconsin 55001 4597 53
2278161 2278161 2022-03-05 Adams Wisconsin 55001 4597 53
2274908 2274908 2022-03-04 Adams Wisconsin 55001 4597 53
2271655 2271655 2022-03-03 Adams Wisconsin 55001 4596 53
2268403 2268403 2022-03-02 Adams Wisconsin 55001 4591 53
2265150 2265150 2022-03-01 Adams Wisconsin 55001 4587 53
2261900 2261900 2022-02-28 Adams Wisconsin 55001 4585 52
2258649 2258649 2022-02-27 Adams Wisconsin 55001 4578 51
2255398 2255398 2022-02-26 Adams Wisconsin 55001 4578 51
2252147 2252147 2022-02-25 Adams Wisconsin 55001 4578 51
2248896 2248896 2022-02-24 Adams Wisconsin 55001 4574 50
2245645 2245645 2022-02-23 Adams Wisconsin 55001 4573 50
2242394 2242394 2022-02-22 Adams Wisconsin 55001 4571 50
2239143 2239143 2022-02-21 Adams Wisconsin 55001 4566 49
2235892 2235892 2022-02-20 Adams Wisconsin 55001 4565 49
2232641 2232641 2022-02-19 Adams Wisconsin 55001 4565 49
2229390 2229390 2022-02-18 Adams Wisconsin 55001 4565 49
2226139 2226139 2022-02-17 Adams Wisconsin 55001 4564 49
2222888 2222888 2022-02-16 Adams Wisconsin 55001 4560 48
2219637 2219637 2022-02-15 Adams Wisconsin 55001 4551 48
2216387 2216387 2022-02-14 Adams Wisconsin 55001 4548 48
2213136 2213136 2022-02-13 Adams Wisconsin 55001 4529 48
2209883 2209883 2022-02-12 Adams Wisconsin 55001 4529 48
2206630 2206630 2022-02-11 Adams Wisconsin 55001 4529 48
2203377 2203377 2022-02-10 Adams Wisconsin 55001 4525 48
2200123 2200123 2022-02-09 Adams Wisconsin 55001 4519 48
2196869 2196869 2022-02-08 Adams Wisconsin 55001 4503 48
2193614 2193614 2022-02-07 Adams Wisconsin 55001 4501 48
2190361 2190361 2022-02-06 Adams Wisconsin 55001 4482 48
2187108 2187108 2022-02-05 Adams Wisconsin 55001 4482 48
2183855 2183855 2022-02-04 Adams Wisconsin 55001 4482 48
2180603 2180603 2022-02-03 Adams Wisconsin 55001 4465 47

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);