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

1,555 rows where county = "Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Dakota · 1,555 ✖
Link rowid date ▲ county state fips cases deaths
2500923 2500923 2022-05-13 Dakota Minnesota 27037 113641 775
2501270 2501270 2022-05-13 Dakota Nebraska 31043 6849 82
2497665 2497665 2022-05-12 Dakota Minnesota 27037 113389 774
2498012 2498012 2022-05-12 Dakota Nebraska 31043 6844 82
2494407 2494407 2022-05-11 Dakota Minnesota 27037 113197 773
2494754 2494754 2022-05-11 Dakota Nebraska 31043 6844 82
2491149 2491149 2022-05-10 Dakota Minnesota 27037 113004 773
2491496 2491496 2022-05-10 Dakota Nebraska 31043 6849 82
2487892 2487892 2022-05-09 Dakota Minnesota 27037 112561 773
2488238 2488238 2022-05-09 Dakota Nebraska 31043 6849 82
2484634 2484634 2022-05-08 Dakota Minnesota 27037 112356 773
2484981 2484981 2022-05-08 Dakota Nebraska 31043 6847 82
2481376 2481376 2022-05-07 Dakota Minnesota 27037 112356 773
2481723 2481723 2022-05-07 Dakota Nebraska 31043 6847 82
2478118 2478118 2022-05-06 Dakota Minnesota 27037 112356 773
2478465 2478465 2022-05-06 Dakota Nebraska 31043 6847 82
2474860 2474860 2022-05-05 Dakota Minnesota 27037 112209 772
2475207 2475207 2022-05-05 Dakota Nebraska 31043 6847 82
2471603 2471603 2022-05-04 Dakota Minnesota 27037 112038 772
2471950 2471950 2022-05-04 Dakota Nebraska 31043 6847 82
2468347 2468347 2022-05-03 Dakota Minnesota 27037 111793 772
2468694 2468694 2022-05-03 Dakota Nebraska 31043 6846 82
2465092 2465092 2022-05-02 Dakota Minnesota 27037 111634 772
2465438 2465438 2022-05-02 Dakota Nebraska 31043 6848 82
2461836 2461836 2022-05-01 Dakota Minnesota 27037 111490 772
2462183 2462183 2022-05-01 Dakota Nebraska 31043 6848 82
2458580 2458580 2022-04-30 Dakota Minnesota 27037 111490 772
2458927 2458927 2022-04-30 Dakota Nebraska 31043 6848 82
2455324 2455324 2022-04-29 Dakota Minnesota 27037 111490 772
2455671 2455671 2022-04-29 Dakota Nebraska 31043 6848 82
2452068 2452068 2022-04-28 Dakota Minnesota 27037 111325 772
2452415 2452415 2022-04-28 Dakota Nebraska 31043 6850 82
2448812 2448812 2022-04-27 Dakota Minnesota 27037 111196 772
2449159 2449159 2022-04-27 Dakota Nebraska 31043 6850 82
2445556 2445556 2022-04-26 Dakota Minnesota 27037 111080 772
2445902 2445902 2022-04-26 Dakota Nebraska 31043 6850 82
2442300 2442300 2022-04-25 Dakota Minnesota 27037 110877 772
2442647 2442647 2022-04-25 Dakota Nebraska 31043 6846 82
2439044 2439044 2022-04-24 Dakota Minnesota 27037 110798 771
2439391 2439391 2022-04-24 Dakota Nebraska 31043 6846 82
2435788 2435788 2022-04-23 Dakota Minnesota 27037 110798 771
2436135 2436135 2022-04-23 Dakota Nebraska 31043 6846 82
2432532 2432532 2022-04-22 Dakota Minnesota 27037 110798 771
2432879 2432879 2022-04-22 Dakota Nebraska 31043 6846 82
2429276 2429276 2022-04-21 Dakota Minnesota 27037 110688 771
2429623 2429623 2022-04-21 Dakota Nebraska 31043 6900 82
2426020 2426020 2022-04-20 Dakota Minnesota 27037 110604 770
2426367 2426367 2022-04-20 Dakota Nebraska 31043 6900 82
2422764 2422764 2022-04-19 Dakota Minnesota 27037 110510 770
2423111 2423111 2022-04-19 Dakota Nebraska 31043 6900 82
2419508 2419508 2022-04-18 Dakota Minnesota 27037 110356 770
2419854 2419854 2022-04-18 Dakota Nebraska 31043 6899 82
2416252 2416252 2022-04-17 Dakota Minnesota 27037 110296 769
2416599 2416599 2022-04-17 Dakota Nebraska 31043 6899 82
2412996 2412996 2022-04-16 Dakota Minnesota 27037 110296 769
2413343 2413343 2022-04-16 Dakota Nebraska 31043 6899 82
2409740 2409740 2022-04-15 Dakota Minnesota 27037 110296 769
2410087 2410087 2022-04-15 Dakota Nebraska 31043 6899 82
2406484 2406484 2022-04-14 Dakota Minnesota 27037 110222 769
2406831 2406831 2022-04-14 Dakota Nebraska 31043 6899 82
2403228 2403228 2022-04-13 Dakota Minnesota 27037 110149 769
2403575 2403575 2022-04-13 Dakota Nebraska 31043 6899 82
2399974 2399974 2022-04-12 Dakota Minnesota 27037 110117 769
2400320 2400320 2022-04-12 Dakota Nebraska 31043 6900 82
2396718 2396718 2022-04-11 Dakota Minnesota 27037 110029 769
2397065 2397065 2022-04-11 Dakota Nebraska 31043 6900 82
2393463 2393463 2022-04-10 Dakota Minnesota 27037 109970 769
2393810 2393810 2022-04-10 Dakota Nebraska 31043 6900 82
2390207 2390207 2022-04-09 Dakota Minnesota 27037 109970 769
2390554 2390554 2022-04-09 Dakota Nebraska 31043 6900 82
2386951 2386951 2022-04-08 Dakota Minnesota 27037 109970 769
2387298 2387298 2022-04-08 Dakota Nebraska 31043 6900 82
2383696 2383696 2022-04-07 Dakota Minnesota 27037 109922 769
2384043 2384043 2022-04-07 Dakota Nebraska 31043 6900 82
2380441 2380441 2022-04-06 Dakota Minnesota 27037 109872 769
2380788 2380788 2022-04-06 Dakota Nebraska 31043 6900 82
2377186 2377186 2022-04-05 Dakota Minnesota 27037 109834 767
2377533 2377533 2022-04-05 Dakota Nebraska 31043 6900 82
2373934 2373934 2022-04-04 Dakota Minnesota 27037 109747 767
2374280 2374280 2022-04-04 Dakota Nebraska 31043 6900 82
2370681 2370681 2022-04-03 Dakota Minnesota 27037 109704 766
2371028 2371028 2022-04-03 Dakota Nebraska 31043 6900 82
2367428 2367428 2022-04-02 Dakota Minnesota 27037 109704 766
2367775 2367775 2022-04-02 Dakota Nebraska 31043 6900 82
2364175 2364175 2022-04-01 Dakota Minnesota 27037 109704 766
2364522 2364522 2022-04-01 Dakota Nebraska 31043 6900 82
2360921 2360921 2022-03-31 Dakota Minnesota 27037 109647 765
2361268 2361268 2022-03-31 Dakota Nebraska 31043 6900 82
2357667 2357667 2022-03-30 Dakota Minnesota 27037 109618 765
2358014 2358014 2022-03-30 Dakota Nebraska 31043 6904 82
2354414 2354414 2022-03-29 Dakota Minnesota 27037 109593 763
2354761 2354761 2022-03-29 Dakota Nebraska 31043 6904 82
2351162 2351162 2022-03-28 Dakota Minnesota 27037 109528 762
2351508 2351508 2022-03-28 Dakota Nebraska 31043 6904 82
2347909 2347909 2022-03-27 Dakota Minnesota 27037 109489 762
2348256 2348256 2022-03-27 Dakota Nebraska 31043 6904 82
2344656 2344656 2022-03-26 Dakota Minnesota 27037 109489 762
2345003 2345003 2022-03-26 Dakota Nebraska 31043 6904 82
2341403 2341403 2022-03-25 Dakota Minnesota 27037 109489 762
2341750 2341750 2022-03-25 Dakota Nebraska 31043 6904 82

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