ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 134 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Colorado · 72 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464004 | 2464004 | 2022-05-02 | Delta | Colorado | 8029 | 6183 | 134 |
2460748 | 2460748 | 2022-05-01 | Delta | Colorado | 8029 | 6181 | 134 |
2457492 | 2457492 | 2022-04-30 | Delta | Colorado | 8029 | 6181 | 134 |
2454236 | 2454236 | 2022-04-29 | Delta | Colorado | 8029 | 6181 | 134 |
2450980 | 2450980 | 2022-04-28 | Delta | Colorado | 8029 | 6181 | 134 |
2447724 | 2447724 | 2022-04-27 | Delta | Colorado | 8029 | 6181 | 134 |
2444468 | 2444468 | 2022-04-26 | Delta | Colorado | 8029 | 6177 | 134 |
2441212 | 2441212 | 2022-04-25 | Delta | Colorado | 8029 | 6177 | 134 |
2437956 | 2437956 | 2022-04-24 | Delta | Colorado | 8029 | 6176 | 134 |
2434700 | 2434700 | 2022-04-23 | Delta | Colorado | 8029 | 6176 | 134 |
2431444 | 2431444 | 2022-04-22 | Delta | Colorado | 8029 | 6176 | 134 |
2428188 | 2428188 | 2022-04-21 | Delta | Colorado | 8029 | 6169 | 134 |
2424932 | 2424932 | 2022-04-20 | Delta | Colorado | 8029 | 6157 | 134 |
2421676 | 2421676 | 2022-04-19 | Delta | Colorado | 8029 | 6144 | 134 |
2418420 | 2418420 | 2022-04-18 | Delta | Colorado | 8029 | 6133 | 134 |
2415164 | 2415164 | 2022-04-17 | Delta | Colorado | 8029 | 6130 | 134 |
2411908 | 2411908 | 2022-04-16 | Delta | Colorado | 8029 | 6130 | 134 |
2408652 | 2408652 | 2022-04-15 | Delta | Colorado | 8029 | 6130 | 134 |
2405396 | 2405396 | 2022-04-14 | Delta | Colorado | 8029 | 6128 | 134 |
2402141 | 2402141 | 2022-04-13 | Delta | Colorado | 8029 | 6109 | 134 |
2398886 | 2398886 | 2022-04-12 | Delta | Colorado | 8029 | 6104 | 134 |
2395631 | 2395631 | 2022-04-11 | Delta | Colorado | 8029 | 6037 | 134 |
2392375 | 2392375 | 2022-04-10 | Delta | Colorado | 8029 | 6028 | 134 |
2389119 | 2389119 | 2022-04-09 | Delta | Colorado | 8029 | 6028 | 134 |
2385864 | 2385864 | 2022-04-08 | Delta | Colorado | 8029 | 6028 | 134 |
2382609 | 2382609 | 2022-04-07 | Delta | Colorado | 8029 | 6023 | 134 |
2379354 | 2379354 | 2022-04-06 | Delta | Colorado | 8029 | 6014 | 134 |
2376100 | 2376100 | 2022-04-05 | Delta | Colorado | 8029 | 6011 | 134 |
2372848 | 2372848 | 2022-04-04 | Delta | Colorado | 8029 | 6009 | 134 |
2369595 | 2369595 | 2022-04-03 | Delta | Colorado | 8029 | 6001 | 134 |
2366342 | 2366342 | 2022-04-02 | Delta | Colorado | 8029 | 6001 | 134 |
2363089 | 2363089 | 2022-04-01 | Delta | Colorado | 8029 | 6001 | 134 |
2359835 | 2359835 | 2022-03-31 | Delta | Colorado | 8029 | 6001 | 134 |
2356581 | 2356581 | 2022-03-30 | Delta | Colorado | 8029 | 5988 | 134 |
2353328 | 2353328 | 2022-03-29 | Delta | Colorado | 8029 | 5985 | 134 |
2350076 | 2350076 | 2022-03-28 | Delta | Colorado | 8029 | 5977 | 134 |
2346823 | 2346823 | 2022-03-27 | Delta | Colorado | 8029 | 5977 | 134 |
2343570 | 2343570 | 2022-03-26 | Delta | Colorado | 8029 | 5977 | 134 |
2340317 | 2340317 | 2022-03-25 | Delta | Colorado | 8029 | 5977 | 134 |
2337064 | 2337064 | 2022-03-24 | Delta | Colorado | 8029 | 5972 | 134 |
2333810 | 2333810 | 2022-03-23 | Delta | Colorado | 8029 | 5967 | 134 |
2330556 | 2330556 | 2022-03-22 | Delta | Colorado | 8029 | 5966 | 134 |
2327304 | 2327304 | 2022-03-21 | Delta | Colorado | 8029 | 5963 | 134 |
2324051 | 2324051 | 2022-03-20 | Delta | Colorado | 8029 | 5961 | 134 |
2324080 | 2324080 | 2022-03-20 | Morgan | Colorado | 8087 | 5522 | 134 |
2320797 | 2320797 | 2022-03-19 | Delta | Colorado | 8029 | 5961 | 134 |
2320826 | 2320826 | 2022-03-19 | Morgan | Colorado | 8087 | 5522 | 134 |
2317543 | 2317543 | 2022-03-18 | Delta | Colorado | 8029 | 5961 | 134 |
2317572 | 2317572 | 2022-03-18 | Morgan | Colorado | 8087 | 5522 | 134 |
2314290 | 2314290 | 2022-03-17 | Delta | Colorado | 8029 | 5961 | 134 |
2314319 | 2314319 | 2022-03-17 | Morgan | Colorado | 8087 | 5522 | 134 |
2311066 | 2311066 | 2022-03-16 | Morgan | Colorado | 8087 | 5513 | 134 |
2307813 | 2307813 | 2022-03-15 | Morgan | Colorado | 8087 | 5506 | 134 |
2304562 | 2304562 | 2022-03-14 | Morgan | Colorado | 8087 | 5500 | 134 |
2301310 | 2301310 | 2022-03-13 | Morgan | Colorado | 8087 | 5500 | 134 |
2298058 | 2298058 | 2022-03-12 | Morgan | Colorado | 8087 | 5500 | 134 |
2294806 | 2294806 | 2022-03-11 | Morgan | Colorado | 8087 | 5500 | 134 |
2291554 | 2291554 | 2022-03-10 | Morgan | Colorado | 8087 | 5498 | 134 |
2288302 | 2288302 | 2022-03-09 | Morgan | Colorado | 8087 | 5497 | 134 |
2285051 | 2285051 | 2022-03-08 | Morgan | Colorado | 8087 | 5491 | 134 |
2281799 | 2281799 | 2022-03-07 | Morgan | Colorado | 8087 | 5484 | 134 |
2278546 | 2278546 | 2022-03-06 | Morgan | Colorado | 8087 | 5475 | 134 |
2275293 | 2275293 | 2022-03-05 | Morgan | Colorado | 8087 | 5475 | 134 |
2272040 | 2272040 | 2022-03-04 | Morgan | Colorado | 8087 | 5475 | 134 |
2268788 | 2268788 | 2022-03-03 | Morgan | Colorado | 8087 | 5470 | 134 |
2265535 | 2265535 | 2022-03-02 | Morgan | Colorado | 8087 | 5470 | 134 |
2262284 | 2262284 | 2022-03-01 | Morgan | Colorado | 8087 | 5470 | 134 |
1969620 | 1969620 | 2021-12-01 | Fremont | Colorado | 8043 | 10008 | 134 |
881776 | 881776 | 2020-12-31 | Mesa | Colorado | 8077 | 9055 | 134 |
875282 | 875282 | 2020-12-29 | Larimer | Colorado | 8069 | 14858 | 134 |
209453 | 209453 | 2020-06-05 | Weld | Colorado | 8123 | 2540 | 134 |
206372 | 206372 | 2020-06-04 | Weld | Colorado | 8123 | 2534 | 134 |
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);