ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Rockland" and fips = 36087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 792 ✖
- 2 3
- 6 2
- 46969 2
- 60364 2
- 91221 2
- 96142 2
- 4 1
- 7 1
- 9 1
- 12 1
- 13 1
- 16 1
- 22 1
- 30 1
- 53 1
- 101 1
- 262 1
- 455 1
- 592 1
- 671 1
- 1069 1
- 1197 1
- 1457 1
- 1896 1
- 2209 1
- 2511 1
- 2863 1
- 3321 1
- 3751 1
- 4289 1
- 4872 1
- 5362 1
- 5703 1
- 5990 1
- 6413 1
- 6665 1
- 7122 1
- 7477 1
- 7721 1
- 7965 1
- 8335 1
- 8474 1
- 8752 1
- 8987 1
- 9171 1
- 9364 1
- 9457 1
- 9568 1
- 9699 1
- 9828 1
- 10091 1
- 11091 1
- 11256 1
- 11366 1
- 11453 1
- 11586 1
- 11708 1
- 11812 1
- 11945 1
- 12025 1
- 12095 1
- 12144 1
- 12204 1
- 12280 1
- 12349 1
- 12400 1
- 12451 1
- 12484 1
- 12504 1
- 12543 1
- 12596 1
- 12637 1
- 12688 1
- 12758 1
- 12777 1
- 12798 1
- 12831 1
- 12877 1
- 12905 1
- 12934 1
- 12963 1
- 12996 1
- 13019 1
- 13047 1
- 13076 1
- 13100 1
- 13128 1
- 13151 1
- 13185 1
- 13223 1
- 13259 1
- 13280 1
- 13297 1
- 13315 1
- 13325 1
- 13340 1
- 13353 1
- 13372 1
- 13385 1
- 13396 1
- 13411 1
- 13423 1
- 13441 1
- 13460 1
- 13467 1
- 13474 1
- 13486 1
- 13495 1
- 13504 1
- 13514 1
- 13529 1
- 13534 1
- 13549 1
- 13557 1
- 13566 1
- 13576 1
- 13580 1
- 13590 1
- 13602 1
- 13612 1
- 13623 1
- 13629 1
- 13648 1
- 13656 1
- 13668 1
- 13679 1
- 13683 1
- 13691 1
- 13700 1
- 13716 1
- 13719 1
- 13733 1
- 13743 1
- 13763 1
- 13775 1
- 13784 1
- 13793 1
- 13798 1
- 13806 1
- 13812 1
- 13820 1
- 13830 1
- 13837 1
- 13839 1
- 13841 1
- 13845 1
- 13852 1
- 13860 1
- 13864 1
- 13880 1
- 13882 1
- 13885 1
- 13893 1
- 13903 1
- 13918 1
- 13925 1
- 13936 1
- 13942 1
- 13949 1
- 13954 1
- 13966 1
- 13973 1
- 13981 1
- 13997 1
- 14007 1
- 14011 1
- 14053 1
- 14067 1
- 14089 1
- 14106 1
- 14118 1
- 14129 1
- 14139 1
- 14149 1
- 14161 1
- 14183 1
- 14197 1
- 14218 1
- 14233 1
- 14255 1
- 14271 1
- 14305 1
- 14334 1
- 14358 1
- 14382 1
- 14396 1
- 14418 1
- 14439 1
- 14459 1
- 14480 1
- 14510 1
- 14530 1
- 14547 1
- 14581 1
- 14617 1
- 14660 1
- 14698 1
- 14747 1
- 14801 1
- 14823 1
- 14833 1
- 14891 1
- 14954 1
- 14998 1
- 15045 1
- 15100 1
- 15167 1
- 15277 1
- 15342 1
- 15452 1
- 15636 1
- 15849 1
- 15973 1
- 16016 1
- 16071 1
- 16190 1
- 16256 1
- 16454 1
- 16599 1
- 16690 1
- 16717 1
- 16760 1
- 16829 1
- 16891 1
- 16972 1
- 17063 1
- 17125 1
- 17171 1
- 17207 1
- 17269 1
- 17453 1
- 17524 1
- 17581 1
- 17635 1
- 17685 1
- 17760 1
- 17832 1
- 17943 1
- 18024 1
- 18110 1
- 18177 1
- 18265 1
- 18353 1
- 18466 1
- 18581 1
- 18683 1
- 18756 1
- 18854 1
- 18910 1
- 18995 1
- 19133 1
- 19277 1
- 19414 1
- 19567 1
- 19723 1
- 19843 1
- 19904 1
- 20044 1
- 20176 1
- 20263 1
- 20351 1
- 20511 1
- 20602 1
- 20708 1
- 20824 1
- 20942 1
- 21111 1
- 21258 1
- 21378 1
- 21502 1
- 21632 1
- 21845 1
- 22048 1
- 22221 1
- 22421 1
- 22633 1
- 22800 1
- 22897 1
- 23072 1
- 23308 1
- 23505 1
- 23680 1
- 23849 1
- 23991 1
- 24183 1
- 24334 1
- 24555 1
- 24787 1
- 24983 1
- 25124 1
- 25275 1
- 25413 1
- 25579 1
- 25839 1
- 26048 1
- 26291 1
- 26433 1
- 26570 1
- 26707 1
- 26926 1
- 27193 1
- 27510 1
- 27768 1
- 28011 1
- 28162 1
- 28335 1
- 28568 1
- 28861 1
- 29202 1
- 29444 1
- 29660 1
- 29827 1
- 30015 1
- 30273 1
- 30557 1
- 30770 1
- 31061 1
- 31346 1
- 31509 1
- 31668 1
- 31884 1
- 32137 1
- 32407 1
- 32660 1
- 32948 1
- 33124 1
- 33327 1
- 33532 1
- 33769 1
- 33995 1
- 34174 1
- 34465 1
- 34589 1
- 34704 1
- 34830 1
- 34950 1
- 35094 1
- 35252 1
- 35495 1
- 35628 1
- 35769 1
- 35927 1
- 36061 1
- 36247 1
- 36423 1
- 36590 1
- 36672 1
- 36777 1
- 36954 1
- 37088 1
- 37200 1
- 37320 1
- 37478 1
- 37579 1
- 37674 1
- 37833 1
- 37948 1
- 38138 1
- 38265 1
- 38416 1
- 38538 1
- 38628 1
- 38797 1
- 38955 1
- 39149 1
- 39324 1
- 39546 1
- 39673 1
- 39805 1
- 40010 1
- 40203 1
- 40407 1
- 40631 1
- 40758 1
- 40870 1
- 40988 1
- 41175 1
- 41359 1
- 41546 1
- 41729 1
- 41858 1
- 41990 1
- 42077 1
- 42250 1
- 42384 1
- 42556 1
- 42741 1
- 42932 1
- 43130 1
- 43237 1
- 43375 1
- 43585 1
- 43718 1
- 43886 1
- 44052 1
- 44150 1
- 44234 1
- 44384 1
- 44503 1
- 44642 1
- 44823 1
- 44952 1
- 45068 1
- 45148 1
- 45245 1
- 45345 1
- 45439 1
- 45527 1
- 45651 1
- 45700 1
- 45739 1
- 45795 1
- 45849 1
- 45922 1
- 46001 1
- 46049 1
- 46083 1
- 46113 1
- 46149 1
- 46181 1
- 46231 1
- 46268 1
- 46319 1
- 46347 1
- 46362 1
- 46388 1
- 46446 1
- 46483 1
- 46511 1
- 46532 1
- 46545 1
- 46553 1
- 46564 1
- 46586 1
- 46607 1
- 46626 1
- 46656 1
- 46673 1
- 46697 1
- 46704 1
- 46715 1
- 46731 1
- 46747 1
- 46768 1
- 46777 1
- 46782 1
- 46793 1
- 46809 1
- 46821 1
- 46829 1
- 46835 1
- 46844 1
- 46849 1
- 46857 1
- 46864 1
- 46868 1
- 46882 1
- 46894 1
- 46904 1
- 46905 1
- 46909 1
- 46915 1
- 46920 1
- 46924 1
- 46930 1
- 46935 1
- 46936 1
- 46944 1
- 46948 1
- 46952 1
- 46958 1
- 46965 1
- 46981 1
- 46986 1
- 46987 1
- 46995 1
- 47007 1
- 47011 1
- 47014 1
- 47017 1
- 47022 1
- 47027 1
- 47068 1
- 47076 1
- 47081 1
- 47086 1
- 47093 1
- 47105 1
- 47114 1
- 47131 1
- 47143 1
- 47151 1
- 47156 1
- 47168 1
- 47179 1
- 47190 1
- 47203 1
- 47221 1
- 47227 1
- 47236 1
- 47247 1
- 47258 1
- 47269 1
- 47288 1
- 47307 1
- 47326 1
- 47345 1
- 47386 1
- 47409 1
- 47434 1
- 47465 1
- 47509 1
- 47535 1
- 47553 1
- 47596 1
- 47648 1
- 47721 1
- 47809 1
- 47869 1
- 47914 1
- 47974 1
- 48030 1
- 48101 1
- 48188 1
- 48247 1
- 48302 1
- 48355 1
- 48385 1
- 48452 1
- 48497 1
- 48569 1
- 48613 1
- 48673 1
- 48734 1
- 48767 1
- 48808 1
- 48895 1
- 48943 1
- 49020 1
- 49090 1
- 49138 1
- 49169 1
- 49219 1
- 49276 1
- 49369 1
- 49429 1
- 49503 1
- 49570 1
- 49597 1
- 49679 1
- 49735 1
- 49780 1
- 49823 1
- 49894 1
- 50015 1
- 50062 1
- 50133 1
- 50261 1
- 50360 1
- 50441 1
- 50497 1
- 50600 1
- 50716 1
- 50818 1
- 50893 1
- 50943 1
- 50996 1
- 51090 1
- 51151 1
- 51271 1
- 51342 1
- 51420 1
- 51464 1
- 51560 1
- 51646 1
- 51729 1
- 51780 1
- 51883 1
- 51974 1
- 52101 1
- 52185 1
- 52270 1
- 52312 1
- 52412 1
- 52466 1
- 52558 1
- 52635 1
- 52711 1
- 52800 1
- 52859 1
- 52918 1
- 52979 1
- 53047 1
- 53112 1
- 53178 1
- 53233 1
- 53278 1
- 53317 1
- 53368 1
- 53426 1
- 53518 1
- 53571 1
- 53632 1
- 53682 1
- 53719 1
- 53765 1
- 53822 1
- 53878 1
- 53959 1
- 54014 1
- 54049 1
- 54068 1
- 54130 1
- 54181 1
- 54249 1
- 54317 1
- 54375 1
- 54425 1
- 54467 1
- 54533 1
- 54607 1
- 54686 1
- 54756 1
- 54824 1
- 54877 1
- 54921 1
- 54984 1
- 55056 1
- 55139 1
- 55201 1
- 55272 1
- 55357 1
- 55405 1
- 55509 1
- 55617 1
- 55730 1
- 55844 1
- 55960 1
- 56085 1
- 56166 1
- 56262 1
- 56362 1
- 56511 1
- 56632 1
- 56757 1
- 56856 1
- 56975 1
- 57095 1
- 57289 1
- 57487 1
- 57706 1
- 58012 1
- 58283 1
- 58489 1
- 58781 1
- 59161 1
- 59723 1
- 61500 1
- 61717 1
- 62396 1
- 63822 1
- 65029 1
- 66565 1
- 68241 1
- 69087 1
- 69935 1
- 71182 1
- 72914 1
- 74264 1
- 75775 1
- 77349 1
- 78478 1
- 79119 1
- 79971 1
- 80991 1
- 82015 1
- 82995 1
- 83819 1
- 85172 1
- 85695 1
- 86360 1
- 86822 1
- 87192 1
- 87552 1
- 87911 1
- 88160 1
- 88325 1
- 88469 1
- 88879 1
- 89063 1
- 89295 1
- 89435 1
- 89532 1
- 89631 1
- 89702 1
- 89813 1
- 89909 1
- 89998 1
- 90067 1
- 90183 1
- 90239 1
- 90332 1
- 90514 1
- 90574 1
- 90628 1
- 90674 1
- 90723 1
- 90758 1
- 90802 1
- 90841 1
- 90885 1
- 90931 1
- 90972 1
- 90993 1
- 91010 1
- 91033 1
- 91052 1
- 91078 1
- 91111 1
- 91135 1
- 91154 1
- 91166 1
- 91180 1
- 91196 1
- 91290 1
- 91307 1
- 91321 1
- 91337 1
- 91365 1
- 91394 1
- 91415 1
- 91442 1
- 91460 1
- 91475 1
- 91503 1
- 91531 1
- 91600 1
- 91629 1
- 91671 1
- 91700 1
- 91718 1
- 91739 1
- 91787 1
- 91830 1
- 91871 1
- 91906 1
- 91947 1
- 91979 1
- 92011 1
- 92056 1
- 92126 1
- 92205 1
- 92283 1
- 92343 1
- 92377 1
- 92405 1
- 92460 1
- 92550 1
- 92620 1
- 92705 1
- 92783 1
- 92841 1
- 92905 1
- 93010 1
- 93103 1
- 93194 1
- 93286 1
- 93347 1
- 93413 1
- 93483 1
- 93544 1
- 93618 1
- 93744 1
- 93819 1
- 93887 1
- 93943 1
- 94024 1
- 94130 1
- 94229 1
- 94359 1
- 94467 1
- 94576 1
- 94646 1
- 94746 1
- 94879 1
- 95018 1
- 95195 1
- 95326 1
- 95605 1
- 95688 1
- 95792 1
- 95943 1
state 1
- New York 799
fips 1
- 36087 · 799 ✖
county 1
- Rockland · 799 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501467 | 2501467 | 2022-05-13 | Rockland | New York | 36087 | 96142 | 897 |
2498209 | 2498209 | 2022-05-12 | Rockland | New York | 36087 | 96142 | 897 |
2494951 | 2494951 | 2022-05-11 | Rockland | New York | 36087 | 95943 | 897 |
2491693 | 2491693 | 2022-05-10 | Rockland | New York | 36087 | 95792 | 896 |
2488435 | 2488435 | 2022-05-09 | Rockland | New York | 36087 | 95688 | 896 |
2485178 | 2485178 | 2022-05-08 | Rockland | New York | 36087 | 95605 | 896 |
2481920 | 2481920 | 2022-05-07 | Rockland | New York | 36087 | 95326 | 896 |
2478662 | 2478662 | 2022-05-06 | Rockland | New York | 36087 | 95195 | 895 |
2475404 | 2475404 | 2022-05-05 | Rockland | New York | 36087 | 95018 | 894 |
2472147 | 2472147 | 2022-05-04 | Rockland | New York | 36087 | 94879 | 894 |
2468891 | 2468891 | 2022-05-03 | Rockland | New York | 36087 | 94746 | 893 |
2465635 | 2465635 | 2022-05-02 | Rockland | New York | 36087 | 94646 | 893 |
2462380 | 2462380 | 2022-05-01 | Rockland | New York | 36087 | 94576 | 893 |
2459124 | 2459124 | 2022-04-30 | Rockland | New York | 36087 | 94467 | 893 |
2455868 | 2455868 | 2022-04-29 | Rockland | New York | 36087 | 94359 | 893 |
2452612 | 2452612 | 2022-04-28 | Rockland | New York | 36087 | 94229 | 893 |
2449356 | 2449356 | 2022-04-27 | Rockland | New York | 36087 | 94130 | 892 |
2446099 | 2446099 | 2022-04-26 | Rockland | New York | 36087 | 94024 | 892 |
2442844 | 2442844 | 2022-04-25 | Rockland | New York | 36087 | 93943 | 892 |
2439588 | 2439588 | 2022-04-24 | Rockland | New York | 36087 | 93887 | 892 |
2436332 | 2436332 | 2022-04-23 | Rockland | New York | 36087 | 93819 | 892 |
2433076 | 2433076 | 2022-04-22 | Rockland | New York | 36087 | 93744 | 892 |
2429820 | 2429820 | 2022-04-21 | Rockland | New York | 36087 | 93618 | 892 |
2426564 | 2426564 | 2022-04-20 | Rockland | New York | 36087 | 93544 | 892 |
2423308 | 2423308 | 2022-04-19 | Rockland | New York | 36087 | 93483 | 891 |
2420051 | 2420051 | 2022-04-18 | Rockland | New York | 36087 | 93413 | 891 |
2416796 | 2416796 | 2022-04-17 | Rockland | New York | 36087 | 93347 | 891 |
2413540 | 2413540 | 2022-04-16 | Rockland | New York | 36087 | 93286 | 891 |
2410284 | 2410284 | 2022-04-15 | Rockland | New York | 36087 | 93194 | 891 |
2407028 | 2407028 | 2022-04-14 | Rockland | New York | 36087 | 93103 | 891 |
2403772 | 2403772 | 2022-04-13 | Rockland | New York | 36087 | 93010 | 891 |
2400517 | 2400517 | 2022-04-12 | Rockland | New York | 36087 | 92905 | 891 |
2397262 | 2397262 | 2022-04-11 | Rockland | New York | 36087 | 92841 | 891 |
2394007 | 2394007 | 2022-04-10 | Rockland | New York | 36087 | 92783 | 891 |
2390751 | 2390751 | 2022-04-09 | Rockland | New York | 36087 | 92705 | 891 |
2387495 | 2387495 | 2022-04-08 | Rockland | New York | 36087 | 92620 | 891 |
2384240 | 2384240 | 2022-04-07 | Rockland | New York | 36087 | 92550 | 891 |
2380985 | 2380985 | 2022-04-06 | Rockland | New York | 36087 | 92460 | 891 |
2377730 | 2377730 | 2022-04-05 | Rockland | New York | 36087 | 92405 | 891 |
2374477 | 2374477 | 2022-04-04 | Rockland | New York | 36087 | 92377 | 891 |
2371225 | 2371225 | 2022-04-03 | Rockland | New York | 36087 | 92343 | 891 |
2367972 | 2367972 | 2022-04-02 | Rockland | New York | 36087 | 92283 | 891 |
2364719 | 2364719 | 2022-04-01 | Rockland | New York | 36087 | 92205 | 891 |
2361465 | 2361465 | 2022-03-31 | Rockland | New York | 36087 | 92126 | 891 |
2358211 | 2358211 | 2022-03-30 | Rockland | New York | 36087 | 92056 | 891 |
2354957 | 2354957 | 2022-03-29 | Rockland | New York | 36087 | 92011 | 891 |
2351704 | 2351704 | 2022-03-28 | Rockland | New York | 36087 | 91979 | 891 |
2348452 | 2348452 | 2022-03-27 | Rockland | New York | 36087 | 91947 | 891 |
2345199 | 2345199 | 2022-03-26 | Rockland | New York | 36087 | 91906 | 891 |
2341946 | 2341946 | 2022-03-25 | Rockland | New York | 36087 | 91871 | 891 |
2338693 | 2338693 | 2022-03-24 | Rockland | New York | 36087 | 91830 | 891 |
2335439 | 2335439 | 2022-03-23 | Rockland | New York | 36087 | 91787 | 891 |
2332185 | 2332185 | 2022-03-22 | Rockland | New York | 36087 | 91739 | 891 |
2328932 | 2328932 | 2022-03-21 | Rockland | New York | 36087 | 91718 | 891 |
2325680 | 2325680 | 2022-03-20 | Rockland | New York | 36087 | 91700 | 891 |
2322427 | 2322427 | 2022-03-19 | Rockland | New York | 36087 | 91671 | 891 |
2319173 | 2319173 | 2022-03-18 | Rockland | New York | 36087 | 91629 | 891 |
2315919 | 2315919 | 2022-03-17 | Rockland | New York | 36087 | 91600 | 891 |
2312666 | 2312666 | 2022-03-16 | Rockland | New York | 36087 | 91531 | 891 |
2309413 | 2309413 | 2022-03-15 | Rockland | New York | 36087 | 91503 | 891 |
2306160 | 2306160 | 2022-03-14 | Rockland | New York | 36087 | 91475 | 891 |
2302909 | 2302909 | 2022-03-13 | Rockland | New York | 36087 | 91460 | 891 |
2299657 | 2299657 | 2022-03-12 | Rockland | New York | 36087 | 91442 | 891 |
2296405 | 2296405 | 2022-03-11 | Rockland | New York | 36087 | 91415 | 891 |
2293153 | 2293153 | 2022-03-10 | Rockland | New York | 36087 | 91394 | 890 |
2289901 | 2289901 | 2022-03-09 | Rockland | New York | 36087 | 91365 | 890 |
2286649 | 2286649 | 2022-03-08 | Rockland | New York | 36087 | 91337 | 890 |
2283397 | 2283397 | 2022-03-07 | Rockland | New York | 36087 | 91321 | 890 |
2280145 | 2280145 | 2022-03-06 | Rockland | New York | 36087 | 91307 | 890 |
2276892 | 2276892 | 2022-03-05 | Rockland | New York | 36087 | 91290 | 890 |
2273639 | 2273639 | 2022-03-04 | Rockland | New York | 36087 | 91221 | 890 |
2270386 | 2270386 | 2022-03-03 | Rockland | New York | 36087 | 91221 | 890 |
2267134 | 2267134 | 2022-03-02 | Rockland | New York | 36087 | 91196 | 890 |
2263882 | 2263882 | 2022-03-01 | Rockland | New York | 36087 | 91180 | 890 |
2260631 | 2260631 | 2022-02-28 | Rockland | New York | 36087 | 91166 | 890 |
2257380 | 2257380 | 2022-02-27 | Rockland | New York | 36087 | 91154 | 890 |
2254129 | 2254129 | 2022-02-26 | Rockland | New York | 36087 | 91135 | 890 |
2250878 | 2250878 | 2022-02-25 | Rockland | New York | 36087 | 91111 | 890 |
2247627 | 2247627 | 2022-02-24 | Rockland | New York | 36087 | 91078 | 890 |
2244376 | 2244376 | 2022-02-23 | Rockland | New York | 36087 | 91052 | 890 |
2241125 | 2241125 | 2022-02-22 | Rockland | New York | 36087 | 91033 | 890 |
2237874 | 2237874 | 2022-02-21 | Rockland | New York | 36087 | 91010 | 890 |
2234623 | 2234623 | 2022-02-20 | Rockland | New York | 36087 | 90993 | 889 |
2231372 | 2231372 | 2022-02-19 | Rockland | New York | 36087 | 90972 | 889 |
2228121 | 2228121 | 2022-02-18 | Rockland | New York | 36087 | 90931 | 888 |
2224870 | 2224870 | 2022-02-17 | Rockland | New York | 36087 | 90885 | 888 |
2221619 | 2221619 | 2022-02-16 | Rockland | New York | 36087 | 90841 | 886 |
2218368 | 2218368 | 2022-02-15 | Rockland | New York | 36087 | 90802 | 885 |
2215117 | 2215117 | 2022-02-14 | Rockland | New York | 36087 | 90758 | 885 |
2211866 | 2211866 | 2022-02-13 | Rockland | New York | 36087 | 90723 | 885 |
2208613 | 2208613 | 2022-02-12 | Rockland | New York | 36087 | 90674 | 885 |
2205360 | 2205360 | 2022-02-11 | Rockland | New York | 36087 | 90628 | 885 |
2202107 | 2202107 | 2022-02-10 | Rockland | New York | 36087 | 90574 | 884 |
2198853 | 2198853 | 2022-02-09 | Rockland | New York | 36087 | 90514 | 884 |
2195599 | 2195599 | 2022-02-08 | Rockland | New York | 36087 | 90332 | 884 |
2192345 | 2192345 | 2022-02-07 | Rockland | New York | 36087 | 90239 | 884 |
2189091 | 2189091 | 2022-02-06 | Rockland | New York | 36087 | 90183 | 884 |
2185838 | 2185838 | 2022-02-05 | Rockland | New York | 36087 | 90067 | 883 |
2182586 | 2182586 | 2022-02-04 | Rockland | New York | 36087 | 89998 | 883 |
2179334 | 2179334 | 2022-02-03 | Rockland | New York | 36087 | 89909 | 883 |
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);