ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 34039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 782 ✖
- 1 6
- 16322 2
- 16337 2
- 16694 2
- 16746 2
- 16761 2
- 71734 2
- 79380 2
- 143215 2
- 145851 2
- 4 1
- 8 1
- 22 1
- 26 1
- 29 1
- 43 1
- 81 1
- 124 1
- 189 1
- 246 1
- 262 1
- 432 1
- 519 1
- 742 1
- 896 1
- 1213 1
- 1418 1
- 1661 1
- 2010 1
- 2487 1
- 2916 1
- 3216 1
- 3685 1
- 4358 1
- 4831 1
- 5203 1
- 5575 1
- 5865 1
- 6180 1
- 6636 1
- 7265 1
- 7438 1
- 7904 1
- 8429 1
- 8959 1
- 9609 1
- 9972 1
- 10289 1
- 10484 1
- 10935 1
- 11208 1
- 11523 1
- 11853 1
- 12011 1
- 12188 1
- 12380 1
- 12578 1
- 12779 1
- 12996 1
- 13225 1
- 13357 1
- 13503 1
- 13604 1
- 13781 1
- 13917 1
- 13984 1
- 14057 1
- 14164 1
- 14203 1
- 14306 1
- 14385 1
- 14492 1
- 14569 1
- 14702 1
- 14903 1
- 15031 1
- 15122 1
- 15169 1
- 15176 1
- 15186 1
- 15191 1
- 15218 1
- 15293 1
- 15324 1
- 15475 1
- 15610 1
- 15764 1
- 15821 1
- 15858 1
- 15868 1
- 15911 1
- 15953 1
- 16038 1
- 16116 1
- 16186 1
- 16241 1
- 16291 1
- 16298 1
- 16302 1
- 16304 1
- 16308 1
- 16315 1
- 16317 1
- 16320 1
- 16330 1
- 16340 1
- 16341 1
- 16351 1
- 16472 1
- 16496 1
- 16510 1
- 16514 1
- 16526 1
- 16533 1
- 16534 1
- 16536 1
- 16548 1
- 16551 1
- 16557 1
- 16564 1
- 16566 1
- 16569 1
- 16585 1
- 16591 1
- 16607 1
- 16610 1
- 16616 1
- 16618 1
- 16625 1
- 16627 1
- 16630 1
- 16644 1
- 16646 1
- 16655 1
- 16685 1
- 16687 1
- 16696 1
- 16703 1
- 16716 1
- 16719 1
- 16721 1
- 16725 1
- 16742 1
- 16775 1
- 16792 1
- 16806 1
- 16833 1
- 16865 1
- 16895 1
- 16919 1
- 16948 1
- 16980 1
- 16995 1
- 17015 1
- 17037 1
- 17047 1
- 17066 1
- 17087 1
- 17093 1
- 17113 1
- 17133 1
- 17144 1
- 17158 1
- 17176 1
- 17189 1
- 17206 1
- 17218 1
- 17232 1
- 17243 1
- 17269 1
- 17290 1
- 17303 1
- 17327 1
- 17353 1
- 17362 1
- 17378 1
- 17384 1
- 17404 1
- 17414 1
- 17433 1
- 17452 1
- 17465 1
- 17481 1
- 17490 1
- 17503 1
- 17521 1
- 17533 1
- 17556 1
- 17581 1
- 17606 1
- 17632 1
- 17671 1
- 17683 1
- 17709 1
- 17731 1
- 17768 1
- 17807 1
- 17837 1
- 17855 1
- 17894 1
- 17928 1
- 17956 1
- 17999 1
- 18037 1
- 18070 1
- 18111 1
- 18145 1
- 18228 1
- 18276 1
- 18330 1
- 18373 1
- 18414 1
- 18483 1
- 18542 1
- 18607 1
- 18672 1
- 18766 1
- 18876 1
- 18982 1
- 19116 1
- 19211 1
- 19328 1
- 19419 1
- 19616 1
- 19726 1
- 19849 1
- 20085 1
- 20274 1
- 20363 1
- 20581 1
- 20720 1
- 20842 1
- 20988 1
- 21187 1
- 21433 1
- 21583 1
- 21772 1
- 22067 1
- 22222 1
- 22407 1
- 22752 1
- 22992 1
- 23319 1
- 23631 1
- 23972 1
- 24324 1
- 24518 1
- 24794 1
- 25083 1
- 25406 1
- 25608 1
- 25934 1
- 26214 1
- 26518 1
- 26923 1
- 27282 1
- 27627 1
- 27879 1
- 27973 1
- 28425 1
- 28607 1
- 28926 1
- 29140 1
- 29466 1
- 29750 1
- 30002 1
- 30376 1
- 30561 1
- 31050 1
- 31410 1
- 31728 1
- 31926 1
- 32272 1
- 32554 1
- 32840 1
- 33106 1
- 33548 1
- 33761 1
- 33923 1
- 34151 1
- 34424 1
- 34561 1
- 34841 1
- 35071 1
- 35279 1
- 35570 1
- 35734 1
- 35838 1
- 35981 1
- 36179 1
- 36451 1
- 36683 1
- 37015 1
- 37339 1
- 37479 1
- 42340 1
- 42658 1
- 42921 1
- 43384 1
- 43776 1
- 44260 1
- 44664 1
- 45006 1
- 45409 1
- 45916 1
- 46352 1
- 46716 1
- 47079 1
- 47363 1
- 47628 1
- 47928 1
- 48248 1
- 48515 1
- 48741 1
- 49139 1
- 49404 1
- 49621 1
- 49908 1
- 50154 1
- 50429 1
- 50685 1
- 50966 1
- 51257 1
- 51441 1
- 51643 1
- 51740 1
- 51932 1
- 52122 1
- 52393 1
- 52602 1
- 52736 1
- 52919 1
- 53193 1
- 53421 1
- 53612 1
- 53869 1
- 54029 1
- 54109 1
- 54378 1
- 54580 1
- 54787 1
- 55029 1
- 55207 1
- 55306 1
- 55484 1
- 55678 1
- 55849 1
- 56067 1
- 56275 1
- 56591 1
- 56756 1
- 56976 1
- 57196 1
- 57442 1
- 57632 1
- 57833 1
- 58121 1
- 58314 1
- 58472 1
- 58754 1
- 58936 1
- 59144 1
- 59397 1
- 59605 1
- 59826 1
- 60047 1
- 60286 1
- 60518 1
- 60820 1
- 61090 1
- 61390 1
- 61593 1
- 61790 1
- 62044 1
- 62285 1
- 62496 1
- 62820 1
- 63096 1
- 63418 1
- 63599 1
- 63926 1
- 64169 1
- 64600 1
- 64852 1
- 65130 1
- 65354 1
- 65522 1
- 65739 1
- 66033 1
- 66310 1
- 66609 1
- 66826 1
- 67048 1
- 67191 1
- 67398 1
- 67647 1
- 67936 1
- 68224 1
- 68498 1
- 68754 1
- 68915 1
- 69121 1
- 69344 1
- 69545 1
- 69572 1
- 69712 1
- 69767 1
- 69881 1
- 69950 1
- 70053 1
- 70092 1
- 70239 1
- 70328 1
- 70399 1
- 70453 1
- 70513 1
- 70626 1
- 70738 1
- 70773 1
- 70807 1
- 70832 1
- 70845 1
- 70874 1
- 70917 1
- 70950 1
- 70986 1
- 71036 1
- 71042 1
- 71049 1
- 71094 1
- 71132 1
- 71157 1
- 71198 1
- 71221 1
- 71229 1
- 71236 1
- 71244 1
- 71266 1
- 71286 1
- 71298 1
- 71305 1
- 71313 1
- 71325 1
- 71336 1
- 71348 1
- 71376 1
- 71392 1
- 71424 1
- 71446 1
- 71465 1
- 71481 1
- 71493 1
- 71513 1
- 71534 1
- 71556 1
- 71574 1
- 71587 1
- 71607 1
- 71625 1
- 71638 1
- 71647 1
- 71654 1
- 71655 1
- 71658 1
- 71670 1
- 71691 1
- 71701 1
- 71723 1
- 71741 1
- 71760 1
- 71768 1
- 71783 1
- 71810 1
- 71823 1
- 71825 1
- 71841 1
- 71854 1
- 71874 1
- 71892 1
- 71917 1
- 71935 1
- 71955 1
- 71970 1
- 71999 1
- 72019 1
- 72046 1
- 72074 1
- 72101 1
- 72112 1
- 72128 1
- 72162 1
- 72208 1
- 72264 1
- 72316 1
- 72374 1
- 72404 1
- 72429 1
- 72473 1
- 72534 1
- 72589 1
- 72666 1
- 72717 1
- 72773 1
- 72813 1
- 72857 1
- 72909 1
- 73000 1
- 73083 1
- 73187 1
- 73265 1
- 73310 1
- 73390 1
- 73485 1
- 73603 1
- 73642 1
- 73793 1
- 73864 1
- 73939 1
- 74053 1
- 74149 1
- 74265 1
- 74401 1
- 74533 1
- 74625 1
- 74712 1
- 74806 1
- 74922 1
- 75067 1
- 75199 1
- 75281 1
- 75354 1
- 75426 1
- 75548 1
- 75633 1
- 75737 1
- 75784 1
- 75901 1
- 75988 1
- 76096 1
- 76120 1
- 76284 1
- 76390 1
- 76533 1
- 76639 1
- 76746 1
- 76815 1
- 76947 1
- 77028 1
- 77179 1
- 77295 1
- 77396 1
- 77514 1
- 77603 1
- 77708 1
- 77833 1
- 77932 1
- 78019 1
- 78195 1
- 78212 1
- 78259 1
- 78358 1
- 78425 1
- 78543 1
- 78596 1
- 78674 1
- 78721 1
- 78766 1
- 78849 1
- 78925 1
- 79000 1
- 79056 1
- 79136 1
- 79184 1
- 79201 1
- 79283 1
- 79306 1
- 79328 1
- 79332 1
- 79334 1
- 79343 1
- 79353 1
- 79363 1
- 79371 1
- 79372 1
- 79387 1
- 79420 1
- 79476 1
- 79531 1
- 79593 1
- 79622 1
- 79683 1
- 79726 1
- 79767 1
- 79813 1
- 79865 1
- 79926 1
- 79992 1
- 80057 1
- 80099 1
- 80134 1
- 80206 1
- 80260 1
- 80355 1
- 80443 1
- 80510 1
- 80574 1
- 80628 1
- 80694 1
- 80784 1
- 80892 1
- 80991 1
- 81080 1
- 81145 1
- 81230 1
- 81353 1
- 81477 1
- 81596 1
- 81677 1
- 81803 1
- 81879 1
- 81953 1
- 82114 1
- 82230 1
- 82467 1
- 82711 1
- 82919 1
- 83073 1
- 83186 1
- 83414 1
- 83625 1
- 83950 1
- 84202 1
- 84447 1
- 84628 1
- 84798 1
- 85079 1
- 85337 1
- 85745 1
- 86222 1
- 86756 1
- 87336 1
- 87798 1
- 88377 1
- 89213 1
- 90695 1
- 92275 1
- 93777 1
- 94945 1
- 95672 1
- 96835 1
- 98914 1
- 101935 1
- 104695 1
- 107164 1
- 109307 1
- 110722 1
- 112647 1
- 115027 1
- 117627 1
- 119799 1
- 121842 1
- 123547 1
- 125035 1
- 126609 1
- 127888 1
- 129031 1
- 130217 1
- 130991 1
- 131744 1
- 132211 1
- 132783 1
- 133231 1
- 133807 1
- 134636 1
- 135061 1
- 135340 1
- 135549 1
- 135824 1
- 136298 1
- 136582 1
- 136917 1
- 137171 1
- 137232 1
- 137326 1
- 137515 1
- 137767 1
- 137975 1
- 138174 1
- 138348 1
- 138424 1
- 138455 1
- 138556 1
- 138715 1
- 138905 1
- 139105 1
- 139284 1
- 139355 1
- 139401 1
- 139571 1
- 140555 1
- 141229 1
- 141385 1
- 141471 1
- 141554 1
- 141605 1
- 141719 1
- 141830 1
- 142058 1
- 142180 1
- 142236 1
- 142339 1
- 142393 1
- 142476 1
- 142590 1
- 142653 1
- 142743 1
- 142787 1
- 142840 1
- 142933 1
- 143014 1
- 143096 1
- 143156 1
- 143287 1
- 143320 1
- 143364 1
- 143491 1
- 143545 1
- 143657 1
- 143711 1
- 143742 1
- 143776 1
- 143802 1
- 143873 1
- 143986 1
- 144059 1
- 144108 1
- 144164 1
- 144219 1
- 144279 1
- 144392 1
- 144488 1
- 144573 1
- 144643 1
- 144695 1
- 144745 1
- 144831 1
- 144936 1
- 145035 1
- 145158 1
- 145240 1
- 145349 1
- 145415 1
- 145542 1
- 145696 1
- 146086 1
- 146176 1
- 146237 1
- 146350 1
- 146496 1
- 146652 1
- 146828 1
- 146971 1
- 147073 1
- 147143 1
- 147296 1
- 147509 1
- 147661 1
- 147890 1
- 148057 1
- 148169 1
- 148326 1
- 148499 1
- 148719 1
- 148951 1
- 149198 1
- 149434 1
- 149624 1
- 149770 1
- 150022 1
- 150301 1
- 150590 1
- 151057 1
state 1
- New Jersey 796
fips 1
- 34039 · 796 ✖
county 1
- Union 796
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501391 | 2501391 | 2022-05-13 | Union | New Jersey | 34039 | 151057 | 2355 |
2498133 | 2498133 | 2022-05-12 | Union | New Jersey | 34039 | 150590 | 2355 |
2494875 | 2494875 | 2022-05-11 | Union | New Jersey | 34039 | 150301 | 2354 |
2491617 | 2491617 | 2022-05-10 | Union | New Jersey | 34039 | 150022 | 2353 |
2488359 | 2488359 | 2022-05-09 | Union | New Jersey | 34039 | 149770 | 2352 |
2485102 | 2485102 | 2022-05-08 | Union | New Jersey | 34039 | 149624 | 2352 |
2481844 | 2481844 | 2022-05-07 | Union | New Jersey | 34039 | 149434 | 2352 |
2478586 | 2478586 | 2022-05-06 | Union | New Jersey | 34039 | 149198 | 2351 |
2475328 | 2475328 | 2022-05-05 | Union | New Jersey | 34039 | 148951 | 2351 |
2472071 | 2472071 | 2022-05-04 | Union | New Jersey | 34039 | 148719 | 2351 |
2468815 | 2468815 | 2022-05-03 | Union | New Jersey | 34039 | 148499 | 2354 |
2465559 | 2465559 | 2022-05-02 | Union | New Jersey | 34039 | 148326 | 2355 |
2462304 | 2462304 | 2022-05-01 | Union | New Jersey | 34039 | 148169 | 2355 |
2459048 | 2459048 | 2022-04-30 | Union | New Jersey | 34039 | 148057 | 2355 |
2455792 | 2455792 | 2022-04-29 | Union | New Jersey | 34039 | 147890 | 2355 |
2452536 | 2452536 | 2022-04-28 | Union | New Jersey | 34039 | 147661 | 2355 |
2449280 | 2449280 | 2022-04-27 | Union | New Jersey | 34039 | 147509 | 2357 |
2446023 | 2446023 | 2022-04-26 | Union | New Jersey | 34039 | 147296 | 2357 |
2442768 | 2442768 | 2022-04-25 | Union | New Jersey | 34039 | 147143 | 2357 |
2439512 | 2439512 | 2022-04-24 | Union | New Jersey | 34039 | 147073 | 2356 |
2436256 | 2436256 | 2022-04-23 | Union | New Jersey | 34039 | 146971 | 2356 |
2433000 | 2433000 | 2022-04-22 | Union | New Jersey | 34039 | 146828 | 2356 |
2429744 | 2429744 | 2022-04-21 | Union | New Jersey | 34039 | 146652 | 2356 |
2426488 | 2426488 | 2022-04-20 | Union | New Jersey | 34039 | 146496 | 2355 |
2423232 | 2423232 | 2022-04-19 | Union | New Jersey | 34039 | 146350 | 2355 |
2419975 | 2419975 | 2022-04-18 | Union | New Jersey | 34039 | 146237 | 2355 |
2416720 | 2416720 | 2022-04-17 | Union | New Jersey | 34039 | 146176 | 2357 |
2413464 | 2413464 | 2022-04-16 | Union | New Jersey | 34039 | 146086 | 2357 |
2410208 | 2410208 | 2022-04-15 | Union | New Jersey | 34039 | 145851 | 2357 |
2406952 | 2406952 | 2022-04-14 | Union | New Jersey | 34039 | 145851 | 2357 |
2403696 | 2403696 | 2022-04-13 | Union | New Jersey | 34039 | 145696 | 2357 |
2400441 | 2400441 | 2022-04-12 | Union | New Jersey | 34039 | 145542 | 2357 |
2397186 | 2397186 | 2022-04-11 | Union | New Jersey | 34039 | 145415 | 2357 |
2393931 | 2393931 | 2022-04-10 | Union | New Jersey | 34039 | 145349 | 2357 |
2390675 | 2390675 | 2022-04-09 | Union | New Jersey | 34039 | 145240 | 2357 |
2387419 | 2387419 | 2022-04-08 | Union | New Jersey | 34039 | 145158 | 2357 |
2384164 | 2384164 | 2022-04-07 | Union | New Jersey | 34039 | 145035 | 2355 |
2380909 | 2380909 | 2022-04-06 | Union | New Jersey | 34039 | 144936 | 2355 |
2377654 | 2377654 | 2022-04-05 | Union | New Jersey | 34039 | 144831 | 2353 |
2374401 | 2374401 | 2022-04-04 | Union | New Jersey | 34039 | 144745 | 2353 |
2371149 | 2371149 | 2022-04-03 | Union | New Jersey | 34039 | 144695 | 2354 |
2367896 | 2367896 | 2022-04-02 | Union | New Jersey | 34039 | 144643 | 2354 |
2364643 | 2364643 | 2022-04-01 | Union | New Jersey | 34039 | 144573 | 2355 |
2361389 | 2361389 | 2022-03-31 | Union | New Jersey | 34039 | 144488 | 2354 |
2358135 | 2358135 | 2022-03-30 | Union | New Jersey | 34039 | 144392 | 2354 |
2354882 | 2354882 | 2022-03-29 | Union | New Jersey | 34039 | 144279 | 2354 |
2351629 | 2351629 | 2022-03-28 | Union | New Jersey | 34039 | 144219 | 2353 |
2348377 | 2348377 | 2022-03-27 | Union | New Jersey | 34039 | 144164 | 2352 |
2345124 | 2345124 | 2022-03-26 | Union | New Jersey | 34039 | 144108 | 2352 |
2341871 | 2341871 | 2022-03-25 | Union | New Jersey | 34039 | 144059 | 2352 |
2338618 | 2338618 | 2022-03-24 | Union | New Jersey | 34039 | 143986 | 2352 |
2335364 | 2335364 | 2022-03-23 | Union | New Jersey | 34039 | 143873 | 2351 |
2332110 | 2332110 | 2022-03-22 | Union | New Jersey | 34039 | 143802 | 2352 |
2328857 | 2328857 | 2022-03-21 | Union | New Jersey | 34039 | 143776 | 2351 |
2325605 | 2325605 | 2022-03-20 | Union | New Jersey | 34039 | 143742 | 2350 |
2322351 | 2322351 | 2022-03-19 | Union | New Jersey | 34039 | 143711 | 2350 |
2319097 | 2319097 | 2022-03-18 | Union | New Jersey | 34039 | 143657 | 2349 |
2315844 | 2315844 | 2022-03-17 | Union | New Jersey | 34039 | 143545 | 2349 |
2312591 | 2312591 | 2022-03-16 | Union | New Jersey | 34039 | 143491 | 2348 |
2309338 | 2309338 | 2022-03-15 | Union | New Jersey | 34039 | 143364 | 2348 |
2306085 | 2306085 | 2022-03-14 | Union | New Jersey | 34039 | 143320 | 2348 |
2302834 | 2302834 | 2022-03-13 | Union | New Jersey | 34039 | 143287 | 2348 |
2299582 | 2299582 | 2022-03-12 | Union | New Jersey | 34039 | 143215 | 2348 |
2296330 | 2296330 | 2022-03-11 | Union | New Jersey | 34039 | 143215 | 2348 |
2293078 | 2293078 | 2022-03-10 | Union | New Jersey | 34039 | 143156 | 2347 |
2289826 | 2289826 | 2022-03-09 | Union | New Jersey | 34039 | 143096 | 2347 |
2286574 | 2286574 | 2022-03-08 | Union | New Jersey | 34039 | 143014 | 2350 |
2283322 | 2283322 | 2022-03-07 | Union | New Jersey | 34039 | 142933 | 2350 |
2280069 | 2280069 | 2022-03-06 | Union | New Jersey | 34039 | 142840 | 2350 |
2276816 | 2276816 | 2022-03-05 | Union | New Jersey | 34039 | 142787 | 2350 |
2273563 | 2273563 | 2022-03-04 | Union | New Jersey | 34039 | 142743 | 2348 |
2270311 | 2270311 | 2022-03-03 | Union | New Jersey | 34039 | 142653 | 2346 |
2267058 | 2267058 | 2022-03-02 | Union | New Jersey | 34039 | 142590 | 2346 |
2263807 | 2263807 | 2022-03-01 | Union | New Jersey | 34039 | 142476 | 2344 |
2260556 | 2260556 | 2022-02-28 | Union | New Jersey | 34039 | 142393 | 2343 |
2257305 | 2257305 | 2022-02-27 | Union | New Jersey | 34039 | 142339 | 2341 |
2254054 | 2254054 | 2022-02-26 | Union | New Jersey | 34039 | 142236 | 2341 |
2250803 | 2250803 | 2022-02-25 | Union | New Jersey | 34039 | 142180 | 2336 |
2247552 | 2247552 | 2022-02-24 | Union | New Jersey | 34039 | 142058 | 2326 |
2244301 | 2244301 | 2022-02-23 | Union | New Jersey | 34039 | 141830 | 2318 |
2241050 | 2241050 | 2022-02-22 | Union | New Jersey | 34039 | 141719 | 2312 |
2237799 | 2237799 | 2022-02-21 | Union | New Jersey | 34039 | 141605 | 2312 |
2234548 | 2234548 | 2022-02-20 | Union | New Jersey | 34039 | 141554 | 2312 |
2231297 | 2231297 | 2022-02-19 | Union | New Jersey | 34039 | 141471 | 2312 |
2228046 | 2228046 | 2022-02-18 | Union | New Jersey | 34039 | 141385 | 2310 |
2224795 | 2224795 | 2022-02-17 | Union | New Jersey | 34039 | 141229 | 2305 |
2221544 | 2221544 | 2022-02-16 | Union | New Jersey | 34039 | 140555 | 2301 |
2218293 | 2218293 | 2022-02-15 | Union | New Jersey | 34039 | 139571 | 2296 |
2215042 | 2215042 | 2022-02-14 | Union | New Jersey | 34039 | 139401 | 2284 |
2211790 | 2211790 | 2022-02-13 | Union | New Jersey | 34039 | 139355 | 2282 |
2208537 | 2208537 | 2022-02-12 | Union | New Jersey | 34039 | 139284 | 2280 |
2205284 | 2205284 | 2022-02-11 | Union | New Jersey | 34039 | 139105 | 2278 |
2202031 | 2202031 | 2022-02-10 | Union | New Jersey | 34039 | 138905 | 2274 |
2198777 | 2198777 | 2022-02-09 | Union | New Jersey | 34039 | 138715 | 2264 |
2195523 | 2195523 | 2022-02-08 | Union | New Jersey | 34039 | 138556 | 2256 |
2192269 | 2192269 | 2022-02-07 | Union | New Jersey | 34039 | 138455 | 2247 |
2189016 | 2189016 | 2022-02-06 | Union | New Jersey | 34039 | 138424 | 2246 |
2185763 | 2185763 | 2022-02-05 | Union | New Jersey | 34039 | 138348 | 2244 |
2182511 | 2182511 | 2022-02-04 | Union | New Jersey | 34039 | 138174 | 2239 |
2179259 | 2179259 | 2022-02-03 | Union | New Jersey | 34039 | 137975 | 2233 |
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);