ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 5, fips = 27071 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 |
---|---|---|---|---|---|---|---|
775759 | 775759 | 2020-11-28 | Koochiching | Minnesota | 27071 | 385 | 5 |
772514 | 772514 | 2020-11-27 | Koochiching | Minnesota | 27071 | 367 | 5 |
769269 | 769269 | 2020-11-26 | Koochiching | Minnesota | 27071 | 353 | 5 |
766023 | 766023 | 2020-11-25 | Koochiching | Minnesota | 27071 | 353 | 5 |
762778 | 762778 | 2020-11-24 | Koochiching | Minnesota | 27071 | 347 | 5 |
759533 | 759533 | 2020-11-23 | Koochiching | Minnesota | 27071 | 332 | 5 |
756286 | 756286 | 2020-11-22 | Koochiching | Minnesota | 27071 | 327 | 5 |
753040 | 753040 | 2020-11-21 | Koochiching | Minnesota | 27071 | 315 | 5 |
749794 | 749794 | 2020-11-20 | Koochiching | Minnesota | 27071 | 308 | 5 |
746548 | 746548 | 2020-11-19 | Koochiching | Minnesota | 27071 | 300 | 5 |
743301 | 743301 | 2020-11-18 | Koochiching | Minnesota | 27071 | 293 | 5 |
740054 | 740054 | 2020-11-17 | Koochiching | Minnesota | 27071 | 285 | 5 |
736810 | 736810 | 2020-11-16 | Koochiching | Minnesota | 27071 | 269 | 5 |
733564 | 733564 | 2020-11-15 | Koochiching | Minnesota | 27071 | 264 | 5 |
730319 | 730319 | 2020-11-14 | Koochiching | Minnesota | 27071 | 256 | 5 |
727076 | 727076 | 2020-11-13 | Koochiching | Minnesota | 27071 | 243 | 5 |
723833 | 723833 | 2020-11-12 | Koochiching | Minnesota | 27071 | 238 | 5 |
720590 | 720590 | 2020-11-11 | Koochiching | Minnesota | 27071 | 229 | 5 |
717347 | 717347 | 2020-11-10 | Koochiching | Minnesota | 27071 | 221 | 5 |
714103 | 714103 | 2020-11-09 | Koochiching | Minnesota | 27071 | 210 | 5 |
710859 | 710859 | 2020-11-08 | Koochiching | Minnesota | 27071 | 206 | 5 |
707615 | 707615 | 2020-11-07 | Koochiching | Minnesota | 27071 | 200 | 5 |
704372 | 704372 | 2020-11-06 | Koochiching | Minnesota | 27071 | 196 | 5 |
701130 | 701130 | 2020-11-05 | Koochiching | Minnesota | 27071 | 197 | 5 |
697886 | 697886 | 2020-11-04 | Koochiching | Minnesota | 27071 | 192 | 5 |
694643 | 694643 | 2020-11-03 | Koochiching | Minnesota | 27071 | 187 | 5 |
691401 | 691401 | 2020-11-02 | Koochiching | Minnesota | 27071 | 185 | 5 |
688156 | 688156 | 2020-11-01 | Koochiching | Minnesota | 27071 | 185 | 5 |
684912 | 684912 | 2020-10-31 | Koochiching | Minnesota | 27071 | 183 | 5 |
681669 | 681669 | 2020-10-30 | Koochiching | Minnesota | 27071 | 177 | 5 |
678425 | 678425 | 2020-10-29 | Koochiching | Minnesota | 27071 | 175 | 5 |
675183 | 675183 | 2020-10-28 | Koochiching | Minnesota | 27071 | 176 | 5 |
671940 | 671940 | 2020-10-27 | Koochiching | Minnesota | 27071 | 172 | 5 |
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);