ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Pitkin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 530 ✖
- 57 17
- 54 8
- 51 7
- 59 6
- 190 6
- 2579 6
- 2606 6
- 11 5
- 58 5
- 204 5
- 223 5
- 2602 5
- 39 4
- 49 4
- 61 4
- 80 4
- 2585 4
- 2604 4
- 2622 4
- 3290 4
- 6282 4
- 6611 4
- 6620 4
- 38 3
- 56 3
- 65 3
- 191 3
- 197 3
- 202 3
- 298 3
- 1818 3
- 2558 3
- 2587 3
- 2589 3
- 2591 3
- 2600 3
- 2612 3
- 2637 3
- 2650 3
- 2682 3
- 2707 3
- 2730 3
- 2757 3
- 2805 3
- 2847 3
- 2888 3
- 2938 3
- 2975 3
- 3008 3
- 3045 3
- 3077 3
- 3111 3
- 3143 3
- 3176 3
- 3212 3
- 3272 3
- 3321 3
- 3334 3
- 3367 3
- 3647 3
- 4161 3
- 4718 3
- 5531 3
- 5789 3
- 5993 3
- 6063 3
- 6147 3
- 6192 3
- 6226 3
- 6259 3
- 6351 3
- 6394 3
- 6442 3
- 6484 3
- 6551 3
- 10 2
- 15 2
- 18 2
- 62 2
- 63 2
- 93 2
- 99 2
- 102 2
- 105 2
- 132 2
- 148 2
- 150 2
- 153 2
- 160 2
- 162 2
- 168 2
- 187 2
- 192 2
- 193 2
- 195 2
- 196 2
- 199 2
- 201 2
- 213 2
- 217 2
- 219 2
- 221 2
- 226 2
- 227 2
- 255 2
- 271 2
- 682 2
- 1195 2
- 1761 2
- 1962 2
- 2084 2
- 2493 2
- 2525 2
- 2561 2
- 2575 2
- 2578 2
- 2586 2
- 2594 2
- 2595 2
- 2598 2
- 2601 2
- 2605 2
- 2635 2
- 2640 2
- 2662 2
- 2704 2
- 2745 2
- 3310 2
- 3323 2
- 5912 2
- 5924 2
- 6032 2
- 6617 2
- 9 1
- 12 1
- 16 1
- 21 1
- 23 1
- 25 1
- 26 1
- 27 1
- 29 1
- 30 1
- 33 1
- 36 1
- 47 1
- 52 1
- 53 1
- 60 1
- 64 1
- 67 1
- 72 1
- 75 1
- 78 1
- 85 1
- 86 1
- 91 1
- 92 1
- 94 1
- 104 1
- 108 1
- 111 1
- 117 1
- 124 1
- 130 1
- 138 1
- 140 1
- 144 1
- 151 1
- 154 1
- 155 1
- 158 1
- 166 1
- 172 1
- 177 1
- 180 1
- 181 1
- 182 1
- 186 1
- 188 1
- 198 1
- 205 1
- 208 1
- 215 1
- 222 1
- 225 1
- 229 1
- 230 1
- 234 1
- 236 1
- 237 1
- 239 1
- 242 1
- 248 1
- 250 1
- 253 1
- 256 1
- 258 1
- 259 1
- 261 1
- 276 1
- 277 1
- 278 1
- 287 1
- 288 1
- 291 1
- 293 1
- 302 1
- 306 1
- 313 1
- 319 1
- 323 1
- 324 1
- 327 1
- 334 1
- 346 1
- 349 1
- 354 1
- 370 1
- 374 1
- 379 1
- 395 1
- 399 1
- 413 1
- 420 1
- 421 1
- 425 1
- 432 1
- 442 1
- 447 1
- 458 1
- 467 1
- 477 1
- 494 1
- 501 1
- 513 1
- 530 1
- 556 1
- 569 1
- 579 1
- 584 1
- 591 1
- 599 1
- 619 1
- 636 1
- 653 1
- 669 1
- 705 1
- 726 1
- 731 1
- 779 1
- 819 1
- 838 1
- 856 1
- 883 1
- 890 1
- 906 1
- 924 1
- 925 1
- 971 1
- 998 1
- 1025 1
- 1042 1
- 1045 1
- 1047 1
- 1063 1
- 1148 1
- 1180 1
- 1266 1
- 1344 1
- 1395 1
- 1435 1
- 1462 1
- 1490 1
- 1520 1
- 1546 1
- 1605 1
- 1651 1
- 1673 1
- 1693 1
- 1698 1
- 1720 1
- 1732 1
- 1748 1
- 1755 1
- 1795 1
- 1809 1
- 1812 1
- 1834 1
- 1845 1
- 1846 1
- 1855 1
- 1865 1
- 1875 1
- 1879 1
- 1881 1
- 1883 1
- 1886 1
- 1895 1
- 1904 1
- 1905 1
- 1907 1
- 1914 1
- 1919 1
- 1920 1
- 1923 1
- 1932 1
- 1939 1
- 1941 1
- 1947 1
- 1951 1
- 1957 1
- 1997 1
- 2010 1
- 2018 1
- 2031 1
- 2034 1
- 2059 1
- 2071 1
- 2091 1
- 2097 1
- 2107 1
- 2123 1
- 2138 1
- 2152 1
- 2165 1
- 2179 1
- 2202 1
- 2213 1
- 2230 1
- 2242 1
- 2259 1
- 2275 1
- 2277 1
- 2298 1
- 2310 1
- 2324 1
- 2370 1
- 2385 1
- 2394 1
- 2399 1
- 2414 1
- 2432 1
- 2456 1
- 2465 1
- 2474 1
- 2481 1
- 2488 1
- 2499 1
- 2535 1
- 2538 1
- 2544 1
- 2548 1
- 2551 1
- 2557 1
- 2559 1
- 2570 1
- 2571 1
- 2580 1
- 2582 1
- 2584 1
- 2588 1
- 2593 1
- 2603 1
- 2607 1
- 2608 1
- 2609 1
- 2614 1
- 2616 1
- 2621 1
- 2623 1
- 2624 1
- 2625 1
- 2627 1
- 2628 1
- 2630 1
- 2633 1
- 2636 1
- 2643 1
- 2647 1
- 2667 1
- 2675 1
- 2694 1
- 2702 1
- 2724 1
- 2727 1
- 2728 1
- 2733 1
- 2743 1
- 2753 1
- 2773 1
- 2786 1
- 2790 1
- 2791 1
- 2813 1
- 2824 1
- 2828 1
- 2838 1
- 2858 1
- 2862 1
- 2868 1
- 2877 1
- 2907 1
- 2918 1
- 2919 1
- 2927 1
- 2951 1
- 2954 1
- 2958 1
- 2968 1
- 2988 1
- 2994 1
- 2996 1
- 3002 1
- 3028 1
- 3033 1
- 3035 1
- 3041 1
- 3058 1
- 3062 1
- 3065 1
- 3071 1
- 3087 1
- 3090 1
- 3096 1
- 3105 1
- 3125 1
- 3128 1
- 3134 1
- 3142 1
- 3157 1
- 3160 1
- 3166 1
- 3172 1
- 3188 1
- 3190 1
- 3197 1
- 3207 1
- 3231 1
- 3237 1
- 3249 1
- 3267 1
- 3284 1
- 3286 1
- 3289 1
- 3311 1
- 3318 1
- 3325 1
- 3330 1
- 3336 1
- 3347 1
- 3354 1
- 3363 1
- 3399 1
- 3442 1
- 3482 1
- 3547 1
- 3839 1
- 3888 1
- 3982 1
- 4129 1
- 4468 1
- 4567 1
- 4625 1
- 4661 1
- 5190 1
- 5226 1
- 5297 1
- 5454 1
- 5595 1
- 5610 1
- 5657 1
- 5743 1
- 5853 1
- 5879 1
- 5883 1
- 5939 1
- 5944 1
- 5946 1
- 5975 1
- 6019 1
- 6058 1
- 6071 1
- 6074 1
- 6117 1
- 6129 1
- 6166 1
- 6167 1
- 6179 1
- 6183 1
- 6202 1
- 6210 1
- 6216 1
- 6220 1
- 6239 1
- 6240 1
- 6242 1
- 6246 1
- 6261 1
- 6262 1
- 6274 1
- 6301 1
- 6305 1
- 6322 1
- 6330 1
- 6356 1
- 6372 1
- 6377 1
- 6393 1
- 6407 1
- 6408 1
- 6409 1
- 6415 1
- 6454 1
- 6458 1
- 6471 1
- 6481 1
- 6504 1
- 6508 1
- 6518 1
- 6530 1
- 6580 1
- 6597 1
- 6610 1
- 6618 1
- 6623 1
- 6624 1
- 6631 1
- 6671 1
- 6676 1
state 1
- Colorado 794
fips 1
- 8097 794
county 1
- Pitkin · 794 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499869 | 2499869 | 2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 |
2496611 | 2496611 | 2022-05-12 | Pitkin | Colorado | 8097 | 6671 | 7 |
2493353 | 2493353 | 2022-05-11 | Pitkin | Colorado | 8097 | 6631 | 7 |
2490095 | 2490095 | 2022-05-10 | Pitkin | Colorado | 8097 | 6624 | 7 |
2486838 | 2486838 | 2022-05-09 | Pitkin | Colorado | 8097 | 6623 | 7 |
2483580 | 2483580 | 2022-05-08 | Pitkin | Colorado | 8097 | 6620 | 7 |
2480322 | 2480322 | 2022-05-07 | Pitkin | Colorado | 8097 | 6620 | 7 |
2477064 | 2477064 | 2022-05-06 | Pitkin | Colorado | 8097 | 6620 | 7 |
2473806 | 2473806 | 2022-05-05 | Pitkin | Colorado | 8097 | 6620 | 7 |
2470549 | 2470549 | 2022-05-04 | Pitkin | Colorado | 8097 | 6618 | 7 |
2467293 | 2467293 | 2022-05-03 | Pitkin | Colorado | 8097 | 6617 | 7 |
2464038 | 2464038 | 2022-05-02 | Pitkin | Colorado | 8097 | 6617 | 6 |
2460782 | 2460782 | 2022-05-01 | Pitkin | Colorado | 8097 | 6611 | 6 |
2457526 | 2457526 | 2022-04-30 | Pitkin | Colorado | 8097 | 6611 | 6 |
2454270 | 2454270 | 2022-04-29 | Pitkin | Colorado | 8097 | 6611 | 6 |
2451014 | 2451014 | 2022-04-28 | Pitkin | Colorado | 8097 | 6610 | 6 |
2447758 | 2447758 | 2022-04-27 | Pitkin | Colorado | 8097 | 6611 | 6 |
2444502 | 2444502 | 2022-04-26 | Pitkin | Colorado | 8097 | 6597 | 6 |
2441246 | 2441246 | 2022-04-25 | Pitkin | Colorado | 8097 | 6580 | 6 |
2437990 | 2437990 | 2022-04-24 | Pitkin | Colorado | 8097 | 6551 | 6 |
2434734 | 2434734 | 2022-04-23 | Pitkin | Colorado | 8097 | 6551 | 6 |
2431478 | 2431478 | 2022-04-22 | Pitkin | Colorado | 8097 | 6551 | 6 |
2428222 | 2428222 | 2022-04-21 | Pitkin | Colorado | 8097 | 6530 | 6 |
2424966 | 2424966 | 2022-04-20 | Pitkin | Colorado | 8097 | 6518 | 6 |
2421710 | 2421710 | 2022-04-19 | Pitkin | Colorado | 8097 | 6508 | 6 |
2418454 | 2418454 | 2022-04-18 | Pitkin | Colorado | 8097 | 6504 | 6 |
2415198 | 2415198 | 2022-04-17 | Pitkin | Colorado | 8097 | 6484 | 6 |
2411942 | 2411942 | 2022-04-16 | Pitkin | Colorado | 8097 | 6484 | 6 |
2408686 | 2408686 | 2022-04-15 | Pitkin | Colorado | 8097 | 6484 | 6 |
2405430 | 2405430 | 2022-04-14 | Pitkin | Colorado | 8097 | 6481 | 6 |
2402175 | 2402175 | 2022-04-13 | Pitkin | Colorado | 8097 | 6471 | 6 |
2398920 | 2398920 | 2022-04-12 | Pitkin | Colorado | 8097 | 6458 | 6 |
2395665 | 2395665 | 2022-04-11 | Pitkin | Colorado | 8097 | 6454 | 6 |
2392409 | 2392409 | 2022-04-10 | Pitkin | Colorado | 8097 | 6442 | 6 |
2389153 | 2389153 | 2022-04-09 | Pitkin | Colorado | 8097 | 6442 | 6 |
2385898 | 2385898 | 2022-04-08 | Pitkin | Colorado | 8097 | 6442 | 6 |
2382643 | 2382643 | 2022-04-07 | Pitkin | Colorado | 8097 | 6415 | 6 |
2379388 | 2379388 | 2022-04-06 | Pitkin | Colorado | 8097 | 6409 | 6 |
2376134 | 2376134 | 2022-04-05 | Pitkin | Colorado | 8097 | 6408 | 6 |
2372882 | 2372882 | 2022-04-04 | Pitkin | Colorado | 8097 | 6407 | 6 |
2369629 | 2369629 | 2022-04-03 | Pitkin | Colorado | 8097 | 6393 | 6 |
2366376 | 2366376 | 2022-04-02 | Pitkin | Colorado | 8097 | 6394 | 6 |
2363123 | 2363123 | 2022-04-01 | Pitkin | Colorado | 8097 | 6394 | 6 |
2359869 | 2359869 | 2022-03-31 | Pitkin | Colorado | 8097 | 6394 | 6 |
2356615 | 2356615 | 2022-03-30 | Pitkin | Colorado | 8097 | 6377 | 6 |
2353362 | 2353362 | 2022-03-29 | Pitkin | Colorado | 8097 | 6372 | 6 |
2350110 | 2350110 | 2022-03-28 | Pitkin | Colorado | 8097 | 6356 | 6 |
2346857 | 2346857 | 2022-03-27 | Pitkin | Colorado | 8097 | 6351 | 6 |
2343604 | 2343604 | 2022-03-26 | Pitkin | Colorado | 8097 | 6351 | 6 |
2340351 | 2340351 | 2022-03-25 | Pitkin | Colorado | 8097 | 6351 | 6 |
2337098 | 2337098 | 2022-03-24 | Pitkin | Colorado | 8097 | 6330 | 6 |
2333844 | 2333844 | 2022-03-23 | Pitkin | Colorado | 8097 | 6322 | 6 |
2330590 | 2330590 | 2022-03-22 | Pitkin | Colorado | 8097 | 6305 | 6 |
2327338 | 2327338 | 2022-03-21 | Pitkin | Colorado | 8097 | 6301 | 6 |
2324085 | 2324085 | 2022-03-20 | Pitkin | Colorado | 8097 | 6282 | 6 |
2320831 | 2320831 | 2022-03-19 | Pitkin | Colorado | 8097 | 6282 | 6 |
2317577 | 2317577 | 2022-03-18 | Pitkin | Colorado | 8097 | 6282 | 6 |
2314324 | 2314324 | 2022-03-17 | Pitkin | Colorado | 8097 | 6282 | 6 |
2311071 | 2311071 | 2022-03-16 | Pitkin | Colorado | 8097 | 6274 | 6 |
2307818 | 2307818 | 2022-03-15 | Pitkin | Colorado | 8097 | 6262 | 6 |
2304567 | 2304567 | 2022-03-14 | Pitkin | Colorado | 8097 | 6261 | 6 |
2301315 | 2301315 | 2022-03-13 | Pitkin | Colorado | 8097 | 6259 | 6 |
2298063 | 2298063 | 2022-03-12 | Pitkin | Colorado | 8097 | 6259 | 6 |
2294811 | 2294811 | 2022-03-11 | Pitkin | Colorado | 8097 | 6259 | 6 |
2291559 | 2291559 | 2022-03-10 | Pitkin | Colorado | 8097 | 6246 | 6 |
2288307 | 2288307 | 2022-03-09 | Pitkin | Colorado | 8097 | 6240 | 6 |
2285056 | 2285056 | 2022-03-08 | Pitkin | Colorado | 8097 | 6242 | 6 |
2281804 | 2281804 | 2022-03-07 | Pitkin | Colorado | 8097 | 6239 | 6 |
2278551 | 2278551 | 2022-03-06 | Pitkin | Colorado | 8097 | 6226 | 6 |
2275298 | 2275298 | 2022-03-05 | Pitkin | Colorado | 8097 | 6226 | 6 |
2272045 | 2272045 | 2022-03-04 | Pitkin | Colorado | 8097 | 6226 | 6 |
2268793 | 2268793 | 2022-03-03 | Pitkin | Colorado | 8097 | 6220 | 6 |
2265540 | 2265540 | 2022-03-02 | Pitkin | Colorado | 8097 | 6216 | 6 |
2262289 | 2262289 | 2022-03-01 | Pitkin | Colorado | 8097 | 6202 | 6 |
2259038 | 2259038 | 2022-02-28 | Pitkin | Colorado | 8097 | 6210 | 6 |
2255787 | 2255787 | 2022-02-27 | Pitkin | Colorado | 8097 | 6192 | 6 |
2252536 | 2252536 | 2022-02-26 | Pitkin | Colorado | 8097 | 6192 | 6 |
2249285 | 2249285 | 2022-02-25 | Pitkin | Colorado | 8097 | 6192 | 6 |
2246034 | 2246034 | 2022-02-24 | Pitkin | Colorado | 8097 | 6183 | 6 |
2242783 | 2242783 | 2022-02-23 | Pitkin | Colorado | 8097 | 6179 | 6 |
2239532 | 2239532 | 2022-02-22 | Pitkin | Colorado | 8097 | 6166 | 6 |
2236281 | 2236281 | 2022-02-21 | Pitkin | Colorado | 8097 | 6167 | 6 |
2233030 | 2233030 | 2022-02-20 | Pitkin | Colorado | 8097 | 6147 | 6 |
2229779 | 2229779 | 2022-02-19 | Pitkin | Colorado | 8097 | 6147 | 6 |
2226528 | 2226528 | 2022-02-18 | Pitkin | Colorado | 8097 | 6147 | 6 |
2223277 | 2223277 | 2022-02-17 | Pitkin | Colorado | 8097 | 6129 | 6 |
2220026 | 2220026 | 2022-02-16 | Pitkin | Colorado | 8097 | 6117 | 6 |
2216775 | 2216775 | 2022-02-15 | Pitkin | Colorado | 8097 | 6074 | 6 |
2213524 | 2213524 | 2022-02-14 | Pitkin | Colorado | 8097 | 6071 | 6 |
2210272 | 2210272 | 2022-02-13 | Pitkin | Colorado | 8097 | 6063 | 6 |
2207019 | 2207019 | 2022-02-12 | Pitkin | Colorado | 8097 | 6063 | 6 |
2203766 | 2203766 | 2022-02-11 | Pitkin | Colorado | 8097 | 6063 | 6 |
2200513 | 2200513 | 2022-02-10 | Pitkin | Colorado | 8097 | 6058 | 6 |
2197259 | 2197259 | 2022-02-09 | Pitkin | Colorado | 8097 | 6032 | 6 |
2194005 | 2194005 | 2022-02-08 | Pitkin | Colorado | 8097 | 6032 | 6 |
2190751 | 2190751 | 2022-02-07 | Pitkin | Colorado | 8097 | 6019 | 6 |
2187498 | 2187498 | 2022-02-06 | Pitkin | Colorado | 8097 | 5993 | 6 |
2184245 | 2184245 | 2022-02-05 | Pitkin | Colorado | 8097 | 5993 | 6 |
2180993 | 2180993 | 2022-02-04 | Pitkin | Colorado | 8097 | 5993 | 6 |
2177742 | 2177742 | 2022-02-03 | Pitkin | Colorado | 8097 | 5975 | 6 |
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);