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 county = "Grant" and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • North Dakota · 774 ✖

fips 1

county 1

  • Grant · 774 ✖
Link rowid date ▲ county state fips cases deaths
2501604 2501604 2022-05-13 Grant North Dakota 38037 451 11
2498346 2498346 2022-05-12 Grant North Dakota 38037 451 11
2495088 2495088 2022-05-11 Grant North Dakota 38037 451 11
2491830 2491830 2022-05-10 Grant North Dakota 38037 451 11
2488572 2488572 2022-05-09 Grant North Dakota 38037 451 11
2485315 2485315 2022-05-08 Grant North Dakota 38037 451 11
2482057 2482057 2022-05-07 Grant North Dakota 38037 451 11
2478799 2478799 2022-05-06 Grant North Dakota 38037 451 11
2475541 2475541 2022-05-05 Grant North Dakota 38037 451 11
2472284 2472284 2022-05-04 Grant North Dakota 38037 451 11
2469028 2469028 2022-05-03 Grant North Dakota 38037 451 11
2465772 2465772 2022-05-02 Grant North Dakota 38037 451 11
2462517 2462517 2022-05-01 Grant North Dakota 38037 451 11
2459261 2459261 2022-04-30 Grant North Dakota 38037 451 11
2456005 2456005 2022-04-29 Grant North Dakota 38037 451 11
2452749 2452749 2022-04-28 Grant North Dakota 38037 451 11
2449493 2449493 2022-04-27 Grant North Dakota 38037 451 11
2446236 2446236 2022-04-26 Grant North Dakota 38037 451 11
2442981 2442981 2022-04-25 Grant North Dakota 38037 451 11
2439725 2439725 2022-04-24 Grant North Dakota 38037 451 11
2436469 2436469 2022-04-23 Grant North Dakota 38037 451 11
2433213 2433213 2022-04-22 Grant North Dakota 38037 451 11
2429957 2429957 2022-04-21 Grant North Dakota 38037 452 11
2426701 2426701 2022-04-20 Grant North Dakota 38037 452 11
2423445 2423445 2022-04-19 Grant North Dakota 38037 452 11
2420188 2420188 2022-04-18 Grant North Dakota 38037 452 11
2416933 2416933 2022-04-17 Grant North Dakota 38037 452 11
2413677 2413677 2022-04-16 Grant North Dakota 38037 452 11
2410421 2410421 2022-04-15 Grant North Dakota 38037 452 11
2407165 2407165 2022-04-14 Grant North Dakota 38037 452 11
2403909 2403909 2022-04-13 Grant North Dakota 38037 452 11
2400654 2400654 2022-04-12 Grant North Dakota 38037 452 11
2397399 2397399 2022-04-11 Grant North Dakota 38037 452 11
2394144 2394144 2022-04-10 Grant North Dakota 38037 452 11
2390888 2390888 2022-04-09 Grant North Dakota 38037 452 11
2387632 2387632 2022-04-08 Grant North Dakota 38037 452 11
2384377 2384377 2022-04-07 Grant North Dakota 38037 451 11
2381122 2381122 2022-04-06 Grant North Dakota 38037 451 11
2377867 2377867 2022-04-05 Grant North Dakota 38037 451 11
2374614 2374614 2022-04-04 Grant North Dakota 38037 451 11
2371362 2371362 2022-04-03 Grant North Dakota 38037 451 11
2368109 2368109 2022-04-02 Grant North Dakota 38037 451 11
2364856 2364856 2022-04-01 Grant North Dakota 38037 451 11
2361602 2361602 2022-03-31 Grant North Dakota 38037 451 11
2358348 2358348 2022-03-30 Grant North Dakota 38037 451 11
2355094 2355094 2022-03-29 Grant North Dakota 38037 451 11
2351841 2351841 2022-03-28 Grant North Dakota 38037 451 11
2348589 2348589 2022-03-27 Grant North Dakota 38037 451 11
2345336 2345336 2022-03-26 Grant North Dakota 38037 451 11
2342083 2342083 2022-03-25 Grant North Dakota 38037 451 11
2338830 2338830 2022-03-24 Grant North Dakota 38037 451 11
2335576 2335576 2022-03-23 Grant North Dakota 38037 451 11
2332322 2332322 2022-03-22 Grant North Dakota 38037 451 11
2329069 2329069 2022-03-21 Grant North Dakota 38037 451 11
2325817 2325817 2022-03-20 Grant North Dakota 38037 451 11
2322564 2322564 2022-03-19 Grant North Dakota 38037 451 11
2319310 2319310 2022-03-18 Grant North Dakota 38037 451 11
2316056 2316056 2022-03-17 Grant North Dakota 38037 452 11
2312803 2312803 2022-03-16 Grant North Dakota 38037 452 11
2309550 2309550 2022-03-15 Grant North Dakota 38037 452 11
2306297 2306297 2022-03-14 Grant North Dakota 38037 453 11
2303046 2303046 2022-03-13 Grant North Dakota 38037 453 11
2299794 2299794 2022-03-12 Grant North Dakota 38037 453 11
2296542 2296542 2022-03-11 Grant North Dakota 38037 449 11
2293290 2293290 2022-03-10 Grant North Dakota 38037 451 11
2290038 2290038 2022-03-09 Grant North Dakota 38037 450 11
2286786 2286786 2022-03-08 Grant North Dakota 38037 450 11
2283534 2283534 2022-03-07 Grant North Dakota 38037 450 11
2280282 2280282 2022-03-06 Grant North Dakota 38037 450 11
2277029 2277029 2022-03-05 Grant North Dakota 38037 450 11
2273776 2273776 2022-03-04 Grant North Dakota 38037 450 11
2270523 2270523 2022-03-03 Grant North Dakota 38037 450 11
2267271 2267271 2022-03-02 Grant North Dakota 38037 450 11
2264019 2264019 2022-03-01 Grant North Dakota 38037 450 11
2260768 2260768 2022-02-28 Grant North Dakota 38037 450 11
2257517 2257517 2022-02-27 Grant North Dakota 38037 450 11
2254266 2254266 2022-02-26 Grant North Dakota 38037 450 11
2251015 2251015 2022-02-25 Grant North Dakota 38037 450 11
2247764 2247764 2022-02-24 Grant North Dakota 38037 448 11
2244513 2244513 2022-02-23 Grant North Dakota 38037 449 11
2241262 2241262 2022-02-22 Grant North Dakota 38037 449 11
2238011 2238011 2022-02-21 Grant North Dakota 38037 449 11
2234760 2234760 2022-02-20 Grant North Dakota 38037 449 11
2231509 2231509 2022-02-19 Grant North Dakota 38037 448 11
2228258 2228258 2022-02-18 Grant North Dakota 38037 448 11
2225007 2225007 2022-02-17 Grant North Dakota 38037 448 11
2221756 2221756 2022-02-16 Grant North Dakota 38037 448 11
2218505 2218505 2022-02-15 Grant North Dakota 38037 448 11
2215254 2215254 2022-02-14 Grant North Dakota 38037 448 11
2212003 2212003 2022-02-13 Grant North Dakota 38037 448 11
2208750 2208750 2022-02-12 Grant North Dakota 38037 448 11
2205497 2205497 2022-02-11 Grant North Dakota 38037 447 11
2202244 2202244 2022-02-10 Grant North Dakota 38037 447 11
2198990 2198990 2022-02-09 Grant North Dakota 38037 447 11
2195736 2195736 2022-02-08 Grant North Dakota 38037 445 11
2192482 2192482 2022-02-07 Grant North Dakota 38037 444 11
2189228 2189228 2022-02-06 Grant North Dakota 38037 443 11
2185975 2185975 2022-02-05 Grant North Dakota 38037 443 11
2182723 2182723 2022-02-04 Grant North Dakota 38037 442 11
2179471 2179471 2022-02-03 Grant North Dakota 38037 441 11

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