ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where deaths = 14 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Crowley 99
- Teller 97
- Gunnison 87
- Summit 87
- Las Animas 71
- Kit Carson 61
- Phillips 59
- Costilla 43
- Rio Grande 40
- Washington 34
- Elbert 32
- Park 18
- Yuma 16
- Montrose 14
- Custer 13
- Archuleta 10
- Montezuma 10
- Pueblo 10
- Logan 8
- Alamosa 5
- Eagle 5
- Fremont 4
- Adams 2
- Denver 2
- Garfield 2
- Prowers 2
- Routt 2
- Boulder 1
- Delta 1
- El Paso 1
- …
state 1
- Colorado · 839 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499846 | 2499846 | 2022-05-13 | Gunnison | Colorado | 8051 | 3407 | 14 |
2499879 | 2499879 | 2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 |
2496588 | 2496588 | 2022-05-12 | Gunnison | Colorado | 8051 | 3406 | 14 |
2496621 | 2496621 | 2022-05-12 | Summit | Colorado | 8117 | 10081 | 14 |
2493330 | 2493330 | 2022-05-11 | Gunnison | Colorado | 8051 | 3401 | 14 |
2493363 | 2493363 | 2022-05-11 | Summit | Colorado | 8117 | 10003 | 14 |
2490072 | 2490072 | 2022-05-10 | Gunnison | Colorado | 8051 | 3402 | 14 |
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2486815 | 2486815 | 2022-05-09 | Gunnison | Colorado | 8051 | 3402 | 14 |
2486848 | 2486848 | 2022-05-09 | Summit | Colorado | 8117 | 9998 | 14 |
2483557 | 2483557 | 2022-05-08 | Gunnison | Colorado | 8051 | 3400 | 14 |
2483590 | 2483590 | 2022-05-08 | Summit | Colorado | 8117 | 9979 | 14 |
2480299 | 2480299 | 2022-05-07 | Gunnison | Colorado | 8051 | 3400 | 14 |
2480332 | 2480332 | 2022-05-07 | Summit | Colorado | 8117 | 9979 | 14 |
2477041 | 2477041 | 2022-05-06 | Gunnison | Colorado | 8051 | 3400 | 14 |
2477074 | 2477074 | 2022-05-06 | Summit | Colorado | 8117 | 9979 | 14 |
2473783 | 2473783 | 2022-05-05 | Gunnison | Colorado | 8051 | 3399 | 14 |
2473816 | 2473816 | 2022-05-05 | Summit | Colorado | 8117 | 9980 | 14 |
2470526 | 2470526 | 2022-05-04 | Gunnison | Colorado | 8051 | 3398 | 14 |
2470559 | 2470559 | 2022-05-04 | Summit | Colorado | 8117 | 9974 | 14 |
2467270 | 2467270 | 2022-05-03 | Gunnison | Colorado | 8051 | 3398 | 14 |
2467303 | 2467303 | 2022-05-03 | Summit | Colorado | 8117 | 9962 | 14 |
2464015 | 2464015 | 2022-05-02 | Gunnison | Colorado | 8051 | 3398 | 14 |
2464048 | 2464048 | 2022-05-02 | Summit | Colorado | 8117 | 9954 | 14 |
2460759 | 2460759 | 2022-05-01 | Gunnison | Colorado | 8051 | 3396 | 14 |
2460792 | 2460792 | 2022-05-01 | Summit | Colorado | 8117 | 9947 | 14 |
2457503 | 2457503 | 2022-04-30 | Gunnison | Colorado | 8051 | 3396 | 14 |
2457536 | 2457536 | 2022-04-30 | Summit | Colorado | 8117 | 9947 | 14 |
2454247 | 2454247 | 2022-04-29 | Gunnison | Colorado | 8051 | 3396 | 14 |
2454280 | 2454280 | 2022-04-29 | Summit | Colorado | 8117 | 9947 | 14 |
2450991 | 2450991 | 2022-04-28 | Gunnison | Colorado | 8051 | 3396 | 14 |
2451024 | 2451024 | 2022-04-28 | Summit | Colorado | 8117 | 9943 | 14 |
2447735 | 2447735 | 2022-04-27 | Gunnison | Colorado | 8051 | 3395 | 14 |
2447768 | 2447768 | 2022-04-27 | Summit | Colorado | 8117 | 9942 | 14 |
2444479 | 2444479 | 2022-04-26 | Gunnison | Colorado | 8051 | 3394 | 14 |
2444512 | 2444512 | 2022-04-26 | Summit | Colorado | 8117 | 9937 | 14 |
2441223 | 2441223 | 2022-04-25 | Gunnison | Colorado | 8051 | 3393 | 14 |
2441256 | 2441256 | 2022-04-25 | Summit | Colorado | 8117 | 9923 | 14 |
2437967 | 2437967 | 2022-04-24 | Gunnison | Colorado | 8051 | 3390 | 14 |
2438000 | 2438000 | 2022-04-24 | Summit | Colorado | 8117 | 9900 | 14 |
2434711 | 2434711 | 2022-04-23 | Gunnison | Colorado | 8051 | 3390 | 14 |
2434744 | 2434744 | 2022-04-23 | Summit | Colorado | 8117 | 9900 | 14 |
2431455 | 2431455 | 2022-04-22 | Gunnison | Colorado | 8051 | 3390 | 14 |
2431488 | 2431488 | 2022-04-22 | Summit | Colorado | 8117 | 9900 | 14 |
2428199 | 2428199 | 2022-04-21 | Gunnison | Colorado | 8051 | 3388 | 14 |
2428232 | 2428232 | 2022-04-21 | Summit | Colorado | 8117 | 9890 | 14 |
2424943 | 2424943 | 2022-04-20 | Gunnison | Colorado | 8051 | 3387 | 14 |
2424976 | 2424976 | 2022-04-20 | Summit | Colorado | 8117 | 9872 | 14 |
2421687 | 2421687 | 2022-04-19 | Gunnison | Colorado | 8051 | 3384 | 14 |
2421720 | 2421720 | 2022-04-19 | Summit | Colorado | 8117 | 9861 | 14 |
2418431 | 2418431 | 2022-04-18 | Gunnison | Colorado | 8051 | 3383 | 14 |
2418464 | 2418464 | 2022-04-18 | Summit | Colorado | 8117 | 9856 | 14 |
2415175 | 2415175 | 2022-04-17 | Gunnison | Colorado | 8051 | 3384 | 14 |
2415208 | 2415208 | 2022-04-17 | Summit | Colorado | 8117 | 9842 | 14 |
2411919 | 2411919 | 2022-04-16 | Gunnison | Colorado | 8051 | 3384 | 14 |
2411952 | 2411952 | 2022-04-16 | Summit | Colorado | 8117 | 9842 | 14 |
2408663 | 2408663 | 2022-04-15 | Gunnison | Colorado | 8051 | 3384 | 14 |
2408696 | 2408696 | 2022-04-15 | Summit | Colorado | 8117 | 9842 | 14 |
2405407 | 2405407 | 2022-04-14 | Gunnison | Colorado | 8051 | 3384 | 14 |
2405440 | 2405440 | 2022-04-14 | Summit | Colorado | 8117 | 9830 | 14 |
2402152 | 2402152 | 2022-04-13 | Gunnison | Colorado | 8051 | 3381 | 14 |
2402185 | 2402185 | 2022-04-13 | Summit | Colorado | 8117 | 9827 | 14 |
2398897 | 2398897 | 2022-04-12 | Gunnison | Colorado | 8051 | 3380 | 14 |
2398930 | 2398930 | 2022-04-12 | Summit | Colorado | 8117 | 9822 | 14 |
2395642 | 2395642 | 2022-04-11 | Gunnison | Colorado | 8051 | 3379 | 14 |
2395675 | 2395675 | 2022-04-11 | Summit | Colorado | 8117 | 9820 | 14 |
2392386 | 2392386 | 2022-04-10 | Gunnison | Colorado | 8051 | 3367 | 14 |
2392419 | 2392419 | 2022-04-10 | Summit | Colorado | 8117 | 9796 | 14 |
2389130 | 2389130 | 2022-04-09 | Gunnison | Colorado | 8051 | 3367 | 14 |
2389163 | 2389163 | 2022-04-09 | Summit | Colorado | 8117 | 9796 | 14 |
2385875 | 2385875 | 2022-04-08 | Gunnison | Colorado | 8051 | 3367 | 14 |
2385908 | 2385908 | 2022-04-08 | Summit | Colorado | 8117 | 9796 | 14 |
2382620 | 2382620 | 2022-04-07 | Gunnison | Colorado | 8051 | 3355 | 14 |
2382653 | 2382653 | 2022-04-07 | Summit | Colorado | 8117 | 9794 | 14 |
2379365 | 2379365 | 2022-04-06 | Gunnison | Colorado | 8051 | 3353 | 14 |
2379398 | 2379398 | 2022-04-06 | Summit | Colorado | 8117 | 9783 | 14 |
2376111 | 2376111 | 2022-04-05 | Gunnison | Colorado | 8051 | 3349 | 14 |
2376144 | 2376144 | 2022-04-05 | Summit | Colorado | 8117 | 9772 | 14 |
2372859 | 2372859 | 2022-04-04 | Gunnison | Colorado | 8051 | 3350 | 14 |
2372892 | 2372892 | 2022-04-04 | Summit | Colorado | 8117 | 9759 | 14 |
2369606 | 2369606 | 2022-04-03 | Gunnison | Colorado | 8051 | 3349 | 14 |
2369639 | 2369639 | 2022-04-03 | Summit | Colorado | 8117 | 9746 | 14 |
2366353 | 2366353 | 2022-04-02 | Gunnison | Colorado | 8051 | 3349 | 14 |
2366386 | 2366386 | 2022-04-02 | Summit | Colorado | 8117 | 9746 | 14 |
2363100 | 2363100 | 2022-04-01 | Gunnison | Colorado | 8051 | 3349 | 14 |
2363133 | 2363133 | 2022-04-01 | Summit | Colorado | 8117 | 9746 | 14 |
2359846 | 2359846 | 2022-03-31 | Gunnison | Colorado | 8051 | 3348 | 14 |
2359879 | 2359879 | 2022-03-31 | Summit | Colorado | 8117 | 9740 | 14 |
2356592 | 2356592 | 2022-03-30 | Gunnison | Colorado | 8051 | 3346 | 14 |
2356625 | 2356625 | 2022-03-30 | Summit | Colorado | 8117 | 9736 | 14 |
2353339 | 2353339 | 2022-03-29 | Gunnison | Colorado | 8051 | 3343 | 14 |
2353372 | 2353372 | 2022-03-29 | Summit | Colorado | 8117 | 9732 | 14 |
2350087 | 2350087 | 2022-03-28 | Gunnison | Colorado | 8051 | 3342 | 14 |
2350120 | 2350120 | 2022-03-28 | Summit | Colorado | 8117 | 9722 | 14 |
2346834 | 2346834 | 2022-03-27 | Gunnison | Colorado | 8051 | 3340 | 14 |
2346867 | 2346867 | 2022-03-27 | Summit | Colorado | 8117 | 9711 | 14 |
2343581 | 2343581 | 2022-03-26 | Gunnison | Colorado | 8051 | 3340 | 14 |
2343614 | 2343614 | 2022-03-26 | Summit | Colorado | 8117 | 9711 | 14 |
2340328 | 2340328 | 2022-03-25 | Gunnison | Colorado | 8051 | 3340 | 14 |
2340361 | 2340361 | 2022-03-25 | Summit | Colorado | 8117 | 9711 | 14 |
Advanced export
JSON shape: default, array, newline-delimited
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);