ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
700 rows where county = "Mellette", fips = 46095 and state = "South Dakota" 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 |
---|---|---|---|---|---|---|---|
2502091 | 2502091 | 2022-05-13 | Mellette | South Dakota | 46095 | 527 | 8 |
2498833 | 2498833 | 2022-05-12 | Mellette | South Dakota | 46095 | 527 | 8 |
2495575 | 2495575 | 2022-05-11 | Mellette | South Dakota | 46095 | 527 | 8 |
2492317 | 2492317 | 2022-05-10 | Mellette | South Dakota | 46095 | 527 | 8 |
2489059 | 2489059 | 2022-05-09 | Mellette | South Dakota | 46095 | 527 | 8 |
2485802 | 2485802 | 2022-05-08 | Mellette | South Dakota | 46095 | 527 | 8 |
2482544 | 2482544 | 2022-05-07 | Mellette | South Dakota | 46095 | 527 | 8 |
2479286 | 2479286 | 2022-05-06 | Mellette | South Dakota | 46095 | 527 | 8 |
2476028 | 2476028 | 2022-05-05 | Mellette | South Dakota | 46095 | 527 | 8 |
2472771 | 2472771 | 2022-05-04 | Mellette | South Dakota | 46095 | 527 | 8 |
2469515 | 2469515 | 2022-05-03 | Mellette | South Dakota | 46095 | 527 | 8 |
2466259 | 2466259 | 2022-05-02 | Mellette | South Dakota | 46095 | 527 | 8 |
2463004 | 2463004 | 2022-05-01 | Mellette | South Dakota | 46095 | 527 | 8 |
2459748 | 2459748 | 2022-04-30 | Mellette | South Dakota | 46095 | 527 | 8 |
2456492 | 2456492 | 2022-04-29 | Mellette | South Dakota | 46095 | 527 | 8 |
2453236 | 2453236 | 2022-04-28 | Mellette | South Dakota | 46095 | 527 | 8 |
2449980 | 2449980 | 2022-04-27 | Mellette | South Dakota | 46095 | 527 | 8 |
2446723 | 2446723 | 2022-04-26 | Mellette | South Dakota | 46095 | 527 | 8 |
2443468 | 2443468 | 2022-04-25 | Mellette | South Dakota | 46095 | 527 | 8 |
2440212 | 2440212 | 2022-04-24 | Mellette | South Dakota | 46095 | 527 | 8 |
2436956 | 2436956 | 2022-04-23 | Mellette | South Dakota | 46095 | 527 | 8 |
2433700 | 2433700 | 2022-04-22 | Mellette | South Dakota | 46095 | 527 | 8 |
2430444 | 2430444 | 2022-04-21 | Mellette | South Dakota | 46095 | 527 | 8 |
2427188 | 2427188 | 2022-04-20 | Mellette | South Dakota | 46095 | 527 | 8 |
2423932 | 2423932 | 2022-04-19 | Mellette | South Dakota | 46095 | 527 | 8 |
2420676 | 2420676 | 2022-04-18 | Mellette | South Dakota | 46095 | 527 | 8 |
2417420 | 2417420 | 2022-04-17 | Mellette | South Dakota | 46095 | 527 | 8 |
2414164 | 2414164 | 2022-04-16 | Mellette | South Dakota | 46095 | 527 | 8 |
2410908 | 2410908 | 2022-04-15 | Mellette | South Dakota | 46095 | 527 | 8 |
2407652 | 2407652 | 2022-04-14 | Mellette | South Dakota | 46095 | 527 | 8 |
2404396 | 2404396 | 2022-04-13 | Mellette | South Dakota | 46095 | 527 | 8 |
2401141 | 2401141 | 2022-04-12 | Mellette | South Dakota | 46095 | 527 | 8 |
2397886 | 2397886 | 2022-04-11 | Mellette | South Dakota | 46095 | 527 | 8 |
2394631 | 2394631 | 2022-04-10 | Mellette | South Dakota | 46095 | 527 | 8 |
2391375 | 2391375 | 2022-04-09 | Mellette | South Dakota | 46095 | 527 | 8 |
2388119 | 2388119 | 2022-04-08 | Mellette | South Dakota | 46095 | 527 | 8 |
2384864 | 2384864 | 2022-04-07 | Mellette | South Dakota | 46095 | 527 | 8 |
2381609 | 2381609 | 2022-04-06 | Mellette | South Dakota | 46095 | 527 | 8 |
2378354 | 2378354 | 2022-04-05 | Mellette | South Dakota | 46095 | 526 | 8 |
2375100 | 2375100 | 2022-04-04 | Mellette | South Dakota | 46095 | 526 | 8 |
2371848 | 2371848 | 2022-04-03 | Mellette | South Dakota | 46095 | 526 | 8 |
2368595 | 2368595 | 2022-04-02 | Mellette | South Dakota | 46095 | 526 | 8 |
2365342 | 2365342 | 2022-04-01 | Mellette | South Dakota | 46095 | 526 | 8 |
2362089 | 2362089 | 2022-03-31 | Mellette | South Dakota | 46095 | 526 | 8 |
2358835 | 2358835 | 2022-03-30 | Mellette | South Dakota | 46095 | 526 | 8 |
2355581 | 2355581 | 2022-03-29 | Mellette | South Dakota | 46095 | 525 | 8 |
2352328 | 2352328 | 2022-03-28 | Mellette | South Dakota | 46095 | 525 | 8 |
2349076 | 2349076 | 2022-03-27 | Mellette | South Dakota | 46095 | 525 | 8 |
2345823 | 2345823 | 2022-03-26 | Mellette | South Dakota | 46095 | 525 | 8 |
2342570 | 2342570 | 2022-03-25 | Mellette | South Dakota | 46095 | 525 | 8 |
2339317 | 2339317 | 2022-03-24 | Mellette | South Dakota | 46095 | 525 | 8 |
2336063 | 2336063 | 2022-03-23 | Mellette | South Dakota | 46095 | 525 | 8 |
2332809 | 2332809 | 2022-03-22 | Mellette | South Dakota | 46095 | 525 | 8 |
2329556 | 2329556 | 2022-03-21 | Mellette | South Dakota | 46095 | 525 | 8 |
2326304 | 2326304 | 2022-03-20 | Mellette | South Dakota | 46095 | 525 | 8 |
2323051 | 2323051 | 2022-03-19 | Mellette | South Dakota | 46095 | 525 | 8 |
2319797 | 2319797 | 2022-03-18 | Mellette | South Dakota | 46095 | 525 | 8 |
2316543 | 2316543 | 2022-03-17 | Mellette | South Dakota | 46095 | 525 | 8 |
2313290 | 2313290 | 2022-03-16 | Mellette | South Dakota | 46095 | 525 | 8 |
2310037 | 2310037 | 2022-03-15 | Mellette | South Dakota | 46095 | 525 | 8 |
2306784 | 2306784 | 2022-03-14 | Mellette | South Dakota | 46095 | 525 | 7 |
2303533 | 2303533 | 2022-03-13 | Mellette | South Dakota | 46095 | 524 | 7 |
2300281 | 2300281 | 2022-03-12 | Mellette | South Dakota | 46095 | 524 | 7 |
2297029 | 2297029 | 2022-03-11 | Mellette | South Dakota | 46095 | 524 | 7 |
2293777 | 2293777 | 2022-03-10 | Mellette | South Dakota | 46095 | 524 | 7 |
2290525 | 2290525 | 2022-03-09 | Mellette | South Dakota | 46095 | 524 | 7 |
2287273 | 2287273 | 2022-03-08 | Mellette | South Dakota | 46095 | 524 | 7 |
2284021 | 2284021 | 2022-03-07 | Mellette | South Dakota | 46095 | 524 | 7 |
2280769 | 2280769 | 2022-03-06 | Mellette | South Dakota | 46095 | 524 | 7 |
2277516 | 2277516 | 2022-03-05 | Mellette | South Dakota | 46095 | 524 | 7 |
2274263 | 2274263 | 2022-03-04 | Mellette | South Dakota | 46095 | 524 | 7 |
2271010 | 2271010 | 2022-03-03 | Mellette | South Dakota | 46095 | 524 | 7 |
2267758 | 2267758 | 2022-03-02 | Mellette | South Dakota | 46095 | 523 | 7 |
2264505 | 2264505 | 2022-03-01 | Mellette | South Dakota | 46095 | 524 | 7 |
2261255 | 2261255 | 2022-02-28 | Mellette | South Dakota | 46095 | 525 | 7 |
2258004 | 2258004 | 2022-02-27 | Mellette | South Dakota | 46095 | 524 | 7 |
2254753 | 2254753 | 2022-02-26 | Mellette | South Dakota | 46095 | 524 | 7 |
2251502 | 2251502 | 2022-02-25 | Mellette | South Dakota | 46095 | 524 | 7 |
2248251 | 2248251 | 2022-02-24 | Mellette | South Dakota | 46095 | 523 | 7 |
2245000 | 2245000 | 2022-02-23 | Mellette | South Dakota | 46095 | 524 | 7 |
2241749 | 2241749 | 2022-02-22 | Mellette | South Dakota | 46095 | 522 | 6 |
2238498 | 2238498 | 2022-02-21 | Mellette | South Dakota | 46095 | 522 | 6 |
2235247 | 2235247 | 2022-02-20 | Mellette | South Dakota | 46095 | 522 | 6 |
2231996 | 2231996 | 2022-02-19 | Mellette | South Dakota | 46095 | 522 | 6 |
2228745 | 2228745 | 2022-02-18 | Mellette | South Dakota | 46095 | 522 | 6 |
2225494 | 2225494 | 2022-02-17 | Mellette | South Dakota | 46095 | 521 | 6 |
2222243 | 2222243 | 2022-02-16 | Mellette | South Dakota | 46095 | 515 | 6 |
2218992 | 2218992 | 2022-02-15 | Mellette | South Dakota | 46095 | 515 | 6 |
2215741 | 2215741 | 2022-02-14 | Mellette | South Dakota | 46095 | 512 | 6 |
2212490 | 2212490 | 2022-02-13 | Mellette | South Dakota | 46095 | 510 | 5 |
2209237 | 2209237 | 2022-02-12 | Mellette | South Dakota | 46095 | 510 | 5 |
2205984 | 2205984 | 2022-02-11 | Mellette | South Dakota | 46095 | 510 | 5 |
2202731 | 2202731 | 2022-02-10 | Mellette | South Dakota | 46095 | 510 | 5 |
2199477 | 2199477 | 2022-02-09 | Mellette | South Dakota | 46095 | 509 | 5 |
2196223 | 2196223 | 2022-02-08 | Mellette | South Dakota | 46095 | 510 | 5 |
2192969 | 2192969 | 2022-02-07 | Mellette | South Dakota | 46095 | 509 | 5 |
2189715 | 2189715 | 2022-02-06 | Mellette | South Dakota | 46095 | 509 | 5 |
2186462 | 2186462 | 2022-02-05 | Mellette | South Dakota | 46095 | 509 | 5 |
2183210 | 2183210 | 2022-02-04 | Mellette | South Dakota | 46095 | 509 | 5 |
2179958 | 2179958 | 2022-02-03 | Mellette | South Dakota | 46095 | 506 | 5 |
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);