ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where deaths = 1, fips = 55063 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 |
---|---|---|---|---|---|---|---|
492310 | 492310 | 2020-09-01 | La Crosse | Wisconsin | 55063 | 1202 | 1 |
489077 | 489077 | 2020-08-31 | La Crosse | Wisconsin | 55063 | 1182 | 1 |
485844 | 485844 | 2020-08-30 | La Crosse | Wisconsin | 55063 | 1177 | 1 |
482609 | 482609 | 2020-08-29 | La Crosse | Wisconsin | 55063 | 1156 | 1 |
479375 | 479375 | 2020-08-28 | La Crosse | Wisconsin | 55063 | 1133 | 1 |
476142 | 476142 | 2020-08-27 | La Crosse | Wisconsin | 55063 | 1109 | 1 |
472909 | 472909 | 2020-08-26 | La Crosse | Wisconsin | 55063 | 1077 | 1 |
469677 | 469677 | 2020-08-25 | La Crosse | Wisconsin | 55063 | 1060 | 1 |
466448 | 466448 | 2020-08-24 | La Crosse | Wisconsin | 55063 | 1047 | 1 |
463219 | 463219 | 2020-08-23 | La Crosse | Wisconsin | 55063 | 1038 | 1 |
459990 | 459990 | 2020-08-22 | La Crosse | Wisconsin | 55063 | 1030 | 1 |
456763 | 456763 | 2020-08-21 | La Crosse | Wisconsin | 55063 | 1016 | 1 |
453535 | 453535 | 2020-08-20 | La Crosse | Wisconsin | 55063 | 1008 | 1 |
450307 | 450307 | 2020-08-19 | La Crosse | Wisconsin | 55063 | 987 | 1 |
447079 | 447079 | 2020-08-18 | La Crosse | Wisconsin | 55063 | 977 | 1 |
443852 | 443852 | 2020-08-17 | La Crosse | Wisconsin | 55063 | 973 | 1 |
440626 | 440626 | 2020-08-16 | La Crosse | Wisconsin | 55063 | 967 | 1 |
437400 | 437400 | 2020-08-15 | La Crosse | Wisconsin | 55063 | 959 | 1 |
434174 | 434174 | 2020-08-14 | La Crosse | Wisconsin | 55063 | 951 | 1 |
430949 | 430949 | 2020-08-13 | La Crosse | Wisconsin | 55063 | 945 | 1 |
427721 | 427721 | 2020-08-12 | La Crosse | Wisconsin | 55063 | 932 | 1 |
424497 | 424497 | 2020-08-11 | La Crosse | Wisconsin | 55063 | 921 | 1 |
421276 | 421276 | 2020-08-10 | La Crosse | Wisconsin | 55063 | 914 | 1 |
418055 | 418055 | 2020-08-09 | La Crosse | Wisconsin | 55063 | 908 | 1 |
414834 | 414834 | 2020-08-08 | La Crosse | Wisconsin | 55063 | 896 | 1 |
411614 | 411614 | 2020-08-07 | La Crosse | Wisconsin | 55063 | 889 | 1 |
408395 | 408395 | 2020-08-06 | La Crosse | Wisconsin | 55063 | 881 | 1 |
405175 | 405175 | 2020-08-05 | La Crosse | Wisconsin | 55063 | 854 | 1 |
401957 | 401957 | 2020-08-04 | La Crosse | Wisconsin | 55063 | 836 | 1 |
398741 | 398741 | 2020-08-03 | La Crosse | Wisconsin | 55063 | 825 | 1 |
395525 | 395525 | 2020-08-02 | La Crosse | Wisconsin | 55063 | 821 | 1 |
392309 | 392309 | 2020-08-01 | La Crosse | Wisconsin | 55063 | 795 | 1 |
389092 | 389092 | 2020-07-31 | La Crosse | Wisconsin | 55063 | 788 | 1 |
385875 | 385875 | 2020-07-30 | La Crosse | Wisconsin | 55063 | 775 | 1 |
382657 | 382657 | 2020-07-29 | La Crosse | Wisconsin | 55063 | 762 | 1 |
379440 | 379440 | 2020-07-28 | La Crosse | Wisconsin | 55063 | 759 | 1 |
376224 | 376224 | 2020-07-27 | La Crosse | Wisconsin | 55063 | 754 | 1 |
373010 | 373010 | 2020-07-26 | La Crosse | Wisconsin | 55063 | 735 | 1 |
369798 | 369798 | 2020-07-25 | La Crosse | Wisconsin | 55063 | 725 | 1 |
366588 | 366588 | 2020-07-24 | La Crosse | Wisconsin | 55063 | 715 | 1 |
363381 | 363381 | 2020-07-23 | La Crosse | Wisconsin | 55063 | 697 | 1 |
360175 | 360175 | 2020-07-22 | La Crosse | Wisconsin | 55063 | 685 | 1 |
356970 | 356970 | 2020-07-21 | La Crosse | Wisconsin | 55063 | 685 | 1 |
353767 | 353767 | 2020-07-20 | La Crosse | Wisconsin | 55063 | 674 | 1 |
350565 | 350565 | 2020-07-19 | La Crosse | Wisconsin | 55063 | 667 | 1 |
347364 | 347364 | 2020-07-18 | La Crosse | Wisconsin | 55063 | 660 | 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);