ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 36119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 798 ✖
- 164595 2
- 246819 2
- 264447 2
- 9 1
- 17 1
- 33 1
- 69 1
- 81 1
- 97 1
- 107 1
- 120 1
- 147 1
- 157 1
- 178 1
- 195 1
- 219 1
- 379 1
- 537 1
- 797 1
- 1091 1
- 1387 1
- 1873 1
- 2894 1
- 3891 1
- 4691 1
- 5944 1
- 7187 1
- 7875 1
- 8519 1
- 9326 1
- 9967 1
- 10683 1
- 11566 1
- 12350 1
- 13080 1
- 13722 1
- 14293 1
- 14804 1
- 15887 1
- 17004 1
- 18077 1
- 18729 1
- 19313 1
- 19785 1
- 20191 1
- 20947 1
- 21828 1
- 22476 1
- 23179 1
- 23803 1
- 24306 1
- 24655 1
- 25275 1
- 25959 1
- 26632 1
- 27230 1
- 27664 1
- 28007 1
- 28245 1
- 28625 1
- 28969 1
- 29231 1
- 29626 1
- 29884 1
- 30097 1
- 30239 1
- 30426 1
- 30709 1
- 30904 1
- 31086 1
- 31293 1
- 31383 1
- 31471 1
- 31610 1
- 31791 1
- 31942 1
- 32096 1
- 32223 1
- 32322 1
- 32401 1
- 32516 1
- 32672 1
- 32766 1
- 32880 1
- 32967 1
- 33048 1
- 33106 1
- 33185 1
- 33292 1
- 33348 1
- 33428 1
- 33480 1
- 33551 1
- 33632 1
- 33690 1
- 33766 1
- 33853 1
- 33923 1
- 33953 1
- 33999 1
- 34034 1
- 34075 1
- 34105 1
- 34174 1
- 34252 1
- 34289 1
- 34326 1
- 34357 1
- 34384 1
- 34408 1
- 34454 1
- 34485 1
- 34520 1
- 34556 1
- 34580 1
- 34596 1
- 34641 1
- 34699 1
- 34747 1
- 34779 1
- 34797 1
- 34837 1
- 34865 1
- 34911 1
- 34979 1
- 35019 1
- 35042 1
- 35083 1
- 35105 1
- 35153 1
- 35182 1
- 35225 1
- 35259 1
- 35296 1
- 35326 1
- 35365 1
- 35393 1
- 35421 1
- 35462 1
- 35502 1
- 35514 1
- 35550 1
- 35586 1
- 35635 1
- 35666 1
- 35699 1
- 35737 1
- 35776 1
- 35798 1
- 35837 1
- 35873 1
- 35912 1
- 35932 1
- 35973 1
- 35997 1
- 36013 1
- 36048 1
- 36074 1
- 36106 1
- 36135 1
- 36179 1
- 36204 1
- 36232 1
- 36271 1
- 36323 1
- 36356 1
- 36401 1
- 36434 1
- 36452 1
- 36485 1
- 36539 1
- 36562 1
- 36585 1
- 36620 1
- 36650 1
- 36688 1
- 36709 1
- 36741 1
- 36779 1
- 36824 1
- 36862 1
- 36894 1
- 36948 1
- 36983 1
- 37020 1
- 37056 1
- 37105 1
- 37151 1
- 37204 1
- 37245 1
- 37276 1
- 37313 1
- 37354 1
- 37404 1
- 37453 1
- 37485 1
- 37530 1
- 37570 1
- 37600 1
- 37633 1
- 37671 1
- 37717 1
- 37754 1
- 37800 1
- 37836 1
- 37865 1
- 37902 1
- 37947 1
- 38000 1
- 38050 1
- 38097 1
- 38132 1
- 38181 1
- 38238 1
- 38299 1
- 38345 1
- 38430 1
- 38474 1
- 38514 1
- 38566 1
- 38627 1
- 38693 1
- 38770 1
- 38846 1
- 38893 1
- 39000 1
- 39063 1
- 39117 1
- 39199 1
- 39287 1
- 39397 1
- 39475 1
- 39547 1
- 39615 1
- 39693 1
- 39788 1
- 39889 1
- 40040 1
- 40130 1
- 40201 1
- 40321 1
- 40437 1
- 40553 1
- 40680 1
- 40796 1
- 40945 1
- 41060 1
- 41225 1
- 41359 1
- 41541 1
- 41719 1
- 41953 1
- 42178 1
- 42453 1
- 42695 1
- 42939 1
- 43291 1
- 43655 1
- 44092 1
- 44345 1
- 44575 1
- 44974 1
- 45334 1
- 45671 1
- 46063 1
- 46468 1
- 46840 1
- 47261 1
- 47631 1
- 47963 1
- 48440 1
- 49101 1
- 49645 1
- 50109 1
- 50692 1
- 51219 1
- 51789 1
- 52417 1
- 53185 1
- 53943 1
- 54670 1
- 55186 1
- 55796 1
- 56371 1
- 56994 1
- 57605 1
- 58243 1
- 58836 1
- 59430 1
- 59990 1
- 60539 1
- 61110 1
- 61826 1
- 62404 1
- 62939 1
- 63372 1
- 63908 1
- 64559 1
- 65136 1
- 65850 1
- 66404 1
- 66836 1
- 67387 1
- 67930 1
- 68701 1
- 69660 1
- 70613 1
- 71626 1
- 72217 1
- 72761 1
- 73380 1
- 74156 1
- 75175 1
- 76088 1
- 76941 1
- 77730 1
- 78533 1
- 79405 1
- 80145 1
- 80868 1
- 81981 1
- 82932 1
- 83707 1
- 84419 1
- 85019 1
- 85722 1
- 86645 1
- 87569 1
- 88403 1
- 89224 1
- 90028 1
- 90664 1
- 91222 1
- 92061 1
- 92793 1
- 93584 1
- 94213 1
- 94697 1
- 95302 1
- 95641 1
- 95988 1
- 96464 1
- 97222 1
- 97907 1
- 98444 1
- 98903 1
- 99308 1
- 99983 1
- 100503 1
- 101014 1
- 101510 1
- 101815 1
- 102196 1
- 102597 1
- 103018 1
- 103505 1
- 103989 1
- 104399 1
- 104776 1
- 105167 1
- 105549 1
- 106128 1
- 106610 1
- 107074 1
- 107486 1
- 107856 1
- 108192 1
- 108622 1
- 109037 1
- 109515 1
- 109950 1
- 110329 1
- 110599 1
- 110969 1
- 111338 1
- 111712 1
- 112207 1
- 112566 1
- 112853 1
- 113203 1
- 113576 1
- 113998 1
- 114401 1
- 114801 1
- 115221 1
- 115562 1
- 115934 1
- 116288 1
- 116663 1
- 117067 1
- 117508 1
- 118000 1
- 118504 1
- 118963 1
- 119241 1
- 119731 1
- 120315 1
- 120733 1
- 121123 1
- 121506 1
- 121803 1
- 122065 1
- 122411 1
- 122779 1
- 123202 1
- 123547 1
- 123837 1
- 124091 1
- 124316 1
- 124534 1
- 124880 1
- 125171 1
- 125486 1
- 125725 1
- 125912 1
- 126093 1
- 126277 1
- 126493 1
- 126705 1
- 126895 1
- 127045 1
- 127178 1
- 127272 1
- 127392 1
- 127520 1
- 127663 1
- 127816 1
- 127912 1
- 127974 1
- 128065 1
- 128152 1
- 128235 1
- 128302 1
- 128411 1
- 128473 1
- 128530 1
- 128583 1
- 128623 1
- 128702 1
- 128762 1
- 128834 1
- 128863 1
- 128896 1
- 128920 1
- 128966 1
- 129017 1
- 129079 1
- 129130 1
- 129160 1
- 129178 1
- 129206 1
- 129237 1
- 129270 1
- 129312 1
- 129341 1
- 129368 1
- 129386 1
- 129398 1
- 129410 1
- 129419 1
- 129448 1
- 129470 1
- 129487 1
- 129506 1
- 129525 1
- 129551 1
- 129578 1
- 129599 1
- 129623 1
- 129644 1
- 129656 1
- 129663 1
- 129679 1
- 129691 1
- 129705 1
- 129727 1
- 129730 1
- 129736 1
- 129745 1
- 129756 1
- 129780 1
- 129799 1
- 129813 1
- 129829 1
- 129834 1
- 129848 1
- 129865 1
- 129887 1
- 129902 1
- 129911 1
- 129926 1
- 129937 1
- 129946 1
- 129961 1
- 129981 1
- 130014 1
- 130048 1
- 130080 1
- 130113 1
- 130150 1
- 130182 1
- 130233 1
- 130280 1
- 130331 1
- 130386 1
- 130420 1
- 130471 1
- 130527 1
- 130590 1
- 130666 1
- 130751 1
- 130825 1
- 130893 1
- 130967 1
- 131049 1
- 131178 1
- 131318 1
- 131474 1
- 131611 1
- 131709 1
- 131856 1
- 131995 1
- 132178 1
- 132326 1
- 132518 1
- 132652 1
- 132820 1
- 132981 1
- 133196 1
- 133424 1
- 133626 1
- 133812 1
- 134020 1
- 134166 1
- 134355 1
- 134589 1
- 134832 1
- 135064 1
- 135294 1
- 135445 1
- 135599 1
- 135745 1
- 135921 1
- 136136 1
- 136417 1
- 136648 1
- 136817 1
- 136964 1
- 137103 1
- 137315 1
- 137491 1
- 137684 1
- 137872 1
- 138047 1
- 138195 1
- 138298 1
- 138416 1
- 138582 1
- 138882 1
- 139047 1
- 139197 1
- 139331 1
- 139487 1
- 139664 1
- 139858 1
- 140024 1
- 140203 1
- 140361 1
- 140480 1
- 140625 1
- 140779 1
- 140933 1
- 141090 1
- 141219 1
- 141334 1
- 141415 1
- 141531 1
- 141627 1
- 141730 1
- 141843 1
- 141941 1
- 142029 1
- 142110 1
- 142199 1
- 142323 1
- 142433 1
- 142547 1
- 142648 1
- 142696 1
- 142835 1
- 142925 1
- 143014 1
- 143099 1
- 143200 1
- 143309 1
- 143387 1
- 143433 1
- 143480 1
- 143553 1
- 143635 1
- 143716 1
- 143775 1
- 143851 1
- 143937 1
- 143986 1
- 144049 1
- 144163 1
- 144251 1
- 144342 1
- 144408 1
- 144476 1
- 144541 1
- 144613 1
- 144677 1
- 144775 1
- 144858 1
- 144942 1
- 145016 1
- 145097 1
- 145179 1
- 145319 1
- 145470 1
- 145601 1
- 145693 1
- 145816 1
- 145934 1
- 146084 1
- 146254 1
- 146399 1
- 146578 1
- 146734 1
- 146871 1
- 147018 1
- 147176 1
- 147369 1
- 147548 1
- 147641 1
- 147820 1
- 147987 1
- 148166 1
- 148453 1
- 148764 1
- 149123 1
- 149445 1
- 149833 1
- 150067 1
- 150347 1
- 150742 1
- 151108 1
- 151549 1
- 152046 1
- 152505 1
- 152855 1
- 153147 1
- 153695 1
- 154425 1
- 155408 1
- 156312 1
- 157295 1
- 158252 1
- 159077 1
- 160477 1
- 162232 1
- 169324 1
- 170513 1
- 172562 1
- 175670 1
- 179079 1
- 182681 1
- 186738 1
- 190045 1
- 192287 1
- 194963 1
- 198899 1
- 203074 1
- 207054 1
- 211486 1
- 215424 1
- 218228 1
- 220257 1
- 222731 1
- 225085 1
- 227666 1
- 229896 1
- 232067 1
- 233045 1
- 233866 1
- 234788 1
- 235817 1
- 236806 1
- 237633 1
- 238394 1
- 238824 1
- 239275 1
- 239845 1
- 240513 1
- 241082 1
- 241496 1
- 241817 1
- 242026 1
- 242283 1
- 242592 1
- 242887 1
- 243178 1
- 243595 1
- 243770 1
- 243877 1
- 244032 1
- 244269 1
- 244499 1
- 244676 1
- 244861 1
- 244997 1
- 245085 1
- 245172 1
- 245289 1
- 245429 1
- 245709 1
- 245849 1
- 245951 1
- 246000 1
- 246058 1
- 246157 1
- 246262 1
- 246358 1
- 246425 1
- 246495 1
- 246550 1
- 246610 1
- 246696 1
- 247035 1
- 247249 1
- 247297 1
- 247343 1
- 247451 1
- 247540 1
- 247646 1
- 247737 1
- 247815 1
- 247863 1
- 248001 1
- 248100 1
- 248222 1
- 248323 1
- 248603 1
- 248705 1
- 248765 1
- 248831 1
- 248969 1
- 249120 1
- 249289 1
- 249451 1
- 249566 1
- 249660 1
- 249794 1
- 249982 1
- 250207 1
- 250429 1
- 250640 1
- 250856 1
- 250973 1
- 251124 1
- 251390 1
- 251676 1
- 252073 1
- 252418 1
- 252751 1
- 252946 1
- 253168 1
- 253499 1
- 253855 1
- 254171 1
- 254505 1
- 254778 1
- 255016 1
- 255289 1
- 255610 1
- 255973 1
- 256401 1
- 256698 1
- 256934 1
- 257144 1
- 257351 1
- 257736 1
- 258177 1
- 258570 1
- 259051 1
- 259391 1
- 259642 1
- 259923 1
- 260394 1
- 260907 1
- 261464 1
- 262014 1
- 262511 1
- 262890 1
- 263253 1
- 263806 1
state 1
- New York 801
fips 1
- 36119 · 801 ✖
county 1
- Westchester 801
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501483 | 2501483 | 2022-05-13 | Westchester | New York | 36119 | 264447 | 2720 |
2498225 | 2498225 | 2022-05-12 | Westchester | New York | 36119 | 264447 | 2720 |
2494967 | 2494967 | 2022-05-11 | Westchester | New York | 36119 | 263806 | 2719 |
2491709 | 2491709 | 2022-05-10 | Westchester | New York | 36119 | 263253 | 2718 |
2488451 | 2488451 | 2022-05-09 | Westchester | New York | 36119 | 262890 | 2718 |
2485194 | 2485194 | 2022-05-08 | Westchester | New York | 36119 | 262511 | 2718 |
2481936 | 2481936 | 2022-05-07 | Westchester | New York | 36119 | 262014 | 2718 |
2478678 | 2478678 | 2022-05-06 | Westchester | New York | 36119 | 261464 | 2718 |
2475420 | 2475420 | 2022-05-05 | Westchester | New York | 36119 | 260907 | 2718 |
2472163 | 2472163 | 2022-05-04 | Westchester | New York | 36119 | 260394 | 2717 |
2468907 | 2468907 | 2022-05-03 | Westchester | New York | 36119 | 259923 | 2717 |
2465651 | 2465651 | 2022-05-02 | Westchester | New York | 36119 | 259642 | 2717 |
2462396 | 2462396 | 2022-05-01 | Westchester | New York | 36119 | 259391 | 2715 |
2459140 | 2459140 | 2022-04-30 | Westchester | New York | 36119 | 259051 | 2715 |
2455884 | 2455884 | 2022-04-29 | Westchester | New York | 36119 | 258570 | 2715 |
2452628 | 2452628 | 2022-04-28 | Westchester | New York | 36119 | 258177 | 2715 |
2449372 | 2449372 | 2022-04-27 | Westchester | New York | 36119 | 257736 | 2715 |
2446115 | 2446115 | 2022-04-26 | Westchester | New York | 36119 | 257351 | 2714 |
2442860 | 2442860 | 2022-04-25 | Westchester | New York | 36119 | 257144 | 2714 |
2439604 | 2439604 | 2022-04-24 | Westchester | New York | 36119 | 256934 | 2714 |
2436348 | 2436348 | 2022-04-23 | Westchester | New York | 36119 | 256698 | 2713 |
2433092 | 2433092 | 2022-04-22 | Westchester | New York | 36119 | 256401 | 2712 |
2429836 | 2429836 | 2022-04-21 | Westchester | New York | 36119 | 255973 | 2710 |
2426580 | 2426580 | 2022-04-20 | Westchester | New York | 36119 | 255610 | 2709 |
2423324 | 2423324 | 2022-04-19 | Westchester | New York | 36119 | 255289 | 2709 |
2420067 | 2420067 | 2022-04-18 | Westchester | New York | 36119 | 255016 | 2708 |
2416812 | 2416812 | 2022-04-17 | Westchester | New York | 36119 | 254778 | 2708 |
2413556 | 2413556 | 2022-04-16 | Westchester | New York | 36119 | 254505 | 2708 |
2410300 | 2410300 | 2022-04-15 | Westchester | New York | 36119 | 254171 | 2708 |
2407044 | 2407044 | 2022-04-14 | Westchester | New York | 36119 | 253855 | 2706 |
2403788 | 2403788 | 2022-04-13 | Westchester | New York | 36119 | 253499 | 2706 |
2400533 | 2400533 | 2022-04-12 | Westchester | New York | 36119 | 253168 | 2706 |
2397278 | 2397278 | 2022-04-11 | Westchester | New York | 36119 | 252946 | 2706 |
2394023 | 2394023 | 2022-04-10 | Westchester | New York | 36119 | 252751 | 2706 |
2390767 | 2390767 | 2022-04-09 | Westchester | New York | 36119 | 252418 | 2706 |
2387511 | 2387511 | 2022-04-08 | Westchester | New York | 36119 | 252073 | 2706 |
2384256 | 2384256 | 2022-04-07 | Westchester | New York | 36119 | 251676 | 2706 |
2381001 | 2381001 | 2022-04-06 | Westchester | New York | 36119 | 251390 | 2705 |
2377746 | 2377746 | 2022-04-05 | Westchester | New York | 36119 | 251124 | 2705 |
2374493 | 2374493 | 2022-04-04 | Westchester | New York | 36119 | 250973 | 2705 |
2371241 | 2371241 | 2022-04-03 | Westchester | New York | 36119 | 250856 | 2705 |
2367988 | 2367988 | 2022-04-02 | Westchester | New York | 36119 | 250640 | 2704 |
2364735 | 2364735 | 2022-04-01 | Westchester | New York | 36119 | 250429 | 2703 |
2361481 | 2361481 | 2022-03-31 | Westchester | New York | 36119 | 250207 | 2702 |
2358227 | 2358227 | 2022-03-30 | Westchester | New York | 36119 | 249982 | 2702 |
2354973 | 2354973 | 2022-03-29 | Westchester | New York | 36119 | 249794 | 2702 |
2351720 | 2351720 | 2022-03-28 | Westchester | New York | 36119 | 249660 | 2701 |
2348468 | 2348468 | 2022-03-27 | Westchester | New York | 36119 | 249566 | 2700 |
2345215 | 2345215 | 2022-03-26 | Westchester | New York | 36119 | 249451 | 2700 |
2341962 | 2341962 | 2022-03-25 | Westchester | New York | 36119 | 249289 | 2699 |
2338709 | 2338709 | 2022-03-24 | Westchester | New York | 36119 | 249120 | 2699 |
2335455 | 2335455 | 2022-03-23 | Westchester | New York | 36119 | 248969 | 2699 |
2332201 | 2332201 | 2022-03-22 | Westchester | New York | 36119 | 248831 | 2698 |
2328948 | 2328948 | 2022-03-21 | Westchester | New York | 36119 | 248765 | 2698 |
2325696 | 2325696 | 2022-03-20 | Westchester | New York | 36119 | 248705 | 2698 |
2322443 | 2322443 | 2022-03-19 | Westchester | New York | 36119 | 248603 | 2698 |
2319189 | 2319189 | 2022-03-18 | Westchester | New York | 36119 | 248323 | 2698 |
2315935 | 2315935 | 2022-03-17 | Westchester | New York | 36119 | 248222 | 2697 |
2312682 | 2312682 | 2022-03-16 | Westchester | New York | 36119 | 248100 | 2697 |
2309429 | 2309429 | 2022-03-15 | Westchester | New York | 36119 | 248001 | 2696 |
2306176 | 2306176 | 2022-03-14 | Westchester | New York | 36119 | 247863 | 2695 |
2302925 | 2302925 | 2022-03-13 | Westchester | New York | 36119 | 247815 | 2695 |
2299673 | 2299673 | 2022-03-12 | Westchester | New York | 36119 | 247737 | 2692 |
2296421 | 2296421 | 2022-03-11 | Westchester | New York | 36119 | 247646 | 2692 |
2293169 | 2293169 | 2022-03-10 | Westchester | New York | 36119 | 247540 | 2692 |
2289917 | 2289917 | 2022-03-09 | Westchester | New York | 36119 | 247451 | 2692 |
2286665 | 2286665 | 2022-03-08 | Westchester | New York | 36119 | 247343 | 2691 |
2283413 | 2283413 | 2022-03-07 | Westchester | New York | 36119 | 247297 | 2691 |
2280161 | 2280161 | 2022-03-06 | Westchester | New York | 36119 | 247249 | 2690 |
2276908 | 2276908 | 2022-03-05 | Westchester | New York | 36119 | 247035 | 2690 |
2273655 | 2273655 | 2022-03-04 | Westchester | New York | 36119 | 246819 | 2690 |
2270402 | 2270402 | 2022-03-03 | Westchester | New York | 36119 | 246819 | 2690 |
2267150 | 2267150 | 2022-03-02 | Westchester | New York | 36119 | 246696 | 2689 |
2263898 | 2263898 | 2022-03-01 | Westchester | New York | 36119 | 246610 | 2687 |
2260647 | 2260647 | 2022-02-28 | Westchester | New York | 36119 | 246550 | 2686 |
2257396 | 2257396 | 2022-02-27 | Westchester | New York | 36119 | 246495 | 2685 |
2254145 | 2254145 | 2022-02-26 | Westchester | New York | 36119 | 246425 | 2685 |
2250894 | 2250894 | 2022-02-25 | Westchester | New York | 36119 | 246358 | 2681 |
2247643 | 2247643 | 2022-02-24 | Westchester | New York | 36119 | 246262 | 2680 |
2244392 | 2244392 | 2022-02-23 | Westchester | New York | 36119 | 246157 | 2677 |
2241141 | 2241141 | 2022-02-22 | Westchester | New York | 36119 | 246058 | 2676 |
2237890 | 2237890 | 2022-02-21 | Westchester | New York | 36119 | 246000 | 2676 |
2234639 | 2234639 | 2022-02-20 | Westchester | New York | 36119 | 245951 | 2672 |
2231388 | 2231388 | 2022-02-19 | Westchester | New York | 36119 | 245849 | 2672 |
2228137 | 2228137 | 2022-02-18 | Westchester | New York | 36119 | 245709 | 2670 |
2224886 | 2224886 | 2022-02-17 | Westchester | New York | 36119 | 245429 | 2669 |
2221635 | 2221635 | 2022-02-16 | Westchester | New York | 36119 | 245289 | 2665 |
2218384 | 2218384 | 2022-02-15 | Westchester | New York | 36119 | 245172 | 2665 |
2215133 | 2215133 | 2022-02-14 | Westchester | New York | 36119 | 245085 | 2660 |
2211882 | 2211882 | 2022-02-13 | Westchester | New York | 36119 | 244997 | 2658 |
2208629 | 2208629 | 2022-02-12 | Westchester | New York | 36119 | 244861 | 2655 |
2205376 | 2205376 | 2022-02-11 | Westchester | New York | 36119 | 244676 | 2655 |
2202123 | 2202123 | 2022-02-10 | Westchester | New York | 36119 | 244499 | 2651 |
2198869 | 2198869 | 2022-02-09 | Westchester | New York | 36119 | 244269 | 2649 |
2195615 | 2195615 | 2022-02-08 | Westchester | New York | 36119 | 244032 | 2647 |
2192361 | 2192361 | 2022-02-07 | Westchester | New York | 36119 | 243877 | 2643 |
2189107 | 2189107 | 2022-02-06 | Westchester | New York | 36119 | 243770 | 2640 |
2185854 | 2185854 | 2022-02-05 | Westchester | New York | 36119 | 243595 | 2638 |
2182602 | 2182602 | 2022-02-04 | Westchester | New York | 36119 | 243178 | 2635 |
2179350 | 2179350 | 2022-02-03 | Westchester | New York | 36119 | 242887 | 2632 |
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);