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

774 rows where fips = 27015 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 27015 · 774 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500912 2500912 2022-05-13 Brown Minnesota 27015 6624 81
2497654 2497654 2022-05-12 Brown Minnesota 27015 6618 81
2494396 2494396 2022-05-11 Brown Minnesota 27015 6601 81
2491138 2491138 2022-05-10 Brown Minnesota 27015 6591 81
2487881 2487881 2022-05-09 Brown Minnesota 27015 6582 81
2484623 2484623 2022-05-08 Brown Minnesota 27015 6576 81
2481365 2481365 2022-05-07 Brown Minnesota 27015 6576 81
2478107 2478107 2022-05-06 Brown Minnesota 27015 6576 81
2474849 2474849 2022-05-05 Brown Minnesota 27015 6571 81
2471592 2471592 2022-05-04 Brown Minnesota 27015 6563 81
2468336 2468336 2022-05-03 Brown Minnesota 27015 6560 81
2465081 2465081 2022-05-02 Brown Minnesota 27015 6559 81
2461825 2461825 2022-05-01 Brown Minnesota 27015 6555 81
2458569 2458569 2022-04-30 Brown Minnesota 27015 6555 81
2455313 2455313 2022-04-29 Brown Minnesota 27015 6555 81
2452057 2452057 2022-04-28 Brown Minnesota 27015 6551 81
2448801 2448801 2022-04-27 Brown Minnesota 27015 6548 81
2445545 2445545 2022-04-26 Brown Minnesota 27015 6546 81
2442289 2442289 2022-04-25 Brown Minnesota 27015 6544 81
2439033 2439033 2022-04-24 Brown Minnesota 27015 6542 81
2435777 2435777 2022-04-23 Brown Minnesota 27015 6542 81
2432521 2432521 2022-04-22 Brown Minnesota 27015 6542 81
2429265 2429265 2022-04-21 Brown Minnesota 27015 6541 81
2426009 2426009 2022-04-20 Brown Minnesota 27015 6539 81
2422753 2422753 2022-04-19 Brown Minnesota 27015 6537 81
2419497 2419497 2022-04-18 Brown Minnesota 27015 6535 81
2416241 2416241 2022-04-17 Brown Minnesota 27015 6535 81
2412985 2412985 2022-04-16 Brown Minnesota 27015 6535 81
2409729 2409729 2022-04-15 Brown Minnesota 27015 6535 81
2406473 2406473 2022-04-14 Brown Minnesota 27015 6532 81
2403217 2403217 2022-04-13 Brown Minnesota 27015 6531 81
2399963 2399963 2022-04-12 Brown Minnesota 27015 6530 81
2396707 2396707 2022-04-11 Brown Minnesota 27015 6528 81
2393452 2393452 2022-04-10 Brown Minnesota 27015 6527 81
2390196 2390196 2022-04-09 Brown Minnesota 27015 6527 81
2386940 2386940 2022-04-08 Brown Minnesota 27015 6527 81
2383685 2383685 2022-04-07 Brown Minnesota 27015 6527 81
2380430 2380430 2022-04-06 Brown Minnesota 27015 6524 81
2377175 2377175 2022-04-05 Brown Minnesota 27015 6522 81
2373923 2373923 2022-04-04 Brown Minnesota 27015 6522 81
2370670 2370670 2022-04-03 Brown Minnesota 27015 6520 81
2367417 2367417 2022-04-02 Brown Minnesota 27015 6520 81
2364164 2364164 2022-04-01 Brown Minnesota 27015 6520 81
2360910 2360910 2022-03-31 Brown Minnesota 27015 6520 81
2357656 2357656 2022-03-30 Brown Minnesota 27015 6518 81
2354403 2354403 2022-03-29 Brown Minnesota 27015 6518 81
2351151 2351151 2022-03-28 Brown Minnesota 27015 6516 80
2347898 2347898 2022-03-27 Brown Minnesota 27015 6516 79
2344645 2344645 2022-03-26 Brown Minnesota 27015 6516 79
2341392 2341392 2022-03-25 Brown Minnesota 27015 6516 79
2338139 2338139 2022-03-24 Brown Minnesota 27015 6515 79
2334885 2334885 2022-03-23 Brown Minnesota 27015 6513 79
2331631 2331631 2022-03-22 Brown Minnesota 27015 6513 79
2328379 2328379 2022-03-21 Brown Minnesota 27015 6513 79
2325126 2325126 2022-03-20 Brown Minnesota 27015 6512 79
2321872 2321872 2022-03-19 Brown Minnesota 27015 6512 79
2318618 2318618 2022-03-18 Brown Minnesota 27015 6512 79
2315365 2315365 2022-03-17 Brown Minnesota 27015 6512 79
2312112 2312112 2022-03-16 Brown Minnesota 27015 6511 79
2308859 2308859 2022-03-15 Brown Minnesota 27015 6507 79
2305608 2305608 2022-03-14 Brown Minnesota 27015 6506 79
2302356 2302356 2022-03-13 Brown Minnesota 27015 6505 79
2299104 2299104 2022-03-12 Brown Minnesota 27015 6505 79
2295852 2295852 2022-03-11 Brown Minnesota 27015 6505 79
2292600 2292600 2022-03-10 Brown Minnesota 27015 6494 78
2289348 2289348 2022-03-09 Brown Minnesota 27015 6486 77
2286097 2286097 2022-03-08 Brown Minnesota 27015 6482 77
2282845 2282845 2022-03-07 Brown Minnesota 27015 6481 77
2279592 2279592 2022-03-06 Brown Minnesota 27015 6478 77
2276339 2276339 2022-03-05 Brown Minnesota 27015 6478 77
2273086 2273086 2022-03-04 Brown Minnesota 27015 6478 77
2269834 2269834 2022-03-03 Brown Minnesota 27015 6475 77
2266581 2266581 2022-03-02 Brown Minnesota 27015 6471 77
2263330 2263330 2022-03-01 Brown Minnesota 27015 6466 76
2260079 2260079 2022-02-28 Brown Minnesota 27015 6462 76
2256828 2256828 2022-02-27 Brown Minnesota 27015 6456 76
2253577 2253577 2022-02-26 Brown Minnesota 27015 6456 76
2250326 2250326 2022-02-25 Brown Minnesota 27015 6456 76
2247075 2247075 2022-02-24 Brown Minnesota 27015 6454 75
2243824 2243824 2022-02-23 Brown Minnesota 27015 6447 74
2240573 2240573 2022-02-22 Brown Minnesota 27015 6442 74
2237322 2237322 2022-02-21 Brown Minnesota 27015 6440 74
2234071 2234071 2022-02-20 Brown Minnesota 27015 6440 74
2230820 2230820 2022-02-19 Brown Minnesota 27015 6440 74
2227569 2227569 2022-02-18 Brown Minnesota 27015 6440 74
2224318 2224318 2022-02-17 Brown Minnesota 27015 6431 73
2221067 2221067 2022-02-16 Brown Minnesota 27015 6427 72
2217816 2217816 2022-02-15 Brown Minnesota 27015 6422 72
2214565 2214565 2022-02-14 Brown Minnesota 27015 6391 72
2211313 2211313 2022-02-13 Brown Minnesota 27015 6368 72
2208060 2208060 2022-02-12 Brown Minnesota 27015 6368 72
2204807 2204807 2022-02-11 Brown Minnesota 27015 6368 72
2201554 2201554 2022-02-10 Brown Minnesota 27015 6347 72
2198300 2198300 2022-02-09 Brown Minnesota 27015 6332 72
2195046 2195046 2022-02-08 Brown Minnesota 27015 6314 71
2191792 2191792 2022-02-07 Brown Minnesota 27015 6278 71
2188539 2188539 2022-02-06 Brown Minnesota 27015 6253 71
2185286 2185286 2022-02-05 Brown Minnesota 27015 6253 71
2182034 2182034 2022-02-04 Brown Minnesota 27015 6253 71
2178782 2178782 2022-02-03 Brown Minnesota 27015 6219 71

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