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

675 rows where county = "Jones" and fips = 46075 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 46075 · 675 ✖

county 1

  • Jones · 675 ✖
Link rowid date ▲ county state fips cases deaths
2502081 2502081 2022-05-13 Jones South Dakota 46075 177 2
2498823 2498823 2022-05-12 Jones South Dakota 46075 177 2
2495565 2495565 2022-05-11 Jones South Dakota 46075 177 2
2492307 2492307 2022-05-10 Jones South Dakota 46075 177 2
2489049 2489049 2022-05-09 Jones South Dakota 46075 177 2
2485792 2485792 2022-05-08 Jones South Dakota 46075 177 2
2482534 2482534 2022-05-07 Jones South Dakota 46075 177 2
2479276 2479276 2022-05-06 Jones South Dakota 46075 177 2
2476018 2476018 2022-05-05 Jones South Dakota 46075 177 2
2472761 2472761 2022-05-04 Jones South Dakota 46075 177 2
2469505 2469505 2022-05-03 Jones South Dakota 46075 177 2
2466249 2466249 2022-05-02 Jones South Dakota 46075 177 2
2462994 2462994 2022-05-01 Jones South Dakota 46075 177 2
2459738 2459738 2022-04-30 Jones South Dakota 46075 177 2
2456482 2456482 2022-04-29 Jones South Dakota 46075 177 2
2453226 2453226 2022-04-28 Jones South Dakota 46075 177 2
2449970 2449970 2022-04-27 Jones South Dakota 46075 177 2
2446713 2446713 2022-04-26 Jones South Dakota 46075 177 2
2443458 2443458 2022-04-25 Jones South Dakota 46075 177 2
2440202 2440202 2022-04-24 Jones South Dakota 46075 177 2
2436946 2436946 2022-04-23 Jones South Dakota 46075 177 2
2433690 2433690 2022-04-22 Jones South Dakota 46075 177 2
2430434 2430434 2022-04-21 Jones South Dakota 46075 177 2
2427178 2427178 2022-04-20 Jones South Dakota 46075 177 2
2423922 2423922 2022-04-19 Jones South Dakota 46075 177 2
2420666 2420666 2022-04-18 Jones South Dakota 46075 177 2
2417410 2417410 2022-04-17 Jones South Dakota 46075 177 2
2414154 2414154 2022-04-16 Jones South Dakota 46075 177 2
2410898 2410898 2022-04-15 Jones South Dakota 46075 177 2
2407642 2407642 2022-04-14 Jones South Dakota 46075 177 2
2404386 2404386 2022-04-13 Jones South Dakota 46075 177 2
2401131 2401131 2022-04-12 Jones South Dakota 46075 177 2
2397876 2397876 2022-04-11 Jones South Dakota 46075 177 2
2394621 2394621 2022-04-10 Jones South Dakota 46075 177 2
2391365 2391365 2022-04-09 Jones South Dakota 46075 177 2
2388109 2388109 2022-04-08 Jones South Dakota 46075 177 2
2384854 2384854 2022-04-07 Jones South Dakota 46075 177 2
2381599 2381599 2022-04-06 Jones South Dakota 46075 177 2
2378344 2378344 2022-04-05 Jones South Dakota 46075 177 2
2375090 2375090 2022-04-04 Jones South Dakota 46075 177 2
2371838 2371838 2022-04-03 Jones South Dakota 46075 177 2
2368585 2368585 2022-04-02 Jones South Dakota 46075 177 2
2365332 2365332 2022-04-01 Jones South Dakota 46075 177 2
2362079 2362079 2022-03-31 Jones South Dakota 46075 177 2
2358825 2358825 2022-03-30 Jones South Dakota 46075 177 2
2355571 2355571 2022-03-29 Jones South Dakota 46075 177 2
2352318 2352318 2022-03-28 Jones South Dakota 46075 177 2
2349066 2349066 2022-03-27 Jones South Dakota 46075 177 2
2345813 2345813 2022-03-26 Jones South Dakota 46075 177 2
2342560 2342560 2022-03-25 Jones South Dakota 46075 177 2
2339307 2339307 2022-03-24 Jones South Dakota 46075 177 2
2336053 2336053 2022-03-23 Jones South Dakota 46075 177 2
2332799 2332799 2022-03-22 Jones South Dakota 46075 177 2
2329546 2329546 2022-03-21 Jones South Dakota 46075 177 2
2326294 2326294 2022-03-20 Jones South Dakota 46075 177 2
2323041 2323041 2022-03-19 Jones South Dakota 46075 177 2
2319787 2319787 2022-03-18 Jones South Dakota 46075 177 2
2316533 2316533 2022-03-17 Jones South Dakota 46075 177 2
2313280 2313280 2022-03-16 Jones South Dakota 46075 177 2
2310027 2310027 2022-03-15 Jones South Dakota 46075 177 2
2306774 2306774 2022-03-14 Jones South Dakota 46075 177 2
2303523 2303523 2022-03-13 Jones South Dakota 46075 177 2
2300271 2300271 2022-03-12 Jones South Dakota 46075 177 2
2297019 2297019 2022-03-11 Jones South Dakota 46075 177 2
2293767 2293767 2022-03-10 Jones South Dakota 46075 177 2
2290515 2290515 2022-03-09 Jones South Dakota 46075 177 2
2287263 2287263 2022-03-08 Jones South Dakota 46075 177 2
2284011 2284011 2022-03-07 Jones South Dakota 46075 177 2
2280759 2280759 2022-03-06 Jones South Dakota 46075 177 2
2277506 2277506 2022-03-05 Jones South Dakota 46075 177 2
2274253 2274253 2022-03-04 Jones South Dakota 46075 177 2
2271000 2271000 2022-03-03 Jones South Dakota 46075 177 2
2267748 2267748 2022-03-02 Jones South Dakota 46075 176 2
2264495 2264495 2022-03-01 Jones South Dakota 46075 176 2
2261245 2261245 2022-02-28 Jones South Dakota 46075 176 2
2257994 2257994 2022-02-27 Jones South Dakota 46075 176 2
2254743 2254743 2022-02-26 Jones South Dakota 46075 176 2
2251492 2251492 2022-02-25 Jones South Dakota 46075 176 2
2248241 2248241 2022-02-24 Jones South Dakota 46075 176 2
2244990 2244990 2022-02-23 Jones South Dakota 46075 176 2
2241739 2241739 2022-02-22 Jones South Dakota 46075 175 2
2238488 2238488 2022-02-21 Jones South Dakota 46075 174 2
2235237 2235237 2022-02-20 Jones South Dakota 46075 174 2
2231986 2231986 2022-02-19 Jones South Dakota 46075 174 2
2228735 2228735 2022-02-18 Jones South Dakota 46075 174 2
2225484 2225484 2022-02-17 Jones South Dakota 46075 174 2
2222233 2222233 2022-02-16 Jones South Dakota 46075 174 2
2218982 2218982 2022-02-15 Jones South Dakota 46075 174 2
2215731 2215731 2022-02-14 Jones South Dakota 46075 173 2
2212480 2212480 2022-02-13 Jones South Dakota 46075 173 2
2209227 2209227 2022-02-12 Jones South Dakota 46075 173 2
2205974 2205974 2022-02-11 Jones South Dakota 46075 173 2
2202721 2202721 2022-02-10 Jones South Dakota 46075 173 2
2199467 2199467 2022-02-09 Jones South Dakota 46075 173 2
2196213 2196213 2022-02-08 Jones South Dakota 46075 174 2
2192959 2192959 2022-02-07 Jones South Dakota 46075 173 2
2189705 2189705 2022-02-06 Jones South Dakota 46075 173 2
2186452 2186452 2022-02-05 Jones South Dakota 46075 173 2
2183200 2183200 2022-02-04 Jones South Dakota 46075 173 2
2179948 2179948 2022-02-03 Jones South Dakota 46075 172 2

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