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

784 rows where county = "Steele" and fips = 27147 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

  • 27147 · 784 ✖

county 1

  • Steele · 784 ✖
Link rowid date ▲ county state fips cases deaths
2500978 2500978 2022-05-13 Steele Minnesota 27147 10657 62
2497720 2497720 2022-05-12 Steele Minnesota 27147 10641 62
2494462 2494462 2022-05-11 Steele Minnesota 27147 10620 62
2491204 2491204 2022-05-10 Steele Minnesota 27147 10615 62
2487947 2487947 2022-05-09 Steele Minnesota 27147 10592 62
2484689 2484689 2022-05-08 Steele Minnesota 27147 10583 62
2481431 2481431 2022-05-07 Steele Minnesota 27147 10583 62
2478173 2478173 2022-05-06 Steele Minnesota 27147 10583 62
2474915 2474915 2022-05-05 Steele Minnesota 27147 10565 62
2471658 2471658 2022-05-04 Steele Minnesota 27147 10550 62
2468402 2468402 2022-05-03 Steele Minnesota 27147 10537 62
2465147 2465147 2022-05-02 Steele Minnesota 27147 10520 62
2461891 2461891 2022-05-01 Steele Minnesota 27147 10508 62
2458635 2458635 2022-04-30 Steele Minnesota 27147 10508 62
2455379 2455379 2022-04-29 Steele Minnesota 27147 10508 62
2452123 2452123 2022-04-28 Steele Minnesota 27147 10495 62
2448867 2448867 2022-04-27 Steele Minnesota 27147 10482 62
2445611 2445611 2022-04-26 Steele Minnesota 27147 10467 62
2442355 2442355 2022-04-25 Steele Minnesota 27147 10445 62
2439099 2439099 2022-04-24 Steele Minnesota 27147 10438 62
2435843 2435843 2022-04-23 Steele Minnesota 27147 10438 62
2432587 2432587 2022-04-22 Steele Minnesota 27147 10438 62
2429331 2429331 2022-04-21 Steele Minnesota 27147 10432 62
2426075 2426075 2022-04-20 Steele Minnesota 27147 10419 62
2422819 2422819 2022-04-19 Steele Minnesota 27147 10413 62
2419563 2419563 2022-04-18 Steele Minnesota 27147 10401 62
2416307 2416307 2022-04-17 Steele Minnesota 27147 10392 62
2413051 2413051 2022-04-16 Steele Minnesota 27147 10392 62
2409795 2409795 2022-04-15 Steele Minnesota 27147 10392 62
2406539 2406539 2022-04-14 Steele Minnesota 27147 10383 62
2403283 2403283 2022-04-13 Steele Minnesota 27147 10376 62
2400029 2400029 2022-04-12 Steele Minnesota 27147 10374 62
2396773 2396773 2022-04-11 Steele Minnesota 27147 10353 61
2393518 2393518 2022-04-10 Steele Minnesota 27147 10348 61
2390262 2390262 2022-04-09 Steele Minnesota 27147 10348 61
2387006 2387006 2022-04-08 Steele Minnesota 27147 10348 61
2383751 2383751 2022-04-07 Steele Minnesota 27147 10339 61
2380496 2380496 2022-04-06 Steele Minnesota 27147 10332 61
2377241 2377241 2022-04-05 Steele Minnesota 27147 10330 61
2373989 2373989 2022-04-04 Steele Minnesota 27147 10322 60
2370736 2370736 2022-04-03 Steele Minnesota 27147 10320 60
2367483 2367483 2022-04-02 Steele Minnesota 27147 10320 60
2364230 2364230 2022-04-01 Steele Minnesota 27147 10320 60
2360976 2360976 2022-03-31 Steele Minnesota 27147 10316 60
2357722 2357722 2022-03-30 Steele Minnesota 27147 10312 59
2354469 2354469 2022-03-29 Steele Minnesota 27147 10306 59
2351217 2351217 2022-03-28 Steele Minnesota 27147 10296 59
2347964 2347964 2022-03-27 Steele Minnesota 27147 10292 59
2344711 2344711 2022-03-26 Steele Minnesota 27147 10292 59
2341458 2341458 2022-03-25 Steele Minnesota 27147 10292 59
2338205 2338205 2022-03-24 Steele Minnesota 27147 10286 58
2334951 2334951 2022-03-23 Steele Minnesota 27147 10283 58
2331697 2331697 2022-03-22 Steele Minnesota 27147 10279 58
2328445 2328445 2022-03-21 Steele Minnesota 27147 10272 58
2325192 2325192 2022-03-20 Steele Minnesota 27147 10270 58
2321938 2321938 2022-03-19 Steele Minnesota 27147 10270 58
2318684 2318684 2022-03-18 Steele Minnesota 27147 10270 58
2315431 2315431 2022-03-17 Steele Minnesota 27147 10262 58
2312178 2312178 2022-03-16 Steele Minnesota 27147 10262 58
2308925 2308925 2022-03-15 Steele Minnesota 27147 10258 58
2305674 2305674 2022-03-14 Steele Minnesota 27147 10255 58
2302422 2302422 2022-03-13 Steele Minnesota 27147 10253 58
2299170 2299170 2022-03-12 Steele Minnesota 27147 10253 58
2295918 2295918 2022-03-11 Steele Minnesota 27147 10253 58
2292666 2292666 2022-03-10 Steele Minnesota 27147 10239 58
2289414 2289414 2022-03-09 Steele Minnesota 27147 10239 58
2286163 2286163 2022-03-08 Steele Minnesota 27147 10238 58
2282911 2282911 2022-03-07 Steele Minnesota 27147 10235 58
2279658 2279658 2022-03-06 Steele Minnesota 27147 10234 58
2276405 2276405 2022-03-05 Steele Minnesota 27147 10234 58
2273152 2273152 2022-03-04 Steele Minnesota 27147 10234 58
2269900 2269900 2022-03-03 Steele Minnesota 27147 10234 58
2266647 2266647 2022-03-02 Steele Minnesota 27147 10229 58
2263396 2263396 2022-03-01 Steele Minnesota 27147 10224 58
2260145 2260145 2022-02-28 Steele Minnesota 27147 10210 57
2256894 2256894 2022-02-27 Steele Minnesota 27147 10202 57
2253643 2253643 2022-02-26 Steele Minnesota 27147 10202 57
2250392 2250392 2022-02-25 Steele Minnesota 27147 10202 57
2247141 2247141 2022-02-24 Steele Minnesota 27147 10191 57
2243890 2243890 2022-02-23 Steele Minnesota 27147 10184 55
2240639 2240639 2022-02-22 Steele Minnesota 27147 10142 55
2237388 2237388 2022-02-21 Steele Minnesota 27147 10128 55
2234137 2234137 2022-02-20 Steele Minnesota 27147 10128 55
2230886 2230886 2022-02-19 Steele Minnesota 27147 10128 55
2227635 2227635 2022-02-18 Steele Minnesota 27147 10128 55
2224384 2224384 2022-02-17 Steele Minnesota 27147 10097 54
2221133 2221133 2022-02-16 Steele Minnesota 27147 10085 53
2217882 2217882 2022-02-15 Steele Minnesota 27147 10076 50
2214631 2214631 2022-02-14 Steele Minnesota 27147 10018 50
2211379 2211379 2022-02-13 Steele Minnesota 27147 9988 50
2208126 2208126 2022-02-12 Steele Minnesota 27147 9988 50
2204873 2204873 2022-02-11 Steele Minnesota 27147 9988 50
2201620 2201620 2022-02-10 Steele Minnesota 27147 9942 50
2198366 2198366 2022-02-09 Steele Minnesota 27147 9905 50
2195112 2195112 2022-02-08 Steele Minnesota 27147 9871 50
2191858 2191858 2022-02-07 Steele Minnesota 27147 9803 50
2188605 2188605 2022-02-06 Steele Minnesota 27147 9763 50
2185352 2185352 2022-02-05 Steele Minnesota 27147 9763 50
2182100 2182100 2022-02-04 Steele Minnesota 27147 9763 50
2178848 2178848 2022-02-03 Steele Minnesota 27147 9719 50

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