ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 27035 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500922 | 2500922 | 2022-05-13 | Crow Wing | Minnesota | 27035 | 16266 | 170 |
2497664 | 2497664 | 2022-05-12 | Crow Wing | Minnesota | 27035 | 16238 | 170 |
2494406 | 2494406 | 2022-05-11 | Crow Wing | Minnesota | 27035 | 16202 | 170 |
2491148 | 2491148 | 2022-05-10 | Crow Wing | Minnesota | 27035 | 16187 | 170 |
2487891 | 2487891 | 2022-05-09 | Crow Wing | Minnesota | 27035 | 16155 | 170 |
2484633 | 2484633 | 2022-05-08 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2481375 | 2481375 | 2022-05-07 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2478117 | 2478117 | 2022-05-06 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2474859 | 2474859 | 2022-05-05 | Crow Wing | Minnesota | 27035 | 16115 | 170 |
2471602 | 2471602 | 2022-05-04 | Crow Wing | Minnesota | 27035 | 16099 | 170 |
2468346 | 2468346 | 2022-05-03 | Crow Wing | Minnesota | 27035 | 16085 | 170 |
2465091 | 2465091 | 2022-05-02 | Crow Wing | Minnesota | 27035 | 16073 | 169 |
2461835 | 2461835 | 2022-05-01 | Crow Wing | Minnesota | 27035 | 16058 | 169 |
2458579 | 2458579 | 2022-04-30 | Crow Wing | Minnesota | 27035 | 16058 | 169 |
2455323 | 2455323 | 2022-04-29 | Crow Wing | Minnesota | 27035 | 16058 | 169 |
2452067 | 2452067 | 2022-04-28 | Crow Wing | Minnesota | 27035 | 16047 | 169 |
2448811 | 2448811 | 2022-04-27 | Crow Wing | Minnesota | 27035 | 16038 | 169 |
2445555 | 2445555 | 2022-04-26 | Crow Wing | Minnesota | 27035 | 16028 | 169 |
2442299 | 2442299 | 2022-04-25 | Crow Wing | Minnesota | 27035 | 16011 | 169 |
2439043 | 2439043 | 2022-04-24 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2435787 | 2435787 | 2022-04-23 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2432531 | 2432531 | 2022-04-22 | Crow Wing | Minnesota | 27035 | 16006 | 169 |
2429275 | 2429275 | 2022-04-21 | Crow Wing | Minnesota | 27035 | 15991 | 169 |
2426019 | 2426019 | 2022-04-20 | Crow Wing | Minnesota | 27035 | 15984 | 169 |
2422763 | 2422763 | 2022-04-19 | Crow Wing | Minnesota | 27035 | 15978 | 169 |
2419507 | 2419507 | 2022-04-18 | Crow Wing | Minnesota | 27035 | 15969 | 169 |
2416251 | 2416251 | 2022-04-17 | Crow Wing | Minnesota | 27035 | 15964 | 169 |
2412995 | 2412995 | 2022-04-16 | Crow Wing | Minnesota | 27035 | 15964 | 169 |
2409739 | 2409739 | 2022-04-15 | Crow Wing | Minnesota | 27035 | 15964 | 169 |
2406483 | 2406483 | 2022-04-14 | Crow Wing | Minnesota | 27035 | 15956 | 168 |
2403227 | 2403227 | 2022-04-13 | Crow Wing | Minnesota | 27035 | 15950 | 168 |
2399973 | 2399973 | 2022-04-12 | Crow Wing | Minnesota | 27035 | 15938 | 168 |
2396717 | 2396717 | 2022-04-11 | Crow Wing | Minnesota | 27035 | 15932 | 168 |
2393462 | 2393462 | 2022-04-10 | Crow Wing | Minnesota | 27035 | 15926 | 168 |
2390206 | 2390206 | 2022-04-09 | Crow Wing | Minnesota | 27035 | 15926 | 168 |
2386950 | 2386950 | 2022-04-08 | Crow Wing | Minnesota | 27035 | 15926 | 168 |
2383695 | 2383695 | 2022-04-07 | Crow Wing | Minnesota | 27035 | 15921 | 168 |
2380440 | 2380440 | 2022-04-06 | Crow Wing | Minnesota | 27035 | 15921 | 168 |
2377185 | 2377185 | 2022-04-05 | Crow Wing | Minnesota | 27035 | 15920 | 168 |
2373933 | 2373933 | 2022-04-04 | Crow Wing | Minnesota | 27035 | 15911 | 168 |
2370680 | 2370680 | 2022-04-03 | Crow Wing | Minnesota | 27035 | 15909 | 168 |
2367427 | 2367427 | 2022-04-02 | Crow Wing | Minnesota | 27035 | 15909 | 168 |
2364174 | 2364174 | 2022-04-01 | Crow Wing | Minnesota | 27035 | 15909 | 168 |
2360920 | 2360920 | 2022-03-31 | Crow Wing | Minnesota | 27035 | 15906 | 168 |
2357666 | 2357666 | 2022-03-30 | Crow Wing | Minnesota | 27035 | 15904 | 168 |
2354413 | 2354413 | 2022-03-29 | Crow Wing | Minnesota | 27035 | 15902 | 168 |
2351161 | 2351161 | 2022-03-28 | Crow Wing | Minnesota | 27035 | 15894 | 167 |
2347908 | 2347908 | 2022-03-27 | Crow Wing | Minnesota | 27035 | 15887 | 167 |
2344655 | 2344655 | 2022-03-26 | Crow Wing | Minnesota | 27035 | 15887 | 167 |
2341402 | 2341402 | 2022-03-25 | Crow Wing | Minnesota | 27035 | 15887 | 167 |
2338149 | 2338149 | 2022-03-24 | Crow Wing | Minnesota | 27035 | 15885 | 167 |
2334895 | 2334895 | 2022-03-23 | Crow Wing | Minnesota | 27035 | 15879 | 166 |
2331641 | 2331641 | 2022-03-22 | Crow Wing | Minnesota | 27035 | 15875 | 165 |
2328389 | 2328389 | 2022-03-21 | Crow Wing | Minnesota | 27035 | 15859 | 165 |
2325136 | 2325136 | 2022-03-20 | Crow Wing | Minnesota | 27035 | 15858 | 165 |
2321882 | 2321882 | 2022-03-19 | Crow Wing | Minnesota | 27035 | 15858 | 165 |
2318628 | 2318628 | 2022-03-18 | Crow Wing | Minnesota | 27035 | 15858 | 165 |
2315375 | 2315375 | 2022-03-17 | Crow Wing | Minnesota | 27035 | 15851 | 165 |
2312122 | 2312122 | 2022-03-16 | Crow Wing | Minnesota | 27035 | 15848 | 165 |
2308869 | 2308869 | 2022-03-15 | Crow Wing | Minnesota | 27035 | 15839 | 165 |
2305618 | 2305618 | 2022-03-14 | Crow Wing | Minnesota | 27035 | 15830 | 165 |
2302366 | 2302366 | 2022-03-13 | Crow Wing | Minnesota | 27035 | 15819 | 165 |
2299114 | 2299114 | 2022-03-12 | Crow Wing | Minnesota | 27035 | 15819 | 165 |
2295862 | 2295862 | 2022-03-11 | Crow Wing | Minnesota | 27035 | 15819 | 165 |
2292610 | 2292610 | 2022-03-10 | Crow Wing | Minnesota | 27035 | 15804 | 165 |
2289358 | 2289358 | 2022-03-09 | Crow Wing | Minnesota | 27035 | 15797 | 165 |
2286107 | 2286107 | 2022-03-08 | Crow Wing | Minnesota | 27035 | 15792 | 164 |
2282855 | 2282855 | 2022-03-07 | Crow Wing | Minnesota | 27035 | 15785 | 164 |
2279602 | 2279602 | 2022-03-06 | Crow Wing | Minnesota | 27035 | 15769 | 164 |
2276349 | 2276349 | 2022-03-05 | Crow Wing | Minnesota | 27035 | 15769 | 164 |
2273096 | 2273096 | 2022-03-04 | Crow Wing | Minnesota | 27035 | 15769 | 164 |
2269844 | 2269844 | 2022-03-03 | Crow Wing | Minnesota | 27035 | 15764 | 164 |
2266591 | 2266591 | 2022-03-02 | Crow Wing | Minnesota | 27035 | 15757 | 163 |
2263340 | 2263340 | 2022-03-01 | Crow Wing | Minnesota | 27035 | 15754 | 163 |
2260089 | 2260089 | 2022-02-28 | Crow Wing | Minnesota | 27035 | 15727 | 163 |
2256838 | 2256838 | 2022-02-27 | Crow Wing | Minnesota | 27035 | 15714 | 163 |
2253587 | 2253587 | 2022-02-26 | Crow Wing | Minnesota | 27035 | 15714 | 163 |
2250336 | 2250336 | 2022-02-25 | Crow Wing | Minnesota | 27035 | 15714 | 163 |
2247085 | 2247085 | 2022-02-24 | Crow Wing | Minnesota | 27035 | 15714 | 163 |
2243834 | 2243834 | 2022-02-23 | Crow Wing | Minnesota | 27035 | 15705 | 161 |
2240583 | 2240583 | 2022-02-22 | Crow Wing | Minnesota | 27035 | 15658 | 161 |
2237332 | 2237332 | 2022-02-21 | Crow Wing | Minnesota | 27035 | 15620 | 160 |
2234081 | 2234081 | 2022-02-20 | Crow Wing | Minnesota | 27035 | 15620 | 160 |
2230830 | 2230830 | 2022-02-19 | Crow Wing | Minnesota | 27035 | 15620 | 160 |
2227579 | 2227579 | 2022-02-18 | Crow Wing | Minnesota | 27035 | 15620 | 160 |
2224328 | 2224328 | 2022-02-17 | Crow Wing | Minnesota | 27035 | 15560 | 160 |
2221077 | 2221077 | 2022-02-16 | Crow Wing | Minnesota | 27035 | 15547 | 159 |
2217826 | 2217826 | 2022-02-15 | Crow Wing | Minnesota | 27035 | 15530 | 158 |
2214575 | 2214575 | 2022-02-14 | Crow Wing | Minnesota | 27035 | 15427 | 158 |
2211323 | 2211323 | 2022-02-13 | Crow Wing | Minnesota | 27035 | 15379 | 158 |
2208070 | 2208070 | 2022-02-12 | Crow Wing | Minnesota | 27035 | 15379 | 158 |
2204817 | 2204817 | 2022-02-11 | Crow Wing | Minnesota | 27035 | 15379 | 158 |
2201564 | 2201564 | 2022-02-10 | Crow Wing | Minnesota | 27035 | 15315 | 156 |
2198310 | 2198310 | 2022-02-09 | Crow Wing | Minnesota | 27035 | 15264 | 155 |
2195056 | 2195056 | 2022-02-08 | Crow Wing | Minnesota | 27035 | 15184 | 155 |
2191802 | 2191802 | 2022-02-07 | Crow Wing | Minnesota | 27035 | 15054 | 154 |
2188549 | 2188549 | 2022-02-06 | Crow Wing | Minnesota | 27035 | 14959 | 154 |
2185296 | 2185296 | 2022-02-05 | Crow Wing | Minnesota | 27035 | 14959 | 154 |
2182044 | 2182044 | 2022-02-04 | Crow Wing | Minnesota | 27035 | 14959 | 154 |
2178792 | 2178792 | 2022-02-03 | Crow Wing | Minnesota | 27035 | 14875 | 154 |
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);