ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,303 rows where deaths = 2 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Pitkin 265
- Sedgwick 192
- Saguache 177
- Costilla 159
- Lake 147
- Clear Creek 130
- Elbert 126
- Rio Grande 119
- La Plata 113
- Teller 112
- Garfield 88
- Archuleta 72
- Alamosa 62
- Ouray 51
- Summit 51
- Custer 49
- Kiowa 34
- Montezuma 31
- Rio Blanco 27
- Huerfano 26
- Gilpin 24
- Mineral 24
- Fremont 23
- Broomfield 21
- Kit Carson 21
- Dolores 20
- Delta 18
- Phillips 11
- Pueblo 8
- Yuma 8
- …
state 1
- Colorado · 2,303 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499854 | 2499854 | 2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 |
2499860 | 2499860 | 2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 |
2496596 | 2496596 | 2022-05-12 | Lake | Colorado | 8065 | 1842 | 2 |
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2493338 | 2493338 | 2022-05-11 | Lake | Colorado | 8065 | 1826 | 2 |
2493344 | 2493344 | 2022-05-11 | Mineral | Colorado | 8079 | 237 | 2 |
2490080 | 2490080 | 2022-05-10 | Lake | Colorado | 8065 | 1825 | 2 |
2490086 | 2490086 | 2022-05-10 | Mineral | Colorado | 8079 | 237 | 2 |
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2483565 | 2483565 | 2022-05-08 | Lake | Colorado | 8065 | 1820 | 2 |
2483571 | 2483571 | 2022-05-08 | Mineral | Colorado | 8079 | 233 | 2 |
2480307 | 2480307 | 2022-05-07 | Lake | Colorado | 8065 | 1820 | 2 |
2480313 | 2480313 | 2022-05-07 | Mineral | Colorado | 8079 | 233 | 2 |
2477049 | 2477049 | 2022-05-06 | Lake | Colorado | 8065 | 1820 | 2 |
2477055 | 2477055 | 2022-05-06 | Mineral | Colorado | 8079 | 233 | 2 |
2473791 | 2473791 | 2022-05-05 | Lake | Colorado | 8065 | 1820 | 2 |
2473797 | 2473797 | 2022-05-05 | Mineral | Colorado | 8079 | 233 | 2 |
2470534 | 2470534 | 2022-05-04 | Lake | Colorado | 8065 | 1819 | 2 |
2470540 | 2470540 | 2022-05-04 | Mineral | Colorado | 8079 | 233 | 2 |
2467278 | 2467278 | 2022-05-03 | Lake | Colorado | 8065 | 1820 | 2 |
2467284 | 2467284 | 2022-05-03 | Mineral | Colorado | 8079 | 233 | 2 |
2464023 | 2464023 | 2022-05-02 | Lake | Colorado | 8065 | 1818 | 2 |
2464029 | 2464029 | 2022-05-02 | Mineral | Colorado | 8079 | 233 | 2 |
2460767 | 2460767 | 2022-05-01 | Lake | Colorado | 8065 | 1817 | 2 |
2460773 | 2460773 | 2022-05-01 | Mineral | Colorado | 8079 | 233 | 2 |
2457511 | 2457511 | 2022-04-30 | Lake | Colorado | 8065 | 1817 | 2 |
2457517 | 2457517 | 2022-04-30 | Mineral | Colorado | 8079 | 233 | 2 |
2454255 | 2454255 | 2022-04-29 | Lake | Colorado | 8065 | 1817 | 2 |
2454261 | 2454261 | 2022-04-29 | Mineral | Colorado | 8079 | 233 | 2 |
2450999 | 2450999 | 2022-04-28 | Lake | Colorado | 8065 | 1815 | 2 |
2451005 | 2451005 | 2022-04-28 | Mineral | Colorado | 8079 | 233 | 2 |
2447743 | 2447743 | 2022-04-27 | Lake | Colorado | 8065 | 1814 | 2 |
2447749 | 2447749 | 2022-04-27 | Mineral | Colorado | 8079 | 233 | 2 |
2444487 | 2444487 | 2022-04-26 | Lake | Colorado | 8065 | 1811 | 2 |
2444493 | 2444493 | 2022-04-26 | Mineral | Colorado | 8079 | 233 | 2 |
2441231 | 2441231 | 2022-04-25 | Lake | Colorado | 8065 | 1809 | 2 |
2441237 | 2441237 | 2022-04-25 | Mineral | Colorado | 8079 | 233 | 2 |
2437975 | 2437975 | 2022-04-24 | Lake | Colorado | 8065 | 1808 | 2 |
2437981 | 2437981 | 2022-04-24 | Mineral | Colorado | 8079 | 233 | 2 |
2434719 | 2434719 | 2022-04-23 | Lake | Colorado | 8065 | 1808 | 2 |
2434725 | 2434725 | 2022-04-23 | Mineral | Colorado | 8079 | 233 | 2 |
2431463 | 2431463 | 2022-04-22 | Lake | Colorado | 8065 | 1808 | 2 |
2431469 | 2431469 | 2022-04-22 | Mineral | Colorado | 8079 | 233 | 2 |
2428207 | 2428207 | 2022-04-21 | Lake | Colorado | 8065 | 1804 | 2 |
2428213 | 2428213 | 2022-04-21 | Mineral | Colorado | 8079 | 233 | 2 |
2424951 | 2424951 | 2022-04-20 | Lake | Colorado | 8065 | 1803 | 2 |
2421695 | 2421695 | 2022-04-19 | Lake | Colorado | 8065 | 1799 | 2 |
2418439 | 2418439 | 2022-04-18 | Lake | Colorado | 8065 | 1797 | 2 |
2415183 | 2415183 | 2022-04-17 | Lake | Colorado | 8065 | 1795 | 2 |
2411927 | 2411927 | 2022-04-16 | Lake | Colorado | 8065 | 1795 | 2 |
2408671 | 2408671 | 2022-04-15 | Lake | Colorado | 8065 | 1795 | 2 |
2405415 | 2405415 | 2022-04-14 | Lake | Colorado | 8065 | 1794 | 2 |
2402160 | 2402160 | 2022-04-13 | Lake | Colorado | 8065 | 1793 | 2 |
2398905 | 2398905 | 2022-04-12 | Lake | Colorado | 8065 | 1793 | 2 |
2395650 | 2395650 | 2022-04-11 | Lake | Colorado | 8065 | 1793 | 2 |
2392394 | 2392394 | 2022-04-10 | Lake | Colorado | 8065 | 1792 | 2 |
2389138 | 2389138 | 2022-04-09 | Lake | Colorado | 8065 | 1792 | 2 |
2385883 | 2385883 | 2022-04-08 | Lake | Colorado | 8065 | 1792 | 2 |
2382628 | 2382628 | 2022-04-07 | Lake | Colorado | 8065 | 1790 | 2 |
2379373 | 2379373 | 2022-04-06 | Lake | Colorado | 8065 | 1790 | 2 |
2376119 | 2376119 | 2022-04-05 | Lake | Colorado | 8065 | 1789 | 2 |
2372867 | 2372867 | 2022-04-04 | Lake | Colorado | 8065 | 1789 | 2 |
2369614 | 2369614 | 2022-04-03 | Lake | Colorado | 8065 | 1789 | 2 |
2366361 | 2366361 | 2022-04-02 | Lake | Colorado | 8065 | 1789 | 2 |
2363108 | 2363108 | 2022-04-01 | Lake | Colorado | 8065 | 1789 | 2 |
2359854 | 2359854 | 2022-03-31 | Lake | Colorado | 8065 | 1789 | 2 |
2356600 | 2356600 | 2022-03-30 | Lake | Colorado | 8065 | 1786 | 2 |
2353347 | 2353347 | 2022-03-29 | Lake | Colorado | 8065 | 1787 | 2 |
2350095 | 2350095 | 2022-03-28 | Lake | Colorado | 8065 | 1787 | 2 |
2346842 | 2346842 | 2022-03-27 | Lake | Colorado | 8065 | 1787 | 2 |
2343589 | 2343589 | 2022-03-26 | Lake | Colorado | 8065 | 1787 | 2 |
2340336 | 2340336 | 2022-03-25 | Lake | Colorado | 8065 | 1787 | 2 |
2337083 | 2337083 | 2022-03-24 | Lake | Colorado | 8065 | 1785 | 2 |
2333829 | 2333829 | 2022-03-23 | Lake | Colorado | 8065 | 1784 | 2 |
2330575 | 2330575 | 2022-03-22 | Lake | Colorado | 8065 | 1784 | 2 |
2327323 | 2327323 | 2022-03-21 | Lake | Colorado | 8065 | 1782 | 2 |
2324070 | 2324070 | 2022-03-20 | Lake | Colorado | 8065 | 1780 | 2 |
2320816 | 2320816 | 2022-03-19 | Lake | Colorado | 8065 | 1780 | 2 |
2317562 | 2317562 | 2022-03-18 | Lake | Colorado | 8065 | 1780 | 2 |
2314309 | 2314309 | 2022-03-17 | Lake | Colorado | 8065 | 1780 | 2 |
2311056 | 2311056 | 2022-03-16 | Lake | Colorado | 8065 | 1780 | 2 |
2307803 | 2307803 | 2022-03-15 | Lake | Colorado | 8065 | 1779 | 2 |
2304552 | 2304552 | 2022-03-14 | Lake | Colorado | 8065 | 1779 | 2 |
2301300 | 2301300 | 2022-03-13 | Lake | Colorado | 8065 | 1777 | 2 |
2298048 | 2298048 | 2022-03-12 | Lake | Colorado | 8065 | 1777 | 2 |
2294796 | 2294796 | 2022-03-11 | Lake | Colorado | 8065 | 1777 | 2 |
2291544 | 2291544 | 2022-03-10 | Lake | Colorado | 8065 | 1779 | 2 |
2288292 | 2288292 | 2022-03-09 | Lake | Colorado | 8065 | 1779 | 2 |
2285041 | 2285041 | 2022-03-08 | Lake | Colorado | 8065 | 1778 | 2 |
2281789 | 2281789 | 2022-03-07 | Lake | Colorado | 8065 | 1778 | 2 |
2278536 | 2278536 | 2022-03-06 | Lake | Colorado | 8065 | 1774 | 2 |
2275283 | 2275283 | 2022-03-05 | Lake | Colorado | 8065 | 1774 | 2 |
2272030 | 2272030 | 2022-03-04 | Lake | Colorado | 8065 | 1774 | 2 |
2268778 | 2268778 | 2022-03-03 | Lake | Colorado | 8065 | 1772 | 2 |
2265525 | 2265525 | 2022-03-02 | Lake | Colorado | 8065 | 1772 | 2 |
2262274 | 2262274 | 2022-03-01 | Lake | Colorado | 8065 | 1770 | 2 |
2259023 | 2259023 | 2022-02-28 | Lake | Colorado | 8065 | 1770 | 2 |
2255772 | 2255772 | 2022-02-27 | Lake | Colorado | 8065 | 1770 | 2 |
2252521 | 2252521 | 2022-02-26 | Lake | Colorado | 8065 | 1770 | 2 |
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);