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

762 rows where county = "Walworth", fips = 46129 and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • South Dakota · 762 ✖

fips 1

  • 46129 · 762 ✖

county 1

  • Walworth · 762 ✖
Link rowid date ▲ county state fips cases deaths
2502108 2502108 2022-05-13 Walworth South Dakota 46129 1315 26
2498850 2498850 2022-05-12 Walworth South Dakota 46129 1315 26
2495592 2495592 2022-05-11 Walworth South Dakota 46129 1315 26
2492334 2492334 2022-05-10 Walworth South Dakota 46129 1315 26
2489076 2489076 2022-05-09 Walworth South Dakota 46129 1315 26
2485819 2485819 2022-05-08 Walworth South Dakota 46129 1315 26
2482561 2482561 2022-05-07 Walworth South Dakota 46129 1315 26
2479303 2479303 2022-05-06 Walworth South Dakota 46129 1315 26
2476045 2476045 2022-05-05 Walworth South Dakota 46129 1315 26
2472788 2472788 2022-05-04 Walworth South Dakota 46129 1315 26
2469532 2469532 2022-05-03 Walworth South Dakota 46129 1314 26
2466276 2466276 2022-05-02 Walworth South Dakota 46129 1314 26
2463021 2463021 2022-05-01 Walworth South Dakota 46129 1314 26
2459765 2459765 2022-04-30 Walworth South Dakota 46129 1314 26
2456509 2456509 2022-04-29 Walworth South Dakota 46129 1314 26
2453253 2453253 2022-04-28 Walworth South Dakota 46129 1314 26
2449997 2449997 2022-04-27 Walworth South Dakota 46129 1314 26
2446740 2446740 2022-04-26 Walworth South Dakota 46129 1313 26
2443485 2443485 2022-04-25 Walworth South Dakota 46129 1313 26
2440229 2440229 2022-04-24 Walworth South Dakota 46129 1313 26
2436973 2436973 2022-04-23 Walworth South Dakota 46129 1313 26
2433717 2433717 2022-04-22 Walworth South Dakota 46129 1313 26
2430461 2430461 2022-04-21 Walworth South Dakota 46129 1313 26
2427205 2427205 2022-04-20 Walworth South Dakota 46129 1313 26
2423949 2423949 2022-04-19 Walworth South Dakota 46129 1313 26
2420693 2420693 2022-04-18 Walworth South Dakota 46129 1313 26
2417437 2417437 2022-04-17 Walworth South Dakota 46129 1313 26
2414181 2414181 2022-04-16 Walworth South Dakota 46129 1313 26
2410925 2410925 2022-04-15 Walworth South Dakota 46129 1313 26
2407669 2407669 2022-04-14 Walworth South Dakota 46129 1313 26
2404413 2404413 2022-04-13 Walworth South Dakota 46129 1313 26
2401158 2401158 2022-04-12 Walworth South Dakota 46129 1312 26
2397903 2397903 2022-04-11 Walworth South Dakota 46129 1312 26
2394648 2394648 2022-04-10 Walworth South Dakota 46129 1312 26
2391392 2391392 2022-04-09 Walworth South Dakota 46129 1312 26
2388136 2388136 2022-04-08 Walworth South Dakota 46129 1312 26
2384881 2384881 2022-04-07 Walworth South Dakota 46129 1312 26
2381626 2381626 2022-04-06 Walworth South Dakota 46129 1312 26
2378371 2378371 2022-04-05 Walworth South Dakota 46129 1310 26
2375117 2375117 2022-04-04 Walworth South Dakota 46129 1310 26
2371865 2371865 2022-04-03 Walworth South Dakota 46129 1310 26
2368612 2368612 2022-04-02 Walworth South Dakota 46129 1310 26
2365359 2365359 2022-04-01 Walworth South Dakota 46129 1310 26
2362106 2362106 2022-03-31 Walworth South Dakota 46129 1310 26
2358852 2358852 2022-03-30 Walworth South Dakota 46129 1310 26
2355598 2355598 2022-03-29 Walworth South Dakota 46129 1309 26
2352345 2352345 2022-03-28 Walworth South Dakota 46129 1309 26
2349093 2349093 2022-03-27 Walworth South Dakota 46129 1309 26
2345840 2345840 2022-03-26 Walworth South Dakota 46129 1309 26
2342587 2342587 2022-03-25 Walworth South Dakota 46129 1309 26
2339334 2339334 2022-03-24 Walworth South Dakota 46129 1309 26
2336080 2336080 2022-03-23 Walworth South Dakota 46129 1309 26
2332826 2332826 2022-03-22 Walworth South Dakota 46129 1309 26
2329573 2329573 2022-03-21 Walworth South Dakota 46129 1309 26
2326321 2326321 2022-03-20 Walworth South Dakota 46129 1309 26
2323068 2323068 2022-03-19 Walworth South Dakota 46129 1309 26
2319814 2319814 2022-03-18 Walworth South Dakota 46129 1309 26
2316560 2316560 2022-03-17 Walworth South Dakota 46129 1309 25
2313307 2313307 2022-03-16 Walworth South Dakota 46129 1309 25
2310054 2310054 2022-03-15 Walworth South Dakota 46129 1309 25
2306801 2306801 2022-03-14 Walworth South Dakota 46129 1309 25
2303550 2303550 2022-03-13 Walworth South Dakota 46129 1309 25
2300298 2300298 2022-03-12 Walworth South Dakota 46129 1309 25
2297046 2297046 2022-03-11 Walworth South Dakota 46129 1309 25
2293794 2293794 2022-03-10 Walworth South Dakota 46129 1308 25
2290542 2290542 2022-03-09 Walworth South Dakota 46129 1307 25
2287290 2287290 2022-03-08 Walworth South Dakota 46129 1307 25
2284038 2284038 2022-03-07 Walworth South Dakota 46129 1306 25
2280786 2280786 2022-03-06 Walworth South Dakota 46129 1305 25
2277533 2277533 2022-03-05 Walworth South Dakota 46129 1305 25
2274280 2274280 2022-03-04 Walworth South Dakota 46129 1305 25
2271027 2271027 2022-03-03 Walworth South Dakota 46129 1303 25
2267775 2267775 2022-03-02 Walworth South Dakota 46129 1303 25
2264522 2264522 2022-03-01 Walworth South Dakota 46129 1301 25
2261272 2261272 2022-02-28 Walworth South Dakota 46129 1301 25
2258021 2258021 2022-02-27 Walworth South Dakota 46129 1301 25
2254770 2254770 2022-02-26 Walworth South Dakota 46129 1301 25
2251519 2251519 2022-02-25 Walworth South Dakota 46129 1301 25
2248268 2248268 2022-02-24 Walworth South Dakota 46129 1302 24
2245017 2245017 2022-02-23 Walworth South Dakota 46129 1301 24
2241766 2241766 2022-02-22 Walworth South Dakota 46129 1300 24
2238515 2238515 2022-02-21 Walworth South Dakota 46129 1300 23
2235264 2235264 2022-02-20 Walworth South Dakota 46129 1300 23
2232013 2232013 2022-02-19 Walworth South Dakota 46129 1300 23
2228762 2228762 2022-02-18 Walworth South Dakota 46129 1300 23
2225511 2225511 2022-02-17 Walworth South Dakota 46129 1298 23
2222260 2222260 2022-02-16 Walworth South Dakota 46129 1297 23
2219009 2219009 2022-02-15 Walworth South Dakota 46129 1295 23
2215758 2215758 2022-02-14 Walworth South Dakota 46129 1294 23
2212507 2212507 2022-02-13 Walworth South Dakota 46129 1291 23
2209254 2209254 2022-02-12 Walworth South Dakota 46129 1291 23
2206001 2206001 2022-02-11 Walworth South Dakota 46129 1291 23
2202748 2202748 2022-02-10 Walworth South Dakota 46129 1288 23
2199494 2199494 2022-02-09 Walworth South Dakota 46129 1284 23
2196240 2196240 2022-02-08 Walworth South Dakota 46129 1283 23
2192986 2192986 2022-02-07 Walworth South Dakota 46129 1282 23
2189732 2189732 2022-02-06 Walworth South Dakota 46129 1275 23
2186479 2186479 2022-02-05 Walworth South Dakota 46129 1275 23
2183227 2183227 2022-02-04 Walworth South Dakota 46129 1275 23
2179975 2179975 2022-02-03 Walworth South Dakota 46129 1270 23

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