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

700 rows where county = "Cook" and state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Minnesota · 700 ✖

fips 1

county 1

  • Cook · 700 ✖
Link rowid date ▲ county state fips cases deaths
2500920 2500920 2022-05-13 Cook Minnesota 27031 594 4
2497662 2497662 2022-05-12 Cook Minnesota 27031 592 4
2494404 2494404 2022-05-11 Cook Minnesota 27031 590 4
2491146 2491146 2022-05-10 Cook Minnesota 27031 586 4
2487889 2487889 2022-05-09 Cook Minnesota 27031 581 4
2484631 2484631 2022-05-08 Cook Minnesota 27031 579 4
2481373 2481373 2022-05-07 Cook Minnesota 27031 579 4
2478115 2478115 2022-05-06 Cook Minnesota 27031 579 4
2474857 2474857 2022-05-05 Cook Minnesota 27031 579 4
2471600 2471600 2022-05-04 Cook Minnesota 27031 577 4
2468344 2468344 2022-05-03 Cook Minnesota 27031 574 4
2465089 2465089 2022-05-02 Cook Minnesota 27031 571 4
2461833 2461833 2022-05-01 Cook Minnesota 27031 571 4
2458577 2458577 2022-04-30 Cook Minnesota 27031 571 4
2455321 2455321 2022-04-29 Cook Minnesota 27031 571 4
2452065 2452065 2022-04-28 Cook Minnesota 27031 570 4
2448809 2448809 2022-04-27 Cook Minnesota 27031 565 4
2445553 2445553 2022-04-26 Cook Minnesota 27031 565 4
2442297 2442297 2022-04-25 Cook Minnesota 27031 563 4
2439041 2439041 2022-04-24 Cook Minnesota 27031 562 4
2435785 2435785 2022-04-23 Cook Minnesota 27031 562 4
2432529 2432529 2022-04-22 Cook Minnesota 27031 562 4
2429273 2429273 2022-04-21 Cook Minnesota 27031 562 4
2426017 2426017 2022-04-20 Cook Minnesota 27031 561 4
2422761 2422761 2022-04-19 Cook Minnesota 27031 561 4
2419505 2419505 2022-04-18 Cook Minnesota 27031 559 4
2416249 2416249 2022-04-17 Cook Minnesota 27031 558 4
2412993 2412993 2022-04-16 Cook Minnesota 27031 558 4
2409737 2409737 2022-04-15 Cook Minnesota 27031 558 4
2406481 2406481 2022-04-14 Cook Minnesota 27031 556 4
2403225 2403225 2022-04-13 Cook Minnesota 27031 555 4
2399971 2399971 2022-04-12 Cook Minnesota 27031 554 4
2396715 2396715 2022-04-11 Cook Minnesota 27031 554 4
2393460 2393460 2022-04-10 Cook Minnesota 27031 554 4
2390204 2390204 2022-04-09 Cook Minnesota 27031 554 4
2386948 2386948 2022-04-08 Cook Minnesota 27031 554 4
2383693 2383693 2022-04-07 Cook Minnesota 27031 554 4
2380438 2380438 2022-04-06 Cook Minnesota 27031 554 4
2377183 2377183 2022-04-05 Cook Minnesota 27031 554 4
2373931 2373931 2022-04-04 Cook Minnesota 27031 554 4
2370678 2370678 2022-04-03 Cook Minnesota 27031 554 4
2367425 2367425 2022-04-02 Cook Minnesota 27031 554 4
2364172 2364172 2022-04-01 Cook Minnesota 27031 554 4
2360918 2360918 2022-03-31 Cook Minnesota 27031 554 4
2357664 2357664 2022-03-30 Cook Minnesota 27031 553 4
2354411 2354411 2022-03-29 Cook Minnesota 27031 552 4
2351159 2351159 2022-03-28 Cook Minnesota 27031 551 4
2347906 2347906 2022-03-27 Cook Minnesota 27031 551 4
2344653 2344653 2022-03-26 Cook Minnesota 27031 551 4
2341400 2341400 2022-03-25 Cook Minnesota 27031 551 4
2338147 2338147 2022-03-24 Cook Minnesota 27031 550 4
2334893 2334893 2022-03-23 Cook Minnesota 27031 550 4
2331639 2331639 2022-03-22 Cook Minnesota 27031 549 4
2328387 2328387 2022-03-21 Cook Minnesota 27031 548 4
2325134 2325134 2022-03-20 Cook Minnesota 27031 548 4
2321880 2321880 2022-03-19 Cook Minnesota 27031 548 4
2318626 2318626 2022-03-18 Cook Minnesota 27031 548 4
2315373 2315373 2022-03-17 Cook Minnesota 27031 548 4
2312120 2312120 2022-03-16 Cook Minnesota 27031 548 4
2308867 2308867 2022-03-15 Cook Minnesota 27031 548 4
2305616 2305616 2022-03-14 Cook Minnesota 27031 550 4
2302364 2302364 2022-03-13 Cook Minnesota 27031 549 4
2299112 2299112 2022-03-12 Cook Minnesota 27031 549 4
2295860 2295860 2022-03-11 Cook Minnesota 27031 549 4
2292608 2292608 2022-03-10 Cook Minnesota 27031 545 4
2289356 2289356 2022-03-09 Cook Minnesota 27031 545 4
2286105 2286105 2022-03-08 Cook Minnesota 27031 545 4
2282853 2282853 2022-03-07 Cook Minnesota 27031 545 4
2279600 2279600 2022-03-06 Cook Minnesota 27031 542 4
2276347 2276347 2022-03-05 Cook Minnesota 27031 542 4
2273094 2273094 2022-03-04 Cook Minnesota 27031 542 4
2269842 2269842 2022-03-03 Cook Minnesota 27031 541 4
2266589 2266589 2022-03-02 Cook Minnesota 27031 541 4
2263338 2263338 2022-03-01 Cook Minnesota 27031 540 4
2260087 2260087 2022-02-28 Cook Minnesota 27031 540 4
2256836 2256836 2022-02-27 Cook Minnesota 27031 539 4
2253585 2253585 2022-02-26 Cook Minnesota 27031 539 4
2250334 2250334 2022-02-25 Cook Minnesota 27031 539 4
2247083 2247083 2022-02-24 Cook Minnesota 27031 538 4
2243832 2243832 2022-02-23 Cook Minnesota 27031 535 4
2240581 2240581 2022-02-22 Cook Minnesota 27031 533 4
2237330 2237330 2022-02-21 Cook Minnesota 27031 533 4
2234079 2234079 2022-02-20 Cook Minnesota 27031 533 4
2230828 2230828 2022-02-19 Cook Minnesota 27031 533 4
2227577 2227577 2022-02-18 Cook Minnesota 27031 533 4
2224326 2224326 2022-02-17 Cook Minnesota 27031 532 4
2221075 2221075 2022-02-16 Cook Minnesota 27031 531 3
2217824 2217824 2022-02-15 Cook Minnesota 27031 531 3
2214573 2214573 2022-02-14 Cook Minnesota 27031 527 3
2211321 2211321 2022-02-13 Cook Minnesota 27031 521 3
2208068 2208068 2022-02-12 Cook Minnesota 27031 521 3
2204815 2204815 2022-02-11 Cook Minnesota 27031 521 3
2201562 2201562 2022-02-10 Cook Minnesota 27031 519 3
2198308 2198308 2022-02-09 Cook Minnesota 27031 518 2
2195054 2195054 2022-02-08 Cook Minnesota 27031 519 2
2191800 2191800 2022-02-07 Cook Minnesota 27031 516 2
2188547 2188547 2022-02-06 Cook Minnesota 27031 513 2
2185294 2185294 2022-02-05 Cook Minnesota 27031 513 2
2182042 2182042 2022-02-04 Cook Minnesota 27031 513 2
2178790 2178790 2022-02-03 Cook Minnesota 27031 509 2

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