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

793 rows where county = "Dakota" 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 · 793 ✖

fips 1

county 1

  • Dakota · 793 ✖
Link rowid date ▲ county state fips cases deaths
2500923 2500923 2022-05-13 Dakota Minnesota 27037 113641 775
2497665 2497665 2022-05-12 Dakota Minnesota 27037 113389 774
2494407 2494407 2022-05-11 Dakota Minnesota 27037 113197 773
2491149 2491149 2022-05-10 Dakota Minnesota 27037 113004 773
2487892 2487892 2022-05-09 Dakota Minnesota 27037 112561 773
2484634 2484634 2022-05-08 Dakota Minnesota 27037 112356 773
2481376 2481376 2022-05-07 Dakota Minnesota 27037 112356 773
2478118 2478118 2022-05-06 Dakota Minnesota 27037 112356 773
2474860 2474860 2022-05-05 Dakota Minnesota 27037 112209 772
2471603 2471603 2022-05-04 Dakota Minnesota 27037 112038 772
2468347 2468347 2022-05-03 Dakota Minnesota 27037 111793 772
2465092 2465092 2022-05-02 Dakota Minnesota 27037 111634 772
2461836 2461836 2022-05-01 Dakota Minnesota 27037 111490 772
2458580 2458580 2022-04-30 Dakota Minnesota 27037 111490 772
2455324 2455324 2022-04-29 Dakota Minnesota 27037 111490 772
2452068 2452068 2022-04-28 Dakota Minnesota 27037 111325 772
2448812 2448812 2022-04-27 Dakota Minnesota 27037 111196 772
2445556 2445556 2022-04-26 Dakota Minnesota 27037 111080 772
2442300 2442300 2022-04-25 Dakota Minnesota 27037 110877 772
2439044 2439044 2022-04-24 Dakota Minnesota 27037 110798 771
2435788 2435788 2022-04-23 Dakota Minnesota 27037 110798 771
2432532 2432532 2022-04-22 Dakota Minnesota 27037 110798 771
2429276 2429276 2022-04-21 Dakota Minnesota 27037 110688 771
2426020 2426020 2022-04-20 Dakota Minnesota 27037 110604 770
2422764 2422764 2022-04-19 Dakota Minnesota 27037 110510 770
2419508 2419508 2022-04-18 Dakota Minnesota 27037 110356 770
2416252 2416252 2022-04-17 Dakota Minnesota 27037 110296 769
2412996 2412996 2022-04-16 Dakota Minnesota 27037 110296 769
2409740 2409740 2022-04-15 Dakota Minnesota 27037 110296 769
2406484 2406484 2022-04-14 Dakota Minnesota 27037 110222 769
2403228 2403228 2022-04-13 Dakota Minnesota 27037 110149 769
2399974 2399974 2022-04-12 Dakota Minnesota 27037 110117 769
2396718 2396718 2022-04-11 Dakota Minnesota 27037 110029 769
2393463 2393463 2022-04-10 Dakota Minnesota 27037 109970 769
2390207 2390207 2022-04-09 Dakota Minnesota 27037 109970 769
2386951 2386951 2022-04-08 Dakota Minnesota 27037 109970 769
2383696 2383696 2022-04-07 Dakota Minnesota 27037 109922 769
2380441 2380441 2022-04-06 Dakota Minnesota 27037 109872 769
2377186 2377186 2022-04-05 Dakota Minnesota 27037 109834 767
2373934 2373934 2022-04-04 Dakota Minnesota 27037 109747 767
2370681 2370681 2022-04-03 Dakota Minnesota 27037 109704 766
2367428 2367428 2022-04-02 Dakota Minnesota 27037 109704 766
2364175 2364175 2022-04-01 Dakota Minnesota 27037 109704 766
2360921 2360921 2022-03-31 Dakota Minnesota 27037 109647 765
2357667 2357667 2022-03-30 Dakota Minnesota 27037 109618 765
2354414 2354414 2022-03-29 Dakota Minnesota 27037 109593 763
2351162 2351162 2022-03-28 Dakota Minnesota 27037 109528 762
2347909 2347909 2022-03-27 Dakota Minnesota 27037 109489 762
2344656 2344656 2022-03-26 Dakota Minnesota 27037 109489 762
2341403 2341403 2022-03-25 Dakota Minnesota 27037 109489 762
2338150 2338150 2022-03-24 Dakota Minnesota 27037 109450 762
2334896 2334896 2022-03-23 Dakota Minnesota 27037 109423 762
2331642 2331642 2022-03-22 Dakota Minnesota 27037 109402 762
2328390 2328390 2022-03-21 Dakota Minnesota 27037 109310 762
2325137 2325137 2022-03-20 Dakota Minnesota 27037 109265 762
2321883 2321883 2022-03-19 Dakota Minnesota 27037 109265 762
2318629 2318629 2022-03-18 Dakota Minnesota 27037 109265 762
2315376 2315376 2022-03-17 Dakota Minnesota 27037 109219 761
2312123 2312123 2022-03-16 Dakota Minnesota 27037 109185 761
2308870 2308870 2022-03-15 Dakota Minnesota 27037 109118 761
2305619 2305619 2022-03-14 Dakota Minnesota 27037 109075 760
2302367 2302367 2022-03-13 Dakota Minnesota 27037 109023 760
2299115 2299115 2022-03-12 Dakota Minnesota 27037 109023 760
2295863 2295863 2022-03-11 Dakota Minnesota 27037 109023 760
2292611 2292611 2022-03-10 Dakota Minnesota 27037 108708 759
2289359 2289359 2022-03-09 Dakota Minnesota 27037 108676 759
2286108 2286108 2022-03-08 Dakota Minnesota 27037 108626 759
2282856 2282856 2022-03-07 Dakota Minnesota 27037 108484 757
2279603 2279603 2022-03-06 Dakota Minnesota 27037 108421 756
2276350 2276350 2022-03-05 Dakota Minnesota 27037 108421 756
2273097 2273097 2022-03-04 Dakota Minnesota 27037 108421 756
2269845 2269845 2022-03-03 Dakota Minnesota 27037 108315 755
2266592 2266592 2022-03-02 Dakota Minnesota 27037 108236 755
2263341 2263341 2022-03-01 Dakota Minnesota 27037 108003 754
2260090 2260090 2022-02-28 Dakota Minnesota 27037 107876 752
2256839 2256839 2022-02-27 Dakota Minnesota 27037 107814 752
2253588 2253588 2022-02-26 Dakota Minnesota 27037 107814 752
2250337 2250337 2022-02-25 Dakota Minnesota 27037 107814 752
2247086 2247086 2022-02-24 Dakota Minnesota 27037 107742 750
2243835 2243835 2022-02-23 Dakota Minnesota 27037 107787 741
2240584 2240584 2022-02-22 Dakota Minnesota 27037 107597 739
2237333 2237333 2022-02-21 Dakota Minnesota 27037 107495 739
2234082 2234082 2022-02-20 Dakota Minnesota 27037 107495 739
2230831 2230831 2022-02-19 Dakota Minnesota 27037 107495 739
2227580 2227580 2022-02-18 Dakota Minnesota 27037 107495 739
2224329 2224329 2022-02-17 Dakota Minnesota 27037 107090 738
2221078 2221078 2022-02-16 Dakota Minnesota 27037 107042 738
2217827 2217827 2022-02-15 Dakota Minnesota 27037 106947 736
2214576 2214576 2022-02-14 Dakota Minnesota 27037 106766 734
2211324 2211324 2022-02-13 Dakota Minnesota 27037 106350 731
2208071 2208071 2022-02-12 Dakota Minnesota 27037 106350 731
2204818 2204818 2022-02-11 Dakota Minnesota 27037 106350 731
2201565 2201565 2022-02-10 Dakota Minnesota 27037 106202 729
2198311 2198311 2022-02-09 Dakota Minnesota 27037 105882 729
2195057 2195057 2022-02-08 Dakota Minnesota 27037 105385 727
2191803 2191803 2022-02-07 Dakota Minnesota 27037 104727 723
2188550 2188550 2022-02-06 Dakota Minnesota 27037 104237 720
2185297 2185297 2022-02-05 Dakota Minnesota 27037 104237 720
2182045 2182045 2022-02-04 Dakota Minnesota 27037 104237 720
2178793 2178793 2022-02-03 Dakota Minnesota 27037 103806 717

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