ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where deaths = 48 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428223 | 2428223 | 2022-04-21 | Prowers | Colorado | 8099 | 2642 | 48 |
2424967 | 2424967 | 2022-04-20 | Prowers | Colorado | 8099 | 2639 | 48 |
2421711 | 2421711 | 2022-04-19 | Prowers | Colorado | 8099 | 2638 | 48 |
2418455 | 2418455 | 2022-04-18 | Prowers | Colorado | 8099 | 2638 | 48 |
2415199 | 2415199 | 2022-04-17 | Prowers | Colorado | 8099 | 2628 | 48 |
2411943 | 2411943 | 2022-04-16 | Prowers | Colorado | 8099 | 2628 | 48 |
2408687 | 2408687 | 2022-04-15 | Prowers | Colorado | 8099 | 2628 | 48 |
2405431 | 2405431 | 2022-04-14 | Prowers | Colorado | 8099 | 2628 | 48 |
2402176 | 2402176 | 2022-04-13 | Prowers | Colorado | 8099 | 2628 | 48 |
2398921 | 2398921 | 2022-04-12 | Prowers | Colorado | 8099 | 2628 | 48 |
2395666 | 2395666 | 2022-04-11 | Prowers | Colorado | 8099 | 2628 | 48 |
2392410 | 2392410 | 2022-04-10 | Prowers | Colorado | 8099 | 2627 | 48 |
2389154 | 2389154 | 2022-04-09 | Prowers | Colorado | 8099 | 2627 | 48 |
2385899 | 2385899 | 2022-04-08 | Prowers | Colorado | 8099 | 2627 | 48 |
2382644 | 2382644 | 2022-04-07 | Prowers | Colorado | 8099 | 2622 | 48 |
2379389 | 2379389 | 2022-04-06 | Prowers | Colorado | 8099 | 2622 | 48 |
2376135 | 2376135 | 2022-04-05 | Prowers | Colorado | 8099 | 2619 | 48 |
2372883 | 2372883 | 2022-04-04 | Prowers | Colorado | 8099 | 2619 | 48 |
2369630 | 2369630 | 2022-04-03 | Prowers | Colorado | 8099 | 2617 | 48 |
2366377 | 2366377 | 2022-04-02 | Prowers | Colorado | 8099 | 2617 | 48 |
2363124 | 2363124 | 2022-04-01 | Prowers | Colorado | 8099 | 2617 | 48 |
2359870 | 2359870 | 2022-03-31 | Prowers | Colorado | 8099 | 2615 | 48 |
2356616 | 2356616 | 2022-03-30 | Prowers | Colorado | 8099 | 2612 | 48 |
2353363 | 2353363 | 2022-03-29 | Prowers | Colorado | 8099 | 2612 | 48 |
2350111 | 2350111 | 2022-03-28 | Prowers | Colorado | 8099 | 2609 | 48 |
2346858 | 2346858 | 2022-03-27 | Prowers | Colorado | 8099 | 2609 | 48 |
2343605 | 2343605 | 2022-03-26 | Prowers | Colorado | 8099 | 2609 | 48 |
2340352 | 2340352 | 2022-03-25 | Prowers | Colorado | 8099 | 2609 | 48 |
2337099 | 2337099 | 2022-03-24 | Prowers | Colorado | 8099 | 2608 | 48 |
2333845 | 2333845 | 2022-03-23 | Prowers | Colorado | 8099 | 2605 | 48 |
2330591 | 2330591 | 2022-03-22 | Prowers | Colorado | 8099 | 2603 | 48 |
2327339 | 2327339 | 2022-03-21 | Prowers | Colorado | 8099 | 2602 | 48 |
2324086 | 2324086 | 2022-03-20 | Prowers | Colorado | 8099 | 2598 | 48 |
2320832 | 2320832 | 2022-03-19 | Prowers | Colorado | 8099 | 2598 | 48 |
2317578 | 2317578 | 2022-03-18 | Prowers | Colorado | 8099 | 2598 | 48 |
2314325 | 2314325 | 2022-03-17 | Prowers | Colorado | 8099 | 2598 | 48 |
2311072 | 2311072 | 2022-03-16 | Prowers | Colorado | 8099 | 2593 | 48 |
2307819 | 2307819 | 2022-03-15 | Prowers | Colorado | 8099 | 2589 | 48 |
2304568 | 2304568 | 2022-03-14 | Prowers | Colorado | 8099 | 2587 | 48 |
2301316 | 2301316 | 2022-03-13 | Prowers | Colorado | 8099 | 2587 | 48 |
2298064 | 2298064 | 2022-03-12 | Prowers | Colorado | 8099 | 2587 | 48 |
2294812 | 2294812 | 2022-03-11 | Prowers | Colorado | 8099 | 2587 | 48 |
2291560 | 2291560 | 2022-03-10 | Prowers | Colorado | 8099 | 2587 | 48 |
2288308 | 2288308 | 2022-03-09 | Prowers | Colorado | 8099 | 2587 | 48 |
2285057 | 2285057 | 2022-03-08 | Prowers | Colorado | 8099 | 2584 | 48 |
2281805 | 2281805 | 2022-03-07 | Prowers | Colorado | 8099 | 2584 | 48 |
2278552 | 2278552 | 2022-03-06 | Prowers | Colorado | 8099 | 2579 | 48 |
2275299 | 2275299 | 2022-03-05 | Prowers | Colorado | 8099 | 2579 | 48 |
2272046 | 2272046 | 2022-03-04 | Prowers | Colorado | 8099 | 2579 | 48 |
2268794 | 2268794 | 2022-03-03 | Prowers | Colorado | 8099 | 2575 | 48 |
2265541 | 2265541 | 2022-03-02 | Prowers | Colorado | 8099 | 2572 | 48 |
2262290 | 2262290 | 2022-03-01 | Prowers | Colorado | 8099 | 2572 | 48 |
2132151 | 2132151 | 2022-01-20 | Conejos | Colorado | 8021 | 1392 | 48 |
2128898 | 2128898 | 2022-01-19 | Conejos | Colorado | 8021 | 1372 | 48 |
2125644 | 2125644 | 2022-01-18 | Conejos | Colorado | 8021 | 1338 | 48 |
2122392 | 2122392 | 2022-01-17 | Conejos | Colorado | 8021 | 1324 | 48 |
2119140 | 2119140 | 2022-01-16 | Conejos | Colorado | 8021 | 1306 | 48 |
2115888 | 2115888 | 2022-01-15 | Conejos | Colorado | 8021 | 1306 | 48 |
2112637 | 2112637 | 2022-01-14 | Conejos | Colorado | 8021 | 1306 | 48 |
2109385 | 2109385 | 2022-01-13 | Conejos | Colorado | 8021 | 1298 | 48 |
2106134 | 2106134 | 2022-01-12 | Conejos | Colorado | 8021 | 1278 | 48 |
2083404 | 2083404 | 2022-01-05 | Moffat | Colorado | 8081 | 2329 | 48 |
2080152 | 2080152 | 2022-01-04 | Moffat | Colorado | 8081 | 2316 | 48 |
2076900 | 2076900 | 2022-01-03 | Moffat | Colorado | 8081 | 2311 | 48 |
2073649 | 2073649 | 2022-01-02 | Moffat | Colorado | 8081 | 2275 | 48 |
2070398 | 2070398 | 2022-01-01 | Moffat | Colorado | 8081 | 2275 | 48 |
2067147 | 2067147 | 2021-12-31 | Moffat | Colorado | 8081 | 2275 | 48 |
2063896 | 2063896 | 2021-12-30 | Moffat | Colorado | 8081 | 2267 | 48 |
2060646 | 2060646 | 2021-12-29 | Moffat | Colorado | 8081 | 2262 | 48 |
2057397 | 2057397 | 2021-12-28 | Moffat | Colorado | 8081 | 2260 | 48 |
2054148 | 2054148 | 2021-12-27 | Moffat | Colorado | 8081 | 2257 | 48 |
2050898 | 2050898 | 2021-12-26 | Moffat | Colorado | 8081 | 2256 | 48 |
2047648 | 2047648 | 2021-12-25 | Moffat | Colorado | 8081 | 2256 | 48 |
2044398 | 2044398 | 2021-12-24 | Moffat | Colorado | 8081 | 2256 | 48 |
2041149 | 2041149 | 2021-12-23 | Moffat | Colorado | 8081 | 2255 | 48 |
2037899 | 2037899 | 2021-12-22 | Moffat | Colorado | 8081 | 2251 | 48 |
2034649 | 2034649 | 2021-12-21 | Moffat | Colorado | 8081 | 2250 | 48 |
2034668 | 2034668 | 2021-12-21 | Teller | Colorado | 8119 | 3468 | 48 |
2031399 | 2031399 | 2021-12-20 | Moffat | Colorado | 8081 | 2242 | 48 |
2031418 | 2031418 | 2021-12-20 | Teller | Colorado | 8119 | 3464 | 48 |
2028148 | 2028148 | 2021-12-19 | Moffat | Colorado | 8081 | 2237 | 48 |
2028167 | 2028167 | 2021-12-19 | Teller | Colorado | 8119 | 3458 | 48 |
2024897 | 2024897 | 2021-12-18 | Moffat | Colorado | 8081 | 2237 | 48 |
2024916 | 2024916 | 2021-12-18 | Teller | Colorado | 8119 | 3458 | 48 |
2021646 | 2021646 | 2021-12-17 | Moffat | Colorado | 8081 | 2237 | 48 |
2021665 | 2021665 | 2021-12-17 | Teller | Colorado | 8119 | 3458 | 48 |
2018395 | 2018395 | 2021-12-16 | Moffat | Colorado | 8081 | 2235 | 48 |
2018414 | 2018414 | 2021-12-16 | Teller | Colorado | 8119 | 3453 | 48 |
2015145 | 2015145 | 2021-12-15 | Moffat | Colorado | 8081 | 2231 | 48 |
2011894 | 2011894 | 2021-12-14 | Moffat | Colorado | 8081 | 2225 | 48 |
1992390 | 1992390 | 2021-12-08 | Montezuma | Colorado | 8083 | 4019 | 48 |
1989138 | 1989138 | 2021-12-07 | Moffat | Colorado | 8081 | 2196 | 48 |
1989139 | 1989139 | 2021-12-07 | Montezuma | Colorado | 8083 | 3997 | 48 |
1985888 | 1985888 | 2021-12-06 | Moffat | Colorado | 8081 | 2186 | 48 |
1985889 | 1985889 | 2021-12-06 | Montezuma | Colorado | 8083 | 3990 | 48 |
1982639 | 1982639 | 2021-12-05 | Montezuma | Colorado | 8083 | 3947 | 48 |
1979389 | 1979389 | 2021-12-04 | Montezuma | Colorado | 8083 | 3947 | 48 |
1976139 | 1976139 | 2021-12-03 | Montezuma | Colorado | 8083 | 3947 | 48 |
1972890 | 1972890 | 2021-12-02 | Montezuma | Colorado | 8083 | 3939 | 48 |
1969599 | 1969599 | 2021-12-01 | Alamosa | Colorado | 8003 | 2931 | 48 |
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);