ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

776 rows where county = "Douglas", fips = 27041 and state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Minnesota · 776 ✖

fips 1

  • 27041 · 776 ✖

county 1

  • Douglas · 776 ✖
Link rowid date ▲ county state fips cases deaths
2500925 2500925 2022-05-13 Douglas Minnesota 27041 11106 117
2497667 2497667 2022-05-12 Douglas Minnesota 27041 11092 116
2494409 2494409 2022-05-11 Douglas Minnesota 27041 11076 116
2491151 2491151 2022-05-10 Douglas Minnesota 27041 11067 116
2487894 2487894 2022-05-09 Douglas Minnesota 27041 11040 116
2484636 2484636 2022-05-08 Douglas Minnesota 27041 11026 116
2481378 2481378 2022-05-07 Douglas Minnesota 27041 11026 116
2478120 2478120 2022-05-06 Douglas Minnesota 27041 11026 116
2474862 2474862 2022-05-05 Douglas Minnesota 27041 11015 116
2471605 2471605 2022-05-04 Douglas Minnesota 27041 11004 116
2468349 2468349 2022-05-03 Douglas Minnesota 27041 10995 116
2465094 2465094 2022-05-02 Douglas Minnesota 27041 10986 116
2461838 2461838 2022-05-01 Douglas Minnesota 27041 10981 116
2458582 2458582 2022-04-30 Douglas Minnesota 27041 10981 116
2455326 2455326 2022-04-29 Douglas Minnesota 27041 10981 116
2452070 2452070 2022-04-28 Douglas Minnesota 27041 10968 116
2448814 2448814 2022-04-27 Douglas Minnesota 27041 10960 116
2445558 2445558 2022-04-26 Douglas Minnesota 27041 10953 116
2442302 2442302 2022-04-25 Douglas Minnesota 27041 10946 116
2439046 2439046 2022-04-24 Douglas Minnesota 27041 10941 116
2435790 2435790 2022-04-23 Douglas Minnesota 27041 10941 116
2432534 2432534 2022-04-22 Douglas Minnesota 27041 10941 116
2429278 2429278 2022-04-21 Douglas Minnesota 27041 10938 116
2426022 2426022 2022-04-20 Douglas Minnesota 27041 10935 116
2422766 2422766 2022-04-19 Douglas Minnesota 27041 10924 116
2419510 2419510 2022-04-18 Douglas Minnesota 27041 10912 116
2416254 2416254 2022-04-17 Douglas Minnesota 27041 10902 116
2412998 2412998 2022-04-16 Douglas Minnesota 27041 10902 116
2409742 2409742 2022-04-15 Douglas Minnesota 27041 10902 116
2406486 2406486 2022-04-14 Douglas Minnesota 27041 10901 116
2403230 2403230 2022-04-13 Douglas Minnesota 27041 10896 116
2399976 2399976 2022-04-12 Douglas Minnesota 27041 10892 116
2396720 2396720 2022-04-11 Douglas Minnesota 27041 10885 116
2393465 2393465 2022-04-10 Douglas Minnesota 27041 10880 116
2390209 2390209 2022-04-09 Douglas Minnesota 27041 10880 116
2386953 2386953 2022-04-08 Douglas Minnesota 27041 10880 116
2383698 2383698 2022-04-07 Douglas Minnesota 27041 10879 116
2380443 2380443 2022-04-06 Douglas Minnesota 27041 10874 116
2377188 2377188 2022-04-05 Douglas Minnesota 27041 10869 116
2373936 2373936 2022-04-04 Douglas Minnesota 27041 10865 116
2370683 2370683 2022-04-03 Douglas Minnesota 27041 10863 116
2367430 2367430 2022-04-02 Douglas Minnesota 27041 10863 116
2364177 2364177 2022-04-01 Douglas Minnesota 27041 10863 116
2360923 2360923 2022-03-31 Douglas Minnesota 27041 10861 116
2357669 2357669 2022-03-30 Douglas Minnesota 27041 10859 116
2354416 2354416 2022-03-29 Douglas Minnesota 27041 10857 116
2351164 2351164 2022-03-28 Douglas Minnesota 27041 10854 116
2347911 2347911 2022-03-27 Douglas Minnesota 27041 10849 116
2344658 2344658 2022-03-26 Douglas Minnesota 27041 10849 116
2341405 2341405 2022-03-25 Douglas Minnesota 27041 10849 116
2338152 2338152 2022-03-24 Douglas Minnesota 27041 10848 116
2334898 2334898 2022-03-23 Douglas Minnesota 27041 10846 116
2331644 2331644 2022-03-22 Douglas Minnesota 27041 10845 116
2328392 2328392 2022-03-21 Douglas Minnesota 27041 10843 116
2325139 2325139 2022-03-20 Douglas Minnesota 27041 10842 116
2321885 2321885 2022-03-19 Douglas Minnesota 27041 10842 116
2318631 2318631 2022-03-18 Douglas Minnesota 27041 10842 116
2315378 2315378 2022-03-17 Douglas Minnesota 27041 10835 116
2312125 2312125 2022-03-16 Douglas Minnesota 27041 10824 116
2308872 2308872 2022-03-15 Douglas Minnesota 27041 10819 116
2305621 2305621 2022-03-14 Douglas Minnesota 27041 10811 116
2302369 2302369 2022-03-13 Douglas Minnesota 27041 10809 116
2299117 2299117 2022-03-12 Douglas Minnesota 27041 10809 116
2295865 2295865 2022-03-11 Douglas Minnesota 27041 10809 116
2292613 2292613 2022-03-10 Douglas Minnesota 27041 10801 116
2289361 2289361 2022-03-09 Douglas Minnesota 27041 10793 115
2286110 2286110 2022-03-08 Douglas Minnesota 27041 10791 115
2282858 2282858 2022-03-07 Douglas Minnesota 27041 10786 115
2279605 2279605 2022-03-06 Douglas Minnesota 27041 10779 115
2276352 2276352 2022-03-05 Douglas Minnesota 27041 10779 115
2273099 2273099 2022-03-04 Douglas Minnesota 27041 10779 115
2269847 2269847 2022-03-03 Douglas Minnesota 27041 10776 115
2266594 2266594 2022-03-02 Douglas Minnesota 27041 10769 115
2263343 2263343 2022-03-01 Douglas Minnesota 27041 10761 115
2260092 2260092 2022-02-28 Douglas Minnesota 27041 10744 115
2256841 2256841 2022-02-27 Douglas Minnesota 27041 10730 115
2253590 2253590 2022-02-26 Douglas Minnesota 27041 10730 115
2250339 2250339 2022-02-25 Douglas Minnesota 27041 10730 115
2247088 2247088 2022-02-24 Douglas Minnesota 27041 10723 115
2243837 2243837 2022-02-23 Douglas Minnesota 27041 10717 113
2240586 2240586 2022-02-22 Douglas Minnesota 27041 10686 113
2237335 2237335 2022-02-21 Douglas Minnesota 27041 10670 113
2234084 2234084 2022-02-20 Douglas Minnesota 27041 10670 113
2230833 2230833 2022-02-19 Douglas Minnesota 27041 10670 113
2227582 2227582 2022-02-18 Douglas Minnesota 27041 10670 113
2224331 2224331 2022-02-17 Douglas Minnesota 27041 10640 113
2221080 2221080 2022-02-16 Douglas Minnesota 27041 10629 113
2217829 2217829 2022-02-15 Douglas Minnesota 27041 10618 113
2214578 2214578 2022-02-14 Douglas Minnesota 27041 10562 113
2211326 2211326 2022-02-13 Douglas Minnesota 27041 10505 113
2208073 2208073 2022-02-12 Douglas Minnesota 27041 10505 113
2204820 2204820 2022-02-11 Douglas Minnesota 27041 10505 113
2201567 2201567 2022-02-10 Douglas Minnesota 27041 10474 113
2198313 2198313 2022-02-09 Douglas Minnesota 27041 10436 113
2195059 2195059 2022-02-08 Douglas Minnesota 27041 10401 113
2191805 2191805 2022-02-07 Douglas Minnesota 27041 10329 112
2188552 2188552 2022-02-06 Douglas Minnesota 27041 10283 112
2185299 2185299 2022-02-05 Douglas Minnesota 27041 10283 112
2182047 2182047 2022-02-04 Douglas Minnesota 27041 10283 112
2178795 2178795 2022-02-03 Douglas Minnesota 27041 10234 112

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);