ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,328 rows where deaths = 9 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Norman 270
- Watonwan 152
- Mahnomen 145
- Murray 68
- Goodhue 62
- Grant 62
- Fillmore 59
- Pipestone 54
- Steele 42
- Rock 30
- Waseca 28
- Stevens 22
- Red Lake 20
- Wilkin 20
- Martin 18
- Big Stone 16
- Carver 16
- Sibley 15
- Unknown 13
- Kanabec 12
- Morrison 11
- Olmsted 11
- Traverse 11
- Wabasha 11
- Dodge 9
- Pennington 9
- Koochiching 8
- Rice 7
- Crow Wing 6
- Faribault 6
- …
state 1
- Minnesota · 1,328 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500910 | 2500910 | 2022-05-13 | Big Stone | Minnesota | 27011 | 1425 | 9 |
2497652 | 2497652 | 2022-05-12 | Big Stone | Minnesota | 27011 | 1423 | 9 |
2494394 | 2494394 | 2022-05-11 | Big Stone | Minnesota | 27011 | 1421 | 9 |
2491136 | 2491136 | 2022-05-10 | Big Stone | Minnesota | 27011 | 1421 | 9 |
2487879 | 2487879 | 2022-05-09 | Big Stone | Minnesota | 27011 | 1420 | 9 |
2484621 | 2484621 | 2022-05-08 | Big Stone | Minnesota | 27011 | 1414 | 9 |
2481363 | 2481363 | 2022-05-07 | Big Stone | Minnesota | 27011 | 1414 | 9 |
2478105 | 2478105 | 2022-05-06 | Big Stone | Minnesota | 27011 | 1414 | 9 |
2474847 | 2474847 | 2022-05-05 | Big Stone | Minnesota | 27011 | 1411 | 9 |
2471590 | 2471590 | 2022-05-04 | Big Stone | Minnesota | 27011 | 1408 | 9 |
2468334 | 2468334 | 2022-05-03 | Big Stone | Minnesota | 27011 | 1408 | 9 |
2465079 | 2465079 | 2022-05-02 | Big Stone | Minnesota | 27011 | 1406 | 9 |
2461823 | 2461823 | 2022-05-01 | Big Stone | Minnesota | 27011 | 1406 | 9 |
2458567 | 2458567 | 2022-04-30 | Big Stone | Minnesota | 27011 | 1406 | 9 |
2455311 | 2455311 | 2022-04-29 | Big Stone | Minnesota | 27011 | 1406 | 9 |
2452055 | 2452055 | 2022-04-28 | Big Stone | Minnesota | 27011 | 1404 | 9 |
2201624 | 2201624 | 2022-02-10 | Traverse | Minnesota | 27155 | 794 | 9 |
2198370 | 2198370 | 2022-02-09 | Traverse | Minnesota | 27155 | 788 | 9 |
2195116 | 2195116 | 2022-02-08 | Traverse | Minnesota | 27155 | 783 | 9 |
2191862 | 2191862 | 2022-02-07 | Traverse | Minnesota | 27155 | 770 | 9 |
2188609 | 2188609 | 2022-02-06 | Traverse | Minnesota | 27155 | 758 | 9 |
2185356 | 2185356 | 2022-02-05 | Traverse | Minnesota | 27155 | 758 | 9 |
2182104 | 2182104 | 2022-02-04 | Traverse | Minnesota | 27155 | 758 | 9 |
2178852 | 2178852 | 2022-02-03 | Traverse | Minnesota | 27155 | 752 | 9 |
2175600 | 2175600 | 2022-02-02 | Traverse | Minnesota | 27155 | 748 | 9 |
2172347 | 2172347 | 2022-02-01 | Traverse | Minnesota | 27155 | 742 | 9 |
2169094 | 2169094 | 2022-01-31 | Traverse | Minnesota | 27155 | 732 | 9 |
1983733 | 1983733 | 2021-12-05 | Norman | Minnesota | 27107 | 1057 | 9 |
1980483 | 1980483 | 2021-12-04 | Norman | Minnesota | 27107 | 1057 | 9 |
1977233 | 1977233 | 2021-12-03 | Norman | Minnesota | 27107 | 1057 | 9 |
1973983 | 1973983 | 2021-12-02 | Norman | Minnesota | 27107 | 1056 | 9 |
1970734 | 1970734 | 2021-12-01 | Norman | Minnesota | 27107 | 1050 | 9 |
1967484 | 1967484 | 2021-11-30 | Norman | Minnesota | 27107 | 1048 | 9 |
1964232 | 1964232 | 2021-11-29 | Norman | Minnesota | 27107 | 1042 | 9 |
1960953 | 1960953 | 2021-11-28 | Grant | Minnesota | 27051 | 971 | 9 |
1960981 | 1960981 | 2021-11-28 | Norman | Minnesota | 27107 | 1038 | 9 |
1957702 | 1957702 | 2021-11-27 | Grant | Minnesota | 27051 | 971 | 9 |
1957730 | 1957730 | 2021-11-27 | Norman | Minnesota | 27107 | 1038 | 9 |
1954451 | 1954451 | 2021-11-26 | Grant | Minnesota | 27051 | 971 | 9 |
1954479 | 1954479 | 2021-11-26 | Norman | Minnesota | 27107 | 1038 | 9 |
1951200 | 1951200 | 2021-11-25 | Grant | Minnesota | 27051 | 967 | 9 |
1951228 | 1951228 | 2021-11-25 | Norman | Minnesota | 27107 | 1029 | 9 |
1947949 | 1947949 | 2021-11-24 | Grant | Minnesota | 27051 | 967 | 9 |
1947977 | 1947977 | 2021-11-24 | Norman | Minnesota | 27107 | 1029 | 9 |
1944698 | 1944698 | 2021-11-23 | Grant | Minnesota | 27051 | 961 | 9 |
1944726 | 1944726 | 2021-11-23 | Norman | Minnesota | 27107 | 1026 | 9 |
1941447 | 1941447 | 2021-11-22 | Grant | Minnesota | 27051 | 945 | 9 |
1941475 | 1941475 | 2021-11-22 | Norman | Minnesota | 27107 | 1018 | 9 |
1941501 | 1941501 | 2021-11-22 | Wabasha | Minnesota | 27157 | 3576 | 9 |
1938197 | 1938197 | 2021-11-21 | Grant | Minnesota | 27051 | 940 | 9 |
1938225 | 1938225 | 2021-11-21 | Norman | Minnesota | 27107 | 1015 | 9 |
1938251 | 1938251 | 2021-11-21 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1934947 | 1934947 | 2021-11-20 | Grant | Minnesota | 27051 | 940 | 9 |
1934975 | 1934975 | 2021-11-20 | Norman | Minnesota | 27107 | 1015 | 9 |
1935001 | 1935001 | 2021-11-20 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1931697 | 1931697 | 2021-11-19 | Grant | Minnesota | 27051 | 940 | 9 |
1931725 | 1931725 | 2021-11-19 | Norman | Minnesota | 27107 | 1015 | 9 |
1931751 | 1931751 | 2021-11-19 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1928446 | 1928446 | 2021-11-18 | Grant | Minnesota | 27051 | 936 | 9 |
1928474 | 1928474 | 2021-11-18 | Norman | Minnesota | 27107 | 1011 | 9 |
1928500 | 1928500 | 2021-11-18 | Wabasha | Minnesota | 27157 | 3529 | 9 |
1925196 | 1925196 | 2021-11-17 | Grant | Minnesota | 27051 | 928 | 9 |
1925224 | 1925224 | 2021-11-17 | Norman | Minnesota | 27107 | 1004 | 9 |
1925250 | 1925250 | 2021-11-17 | Wabasha | Minnesota | 27157 | 3513 | 9 |
1921947 | 1921947 | 2021-11-16 | Grant | Minnesota | 27051 | 922 | 9 |
1921975 | 1921975 | 2021-11-16 | Norman | Minnesota | 27107 | 995 | 9 |
1922001 | 1922001 | 2021-11-16 | Wabasha | Minnesota | 27157 | 3500 | 9 |
1918697 | 1918697 | 2021-11-15 | Grant | Minnesota | 27051 | 916 | 9 |
1918725 | 1918725 | 2021-11-15 | Norman | Minnesota | 27107 | 979 | 9 |
1918751 | 1918751 | 2021-11-15 | Wabasha | Minnesota | 27157 | 3438 | 9 |
1915447 | 1915447 | 2021-11-14 | Grant | Minnesota | 27051 | 900 | 9 |
1915475 | 1915475 | 2021-11-14 | Norman | Minnesota | 27107 | 975 | 9 |
1915501 | 1915501 | 2021-11-14 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1912197 | 1912197 | 2021-11-13 | Grant | Minnesota | 27051 | 900 | 9 |
1912225 | 1912225 | 2021-11-13 | Norman | Minnesota | 27107 | 975 | 9 |
1912251 | 1912251 | 2021-11-13 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1908947 | 1908947 | 2021-11-12 | Grant | Minnesota | 27051 | 900 | 9 |
1908975 | 1908975 | 2021-11-12 | Norman | Minnesota | 27107 | 975 | 9 |
1909001 | 1909001 | 2021-11-12 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1905698 | 1905698 | 2021-11-11 | Grant | Minnesota | 27051 | 888 | 9 |
1905726 | 1905726 | 2021-11-11 | Norman | Minnesota | 27107 | 972 | 9 |
1902449 | 1902449 | 2021-11-10 | Grant | Minnesota | 27051 | 885 | 9 |
1902477 | 1902477 | 2021-11-10 | Norman | Minnesota | 27107 | 961 | 9 |
1899199 | 1899199 | 2021-11-09 | Grant | Minnesota | 27051 | 880 | 9 |
1899227 | 1899227 | 2021-11-09 | Norman | Minnesota | 27107 | 958 | 9 |
1895949 | 1895949 | 2021-11-08 | Grant | Minnesota | 27051 | 868 | 9 |
1895977 | 1895977 | 2021-11-08 | Norman | Minnesota | 27107 | 956 | 9 |
1892699 | 1892699 | 2021-11-07 | Grant | Minnesota | 27051 | 865 | 9 |
1892727 | 1892727 | 2021-11-07 | Norman | Minnesota | 27107 | 953 | 9 |
1889449 | 1889449 | 2021-11-06 | Grant | Minnesota | 27051 | 865 | 9 |
1889477 | 1889477 | 2021-11-06 | Norman | Minnesota | 27107 | 953 | 9 |
1886199 | 1886199 | 2021-11-05 | Grant | Minnesota | 27051 | 865 | 9 |
1886227 | 1886227 | 2021-11-05 | Norman | Minnesota | 27107 | 953 | 9 |
1882950 | 1882950 | 2021-11-04 | Grant | Minnesota | 27051 | 859 | 9 |
1882978 | 1882978 | 2021-11-04 | Norman | Minnesota | 27107 | 942 | 9 |
1879701 | 1879701 | 2021-11-03 | Grant | Minnesota | 27051 | 853 | 9 |
1879729 | 1879729 | 2021-11-03 | Norman | Minnesota | 27107 | 937 | 9 |
1876452 | 1876452 | 2021-11-02 | Grant | Minnesota | 27051 | 848 | 9 |
1876480 | 1876480 | 2021-11-02 | Norman | Minnesota | 27107 | 935 | 9 |
1876489 | 1876489 | 2021-11-02 | Red Lake | Minnesota | 27125 | 616 | 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);