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

785 rows where county = "Douglas" and fips = 55031 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

  • 55031 · 785 ✖

county 1

  • Douglas · 785 ✖
Link rowid date ▲ county state fips cases deaths
2502753 2502753 2022-05-13 Douglas Wisconsin 55031 11993 79
2499495 2499495 2022-05-12 Douglas Wisconsin 55031 11964 79
2496237 2496237 2022-05-11 Douglas Wisconsin 55031 11930 79
2492979 2492979 2022-05-10 Douglas Wisconsin 55031 11891 79
2489721 2489721 2022-05-09 Douglas Wisconsin 55031 11880 79
2486464 2486464 2022-05-08 Douglas Wisconsin 55031 11846 79
2483206 2483206 2022-05-07 Douglas Wisconsin 55031 11846 79
2479948 2479948 2022-05-06 Douglas Wisconsin 55031 11846 79
2476690 2476690 2022-05-05 Douglas Wisconsin 55031 11828 79
2473432 2473432 2022-05-04 Douglas Wisconsin 55031 11808 79
2470175 2470175 2022-05-03 Douglas Wisconsin 55031 11783 79
2466919 2466919 2022-05-02 Douglas Wisconsin 55031 11764 79
2463664 2463664 2022-05-01 Douglas Wisconsin 55031 11738 79
2460408 2460408 2022-04-30 Douglas Wisconsin 55031 11738 79
2457152 2457152 2022-04-29 Douglas Wisconsin 55031 11738 79
2453896 2453896 2022-04-28 Douglas Wisconsin 55031 11727 79
2450640 2450640 2022-04-27 Douglas Wisconsin 55031 11721 79
2447384 2447384 2022-04-26 Douglas Wisconsin 55031 11709 79
2444128 2444128 2022-04-25 Douglas Wisconsin 55031 11700 79
2440872 2440872 2022-04-24 Douglas Wisconsin 55031 11684 79
2437616 2437616 2022-04-23 Douglas Wisconsin 55031 11684 79
2434360 2434360 2022-04-22 Douglas Wisconsin 55031 11684 79
2431104 2431104 2022-04-21 Douglas Wisconsin 55031 11671 79
2427848 2427848 2022-04-20 Douglas Wisconsin 55031 11659 79
2424592 2424592 2022-04-19 Douglas Wisconsin 55031 11645 79
2421336 2421336 2022-04-18 Douglas Wisconsin 55031 11638 79
2418080 2418080 2022-04-17 Douglas Wisconsin 55031 11620 79
2414824 2414824 2022-04-16 Douglas Wisconsin 55031 11620 79
2411568 2411568 2022-04-15 Douglas Wisconsin 55031 11620 79
2408312 2408312 2022-04-14 Douglas Wisconsin 55031 11608 77
2405056 2405056 2022-04-13 Douglas Wisconsin 55031 11599 77
2401801 2401801 2022-04-12 Douglas Wisconsin 55031 11591 77
2398546 2398546 2022-04-11 Douglas Wisconsin 55031 11582 76
2395291 2395291 2022-04-10 Douglas Wisconsin 55031 11574 76
2392035 2392035 2022-04-09 Douglas Wisconsin 55031 11574 76
2388779 2388779 2022-04-08 Douglas Wisconsin 55031 11574 76
2385524 2385524 2022-04-07 Douglas Wisconsin 55031 11550 76
2382269 2382269 2022-04-06 Douglas Wisconsin 55031 11544 76
2379014 2379014 2022-04-05 Douglas Wisconsin 55031 11543 76
2375760 2375760 2022-04-04 Douglas Wisconsin 55031 11540 76
2372508 2372508 2022-04-03 Douglas Wisconsin 55031 11532 76
2369255 2369255 2022-04-02 Douglas Wisconsin 55031 11532 76
2366002 2366002 2022-04-01 Douglas Wisconsin 55031 11532 76
2362749 2362749 2022-03-31 Douglas Wisconsin 55031 11527 76
2359495 2359495 2022-03-30 Douglas Wisconsin 55031 11518 76
2356241 2356241 2022-03-29 Douglas Wisconsin 55031 11514 76
2352988 2352988 2022-03-28 Douglas Wisconsin 55031 11507 76
2349736 2349736 2022-03-27 Douglas Wisconsin 55031 11500 76
2346483 2346483 2022-03-26 Douglas Wisconsin 55031 11500 76
2343230 2343230 2022-03-25 Douglas Wisconsin 55031 11500 76
2339977 2339977 2022-03-24 Douglas Wisconsin 55031 11493 76
2336724 2336724 2022-03-23 Douglas Wisconsin 55031 11491 76
2333470 2333470 2022-03-22 Douglas Wisconsin 55031 11484 76
2330216 2330216 2022-03-21 Douglas Wisconsin 55031 11480 76
2326964 2326964 2022-03-20 Douglas Wisconsin 55031 11476 76
2323711 2323711 2022-03-19 Douglas Wisconsin 55031 11476 76
2320457 2320457 2022-03-18 Douglas Wisconsin 55031 11476 76
2317203 2317203 2022-03-17 Douglas Wisconsin 55031 11472 76
2313950 2313950 2022-03-16 Douglas Wisconsin 55031 11469 76
2310697 2310697 2022-03-15 Douglas Wisconsin 55031 11462 76
2307444 2307444 2022-03-14 Douglas Wisconsin 55031 11455 75
2304193 2304193 2022-03-13 Douglas Wisconsin 55031 11447 74
2300941 2300941 2022-03-12 Douglas Wisconsin 55031 11447 74
2297689 2297689 2022-03-11 Douglas Wisconsin 55031 11447 74
2294437 2294437 2022-03-10 Douglas Wisconsin 55031 11444 74
2291185 2291185 2022-03-09 Douglas Wisconsin 55031 11440 73
2287933 2287933 2022-03-08 Douglas Wisconsin 55031 11437 73
2284681 2284681 2022-03-07 Douglas Wisconsin 55031 11425 73
2281429 2281429 2022-03-06 Douglas Wisconsin 55031 11408 73
2278176 2278176 2022-03-05 Douglas Wisconsin 55031 11408 73
2274923 2274923 2022-03-04 Douglas Wisconsin 55031 11408 73
2271670 2271670 2022-03-03 Douglas Wisconsin 55031 11403 73
2268418 2268418 2022-03-02 Douglas Wisconsin 55031 11400 73
2265165 2265165 2022-03-01 Douglas Wisconsin 55031 11393 73
2261915 2261915 2022-02-28 Douglas Wisconsin 55031 11386 73
2258664 2258664 2022-02-27 Douglas Wisconsin 55031 11373 73
2255413 2255413 2022-02-26 Douglas Wisconsin 55031 11373 73
2252162 2252162 2022-02-25 Douglas Wisconsin 55031 11373 73
2248911 2248911 2022-02-24 Douglas Wisconsin 55031 11350 72
2245660 2245660 2022-02-23 Douglas Wisconsin 55031 11340 72
2242409 2242409 2022-02-22 Douglas Wisconsin 55031 11334 72
2239158 2239158 2022-02-21 Douglas Wisconsin 55031 11327 72
2235907 2235907 2022-02-20 Douglas Wisconsin 55031 11300 72
2232656 2232656 2022-02-19 Douglas Wisconsin 55031 11300 72
2229405 2229405 2022-02-18 Douglas Wisconsin 55031 11300 72
2226154 2226154 2022-02-17 Douglas Wisconsin 55031 11277 72
2222903 2222903 2022-02-16 Douglas Wisconsin 55031 11243 72
2219652 2219652 2022-02-15 Douglas Wisconsin 55031 11215 72
2216402 2216402 2022-02-14 Douglas Wisconsin 55031 11193 72
2213151 2213151 2022-02-13 Douglas Wisconsin 55031 11123 72
2209898 2209898 2022-02-12 Douglas Wisconsin 55031 11123 72
2206645 2206645 2022-02-11 Douglas Wisconsin 55031 11123 72
2203392 2203392 2022-02-10 Douglas Wisconsin 55031 11105 72
2200138 2200138 2022-02-09 Douglas Wisconsin 55031 11061 72
2196884 2196884 2022-02-08 Douglas Wisconsin 55031 11031 72
2193629 2193629 2022-02-07 Douglas Wisconsin 55031 10999 72
2190376 2190376 2022-02-06 Douglas Wisconsin 55031 10904 72
2187123 2187123 2022-02-05 Douglas Wisconsin 55031 10904 72
2183870 2183870 2022-02-04 Douglas Wisconsin 55031 10904 72
2180618 2180618 2022-02-03 Douglas Wisconsin 55031 10855 71

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