ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where county = "Waseca", deaths = 9, fips = 27161 and state = "Minnesota" 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 |
---|---|---|---|---|---|---|---|
675229 | 675229 | 2020-10-28 | Waseca | Minnesota | 27161 | 941 | 9 |
671986 | 671986 | 2020-10-27 | Waseca | Minnesota | 27161 | 937 | 9 |
668744 | 668744 | 2020-10-26 | Waseca | Minnesota | 27161 | 929 | 9 |
665500 | 665500 | 2020-10-25 | Waseca | Minnesota | 27161 | 928 | 9 |
662255 | 662255 | 2020-10-24 | Waseca | Minnesota | 27161 | 927 | 9 |
659011 | 659011 | 2020-10-23 | Waseca | Minnesota | 27161 | 922 | 9 |
655766 | 655766 | 2020-10-22 | Waseca | Minnesota | 27161 | 919 | 9 |
652521 | 652521 | 2020-10-21 | Waseca | Minnesota | 27161 | 918 | 9 |
649276 | 649276 | 2020-10-20 | Waseca | Minnesota | 27161 | 911 | 9 |
646032 | 646032 | 2020-10-19 | Waseca | Minnesota | 27161 | 912 | 9 |
642785 | 642785 | 2020-10-18 | Waseca | Minnesota | 27161 | 908 | 9 |
639538 | 639538 | 2020-10-17 | Waseca | Minnesota | 27161 | 904 | 9 |
636292 | 636292 | 2020-10-16 | Waseca | Minnesota | 27161 | 893 | 9 |
633046 | 633046 | 2020-10-15 | Waseca | Minnesota | 27161 | 885 | 9 |
629801 | 629801 | 2020-10-14 | Waseca | Minnesota | 27161 | 881 | 9 |
626557 | 626557 | 2020-10-13 | Waseca | Minnesota | 27161 | 878 | 9 |
623315 | 623315 | 2020-10-12 | Waseca | Minnesota | 27161 | 877 | 9 |
620072 | 620072 | 2020-10-11 | Waseca | Minnesota | 27161 | 875 | 9 |
616830 | 616830 | 2020-10-10 | Waseca | Minnesota | 27161 | 852 | 9 |
613589 | 613589 | 2020-10-09 | Waseca | Minnesota | 27161 | 844 | 9 |
610347 | 610347 | 2020-10-08 | Waseca | Minnesota | 27161 | 840 | 9 |
607105 | 607105 | 2020-10-07 | Waseca | Minnesota | 27161 | 837 | 9 |
603862 | 603862 | 2020-10-06 | Waseca | Minnesota | 27161 | 822 | 9 |
600620 | 600620 | 2020-10-05 | Waseca | Minnesota | 27161 | 820 | 9 |
597377 | 597377 | 2020-10-04 | Waseca | Minnesota | 27161 | 819 | 9 |
594136 | 594136 | 2020-10-03 | Waseca | Minnesota | 27161 | 817 | 9 |
590895 | 590895 | 2020-10-02 | Waseca | Minnesota | 27161 | 770 | 9 |
587654 | 587654 | 2020-10-01 | Waseca | Minnesota | 27161 | 768 | 9 |
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);