ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 779 ✖
- 2 3
- 377 3
- 301 2
- 349 2
- 39007 2
- 67046 2
- 107408 2
- 121727 2
- 1 1
- 8 1
- 17 1
- 29 1
- 52 1
- 60 1
- 65 1
- 83 1
- 115 1
- 129 1
- 152 1
- 180 1
- 194 1
- 249 1
- 358 1
- 369 1
- 380 1
- 397 1
- 416 1
- 431 1
- 449 1
- 462 1
- 483 1
- 492 1
- 498 1
- 509 1
- 514 1
- 526 1
- 600 1
- 639 1
- 664 1
- 692 1
- 726 1
- 742 1
- 782 1
- 832 1
- 860 1
- 903 1
- 952 1
- 971 1
- 1002 1
- 1056 1
- 1115 1
- 1169 1
- 1218 1
- 1265 1
- 1287 1
- 1308 1
- 1395 1
- 1423 1
- 1440 1
- 1469 1
- 1501 1
- 1520 1
- 1665 1
- 1718 1
- 1771 1
- 1828 1
- 1904 1
- 1953 1
- 1981 1
- 2012 1
- 2033 1
- 2054 1
- 2092 1
- 2133 1
- 2170 1
- 2197 1
- 2228 1
- 2256 1
- 2295 1
- 2329 1
- 2375 1
- 2392 1
- 2408 1
- 2427 1
- 2433 1
- 2454 1
- 2474 1
- 2498 1
- 2519 1
- 2531 1
- 2545 1
- 2558 1
- 2615 1
- 2634 1
- 2644 1
- 2666 1
- 2675 1
- 2702 1
- 2734 1
- 2751 1
- 2782 1
- 2791 1
- 2816 1
- 2822 1
- 2842 1
- 2863 1
- 2897 1
- 2909 1
- 2928 1
- 2949 1
- 2963 1
- 2997 1
- 3029 1
- 3050 1
- 3078 1
- 3100 1
- 3124 1
- 3142 1
- 3179 1
- 3203 1
- 3225 1
- 3240 1
- 3262 1
- 3278 1
- 3290 1
- 3312 1
- 3326 1
- 3344 1
- 3360 1
- 3378 1
- 3389 1
- 3398 1
- 3419 1
- 3437 1
- 3459 1
- 3464 1
- 3477 1
- 3485 1
- 3490 1
- 3515 1
- 3525 1
- 3535 1
- 3556 1
- 3565 1
- 3576 1
- 3585 1
- 3602 1
- 3613 1
- 3627 1
- 3646 1
- 3663 1
- 3674 1
- 3680 1
- 3696 1
- 3712 1
- 3719 1
- 3743 1
- 3756 1
- 3758 1
- 3768 1
- 3792 1
- 3801 1
- 3832 1
- 3847 1
- 3866 1
- 3883 1
- 3892 1
- 3912 1
- 3922 1
- 3937 1
- 3947 1
- 3964 1
- 3983 1
- 3993 1
- 4002 1
- 4012 1
- 4023 1
- 4043 1
- 4060 1
- 4081 1
- 4096 1
- 4114 1
- 4133 1
- 4158 1
- 4185 1
- 4201 1
- 4220 1
- 4231 1
- 4253 1
- 4270 1
- 4300 1
- 4321 1
- 4342 1
- 4365 1
- 4379 1
- 4409 1
- 4424 1
- 4456 1
- 4494 1
- 4528 1
- 4537 1
- 4556 1
- 4593 1
- 4636 1
- 4669 1
- 4693 1
- 4747 1
- 4779 1
- 4807 1
- 4843 1
- 4880 1
- 4908 1
- 4946 1
- 4977 1
- 5011 1
- 5021 1
- 5052 1
- 5121 1
- 5170 1
- 5222 1
- 5277 1
- 5309 1
- 5337 1
- 5399 1
- 5454 1
- 5498 1
- 5603 1
- 5696 1
- 5762 1
- 5795 1
- 5881 1
- 6001 1
- 6122 1
- 6257 1
- 6396 1
- 6491 1
- 6576 1
- 6826 1
- 7021 1
- 7211 1
- 7421 1
- 7650 1
- 7749 1
- 7892 1
- 8084 1
- 8301 1
- 8494 1
- 8735 1
- 8947 1
- 9160 1
- 9362 1
- 9470 1
- 9785 1
- 10024 1
- 10248 1
- 10480 1
- 10701 1
- 10804 1
- 10995 1
- 11281 1
- 11657 1
- 11933 1
- 12358 1
- 12662 1
- 12941 1
- 13188 1
- 13598 1
- 13945 1
- 14397 1
- 14772 1
- 15182 1
- 15481 1
- 15722 1
- 16054 1
- 16429 1
- 16860 1
- 17267 1
- 17586 1
- 17860 1
- 18081 1
- 18351 1
- 18822 1
- 19155 1
- 19452 1
- 19567 1
- 19985 1
- 20278 1
- 20658 1
- 21146 1
- 21508 1
- 21926 1
- 22213 1
- 22697 1
- 22880 1
- 23347 1
- 23764 1
- 24316 1
- 24668 1
- 25057 1
- 25366 1
- 25626 1
- 25855 1
- 26152 1
- 26544 1
- 26954 1
- 27190 1
- 27492 1
- 27755 1
- 27948 1
- 28226 1
- 28476 1
- 28797 1
- 29039 1
- 29147 1
- 29264 1
- 29433 1
- 29588 1
- 29690 1
- 29860 1
- 30054 1
- 30124 1
- 30232 1
- 30350 1
- 30421 1
- 30563 1
- 30697 1
- 30795 1
- 30872 1
- 30931 1
- 31054 1
- 31167 1
- 31261 1
- 31351 1
- 31445 1
- 31505 1
- 31580 1
- 31639 1
- 31718 1
- 31793 1
- 31848 1
- 31909 1
- 31954 1
- 32017 1
- 32054 1
- 32151 1
- 32224 1
- 32312 1
- 32410 1
- 32452 1
- 32489 1
- 32562 1
- 32606 1
- 32681 1
- 32733 1
- 32798 1
- 32857 1
- 32891 1
- 32941 1
- 32998 1
- 33067 1
- 33107 1
- 33162 1
- 33203 1
- 33249 1
- 33312 1
- 33385 1
- 33441 1
- 33504 1
- 33584 1
- 33617 1
- 33689 1
- 33736 1
- 33805 1
- 33879 1
- 33978 1
- 34062 1
- 34127 1
- 34176 1
- 34235 1
- 34328 1
- 34438 1
- 34531 1
- 34629 1
- 34741 1
- 34773 1
- 34868 1
- 35014 1
- 35149 1
- 35252 1
- 35353 1
- 35415 1
- 35490 1
- 35576 1
- 35694 1
- 35790 1
- 35941 1
- 36061 1
- 36119 1
- 36191 1
- 36254 1
- 36344 1
- 36472 1
- 36536 1
- 36643 1
- 36689 1
- 36760 1
- 36853 1
- 36982 1
- 37125 1
- 37232 1
- 37316 1
- 37359 1
- 37416 1
- 37457 1
- 37518 1
- 37558 1
- 37609 1
- 37714 1
- 37744 1
- 37769 1
- 37841 1
- 37901 1
- 37973 1
- 38048 1
- 38098 1
- 38132 1
- 38158 1
- 38230 1
- 38287 1
- 38339 1
- 38380 1
- 38418 1
- 38458 1
- 38475 1
- 38525 1
- 38557 1
- 38596 1
- 38643 1
- 38691 1
- 38703 1
- 38715 1
- 38726 1
- 38740 1
- 38758 1
- 38798 1
- 38816 1
- 38839 1
- 38849 1
- 38859 1
- 38875 1
- 38888 1
- 38903 1
- 38913 1
- 38928 1
- 38931 1
- 38941 1
- 38954 1
- 38960 1
- 38970 1
- 38976 1
- 38980 1
- 38990 1
- 38998 1
- 39004 1
- 39020 1
- 39024 1
- 39030 1
- 39035 1
- 39044 1
- 39066 1
- 39074 1
- 39084 1
- 39089 1
- 39094 1
- 39101 1
- 39107 1
- 39126 1
- 39130 1
- 39139 1
- 39148 1
- 39159 1
- 39166 1
- 39173 1
- 39180 1
- 39182 1
- 39209 1
- 39212 1
- 39228 1
- 39242 1
- 39253 1
- 39271 1
- 39280 1
- 39310 1
- 39320 1
- 39348 1
- 39383 1
- 39420 1
- 39473 1
- 39537 1
- 39580 1
- 39603 1
- 39672 1
- 39738 1
- 39797 1
- 39850 1
- 39964 1
- 40030 1
- 40076 1
- 40136 1
- 40200 1
- 40301 1
- 40404 1
- 40520 1
- 40621 1
- 40711 1
- 40807 1
- 40912 1
- 41016 1
- 41119 1
- 41256 1
- 41364 1
- 41493 1
- 41532 1
- 41600 1
- 41688 1
- 41986 1
- 42103 1
- 42182 1
- 42362 1
- 42456 1
- 42553 1
- 42691 1
- 42914 1
- 43076 1
- 43166 1
- 43325 1
- 43420 1
- 43526 1
- 43698 1
- 43906 1
- 44085 1
- 44329 1
- 44435 1
- 44486 1
- 44596 1
- 44884 1
- 45101 1
- 45229 1
- 45436 1
- 45521 1
- 45732 1
- 45853 1
- 45981 1
- 46325 1
- 46538 1
- 46663 1
- 46939 1
- 47082 1
- 47374 1
- 47570 1
- 47924 1
- 48123 1
- 48409 1
- 48488 1
- 48651 1
- 49000 1
- 49204 1
- 49517 1
- 49737 1
- 49878 1
- 50137 1
- 50231 1
- 50426 1
- 50637 1
- 50966 1
- 51242 1
- 51456 1
- 51624 1
- 51689 1
- 51911 1
- 52054 1
- 52166 1
- 52355 1
- 52461 1
- 52624 1
- 52686 1
- 52942 1
- 53074 1
- 53379 1
- 53532 1
- 53686 1
- 53813 1
- 53927 1
- 54094 1
- 54275 1
- 54461 1
- 54627 1
- 54811 1
- 54953 1
- 55074 1
- 55282 1
- 55512 1
- 55714 1
- 55934 1
- 56093 1
- 56228 1
- 56370 1
- 56645 1
- 56962 1
- 57247 1
- 57449 1
- 57751 1
- 57914 1
- 58070 1
- 58327 1
- 58601 1
- 58795 1
- 58942 1
- 59057 1
- 59188 1
- 59393 1
- 59728 1
- 60114 1
- 60557 1
- 60869 1
- 61261 1
- 61428 1
- 61679 1
- 62018 1
- 62372 1
- 62668 1
- 62935 1
- 63178 1
- 63396 1
- 63582 1
- 63907 1
- 64227 1
- 64567 1
- 64961 1
- 65258 1
- 65494 1
- 65719 1
- 66123 1
- 66615 1
- 67800 1
- 67978 1
- 68287 1
- 69041 1
- 69885 1
- 70960 1
- 72173 1
- 72921 1
- 73874 1
- 74960 1
- 76730 1
- 78104 1
- 80188 1
- 82087 1
- 83866 1
- 84975 1
- 85964 1
- 87307 1
- 88707 1
- 89688 1
- 91347 1
- 92358 1
- 93076 1
- 93776 1
- 94516 1
- 95860 1
- 96720 1
- 97726 1
- 98269 1
- 98669 1
- 99337 1
- 99999 1
- 100596 1
- 100975 1
- 101518 1
- 101867 1
- 102108 1
- 102348 1
- 102848 1
- 103195 1
- 103496 1
- 103840 1
- 103968 1
- 104107 1
- 104412 1
- 104657 1
- 104897 1
- 105048 1
- 105247 1
- 105413 1
- 105492 1
- 105589 1
- 105776 1
- 105917 1
- 106091 1
- 106211 1
- 106307 1
- 106365 1
- 106442 1
- 106548 1
- 106670 1
- 106793 1
- 106883 1
- 106938 1
- 107001 1
- 107100 1
- 107268 1
- 107652 1
- 107706 1
- 107756 1
- 107847 1
- 108013 1
- 108097 1
- 108272 1
- 108353 1
- 108500 1
- 108543 1
- 108734 1
- 108851 1
- 109088 1
- 109206 1
- 109421 1
- 109547 1
- 109618 1
- 109846 1
- 110228 1
- 110504 1
- 110775 1
- 110947 1
- 111161 1
- 111323 1
- 111597 1
- 111793 1
- 112251 1
- 112463 1
- 112687 1
- 112866 1
- 113021 1
- 113177 1
- 113427 1
- 113728 1
- 114017 1
- 114262 1
- 114488 1
- 114684 1
- 114864 1
- 115150 1
- 115487 1
- 115777 1
- 116097 1
- 116313 1
- 116493 1
- 116674 1
- 116954 1
- 117302 1
- 117542 1
- 117831 1
- 118031 1
- 118231 1
- 118381 1
- 118676 1
- 118997 1
- 119268 1
- 119467 1
- 119644 1
- 119809 1
- 119941 1
- 120191 1
- 120457 1
- 120720 1
- 120905 1
- 121096 1
- 121238 1
- 121351 1
- 121517 1
state 1
- New York 789
fips 1
- 36067 · 789 ✖
county 1
- Onondaga 789
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501459 | 2501459 | 2022-05-13 | Onondaga | New York | 36067 | 121727 | 1073 |
2498201 | 2498201 | 2022-05-12 | Onondaga | New York | 36067 | 121727 | 1073 |
2494943 | 2494943 | 2022-05-11 | Onondaga | New York | 36067 | 121517 | 1073 |
2491685 | 2491685 | 2022-05-10 | Onondaga | New York | 36067 | 121351 | 1072 |
2488427 | 2488427 | 2022-05-09 | Onondaga | New York | 36067 | 121238 | 1072 |
2485170 | 2485170 | 2022-05-08 | Onondaga | New York | 36067 | 121096 | 1071 |
2481912 | 2481912 | 2022-05-07 | Onondaga | New York | 36067 | 120905 | 1069 |
2478654 | 2478654 | 2022-05-06 | Onondaga | New York | 36067 | 120720 | 1068 |
2475396 | 2475396 | 2022-05-05 | Onondaga | New York | 36067 | 120457 | 1066 |
2472139 | 2472139 | 2022-05-04 | Onondaga | New York | 36067 | 120191 | 1065 |
2468883 | 2468883 | 2022-05-03 | Onondaga | New York | 36067 | 119941 | 1065 |
2465627 | 2465627 | 2022-05-02 | Onondaga | New York | 36067 | 119809 | 1064 |
2462372 | 2462372 | 2022-05-01 | Onondaga | New York | 36067 | 119644 | 1063 |
2459116 | 2459116 | 2022-04-30 | Onondaga | New York | 36067 | 119467 | 1062 |
2455860 | 2455860 | 2022-04-29 | Onondaga | New York | 36067 | 119268 | 1060 |
2452604 | 2452604 | 2022-04-28 | Onondaga | New York | 36067 | 118997 | 1060 |
2449348 | 2449348 | 2022-04-27 | Onondaga | New York | 36067 | 118676 | 1058 |
2446091 | 2446091 | 2022-04-26 | Onondaga | New York | 36067 | 118381 | 1056 |
2442836 | 2442836 | 2022-04-25 | Onondaga | New York | 36067 | 118231 | 1055 |
2439580 | 2439580 | 2022-04-24 | Onondaga | New York | 36067 | 118031 | 1053 |
2436324 | 2436324 | 2022-04-23 | Onondaga | New York | 36067 | 117831 | 1051 |
2433068 | 2433068 | 2022-04-22 | Onondaga | New York | 36067 | 117542 | 1051 |
2429812 | 2429812 | 2022-04-21 | Onondaga | New York | 36067 | 117302 | 1049 |
2426556 | 2426556 | 2022-04-20 | Onondaga | New York | 36067 | 116954 | 1048 |
2423300 | 2423300 | 2022-04-19 | Onondaga | New York | 36067 | 116674 | 1048 |
2420043 | 2420043 | 2022-04-18 | Onondaga | New York | 36067 | 116493 | 1047 |
2416788 | 2416788 | 2022-04-17 | Onondaga | New York | 36067 | 116313 | 1047 |
2413532 | 2413532 | 2022-04-16 | Onondaga | New York | 36067 | 116097 | 1047 |
2410276 | 2410276 | 2022-04-15 | Onondaga | New York | 36067 | 115777 | 1047 |
2407020 | 2407020 | 2022-04-14 | Onondaga | New York | 36067 | 115487 | 1047 |
2403764 | 2403764 | 2022-04-13 | Onondaga | New York | 36067 | 115150 | 1047 |
2400509 | 2400509 | 2022-04-12 | Onondaga | New York | 36067 | 114864 | 1047 |
2397254 | 2397254 | 2022-04-11 | Onondaga | New York | 36067 | 114684 | 1047 |
2393999 | 2393999 | 2022-04-10 | Onondaga | New York | 36067 | 114488 | 1047 |
2390743 | 2390743 | 2022-04-09 | Onondaga | New York | 36067 | 114262 | 1046 |
2387487 | 2387487 | 2022-04-08 | Onondaga | New York | 36067 | 114017 | 1046 |
2384232 | 2384232 | 2022-04-07 | Onondaga | New York | 36067 | 113728 | 1046 |
2380977 | 2380977 | 2022-04-06 | Onondaga | New York | 36067 | 113427 | 1046 |
2377722 | 2377722 | 2022-04-05 | Onondaga | New York | 36067 | 113177 | 1046 |
2374469 | 2374469 | 2022-04-04 | Onondaga | New York | 36067 | 113021 | 1044 |
2371217 | 2371217 | 2022-04-03 | Onondaga | New York | 36067 | 112866 | 1043 |
2367964 | 2367964 | 2022-04-02 | Onondaga | New York | 36067 | 112687 | 1042 |
2364711 | 2364711 | 2022-04-01 | Onondaga | New York | 36067 | 112463 | 1042 |
2361457 | 2361457 | 2022-03-31 | Onondaga | New York | 36067 | 112251 | 1040 |
2358203 | 2358203 | 2022-03-30 | Onondaga | New York | 36067 | 111793 | 1040 |
2354949 | 2354949 | 2022-03-29 | Onondaga | New York | 36067 | 111597 | 1040 |
2351696 | 2351696 | 2022-03-28 | Onondaga | New York | 36067 | 111323 | 1040 |
2348444 | 2348444 | 2022-03-27 | Onondaga | New York | 36067 | 111161 | 1040 |
2345191 | 2345191 | 2022-03-26 | Onondaga | New York | 36067 | 110947 | 1040 |
2341938 | 2341938 | 2022-03-25 | Onondaga | New York | 36067 | 110775 | 1039 |
2338685 | 2338685 | 2022-03-24 | Onondaga | New York | 36067 | 110504 | 1039 |
2335431 | 2335431 | 2022-03-23 | Onondaga | New York | 36067 | 110228 | 1039 |
2332177 | 2332177 | 2022-03-22 | Onondaga | New York | 36067 | 109846 | 1038 |
2328924 | 2328924 | 2022-03-21 | Onondaga | New York | 36067 | 109618 | 1038 |
2325672 | 2325672 | 2022-03-20 | Onondaga | New York | 36067 | 109547 | 1038 |
2322419 | 2322419 | 2022-03-19 | Onondaga | New York | 36067 | 109421 | 1038 |
2319165 | 2319165 | 2022-03-18 | Onondaga | New York | 36067 | 109206 | 1038 |
2315911 | 2315911 | 2022-03-17 | Onondaga | New York | 36067 | 109088 | 1038 |
2312658 | 2312658 | 2022-03-16 | Onondaga | New York | 36067 | 108851 | 1038 |
2309405 | 2309405 | 2022-03-15 | Onondaga | New York | 36067 | 108734 | 1037 |
2306152 | 2306152 | 2022-03-14 | Onondaga | New York | 36067 | 108543 | 1037 |
2302901 | 2302901 | 2022-03-13 | Onondaga | New York | 36067 | 108500 | 1036 |
2299649 | 2299649 | 2022-03-12 | Onondaga | New York | 36067 | 108353 | 1036 |
2296397 | 2296397 | 2022-03-11 | Onondaga | New York | 36067 | 108272 | 1036 |
2293145 | 2293145 | 2022-03-10 | Onondaga | New York | 36067 | 108097 | 1036 |
2289893 | 2289893 | 2022-03-09 | Onondaga | New York | 36067 | 108013 | 1035 |
2286641 | 2286641 | 2022-03-08 | Onondaga | New York | 36067 | 107847 | 1033 |
2283389 | 2283389 | 2022-03-07 | Onondaga | New York | 36067 | 107756 | 1032 |
2280137 | 2280137 | 2022-03-06 | Onondaga | New York | 36067 | 107706 | 1031 |
2276884 | 2276884 | 2022-03-05 | Onondaga | New York | 36067 | 107652 | 1031 |
2273631 | 2273631 | 2022-03-04 | Onondaga | New York | 36067 | 107408 | 1030 |
2270378 | 2270378 | 2022-03-03 | Onondaga | New York | 36067 | 107408 | 1030 |
2267126 | 2267126 | 2022-03-02 | Onondaga | New York | 36067 | 107268 | 1029 |
2263874 | 2263874 | 2022-03-01 | Onondaga | New York | 36067 | 107100 | 1029 |
2260623 | 2260623 | 2022-02-28 | Onondaga | New York | 36067 | 107001 | 1029 |
2257372 | 2257372 | 2022-02-27 | Onondaga | New York | 36067 | 106938 | 1027 |
2254121 | 2254121 | 2022-02-26 | Onondaga | New York | 36067 | 106883 | 1025 |
2250870 | 2250870 | 2022-02-25 | Onondaga | New York | 36067 | 106793 | 1023 |
2247619 | 2247619 | 2022-02-24 | Onondaga | New York | 36067 | 106670 | 1022 |
2244368 | 2244368 | 2022-02-23 | Onondaga | New York | 36067 | 106548 | 1022 |
2241117 | 2241117 | 2022-02-22 | Onondaga | New York | 36067 | 106442 | 1021 |
2237866 | 2237866 | 2022-02-21 | Onondaga | New York | 36067 | 106365 | 1021 |
2234615 | 2234615 | 2022-02-20 | Onondaga | New York | 36067 | 106307 | 1019 |
2231364 | 2231364 | 2022-02-19 | Onondaga | New York | 36067 | 106211 | 1016 |
2228113 | 2228113 | 2022-02-18 | Onondaga | New York | 36067 | 106091 | 1015 |
2224862 | 2224862 | 2022-02-17 | Onondaga | New York | 36067 | 105917 | 1012 |
2221611 | 2221611 | 2022-02-16 | Onondaga | New York | 36067 | 105776 | 1010 |
2218360 | 2218360 | 2022-02-15 | Onondaga | New York | 36067 | 105589 | 1010 |
2215109 | 2215109 | 2022-02-14 | Onondaga | New York | 36067 | 105492 | 1009 |
2211858 | 2211858 | 2022-02-13 | Onondaga | New York | 36067 | 105413 | 1006 |
2208605 | 2208605 | 2022-02-12 | Onondaga | New York | 36067 | 105247 | 1003 |
2205352 | 2205352 | 2022-02-11 | Onondaga | New York | 36067 | 105048 | 1003 |
2202099 | 2202099 | 2022-02-10 | Onondaga | New York | 36067 | 104897 | 997 |
2198845 | 2198845 | 2022-02-09 | Onondaga | New York | 36067 | 104657 | 995 |
2195591 | 2195591 | 2022-02-08 | Onondaga | New York | 36067 | 104412 | 992 |
2192337 | 2192337 | 2022-02-07 | Onondaga | New York | 36067 | 104107 | 989 |
2189083 | 2189083 | 2022-02-06 | Onondaga | New York | 36067 | 103968 | 989 |
2185830 | 2185830 | 2022-02-05 | Onondaga | New York | 36067 | 103840 | 988 |
2182578 | 2182578 | 2022-02-04 | Onondaga | New York | 36067 | 103496 | 985 |
2179326 | 2179326 | 2022-02-03 | Onondaga | New York | 36067 | 103195 | 983 |
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);