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

777 rows where county = "Grant" and fips = 21081 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

  • 21081 · 777 ✖

county 1

  • Grant · 777 ✖
Link rowid date ▲ county state fips cases deaths
2500619 2500619 2022-05-13 Grant Kentucky 21081 7855 62
2497361 2497361 2022-05-12 Grant Kentucky 21081 7814 62
2494103 2494103 2022-05-11 Grant Kentucky 21081 7814 62
2490845 2490845 2022-05-10 Grant Kentucky 21081 7814 62
2487588 2487588 2022-05-09 Grant Kentucky 21081 7814 62
2484330 2484330 2022-05-08 Grant Kentucky 21081 7814 62
2481072 2481072 2022-05-07 Grant Kentucky 21081 7814 62
2477814 2477814 2022-05-06 Grant Kentucky 21081 7814 62
2474556 2474556 2022-05-05 Grant Kentucky 21081 7802 61
2471299 2471299 2022-05-04 Grant Kentucky 21081 7802 61
2468043 2468043 2022-05-03 Grant Kentucky 21081 7802 61
2464788 2464788 2022-05-02 Grant Kentucky 21081 7802 61
2461532 2461532 2022-05-01 Grant Kentucky 21081 7802 61
2458276 2458276 2022-04-30 Grant Kentucky 21081 7802 61
2455020 2455020 2022-04-29 Grant Kentucky 21081 7802 61
2451764 2451764 2022-04-28 Grant Kentucky 21081 7793 58
2448508 2448508 2022-04-27 Grant Kentucky 21081 7793 58
2445252 2445252 2022-04-26 Grant Kentucky 21081 7793 58
2441996 2441996 2022-04-25 Grant Kentucky 21081 7793 58
2438740 2438740 2022-04-24 Grant Kentucky 21081 7793 58
2435484 2435484 2022-04-23 Grant Kentucky 21081 7793 58
2432228 2432228 2022-04-22 Grant Kentucky 21081 7793 58
2428972 2428972 2022-04-21 Grant Kentucky 21081 7785 58
2425716 2425716 2022-04-20 Grant Kentucky 21081 7785 58
2422460 2422460 2022-04-19 Grant Kentucky 21081 7785 58
2419204 2419204 2022-04-18 Grant Kentucky 21081 7785 58
2415948 2415948 2022-04-17 Grant Kentucky 21081 7774 58
2412692 2412692 2022-04-16 Grant Kentucky 21081 7774 58
2409436 2409436 2022-04-15 Grant Kentucky 21081 7774 58
2406180 2406180 2022-04-14 Grant Kentucky 21081 7774 58
2402924 2402924 2022-04-13 Grant Kentucky 21081 7774 58
2399670 2399670 2022-04-12 Grant Kentucky 21081 7774 58
2396414 2396414 2022-04-11 Grant Kentucky 21081 7774 58
2393159 2393159 2022-04-10 Grant Kentucky 21081 7774 58
2389903 2389903 2022-04-09 Grant Kentucky 21081 7774 58
2386647 2386647 2022-04-08 Grant Kentucky 21081 7774 58
2383392 2383392 2022-04-07 Grant Kentucky 21081 7762 58
2380137 2380137 2022-04-06 Grant Kentucky 21081 7762 58
2376882 2376882 2022-04-05 Grant Kentucky 21081 7762 58
2373630 2373630 2022-04-04 Grant Kentucky 21081 7762 58
2370377 2370377 2022-04-03 Grant Kentucky 21081 7762 58
2367124 2367124 2022-04-02 Grant Kentucky 21081 7762 58
2363871 2363871 2022-04-01 Grant Kentucky 21081 7762 58
2360617 2360617 2022-03-31 Grant Kentucky 21081 7733 58
2357363 2357363 2022-03-30 Grant Kentucky 21081 7733 58
2354110 2354110 2022-03-29 Grant Kentucky 21081 7733 58
2350858 2350858 2022-03-28 Grant Kentucky 21081 7733 58
2347605 2347605 2022-03-27 Grant Kentucky 21081 7733 58
2344352 2344352 2022-03-26 Grant Kentucky 21081 7733 58
2341099 2341099 2022-03-25 Grant Kentucky 21081 7733 58
2337846 2337846 2022-03-24 Grant Kentucky 21081 7685 58
2334592 2334592 2022-03-23 Grant Kentucky 21081 7685 58
2331338 2331338 2022-03-22 Grant Kentucky 21081 7685 58
2328086 2328086 2022-03-21 Grant Kentucky 21081 7685 58
2324833 2324833 2022-03-20 Grant Kentucky 21081 7685 58
2321579 2321579 2022-03-19 Grant Kentucky 21081 7685 58
2318325 2318325 2022-03-18 Grant Kentucky 21081 7685 58
2315072 2315072 2022-03-17 Grant Kentucky 21081 7639 58
2311819 2311819 2022-03-16 Grant Kentucky 21081 7639 58
2308566 2308566 2022-03-15 Grant Kentucky 21081 7639 58
2305315 2305315 2022-03-14 Grant Kentucky 21081 7639 58
2302063 2302063 2022-03-13 Grant Kentucky 21081 7621 58
2298811 2298811 2022-03-12 Grant Kentucky 21081 7621 58
2295559 2295559 2022-03-11 Grant Kentucky 21081 7621 58
2292307 2292307 2022-03-10 Grant Kentucky 21081 7613 58
2289055 2289055 2022-03-09 Grant Kentucky 21081 7595 57
2285804 2285804 2022-03-08 Grant Kentucky 21081 7583 57
2282552 2282552 2022-03-07 Grant Kentucky 21081 7581 57
2279299 2279299 2022-03-06 Grant Kentucky 21081 7566 57
2276046 2276046 2022-03-05 Grant Kentucky 21081 7566 57
2272793 2272793 2022-03-04 Grant Kentucky 21081 7566 57
2269541 2269541 2022-03-03 Grant Kentucky 21081 7555 57
2266288 2266288 2022-03-02 Grant Kentucky 21081 7550 57
2263037 2263037 2022-03-01 Grant Kentucky 21081 7531 55
2259786 2259786 2022-02-28 Grant Kentucky 21081 7523 55
2256535 2256535 2022-02-27 Grant Kentucky 21081 7494 55
2253284 2253284 2022-02-26 Grant Kentucky 21081 7494 55
2250033 2250033 2022-02-25 Grant Kentucky 21081 7494 55
2246782 2246782 2022-02-24 Grant Kentucky 21081 7516 55
2243531 2243531 2022-02-23 Grant Kentucky 21081 7509 55
2240280 2240280 2022-02-22 Grant Kentucky 21081 7490 55
2237029 2237029 2022-02-21 Grant Kentucky 21081 7476 55
2233778 2233778 2022-02-20 Grant Kentucky 21081 7429 55
2230527 2230527 2022-02-19 Grant Kentucky 21081 7429 55
2227276 2227276 2022-02-18 Grant Kentucky 21081 7429 55
2224025 2224025 2022-02-17 Grant Kentucky 21081 7399 55
2220774 2220774 2022-02-16 Grant Kentucky 21081 7392 55
2217523 2217523 2022-02-15 Grant Kentucky 21081 7377 55
2214272 2214272 2022-02-14 Grant Kentucky 21081 7366 55
2211020 2211020 2022-02-13 Grant Kentucky 21081 7307 55
2207767 2207767 2022-02-12 Grant Kentucky 21081 7307 55
2204514 2204514 2022-02-11 Grant Kentucky 21081 7307 55
2201261 2201261 2022-02-10 Grant Kentucky 21081 7263 55
2198007 2198007 2022-02-09 Grant Kentucky 21081 7253 54
2194753 2194753 2022-02-08 Grant Kentucky 21081 7229 53
2191499 2191499 2022-02-07 Grant Kentucky 21081 7210 53
2188246 2188246 2022-02-06 Grant Kentucky 21081 7180 53
2184993 2184993 2022-02-05 Grant Kentucky 21081 7180 53
2181741 2181741 2022-02-04 Grant Kentucky 21081 7180 53
2178490 2178490 2022-02-03 Grant Kentucky 21081 7127 52

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