ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 55059 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334572 | 334572 | 2020-07-14 | Kenosha | Wisconsin | 55059 | 1809 | 47 |
331379 | 331379 | 2020-07-13 | Kenosha | Wisconsin | 55059 | 1782 | 46 |
328193 | 328193 | 2020-07-12 | Kenosha | Wisconsin | 55059 | 1734 | 46 |
325007 | 325007 | 2020-07-11 | Kenosha | Wisconsin | 55059 | 1717 | 46 |
321826 | 321826 | 2020-07-10 | Kenosha | Wisconsin | 55059 | 1703 | 46 |
318647 | 318647 | 2020-07-09 | Kenosha | Wisconsin | 55059 | 1666 | 44 |
315474 | 315474 | 2020-07-08 | Kenosha | Wisconsin | 55059 | 1628 | 44 |
312299 | 312299 | 2020-07-07 | Kenosha | Wisconsin | 55059 | 1626 | 44 |
309130 | 309130 | 2020-07-06 | Kenosha | Wisconsin | 55059 | 1601 | 44 |
305961 | 305961 | 2020-07-05 | Kenosha | Wisconsin | 55059 | 1586 | 44 |
302797 | 302797 | 2020-07-04 | Kenosha | Wisconsin | 55059 | 1574 | 44 |
299633 | 299633 | 2020-07-03 | Kenosha | Wisconsin | 55059 | 1547 | 44 |
296471 | 296471 | 2020-07-02 | Kenosha | Wisconsin | 55059 | 1535 | 44 |
293316 | 293316 | 2020-07-01 | Kenosha | Wisconsin | 55059 | 1527 | 43 |
290163 | 290163 | 2020-06-30 | Kenosha | Wisconsin | 55059 | 1505 | 43 |
287013 | 287013 | 2020-06-29 | Kenosha | Wisconsin | 55059 | 1492 | 43 |
283867 | 283867 | 2020-06-28 | Kenosha | Wisconsin | 55059 | 1478 | 43 |
280721 | 280721 | 2020-06-27 | Kenosha | Wisconsin | 55059 | 1468 | 43 |
277573 | 277573 | 2020-06-26 | Kenosha | Wisconsin | 55059 | 1455 | 41 |
274425 | 274425 | 2020-06-25 | Kenosha | Wisconsin | 55059 | 1442 | 41 |
271285 | 271285 | 2020-06-24 | Kenosha | Wisconsin | 55059 | 1438 | 41 |
268151 | 268151 | 2020-06-23 | Kenosha | Wisconsin | 55059 | 1425 | 39 |
265022 | 265022 | 2020-06-22 | Kenosha | Wisconsin | 55059 | 1421 | 39 |
261893 | 261893 | 2020-06-21 | Kenosha | Wisconsin | 55059 | 1416 | 39 |
258766 | 258766 | 2020-06-20 | Kenosha | Wisconsin | 55059 | 1406 | 39 |
255639 | 255639 | 2020-06-19 | Kenosha | Wisconsin | 55059 | 1400 | 37 |
252520 | 252520 | 2020-06-18 | Kenosha | Wisconsin | 55059 | 1392 | 36 |
249405 | 249405 | 2020-06-17 | Kenosha | Wisconsin | 55059 | 1385 | 36 |
246293 | 246293 | 2020-06-16 | Kenosha | Wisconsin | 55059 | 1376 | 37 |
243180 | 243180 | 2020-06-15 | Kenosha | Wisconsin | 55059 | 1368 | 36 |
240069 | 240069 | 2020-06-14 | Kenosha | Wisconsin | 55059 | 1356 | 36 |
236961 | 236961 | 2020-06-13 | Kenosha | Wisconsin | 55059 | 1343 | 36 |
233854 | 233854 | 2020-06-12 | Kenosha | Wisconsin | 55059 | 1337 | 36 |
230749 | 230749 | 2020-06-11 | Kenosha | Wisconsin | 55059 | 1319 | 36 |
227645 | 227645 | 2020-06-10 | Kenosha | Wisconsin | 55059 | 1310 | 36 |
224545 | 224545 | 2020-06-09 | Kenosha | Wisconsin | 55059 | 1296 | 36 |
221449 | 221449 | 2020-06-08 | Kenosha | Wisconsin | 55059 | 1290 | 35 |
218357 | 218357 | 2020-06-07 | Kenosha | Wisconsin | 55059 | 1274 | 34 |
215267 | 215267 | 2020-06-06 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
212180 | 212180 | 2020-06-05 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
209095 | 209095 | 2020-06-04 | Kenosha | Wisconsin | 55059 | 1252 | 33 |
206013 | 206013 | 2020-06-03 | Kenosha | Wisconsin | 55059 | 1222 | 30 |
202934 | 202934 | 2020-06-02 | Kenosha | Wisconsin | 55059 | 1201 | 30 |
199858 | 199858 | 2020-06-01 | Kenosha | Wisconsin | 55059 | 1178 | 30 |
196785 | 196785 | 2020-05-31 | Kenosha | Wisconsin | 55059 | 1168 | 30 |
193715 | 193715 | 2020-05-30 | Kenosha | Wisconsin | 55059 | 1165 | 30 |
190649 | 190649 | 2020-05-29 | Kenosha | Wisconsin | 55059 | 1131 | 27 |
187585 | 187585 | 2020-05-28 | Kenosha | Wisconsin | 55059 | 1088 | 25 |
184528 | 184528 | 2020-05-27 | Kenosha | Wisconsin | 55059 | 1033 | 24 |
181477 | 181477 | 2020-05-26 | Kenosha | Wisconsin | 55059 | 1008 | 22 |
178433 | 178433 | 2020-05-25 | Kenosha | Wisconsin | 55059 | 1001 | 22 |
175388 | 175388 | 2020-05-24 | Kenosha | Wisconsin | 55059 | 998 | 22 |
172345 | 172345 | 2020-05-23 | Kenosha | Wisconsin | 55059 | 983 | 22 |
169304 | 169304 | 2020-05-22 | Kenosha | Wisconsin | 55059 | 948 | 22 |
166268 | 166268 | 2020-05-21 | Kenosha | Wisconsin | 55059 | 921 | 21 |
163239 | 163239 | 2020-05-20 | Kenosha | Wisconsin | 55059 | 889 | 21 |
160211 | 160211 | 2020-05-19 | Kenosha | Wisconsin | 55059 | 866 | 19 |
157187 | 157187 | 2020-05-18 | Kenosha | Wisconsin | 55059 | 848 | 18 |
154171 | 154171 | 2020-05-17 | Kenosha | Wisconsin | 55059 | 838 | 18 |
151159 | 151159 | 2020-05-16 | Kenosha | Wisconsin | 55059 | 820 | 18 |
148150 | 148150 | 2020-05-15 | Kenosha | Wisconsin | 55059 | 780 | 17 |
145147 | 145147 | 2020-05-14 | Kenosha | Wisconsin | 55059 | 762 | 17 |
142149 | 142149 | 2020-05-13 | Kenosha | Wisconsin | 55059 | 736 | 17 |
139153 | 139153 | 2020-05-12 | Kenosha | Wisconsin | 55059 | 716 | 16 |
136162 | 136162 | 2020-05-11 | Kenosha | Wisconsin | 55059 | 693 | 16 |
133172 | 133172 | 2020-05-10 | Kenosha | Wisconsin | 55059 | 682 | 15 |
130182 | 130182 | 2020-05-09 | Kenosha | Wisconsin | 55059 | 651 | 15 |
127192 | 127192 | 2020-05-08 | Kenosha | Wisconsin | 55059 | 627 | 15 |
124207 | 124207 | 2020-05-07 | Kenosha | Wisconsin | 55059 | 610 | 14 |
121227 | 121227 | 2020-05-06 | Kenosha | Wisconsin | 55059 | 580 | 14 |
118261 | 118261 | 2020-05-05 | Kenosha | Wisconsin | 55059 | 571 | 14 |
115302 | 115302 | 2020-05-04 | Kenosha | Wisconsin | 55059 | 546 | 14 |
112419 | 112419 | 2020-05-03 | Kenosha | Wisconsin | 55059 | 534 | 14 |
109544 | 109544 | 2020-05-02 | Kenosha | Wisconsin | 55059 | 521 | 13 |
106675 | 106675 | 2020-05-01 | Kenosha | Wisconsin | 55059 | 477 | 13 |
103811 | 103811 | 2020-04-30 | Kenosha | Wisconsin | 55059 | 391 | 12 |
100956 | 100956 | 2020-04-29 | Kenosha | Wisconsin | 55059 | 363 | 11 |
98106 | 98106 | 2020-04-28 | Kenosha | Wisconsin | 55059 | 348 | 9 |
95261 | 95261 | 2020-04-27 | Kenosha | Wisconsin | 55059 | 340 | 7 |
92431 | 92431 | 2020-04-26 | Kenosha | Wisconsin | 55059 | 339 | 7 |
89613 | 89613 | 2020-04-25 | Kenosha | Wisconsin | 55059 | 329 | 7 |
86797 | 86797 | 2020-04-24 | Kenosha | Wisconsin | 55059 | 314 | 7 |
83990 | 83990 | 2020-04-23 | Kenosha | Wisconsin | 55059 | 294 | 6 |
81189 | 81189 | 2020-04-22 | Kenosha | Wisconsin | 55059 | 278 | 6 |
78396 | 78396 | 2020-04-21 | Kenosha | Wisconsin | 55059 | 264 | 6 |
75613 | 75613 | 2020-04-20 | Kenosha | Wisconsin | 55059 | 257 | 5 |
72837 | 72837 | 2020-04-19 | Kenosha | Wisconsin | 55059 | 248 | 5 |
70068 | 70068 | 2020-04-18 | Kenosha | Wisconsin | 55059 | 236 | 5 |
67306 | 67306 | 2020-04-17 | Kenosha | Wisconsin | 55059 | 218 | 5 |
64558 | 64558 | 2020-04-16 | Kenosha | Wisconsin | 55059 | 208 | 5 |
61825 | 61825 | 2020-04-15 | Kenosha | Wisconsin | 55059 | 204 | 4 |
59106 | 59106 | 2020-04-14 | Kenosha | Wisconsin | 55059 | 186 | 3 |
56399 | 56399 | 2020-04-13 | Kenosha | Wisconsin | 55059 | 182 | 4 |
53708 | 53708 | 2020-04-12 | Kenosha | Wisconsin | 55059 | 173 | 2 |
51031 | 51031 | 2020-04-11 | Kenosha | Wisconsin | 55059 | 163 | 1 |
48371 | 48371 | 2020-04-10 | Kenosha | Wisconsin | 55059 | 147 | 1 |
45743 | 45743 | 2020-04-09 | Kenosha | Wisconsin | 55059 | 135 | 1 |
43146 | 43146 | 2020-04-08 | Kenosha | Wisconsin | 55059 | 129 | 1 |
40574 | 40574 | 2020-04-07 | Kenosha | Wisconsin | 55059 | 112 | 1 |
38033 | 38033 | 2020-04-06 | Kenosha | Wisconsin | 55059 | 104 | 1 |
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);