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

786 rows where fips = 8025 and state = "Colorado" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Colorado · 786 ✖

fips 1

  • 8025 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499833 2499833 2022-05-13 Crowley Colorado 8025 3347 30
2496575 2496575 2022-05-12 Crowley Colorado 8025 3344 30
2493317 2493317 2022-05-11 Crowley Colorado 8025 3342 30
2490059 2490059 2022-05-10 Crowley Colorado 8025 3342 30
2486802 2486802 2022-05-09 Crowley Colorado 8025 3342 30
2483544 2483544 2022-05-08 Crowley Colorado 8025 3341 30
2480286 2480286 2022-05-07 Crowley Colorado 8025 3341 30
2477028 2477028 2022-05-06 Crowley Colorado 8025 3341 30
2473770 2473770 2022-05-05 Crowley Colorado 8025 3341 30
2470513 2470513 2022-05-04 Crowley Colorado 8025 3338 30
2467257 2467257 2022-05-03 Crowley Colorado 8025 3338 30
2464002 2464002 2022-05-02 Crowley Colorado 8025 3338 29
2460746 2460746 2022-05-01 Crowley Colorado 8025 3338 29
2457490 2457490 2022-04-30 Crowley Colorado 8025 3338 29
2454234 2454234 2022-04-29 Crowley Colorado 8025 3338 29
2450978 2450978 2022-04-28 Crowley Colorado 8025 3338 29
2447722 2447722 2022-04-27 Crowley Colorado 8025 3338 29
2444466 2444466 2022-04-26 Crowley Colorado 8025 3338 30
2441210 2441210 2022-04-25 Crowley Colorado 8025 3338 30
2437954 2437954 2022-04-24 Crowley Colorado 8025 3338 30
2434698 2434698 2022-04-23 Crowley Colorado 8025 3338 30
2431442 2431442 2022-04-22 Crowley Colorado 8025 3338 30
2428186 2428186 2022-04-21 Crowley Colorado 8025 3336 28
2424930 2424930 2022-04-20 Crowley Colorado 8025 3317 28
2421674 2421674 2022-04-19 Crowley Colorado 8025 3300 28
2418418 2418418 2022-04-18 Crowley Colorado 8025 3300 28
2415162 2415162 2022-04-17 Crowley Colorado 8025 3300 28
2411906 2411906 2022-04-16 Crowley Colorado 8025 3300 28
2408650 2408650 2022-04-15 Crowley Colorado 8025 3300 28
2405394 2405394 2022-04-14 Crowley Colorado 8025 3297 28
2402139 2402139 2022-04-13 Crowley Colorado 8025 3297 28
2398884 2398884 2022-04-12 Crowley Colorado 8025 3297 28
2395629 2395629 2022-04-11 Crowley Colorado 8025 3297 28
2392373 2392373 2022-04-10 Crowley Colorado 8025 3295 28
2389117 2389117 2022-04-09 Crowley Colorado 8025 3295 28
2385862 2385862 2022-04-08 Crowley Colorado 8025 3295 28
2382607 2382607 2022-04-07 Crowley Colorado 8025 3291 28
2379352 2379352 2022-04-06 Crowley Colorado 8025 3286 28
2376098 2376098 2022-04-05 Crowley Colorado 8025 3284 28
2372846 2372846 2022-04-04 Crowley Colorado 8025 3288 28
2369593 2369593 2022-04-03 Crowley Colorado 8025 3284 28
2366340 2366340 2022-04-02 Crowley Colorado 8025 3284 28
2363087 2363087 2022-04-01 Crowley Colorado 8025 3284 28
2359833 2359833 2022-03-31 Crowley Colorado 8025 3225 28
2356579 2356579 2022-03-30 Crowley Colorado 8025 3213 28
2353326 2353326 2022-03-29 Crowley Colorado 8025 3217 28
2350074 2350074 2022-03-28 Crowley Colorado 8025 3153 28
2346821 2346821 2022-03-27 Crowley Colorado 8025 3153 28
2343568 2343568 2022-03-26 Crowley Colorado 8025 3153 28
2340315 2340315 2022-03-25 Crowley Colorado 8025 3153 28
2337062 2337062 2022-03-24 Crowley Colorado 8025 3150 28
2333808 2333808 2022-03-23 Crowley Colorado 8025 3152 28
2330554 2330554 2022-03-22 Crowley Colorado 8025 3151 28
2327302 2327302 2022-03-21 Crowley Colorado 8025 3150 28
2324049 2324049 2022-03-20 Crowley Colorado 8025 3147 28
2320795 2320795 2022-03-19 Crowley Colorado 8025 3147 28
2317541 2317541 2022-03-18 Crowley Colorado 8025 3147 28
2314288 2314288 2022-03-17 Crowley Colorado 8025 3147 28
2311035 2311035 2022-03-16 Crowley Colorado 8025 3149 28
2307782 2307782 2022-03-15 Crowley Colorado 8025 3145 28
2304531 2304531 2022-03-14 Crowley Colorado 8025 3146 28
2301279 2301279 2022-03-13 Crowley Colorado 8025 3146 28
2298027 2298027 2022-03-12 Crowley Colorado 8025 3146 28
2294775 2294775 2022-03-11 Crowley Colorado 8025 3146 28
2291523 2291523 2022-03-10 Crowley Colorado 8025 3147 28
2288271 2288271 2022-03-09 Crowley Colorado 8025 3145 28
2285020 2285020 2022-03-08 Crowley Colorado 8025 3142 28
2281768 2281768 2022-03-07 Crowley Colorado 8025 3144 28
2278515 2278515 2022-03-06 Crowley Colorado 8025 3121 28
2275262 2275262 2022-03-05 Crowley Colorado 8025 3121 28
2272009 2272009 2022-03-04 Crowley Colorado 8025 3121 28
2268757 2268757 2022-03-03 Crowley Colorado 8025 3125 28
2265504 2265504 2022-03-02 Crowley Colorado 8025 3123 28
2262253 2262253 2022-03-01 Crowley Colorado 8025 3119 28
2259002 2259002 2022-02-28 Crowley Colorado 8025 3118 28
2255751 2255751 2022-02-27 Crowley Colorado 8025 3107 28
2252500 2252500 2022-02-26 Crowley Colorado 8025 3107 28
2249249 2249249 2022-02-25 Crowley Colorado 8025 3107 28
2245998 2245998 2022-02-24 Crowley Colorado 8025 3101 28
2242747 2242747 2022-02-23 Crowley Colorado 8025 3099 28
2239496 2239496 2022-02-22 Crowley Colorado 8025 3103 28
2236245 2236245 2022-02-21 Crowley Colorado 8025 3103 28
2232994 2232994 2022-02-20 Crowley Colorado 8025 3094 28
2229743 2229743 2022-02-19 Crowley Colorado 8025 3094 28
2226492 2226492 2022-02-18 Crowley Colorado 8025 3094 28
2223241 2223241 2022-02-17 Crowley Colorado 8025 3084 28
2219990 2219990 2022-02-16 Crowley Colorado 8025 3079 28
2216739 2216739 2022-02-15 Crowley Colorado 8025 3070 28
2213488 2213488 2022-02-14 Crowley Colorado 8025 3067 28
2210236 2210236 2022-02-13 Crowley Colorado 8025 3068 28
2206983 2206983 2022-02-12 Crowley Colorado 8025 3068 28
2203730 2203730 2022-02-11 Crowley Colorado 8025 3068 28
2200477 2200477 2022-02-10 Crowley Colorado 8025 3039 28
2197223 2197223 2022-02-09 Crowley Colorado 8025 3036 28
2193969 2193969 2022-02-08 Crowley Colorado 8025 3032 28
2190715 2190715 2022-02-07 Crowley Colorado 8025 3029 28
2187462 2187462 2022-02-06 Crowley Colorado 8025 2949 28
2184209 2184209 2022-02-05 Crowley Colorado 8025 2949 28
2180957 2180957 2022-02-04 Crowley Colorado 8025 2949 28
2177706 2177706 2022-02-03 Crowley Colorado 8025 2943 28

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