ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 10005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 774 ✖
- 61627 3
- 62096 3
- 62531 3
- 3 2
- 886 2
- 6432 2
- 26263 2
- 34475 2
- 35771 2
- 61880 2
- 62866 2
- 1 1
- 7 1
- 8 1
- 12 1
- 20 1
- 23 1
- 26 1
- 33 1
- 38 1
- 59 1
- 66 1
- 81 1
- 88 1
- 101 1
- 105 1
- 117 1
- 125 1
- 151 1
- 159 1
- 210 1
- 279 1
- 294 1
- 336 1
- 404 1
- 464 1
- 551 1
- 639 1
- 678 1
- 698 1
- 811 1
- 1055 1
- 1139 1
- 1317 1
- 1377 1
- 1394 1
- 1490 1
- 1801 1
- 1870 1
- 2114 1
- 2169 1
- 2216 1
- 2292 1
- 2359 1
- 2461 1
- 2497 1
- 2520 1
- 2764 1
- 2834 1
- 2936 1
- 2990 1
- 3059 1
- 3091 1
- 3205 1
- 3336 1
- 3503 1
- 3565 1
- 3658 1
- 3739 1
- 3861 1
- 3904 1
- 3960 1
- 4006 1
- 4048 1
- 4084 1
- 4103 1
- 4118 1
- 4132 1
- 4140 1
- 4151 1
- 4155 1
- 4215 1
- 4253 1
- 4272 1
- 4299 1
- 4305 1
- 4314 1
- 4322 1
- 4342 1
- 4346 1
- 4353 1
- 4361 1
- 4373 1
- 4379 1
- 4389 1
- 4401 1
- 4406 1
- 4416 1
- 4428 1
- 4429 1
- 4431 1
- 4470 1
- 4487 1
- 4495 1
- 4501 1
- 4509 1
- 4519 1
- 4522 1
- 4538 1
- 4542 1
- 4608 1
- 4637 1
- 4681 1
- 4690 1
- 4779 1
- 4847 1
- 4854 1
- 4903 1
- 4952 1
- 4977 1
- 4988 1
- 5008 1
- 5045 1
- 5076 1
- 5093 1
- 5119 1
- 5130 1
- 5153 1
- 5171 1
- 5244 1
- 5264 1
- 5304 1
- 5333 1
- 5365 1
- 5375 1
- 5407 1
- 5488 1
- 5506 1
- 5508 1
- 5529 1
- 5564 1
- 5575 1
- 5583 1
- 5608 1
- 5630 1
- 5656 1
- 5673 1
- 5685 1
- 5778 1
- 5786 1
- 5803 1
- 5821 1
- 5839 1
- 5848 1
- 5867 1
- 5881 1
- 5928 1
- 6167 1
- 6172 1
- 6181 1
- 6197 1
- 6208 1
- 6209 1
- 6213 1
- 6221 1
- 6225 1
- 6235 1
- 6237 1
- 6239 1
- 6242 1
- 6245 1
- 6249 1
- 6317 1
- 6330 1
- 6335 1
- 6346 1
- 6350 1
- 6357 1
- 6365 1
- 6374 1
- 6396 1
- 6420 1
- 6456 1
- 6471 1
- 6491 1
- 6504 1
- 6519 1
- 6567 1
- 6570 1
- 6578 1
- 6585 1
- 6600 1
- 6631 1
- 6649 1
- 6666 1
- 6673 1
- 6691 1
- 6718 1
- 6727 1
- 6740 1
- 6761 1
- 6782 1
- 6791 1
- 6807 1
- 6913 1
- 6962 1
- 6996 1
- 7024 1
- 7050 1
- 7066 1
- 7112 1
- 7148 1
- 7188 1
- 7221 1
- 7267 1
- 7302 1
- 7328 1
- 7346 1
- 7390 1
- 7476 1
- 7518 1
- 7560 1
- 7593 1
- 7609 1
- 7660 1
- 7711 1
- 7770 1
- 7802 1
- 7854 1
- 7882 1
- 7925 1
- 7968 1
- 8036 1
- 8099 1
- 8170 1
- 8213 1
- 8255 1
- 8299 1
- 8342 1
- 8408 1
- 8461 1
- 8528 1
- 8589 1
- 8645 1
- 8700 1
- 8752 1
- 8854 1
- 8932 1
- 9035 1
- 9139 1
- 9194 1
- 9247 1
- 9341 1
- 9493 1
- 9585 1
- 9682 1
- 9793 1
- 9876 1
- 9918 1
- 10069 1
- 10175 1
- 10253 1
- 10377 1
- 10436 1
- 10558 1
- 10620 1
- 10746 1
- 10899 1
- 11007 1
- 11165 1
- 11355 1
- 11499 1
- 11618 1
- 11702 1
- 11912 1
- 12108 1
- 12286 1
- 12526 1
- 12651 1
- 12780 1
- 12976 1
- 13079 1
- 13318 1
- 13460 1
- 13611 1
- 13727 1
- 13815 1
- 14021 1
- 14129 1
- 14325 1
- 14458 1
- 14555 1
- 14689 1
- 14758 1
- 14936 1
- 15166 1
- 15396 1
- 15563 1
- 15819 1
- 16022 1
- 16205 1
- 16515 1
- 16715 1
- 17045 1
- 17252 1
- 17419 1
- 17579 1
- 17758 1
- 17983 1
- 18142 1
- 18328 1
- 18570 1
- 18762 1
- 18844 1
- 18977 1
- 19148 1
- 19372 1
- 19545 1
- 19745 1
- 19903 1
- 19985 1
- 20092 1
- 20256 1
- 20361 1
- 20550 1
- 20728 1
- 20824 1
- 20867 1
- 20940 1
- 21018 1
- 21092 1
- 21158 1
- 21339 1
- 21442 1
- 21532 1
- 21570 1
- 21683 1
- 21773 1
- 21858 1
- 21945 1
- 22017 1
- 22046 1
- 22095 1
- 22148 1
- 22195 1
- 22253 1
- 22311 1
- 22368 1
- 22398 1
- 22467 1
- 22526 1
- 22590 1
- 22664 1
- 22694 1
- 22725 1
- 22744 1
- 22785 1
- 22802 1
- 22847 1
- 22890 1
- 22918 1
- 22949 1
- 22962 1
- 22993 1
- 23023 1
- 23047 1
- 23073 1
- 23125 1
- 23158 1
- 23176 1
- 23248 1
- 23291 1
- 23308 1
- 23379 1
- 23423 1
- 23438 1
- 23456 1
- 23482 1
- 23521 1
- 23548 1
- 23606 1
- 23651 1
- 23691 1
- 23717 1
- 23744 1
- 23788 1
- 23852 1
- 23924 1
- 23955 1
- 23989 1
- 24025 1
- 24046 1
- 24089 1
- 24136 1
- 24184 1
- 24243 1
- 24285 1
- 24314 1
- 24370 1
- 24416 1
- 24494 1
- 24570 1
- 24630 1
- 24678 1
- 24703 1
- 24754 1
- 24815 1
- 24857 1
- 24926 1
- 24973 1
- 25019 1
- 25034 1
- 25064 1
- 25108 1
- 25165 1
- 25205 1
- 25272 1
- 25300 1
- 25319 1
- 25356 1
- 25392 1
- 25423 1
- 25458 1
- 25502 1
- 25515 1
- 25537 1
- 25566 1
- 25590 1
- 25617 1
- 25654 1
- 25674 1
- 25696 1
- 25716 1
- 25756 1
- 25774 1
- 25802 1
- 25829 1
- 25841 1
- 25847 1
- 25866 1
- 25881 1
- 25900 1
- 25915 1
- 25937 1
- 25963 1
- 25972 1
- 25984 1
- 25987 1
- 25997 1
- 26019 1
- 26045 1
- 26060 1
- 26072 1
- 26081 1
- 26097 1
- 26106 1
- 26117 1
- 26121 1
- 26133 1
- 26135 1
- 26142 1
- 26144 1
- 26154 1
- 26168 1
- 26174 1
- 26178 1
- 26184 1
- 26187 1
- 26196 1
- 26202 1
- 26206 1
- 26207 1
- 26214 1
- 26217 1
- 26221 1
- 26230 1
- 26241 1
- 26250 1
- 26256 1
- 26259 1
- 26261 1
- 26276 1
- 26289 1
- 26295 1
- 26306 1
- 26310 1
- 26318 1
- 26330 1
- 26350 1
- 26364 1
- 26381 1
- 26396 1
- 26404 1
- 26412 1
- 26422 1
- 26447 1
- 26479 1
- 26515 1
- 26532 1
- 26540 1
- 26565 1
- 26578 1
- 26617 1
- 26650 1
- 26681 1
- 26727 1
- 26765 1
- 26783 1
- 26811 1
- 26864 1
- 26917 1
- 26984 1
- 27057 1
- 27113 1
- 27145 1
- 27186 1
- 27270 1
- 27349 1
- 27431 1
- 27524 1
- 27580 1
- 27625 1
- 27709 1
- 27821 1
- 27903 1
- 28009 1
- 28102 1
- 28199 1
- 28253 1
- 28362 1
- 28474 1
- 28609 1
- 28724 1
- 28813 1
- 28910 1
- 28999 1
- 29094 1
- 29239 1
- 29378 1
- 29515 1
- 29619 1
- 29702 1
- 29801 1
- 29870 1
- 29969 1
- 30125 1
- 30280 1
- 30406 1
- 30560 1
- 30630 1
- 30727 1
- 30853 1
- 31024 1
- 31157 1
- 31301 1
- 31413 1
- 31494 1
- 31576 1
- 31750 1
- 31934 1
- 32094 1
- 32199 1
- 32333 1
- 32405 1
- 32476 1
- 32630 1
- 32816 1
- 32945 1
- 33059 1
- 33158 1
- 33232 1
- 33319 1
- 33448 1
- 33608 1
- 33777 1
- 33897 1
- 33967 1
- 34013 1
- 34103 1
- 34220 1
- 34345 1
- 34627 1
- 34683 1
- 34777 1
- 34874 1
- 34969 1
- 35022 1
- 35117 1
- 35163 1
- 35198 1
- 35252 1
- 35330 1
- 35419 1
- 35495 1
- 35560 1
- 35610 1
- 35627 1
- 35693 1
- 35886 1
- 35949 1
- 35992 1
- 36009 1
- 36056 1
- 36103 1
- 36186 1
- 36261 1
- 36318 1
- 36345 1
- 36348 1
- 36372 1
- 36400 1
- 36461 1
- 36846 1
- 36907 1
- 36955 1
- 37010 1
- 37062 1
- 37202 1
- 37297 1
- 37349 1
- 37407 1
- 37457 1
- 37513 1
- 37610 1
- 37777 1
- 37938 1
- 38097 1
- 38225 1
- 38364 1
- 38414 1
- 38557 1
- 38747 1
- 38922 1
- 39052 1
- 39229 1
- 39329 1
- 39423 1
- 39562 1
- 39782 1
- 39987 1
- 40184 1
- 40374 1
- 40508 1
- 40627 1
- 40814 1
- 41041 1
- 41279 1
- 41545 1
- 41826 1
- 41920 1
- 42029 1
- 42304 1
- 42695 1
- 43548 1
- 44129 1
- 44896 1
- 45253 1
- 45857 1
- 46085 1
- 46508 1
- 46989 1
- 47640 1
- 48355 1
- 48863 1
- 49315 1
- 50147 1
- 51137 1
- 51952 1
- 52805 1
- 53512 1
- 54011 1
- 54224 1
- 54531 1
- 55028 1
- 55486 1
- 56204 1
- 56571 1
- 56905 1
- 57129 1
- 57361 1
- 57822 1
- 58178 1
- 58391 1
- 58587 1
- 58688 1
- 58760 1
- 58885 1
- 59061 1
- 59213 1
- 59323 1
- 59415 1
- 59493 1
- 59526 1
- 59658 1
- 59772 1
- 59881 1
- 59960 1
- 60018 1
- 60061 1
- 60089 1
- 60149 1
- 60232 1
- 60299 1
- 60366 1
- 60396 1
- 60415 1
- 60434 1
- 60461 1
- 60645 1
- 60671 1
- 60701 1
- 60724 1
- 60741 1
- 60755 1
- 60772 1
- 60806 1
- 60840 1
- 60875 1
- 60894 1
- 60911 1
- 60926 1
- 60945 1
- 61061 1
- 61112 1
- 61143 1
- 61160 1
- 61174 1
- 61197 1
- 61210 1
- 61234 1
- 61245 1
- 61260 1
- 61272 1
- 61277 1
- 61285 1
- 61301 1
- 61348 1
- 61411 1
- 61414 1
- 61437 1
- 61438 1
- 61453 1
- 61461 1
- 61470 1
- 61472 1
- 61490 1
- 61503 1
- 61507 1
- 61525 1
- 61527 1
- 61549 1
- 61576 1
- 61578 1
- 61592 1
- 61611 1
- 61626 1
- 61653 1
- 61685 1
- 61703 1
- 61724 1
- 61751 1
- 61790 1
- 61838 1
- 61940 1
- 61961 1
- 61991 1
- 62045 1
- 62229 1
- 62253 1
- 62303 1
- 62429 1
- 62808 1
- 63024 1
- 63138 1
state 1
- Delaware 788
fips 1
- 10005 · 788 ✖
county 1
- Sussex 788
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499895 | 2499895 | 2022-05-13 | Sussex | Delaware | 10005 | 63138 | 857 |
2496637 | 2496637 | 2022-05-12 | Sussex | Delaware | 10005 | 63024 | 855 |
2493379 | 2493379 | 2022-05-11 | Sussex | Delaware | 10005 | 62866 | 855 |
2490121 | 2490121 | 2022-05-10 | Sussex | Delaware | 10005 | 62866 | 855 |
2486864 | 2486864 | 2022-05-09 | Sussex | Delaware | 10005 | 62808 | 855 |
2483606 | 2483606 | 2022-05-08 | Sussex | Delaware | 10005 | 62531 | 855 |
2480348 | 2480348 | 2022-05-07 | Sussex | Delaware | 10005 | 62531 | 855 |
2477090 | 2477090 | 2022-05-06 | Sussex | Delaware | 10005 | 62531 | 855 |
2473832 | 2473832 | 2022-05-05 | Sussex | Delaware | 10005 | 62429 | 850 |
2470575 | 2470575 | 2022-05-04 | Sussex | Delaware | 10005 | 62303 | 850 |
2467319 | 2467319 | 2022-05-03 | Sussex | Delaware | 10005 | 62253 | 850 |
2464064 | 2464064 | 2022-05-02 | Sussex | Delaware | 10005 | 62229 | 850 |
2460808 | 2460808 | 2022-05-01 | Sussex | Delaware | 10005 | 62096 | 848 |
2457552 | 2457552 | 2022-04-30 | Sussex | Delaware | 10005 | 62096 | 848 |
2454296 | 2454296 | 2022-04-29 | Sussex | Delaware | 10005 | 62096 | 848 |
2451040 | 2451040 | 2022-04-28 | Sussex | Delaware | 10005 | 62045 | 848 |
2447784 | 2447784 | 2022-04-27 | Sussex | Delaware | 10005 | 61991 | 848 |
2444528 | 2444528 | 2022-04-26 | Sussex | Delaware | 10005 | 61961 | 848 |
2441272 | 2441272 | 2022-04-25 | Sussex | Delaware | 10005 | 61940 | 848 |
2438016 | 2438016 | 2022-04-24 | Sussex | Delaware | 10005 | 61880 | 848 |
2434760 | 2434760 | 2022-04-23 | Sussex | Delaware | 10005 | 61880 | 848 |
2431504 | 2431504 | 2022-04-22 | Sussex | Delaware | 10005 | 61838 | 845 |
2428248 | 2428248 | 2022-04-21 | Sussex | Delaware | 10005 | 61790 | 845 |
2424992 | 2424992 | 2022-04-20 | Sussex | Delaware | 10005 | 61751 | 845 |
2421736 | 2421736 | 2022-04-19 | Sussex | Delaware | 10005 | 61724 | 845 |
2418480 | 2418480 | 2022-04-18 | Sussex | Delaware | 10005 | 61703 | 844 |
2415224 | 2415224 | 2022-04-17 | Sussex | Delaware | 10005 | 61627 | 844 |
2411968 | 2411968 | 2022-04-16 | Sussex | Delaware | 10005 | 61627 | 844 |
2408712 | 2408712 | 2022-04-15 | Sussex | Delaware | 10005 | 61627 | 844 |
2405456 | 2405456 | 2022-04-14 | Sussex | Delaware | 10005 | 61578 | 844 |
2402201 | 2402201 | 2022-04-13 | Sussex | Delaware | 10005 | 61525 | 844 |
2398946 | 2398946 | 2022-04-12 | Sussex | Delaware | 10005 | 61507 | 844 |
2395691 | 2395691 | 2022-04-11 | Sussex | Delaware | 10005 | 61490 | 844 |
2392435 | 2392435 | 2022-04-10 | Sussex | Delaware | 10005 | 61472 | 844 |
2389179 | 2389179 | 2022-04-09 | Sussex | Delaware | 10005 | 61438 | 844 |
2385924 | 2385924 | 2022-04-08 | Sussex | Delaware | 10005 | 61414 | 837 |
2382669 | 2382669 | 2022-04-07 | Sussex | Delaware | 10005 | 61685 | 837 |
2379414 | 2379414 | 2022-04-06 | Sussex | Delaware | 10005 | 61653 | 837 |
2376160 | 2376160 | 2022-04-05 | Sussex | Delaware | 10005 | 61626 | 837 |
2372908 | 2372908 | 2022-04-04 | Sussex | Delaware | 10005 | 61611 | 837 |
2369655 | 2369655 | 2022-04-03 | Sussex | Delaware | 10005 | 61592 | 837 |
2366402 | 2366402 | 2022-04-02 | Sussex | Delaware | 10005 | 61576 | 837 |
2363149 | 2363149 | 2022-04-01 | Sussex | Delaware | 10005 | 61549 | 829 |
2359895 | 2359895 | 2022-03-31 | Sussex | Delaware | 10005 | 61527 | 829 |
2356641 | 2356641 | 2022-03-30 | Sussex | Delaware | 10005 | 61503 | 829 |
2353388 | 2353388 | 2022-03-29 | Sussex | Delaware | 10005 | 61470 | 829 |
2350136 | 2350136 | 2022-03-28 | Sussex | Delaware | 10005 | 61461 | 829 |
2346883 | 2346883 | 2022-03-27 | Sussex | Delaware | 10005 | 61453 | 829 |
2343630 | 2343630 | 2022-03-26 | Sussex | Delaware | 10005 | 61437 | 829 |
2340377 | 2340377 | 2022-03-25 | Sussex | Delaware | 10005 | 61411 | 826 |
2337124 | 2337124 | 2022-03-24 | Sussex | Delaware | 10005 | 61348 | 826 |
2333870 | 2333870 | 2022-03-23 | Sussex | Delaware | 10005 | 61301 | 825 |
2330616 | 2330616 | 2022-03-22 | Sussex | Delaware | 10005 | 61285 | 825 |
2327364 | 2327364 | 2022-03-21 | Sussex | Delaware | 10005 | 61277 | 823 |
2324111 | 2324111 | 2022-03-20 | Sussex | Delaware | 10005 | 61272 | 823 |
2320857 | 2320857 | 2022-03-19 | Sussex | Delaware | 10005 | 61260 | 823 |
2317603 | 2317603 | 2022-03-18 | Sussex | Delaware | 10005 | 61245 | 819 |
2314350 | 2314350 | 2022-03-17 | Sussex | Delaware | 10005 | 61234 | 819 |
2311097 | 2311097 | 2022-03-16 | Sussex | Delaware | 10005 | 61210 | 819 |
2307844 | 2307844 | 2022-03-15 | Sussex | Delaware | 10005 | 61197 | 818 |
2304593 | 2304593 | 2022-03-14 | Sussex | Delaware | 10005 | 61174 | 818 |
2301341 | 2301341 | 2022-03-13 | Sussex | Delaware | 10005 | 61160 | 818 |
2298089 | 2298089 | 2022-03-12 | Sussex | Delaware | 10005 | 61143 | 818 |
2294837 | 2294837 | 2022-03-11 | Sussex | Delaware | 10005 | 61112 | 804 |
2291585 | 2291585 | 2022-03-10 | Sussex | Delaware | 10005 | 61061 | 804 |
2288333 | 2288333 | 2022-03-09 | Sussex | Delaware | 10005 | 60945 | 804 |
2285082 | 2285082 | 2022-03-08 | Sussex | Delaware | 10005 | 60926 | 804 |
2281830 | 2281830 | 2022-03-07 | Sussex | Delaware | 10005 | 60911 | 804 |
2278577 | 2278577 | 2022-03-06 | Sussex | Delaware | 10005 | 60894 | 804 |
2275324 | 2275324 | 2022-03-05 | Sussex | Delaware | 10005 | 60875 | 804 |
2272071 | 2272071 | 2022-03-04 | Sussex | Delaware | 10005 | 60840 | 798 |
2268819 | 2268819 | 2022-03-03 | Sussex | Delaware | 10005 | 60806 | 797 |
2265566 | 2265566 | 2022-03-02 | Sussex | Delaware | 10005 | 60772 | 797 |
2262315 | 2262315 | 2022-03-01 | Sussex | Delaware | 10005 | 60755 | 797 |
2259064 | 2259064 | 2022-02-28 | Sussex | Delaware | 10005 | 60741 | 797 |
2255813 | 2255813 | 2022-02-27 | Sussex | Delaware | 10005 | 60724 | 797 |
2252562 | 2252562 | 2022-02-26 | Sussex | Delaware | 10005 | 60701 | 797 |
2249311 | 2249311 | 2022-02-25 | Sussex | Delaware | 10005 | 60671 | 795 |
2246060 | 2246060 | 2022-02-24 | Sussex | Delaware | 10005 | 60645 | 795 |
2242809 | 2242809 | 2022-02-23 | Sussex | Delaware | 10005 | 60461 | 795 |
2239558 | 2239558 | 2022-02-22 | Sussex | Delaware | 10005 | 60434 | 795 |
2236307 | 2236307 | 2022-02-21 | Sussex | Delaware | 10005 | 60415 | 792 |
2233056 | 2233056 | 2022-02-20 | Sussex | Delaware | 10005 | 60396 | 792 |
2229805 | 2229805 | 2022-02-19 | Sussex | Delaware | 10005 | 60366 | 792 |
2226554 | 2226554 | 2022-02-18 | Sussex | Delaware | 10005 | 60299 | 785 |
2223303 | 2223303 | 2022-02-17 | Sussex | Delaware | 10005 | 60232 | 784 |
2220052 | 2220052 | 2022-02-16 | Sussex | Delaware | 10005 | 60149 | 784 |
2216801 | 2216801 | 2022-02-15 | Sussex | Delaware | 10005 | 60089 | 778 |
2213550 | 2213550 | 2022-02-14 | Sussex | Delaware | 10005 | 60061 | 778 |
2210298 | 2210298 | 2022-02-13 | Sussex | Delaware | 10005 | 60018 | 778 |
2207045 | 2207045 | 2022-02-12 | Sussex | Delaware | 10005 | 59960 | 778 |
2203792 | 2203792 | 2022-02-11 | Sussex | Delaware | 10005 | 59881 | 772 |
2200539 | 2200539 | 2022-02-10 | Sussex | Delaware | 10005 | 59772 | 772 |
2197285 | 2197285 | 2022-02-09 | Sussex | Delaware | 10005 | 59658 | 771 |
2194031 | 2194031 | 2022-02-08 | Sussex | Delaware | 10005 | 59526 | 771 |
2190777 | 2190777 | 2022-02-07 | Sussex | Delaware | 10005 | 59493 | 763 |
2187524 | 2187524 | 2022-02-06 | Sussex | Delaware | 10005 | 59415 | 763 |
2184271 | 2184271 | 2022-02-05 | Sussex | Delaware | 10005 | 59323 | 763 |
2181019 | 2181019 | 2022-02-04 | Sussex | Delaware | 10005 | 59213 | 762 |
2177768 | 2177768 | 2022-02-03 | Sussex | Delaware | 10005 | 59061 | 761 |
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);