ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
914 rows where deaths = 11 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Stevens 266
- Red Lake 72
- Koochiching 69
- Murray 55
- Steele 48
- Watonwan 39
- Wilkin 26
- Goodhue 23
- Dodge 22
- Waseca 21
- Marshall 16
- Kanabec 14
- Nicollet 14
- Jackson 13
- Renville 11
- Redwood 10
- St. Louis 10
- Crow Wing 9
- Faribault 9
- Grant 9
- Lyon 9
- Fillmore 8
- Wabasha 8
- Nobles 7
- Norman 7
- Unknown 7
- Blue Earth 6
- Le Sueur 6
- Rock 6
- Scott 6
- …
state 1
- Minnesota · 914 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2221122 | 2221122 | 2022-02-16 | Red Lake | Minnesota | 27125 | 918 | 11 |
2217871 | 2217871 | 2022-02-15 | Red Lake | Minnesota | 27125 | 917 | 11 |
2214620 | 2214620 | 2022-02-14 | Red Lake | Minnesota | 27125 | 910 | 11 |
2211368 | 2211368 | 2022-02-13 | Red Lake | Minnesota | 27125 | 905 | 11 |
2208115 | 2208115 | 2022-02-12 | Red Lake | Minnesota | 27125 | 905 | 11 |
2204862 | 2204862 | 2022-02-11 | Red Lake | Minnesota | 27125 | 905 | 11 |
2201609 | 2201609 | 2022-02-10 | Red Lake | Minnesota | 27125 | 902 | 11 |
2198355 | 2198355 | 2022-02-09 | Red Lake | Minnesota | 27125 | 900 | 11 |
2195101 | 2195101 | 2022-02-08 | Red Lake | Minnesota | 27125 | 897 | 11 |
2191847 | 2191847 | 2022-02-07 | Red Lake | Minnesota | 27125 | 891 | 11 |
2188594 | 2188594 | 2022-02-06 | Red Lake | Minnesota | 27125 | 888 | 11 |
2185341 | 2185341 | 2022-02-05 | Red Lake | Minnesota | 27125 | 888 | 11 |
2182089 | 2182089 | 2022-02-04 | Red Lake | Minnesota | 27125 | 888 | 11 |
2178837 | 2178837 | 2022-02-03 | Red Lake | Minnesota | 27125 | 886 | 11 |
2175585 | 2175585 | 2022-02-02 | Red Lake | Minnesota | 27125 | 881 | 11 |
2172332 | 2172332 | 2022-02-01 | Red Lake | Minnesota | 27125 | 876 | 11 |
2169079 | 2169079 | 2022-01-31 | Red Lake | Minnesota | 27125 | 855 | 11 |
2165824 | 2165824 | 2022-01-30 | Red Lake | Minnesota | 27125 | 849 | 11 |
2162569 | 2162569 | 2022-01-29 | Red Lake | Minnesota | 27125 | 849 | 11 |
2159314 | 2159314 | 2022-01-28 | Red Lake | Minnesota | 27125 | 849 | 11 |
2156060 | 2156060 | 2022-01-27 | Red Lake | Minnesota | 27125 | 843 | 11 |
2152807 | 2152807 | 2022-01-26 | Red Lake | Minnesota | 27125 | 827 | 11 |
2149555 | 2149555 | 2022-01-25 | Red Lake | Minnesota | 27125 | 819 | 11 |
2146303 | 2146303 | 2022-01-24 | Red Lake | Minnesota | 27125 | 806 | 11 |
2146315 | 2146315 | 2022-01-24 | Stevens | Minnesota | 27149 | 2182 | 11 |
2143048 | 2143048 | 2022-01-23 | Red Lake | Minnesota | 27125 | 804 | 11 |
2143060 | 2143060 | 2022-01-23 | Stevens | Minnesota | 27149 | 2170 | 11 |
2139793 | 2139793 | 2022-01-22 | Red Lake | Minnesota | 27125 | 804 | 11 |
2139805 | 2139805 | 2022-01-22 | Stevens | Minnesota | 27149 | 2170 | 11 |
2136537 | 2136537 | 2022-01-21 | Red Lake | Minnesota | 27125 | 804 | 11 |
2136549 | 2136549 | 2022-01-21 | Stevens | Minnesota | 27149 | 2170 | 11 |
2133285 | 2133285 | 2022-01-20 | Red Lake | Minnesota | 27125 | 796 | 11 |
2133297 | 2133297 | 2022-01-20 | Stevens | Minnesota | 27149 | 2152 | 11 |
2130032 | 2130032 | 2022-01-19 | Red Lake | Minnesota | 27125 | 787 | 11 |
2130044 | 2130044 | 2022-01-19 | Stevens | Minnesota | 27149 | 2125 | 11 |
2126769 | 2126769 | 2022-01-18 | Norman | Minnesota | 27107 | 1147 | 11 |
2126778 | 2126778 | 2022-01-18 | Red Lake | Minnesota | 27125 | 775 | 11 |
2126790 | 2126790 | 2022-01-18 | Stevens | Minnesota | 27149 | 2080 | 11 |
2123517 | 2123517 | 2022-01-17 | Norman | Minnesota | 27107 | 1139 | 11 |
2123526 | 2123526 | 2022-01-17 | Red Lake | Minnesota | 27125 | 770 | 11 |
2123538 | 2123538 | 2022-01-17 | Stevens | Minnesota | 27149 | 2058 | 11 |
2120265 | 2120265 | 2022-01-16 | Norman | Minnesota | 27107 | 1139 | 11 |
2120274 | 2120274 | 2022-01-16 | Red Lake | Minnesota | 27125 | 770 | 11 |
2120286 | 2120286 | 2022-01-16 | Stevens | Minnesota | 27149 | 2058 | 11 |
2117013 | 2117013 | 2022-01-15 | Norman | Minnesota | 27107 | 1139 | 11 |
2117022 | 2117022 | 2022-01-15 | Red Lake | Minnesota | 27125 | 770 | 11 |
2117034 | 2117034 | 2022-01-15 | Stevens | Minnesota | 27149 | 2058 | 11 |
2113762 | 2113762 | 2022-01-14 | Norman | Minnesota | 27107 | 1139 | 11 |
2113771 | 2113771 | 2022-01-14 | Red Lake | Minnesota | 27125 | 770 | 11 |
2113783 | 2113783 | 2022-01-14 | Stevens | Minnesota | 27149 | 2058 | 11 |
2110510 | 2110510 | 2022-01-13 | Norman | Minnesota | 27107 | 1134 | 11 |
2110519 | 2110519 | 2022-01-13 | Red Lake | Minnesota | 27125 | 773 | 11 |
2110531 | 2110531 | 2022-01-13 | Stevens | Minnesota | 27149 | 2047 | 11 |
2107259 | 2107259 | 2022-01-12 | Norman | Minnesota | 27107 | 1129 | 11 |
2107268 | 2107268 | 2022-01-12 | Red Lake | Minnesota | 27125 | 766 | 11 |
2107280 | 2107280 | 2022-01-12 | Stevens | Minnesota | 27149 | 2038 | 11 |
2104017 | 2104017 | 2022-01-11 | Red Lake | Minnesota | 27125 | 762 | 11 |
2104029 | 2104029 | 2022-01-11 | Stevens | Minnesota | 27149 | 2028 | 11 |
2100766 | 2100766 | 2022-01-10 | Red Lake | Minnesota | 27125 | 747 | 11 |
2100778 | 2100778 | 2022-01-10 | Stevens | Minnesota | 27149 | 1979 | 11 |
2097515 | 2097515 | 2022-01-09 | Red Lake | Minnesota | 27125 | 747 | 11 |
2097527 | 2097527 | 2022-01-09 | Stevens | Minnesota | 27149 | 1967 | 11 |
2094263 | 2094263 | 2022-01-08 | Red Lake | Minnesota | 27125 | 747 | 11 |
2094275 | 2094275 | 2022-01-08 | Stevens | Minnesota | 27149 | 1967 | 11 |
2091011 | 2091011 | 2022-01-07 | Red Lake | Minnesota | 27125 | 747 | 11 |
2091023 | 2091023 | 2022-01-07 | Stevens | Minnesota | 27149 | 1967 | 11 |
2087760 | 2087760 | 2022-01-06 | Red Lake | Minnesota | 27125 | 746 | 11 |
2087772 | 2087772 | 2022-01-06 | Stevens | Minnesota | 27149 | 1928 | 11 |
2084508 | 2084508 | 2022-01-05 | Red Lake | Minnesota | 27125 | 740 | 11 |
2084520 | 2084520 | 2022-01-05 | Stevens | Minnesota | 27149 | 1917 | 11 |
2081256 | 2081256 | 2022-01-04 | Red Lake | Minnesota | 27125 | 738 | 11 |
2081268 | 2081268 | 2022-01-04 | Stevens | Minnesota | 27149 | 1917 | 11 |
2078004 | 2078004 | 2022-01-03 | Red Lake | Minnesota | 27125 | 737 | 11 |
2078016 | 2078016 | 2022-01-03 | Stevens | Minnesota | 27149 | 1885 | 11 |
2074753 | 2074753 | 2022-01-02 | Red Lake | Minnesota | 27125 | 736 | 11 |
2074765 | 2074765 | 2022-01-02 | Stevens | Minnesota | 27149 | 1885 | 11 |
2071502 | 2071502 | 2022-01-01 | Red Lake | Minnesota | 27125 | 736 | 11 |
2071514 | 2071514 | 2022-01-01 | Stevens | Minnesota | 27149 | 1885 | 11 |
2068251 | 2068251 | 2021-12-31 | Red Lake | Minnesota | 27125 | 736 | 11 |
2068263 | 2068263 | 2021-12-31 | Stevens | Minnesota | 27149 | 1885 | 11 |
2065000 | 2065000 | 2021-12-30 | Red Lake | Minnesota | 27125 | 736 | 11 |
2065012 | 2065012 | 2021-12-30 | Stevens | Minnesota | 27149 | 1885 | 11 |
2061750 | 2061750 | 2021-12-29 | Red Lake | Minnesota | 27125 | 736 | 11 |
2061762 | 2061762 | 2021-12-29 | Stevens | Minnesota | 27149 | 1880 | 11 |
2058501 | 2058501 | 2021-12-28 | Red Lake | Minnesota | 27125 | 735 | 11 |
2058513 | 2058513 | 2021-12-28 | Stevens | Minnesota | 27149 | 1871 | 11 |
2055252 | 2055252 | 2021-12-27 | Red Lake | Minnesota | 27125 | 731 | 11 |
2055264 | 2055264 | 2021-12-27 | Stevens | Minnesota | 27149 | 1852 | 11 |
2052002 | 2052002 | 2021-12-26 | Red Lake | Minnesota | 27125 | 731 | 11 |
2052014 | 2052014 | 2021-12-26 | Stevens | Minnesota | 27149 | 1847 | 11 |
2048752 | 2048752 | 2021-12-25 | Red Lake | Minnesota | 27125 | 731 | 11 |
2048764 | 2048764 | 2021-12-25 | Stevens | Minnesota | 27149 | 1847 | 11 |
2045502 | 2045502 | 2021-12-24 | Red Lake | Minnesota | 27125 | 731 | 11 |
2045514 | 2045514 | 2021-12-24 | Stevens | Minnesota | 27149 | 1847 | 11 |
2042252 | 2042252 | 2021-12-23 | Red Lake | Minnesota | 27125 | 731 | 11 |
2042264 | 2042264 | 2021-12-23 | Stevens | Minnesota | 27149 | 1847 | 11 |
2039003 | 2039003 | 2021-12-22 | Red Lake | Minnesota | 27125 | 730 | 11 |
2039015 | 2039015 | 2021-12-22 | Stevens | Minnesota | 27149 | 1835 | 11 |
2035753 | 2035753 | 2021-12-21 | Red Lake | Minnesota | 27125 | 731 | 11 |
2035765 | 2035765 | 2021-12-21 | Stevens | Minnesota | 27149 | 1834 | 11 |
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);