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 = "Comanche" 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 · 773 ✖

fips 1

county 1

  • Comanche · 773 ✖
Link rowid date ▲ county state fips cases deaths
2502253 2502253 2022-05-13 Comanche Texas 48093 3698 78
2498995 2498995 2022-05-12 Comanche Texas 48093 3698 78
2495737 2495737 2022-05-11 Comanche Texas 48093 3698 78
2492479 2492479 2022-05-10 Comanche Texas 48093 3697 78
2489221 2489221 2022-05-09 Comanche Texas 48093 3697 78
2485964 2485964 2022-05-08 Comanche Texas 48093 3697 78
2482706 2482706 2022-05-07 Comanche Texas 48093 3697 78
2479448 2479448 2022-05-06 Comanche Texas 48093 3697 78
2476190 2476190 2022-05-05 Comanche Texas 48093 3697 78
2472933 2472933 2022-05-04 Comanche Texas 48093 3695 78
2469677 2469677 2022-05-03 Comanche Texas 48093 3688 78
2466421 2466421 2022-05-02 Comanche Texas 48093 3688 78
2463166 2463166 2022-05-01 Comanche Texas 48093 3688 78
2459910 2459910 2022-04-30 Comanche Texas 48093 3688 78
2456654 2456654 2022-04-29 Comanche Texas 48093 3684 78
2453398 2453398 2022-04-28 Comanche Texas 48093 3676 78
2450142 2450142 2022-04-27 Comanche Texas 48093 3654 78
2446885 2446885 2022-04-26 Comanche Texas 48093 3640 78
2443630 2443630 2022-04-25 Comanche Texas 48093 3632 78
2440374 2440374 2022-04-24 Comanche Texas 48093 3632 78
2437118 2437118 2022-04-23 Comanche Texas 48093 3632 78
2433862 2433862 2022-04-22 Comanche Texas 48093 3631 78
2430606 2430606 2022-04-21 Comanche Texas 48093 3631 78
2427350 2427350 2022-04-20 Comanche Texas 48093 3629 78
2424094 2424094 2022-04-19 Comanche Texas 48093 3627 78
2420838 2420838 2022-04-18 Comanche Texas 48093 3615 78
2417582 2417582 2022-04-17 Comanche Texas 48093 3599 78
2414326 2414326 2022-04-16 Comanche Texas 48093 3599 78
2411070 2411070 2022-04-15 Comanche Texas 48093 3599 78
2407814 2407814 2022-04-14 Comanche Texas 48093 3599 78
2404558 2404558 2022-04-13 Comanche Texas 48093 3590 78
2401303 2401303 2022-04-12 Comanche Texas 48093 3579 78
2398048 2398048 2022-04-11 Comanche Texas 48093 3570 78
2394793 2394793 2022-04-10 Comanche Texas 48093 3570 78
2391537 2391537 2022-04-09 Comanche Texas 48093 3570 78
2388281 2388281 2022-04-08 Comanche Texas 48093 3553 78
2385026 2385026 2022-04-07 Comanche Texas 48093 3542 78
2381771 2381771 2022-04-06 Comanche Texas 48093 3540 78
2378516 2378516 2022-04-05 Comanche Texas 48093 3540 78
2375262 2375262 2022-04-04 Comanche Texas 48093 3514 78
2372010 2372010 2022-04-03 Comanche Texas 48093 3514 78
2368757 2368757 2022-04-02 Comanche Texas 48093 3514 78
2365504 2365504 2022-04-01 Comanche Texas 48093 3496 78
2362251 2362251 2022-03-31 Comanche Texas 48093 3475 78
2358997 2358997 2022-03-30 Comanche Texas 48093 3456 78
2355743 2355743 2022-03-29 Comanche Texas 48093 3440 78
2352490 2352490 2022-03-28 Comanche Texas 48093 3412 78
2349238 2349238 2022-03-27 Comanche Texas 48093 3412 78
2345985 2345985 2022-03-26 Comanche Texas 48093 3412 78
2342732 2342732 2022-03-25 Comanche Texas 48093 3393 78
2339479 2339479 2022-03-24 Comanche Texas 48093 3338 78
2336225 2336225 2022-03-23 Comanche Texas 48093 3293 78
2332971 2332971 2022-03-22 Comanche Texas 48093 3253 78
2329718 2329718 2022-03-21 Comanche Texas 48093 3213 78
2326466 2326466 2022-03-20 Comanche Texas 48093 3213 78
2323213 2323213 2022-03-19 Comanche Texas 48093 3213 78
2319959 2319959 2022-03-18 Comanche Texas 48093 3196 78
2316705 2316705 2022-03-17 Comanche Texas 48093 3172 78
2313452 2313452 2022-03-16 Comanche Texas 48093 3160 78
2310199 2310199 2022-03-15 Comanche Texas 48093 3160 78
2306946 2306946 2022-03-14 Comanche Texas 48093 3153 78
2303695 2303695 2022-03-13 Comanche Texas 48093 3153 78
2300443 2300443 2022-03-12 Comanche Texas 48093 3153 78
2297191 2297191 2022-03-11 Comanche Texas 48093 3137 78
2293939 2293939 2022-03-10 Comanche Texas 48093 3137 78
2290687 2290687 2022-03-09 Comanche Texas 48093 3135 78
2287435 2287435 2022-03-08 Comanche Texas 48093 3134 77
2284183 2284183 2022-03-07 Comanche Texas 48093 3134 77
2280931 2280931 2022-03-06 Comanche Texas 48093 3132 77
2277678 2277678 2022-03-05 Comanche Texas 48093 3132 77
2274425 2274425 2022-03-04 Comanche Texas 48093 3129 77
2271172 2271172 2022-03-03 Comanche Texas 48093 3129 77
2267920 2267920 2022-03-02 Comanche Texas 48093 3129 77
2264667 2264667 2022-03-01 Comanche Texas 48093 3129 76
2261417 2261417 2022-02-28 Comanche Texas 48093 3129 76
2258166 2258166 2022-02-27 Comanche Texas 48093 3129 76
2254915 2254915 2022-02-26 Comanche Texas 48093 3129 76
2251664 2251664 2022-02-25 Comanche Texas 48093 3126 76
2248413 2248413 2022-02-24 Comanche Texas 48093 3124 76
2245162 2245162 2022-02-23 Comanche Texas 48093 3122 76
2241911 2241911 2022-02-22 Comanche Texas 48093 3122 75
2238660 2238660 2022-02-21 Comanche Texas 48093 3122 75
2235409 2235409 2022-02-20 Comanche Texas 48093 3120 75
2232158 2232158 2022-02-19 Comanche Texas 48093 3120 75
2228907 2228907 2022-02-18 Comanche Texas 48093 3120 75
2225656 2225656 2022-02-17 Comanche Texas 48093 3119 75
2222405 2222405 2022-02-16 Comanche Texas 48093 3118 75
2219154 2219154 2022-02-15 Comanche Texas 48093 3118 75
2215903 2215903 2022-02-14 Comanche Texas 48093 3115 75
2212652 2212652 2022-02-13 Comanche Texas 48093 3113 75
2209399 2209399 2022-02-12 Comanche Texas 48093 3108 75
2206146 2206146 2022-02-11 Comanche Texas 48093 3104 75
2202893 2202893 2022-02-10 Comanche Texas 48093 3101 75
2199639 2199639 2022-02-09 Comanche Texas 48093 3095 75
2196385 2196385 2022-02-08 Comanche Texas 48093 3087 75
2193131 2193131 2022-02-07 Comanche Texas 48093 3085 75
2189877 2189877 2022-02-06 Comanche Texas 48093 3079 75
2186624 2186624 2022-02-05 Comanche Texas 48093 3079 75
2183372 2183372 2022-02-04 Comanche Texas 48093 3078 72
2180120 2180120 2022-02-03 Comanche Texas 48093 3073 72

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