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

780 rows where county = "Grant" 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 · 780 ✖

fips 1

county 1

  • Grant · 780 ✖
Link rowid date ▲ county state fips cases deaths
2502759 2502759 2022-05-13 Grant Wisconsin 55043 12945 146
2499501 2499501 2022-05-12 Grant Wisconsin 55043 12930 146
2496243 2496243 2022-05-11 Grant Wisconsin 55043 12913 146
2492985 2492985 2022-05-10 Grant Wisconsin 55043 12896 145
2489727 2489727 2022-05-09 Grant Wisconsin 55043 12883 145
2486470 2486470 2022-05-08 Grant Wisconsin 55043 12863 145
2483212 2483212 2022-05-07 Grant Wisconsin 55043 12863 145
2479954 2479954 2022-05-06 Grant Wisconsin 55043 12863 145
2476696 2476696 2022-05-05 Grant Wisconsin 55043 12851 145
2473438 2473438 2022-05-04 Grant Wisconsin 55043 12840 145
2470181 2470181 2022-05-03 Grant Wisconsin 55043 12820 145
2466925 2466925 2022-05-02 Grant Wisconsin 55043 12814 145
2463670 2463670 2022-05-01 Grant Wisconsin 55043 12789 145
2460414 2460414 2022-04-30 Grant Wisconsin 55043 12789 145
2457158 2457158 2022-04-29 Grant Wisconsin 55043 12789 145
2453902 2453902 2022-04-28 Grant Wisconsin 55043 12779 145
2450646 2450646 2022-04-27 Grant Wisconsin 55043 12768 145
2447390 2447390 2022-04-26 Grant Wisconsin 55043 12759 145
2444134 2444134 2022-04-25 Grant Wisconsin 55043 12755 145
2440878 2440878 2022-04-24 Grant Wisconsin 55043 12743 145
2437622 2437622 2022-04-23 Grant Wisconsin 55043 12743 145
2434366 2434366 2022-04-22 Grant Wisconsin 55043 12743 145
2431110 2431110 2022-04-21 Grant Wisconsin 55043 12736 145
2427854 2427854 2022-04-20 Grant Wisconsin 55043 12731 145
2424598 2424598 2022-04-19 Grant Wisconsin 55043 12717 145
2421342 2421342 2022-04-18 Grant Wisconsin 55043 12711 145
2418086 2418086 2022-04-17 Grant Wisconsin 55043 12703 145
2414830 2414830 2022-04-16 Grant Wisconsin 55043 12703 145
2411574 2411574 2022-04-15 Grant Wisconsin 55043 12703 145
2408318 2408318 2022-04-14 Grant Wisconsin 55043 12699 145
2405062 2405062 2022-04-13 Grant Wisconsin 55043 12695 145
2401807 2401807 2022-04-12 Grant Wisconsin 55043 12663 145
2398552 2398552 2022-04-11 Grant Wisconsin 55043 12661 145
2395297 2395297 2022-04-10 Grant Wisconsin 55043 12654 145
2392041 2392041 2022-04-09 Grant Wisconsin 55043 12654 145
2388785 2388785 2022-04-08 Grant Wisconsin 55043 12654 145
2385530 2385530 2022-04-07 Grant Wisconsin 55043 12656 145
2382275 2382275 2022-04-06 Grant Wisconsin 55043 12652 145
2379020 2379020 2022-04-05 Grant Wisconsin 55043 12652 145
2375766 2375766 2022-04-04 Grant Wisconsin 55043 12649 145
2372514 2372514 2022-04-03 Grant Wisconsin 55043 12647 143
2369261 2369261 2022-04-02 Grant Wisconsin 55043 12647 143
2366008 2366008 2022-04-01 Grant Wisconsin 55043 12647 143
2362755 2362755 2022-03-31 Grant Wisconsin 55043 12646 143
2359501 2359501 2022-03-30 Grant Wisconsin 55043 12644 143
2356247 2356247 2022-03-29 Grant Wisconsin 55043 12642 143
2352994 2352994 2022-03-28 Grant Wisconsin 55043 12639 143
2349742 2349742 2022-03-27 Grant Wisconsin 55043 12636 143
2346489 2346489 2022-03-26 Grant Wisconsin 55043 12636 143
2343236 2343236 2022-03-25 Grant Wisconsin 55043 12636 143
2339983 2339983 2022-03-24 Grant Wisconsin 55043 12634 143
2336730 2336730 2022-03-23 Grant Wisconsin 55043 12632 143
2333476 2333476 2022-03-22 Grant Wisconsin 55043 12630 143
2330222 2330222 2022-03-21 Grant Wisconsin 55043 12626 143
2326970 2326970 2022-03-20 Grant Wisconsin 55043 12622 143
2323717 2323717 2022-03-19 Grant Wisconsin 55043 12622 143
2320463 2320463 2022-03-18 Grant Wisconsin 55043 12622 143
2317209 2317209 2022-03-17 Grant Wisconsin 55043 12622 143
2313956 2313956 2022-03-16 Grant Wisconsin 55043 12619 143
2310703 2310703 2022-03-15 Grant Wisconsin 55043 12617 143
2307450 2307450 2022-03-14 Grant Wisconsin 55043 12614 143
2304199 2304199 2022-03-13 Grant Wisconsin 55043 12605 143
2300947 2300947 2022-03-12 Grant Wisconsin 55043 12605 143
2297695 2297695 2022-03-11 Grant Wisconsin 55043 12605 143
2294443 2294443 2022-03-10 Grant Wisconsin 55043 12601 143
2291191 2291191 2022-03-09 Grant Wisconsin 55043 12594 143
2287939 2287939 2022-03-08 Grant Wisconsin 55043 12587 143
2284687 2284687 2022-03-07 Grant Wisconsin 55043 12584 143
2281435 2281435 2022-03-06 Grant Wisconsin 55043 12564 143
2278182 2278182 2022-03-05 Grant Wisconsin 55043 12564 143
2274929 2274929 2022-03-04 Grant Wisconsin 55043 12564 143
2271676 2271676 2022-03-03 Grant Wisconsin 55043 12549 142
2268424 2268424 2022-03-02 Grant Wisconsin 55043 12546 142
2265171 2265171 2022-03-01 Grant Wisconsin 55043 12543 142
2261921 2261921 2022-02-28 Grant Wisconsin 55043 12526 142
2258670 2258670 2022-02-27 Grant Wisconsin 55043 12515 141
2255419 2255419 2022-02-26 Grant Wisconsin 55043 12515 141
2252168 2252168 2022-02-25 Grant Wisconsin 55043 12515 141
2248917 2248917 2022-02-24 Grant Wisconsin 55043 12505 141
2245666 2245666 2022-02-23 Grant Wisconsin 55043 12495 141
2242415 2242415 2022-02-22 Grant Wisconsin 55043 12483 141
2239164 2239164 2022-02-21 Grant Wisconsin 55043 12476 141
2235913 2235913 2022-02-20 Grant Wisconsin 55043 12451 141
2232662 2232662 2022-02-19 Grant Wisconsin 55043 12451 141
2229411 2229411 2022-02-18 Grant Wisconsin 55043 12451 141
2226160 2226160 2022-02-17 Grant Wisconsin 55043 12426 140
2222909 2222909 2022-02-16 Grant Wisconsin 55043 12407 140
2219658 2219658 2022-02-15 Grant Wisconsin 55043 12387 140
2216408 2216408 2022-02-14 Grant Wisconsin 55043 12368 140
2213157 2213157 2022-02-13 Grant Wisconsin 55043 12335 139
2209904 2209904 2022-02-12 Grant Wisconsin 55043 12335 139
2206651 2206651 2022-02-11 Grant Wisconsin 55043 12335 139
2203398 2203398 2022-02-10 Grant Wisconsin 55043 12314 139
2200144 2200144 2022-02-09 Grant Wisconsin 55043 12288 139
2196890 2196890 2022-02-08 Grant Wisconsin 55043 12264 139
2193635 2193635 2022-02-07 Grant Wisconsin 55043 12235 139
2190382 2190382 2022-02-06 Grant Wisconsin 55043 12170 138
2187129 2187129 2022-02-05 Grant Wisconsin 55043 12170 138
2183876 2183876 2022-02-04 Grant Wisconsin 55043 12170 138
2180624 2180624 2022-02-03 Grant Wisconsin 55043 12144 138

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