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

773 rows where fips = 16057 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 · 773 ✖

fips 1

  • 16057 · 773 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500161 2500161 2022-05-13 Latah Idaho 16057 6801 49
2496903 2496903 2022-05-12 Latah Idaho 16057 6787 48
2493645 2493645 2022-05-11 Latah Idaho 16057 6787 48
2490387 2490387 2022-05-10 Latah Idaho 16057 6775 48
2487130 2487130 2022-05-09 Latah Idaho 16057 6775 48
2483872 2483872 2022-05-08 Latah Idaho 16057 6764 48
2480614 2480614 2022-05-07 Latah Idaho 16057 6764 48
2477356 2477356 2022-05-06 Latah Idaho 16057 6764 48
2474098 2474098 2022-05-05 Latah Idaho 16057 6755 48
2470841 2470841 2022-05-04 Latah Idaho 16057 6755 48
2467585 2467585 2022-05-03 Latah Idaho 16057 6745 48
2464330 2464330 2022-05-02 Latah Idaho 16057 6745 48
2461074 2461074 2022-05-01 Latah Idaho 16057 6738 48
2457818 2457818 2022-04-30 Latah Idaho 16057 6738 48
2454562 2454562 2022-04-29 Latah Idaho 16057 6738 48
2451306 2451306 2022-04-28 Latah Idaho 16057 6722 48
2448050 2448050 2022-04-27 Latah Idaho 16057 6722 48
2444794 2444794 2022-04-26 Latah Idaho 16057 6717 48
2441538 2441538 2022-04-25 Latah Idaho 16057 6717 48
2438282 2438282 2022-04-24 Latah Idaho 16057 6716 48
2435026 2435026 2022-04-23 Latah Idaho 16057 6716 48
2431770 2431770 2022-04-22 Latah Idaho 16057 6716 48
2428514 2428514 2022-04-21 Latah Idaho 16057 6711 48
2425258 2425258 2022-04-20 Latah Idaho 16057 6711 48
2422002 2422002 2022-04-19 Latah Idaho 16057 6702 48
2418746 2418746 2022-04-18 Latah Idaho 16057 6702 48
2415490 2415490 2022-04-17 Latah Idaho 16057 6701 48
2412234 2412234 2022-04-16 Latah Idaho 16057 6701 48
2408978 2408978 2022-04-15 Latah Idaho 16057 6701 48
2405722 2405722 2022-04-14 Latah Idaho 16057 6700 48
2402467 2402467 2022-04-13 Latah Idaho 16057 6699 48
2399212 2399212 2022-04-12 Latah Idaho 16057 6699 48
2395957 2395957 2022-04-11 Latah Idaho 16057 6698 48
2392701 2392701 2022-04-10 Latah Idaho 16057 6697 48
2389445 2389445 2022-04-09 Latah Idaho 16057 6697 48
2386190 2386190 2022-04-08 Latah Idaho 16057 6697 48
2382935 2382935 2022-04-07 Latah Idaho 16057 6696 48
2379680 2379680 2022-04-06 Latah Idaho 16057 6695 48
2376426 2376426 2022-04-05 Latah Idaho 16057 6694 48
2373174 2373174 2022-04-04 Latah Idaho 16057 6694 48
2369921 2369921 2022-04-03 Latah Idaho 16057 6689 48
2366668 2366668 2022-04-02 Latah Idaho 16057 6689 48
2363415 2363415 2022-04-01 Latah Idaho 16057 6689 48
2360161 2360161 2022-03-31 Latah Idaho 16057 6689 48
2356907 2356907 2022-03-30 Latah Idaho 16057 6688 48
2353654 2353654 2022-03-29 Latah Idaho 16057 6688 48
2350402 2350402 2022-03-28 Latah Idaho 16057 6687 48
2347149 2347149 2022-03-27 Latah Idaho 16057 6687 48
2343896 2343896 2022-03-26 Latah Idaho 16057 6687 48
2340643 2340643 2022-03-25 Latah Idaho 16057 6687 48
2337390 2337390 2022-03-24 Latah Idaho 16057 6687 48
2334136 2334136 2022-03-23 Latah Idaho 16057 6685 48
2330882 2330882 2022-03-22 Latah Idaho 16057 6683 48
2327630 2327630 2022-03-21 Latah Idaho 16057 6681 48
2324377 2324377 2022-03-20 Latah Idaho 16057 6679 48
2321123 2321123 2022-03-19 Latah Idaho 16057 6679 48
2317869 2317869 2022-03-18 Latah Idaho 16057 6679 48
2314616 2314616 2022-03-17 Latah Idaho 16057 6677 48
2311363 2311363 2022-03-16 Latah Idaho 16057 6675 48
2308110 2308110 2022-03-15 Latah Idaho 16057 6674 48
2304859 2304859 2022-03-14 Latah Idaho 16057 6674 48
2301607 2301607 2022-03-13 Latah Idaho 16057 6673 48
2298355 2298355 2022-03-12 Latah Idaho 16057 6673 48
2295103 2295103 2022-03-11 Latah Idaho 16057 6673 48
2291851 2291851 2022-03-10 Latah Idaho 16057 6668 48
2288599 2288599 2022-03-09 Latah Idaho 16057 6665 48
2285348 2285348 2022-03-08 Latah Idaho 16057 6660 48
2282096 2282096 2022-03-07 Latah Idaho 16057 6658 48
2278843 2278843 2022-03-06 Latah Idaho 16057 6656 48
2275590 2275590 2022-03-05 Latah Idaho 16057 6656 48
2272337 2272337 2022-03-04 Latah Idaho 16057 6656 48
2269085 2269085 2022-03-03 Latah Idaho 16057 6650 48
2265832 2265832 2022-03-02 Latah Idaho 16057 6647 48
2262581 2262581 2022-03-01 Latah Idaho 16057 6646 48
2259330 2259330 2022-02-28 Latah Idaho 16057 6645 48
2256079 2256079 2022-02-27 Latah Idaho 16057 6638 48
2252828 2252828 2022-02-26 Latah Idaho 16057 6638 48
2249577 2249577 2022-02-25 Latah Idaho 16057 6638 48
2246326 2246326 2022-02-24 Latah Idaho 16057 6635 48
2243075 2243075 2022-02-23 Latah Idaho 16057 6625 48
2239824 2239824 2022-02-22 Latah Idaho 16057 6621 48
2236573 2236573 2022-02-21 Latah Idaho 16057 6607 48
2233322 2233322 2022-02-20 Latah Idaho 16057 6607 48
2230071 2230071 2022-02-19 Latah Idaho 16057 6607 48
2226820 2226820 2022-02-18 Latah Idaho 16057 6607 48
2223569 2223569 2022-02-17 Latah Idaho 16057 6599 48
2220318 2220318 2022-02-16 Latah Idaho 16057 6585 48
2217067 2217067 2022-02-15 Latah Idaho 16057 6557 48
2213816 2213816 2022-02-14 Latah Idaho 16057 6540 47
2210564 2210564 2022-02-13 Latah Idaho 16057 6522 47
2207311 2207311 2022-02-12 Latah Idaho 16057 6522 47
2204058 2204058 2022-02-11 Latah Idaho 16057 6522 47
2200805 2200805 2022-02-10 Latah Idaho 16057 6505 46
2197551 2197551 2022-02-09 Latah Idaho 16057 6486 46
2194297 2194297 2022-02-08 Latah Idaho 16057 6454 46
2191043 2191043 2022-02-07 Latah Idaho 16057 6444 46
2187790 2187790 2022-02-06 Latah Idaho 16057 6399 46
2184537 2184537 2022-02-05 Latah Idaho 16057 6399 46
2181285 2181285 2022-02-04 Latah Idaho 16057 6397 46
2178034 2178034 2022-02-03 Latah Idaho 16057 6371 45

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