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

778 rows where county = "Richland", fips = 55103 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 · 778 ✖

fips 1

  • 55103 · 778 ✖

county 1

  • Richland · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502790 2502790 2022-05-13 Richland Wisconsin 55103 3995 48
2499532 2499532 2022-05-12 Richland Wisconsin 55103 3988 48
2496274 2496274 2022-05-11 Richland Wisconsin 55103 3976 48
2493016 2493016 2022-05-10 Richland Wisconsin 55103 3969 48
2489758 2489758 2022-05-09 Richland Wisconsin 55103 3965 48
2486501 2486501 2022-05-08 Richland Wisconsin 55103 3957 48
2483243 2483243 2022-05-07 Richland Wisconsin 55103 3957 48
2479985 2479985 2022-05-06 Richland Wisconsin 55103 3957 48
2476727 2476727 2022-05-05 Richland Wisconsin 55103 3951 48
2473469 2473469 2022-05-04 Richland Wisconsin 55103 3949 48
2470212 2470212 2022-05-03 Richland Wisconsin 55103 3937 48
2466956 2466956 2022-05-02 Richland Wisconsin 55103 3935 48
2463701 2463701 2022-05-01 Richland Wisconsin 55103 3921 48
2460445 2460445 2022-04-30 Richland Wisconsin 55103 3921 48
2457189 2457189 2022-04-29 Richland Wisconsin 55103 3921 48
2453933 2453933 2022-04-28 Richland Wisconsin 55103 3908 48
2450677 2450677 2022-04-27 Richland Wisconsin 55103 3905 48
2447421 2447421 2022-04-26 Richland Wisconsin 55103 3898 48
2444165 2444165 2022-04-25 Richland Wisconsin 55103 3890 48
2440909 2440909 2022-04-24 Richland Wisconsin 55103 3882 48
2437653 2437653 2022-04-23 Richland Wisconsin 55103 3882 48
2434397 2434397 2022-04-22 Richland Wisconsin 55103 3882 48
2431141 2431141 2022-04-21 Richland Wisconsin 55103 3876 48
2427885 2427885 2022-04-20 Richland Wisconsin 55103 3872 48
2424629 2424629 2022-04-19 Richland Wisconsin 55103 3865 48
2421373 2421373 2022-04-18 Richland Wisconsin 55103 3865 48
2418117 2418117 2022-04-17 Richland Wisconsin 55103 3863 48
2414861 2414861 2022-04-16 Richland Wisconsin 55103 3863 48
2411605 2411605 2022-04-15 Richland Wisconsin 55103 3863 48
2408349 2408349 2022-04-14 Richland Wisconsin 55103 3861 48
2405093 2405093 2022-04-13 Richland Wisconsin 55103 3859 48
2401838 2401838 2022-04-12 Richland Wisconsin 55103 3857 48
2398583 2398583 2022-04-11 Richland Wisconsin 55103 3857 47
2395328 2395328 2022-04-10 Richland Wisconsin 55103 3853 47
2392072 2392072 2022-04-09 Richland Wisconsin 55103 3853 47
2388816 2388816 2022-04-08 Richland Wisconsin 55103 3853 47
2385561 2385561 2022-04-07 Richland Wisconsin 55103 3849 47
2382306 2382306 2022-04-06 Richland Wisconsin 55103 3847 47
2379051 2379051 2022-04-05 Richland Wisconsin 55103 3846 47
2375797 2375797 2022-04-04 Richland Wisconsin 55103 3845 47
2372545 2372545 2022-04-03 Richland Wisconsin 55103 3842 47
2369292 2369292 2022-04-02 Richland Wisconsin 55103 3842 47
2366039 2366039 2022-04-01 Richland Wisconsin 55103 3842 47
2362786 2362786 2022-03-31 Richland Wisconsin 55103 3842 47
2359532 2359532 2022-03-30 Richland Wisconsin 55103 3837 47
2356278 2356278 2022-03-29 Richland Wisconsin 55103 3837 47
2353025 2353025 2022-03-28 Richland Wisconsin 55103 3835 47
2349773 2349773 2022-03-27 Richland Wisconsin 55103 3831 46
2346520 2346520 2022-03-26 Richland Wisconsin 55103 3831 46
2343267 2343267 2022-03-25 Richland Wisconsin 55103 3831 46
2340014 2340014 2022-03-24 Richland Wisconsin 55103 3830 46
2336761 2336761 2022-03-23 Richland Wisconsin 55103 3828 45
2333507 2333507 2022-03-22 Richland Wisconsin 55103 3826 45
2330253 2330253 2022-03-21 Richland Wisconsin 55103 3825 45
2327001 2327001 2022-03-20 Richland Wisconsin 55103 3822 45
2323748 2323748 2022-03-19 Richland Wisconsin 55103 3822 45
2320494 2320494 2022-03-18 Richland Wisconsin 55103 3822 45
2317240 2317240 2022-03-17 Richland Wisconsin 55103 3818 45
2313987 2313987 2022-03-16 Richland Wisconsin 55103 3815 45
2310734 2310734 2022-03-15 Richland Wisconsin 55103 3814 45
2307481 2307481 2022-03-14 Richland Wisconsin 55103 3811 45
2304230 2304230 2022-03-13 Richland Wisconsin 55103 3806 45
2300978 2300978 2022-03-12 Richland Wisconsin 55103 3806 45
2297726 2297726 2022-03-11 Richland Wisconsin 55103 3806 45
2294474 2294474 2022-03-10 Richland Wisconsin 55103 3805 45
2291222 2291222 2022-03-09 Richland Wisconsin 55103 3801 44
2287970 2287970 2022-03-08 Richland Wisconsin 55103 3798 44
2284718 2284718 2022-03-07 Richland Wisconsin 55103 3796 44
2281466 2281466 2022-03-06 Richland Wisconsin 55103 3790 44
2278213 2278213 2022-03-05 Richland Wisconsin 55103 3790 44
2274960 2274960 2022-03-04 Richland Wisconsin 55103 3790 44
2271707 2271707 2022-03-03 Richland Wisconsin 55103 3790 44
2268455 2268455 2022-03-02 Richland Wisconsin 55103 3788 43
2265202 2265202 2022-03-01 Richland Wisconsin 55103 3786 43
2261952 2261952 2022-02-28 Richland Wisconsin 55103 3785 43
2258701 2258701 2022-02-27 Richland Wisconsin 55103 3784 43
2255450 2255450 2022-02-26 Richland Wisconsin 55103 3784 43
2252199 2252199 2022-02-25 Richland Wisconsin 55103 3784 43
2248948 2248948 2022-02-24 Richland Wisconsin 55103 3784 42
2245697 2245697 2022-02-23 Richland Wisconsin 55103 3783 42
2242446 2242446 2022-02-22 Richland Wisconsin 55103 3779 41
2239195 2239195 2022-02-21 Richland Wisconsin 55103 3777 41
2235944 2235944 2022-02-20 Richland Wisconsin 55103 3773 41
2232693 2232693 2022-02-19 Richland Wisconsin 55103 3773 41
2229442 2229442 2022-02-18 Richland Wisconsin 55103 3773 41
2226191 2226191 2022-02-17 Richland Wisconsin 55103 3770 40
2222940 2222940 2022-02-16 Richland Wisconsin 55103 3761 40
2219689 2219689 2022-02-15 Richland Wisconsin 55103 3754 40
2216439 2216439 2022-02-14 Richland Wisconsin 55103 3751 39
2213188 2213188 2022-02-13 Richland Wisconsin 55103 3734 39
2209935 2209935 2022-02-12 Richland Wisconsin 55103 3734 39
2206682 2206682 2022-02-11 Richland Wisconsin 55103 3734 39
2203429 2203429 2022-02-10 Richland Wisconsin 55103 3727 39
2200175 2200175 2022-02-09 Richland Wisconsin 55103 3718 39
2196921 2196921 2022-02-08 Richland Wisconsin 55103 3706 39
2193666 2193666 2022-02-07 Richland Wisconsin 55103 3704 39
2190413 2190413 2022-02-06 Richland Wisconsin 55103 3682 39
2187160 2187160 2022-02-05 Richland Wisconsin 55103 3682 39
2183907 2183907 2022-02-04 Richland Wisconsin 55103 3682 39
2180655 2180655 2022-02-03 Richland Wisconsin 55103 3672 39

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