ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

792 rows where county = "Clear Creek" and state = "Colorado" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

  • Colorado · 792 ✖

fips 1

county 1

  • Clear Creek · 792 ✖
Link rowid date ▲ county state fips cases deaths
2499830 2499830 2022-05-13 Clear Creek Colorado 8019 1601 12
2496572 2496572 2022-05-12 Clear Creek Colorado 8019 1599 12
2493314 2493314 2022-05-11 Clear Creek Colorado 8019 1588 12
2490056 2490056 2022-05-10 Clear Creek Colorado 8019 1587 12
2486799 2486799 2022-05-09 Clear Creek Colorado 8019 1587 12
2483541 2483541 2022-05-08 Clear Creek Colorado 8019 1582 12
2480283 2480283 2022-05-07 Clear Creek Colorado 8019 1582 12
2477025 2477025 2022-05-06 Clear Creek Colorado 8019 1582 12
2473767 2473767 2022-05-05 Clear Creek Colorado 8019 1580 12
2470510 2470510 2022-05-04 Clear Creek Colorado 8019 1579 12
2467254 2467254 2022-05-03 Clear Creek Colorado 8019 1578 12
2463999 2463999 2022-05-02 Clear Creek Colorado 8019 1577 12
2460743 2460743 2022-05-01 Clear Creek Colorado 8019 1571 12
2457487 2457487 2022-04-30 Clear Creek Colorado 8019 1571 12
2454231 2454231 2022-04-29 Clear Creek Colorado 8019 1571 12
2450975 2450975 2022-04-28 Clear Creek Colorado 8019 1572 12
2447719 2447719 2022-04-27 Clear Creek Colorado 8019 1570 12
2444463 2444463 2022-04-26 Clear Creek Colorado 8019 1570 12
2441207 2441207 2022-04-25 Clear Creek Colorado 8019 1566 12
2437951 2437951 2022-04-24 Clear Creek Colorado 8019 1566 12
2434695 2434695 2022-04-23 Clear Creek Colorado 8019 1566 12
2431439 2431439 2022-04-22 Clear Creek Colorado 8019 1566 12
2428183 2428183 2022-04-21 Clear Creek Colorado 8019 1566 12
2424927 2424927 2022-04-20 Clear Creek Colorado 8019 1562 12
2421671 2421671 2022-04-19 Clear Creek Colorado 8019 1559 12
2418415 2418415 2022-04-18 Clear Creek Colorado 8019 1559 12
2415159 2415159 2022-04-17 Clear Creek Colorado 8019 1559 12
2411903 2411903 2022-04-16 Clear Creek Colorado 8019 1559 12
2408647 2408647 2022-04-15 Clear Creek Colorado 8019 1559 12
2405391 2405391 2022-04-14 Clear Creek Colorado 8019 1559 12
2402136 2402136 2022-04-13 Clear Creek Colorado 8019 1557 12
2398881 2398881 2022-04-12 Clear Creek Colorado 8019 1553 12
2395626 2395626 2022-04-11 Clear Creek Colorado 8019 1551 12
2392370 2392370 2022-04-10 Clear Creek Colorado 8019 1548 12
2389114 2389114 2022-04-09 Clear Creek Colorado 8019 1548 12
2385859 2385859 2022-04-08 Clear Creek Colorado 8019 1548 12
2382604 2382604 2022-04-07 Clear Creek Colorado 8019 1546 12
2379349 2379349 2022-04-06 Clear Creek Colorado 8019 1544 12
2376095 2376095 2022-04-05 Clear Creek Colorado 8019 1544 12
2372843 2372843 2022-04-04 Clear Creek Colorado 8019 1539 12
2369590 2369590 2022-04-03 Clear Creek Colorado 8019 1535 12
2366337 2366337 2022-04-02 Clear Creek Colorado 8019 1535 12
2363084 2363084 2022-04-01 Clear Creek Colorado 8019 1535 12
2359830 2359830 2022-03-31 Clear Creek Colorado 8019 1533 12
2356576 2356576 2022-03-30 Clear Creek Colorado 8019 1533 12
2353323 2353323 2022-03-29 Clear Creek Colorado 8019 1530 12
2350071 2350071 2022-03-28 Clear Creek Colorado 8019 1526 12
2346818 2346818 2022-03-27 Clear Creek Colorado 8019 1520 12
2343565 2343565 2022-03-26 Clear Creek Colorado 8019 1520 12
2340312 2340312 2022-03-25 Clear Creek Colorado 8019 1520 12
2337059 2337059 2022-03-24 Clear Creek Colorado 8019 1518 12
2333805 2333805 2022-03-23 Clear Creek Colorado 8019 1517 12
2330551 2330551 2022-03-22 Clear Creek Colorado 8019 1516 12
2327299 2327299 2022-03-21 Clear Creek Colorado 8019 1515 12
2324046 2324046 2022-03-20 Clear Creek Colorado 8019 1512 11
2320792 2320792 2022-03-19 Clear Creek Colorado 8019 1512 11
2317538 2317538 2022-03-18 Clear Creek Colorado 8019 1512 11
2314285 2314285 2022-03-17 Clear Creek Colorado 8019 1512 11
2311032 2311032 2022-03-16 Clear Creek Colorado 8019 1510 11
2307779 2307779 2022-03-15 Clear Creek Colorado 8019 1509 11
2304528 2304528 2022-03-14 Clear Creek Colorado 8019 1505 11
2301276 2301276 2022-03-13 Clear Creek Colorado 8019 1505 11
2298024 2298024 2022-03-12 Clear Creek Colorado 8019 1505 11
2294772 2294772 2022-03-11 Clear Creek Colorado 8019 1505 11
2291520 2291520 2022-03-10 Clear Creek Colorado 8019 1503 11
2288268 2288268 2022-03-09 Clear Creek Colorado 8019 1503 11
2285017 2285017 2022-03-08 Clear Creek Colorado 8019 1502 11
2281765 2281765 2022-03-07 Clear Creek Colorado 8019 1502 11
2278512 2278512 2022-03-06 Clear Creek Colorado 8019 1499 11
2275259 2275259 2022-03-05 Clear Creek Colorado 8019 1499 11
2272006 2272006 2022-03-04 Clear Creek Colorado 8019 1499 11
2268754 2268754 2022-03-03 Clear Creek Colorado 8019 1496 11
2265501 2265501 2022-03-02 Clear Creek Colorado 8019 1496 11
2262250 2262250 2022-03-01 Clear Creek Colorado 8019 1493 11
2258999 2258999 2022-02-28 Clear Creek Colorado 8019 1493 11
2255748 2255748 2022-02-27 Clear Creek Colorado 8019 1493 11
2252497 2252497 2022-02-26 Clear Creek Colorado 8019 1493 11
2249246 2249246 2022-02-25 Clear Creek Colorado 8019 1493 11
2245995 2245995 2022-02-24 Clear Creek Colorado 8019 1491 11
2242744 2242744 2022-02-23 Clear Creek Colorado 8019 1491 11
2239493 2239493 2022-02-22 Clear Creek Colorado 8019 1489 11
2236242 2236242 2022-02-21 Clear Creek Colorado 8019 1489 11
2232991 2232991 2022-02-20 Clear Creek Colorado 8019 1487 11
2229740 2229740 2022-02-19 Clear Creek Colorado 8019 1487 11
2226489 2226489 2022-02-18 Clear Creek Colorado 8019 1487 11
2223238 2223238 2022-02-17 Clear Creek Colorado 8019 1487 11
2219987 2219987 2022-02-16 Clear Creek Colorado 8019 1487 11
2216736 2216736 2022-02-15 Clear Creek Colorado 8019 1487 11
2213485 2213485 2022-02-14 Clear Creek Colorado 8019 1484 11
2210233 2210233 2022-02-13 Clear Creek Colorado 8019 1481 10
2206980 2206980 2022-02-12 Clear Creek Colorado 8019 1481 10
2203727 2203727 2022-02-11 Clear Creek Colorado 8019 1481 10
2200474 2200474 2022-02-10 Clear Creek Colorado 8019 1479 10
2197220 2197220 2022-02-09 Clear Creek Colorado 8019 1474 10
2193966 2193966 2022-02-08 Clear Creek Colorado 8019 1472 10
2190712 2190712 2022-02-07 Clear Creek Colorado 8019 1468 10
2187459 2187459 2022-02-06 Clear Creek Colorado 8019 1466 10
2184206 2184206 2022-02-05 Clear Creek Colorado 8019 1466 10
2180954 2180954 2022-02-04 Clear Creek Colorado 8019 1466 10
2177703 2177703 2022-02-03 Clear Creek Colorado 8019 1463 10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);