ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,560 rows where deaths = 0 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hinsdale 784
- Jackson 688
- San Juan 679
- Lake 476
- San Miguel 452
- Dolores 310
- Archuleta 296
- Custer 280
- Baca 271
- Lincoln 257
- Mineral 255
- Gilpin 236
- Rio Blanco 232
- Las Animas 223
- Washington 223
- Phillips 222
- Cheyenne 210
- Prowers 201
- Bent 195
- Yuma 189
- Conejos 183
- Fremont 169
- Costilla 157
- Mesa 131
- Park 119
- Moffat 104
- Grand 102
- Huerfano 99
- Rio Grande 84
- Kiowa 82
- …
state 1
- Colorado · 8,560 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499847 | 2499847 | 2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 |
2499849 | 2499849 | 2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 |
2499876 | 2499876 | 2022-05-13 | San Juan | Colorado | 8111 | 203 | 0 |
2496589 | 2496589 | 2022-05-12 | Hinsdale | Colorado | 8053 | 131 | 0 |
2496591 | 2496591 | 2022-05-12 | Jackson | Colorado | 8057 | 166 | 0 |
2496618 | 2496618 | 2022-05-12 | San Juan | Colorado | 8111 | 203 | 0 |
2493331 | 2493331 | 2022-05-11 | Hinsdale | Colorado | 8053 | 131 | 0 |
2493333 | 2493333 | 2022-05-11 | Jackson | Colorado | 8057 | 165 | 0 |
2493360 | 2493360 | 2022-05-11 | San Juan | Colorado | 8111 | 203 | 0 |
2490073 | 2490073 | 2022-05-10 | Hinsdale | Colorado | 8053 | 131 | 0 |
2490075 | 2490075 | 2022-05-10 | Jackson | Colorado | 8057 | 165 | 0 |
2490102 | 2490102 | 2022-05-10 | San Juan | Colorado | 8111 | 203 | 0 |
2486816 | 2486816 | 2022-05-09 | Hinsdale | Colorado | 8053 | 131 | 0 |
2486818 | 2486818 | 2022-05-09 | Jackson | Colorado | 8057 | 165 | 0 |
2486845 | 2486845 | 2022-05-09 | San Juan | Colorado | 8111 | 203 | 0 |
2483558 | 2483558 | 2022-05-08 | Hinsdale | Colorado | 8053 | 131 | 0 |
2483560 | 2483560 | 2022-05-08 | Jackson | Colorado | 8057 | 165 | 0 |
2483587 | 2483587 | 2022-05-08 | San Juan | Colorado | 8111 | 203 | 0 |
2480300 | 2480300 | 2022-05-07 | Hinsdale | Colorado | 8053 | 131 | 0 |
2480302 | 2480302 | 2022-05-07 | Jackson | Colorado | 8057 | 165 | 0 |
2480329 | 2480329 | 2022-05-07 | San Juan | Colorado | 8111 | 203 | 0 |
2477042 | 2477042 | 2022-05-06 | Hinsdale | Colorado | 8053 | 131 | 0 |
2477044 | 2477044 | 2022-05-06 | Jackson | Colorado | 8057 | 165 | 0 |
2477071 | 2477071 | 2022-05-06 | San Juan | Colorado | 8111 | 203 | 0 |
2473784 | 2473784 | 2022-05-05 | Hinsdale | Colorado | 8053 | 130 | 0 |
2473786 | 2473786 | 2022-05-05 | Jackson | Colorado | 8057 | 165 | 0 |
2473813 | 2473813 | 2022-05-05 | San Juan | Colorado | 8111 | 203 | 0 |
2470527 | 2470527 | 2022-05-04 | Hinsdale | Colorado | 8053 | 130 | 0 |
2470529 | 2470529 | 2022-05-04 | Jackson | Colorado | 8057 | 165 | 0 |
2470556 | 2470556 | 2022-05-04 | San Juan | Colorado | 8111 | 203 | 0 |
2467271 | 2467271 | 2022-05-03 | Hinsdale | Colorado | 8053 | 130 | 0 |
2467273 | 2467273 | 2022-05-03 | Jackson | Colorado | 8057 | 165 | 0 |
2467300 | 2467300 | 2022-05-03 | San Juan | Colorado | 8111 | 202 | 0 |
2464016 | 2464016 | 2022-05-02 | Hinsdale | Colorado | 8053 | 130 | 0 |
2464018 | 2464018 | 2022-05-02 | Jackson | Colorado | 8057 | 165 | 0 |
2464045 | 2464045 | 2022-05-02 | San Juan | Colorado | 8111 | 202 | 0 |
2460760 | 2460760 | 2022-05-01 | Hinsdale | Colorado | 8053 | 130 | 0 |
2460762 | 2460762 | 2022-05-01 | Jackson | Colorado | 8057 | 165 | 0 |
2460789 | 2460789 | 2022-05-01 | San Juan | Colorado | 8111 | 202 | 0 |
2457504 | 2457504 | 2022-04-30 | Hinsdale | Colorado | 8053 | 130 | 0 |
2457506 | 2457506 | 2022-04-30 | Jackson | Colorado | 8057 | 165 | 0 |
2457533 | 2457533 | 2022-04-30 | San Juan | Colorado | 8111 | 202 | 0 |
2454248 | 2454248 | 2022-04-29 | Hinsdale | Colorado | 8053 | 130 | 0 |
2454250 | 2454250 | 2022-04-29 | Jackson | Colorado | 8057 | 165 | 0 |
2454277 | 2454277 | 2022-04-29 | San Juan | Colorado | 8111 | 202 | 0 |
2450992 | 2450992 | 2022-04-28 | Hinsdale | Colorado | 8053 | 130 | 0 |
2450994 | 2450994 | 2022-04-28 | Jackson | Colorado | 8057 | 165 | 0 |
2451021 | 2451021 | 2022-04-28 | San Juan | Colorado | 8111 | 202 | 0 |
2447736 | 2447736 | 2022-04-27 | Hinsdale | Colorado | 8053 | 129 | 0 |
2447738 | 2447738 | 2022-04-27 | Jackson | Colorado | 8057 | 165 | 0 |
2447765 | 2447765 | 2022-04-27 | San Juan | Colorado | 8111 | 202 | 0 |
2444480 | 2444480 | 2022-04-26 | Hinsdale | Colorado | 8053 | 129 | 0 |
2444482 | 2444482 | 2022-04-26 | Jackson | Colorado | 8057 | 165 | 0 |
2444509 | 2444509 | 2022-04-26 | San Juan | Colorado | 8111 | 202 | 0 |
2441224 | 2441224 | 2022-04-25 | Hinsdale | Colorado | 8053 | 129 | 0 |
2441226 | 2441226 | 2022-04-25 | Jackson | Colorado | 8057 | 165 | 0 |
2441253 | 2441253 | 2022-04-25 | San Juan | Colorado | 8111 | 202 | 0 |
2437968 | 2437968 | 2022-04-24 | Hinsdale | Colorado | 8053 | 129 | 0 |
2437970 | 2437970 | 2022-04-24 | Jackson | Colorado | 8057 | 165 | 0 |
2437997 | 2437997 | 2022-04-24 | San Juan | Colorado | 8111 | 202 | 0 |
2434712 | 2434712 | 2022-04-23 | Hinsdale | Colorado | 8053 | 129 | 0 |
2434714 | 2434714 | 2022-04-23 | Jackson | Colorado | 8057 | 165 | 0 |
2434741 | 2434741 | 2022-04-23 | San Juan | Colorado | 8111 | 202 | 0 |
2431456 | 2431456 | 2022-04-22 | Hinsdale | Colorado | 8053 | 129 | 0 |
2431458 | 2431458 | 2022-04-22 | Jackson | Colorado | 8057 | 165 | 0 |
2431485 | 2431485 | 2022-04-22 | San Juan | Colorado | 8111 | 202 | 0 |
2428200 | 2428200 | 2022-04-21 | Hinsdale | Colorado | 8053 | 129 | 0 |
2428202 | 2428202 | 2022-04-21 | Jackson | Colorado | 8057 | 165 | 0 |
2428229 | 2428229 | 2022-04-21 | San Juan | Colorado | 8111 | 202 | 0 |
2424944 | 2424944 | 2022-04-20 | Hinsdale | Colorado | 8053 | 129 | 0 |
2424946 | 2424946 | 2022-04-20 | Jackson | Colorado | 8057 | 165 | 0 |
2424973 | 2424973 | 2022-04-20 | San Juan | Colorado | 8111 | 202 | 0 |
2421688 | 2421688 | 2022-04-19 | Hinsdale | Colorado | 8053 | 126 | 0 |
2421690 | 2421690 | 2022-04-19 | Jackson | Colorado | 8057 | 165 | 0 |
2421717 | 2421717 | 2022-04-19 | San Juan | Colorado | 8111 | 202 | 0 |
2418432 | 2418432 | 2022-04-18 | Hinsdale | Colorado | 8053 | 123 | 0 |
2418434 | 2418434 | 2022-04-18 | Jackson | Colorado | 8057 | 165 | 0 |
2418461 | 2418461 | 2022-04-18 | San Juan | Colorado | 8111 | 201 | 0 |
2415176 | 2415176 | 2022-04-17 | Hinsdale | Colorado | 8053 | 123 | 0 |
2415178 | 2415178 | 2022-04-17 | Jackson | Colorado | 8057 | 164 | 0 |
2415205 | 2415205 | 2022-04-17 | San Juan | Colorado | 8111 | 201 | 0 |
2411920 | 2411920 | 2022-04-16 | Hinsdale | Colorado | 8053 | 123 | 0 |
2411922 | 2411922 | 2022-04-16 | Jackson | Colorado | 8057 | 164 | 0 |
2411949 | 2411949 | 2022-04-16 | San Juan | Colorado | 8111 | 201 | 0 |
2408664 | 2408664 | 2022-04-15 | Hinsdale | Colorado | 8053 | 123 | 0 |
2408666 | 2408666 | 2022-04-15 | Jackson | Colorado | 8057 | 164 | 0 |
2408693 | 2408693 | 2022-04-15 | San Juan | Colorado | 8111 | 201 | 0 |
2405408 | 2405408 | 2022-04-14 | Hinsdale | Colorado | 8053 | 123 | 0 |
2405410 | 2405410 | 2022-04-14 | Jackson | Colorado | 8057 | 164 | 0 |
2405437 | 2405437 | 2022-04-14 | San Juan | Colorado | 8111 | 201 | 0 |
2402153 | 2402153 | 2022-04-13 | Hinsdale | Colorado | 8053 | 123 | 0 |
2402155 | 2402155 | 2022-04-13 | Jackson | Colorado | 8057 | 164 | 0 |
2402182 | 2402182 | 2022-04-13 | San Juan | Colorado | 8111 | 201 | 0 |
2398898 | 2398898 | 2022-04-12 | Hinsdale | Colorado | 8053 | 123 | 0 |
2398900 | 2398900 | 2022-04-12 | Jackson | Colorado | 8057 | 164 | 0 |
2398927 | 2398927 | 2022-04-12 | San Juan | Colorado | 8111 | 201 | 0 |
2395643 | 2395643 | 2022-04-11 | Hinsdale | Colorado | 8053 | 123 | 0 |
2395645 | 2395645 | 2022-04-11 | Jackson | Colorado | 8057 | 164 | 0 |
2395672 | 2395672 | 2022-04-11 | San Juan | Colorado | 8111 | 200 | 0 |
2392387 | 2392387 | 2022-04-10 | Hinsdale | Colorado | 8053 | 123 | 0 |
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);