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 = "Martin" 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

  • Martin · 788 ✖
Link rowid date ▲ county state fips cases deaths
2500949 2500949 2022-05-13 Martin Minnesota 27091 5685 65
2497691 2497691 2022-05-12 Martin Minnesota 27091 5678 65
2494433 2494433 2022-05-11 Martin Minnesota 27091 5671 64
2491175 2491175 2022-05-10 Martin Minnesota 27091 5670 64
2487918 2487918 2022-05-09 Martin Minnesota 27091 5659 64
2484660 2484660 2022-05-08 Martin Minnesota 27091 5657 64
2481402 2481402 2022-05-07 Martin Minnesota 27091 5657 64
2478144 2478144 2022-05-06 Martin Minnesota 27091 5657 64
2474886 2474886 2022-05-05 Martin Minnesota 27091 5653 64
2471629 2471629 2022-05-04 Martin Minnesota 27091 5649 64
2468373 2468373 2022-05-03 Martin Minnesota 27091 5640 64
2465118 2465118 2022-05-02 Martin Minnesota 27091 5626 64
2461862 2461862 2022-05-01 Martin Minnesota 27091 5624 64
2458606 2458606 2022-04-30 Martin Minnesota 27091 5624 64
2455350 2455350 2022-04-29 Martin Minnesota 27091 5624 64
2452094 2452094 2022-04-28 Martin Minnesota 27091 5622 64
2448838 2448838 2022-04-27 Martin Minnesota 27091 5621 64
2445582 2445582 2022-04-26 Martin Minnesota 27091 5616 64
2442326 2442326 2022-04-25 Martin Minnesota 27091 5608 64
2439070 2439070 2022-04-24 Martin Minnesota 27091 5607 64
2435814 2435814 2022-04-23 Martin Minnesota 27091 5607 64
2432558 2432558 2022-04-22 Martin Minnesota 27091 5607 64
2429302 2429302 2022-04-21 Martin Minnesota 27091 5605 64
2426046 2426046 2022-04-20 Martin Minnesota 27091 5597 64
2422790 2422790 2022-04-19 Martin Minnesota 27091 5597 64
2419534 2419534 2022-04-18 Martin Minnesota 27091 5595 64
2416278 2416278 2022-04-17 Martin Minnesota 27091 5594 64
2413022 2413022 2022-04-16 Martin Minnesota 27091 5594 64
2409766 2409766 2022-04-15 Martin Minnesota 27091 5594 64
2406510 2406510 2022-04-14 Martin Minnesota 27091 5591 64
2403254 2403254 2022-04-13 Martin Minnesota 27091 5588 64
2400000 2400000 2022-04-12 Martin Minnesota 27091 5589 64
2396744 2396744 2022-04-11 Martin Minnesota 27091 5588 64
2393489 2393489 2022-04-10 Martin Minnesota 27091 5588 64
2390233 2390233 2022-04-09 Martin Minnesota 27091 5588 64
2386977 2386977 2022-04-08 Martin Minnesota 27091 5588 64
2383722 2383722 2022-04-07 Martin Minnesota 27091 5588 64
2380467 2380467 2022-04-06 Martin Minnesota 27091 5586 64
2377212 2377212 2022-04-05 Martin Minnesota 27091 5585 64
2373960 2373960 2022-04-04 Martin Minnesota 27091 5579 64
2370707 2370707 2022-04-03 Martin Minnesota 27091 5579 64
2367454 2367454 2022-04-02 Martin Minnesota 27091 5579 64
2364201 2364201 2022-04-01 Martin Minnesota 27091 5579 64
2360947 2360947 2022-03-31 Martin Minnesota 27091 5577 64
2357693 2357693 2022-03-30 Martin Minnesota 27091 5575 64
2354440 2354440 2022-03-29 Martin Minnesota 27091 5574 64
2351188 2351188 2022-03-28 Martin Minnesota 27091 5567 64
2347935 2347935 2022-03-27 Martin Minnesota 27091 5565 64
2344682 2344682 2022-03-26 Martin Minnesota 27091 5565 64
2341429 2341429 2022-03-25 Martin Minnesota 27091 5565 64
2338176 2338176 2022-03-24 Martin Minnesota 27091 5566 64
2334922 2334922 2022-03-23 Martin Minnesota 27091 5565 64
2331668 2331668 2022-03-22 Martin Minnesota 27091 5564 64
2328416 2328416 2022-03-21 Martin Minnesota 27091 5562 64
2325163 2325163 2022-03-20 Martin Minnesota 27091 5560 64
2321909 2321909 2022-03-19 Martin Minnesota 27091 5560 64
2318655 2318655 2022-03-18 Martin Minnesota 27091 5560 64
2315402 2315402 2022-03-17 Martin Minnesota 27091 5557 64
2312149 2312149 2022-03-16 Martin Minnesota 27091 5557 63
2308896 2308896 2022-03-15 Martin Minnesota 27091 5551 62
2305645 2305645 2022-03-14 Martin Minnesota 27091 5550 62
2302393 2302393 2022-03-13 Martin Minnesota 27091 5547 61
2299141 2299141 2022-03-12 Martin Minnesota 27091 5547 61
2295889 2295889 2022-03-11 Martin Minnesota 27091 5547 61
2292637 2292637 2022-03-10 Martin Minnesota 27091 5538 61
2289385 2289385 2022-03-09 Martin Minnesota 27091 5538 61
2286134 2286134 2022-03-08 Martin Minnesota 27091 5533 61
2282882 2282882 2022-03-07 Martin Minnesota 27091 5527 61
2279629 2279629 2022-03-06 Martin Minnesota 27091 5520 61
2276376 2276376 2022-03-05 Martin Minnesota 27091 5520 61
2273123 2273123 2022-03-04 Martin Minnesota 27091 5520 61
2269871 2269871 2022-03-03 Martin Minnesota 27091 5517 60
2266618 2266618 2022-03-02 Martin Minnesota 27091 5512 60
2263367 2263367 2022-03-01 Martin Minnesota 27091 5514 60
2260116 2260116 2022-02-28 Martin Minnesota 27091 5504 60
2256865 2256865 2022-02-27 Martin Minnesota 27091 5502 59
2253614 2253614 2022-02-26 Martin Minnesota 27091 5502 59
2250363 2250363 2022-02-25 Martin Minnesota 27091 5502 59
2247112 2247112 2022-02-24 Martin Minnesota 27091 5495 59
2243861 2243861 2022-02-23 Martin Minnesota 27091 5485 59
2240610 2240610 2022-02-22 Martin Minnesota 27091 5466 59
2237359 2237359 2022-02-21 Martin Minnesota 27091 5448 59
2234108 2234108 2022-02-20 Martin Minnesota 27091 5448 59
2230857 2230857 2022-02-19 Martin Minnesota 27091 5448 59
2227606 2227606 2022-02-18 Martin Minnesota 27091 5448 59
2224355 2224355 2022-02-17 Martin Minnesota 27091 5436 59
2221104 2221104 2022-02-16 Martin Minnesota 27091 5428 59
2217853 2217853 2022-02-15 Martin Minnesota 27091 5415 58
2214602 2214602 2022-02-14 Martin Minnesota 27091 5390 56
2211350 2211350 2022-02-13 Martin Minnesota 27091 5354 56
2208097 2208097 2022-02-12 Martin Minnesota 27091 5354 56
2204844 2204844 2022-02-11 Martin Minnesota 27091 5354 56
2201591 2201591 2022-02-10 Martin Minnesota 27091 5328 56
2198337 2198337 2022-02-09 Martin Minnesota 27091 5310 56
2195083 2195083 2022-02-08 Martin Minnesota 27091 5293 56
2191829 2191829 2022-02-07 Martin Minnesota 27091 5249 54
2188576 2188576 2022-02-06 Martin Minnesota 27091 5220 54
2185323 2185323 2022-02-05 Martin Minnesota 27091 5220 54
2182071 2182071 2022-02-04 Martin Minnesota 27091 5220 54
2178819 2178819 2022-02-03 Martin Minnesota 27091 5193 54

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