ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55111 and state = "Wisconsin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5155 | 5155 | 2020-03-19 | Sauk | Wisconsin | 55111 | 1 | 0 |
6068 | 6068 | 2020-03-20 | Sauk | Wisconsin | 55111 | 2 | 0 |
7101 | 7101 | 2020-03-21 | Sauk | Wisconsin | 55111 | 2 | 0 |
8239 | 8239 | 2020-03-22 | Sauk | Wisconsin | 55111 | 2 | 0 |
9465 | 9465 | 2020-03-23 | Sauk | Wisconsin | 55111 | 3 | 0 |
10819 | 10819 | 2020-03-24 | Sauk | Wisconsin | 55111 | 4 | 0 |
12350 | 12350 | 2020-03-25 | Sauk | Wisconsin | 55111 | 6 | 0 |
14005 | 14005 | 2020-03-26 | Sauk | Wisconsin | 55111 | 7 | 0 |
15780 | 15780 | 2020-03-27 | Sauk | Wisconsin | 55111 | 8 | 1 |
17661 | 17661 | 2020-03-28 | Sauk | Wisconsin | 55111 | 11 | 1 |
19630 | 19630 | 2020-03-29 | Sauk | Wisconsin | 55111 | 12 | 1 |
21702 | 21702 | 2020-03-30 | Sauk | Wisconsin | 55111 | 13 | 1 |
23855 | 23855 | 2020-03-31 | Sauk | Wisconsin | 55111 | 13 | 1 |
26076 | 26076 | 2020-04-01 | Sauk | Wisconsin | 55111 | 14 | 2 |
28369 | 28369 | 2020-04-02 | Sauk | Wisconsin | 55111 | 16 | 2 |
30725 | 30725 | 2020-04-03 | Sauk | Wisconsin | 55111 | 18 | 2 |
33127 | 33127 | 2020-04-04 | Sauk | Wisconsin | 55111 | 18 | 2 |
35566 | 35566 | 2020-04-05 | Sauk | Wisconsin | 55111 | 18 | 2 |
38053 | 38053 | 2020-04-06 | Sauk | Wisconsin | 55111 | 18 | 2 |
40595 | 40595 | 2020-04-07 | Sauk | Wisconsin | 55111 | 20 | 2 |
43167 | 43167 | 2020-04-08 | Sauk | Wisconsin | 55111 | 20 | 2 |
45764 | 45764 | 2020-04-09 | Sauk | Wisconsin | 55111 | 21 | 2 |
48393 | 48393 | 2020-04-10 | Sauk | Wisconsin | 55111 | 25 | 2 |
51054 | 51054 | 2020-04-11 | Sauk | Wisconsin | 55111 | 25 | 2 |
53731 | 53731 | 2020-04-12 | Sauk | Wisconsin | 55111 | 26 | 2 |
56422 | 56422 | 2020-04-13 | Sauk | Wisconsin | 55111 | 26 | 2 |
59129 | 59129 | 2020-04-14 | Sauk | Wisconsin | 55111 | 28 | 4 |
61848 | 61848 | 2020-04-15 | Sauk | Wisconsin | 55111 | 31 | 4 |
64581 | 64581 | 2020-04-16 | Sauk | Wisconsin | 55111 | 31 | 3 |
67329 | 67329 | 2020-04-17 | Sauk | Wisconsin | 55111 | 31 | 3 |
70091 | 70091 | 2020-04-18 | Sauk | Wisconsin | 55111 | 32 | 3 |
72860 | 72860 | 2020-04-19 | Sauk | Wisconsin | 55111 | 33 | 3 |
75636 | 75636 | 2020-04-20 | Sauk | Wisconsin | 55111 | 34 | 3 |
78419 | 78419 | 2020-04-21 | Sauk | Wisconsin | 55111 | 34 | 3 |
81212 | 81212 | 2020-04-22 | Sauk | Wisconsin | 55111 | 36 | 3 |
84013 | 84013 | 2020-04-23 | Sauk | Wisconsin | 55111 | 37 | 3 |
86820 | 86820 | 2020-04-24 | Sauk | Wisconsin | 55111 | 38 | 3 |
89636 | 89636 | 2020-04-25 | Sauk | Wisconsin | 55111 | 38 | 3 |
92454 | 92454 | 2020-04-26 | Sauk | Wisconsin | 55111 | 40 | 3 |
95284 | 95284 | 2020-04-27 | Sauk | Wisconsin | 55111 | 42 | 3 |
98129 | 98129 | 2020-04-28 | Sauk | Wisconsin | 55111 | 44 | 3 |
100979 | 100979 | 2020-04-29 | Sauk | Wisconsin | 55111 | 44 | 3 |
103834 | 103834 | 2020-04-30 | Sauk | Wisconsin | 55111 | 45 | 3 |
106699 | 106699 | 2020-05-01 | Sauk | Wisconsin | 55111 | 58 | 3 |
109568 | 109568 | 2020-05-02 | Sauk | Wisconsin | 55111 | 64 | 3 |
112443 | 112443 | 2020-05-03 | Sauk | Wisconsin | 55111 | 65 | 3 |
115326 | 115326 | 2020-05-04 | Sauk | Wisconsin | 55111 | 66 | 3 |
118285 | 118285 | 2020-05-05 | Sauk | Wisconsin | 55111 | 67 | 3 |
121251 | 121251 | 2020-05-06 | Sauk | Wisconsin | 55111 | 70 | 3 |
124231 | 124231 | 2020-05-07 | Sauk | Wisconsin | 55111 | 69 | 3 |
127216 | 127216 | 2020-05-08 | Sauk | Wisconsin | 55111 | 69 | 3 |
130206 | 130206 | 2020-05-09 | Sauk | Wisconsin | 55111 | 71 | 3 |
133196 | 133196 | 2020-05-10 | Sauk | Wisconsin | 55111 | 71 | 3 |
136186 | 136186 | 2020-05-11 | Sauk | Wisconsin | 55111 | 72 | 3 |
139177 | 139177 | 2020-05-12 | Sauk | Wisconsin | 55111 | 73 | 3 |
142173 | 142173 | 2020-05-13 | Sauk | Wisconsin | 55111 | 73 | 3 |
145172 | 145172 | 2020-05-14 | Sauk | Wisconsin | 55111 | 74 | 3 |
148175 | 148175 | 2020-05-15 | Sauk | Wisconsin | 55111 | 76 | 3 |
151184 | 151184 | 2020-05-16 | Sauk | Wisconsin | 55111 | 77 | 3 |
154196 | 154196 | 2020-05-17 | Sauk | Wisconsin | 55111 | 77 | 3 |
157212 | 157212 | 2020-05-18 | Sauk | Wisconsin | 55111 | 77 | 3 |
160236 | 160236 | 2020-05-19 | Sauk | Wisconsin | 55111 | 77 | 3 |
163264 | 163264 | 2020-05-20 | Sauk | Wisconsin | 55111 | 77 | 3 |
166294 | 166294 | 2020-05-21 | Sauk | Wisconsin | 55111 | 77 | 3 |
169330 | 169330 | 2020-05-22 | Sauk | Wisconsin | 55111 | 77 | 3 |
172371 | 172371 | 2020-05-23 | Sauk | Wisconsin | 55111 | 77 | 3 |
175414 | 175414 | 2020-05-24 | Sauk | Wisconsin | 55111 | 77 | 3 |
178459 | 178459 | 2020-05-25 | Sauk | Wisconsin | 55111 | 77 | 3 |
181503 | 181503 | 2020-05-26 | Sauk | Wisconsin | 55111 | 77 | 3 |
184554 | 184554 | 2020-05-27 | Sauk | Wisconsin | 55111 | 78 | 3 |
187611 | 187611 | 2020-05-28 | Sauk | Wisconsin | 55111 | 78 | 3 |
190675 | 190675 | 2020-05-29 | Sauk | Wisconsin | 55111 | 78 | 3 |
193741 | 193741 | 2020-05-30 | Sauk | Wisconsin | 55111 | 78 | 3 |
196811 | 196811 | 2020-05-31 | Sauk | Wisconsin | 55111 | 78 | 3 |
199884 | 199884 | 2020-06-01 | Sauk | Wisconsin | 55111 | 78 | 3 |
202960 | 202960 | 2020-06-02 | Sauk | Wisconsin | 55111 | 79 | 3 |
206039 | 206039 | 2020-06-03 | Sauk | Wisconsin | 55111 | 81 | 3 |
209121 | 209121 | 2020-06-04 | Sauk | Wisconsin | 55111 | 81 | 3 |
212206 | 212206 | 2020-06-05 | Sauk | Wisconsin | 55111 | 81 | 3 |
215293 | 215293 | 2020-06-06 | Sauk | Wisconsin | 55111 | 81 | 3 |
218383 | 218383 | 2020-06-07 | Sauk | Wisconsin | 55111 | 83 | 3 |
221475 | 221475 | 2020-06-08 | Sauk | Wisconsin | 55111 | 83 | 3 |
224571 | 224571 | 2020-06-09 | Sauk | Wisconsin | 55111 | 84 | 3 |
227671 | 227671 | 2020-06-10 | Sauk | Wisconsin | 55111 | 84 | 3 |
230775 | 230775 | 2020-06-11 | Sauk | Wisconsin | 55111 | 84 | 3 |
233880 | 233880 | 2020-06-12 | Sauk | Wisconsin | 55111 | 84 | 3 |
236987 | 236987 | 2020-06-13 | Sauk | Wisconsin | 55111 | 86 | 3 |
240095 | 240095 | 2020-06-14 | Sauk | Wisconsin | 55111 | 85 | 3 |
243206 | 243206 | 2020-06-15 | Sauk | Wisconsin | 55111 | 85 | 3 |
246319 | 246319 | 2020-06-16 | Sauk | Wisconsin | 55111 | 87 | 3 |
249431 | 249431 | 2020-06-17 | Sauk | Wisconsin | 55111 | 87 | 3 |
252546 | 252546 | 2020-06-18 | Sauk | Wisconsin | 55111 | 88 | 3 |
255665 | 255665 | 2020-06-19 | Sauk | Wisconsin | 55111 | 90 | 3 |
258792 | 258792 | 2020-06-20 | Sauk | Wisconsin | 55111 | 94 | 3 |
261919 | 261919 | 2020-06-21 | Sauk | Wisconsin | 55111 | 96 | 3 |
265048 | 265048 | 2020-06-22 | Sauk | Wisconsin | 55111 | 96 | 3 |
268177 | 268177 | 2020-06-23 | Sauk | Wisconsin | 55111 | 97 | 3 |
271311 | 271311 | 2020-06-24 | Sauk | Wisconsin | 55111 | 97 | 3 |
274451 | 274451 | 2020-06-25 | Sauk | Wisconsin | 55111 | 98 | 3 |
277599 | 277599 | 2020-06-26 | Sauk | Wisconsin | 55111 | 98 | 3 |
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);