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 = 16039 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

  • 16039 · 775 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500152 2500152 2022-05-13 Elmore Idaho 16039 7264 70
2496894 2496894 2022-05-12 Elmore Idaho 16039 7257 70
2493636 2493636 2022-05-11 Elmore Idaho 16039 7257 70
2490378 2490378 2022-05-10 Elmore Idaho 16039 7252 70
2487121 2487121 2022-05-09 Elmore Idaho 16039 7252 70
2483863 2483863 2022-05-08 Elmore Idaho 16039 7247 70
2480605 2480605 2022-05-07 Elmore Idaho 16039 7247 70
2477347 2477347 2022-05-06 Elmore Idaho 16039 7247 70
2474089 2474089 2022-05-05 Elmore Idaho 16039 7232 70
2470832 2470832 2022-05-04 Elmore Idaho 16039 7232 70
2467576 2467576 2022-05-03 Elmore Idaho 16039 7225 70
2464321 2464321 2022-05-02 Elmore Idaho 16039 7225 70
2461065 2461065 2022-05-01 Elmore Idaho 16039 7220 70
2457809 2457809 2022-04-30 Elmore Idaho 16039 7220 70
2454553 2454553 2022-04-29 Elmore Idaho 16039 7220 70
2451297 2451297 2022-04-28 Elmore Idaho 16039 7215 70
2448041 2448041 2022-04-27 Elmore Idaho 16039 7215 70
2444785 2444785 2022-04-26 Elmore Idaho 16039 7211 70
2441529 2441529 2022-04-25 Elmore Idaho 16039 7211 70
2438273 2438273 2022-04-24 Elmore Idaho 16039 7211 70
2435017 2435017 2022-04-23 Elmore Idaho 16039 7211 70
2431761 2431761 2022-04-22 Elmore Idaho 16039 7211 70
2428505 2428505 2022-04-21 Elmore Idaho 16039 7206 70
2425249 2425249 2022-04-20 Elmore Idaho 16039 7206 70
2421993 2421993 2022-04-19 Elmore Idaho 16039 7204 70
2418737 2418737 2022-04-18 Elmore Idaho 16039 7204 70
2415481 2415481 2022-04-17 Elmore Idaho 16039 7198 70
2412225 2412225 2022-04-16 Elmore Idaho 16039 7198 70
2408969 2408969 2022-04-15 Elmore Idaho 16039 7198 70
2405713 2405713 2022-04-14 Elmore Idaho 16039 7198 70
2402458 2402458 2022-04-13 Elmore Idaho 16039 7194 70
2399203 2399203 2022-04-12 Elmore Idaho 16039 7193 70
2395948 2395948 2022-04-11 Elmore Idaho 16039 7191 70
2392692 2392692 2022-04-10 Elmore Idaho 16039 7189 70
2389436 2389436 2022-04-09 Elmore Idaho 16039 7189 70
2386181 2386181 2022-04-08 Elmore Idaho 16039 7189 70
2382926 2382926 2022-04-07 Elmore Idaho 16039 7187 70
2379671 2379671 2022-04-06 Elmore Idaho 16039 7187 70
2376417 2376417 2022-04-05 Elmore Idaho 16039 7187 70
2373165 2373165 2022-04-04 Elmore Idaho 16039 7185 70
2369912 2369912 2022-04-03 Elmore Idaho 16039 7184 70
2366659 2366659 2022-04-02 Elmore Idaho 16039 7184 70
2363406 2363406 2022-04-01 Elmore Idaho 16039 7184 70
2360152 2360152 2022-03-31 Elmore Idaho 16039 7182 70
2356898 2356898 2022-03-30 Elmore Idaho 16039 7180 70
2353645 2353645 2022-03-29 Elmore Idaho 16039 7178 70
2350393 2350393 2022-03-28 Elmore Idaho 16039 7173 70
2347140 2347140 2022-03-27 Elmore Idaho 16039 7172 70
2343887 2343887 2022-03-26 Elmore Idaho 16039 7172 70
2340634 2340634 2022-03-25 Elmore Idaho 16039 7172 70
2337381 2337381 2022-03-24 Elmore Idaho 16039 7160 70
2334127 2334127 2022-03-23 Elmore Idaho 16039 7158 70
2330873 2330873 2022-03-22 Elmore Idaho 16039 7159 70
2327621 2327621 2022-03-21 Elmore Idaho 16039 7157 70
2324368 2324368 2022-03-20 Elmore Idaho 16039 7143 70
2321114 2321114 2022-03-19 Elmore Idaho 16039 7143 70
2317860 2317860 2022-03-18 Elmore Idaho 16039 7143 70
2314607 2314607 2022-03-17 Elmore Idaho 16039 7140 70
2311354 2311354 2022-03-16 Elmore Idaho 16039 7140 70
2308101 2308101 2022-03-15 Elmore Idaho 16039 7133 70
2304850 2304850 2022-03-14 Elmore Idaho 16039 7126 70
2301598 2301598 2022-03-13 Elmore Idaho 16039 7061 70
2298346 2298346 2022-03-12 Elmore Idaho 16039 7061 70
2295094 2295094 2022-03-11 Elmore Idaho 16039 7061 70
2291842 2291842 2022-03-10 Elmore Idaho 16039 6978 69
2288590 2288590 2022-03-09 Elmore Idaho 16039 6945 69
2285339 2285339 2022-03-08 Elmore Idaho 16039 6927 69
2282087 2282087 2022-03-07 Elmore Idaho 16039 6889 69
2278834 2278834 2022-03-06 Elmore Idaho 16039 6837 69
2275581 2275581 2022-03-05 Elmore Idaho 16039 6837 69
2272328 2272328 2022-03-04 Elmore Idaho 16039 6837 69
2269076 2269076 2022-03-03 Elmore Idaho 16039 6812 67
2265823 2265823 2022-03-02 Elmore Idaho 16039 6789 67
2262572 2262572 2022-03-01 Elmore Idaho 16039 6773 66
2259321 2259321 2022-02-28 Elmore Idaho 16039 6734 65
2256070 2256070 2022-02-27 Elmore Idaho 16039 6660 64
2252819 2252819 2022-02-26 Elmore Idaho 16039 6660 64
2249568 2249568 2022-02-25 Elmore Idaho 16039 6660 64
2246317 2246317 2022-02-24 Elmore Idaho 16039 6598 63
2243066 2243066 2022-02-23 Elmore Idaho 16039 6494 63
2239815 2239815 2022-02-22 Elmore Idaho 16039 6396 63
2236564 2236564 2022-02-21 Elmore Idaho 16039 6320 63
2233313 2233313 2022-02-20 Elmore Idaho 16039 6320 63
2230062 2230062 2022-02-19 Elmore Idaho 16039 6320 63
2226811 2226811 2022-02-18 Elmore Idaho 16039 6261 63
2223560 2223560 2022-02-17 Elmore Idaho 16039 6192 62
2220309 2220309 2022-02-16 Elmore Idaho 16039 6122 61
2217058 2217058 2022-02-15 Elmore Idaho 16039 6047 61
2213807 2213807 2022-02-14 Elmore Idaho 16039 5979 61
2210555 2210555 2022-02-13 Elmore Idaho 16039 5940 58
2207302 2207302 2022-02-12 Elmore Idaho 16039 5940 58
2204049 2204049 2022-02-11 Elmore Idaho 16039 5898 58
2200796 2200796 2022-02-10 Elmore Idaho 16039 5867 58
2197542 2197542 2022-02-09 Elmore Idaho 16039 5785 58
2194288 2194288 2022-02-08 Elmore Idaho 16039 5697 58
2191034 2191034 2022-02-07 Elmore Idaho 16039 5643 58
2187781 2187781 2022-02-06 Elmore Idaho 16039 5602 58
2184528 2184528 2022-02-05 Elmore Idaho 16039 5602 58
2181276 2181276 2022-02-04 Elmore Idaho 16039 5560 58
2178025 2178025 2022-02-03 Elmore Idaho 16039 5475 58

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