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

796 rows where county = "Pierce" and state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Wisconsin · 796 ✖

fips 1

county 1

  • Pierce · 796 ✖
Link rowid date ▲ county state fips cases deaths
2502785 2502785 2022-05-13 Pierce Wisconsin 55093 11879 73
2499527 2499527 2022-05-12 Pierce Wisconsin 55093 11864 73
2496269 2496269 2022-05-11 Pierce Wisconsin 55093 11842 73
2493011 2493011 2022-05-10 Pierce Wisconsin 55093 11824 73
2489753 2489753 2022-05-09 Pierce Wisconsin 55093 11785 73
2486496 2486496 2022-05-08 Pierce Wisconsin 55093 11762 73
2483238 2483238 2022-05-07 Pierce Wisconsin 55093 11762 73
2479980 2479980 2022-05-06 Pierce Wisconsin 55093 11762 73
2476722 2476722 2022-05-05 Pierce Wisconsin 55093 11743 73
2473464 2473464 2022-05-04 Pierce Wisconsin 55093 11713 73
2470207 2470207 2022-05-03 Pierce Wisconsin 55093 11699 73
2466951 2466951 2022-05-02 Pierce Wisconsin 55093 11691 73
2463696 2463696 2022-05-01 Pierce Wisconsin 55093 11672 73
2460440 2460440 2022-04-30 Pierce Wisconsin 55093 11672 73
2457184 2457184 2022-04-29 Pierce Wisconsin 55093 11672 73
2453928 2453928 2022-04-28 Pierce Wisconsin 55093 11662 73
2450672 2450672 2022-04-27 Pierce Wisconsin 55093 11646 73
2447416 2447416 2022-04-26 Pierce Wisconsin 55093 11636 73
2444160 2444160 2022-04-25 Pierce Wisconsin 55093 11627 73
2440904 2440904 2022-04-24 Pierce Wisconsin 55093 11612 73
2437648 2437648 2022-04-23 Pierce Wisconsin 55093 11612 73
2434392 2434392 2022-04-22 Pierce Wisconsin 55093 11612 73
2431136 2431136 2022-04-21 Pierce Wisconsin 55093 11607 73
2427880 2427880 2022-04-20 Pierce Wisconsin 55093 11600 73
2424624 2424624 2022-04-19 Pierce Wisconsin 55093 11585 73
2421368 2421368 2022-04-18 Pierce Wisconsin 55093 11581 73
2418112 2418112 2022-04-17 Pierce Wisconsin 55093 11569 73
2414856 2414856 2022-04-16 Pierce Wisconsin 55093 11569 73
2411600 2411600 2022-04-15 Pierce Wisconsin 55093 11569 73
2408344 2408344 2022-04-14 Pierce Wisconsin 55093 11562 73
2405088 2405088 2022-04-13 Pierce Wisconsin 55093 11555 73
2401833 2401833 2022-04-12 Pierce Wisconsin 55093 11547 73
2398578 2398578 2022-04-11 Pierce Wisconsin 55093 11542 72
2395323 2395323 2022-04-10 Pierce Wisconsin 55093 11532 72
2392067 2392067 2022-04-09 Pierce Wisconsin 55093 11532 72
2388811 2388811 2022-04-08 Pierce Wisconsin 55093 11532 72
2385556 2385556 2022-04-07 Pierce Wisconsin 55093 11527 72
2382301 2382301 2022-04-06 Pierce Wisconsin 55093 11525 72
2379046 2379046 2022-04-05 Pierce Wisconsin 55093 11525 72
2375792 2375792 2022-04-04 Pierce Wisconsin 55093 11518 72
2372540 2372540 2022-04-03 Pierce Wisconsin 55093 11510 72
2369287 2369287 2022-04-02 Pierce Wisconsin 55093 11510 72
2366034 2366034 2022-04-01 Pierce Wisconsin 55093 11510 72
2362781 2362781 2022-03-31 Pierce Wisconsin 55093 11508 72
2359527 2359527 2022-03-30 Pierce Wisconsin 55093 11503 72
2356273 2356273 2022-03-29 Pierce Wisconsin 55093 11500 72
2353020 2353020 2022-03-28 Pierce Wisconsin 55093 11493 72
2349768 2349768 2022-03-27 Pierce Wisconsin 55093 11488 72
2346515 2346515 2022-03-26 Pierce Wisconsin 55093 11488 72
2343262 2343262 2022-03-25 Pierce Wisconsin 55093 11488 72
2340009 2340009 2022-03-24 Pierce Wisconsin 55093 11487 72
2336756 2336756 2022-03-23 Pierce Wisconsin 55093 11483 72
2333502 2333502 2022-03-22 Pierce Wisconsin 55093 11480 72
2330248 2330248 2022-03-21 Pierce Wisconsin 55093 11472 72
2326996 2326996 2022-03-20 Pierce Wisconsin 55093 11461 72
2323743 2323743 2022-03-19 Pierce Wisconsin 55093 11461 72
2320489 2320489 2022-03-18 Pierce Wisconsin 55093 11461 72
2317235 2317235 2022-03-17 Pierce Wisconsin 55093 11461 72
2313982 2313982 2022-03-16 Pierce Wisconsin 55093 11454 72
2310729 2310729 2022-03-15 Pierce Wisconsin 55093 11450 72
2307476 2307476 2022-03-14 Pierce Wisconsin 55093 11437 72
2304225 2304225 2022-03-13 Pierce Wisconsin 55093 11432 72
2300973 2300973 2022-03-12 Pierce Wisconsin 55093 11432 72
2297721 2297721 2022-03-11 Pierce Wisconsin 55093 11432 72
2294469 2294469 2022-03-10 Pierce Wisconsin 55093 11429 72
2291217 2291217 2022-03-09 Pierce Wisconsin 55093 11426 72
2287965 2287965 2022-03-08 Pierce Wisconsin 55093 11421 72
2284713 2284713 2022-03-07 Pierce Wisconsin 55093 11414 72
2281461 2281461 2022-03-06 Pierce Wisconsin 55093 11406 72
2278208 2278208 2022-03-05 Pierce Wisconsin 55093 11406 72
2274955 2274955 2022-03-04 Pierce Wisconsin 55093 11406 72
2271702 2271702 2022-03-03 Pierce Wisconsin 55093 11399 71
2268450 2268450 2022-03-02 Pierce Wisconsin 55093 11392 71
2265197 2265197 2022-03-01 Pierce Wisconsin 55093 11387 71
2261947 2261947 2022-02-28 Pierce Wisconsin 55093 11380 71
2258696 2258696 2022-02-27 Pierce Wisconsin 55093 11368 71
2255445 2255445 2022-02-26 Pierce Wisconsin 55093 11368 71
2252194 2252194 2022-02-25 Pierce Wisconsin 55093 11368 71
2248943 2248943 2022-02-24 Pierce Wisconsin 55093 11358 70
2245692 2245692 2022-02-23 Pierce Wisconsin 55093 11350 70
2242441 2242441 2022-02-22 Pierce Wisconsin 55093 11338 70
2239190 2239190 2022-02-21 Pierce Wisconsin 55093 11334 70
2235939 2235939 2022-02-20 Pierce Wisconsin 55093 11318 70
2232688 2232688 2022-02-19 Pierce Wisconsin 55093 11318 70
2229437 2229437 2022-02-18 Pierce Wisconsin 55093 11318 70
2226186 2226186 2022-02-17 Pierce Wisconsin 55093 11304 70
2222935 2222935 2022-02-16 Pierce Wisconsin 55093 11283 70
2219684 2219684 2022-02-15 Pierce Wisconsin 55093 11266 70
2216434 2216434 2022-02-14 Pierce Wisconsin 55093 11249 71
2213183 2213183 2022-02-13 Pierce Wisconsin 55093 11195 68
2209930 2209930 2022-02-12 Pierce Wisconsin 55093 11195 68
2206677 2206677 2022-02-11 Pierce Wisconsin 55093 11195 68
2203424 2203424 2022-02-10 Pierce Wisconsin 55093 11157 68
2200170 2200170 2022-02-09 Pierce Wisconsin 55093 11136 68
2196916 2196916 2022-02-08 Pierce Wisconsin 55093 11109 68
2193661 2193661 2022-02-07 Pierce Wisconsin 55093 11076 67
2190408 2190408 2022-02-06 Pierce Wisconsin 55093 11041 67
2187155 2187155 2022-02-05 Pierce Wisconsin 55093 11041 67
2183902 2183902 2022-02-04 Pierce Wisconsin 55093 11041 67
2180650 2180650 2022-02-03 Pierce Wisconsin 55093 11009 67

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