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

798 rows where county = "Kittitas" and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 798 ✖

fips 1

county 1

  • Kittitas · 798 ✖
Link rowid date ▲ county state fips cases deaths
2502661 2502661 2022-05-13 Kittitas Washington 53037 8607 66
2499403 2499403 2022-05-12 Kittitas Washington 53037 8585 66
2496145 2496145 2022-05-11 Kittitas Washington 53037 8585 66
2492887 2492887 2022-05-10 Kittitas Washington 53037 8580 66
2489629 2489629 2022-05-09 Kittitas Washington 53037 8580 66
2486372 2486372 2022-05-08 Kittitas Washington 53037 8561 66
2483114 2483114 2022-05-07 Kittitas Washington 53037 8561 66
2479856 2479856 2022-05-06 Kittitas Washington 53037 8561 66
2476598 2476598 2022-05-05 Kittitas Washington 53037 8561 66
2473340 2473340 2022-05-04 Kittitas Washington 53037 8561 66
2470084 2470084 2022-05-03 Kittitas Washington 53037 8571 66
2466828 2466828 2022-05-02 Kittitas Washington 53037 8571 66
2463573 2463573 2022-05-01 Kittitas Washington 53037 8538 66
2460317 2460317 2022-04-30 Kittitas Washington 53037 8538 66
2457061 2457061 2022-04-29 Kittitas Washington 53037 8538 66
2453805 2453805 2022-04-28 Kittitas Washington 53037 8525 66
2450549 2450549 2022-04-27 Kittitas Washington 53037 8525 66
2447293 2447293 2022-04-26 Kittitas Washington 53037 8508 65
2444037 2444037 2022-04-25 Kittitas Washington 53037 8508 65
2440781 2440781 2022-04-24 Kittitas Washington 53037 8491 65
2437525 2437525 2022-04-23 Kittitas Washington 53037 8491 65
2434269 2434269 2022-04-22 Kittitas Washington 53037 8491 65
2431013 2431013 2022-04-21 Kittitas Washington 53037 8476 64
2427757 2427757 2022-04-20 Kittitas Washington 53037 8476 64
2424501 2424501 2022-04-19 Kittitas Washington 53037 8437 62
2421245 2421245 2022-04-18 Kittitas Washington 53037 8437 62
2417989 2417989 2022-04-17 Kittitas Washington 53037 8436 62
2414733 2414733 2022-04-16 Kittitas Washington 53037 8436 62
2411477 2411477 2022-04-15 Kittitas Washington 53037 8436 62
2408221 2408221 2022-04-14 Kittitas Washington 53037 8401 62
2404965 2404965 2022-04-13 Kittitas Washington 53037 8401 62
2401710 2401710 2022-04-12 Kittitas Washington 53037 8374 62
2398455 2398455 2022-04-11 Kittitas Washington 53037 8374 62
2395200 2395200 2022-04-10 Kittitas Washington 53037 8374 62
2391944 2391944 2022-04-09 Kittitas Washington 53037 8374 62
2388688 2388688 2022-04-08 Kittitas Washington 53037 8374 62
2385433 2385433 2022-04-07 Kittitas Washington 53037 8371 61
2382178 2382178 2022-04-06 Kittitas Washington 53037 8371 61
2378923 2378923 2022-04-05 Kittitas Washington 53037 8343 60
2375669 2375669 2022-04-04 Kittitas Washington 53037 8343 60
2372417 2372417 2022-04-03 Kittitas Washington 53037 8341 60
2369164 2369164 2022-04-02 Kittitas Washington 53037 8341 60
2365911 2365911 2022-04-01 Kittitas Washington 53037 8341 60
2362658 2362658 2022-03-31 Kittitas Washington 53037 8328 60
2359404 2359404 2022-03-30 Kittitas Washington 53037 8328 60
2356150 2356150 2022-03-29 Kittitas Washington 53037 8313 60
2352897 2352897 2022-03-28 Kittitas Washington 53037 8313 60
2349645 2349645 2022-03-27 Kittitas Washington 53037 8284 60
2346392 2346392 2022-03-26 Kittitas Washington 53037 8284 60
2343139 2343139 2022-03-25 Kittitas Washington 53037 8284 60
2339886 2339886 2022-03-24 Kittitas Washington 53037 8207 59
2336633 2336633 2022-03-23 Kittitas Washington 53037 8207 59
2333379 2333379 2022-03-22 Kittitas Washington 53037 8164 58
2330125 2330125 2022-03-21 Kittitas Washington 53037 8164 58
2326873 2326873 2022-03-20 Kittitas Washington 53037 8153 58
2323620 2323620 2022-03-19 Kittitas Washington 53037 8153 58
2320366 2320366 2022-03-18 Kittitas Washington 53037 8153 58
2317112 2317112 2022-03-17 Kittitas Washington 53037 8138 58
2313859 2313859 2022-03-16 Kittitas Washington 53037 8138 58
2310606 2310606 2022-03-15 Kittitas Washington 53037 8113 58
2307353 2307353 2022-03-14 Kittitas Washington 53037 8113 58
2304102 2304102 2022-03-13 Kittitas Washington 53037 8109 58
2300850 2300850 2022-03-12 Kittitas Washington 53037 8109 58
2297598 2297598 2022-03-11 Kittitas Washington 53037 8109 58
2294346 2294346 2022-03-10 Kittitas Washington 53037 8083 58
2291094 2291094 2022-03-09 Kittitas Washington 53037 8083 58
2287842 2287842 2022-03-08 Kittitas Washington 53037 8071 58
2284590 2284590 2022-03-07 Kittitas Washington 53037 8071 58
2281338 2281338 2022-03-06 Kittitas Washington 53037 8056 58
2278085 2278085 2022-03-05 Kittitas Washington 53037 8056 58
2274832 2274832 2022-03-04 Kittitas Washington 53037 8056 58
2271579 2271579 2022-03-03 Kittitas Washington 53037 8026 58
2268327 2268327 2022-03-02 Kittitas Washington 53037 8026 58
2265074 2265074 2022-03-01 Kittitas Washington 53037 7985 58
2261824 2261824 2022-02-28 Kittitas Washington 53037 7985 58
2258573 2258573 2022-02-27 Kittitas Washington 53037 7971 58
2255322 2255322 2022-02-26 Kittitas Washington 53037 7971 58
2252071 2252071 2022-02-25 Kittitas Washington 53037 7971 58
2248820 2248820 2022-02-24 Kittitas Washington 53037 7973 58
2245569 2245569 2022-02-23 Kittitas Washington 53037 7973 58
2242318 2242318 2022-02-22 Kittitas Washington 53037 8082 58
2239067 2239067 2022-02-21 Kittitas Washington 53037 8082 58
2235816 2235816 2022-02-20 Kittitas Washington 53037 8082 58
2232565 2232565 2022-02-19 Kittitas Washington 53037 8082 58
2229314 2229314 2022-02-18 Kittitas Washington 53037 8082 58
2226063 2226063 2022-02-17 Kittitas Washington 53037 8101 58
2222812 2222812 2022-02-16 Kittitas Washington 53037 8101 58
2219561 2219561 2022-02-15 Kittitas Washington 53037 8127 58
2216311 2216311 2022-02-14 Kittitas Washington 53037 8127 58
2213060 2213060 2022-02-13 Kittitas Washington 53037 8183 58
2209807 2209807 2022-02-12 Kittitas Washington 53037 8183 58
2206554 2206554 2022-02-11 Kittitas Washington 53037 8183 58
2203301 2203301 2022-02-10 Kittitas Washington 53037 7995 58
2200047 2200047 2022-02-09 Kittitas Washington 53037 7995 58
2196793 2196793 2022-02-08 Kittitas Washington 53037 8037 58
2193538 2193538 2022-02-07 Kittitas Washington 53037 8037 58
2190285 2190285 2022-02-06 Kittitas Washington 53037 8017 58
2187032 2187032 2022-02-05 Kittitas Washington 53037 8017 58
2183779 2183779 2022-02-04 Kittitas Washington 53037 8017 58
2180527 2180527 2022-02-03 Kittitas Washington 53037 7965 58

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