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 county = "Gooding" 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

county 1

  • Gooding · 773 ✖
Link rowid date ▲ county state fips cases deaths
2500156 2500156 2022-05-13 Gooding Idaho 16047 3297 55
2496898 2496898 2022-05-12 Gooding Idaho 16047 3297 55
2493640 2493640 2022-05-11 Gooding Idaho 16047 3297 55
2490382 2490382 2022-05-10 Gooding Idaho 16047 3294 55
2487125 2487125 2022-05-09 Gooding Idaho 16047 3294 55
2483867 2483867 2022-05-08 Gooding Idaho 16047 3293 54
2480609 2480609 2022-05-07 Gooding Idaho 16047 3293 54
2477351 2477351 2022-05-06 Gooding Idaho 16047 3293 54
2474093 2474093 2022-05-05 Gooding Idaho 16047 3291 54
2470836 2470836 2022-05-04 Gooding Idaho 16047 3291 54
2467580 2467580 2022-05-03 Gooding Idaho 16047 3287 54
2464325 2464325 2022-05-02 Gooding Idaho 16047 3287 54
2461069 2461069 2022-05-01 Gooding Idaho 16047 3288 54
2457813 2457813 2022-04-30 Gooding Idaho 16047 3288 54
2454557 2454557 2022-04-29 Gooding Idaho 16047 3288 54
2451301 2451301 2022-04-28 Gooding Idaho 16047 3286 54
2448045 2448045 2022-04-27 Gooding Idaho 16047 3286 54
2444789 2444789 2022-04-26 Gooding Idaho 16047 3286 54
2441533 2441533 2022-04-25 Gooding Idaho 16047 3286 54
2438277 2438277 2022-04-24 Gooding Idaho 16047 3286 54
2435021 2435021 2022-04-23 Gooding Idaho 16047 3286 54
2431765 2431765 2022-04-22 Gooding Idaho 16047 3286 54
2428509 2428509 2022-04-21 Gooding Idaho 16047 3287 54
2425253 2425253 2022-04-20 Gooding Idaho 16047 3287 54
2421997 2421997 2022-04-19 Gooding Idaho 16047 3287 54
2418741 2418741 2022-04-18 Gooding Idaho 16047 3287 54
2415485 2415485 2022-04-17 Gooding Idaho 16047 3287 54
2412229 2412229 2022-04-16 Gooding Idaho 16047 3287 54
2408973 2408973 2022-04-15 Gooding Idaho 16047 3287 54
2405717 2405717 2022-04-14 Gooding Idaho 16047 3287 54
2402462 2402462 2022-04-13 Gooding Idaho 16047 3280 54
2399207 2399207 2022-04-12 Gooding Idaho 16047 3280 54
2395952 2395952 2022-04-11 Gooding Idaho 16047 3281 54
2392696 2392696 2022-04-10 Gooding Idaho 16047 3279 54
2389440 2389440 2022-04-09 Gooding Idaho 16047 3279 54
2386185 2386185 2022-04-08 Gooding Idaho 16047 3279 54
2382930 2382930 2022-04-07 Gooding Idaho 16047 3279 54
2379675 2379675 2022-04-06 Gooding Idaho 16047 3279 54
2376421 2376421 2022-04-05 Gooding Idaho 16047 3280 54
2373169 2373169 2022-04-04 Gooding Idaho 16047 3280 54
2369916 2369916 2022-04-03 Gooding Idaho 16047 3280 54
2366663 2366663 2022-04-02 Gooding Idaho 16047 3280 54
2363410 2363410 2022-04-01 Gooding Idaho 16047 3280 54
2360156 2360156 2022-03-31 Gooding Idaho 16047 3282 54
2356902 2356902 2022-03-30 Gooding Idaho 16047 3281 54
2353649 2353649 2022-03-29 Gooding Idaho 16047 3281 54
2350397 2350397 2022-03-28 Gooding Idaho 16047 3281 54
2347144 2347144 2022-03-27 Gooding Idaho 16047 3282 54
2343891 2343891 2022-03-26 Gooding Idaho 16047 3282 54
2340638 2340638 2022-03-25 Gooding Idaho 16047 3282 54
2337385 2337385 2022-03-24 Gooding Idaho 16047 3277 54
2334131 2334131 2022-03-23 Gooding Idaho 16047 3276 54
2330877 2330877 2022-03-22 Gooding Idaho 16047 3275 54
2327625 2327625 2022-03-21 Gooding Idaho 16047 3274 54
2324372 2324372 2022-03-20 Gooding Idaho 16047 3255 54
2321118 2321118 2022-03-19 Gooding Idaho 16047 3255 54
2317864 2317864 2022-03-18 Gooding Idaho 16047 3255 54
2314611 2314611 2022-03-17 Gooding Idaho 16047 3239 54
2311358 2311358 2022-03-16 Gooding Idaho 16047 3233 54
2308105 2308105 2022-03-15 Gooding Idaho 16047 3215 54
2304854 2304854 2022-03-14 Gooding Idaho 16047 3203 54
2301602 2301602 2022-03-13 Gooding Idaho 16047 3175 54
2298350 2298350 2022-03-12 Gooding Idaho 16047 3175 54
2295098 2295098 2022-03-11 Gooding Idaho 16047 3175 54
2291846 2291846 2022-03-10 Gooding Idaho 16047 3166 54
2288594 2288594 2022-03-09 Gooding Idaho 16047 3154 54
2285343 2285343 2022-03-08 Gooding Idaho 16047 3134 54
2282091 2282091 2022-03-07 Gooding Idaho 16047 3122 54
2278838 2278838 2022-03-06 Gooding Idaho 16047 3088 53
2275585 2275585 2022-03-05 Gooding Idaho 16047 3088 53
2272332 2272332 2022-03-04 Gooding Idaho 16047 3088 53
2269080 2269080 2022-03-03 Gooding Idaho 16047 3069 53
2265827 2265827 2022-03-02 Gooding Idaho 16047 3044 53
2262576 2262576 2022-03-01 Gooding Idaho 16047 3023 53
2259325 2259325 2022-02-28 Gooding Idaho 16047 2996 52
2256074 2256074 2022-02-27 Gooding Idaho 16047 2977 52
2252823 2252823 2022-02-26 Gooding Idaho 16047 2977 52
2249572 2249572 2022-02-25 Gooding Idaho 16047 2977 52
2246321 2246321 2022-02-24 Gooding Idaho 16047 2957 52
2243070 2243070 2022-02-23 Gooding Idaho 16047 2880 52
2239819 2239819 2022-02-22 Gooding Idaho 16047 2851 52
2236568 2236568 2022-02-21 Gooding Idaho 16047 2834 52
2233317 2233317 2022-02-20 Gooding Idaho 16047 2834 52
2230066 2230066 2022-02-19 Gooding Idaho 16047 2834 52
2226815 2226815 2022-02-18 Gooding Idaho 16047 2814 52
2223564 2223564 2022-02-17 Gooding Idaho 16047 2785 51
2220313 2220313 2022-02-16 Gooding Idaho 16047 2752 51
2217062 2217062 2022-02-15 Gooding Idaho 16047 2726 51
2213811 2213811 2022-02-14 Gooding Idaho 16047 2715 50
2210559 2210559 2022-02-13 Gooding Idaho 16047 2709 50
2207306 2207306 2022-02-12 Gooding Idaho 16047 2709 50
2204053 2204053 2022-02-11 Gooding Idaho 16047 2701 50
2200800 2200800 2022-02-10 Gooding Idaho 16047 2689 48
2197546 2197546 2022-02-09 Gooding Idaho 16047 2675 48
2194292 2194292 2022-02-08 Gooding Idaho 16047 2667 48
2191038 2191038 2022-02-07 Gooding Idaho 16047 2662 48
2187785 2187785 2022-02-06 Gooding Idaho 16047 2653 48
2184532 2184532 2022-02-05 Gooding Idaho 16047 2653 48
2181280 2181280 2022-02-04 Gooding Idaho 16047 2642 48
2178029 2178029 2022-02-03 Gooding Idaho 16047 2637 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);