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

781 rows where fips = 16031 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 · 781 ✖

fips 1

  • 16031 · 781 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500148 2500148 2022-05-13 Cassia Idaho 16031 5032 52
2496890 2496890 2022-05-12 Cassia Idaho 16031 5032 52
2493632 2493632 2022-05-11 Cassia Idaho 16031 5032 52
2490374 2490374 2022-05-10 Cassia Idaho 16031 5033 52
2487117 2487117 2022-05-09 Cassia Idaho 16031 5033 52
2483859 2483859 2022-05-08 Cassia Idaho 16031 5032 52
2480601 2480601 2022-05-07 Cassia Idaho 16031 5032 52
2477343 2477343 2022-05-06 Cassia Idaho 16031 5032 52
2474085 2474085 2022-05-05 Cassia Idaho 16031 5032 52
2470828 2470828 2022-05-04 Cassia Idaho 16031 5032 52
2467572 2467572 2022-05-03 Cassia Idaho 16031 5031 52
2464317 2464317 2022-05-02 Cassia Idaho 16031 5031 52
2461061 2461061 2022-05-01 Cassia Idaho 16031 5030 52
2457805 2457805 2022-04-30 Cassia Idaho 16031 5030 52
2454549 2454549 2022-04-29 Cassia Idaho 16031 5030 52
2451293 2451293 2022-04-28 Cassia Idaho 16031 5030 52
2448037 2448037 2022-04-27 Cassia Idaho 16031 5030 52
2444781 2444781 2022-04-26 Cassia Idaho 16031 5031 52
2441525 2441525 2022-04-25 Cassia Idaho 16031 5031 52
2438269 2438269 2022-04-24 Cassia Idaho 16031 5031 52
2435013 2435013 2022-04-23 Cassia Idaho 16031 5031 52
2431757 2431757 2022-04-22 Cassia Idaho 16031 5031 52
2428501 2428501 2022-04-21 Cassia Idaho 16031 5029 52
2425245 2425245 2022-04-20 Cassia Idaho 16031 5029 52
2421989 2421989 2022-04-19 Cassia Idaho 16031 5029 52
2418733 2418733 2022-04-18 Cassia Idaho 16031 5029 52
2415477 2415477 2022-04-17 Cassia Idaho 16031 5029 52
2412221 2412221 2022-04-16 Cassia Idaho 16031 5029 52
2408965 2408965 2022-04-15 Cassia Idaho 16031 5029 52
2405709 2405709 2022-04-14 Cassia Idaho 16031 5028 52
2402454 2402454 2022-04-13 Cassia Idaho 16031 5028 52
2399199 2399199 2022-04-12 Cassia Idaho 16031 5028 52
2395944 2395944 2022-04-11 Cassia Idaho 16031 5028 52
2392688 2392688 2022-04-10 Cassia Idaho 16031 5028 52
2389432 2389432 2022-04-09 Cassia Idaho 16031 5028 52
2386177 2386177 2022-04-08 Cassia Idaho 16031 5028 52
2382922 2382922 2022-04-07 Cassia Idaho 16031 5024 52
2379667 2379667 2022-04-06 Cassia Idaho 16031 5024 52
2376413 2376413 2022-04-05 Cassia Idaho 16031 5027 52
2373161 2373161 2022-04-04 Cassia Idaho 16031 5026 52
2369908 2369908 2022-04-03 Cassia Idaho 16031 5026 52
2366655 2366655 2022-04-02 Cassia Idaho 16031 5026 52
2363402 2363402 2022-04-01 Cassia Idaho 16031 5026 52
2360148 2360148 2022-03-31 Cassia Idaho 16031 5026 52
2356894 2356894 2022-03-30 Cassia Idaho 16031 5026 52
2353641 2353641 2022-03-29 Cassia Idaho 16031 5036 52
2350389 2350389 2022-03-28 Cassia Idaho 16031 5036 52
2347136 2347136 2022-03-27 Cassia Idaho 16031 5037 52
2343883 2343883 2022-03-26 Cassia Idaho 16031 5037 52
2340630 2340630 2022-03-25 Cassia Idaho 16031 5037 52
2337377 2337377 2022-03-24 Cassia Idaho 16031 5033 52
2334123 2334123 2022-03-23 Cassia Idaho 16031 5033 52
2330869 2330869 2022-03-22 Cassia Idaho 16031 5031 52
2327617 2327617 2022-03-21 Cassia Idaho 16031 5032 52
2324364 2324364 2022-03-20 Cassia Idaho 16031 5013 52
2321110 2321110 2022-03-19 Cassia Idaho 16031 5013 52
2317856 2317856 2022-03-18 Cassia Idaho 16031 5013 52
2314603 2314603 2022-03-17 Cassia Idaho 16031 4997 52
2311350 2311350 2022-03-16 Cassia Idaho 16031 4997 52
2308097 2308097 2022-03-15 Cassia Idaho 16031 4981 52
2304846 2304846 2022-03-14 Cassia Idaho 16031 4961 52
2301594 2301594 2022-03-13 Cassia Idaho 16031 4929 52
2298342 2298342 2022-03-12 Cassia Idaho 16031 4929 52
2295090 2295090 2022-03-11 Cassia Idaho 16031 4929 52
2291838 2291838 2022-03-10 Cassia Idaho 16031 4904 52
2288586 2288586 2022-03-09 Cassia Idaho 16031 4892 52
2285335 2285335 2022-03-08 Cassia Idaho 16031 4879 52
2282083 2282083 2022-03-07 Cassia Idaho 16031 4855 52
2278830 2278830 2022-03-06 Cassia Idaho 16031 4826 52
2275577 2275577 2022-03-05 Cassia Idaho 16031 4826 52
2272324 2272324 2022-03-04 Cassia Idaho 16031 4826 52
2269072 2269072 2022-03-03 Cassia Idaho 16031 4815 52
2265819 2265819 2022-03-02 Cassia Idaho 16031 4784 52
2262568 2262568 2022-03-01 Cassia Idaho 16031 4760 52
2259317 2259317 2022-02-28 Cassia Idaho 16031 4734 52
2256066 2256066 2022-02-27 Cassia Idaho 16031 4702 52
2252815 2252815 2022-02-26 Cassia Idaho 16031 4702 52
2249564 2249564 2022-02-25 Cassia Idaho 16031 4702 52
2246313 2246313 2022-02-24 Cassia Idaho 16031 4676 52
2243062 2243062 2022-02-23 Cassia Idaho 16031 4653 52
2239811 2239811 2022-02-22 Cassia Idaho 16031 4625 53
2236560 2236560 2022-02-21 Cassia Idaho 16031 4602 53
2233309 2233309 2022-02-20 Cassia Idaho 16031 4602 53
2230058 2230058 2022-02-19 Cassia Idaho 16031 4602 53
2226807 2226807 2022-02-18 Cassia Idaho 16031 4598 53
2223556 2223556 2022-02-17 Cassia Idaho 16031 4583 52
2220305 2220305 2022-02-16 Cassia Idaho 16031 4565 51
2217054 2217054 2022-02-15 Cassia Idaho 16031 4535 51
2213803 2213803 2022-02-14 Cassia Idaho 16031 4520 51
2210551 2210551 2022-02-13 Cassia Idaho 16031 4508 51
2207298 2207298 2022-02-12 Cassia Idaho 16031 4508 51
2204045 2204045 2022-02-11 Cassia Idaho 16031 4498 51
2200792 2200792 2022-02-10 Cassia Idaho 16031 4486 52
2197538 2197538 2022-02-09 Cassia Idaho 16031 4476 52
2194284 2194284 2022-02-08 Cassia Idaho 16031 4441 49
2191030 2191030 2022-02-07 Cassia Idaho 16031 4412 49
2187777 2187777 2022-02-06 Cassia Idaho 16031 4382 48
2184524 2184524 2022-02-05 Cassia Idaho 16031 4382 48
2181272 2181272 2022-02-04 Cassia Idaho 16031 4355 48
2178021 2178021 2022-02-03 Cassia Idaho 16031 4336 48

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