Filter Tips
PriorityTypeDescription
1| or  OR Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2 &&  or  AND Logical "and". Filter the column for content that matches text from either side of the operator.
3/\d/Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4< <= >= >Find alphabetical or numerical values less than or greater than or equal to the filtered query
5! or !=Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6" or =To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7 -  or  to Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8?Wildcard for a single, non-space character.
8*Wildcard for zero or more non-space characters.
9~Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10textAny text entered in the filter will match text found within the column
Size City State/Province Population Start Bonus Hockey Lovers Total Season Ticket Bonus
1 New York NY 19,216,182 19 5 5 29
2 Los Angeles CA 13,214,799 13 5 -5 13
3 Chicago IL 9,458,539 9 5 5 19
4 Dallas TX 7,573,136 8 5 -5 8
5 Houston TX 7,066,141 7 5 -5 7
6 Toronto ON 6,471,850 6 5 10 21
7 Washington DC 6,280,487 6 5 5 16
8 Miami FL 6,166,488 6 5 -5 6
9 Philadelphia PA 6,102,434 6 5 5 16
10 Atlanta GA 6,020,364 6 -10 -4
11 Phoenix AZ 4,948,203 5 5 -10 0
12 Boston MA 4,873,019 5 5 5 15
13 San Francisco CA 4,731,803 5 5 -5 5
14 Riverside CA 4,650,631 5 -5 0
15 Detroit MI 4,319,629 4 5 5 14
16 Montreal QC 4,318,505 4 5 10 19
17 Seattle WA 3,979,845 4 5 9
18 Minneapolis MN 3,640,043 4 5 10 19
19 San Diego CA 3,338,330 3 -5 -2
20 Tampa FL 3,194,831 3 -5 -2
21 Denver CO 2,967,239 3 5 5 13
22 St. Louis MO 2,803,228 3 5 0 8
23 Baltimore MD 2,800,053 3 5 8
24 Vancouver BC 2,691,351 3 10 13
25 Charlotte NC 2,636,883 3 0 3
26 Orlando FL 2,608,147 3 -5 -2
27 San Antonio TX 2,550,960 3 5 -5 3
28 Portland OR 2,492,412 2 5 7
29 Sacramento CA 2,363,730 2 -5 -3
30 Pittsburgh PA 2,317,600 2 5 5 12
31 Las Vegas NV 2,266,715 2 -10 -8
32 Austin TX 2,227,083 2 -5 -3
33 Cincinnati OH 2,221,208 2 5 7
34 Kansas City MO 2,157,990 2 0 2
35 Columbus OH 2,122,271 2 5 7
36 Indianapolis IN 2,074,537 2 5 7
37 Cleveland OH 2,048,449 2 5 7
38 San Jose CA 1,990,660 2 -5 -3
39 Nashville TN 1,934,317 2 -5 -3
40 Virginia Beach VA 1,768,901 2 0 2
41 Providence RI 1,624,578 2 5 7
42 Milwaukee WI 1,575,179 2 5 7
43 Jacksonville FL 1,559,514 2 -5 -3
44 Calgary AB 1,514,723 2 10 12
45 Edmonton AB 1,447,143 1 10 11
46 Ottawa ON 1,441,118 1 10 11
47 Oklahoma City OK 1,408,950 1 -5 -4
48 Raleigh NC 1,390,785 1 0 1
49 Memphis TN 1,346,045 1 -5 -4
50 Richmond VA 1,291,900 1 0 1
51 New Orleans LA 1,270,530 1 -10 -9
52 Louisville/Jefferson County KY 1,265,108 1 0 1
53 Salt Lake City UT 1,232,696 1 -5 -4
54 Hartford CT 1,204,877 1 5 6
55 Buffalo NY 1,127,983 1 5 6
56 Birmingham AL 1,090,435 1 -10 -9
57 Grand Rapids MI 1,077,370 1 5 6
58 Rochester NY 1,069,644 1 5 6
59 Tucson AZ 1,047,279 1 -10 -9
60 Fresno CA 999,101 1 -5 -4
61 Tulsa OK 998,626 1 -5 -4
62 Urban Honolulu HI 974,563 1 -100 -99
63 Omaha NE 949,442 1 0 1
64 Worcester MA 947,404 1 5 6
65 Bridgeport CT 943,332 1 5 6
66 Greenville SC 920,477 1 -5 -4
67 Albuquerque NM 918,018 1 -10 -9
68 Bakersfield CA 900,202 1 -5 -4
69 Albany NY 880,381 1 5 6
70 Knoxville TN 869,046 1 -5 -4
71 McAllen TX 868,707 1 -5 -4
72 Baton Rouge LA 854,884 1 -10 -9
73 New Haven CT 854,757 1 5 6
74 Oxnard CA 846,006 1 -5 -4
75 Winnipeg MB 844,566 1 10 11
76 El Paso TX 844,124 1 -5 -4
77 Allentown PA 844,052 1 5 6
78 Columbia SC 838,433 1 -5 -4
79 North Port FL 836,995 1 -5 -4
80 Quebec QC 824,411 1 10 11
81 Dayton OH 807,611 1 5 6
82 Charleston SC 802,122 1 -5 -4
83 Hamilton ON 794,716 1 10 11
84 Greensboro NC 771,851 1 0 1
85 Cape Coral FL 770,577 1 -5 -4
86 Stockton CA 762,148 1 -5 -4
87 Boise City ID 749,202 1 0 1
88 Colorado Springs CO 745,791 1 5 6
89 Little Rock AR 742,384 1 -5 -4
90 Lakeland FL 724,777 1 -5 -4
91 Akron OH 703,479 1 5 6
92 Des Moines IA 699,292 1 5 6
93 Springfield MA 697,382 1 5 6
94 Ogden UT 683,864 1 -5 -4
95 Poughkeepsie NY 679,158 1 5 6
96 Winston NC 676,008 1 0 1
97 Deltona FL 668,365 1 -5 -4
98 Madison WI 664,865 1 5 6
99 Syracuse NY 648,593 1 5 6
100 Provo UT 648,252 1 -5 -4
101 Durham NC 644,367 1 0 1
102 Toledo OH 641,816 1 5 6
103 Wichita KS 640,218 1 0 1
104 Augusta GA 608,980 1 -10 -9
105 Palm Bay FL 601,942 1 -5 -4
106 Jackson MS 594,806 1 -10 -9
107 Kitchener (Tri-Cities) ON 584,259 1 10 11
108 Harrisburg PA 577,941 1 5 6
109 Spokane WA 568,521 1 5 6
110 Chattanooga TN 565,194 1 -5 -4
111 Scranton–Wilkes PA 553,885 1 5 6
112 Modesto CA 550,660 1 -5 -4
113 Lansing MI 550,391 1 5 6
114 Lancaster PA 545,724 1 5 6
115 London ON 545,441 1 10 11
116 Portland ME 538,500 1 5 6
117 Youngstown OH 536,081 1 5 6
118 Fayetteville AR 534,904 1 -5 -4
119 Fayetteville NC 526,719 1 0 1
120 Lexington KY 517,056 1 0 1
121 Pensacola FL 502,629 1 -5 -4
122 Myrtle Beach SC 496,901 1 -5 -4
123 Santa Rosa CA 494,336 1 -5 -4
124 Port St. Lucie FL 489,297 1 -5 -4
125 Lafayette LA 489,207 1 -10 -9
126 Reno NV 475,642 1 -10 -9
127 Huntsville AL 471,824 1 -10 -9
128 Springfield MO 470,300 1 0 1
129 Visalia CA 466,195 1 -5 -4
130 Asheville NC 462,680 1 0 1
131 Killeen TX 460,303 1 -5 -4
132 York PA 449,058 1 5 6
133 Vallejo CA 447,643 1 -5 -4
134 Santa Maria CA 446,499 1 -5 -4
135 Halifax NS 440,348 1 10 11
136 St. Catharines - Niagara ON 434,927 1 10 11
137 Salinas CA 434,061 1 -5 -4
138 Salem OR 433,903 1 5 6
139 Mobile AL 429,536 1 -10 -9
140 Corpus Christi TX 429,024 1 -5 -4
141 Brownsville TX 423,163 1 -5 -4
142 Reading PA 421,164 1 5 6
143 Gulfport MS 417,665 1 -10 -9
144 Manchester NH 417,025 1 5 6
145 Salisbury MD 415,726 1 5 6
146 Oshawa ON 413,936 1 10 11
147 Fort Wayne IN 413,263 1 5 6
148 Flint MI 405,813 1 5 6
149 Victoria BC 402,271 1 10 11
150 Peoria IL 400,561 1 5 6
151 Canton OH 397,520 1 5 6
152 Anchorage AK 396,317 1 -5 -4
153 Shreveport LA 394,706 1 -10 -9
154 Savannah GA 393,353 1 -10 -9
155 Beaumont TX 392,563 1 -5 -4
156 Tallahassee FL 387,227 1 -5 -4
157 Naples FL 384,902 1 -5 -4
158 Eugene OR 382,067 1 5 6
159 Davenport IA 379,172 1 5 6
160 Montgomery AL 373,290 1 -10 -9
161 Hickory NC 369,711 1 0 1
162 Ann Arbor MI 367,601 1 5 6
163 Trenton NJ 367,430 1 5 6
164 Ocala FL 365,579 1 -5 -4
165 Fort Collins CO 356,899 1 5 6
166 Huntington WV 355,873 1 0 1
167 Windsor ON 354,917 1 10 11
168 Lincoln NE 336,374 1 0 1
169 Rockford IL 336,116 1 5 6
170 Saskatoon SK 330,674 1 10 11
171 Gainesville FL 329,128 1 -5 -4
172 Boulder CO 326,196 1 5 6
173 Greeley CO 324,492 1 5 6
174 South Bend IN 323,613 1 5 6
175 Green Bay WI 322,906 1 5 6
176 Lubbock TX 322,257 1 -5 -4
177 Columbus GA 321,048 1 -10 -9
178 Spartanburg SC 319,785 1 -5 -4
179 Evansville IN 315,086 1 5 6
180 Roanoke VA 313,222 1 0 1
181 Clarksville TN 307,820 1 -5 -4
182 Kingsport TN 307,202 1 -5 -4
183 Kennewick WA 299,612 1 5 6
184 Wilmington NC 297,533 1 0 1
185 Olympia WA 290,536 1 5 6
186 Utica NY 289,990 1 5 6
187 Duluth MN 288,732 1 10 11
188 Hagerstown MD 288,104 1 5 6
189 Longview TX 286,657 1 -5 -4
190 Crestview FL 284,809 1 -5 -4
191 San Luis Obispo CA 283,111 1 -5 -4
192 Merced CA 277,680 1 -5 -4
193 Laredo TX 276,652 1 -5 -4
194 Waco TX 273,920 1 -5 -4
195 Santa Cruz CA 273,213 1 -5 -4
196 Cedar Rapids IA 273,032 1 5 6
197 Bremerton WA 271,473 1 5 6
198 Erie PA 269,728 1 5 6
199 Sioux Falls SD 268,232 1 5 6
200 Norwich CT 265,206 1 5 6
201 Kalamazoo MI 265,066 1 5 6
202 Amarillo TX 265,053 1 -5 -4
203 College Station TX 264,728 1 -5 -4
204 Atlantic City NJ 263,670 1 5 6
205 Lynchburg VA 263,566 1 0 1
206 Regina SK 261,684 1 10 11
207 Charleston WV 257,074 1 0 1
208 Tuscaloosa AL 252,047 1 -10 -9
209 Yakima WA 250,873 1 5 6
210 Fort Smith AR 250,368 1 -5 -4
211 Fargo ND 246,145 1 5 6