ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Waupaca" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502806 | 2502806 | 2022-05-13 | Waupaca | Wisconsin | 55135 | 13835 | 252 |
2499548 | 2499548 | 2022-05-12 | Waupaca | Wisconsin | 55135 | 13807 | 252 |
2496290 | 2496290 | 2022-05-11 | Waupaca | Wisconsin | 55135 | 13786 | 252 |
2493032 | 2493032 | 2022-05-10 | Waupaca | Wisconsin | 55135 | 13774 | 252 |
2489774 | 2489774 | 2022-05-09 | Waupaca | Wisconsin | 55135 | 13762 | 252 |
2486517 | 2486517 | 2022-05-08 | Waupaca | Wisconsin | 55135 | 13732 | 252 |
2483259 | 2483259 | 2022-05-07 | Waupaca | Wisconsin | 55135 | 13732 | 252 |
2480001 | 2480001 | 2022-05-06 | Waupaca | Wisconsin | 55135 | 13732 | 252 |
2476743 | 2476743 | 2022-05-05 | Waupaca | Wisconsin | 55135 | 13722 | 252 |
2473485 | 2473485 | 2022-05-04 | Waupaca | Wisconsin | 55135 | 13707 | 252 |
2470228 | 2470228 | 2022-05-03 | Waupaca | Wisconsin | 55135 | 13694 | 252 |
2466972 | 2466972 | 2022-05-02 | Waupaca | Wisconsin | 55135 | 13686 | 252 |
2463717 | 2463717 | 2022-05-01 | Waupaca | Wisconsin | 55135 | 13669 | 252 |
2460461 | 2460461 | 2022-04-30 | Waupaca | Wisconsin | 55135 | 13669 | 252 |
2457205 | 2457205 | 2022-04-29 | Waupaca | Wisconsin | 55135 | 13669 | 252 |
2453949 | 2453949 | 2022-04-28 | Waupaca | Wisconsin | 55135 | 13663 | 252 |
2450693 | 2450693 | 2022-04-27 | Waupaca | Wisconsin | 55135 | 13661 | 251 |
2447437 | 2447437 | 2022-04-26 | Waupaca | Wisconsin | 55135 | 13658 | 251 |
2444181 | 2444181 | 2022-04-25 | Waupaca | Wisconsin | 55135 | 13655 | 251 |
2440925 | 2440925 | 2022-04-24 | Waupaca | Wisconsin | 55135 | 13648 | 251 |
2437669 | 2437669 | 2022-04-23 | Waupaca | Wisconsin | 55135 | 13648 | 251 |
2434413 | 2434413 | 2022-04-22 | Waupaca | Wisconsin | 55135 | 13648 | 251 |
2431157 | 2431157 | 2022-04-21 | Waupaca | Wisconsin | 55135 | 13647 | 251 |
2427901 | 2427901 | 2022-04-20 | Waupaca | Wisconsin | 55135 | 13644 | 251 |
2424645 | 2424645 | 2022-04-19 | Waupaca | Wisconsin | 55135 | 13635 | 251 |
2421389 | 2421389 | 2022-04-18 | Waupaca | Wisconsin | 55135 | 13637 | 251 |
2418133 | 2418133 | 2022-04-17 | Waupaca | Wisconsin | 55135 | 13631 | 251 |
2414877 | 2414877 | 2022-04-16 | Waupaca | Wisconsin | 55135 | 13631 | 251 |
2411621 | 2411621 | 2022-04-15 | Waupaca | Wisconsin | 55135 | 13631 | 251 |
2408365 | 2408365 | 2022-04-14 | Waupaca | Wisconsin | 55135 | 13630 | 251 |
2405109 | 2405109 | 2022-04-13 | Waupaca | Wisconsin | 55135 | 13631 | 251 |
2401854 | 2401854 | 2022-04-12 | Waupaca | Wisconsin | 55135 | 13628 | 251 |
2398599 | 2398599 | 2022-04-11 | Waupaca | Wisconsin | 55135 | 13627 | 251 |
2395344 | 2395344 | 2022-04-10 | Waupaca | Wisconsin | 55135 | 13624 | 251 |
2392088 | 2392088 | 2022-04-09 | Waupaca | Wisconsin | 55135 | 13624 | 251 |
2388832 | 2388832 | 2022-04-08 | Waupaca | Wisconsin | 55135 | 13624 | 251 |
2385577 | 2385577 | 2022-04-07 | Waupaca | Wisconsin | 55135 | 13616 | 251 |
2382322 | 2382322 | 2022-04-06 | Waupaca | Wisconsin | 55135 | 13612 | 251 |
2379067 | 2379067 | 2022-04-05 | Waupaca | Wisconsin | 55135 | 13610 | 251 |
2375813 | 2375813 | 2022-04-04 | Waupaca | Wisconsin | 55135 | 13609 | 250 |
2372561 | 2372561 | 2022-04-03 | Waupaca | Wisconsin | 55135 | 13602 | 250 |
2369308 | 2369308 | 2022-04-02 | Waupaca | Wisconsin | 55135 | 13602 | 250 |
2366055 | 2366055 | 2022-04-01 | Waupaca | Wisconsin | 55135 | 13602 | 250 |
2362802 | 2362802 | 2022-03-31 | Waupaca | Wisconsin | 55135 | 13602 | 250 |
2359548 | 2359548 | 2022-03-30 | Waupaca | Wisconsin | 55135 | 13601 | 250 |
2356294 | 2356294 | 2022-03-29 | Waupaca | Wisconsin | 55135 | 13600 | 250 |
2353041 | 2353041 | 2022-03-28 | Waupaca | Wisconsin | 55135 | 13599 | 250 |
2349789 | 2349789 | 2022-03-27 | Waupaca | Wisconsin | 55135 | 13594 | 250 |
2346536 | 2346536 | 2022-03-26 | Waupaca | Wisconsin | 55135 | 13594 | 250 |
2343283 | 2343283 | 2022-03-25 | Waupaca | Wisconsin | 55135 | 13594 | 250 |
2340030 | 2340030 | 2022-03-24 | Waupaca | Wisconsin | 55135 | 13587 | 249 |
2336777 | 2336777 | 2022-03-23 | Waupaca | Wisconsin | 55135 | 13586 | 249 |
2333523 | 2333523 | 2022-03-22 | Waupaca | Wisconsin | 55135 | 13585 | 249 |
2330269 | 2330269 | 2022-03-21 | Waupaca | Wisconsin | 55135 | 13584 | 249 |
2327017 | 2327017 | 2022-03-20 | Waupaca | Wisconsin | 55135 | 13578 | 249 |
2323764 | 2323764 | 2022-03-19 | Waupaca | Wisconsin | 55135 | 13578 | 249 |
2320510 | 2320510 | 2022-03-18 | Waupaca | Wisconsin | 55135 | 13578 | 249 |
2317256 | 2317256 | 2022-03-17 | Waupaca | Wisconsin | 55135 | 13576 | 248 |
2314003 | 2314003 | 2022-03-16 | Waupaca | Wisconsin | 55135 | 13574 | 248 |
2310750 | 2310750 | 2022-03-15 | Waupaca | Wisconsin | 55135 | 13570 | 247 |
2307497 | 2307497 | 2022-03-14 | Waupaca | Wisconsin | 55135 | 13568 | 247 |
2304246 | 2304246 | 2022-03-13 | Waupaca | Wisconsin | 55135 | 13562 | 247 |
2300994 | 2300994 | 2022-03-12 | Waupaca | Wisconsin | 55135 | 13562 | 247 |
2297742 | 2297742 | 2022-03-11 | Waupaca | Wisconsin | 55135 | 13562 | 247 |
2294490 | 2294490 | 2022-03-10 | Waupaca | Wisconsin | 55135 | 13558 | 247 |
2291238 | 2291238 | 2022-03-09 | Waupaca | Wisconsin | 55135 | 13554 | 246 |
2287986 | 2287986 | 2022-03-08 | Waupaca | Wisconsin | 55135 | 13550 | 246 |
2284734 | 2284734 | 2022-03-07 | Waupaca | Wisconsin | 55135 | 13547 | 246 |
2281482 | 2281482 | 2022-03-06 | Waupaca | Wisconsin | 55135 | 13540 | 246 |
2278229 | 2278229 | 2022-03-05 | Waupaca | Wisconsin | 55135 | 13540 | 246 |
2274976 | 2274976 | 2022-03-04 | Waupaca | Wisconsin | 55135 | 13540 | 246 |
2271723 | 2271723 | 2022-03-03 | Waupaca | Wisconsin | 55135 | 13537 | 246 |
2268471 | 2268471 | 2022-03-02 | Waupaca | Wisconsin | 55135 | 13536 | 246 |
2265218 | 2265218 | 2022-03-01 | Waupaca | Wisconsin | 55135 | 13531 | 246 |
2261968 | 2261968 | 2022-02-28 | Waupaca | Wisconsin | 55135 | 13523 | 246 |
2258717 | 2258717 | 2022-02-27 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2255466 | 2255466 | 2022-02-26 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2252215 | 2252215 | 2022-02-25 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2248964 | 2248964 | 2022-02-24 | Waupaca | Wisconsin | 55135 | 13504 | 243 |
2245713 | 2245713 | 2022-02-23 | Waupaca | Wisconsin | 55135 | 13496 | 243 |
2242462 | 2242462 | 2022-02-22 | Waupaca | Wisconsin | 55135 | 13491 | 242 |
2239211 | 2239211 | 2022-02-21 | Waupaca | Wisconsin | 55135 | 13479 | 241 |
2235960 | 2235960 | 2022-02-20 | Waupaca | Wisconsin | 55135 | 13459 | 241 |
2232709 | 2232709 | 2022-02-19 | Waupaca | Wisconsin | 55135 | 13459 | 241 |
2229458 | 2229458 | 2022-02-18 | Waupaca | Wisconsin | 55135 | 13459 | 241 |
2226207 | 2226207 | 2022-02-17 | Waupaca | Wisconsin | 55135 | 13436 | 241 |
2222956 | 2222956 | 2022-02-16 | Waupaca | Wisconsin | 55135 | 13426 | 240 |
2219705 | 2219705 | 2022-02-15 | Waupaca | Wisconsin | 55135 | 13415 | 240 |
2216455 | 2216455 | 2022-02-14 | Waupaca | Wisconsin | 55135 | 13390 | 239 |
2213204 | 2213204 | 2022-02-13 | Waupaca | Wisconsin | 55135 | 13365 | 237 |
2209951 | 2209951 | 2022-02-12 | Waupaca | Wisconsin | 55135 | 13365 | 237 |
2206698 | 2206698 | 2022-02-11 | Waupaca | Wisconsin | 55135 | 13365 | 237 |
2203445 | 2203445 | 2022-02-10 | Waupaca | Wisconsin | 55135 | 13352 | 237 |
2200191 | 2200191 | 2022-02-09 | Waupaca | Wisconsin | 55135 | 13319 | 236 |
2196937 | 2196937 | 2022-02-08 | Waupaca | Wisconsin | 55135 | 13296 | 236 |
2193682 | 2193682 | 2022-02-07 | Waupaca | Wisconsin | 55135 | 13269 | 236 |
2190429 | 2190429 | 2022-02-06 | Waupaca | Wisconsin | 55135 | 13216 | 236 |
2187176 | 2187176 | 2022-02-05 | Waupaca | Wisconsin | 55135 | 13216 | 236 |
2183923 | 2183923 | 2022-02-04 | Waupaca | Wisconsin | 55135 | 13216 | 236 |
2180671 | 2180671 | 2022-02-03 | Waupaca | Wisconsin | 55135 | 13180 | 236 |
Advanced export
JSON shape: default, array, newline-delimited
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);