ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where deaths = 0 and fips = 55023 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 |
---|---|---|---|---|---|---|---|
673738 | 673738 | 2020-10-27 | Crawford | Wisconsin | 55023 | 335 | 0 |
670496 | 670496 | 2020-10-26 | Crawford | Wisconsin | 55023 | 330 | 0 |
667253 | 667253 | 2020-10-25 | Crawford | Wisconsin | 55023 | 323 | 0 |
664008 | 664008 | 2020-10-24 | Crawford | Wisconsin | 55023 | 320 | 0 |
660764 | 660764 | 2020-10-23 | Crawford | Wisconsin | 55023 | 318 | 0 |
657520 | 657520 | 2020-10-22 | Crawford | Wisconsin | 55023 | 315 | 0 |
654275 | 654275 | 2020-10-21 | Crawford | Wisconsin | 55023 | 307 | 0 |
651030 | 651030 | 2020-10-20 | Crawford | Wisconsin | 55023 | 304 | 0 |
647786 | 647786 | 2020-10-19 | Crawford | Wisconsin | 55023 | 303 | 0 |
644540 | 644540 | 2020-10-18 | Crawford | Wisconsin | 55023 | 291 | 0 |
641292 | 641292 | 2020-10-17 | Crawford | Wisconsin | 55023 | 291 | 0 |
638045 | 638045 | 2020-10-16 | Crawford | Wisconsin | 55023 | 291 | 0 |
634800 | 634800 | 2020-10-15 | Crawford | Wisconsin | 55023 | 275 | 0 |
631555 | 631555 | 2020-10-14 | Crawford | Wisconsin | 55023 | 268 | 0 |
628311 | 628311 | 2020-10-13 | Crawford | Wisconsin | 55023 | 261 | 0 |
625068 | 625068 | 2020-10-12 | Crawford | Wisconsin | 55023 | 248 | 0 |
621825 | 621825 | 2020-10-11 | Crawford | Wisconsin | 55023 | 246 | 0 |
618582 | 618582 | 2020-10-10 | Crawford | Wisconsin | 55023 | 244 | 0 |
615340 | 615340 | 2020-10-09 | Crawford | Wisconsin | 55023 | 233 | 0 |
612099 | 612099 | 2020-10-08 | Crawford | Wisconsin | 55023 | 226 | 0 |
608857 | 608857 | 2020-10-07 | Crawford | Wisconsin | 55023 | 216 | 0 |
605614 | 605614 | 2020-10-06 | Crawford | Wisconsin | 55023 | 212 | 0 |
602372 | 602372 | 2020-10-05 | Crawford | Wisconsin | 55023 | 209 | 0 |
599129 | 599129 | 2020-10-04 | Crawford | Wisconsin | 55023 | 204 | 0 |
595886 | 595886 | 2020-10-03 | Crawford | Wisconsin | 55023 | 199 | 0 |
592644 | 592644 | 2020-10-02 | Crawford | Wisconsin | 55023 | 192 | 0 |
589404 | 589404 | 2020-10-01 | Crawford | Wisconsin | 55023 | 188 | 0 |
586163 | 586163 | 2020-09-30 | Crawford | Wisconsin | 55023 | 183 | 0 |
582923 | 582923 | 2020-09-29 | Crawford | Wisconsin | 55023 | 177 | 0 |
579684 | 579684 | 2020-09-28 | Crawford | Wisconsin | 55023 | 172 | 0 |
576443 | 576443 | 2020-09-27 | Crawford | Wisconsin | 55023 | 168 | 0 |
573199 | 573199 | 2020-09-26 | Crawford | Wisconsin | 55023 | 164 | 0 |
569957 | 569957 | 2020-09-25 | Crawford | Wisconsin | 55023 | 160 | 0 |
566716 | 566716 | 2020-09-24 | Crawford | Wisconsin | 55023 | 156 | 0 |
563475 | 563475 | 2020-09-23 | Crawford | Wisconsin | 55023 | 151 | 0 |
560236 | 560236 | 2020-09-22 | Crawford | Wisconsin | 55023 | 145 | 0 |
557000 | 557000 | 2020-09-21 | Crawford | Wisconsin | 55023 | 145 | 0 |
553763 | 553763 | 2020-09-20 | Crawford | Wisconsin | 55023 | 142 | 0 |
550524 | 550524 | 2020-09-19 | Crawford | Wisconsin | 55023 | 143 | 0 |
547285 | 547285 | 2020-09-18 | Crawford | Wisconsin | 55023 | 139 | 0 |
544048 | 544048 | 2020-09-17 | Crawford | Wisconsin | 55023 | 137 | 0 |
540812 | 540812 | 2020-09-16 | Crawford | Wisconsin | 55023 | 135 | 0 |
537575 | 537575 | 2020-09-15 | Crawford | Wisconsin | 55023 | 136 | 0 |
534339 | 534339 | 2020-09-14 | Crawford | Wisconsin | 55023 | 134 | 0 |
531104 | 531104 | 2020-09-13 | Crawford | Wisconsin | 55023 | 131 | 0 |
527867 | 527867 | 2020-09-12 | Crawford | Wisconsin | 55023 | 130 | 0 |
524631 | 524631 | 2020-09-11 | Crawford | Wisconsin | 55023 | 129 | 0 |
521395 | 521395 | 2020-09-10 | Crawford | Wisconsin | 55023 | 126 | 0 |
518158 | 518158 | 2020-09-09 | Crawford | Wisconsin | 55023 | 126 | 0 |
514923 | 514923 | 2020-09-08 | Crawford | Wisconsin | 55023 | 125 | 0 |
511690 | 511690 | 2020-09-07 | Crawford | Wisconsin | 55023 | 125 | 0 |
508457 | 508457 | 2020-09-06 | Crawford | Wisconsin | 55023 | 125 | 0 |
505225 | 505225 | 2020-09-05 | Crawford | Wisconsin | 55023 | 124 | 0 |
501991 | 501991 | 2020-09-04 | Crawford | Wisconsin | 55023 | 118 | 0 |
498757 | 498757 | 2020-09-03 | Crawford | Wisconsin | 55023 | 111 | 0 |
495524 | 495524 | 2020-09-02 | Crawford | Wisconsin | 55023 | 107 | 0 |
492290 | 492290 | 2020-09-01 | Crawford | Wisconsin | 55023 | 104 | 0 |
489057 | 489057 | 2020-08-31 | Crawford | Wisconsin | 55023 | 102 | 0 |
485824 | 485824 | 2020-08-30 | Crawford | Wisconsin | 55023 | 102 | 0 |
482589 | 482589 | 2020-08-29 | Crawford | Wisconsin | 55023 | 102 | 0 |
479355 | 479355 | 2020-08-28 | Crawford | Wisconsin | 55023 | 99 | 0 |
476122 | 476122 | 2020-08-27 | Crawford | Wisconsin | 55023 | 99 | 0 |
472889 | 472889 | 2020-08-26 | Crawford | Wisconsin | 55023 | 98 | 0 |
469657 | 469657 | 2020-08-25 | Crawford | Wisconsin | 55023 | 98 | 0 |
466428 | 466428 | 2020-08-24 | Crawford | Wisconsin | 55023 | 96 | 0 |
463199 | 463199 | 2020-08-23 | Crawford | Wisconsin | 55023 | 95 | 0 |
459970 | 459970 | 2020-08-22 | Crawford | Wisconsin | 55023 | 94 | 0 |
456743 | 456743 | 2020-08-21 | Crawford | Wisconsin | 55023 | 94 | 0 |
453515 | 453515 | 2020-08-20 | Crawford | Wisconsin | 55023 | 93 | 0 |
450287 | 450287 | 2020-08-19 | Crawford | Wisconsin | 55023 | 93 | 0 |
447059 | 447059 | 2020-08-18 | Crawford | Wisconsin | 55023 | 91 | 0 |
443832 | 443832 | 2020-08-17 | Crawford | Wisconsin | 55023 | 90 | 0 |
440606 | 440606 | 2020-08-16 | Crawford | Wisconsin | 55023 | 86 | 0 |
437380 | 437380 | 2020-08-15 | Crawford | Wisconsin | 55023 | 84 | 0 |
434154 | 434154 | 2020-08-14 | Crawford | Wisconsin | 55023 | 84 | 0 |
430929 | 430929 | 2020-08-13 | Crawford | Wisconsin | 55023 | 82 | 0 |
427701 | 427701 | 2020-08-12 | Crawford | Wisconsin | 55023 | 78 | 0 |
424477 | 424477 | 2020-08-11 | Crawford | Wisconsin | 55023 | 76 | 0 |
421256 | 421256 | 2020-08-10 | Crawford | Wisconsin | 55023 | 75 | 0 |
418035 | 418035 | 2020-08-09 | Crawford | Wisconsin | 55023 | 75 | 0 |
414814 | 414814 | 2020-08-08 | Crawford | Wisconsin | 55023 | 74 | 0 |
411594 | 411594 | 2020-08-07 | Crawford | Wisconsin | 55023 | 72 | 0 |
408375 | 408375 | 2020-08-06 | Crawford | Wisconsin | 55023 | 70 | 0 |
405155 | 405155 | 2020-08-05 | Crawford | Wisconsin | 55023 | 69 | 0 |
401937 | 401937 | 2020-08-04 | Crawford | Wisconsin | 55023 | 65 | 0 |
398721 | 398721 | 2020-08-03 | Crawford | Wisconsin | 55023 | 62 | 0 |
395505 | 395505 | 2020-08-02 | Crawford | Wisconsin | 55023 | 62 | 0 |
392289 | 392289 | 2020-08-01 | Crawford | Wisconsin | 55023 | 57 | 0 |
389072 | 389072 | 2020-07-31 | Crawford | Wisconsin | 55023 | 56 | 0 |
385855 | 385855 | 2020-07-30 | Crawford | Wisconsin | 55023 | 55 | 0 |
382637 | 382637 | 2020-07-29 | Crawford | Wisconsin | 55023 | 54 | 0 |
379420 | 379420 | 2020-07-28 | Crawford | Wisconsin | 55023 | 53 | 0 |
376204 | 376204 | 2020-07-27 | Crawford | Wisconsin | 55023 | 52 | 0 |
372990 | 372990 | 2020-07-26 | Crawford | Wisconsin | 55023 | 52 | 0 |
369778 | 369778 | 2020-07-25 | Crawford | Wisconsin | 55023 | 51 | 0 |
366568 | 366568 | 2020-07-24 | Crawford | Wisconsin | 55023 | 50 | 0 |
363361 | 363361 | 2020-07-23 | Crawford | Wisconsin | 55023 | 49 | 0 |
360155 | 360155 | 2020-07-22 | Crawford | Wisconsin | 55023 | 49 | 0 |
356950 | 356950 | 2020-07-21 | Crawford | Wisconsin | 55023 | 48 | 0 |
353747 | 353747 | 2020-07-20 | Crawford | Wisconsin | 55023 | 48 | 0 |
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);