ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Bayfield" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389064 | 389064 | 2020-07-31 | Bayfield | Wisconsin | 55007 | 18 | 1 |
385847 | 385847 | 2020-07-30 | Bayfield | Wisconsin | 55007 | 18 | 1 |
382629 | 382629 | 2020-07-29 | Bayfield | Wisconsin | 55007 | 19 | 1 |
379412 | 379412 | 2020-07-28 | Bayfield | Wisconsin | 55007 | 19 | 1 |
376196 | 376196 | 2020-07-27 | Bayfield | Wisconsin | 55007 | 19 | 1 |
372982 | 372982 | 2020-07-26 | Bayfield | Wisconsin | 55007 | 18 | 1 |
369770 | 369770 | 2020-07-25 | Bayfield | Wisconsin | 55007 | 16 | 1 |
366560 | 366560 | 2020-07-24 | Bayfield | Wisconsin | 55007 | 16 | 1 |
363353 | 363353 | 2020-07-23 | Bayfield | Wisconsin | 55007 | 15 | 1 |
360147 | 360147 | 2020-07-22 | Bayfield | Wisconsin | 55007 | 14 | 1 |
356942 | 356942 | 2020-07-21 | Bayfield | Wisconsin | 55007 | 13 | 1 |
353739 | 353739 | 2020-07-20 | Bayfield | Wisconsin | 55007 | 13 | 1 |
350537 | 350537 | 2020-07-19 | Bayfield | Wisconsin | 55007 | 13 | 1 |
347336 | 347336 | 2020-07-18 | Bayfield | Wisconsin | 55007 | 13 | 1 |
344136 | 344136 | 2020-07-17 | Bayfield | Wisconsin | 55007 | 12 | 1 |
340937 | 340937 | 2020-07-16 | Bayfield | Wisconsin | 55007 | 11 | 1 |
337741 | 337741 | 2020-07-15 | Bayfield | Wisconsin | 55007 | 11 | 1 |
334546 | 334546 | 2020-07-14 | Bayfield | Wisconsin | 55007 | 9 | 1 |
331353 | 331353 | 2020-07-13 | Bayfield | Wisconsin | 55007 | 7 | 1 |
328167 | 328167 | 2020-07-12 | Bayfield | Wisconsin | 55007 | 6 | 1 |
324981 | 324981 | 2020-07-11 | Bayfield | Wisconsin | 55007 | 6 | 1 |
321800 | 321800 | 2020-07-10 | Bayfield | Wisconsin | 55007 | 5 | 1 |
318621 | 318621 | 2020-07-09 | Bayfield | Wisconsin | 55007 | 4 | 1 |
315448 | 315448 | 2020-07-08 | Bayfield | Wisconsin | 55007 | 4 | 1 |
312273 | 312273 | 2020-07-07 | Bayfield | Wisconsin | 55007 | 4 | 1 |
309104 | 309104 | 2020-07-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
305935 | 305935 | 2020-07-05 | Bayfield | Wisconsin | 55007 | 3 | 1 |
302771 | 302771 | 2020-07-04 | Bayfield | Wisconsin | 55007 | 3 | 1 |
299607 | 299607 | 2020-07-03 | Bayfield | Wisconsin | 55007 | 3 | 1 |
296445 | 296445 | 2020-07-02 | Bayfield | Wisconsin | 55007 | 3 | 1 |
293290 | 293290 | 2020-07-01 | Bayfield | Wisconsin | 55007 | 3 | 1 |
290137 | 290137 | 2020-06-30 | Bayfield | Wisconsin | 55007 | 3 | 1 |
286987 | 286987 | 2020-06-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
283841 | 283841 | 2020-06-28 | Bayfield | Wisconsin | 55007 | 3 | 1 |
280695 | 280695 | 2020-06-27 | Bayfield | Wisconsin | 55007 | 3 | 1 |
277547 | 277547 | 2020-06-26 | Bayfield | Wisconsin | 55007 | 3 | 1 |
274399 | 274399 | 2020-06-25 | Bayfield | Wisconsin | 55007 | 3 | 1 |
271259 | 271259 | 2020-06-24 | Bayfield | Wisconsin | 55007 | 3 | 1 |
268125 | 268125 | 2020-06-23 | Bayfield | Wisconsin | 55007 | 3 | 1 |
264996 | 264996 | 2020-06-22 | Bayfield | Wisconsin | 55007 | 3 | 1 |
261867 | 261867 | 2020-06-21 | Bayfield | Wisconsin | 55007 | 3 | 1 |
258740 | 258740 | 2020-06-20 | Bayfield | Wisconsin | 55007 | 3 | 1 |
255613 | 255613 | 2020-06-19 | Bayfield | Wisconsin | 55007 | 3 | 1 |
252494 | 252494 | 2020-06-18 | Bayfield | Wisconsin | 55007 | 3 | 1 |
249379 | 249379 | 2020-06-17 | Bayfield | Wisconsin | 55007 | 3 | 1 |
246267 | 246267 | 2020-06-16 | Bayfield | Wisconsin | 55007 | 3 | 1 |
243154 | 243154 | 2020-06-15 | Bayfield | Wisconsin | 55007 | 3 | 1 |
240043 | 240043 | 2020-06-14 | Bayfield | Wisconsin | 55007 | 3 | 1 |
236935 | 236935 | 2020-06-13 | Bayfield | Wisconsin | 55007 | 3 | 1 |
233828 | 233828 | 2020-06-12 | Bayfield | Wisconsin | 55007 | 3 | 1 |
230723 | 230723 | 2020-06-11 | Bayfield | Wisconsin | 55007 | 3 | 1 |
227619 | 227619 | 2020-06-10 | Bayfield | Wisconsin | 55007 | 3 | 1 |
224519 | 224519 | 2020-06-09 | Bayfield | Wisconsin | 55007 | 3 | 1 |
221423 | 221423 | 2020-06-08 | Bayfield | Wisconsin | 55007 | 3 | 1 |
218331 | 218331 | 2020-06-07 | Bayfield | Wisconsin | 55007 | 3 | 1 |
215241 | 215241 | 2020-06-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
212154 | 212154 | 2020-06-05 | Bayfield | Wisconsin | 55007 | 3 | 1 |
209069 | 209069 | 2020-06-04 | Bayfield | Wisconsin | 55007 | 3 | 1 |
205987 | 205987 | 2020-06-03 | Bayfield | Wisconsin | 55007 | 3 | 1 |
202908 | 202908 | 2020-06-02 | Bayfield | Wisconsin | 55007 | 3 | 1 |
199832 | 199832 | 2020-06-01 | Bayfield | Wisconsin | 55007 | 3 | 1 |
196759 | 196759 | 2020-05-31 | Bayfield | Wisconsin | 55007 | 3 | 1 |
193689 | 193689 | 2020-05-30 | Bayfield | Wisconsin | 55007 | 3 | 1 |
190623 | 190623 | 2020-05-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
187559 | 187559 | 2020-05-28 | Bayfield | Wisconsin | 55007 | 3 | 1 |
184502 | 184502 | 2020-05-27 | Bayfield | Wisconsin | 55007 | 3 | 1 |
181451 | 181451 | 2020-05-26 | Bayfield | Wisconsin | 55007 | 3 | 1 |
178407 | 178407 | 2020-05-25 | Bayfield | Wisconsin | 55007 | 3 | 1 |
175362 | 175362 | 2020-05-24 | Bayfield | Wisconsin | 55007 | 3 | 1 |
172319 | 172319 | 2020-05-23 | Bayfield | Wisconsin | 55007 | 3 | 1 |
169278 | 169278 | 2020-05-22 | Bayfield | Wisconsin | 55007 | 3 | 1 |
166242 | 166242 | 2020-05-21 | Bayfield | Wisconsin | 55007 | 3 | 1 |
163213 | 163213 | 2020-05-20 | Bayfield | Wisconsin | 55007 | 3 | 1 |
160185 | 160185 | 2020-05-19 | Bayfield | Wisconsin | 55007 | 3 | 1 |
157161 | 157161 | 2020-05-18 | Bayfield | Wisconsin | 55007 | 3 | 1 |
154145 | 154145 | 2020-05-17 | Bayfield | Wisconsin | 55007 | 3 | 1 |
151133 | 151133 | 2020-05-16 | Bayfield | Wisconsin | 55007 | 3 | 1 |
148124 | 148124 | 2020-05-15 | Bayfield | Wisconsin | 55007 | 3 | 1 |
145121 | 145121 | 2020-05-14 | Bayfield | Wisconsin | 55007 | 3 | 1 |
142124 | 142124 | 2020-05-13 | Bayfield | Wisconsin | 55007 | 3 | 1 |
139128 | 139128 | 2020-05-12 | Bayfield | Wisconsin | 55007 | 3 | 1 |
136137 | 136137 | 2020-05-11 | Bayfield | Wisconsin | 55007 | 3 | 1 |
133147 | 133147 | 2020-05-10 | Bayfield | Wisconsin | 55007 | 3 | 1 |
130157 | 130157 | 2020-05-09 | Bayfield | Wisconsin | 55007 | 3 | 1 |
127167 | 127167 | 2020-05-08 | Bayfield | Wisconsin | 55007 | 3 | 1 |
124182 | 124182 | 2020-05-07 | Bayfield | Wisconsin | 55007 | 3 | 1 |
121202 | 121202 | 2020-05-06 | Bayfield | Wisconsin | 55007 | 3 | 1 |
118237 | 118237 | 2020-05-05 | Bayfield | Wisconsin | 55007 | 3 | 1 |
115278 | 115278 | 2020-05-04 | Bayfield | Wisconsin | 55007 | 3 | 1 |
112395 | 112395 | 2020-05-03 | Bayfield | Wisconsin | 55007 | 3 | 1 |
109520 | 109520 | 2020-05-02 | Bayfield | Wisconsin | 55007 | 3 | 1 |
106651 | 106651 | 2020-05-01 | Bayfield | Wisconsin | 55007 | 3 | 1 |
103787 | 103787 | 2020-04-30 | Bayfield | Wisconsin | 55007 | 3 | 1 |
100932 | 100932 | 2020-04-29 | Bayfield | Wisconsin | 55007 | 3 | 1 |
98082 | 98082 | 2020-04-28 | Bayfield | Wisconsin | 55007 | 3 | 1 |
95237 | 95237 | 2020-04-27 | Bayfield | Wisconsin | 55007 | 3 | 1 |
92407 | 92407 | 2020-04-26 | Bayfield | Wisconsin | 55007 | 3 | 1 |
89589 | 89589 | 2020-04-25 | Bayfield | Wisconsin | 55007 | 3 | 1 |
86773 | 86773 | 2020-04-24 | Bayfield | Wisconsin | 55007 | 3 | 1 |
83966 | 83966 | 2020-04-23 | Bayfield | Wisconsin | 55007 | 3 | 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);