ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 55059 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3748 | 3748 | 2020-03-17 | Kenosha | Wisconsin | 55059 | 4 | 0 |
4385 | 4385 | 2020-03-18 | Kenosha | Wisconsin | 55059 | 4 | 0 |
5148 | 5148 | 2020-03-19 | Kenosha | Wisconsin | 55059 | 4 | 0 |
6059 | 6059 | 2020-03-20 | Kenosha | Wisconsin | 55059 | 4 | 0 |
7092 | 7092 | 2020-03-21 | Kenosha | Wisconsin | 55059 | 5 | 0 |
8230 | 8230 | 2020-03-22 | Kenosha | Wisconsin | 55059 | 10 | 0 |
9456 | 9456 | 2020-03-23 | Kenosha | Wisconsin | 55059 | 12 | 0 |
10810 | 10810 | 2020-03-24 | Kenosha | Wisconsin | 55059 | 13 | 0 |
12340 | 12340 | 2020-03-25 | Kenosha | Wisconsin | 55059 | 14 | 0 |
13994 | 13994 | 2020-03-26 | Kenosha | Wisconsin | 55059 | 19 | 0 |
15767 | 15767 | 2020-03-27 | Kenosha | Wisconsin | 55059 | 24 | 0 |
17647 | 17647 | 2020-03-28 | Kenosha | Wisconsin | 55059 | 24 | 0 |
19616 | 19616 | 2020-03-29 | Kenosha | Wisconsin | 55059 | 30 | 0 |
21687 | 21687 | 2020-03-30 | Kenosha | Wisconsin | 55059 | 30 | 0 |
23839 | 23839 | 2020-03-31 | Kenosha | Wisconsin | 55059 | 37 | 0 |
26059 | 26059 | 2020-04-01 | Kenosha | Wisconsin | 55059 | 54 | 0 |
28352 | 28352 | 2020-04-02 | Kenosha | Wisconsin | 55059 | 67 | 0 |
30707 | 30707 | 2020-04-03 | Kenosha | Wisconsin | 55059 | 81 | 0 |
33108 | 33108 | 2020-04-04 | Kenosha | Wisconsin | 55059 | 93 | 1 |
35547 | 35547 | 2020-04-05 | Kenosha | Wisconsin | 55059 | 98 | 1 |
38033 | 38033 | 2020-04-06 | Kenosha | Wisconsin | 55059 | 104 | 1 |
40574 | 40574 | 2020-04-07 | Kenosha | Wisconsin | 55059 | 112 | 1 |
43146 | 43146 | 2020-04-08 | Kenosha | Wisconsin | 55059 | 129 | 1 |
45743 | 45743 | 2020-04-09 | Kenosha | Wisconsin | 55059 | 135 | 1 |
48371 | 48371 | 2020-04-10 | Kenosha | Wisconsin | 55059 | 147 | 1 |
51031 | 51031 | 2020-04-11 | Kenosha | Wisconsin | 55059 | 163 | 1 |
53708 | 53708 | 2020-04-12 | Kenosha | Wisconsin | 55059 | 173 | 2 |
56399 | 56399 | 2020-04-13 | Kenosha | Wisconsin | 55059 | 182 | 4 |
59106 | 59106 | 2020-04-14 | Kenosha | Wisconsin | 55059 | 186 | 3 |
61825 | 61825 | 2020-04-15 | Kenosha | Wisconsin | 55059 | 204 | 4 |
64558 | 64558 | 2020-04-16 | Kenosha | Wisconsin | 55059 | 208 | 5 |
67306 | 67306 | 2020-04-17 | Kenosha | Wisconsin | 55059 | 218 | 5 |
70068 | 70068 | 2020-04-18 | Kenosha | Wisconsin | 55059 | 236 | 5 |
72837 | 72837 | 2020-04-19 | Kenosha | Wisconsin | 55059 | 248 | 5 |
75613 | 75613 | 2020-04-20 | Kenosha | Wisconsin | 55059 | 257 | 5 |
78396 | 78396 | 2020-04-21 | Kenosha | Wisconsin | 55059 | 264 | 6 |
81189 | 81189 | 2020-04-22 | Kenosha | Wisconsin | 55059 | 278 | 6 |
83990 | 83990 | 2020-04-23 | Kenosha | Wisconsin | 55059 | 294 | 6 |
86797 | 86797 | 2020-04-24 | Kenosha | Wisconsin | 55059 | 314 | 7 |
89613 | 89613 | 2020-04-25 | Kenosha | Wisconsin | 55059 | 329 | 7 |
92431 | 92431 | 2020-04-26 | Kenosha | Wisconsin | 55059 | 339 | 7 |
95261 | 95261 | 2020-04-27 | Kenosha | Wisconsin | 55059 | 340 | 7 |
98106 | 98106 | 2020-04-28 | Kenosha | Wisconsin | 55059 | 348 | 9 |
100956 | 100956 | 2020-04-29 | Kenosha | Wisconsin | 55059 | 363 | 11 |
103811 | 103811 | 2020-04-30 | Kenosha | Wisconsin | 55059 | 391 | 12 |
106675 | 106675 | 2020-05-01 | Kenosha | Wisconsin | 55059 | 477 | 13 |
109544 | 109544 | 2020-05-02 | Kenosha | Wisconsin | 55059 | 521 | 13 |
112419 | 112419 | 2020-05-03 | Kenosha | Wisconsin | 55059 | 534 | 14 |
115302 | 115302 | 2020-05-04 | Kenosha | Wisconsin | 55059 | 546 | 14 |
118261 | 118261 | 2020-05-05 | Kenosha | Wisconsin | 55059 | 571 | 14 |
121227 | 121227 | 2020-05-06 | Kenosha | Wisconsin | 55059 | 580 | 14 |
124207 | 124207 | 2020-05-07 | Kenosha | Wisconsin | 55059 | 610 | 14 |
127192 | 127192 | 2020-05-08 | Kenosha | Wisconsin | 55059 | 627 | 15 |
130182 | 130182 | 2020-05-09 | Kenosha | Wisconsin | 55059 | 651 | 15 |
133172 | 133172 | 2020-05-10 | Kenosha | Wisconsin | 55059 | 682 | 15 |
136162 | 136162 | 2020-05-11 | Kenosha | Wisconsin | 55059 | 693 | 16 |
139153 | 139153 | 2020-05-12 | Kenosha | Wisconsin | 55059 | 716 | 16 |
142149 | 142149 | 2020-05-13 | Kenosha | Wisconsin | 55059 | 736 | 17 |
145147 | 145147 | 2020-05-14 | Kenosha | Wisconsin | 55059 | 762 | 17 |
148150 | 148150 | 2020-05-15 | Kenosha | Wisconsin | 55059 | 780 | 17 |
151159 | 151159 | 2020-05-16 | Kenosha | Wisconsin | 55059 | 820 | 18 |
154171 | 154171 | 2020-05-17 | Kenosha | Wisconsin | 55059 | 838 | 18 |
157187 | 157187 | 2020-05-18 | Kenosha | Wisconsin | 55059 | 848 | 18 |
160211 | 160211 | 2020-05-19 | Kenosha | Wisconsin | 55059 | 866 | 19 |
163239 | 163239 | 2020-05-20 | Kenosha | Wisconsin | 55059 | 889 | 21 |
166268 | 166268 | 2020-05-21 | Kenosha | Wisconsin | 55059 | 921 | 21 |
169304 | 169304 | 2020-05-22 | Kenosha | Wisconsin | 55059 | 948 | 22 |
172345 | 172345 | 2020-05-23 | Kenosha | Wisconsin | 55059 | 983 | 22 |
175388 | 175388 | 2020-05-24 | Kenosha | Wisconsin | 55059 | 998 | 22 |
178433 | 178433 | 2020-05-25 | Kenosha | Wisconsin | 55059 | 1001 | 22 |
181477 | 181477 | 2020-05-26 | Kenosha | Wisconsin | 55059 | 1008 | 22 |
184528 | 184528 | 2020-05-27 | Kenosha | Wisconsin | 55059 | 1033 | 24 |
187585 | 187585 | 2020-05-28 | Kenosha | Wisconsin | 55059 | 1088 | 25 |
190649 | 190649 | 2020-05-29 | Kenosha | Wisconsin | 55059 | 1131 | 27 |
193715 | 193715 | 2020-05-30 | Kenosha | Wisconsin | 55059 | 1165 | 30 |
196785 | 196785 | 2020-05-31 | Kenosha | Wisconsin | 55059 | 1168 | 30 |
199858 | 199858 | 2020-06-01 | Kenosha | Wisconsin | 55059 | 1178 | 30 |
202934 | 202934 | 2020-06-02 | Kenosha | Wisconsin | 55059 | 1201 | 30 |
206013 | 206013 | 2020-06-03 | Kenosha | Wisconsin | 55059 | 1222 | 30 |
209095 | 209095 | 2020-06-04 | Kenosha | Wisconsin | 55059 | 1252 | 33 |
212180 | 212180 | 2020-06-05 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
215267 | 215267 | 2020-06-06 | Kenosha | Wisconsin | 55059 | 1267 | 34 |
218357 | 218357 | 2020-06-07 | Kenosha | Wisconsin | 55059 | 1274 | 34 |
221449 | 221449 | 2020-06-08 | Kenosha | Wisconsin | 55059 | 1290 | 35 |
224545 | 224545 | 2020-06-09 | Kenosha | Wisconsin | 55059 | 1296 | 36 |
227645 | 227645 | 2020-06-10 | Kenosha | Wisconsin | 55059 | 1310 | 36 |
230749 | 230749 | 2020-06-11 | Kenosha | Wisconsin | 55059 | 1319 | 36 |
233854 | 233854 | 2020-06-12 | Kenosha | Wisconsin | 55059 | 1337 | 36 |
236961 | 236961 | 2020-06-13 | Kenosha | Wisconsin | 55059 | 1343 | 36 |
240069 | 240069 | 2020-06-14 | Kenosha | Wisconsin | 55059 | 1356 | 36 |
243180 | 243180 | 2020-06-15 | Kenosha | Wisconsin | 55059 | 1368 | 36 |
246293 | 246293 | 2020-06-16 | Kenosha | Wisconsin | 55059 | 1376 | 37 |
249405 | 249405 | 2020-06-17 | Kenosha | Wisconsin | 55059 | 1385 | 36 |
252520 | 252520 | 2020-06-18 | Kenosha | Wisconsin | 55059 | 1392 | 36 |
255639 | 255639 | 2020-06-19 | Kenosha | Wisconsin | 55059 | 1400 | 37 |
258766 | 258766 | 2020-06-20 | Kenosha | Wisconsin | 55059 | 1406 | 39 |
261893 | 261893 | 2020-06-21 | Kenosha | Wisconsin | 55059 | 1416 | 39 |
265022 | 265022 | 2020-06-22 | Kenosha | Wisconsin | 55059 | 1421 | 39 |
268151 | 268151 | 2020-06-23 | Kenosha | Wisconsin | 55059 | 1425 | 39 |
271285 | 271285 | 2020-06-24 | Kenosha | Wisconsin | 55059 | 1438 | 41 |
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);