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

782 rows where county = "La Plata" 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 · 782 ✖

fips 1

county 1

  • La Plata · 782 ✖
Link rowid date ▲ county state fips cases deaths
2499853 2499853 2022-05-13 La Plata Colorado 8067 13002 86
2496595 2496595 2022-05-12 La Plata Colorado 8067 12990 86
2493337 2493337 2022-05-11 La Plata Colorado 8067 12945 86
2490079 2490079 2022-05-10 La Plata Colorado 8067 12943 86
2486822 2486822 2022-05-09 La Plata Colorado 8067 12941 86
2483564 2483564 2022-05-08 La Plata Colorado 8067 12927 86
2480306 2480306 2022-05-07 La Plata Colorado 8067 12927 86
2477048 2477048 2022-05-06 La Plata Colorado 8067 12927 86
2473790 2473790 2022-05-05 La Plata Colorado 8067 12918 86
2470533 2470533 2022-05-04 La Plata Colorado 8067 12907 86
2467277 2467277 2022-05-03 La Plata Colorado 8067 12900 86
2464022 2464022 2022-05-02 La Plata Colorado 8067 12893 82
2460766 2460766 2022-05-01 La Plata Colorado 8067 12878 82
2457510 2457510 2022-04-30 La Plata Colorado 8067 12878 82
2454254 2454254 2022-04-29 La Plata Colorado 8067 12878 82
2450998 2450998 2022-04-28 La Plata Colorado 8067 12870 82
2447742 2447742 2022-04-27 La Plata Colorado 8067 12862 82
2444486 2444486 2022-04-26 La Plata Colorado 8067 12857 82
2441230 2441230 2022-04-25 La Plata Colorado 8067 12856 82
2437974 2437974 2022-04-24 La Plata Colorado 8067 12847 82
2434718 2434718 2022-04-23 La Plata Colorado 8067 12847 82
2431462 2431462 2022-04-22 La Plata Colorado 8067 12847 82
2428206 2428206 2022-04-21 La Plata Colorado 8067 12837 81
2424950 2424950 2022-04-20 La Plata Colorado 8067 12826 81
2421694 2421694 2022-04-19 La Plata Colorado 8067 12812 81
2418438 2418438 2022-04-18 La Plata Colorado 8067 12803 81
2415182 2415182 2022-04-17 La Plata Colorado 8067 12793 81
2411926 2411926 2022-04-16 La Plata Colorado 8067 12793 81
2408670 2408670 2022-04-15 La Plata Colorado 8067 12793 81
2405414 2405414 2022-04-14 La Plata Colorado 8067 12788 81
2402159 2402159 2022-04-13 La Plata Colorado 8067 12775 80
2398904 2398904 2022-04-12 La Plata Colorado 8067 12767 80
2395649 2395649 2022-04-11 La Plata Colorado 8067 12765 80
2392393 2392393 2022-04-10 La Plata Colorado 8067 12742 80
2389137 2389137 2022-04-09 La Plata Colorado 8067 12742 80
2385882 2385882 2022-04-08 La Plata Colorado 8067 12742 80
2382627 2382627 2022-04-07 La Plata Colorado 8067 12729 80
2379372 2379372 2022-04-06 La Plata Colorado 8067 12720 80
2376118 2376118 2022-04-05 La Plata Colorado 8067 12714 80
2372866 2372866 2022-04-04 La Plata Colorado 8067 12707 80
2369613 2369613 2022-04-03 La Plata Colorado 8067 12689 80
2366360 2366360 2022-04-02 La Plata Colorado 8067 12689 80
2363107 2363107 2022-04-01 La Plata Colorado 8067 12689 80
2359853 2359853 2022-03-31 La Plata Colorado 8067 12683 80
2356599 2356599 2022-03-30 La Plata Colorado 8067 12666 80
2353346 2353346 2022-03-29 La Plata Colorado 8067 12672 80
2350094 2350094 2022-03-28 La Plata Colorado 8067 12662 80
2346841 2346841 2022-03-27 La Plata Colorado 8067 12644 80
2343588 2343588 2022-03-26 La Plata Colorado 8067 12644 80
2340335 2340335 2022-03-25 La Plata Colorado 8067 12644 80
2337082 2337082 2022-03-24 La Plata Colorado 8067 12634 80
2333828 2333828 2022-03-23 La Plata Colorado 8067 12631 80
2330574 2330574 2022-03-22 La Plata Colorado 8067 12624 80
2327322 2327322 2022-03-21 La Plata Colorado 8067 12615 80
2324069 2324069 2022-03-20 La Plata Colorado 8067 12586 80
2320815 2320815 2022-03-19 La Plata Colorado 8067 12586 80
2317561 2317561 2022-03-18 La Plata Colorado 8067 12586 80
2314308 2314308 2022-03-17 La Plata Colorado 8067 12586 80
2311055 2311055 2022-03-16 La Plata Colorado 8067 12583 80
2307802 2307802 2022-03-15 La Plata Colorado 8067 12580 80
2304551 2304551 2022-03-14 La Plata Colorado 8067 12569 80
2301299 2301299 2022-03-13 La Plata Colorado 8067 12558 80
2298047 2298047 2022-03-12 La Plata Colorado 8067 12558 80
2294795 2294795 2022-03-11 La Plata Colorado 8067 12558 80
2291543 2291543 2022-03-10 La Plata Colorado 8067 12560 80
2288291 2288291 2022-03-09 La Plata Colorado 8067 12551 80
2285040 2285040 2022-03-08 La Plata Colorado 8067 12550 80
2281788 2281788 2022-03-07 La Plata Colorado 8067 12544 80
2278535 2278535 2022-03-06 La Plata Colorado 8067 12399 80
2275282 2275282 2022-03-05 La Plata Colorado 8067 12399 80
2272029 2272029 2022-03-04 La Plata Colorado 8067 12399 80
2268777 2268777 2022-03-03 La Plata Colorado 8067 12387 80
2265524 2265524 2022-03-02 La Plata Colorado 8067 12383 80
2262273 2262273 2022-03-01 La Plata Colorado 8067 12386 80
2259022 2259022 2022-02-28 La Plata Colorado 8067 12379 80
2255771 2255771 2022-02-27 La Plata Colorado 8067 12356 80
2252520 2252520 2022-02-26 La Plata Colorado 8067 12356 80
2249269 2249269 2022-02-25 La Plata Colorado 8067 12356 80
2246018 2246018 2022-02-24 La Plata Colorado 8067 12348 80
2242767 2242767 2022-02-23 La Plata Colorado 8067 12337 80
2239516 2239516 2022-02-22 La Plata Colorado 8067 12310 80
2236265 2236265 2022-02-21 La Plata Colorado 8067 12300 80
2233014 2233014 2022-02-20 La Plata Colorado 8067 12284 80
2229763 2229763 2022-02-19 La Plata Colorado 8067 12284 80
2226512 2226512 2022-02-18 La Plata Colorado 8067 12284 80
2223261 2223261 2022-02-17 La Plata Colorado 8067 12258 80
2220010 2220010 2022-02-16 La Plata Colorado 8067 12234 79
2216759 2216759 2022-02-15 La Plata Colorado 8067 12208 79
2213508 2213508 2022-02-14 La Plata Colorado 8067 12178 78
2210256 2210256 2022-02-13 La Plata Colorado 8067 12118 78
2207003 2207003 2022-02-12 La Plata Colorado 8067 12118 78
2203750 2203750 2022-02-11 La Plata Colorado 8067 12118 78
2200497 2200497 2022-02-10 La Plata Colorado 8067 12083 77
2197243 2197243 2022-02-09 La Plata Colorado 8067 12032 77
2193989 2193989 2022-02-08 La Plata Colorado 8067 11982 76
2190735 2190735 2022-02-07 La Plata Colorado 8067 11940 75
2187482 2187482 2022-02-06 La Plata Colorado 8067 11865 73
2184229 2184229 2022-02-05 La Plata Colorado 8067 11865 73
2180977 2180977 2022-02-04 La Plata Colorado 8067 11865 73
2177726 2177726 2022-02-03 La Plata Colorado 8067 11814 73

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