ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where county = "Bennett", deaths = 14 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502047 | 2502047 | 2022-05-13 | Bennett | South Dakota | 46007 | 789 | 14 |
2498789 | 2498789 | 2022-05-12 | Bennett | South Dakota | 46007 | 789 | 14 |
2495531 | 2495531 | 2022-05-11 | Bennett | South Dakota | 46007 | 789 | 14 |
2492273 | 2492273 | 2022-05-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2489015 | 2489015 | 2022-05-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2485758 | 2485758 | 2022-05-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2482500 | 2482500 | 2022-05-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2479242 | 2479242 | 2022-05-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2475984 | 2475984 | 2022-05-05 | Bennett | South Dakota | 46007 | 788 | 14 |
2472727 | 2472727 | 2022-05-04 | Bennett | South Dakota | 46007 | 788 | 14 |
2469471 | 2469471 | 2022-05-03 | Bennett | South Dakota | 46007 | 788 | 14 |
2466215 | 2466215 | 2022-05-02 | Bennett | South Dakota | 46007 | 788 | 14 |
2462960 | 2462960 | 2022-05-01 | Bennett | South Dakota | 46007 | 788 | 14 |
2459704 | 2459704 | 2022-04-30 | Bennett | South Dakota | 46007 | 788 | 14 |
2456448 | 2456448 | 2022-04-29 | Bennett | South Dakota | 46007 | 788 | 14 |
2453192 | 2453192 | 2022-04-28 | Bennett | South Dakota | 46007 | 788 | 14 |
2449936 | 2449936 | 2022-04-27 | Bennett | South Dakota | 46007 | 788 | 14 |
2446679 | 2446679 | 2022-04-26 | Bennett | South Dakota | 46007 | 788 | 14 |
2443424 | 2443424 | 2022-04-25 | Bennett | South Dakota | 46007 | 788 | 14 |
2440168 | 2440168 | 2022-04-24 | Bennett | South Dakota | 46007 | 788 | 14 |
2436912 | 2436912 | 2022-04-23 | Bennett | South Dakota | 46007 | 788 | 14 |
2433656 | 2433656 | 2022-04-22 | Bennett | South Dakota | 46007 | 788 | 14 |
2430400 | 2430400 | 2022-04-21 | Bennett | South Dakota | 46007 | 788 | 14 |
2427144 | 2427144 | 2022-04-20 | Bennett | South Dakota | 46007 | 788 | 14 |
2423888 | 2423888 | 2022-04-19 | Bennett | South Dakota | 46007 | 788 | 14 |
2420632 | 2420632 | 2022-04-18 | Bennett | South Dakota | 46007 | 788 | 14 |
2417376 | 2417376 | 2022-04-17 | Bennett | South Dakota | 46007 | 788 | 14 |
2414120 | 2414120 | 2022-04-16 | Bennett | South Dakota | 46007 | 788 | 14 |
2410864 | 2410864 | 2022-04-15 | Bennett | South Dakota | 46007 | 788 | 14 |
2407608 | 2407608 | 2022-04-14 | Bennett | South Dakota | 46007 | 788 | 14 |
2404352 | 2404352 | 2022-04-13 | Bennett | South Dakota | 46007 | 788 | 14 |
2401097 | 2401097 | 2022-04-12 | Bennett | South Dakota | 46007 | 788 | 14 |
2397842 | 2397842 | 2022-04-11 | Bennett | South Dakota | 46007 | 788 | 14 |
2394587 | 2394587 | 2022-04-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2391331 | 2391331 | 2022-04-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2388075 | 2388075 | 2022-04-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2384820 | 2384820 | 2022-04-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2381565 | 2381565 | 2022-04-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2378310 | 2378310 | 2022-04-05 | Bennett | South Dakota | 46007 | 787 | 14 |
2375056 | 2375056 | 2022-04-04 | Bennett | South Dakota | 46007 | 787 | 14 |
2371804 | 2371804 | 2022-04-03 | Bennett | South Dakota | 46007 | 787 | 14 |
2368551 | 2368551 | 2022-04-02 | Bennett | South Dakota | 46007 | 787 | 14 |
2365298 | 2365298 | 2022-04-01 | Bennett | South Dakota | 46007 | 787 | 14 |
2362045 | 2362045 | 2022-03-31 | Bennett | South Dakota | 46007 | 787 | 14 |
2358791 | 2358791 | 2022-03-30 | Bennett | South Dakota | 46007 | 787 | 14 |
2355537 | 2355537 | 2022-03-29 | Bennett | South Dakota | 46007 | 786 | 14 |
2352284 | 2352284 | 2022-03-28 | Bennett | South Dakota | 46007 | 786 | 14 |
2349032 | 2349032 | 2022-03-27 | Bennett | South Dakota | 46007 | 786 | 14 |
2345779 | 2345779 | 2022-03-26 | Bennett | South Dakota | 46007 | 786 | 14 |
2342526 | 2342526 | 2022-03-25 | Bennett | South Dakota | 46007 | 786 | 14 |
2339273 | 2339273 | 2022-03-24 | Bennett | South Dakota | 46007 | 786 | 14 |
2336019 | 2336019 | 2022-03-23 | Bennett | South Dakota | 46007 | 786 | 14 |
2332765 | 2332765 | 2022-03-22 | Bennett | South Dakota | 46007 | 786 | 14 |
2329512 | 2329512 | 2022-03-21 | Bennett | South Dakota | 46007 | 786 | 14 |
2326260 | 2326260 | 2022-03-20 | Bennett | South Dakota | 46007 | 786 | 14 |
2323007 | 2323007 | 2022-03-19 | Bennett | South Dakota | 46007 | 786 | 14 |
2319753 | 2319753 | 2022-03-18 | Bennett | South Dakota | 46007 | 786 | 14 |
2316499 | 2316499 | 2022-03-17 | Bennett | South Dakota | 46007 | 786 | 14 |
2313246 | 2313246 | 2022-03-16 | Bennett | South Dakota | 46007 | 786 | 14 |
2309993 | 2309993 | 2022-03-15 | Bennett | South Dakota | 46007 | 786 | 14 |
2306740 | 2306740 | 2022-03-14 | Bennett | South Dakota | 46007 | 786 | 14 |
2303489 | 2303489 | 2022-03-13 | Bennett | South Dakota | 46007 | 785 | 14 |
2300237 | 2300237 | 2022-03-12 | Bennett | South Dakota | 46007 | 785 | 14 |
2296985 | 2296985 | 2022-03-11 | Bennett | South Dakota | 46007 | 785 | 14 |
2293733 | 2293733 | 2022-03-10 | Bennett | South Dakota | 46007 | 785 | 14 |
2290481 | 2290481 | 2022-03-09 | Bennett | South Dakota | 46007 | 785 | 14 |
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);