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

777 rows where county = "Washington" and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Texas · 777 ✖

fips 1

county 1

  • Washington · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502446 2502446 2022-05-13 Washington Texas 48477 9232 148
2499188 2499188 2022-05-12 Washington Texas 48477 9230 148
2495930 2495930 2022-05-11 Washington Texas 48477 9230 148
2492672 2492672 2022-05-10 Washington Texas 48477 9227 148
2489414 2489414 2022-05-09 Washington Texas 48477 9227 148
2486156 2486156 2022-05-08 Washington Texas 48477 9227 148
2482898 2482898 2022-05-07 Washington Texas 48477 9227 148
2479640 2479640 2022-05-06 Washington Texas 48477 9225 148
2476382 2476382 2022-05-05 Washington Texas 48477 9224 148
2473125 2473125 2022-05-04 Washington Texas 48477 9223 148
2469869 2469869 2022-05-03 Washington Texas 48477 9223 148
2466613 2466613 2022-05-02 Washington Texas 48477 9223 148
2463358 2463358 2022-05-01 Washington Texas 48477 9222 148
2460102 2460102 2022-04-30 Washington Texas 48477 9220 148
2456846 2456846 2022-04-29 Washington Texas 48477 9220 148
2453590 2453590 2022-04-28 Washington Texas 48477 9219 148
2450334 2450334 2022-04-27 Washington Texas 48477 9219 148
2447077 2447077 2022-04-26 Washington Texas 48477 9219 147
2443822 2443822 2022-04-25 Washington Texas 48477 9219 147
2440566 2440566 2022-04-24 Washington Texas 48477 9219 147
2437310 2437310 2022-04-23 Washington Texas 48477 9218 147
2434054 2434054 2022-04-22 Washington Texas 48477 9216 147
2430798 2430798 2022-04-21 Washington Texas 48477 9215 147
2427542 2427542 2022-04-20 Washington Texas 48477 9213 147
2424286 2424286 2022-04-19 Washington Texas 48477 9212 147
2421030 2421030 2022-04-18 Washington Texas 48477 9210 147
2417774 2417774 2022-04-17 Washington Texas 48477 9207 147
2414518 2414518 2022-04-16 Washington Texas 48477 9207 147
2411262 2411262 2022-04-15 Washington Texas 48477 9207 147
2408006 2408006 2022-04-14 Washington Texas 48477 9207 147
2404750 2404750 2022-04-13 Washington Texas 48477 9206 147
2401495 2401495 2022-04-12 Washington Texas 48477 9204 147
2398240 2398240 2022-04-11 Washington Texas 48477 9202 147
2394985 2394985 2022-04-10 Washington Texas 48477 9202 147
2391729 2391729 2022-04-09 Washington Texas 48477 9201 147
2388473 2388473 2022-04-08 Washington Texas 48477 9196 147
2385218 2385218 2022-04-07 Washington Texas 48477 9193 147
2381963 2381963 2022-04-06 Washington Texas 48477 9192 147
2378708 2378708 2022-04-05 Washington Texas 48477 9187 146
2375454 2375454 2022-04-04 Washington Texas 48477 9186 146
2372202 2372202 2022-04-03 Washington Texas 48477 9186 146
2368949 2368949 2022-04-02 Washington Texas 48477 9184 146
2365696 2365696 2022-04-01 Washington Texas 48477 9182 146
2362443 2362443 2022-03-31 Washington Texas 48477 9177 146
2359189 2359189 2022-03-30 Washington Texas 48477 9168 146
2355935 2355935 2022-03-29 Washington Texas 48477 9160 146
2352682 2352682 2022-03-28 Washington Texas 48477 9159 146
2349430 2349430 2022-03-27 Washington Texas 48477 9157 146
2346177 2346177 2022-03-26 Washington Texas 48477 9156 146
2342924 2342924 2022-03-25 Washington Texas 48477 9147 146
2339671 2339671 2022-03-24 Washington Texas 48477 9134 146
2336417 2336417 2022-03-23 Washington Texas 48477 9124 146
2333163 2333163 2022-03-22 Washington Texas 48477 9121 146
2329910 2329910 2022-03-21 Washington Texas 48477 9114 146
2326658 2326658 2022-03-20 Washington Texas 48477 9114 146
2323405 2323405 2022-03-19 Washington Texas 48477 9109 146
2320151 2320151 2022-03-18 Washington Texas 48477 9098 146
2316897 2316897 2022-03-17 Washington Texas 48477 9066 146
2313644 2313644 2022-03-16 Washington Texas 48477 9053 146
2310391 2310391 2022-03-15 Washington Texas 48477 9037 146
2307138 2307138 2022-03-14 Washington Texas 48477 9029 146
2303887 2303887 2022-03-13 Washington Texas 48477 9028 146
2300635 2300635 2022-03-12 Washington Texas 48477 9026 146
2297383 2297383 2022-03-11 Washington Texas 48477 9015 146
2294131 2294131 2022-03-10 Washington Texas 48477 9006 146
2290879 2290879 2022-03-09 Washington Texas 48477 8996 145
2287627 2287627 2022-03-08 Washington Texas 48477 8990 145
2284375 2284375 2022-03-07 Washington Texas 48477 8985 144
2281123 2281123 2022-03-06 Washington Texas 48477 8984 144
2277870 2277870 2022-03-05 Washington Texas 48477 8984 144
2274617 2274617 2022-03-04 Washington Texas 48477 8980 144
2271364 2271364 2022-03-03 Washington Texas 48477 8973 144
2268112 2268112 2022-03-02 Washington Texas 48477 8964 144
2264859 2264859 2022-03-01 Washington Texas 48477 8960 144
2261609 2261609 2022-02-28 Washington Texas 48477 8956 144
2258358 2258358 2022-02-27 Washington Texas 48477 8955 144
2255107 2255107 2022-02-26 Washington Texas 48477 8954 144
2251856 2251856 2022-02-25 Washington Texas 48477 8948 144
2248605 2248605 2022-02-24 Washington Texas 48477 8943 144
2245354 2245354 2022-02-23 Washington Texas 48477 8939 144
2242103 2242103 2022-02-22 Washington Texas 48477 8932 144
2238852 2238852 2022-02-21 Washington Texas 48477 8932 144
2235601 2235601 2022-02-20 Washington Texas 48477 8928 144
2232350 2232350 2022-02-19 Washington Texas 48477 8925 144
2229099 2229099 2022-02-18 Washington Texas 48477 8912 144
2225848 2225848 2022-02-17 Washington Texas 48477 8905 144
2222597 2222597 2022-02-16 Washington Texas 48477 8897 144
2219346 2219346 2022-02-15 Washington Texas 48477 8883 144
2216095 2216095 2022-02-14 Washington Texas 48477 8879 144
2212844 2212844 2022-02-13 Washington Texas 48477 8873 144
2209591 2209591 2022-02-12 Washington Texas 48477 8865 144
2206338 2206338 2022-02-11 Washington Texas 48477 8854 144
2203085 2203085 2022-02-10 Washington Texas 48477 8835 143
2199831 2199831 2022-02-09 Washington Texas 48477 8800 143
2196577 2196577 2022-02-08 Washington Texas 48477 8778 141
2193323 2193323 2022-02-07 Washington Texas 48477 8774 140
2190070 2190070 2022-02-06 Washington Texas 48477 8771 140
2186817 2186817 2022-02-05 Washington Texas 48477 8761 140
2183564 2183564 2022-02-04 Washington Texas 48477 8748 140
2180312 2180312 2022-02-03 Washington Texas 48477 8720 139

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