ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 55077 and state = "Wisconsin" 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 |
---|---|---|---|---|---|---|---|
21691 | 21691 | 2020-03-30 | Marquette | Wisconsin | 55077 | 2 | 0 |
23843 | 23843 | 2020-03-31 | Marquette | Wisconsin | 55077 | 2 | 0 |
26063 | 26063 | 2020-04-01 | Marquette | Wisconsin | 55077 | 2 | 0 |
28356 | 28356 | 2020-04-02 | Marquette | Wisconsin | 55077 | 2 | 0 |
30711 | 30711 | 2020-04-03 | Marquette | Wisconsin | 55077 | 2 | 0 |
33113 | 33113 | 2020-04-04 | Marquette | Wisconsin | 55077 | 2 | 0 |
35552 | 35552 | 2020-04-05 | Marquette | Wisconsin | 55077 | 2 | 0 |
38039 | 38039 | 2020-04-06 | Marquette | Wisconsin | 55077 | 2 | 0 |
40581 | 40581 | 2020-04-07 | Marquette | Wisconsin | 55077 | 2 | 0 |
43153 | 43153 | 2020-04-08 | Marquette | Wisconsin | 55077 | 2 | 0 |
45750 | 45750 | 2020-04-09 | Marquette | Wisconsin | 55077 | 2 | 0 |
48378 | 48378 | 2020-04-10 | Marquette | Wisconsin | 55077 | 2 | 0 |
51038 | 51038 | 2020-04-11 | Marquette | Wisconsin | 55077 | 2 | 0 |
53715 | 53715 | 2020-04-12 | Marquette | Wisconsin | 55077 | 2 | 0 |
56406 | 56406 | 2020-04-13 | Marquette | Wisconsin | 55077 | 2 | 0 |
59113 | 59113 | 2020-04-14 | Marquette | Wisconsin | 55077 | 2 | 0 |
61832 | 61832 | 2020-04-15 | Marquette | Wisconsin | 55077 | 3 | 0 |
64565 | 64565 | 2020-04-16 | Marquette | Wisconsin | 55077 | 3 | 0 |
67313 | 67313 | 2020-04-17 | Marquette | Wisconsin | 55077 | 3 | 0 |
70075 | 70075 | 2020-04-18 | Marquette | Wisconsin | 55077 | 3 | 1 |
72844 | 72844 | 2020-04-19 | Marquette | Wisconsin | 55077 | 3 | 1 |
75620 | 75620 | 2020-04-20 | Marquette | Wisconsin | 55077 | 3 | 1 |
78403 | 78403 | 2020-04-21 | Marquette | Wisconsin | 55077 | 3 | 1 |
81196 | 81196 | 2020-04-22 | Marquette | Wisconsin | 55077 | 3 | 1 |
83997 | 83997 | 2020-04-23 | Marquette | Wisconsin | 55077 | 3 | 1 |
86804 | 86804 | 2020-04-24 | Marquette | Wisconsin | 55077 | 3 | 1 |
89620 | 89620 | 2020-04-25 | Marquette | Wisconsin | 55077 | 3 | 1 |
92438 | 92438 | 2020-04-26 | Marquette | Wisconsin | 55077 | 3 | 1 |
95268 | 95268 | 2020-04-27 | Marquette | Wisconsin | 55077 | 3 | 1 |
98113 | 98113 | 2020-04-28 | Marquette | Wisconsin | 55077 | 3 | 1 |
100963 | 100963 | 2020-04-29 | Marquette | Wisconsin | 55077 | 3 | 1 |
103818 | 103818 | 2020-04-30 | Marquette | Wisconsin | 55077 | 3 | 1 |
106683 | 106683 | 2020-05-01 | Marquette | Wisconsin | 55077 | 3 | 1 |
109552 | 109552 | 2020-05-02 | Marquette | Wisconsin | 55077 | 3 | 1 |
112427 | 112427 | 2020-05-03 | Marquette | Wisconsin | 55077 | 3 | 1 |
115310 | 115310 | 2020-05-04 | Marquette | Wisconsin | 55077 | 3 | 1 |
118269 | 118269 | 2020-05-05 | Marquette | Wisconsin | 55077 | 3 | 1 |
121235 | 121235 | 2020-05-06 | Marquette | Wisconsin | 55077 | 3 | 1 |
124215 | 124215 | 2020-05-07 | Marquette | Wisconsin | 55077 | 3 | 1 |
127200 | 127200 | 2020-05-08 | Marquette | Wisconsin | 55077 | 3 | 1 |
130190 | 130190 | 2020-05-09 | Marquette | Wisconsin | 55077 | 3 | 1 |
133180 | 133180 | 2020-05-10 | Marquette | Wisconsin | 55077 | 3 | 1 |
136170 | 136170 | 2020-05-11 | Marquette | Wisconsin | 55077 | 3 | 1 |
139161 | 139161 | 2020-05-12 | Marquette | Wisconsin | 55077 | 3 | 1 |
142157 | 142157 | 2020-05-13 | Marquette | Wisconsin | 55077 | 3 | 1 |
145155 | 145155 | 2020-05-14 | Marquette | Wisconsin | 55077 | 3 | 1 |
148158 | 148158 | 2020-05-15 | Marquette | Wisconsin | 55077 | 3 | 1 |
151167 | 151167 | 2020-05-16 | Marquette | Wisconsin | 55077 | 3 | 1 |
154179 | 154179 | 2020-05-17 | Marquette | Wisconsin | 55077 | 3 | 1 |
157195 | 157195 | 2020-05-18 | Marquette | Wisconsin | 55077 | 3 | 1 |
160219 | 160219 | 2020-05-19 | Marquette | Wisconsin | 55077 | 3 | 1 |
163247 | 163247 | 2020-05-20 | Marquette | Wisconsin | 55077 | 3 | 1 |
166277 | 166277 | 2020-05-21 | Marquette | Wisconsin | 55077 | 3 | 1 |
169313 | 169313 | 2020-05-22 | Marquette | Wisconsin | 55077 | 3 | 1 |
172354 | 172354 | 2020-05-23 | Marquette | Wisconsin | 55077 | 3 | 1 |
175397 | 175397 | 2020-05-24 | Marquette | Wisconsin | 55077 | 3 | 1 |
178442 | 178442 | 2020-05-25 | Marquette | Wisconsin | 55077 | 3 | 1 |
181486 | 181486 | 2020-05-26 | Marquette | Wisconsin | 55077 | 3 | 1 |
184537 | 184537 | 2020-05-27 | Marquette | Wisconsin | 55077 | 3 | 1 |
187594 | 187594 | 2020-05-28 | Marquette | Wisconsin | 55077 | 3 | 1 |
190658 | 190658 | 2020-05-29 | Marquette | Wisconsin | 55077 | 3 | 1 |
193724 | 193724 | 2020-05-30 | Marquette | Wisconsin | 55077 | 4 | 1 |
196794 | 196794 | 2020-05-31 | Marquette | Wisconsin | 55077 | 4 | 1 |
199867 | 199867 | 2020-06-01 | Marquette | Wisconsin | 55077 | 4 | 1 |
202943 | 202943 | 2020-06-02 | Marquette | Wisconsin | 55077 | 4 | 1 |
206022 | 206022 | 2020-06-03 | Marquette | Wisconsin | 55077 | 6 | 1 |
209104 | 209104 | 2020-06-04 | Marquette | Wisconsin | 55077 | 5 | 1 |
212189 | 212189 | 2020-06-05 | Marquette | Wisconsin | 55077 | 5 | 1 |
215276 | 215276 | 2020-06-06 | Marquette | Wisconsin | 55077 | 5 | 1 |
218366 | 218366 | 2020-06-07 | Marquette | Wisconsin | 55077 | 5 | 1 |
221458 | 221458 | 2020-06-08 | Marquette | Wisconsin | 55077 | 5 | 1 |
224554 | 224554 | 2020-06-09 | Marquette | Wisconsin | 55077 | 6 | 1 |
227654 | 227654 | 2020-06-10 | Marquette | Wisconsin | 55077 | 7 | 1 |
230758 | 230758 | 2020-06-11 | Marquette | Wisconsin | 55077 | 9 | 1 |
233863 | 233863 | 2020-06-12 | Marquette | Wisconsin | 55077 | 9 | 1 |
236970 | 236970 | 2020-06-13 | Marquette | Wisconsin | 55077 | 9 | 1 |
240078 | 240078 | 2020-06-14 | Marquette | Wisconsin | 55077 | 9 | 1 |
243189 | 243189 | 2020-06-15 | Marquette | Wisconsin | 55077 | 9 | 1 |
246302 | 246302 | 2020-06-16 | Marquette | Wisconsin | 55077 | 9 | 1 |
249414 | 249414 | 2020-06-17 | Marquette | Wisconsin | 55077 | 9 | 1 |
252529 | 252529 | 2020-06-18 | Marquette | Wisconsin | 55077 | 9 | 1 |
255648 | 255648 | 2020-06-19 | Marquette | Wisconsin | 55077 | 9 | 1 |
258775 | 258775 | 2020-06-20 | Marquette | Wisconsin | 55077 | 9 | 1 |
261902 | 261902 | 2020-06-21 | Marquette | Wisconsin | 55077 | 9 | 1 |
265031 | 265031 | 2020-06-22 | Marquette | Wisconsin | 55077 | 10 | 1 |
268160 | 268160 | 2020-06-23 | Marquette | Wisconsin | 55077 | 10 | 1 |
271294 | 271294 | 2020-06-24 | Marquette | Wisconsin | 55077 | 10 | 1 |
274434 | 274434 | 2020-06-25 | Marquette | Wisconsin | 55077 | 10 | 1 |
277582 | 277582 | 2020-06-26 | Marquette | Wisconsin | 55077 | 12 | 1 |
280730 | 280730 | 2020-06-27 | Marquette | Wisconsin | 55077 | 12 | 1 |
283876 | 283876 | 2020-06-28 | Marquette | Wisconsin | 55077 | 13 | 1 |
287022 | 287022 | 2020-06-29 | Marquette | Wisconsin | 55077 | 13 | 1 |
290172 | 290172 | 2020-06-30 | Marquette | Wisconsin | 55077 | 13 | 1 |
293325 | 293325 | 2020-07-01 | Marquette | Wisconsin | 55077 | 16 | 1 |
296480 | 296480 | 2020-07-02 | Marquette | Wisconsin | 55077 | 17 | 1 |
299642 | 299642 | 2020-07-03 | Marquette | Wisconsin | 55077 | 17 | 1 |
302806 | 302806 | 2020-07-04 | Marquette | Wisconsin | 55077 | 23 | 1 |
305970 | 305970 | 2020-07-05 | Marquette | Wisconsin | 55077 | 24 | 1 |
309139 | 309139 | 2020-07-06 | Marquette | Wisconsin | 55077 | 24 | 1 |
312308 | 312308 | 2020-07-07 | Marquette | Wisconsin | 55077 | 31 | 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);