ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Iowa" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502762 | 2502762 | 2022-05-13 | Iowa | Wisconsin | 55049 | 5424 | 29 |
2499504 | 2499504 | 2022-05-12 | Iowa | Wisconsin | 55049 | 5420 | 29 |
2496246 | 2496246 | 2022-05-11 | Iowa | Wisconsin | 55049 | 5406 | 29 |
2492988 | 2492988 | 2022-05-10 | Iowa | Wisconsin | 55049 | 5394 | 28 |
2489730 | 2489730 | 2022-05-09 | Iowa | Wisconsin | 55049 | 5385 | 28 |
2486473 | 2486473 | 2022-05-08 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2483215 | 2483215 | 2022-05-07 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2479957 | 2479957 | 2022-05-06 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2476699 | 2476699 | 2022-05-05 | Iowa | Wisconsin | 55049 | 5355 | 28 |
2473441 | 2473441 | 2022-05-04 | Iowa | Wisconsin | 55049 | 5339 | 28 |
2470184 | 2470184 | 2022-05-03 | Iowa | Wisconsin | 55049 | 5326 | 28 |
2466928 | 2466928 | 2022-05-02 | Iowa | Wisconsin | 55049 | 5323 | 28 |
2463673 | 2463673 | 2022-05-01 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2460417 | 2460417 | 2022-04-30 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2457161 | 2457161 | 2022-04-29 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2453905 | 2453905 | 2022-04-28 | Iowa | Wisconsin | 55049 | 5310 | 28 |
2450649 | 2450649 | 2022-04-27 | Iowa | Wisconsin | 55049 | 5299 | 28 |
2447393 | 2447393 | 2022-04-26 | Iowa | Wisconsin | 55049 | 5286 | 28 |
2444137 | 2444137 | 2022-04-25 | Iowa | Wisconsin | 55049 | 5280 | 28 |
2440881 | 2440881 | 2022-04-24 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2437625 | 2437625 | 2022-04-23 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2434369 | 2434369 | 2022-04-22 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2431113 | 2431113 | 2022-04-21 | Iowa | Wisconsin | 55049 | 5271 | 28 |
2427857 | 2427857 | 2022-04-20 | Iowa | Wisconsin | 55049 | 5267 | 28 |
2424601 | 2424601 | 2022-04-19 | Iowa | Wisconsin | 55049 | 5264 | 28 |
2421345 | 2421345 | 2022-04-18 | Iowa | Wisconsin | 55049 | 5264 | 28 |
2418089 | 2418089 | 2022-04-17 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2414833 | 2414833 | 2022-04-16 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2411577 | 2411577 | 2022-04-15 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2408321 | 2408321 | 2022-04-14 | Iowa | Wisconsin | 55049 | 5256 | 28 |
2405065 | 2405065 | 2022-04-13 | Iowa | Wisconsin | 55049 | 5255 | 28 |
2401810 | 2401810 | 2022-04-12 | Iowa | Wisconsin | 55049 | 5254 | 28 |
2398555 | 2398555 | 2022-04-11 | Iowa | Wisconsin | 55049 | 5250 | 28 |
2395300 | 2395300 | 2022-04-10 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2392044 | 2392044 | 2022-04-09 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2388788 | 2388788 | 2022-04-08 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2385533 | 2385533 | 2022-04-07 | Iowa | Wisconsin | 55049 | 5242 | 28 |
2382278 | 2382278 | 2022-04-06 | Iowa | Wisconsin | 55049 | 5241 | 28 |
2379023 | 2379023 | 2022-04-05 | Iowa | Wisconsin | 55049 | 5237 | 28 |
2375769 | 2375769 | 2022-04-04 | Iowa | Wisconsin | 55049 | 5232 | 28 |
2372517 | 2372517 | 2022-04-03 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2369264 | 2369264 | 2022-04-02 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2366011 | 2366011 | 2022-04-01 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2362758 | 2362758 | 2022-03-31 | Iowa | Wisconsin | 55049 | 5226 | 28 |
2359504 | 2359504 | 2022-03-30 | Iowa | Wisconsin | 55049 | 5226 | 28 |
2356250 | 2356250 | 2022-03-29 | Iowa | Wisconsin | 55049 | 5221 | 27 |
2352997 | 2352997 | 2022-03-28 | Iowa | Wisconsin | 55049 | 5214 | 27 |
2349745 | 2349745 | 2022-03-27 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2346492 | 2346492 | 2022-03-26 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2343239 | 2343239 | 2022-03-25 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2339986 | 2339986 | 2022-03-24 | Iowa | Wisconsin | 55049 | 5206 | 26 |
2336733 | 2336733 | 2022-03-23 | Iowa | Wisconsin | 55049 | 5203 | 26 |
2333479 | 2333479 | 2022-03-22 | Iowa | Wisconsin | 55049 | 5201 | 26 |
2330225 | 2330225 | 2022-03-21 | Iowa | Wisconsin | 55049 | 5201 | 26 |
2326973 | 2326973 | 2022-03-20 | Iowa | Wisconsin | 55049 | 5195 | 26 |
2323720 | 2323720 | 2022-03-19 | Iowa | Wisconsin | 55049 | 5195 | 26 |
2320466 | 2320466 | 2022-03-18 | Iowa | Wisconsin | 55049 | 5195 | 26 |
2317212 | 2317212 | 2022-03-17 | Iowa | Wisconsin | 55049 | 5194 | 26 |
2313959 | 2313959 | 2022-03-16 | Iowa | Wisconsin | 55049 | 5189 | 26 |
2310706 | 2310706 | 2022-03-15 | Iowa | Wisconsin | 55049 | 5188 | 26 |
2307453 | 2307453 | 2022-03-14 | Iowa | Wisconsin | 55049 | 5186 | 26 |
2304202 | 2304202 | 2022-03-13 | Iowa | Wisconsin | 55049 | 5185 | 26 |
2300950 | 2300950 | 2022-03-12 | Iowa | Wisconsin | 55049 | 5185 | 26 |
2297698 | 2297698 | 2022-03-11 | Iowa | Wisconsin | 55049 | 5185 | 26 |
2294446 | 2294446 | 2022-03-10 | Iowa | Wisconsin | 55049 | 5184 | 26 |
2291194 | 2291194 | 2022-03-09 | Iowa | Wisconsin | 55049 | 5183 | 26 |
2287942 | 2287942 | 2022-03-08 | Iowa | Wisconsin | 55049 | 5180 | 25 |
2284690 | 2284690 | 2022-03-07 | Iowa | Wisconsin | 55049 | 5178 | 25 |
2281438 | 2281438 | 2022-03-06 | Iowa | Wisconsin | 55049 | 5174 | 25 |
2278185 | 2278185 | 2022-03-05 | Iowa | Wisconsin | 55049 | 5174 | 25 |
2274932 | 2274932 | 2022-03-04 | Iowa | Wisconsin | 55049 | 5174 | 25 |
2271679 | 2271679 | 2022-03-03 | Iowa | Wisconsin | 55049 | 5171 | 25 |
2268427 | 2268427 | 2022-03-02 | Iowa | Wisconsin | 55049 | 5167 | 25 |
2265174 | 2265174 | 2022-03-01 | Iowa | Wisconsin | 55049 | 5159 | 25 |
2261924 | 2261924 | 2022-02-28 | Iowa | Wisconsin | 55049 | 5156 | 25 |
2258673 | 2258673 | 2022-02-27 | Iowa | Wisconsin | 55049 | 5150 | 25 |
2255422 | 2255422 | 2022-02-26 | Iowa | Wisconsin | 55049 | 5150 | 25 |
2252171 | 2252171 | 2022-02-25 | Iowa | Wisconsin | 55049 | 5150 | 25 |
2248920 | 2248920 | 2022-02-24 | Iowa | Wisconsin | 55049 | 5147 | 25 |
2245669 | 2245669 | 2022-02-23 | Iowa | Wisconsin | 55049 | 5143 | 25 |
2242418 | 2242418 | 2022-02-22 | Iowa | Wisconsin | 55049 | 5138 | 25 |
2239167 | 2239167 | 2022-02-21 | Iowa | Wisconsin | 55049 | 5135 | 25 |
2235916 | 2235916 | 2022-02-20 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2232665 | 2232665 | 2022-02-19 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2229414 | 2229414 | 2022-02-18 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2226163 | 2226163 | 2022-02-17 | Iowa | Wisconsin | 55049 | 5109 | 25 |
2222912 | 2222912 | 2022-02-16 | Iowa | Wisconsin | 55049 | 5099 | 25 |
2219661 | 2219661 | 2022-02-15 | Iowa | Wisconsin | 55049 | 5087 | 25 |
2216411 | 2216411 | 2022-02-14 | Iowa | Wisconsin | 55049 | 5081 | 25 |
2213160 | 2213160 | 2022-02-13 | Iowa | Wisconsin | 55049 | 5056 | 25 |
2209907 | 2209907 | 2022-02-12 | Iowa | Wisconsin | 55049 | 5056 | 25 |
2206654 | 2206654 | 2022-02-11 | Iowa | Wisconsin | 55049 | 5056 | 25 |
2203401 | 2203401 | 2022-02-10 | Iowa | Wisconsin | 55049 | 5043 | 25 |
2200147 | 2200147 | 2022-02-09 | Iowa | Wisconsin | 55049 | 5023 | 25 |
2196893 | 2196893 | 2022-02-08 | Iowa | Wisconsin | 55049 | 5001 | 25 |
2193638 | 2193638 | 2022-02-07 | Iowa | Wisconsin | 55049 | 4993 | 25 |
2190385 | 2190385 | 2022-02-06 | Iowa | Wisconsin | 55049 | 4949 | 24 |
2187132 | 2187132 | 2022-02-05 | Iowa | Wisconsin | 55049 | 4949 | 24 |
2183879 | 2183879 | 2022-02-04 | Iowa | Wisconsin | 55049 | 4949 | 24 |
2180627 | 2180627 | 2022-02-03 | Iowa | Wisconsin | 55049 | 4936 | 24 |
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);