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

742 rows where county = "Grant" and fips = 27051 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 27051 · 742 ✖

county 1

  • Grant · 742 ✖
Link rowid date ▲ county state fips cases deaths
2500930 2500930 2022-05-13 Grant Minnesota 27051 1506 12
2497672 2497672 2022-05-12 Grant Minnesota 27051 1502 12
2494414 2494414 2022-05-11 Grant Minnesota 27051 1502 12
2491156 2491156 2022-05-10 Grant Minnesota 27051 1500 12
2487899 2487899 2022-05-09 Grant Minnesota 27051 1497 12
2484641 2484641 2022-05-08 Grant Minnesota 27051 1495 12
2481383 2481383 2022-05-07 Grant Minnesota 27051 1495 12
2478125 2478125 2022-05-06 Grant Minnesota 27051 1495 12
2474867 2474867 2022-05-05 Grant Minnesota 27051 1493 12
2471610 2471610 2022-05-04 Grant Minnesota 27051 1487 12
2468354 2468354 2022-05-03 Grant Minnesota 27051 1487 12
2465099 2465099 2022-05-02 Grant Minnesota 27051 1483 12
2461843 2461843 2022-05-01 Grant Minnesota 27051 1481 12
2458587 2458587 2022-04-30 Grant Minnesota 27051 1481 12
2455331 2455331 2022-04-29 Grant Minnesota 27051 1481 12
2452075 2452075 2022-04-28 Grant Minnesota 27051 1478 12
2448819 2448819 2022-04-27 Grant Minnesota 27051 1478 12
2445563 2445563 2022-04-26 Grant Minnesota 27051 1478 12
2442307 2442307 2022-04-25 Grant Minnesota 27051 1475 12
2439051 2439051 2022-04-24 Grant Minnesota 27051 1474 12
2435795 2435795 2022-04-23 Grant Minnesota 27051 1474 12
2432539 2432539 2022-04-22 Grant Minnesota 27051 1474 12
2429283 2429283 2022-04-21 Grant Minnesota 27051 1474 12
2426027 2426027 2022-04-20 Grant Minnesota 27051 1473 12
2422771 2422771 2022-04-19 Grant Minnesota 27051 1472 12
2419515 2419515 2022-04-18 Grant Minnesota 27051 1472 12
2416259 2416259 2022-04-17 Grant Minnesota 27051 1471 12
2413003 2413003 2022-04-16 Grant Minnesota 27051 1471 12
2409747 2409747 2022-04-15 Grant Minnesota 27051 1471 12
2406491 2406491 2022-04-14 Grant Minnesota 27051 1471 12
2403235 2403235 2022-04-13 Grant Minnesota 27051 1468 12
2399981 2399981 2022-04-12 Grant Minnesota 27051 1468 12
2396725 2396725 2022-04-11 Grant Minnesota 27051 1467 12
2393470 2393470 2022-04-10 Grant Minnesota 27051 1467 12
2390214 2390214 2022-04-09 Grant Minnesota 27051 1467 12
2386958 2386958 2022-04-08 Grant Minnesota 27051 1467 12
2383703 2383703 2022-04-07 Grant Minnesota 27051 1466 12
2380448 2380448 2022-04-06 Grant Minnesota 27051 1466 12
2377193 2377193 2022-04-05 Grant Minnesota 27051 1466 12
2373941 2373941 2022-04-04 Grant Minnesota 27051 1466 12
2370688 2370688 2022-04-03 Grant Minnesota 27051 1465 12
2367435 2367435 2022-04-02 Grant Minnesota 27051 1465 12
2364182 2364182 2022-04-01 Grant Minnesota 27051 1465 12
2360928 2360928 2022-03-31 Grant Minnesota 27051 1465 12
2357674 2357674 2022-03-30 Grant Minnesota 27051 1465 12
2354421 2354421 2022-03-29 Grant Minnesota 27051 1464 12
2351169 2351169 2022-03-28 Grant Minnesota 27051 1464 12
2347916 2347916 2022-03-27 Grant Minnesota 27051 1464 12
2344663 2344663 2022-03-26 Grant Minnesota 27051 1464 12
2341410 2341410 2022-03-25 Grant Minnesota 27051 1464 12
2338157 2338157 2022-03-24 Grant Minnesota 27051 1463 12
2334903 2334903 2022-03-23 Grant Minnesota 27051 1464 12
2331649 2331649 2022-03-22 Grant Minnesota 27051 1464 12
2328397 2328397 2022-03-21 Grant Minnesota 27051 1464 12
2325144 2325144 2022-03-20 Grant Minnesota 27051 1465 12
2321890 2321890 2022-03-19 Grant Minnesota 27051 1465 12
2318636 2318636 2022-03-18 Grant Minnesota 27051 1465 12
2315383 2315383 2022-03-17 Grant Minnesota 27051 1465 12
2312130 2312130 2022-03-16 Grant Minnesota 27051 1465 12
2308877 2308877 2022-03-15 Grant Minnesota 27051 1464 12
2305626 2305626 2022-03-14 Grant Minnesota 27051 1464 12
2302374 2302374 2022-03-13 Grant Minnesota 27051 1464 12
2299122 2299122 2022-03-12 Grant Minnesota 27051 1464 12
2295870 2295870 2022-03-11 Grant Minnesota 27051 1464 12
2292618 2292618 2022-03-10 Grant Minnesota 27051 1457 12
2289366 2289366 2022-03-09 Grant Minnesota 27051 1450 12
2286115 2286115 2022-03-08 Grant Minnesota 27051 1447 12
2282863 2282863 2022-03-07 Grant Minnesota 27051 1443 12
2279610 2279610 2022-03-06 Grant Minnesota 27051 1442 12
2276357 2276357 2022-03-05 Grant Minnesota 27051 1442 12
2273104 2273104 2022-03-04 Grant Minnesota 27051 1442 12
2269852 2269852 2022-03-03 Grant Minnesota 27051 1441 12
2266599 2266599 2022-03-02 Grant Minnesota 27051 1441 12
2263348 2263348 2022-03-01 Grant Minnesota 27051 1439 12
2260097 2260097 2022-02-28 Grant Minnesota 27051 1439 12
2256846 2256846 2022-02-27 Grant Minnesota 27051 1437 12
2253595 2253595 2022-02-26 Grant Minnesota 27051 1437 12
2250344 2250344 2022-02-25 Grant Minnesota 27051 1437 12
2247093 2247093 2022-02-24 Grant Minnesota 27051 1435 12
2243842 2243842 2022-02-23 Grant Minnesota 27051 1434 12
2240591 2240591 2022-02-22 Grant Minnesota 27051 1430 12
2237340 2237340 2022-02-21 Grant Minnesota 27051 1430 12
2234089 2234089 2022-02-20 Grant Minnesota 27051 1430 12
2230838 2230838 2022-02-19 Grant Minnesota 27051 1430 12
2227587 2227587 2022-02-18 Grant Minnesota 27051 1430 12
2224336 2224336 2022-02-17 Grant Minnesota 27051 1426 12
2221085 2221085 2022-02-16 Grant Minnesota 27051 1426 12
2217834 2217834 2022-02-15 Grant Minnesota 27051 1427 12
2214583 2214583 2022-02-14 Grant Minnesota 27051 1423 12
2211331 2211331 2022-02-13 Grant Minnesota 27051 1413 12
2208078 2208078 2022-02-12 Grant Minnesota 27051 1413 12
2204825 2204825 2022-02-11 Grant Minnesota 27051 1413 12
2201572 2201572 2022-02-10 Grant Minnesota 27051 1409 12
2198318 2198318 2022-02-09 Grant Minnesota 27051 1404 12
2195064 2195064 2022-02-08 Grant Minnesota 27051 1397 12
2191810 2191810 2022-02-07 Grant Minnesota 27051 1388 12
2188557 2188557 2022-02-06 Grant Minnesota 27051 1380 12
2185304 2185304 2022-02-05 Grant Minnesota 27051 1380 12
2182052 2182052 2022-02-04 Grant Minnesota 27051 1380 12
2178800 2178800 2022-02-03 Grant Minnesota 27051 1374 12

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