ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,511 rows where county = "Steele" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500978 | 2500978 | 2022-05-13 | Steele | Minnesota | 27147 | 10657 | 62 |
2501631 | 2501631 | 2022-05-13 | Steele | North Dakota | 38091 | 388 | 2 |
2497720 | 2497720 | 2022-05-12 | Steele | Minnesota | 27147 | 10641 | 62 |
2498373 | 2498373 | 2022-05-12 | Steele | North Dakota | 38091 | 385 | 2 |
2494462 | 2494462 | 2022-05-11 | Steele | Minnesota | 27147 | 10620 | 62 |
2495115 | 2495115 | 2022-05-11 | Steele | North Dakota | 38091 | 385 | 2 |
2491204 | 2491204 | 2022-05-10 | Steele | Minnesota | 27147 | 10615 | 62 |
2491857 | 2491857 | 2022-05-10 | Steele | North Dakota | 38091 | 385 | 2 |
2487947 | 2487947 | 2022-05-09 | Steele | Minnesota | 27147 | 10592 | 62 |
2488599 | 2488599 | 2022-05-09 | Steele | North Dakota | 38091 | 385 | 2 |
2484689 | 2484689 | 2022-05-08 | Steele | Minnesota | 27147 | 10583 | 62 |
2485342 | 2485342 | 2022-05-08 | Steele | North Dakota | 38091 | 385 | 2 |
2481431 | 2481431 | 2022-05-07 | Steele | Minnesota | 27147 | 10583 | 62 |
2482084 | 2482084 | 2022-05-07 | Steele | North Dakota | 38091 | 385 | 2 |
2478173 | 2478173 | 2022-05-06 | Steele | Minnesota | 27147 | 10583 | 62 |
2478826 | 2478826 | 2022-05-06 | Steele | North Dakota | 38091 | 385 | 2 |
2474915 | 2474915 | 2022-05-05 | Steele | Minnesota | 27147 | 10565 | 62 |
2475568 | 2475568 | 2022-05-05 | Steele | North Dakota | 38091 | 384 | 2 |
2471658 | 2471658 | 2022-05-04 | Steele | Minnesota | 27147 | 10550 | 62 |
2472311 | 2472311 | 2022-05-04 | Steele | North Dakota | 38091 | 384 | 2 |
2468402 | 2468402 | 2022-05-03 | Steele | Minnesota | 27147 | 10537 | 62 |
2469055 | 2469055 | 2022-05-03 | Steele | North Dakota | 38091 | 384 | 2 |
2465147 | 2465147 | 2022-05-02 | Steele | Minnesota | 27147 | 10520 | 62 |
2465799 | 2465799 | 2022-05-02 | Steele | North Dakota | 38091 | 384 | 2 |
2461891 | 2461891 | 2022-05-01 | Steele | Minnesota | 27147 | 10508 | 62 |
2462544 | 2462544 | 2022-05-01 | Steele | North Dakota | 38091 | 384 | 2 |
2458635 | 2458635 | 2022-04-30 | Steele | Minnesota | 27147 | 10508 | 62 |
2459288 | 2459288 | 2022-04-30 | Steele | North Dakota | 38091 | 384 | 2 |
2455379 | 2455379 | 2022-04-29 | Steele | Minnesota | 27147 | 10508 | 62 |
2456032 | 2456032 | 2022-04-29 | Steele | North Dakota | 38091 | 384 | 2 |
2452123 | 2452123 | 2022-04-28 | Steele | Minnesota | 27147 | 10495 | 62 |
2452776 | 2452776 | 2022-04-28 | Steele | North Dakota | 38091 | 381 | 2 |
2448867 | 2448867 | 2022-04-27 | Steele | Minnesota | 27147 | 10482 | 62 |
2449520 | 2449520 | 2022-04-27 | Steele | North Dakota | 38091 | 381 | 2 |
2445611 | 2445611 | 2022-04-26 | Steele | Minnesota | 27147 | 10467 | 62 |
2446263 | 2446263 | 2022-04-26 | Steele | North Dakota | 38091 | 381 | 2 |
2442355 | 2442355 | 2022-04-25 | Steele | Minnesota | 27147 | 10445 | 62 |
2443008 | 2443008 | 2022-04-25 | Steele | North Dakota | 38091 | 381 | 2 |
2439099 | 2439099 | 2022-04-24 | Steele | Minnesota | 27147 | 10438 | 62 |
2439752 | 2439752 | 2022-04-24 | Steele | North Dakota | 38091 | 381 | 2 |
2435843 | 2435843 | 2022-04-23 | Steele | Minnesota | 27147 | 10438 | 62 |
2436496 | 2436496 | 2022-04-23 | Steele | North Dakota | 38091 | 381 | 2 |
2432587 | 2432587 | 2022-04-22 | Steele | Minnesota | 27147 | 10438 | 62 |
2433240 | 2433240 | 2022-04-22 | Steele | North Dakota | 38091 | 381 | 2 |
2429331 | 2429331 | 2022-04-21 | Steele | Minnesota | 27147 | 10432 | 62 |
2429984 | 2429984 | 2022-04-21 | Steele | North Dakota | 38091 | 381 | 2 |
2426075 | 2426075 | 2022-04-20 | Steele | Minnesota | 27147 | 10419 | 62 |
2426728 | 2426728 | 2022-04-20 | Steele | North Dakota | 38091 | 381 | 2 |
2422819 | 2422819 | 2022-04-19 | Steele | Minnesota | 27147 | 10413 | 62 |
2423472 | 2423472 | 2022-04-19 | Steele | North Dakota | 38091 | 381 | 2 |
2419563 | 2419563 | 2022-04-18 | Steele | Minnesota | 27147 | 10401 | 62 |
2420215 | 2420215 | 2022-04-18 | Steele | North Dakota | 38091 | 381 | 2 |
2416307 | 2416307 | 2022-04-17 | Steele | Minnesota | 27147 | 10392 | 62 |
2416960 | 2416960 | 2022-04-17 | Steele | North Dakota | 38091 | 381 | 2 |
2413051 | 2413051 | 2022-04-16 | Steele | Minnesota | 27147 | 10392 | 62 |
2413704 | 2413704 | 2022-04-16 | Steele | North Dakota | 38091 | 381 | 2 |
2409795 | 2409795 | 2022-04-15 | Steele | Minnesota | 27147 | 10392 | 62 |
2410448 | 2410448 | 2022-04-15 | Steele | North Dakota | 38091 | 381 | 2 |
2406539 | 2406539 | 2022-04-14 | Steele | Minnesota | 27147 | 10383 | 62 |
2407192 | 2407192 | 2022-04-14 | Steele | North Dakota | 38091 | 380 | 2 |
2403283 | 2403283 | 2022-04-13 | Steele | Minnesota | 27147 | 10376 | 62 |
2403936 | 2403936 | 2022-04-13 | Steele | North Dakota | 38091 | 380 | 2 |
2400029 | 2400029 | 2022-04-12 | Steele | Minnesota | 27147 | 10374 | 62 |
2400681 | 2400681 | 2022-04-12 | Steele | North Dakota | 38091 | 380 | 2 |
2396773 | 2396773 | 2022-04-11 | Steele | Minnesota | 27147 | 10353 | 61 |
2397426 | 2397426 | 2022-04-11 | Steele | North Dakota | 38091 | 380 | 2 |
2393518 | 2393518 | 2022-04-10 | Steele | Minnesota | 27147 | 10348 | 61 |
2394171 | 2394171 | 2022-04-10 | Steele | North Dakota | 38091 | 380 | 2 |
2390262 | 2390262 | 2022-04-09 | Steele | Minnesota | 27147 | 10348 | 61 |
2390915 | 2390915 | 2022-04-09 | Steele | North Dakota | 38091 | 380 | 2 |
2387006 | 2387006 | 2022-04-08 | Steele | Minnesota | 27147 | 10348 | 61 |
2387659 | 2387659 | 2022-04-08 | Steele | North Dakota | 38091 | 380 | 2 |
2383751 | 2383751 | 2022-04-07 | Steele | Minnesota | 27147 | 10339 | 61 |
2384404 | 2384404 | 2022-04-07 | Steele | North Dakota | 38091 | 380 | 2 |
2380496 | 2380496 | 2022-04-06 | Steele | Minnesota | 27147 | 10332 | 61 |
2381149 | 2381149 | 2022-04-06 | Steele | North Dakota | 38091 | 380 | 2 |
2377241 | 2377241 | 2022-04-05 | Steele | Minnesota | 27147 | 10330 | 61 |
2377894 | 2377894 | 2022-04-05 | Steele | North Dakota | 38091 | 380 | 2 |
2373989 | 2373989 | 2022-04-04 | Steele | Minnesota | 27147 | 10322 | 60 |
2374641 | 2374641 | 2022-04-04 | Steele | North Dakota | 38091 | 380 | 2 |
2370736 | 2370736 | 2022-04-03 | Steele | Minnesota | 27147 | 10320 | 60 |
2371389 | 2371389 | 2022-04-03 | Steele | North Dakota | 38091 | 380 | 2 |
2367483 | 2367483 | 2022-04-02 | Steele | Minnesota | 27147 | 10320 | 60 |
2368136 | 2368136 | 2022-04-02 | Steele | North Dakota | 38091 | 380 | 2 |
2364230 | 2364230 | 2022-04-01 | Steele | Minnesota | 27147 | 10320 | 60 |
2364883 | 2364883 | 2022-04-01 | Steele | North Dakota | 38091 | 380 | 2 |
2360976 | 2360976 | 2022-03-31 | Steele | Minnesota | 27147 | 10316 | 60 |
2361629 | 2361629 | 2022-03-31 | Steele | North Dakota | 38091 | 380 | 2 |
2357722 | 2357722 | 2022-03-30 | Steele | Minnesota | 27147 | 10312 | 59 |
2358375 | 2358375 | 2022-03-30 | Steele | North Dakota | 38091 | 380 | 2 |
2354469 | 2354469 | 2022-03-29 | Steele | Minnesota | 27147 | 10306 | 59 |
2355121 | 2355121 | 2022-03-29 | Steele | North Dakota | 38091 | 380 | 2 |
2351217 | 2351217 | 2022-03-28 | Steele | Minnesota | 27147 | 10296 | 59 |
2351868 | 2351868 | 2022-03-28 | Steele | North Dakota | 38091 | 380 | 2 |
2347964 | 2347964 | 2022-03-27 | Steele | Minnesota | 27147 | 10292 | 59 |
2348616 | 2348616 | 2022-03-27 | Steele | North Dakota | 38091 | 380 | 2 |
2344711 | 2344711 | 2022-03-26 | Steele | Minnesota | 27147 | 10292 | 59 |
2345363 | 2345363 | 2022-03-26 | Steele | North Dakota | 38091 | 380 | 2 |
2341458 | 2341458 | 2022-03-25 | Steele | Minnesota | 27147 | 10292 | 59 |
2342110 | 2342110 | 2022-03-25 | Steele | North Dakota | 38091 | 380 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
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);