ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where county = "Juneau", deaths = 1 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
547302 | 547302 | 2020-09-18 | Juneau | Wisconsin | 55057 | 306 | 1 |
544065 | 544065 | 2020-09-17 | Juneau | Wisconsin | 55057 | 298 | 1 |
540829 | 540829 | 2020-09-16 | Juneau | Wisconsin | 55057 | 289 | 1 |
537592 | 537592 | 2020-09-15 | Juneau | Wisconsin | 55057 | 281 | 1 |
534356 | 534356 | 2020-09-14 | Juneau | Wisconsin | 55057 | 276 | 1 |
531121 | 531121 | 2020-09-13 | Juneau | Wisconsin | 55057 | 274 | 1 |
527884 | 527884 | 2020-09-12 | Juneau | Wisconsin | 55057 | 270 | 1 |
524648 | 524648 | 2020-09-11 | Juneau | Wisconsin | 55057 | 264 | 1 |
521412 | 521412 | 2020-09-10 | Juneau | Wisconsin | 55057 | 262 | 1 |
518175 | 518175 | 2020-09-09 | Juneau | Wisconsin | 55057 | 258 | 1 |
514940 | 514940 | 2020-09-08 | Juneau | Wisconsin | 55057 | 256 | 1 |
511707 | 511707 | 2020-09-07 | Juneau | Wisconsin | 55057 | 253 | 1 |
508474 | 508474 | 2020-09-06 | Juneau | Wisconsin | 55057 | 252 | 1 |
505242 | 505242 | 2020-09-05 | Juneau | Wisconsin | 55057 | 251 | 1 |
502008 | 502008 | 2020-09-04 | Juneau | Wisconsin | 55057 | 251 | 1 |
498774 | 498774 | 2020-09-03 | Juneau | Wisconsin | 55057 | 245 | 1 |
495541 | 495541 | 2020-09-02 | Juneau | Wisconsin | 55057 | 240 | 1 |
492307 | 492307 | 2020-09-01 | Juneau | Wisconsin | 55057 | 238 | 1 |
489074 | 489074 | 2020-08-31 | Juneau | Wisconsin | 55057 | 199 | 1 |
485841 | 485841 | 2020-08-30 | Juneau | Wisconsin | 55057 | 197 | 1 |
482606 | 482606 | 2020-08-29 | Juneau | Wisconsin | 55057 | 193 | 1 |
479372 | 479372 | 2020-08-28 | Juneau | Wisconsin | 55057 | 189 | 1 |
476139 | 476139 | 2020-08-27 | Juneau | Wisconsin | 55057 | 188 | 1 |
472906 | 472906 | 2020-08-26 | Juneau | Wisconsin | 55057 | 182 | 1 |
469674 | 469674 | 2020-08-25 | Juneau | Wisconsin | 55057 | 177 | 1 |
466445 | 466445 | 2020-08-24 | Juneau | Wisconsin | 55057 | 173 | 1 |
463216 | 463216 | 2020-08-23 | Juneau | Wisconsin | 55057 | 171 | 1 |
459987 | 459987 | 2020-08-22 | Juneau | Wisconsin | 55057 | 169 | 1 |
456760 | 456760 | 2020-08-21 | Juneau | Wisconsin | 55057 | 163 | 1 |
453532 | 453532 | 2020-08-20 | Juneau | Wisconsin | 55057 | 162 | 1 |
450304 | 450304 | 2020-08-19 | Juneau | Wisconsin | 55057 | 155 | 1 |
447076 | 447076 | 2020-08-18 | Juneau | Wisconsin | 55057 | 153 | 1 |
443849 | 443849 | 2020-08-17 | Juneau | Wisconsin | 55057 | 152 | 1 |
440623 | 440623 | 2020-08-16 | Juneau | Wisconsin | 55057 | 152 | 1 |
437397 | 437397 | 2020-08-15 | Juneau | Wisconsin | 55057 | 151 | 1 |
434171 | 434171 | 2020-08-14 | Juneau | Wisconsin | 55057 | 149 | 1 |
430946 | 430946 | 2020-08-13 | Juneau | Wisconsin | 55057 | 145 | 1 |
427718 | 427718 | 2020-08-12 | Juneau | Wisconsin | 55057 | 139 | 1 |
424494 | 424494 | 2020-08-11 | Juneau | Wisconsin | 55057 | 138 | 1 |
421273 | 421273 | 2020-08-10 | Juneau | Wisconsin | 55057 | 138 | 1 |
418052 | 418052 | 2020-08-09 | Juneau | Wisconsin | 55057 | 137 | 1 |
414831 | 414831 | 2020-08-08 | Juneau | Wisconsin | 55057 | 137 | 1 |
411611 | 411611 | 2020-08-07 | Juneau | Wisconsin | 55057 | 135 | 1 |
408392 | 408392 | 2020-08-06 | Juneau | Wisconsin | 55057 | 135 | 1 |
405172 | 405172 | 2020-08-05 | Juneau | Wisconsin | 55057 | 133 | 1 |
401954 | 401954 | 2020-08-04 | Juneau | Wisconsin | 55057 | 129 | 1 |
398738 | 398738 | 2020-08-03 | Juneau | Wisconsin | 55057 | 129 | 1 |
395522 | 395522 | 2020-08-02 | Juneau | Wisconsin | 55057 | 129 | 1 |
392306 | 392306 | 2020-08-01 | Juneau | Wisconsin | 55057 | 122 | 1 |
389089 | 389089 | 2020-07-31 | Juneau | Wisconsin | 55057 | 119 | 1 |
385872 | 385872 | 2020-07-30 | Juneau | Wisconsin | 55057 | 117 | 1 |
382654 | 382654 | 2020-07-29 | Juneau | Wisconsin | 55057 | 114 | 1 |
379437 | 379437 | 2020-07-28 | Juneau | Wisconsin | 55057 | 112 | 1 |
376221 | 376221 | 2020-07-27 | Juneau | Wisconsin | 55057 | 109 | 1 |
373007 | 373007 | 2020-07-26 | Juneau | Wisconsin | 55057 | 107 | 1 |
369795 | 369795 | 2020-07-25 | Juneau | Wisconsin | 55057 | 98 | 1 |
366585 | 366585 | 2020-07-24 | Juneau | Wisconsin | 55057 | 86 | 1 |
363378 | 363378 | 2020-07-23 | Juneau | Wisconsin | 55057 | 84 | 1 |
360172 | 360172 | 2020-07-22 | Juneau | Wisconsin | 55057 | 80 | 1 |
356967 | 356967 | 2020-07-21 | Juneau | Wisconsin | 55057 | 77 | 1 |
353764 | 353764 | 2020-07-20 | Juneau | Wisconsin | 55057 | 76 | 1 |
350562 | 350562 | 2020-07-19 | Juneau | Wisconsin | 55057 | 74 | 1 |
347361 | 347361 | 2020-07-18 | Juneau | Wisconsin | 55057 | 73 | 1 |
344161 | 344161 | 2020-07-17 | Juneau | Wisconsin | 55057 | 69 | 1 |
340962 | 340962 | 2020-07-16 | Juneau | Wisconsin | 55057 | 66 | 1 |
337766 | 337766 | 2020-07-15 | Juneau | Wisconsin | 55057 | 59 | 1 |
334571 | 334571 | 2020-07-14 | Juneau | Wisconsin | 55057 | 54 | 1 |
331378 | 331378 | 2020-07-13 | Juneau | Wisconsin | 55057 | 52 | 1 |
328192 | 328192 | 2020-07-12 | Juneau | Wisconsin | 55057 | 51 | 1 |
325006 | 325006 | 2020-07-11 | Juneau | Wisconsin | 55057 | 50 | 1 |
321825 | 321825 | 2020-07-10 | Juneau | Wisconsin | 55057 | 50 | 1 |
318646 | 318646 | 2020-07-09 | Juneau | Wisconsin | 55057 | 47 | 1 |
315473 | 315473 | 2020-07-08 | Juneau | Wisconsin | 55057 | 44 | 1 |
312298 | 312298 | 2020-07-07 | Juneau | Wisconsin | 55057 | 43 | 1 |
309129 | 309129 | 2020-07-06 | Juneau | Wisconsin | 55057 | 43 | 1 |
305960 | 305960 | 2020-07-05 | Juneau | Wisconsin | 55057 | 43 | 1 |
302796 | 302796 | 2020-07-04 | Juneau | Wisconsin | 55057 | 43 | 1 |
299632 | 299632 | 2020-07-03 | Juneau | Wisconsin | 55057 | 42 | 1 |
296470 | 296470 | 2020-07-02 | Juneau | Wisconsin | 55057 | 40 | 1 |
293315 | 293315 | 2020-07-01 | Juneau | Wisconsin | 55057 | 39 | 1 |
290162 | 290162 | 2020-06-30 | Juneau | Wisconsin | 55057 | 36 | 1 |
287012 | 287012 | 2020-06-29 | Juneau | Wisconsin | 55057 | 35 | 1 |
283866 | 283866 | 2020-06-28 | Juneau | Wisconsin | 55057 | 32 | 1 |
280720 | 280720 | 2020-06-27 | Juneau | Wisconsin | 55057 | 32 | 1 |
277572 | 277572 | 2020-06-26 | Juneau | Wisconsin | 55057 | 31 | 1 |
274424 | 274424 | 2020-06-25 | Juneau | Wisconsin | 55057 | 31 | 1 |
271284 | 271284 | 2020-06-24 | Juneau | Wisconsin | 55057 | 31 | 1 |
268150 | 268150 | 2020-06-23 | Juneau | Wisconsin | 55057 | 29 | 1 |
265021 | 265021 | 2020-06-22 | Juneau | Wisconsin | 55057 | 29 | 1 |
261892 | 261892 | 2020-06-21 | Juneau | Wisconsin | 55057 | 28 | 1 |
258765 | 258765 | 2020-06-20 | Juneau | Wisconsin | 55057 | 27 | 1 |
255638 | 255638 | 2020-06-19 | Juneau | Wisconsin | 55057 | 27 | 1 |
252519 | 252519 | 2020-06-18 | Juneau | Wisconsin | 55057 | 27 | 1 |
249404 | 249404 | 2020-06-17 | Juneau | Wisconsin | 55057 | 25 | 1 |
246292 | 246292 | 2020-06-16 | Juneau | Wisconsin | 55057 | 25 | 1 |
243179 | 243179 | 2020-06-15 | Juneau | Wisconsin | 55057 | 25 | 1 |
240068 | 240068 | 2020-06-14 | Juneau | Wisconsin | 55057 | 25 | 1 |
236960 | 236960 | 2020-06-13 | Juneau | Wisconsin | 55057 | 24 | 1 |
233853 | 233853 | 2020-06-12 | Juneau | Wisconsin | 55057 | 24 | 1 |
230748 | 230748 | 2020-06-11 | Juneau | Wisconsin | 55057 | 24 | 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);