ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 770 ✖
- 1 7
- 80977 7
- 81732 3
- 4224 2
- 4554 2
- 35509 2
- 35875 2
- 36328 2
- 36806 2
- 44694 2
- 78576 2
- 79418 2
- 5 1
- 10 1
- 17 1
- 21 1
- 23 1
- 33 1
- 44 1
- 56 1
- 79 1
- 94 1
- 126 1
- 184 1
- 245 1
- 312 1
- 378 1
- 466 1
- 588 1
- 636 1
- 716 1
- 774 1
- 857 1
- 949 1
- 994 1
- 1039 1
- 1082 1
- 1130 1
- 1176 1
- 1251 1
- 1296 1
- 1335 1
- 1396 1
- 1441 1
- 1469 1
- 1544 1
- 1591 1
- 1656 1
- 1716 1
- 1780 1
- 1813 1
- 1834 1
- 1970 1
- 2008 1
- 2050 1
- 2103 1
- 2182 1
- 2214 1
- 2240 1
- 2279 1
- 2313 1
- 2355 1
- 2390 1
- 2429 1
- 2453 1
- 2465 1
- 2499 1
- 2518 1
- 2566 1
- 2600 1
- 2659 1
- 2703 1
- 2727 1
- 2758 1
- 2779 1
- 2814 1
- 2842 1
- 2866 1
- 2911 1
- 2920 1
- 2933 1
- 2958 1
- 3022 1
- 3045 1
- 3062 1
- 3082 1
- 3083 1
- 3108 1
- 3120 1
- 3124 1
- 3136 1
- 3144 1
- 3151 1
- 3168 1
- 3175 1
- 3193 1
- 3202 1
- 3217 1
- 3232 1
- 3240 1
- 3246 1
- 3250 1
- 3255 1
- 3270 1
- 3284 1
- 3304 1
- 3309 1
- 3312 1
- 3327 1
- 3339 1
- 3352 1
- 3360 1
- 3377 1
- 3389 1
- 3407 1
- 3413 1
- 3425 1
- 3441 1
- 3458 1
- 3463 1
- 3471 1
- 3475 1
- 3485 1
- 3500 1
- 3513 1
- 3527 1
- 3546 1
- 3554 1
- 3555 1
- 3558 1
- 3582 1
- 3601 1
- 3614 1
- 3631 1
- 3643 1
- 3649 1
- 3657 1
- 3669 1
- 3686 1
- 3703 1
- 3727 1
- 3746 1
- 3758 1
- 3780 1
- 3806 1
- 3816 1
- 3827 1
- 3843 1
- 3860 1
- 3863 1
- 3878 1
- 3891 1
- 3902 1
- 3913 1
- 3918 1
- 3928 1
- 3931 1
- 3944 1
- 3956 1
- 3982 1
- 3991 1
- 3999 1
- 4008 1
- 4013 1
- 4014 1
- 4022 1
- 4036 1
- 4049 1
- 4050 1
- 4059 1
- 4066 1
- 4068 1
- 4073 1
- 4080 1
- 4092 1
- 4112 1
- 4114 1
- 4117 1
- 4120 1
- 4130 1
- 4134 1
- 4141 1
- 4152 1
- 4158 1
- 4173 1
- 4176 1
- 4186 1
- 4196 1
- 4210 1
- 4258 1
- 4277 1
- 4301 1
- 4329 1
- 4349 1
- 4364 1
- 4390 1
- 4394 1
- 4403 1
- 4421 1
- 4443 1
- 4457 1
- 4476 1
- 4487 1
- 4503 1
- 4513 1
- 4523 1
- 4532 1
- 4597 1
- 4606 1
- 4638 1
- 4684 1
- 4714 1
- 4737 1
- 4820 1
- 4852 1
- 4864 1
- 4883 1
- 4905 1
- 4929 1
- 4972 1
- 5022 1
- 5049 1
- 5062 1
- 5088 1
- 5108 1
- 5155 1
- 5184 1
- 5232 1
- 5269 1
- 5304 1
- 5341 1
- 5393 1
- 5439 1
- 5481 1
- 5568 1
- 5619 1
- 5655 1
- 5700 1
- 5748 1
- 5826 1
- 5911 1
- 6004 1
- 6058 1
- 6131 1
- 6207 1
- 6324 1
- 6457 1
- 6593 1
- 6700 1
- 6842 1
- 6918 1
- 7013 1
- 7143 1
- 7311 1
- 7472 1
- 7666 1
- 7840 1
- 7984 1
- 8137 1
- 8277 1
- 8478 1
- 8667 1
- 8903 1
- 9000 1
- 9104 1
- 9199 1
- 9444 1
- 9632 1
- 10036 1
- 10327 1
- 10539 1
- 10767 1
- 11000 1
- 11226 1
- 11639 1
- 11908 1
- 12151 1
- 12446 1
- 12672 1
- 12818 1
- 13151 1
- 13459 1
- 13642 1
- 13855 1
- 14123 1
- 14443 1
- 14638 1
- 14876 1
- 15226 1
- 15460 1
- 15679 1
- 15779 1
- 15893 1
- 16084 1
- 16380 1
- 16648 1
- 16940 1
- 17261 1
- 17358 1
- 17430 1
- 17738 1
- 18017 1
- 18331 1
- 18653 1
- 18990 1
- 19205 1
- 19334 1
- 19508 1
- 19753 1
- 19981 1
- 20191 1
- 20432 1
- 20611 1
- 20716 1
- 20952 1
- 21157 1
- 21337 1
- 21553 1
- 21800 1
- 21929 1
- 22026 1
- 22277 1
- 22485 1
- 22687 1
- 23135 1
- 23315 1
- 23443 1
- 23585 1
- 23716 1
- 23799 1
- 23867 1
- 23981 1
- 24147 1
- 24327 1
- 24388 1
- 24613 1
- 24719 1
- 24910 1
- 25060 1
- 25250 1
- 25386 1
- 25433 1
- 25546 1
- 25694 1
- 25837 1
- 25960 1
- 26058 1
- 26143 1
- 26208 1
- 26356 1
- 26453 1
- 26549 1
- 26662 1
- 26747 1
- 26814 1
- 26855 1
- 26969 1
- 27090 1
- 27207 1
- 27286 1
- 27389 1
- 27446 1
- 27483 1
- 27564 1
- 27650 1
- 27765 1
- 27898 1
- 28001 1
- 28076 1
- 28136 1
- 28257 1
- 28358 1
- 28482 1
- 28639 1
- 28822 1
- 28907 1
- 28955 1
- 29150 1
- 29341 1
- 29543 1
- 29725 1
- 29886 1
- 29974 1
- 30082 1
- 30312 1
- 30460 1
- 30602 1
- 30768 1
- 31002 1
- 31125 1
- 31225 1
- 31389 1
- 31540 1
- 31711 1
- 31882 1
- 32051 1
- 32118 1
- 32197 1
- 32445 1
- 32586 1
- 32743 1
- 32945 1
- 33099 1
- 33168 1
- 33225 1
- 33388 1
- 33497 1
- 33630 1
- 33763 1
- 33895 1
- 33992 1
- 34061 1
- 34159 1
- 34248 1
- 34347 1
- 34475 1
- 34570 1
- 34640 1
- 34674 1
- 34759 1
- 34822 1
- 34876 1
- 34967 1
- 35012 1
- 35039 1
- 35065 1
- 35132 1
- 35172 1
- 35216 1
- 35282 1
- 35322 1
- 35342 1
- 35355 1
- 35391 1
- 35417 1
- 35451 1
- 35564 1
- 35578 1
- 35607 1
- 35627 1
- 35641 1
- 35660 1
- 35676 1
- 35694 1
- 35700 1
- 35702 1
- 35710 1
- 35714 1
- 35722 1
- 35728 1
- 35734 1
- 35742 1
- 35763 1
- 35767 1
- 35773 1
- 35787 1
- 35792 1
- 35797 1
- 35801 1
- 35809 1
- 35823 1
- 35826 1
- 35832 1
- 35839 1
- 35841 1
- 35849 1
- 35853 1
- 35855 1
- 35865 1
- 35867 1
- 35879 1
- 35885 1
- 35886 1
- 35890 1
- 35897 1
- 35906 1
- 35912 1
- 35915 1
- 35919 1
- 35923 1
- 35927 1
- 35934 1
- 35938 1
- 35943 1
- 35947 1
- 35956 1
- 35965 1
- 35978 1
- 35993 1
- 36002 1
- 36012 1
- 36021 1
- 36056 1
- 36080 1
- 36099 1
- 36123 1
- 36152 1
- 36171 1
- 36188 1
- 36224 1
- 36245 1
- 36290 1
- 36413 1
- 36459 1
- 36535 1
- 36609 1
- 36657 1
- 36725 1
- 36890 1
- 36961 1
- 37040 1
- 37126 1
- 37211 1
- 37290 1
- 37359 1
- 37422 1
- 37516 1
- 37604 1
- 37739 1
- 37807 1
- 37877 1
- 37963 1
- 38017 1
- 38122 1
- 38255 1
- 38323 1
- 38418 1
- 38511 1
- 38584 1
- 38639 1
- 38707 1
- 38829 1
- 38982 1
- 39093 1
- 39208 1
- 39330 1
- 39402 1
- 39457 1
- 39564 1
- 39700 1
- 39923 1
- 40078 1
- 40149 1
- 40223 1
- 40326 1
- 40452 1
- 40580 1
- 40741 1
- 40812 1
- 40926 1
- 40972 1
- 41093 1
- 41208 1
- 41353 1
- 41499 1
- 41640 1
- 41716 1
- 41791 1
- 41922 1
- 42017 1
- 42137 1
- 42209 1
- 42266 1
- 42417 1
- 42552 1
- 42640 1
- 42700 1
- 42818 1
- 42961 1
- 43050 1
- 43098 1
- 43156 1
- 43262 1
- 43318 1
- 43443 1
- 43507 1
- 43591 1
- 43670 1
- 43715 1
- 43804 1
- 43861 1
- 43966 1
- 44049 1
- 44138 1
- 44191 1
- 44225 1
- 44320 1
- 44377 1
- 44490 1
- 44571 1
- 44645 1
- 44856 1
- 44897 1
- 44996 1
- 45082 1
- 45199 1
- 45260 1
- 45319 1
- 45441 1
- 45510 1
- 45639 1
- 45756 1
- 46286 1
- 46375 1
- 46424 1
- 46580 1
- 46724 1
- 46886 1
- 47038 1
- 47162 1
- 47261 1
- 47373 1
- 47586 1
- 47741 1
- 47879 1
- 48053 1
- 48147 1
- 48274 1
- 48397 1
- 48548 1
- 48668 1
- 48992 1
- 49326 1
- 49658 1
- 49958 1
- 50144 1
- 50386 1
- 50581 1
- 50768 1
- 51178 1
- 51563 1
- 51917 1
- 52131 1
- 52376 1
- 52581 1
- 52929 1
- 53179 1
- 53535 1
- 53806 1
- 54047 1
- 54387 1
- 54646 1
- 54959 1
- 55301 1
- 55726 1
- 56143 1
- 56419 1
- 57047 1
- 57463 1
- 57829 1
- 58875 1
- 59540 1
- 60175 1
- 61091 1
- 61669 1
- 62242 1
- 63189 1
- 64193 1
- 65337 1
- 66238 1
- 67302 1
- 68678 1
- 69717 1
- 70436 1
- 71205 1
- 71600 1
- 72729 1
- 73080 1
- 73365 1
- 73679 1
- 73982 1
- 74410 1
- 74876 1
- 75154 1
- 75269 1
- 75544 1
- 75826 1
- 76210 1
- 76508 1
- 76664 1
- 76847 1
- 76968 1
- 77061 1
- 77204 1
- 77337 1
- 77485 1
- 77667 1
- 77740 1
- 77774 1
- 77879 1
- 77956 1
- 77993 1
- 78062 1
- 78160 1
- 78193 1
- 78235 1
- 78275 1
- 78336 1
- 78389 1
- 78445 1
- 78545 1
- 78617 1
- 78654 1
- 78693 1
- 78734 1
- 78765 1
- 78778 1
- 78792 1
- 78813 1
- 78841 1
- 78875 1
- 78888 1
- 78907 1
- 78918 1
- 78927 1
- 78952 1
- 78974 1
- 78999 1
- 79014 1
- 79039 1
- 79045 1
- 79052 1
- 79066 1
- 79078 1
- 79092 1
- 79114 1
- 79129 1
- 79153 1
- 79166 1
- 79169 1
- 79182 1
- 79224 1
- 79254 1
- 79276 1
- 79291 1
- 79299 1
- 79314 1
- 79332 1
- 79364 1
- 79393 1
- 79432 1
- 79456 1
- 79486 1
- 79524 1
- 79555 1
- 79596 1
- 79623 1
- 79634 1
- 79660 1
- 79705 1
- 79764 1
- 79825 1
- 79882 1
- 79914 1
- 79944 1
- 79966 1
- 80011 1
- 80075 1
- 80129 1
- 80187 1
- 80234 1
- 80285 1
- 80342 1
- 80408 1
- 80502 1
- 80608 1
- 80718 1
- 80783 1
- 80835 1
- 80898 1
state 1
- Pennsylvania 793
fips 1
- 42095 · 793 ✖
county 1
- Northampton 793
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
4251 | 4251 | 2020-03-18 | Northampton | Pennsylvania | 42095 | 1 | 1 |
4992 | 4992 | 2020-03-19 | Northampton | Pennsylvania | 42095 | 5 | 1 |
5864 | 5864 | 2020-03-20 | Northampton | Pennsylvania | 42095 | 10 | 1 |
6868 | 6868 | 2020-03-21 | Northampton | Pennsylvania | 42095 | 17 | 1 |
7987 | 7987 | 2020-03-22 | Northampton | Pennsylvania | 42095 | 21 | 1 |
9198 | 9198 | 2020-03-23 | Northampton | Pennsylvania | 42095 | 23 | 1 |
10522 | 10522 | 2020-03-24 | Northampton | Pennsylvania | 42095 | 33 | 2 |
11987 | 11987 | 2020-03-25 | Northampton | Pennsylvania | 42095 | 44 | 3 |
13608 | 13608 | 2020-03-26 | Northampton | Pennsylvania | 42095 | 56 | 3 |
15354 | 15354 | 2020-03-27 | Northampton | Pennsylvania | 42095 | 79 | 3 |
17205 | 17205 | 2020-03-28 | Northampton | Pennsylvania | 42095 | 94 | 4 |
19144 | 19144 | 2020-03-29 | Northampton | Pennsylvania | 42095 | 126 | 4 |
21194 | 21194 | 2020-03-30 | Northampton | Pennsylvania | 42095 | 184 | 5 |
23330 | 23330 | 2020-03-31 | Northampton | Pennsylvania | 42095 | 245 | 5 |
25528 | 25528 | 2020-04-01 | Northampton | Pennsylvania | 42095 | 312 | 5 |
27801 | 27801 | 2020-04-02 | Northampton | Pennsylvania | 42095 | 378 | 9 |
30135 | 30135 | 2020-04-03 | Northampton | Pennsylvania | 42095 | 466 | 10 |
32525 | 32525 | 2020-04-04 | Northampton | Pennsylvania | 42095 | 588 | 11 |
34961 | 34961 | 2020-04-05 | Northampton | Pennsylvania | 42095 | 636 | 11 |
37436 | 37436 | 2020-04-06 | Northampton | Pennsylvania | 42095 | 716 | 12 |
39959 | 39959 | 2020-04-07 | Northampton | Pennsylvania | 42095 | 774 | 14 |
42519 | 42519 | 2020-04-08 | Northampton | Pennsylvania | 42095 | 857 | 17 |
45105 | 45105 | 2020-04-09 | Northampton | Pennsylvania | 42095 | 949 | 20 |
47722 | 47722 | 2020-04-10 | Northampton | Pennsylvania | 42095 | 994 | 21 |
50379 | 50379 | 2020-04-11 | Northampton | Pennsylvania | 42095 | 1039 | 23 |
53052 | 53052 | 2020-04-12 | Northampton | Pennsylvania | 42095 | 1082 | 23 |
55737 | 55737 | 2020-04-13 | Northampton | Pennsylvania | 42095 | 1130 | 23 |
58440 | 58440 | 2020-04-14 | Northampton | Pennsylvania | 42095 | 1176 | 25 |
61155 | 61155 | 2020-04-15 | Northampton | Pennsylvania | 42095 | 1251 | 25 |
63881 | 63881 | 2020-04-16 | Northampton | Pennsylvania | 42095 | 1296 | 25 |
66627 | 66627 | 2020-04-17 | Northampton | Pennsylvania | 42095 | 1335 | 27 |
69385 | 69385 | 2020-04-18 | Northampton | Pennsylvania | 42095 | 1396 | 29 |
72152 | 72152 | 2020-04-19 | Northampton | Pennsylvania | 42095 | 1441 | 36 |
74927 | 74927 | 2020-04-20 | Northampton | Pennsylvania | 42095 | 1469 | 36 |
77709 | 77709 | 2020-04-21 | Northampton | Pennsylvania | 42095 | 1544 | 43 |
80499 | 80499 | 2020-04-22 | Northampton | Pennsylvania | 42095 | 1591 | 44 |
83298 | 83298 | 2020-04-23 | Northampton | Pennsylvania | 42095 | 1656 | 45 |
86102 | 86102 | 2020-04-24 | Northampton | Pennsylvania | 42095 | 1716 | 46 |
88916 | 88916 | 2020-04-25 | Northampton | Pennsylvania | 42095 | 1780 | 49 |
91732 | 91732 | 2020-04-26 | Northampton | Pennsylvania | 42095 | 1813 | 49 |
94559 | 94559 | 2020-04-27 | Northampton | Pennsylvania | 42095 | 1834 | 49 |
97398 | 97398 | 2020-04-28 | Northampton | Pennsylvania | 42095 | 1970 | 55 |
100247 | 100247 | 2020-04-29 | Northampton | Pennsylvania | 42095 | 2008 | 85 |
103100 | 103100 | 2020-04-30 | Northampton | Pennsylvania | 42095 | 2050 | 94 |
105963 | 105963 | 2020-05-01 | Northampton | Pennsylvania | 42095 | 2103 | 94 |
108830 | 108830 | 2020-05-02 | Northampton | Pennsylvania | 42095 | 2182 | 94 |
111704 | 111704 | 2020-05-03 | Northampton | Pennsylvania | 42095 | 2214 | 94 |
114586 | 114586 | 2020-05-04 | Northampton | Pennsylvania | 42095 | 2240 | 94 |
117467 | 117467 | 2020-05-05 | Northampton | Pennsylvania | 42095 | 2279 | 117 |
120429 | 120429 | 2020-05-06 | Northampton | Pennsylvania | 42095 | 2313 | 122 |
123406 | 123406 | 2020-05-07 | Northampton | Pennsylvania | 42095 | 2355 | 152 |
126389 | 126389 | 2020-05-08 | Northampton | Pennsylvania | 42095 | 2390 | 153 |
129378 | 129378 | 2020-05-09 | Northampton | Pennsylvania | 42095 | 2429 | 158 |
132367 | 132367 | 2020-05-10 | Northampton | Pennsylvania | 42095 | 2453 | 158 |
135358 | 135358 | 2020-05-11 | Northampton | Pennsylvania | 42095 | 2465 | 160 |
138348 | 138348 | 2020-05-12 | Northampton | Pennsylvania | 42095 | 2499 | 161 |
141344 | 141344 | 2020-05-13 | Northampton | Pennsylvania | 42095 | 2518 | 162 |
144340 | 144340 | 2020-05-14 | Northampton | Pennsylvania | 42095 | 2566 | 182 |
147341 | 147341 | 2020-05-15 | Northampton | Pennsylvania | 42095 | 2600 | 196 |
150348 | 150348 | 2020-05-16 | Northampton | Pennsylvania | 42095 | 2659 | 196 |
153359 | 153359 | 2020-05-17 | Northampton | Pennsylvania | 42095 | 2703 | 199 |
156376 | 156376 | 2020-05-18 | Northampton | Pennsylvania | 42095 | 2727 | 171 |
159397 | 159397 | 2020-05-19 | Northampton | Pennsylvania | 42095 | 2758 | 176 |
162424 | 162424 | 2020-05-20 | Northampton | Pennsylvania | 42095 | 2779 | 182 |
165453 | 165453 | 2020-05-21 | Northampton | Pennsylvania | 42095 | 2814 | 186 |
168489 | 168489 | 2020-05-22 | Northampton | Pennsylvania | 42095 | 2842 | 192 |
171528 | 171528 | 2020-05-23 | Northampton | Pennsylvania | 42095 | 2866 | 197 |
174570 | 174570 | 2020-05-24 | Northampton | Pennsylvania | 42095 | 2911 | 198 |
177614 | 177614 | 2020-05-25 | Northampton | Pennsylvania | 42095 | 2920 | 199 |
180657 | 180657 | 2020-05-26 | Northampton | Pennsylvania | 42095 | 2933 | 199 |
183707 | 183707 | 2020-05-27 | Northampton | Pennsylvania | 42095 | 2958 | 203 |
186764 | 186764 | 2020-05-28 | Northampton | Pennsylvania | 42095 | 3022 | 206 |
189825 | 189825 | 2020-05-29 | Northampton | Pennsylvania | 42095 | 3045 | 207 |
192890 | 192890 | 2020-05-30 | Northampton | Pennsylvania | 42095 | 3062 | 210 |
195959 | 195959 | 2020-05-31 | Northampton | Pennsylvania | 42095 | 3083 | 210 |
199032 | 199032 | 2020-06-01 | Northampton | Pennsylvania | 42095 | 3082 | 210 |
202107 | 202107 | 2020-06-02 | Northampton | Pennsylvania | 42095 | 3108 | 213 |
205184 | 205184 | 2020-06-03 | Northampton | Pennsylvania | 42095 | 3120 | 220 |
208265 | 208265 | 2020-06-04 | Northampton | Pennsylvania | 42095 | 3124 | 225 |
211347 | 211347 | 2020-06-05 | Northampton | Pennsylvania | 42095 | 3136 | 229 |
214433 | 214433 | 2020-06-06 | Northampton | Pennsylvania | 42095 | 3144 | 231 |
217523 | 217523 | 2020-06-07 | Northampton | Pennsylvania | 42095 | 3151 | 232 |
220615 | 220615 | 2020-06-08 | Northampton | Pennsylvania | 42095 | 3168 | 232 |
223710 | 223710 | 2020-06-09 | Northampton | Pennsylvania | 42095 | 3175 | 236 |
226810 | 226810 | 2020-06-10 | Northampton | Pennsylvania | 42095 | 3193 | 238 |
229914 | 229914 | 2020-06-11 | Northampton | Pennsylvania | 42095 | 3202 | 238 |
233019 | 233019 | 2020-06-12 | Northampton | Pennsylvania | 42095 | 3217 | 238 |
236124 | 236124 | 2020-06-13 | Northampton | Pennsylvania | 42095 | 3232 | 241 |
239232 | 239232 | 2020-06-14 | Northampton | Pennsylvania | 42095 | 3240 | 241 |
242341 | 242341 | 2020-06-15 | Northampton | Pennsylvania | 42095 | 3246 | 243 |
245453 | 245453 | 2020-06-16 | Northampton | Pennsylvania | 42095 | 3250 | 244 |
248566 | 248566 | 2020-06-17 | Northampton | Pennsylvania | 42095 | 3255 | 247 |
251681 | 251681 | 2020-06-18 | Northampton | Pennsylvania | 42095 | 3270 | 249 |
254796 | 254796 | 2020-06-19 | Northampton | Pennsylvania | 42095 | 3284 | 250 |
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);