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

788 rows where county = "Nicollet" 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 · 788 ✖

fips 1

county 1

  • Nicollet · 788 ✖
Link rowid date ▲ county state fips cases deaths
2500956 2500956 2022-05-13 Nicollet Minnesota 27103 8305 66
2497698 2497698 2022-05-12 Nicollet Minnesota 27103 8285 66
2494440 2494440 2022-05-11 Nicollet Minnesota 27103 8269 66
2491182 2491182 2022-05-10 Nicollet Minnesota 27103 8259 66
2487925 2487925 2022-05-09 Nicollet Minnesota 27103 8228 66
2484667 2484667 2022-05-08 Nicollet Minnesota 27103 8207 66
2481409 2481409 2022-05-07 Nicollet Minnesota 27103 8207 66
2478151 2478151 2022-05-06 Nicollet Minnesota 27103 8207 66
2474893 2474893 2022-05-05 Nicollet Minnesota 27103 8179 66
2471636 2471636 2022-05-04 Nicollet Minnesota 27103 8154 66
2468380 2468380 2022-05-03 Nicollet Minnesota 27103 8146 66
2465125 2465125 2022-05-02 Nicollet Minnesota 27103 8126 66
2461869 2461869 2022-05-01 Nicollet Minnesota 27103 8119 66
2458613 2458613 2022-04-30 Nicollet Minnesota 27103 8119 66
2455357 2455357 2022-04-29 Nicollet Minnesota 27103 8119 66
2452101 2452101 2022-04-28 Nicollet Minnesota 27103 8101 66
2448845 2448845 2022-04-27 Nicollet Minnesota 27103 8090 66
2445589 2445589 2022-04-26 Nicollet Minnesota 27103 8083 66
2442333 2442333 2022-04-25 Nicollet Minnesota 27103 8064 66
2439077 2439077 2022-04-24 Nicollet Minnesota 27103 8056 66
2435821 2435821 2022-04-23 Nicollet Minnesota 27103 8056 66
2432565 2432565 2022-04-22 Nicollet Minnesota 27103 8056 66
2429309 2429309 2022-04-21 Nicollet Minnesota 27103 8040 66
2426053 2426053 2022-04-20 Nicollet Minnesota 27103 8034 66
2422797 2422797 2022-04-19 Nicollet Minnesota 27103 8013 66
2419541 2419541 2022-04-18 Nicollet Minnesota 27103 7998 66
2416285 2416285 2022-04-17 Nicollet Minnesota 27103 7996 66
2413029 2413029 2022-04-16 Nicollet Minnesota 27103 7996 66
2409773 2409773 2022-04-15 Nicollet Minnesota 27103 7996 66
2406517 2406517 2022-04-14 Nicollet Minnesota 27103 7994 66
2403261 2403261 2022-04-13 Nicollet Minnesota 27103 7994 66
2400007 2400007 2022-04-12 Nicollet Minnesota 27103 7992 66
2396751 2396751 2022-04-11 Nicollet Minnesota 27103 7982 66
2393496 2393496 2022-04-10 Nicollet Minnesota 27103 7980 66
2390240 2390240 2022-04-09 Nicollet Minnesota 27103 7980 66
2386984 2386984 2022-04-08 Nicollet Minnesota 27103 7980 66
2383729 2383729 2022-04-07 Nicollet Minnesota 27103 7978 66
2380474 2380474 2022-04-06 Nicollet Minnesota 27103 7977 66
2377219 2377219 2022-04-05 Nicollet Minnesota 27103 7976 66
2373967 2373967 2022-04-04 Nicollet Minnesota 27103 7974 66
2370714 2370714 2022-04-03 Nicollet Minnesota 27103 7972 66
2367461 2367461 2022-04-02 Nicollet Minnesota 27103 7972 66
2364208 2364208 2022-04-01 Nicollet Minnesota 27103 7972 66
2360954 2360954 2022-03-31 Nicollet Minnesota 27103 7970 66
2357700 2357700 2022-03-30 Nicollet Minnesota 27103 7970 66
2354447 2354447 2022-03-29 Nicollet Minnesota 27103 7968 66
2351195 2351195 2022-03-28 Nicollet Minnesota 27103 7963 66
2347942 2347942 2022-03-27 Nicollet Minnesota 27103 7961 66
2344689 2344689 2022-03-26 Nicollet Minnesota 27103 7961 66
2341436 2341436 2022-03-25 Nicollet Minnesota 27103 7961 66
2338183 2338183 2022-03-24 Nicollet Minnesota 27103 7961 66
2334929 2334929 2022-03-23 Nicollet Minnesota 27103 7957 66
2331675 2331675 2022-03-22 Nicollet Minnesota 27103 7952 66
2328423 2328423 2022-03-21 Nicollet Minnesota 27103 7947 66
2325170 2325170 2022-03-20 Nicollet Minnesota 27103 7945 66
2321916 2321916 2022-03-19 Nicollet Minnesota 27103 7945 66
2318662 2318662 2022-03-18 Nicollet Minnesota 27103 7945 66
2315409 2315409 2022-03-17 Nicollet Minnesota 27103 7942 66
2312156 2312156 2022-03-16 Nicollet Minnesota 27103 7938 66
2308903 2308903 2022-03-15 Nicollet Minnesota 27103 7931 66
2305652 2305652 2022-03-14 Nicollet Minnesota 27103 7929 66
2302400 2302400 2022-03-13 Nicollet Minnesota 27103 7924 66
2299148 2299148 2022-03-12 Nicollet Minnesota 27103 7924 66
2295896 2295896 2022-03-11 Nicollet Minnesota 27103 7924 66
2292644 2292644 2022-03-10 Nicollet Minnesota 27103 7886 66
2289392 2289392 2022-03-09 Nicollet Minnesota 27103 7882 66
2286141 2286141 2022-03-08 Nicollet Minnesota 27103 7878 66
2282889 2282889 2022-03-07 Nicollet Minnesota 27103 7865 66
2279636 2279636 2022-03-06 Nicollet Minnesota 27103 7861 66
2276383 2276383 2022-03-05 Nicollet Minnesota 27103 7861 66
2273130 2273130 2022-03-04 Nicollet Minnesota 27103 7861 66
2269878 2269878 2022-03-03 Nicollet Minnesota 27103 7856 66
2266625 2266625 2022-03-02 Nicollet Minnesota 27103 7849 66
2263374 2263374 2022-03-01 Nicollet Minnesota 27103 7845 66
2260123 2260123 2022-02-28 Nicollet Minnesota 27103 7834 66
2256872 2256872 2022-02-27 Nicollet Minnesota 27103 7827 66
2253621 2253621 2022-02-26 Nicollet Minnesota 27103 7827 66
2250370 2250370 2022-02-25 Nicollet Minnesota 27103 7827 66
2247119 2247119 2022-02-24 Nicollet Minnesota 27103 7821 66
2243868 2243868 2022-02-23 Nicollet Minnesota 27103 7810 66
2240617 2240617 2022-02-22 Nicollet Minnesota 27103 7794 66
2237366 2237366 2022-02-21 Nicollet Minnesota 27103 7767 66
2234115 2234115 2022-02-20 Nicollet Minnesota 27103 7767 66
2230864 2230864 2022-02-19 Nicollet Minnesota 27103 7767 66
2227613 2227613 2022-02-18 Nicollet Minnesota 27103 7767 66
2224362 2224362 2022-02-17 Nicollet Minnesota 27103 7742 66
2221111 2221111 2022-02-16 Nicollet Minnesota 27103 7735 66
2217860 2217860 2022-02-15 Nicollet Minnesota 27103 7734 66
2214609 2214609 2022-02-14 Nicollet Minnesota 27103 7703 66
2211357 2211357 2022-02-13 Nicollet Minnesota 27103 7670 66
2208104 2208104 2022-02-12 Nicollet Minnesota 27103 7670 66
2204851 2204851 2022-02-11 Nicollet Minnesota 27103 7670 66
2201598 2201598 2022-02-10 Nicollet Minnesota 27103 7650 66
2198344 2198344 2022-02-09 Nicollet Minnesota 27103 7620 66
2195090 2195090 2022-02-08 Nicollet Minnesota 27103 7571 66
2191836 2191836 2022-02-07 Nicollet Minnesota 27103 7499 66
2188583 2188583 2022-02-06 Nicollet Minnesota 27103 7455 66
2185330 2185330 2022-02-05 Nicollet Minnesota 27103 7455 66
2182078 2182078 2022-02-04 Nicollet Minnesota 27103 7455 66
2178826 2178826 2022-02-03 Nicollet Minnesota 27103 7412 66

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