ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jerauld" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502080 | 2502080 | 2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2498822 | 2498822 | 2022-05-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2495564 | 2495564 | 2022-05-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2492306 | 2492306 | 2022-05-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2489048 | 2489048 | 2022-05-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2485791 | 2485791 | 2022-05-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2482533 | 2482533 | 2022-05-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2479275 | 2479275 | 2022-05-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
2476017 | 2476017 | 2022-05-05 | Jerauld | South Dakota | 46073 | 415 | 20 |
2472760 | 2472760 | 2022-05-04 | Jerauld | South Dakota | 46073 | 415 | 20 |
2469504 | 2469504 | 2022-05-03 | Jerauld | South Dakota | 46073 | 415 | 20 |
2466248 | 2466248 | 2022-05-02 | Jerauld | South Dakota | 46073 | 415 | 20 |
2462993 | 2462993 | 2022-05-01 | Jerauld | South Dakota | 46073 | 415 | 20 |
2459737 | 2459737 | 2022-04-30 | Jerauld | South Dakota | 46073 | 415 | 20 |
2456481 | 2456481 | 2022-04-29 | Jerauld | South Dakota | 46073 | 415 | 20 |
2453225 | 2453225 | 2022-04-28 | Jerauld | South Dakota | 46073 | 415 | 20 |
2449969 | 2449969 | 2022-04-27 | Jerauld | South Dakota | 46073 | 415 | 20 |
2446712 | 2446712 | 2022-04-26 | Jerauld | South Dakota | 46073 | 415 | 20 |
2443457 | 2443457 | 2022-04-25 | Jerauld | South Dakota | 46073 | 415 | 20 |
2440201 | 2440201 | 2022-04-24 | Jerauld | South Dakota | 46073 | 415 | 20 |
2436945 | 2436945 | 2022-04-23 | Jerauld | South Dakota | 46073 | 415 | 20 |
2433689 | 2433689 | 2022-04-22 | Jerauld | South Dakota | 46073 | 415 | 20 |
2430433 | 2430433 | 2022-04-21 | Jerauld | South Dakota | 46073 | 415 | 20 |
2427177 | 2427177 | 2022-04-20 | Jerauld | South Dakota | 46073 | 415 | 20 |
2423921 | 2423921 | 2022-04-19 | Jerauld | South Dakota | 46073 | 415 | 20 |
2420665 | 2420665 | 2022-04-18 | Jerauld | South Dakota | 46073 | 415 | 20 |
2417409 | 2417409 | 2022-04-17 | Jerauld | South Dakota | 46073 | 415 | 20 |
2414153 | 2414153 | 2022-04-16 | Jerauld | South Dakota | 46073 | 415 | 20 |
2410897 | 2410897 | 2022-04-15 | Jerauld | South Dakota | 46073 | 415 | 20 |
2407641 | 2407641 | 2022-04-14 | Jerauld | South Dakota | 46073 | 415 | 20 |
2404385 | 2404385 | 2022-04-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2401130 | 2401130 | 2022-04-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2397875 | 2397875 | 2022-04-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2394620 | 2394620 | 2022-04-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2391364 | 2391364 | 2022-04-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2388108 | 2388108 | 2022-04-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2384853 | 2384853 | 2022-04-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2381598 | 2381598 | 2022-04-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
2378343 | 2378343 | 2022-04-05 | Jerauld | South Dakota | 46073 | 415 | 20 |
2375089 | 2375089 | 2022-04-04 | Jerauld | South Dakota | 46073 | 415 | 20 |
2371837 | 2371837 | 2022-04-03 | Jerauld | South Dakota | 46073 | 415 | 20 |
2368584 | 2368584 | 2022-04-02 | Jerauld | South Dakota | 46073 | 415 | 20 |
2365331 | 2365331 | 2022-04-01 | Jerauld | South Dakota | 46073 | 415 | 20 |
2362078 | 2362078 | 2022-03-31 | Jerauld | South Dakota | 46073 | 415 | 20 |
2358824 | 2358824 | 2022-03-30 | Jerauld | South Dakota | 46073 | 415 | 20 |
2355570 | 2355570 | 2022-03-29 | Jerauld | South Dakota | 46073 | 415 | 20 |
2352317 | 2352317 | 2022-03-28 | Jerauld | South Dakota | 46073 | 415 | 20 |
2349065 | 2349065 | 2022-03-27 | Jerauld | South Dakota | 46073 | 415 | 20 |
2345812 | 2345812 | 2022-03-26 | Jerauld | South Dakota | 46073 | 415 | 20 |
2342559 | 2342559 | 2022-03-25 | Jerauld | South Dakota | 46073 | 415 | 20 |
2339306 | 2339306 | 2022-03-24 | Jerauld | South Dakota | 46073 | 415 | 20 |
2336052 | 2336052 | 2022-03-23 | Jerauld | South Dakota | 46073 | 415 | 20 |
2332798 | 2332798 | 2022-03-22 | Jerauld | South Dakota | 46073 | 415 | 20 |
2329545 | 2329545 | 2022-03-21 | Jerauld | South Dakota | 46073 | 415 | 20 |
2326293 | 2326293 | 2022-03-20 | Jerauld | South Dakota | 46073 | 415 | 20 |
2323040 | 2323040 | 2022-03-19 | Jerauld | South Dakota | 46073 | 415 | 20 |
2319786 | 2319786 | 2022-03-18 | Jerauld | South Dakota | 46073 | 415 | 20 |
2316532 | 2316532 | 2022-03-17 | Jerauld | South Dakota | 46073 | 414 | 20 |
2313279 | 2313279 | 2022-03-16 | Jerauld | South Dakota | 46073 | 414 | 20 |
2310026 | 2310026 | 2022-03-15 | Jerauld | South Dakota | 46073 | 414 | 20 |
2306773 | 2306773 | 2022-03-14 | Jerauld | South Dakota | 46073 | 414 | 20 |
2303522 | 2303522 | 2022-03-13 | Jerauld | South Dakota | 46073 | 414 | 20 |
2300270 | 2300270 | 2022-03-12 | Jerauld | South Dakota | 46073 | 414 | 20 |
2297018 | 2297018 | 2022-03-11 | Jerauld | South Dakota | 46073 | 414 | 20 |
2293766 | 2293766 | 2022-03-10 | Jerauld | South Dakota | 46073 | 413 | 20 |
2290514 | 2290514 | 2022-03-09 | Jerauld | South Dakota | 46073 | 412 | 20 |
2287262 | 2287262 | 2022-03-08 | Jerauld | South Dakota | 46073 | 412 | 20 |
2284010 | 2284010 | 2022-03-07 | Jerauld | South Dakota | 46073 | 412 | 20 |
2280758 | 2280758 | 2022-03-06 | Jerauld | South Dakota | 46073 | 412 | 20 |
2277505 | 2277505 | 2022-03-05 | Jerauld | South Dakota | 46073 | 412 | 20 |
2274252 | 2274252 | 2022-03-04 | Jerauld | South Dakota | 46073 | 412 | 20 |
2270999 | 2270999 | 2022-03-03 | Jerauld | South Dakota | 46073 | 411 | 20 |
2267747 | 2267747 | 2022-03-02 | Jerauld | South Dakota | 46073 | 411 | 20 |
2264494 | 2264494 | 2022-03-01 | Jerauld | South Dakota | 46073 | 411 | 20 |
2261244 | 2261244 | 2022-02-28 | Jerauld | South Dakota | 46073 | 410 | 20 |
2257993 | 2257993 | 2022-02-27 | Jerauld | South Dakota | 46073 | 409 | 20 |
2254742 | 2254742 | 2022-02-26 | Jerauld | South Dakota | 46073 | 409 | 20 |
2251491 | 2251491 | 2022-02-25 | Jerauld | South Dakota | 46073 | 409 | 20 |
2248240 | 2248240 | 2022-02-24 | Jerauld | South Dakota | 46073 | 409 | 20 |
2244989 | 2244989 | 2022-02-23 | Jerauld | South Dakota | 46073 | 408 | 20 |
2241738 | 2241738 | 2022-02-22 | Jerauld | South Dakota | 46073 | 406 | 20 |
2238487 | 2238487 | 2022-02-21 | Jerauld | South Dakota | 46073 | 406 | 20 |
2235236 | 2235236 | 2022-02-20 | Jerauld | South Dakota | 46073 | 406 | 20 |
2231985 | 2231985 | 2022-02-19 | Jerauld | South Dakota | 46073 | 406 | 20 |
2228734 | 2228734 | 2022-02-18 | Jerauld | South Dakota | 46073 | 406 | 20 |
2225483 | 2225483 | 2022-02-17 | Jerauld | South Dakota | 46073 | 406 | 20 |
2222232 | 2222232 | 2022-02-16 | Jerauld | South Dakota | 46073 | 404 | 20 |
2218981 | 2218981 | 2022-02-15 | Jerauld | South Dakota | 46073 | 404 | 20 |
2215730 | 2215730 | 2022-02-14 | Jerauld | South Dakota | 46073 | 404 | 20 |
2212479 | 2212479 | 2022-02-13 | Jerauld | South Dakota | 46073 | 402 | 19 |
2209226 | 2209226 | 2022-02-12 | Jerauld | South Dakota | 46073 | 402 | 19 |
2205973 | 2205973 | 2022-02-11 | Jerauld | South Dakota | 46073 | 402 | 19 |
2202720 | 2202720 | 2022-02-10 | Jerauld | South Dakota | 46073 | 401 | 19 |
2199466 | 2199466 | 2022-02-09 | Jerauld | South Dakota | 46073 | 401 | 19 |
2196212 | 2196212 | 2022-02-08 | Jerauld | South Dakota | 46073 | 399 | 19 |
2192958 | 2192958 | 2022-02-07 | Jerauld | South Dakota | 46073 | 399 | 19 |
2189704 | 2189704 | 2022-02-06 | Jerauld | South Dakota | 46073 | 396 | 19 |
2186451 | 2186451 | 2022-02-05 | Jerauld | South Dakota | 46073 | 396 | 19 |
2183199 | 2183199 | 2022-02-04 | Jerauld | South Dakota | 46073 | 396 | 19 |
2179947 | 2179947 | 2022-02-03 | Jerauld | South Dakota | 46073 | 395 | 19 |
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);