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

779 rows where county = "Washington" and fips = 8121 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 8121 · 779 ✖

county 1

  • Washington · 779 ✖
Link rowid date ▲ county state fips cases deaths
2499881 2499881 2022-05-13 Washington Colorado 8121 1066 28
2496623 2496623 2022-05-12 Washington Colorado 8121 1065 28
2493365 2493365 2022-05-11 Washington Colorado 8121 1063 28
2490107 2490107 2022-05-10 Washington Colorado 8121 1063 28
2486850 2486850 2022-05-09 Washington Colorado 8121 1063 28
2483592 2483592 2022-05-08 Washington Colorado 8121 1063 28
2480334 2480334 2022-05-07 Washington Colorado 8121 1063 28
2477076 2477076 2022-05-06 Washington Colorado 8121 1063 28
2473818 2473818 2022-05-05 Washington Colorado 8121 1061 28
2470561 2470561 2022-05-04 Washington Colorado 8121 1061 28
2467305 2467305 2022-05-03 Washington Colorado 8121 1061 28
2464050 2464050 2022-05-02 Washington Colorado 8121 1061 27
2460794 2460794 2022-05-01 Washington Colorado 8121 1061 27
2457538 2457538 2022-04-30 Washington Colorado 8121 1061 27
2454282 2454282 2022-04-29 Washington Colorado 8121 1061 27
2451026 2451026 2022-04-28 Washington Colorado 8121 1061 27
2447770 2447770 2022-04-27 Washington Colorado 8121 1061 27
2444514 2444514 2022-04-26 Washington Colorado 8121 1061 27
2441258 2441258 2022-04-25 Washington Colorado 8121 1061 27
2438002 2438002 2022-04-24 Washington Colorado 8121 1061 27
2434746 2434746 2022-04-23 Washington Colorado 8121 1061 27
2431490 2431490 2022-04-22 Washington Colorado 8121 1061 27
2428234 2428234 2022-04-21 Washington Colorado 8121 1061 27
2424978 2424978 2022-04-20 Washington Colorado 8121 1061 27
2421722 2421722 2022-04-19 Washington Colorado 8121 1061 27
2418466 2418466 2022-04-18 Washington Colorado 8121 1060 27
2415210 2415210 2022-04-17 Washington Colorado 8121 1060 27
2411954 2411954 2022-04-16 Washington Colorado 8121 1060 27
2408698 2408698 2022-04-15 Washington Colorado 8121 1060 27
2405442 2405442 2022-04-14 Washington Colorado 8121 1060 27
2402187 2402187 2022-04-13 Washington Colorado 8121 1060 27
2398932 2398932 2022-04-12 Washington Colorado 8121 1060 27
2395677 2395677 2022-04-11 Washington Colorado 8121 1060 27
2392421 2392421 2022-04-10 Washington Colorado 8121 1058 27
2389165 2389165 2022-04-09 Washington Colorado 8121 1058 27
2385910 2385910 2022-04-08 Washington Colorado 8121 1058 27
2382655 2382655 2022-04-07 Washington Colorado 8121 1057 27
2379400 2379400 2022-04-06 Washington Colorado 8121 1055 27
2376146 2376146 2022-04-05 Washington Colorado 8121 1053 27
2372894 2372894 2022-04-04 Washington Colorado 8121 1054 27
2369641 2369641 2022-04-03 Washington Colorado 8121 1053 27
2366388 2366388 2022-04-02 Washington Colorado 8121 1053 27
2363135 2363135 2022-04-01 Washington Colorado 8121 1053 27
2359881 2359881 2022-03-31 Washington Colorado 8121 1052 27
2356627 2356627 2022-03-30 Washington Colorado 8121 1053 27
2353374 2353374 2022-03-29 Washington Colorado 8121 1052 27
2350122 2350122 2022-03-28 Washington Colorado 8121 1052 27
2346869 2346869 2022-03-27 Washington Colorado 8121 1052 27
2343616 2343616 2022-03-26 Washington Colorado 8121 1052 27
2340363 2340363 2022-03-25 Washington Colorado 8121 1052 27
2337110 2337110 2022-03-24 Washington Colorado 8121 1052 27
2333856 2333856 2022-03-23 Washington Colorado 8121 1051 27
2330602 2330602 2022-03-22 Washington Colorado 8121 1049 27
2327350 2327350 2022-03-21 Washington Colorado 8121 1047 27
2324097 2324097 2022-03-20 Washington Colorado 8121 1044 27
2320843 2320843 2022-03-19 Washington Colorado 8121 1044 27
2317589 2317589 2022-03-18 Washington Colorado 8121 1044 27
2314336 2314336 2022-03-17 Washington Colorado 8121 1044 27
2311083 2311083 2022-03-16 Washington Colorado 8121 1044 27
2307830 2307830 2022-03-15 Washington Colorado 8121 1041 27
2304579 2304579 2022-03-14 Washington Colorado 8121 1041 27
2301327 2301327 2022-03-13 Washington Colorado 8121 1041 27
2298075 2298075 2022-03-12 Washington Colorado 8121 1041 27
2294823 2294823 2022-03-11 Washington Colorado 8121 1041 27
2291571 2291571 2022-03-10 Washington Colorado 8121 1039 27
2288319 2288319 2022-03-09 Washington Colorado 8121 1038 27
2285068 2285068 2022-03-08 Washington Colorado 8121 1037 27
2281816 2281816 2022-03-07 Washington Colorado 8121 1037 27
2278563 2278563 2022-03-06 Washington Colorado 8121 1034 26
2275310 2275310 2022-03-05 Washington Colorado 8121 1034 26
2272057 2272057 2022-03-04 Washington Colorado 8121 1034 26
2268805 2268805 2022-03-03 Washington Colorado 8121 1033 26
2265552 2265552 2022-03-02 Washington Colorado 8121 1031 26
2262301 2262301 2022-03-01 Washington Colorado 8121 1031 26
2259050 2259050 2022-02-28 Washington Colorado 8121 1032 26
2255799 2255799 2022-02-27 Washington Colorado 8121 1028 26
2252548 2252548 2022-02-26 Washington Colorado 8121 1028 26
2249297 2249297 2022-02-25 Washington Colorado 8121 1028 26
2246046 2246046 2022-02-24 Washington Colorado 8121 1028 26
2242795 2242795 2022-02-23 Washington Colorado 8121 1026 26
2239544 2239544 2022-02-22 Washington Colorado 8121 1025 26
2236293 2236293 2022-02-21 Washington Colorado 8121 1026 26
2233042 2233042 2022-02-20 Washington Colorado 8121 1020 26
2229791 2229791 2022-02-19 Washington Colorado 8121 1020 26
2226540 2226540 2022-02-18 Washington Colorado 8121 1020 26
2223289 2223289 2022-02-17 Washington Colorado 8121 1021 26
2220038 2220038 2022-02-16 Washington Colorado 8121 1016 26
2216787 2216787 2022-02-15 Washington Colorado 8121 1012 26
2213536 2213536 2022-02-14 Washington Colorado 8121 1012 26
2210284 2210284 2022-02-13 Washington Colorado 8121 1011 26
2207031 2207031 2022-02-12 Washington Colorado 8121 1011 26
2203778 2203778 2022-02-11 Washington Colorado 8121 1011 26
2200525 2200525 2022-02-10 Washington Colorado 8121 1005 26
2197271 2197271 2022-02-09 Washington Colorado 8121 992 26
2194017 2194017 2022-02-08 Washington Colorado 8121 978 26
2190763 2190763 2022-02-07 Washington Colorado 8121 970 26
2187510 2187510 2022-02-06 Washington Colorado 8121 958 26
2184257 2184257 2022-02-05 Washington Colorado 8121 958 26
2181005 2181005 2022-02-04 Washington Colorado 8121 958 26
2177754 2177754 2022-02-03 Washington Colorado 8121 956 26

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