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 = "St. Croix" 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 · 785 ✖

fips 1

county 1

  • St. Croix · 785 ✖
Link rowid date ▲ county state fips cases deaths
2502797 2502797 2022-05-13 St. Croix Wisconsin 55109 25656 149
2499539 2499539 2022-05-12 St. Croix Wisconsin 55109 25600 149
2496281 2496281 2022-05-11 St. Croix Wisconsin 55109 25553 149
2493023 2493023 2022-05-10 St. Croix Wisconsin 55109 25505 149
2489765 2489765 2022-05-09 St. Croix Wisconsin 55109 25376 149
2486508 2486508 2022-05-08 St. Croix Wisconsin 55109 25293 149
2483250 2483250 2022-05-07 St. Croix Wisconsin 55109 25293 149
2479992 2479992 2022-05-06 St. Croix Wisconsin 55109 25293 149
2476734 2476734 2022-05-05 St. Croix Wisconsin 55109 25254 148
2473476 2473476 2022-05-04 St. Croix Wisconsin 55109 25176 148
2470219 2470219 2022-05-03 St. Croix Wisconsin 55109 25144 149
2466963 2466963 2022-05-02 St. Croix Wisconsin 55109 25125 148
2463708 2463708 2022-05-01 St. Croix Wisconsin 55109 25070 148
2460452 2460452 2022-04-30 St. Croix Wisconsin 55109 25070 148
2457196 2457196 2022-04-29 St. Croix Wisconsin 55109 25070 148
2453940 2453940 2022-04-28 St. Croix Wisconsin 55109 25038 148
2450684 2450684 2022-04-27 St. Croix Wisconsin 55109 25013 148
2447428 2447428 2022-04-26 St. Croix Wisconsin 55109 24983 148
2444172 2444172 2022-04-25 St. Croix Wisconsin 55109 24954 148
2440916 2440916 2022-04-24 St. Croix Wisconsin 55109 24917 148
2437660 2437660 2022-04-23 St. Croix Wisconsin 55109 24917 148
2434404 2434404 2022-04-22 St. Croix Wisconsin 55109 24917 148
2431148 2431148 2022-04-21 St. Croix Wisconsin 55109 24889 148
2427892 2427892 2022-04-20 St. Croix Wisconsin 55109 24873 148
2424636 2424636 2022-04-19 St. Croix Wisconsin 55109 24860 148
2421380 2421380 2022-04-18 St. Croix Wisconsin 55109 24830 148
2418124 2418124 2022-04-17 St. Croix Wisconsin 55109 24780 148
2414868 2414868 2022-04-16 St. Croix Wisconsin 55109 24780 148
2411612 2411612 2022-04-15 St. Croix Wisconsin 55109 24780 148
2408356 2408356 2022-04-14 St. Croix Wisconsin 55109 24749 148
2405100 2405100 2022-04-13 St. Croix Wisconsin 55109 24733 147
2401845 2401845 2022-04-12 St. Croix Wisconsin 55109 24714 147
2398590 2398590 2022-04-11 St. Croix Wisconsin 55109 24688 147
2395335 2395335 2022-04-10 St. Croix Wisconsin 55109 24665 147
2392079 2392079 2022-04-09 St. Croix Wisconsin 55109 24665 147
2388823 2388823 2022-04-08 St. Croix Wisconsin 55109 24665 147
2385568 2385568 2022-04-07 St. Croix Wisconsin 55109 24635 147
2382313 2382313 2022-04-06 St. Croix Wisconsin 55109 24611 147
2379058 2379058 2022-04-05 St. Croix Wisconsin 55109 24601 147
2375804 2375804 2022-04-04 St. Croix Wisconsin 55109 24580 147
2372552 2372552 2022-04-03 St. Croix Wisconsin 55109 24558 147
2369299 2369299 2022-04-02 St. Croix Wisconsin 55109 24558 147
2366046 2366046 2022-04-01 St. Croix Wisconsin 55109 24558 147
2362793 2362793 2022-03-31 St. Croix Wisconsin 55109 24547 146
2359539 2359539 2022-03-30 St. Croix Wisconsin 55109 24526 146
2356285 2356285 2022-03-29 St. Croix Wisconsin 55109 24515 146
2353032 2353032 2022-03-28 St. Croix Wisconsin 55109 24496 146
2349780 2349780 2022-03-27 St. Croix Wisconsin 55109 24482 146
2346527 2346527 2022-03-26 St. Croix Wisconsin 55109 24482 146
2343274 2343274 2022-03-25 St. Croix Wisconsin 55109 24482 146
2340021 2340021 2022-03-24 St. Croix Wisconsin 55109 24464 145
2336768 2336768 2022-03-23 St. Croix Wisconsin 55109 24446 145
2333514 2333514 2022-03-22 St. Croix Wisconsin 55109 24438 145
2330260 2330260 2022-03-21 St. Croix Wisconsin 55109 24422 144
2327008 2327008 2022-03-20 St. Croix Wisconsin 55109 24399 144
2323755 2323755 2022-03-19 St. Croix Wisconsin 55109 24399 144
2320501 2320501 2022-03-18 St. Croix Wisconsin 55109 24399 144
2317247 2317247 2022-03-17 St. Croix Wisconsin 55109 24388 144
2313994 2313994 2022-03-16 St. Croix Wisconsin 55109 24362 144
2310741 2310741 2022-03-15 St. Croix Wisconsin 55109 24348 144
2307488 2307488 2022-03-14 St. Croix Wisconsin 55109 24342 144
2304237 2304237 2022-03-13 St. Croix Wisconsin 55109 24327 143
2300985 2300985 2022-03-12 St. Croix Wisconsin 55109 24327 143
2297733 2297733 2022-03-11 St. Croix Wisconsin 55109 24327 143
2294481 2294481 2022-03-10 St. Croix Wisconsin 55109 24324 143
2291229 2291229 2022-03-09 St. Croix Wisconsin 55109 24313 143
2287977 2287977 2022-03-08 St. Croix Wisconsin 55109 24294 143
2284725 2284725 2022-03-07 St. Croix Wisconsin 55109 24288 143
2281473 2281473 2022-03-06 St. Croix Wisconsin 55109 24279 142
2278220 2278220 2022-03-05 St. Croix Wisconsin 55109 24279 142
2274967 2274967 2022-03-04 St. Croix Wisconsin 55109 24279 142
2271714 2271714 2022-03-03 St. Croix Wisconsin 55109 24256 142
2268462 2268462 2022-03-02 St. Croix Wisconsin 55109 24240 141
2265209 2265209 2022-03-01 St. Croix Wisconsin 55109 24206 140
2261959 2261959 2022-02-28 St. Croix Wisconsin 55109 24186 140
2258708 2258708 2022-02-27 St. Croix Wisconsin 55109 24159 139
2255457 2255457 2022-02-26 St. Croix Wisconsin 55109 24159 139
2252206 2252206 2022-02-25 St. Croix Wisconsin 55109 24159 139
2248955 2248955 2022-02-24 St. Croix Wisconsin 55109 24120 138
2245704 2245704 2022-02-23 St. Croix Wisconsin 55109 24102 138
2242453 2242453 2022-02-22 St. Croix Wisconsin 55109 24068 137
2239202 2239202 2022-02-21 St. Croix Wisconsin 55109 24043 137
2235951 2235951 2022-02-20 St. Croix Wisconsin 55109 24001 136
2232700 2232700 2022-02-19 St. Croix Wisconsin 55109 24001 136
2229449 2229449 2022-02-18 St. Croix Wisconsin 55109 24001 136
2226198 2226198 2022-02-17 St. Croix Wisconsin 55109 23978 136
2222947 2222947 2022-02-16 St. Croix Wisconsin 55109 23938 136
2219696 2219696 2022-02-15 St. Croix Wisconsin 55109 23902 136
2216446 2216446 2022-02-14 St. Croix Wisconsin 55109 23874 136
2213195 2213195 2022-02-13 St. Croix Wisconsin 55109 23789 136
2209942 2209942 2022-02-12 St. Croix Wisconsin 55109 23789 136
2206689 2206689 2022-02-11 St. Croix Wisconsin 55109 23789 136
2203436 2203436 2022-02-10 St. Croix Wisconsin 55109 23765 136
2200182 2200182 2022-02-09 St. Croix Wisconsin 55109 23709 135
2196928 2196928 2022-02-08 St. Croix Wisconsin 55109 23674 133
2193673 2193673 2022-02-07 St. Croix Wisconsin 55109 23636 134
2190420 2190420 2022-02-06 St. Croix Wisconsin 55109 23502 134
2187167 2187167 2022-02-05 St. Croix Wisconsin 55109 23502 134
2183914 2183914 2022-02-04 St. Croix Wisconsin 55109 23502 134
2180662 2180662 2022-02-03 St. Croix Wisconsin 55109 23431 133

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