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

784 rows where fips = 8039 and state = "Colorado" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Colorado · 784 ✖

fips 1

  • 8039 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499841 2499841 2022-05-13 Elbert Colorado 8039 4880 40
2496583 2496583 2022-05-12 Elbert Colorado 8039 4874 40
2493325 2493325 2022-05-11 Elbert Colorado 8039 4834 40
2490067 2490067 2022-05-10 Elbert Colorado 8039 4831 40
2486810 2486810 2022-05-09 Elbert Colorado 8039 4826 40
2483552 2483552 2022-05-08 Elbert Colorado 8039 4824 40
2480294 2480294 2022-05-07 Elbert Colorado 8039 4824 40
2477036 2477036 2022-05-06 Elbert Colorado 8039 4824 40
2473778 2473778 2022-05-05 Elbert Colorado 8039 4822 40
2470521 2470521 2022-05-04 Elbert Colorado 8039 4817 40
2467265 2467265 2022-05-03 Elbert Colorado 8039 4816 40
2464010 2464010 2022-05-02 Elbert Colorado 8039 4814 39
2460754 2460754 2022-05-01 Elbert Colorado 8039 4813 39
2457498 2457498 2022-04-30 Elbert Colorado 8039 4813 39
2454242 2454242 2022-04-29 Elbert Colorado 8039 4813 39
2450986 2450986 2022-04-28 Elbert Colorado 8039 4813 39
2447730 2447730 2022-04-27 Elbert Colorado 8039 4810 39
2444474 2444474 2022-04-26 Elbert Colorado 8039 4809 39
2441218 2441218 2022-04-25 Elbert Colorado 8039 4806 39
2437962 2437962 2022-04-24 Elbert Colorado 8039 4800 39
2434706 2434706 2022-04-23 Elbert Colorado 8039 4800 39
2431450 2431450 2022-04-22 Elbert Colorado 8039 4800 39
2428194 2428194 2022-04-21 Elbert Colorado 8039 4798 39
2424938 2424938 2022-04-20 Elbert Colorado 8039 4793 37
2421682 2421682 2022-04-19 Elbert Colorado 8039 4785 37
2418426 2418426 2022-04-18 Elbert Colorado 8039 4785 37
2415170 2415170 2022-04-17 Elbert Colorado 8039 4775 37
2411914 2411914 2022-04-16 Elbert Colorado 8039 4775 37
2408658 2408658 2022-04-15 Elbert Colorado 8039 4775 37
2405402 2405402 2022-04-14 Elbert Colorado 8039 4770 37
2402147 2402147 2022-04-13 Elbert Colorado 8039 4764 37
2398892 2398892 2022-04-12 Elbert Colorado 8039 4763 37
2395637 2395637 2022-04-11 Elbert Colorado 8039 4762 37
2392381 2392381 2022-04-10 Elbert Colorado 8039 4752 37
2389125 2389125 2022-04-09 Elbert Colorado 8039 4752 37
2385870 2385870 2022-04-08 Elbert Colorado 8039 4752 37
2382615 2382615 2022-04-07 Elbert Colorado 8039 4748 37
2379360 2379360 2022-04-06 Elbert Colorado 8039 4745 37
2376106 2376106 2022-04-05 Elbert Colorado 8039 4741 37
2372854 2372854 2022-04-04 Elbert Colorado 8039 4740 37
2369601 2369601 2022-04-03 Elbert Colorado 8039 4739 37
2366348 2366348 2022-04-02 Elbert Colorado 8039 4739 37
2363095 2363095 2022-04-01 Elbert Colorado 8039 4739 37
2359841 2359841 2022-03-31 Elbert Colorado 8039 4734 37
2356587 2356587 2022-03-30 Elbert Colorado 8039 4729 37
2353334 2353334 2022-03-29 Elbert Colorado 8039 4723 37
2350082 2350082 2022-03-28 Elbert Colorado 8039 4718 37
2346829 2346829 2022-03-27 Elbert Colorado 8039 4716 37
2343576 2343576 2022-03-26 Elbert Colorado 8039 4716 37
2340323 2340323 2022-03-25 Elbert Colorado 8039 4716 37
2337070 2337070 2022-03-24 Elbert Colorado 8039 4715 37
2333816 2333816 2022-03-23 Elbert Colorado 8039 4712 37
2330562 2330562 2022-03-22 Elbert Colorado 8039 4708 37
2327310 2327310 2022-03-21 Elbert Colorado 8039 4703 37
2324057 2324057 2022-03-20 Elbert Colorado 8039 4689 37
2320803 2320803 2022-03-19 Elbert Colorado 8039 4689 37
2317549 2317549 2022-03-18 Elbert Colorado 8039 4689 37
2314296 2314296 2022-03-17 Elbert Colorado 8039 4689 37
2311043 2311043 2022-03-16 Elbert Colorado 8039 4687 37
2307790 2307790 2022-03-15 Elbert Colorado 8039 4683 37
2304539 2304539 2022-03-14 Elbert Colorado 8039 4680 37
2301287 2301287 2022-03-13 Elbert Colorado 8039 4676 37
2298035 2298035 2022-03-12 Elbert Colorado 8039 4676 37
2294783 2294783 2022-03-11 Elbert Colorado 8039 4676 37
2291531 2291531 2022-03-10 Elbert Colorado 8039 4676 37
2288279 2288279 2022-03-09 Elbert Colorado 8039 4674 37
2285028 2285028 2022-03-08 Elbert Colorado 8039 4674 37
2281776 2281776 2022-03-07 Elbert Colorado 8039 4670 37
2278523 2278523 2022-03-06 Elbert Colorado 8039 4664 37
2275270 2275270 2022-03-05 Elbert Colorado 8039 4664 37
2272017 2272017 2022-03-04 Elbert Colorado 8039 4664 37
2268765 2268765 2022-03-03 Elbert Colorado 8039 4658 37
2265512 2265512 2022-03-02 Elbert Colorado 8039 4660 37
2262261 2262261 2022-03-01 Elbert Colorado 8039 4656 37
2259010 2259010 2022-02-28 Elbert Colorado 8039 4650 37
2255759 2255759 2022-02-27 Elbert Colorado 8039 4647 36
2252508 2252508 2022-02-26 Elbert Colorado 8039 4647 36
2249257 2249257 2022-02-25 Elbert Colorado 8039 4647 36
2246006 2246006 2022-02-24 Elbert Colorado 8039 4641 36
2242755 2242755 2022-02-23 Elbert Colorado 8039 4639 37
2239504 2239504 2022-02-22 Elbert Colorado 8039 4627 36
2236253 2236253 2022-02-21 Elbert Colorado 8039 4622 36
2233002 2233002 2022-02-20 Elbert Colorado 8039 4594 36
2229751 2229751 2022-02-19 Elbert Colorado 8039 4594 36
2226500 2226500 2022-02-18 Elbert Colorado 8039 4594 36
2223249 2223249 2022-02-17 Elbert Colorado 8039 4588 36
2219998 2219998 2022-02-16 Elbert Colorado 8039 4579 36
2216747 2216747 2022-02-15 Elbert Colorado 8039 4574 36
2213496 2213496 2022-02-14 Elbert Colorado 8039 4567 36
2210244 2210244 2022-02-13 Elbert Colorado 8039 4554 35
2206991 2206991 2022-02-12 Elbert Colorado 8039 4554 35
2203738 2203738 2022-02-11 Elbert Colorado 8039 4554 35
2200485 2200485 2022-02-10 Elbert Colorado 8039 4548 35
2197231 2197231 2022-02-09 Elbert Colorado 8039 4541 35
2193977 2193977 2022-02-08 Elbert Colorado 8039 4534 34
2190723 2190723 2022-02-07 Elbert Colorado 8039 4518 34
2187470 2187470 2022-02-06 Elbert Colorado 8039 4501 33
2184217 2184217 2022-02-05 Elbert Colorado 8039 4501 33
2180965 2180965 2022-02-04 Elbert Colorado 8039 4501 33
2177714 2177714 2022-02-03 Elbert Colorado 8039 4489 33

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