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

406 rows where deaths = 28 and state = "Idaho" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 25

state 1

  • Idaho · 406 ✖
Link rowid date ▲ county state fips cases deaths
2500147 2500147 2022-05-13 Caribou Idaho 16029 1495 28
2500154 2500154 2022-05-13 Fremont Idaho 16043 2158 28
2496889 2496889 2022-05-12 Caribou Idaho 16029 1495 28
2496896 2496896 2022-05-12 Fremont Idaho 16043 2158 28
2493631 2493631 2022-05-11 Caribou Idaho 16029 1495 28
2493638 2493638 2022-05-11 Fremont Idaho 16043 2158 28
2490373 2490373 2022-05-10 Caribou Idaho 16029 1495 28
2490380 2490380 2022-05-10 Fremont Idaho 16043 2157 28
2487116 2487116 2022-05-09 Caribou Idaho 16029 1495 28
2487123 2487123 2022-05-09 Fremont Idaho 16043 2157 28
2483858 2483858 2022-05-08 Caribou Idaho 16029 1494 28
2483865 2483865 2022-05-08 Fremont Idaho 16043 2157 28
2480600 2480600 2022-05-07 Caribou Idaho 16029 1494 28
2480607 2480607 2022-05-07 Fremont Idaho 16043 2157 28
2477342 2477342 2022-05-06 Caribou Idaho 16029 1494 28
2477349 2477349 2022-05-06 Fremont Idaho 16043 2157 28
2474084 2474084 2022-05-05 Caribou Idaho 16029 1493 28
2474091 2474091 2022-05-05 Fremont Idaho 16043 2157 28
2470827 2470827 2022-05-04 Caribou Idaho 16029 1492 28
2470834 2470834 2022-05-04 Fremont Idaho 16043 2157 28
2467571 2467571 2022-05-03 Caribou Idaho 16029 1492 28
2467578 2467578 2022-05-03 Fremont Idaho 16043 2157 28
2464316 2464316 2022-05-02 Caribou Idaho 16029 1492 28
2464323 2464323 2022-05-02 Fremont Idaho 16043 2157 28
2461060 2461060 2022-05-01 Caribou Idaho 16029 1492 28
2461067 2461067 2022-05-01 Fremont Idaho 16043 2157 28
2457804 2457804 2022-04-30 Caribou Idaho 16029 1492 28
2457811 2457811 2022-04-30 Fremont Idaho 16043 2157 28
2454548 2454548 2022-04-29 Caribou Idaho 16029 1492 28
2454555 2454555 2022-04-29 Fremont Idaho 16043 2157 28
2451292 2451292 2022-04-28 Caribou Idaho 16029 1492 28
2451299 2451299 2022-04-28 Fremont Idaho 16043 2156 28
2448036 2448036 2022-04-27 Caribou Idaho 16029 1490 28
2448043 2448043 2022-04-27 Fremont Idaho 16043 2156 28
2444780 2444780 2022-04-26 Caribou Idaho 16029 1490 28
2444787 2444787 2022-04-26 Fremont Idaho 16043 2156 28
2441524 2441524 2022-04-25 Caribou Idaho 16029 1490 28
2441531 2441531 2022-04-25 Fremont Idaho 16043 2156 28
2438268 2438268 2022-04-24 Caribou Idaho 16029 1490 28
2438275 2438275 2022-04-24 Fremont Idaho 16043 2156 28
2435012 2435012 2022-04-23 Caribou Idaho 16029 1490 28
2435019 2435019 2022-04-23 Fremont Idaho 16043 2156 28
2431756 2431756 2022-04-22 Caribou Idaho 16029 1490 28
2431763 2431763 2022-04-22 Fremont Idaho 16043 2156 28
2428500 2428500 2022-04-21 Caribou Idaho 16029 1490 28
2428507 2428507 2022-04-21 Fremont Idaho 16043 2156 28
2425244 2425244 2022-04-20 Caribou Idaho 16029 1490 28
2425251 2425251 2022-04-20 Fremont Idaho 16043 2156 28
2421988 2421988 2022-04-19 Caribou Idaho 16029 1490 28
2421995 2421995 2022-04-19 Fremont Idaho 16043 2156 28
2418732 2418732 2022-04-18 Caribou Idaho 16029 1490 28
2418739 2418739 2022-04-18 Fremont Idaho 16043 2156 28
2415476 2415476 2022-04-17 Caribou Idaho 16029 1490 28
2415483 2415483 2022-04-17 Fremont Idaho 16043 2156 28
2412220 2412220 2022-04-16 Caribou Idaho 16029 1490 28
2412227 2412227 2022-04-16 Fremont Idaho 16043 2156 28
2408964 2408964 2022-04-15 Caribou Idaho 16029 1490 28
2408971 2408971 2022-04-15 Fremont Idaho 16043 2156 28
2405708 2405708 2022-04-14 Caribou Idaho 16029 1489 28
2405715 2405715 2022-04-14 Fremont Idaho 16043 2156 28
2402460 2402460 2022-04-13 Fremont Idaho 16043 2156 28
2399205 2399205 2022-04-12 Fremont Idaho 16043 2156 28
2395950 2395950 2022-04-11 Fremont Idaho 16043 2156 28
2392694 2392694 2022-04-10 Fremont Idaho 16043 2156 28
2389438 2389438 2022-04-09 Fremont Idaho 16043 2156 28
2386183 2386183 2022-04-08 Fremont Idaho 16043 2156 28
2382928 2382928 2022-04-07 Fremont Idaho 16043 2156 28
2379673 2379673 2022-04-06 Fremont Idaho 16043 2155 28
2291853 2291853 2022-03-10 Lewis Idaho 16061 1126 28
2288601 2288601 2022-03-09 Lewis Idaho 16061 1126 28
2285350 2285350 2022-03-08 Lewis Idaho 16061 1126 28
2282098 2282098 2022-03-07 Lewis Idaho 16061 1126 28
2278845 2278845 2022-03-06 Lewis Idaho 16061 1126 28
2275592 2275592 2022-03-05 Lewis Idaho 16061 1126 28
2272339 2272339 2022-03-04 Lewis Idaho 16061 1126 28
2269087 2269087 2022-03-03 Lewis Idaho 16061 1125 28
2265834 2265834 2022-03-02 Lewis Idaho 16061 1125 28
2262583 2262583 2022-03-01 Lewis Idaho 16061 1125 28
2259332 2259332 2022-02-28 Lewis Idaho 16061 1124 28
2171506 2171506 2022-02-01 Blaine Idaho 16013 4889 28
2168253 2168253 2022-01-31 Blaine Idaho 16013 4865 28
2164998 2164998 2022-01-30 Blaine Idaho 16013 4826 28
2161743 2161743 2022-01-29 Blaine Idaho 16013 4826 28
2158487 2158487 2022-01-28 Blaine Idaho 16013 4759 28
2155234 2155234 2022-01-27 Blaine Idaho 16013 4759 28
2151981 2151981 2022-01-26 Blaine Idaho 16013 4734 28
2148729 2148729 2022-01-25 Blaine Idaho 16013 4692 28
2145477 2145477 2022-01-24 Blaine Idaho 16013 4660 28
2142222 2142222 2022-01-23 Blaine Idaho 16013 4628 28
2138967 2138967 2022-01-22 Blaine Idaho 16013 4628 28
2135711 2135711 2022-01-21 Blaine Idaho 16013 4579 28
2132459 2132459 2022-01-20 Blaine Idaho 16013 4548 28
2129206 2129206 2022-01-19 Blaine Idaho 16013 4516 28
2083693 2083693 2022-01-05 Clearwater Idaho 16035 1773 28
2080441 2080441 2022-01-04 Clearwater Idaho 16035 1763 28
2077189 2077189 2022-01-03 Clearwater Idaho 16035 1760 28
2073938 2073938 2022-01-02 Clearwater Idaho 16035 1760 28
2070687 2070687 2022-01-01 Clearwater Idaho 16035 1760 28
2067436 2067436 2021-12-31 Clearwater Idaho 16035 1760 28
2064185 2064185 2021-12-30 Clearwater Idaho 16035 1760 28

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