united_states

Custom SQL query returning 101 rows (show)

Query parameters

rowidfipsacp_typecountysttotal_votesleadst_nametrumpclintonother
101 27139 1 Scott County MN 74389 Donald Trump Minnesota 39948 28502 5939
102 27141 1 Sherburne County MN 47934 Donald Trump Minnesota 31053 13293 3588
103 27163 1 Washington County MN 142842 Hillary Clinton Minnesota 64428 67086 11328
104 27171 1 Wright County MN 69152 Donald Trump Minnesota 43274 20334 5544
105 28033 1 DeSoto County MS 65695 Donald Trump Mississippi 43089 20591 2015
106 28045 1 Hancock County MS 17637 Donald Trump Mississippi 13811 3344 482
107 28073 1 Lamar County MS 24592 Donald Trump Mississippi 18751 5190 651
108 28121 1 Rankin County MS 62768 Donald Trump Mississippi 47178 14110 1480
109 29027 1 Callaway County MO 19138 Donald Trump Missouri 13057 4989 1092
110 29037 1 Cass County MO 50846 Donald Trump Missouri 33098 14846 2902
111 29043 1 Christian County MO 41403 Donald Trump Missouri 30946 8508 1949
112 29047 1 Clay County MO 109536 Donald Trump Missouri 57476 45304 6756
113 29049 1 Clinton County MO 10208 Donald Trump Missouri 7067 2572 569
114 29099 1 Jefferson County MO 106056 Donald Trump Missouri 69036 31568 5452
115 29113 1 Lincoln County MO 24920 Donald Trump Missouri 18159 5575 1186
116 29165 1 Platte County MO 48902 Donald Trump Missouri 25933 20057 2912
117 29183 1 St. Charles County MO 200737 Donald Trump Missouri 121650 68626 10461
118 29219 1 Warren County MO 15768 Donald Trump Missouri 11111 3915 742
119 29225 1 Webster County MO 16707 Donald Trump Missouri 12840 3177 690
120 30043 1 Jefferson County MT 6668 Donald Trump Montana 4177 1998 493
121 32001 1 Churchill County NV 10938 Donald Trump Nevada 7830 2210 898
122 32005 1 Douglas County NV 27885 Donald Trump Nevada 17415 8454 2016
123 32019 1 Lyon County NV 23762 Donald Trump Nevada 16005 6146 1611
124 32029 1 Storey County NV 2558 Donald Trump Nevada 1616 752 190
125 33011 1 Hillsborough County NH 210746 Donald Trump New Hampshire 100013 99589 11144
126 33013 1 Merrimack County NH 82064 Hillary Clinton New Hampshire 37674 40198 4192
127 33015 1 Rockingham County NH 179168 Donald Trump New Hampshire 90447 79994 8727
128 34005 1 Burlington County NJ 218943 Hillary Clinton New Jersey 89272 121725 7946
129 34015 1 Gloucester County NJ 139542 Donald Trump New Jersey 67544 66870 5128
130 34019 1 Hunterdon County NJ 70836 Donald Trump New Jersey 38712 28898 3226
131 34033 1 Salem County NJ 29494 Donald Trump New Jersey 16381 11904 1209
132 34037 1 Sussex County NJ 74126 Donald Trump New Jersey 46658 24212 3256
133 34041 1 Warren County NJ 49236 Donald Trump New Jersey 29858 17281 2097
134 35043 1 Sandoval County NM 61690 Hillary Clinton New Mexico 25905 27707 8078
135 36091 1 Saratoga County NY 112429 Donald Trump New York 54575 50913 6941
136 37025 1 Cabarrus County NC 92126 Donald Trump North Carolina 53819 35521 2786
137 37029 1 Camden County NC 4969 Donald Trump North Carolina 3546 1274 149
138 37037 1 Chatham County NC 39300 Hillary Clinton North Carolina 17105 21065 1130
139 37053 1 Currituck County NC 12558 Donald Trump North Carolina 9163 2913 482
140 37097 1 Iredell County NC 81673 Donald Trump North Carolina 54754 24734 2185
141 37101 1 Johnston County NC 85081 Donald Trump North Carolina 54372 28362 2347
142 37109 1 Lincoln County NC 39674 Donald Trump North Carolina 28806 9897 971
143 37179 1 Union County NC 104371 Donald Trump North Carolina 66707 34337 3327
144 39041 1 Delaware County OH 103557 Donald Trump Ohio 57568 40872 5117
145 39159 1 Union County OH 27261 Donald Trump Ohio 18096 7718 1447
146 39165 1 Warren County OH 116764 Donald Trump Ohio 77643 33730 5391
147 40017 1 Canadian County OK 55278 Donald Trump Oklahoma 39986 11674 3618
148 40083 1 Logan County OK 18979 Donald Trump Oklahoma 13633 4248 1098
149 40131 1 Rogers County OK 40862 Donald Trump Oklahoma 30913 7902 2047
150 40145 1 Wagoner County OK 31300 Donald Trump Oklahoma 23005 6723 1572
151 41005 1 Clackamas County OR 205541 Hillary Clinton Oregon 88392 102095 15054
152 41071 1 Yamhill County OR 46641 Donald Trump Oregon 23250 19301 4090
153 42017 1 Bucks County PA 344297 Hillary Clinton Pennsylvania 164361 167060 12876
154 42029 1 Chester County PA 268800 Hillary Clinton Pennsylvania 116114 141682 11004
155 42089 1 Monroe County PA 69752 Hillary Clinton Pennsylvania 33386 33918 2448
156 42103 1 Pike County PA 26101 Donald Trump Pennsylvania 16056 9256 789
157 45063 1 Lexington County SC 122093 Donald Trump South Carolina 80026 35230 6837
158 45091 1 York County SC 114357 Donald Trump South Carolina 66754 41593 6010
159 46033 1 Custer County SD 4721 Donald Trump South Dakota 3293 1121 307
160 46083 1 Lincoln County SD 25231 Donald Trump South Dakota 15499 8076 1656
161 47009 1 Blount County TN 51927 Donald Trump Tennessee 37443 12100 2384
162 47021 1 Cheatham County TN 15826 Donald Trump Tennessee 11297 3878 651
163 47043 1 Dickson County TN 18646 Donald Trump Tennessee 13233 4722 691
164 47047 1 Fayette County TN 19324 Donald Trump Tennessee 13055 5874 395
165 47147 1 Robertson County TN 27062 Donald Trump Tennessee 19410 6637 1015
166 47149 1 Rutherford County TN 106696 Donald Trump Tennessee 64515 36706 5475
167 47165 1 Sumner County TN 71114 Donald Trump Tennessee 50129 18161 2824
168 47167 1 Tipton County TN 23396 Donald Trump Tennessee 16910 5785 701
169 47187 1 Williamson County TN 104784 Donald Trump Tennessee 68212 31013 5559
170 47189 1 Wilson County TN 56424 Donald Trump Tennessee 39406 14385 2633
171 48021 1 Bastrop County TX 28280 Donald Trump Texas 16328 10569 1383
172 48039 1 Brazoria County TX 120565 Donald Trump Texas 72791 43200 4574
173 48071 1 Chambers County TX 16731 Donald Trump Texas 13339 2948 444
174 48085 1 Collin County TX 358032 Donald Trump Texas 201014 140624 16394
175 48091 1 Comal County TX 61785 Donald Trump Texas 45136 14238 2411
176 48121 1 Denton County TX 295736 Donald Trump Texas 170603 110890 14243
177 48139 1 Ellis County TX 63266 Donald Trump Texas 44941 16253 2072
178 48157 1 Fort Bend County TX 260667 Hillary Clinton Texas 117291 134686 8690
179 48167 1 Galveston County TX 122349 Donald Trump Texas 73757 43658 4934
180 48187 1 Guadalupe County TX 57457 Donald Trump Texas 36632 18391 2434
181 48209 1 Hays County TX 71741 Donald Trump Texas 33826 33224 4691
182 48251 1 Johnson County TX 57299 Donald Trump Texas 44382 10988 1929
183 48257 1 Kaufman County TX 41045 Donald Trump Texas 29587 10278 1180
184 48259 1 Kendall County TX 19985 Donald Trump Texas 15700 3643 642
185 48339 1 Montgomery County TX 203309 Donald Trump Texas 150314 45835 7160
186 48367 1 Parker County TX 56471 Donald Trump Texas 46473 8344 1654
187 48397 1 Rockwall County TX 39618 Donald Trump Texas 28451 9655 1512
188 48491 1 Williamson County TX 200919 Donald Trump Texas 104175 84468 12276
189 48493 1 Wilson County TX 19262 Donald Trump Texas 13998 4790 474
190 48497 1 Wise County TX 24678 Donald Trump Texas 20670 3412 596
191 51007 1 Amelia County VA 7017 Donald Trump Virginia 4708 2128 181
192 51033 1 Caroline County VA 14200 Donald Trump Virginia 7147 6432 621
193 51041 1 Chesterfield County VA 175360 Donald Trump Virginia 85045 81074 9241
194 51043 1 Clarke County VA 8139 Donald Trump Virginia 4661 3051 427
195 51047 1 Culpeper County VA 22110 Donald Trump Virginia 13349 7759 1002
196 51061 1 Fauquier County VA 37153 Donald Trump Virginia 22127 12971 2055
197 51065 1 Fluvanna County VA 13508 Donald Trump Virginia 7025 5760 723
198 51069 1 Frederick County VA 40163 Donald Trump Virginia 26083 11932 2148
199 51075 1 Goochland County VA 13946 Donald Trump Virginia 8384 4889 673
200 51079 1 Greene County VA 9508 Donald Trump Virginia 5945 2924 639
201 51085 1 Hanover County VA 62377 Donald Trump Virginia 39630 19382 3365