ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Delta" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499835 | 2499835 | 2022-05-13 | Delta | Colorado | 8029 | 6232 | 140 |
2496577 | 2496577 | 2022-05-12 | Delta | Colorado | 8029 | 6232 | 140 |
2493319 | 2493319 | 2022-05-11 | Delta | Colorado | 8029 | 6195 | 140 |
2490061 | 2490061 | 2022-05-10 | Delta | Colorado | 8029 | 6195 | 140 |
2486804 | 2486804 | 2022-05-09 | Delta | Colorado | 8029 | 6191 | 140 |
2483546 | 2483546 | 2022-05-08 | Delta | Colorado | 8029 | 6189 | 140 |
2480288 | 2480288 | 2022-05-07 | Delta | Colorado | 8029 | 6189 | 140 |
2477030 | 2477030 | 2022-05-06 | Delta | Colorado | 8029 | 6189 | 140 |
2473772 | 2473772 | 2022-05-05 | Delta | Colorado | 8029 | 6187 | 140 |
2470515 | 2470515 | 2022-05-04 | Delta | Colorado | 8029 | 6183 | 140 |
2467259 | 2467259 | 2022-05-03 | Delta | Colorado | 8029 | 6183 | 140 |
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 |
2320797 | 2320797 | 2022-03-19 | Delta | Colorado | 8029 | 5961 | 134 |
2317543 | 2317543 | 2022-03-18 | Delta | Colorado | 8029 | 5961 | 134 |
2314290 | 2314290 | 2022-03-17 | Delta | Colorado | 8029 | 5961 | 134 |
2311037 | 2311037 | 2022-03-16 | Delta | Colorado | 8029 | 5955 | 132 |
2307784 | 2307784 | 2022-03-15 | Delta | Colorado | 8029 | 5951 | 132 |
2304533 | 2304533 | 2022-03-14 | Delta | Colorado | 8029 | 5946 | 131 |
2301281 | 2301281 | 2022-03-13 | Delta | Colorado | 8029 | 5938 | 131 |
2298029 | 2298029 | 2022-03-12 | Delta | Colorado | 8029 | 5938 | 131 |
2294777 | 2294777 | 2022-03-11 | Delta | Colorado | 8029 | 5938 | 131 |
2291525 | 2291525 | 2022-03-10 | Delta | Colorado | 8029 | 5936 | 131 |
2288273 | 2288273 | 2022-03-09 | Delta | Colorado | 8029 | 5937 | 131 |
2285022 | 2285022 | 2022-03-08 | Delta | Colorado | 8029 | 5932 | 130 |
2281770 | 2281770 | 2022-03-07 | Delta | Colorado | 8029 | 5923 | 130 |
2278517 | 2278517 | 2022-03-06 | Delta | Colorado | 8029 | 5908 | 130 |
2275264 | 2275264 | 2022-03-05 | Delta | Colorado | 8029 | 5908 | 130 |
2272011 | 2272011 | 2022-03-04 | Delta | Colorado | 8029 | 5908 | 130 |
2268759 | 2268759 | 2022-03-03 | Delta | Colorado | 8029 | 5900 | 130 |
2265506 | 2265506 | 2022-03-02 | Delta | Colorado | 8029 | 5898 | 130 |
2262255 | 2262255 | 2022-03-01 | Delta | Colorado | 8029 | 5892 | 130 |
2259004 | 2259004 | 2022-02-28 | Delta | Colorado | 8029 | 5890 | 130 |
2255753 | 2255753 | 2022-02-27 | Delta | Colorado | 8029 | 5877 | 129 |
2252502 | 2252502 | 2022-02-26 | Delta | Colorado | 8029 | 5877 | 129 |
2249251 | 2249251 | 2022-02-25 | Delta | Colorado | 8029 | 5877 | 129 |
2246000 | 2246000 | 2022-02-24 | Delta | Colorado | 8029 | 5870 | 129 |
2242749 | 2242749 | 2022-02-23 | Delta | Colorado | 8029 | 5865 | 129 |
2239498 | 2239498 | 2022-02-22 | Delta | Colorado | 8029 | 5850 | 129 |
2236247 | 2236247 | 2022-02-21 | Delta | Colorado | 8029 | 5845 | 129 |
2232996 | 2232996 | 2022-02-20 | Delta | Colorado | 8029 | 5831 | 129 |
2229745 | 2229745 | 2022-02-19 | Delta | Colorado | 8029 | 5831 | 129 |
2226494 | 2226494 | 2022-02-18 | Delta | Colorado | 8029 | 5831 | 129 |
2223243 | 2223243 | 2022-02-17 | Delta | Colorado | 8029 | 5819 | 129 |
2219992 | 2219992 | 2022-02-16 | Delta | Colorado | 8029 | 5803 | 129 |
2216741 | 2216741 | 2022-02-15 | Delta | Colorado | 8029 | 5778 | 128 |
2213490 | 2213490 | 2022-02-14 | Delta | Colorado | 8029 | 5765 | 128 |
2210238 | 2210238 | 2022-02-13 | Delta | Colorado | 8029 | 5740 | 128 |
2206985 | 2206985 | 2022-02-12 | Delta | Colorado | 8029 | 5740 | 128 |
2203732 | 2203732 | 2022-02-11 | Delta | Colorado | 8029 | 5740 | 128 |
2200479 | 2200479 | 2022-02-10 | Delta | Colorado | 8029 | 5715 | 128 |
2197225 | 2197225 | 2022-02-09 | Delta | Colorado | 8029 | 5692 | 127 |
2193971 | 2193971 | 2022-02-08 | Delta | Colorado | 8029 | 5651 | 126 |
2190717 | 2190717 | 2022-02-07 | Delta | Colorado | 8029 | 5626 | 125 |
2187464 | 2187464 | 2022-02-06 | Delta | Colorado | 8029 | 5597 | 124 |
2184211 | 2184211 | 2022-02-05 | Delta | Colorado | 8029 | 5597 | 124 |
2180959 | 2180959 | 2022-02-04 | Delta | Colorado | 8029 | 5597 | 124 |
2177708 | 2177708 | 2022-02-03 | Delta | Colorado | 8029 | 5559 | 124 |
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);