ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42133 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 767 ✖
- 119729 7
- 120372 3
- 2 2
- 10 2
- 66 2
- 102 2
- 4124 2
- 5008 2
- 45968 2
- 47475 2
- 47847 2
- 62909 2
- 117222 2
- 118453 2
- 6 1
- 9 1
- 18 1
- 20 1
- 21 1
- 29 1
- 37 1
- 43 1
- 54 1
- 144 1
- 171 1
- 189 1
- 218 1
- 233 1
- 250 1
- 283 1
- 293 1
- 307 1
- 331 1
- 371 1
- 381 1
- 393 1
- 443 1
- 463 1
- 481 1
- 493 1
- 517 1
- 531 1
- 546 1
- 563 1
- 578 1
- 593 1
- 606 1
- 614 1
- 624 1
- 641 1
- 651 1
- 664 1
- 679 1
- 702 1
- 716 1
- 722 1
- 740 1
- 753 1
- 767 1
- 773 1
- 784 1
- 793 1
- 803 1
- 817 1
- 828 1
- 835 1
- 851 1
- 857 1
- 866 1
- 872 1
- 883 1
- 895 1
- 904 1
- 924 1
- 930 1
- 943 1
- 956 1
- 970 1
- 991 1
- 1000 1
- 1007 1
- 1013 1
- 1028 1
- 1037 1
- 1038 1
- 1040 1
- 1049 1
- 1082 1
- 1086 1
- 1094 1
- 1102 1
- 1117 1
- 1141 1
- 1157 1
- 1162 1
- 1169 1
- 1183 1
- 1195 1
- 1209 1
- 1229 1
- 1255 1
- 1296 1
- 1351 1
- 1381 1
- 1400 1
- 1418 1
- 1428 1
- 1443 1
- 1456 1
- 1477 1
- 1515 1
- 1531 1
- 1555 1
- 1577 1
- 1595 1
- 1609 1
- 1613 1
- 1654 1
- 1692 1
- 1714 1
- 1791 1
- 1830 1
- 1850 1
- 1858 1
- 1872 1
- 1908 1
- 1942 1
- 1963 1
- 1975 1
- 1985 1
- 2006 1
- 2052 1
- 2067 1
- 2098 1
- 2119 1
- 2152 1
- 2161 1
- 2182 1
- 2196 1
- 2223 1
- 2243 1
- 2269 1
- 2286 1
- 2325 1
- 2350 1
- 2365 1
- 2400 1
- 2444 1
- 2485 1
- 2501 1
- 2572 1
- 2591 1
- 2637 1
- 2680 1
- 2751 1
- 2801 1
- 2854 1
- 2884 1
- 2907 1
- 2929 1
- 2966 1
- 3011 1
- 3038 1
- 3086 1
- 3119 1
- 3136 1
- 3158 1
- 3189 1
- 3232 1
- 3269 1
- 3301 1
- 3328 1
- 3368 1
- 3442 1
- 3490 1
- 3618 1
- 3667 1
- 3739 1
- 3773 1
- 3807 1
- 3832 1
- 3889 1
- 3929 1
- 3995 1
- 4216 1
- 4258 1
- 4333 1
- 4361 1
- 4391 1
- 4453 1
- 4490 1
- 4520 1
- 4554 1
- 4606 1
- 4650 1
- 4752 1
- 4784 1
- 4828 1
- 4851 1
- 4891 1
- 4941 1
- 4971 1
- 5107 1
- 5125 1
- 5171 1
- 5239 1
- 5300 1
- 5333 1
- 5415 1
- 5445 1
- 5487 1
- 5553 1
- 5615 1
- 5649 1
- 5708 1
- 5784 1
- 5851 1
- 5896 1
- 5971 1
- 6013 1
- 6065 1
- 6137 1
- 6203 1
- 6243 1
- 6315 1
- 6405 1
- 6484 1
- 6545 1
- 6630 1
- 6716 1
- 6742 1
- 6798 1
- 6881 1
- 6947 1
- 7026 1
- 7072 1
- 7218 1
- 7301 1
- 7388 1
- 7477 1
- 7608 1
- 7734 1
- 7869 1
- 7966 1
- 8074 1
- 8216 1
- 8454 1
- 8632 1
- 8825 1
- 8975 1
- 9103 1
- 9662 1
- 9755 1
- 9978 1
- 10161 1
- 10428 1
- 10604 1
- 10806 1
- 11001 1
- 11202 1
- 11338 1
- 11711 1
- 12388 1
- 12777 1
- 13573 1
- 13845 1
- 13967 1
- 14436 1
- 14950 1
- 15531 1
- 15879 1
- 16344 1
- 17077 1
- 17522 1
- 17811 1
- 18232 1
- 18556 1
- 19039 1
- 19439 1
- 19760 1
- 20128 1
- 20332 1
- 20897 1
- 21255 1
- 21477 1
- 21837 1
- 22088 1
- 22293 1
- 22537 1
- 22920 1
- 23283 1
- 23581 1
- 23874 1
- 24086 1
- 24158 1
- 24608 1
- 25040 1
- 25349 1
- 25710 1
- 26155 1
- 26494 1
- 26759 1
- 27005 1
- 27275 1
- 27663 1
- 27846 1
- 28125 1
- 28488 1
- 28686 1
- 28930 1
- 29155 1
- 29360 1
- 29618 1
- 29812 1
- 30002 1
- 30224 1
- 30363 1
- 30646 1
- 31218 1
- 31670 1
- 31889 1
- 32142 1
- 32263 1
- 32464 1
- 32578 1
- 32715 1
- 32858 1
- 33074 1
- 33314 1
- 33466 1
- 33618 1
- 33750 1
- 33946 1
- 34087 1
- 34254 1
- 34423 1
- 34504 1
- 34582 1
- 34721 1
- 34870 1
- 34976 1
- 35108 1
- 35185 1
- 35231 1
- 35332 1
- 35447 1
- 35528 1
- 35634 1
- 35739 1
- 35812 1
- 35878 1
- 35938 1
- 36033 1
- 36136 1
- 36256 1
- 36355 1
- 36413 1
- 36466 1
- 36540 1
- 36669 1
- 36781 1
- 36923 1
- 37029 1
- 37115 1
- 37166 1
- 37258 1
- 37393 1
- 37544 1
- 37680 1
- 37881 1
- 37964 1
- 38027 1
- 38120 1
- 38367 1
- 38521 1
- 38767 1
- 38923 1
- 39027 1
- 39111 1
- 39298 1
- 39481 1
- 39646 1
- 39820 1
- 39993 1
- 40118 1
- 40198 1
- 40322 1
- 40526 1
- 40691 1
- 40851 1
- 41076 1
- 41220 1
- 41306 1
- 41539 1
- 41711 1
- 41908 1
- 42125 1
- 42335 1
- 42464 1
- 42532 1
- 42693 1
- 42890 1
- 43072 1
- 43204 1
- 43372 1
- 43493 1
- 43576 1
- 43700 1
- 43821 1
- 43963 1
- 44127 1
- 44286 1
- 44398 1
- 44485 1
- 44608 1
- 44732 1
- 44837 1
- 44970 1
- 45087 1
- 45139 1
- 45183 1
- 45255 1
- 45339 1
- 45420 1
- 45477 1
- 45567 1
- 45610 1
- 45654 1
- 45741 1
- 45812 1
- 45868 1
- 46066 1
- 46099 1
- 46132 1
- 46182 1
- 46227 1
- 46271 1
- 46318 1
- 46346 1
- 46362 1
- 46392 1
- 46429 1
- 46465 1
- 46516 1
- 46537 1
- 46554 1
- 46573 1
- 46626 1
- 46717 1
- 46810 1
- 46819 1
- 46848 1
- 46859 1
- 46863 1
- 46884 1
- 46901 1
- 46919 1
- 46936 1
- 46943 1
- 46946 1
- 46951 1
- 46960 1
- 46971 1
- 46976 1
- 46989 1
- 47004 1
- 47010 1
- 47011 1
- 47022 1
- 47027 1
- 47035 1
- 47045 1
- 47054 1
- 47061 1
- 47070 1
- 47074 1
- 47078 1
- 47088 1
- 47099 1
- 47112 1
- 47122 1
- 47123 1
- 47138 1
- 47149 1
- 47161 1
- 47176 1
- 47189 1
- 47205 1
- 47206 1
- 47226 1
- 47250 1
- 47268 1
- 47287 1
- 47309 1
- 47324 1
- 47337 1
- 47371 1
- 47404 1
- 47446 1
- 47537 1
- 47571 1
- 47615 1
- 47671 1
- 47724 1
- 47785 1
- 47945 1
- 48022 1
- 48079 1
- 48177 1
- 48267 1
- 48373 1
- 48492 1
- 48557 1
- 48632 1
- 48746 1
- 48862 1
- 48971 1
- 49075 1
- 49180 1
- 49273 1
- 49361 1
- 49535 1
- 49670 1
- 49830 1
- 49972 1
- 50118 1
- 50210 1
- 50362 1
- 50550 1
- 50727 1
- 50883 1
- 51117 1
- 51283 1
- 51406 1
- 51588 1
- 51763 1
- 51959 1
- 52168 1
- 52327 1
- 52575 1
- 52753 1
- 52906 1
- 53062 1
- 53323 1
- 53541 1
- 53746 1
- 53949 1
- 54100 1
- 54292 1
- 54476 1
- 54722 1
- 55000 1
- 55256 1
- 55486 1
- 55654 1
- 55880 1
- 56079 1
- 56293 1
- 56473 1
- 56603 1
- 56925 1
- 57192 1
- 57361 1
- 57587 1
- 57821 1
- 58042 1
- 58300 1
- 58479 1
- 58715 1
- 58929 1
- 59160 1
- 59415 1
- 59671 1
- 59833 1
- 60078 1
- 60259 1
- 60440 1
- 60631 1
- 60866 1
- 61118 1
- 61293 1
- 61574 1
- 61707 1
- 61846 1
- 62106 1
- 62358 1
- 62548 1
- 62751 1
- 63225 1
- 63354 1
- 63629 1
- 63889 1
- 64107 1
- 64259 1
- 64425 1
- 64570 1
- 64760 1
- 65028 1
- 65235 1
- 66404 1
- 66586 1
- 66754 1
- 66993 1
- 67238 1
- 67519 1
- 67776 1
- 67957 1
- 68294 1
- 68544 1
- 68764 1
- 69066 1
- 69383 1
- 69678 1
- 69910 1
- 70099 1
- 70372 1
- 70599 1
- 70896 1
- 71342 1
- 71617 1
- 72146 1
- 72448 1
- 72719 1
- 73026 1
- 73282 1
- 73728 1
- 74081 1
- 74629 1
- 75136 1
- 75451 1
- 75757 1
- 76049 1
- 76480 1
- 76873 1
- 77358 1
- 77823 1
- 78153 1
- 78696 1
- 79983 1
- 80756 1
- 81411 1
- 82094 1
- 82434 1
- 82924 1
- 83474 1
- 84121 1
- 84916 1
- 86112 1
- 86890 1
- 88124 1
- 89051 1
- 89981 1
- 91095 1
- 91847 1
- 92838 1
- 94303 1
- 95186 1
- 97191 1
- 97888 1
- 98796 1
- 99967 1
- 100851 1
- 102239 1
- 104182 1
- 105307 1
- 106101 1
- 106721 1
- 107537 1
- 108394 1
- 109201 1
- 109889 1
- 110402 1
- 110891 1
- 111392 1
- 112082 1
- 112762 1
- 113100 1
- 113620 1
- 113904 1
- 114183 1
- 114429 1
- 114771 1
- 115038 1
- 115334 1
- 115550 1
- 115764 1
- 115818 1
- 115909 1
- 116070 1
- 116225 1
- 116425 1
- 116532 1
- 116598 1
- 116703 1
- 116773 1
- 116911 1
- 117012 1
- 117152 1
- 117303 1
- 117364 1
- 117449 1
- 117500 1
- 117779 1
- 117810 1
- 117826 1
- 117832 1
- 117864 1
- 117911 1
- 117935 1
- 117981 1
- 118003 1
- 118023 1
- 118043 1
- 118068 1
- 118091 1
- 118110 1
- 118139 1
- 118151 1
- 118162 1
- 118172 1
- 118199 1
- 118217 1
- 118235 1
- 118250 1
- 118255 1
- 118264 1
- 118277 1
- 118295 1
- 118310 1
- 118330 1
- 118348 1
- 118359 1
- 118367 1
- 118379 1
- 118389 1
- 118416 1
- 118435 1
- 118474 1
- 118484 1
- 118518 1
- 118544 1
- 118572 1
- 118605 1
- 118613 1
- 118625 1
- 118656 1
- 118696 1
- 118736 1
- 118775 1
- 118826 1
- 118846 1
- 118865 1
- 118900 1
- 118941 1
- 118992 1
- 119031 1
- 119085 1
- 119110 1
- 119138 1
- 119202 1
- 119253 1
- 119338 1
- 119413 1
- 119489 1
- 119534 1
- 119574 1
- 119653 1
state 1
- Pennsylvania 787
fips 1
- 42133 · 787 ✖
county 1
- York 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501913 | 2501913 | 2022-05-13 | York | Pennsylvania | 42133 | 120372 | 1502 |
2498655 | 2498655 | 2022-05-12 | York | Pennsylvania | 42133 | 120372 | 1502 |
2495397 | 2495397 | 2022-05-11 | York | Pennsylvania | 42133 | 120372 | 1502 |
2492139 | 2492139 | 2022-05-10 | York | Pennsylvania | 42133 | 119729 | 1501 |
2488881 | 2488881 | 2022-05-09 | York | Pennsylvania | 42133 | 119729 | 1501 |
2485624 | 2485624 | 2022-05-08 | York | Pennsylvania | 42133 | 119729 | 1501 |
2482366 | 2482366 | 2022-05-07 | York | Pennsylvania | 42133 | 119729 | 1501 |
2479108 | 2479108 | 2022-05-06 | York | Pennsylvania | 42133 | 119729 | 1501 |
2475850 | 2475850 | 2022-05-05 | York | Pennsylvania | 42133 | 119729 | 1501 |
2472593 | 2472593 | 2022-05-04 | York | Pennsylvania | 42133 | 119729 | 1501 |
2469337 | 2469337 | 2022-05-03 | York | Pennsylvania | 42133 | 119653 | 1500 |
2466081 | 2466081 | 2022-05-02 | York | Pennsylvania | 42133 | 119574 | 1499 |
2462826 | 2462826 | 2022-05-01 | York | Pennsylvania | 42133 | 119534 | 1499 |
2459570 | 2459570 | 2022-04-30 | York | Pennsylvania | 42133 | 119489 | 1499 |
2456314 | 2456314 | 2022-04-29 | York | Pennsylvania | 42133 | 119413 | 1498 |
2453058 | 2453058 | 2022-04-28 | York | Pennsylvania | 42133 | 119338 | 1498 |
2449802 | 2449802 | 2022-04-27 | York | Pennsylvania | 42133 | 119253 | 1497 |
2446545 | 2446545 | 2022-04-26 | York | Pennsylvania | 42133 | 119202 | 1496 |
2443290 | 2443290 | 2022-04-25 | York | Pennsylvania | 42133 | 119138 | 1496 |
2440034 | 2440034 | 2022-04-24 | York | Pennsylvania | 42133 | 119110 | 1496 |
2436778 | 2436778 | 2022-04-23 | York | Pennsylvania | 42133 | 119085 | 1496 |
2433522 | 2433522 | 2022-04-22 | York | Pennsylvania | 42133 | 119031 | 1496 |
2430266 | 2430266 | 2022-04-21 | York | Pennsylvania | 42133 | 118992 | 1495 |
2427010 | 2427010 | 2022-04-20 | York | Pennsylvania | 42133 | 118941 | 1495 |
2423754 | 2423754 | 2022-04-19 | York | Pennsylvania | 42133 | 118900 | 1495 |
2420498 | 2420498 | 2022-04-18 | York | Pennsylvania | 42133 | 118865 | 1494 |
2417242 | 2417242 | 2022-04-17 | York | Pennsylvania | 42133 | 118846 | 1494 |
2413986 | 2413986 | 2022-04-16 | York | Pennsylvania | 42133 | 118826 | 1494 |
2410730 | 2410730 | 2022-04-15 | York | Pennsylvania | 42133 | 118775 | 1494 |
2407474 | 2407474 | 2022-04-14 | York | Pennsylvania | 42133 | 118736 | 1493 |
2404218 | 2404218 | 2022-04-13 | York | Pennsylvania | 42133 | 118696 | 1491 |
2400963 | 2400963 | 2022-04-12 | York | Pennsylvania | 42133 | 118656 | 1491 |
2397708 | 2397708 | 2022-04-11 | York | Pennsylvania | 42133 | 118625 | 1491 |
2394453 | 2394453 | 2022-04-10 | York | Pennsylvania | 42133 | 118613 | 1491 |
2391197 | 2391197 | 2022-04-09 | York | Pennsylvania | 42133 | 118605 | 1491 |
2387941 | 2387941 | 2022-04-08 | York | Pennsylvania | 42133 | 118572 | 1491 |
2384686 | 2384686 | 2022-04-07 | York | Pennsylvania | 42133 | 118544 | 1491 |
2381431 | 2381431 | 2022-04-06 | York | Pennsylvania | 42133 | 118518 | 1490 |
2378176 | 2378176 | 2022-04-05 | York | Pennsylvania | 42133 | 118484 | 1490 |
2374922 | 2374922 | 2022-04-04 | York | Pennsylvania | 42133 | 118474 | 1486 |
2371670 | 2371670 | 2022-04-03 | York | Pennsylvania | 42133 | 118453 | 1486 |
2368417 | 2368417 | 2022-04-02 | York | Pennsylvania | 42133 | 118453 | 1486 |
2365164 | 2365164 | 2022-04-01 | York | Pennsylvania | 42133 | 118435 | 1485 |
2361911 | 2361911 | 2022-03-31 | York | Pennsylvania | 42133 | 118416 | 1485 |
2358657 | 2358657 | 2022-03-30 | York | Pennsylvania | 42133 | 118389 | 1485 |
2355403 | 2355403 | 2022-03-29 | York | Pennsylvania | 42133 | 118379 | 1485 |
2352150 | 2352150 | 2022-03-28 | York | Pennsylvania | 42133 | 118367 | 1484 |
2348898 | 2348898 | 2022-03-27 | York | Pennsylvania | 42133 | 118359 | 1484 |
2345645 | 2345645 | 2022-03-26 | York | Pennsylvania | 42133 | 118348 | 1484 |
2342392 | 2342392 | 2022-03-25 | York | Pennsylvania | 42133 | 118330 | 1481 |
2339139 | 2339139 | 2022-03-24 | York | Pennsylvania | 42133 | 118310 | 1477 |
2335885 | 2335885 | 2022-03-23 | York | Pennsylvania | 42133 | 118295 | 1477 |
2332631 | 2332631 | 2022-03-22 | York | Pennsylvania | 42133 | 118277 | 1475 |
2329378 | 2329378 | 2022-03-21 | York | Pennsylvania | 42133 | 118264 | 1473 |
2326126 | 2326126 | 2022-03-20 | York | Pennsylvania | 42133 | 118255 | 1473 |
2322873 | 2322873 | 2022-03-19 | York | Pennsylvania | 42133 | 118250 | 1471 |
2319619 | 2319619 | 2022-03-18 | York | Pennsylvania | 42133 | 118235 | 1471 |
2316365 | 2316365 | 2022-03-17 | York | Pennsylvania | 42133 | 118217 | 1470 |
2313112 | 2313112 | 2022-03-16 | York | Pennsylvania | 42133 | 118199 | 1469 |
2309859 | 2309859 | 2022-03-15 | York | Pennsylvania | 42133 | 118172 | 1468 |
2306606 | 2306606 | 2022-03-14 | York | Pennsylvania | 42133 | 118162 | 1466 |
2303355 | 2303355 | 2022-03-13 | York | Pennsylvania | 42133 | 118151 | 1466 |
2300103 | 2300103 | 2022-03-12 | York | Pennsylvania | 42133 | 118139 | 1466 |
2296851 | 2296851 | 2022-03-11 | York | Pennsylvania | 42133 | 118110 | 1465 |
2293599 | 2293599 | 2022-03-10 | York | Pennsylvania | 42133 | 118091 | 1464 |
2290347 | 2290347 | 2022-03-09 | York | Pennsylvania | 42133 | 118068 | 1464 |
2287095 | 2287095 | 2022-03-08 | York | Pennsylvania | 42133 | 118043 | 1463 |
2283843 | 2283843 | 2022-03-07 | York | Pennsylvania | 42133 | 118023 | 1461 |
2280591 | 2280591 | 2022-03-06 | York | Pennsylvania | 42133 | 118003 | 1461 |
2277338 | 2277338 | 2022-03-05 | York | Pennsylvania | 42133 | 117981 | 1460 |
2274085 | 2274085 | 2022-03-04 | York | Pennsylvania | 42133 | 117935 | 1460 |
2270832 | 2270832 | 2022-03-03 | York | Pennsylvania | 42133 | 117911 | 1459 |
2267580 | 2267580 | 2022-03-02 | York | Pennsylvania | 42133 | 117864 | 1458 |
2264327 | 2264327 | 2022-03-01 | York | Pennsylvania | 42133 | 117832 | 1452 |
2261077 | 2261077 | 2022-02-28 | York | Pennsylvania | 42133 | 117826 | 1448 |
2257826 | 2257826 | 2022-02-27 | York | Pennsylvania | 42133 | 117810 | 1448 |
2254575 | 2254575 | 2022-02-26 | York | Pennsylvania | 42133 | 117779 | 1447 |
2251324 | 2251324 | 2022-02-25 | York | Pennsylvania | 42133 | 117500 | 1445 |
2248073 | 2248073 | 2022-02-24 | York | Pennsylvania | 42133 | 117449 | 1440 |
2244822 | 2244822 | 2022-02-23 | York | Pennsylvania | 42133 | 117364 | 1434 |
2241571 | 2241571 | 2022-02-22 | York | Pennsylvania | 42133 | 117303 | 1431 |
2238320 | 2238320 | 2022-02-21 | York | Pennsylvania | 42133 | 117222 | 1431 |
2235069 | 2235069 | 2022-02-20 | York | Pennsylvania | 42133 | 117222 | 1431 |
2231818 | 2231818 | 2022-02-19 | York | Pennsylvania | 42133 | 117152 | 1427 |
2228567 | 2228567 | 2022-02-18 | York | Pennsylvania | 42133 | 117012 | 1427 |
2225316 | 2225316 | 2022-02-17 | York | Pennsylvania | 42133 | 116911 | 1423 |
2222065 | 2222065 | 2022-02-16 | York | Pennsylvania | 42133 | 116773 | 1420 |
2218814 | 2218814 | 2022-02-15 | York | Pennsylvania | 42133 | 116703 | 1412 |
2215563 | 2215563 | 2022-02-14 | York | Pennsylvania | 42133 | 116598 | 1406 |
2212312 | 2212312 | 2022-02-13 | York | Pennsylvania | 42133 | 116532 | 1406 |
2209059 | 2209059 | 2022-02-12 | York | Pennsylvania | 42133 | 116425 | 1406 |
2205806 | 2205806 | 2022-02-11 | York | Pennsylvania | 42133 | 116225 | 1403 |
2202553 | 2202553 | 2022-02-10 | York | Pennsylvania | 42133 | 116070 | 1403 |
2199299 | 2199299 | 2022-02-09 | York | Pennsylvania | 42133 | 115909 | 1403 |
2196045 | 2196045 | 2022-02-08 | York | Pennsylvania | 42133 | 115764 | 1402 |
2192791 | 2192791 | 2022-02-07 | York | Pennsylvania | 42133 | 115818 | 1401 |
2189537 | 2189537 | 2022-02-06 | York | Pennsylvania | 42133 | 115550 | 1401 |
2186284 | 2186284 | 2022-02-05 | York | Pennsylvania | 42133 | 115334 | 1399 |
2183032 | 2183032 | 2022-02-04 | York | Pennsylvania | 42133 | 115038 | 1393 |
2179780 | 2179780 | 2022-02-03 | York | Pennsylvania | 42133 | 114771 | 1388 |
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);