ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Buffalo" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389066 | 389066 | 2020-07-31 | Buffalo | Wisconsin | 55011 | 41 | 2 |
385849 | 385849 | 2020-07-30 | Buffalo | Wisconsin | 55011 | 41 | 2 |
382631 | 382631 | 2020-07-29 | Buffalo | Wisconsin | 55011 | 40 | 2 |
379414 | 379414 | 2020-07-28 | Buffalo | Wisconsin | 55011 | 37 | 2 |
376198 | 376198 | 2020-07-27 | Buffalo | Wisconsin | 55011 | 36 | 2 |
372984 | 372984 | 2020-07-26 | Buffalo | Wisconsin | 55011 | 36 | 2 |
369772 | 369772 | 2020-07-25 | Buffalo | Wisconsin | 55011 | 36 | 2 |
366562 | 366562 | 2020-07-24 | Buffalo | Wisconsin | 55011 | 34 | 2 |
363355 | 363355 | 2020-07-23 | Buffalo | Wisconsin | 55011 | 33 | 2 |
360149 | 360149 | 2020-07-22 | Buffalo | Wisconsin | 55011 | 28 | 2 |
356944 | 356944 | 2020-07-21 | Buffalo | Wisconsin | 55011 | 29 | 2 |
353741 | 353741 | 2020-07-20 | Buffalo | Wisconsin | 55011 | 25 | 2 |
350539 | 350539 | 2020-07-19 | Buffalo | Wisconsin | 55011 | 22 | 2 |
347338 | 347338 | 2020-07-18 | Buffalo | Wisconsin | 55011 | 20 | 2 |
344138 | 344138 | 2020-07-17 | Buffalo | Wisconsin | 55011 | 19 | 2 |
340939 | 340939 | 2020-07-16 | Buffalo | Wisconsin | 55011 | 21 | 2 |
337743 | 337743 | 2020-07-15 | Buffalo | Wisconsin | 55011 | 21 | 2 |
334548 | 334548 | 2020-07-14 | Buffalo | Wisconsin | 55011 | 16 | 2 |
331355 | 331355 | 2020-07-13 | Buffalo | Wisconsin | 55011 | 15 | 2 |
328169 | 328169 | 2020-07-12 | Buffalo | Wisconsin | 55011 | 14 | 2 |
324983 | 324983 | 2020-07-11 | Buffalo | Wisconsin | 55011 | 13 | 2 |
321802 | 321802 | 2020-07-10 | Buffalo | Wisconsin | 55011 | 11 | 2 |
318623 | 318623 | 2020-07-09 | Buffalo | Wisconsin | 55011 | 11 | 2 |
315450 | 315450 | 2020-07-08 | Buffalo | Wisconsin | 55011 | 10 | 2 |
312275 | 312275 | 2020-07-07 | Buffalo | Wisconsin | 55011 | 9 | 2 |
309106 | 309106 | 2020-07-06 | Buffalo | Wisconsin | 55011 | 8 | 2 |
305937 | 305937 | 2020-07-05 | Buffalo | Wisconsin | 55011 | 8 | 2 |
302773 | 302773 | 2020-07-04 | Buffalo | Wisconsin | 55011 | 8 | 2 |
299609 | 299609 | 2020-07-03 | Buffalo | Wisconsin | 55011 | 8 | 2 |
296447 | 296447 | 2020-07-02 | Buffalo | Wisconsin | 55011 | 7 | 2 |
293292 | 293292 | 2020-07-01 | Buffalo | Wisconsin | 55011 | 8 | 2 |
290139 | 290139 | 2020-06-30 | Buffalo | Wisconsin | 55011 | 7 | 2 |
286989 | 286989 | 2020-06-29 | Buffalo | Wisconsin | 55011 | 7 | 2 |
283843 | 283843 | 2020-06-28 | Buffalo | Wisconsin | 55011 | 7 | 2 |
280697 | 280697 | 2020-06-27 | Buffalo | Wisconsin | 55011 | 7 | 2 |
277549 | 277549 | 2020-06-26 | Buffalo | Wisconsin | 55011 | 7 | 2 |
274401 | 274401 | 2020-06-25 | Buffalo | Wisconsin | 55011 | 7 | 2 |
271261 | 271261 | 2020-06-24 | Buffalo | Wisconsin | 55011 | 7 | 2 |
268127 | 268127 | 2020-06-23 | Buffalo | Wisconsin | 55011 | 7 | 2 |
264998 | 264998 | 2020-06-22 | Buffalo | Wisconsin | 55011 | 6 | 2 |
261869 | 261869 | 2020-06-21 | Buffalo | Wisconsin | 55011 | 6 | 2 |
258742 | 258742 | 2020-06-20 | Buffalo | Wisconsin | 55011 | 6 | 2 |
255615 | 255615 | 2020-06-19 | Buffalo | Wisconsin | 55011 | 7 | 2 |
252496 | 252496 | 2020-06-18 | Buffalo | Wisconsin | 55011 | 6 | 2 |
249381 | 249381 | 2020-06-17 | Buffalo | Wisconsin | 55011 | 7 | 2 |
246269 | 246269 | 2020-06-16 | Buffalo | Wisconsin | 55011 | 7 | 2 |
243156 | 243156 | 2020-06-15 | Buffalo | Wisconsin | 55011 | 7 | 2 |
240045 | 240045 | 2020-06-14 | Buffalo | Wisconsin | 55011 | 7 | 2 |
236937 | 236937 | 2020-06-13 | Buffalo | Wisconsin | 55011 | 7 | 2 |
233830 | 233830 | 2020-06-12 | Buffalo | Wisconsin | 55011 | 7 | 2 |
230725 | 230725 | 2020-06-11 | Buffalo | Wisconsin | 55011 | 7 | 2 |
227621 | 227621 | 2020-06-10 | Buffalo | Wisconsin | 55011 | 6 | 2 |
224521 | 224521 | 2020-06-09 | Buffalo | Wisconsin | 55011 | 6 | 2 |
221425 | 221425 | 2020-06-08 | Buffalo | Wisconsin | 55011 | 6 | 2 |
218333 | 218333 | 2020-06-07 | Buffalo | Wisconsin | 55011 | 6 | 2 |
215243 | 215243 | 2020-06-06 | Buffalo | Wisconsin | 55011 | 6 | 2 |
212156 | 212156 | 2020-06-05 | Buffalo | Wisconsin | 55011 | 6 | 2 |
209071 | 209071 | 2020-06-04 | Buffalo | Wisconsin | 55011 | 6 | 1 |
205989 | 205989 | 2020-06-03 | Buffalo | Wisconsin | 55011 | 6 | 1 |
202910 | 202910 | 2020-06-02 | Buffalo | Wisconsin | 55011 | 6 | 1 |
199834 | 199834 | 2020-06-01 | Buffalo | Wisconsin | 55011 | 6 | 1 |
196761 | 196761 | 2020-05-31 | Buffalo | Wisconsin | 55011 | 6 | 1 |
193691 | 193691 | 2020-05-30 | Buffalo | Wisconsin | 55011 | 6 | 1 |
190625 | 190625 | 2020-05-29 | Buffalo | Wisconsin | 55011 | 5 | 1 |
187561 | 187561 | 2020-05-28 | Buffalo | Wisconsin | 55011 | 5 | 1 |
184504 | 184504 | 2020-05-27 | Buffalo | Wisconsin | 55011 | 5 | 1 |
181453 | 181453 | 2020-05-26 | Buffalo | Wisconsin | 55011 | 5 | 1 |
178409 | 178409 | 2020-05-25 | Buffalo | Wisconsin | 55011 | 5 | 1 |
175364 | 175364 | 2020-05-24 | Buffalo | Wisconsin | 55011 | 5 | 1 |
172321 | 172321 | 2020-05-23 | Buffalo | Wisconsin | 55011 | 5 | 1 |
169280 | 169280 | 2020-05-22 | Buffalo | Wisconsin | 55011 | 5 | 1 |
166244 | 166244 | 2020-05-21 | Buffalo | Wisconsin | 55011 | 5 | 1 |
163215 | 163215 | 2020-05-20 | Buffalo | Wisconsin | 55011 | 5 | 1 |
160187 | 160187 | 2020-05-19 | Buffalo | Wisconsin | 55011 | 5 | 1 |
157163 | 157163 | 2020-05-18 | Buffalo | Wisconsin | 55011 | 5 | 1 |
154147 | 154147 | 2020-05-17 | Buffalo | Wisconsin | 55011 | 5 | 1 |
151135 | 151135 | 2020-05-16 | Buffalo | Wisconsin | 55011 | 5 | 1 |
148126 | 148126 | 2020-05-15 | Buffalo | Wisconsin | 55011 | 5 | 1 |
145123 | 145123 | 2020-05-14 | Buffalo | Wisconsin | 55011 | 5 | 1 |
142126 | 142126 | 2020-05-13 | Buffalo | Wisconsin | 55011 | 5 | 1 |
139130 | 139130 | 2020-05-12 | Buffalo | Wisconsin | 55011 | 5 | 1 |
136139 | 136139 | 2020-05-11 | Buffalo | Wisconsin | 55011 | 5 | 1 |
133149 | 133149 | 2020-05-10 | Buffalo | Wisconsin | 55011 | 5 | 1 |
130159 | 130159 | 2020-05-09 | Buffalo | Wisconsin | 55011 | 5 | 1 |
127169 | 127169 | 2020-05-08 | Buffalo | Wisconsin | 55011 | 5 | 1 |
124184 | 124184 | 2020-05-07 | Buffalo | Wisconsin | 55011 | 5 | 1 |
121204 | 121204 | 2020-05-06 | Buffalo | Wisconsin | 55011 | 6 | 1 |
118239 | 118239 | 2020-05-05 | Buffalo | Wisconsin | 55011 | 6 | 1 |
115280 | 115280 | 2020-05-04 | Buffalo | Wisconsin | 55011 | 5 | 1 |
112397 | 112397 | 2020-05-03 | Buffalo | Wisconsin | 55011 | 4 | 1 |
109522 | 109522 | 2020-05-02 | Buffalo | Wisconsin | 55011 | 4 | 1 |
106653 | 106653 | 2020-05-01 | Buffalo | Wisconsin | 55011 | 4 | 1 |
103789 | 103789 | 2020-04-30 | Buffalo | Wisconsin | 55011 | 4 | 1 |
100934 | 100934 | 2020-04-29 | Buffalo | Wisconsin | 55011 | 4 | 1 |
98084 | 98084 | 2020-04-28 | Buffalo | Wisconsin | 55011 | 4 | 1 |
95239 | 95239 | 2020-04-27 | Buffalo | Wisconsin | 55011 | 4 | 1 |
92409 | 92409 | 2020-04-26 | Buffalo | Wisconsin | 55011 | 4 | 1 |
89591 | 89591 | 2020-04-25 | Buffalo | Wisconsin | 55011 | 4 | 1 |
86775 | 86775 | 2020-04-24 | Buffalo | Wisconsin | 55011 | 4 | 1 |
83968 | 83968 | 2020-04-23 | Buffalo | Wisconsin | 55011 | 4 | 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);