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
Abbr State/Province Country Hockey Lovers Population
CA California USA -5 39,512,223
TX Texas USA -5 28,995,881
FL Florida USA -5 21,477,737
NY New York USA 5 19,453,561
ON Ontario CA 10 14,711,827
PA Pennsylvania USA 5 12,801,989
IL Illinois USA 5 12,671,821
OH Ohio USA 5 11,689,100
GA Georgia USA -10 10,617,423
NC North Carolina USA 0 10,488,084
MI Michigan USA 5 9,986,857
NJ New Jersey USA 5 8,882,190
QC Quebec CA 10 8,537,674
VA Virginia USA 0 8,535,519
WA Washington USA 5 7,614,893
AZ Arizona USA -10 7,278,717
MA Massachusetts USA 5 6,949,503
TN Tennessee USA -5 6,833,174
IN Indiana USA 5 6,732,219
MO Missouri USA 0 6,137,428
MD Maryland USA 5 6,045,680
WI Wisconsin USA 5 5,822,434
CO Colorado USA 5 5,758,736
MN Minnesota USA 10 5,639,632
SC South Carolina USA -5 5,148,714
BC British Columbia CA 10 5,110,917
AL Alabama USA -10 4,903,185
LA Louisiana USA -10 4,648,794
KY Kentucky USA 0 4,467,673
AB Alberta CA 10 4,413,146
OR Oregon USA 5 4,217,737
OK Oklahoma USA -5 3,956,971
CT Connecticut USA 5 3,565,287
UT Utah USA -5 3,205,958
IA Iowa USA 5 3,155,070
NV Nevada USA -10 3,080,156
AR Arkansas USA -5 3,017,825
MS Mississippi USA -10 2,976,149
KS Kansas USA 0 2,913,314
NM New Mexico USA -10 2,096,829
NE Nebraska USA 0 1,934,408
NS Nova Scotia CA 10 1,915,608
WV West Virginia USA 0 1,792,147
ID Idaho USA 0 1,787,065
HI Hawaii USA -100 1,415,872
MB Manitoba CA 10 1,377,517
NH New Hampshire USA 5 1,359,711
ME Maine USA 5 1,344,212
SK Saskatchewan CA 10 1,181,666
MT Montana USA 0 1,068,778
RI Rhode Island USA 5 1,059,361
DE Delaware USA 5 973,764
SD South Dakota USA 5 884,659
ND North Dakota USA 5 762,062
AK Alaska USA -5 731,545
DC District of Columbia USA 5 705,749
VT Vermont USA 0 623,989
WY Wyoming USA 5 578,759