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

727 rows where county = "Steele" 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 · 727 ✖

fips 1

county 1

  • Steele · 727 ✖
Link rowid date ▲ county state fips cases deaths
2501631 2501631 2022-05-13 Steele North Dakota 38091 388 2
2498373 2498373 2022-05-12 Steele North Dakota 38091 385 2
2495115 2495115 2022-05-11 Steele North Dakota 38091 385 2
2491857 2491857 2022-05-10 Steele North Dakota 38091 385 2
2488599 2488599 2022-05-09 Steele North Dakota 38091 385 2
2485342 2485342 2022-05-08 Steele North Dakota 38091 385 2
2482084 2482084 2022-05-07 Steele North Dakota 38091 385 2
2478826 2478826 2022-05-06 Steele North Dakota 38091 385 2
2475568 2475568 2022-05-05 Steele North Dakota 38091 384 2
2472311 2472311 2022-05-04 Steele North Dakota 38091 384 2
2469055 2469055 2022-05-03 Steele North Dakota 38091 384 2
2465799 2465799 2022-05-02 Steele North Dakota 38091 384 2
2462544 2462544 2022-05-01 Steele North Dakota 38091 384 2
2459288 2459288 2022-04-30 Steele North Dakota 38091 384 2
2456032 2456032 2022-04-29 Steele North Dakota 38091 384 2
2452776 2452776 2022-04-28 Steele North Dakota 38091 381 2
2449520 2449520 2022-04-27 Steele North Dakota 38091 381 2
2446263 2446263 2022-04-26 Steele North Dakota 38091 381 2
2443008 2443008 2022-04-25 Steele North Dakota 38091 381 2
2439752 2439752 2022-04-24 Steele North Dakota 38091 381 2
2436496 2436496 2022-04-23 Steele North Dakota 38091 381 2
2433240 2433240 2022-04-22 Steele North Dakota 38091 381 2
2429984 2429984 2022-04-21 Steele North Dakota 38091 381 2
2426728 2426728 2022-04-20 Steele North Dakota 38091 381 2
2423472 2423472 2022-04-19 Steele North Dakota 38091 381 2
2420215 2420215 2022-04-18 Steele North Dakota 38091 381 2
2416960 2416960 2022-04-17 Steele North Dakota 38091 381 2
2413704 2413704 2022-04-16 Steele North Dakota 38091 381 2
2410448 2410448 2022-04-15 Steele North Dakota 38091 381 2
2407192 2407192 2022-04-14 Steele North Dakota 38091 380 2
2403936 2403936 2022-04-13 Steele North Dakota 38091 380 2
2400681 2400681 2022-04-12 Steele North Dakota 38091 380 2
2397426 2397426 2022-04-11 Steele North Dakota 38091 380 2
2394171 2394171 2022-04-10 Steele North Dakota 38091 380 2
2390915 2390915 2022-04-09 Steele North Dakota 38091 380 2
2387659 2387659 2022-04-08 Steele North Dakota 38091 380 2
2384404 2384404 2022-04-07 Steele North Dakota 38091 380 2
2381149 2381149 2022-04-06 Steele North Dakota 38091 380 2
2377894 2377894 2022-04-05 Steele North Dakota 38091 380 2
2374641 2374641 2022-04-04 Steele North Dakota 38091 380 2
2371389 2371389 2022-04-03 Steele North Dakota 38091 380 2
2368136 2368136 2022-04-02 Steele North Dakota 38091 380 2
2364883 2364883 2022-04-01 Steele North Dakota 38091 380 2
2361629 2361629 2022-03-31 Steele North Dakota 38091 380 2
2358375 2358375 2022-03-30 Steele North Dakota 38091 380 2
2355121 2355121 2022-03-29 Steele North Dakota 38091 380 2
2351868 2351868 2022-03-28 Steele North Dakota 38091 380 2
2348616 2348616 2022-03-27 Steele North Dakota 38091 380 2
2345363 2345363 2022-03-26 Steele North Dakota 38091 380 2
2342110 2342110 2022-03-25 Steele North Dakota 38091 380 2
2338857 2338857 2022-03-24 Steele North Dakota 38091 380 2
2335603 2335603 2022-03-23 Steele North Dakota 38091 380 2
2332349 2332349 2022-03-22 Steele North Dakota 38091 380 2
2329096 2329096 2022-03-21 Steele North Dakota 38091 380 2
2325844 2325844 2022-03-20 Steele North Dakota 38091 380 2
2322591 2322591 2022-03-19 Steele North Dakota 38091 380 2
2319337 2319337 2022-03-18 Steele North Dakota 38091 380 2
2316083 2316083 2022-03-17 Steele North Dakota 38091 380 2
2312830 2312830 2022-03-16 Steele North Dakota 38091 380 2
2309577 2309577 2022-03-15 Steele North Dakota 38091 380 2
2306324 2306324 2022-03-14 Steele North Dakota 38091 380 2
2303073 2303073 2022-03-13 Steele North Dakota 38091 380 2
2299821 2299821 2022-03-12 Steele North Dakota 38091 380 2
2296569 2296569 2022-03-11 Steele North Dakota 38091 383 2
2293317 2293317 2022-03-10 Steele North Dakota 38091 383 2
2290065 2290065 2022-03-09 Steele North Dakota 38091 383 2
2286813 2286813 2022-03-08 Steele North Dakota 38091 383 2
2283561 2283561 2022-03-07 Steele North Dakota 38091 383 2
2280309 2280309 2022-03-06 Steele North Dakota 38091 383 2
2277056 2277056 2022-03-05 Steele North Dakota 38091 383 2
2273803 2273803 2022-03-04 Steele North Dakota 38091 383 2
2270550 2270550 2022-03-03 Steele North Dakota 38091 383 2
2267298 2267298 2022-03-02 Steele North Dakota 38091 382 2
2264046 2264046 2022-03-01 Steele North Dakota 38091 382 2
2260795 2260795 2022-02-28 Steele North Dakota 38091 381 2
2257544 2257544 2022-02-27 Steele North Dakota 38091 381 2
2254293 2254293 2022-02-26 Steele North Dakota 38091 381 2
2251042 2251042 2022-02-25 Steele North Dakota 38091 381 2
2247791 2247791 2022-02-24 Steele North Dakota 38091 381 2
2244540 2244540 2022-02-23 Steele North Dakota 38091 381 2
2241289 2241289 2022-02-22 Steele North Dakota 38091 381 2
2238038 2238038 2022-02-21 Steele North Dakota 38091 381 2
2234787 2234787 2022-02-20 Steele North Dakota 38091 381 2
2231536 2231536 2022-02-19 Steele North Dakota 38091 381 2
2228285 2228285 2022-02-18 Steele North Dakota 38091 381 2
2225034 2225034 2022-02-17 Steele North Dakota 38091 380 2
2221783 2221783 2022-02-16 Steele North Dakota 38091 380 2
2218532 2218532 2022-02-15 Steele North Dakota 38091 380 2
2215281 2215281 2022-02-14 Steele North Dakota 38091 379 2
2212030 2212030 2022-02-13 Steele North Dakota 38091 377 2
2208777 2208777 2022-02-12 Steele North Dakota 38091 377 2
2205524 2205524 2022-02-11 Steele North Dakota 38091 377 2
2202271 2202271 2022-02-10 Steele North Dakota 38091 377 2
2199017 2199017 2022-02-09 Steele North Dakota 38091 377 2
2195763 2195763 2022-02-08 Steele North Dakota 38091 378 2
2192509 2192509 2022-02-07 Steele North Dakota 38091 378 2
2189255 2189255 2022-02-06 Steele North Dakota 38091 377 2
2186002 2186002 2022-02-05 Steele North Dakota 38091 377 2
2182750 2182750 2022-02-04 Steele North Dakota 38091 376 2
2179498 2179498 2022-02-03 Steele North Dakota 38091 376 2

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