ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 464 ✖
- 5 32
- 4 22
- 15 12
- 2 10
- 18 8
- 21 8
- 71 8
- 69 7
- 1507 7
- 56 6
- 66 6
- 1504 6
- 1516 6
- 1529 6
- 39 5
- 54 5
- 1500 5
- 3417 5
- 17 4
- 46 4
- 62 4
- 74 4
- 1469 4
- 1485 4
- 1502 4
- 1546 4
- 2284 4
- 3436 4
- 3444 4
- 3580 4
- 3590 4
- 14 3
- 23 3
- 29 3
- 44 3
- 83 3
- 142 3
- 153 3
- 930 3
- 1479 3
- 1487 3
- 1533 3
- 1563 3
- 1595 3
- 1646 3
- 1695 3
- 1751 3
- 1823 3
- 1939 3
- 2025 3
- 2065 3
- 2103 3
- 2144 3
- 2162 3
- 2188 3
- 2216 3
- 2262 3
- 2316 3
- 2358 3
- 2364 3
- 2377 3
- 2424 3
- 2571 3
- 2709 3
- 3039 3
- 3169 3
- 3344 3
- 3356 3
- 3390 3
- 3406 3
- 3459 3
- 3484 3
- 3493 3
- 3518 3
- 3537 3
- 6 2
- 7 2
- 19 2
- 35 2
- 37 2
- 40 2
- 41 2
- 43 2
- 67 2
- 72 2
- 116 2
- 162 2
- 517 2
- 521 2
- 619 2
- 693 2
- 898 2
- 1159 2
- 1259 2
- 1271 2
- 1289 2
- 1299 2
- 1312 2
- 1327 2
- 1351 2
- 1390 2
- 1412 2
- 1437 2
- 1467 2
- 1470 2
- 1471 2
- 1472 2
- 1474 2
- 1480 2
- 1483 2
- 1505 2
- 1510 2
- 1513 2
- 2156 2
- 2201 2
- 3271 2
- 3292 2
- 3416 2
- 3437 2
- 3471 2
- 3504 2
- 3528 2
- 3573 2
- 3599 2
- 1 1
- 8 1
- 10 1
- 12 1
- 16 1
- 26 1
- 27 1
- 28 1
- 32 1
- 34 1
- 42 1
- 45 1
- 51 1
- 53 1
- 55 1
- 57 1
- 60 1
- 63 1
- 76 1
- 85 1
- 96 1
- 100 1
- 106 1
- 108 1
- 111 1
- 114 1
- 117 1
- 118 1
- 123 1
- 127 1
- 133 1
- 134 1
- 139 1
- 140 1
- 141 1
- 144 1
- 149 1
- 154 1
- 158 1
- 159 1
- 161 1
- 165 1
- 167 1
- 172 1
- 174 1
- 178 1
- 182 1
- 186 1
- 194 1
- 200 1
- 206 1
- 214 1
- 220 1
- 229 1
- 241 1
- 251 1
- 259 1
- 266 1
- 273 1
- 281 1
- 333 1
- 352 1
- 373 1
- 376 1
- 388 1
- 393 1
- 398 1
- 415 1
- 421 1
- 439 1
- 452 1
- 464 1
- 469 1
- 481 1
- 490 1
- 498 1
- 507 1
- 535 1
- 560 1
- 567 1
- 576 1
- 587 1
- 594 1
- 596 1
- 599 1
- 603 1
- 613 1
- 620 1
- 626 1
- 627 1
- 648 1
- 660 1
- 671 1
- 675 1
- 679 1
- 688 1
- 716 1
- 745 1
- 748 1
- 756 1
- 760 1
- 763 1
- 770 1
- 777 1
- 783 1
- 785 1
- 795 1
- 803 1
- 805 1
- 819 1
- 842 1
- 863 1
- 892 1
- 908 1
- 917 1
- 924 1
- 975 1
- 979 1
- 1005 1
- 1038 1
- 1063 1
- 1074 1
- 1083 1
- 1103 1
- 1104 1
- 1119 1
- 1127 1
- 1166 1
- 1167 1
- 1184 1
- 1211 1
- 1218 1
- 1226 1
- 1234 1
- 1241 1
- 1242 1
- 1243 1
- 1252 1
- 1272 1
- 1273 1
- 1282 1
- 1287 1
- 1288 1
- 1290 1
- 1292 1
- 1295 1
- 1296 1
- 1297 1
- 1301 1
- 1302 1
- 1304 1
- 1308 1
- 1309 1
- 1310 1
- 1313 1
- 1317 1
- 1318 1
- 1322 1
- 1324 1
- 1329 1
- 1335 1
- 1338 1
- 1342 1
- 1343 1
- 1344 1
- 1350 1
- 1369 1
- 1370 1
- 1374 1
- 1380 1
- 1386 1
- 1397 1
- 1400 1
- 1404 1
- 1408 1
- 1409 1
- 1420 1
- 1422 1
- 1427 1
- 1440 1
- 1441 1
- 1449 1
- 1451 1
- 1455 1
- 1460 1
- 1463 1
- 1468 1
- 1473 1
- 1475 1
- 1478 1
- 1481 1
- 1489 1
- 1490 1
- 1494 1
- 1495 1
- 1497 1
- 1498 1
- 1503 1
- 1506 1
- 1509 1
- 1511 1
- 1515 1
- 1522 1
- 1524 1
- 1532 1
- 1540 1
- 1541 1
- 1542 1
- 1552 1
- 1553 1
- 1555 1
- 1558 1
- 1575 1
- 1578 1
- 1582 1
- 1586 1
- 1617 1
- 1621 1
- 1632 1
- 1637 1
- 1662 1
- 1672 1
- 1682 1
- 1691 1
- 1724 1
- 1733 1
- 1740 1
- 1747 1
- 1773 1
- 1780 1
- 1797 1
- 1808 1
- 1866 1
- 1889 1
- 1907 1
- 1924 1
- 1982 1
- 1993 1
- 1999 1
- 2012 1
- 2041 1
- 2044 1
- 2053 1
- 2059 1
- 2078 1
- 2083 1
- 2093 1
- 2102 1
- 2123 1
- 2126 1
- 2132 1
- 2137 1
- 2152 1
- 2158 1
- 2171 1
- 2176 1
- 2179 1
- 2181 1
- 2197 1
- 2207 1
- 2233 1
- 2234 1
- 2247 1
- 2254 1
- 2268 1
- 2272 1
- 2275 1
- 2295 1
- 2300 1
- 2301 1
- 2312 1
- 2332 1
- 2339 1
- 2343 1
- 2356 1
- 2367 1
- 2388 1
- 2395 1
- 2405 1
- 2419 1
- 2453 1
- 2462 1
- 2480 1
- 2530 1
- 2640 1
- 2649 1
- 2666 1
- 2676 1
- 2874 1
- 2885 1
- 2894 1
- 2995 1
- 3088 1
- 3092 1
- 3116 1
- 3143 1
- 3219 1
- 3232 1
- 3248 1
- 3302 1
- 3307 1
- 3313 1
- 3327 1
- 3346 1
- 3347 1
- 3350 1
- 3353 1
- 3363 1
- 3366 1
- 3378 1
- 3383 1
- 3398 1
- 3400 1
- 3401 1
- 3402 1
- 3432 1
- 3433 1
- 3438 1
- 3442 1
- 3446 1
- 3451 1
- 3452 1
- 3455 1
- 3460 1
- 3483 1
- 3485 1
- 3486 1
- 3487 1
- 3488 1
- 3505 1
- 3514 1
- 3525 1
- 3526 1
- 3575 1
- 3583 1
- 3584 1
- 3586 1
- 3588 1
- 3593 1
- 3596 1
state 1
- Colorado 786
fips 1
- 8049 · 786 ✖
county 1
- Grand 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499845 | 2499845 | 2022-05-13 | Grand | Colorado | 8049 | 3599 | 28 |
2496587 | 2496587 | 2022-05-12 | Grand | Colorado | 8049 | 3599 | 28 |
2493329 | 2493329 | 2022-05-11 | Grand | Colorado | 8049 | 3596 | 28 |
2490071 | 2490071 | 2022-05-10 | Grand | Colorado | 8049 | 3593 | 28 |
2486814 | 2486814 | 2022-05-09 | Grand | Colorado | 8049 | 3590 | 28 |
2483556 | 2483556 | 2022-05-08 | Grand | Colorado | 8049 | 3590 | 28 |
2480298 | 2480298 | 2022-05-07 | Grand | Colorado | 8049 | 3590 | 28 |
2477040 | 2477040 | 2022-05-06 | Grand | Colorado | 8049 | 3590 | 28 |
2473782 | 2473782 | 2022-05-05 | Grand | Colorado | 8049 | 3588 | 28 |
2470525 | 2470525 | 2022-05-04 | Grand | Colorado | 8049 | 3586 | 28 |
2467269 | 2467269 | 2022-05-03 | Grand | Colorado | 8049 | 3584 | 28 |
2464014 | 2464014 | 2022-05-02 | Grand | Colorado | 8049 | 3583 | 26 |
2460758 | 2460758 | 2022-05-01 | Grand | Colorado | 8049 | 3580 | 26 |
2457502 | 2457502 | 2022-04-30 | Grand | Colorado | 8049 | 3580 | 26 |
2454246 | 2454246 | 2022-04-29 | Grand | Colorado | 8049 | 3580 | 26 |
2450990 | 2450990 | 2022-04-28 | Grand | Colorado | 8049 | 3580 | 26 |
2447734 | 2447734 | 2022-04-27 | Grand | Colorado | 8049 | 3575 | 26 |
2444478 | 2444478 | 2022-04-26 | Grand | Colorado | 8049 | 3573 | 26 |
2441222 | 2441222 | 2022-04-25 | Grand | Colorado | 8049 | 3573 | 26 |
2437966 | 2437966 | 2022-04-24 | Grand | Colorado | 8049 | 3537 | 26 |
2434710 | 2434710 | 2022-04-23 | Grand | Colorado | 8049 | 3537 | 26 |
2431454 | 2431454 | 2022-04-22 | Grand | Colorado | 8049 | 3537 | 26 |
2428198 | 2428198 | 2022-04-21 | Grand | Colorado | 8049 | 3528 | 26 |
2424942 | 2424942 | 2022-04-20 | Grand | Colorado | 8049 | 3528 | 26 |
2421686 | 2421686 | 2022-04-19 | Grand | Colorado | 8049 | 3526 | 26 |
2418430 | 2418430 | 2022-04-18 | Grand | Colorado | 8049 | 3525 | 26 |
2415174 | 2415174 | 2022-04-17 | Grand | Colorado | 8049 | 3518 | 26 |
2411918 | 2411918 | 2022-04-16 | Grand | Colorado | 8049 | 3518 | 26 |
2408662 | 2408662 | 2022-04-15 | Grand | Colorado | 8049 | 3518 | 26 |
2405406 | 2405406 | 2022-04-14 | Grand | Colorado | 8049 | 3514 | 26 |
2402151 | 2402151 | 2022-04-13 | Grand | Colorado | 8049 | 3505 | 26 |
2398896 | 2398896 | 2022-04-12 | Grand | Colorado | 8049 | 3504 | 26 |
2395641 | 2395641 | 2022-04-11 | Grand | Colorado | 8049 | 3504 | 26 |
2392385 | 2392385 | 2022-04-10 | Grand | Colorado | 8049 | 3493 | 26 |
2389129 | 2389129 | 2022-04-09 | Grand | Colorado | 8049 | 3493 | 26 |
2385874 | 2385874 | 2022-04-08 | Grand | Colorado | 8049 | 3493 | 26 |
2382619 | 2382619 | 2022-04-07 | Grand | Colorado | 8049 | 3488 | 26 |
2379364 | 2379364 | 2022-04-06 | Grand | Colorado | 8049 | 3487 | 26 |
2376110 | 2376110 | 2022-04-05 | Grand | Colorado | 8049 | 3485 | 26 |
2372858 | 2372858 | 2022-04-04 | Grand | Colorado | 8049 | 3486 | 26 |
2369605 | 2369605 | 2022-04-03 | Grand | Colorado | 8049 | 3483 | 26 |
2366352 | 2366352 | 2022-04-02 | Grand | Colorado | 8049 | 3484 | 26 |
2363099 | 2363099 | 2022-04-01 | Grand | Colorado | 8049 | 3484 | 26 |
2359845 | 2359845 | 2022-03-31 | Grand | Colorado | 8049 | 3484 | 26 |
2356591 | 2356591 | 2022-03-30 | Grand | Colorado | 8049 | 3471 | 26 |
2353338 | 2353338 | 2022-03-29 | Grand | Colorado | 8049 | 3471 | 25 |
2350086 | 2350086 | 2022-03-28 | Grand | Colorado | 8049 | 3460 | 26 |
2346833 | 2346833 | 2022-03-27 | Grand | Colorado | 8049 | 3459 | 25 |
2343580 | 2343580 | 2022-03-26 | Grand | Colorado | 8049 | 3459 | 25 |
2340327 | 2340327 | 2022-03-25 | Grand | Colorado | 8049 | 3459 | 25 |
2337074 | 2337074 | 2022-03-24 | Grand | Colorado | 8049 | 3455 | 25 |
2333820 | 2333820 | 2022-03-23 | Grand | Colorado | 8049 | 3452 | 25 |
2330566 | 2330566 | 2022-03-22 | Grand | Colorado | 8049 | 3446 | 24 |
2327314 | 2327314 | 2022-03-21 | Grand | Colorado | 8049 | 3451 | 24 |
2324061 | 2324061 | 2022-03-20 | Grand | Colorado | 8049 | 3444 | 24 |
2320807 | 2320807 | 2022-03-19 | Grand | Colorado | 8049 | 3444 | 24 |
2317553 | 2317553 | 2022-03-18 | Grand | Colorado | 8049 | 3444 | 24 |
2314300 | 2314300 | 2022-03-17 | Grand | Colorado | 8049 | 3444 | 24 |
2311047 | 2311047 | 2022-03-16 | Grand | Colorado | 8049 | 3442 | 24 |
2307794 | 2307794 | 2022-03-15 | Grand | Colorado | 8049 | 3437 | 24 |
2304543 | 2304543 | 2022-03-14 | Grand | Colorado | 8049 | 3437 | 24 |
2301291 | 2301291 | 2022-03-13 | Grand | Colorado | 8049 | 3436 | 23 |
2298039 | 2298039 | 2022-03-12 | Grand | Colorado | 8049 | 3436 | 23 |
2294787 | 2294787 | 2022-03-11 | Grand | Colorado | 8049 | 3436 | 23 |
2291535 | 2291535 | 2022-03-10 | Grand | Colorado | 8049 | 3438 | 23 |
2288283 | 2288283 | 2022-03-09 | Grand | Colorado | 8049 | 3436 | 23 |
2285032 | 2285032 | 2022-03-08 | Grand | Colorado | 8049 | 3433 | 23 |
2281780 | 2281780 | 2022-03-07 | Grand | Colorado | 8049 | 3432 | 23 |
2278527 | 2278527 | 2022-03-06 | Grand | Colorado | 8049 | 3417 | 23 |
2275274 | 2275274 | 2022-03-05 | Grand | Colorado | 8049 | 3417 | 23 |
2272021 | 2272021 | 2022-03-04 | Grand | Colorado | 8049 | 3417 | 23 |
2268769 | 2268769 | 2022-03-03 | Grand | Colorado | 8049 | 3416 | 23 |
2265516 | 2265516 | 2022-03-02 | Grand | Colorado | 8049 | 3417 | 23 |
2262265 | 2262265 | 2022-03-01 | Grand | Colorado | 8049 | 3417 | 23 |
2259014 | 2259014 | 2022-02-28 | Grand | Colorado | 8049 | 3416 | 23 |
2255763 | 2255763 | 2022-02-27 | Grand | Colorado | 8049 | 3406 | 23 |
2252512 | 2252512 | 2022-02-26 | Grand | Colorado | 8049 | 3406 | 23 |
2249261 | 2249261 | 2022-02-25 | Grand | Colorado | 8049 | 3406 | 23 |
2246010 | 2246010 | 2022-02-24 | Grand | Colorado | 8049 | 3401 | 23 |
2242759 | 2242759 | 2022-02-23 | Grand | Colorado | 8049 | 3402 | 23 |
2239508 | 2239508 | 2022-02-22 | Grand | Colorado | 8049 | 3400 | 23 |
2236257 | 2236257 | 2022-02-21 | Grand | Colorado | 8049 | 3398 | 23 |
2233006 | 2233006 | 2022-02-20 | Grand | Colorado | 8049 | 3390 | 23 |
2229755 | 2229755 | 2022-02-19 | Grand | Colorado | 8049 | 3390 | 23 |
2226504 | 2226504 | 2022-02-18 | Grand | Colorado | 8049 | 3390 | 23 |
2223253 | 2223253 | 2022-02-17 | Grand | Colorado | 8049 | 3383 | 23 |
2220002 | 2220002 | 2022-02-16 | Grand | Colorado | 8049 | 3378 | 23 |
2216751 | 2216751 | 2022-02-15 | Grand | Colorado | 8049 | 3366 | 23 |
2213500 | 2213500 | 2022-02-14 | Grand | Colorado | 8049 | 3363 | 23 |
2210248 | 2210248 | 2022-02-13 | Grand | Colorado | 8049 | 3356 | 23 |
2206995 | 2206995 | 2022-02-12 | Grand | Colorado | 8049 | 3356 | 23 |
2203742 | 2203742 | 2022-02-11 | Grand | Colorado | 8049 | 3356 | 23 |
2200489 | 2200489 | 2022-02-10 | Grand | Colorado | 8049 | 3353 | 23 |
2197235 | 2197235 | 2022-02-09 | Grand | Colorado | 8049 | 3350 | 23 |
2193981 | 2193981 | 2022-02-08 | Grand | Colorado | 8049 | 3346 | 23 |
2190727 | 2190727 | 2022-02-07 | Grand | Colorado | 8049 | 3347 | 23 |
2187474 | 2187474 | 2022-02-06 | Grand | Colorado | 8049 | 3344 | 23 |
2184221 | 2184221 | 2022-02-05 | Grand | Colorado | 8049 | 3344 | 23 |
2180969 | 2180969 | 2022-02-04 | Grand | Colorado | 8049 | 3344 | 23 |
2177718 | 2177718 | 2022-02-03 | Grand | Colorado | 8049 | 3327 | 23 |
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);