ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 55029 and state = "Wisconsin" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21675 | 21675 | 2020-03-30 | Door | Wisconsin | 55029 | 1 | 0 |
23827 | 23827 | 2020-03-31 | Door | Wisconsin | 55029 | 1 | 0 |
26047 | 26047 | 2020-04-01 | Door | Wisconsin | 55029 | 1 | 0 |
28340 | 28340 | 2020-04-02 | Door | Wisconsin | 55029 | 2 | 0 |
30695 | 30695 | 2020-04-03 | Door | Wisconsin | 55029 | 2 | 0 |
33096 | 33096 | 2020-04-04 | Door | Wisconsin | 55029 | 2 | 0 |
35534 | 35534 | 2020-04-05 | Door | Wisconsin | 55029 | 4 | 0 |
38020 | 38020 | 2020-04-06 | Door | Wisconsin | 55029 | 4 | 0 |
40561 | 40561 | 2020-04-07 | Door | Wisconsin | 55029 | 7 | 0 |
43133 | 43133 | 2020-04-08 | Door | Wisconsin | 55029 | 7 | 0 |
45730 | 45730 | 2020-04-09 | Door | Wisconsin | 55029 | 8 | 0 |
48358 | 48358 | 2020-04-10 | Door | Wisconsin | 55029 | 8 | 0 |
51018 | 51018 | 2020-04-11 | Door | Wisconsin | 55029 | 9 | 0 |
53695 | 53695 | 2020-04-12 | Door | Wisconsin | 55029 | 9 | 0 |
56385 | 56385 | 2020-04-13 | Door | Wisconsin | 55029 | 9 | 0 |
59092 | 59092 | 2020-04-14 | Door | Wisconsin | 55029 | 9 | 1 |
61811 | 61811 | 2020-04-15 | Door | Wisconsin | 55029 | 9 | 1 |
64544 | 64544 | 2020-04-16 | Door | Wisconsin | 55029 | 9 | 1 |
67292 | 67292 | 2020-04-17 | Door | Wisconsin | 55029 | 9 | 1 |
70054 | 70054 | 2020-04-18 | Door | Wisconsin | 55029 | 9 | 1 |
72823 | 72823 | 2020-04-19 | Door | Wisconsin | 55029 | 9 | 1 |
75599 | 75599 | 2020-04-20 | Door | Wisconsin | 55029 | 9 | 1 |
78382 | 78382 | 2020-04-21 | Door | Wisconsin | 55029 | 9 | 1 |
81175 | 81175 | 2020-04-22 | Door | Wisconsin | 55029 | 9 | 1 |
83976 | 83976 | 2020-04-23 | Door | Wisconsin | 55029 | 9 | 1 |
86783 | 86783 | 2020-04-24 | Door | Wisconsin | 55029 | 9 | 1 |
89599 | 89599 | 2020-04-25 | Door | Wisconsin | 55029 | 10 | 1 |
92417 | 92417 | 2020-04-26 | Door | Wisconsin | 55029 | 10 | 1 |
95247 | 95247 | 2020-04-27 | Door | Wisconsin | 55029 | 10 | 1 |
98092 | 98092 | 2020-04-28 | Door | Wisconsin | 55029 | 12 | 1 |
100942 | 100942 | 2020-04-29 | Door | Wisconsin | 55029 | 12 | 2 |
103797 | 103797 | 2020-04-30 | Door | Wisconsin | 55029 | 12 | 2 |
106661 | 106661 | 2020-05-01 | Door | Wisconsin | 55029 | 12 | 2 |
109530 | 109530 | 2020-05-02 | Door | Wisconsin | 55029 | 14 | 3 |
112405 | 112405 | 2020-05-03 | Door | Wisconsin | 55029 | 15 | 3 |
115288 | 115288 | 2020-05-04 | Door | Wisconsin | 55029 | 15 | 3 |
118247 | 118247 | 2020-05-05 | Door | Wisconsin | 55029 | 18 | 3 |
121212 | 121212 | 2020-05-06 | Door | Wisconsin | 55029 | 18 | 3 |
124192 | 124192 | 2020-05-07 | Door | Wisconsin | 55029 | 18 | 3 |
127177 | 127177 | 2020-05-08 | Door | Wisconsin | 55029 | 18 | 3 |
130167 | 130167 | 2020-05-09 | Door | Wisconsin | 55029 | 20 | 3 |
133157 | 133157 | 2020-05-10 | Door | Wisconsin | 55029 | 21 | 3 |
136147 | 136147 | 2020-05-11 | Door | Wisconsin | 55029 | 22 | 3 |
139138 | 139138 | 2020-05-12 | Door | Wisconsin | 55029 | 22 | 3 |
142134 | 142134 | 2020-05-13 | Door | Wisconsin | 55029 | 23 | 3 |
145132 | 145132 | 2020-05-14 | Door | Wisconsin | 55029 | 23 | 3 |
148135 | 148135 | 2020-05-15 | Door | Wisconsin | 55029 | 29 | 3 |
151144 | 151144 | 2020-05-16 | Door | Wisconsin | 55029 | 33 | 3 |
154156 | 154156 | 2020-05-17 | Door | Wisconsin | 55029 | 33 | 3 |
157172 | 157172 | 2020-05-18 | Door | Wisconsin | 55029 | 33 | 3 |
160196 | 160196 | 2020-05-19 | Door | Wisconsin | 55029 | 33 | 3 |
163224 | 163224 | 2020-05-20 | Door | Wisconsin | 55029 | 34 | 3 |
166253 | 166253 | 2020-05-21 | Door | Wisconsin | 55029 | 34 | 3 |
169289 | 169289 | 2020-05-22 | Door | Wisconsin | 55029 | 35 | 3 |
172330 | 172330 | 2020-05-23 | Door | Wisconsin | 55029 | 37 | 3 |
175373 | 175373 | 2020-05-24 | Door | Wisconsin | 55029 | 37 | 3 |
178418 | 178418 | 2020-05-25 | Door | Wisconsin | 55029 | 37 | 3 |
181462 | 181462 | 2020-05-26 | Door | Wisconsin | 55029 | 38 | 3 |
184513 | 184513 | 2020-05-27 | Door | Wisconsin | 55029 | 38 | 3 |
187570 | 187570 | 2020-05-28 | Door | Wisconsin | 55029 | 38 | 3 |
190634 | 190634 | 2020-05-29 | Door | Wisconsin | 55029 | 38 | 3 |
193700 | 193700 | 2020-05-30 | Door | Wisconsin | 55029 | 38 | 3 |
196770 | 196770 | 2020-05-31 | Door | Wisconsin | 55029 | 38 | 3 |
199843 | 199843 | 2020-06-01 | Door | Wisconsin | 55029 | 38 | 3 |
202919 | 202919 | 2020-06-02 | Door | Wisconsin | 55029 | 38 | 3 |
205998 | 205998 | 2020-06-03 | Door | Wisconsin | 55029 | 38 | 3 |
209080 | 209080 | 2020-06-04 | Door | Wisconsin | 55029 | 40 | 3 |
212165 | 212165 | 2020-06-05 | Door | Wisconsin | 55029 | 39 | 3 |
215252 | 215252 | 2020-06-06 | Door | Wisconsin | 55029 | 39 | 3 |
218342 | 218342 | 2020-06-07 | Door | Wisconsin | 55029 | 39 | 3 |
221434 | 221434 | 2020-06-08 | Door | Wisconsin | 55029 | 39 | 3 |
224530 | 224530 | 2020-06-09 | Door | Wisconsin | 55029 | 39 | 3 |
227630 | 227630 | 2020-06-10 | Door | Wisconsin | 55029 | 39 | 3 |
230734 | 230734 | 2020-06-11 | Door | Wisconsin | 55029 | 39 | 3 |
233839 | 233839 | 2020-06-12 | Door | Wisconsin | 55029 | 41 | 3 |
236946 | 236946 | 2020-06-13 | Door | Wisconsin | 55029 | 39 | 3 |
240054 | 240054 | 2020-06-14 | Door | Wisconsin | 55029 | 39 | 3 |
243165 | 243165 | 2020-06-15 | Door | Wisconsin | 55029 | 39 | 3 |
246278 | 246278 | 2020-06-16 | Door | Wisconsin | 55029 | 39 | 3 |
249390 | 249390 | 2020-06-17 | Door | Wisconsin | 55029 | 39 | 3 |
252505 | 252505 | 2020-06-18 | Door | Wisconsin | 55029 | 39 | 3 |
255624 | 255624 | 2020-06-19 | Door | Wisconsin | 55029 | 40 | 3 |
258751 | 258751 | 2020-06-20 | Door | Wisconsin | 55029 | 40 | 3 |
261878 | 261878 | 2020-06-21 | Door | Wisconsin | 55029 | 40 | 3 |
265007 | 265007 | 2020-06-22 | Door | Wisconsin | 55029 | 40 | 3 |
268136 | 268136 | 2020-06-23 | Door | Wisconsin | 55029 | 40 | 3 |
271270 | 271270 | 2020-06-24 | Door | Wisconsin | 55029 | 40 | 3 |
274410 | 274410 | 2020-06-25 | Door | Wisconsin | 55029 | 40 | 3 |
277558 | 277558 | 2020-06-26 | Door | Wisconsin | 55029 | 43 | 3 |
280706 | 280706 | 2020-06-27 | Door | Wisconsin | 55029 | 43 | 3 |
283852 | 283852 | 2020-06-28 | Door | Wisconsin | 55029 | 43 | 3 |
286998 | 286998 | 2020-06-29 | Door | Wisconsin | 55029 | 43 | 3 |
290148 | 290148 | 2020-06-30 | Door | Wisconsin | 55029 | 44 | 3 |
293301 | 293301 | 2020-07-01 | Door | Wisconsin | 55029 | 43 | 3 |
296456 | 296456 | 2020-07-02 | Door | Wisconsin | 55029 | 44 | 3 |
299618 | 299618 | 2020-07-03 | Door | Wisconsin | 55029 | 45 | 3 |
302782 | 302782 | 2020-07-04 | Door | Wisconsin | 55029 | 44 | 3 |
305946 | 305946 | 2020-07-05 | Door | Wisconsin | 55029 | 45 | 3 |
309115 | 309115 | 2020-07-06 | Door | Wisconsin | 55029 | 45 | 3 |
312284 | 312284 | 2020-07-07 | Door | Wisconsin | 55029 | 49 | 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);