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

773 rows where county = "Crawford" 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 · 773 ✖

fips 1

county 1

  • Crawford · 773 ✖
Link rowid date ▲ county state fips cases deaths
2502749 2502749 2022-05-13 Crawford Wisconsin 55023 4299 28
2499491 2499491 2022-05-12 Crawford Wisconsin 55023 4291 28
2496233 2496233 2022-05-11 Crawford Wisconsin 55023 4286 28
2492975 2492975 2022-05-10 Crawford Wisconsin 55023 4281 28
2489717 2489717 2022-05-09 Crawford Wisconsin 55023 4276 28
2486460 2486460 2022-05-08 Crawford Wisconsin 55023 4271 28
2483202 2483202 2022-05-07 Crawford Wisconsin 55023 4271 28
2479944 2479944 2022-05-06 Crawford Wisconsin 55023 4271 28
2476686 2476686 2022-05-05 Crawford Wisconsin 55023 4269 28
2473428 2473428 2022-05-04 Crawford Wisconsin 55023 4267 28
2470171 2470171 2022-05-03 Crawford Wisconsin 55023 4263 28
2466915 2466915 2022-05-02 Crawford Wisconsin 55023 4261 28
2463660 2463660 2022-05-01 Crawford Wisconsin 55023 4257 28
2460404 2460404 2022-04-30 Crawford Wisconsin 55023 4257 28
2457148 2457148 2022-04-29 Crawford Wisconsin 55023 4257 28
2453892 2453892 2022-04-28 Crawford Wisconsin 55023 4252 28
2450636 2450636 2022-04-27 Crawford Wisconsin 55023 4250 28
2447380 2447380 2022-04-26 Crawford Wisconsin 55023 4247 28
2444124 2444124 2022-04-25 Crawford Wisconsin 55023 4246 28
2440868 2440868 2022-04-24 Crawford Wisconsin 55023 4243 28
2437612 2437612 2022-04-23 Crawford Wisconsin 55023 4243 28
2434356 2434356 2022-04-22 Crawford Wisconsin 55023 4243 28
2431100 2431100 2022-04-21 Crawford Wisconsin 55023 4240 28
2427844 2427844 2022-04-20 Crawford Wisconsin 55023 4239 28
2424588 2424588 2022-04-19 Crawford Wisconsin 55023 4238 28
2421332 2421332 2022-04-18 Crawford Wisconsin 55023 4238 28
2418076 2418076 2022-04-17 Crawford Wisconsin 55023 4237 28
2414820 2414820 2022-04-16 Crawford Wisconsin 55023 4237 28
2411564 2411564 2022-04-15 Crawford Wisconsin 55023 4237 28
2408308 2408308 2022-04-14 Crawford Wisconsin 55023 4236 28
2405052 2405052 2022-04-13 Crawford Wisconsin 55023 4236 28
2401797 2401797 2022-04-12 Crawford Wisconsin 55023 4234 28
2398542 2398542 2022-04-11 Crawford Wisconsin 55023 4232 28
2395287 2395287 2022-04-10 Crawford Wisconsin 55023 4230 28
2392031 2392031 2022-04-09 Crawford Wisconsin 55023 4230 28
2388775 2388775 2022-04-08 Crawford Wisconsin 55023 4230 28
2385520 2385520 2022-04-07 Crawford Wisconsin 55023 4230 28
2382265 2382265 2022-04-06 Crawford Wisconsin 55023 4228 28
2379010 2379010 2022-04-05 Crawford Wisconsin 55023 4227 28
2375756 2375756 2022-04-04 Crawford Wisconsin 55023 4227 28
2372504 2372504 2022-04-03 Crawford Wisconsin 55023 4227 28
2369251 2369251 2022-04-02 Crawford Wisconsin 55023 4227 28
2365998 2365998 2022-04-01 Crawford Wisconsin 55023 4227 28
2362745 2362745 2022-03-31 Crawford Wisconsin 55023 4227 28
2359491 2359491 2022-03-30 Crawford Wisconsin 55023 4226 28
2356237 2356237 2022-03-29 Crawford Wisconsin 55023 4224 28
2352984 2352984 2022-03-28 Crawford Wisconsin 55023 4224 28
2349732 2349732 2022-03-27 Crawford Wisconsin 55023 4223 28
2346479 2346479 2022-03-26 Crawford Wisconsin 55023 4223 28
2343226 2343226 2022-03-25 Crawford Wisconsin 55023 4223 28
2339973 2339973 2022-03-24 Crawford Wisconsin 55023 4219 28
2336720 2336720 2022-03-23 Crawford Wisconsin 55023 4218 28
2333466 2333466 2022-03-22 Crawford Wisconsin 55023 4216 28
2330212 2330212 2022-03-21 Crawford Wisconsin 55023 4216 28
2326960 2326960 2022-03-20 Crawford Wisconsin 55023 4216 28
2323707 2323707 2022-03-19 Crawford Wisconsin 55023 4216 28
2320453 2320453 2022-03-18 Crawford Wisconsin 55023 4216 28
2317199 2317199 2022-03-17 Crawford Wisconsin 55023 4216 28
2313946 2313946 2022-03-16 Crawford Wisconsin 55023 4208 28
2310693 2310693 2022-03-15 Crawford Wisconsin 55023 4208 28
2307440 2307440 2022-03-14 Crawford Wisconsin 55023 4208 28
2304189 2304189 2022-03-13 Crawford Wisconsin 55023 4207 28
2300937 2300937 2022-03-12 Crawford Wisconsin 55023 4207 28
2297685 2297685 2022-03-11 Crawford Wisconsin 55023 4207 28
2294433 2294433 2022-03-10 Crawford Wisconsin 55023 4207 28
2291181 2291181 2022-03-09 Crawford Wisconsin 55023 4206 28
2287929 2287929 2022-03-08 Crawford Wisconsin 55023 4205 28
2284677 2284677 2022-03-07 Crawford Wisconsin 55023 4204 28
2281425 2281425 2022-03-06 Crawford Wisconsin 55023 4200 28
2278172 2278172 2022-03-05 Crawford Wisconsin 55023 4200 28
2274919 2274919 2022-03-04 Crawford Wisconsin 55023 4200 28
2271666 2271666 2022-03-03 Crawford Wisconsin 55023 4200 28
2268414 2268414 2022-03-02 Crawford Wisconsin 55023 4198 28
2265161 2265161 2022-03-01 Crawford Wisconsin 55023 4197 28
2261911 2261911 2022-02-28 Crawford Wisconsin 55023 4193 28
2258660 2258660 2022-02-27 Crawford Wisconsin 55023 4186 28
2255409 2255409 2022-02-26 Crawford Wisconsin 55023 4186 28
2252158 2252158 2022-02-25 Crawford Wisconsin 55023 4186 28
2248907 2248907 2022-02-24 Crawford Wisconsin 55023 4181 28
2245656 2245656 2022-02-23 Crawford Wisconsin 55023 4176 28
2242405 2242405 2022-02-22 Crawford Wisconsin 55023 4167 28
2239154 2239154 2022-02-21 Crawford Wisconsin 55023 4165 28
2235903 2235903 2022-02-20 Crawford Wisconsin 55023 4156 28
2232652 2232652 2022-02-19 Crawford Wisconsin 55023 4156 28
2229401 2229401 2022-02-18 Crawford Wisconsin 55023 4156 28
2226150 2226150 2022-02-17 Crawford Wisconsin 55023 4154 28
2222899 2222899 2022-02-16 Crawford Wisconsin 55023 4146 28
2219648 2219648 2022-02-15 Crawford Wisconsin 55023 4129 28
2216398 2216398 2022-02-14 Crawford Wisconsin 55023 4124 28
2213147 2213147 2022-02-13 Crawford Wisconsin 55023 4096 28
2209894 2209894 2022-02-12 Crawford Wisconsin 55023 4096 28
2206641 2206641 2022-02-11 Crawford Wisconsin 55023 4096 28
2203388 2203388 2022-02-10 Crawford Wisconsin 55023 4082 28
2200134 2200134 2022-02-09 Crawford Wisconsin 55023 4072 28
2196880 2196880 2022-02-08 Crawford Wisconsin 55023 4065 28
2193625 2193625 2022-02-07 Crawford Wisconsin 55023 4056 28
2190372 2190372 2022-02-06 Crawford Wisconsin 55023 4031 28
2187119 2187119 2022-02-05 Crawford Wisconsin 55023 4031 28
2183866 2183866 2022-02-04 Crawford Wisconsin 55023 4031 28
2180614 2180614 2022-02-03 Crawford Wisconsin 55023 4021 28

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