ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where county = "Bayfield", deaths = 1, fips = 55007 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 |
---|---|---|---|---|---|---|---|
670488 | 670488 | 2020-10-26 | Bayfield | Wisconsin | 55007 | 231 | 1 |
667245 | 667245 | 2020-10-25 | Bayfield | Wisconsin | 55007 | 218 | 1 |
664000 | 664000 | 2020-10-24 | Bayfield | Wisconsin | 55007 | 214 | 1 |
660756 | 660756 | 2020-10-23 | Bayfield | Wisconsin | 55007 | 210 | 1 |
657512 | 657512 | 2020-10-22 | Bayfield | Wisconsin | 55007 | 202 | 1 |
654267 | 654267 | 2020-10-21 | Bayfield | Wisconsin | 55007 | 196 | 1 |
651022 | 651022 | 2020-10-20 | Bayfield | Wisconsin | 55007 | 194 | 1 |
647778 | 647778 | 2020-10-19 | Bayfield | Wisconsin | 55007 | 186 | 1 |
644532 | 644532 | 2020-10-18 | Bayfield | Wisconsin | 55007 | 178 | 1 |
641284 | 641284 | 2020-10-17 | Bayfield | Wisconsin | 55007 | 178 | 1 |
638037 | 638037 | 2020-10-16 | Bayfield | Wisconsin | 55007 | 178 | 1 |
634792 | 634792 | 2020-10-15 | Bayfield | Wisconsin | 55007 | 176 | 1 |
631547 | 631547 | 2020-10-14 | Bayfield | Wisconsin | 55007 | 170 | 1 |
628303 | 628303 | 2020-10-13 | Bayfield | Wisconsin | 55007 | 166 | 1 |
625060 | 625060 | 2020-10-12 | Bayfield | Wisconsin | 55007 | 159 | 1 |
621817 | 621817 | 2020-10-11 | Bayfield | Wisconsin | 55007 | 159 | 1 |
618574 | 618574 | 2020-10-10 | Bayfield | Wisconsin | 55007 | 156 | 1 |
615332 | 615332 | 2020-10-09 | Bayfield | Wisconsin | 55007 | 145 | 1 |
612091 | 612091 | 2020-10-08 | Bayfield | Wisconsin | 55007 | 141 | 1 |
608849 | 608849 | 2020-10-07 | Bayfield | Wisconsin | 55007 | 141 | 1 |
605606 | 605606 | 2020-10-06 | Bayfield | Wisconsin | 55007 | 141 | 1 |
602364 | 602364 | 2020-10-05 | Bayfield | Wisconsin | 55007 | 140 | 1 |
599121 | 599121 | 2020-10-04 | Bayfield | Wisconsin | 55007 | 136 | 1 |
595878 | 595878 | 2020-10-03 | Bayfield | Wisconsin | 55007 | 134 | 1 |
592636 | 592636 | 2020-10-02 | Bayfield | Wisconsin | 55007 | 130 | 1 |
589396 | 589396 | 2020-10-01 | Bayfield | Wisconsin | 55007 | 129 | 1 |
586155 | 586155 | 2020-09-30 | Bayfield | Wisconsin | 55007 | 125 | 1 |
582915 | 582915 | 2020-09-29 | Bayfield | Wisconsin | 55007 | 123 | 1 |
579676 | 579676 | 2020-09-28 | Bayfield | Wisconsin | 55007 | 115 | 1 |
576435 | 576435 | 2020-09-27 | Bayfield | Wisconsin | 55007 | 110 | 1 |
573191 | 573191 | 2020-09-26 | Bayfield | Wisconsin | 55007 | 109 | 1 |
569949 | 569949 | 2020-09-25 | Bayfield | Wisconsin | 55007 | 105 | 1 |
566708 | 566708 | 2020-09-24 | Bayfield | Wisconsin | 55007 | 101 | 1 |
563467 | 563467 | 2020-09-23 | Bayfield | Wisconsin | 55007 | 97 | 1 |
560228 | 560228 | 2020-09-22 | Bayfield | Wisconsin | 55007 | 94 | 1 |
556992 | 556992 | 2020-09-21 | Bayfield | Wisconsin | 55007 | 91 | 1 |
553755 | 553755 | 2020-09-20 | Bayfield | Wisconsin | 55007 | 90 | 1 |
550516 | 550516 | 2020-09-19 | Bayfield | Wisconsin | 55007 | 86 | 1 |
547277 | 547277 | 2020-09-18 | Bayfield | Wisconsin | 55007 | 84 | 1 |
544040 | 544040 | 2020-09-17 | Bayfield | Wisconsin | 55007 | 81 | 1 |
540804 | 540804 | 2020-09-16 | Bayfield | Wisconsin | 55007 | 79 | 1 |
537567 | 537567 | 2020-09-15 | Bayfield | Wisconsin | 55007 | 77 | 1 |
534331 | 534331 | 2020-09-14 | Bayfield | Wisconsin | 55007 | 75 | 1 |
531096 | 531096 | 2020-09-13 | Bayfield | Wisconsin | 55007 | 74 | 1 |
527859 | 527859 | 2020-09-12 | Bayfield | Wisconsin | 55007 | 74 | 1 |
524623 | 524623 | 2020-09-11 | Bayfield | Wisconsin | 55007 | 74 | 1 |
521387 | 521387 | 2020-09-10 | Bayfield | Wisconsin | 55007 | 74 | 1 |
518150 | 518150 | 2020-09-09 | Bayfield | Wisconsin | 55007 | 72 | 1 |
514915 | 514915 | 2020-09-08 | Bayfield | Wisconsin | 55007 | 67 | 1 |
511682 | 511682 | 2020-09-07 | Bayfield | Wisconsin | 55007 | 65 | 1 |
508449 | 508449 | 2020-09-06 | Bayfield | Wisconsin | 55007 | 64 | 1 |
505217 | 505217 | 2020-09-05 | Bayfield | Wisconsin | 55007 | 61 | 1 |
501983 | 501983 | 2020-09-04 | Bayfield | Wisconsin | 55007 | 59 | 1 |
498749 | 498749 | 2020-09-03 | Bayfield | Wisconsin | 55007 | 47 | 1 |
495516 | 495516 | 2020-09-02 | Bayfield | Wisconsin | 55007 | 47 | 1 |
492282 | 492282 | 2020-09-01 | Bayfield | Wisconsin | 55007 | 46 | 1 |
489049 | 489049 | 2020-08-31 | Bayfield | Wisconsin | 55007 | 45 | 1 |
485816 | 485816 | 2020-08-30 | Bayfield | Wisconsin | 55007 | 45 | 1 |
482581 | 482581 | 2020-08-29 | Bayfield | Wisconsin | 55007 | 44 | 1 |
479347 | 479347 | 2020-08-28 | Bayfield | Wisconsin | 55007 | 43 | 1 |
476114 | 476114 | 2020-08-27 | Bayfield | Wisconsin | 55007 | 42 | 1 |
472881 | 472881 | 2020-08-26 | Bayfield | Wisconsin | 55007 | 41 | 1 |
469649 | 469649 | 2020-08-25 | Bayfield | Wisconsin | 55007 | 42 | 1 |
466420 | 466420 | 2020-08-24 | Bayfield | Wisconsin | 55007 | 41 | 1 |
463191 | 463191 | 2020-08-23 | Bayfield | Wisconsin | 55007 | 41 | 1 |
459962 | 459962 | 2020-08-22 | Bayfield | Wisconsin | 55007 | 41 | 1 |
456735 | 456735 | 2020-08-21 | Bayfield | Wisconsin | 55007 | 40 | 1 |
453507 | 453507 | 2020-08-20 | Bayfield | Wisconsin | 55007 | 40 | 1 |
450279 | 450279 | 2020-08-19 | Bayfield | Wisconsin | 55007 | 39 | 1 |
447051 | 447051 | 2020-08-18 | Bayfield | Wisconsin | 55007 | 39 | 1 |
443824 | 443824 | 2020-08-17 | Bayfield | Wisconsin | 55007 | 37 | 1 |
440598 | 440598 | 2020-08-16 | Bayfield | Wisconsin | 55007 | 34 | 1 |
437372 | 437372 | 2020-08-15 | Bayfield | Wisconsin | 55007 | 32 | 1 |
434146 | 434146 | 2020-08-14 | Bayfield | Wisconsin | 55007 | 32 | 1 |
430921 | 430921 | 2020-08-13 | Bayfield | Wisconsin | 55007 | 30 | 1 |
427693 | 427693 | 2020-08-12 | Bayfield | Wisconsin | 55007 | 29 | 1 |
424469 | 424469 | 2020-08-11 | Bayfield | Wisconsin | 55007 | 29 | 1 |
421248 | 421248 | 2020-08-10 | Bayfield | Wisconsin | 55007 | 28 | 1 |
418027 | 418027 | 2020-08-09 | Bayfield | Wisconsin | 55007 | 27 | 1 |
414806 | 414806 | 2020-08-08 | Bayfield | Wisconsin | 55007 | 23 | 1 |
411586 | 411586 | 2020-08-07 | Bayfield | Wisconsin | 55007 | 22 | 1 |
408367 | 408367 | 2020-08-06 | Bayfield | Wisconsin | 55007 | 21 | 1 |
405147 | 405147 | 2020-08-05 | Bayfield | Wisconsin | 55007 | 21 | 1 |
401929 | 401929 | 2020-08-04 | Bayfield | Wisconsin | 55007 | 21 | 1 |
398713 | 398713 | 2020-08-03 | Bayfield | Wisconsin | 55007 | 20 | 1 |
395497 | 395497 | 2020-08-02 | Bayfield | Wisconsin | 55007 | 20 | 1 |
392281 | 392281 | 2020-08-01 | Bayfield | Wisconsin | 55007 | 19 | 1 |
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 |
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);