ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-05-18 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1330813 | 1330813 | 2021-05-18 | Aitkin | Minnesota | 27001 | 1353 | 36 |
1330814 | 1330814 | 2021-05-18 | Anoka | Minnesota | 27003 | 41948 | 441 |
1330815 | 1330815 | 2021-05-18 | Becker | Minnesota | 27005 | 3815 | 53 |
1330816 | 1330816 | 2021-05-18 | Beltrami | Minnesota | 27007 | 3995 | 59 |
1330817 | 1330817 | 2021-05-18 | Benton | Minnesota | 27009 | 5738 | 97 |
1330818 | 1330818 | 2021-05-18 | Big Stone | Minnesota | 27011 | 600 | 4 |
1330819 | 1330819 | 2021-05-18 | Blue Earth | Minnesota | 27013 | 7539 | 41 |
1330820 | 1330820 | 2021-05-18 | Brown | Minnesota | 27015 | 3061 | 40 |
1330821 | 1330821 | 2021-05-18 | Carlton | Minnesota | 27017 | 3465 | 54 |
1330822 | 1330822 | 2021-05-18 | Carver | Minnesota | 27019 | 10523 | 45 |
1330823 | 1330823 | 2021-05-18 | Cass | Minnesota | 27021 | 2754 | 29 |
1330824 | 1330824 | 2021-05-18 | Chippewa | Minnesota | 27023 | 1525 | 38 |
1330825 | 1330825 | 2021-05-18 | Chisago | Minnesota | 27025 | 6054 | 51 |
1330826 | 1330826 | 2021-05-18 | Clay | Minnesota | 27027 | 8180 | 92 |
1330827 | 1330827 | 2021-05-18 | Clearwater | Minnesota | 27029 | 872 | 16 |
1330828 | 1330828 | 2021-05-18 | Cook | Minnesota | 27031 | 166 | 0 |
1330829 | 1330829 | 2021-05-18 | Cottonwood | Minnesota | 27033 | 1661 | 23 |
1330830 | 1330830 | 2021-05-18 | Crow Wing | Minnesota | 27035 | 6681 | 90 |
1330831 | 1330831 | 2021-05-18 | Dakota | Minnesota | 27037 | 46114 | 454 |
1330832 | 1330832 | 2021-05-18 | Dodge | Minnesota | 27039 | 1854 | 3 |
1330833 | 1330833 | 2021-05-18 | Douglas | Minnesota | 27041 | 4698 | 76 |
1330834 | 1330834 | 2021-05-18 | Faribault | Minnesota | 27043 | 1527 | 19 |
1330835 | 1330835 | 2021-05-18 | Fillmore | Minnesota | 27045 | 1567 | 10 |
1330836 | 1330836 | 2021-05-18 | Freeborn | Minnesota | 27047 | 3421 | 29 |
1330837 | 1330837 | 2021-05-18 | Goodhue | Minnesota | 27049 | 4793 | 72 |
1330838 | 1330838 | 2021-05-18 | Grant | Minnesota | 27051 | 582 | 8 |
1330839 | 1330839 | 2021-05-18 | Hennepin | Minnesota | 27053 | 123162 | 1735 |
1330840 | 1330840 | 2021-05-18 | Houston | Minnesota | 27055 | 1720 | 16 |
1330841 | 1330841 | 2021-05-18 | Hubbard | Minnesota | 27057 | 1909 | 41 |
1330842 | 1330842 | 2021-05-18 | Isanti | Minnesota | 27059 | 4257 | 64 |
1330843 | 1330843 | 2021-05-18 | Itasca | Minnesota | 27061 | 4435 | 56 |
1330844 | 1330844 | 2021-05-18 | Jackson | Minnesota | 27063 | 1218 | 12 |
1330845 | 1330845 | 2021-05-18 | Kanabec | Minnesota | 27065 | 1453 | 27 |
1330846 | 1330846 | 2021-05-18 | Kandiyohi | Minnesota | 27067 | 6579 | 83 |
1330847 | 1330847 | 2021-05-18 | Kittson | Minnesota | 27069 | 487 | 22 |
1330848 | 1330848 | 2021-05-18 | Koochiching | Minnesota | 27071 | 848 | 15 |
1330849 | 1330849 | 2021-05-18 | Lac qui Parle | Minnesota | 27073 | 754 | 22 |
1330850 | 1330850 | 2021-05-18 | Lake | Minnesota | 27075 | 811 | 20 |
1330851 | 1330851 | 2021-05-18 | Lake of the Woods | Minnesota | 27077 | 333 | 3 |
1330852 | 1330852 | 2021-05-18 | Le Sueur | Minnesota | 27079 | 2933 | 23 |
1330853 | 1330853 | 2021-05-18 | Lincoln | Minnesota | 27081 | 581 | 3 |
1330854 | 1330854 | 2021-05-18 | Lyon | Minnesota | 27083 | 3616 | 51 |
1330855 | 1330855 | 2021-05-18 | Mahnomen | Minnesota | 27087 | 554 | 9 |
1330856 | 1330856 | 2021-05-18 | Marshall | Minnesota | 27089 | 881 | 17 |
1330857 | 1330857 | 2021-05-18 | Martin | Minnesota | 27091 | 2311 | 32 |
1330858 | 1330858 | 2021-05-18 | McLeod | Minnesota | 27085 | 4261 | 59 |
1330859 | 1330859 | 2021-05-18 | Meeker | Minnesota | 27093 | 2584 | 40 |
1330860 | 1330860 | 2021-05-18 | Mille Lacs | Minnesota | 27095 | 3062 | 53 |
1330861 | 1330861 | 2021-05-18 | Morrison | Minnesota | 27097 | 4200 | 60 |
1330862 | 1330862 | 2021-05-18 | Mower | Minnesota | 27099 | 4669 | 32 |
1330863 | 1330863 | 2021-05-18 | Murray | Minnesota | 27101 | 1065 | 9 |
1330864 | 1330864 | 2021-05-18 | Nicollet | Minnesota | 27103 | 3272 | 43 |
1330865 | 1330865 | 2021-05-18 | Nobles | Minnesota | 27105 | 4082 | 48 |
1330866 | 1330866 | 2021-05-18 | Norman | Minnesota | 27107 | 540 | 9 |
1330867 | 1330867 | 2021-05-18 | Olmsted | Minnesota | 27109 | 13276 | 99 |
1330868 | 1330868 | 2021-05-18 | Otter Tail | Minnesota | 27111 | 5765 | 78 |
1330869 | 1330869 | 2021-05-18 | Pennington | Minnesota | 27113 | 1537 | 19 |
1330870 | 1330870 | 2021-05-18 | Pine | Minnesota | 27115 | 3299 | 23 |
1330871 | 1330871 | 2021-05-18 | Pipestone | Minnesota | 27117 | 1160 | 26 |
1330872 | 1330872 | 2021-05-18 | Polk | Minnesota | 27119 | 3851 | 68 |
1330873 | 1330873 | 2021-05-18 | Pope | Minnesota | 27121 | 1110 | 6 |
1330874 | 1330874 | 2021-05-18 | Ramsey | Minnesota | 27123 | 51644 | 876 |
1330875 | 1330875 | 2021-05-18 | Red Lake | Minnesota | 27125 | 399 | 7 |
1330876 | 1330876 | 2021-05-18 | Redwood | Minnesota | 27127 | 1749 | 37 |
1330877 | 1330877 | 2021-05-18 | Renville | Minnesota | 27129 | 1805 | 43 |
1330878 | 1330878 | 2021-05-18 | Rice | Minnesota | 27131 | 8089 | 108 |
1330879 | 1330879 | 2021-05-18 | Rock | Minnesota | 27133 | 1284 | 19 |
1330880 | 1330880 | 2021-05-18 | Roseau | Minnesota | 27135 | 2098 | 19 |
1330881 | 1330881 | 2021-05-18 | Scott | Minnesota | 27139 | 17348 | 127 |
1330882 | 1330882 | 2021-05-18 | Sherburne | Minnesota | 27141 | 11792 | 88 |
1330883 | 1330883 | 2021-05-18 | Sibley | Minnesota | 27143 | 1443 | 10 |
1330884 | 1330884 | 2021-05-18 | St. Louis | Minnesota | 27137 | 17856 | 305 |
1330885 | 1330885 | 2021-05-18 | Stearns | Minnesota | 27145 | 22337 | 222 |
1330886 | 1330886 | 2021-05-18 | Steele | Minnesota | 27147 | 3904 | 15 |
1330887 | 1330887 | 2021-05-18 | Stevens | Minnesota | 27149 | 916 | 11 |
1330888 | 1330888 | 2021-05-18 | Swift | Minnesota | 27151 | 1059 | 18 |
1330889 | 1330889 | 2021-05-18 | Todd | Minnesota | 27153 | 2831 | 32 |
1330890 | 1330890 | 2021-05-18 | Traverse | Minnesota | 27155 | 370 | 5 |
1330891 | 1330891 | 2021-05-18 | Unknown | Minnesota | 600 | 93 | |
1330892 | 1330892 | 2021-05-18 | Wabasha | Minnesota | 27157 | 2065 | 3 |
1330893 | 1330893 | 2021-05-18 | Wadena | Minnesota | 27159 | 1563 | 22 |
1330894 | 1330894 | 2021-05-18 | Waseca | Minnesota | 27161 | 2367 | 22 |
1330895 | 1330895 | 2021-05-18 | Washington | Minnesota | 27163 | 27033 | 286 |
1330896 | 1330896 | 2021-05-18 | Watonwan | Minnesota | 27165 | 1337 | 9 |
1330897 | 1330897 | 2021-05-18 | Wilkin | Minnesota | 27167 | 816 | 12 |
1330898 | 1330898 | 2021-05-18 | Winona | Minnesota | 27169 | 4554 | 50 |
1330899 | 1330899 | 2021-05-18 | Wright | Minnesota | 27171 | 16161 | 141 |
1330900 | 1330900 | 2021-05-18 | Yellow Medicine | Minnesota | 27173 | 1144 | 20 |
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);