ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 8055 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499848 | 2499848 | 2022-05-13 | Huerfano | Colorado | 8055 | 1452 | 35 |
2496590 | 2496590 | 2022-05-12 | Huerfano | Colorado | 8055 | 1451 | 35 |
2493332 | 2493332 | 2022-05-11 | Huerfano | Colorado | 8055 | 1449 | 35 |
2490074 | 2490074 | 2022-05-10 | Huerfano | Colorado | 8055 | 1449 | 35 |
2486817 | 2486817 | 2022-05-09 | Huerfano | Colorado | 8055 | 1449 | 35 |
2483559 | 2483559 | 2022-05-08 | Huerfano | Colorado | 8055 | 1448 | 35 |
2480301 | 2480301 | 2022-05-07 | Huerfano | Colorado | 8055 | 1448 | 35 |
2477043 | 2477043 | 2022-05-06 | Huerfano | Colorado | 8055 | 1448 | 35 |
2473785 | 2473785 | 2022-05-05 | Huerfano | Colorado | 8055 | 1448 | 35 |
2470528 | 2470528 | 2022-05-04 | Huerfano | Colorado | 8055 | 1448 | 35 |
2467272 | 2467272 | 2022-05-03 | Huerfano | Colorado | 8055 | 1448 | 35 |
2464017 | 2464017 | 2022-05-02 | Huerfano | Colorado | 8055 | 1448 | 33 |
2460761 | 2460761 | 2022-05-01 | Huerfano | Colorado | 8055 | 1448 | 33 |
2457505 | 2457505 | 2022-04-30 | Huerfano | Colorado | 8055 | 1448 | 33 |
2454249 | 2454249 | 2022-04-29 | Huerfano | Colorado | 8055 | 1448 | 33 |
2450993 | 2450993 | 2022-04-28 | Huerfano | Colorado | 8055 | 1445 | 33 |
2447737 | 2447737 | 2022-04-27 | Huerfano | Colorado | 8055 | 1445 | 33 |
2444481 | 2444481 | 2022-04-26 | Huerfano | Colorado | 8055 | 1445 | 33 |
2441225 | 2441225 | 2022-04-25 | Huerfano | Colorado | 8055 | 1445 | 33 |
2437969 | 2437969 | 2022-04-24 | Huerfano | Colorado | 8055 | 1443 | 32 |
2434713 | 2434713 | 2022-04-23 | Huerfano | Colorado | 8055 | 1443 | 32 |
2431457 | 2431457 | 2022-04-22 | Huerfano | Colorado | 8055 | 1443 | 32 |
2428201 | 2428201 | 2022-04-21 | Huerfano | Colorado | 8055 | 1443 | 32 |
2424945 | 2424945 | 2022-04-20 | Huerfano | Colorado | 8055 | 1443 | 31 |
2421689 | 2421689 | 2022-04-19 | Huerfano | Colorado | 8055 | 1443 | 31 |
2418433 | 2418433 | 2022-04-18 | Huerfano | Colorado | 8055 | 1443 | 31 |
2415177 | 2415177 | 2022-04-17 | Huerfano | Colorado | 8055 | 1443 | 31 |
2411921 | 2411921 | 2022-04-16 | Huerfano | Colorado | 8055 | 1443 | 31 |
2408665 | 2408665 | 2022-04-15 | Huerfano | Colorado | 8055 | 1443 | 31 |
2405409 | 2405409 | 2022-04-14 | Huerfano | Colorado | 8055 | 1443 | 31 |
2402154 | 2402154 | 2022-04-13 | Huerfano | Colorado | 8055 | 1443 | 31 |
2398899 | 2398899 | 2022-04-12 | Huerfano | Colorado | 8055 | 1442 | 31 |
2395644 | 2395644 | 2022-04-11 | Huerfano | Colorado | 8055 | 1442 | 31 |
2392388 | 2392388 | 2022-04-10 | Huerfano | Colorado | 8055 | 1440 | 31 |
2389132 | 2389132 | 2022-04-09 | Huerfano | Colorado | 8055 | 1440 | 31 |
2385877 | 2385877 | 2022-04-08 | Huerfano | Colorado | 8055 | 1440 | 31 |
2382622 | 2382622 | 2022-04-07 | Huerfano | Colorado | 8055 | 1439 | 31 |
2379367 | 2379367 | 2022-04-06 | Huerfano | Colorado | 8055 | 1439 | 31 |
2376113 | 2376113 | 2022-04-05 | Huerfano | Colorado | 8055 | 1439 | 31 |
2372861 | 2372861 | 2022-04-04 | Huerfano | Colorado | 8055 | 1440 | 31 |
2369608 | 2369608 | 2022-04-03 | Huerfano | Colorado | 8055 | 1439 | 31 |
2366355 | 2366355 | 2022-04-02 | Huerfano | Colorado | 8055 | 1439 | 31 |
2363102 | 2363102 | 2022-04-01 | Huerfano | Colorado | 8055 | 1439 | 31 |
2359848 | 2359848 | 2022-03-31 | Huerfano | Colorado | 8055 | 1438 | 31 |
2356594 | 2356594 | 2022-03-30 | Huerfano | Colorado | 8055 | 1437 | 31 |
2353341 | 2353341 | 2022-03-29 | Huerfano | Colorado | 8055 | 1438 | 31 |
2350089 | 2350089 | 2022-03-28 | Huerfano | Colorado | 8055 | 1437 | 31 |
2346836 | 2346836 | 2022-03-27 | Huerfano | Colorado | 8055 | 1437 | 31 |
2343583 | 2343583 | 2022-03-26 | Huerfano | Colorado | 8055 | 1437 | 31 |
2340330 | 2340330 | 2022-03-25 | Huerfano | Colorado | 8055 | 1437 | 31 |
2337077 | 2337077 | 2022-03-24 | Huerfano | Colorado | 8055 | 1438 | 31 |
2333823 | 2333823 | 2022-03-23 | Huerfano | Colorado | 8055 | 1435 | 31 |
2330569 | 2330569 | 2022-03-22 | Huerfano | Colorado | 8055 | 1433 | 31 |
2327317 | 2327317 | 2022-03-21 | Huerfano | Colorado | 8055 | 1433 | 31 |
2324064 | 2324064 | 2022-03-20 | Huerfano | Colorado | 8055 | 1430 | 31 |
2320810 | 2320810 | 2022-03-19 | Huerfano | Colorado | 8055 | 1430 | 31 |
2317556 | 2317556 | 2022-03-18 | Huerfano | Colorado | 8055 | 1430 | 31 |
2314303 | 2314303 | 2022-03-17 | Huerfano | Colorado | 8055 | 1430 | 31 |
2311050 | 2311050 | 2022-03-16 | Huerfano | Colorado | 8055 | 1430 | 31 |
2307797 | 2307797 | 2022-03-15 | Huerfano | Colorado | 8055 | 1430 | 31 |
2304546 | 2304546 | 2022-03-14 | Huerfano | Colorado | 8055 | 1427 | 31 |
2301294 | 2301294 | 2022-03-13 | Huerfano | Colorado | 8055 | 1427 | 31 |
2298042 | 2298042 | 2022-03-12 | Huerfano | Colorado | 8055 | 1427 | 31 |
2294790 | 2294790 | 2022-03-11 | Huerfano | Colorado | 8055 | 1427 | 31 |
2291538 | 2291538 | 2022-03-10 | Huerfano | Colorado | 8055 | 1427 | 31 |
2288286 | 2288286 | 2022-03-09 | Huerfano | Colorado | 8055 | 1427 | 31 |
2285035 | 2285035 | 2022-03-08 | Huerfano | Colorado | 8055 | 1428 | 31 |
2281783 | 2281783 | 2022-03-07 | Huerfano | Colorado | 8055 | 1426 | 31 |
2278530 | 2278530 | 2022-03-06 | Huerfano | Colorado | 8055 | 1405 | 31 |
2275277 | 2275277 | 2022-03-05 | Huerfano | Colorado | 8055 | 1405 | 31 |
2272024 | 2272024 | 2022-03-04 | Huerfano | Colorado | 8055 | 1405 | 31 |
2268772 | 2268772 | 2022-03-03 | Huerfano | Colorado | 8055 | 1404 | 31 |
2265519 | 2265519 | 2022-03-02 | Huerfano | Colorado | 8055 | 1403 | 31 |
2262268 | 2262268 | 2022-03-01 | Huerfano | Colorado | 8055 | 1402 | 31 |
2259017 | 2259017 | 2022-02-28 | Huerfano | Colorado | 8055 | 1399 | 31 |
2255766 | 2255766 | 2022-02-27 | Huerfano | Colorado | 8055 | 1400 | 30 |
2252515 | 2252515 | 2022-02-26 | Huerfano | Colorado | 8055 | 1400 | 30 |
2249264 | 2249264 | 2022-02-25 | Huerfano | Colorado | 8055 | 1400 | 30 |
2246013 | 2246013 | 2022-02-24 | Huerfano | Colorado | 8055 | 1398 | 30 |
2242762 | 2242762 | 2022-02-23 | Huerfano | Colorado | 8055 | 1396 | 30 |
2239511 | 2239511 | 2022-02-22 | Huerfano | Colorado | 8055 | 1395 | 29 |
2236260 | 2236260 | 2022-02-21 | Huerfano | Colorado | 8055 | 1392 | 29 |
2233009 | 2233009 | 2022-02-20 | Huerfano | Colorado | 8055 | 1389 | 29 |
2229758 | 2229758 | 2022-02-19 | Huerfano | Colorado | 8055 | 1389 | 29 |
2226507 | 2226507 | 2022-02-18 | Huerfano | Colorado | 8055 | 1389 | 29 |
2223256 | 2223256 | 2022-02-17 | Huerfano | Colorado | 8055 | 1389 | 29 |
2220005 | 2220005 | 2022-02-16 | Huerfano | Colorado | 8055 | 1378 | 29 |
2216754 | 2216754 | 2022-02-15 | Huerfano | Colorado | 8055 | 1373 | 28 |
2213503 | 2213503 | 2022-02-14 | Huerfano | Colorado | 8055 | 1372 | 28 |
2210251 | 2210251 | 2022-02-13 | Huerfano | Colorado | 8055 | 1354 | 28 |
2206998 | 2206998 | 2022-02-12 | Huerfano | Colorado | 8055 | 1354 | 28 |
2203745 | 2203745 | 2022-02-11 | Huerfano | Colorado | 8055 | 1354 | 28 |
2200492 | 2200492 | 2022-02-10 | Huerfano | Colorado | 8055 | 1347 | 28 |
2197238 | 2197238 | 2022-02-09 | Huerfano | Colorado | 8055 | 1337 | 28 |
2193984 | 2193984 | 2022-02-08 | Huerfano | Colorado | 8055 | 1328 | 28 |
2190730 | 2190730 | 2022-02-07 | Huerfano | Colorado | 8055 | 1322 | 28 |
2187477 | 2187477 | 2022-02-06 | Huerfano | Colorado | 8055 | 1319 | 28 |
2184224 | 2184224 | 2022-02-05 | Huerfano | Colorado | 8055 | 1319 | 28 |
2180972 | 2180972 | 2022-02-04 | Huerfano | Colorado | 8055 | 1319 | 28 |
2177721 | 2177721 | 2022-02-03 | Huerfano | Colorado | 8055 | 1315 | 28 |
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);