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

775 rows where fips = 16053 and state = "Idaho" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Idaho · 775 ✖

fips 1

  • 16053 · 775 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500159 2500159 2022-05-13 Jerome Idaho 16053 6101 65
2496901 2496901 2022-05-12 Jerome Idaho 16053 6098 65
2493643 2493643 2022-05-11 Jerome Idaho 16053 6098 65
2490385 2490385 2022-05-10 Jerome Idaho 16053 6096 65
2487128 2487128 2022-05-09 Jerome Idaho 16053 6096 65
2483870 2483870 2022-05-08 Jerome Idaho 16053 6095 65
2480612 2480612 2022-05-07 Jerome Idaho 16053 6095 65
2477354 2477354 2022-05-06 Jerome Idaho 16053 6095 65
2474096 2474096 2022-05-05 Jerome Idaho 16053 6094 65
2470839 2470839 2022-05-04 Jerome Idaho 16053 6094 65
2467583 2467583 2022-05-03 Jerome Idaho 16053 6080 65
2464328 2464328 2022-05-02 Jerome Idaho 16053 6080 65
2461072 2461072 2022-05-01 Jerome Idaho 16053 6079 65
2457816 2457816 2022-04-30 Jerome Idaho 16053 6079 65
2454560 2454560 2022-04-29 Jerome Idaho 16053 6079 65
2451304 2451304 2022-04-28 Jerome Idaho 16053 6073 65
2448048 2448048 2022-04-27 Jerome Idaho 16053 6073 65
2444792 2444792 2022-04-26 Jerome Idaho 16053 6073 65
2441536 2441536 2022-04-25 Jerome Idaho 16053 6073 65
2438280 2438280 2022-04-24 Jerome Idaho 16053 6072 65
2435024 2435024 2022-04-23 Jerome Idaho 16053 6072 65
2431768 2431768 2022-04-22 Jerome Idaho 16053 6072 65
2428512 2428512 2022-04-21 Jerome Idaho 16053 6072 65
2425256 2425256 2022-04-20 Jerome Idaho 16053 6072 65
2422000 2422000 2022-04-19 Jerome Idaho 16053 6072 65
2418744 2418744 2022-04-18 Jerome Idaho 16053 6072 65
2415488 2415488 2022-04-17 Jerome Idaho 16053 6071 65
2412232 2412232 2022-04-16 Jerome Idaho 16053 6071 65
2408976 2408976 2022-04-15 Jerome Idaho 16053 6071 65
2405720 2405720 2022-04-14 Jerome Idaho 16053 6071 65
2402465 2402465 2022-04-13 Jerome Idaho 16053 6069 65
2399210 2399210 2022-04-12 Jerome Idaho 16053 6067 65
2395955 2395955 2022-04-11 Jerome Idaho 16053 6067 65
2392699 2392699 2022-04-10 Jerome Idaho 16053 6063 65
2389443 2389443 2022-04-09 Jerome Idaho 16053 6063 65
2386188 2386188 2022-04-08 Jerome Idaho 16053 6063 65
2382933 2382933 2022-04-07 Jerome Idaho 16053 6062 65
2379678 2379678 2022-04-06 Jerome Idaho 16053 6062 65
2376424 2376424 2022-04-05 Jerome Idaho 16053 6063 65
2373172 2373172 2022-04-04 Jerome Idaho 16053 6063 65
2369919 2369919 2022-04-03 Jerome Idaho 16053 6063 64
2366666 2366666 2022-04-02 Jerome Idaho 16053 6063 64
2363413 2363413 2022-04-01 Jerome Idaho 16053 6063 64
2360159 2360159 2022-03-31 Jerome Idaho 16053 6063 64
2356905 2356905 2022-03-30 Jerome Idaho 16053 6059 64
2353652 2353652 2022-03-29 Jerome Idaho 16053 6060 64
2350400 2350400 2022-03-28 Jerome Idaho 16053 6061 64
2347147 2347147 2022-03-27 Jerome Idaho 16053 6059 64
2343894 2343894 2022-03-26 Jerome Idaho 16053 6059 64
2340641 2340641 2022-03-25 Jerome Idaho 16053 6059 64
2337388 2337388 2022-03-24 Jerome Idaho 16053 6058 64
2334134 2334134 2022-03-23 Jerome Idaho 16053 6058 64
2330880 2330880 2022-03-22 Jerome Idaho 16053 6054 64
2327628 2327628 2022-03-21 Jerome Idaho 16053 6051 64
2324375 2324375 2022-03-20 Jerome Idaho 16053 6035 64
2321121 2321121 2022-03-19 Jerome Idaho 16053 6035 64
2317867 2317867 2022-03-18 Jerome Idaho 16053 6035 64
2314614 2314614 2022-03-17 Jerome Idaho 16053 5986 64
2311361 2311361 2022-03-16 Jerome Idaho 16053 5970 64
2308108 2308108 2022-03-15 Jerome Idaho 16053 5944 64
2304857 2304857 2022-03-14 Jerome Idaho 16053 5887 64
2301605 2301605 2022-03-13 Jerome Idaho 16053 5808 64
2298353 2298353 2022-03-12 Jerome Idaho 16053 5808 64
2295101 2295101 2022-03-11 Jerome Idaho 16053 5808 64
2291849 2291849 2022-03-10 Jerome Idaho 16053 5770 64
2288597 2288597 2022-03-09 Jerome Idaho 16053 5724 64
2285346 2285346 2022-03-08 Jerome Idaho 16053 5697 64
2282094 2282094 2022-03-07 Jerome Idaho 16053 5655 64
2278841 2278841 2022-03-06 Jerome Idaho 16053 5590 64
2275588 2275588 2022-03-05 Jerome Idaho 16053 5590 64
2272335 2272335 2022-03-04 Jerome Idaho 16053 5590 64
2269083 2269083 2022-03-03 Jerome Idaho 16053 5545 64
2265830 2265830 2022-03-02 Jerome Idaho 16053 5517 64
2262579 2262579 2022-03-01 Jerome Idaho 16053 5463 64
2259328 2259328 2022-02-28 Jerome Idaho 16053 5408 64
2256077 2256077 2022-02-27 Jerome Idaho 16053 5340 63
2252826 2252826 2022-02-26 Jerome Idaho 16053 5340 63
2249575 2249575 2022-02-25 Jerome Idaho 16053 5340 63
2246324 2246324 2022-02-24 Jerome Idaho 16053 5293 62
2243073 2243073 2022-02-23 Jerome Idaho 16053 5258 62
2239822 2239822 2022-02-22 Jerome Idaho 16053 5223 62
2236571 2236571 2022-02-21 Jerome Idaho 16053 5173 62
2233320 2233320 2022-02-20 Jerome Idaho 16053 5173 62
2230069 2230069 2022-02-19 Jerome Idaho 16053 5173 62
2226818 2226818 2022-02-18 Jerome Idaho 16053 5153 62
2223567 2223567 2022-02-17 Jerome Idaho 16053 5129 61
2220316 2220316 2022-02-16 Jerome Idaho 16053 5114 61
2217065 2217065 2022-02-15 Jerome Idaho 16053 5083 61
2213814 2213814 2022-02-14 Jerome Idaho 16053 5061 61
2210562 2210562 2022-02-13 Jerome Idaho 16053 5051 61
2207309 2207309 2022-02-12 Jerome Idaho 16053 5051 61
2204056 2204056 2022-02-11 Jerome Idaho 16053 5035 61
2200803 2200803 2022-02-10 Jerome Idaho 16053 5016 60
2197549 2197549 2022-02-09 Jerome Idaho 16053 4989 60
2194295 2194295 2022-02-08 Jerome Idaho 16053 4957 60
2191041 2191041 2022-02-07 Jerome Idaho 16053 4928 60
2187788 2187788 2022-02-06 Jerome Idaho 16053 4907 60
2184535 2184535 2022-02-05 Jerome Idaho 16053 4907 60
2181283 2181283 2022-02-04 Jerome Idaho 16053 4897 60
2178032 2178032 2022-02-03 Jerome Idaho 16053 4887 60

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