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

787 rows where county = "Twin Falls" 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 · 787 ✖

fips 1

county 1

  • Twin Falls · 787 ✖
Link rowid date ▲ county state fips cases deaths
2500174 2500174 2022-05-13 Twin Falls Idaho 16083 24129 296
2496916 2496916 2022-05-12 Twin Falls Idaho 16083 24115 295
2493658 2493658 2022-05-11 Twin Falls Idaho 16083 24115 295
2490400 2490400 2022-05-10 Twin Falls Idaho 16083 24107 295
2487143 2487143 2022-05-09 Twin Falls Idaho 16083 24107 295
2483885 2483885 2022-05-08 Twin Falls Idaho 16083 24091 295
2480627 2480627 2022-05-07 Twin Falls Idaho 16083 24091 295
2477369 2477369 2022-05-06 Twin Falls Idaho 16083 24091 295
2474111 2474111 2022-05-05 Twin Falls Idaho 16083 24080 295
2470854 2470854 2022-05-04 Twin Falls Idaho 16083 24080 295
2467598 2467598 2022-05-03 Twin Falls Idaho 16083 24060 295
2464343 2464343 2022-05-02 Twin Falls Idaho 16083 24060 295
2461087 2461087 2022-05-01 Twin Falls Idaho 16083 24056 295
2457831 2457831 2022-04-30 Twin Falls Idaho 16083 24056 295
2454575 2454575 2022-04-29 Twin Falls Idaho 16083 24056 295
2451319 2451319 2022-04-28 Twin Falls Idaho 16083 24051 295
2448063 2448063 2022-04-27 Twin Falls Idaho 16083 24051 295
2444807 2444807 2022-04-26 Twin Falls Idaho 16083 24047 295
2441551 2441551 2022-04-25 Twin Falls Idaho 16083 24047 295
2438295 2438295 2022-04-24 Twin Falls Idaho 16083 24041 295
2435039 2435039 2022-04-23 Twin Falls Idaho 16083 24041 295
2431783 2431783 2022-04-22 Twin Falls Idaho 16083 24041 295
2428527 2428527 2022-04-21 Twin Falls Idaho 16083 24037 294
2425271 2425271 2022-04-20 Twin Falls Idaho 16083 24037 294
2422015 2422015 2022-04-19 Twin Falls Idaho 16083 24035 294
2418759 2418759 2022-04-18 Twin Falls Idaho 16083 24035 294
2415503 2415503 2022-04-17 Twin Falls Idaho 16083 24031 294
2412247 2412247 2022-04-16 Twin Falls Idaho 16083 24031 294
2408991 2408991 2022-04-15 Twin Falls Idaho 16083 24031 294
2405735 2405735 2022-04-14 Twin Falls Idaho 16083 24031 294
2402480 2402480 2022-04-13 Twin Falls Idaho 16083 24027 293
2399225 2399225 2022-04-12 Twin Falls Idaho 16083 24028 293
2395970 2395970 2022-04-11 Twin Falls Idaho 16083 24025 293
2392714 2392714 2022-04-10 Twin Falls Idaho 16083 24020 293
2389458 2389458 2022-04-09 Twin Falls Idaho 16083 24020 293
2386203 2386203 2022-04-08 Twin Falls Idaho 16083 24020 293
2382948 2382948 2022-04-07 Twin Falls Idaho 16083 24014 293
2379693 2379693 2022-04-06 Twin Falls Idaho 16083 24013 293
2376439 2376439 2022-04-05 Twin Falls Idaho 16083 24023 292
2373187 2373187 2022-04-04 Twin Falls Idaho 16083 24021 292
2369934 2369934 2022-04-03 Twin Falls Idaho 16083 24016 290
2366681 2366681 2022-04-02 Twin Falls Idaho 16083 24016 290
2363428 2363428 2022-04-01 Twin Falls Idaho 16083 24016 290
2360174 2360174 2022-03-31 Twin Falls Idaho 16083 24014 290
2356920 2356920 2022-03-30 Twin Falls Idaho 16083 24011 290
2353667 2353667 2022-03-29 Twin Falls Idaho 16083 24013 290
2350415 2350415 2022-03-28 Twin Falls Idaho 16083 24010 290
2347162 2347162 2022-03-27 Twin Falls Idaho 16083 24004 290
2343909 2343909 2022-03-26 Twin Falls Idaho 16083 24004 290
2340656 2340656 2022-03-25 Twin Falls Idaho 16083 24004 290
2337403 2337403 2022-03-24 Twin Falls Idaho 16083 23997 290
2334149 2334149 2022-03-23 Twin Falls Idaho 16083 23990 290
2330895 2330895 2022-03-22 Twin Falls Idaho 16083 23967 290
2327643 2327643 2022-03-21 Twin Falls Idaho 16083 23940 288
2324390 2324390 2022-03-20 Twin Falls Idaho 16083 23823 288
2321136 2321136 2022-03-19 Twin Falls Idaho 16083 23823 288
2317882 2317882 2022-03-18 Twin Falls Idaho 16083 23823 288
2314629 2314629 2022-03-17 Twin Falls Idaho 16083 23730 288
2311376 2311376 2022-03-16 Twin Falls Idaho 16083 23663 288
2308123 2308123 2022-03-15 Twin Falls Idaho 16083 23492 286
2304872 2304872 2022-03-14 Twin Falls Idaho 16083 23334 286
2301620 2301620 2022-03-13 Twin Falls Idaho 16083 22960 286
2298368 2298368 2022-03-12 Twin Falls Idaho 16083 22960 286
2295116 2295116 2022-03-11 Twin Falls Idaho 16083 22960 286
2291864 2291864 2022-03-10 Twin Falls Idaho 16083 22842 286
2288612 2288612 2022-03-09 Twin Falls Idaho 16083 22655 285
2285361 2285361 2022-03-08 Twin Falls Idaho 16083 22462 284
2282109 2282109 2022-03-07 Twin Falls Idaho 16083 22340 284
2278856 2278856 2022-03-06 Twin Falls Idaho 16083 21982 284
2275603 2275603 2022-03-05 Twin Falls Idaho 16083 21982 284
2272350 2272350 2022-03-04 Twin Falls Idaho 16083 21982 284
2269098 2269098 2022-03-03 Twin Falls Idaho 16083 21809 283
2265845 2265845 2022-03-02 Twin Falls Idaho 16083 21631 283
2262594 2262594 2022-03-01 Twin Falls Idaho 16083 21353 282
2259343 2259343 2022-02-28 Twin Falls Idaho 16083 21167 282
2256092 2256092 2022-02-27 Twin Falls Idaho 16083 20915 281
2252841 2252841 2022-02-26 Twin Falls Idaho 16083 20915 281
2249590 2249590 2022-02-25 Twin Falls Idaho 16083 20915 281
2246339 2246339 2022-02-24 Twin Falls Idaho 16083 20771 281
2243088 2243088 2022-02-23 Twin Falls Idaho 16083 20662 281
2239837 2239837 2022-02-22 Twin Falls Idaho 16083 20503 280
2236586 2236586 2022-02-21 Twin Falls Idaho 16083 20309 279
2233335 2233335 2022-02-20 Twin Falls Idaho 16083 20309 279
2230084 2230084 2022-02-19 Twin Falls Idaho 16083 20309 279
2226833 2226833 2022-02-18 Twin Falls Idaho 16083 20219 279
2223582 2223582 2022-02-17 Twin Falls Idaho 16083 20114 279
2220331 2220331 2022-02-16 Twin Falls Idaho 16083 20010 277
2217080 2217080 2022-02-15 Twin Falls Idaho 16083 19901 276
2213829 2213829 2022-02-14 Twin Falls Idaho 16083 19824 274
2210577 2210577 2022-02-13 Twin Falls Idaho 16083 19773 271
2207324 2207324 2022-02-12 Twin Falls Idaho 16083 19773 271
2204071 2204071 2022-02-11 Twin Falls Idaho 16083 19713 271
2200818 2200818 2022-02-10 Twin Falls Idaho 16083 19640 271
2197564 2197564 2022-02-09 Twin Falls Idaho 16083 19555 270
2194310 2194310 2022-02-08 Twin Falls Idaho 16083 19453 267
2191056 2191056 2022-02-07 Twin Falls Idaho 16083 19383 267
2187803 2187803 2022-02-06 Twin Falls Idaho 16083 19294 266
2184550 2184550 2022-02-05 Twin Falls Idaho 16083 19294 266
2181298 2181298 2022-02-04 Twin Falls Idaho 16083 19245 266
2178047 2178047 2022-02-03 Twin Falls Idaho 16083 19152 266

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