ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 796 ✖
- 4 2
- 260301 2
- 398668 2
- 425386 2
- 1 1
- 5 1
- 17 1
- 19 1
- 28 1
- 41 1
- 51 1
- 79 1
- 98 1
- 109 1
- 131 1
- 183 1
- 382 1
- 754 1
- 1234 1
- 1900 1
- 2442 1
- 2869 1
- 3285 1
- 3914 1
- 4657 1
- 5537 1
- 6445 1
- 7344 1
- 8544 1
- 9555 1
- 10587 1
- 12024 1
- 13346 1
- 14398 1
- 15616 1
- 16610 1
- 18548 1
- 20140 1
- 21512 1
- 22584 1
- 23553 1
- 24358 1
- 25250 1
- 26715 1
- 27772 1
- 28539 1
- 29180 1
- 30013 1
- 30677 1
- 31079 1
- 31555 1
- 32124 1
- 32765 1
- 33798 1
- 34522 1
- 34865 1
- 35085 1
- 35505 1
- 35854 1
- 36161 1
- 36519 1
- 36780 1
- 36965 1
- 37152 1
- 37350 1
- 37593 1
- 37812 1
- 38028 1
- 38217 1
- 38337 1
- 38434 1
- 38587 1
- 38743 1
- 38864 1
- 39033 1
- 39136 1
- 39225 1
- 39295 1
- 39368 1
- 39487 1
- 39608 1
- 39726 1
- 39837 1
- 39907 1
- 39974 1
- 40034 1
- 40140 1
- 40226 1
- 40307 1
- 40396 1
- 40479 1
- 40572 1
- 40644 1
- 40713 1
- 40797 1
- 40853 1
- 40904 1
- 40947 1
- 40980 1
- 41015 1
- 41060 1
- 41114 1
- 41172 1
- 41204 1
- 41240 1
- 41290 1
- 41320 1
- 41349 1
- 41387 1
- 41443 1
- 41479 1
- 41513 1
- 41544 1
- 41585 1
- 41646 1
- 41684 1
- 41725 1
- 41754 1
- 41780 1
- 41807 1
- 41853 1
- 41910 1
- 41947 1
- 41988 1
- 42031 1
- 42053 1
- 42088 1
- 42122 1
- 42164 1
- 42232 1
- 42267 1
- 42307 1
- 42354 1
- 42423 1
- 42462 1
- 42506 1
- 42555 1
- 42594 1
- 42622 1
- 42678 1
- 42729 1
- 42765 1
- 42816 1
- 42860 1
- 42915 1
- 42960 1
- 43017 1
- 43059 1
- 43100 1
- 43158 1
- 43203 1
- 43271 1
- 43322 1
- 43380 1
- 43436 1
- 43482 1
- 43534 1
- 43580 1
- 43628 1
- 43655 1
- 43690 1
- 43724 1
- 43761 1
- 43795 1
- 43840 1
- 43891 1
- 43929 1
- 43955 1
- 44001 1
- 44063 1
- 44112 1
- 44162 1
- 44205 1
- 44245 1
- 44284 1
- 44348 1
- 44403 1
- 44450 1
- 44503 1
- 44554 1
- 44610 1
- 44677 1
- 44761 1
- 44845 1
- 44924 1
- 45008 1
- 45115 1
- 45193 1
- 45229 1
- 45294 1
- 45372 1
- 45445 1
- 45550 1
- 45633 1
- 45711 1
- 45763 1
- 45840 1
- 45906 1
- 45989 1
- 46052 1
- 46154 1
- 46218 1
- 46259 1
- 46325 1
- 46388 1
- 46434 1
- 46505 1
- 46576 1
- 46643 1
- 46711 1
- 46791 1
- 46857 1
- 46929 1
- 47034 1
- 47167 1
- 47246 1
- 47302 1
- 47392 1
- 47516 1
- 47656 1
- 47736 1
- 47841 1
- 47933 1
- 47998 1
- 48099 1
- 48184 1
- 48272 1
- 48377 1
- 48494 1
- 48596 1
- 48657 1
- 48731 1
- 48864 1
- 48941 1
- 49042 1
- 49203 1
- 49312 1
- 49377 1
- 49496 1
- 49663 1
- 49841 1
- 50007 1
- 50153 1
- 50294 1
- 50407 1
- 50602 1
- 50702 1
- 50918 1
- 51164 1
- 51418 1
- 51682 1
- 51895 1
- 52173 1
- 52575 1
- 52897 1
- 53271 1
- 53688 1
- 54014 1
- 54309 1
- 54715 1
- 55112 1
- 55486 1
- 55875 1
- 56269 1
- 56706 1
- 57127 1
- 57489 1
- 57985 1
- 58567 1
- 59238 1
- 59700 1
- 60181 1
- 60701 1
- 61162 1
- 61988 1
- 62745 1
- 63661 1
- 64359 1
- 65098 1
- 65632 1
- 66495 1
- 67203 1
- 67978 1
- 68737 1
- 69636 1
- 70475 1
- 71214 1
- 72122 1
- 72904 1
- 73757 1
- 74658 1
- 75421 1
- 76322 1
- 77088 1
- 77968 1
- 78983 1
- 80003 1
- 81099 1
- 82233 1
- 83045 1
- 84044 1
- 85023 1
- 86296 1
- 87904 1
- 89460 1
- 90869 1
- 92035 1
- 93106 1
- 94379 1
- 96112 1
- 97746 1
- 99439 1
- 101181 1
- 102584 1
- 104078 1
- 105497 1
- 106954 1
- 108126 1
- 109984 1
- 111393 1
- 112702 1
- 113812 1
- 114969 1
- 116065 1
- 117371 1
- 118735 1
- 119933 1
- 121002 1
- 122200 1
- 123142 1
- 124119 1
- 125370 1
- 126604 1
- 127743 1
- 128735 1
- 129654 1
- 130386 1
- 130933 1
- 131544 1
- 132301 1
- 133357 1
- 134227 1
- 134891 1
- 135711 1
- 136277 1
- 137196 1
- 137944 1
- 138784 1
- 139516 1
- 140107 1
- 140686 1
- 141224 1
- 141738 1
- 142467 1
- 143069 1
- 143615 1
- 144131 1
- 144771 1
- 145290 1
- 145985 1
- 146727 1
- 147472 1
- 148110 1
- 148669 1
- 149251 1
- 149851 1
- 150538 1
- 151327 1
- 151970 1
- 152646 1
- 153099 1
- 153711 1
- 154288 1
- 154867 1
- 155646 1
- 156309 1
- 156822 1
- 157362 1
- 157985 1
- 158769 1
- 159401 1
- 160103 1
- 160800 1
- 161408 1
- 161948 1
- 162481 1
- 163084 1
- 163785 1
- 164481 1
- 165095 1
- 165785 1
- 166365 1
- 166881 1
- 167557 1
- 168246 1
- 168884 1
- 169535 1
- 170179 1
- 170680 1
- 171185 1
- 171738 1
- 172548 1
- 173216 1
- 173772 1
- 174279 1
- 174673 1
- 175023 1
- 175392 1
- 175919 1
- 176399 1
- 177001 1
- 177344 1
- 177656 1
- 177933 1
- 178235 1
- 178512 1
- 178834 1
- 179117 1
- 179350 1
- 179572 1
- 179724 1
- 179895 1
- 180144 1
- 180373 1
- 180605 1
- 180730 1
- 180860 1
- 180992 1
- 181108 1
- 181253 1
- 181375 1
- 181553 1
- 181639 1
- 181727 1
- 181804 1
- 181920 1
- 182027 1
- 182139 1
- 182253 1
- 182343 1
- 182422 1
- 182491 1
- 182565 1
- 182656 1
- 182739 1
- 182810 1
- 182859 1
- 182902 1
- 182945 1
- 183001 1
- 183056 1
- 183108 1
- 183145 1
- 183169 1
- 183195 1
- 183212 1
- 183233 1
- 183266 1
- 183309 1
- 183360 1
- 183392 1
- 183422 1
- 183449 1
- 183468 1
- 183511 1
- 183545 1
- 183578 1
- 183601 1
- 183624 1
- 183649 1
- 183673 1
- 183697 1
- 183727 1
- 183753 1
- 183768 1
- 183787 1
- 183809 1
- 183825 1
- 183852 1
- 183879 1
- 183907 1
- 183926 1
- 183948 1
- 183963 1
- 183980 1
- 184017 1
- 184056 1
- 184084 1
- 184122 1
- 184153 1
- 184182 1
- 184219 1
- 184283 1
- 184351 1
- 184408 1
- 184472 1
- 184514 1
- 184580 1
- 184652 1
- 184743 1
- 184830 1
- 184936 1
- 185035 1
- 185134 1
- 185235 1
- 185373 1
- 185525 1
- 185692 1
- 185866 1
- 186086 1
- 186209 1
- 186371 1
- 186556 1
- 186808 1
- 187051 1
- 187302 1
- 187515 1
- 187735 1
- 188050 1
- 188329 1
- 188626 1
- 188944 1
- 189356 1
- 189700 1
- 190038 1
- 190306 1
- 190674 1
- 191088 1
- 191540 1
- 191875 1
- 192254 1
- 192601 1
- 192939 1
- 193324 1
- 193731 1
- 194235 1
- 194686 1
- 195039 1
- 195401 1
- 195695 1
- 195992 1
- 196540 1
- 197020 1
- 197459 1
- 197786 1
- 198170 1
- 198481 1
- 198853 1
- 199230 1
- 199700 1
- 200062 1
- 200481 1
- 200720 1
- 200945 1
- 201258 1
- 201651 1
- 202196 1
- 202573 1
- 202967 1
- 203217 1
- 203624 1
- 204062 1
- 204542 1
- 205019 1
- 205391 1
- 205748 1
- 205971 1
- 206372 1
- 206711 1
- 207104 1
- 207463 1
- 207815 1
- 208087 1
- 208290 1
- 208596 1
- 208903 1
- 209215 1
- 209487 1
- 209782 1
- 209987 1
- 210154 1
- 210362 1
- 210698 1
- 211019 1
- 211335 1
- 211636 1
- 211797 1
- 212062 1
- 212296 1
- 212560 1
- 212807 1
- 213093 1
- 213353 1
- 213603 1
- 213730 1
- 213905 1
- 214153 1
- 214370 1
- 214570 1
- 214772 1
- 214930 1
- 215085 1
- 215227 1
- 215425 1
- 215664 1
- 215863 1
- 216060 1
- 216266 1
- 216407 1
- 216578 1
- 216800 1
- 217038 1
- 217281 1
- 217518 1
- 217726 1
- 217879 1
- 218094 1
- 218368 1
- 218697 1
- 219038 1
- 219384 1
- 219613 1
- 219935 1
- 220225 1
- 220612 1
- 221030 1
- 221437 1
- 221880 1
- 222290 1
- 222638 1
- 222982 1
- 223456 1
- 223988 1
- 224379 1
- 224617 1
- 225182 1
- 225634 1
- 226135 1
- 226764 1
- 227654 1
- 228510 1
- 229198 1
- 230124 1
- 230523 1
- 231282 1
- 232051 1
- 232962 1
- 233888 1
- 234881 1
- 235824 1
- 236612 1
- 237345 1
- 238425 1
- 240073 1
- 242013 1
- 243769 1
- 245792 1
- 247739 1
- 249694 1
- 252162 1
- 255844 1
- 268422 1
- 270952 1
- 274475 1
- 280443 1
- 287304 1
- 294650 1
- 302366 1
- 308406 1
- 313601 1
- 317907 1
- 323887 1
- 330870 1
- 336980 1
- 343597 1
- 350265 1
- 354032 1
- 357439 1
- 361426 1
- 365524 1
- 368719 1
- 371873 1
- 374615 1
- 376298 1
- 377485 1
- 379090 1
- 380937 1
- 382820 1
- 384123 1
- 385225 1
- 386031 1
- 386676 1
- 387829 1
- 388880 1
- 389697 1
- 390398 1
- 390879 1
- 391056 1
- 391526 1
- 392191 1
- 392767 1
- 393177 1
- 393610 1
- 394006 1
- 394261 1
- 394485 1
- 394917 1
- 395337 1
- 395623 1
- 395873 1
- 396090 1
- 396250 1
- 396418 1
- 396617 1
- 396845 1
- 397058 1
- 397223 1
- 397356 1
- 397464 1
- 397550 1
- 397697 1
- 397812 1
- 397963 1
- 398082 1
- 398199 1
- 398278 1
- 398376 1
- 398487 1
- 398883 1
- 398962 1
- 399040 1
- 399090 1
- 399215 1
- 399334 1
- 399467 1
- 399571 1
- 399681 1
- 399755 1
- 399871 1
- 399980 1
- 400107 1
- 400265 1
- 400447 1
- 400564 1
- 400664 1
- 400768 1
- 400984 1
- 401205 1
- 401433 1
- 401654 1
- 401853 1
- 401999 1
- 402165 1
- 402360 1
- 402658 1
- 402919 1
- 403240 1
- 403486 1
- 403647 1
- 403806 1
- 404072 1
- 404538 1
- 404892 1
- 405208 1
- 405875 1
- 406276 1
- 406550 1
- 407111 1
- 407708 1
- 408289 1
- 408824 1
- 409205 1
- 409609 1
- 409997 1
- 410511 1
- 410967 1
- 411633 1
- 412010 1
- 412451 1
- 412805 1
- 413115 1
- 413836 1
- 414671 1
- 415333 1
- 416016 1
- 416557 1
- 417013 1
- 417503 1
- 418294 1
- 419200 1
- 420192 1
- 421094 1
- 422047 1
- 422614 1
- 423242 1
- 424236 1
state 1
- New York 800
fips 1
- 36059 · 800 ✖
county 1
- Nassau 800
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501455 | 2501455 | 2022-05-13 | Nassau | New York | 36059 | 425386 | 3853 |
2498197 | 2498197 | 2022-05-12 | Nassau | New York | 36059 | 425386 | 3852 |
2494939 | 2494939 | 2022-05-11 | Nassau | New York | 36059 | 424236 | 3851 |
2491681 | 2491681 | 2022-05-10 | Nassau | New York | 36059 | 423242 | 3850 |
2488423 | 2488423 | 2022-05-09 | Nassau | New York | 36059 | 422614 | 3847 |
2485166 | 2485166 | 2022-05-08 | Nassau | New York | 36059 | 422047 | 3845 |
2481908 | 2481908 | 2022-05-07 | Nassau | New York | 36059 | 421094 | 3844 |
2478650 | 2478650 | 2022-05-06 | Nassau | New York | 36059 | 420192 | 3843 |
2475392 | 2475392 | 2022-05-05 | Nassau | New York | 36059 | 419200 | 3843 |
2472135 | 2472135 | 2022-05-04 | Nassau | New York | 36059 | 418294 | 3842 |
2468879 | 2468879 | 2022-05-03 | Nassau | New York | 36059 | 417503 | 3842 |
2465623 | 2465623 | 2022-05-02 | Nassau | New York | 36059 | 417013 | 3842 |
2462368 | 2462368 | 2022-05-01 | Nassau | New York | 36059 | 416557 | 3842 |
2459112 | 2459112 | 2022-04-30 | Nassau | New York | 36059 | 416016 | 3840 |
2455856 | 2455856 | 2022-04-29 | Nassau | New York | 36059 | 415333 | 3836 |
2452600 | 2452600 | 2022-04-28 | Nassau | New York | 36059 | 414671 | 3835 |
2449344 | 2449344 | 2022-04-27 | Nassau | New York | 36059 | 413836 | 3834 |
2446087 | 2446087 | 2022-04-26 | Nassau | New York | 36059 | 413115 | 3833 |
2442832 | 2442832 | 2022-04-25 | Nassau | New York | 36059 | 412805 | 3833 |
2439576 | 2439576 | 2022-04-24 | Nassau | New York | 36059 | 412451 | 3833 |
2436320 | 2436320 | 2022-04-23 | Nassau | New York | 36059 | 412010 | 3833 |
2433064 | 2433064 | 2022-04-22 | Nassau | New York | 36059 | 411633 | 3831 |
2429808 | 2429808 | 2022-04-21 | Nassau | New York | 36059 | 410967 | 3830 |
2426552 | 2426552 | 2022-04-20 | Nassau | New York | 36059 | 410511 | 3830 |
2423296 | 2423296 | 2022-04-19 | Nassau | New York | 36059 | 409997 | 3830 |
2420039 | 2420039 | 2022-04-18 | Nassau | New York | 36059 | 409609 | 3826 |
2416784 | 2416784 | 2022-04-17 | Nassau | New York | 36059 | 409205 | 3826 |
2413528 | 2413528 | 2022-04-16 | Nassau | New York | 36059 | 408824 | 3826 |
2410272 | 2410272 | 2022-04-15 | Nassau | New York | 36059 | 408289 | 3826 |
2407016 | 2407016 | 2022-04-14 | Nassau | New York | 36059 | 407708 | 3825 |
2403760 | 2403760 | 2022-04-13 | Nassau | New York | 36059 | 407111 | 3825 |
2400505 | 2400505 | 2022-04-12 | Nassau | New York | 36059 | 406550 | 3825 |
2397250 | 2397250 | 2022-04-11 | Nassau | New York | 36059 | 406276 | 3825 |
2393995 | 2393995 | 2022-04-10 | Nassau | New York | 36059 | 405875 | 3825 |
2390739 | 2390739 | 2022-04-09 | Nassau | New York | 36059 | 405208 | 3825 |
2387483 | 2387483 | 2022-04-08 | Nassau | New York | 36059 | 404892 | 3824 |
2384228 | 2384228 | 2022-04-07 | Nassau | New York | 36059 | 404538 | 3824 |
2380973 | 2380973 | 2022-04-06 | Nassau | New York | 36059 | 404072 | 3824 |
2377718 | 2377718 | 2022-04-05 | Nassau | New York | 36059 | 403806 | 3823 |
2374465 | 2374465 | 2022-04-04 | Nassau | New York | 36059 | 403647 | 3822 |
2371213 | 2371213 | 2022-04-03 | Nassau | New York | 36059 | 403486 | 3822 |
2367960 | 2367960 | 2022-04-02 | Nassau | New York | 36059 | 403240 | 3822 |
2364707 | 2364707 | 2022-04-01 | Nassau | New York | 36059 | 402919 | 3822 |
2361453 | 2361453 | 2022-03-31 | Nassau | New York | 36059 | 402658 | 3822 |
2358199 | 2358199 | 2022-03-30 | Nassau | New York | 36059 | 402360 | 3822 |
2354945 | 2354945 | 2022-03-29 | Nassau | New York | 36059 | 402165 | 3822 |
2351692 | 2351692 | 2022-03-28 | Nassau | New York | 36059 | 401999 | 3821 |
2348440 | 2348440 | 2022-03-27 | Nassau | New York | 36059 | 401853 | 3821 |
2345187 | 2345187 | 2022-03-26 | Nassau | New York | 36059 | 401654 | 3821 |
2341934 | 2341934 | 2022-03-25 | Nassau | New York | 36059 | 401433 | 3821 |
2338681 | 2338681 | 2022-03-24 | Nassau | New York | 36059 | 401205 | 3821 |
2335427 | 2335427 | 2022-03-23 | Nassau | New York | 36059 | 400984 | 3821 |
2332173 | 2332173 | 2022-03-22 | Nassau | New York | 36059 | 400768 | 3820 |
2328920 | 2328920 | 2022-03-21 | Nassau | New York | 36059 | 400664 | 3820 |
2325668 | 2325668 | 2022-03-20 | Nassau | New York | 36059 | 400564 | 3820 |
2322415 | 2322415 | 2022-03-19 | Nassau | New York | 36059 | 400447 | 3820 |
2319161 | 2319161 | 2022-03-18 | Nassau | New York | 36059 | 400265 | 3820 |
2315907 | 2315907 | 2022-03-17 | Nassau | New York | 36059 | 400107 | 3819 |
2312654 | 2312654 | 2022-03-16 | Nassau | New York | 36059 | 399980 | 3818 |
2309401 | 2309401 | 2022-03-15 | Nassau | New York | 36059 | 399871 | 3817 |
2306148 | 2306148 | 2022-03-14 | Nassau | New York | 36059 | 399755 | 3815 |
2302897 | 2302897 | 2022-03-13 | Nassau | New York | 36059 | 399681 | 3815 |
2299645 | 2299645 | 2022-03-12 | Nassau | New York | 36059 | 399571 | 3814 |
2296393 | 2296393 | 2022-03-11 | Nassau | New York | 36059 | 399467 | 3814 |
2293141 | 2293141 | 2022-03-10 | Nassau | New York | 36059 | 399334 | 3813 |
2289889 | 2289889 | 2022-03-09 | Nassau | New York | 36059 | 399215 | 3811 |
2286637 | 2286637 | 2022-03-08 | Nassau | New York | 36059 | 399090 | 3809 |
2283385 | 2283385 | 2022-03-07 | Nassau | New York | 36059 | 399040 | 3808 |
2280133 | 2280133 | 2022-03-06 | Nassau | New York | 36059 | 398962 | 3808 |
2276880 | 2276880 | 2022-03-05 | Nassau | New York | 36059 | 398883 | 3808 |
2273627 | 2273627 | 2022-03-04 | Nassau | New York | 36059 | 398668 | 3806 |
2270374 | 2270374 | 2022-03-03 | Nassau | New York | 36059 | 398668 | 3806 |
2267122 | 2267122 | 2022-03-02 | Nassau | New York | 36059 | 398487 | 3806 |
2263870 | 2263870 | 2022-03-01 | Nassau | New York | 36059 | 398376 | 3805 |
2260619 | 2260619 | 2022-02-28 | Nassau | New York | 36059 | 398278 | 3802 |
2257368 | 2257368 | 2022-02-27 | Nassau | New York | 36059 | 398199 | 3801 |
2254117 | 2254117 | 2022-02-26 | Nassau | New York | 36059 | 398082 | 3800 |
2250866 | 2250866 | 2022-02-25 | Nassau | New York | 36059 | 397963 | 3800 |
2247615 | 2247615 | 2022-02-24 | Nassau | New York | 36059 | 397812 | 3797 |
2244364 | 2244364 | 2022-02-23 | Nassau | New York | 36059 | 397697 | 3794 |
2241113 | 2241113 | 2022-02-22 | Nassau | New York | 36059 | 397550 | 3793 |
2237862 | 2237862 | 2022-02-21 | Nassau | New York | 36059 | 397464 | 3792 |
2234611 | 2234611 | 2022-02-20 | Nassau | New York | 36059 | 397356 | 3791 |
2231360 | 2231360 | 2022-02-19 | Nassau | New York | 36059 | 397223 | 3789 |
2228109 | 2228109 | 2022-02-18 | Nassau | New York | 36059 | 397058 | 3787 |
2224858 | 2224858 | 2022-02-17 | Nassau | New York | 36059 | 396845 | 3787 |
2221607 | 2221607 | 2022-02-16 | Nassau | New York | 36059 | 396617 | 3786 |
2218356 | 2218356 | 2022-02-15 | Nassau | New York | 36059 | 396418 | 3785 |
2215105 | 2215105 | 2022-02-14 | Nassau | New York | 36059 | 396250 | 3782 |
2211854 | 2211854 | 2022-02-13 | Nassau | New York | 36059 | 396090 | 3780 |
2208601 | 2208601 | 2022-02-12 | Nassau | New York | 36059 | 395873 | 3772 |
2205348 | 2205348 | 2022-02-11 | Nassau | New York | 36059 | 395623 | 3772 |
2202095 | 2202095 | 2022-02-10 | Nassau | New York | 36059 | 395337 | 3766 |
2198841 | 2198841 | 2022-02-09 | Nassau | New York | 36059 | 394917 | 3761 |
2195587 | 2195587 | 2022-02-08 | Nassau | New York | 36059 | 394485 | 3757 |
2192333 | 2192333 | 2022-02-07 | Nassau | New York | 36059 | 394261 | 3754 |
2189079 | 2189079 | 2022-02-06 | Nassau | New York | 36059 | 394006 | 3753 |
2185826 | 2185826 | 2022-02-05 | Nassau | New York | 36059 | 393610 | 3746 |
2182574 | 2182574 | 2022-02-04 | Nassau | New York | 36059 | 393177 | 3741 |
2179322 | 2179322 | 2022-02-03 | Nassau | New York | 36059 | 392767 | 3735 |
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);