bmf_group_exemptions

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

3,895 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ gen member_count most_common_state inferred_parent_hint parent_ein parent_name
1 1 0002 2101 FL LOYAL ORDER 361408120 MOOSE INTERNATIONAL INC
2 2 0005 17 NH ORDER OF 010174648 ORDER OF THE EASTERN STAR OF NEW HAMPSHIRE GRAND CHAPTER
3 3 0006 10 MD ROYAL SELECT 520467023 ROYAL & SELECT MASTERS OF MARYLAND
4 4 0007 3 OR OREGON MEDICAL 930497431 OREGON MEDICAL ASSOCIATION
5 5 0008 102 NY SIGMA CHI 361773960 SIGMA CHI FRATERNITY
6 6 0011 10 NY WORKMENS BENEFIT 111488600 WORKMENS BENEFIT FUND OF THE USA
7 7 0012 6 ME KNIGHTS OF 010102346 KNIGHTS OF PYTHIAS OF MAINE GRAND LODGE
8 8 0015 5 MD IMPROVED ORDER 526066964 GREAT COUNCIL OF MARYLAND DEGREE OF POCAHONTAS
9 9 0020 263 MO ANCIENT FREE 430160306 GRAND LODGE AF & AM OF MO
10 10 0021 17 WV JUNIOR ORDER 231173150 JUNIOR ORDER UNITED AMERICAN MECHANICS
11 11 0022 217 SC ANCIENT FREE 570115100 ANCIENT FREE MASONS OF SOUTH CAROLINA
12 12 0023 32 IL ROYAL ARCH 362130314 ROYAL ARCH MASONS OF ILLINOIS GRAND CHAPTER
13 13 0024 6 DC ORDER OF 530121296 ORDER OF THE EASTERN STAR OF DISTRICT OF COLUMBIA GRAND CHAPTER
14 14 0025 75 MD ANCIENT FREE 520226260 ANCIENT FREE & ACCEPTED MASONS OF MARYLAND GRAND LODGE
15 15 0026 2601 CA KIWANIS INTERNATIONAL 361327510 KIWANIS INTERNATIONAL INC
16 16 0027 73 NY ORDER OF 135583336 ORDER OF EASTERN STAR OF NEW YORK
17 17 0028 784 CA INDEPENDENT ORDER 520363509 INDEPENDENT ORDER OF ODD FELLOWS
18 18 0029 26 MD ORDER OF 520435078 ORDER OF THE EASTERN STAR OF MARYLAND GRAND CHAPTER
19 19 0030 11 MD ROYAL ARCH 520226305 ROYAL ARCH MASONS OF MARYLAND GRAND CHAPTER
20 20 0031 8 MA GREAT COUNCIL 041397750 GREAT COUNCIL OF MASSACHUSETTS IMPROVED ORDER OF RED MEN
21 21 0036 30 DC FREE AND 530070153 FREE AND ACCEPTED MASONS OF THE DISTRICT OF COLUMBIA
22 22 0038 411 IL ANCIENT FREE 370154973 ANCIENT FREE & ACCEPTED MASONS OF ILLINOIS
23 23 0039 66 PA OPERATIVE PLASTERERS 530258484 OPERATIVE PLASTERERS & CEMENT MASONS INTERNATIONAL ASSOCIATION
24 24 0040 125 CA ORDER OF 940446470 GRAND CHAPTER OF CALIFORNIA ORDER OF THE EASTERN STAR
25 25 0041 8 PA PATRIOTIC ORDER 230945282 PATRIOTIC ORDER SONS OF AMERICA PENNSYLVANIA STATE CAMP
26 26 0043 39 NY ROYAL ARCH 135572761 ROYAL ARCH MASONS OF NEW YORK GRAND CHAPTER
27 27 0048 69 CA YOUNG LADIES 940997070 YOUNG LADIES GRAND INSTITUTE
28 28 0049 102 MO ORDER OF 430443360 ORDER OF THE EASTERN STAR OF MISSOURI GRAND CHAPTER
29 29 0050 22 TX AUXILIARY OF 314135005 SMART TRANSPORATION DIVISION AUXILIARY
30 30 0051 200 WA ORDER OF 221627631 ORDER OF THE AMARANTH INC SUPREME COUNCIL
31 31 0053 17 OH AMERICAN MUTUAL 346577472 AMERICAN MUTUAL LIFE ASSOCIATION
32 32 0055 5 DC ORDER OF 526074275 GEORGIANNA THOMAS GRAND CHAPTER
33 33 0056 84 IL ORDER OF 361584860 GRAND CHAPTER ORDER OF EASTERN STAR OF THE STATE OF ILLINOIS
34 34 0057 8 NY KNIGHTS OF 135668089 KNIGHTS OF PYTHIAS OF NEW YORK GRAND LODGE
35 35 0064 680 OH INTERNATIONAL BROTHERHOOD 530088380 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS
36 36 0065 23 SC ROYAL ARCH 570238332 ROYAL ARCH MASONS OF SOUTH CAROLINA GRAND CHAPTER
37 37 0066 215 VA KAPPA ALPHA 580310956 KAPPA ALPHA ORDER
38 38 0068 16 PA ARTISANS ORDER 230368600 ARTISANS ORDER OF MUTUAL PROTECTION MOST EXCELLENT ASSEMBLY
39 39 0070 24 SC ROYAL AND 570238327 ROYAL AND SELECT MASTERS OF SOUTH CAROLINA
40 40 0071 145 IL POLISH NATIONAL 361635410 POLISH NATIONAL ALLIANCE OF THE UNITED STATES OF NORTH AMERICA
41 41 0072 226 WI CATHOLIC ORDER 360879870 CATHOLIC ORDER OF FORESTERS
42 42 0073 2 NJ KNIGHTS OF 210684231 KNIGHTS OF PYTHIAS OF NEW JERSEY GRAND LODGE
43 43 0077 5 DC ROYAL ARCH 530135445 ROYAL ARCH MASONS OF DISTRICT OF COLUMBIA GRAND CHAPTER
44 44 0078 19 KY ROYAL SELECT 610326335 ROYAL & SELECT MASTERS OF KENTUCKY GRAND COUNCIL
45 45 0081 55 AZ THE MOST 860024053 THE MOST WORSHIPFUL GRAND LODGE OF FREE & ACCEPTED MASONS OF ARIZONA
46 46 0082 28 KY ROYAL ARCH 610326188 GRAND CHAPTER OF KENTUCKY
47 47 0083 41 CO ASSURED LIFE 840356870 ASSURED LIFE ASSOCIATION
48 48 0085 68 NH FREE ACCEPTED 020104256 FREE & ACCEPTED MASONS OF NEW HAMPSHIRE GRAND LODGE
49 49 0086 9 NH ROYAL ARCH 026007854 ROYAL ARCH MASONS OF NEW HAMPSHIRE GRAND LODGE
50 50 0089 75 FL LADIES ORIENTAL 350344792 LADIES ORIENTAL SHRINE OF NORTH AMERICA INC
51 51 0091 173 TX DELTA DELTA 362374316 DELTA DELTA DELTA
52 52 0093 40 OH ORDER OF 340677593 ORDER OF THE WHITE SHRINE OF JERUSALEM
53 53 0095 215 CA ANCIENT ACCEPTED 530152875 ANCIENT & ACCEPTED SCOTTISH RITE OF FREE MASONRY SO JURIS USA
54 54 0096 89 IL BAKERY CONFECTIONERY 530231138 BAKERY CONFECTIONERY TOBACCO WORKERS AND GRAIN MILLERS INTL UNI
55 55 0097 7 NH ROYAL SELECT 026014819 GRAND COUNCIL CRYPTIC MASONS OF NEW HAMPSHIRE
56 56 0098 29 CA ROYAL ARCH 940661480 ROYAL ARCH MASONS OF CALIFORNIA GRAND CHAPTER
57 57 0099 17 CA CRYPTIC MASONS 940819564 CRYPTIC MASONS OF CALIFORNIA GRAND COUNCIL
58 58 0101 187 OH ORDER OF 340680705 ORDER OF THE EASTERN STAR OF OHIO GRAND CHAPTER
59 59 0102 2106 OH FRATERNAL ORDER 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
60 60 0106 78 IL CZECHOSLOVAK SOCIETY 360971620 CSA FRATERNAL LIFE
61 61 0108 253 MN SONS OF 410547795 SONS OF NORWAY
62 62 0110 12 PA GREAT COUNCIL 230721990 GREAT COUNCIL OF PENNSYLVANIA IMPROVED ORDER OF RED MEN
63 63 0114 75 PA SLOVENE NATIONAL 361787650 SLOVENE NATIONAL BENEFIT SOCIETY
64 64 0115 17 OH KNIGHTS OF 314375610 KNIGHTS OF PYTHIAS GRAND LODGE
65 65 0116 17 NY CRYPTIC MASONS 111740353 CRYPTIC MASONS OF THE STATE OF NEW YORK INC
66 66 0120 37 IL AMERICAN SLOVENIAN 361150880 KSKJ LIFE CATHOLIC UNION
67 67 0121 369 IL LABORERS INTERNATIONAL 530088501 LABORERS INTERNATIONAL UNION OF NORTH AMERICA
68 68 0122 114 NY AMERICAN FEDERATION 221476432 AMERICAN FEDERATION OF MUSICIANS OF THE US & CANADA
69 69 0123 10 OH ALPHA OMEGA 131872717 ALPHA OMEGA INTERNATIONAL DENTAL FRATERNITY INC
70 70 0124 121 TX DELTA TAU 350267650 DELTA TAU DELTA FRATERNITY
71 71 0125 108 WI WESTERN FRATERNAL 420594470 BETTERLIFE
72 72 0128 243 IL POLISH ROMAN 361635425 POLISH ROMAN CATHOLIC UNION OF AMERICA
73 73 0133 56 WI INTERNATIONAL UNION 530038250 INTERNATIONAL UNION OF BRICKLAYERS AND ALLIED CRAFTWORKERS
74 74 0143 267 CA UNITED BROTHERHOOD 350723065 UNITED BROTHERHOOD OF CARPENTERS & JOINERS OF AMERICA
75 75 0144 246 LA FREE ACCEPTED 720189107 FREE & ACCEPTED MASONS OF LOUISIANA GRAND LODGE
76 76 0145 1 TX MOST WORSHIPFUL 740796535 MOST WORSHIPFUL ST JOSEPH GRAND LODGE OF ANCIENT FREE AND ACCEPTED
77 77 0147 62 VT FREE ACCEPTED 030123345 FREE & ACCEPTED MASONS OF VERMONT
78 78 0151 81 OH UNITED COMMERCIAL 314273120 ORDER OF UNITED COMMERCIAL TRAVELERS OF AMERICA
79 79 0152 39 TX IMPROVED ORDER 746066282 IMPROVED ORDER OF RED MEN OF TEXAS GREAT COUNCIL
80 80 0154 282 CA KAPPA ALPHA 361305568 KAPPA ALPHA THETA FRATERNITY
81 81 0155 160 PA AMALGAMATED TRANSIT 536014540 AMALGAMATED TRANSIT UNION
82 82 0158 46 CA ZETA BETA 131496610 ZETA BETA TAU FRATERNITY
83 83 0160 1863 OH INTERNATIONAL ASSOCIATION 530088290 INTERNATIONAL ASSOCIATION OF FIRE FIGHTERS
84 84 0162 25 PA TRIANGLE FRATERNITY 381467069 TRIANGLE FRATERNITY NATIONAL COUNCIL
85 85 0164 99 TX PHI DELTA 310406470 PHI DELTA THETA FRATERNITY
86 86 0168 20 NY ACACIA FRATERNITY 360700015 ACACIA FRATERNITY INCORPORATED
87 87 0169 52 MA MASSACHUSETTS STATE 041591155 MASSACHUSETTS STATE GRANGE PATRONS OF HUSBANDRY INC
88 88 0171 404 OH FREE ACCEPTED 314419355 FREE & ACCEPTED MASONS OF OHIO
89 89 0174 122 TX HERMANN SONS 740817310 HERMANN SONS LIFE
90 90 0182 86 TX ROYAL ARCH 740688076 GRAND ROYAL ARCH CHAPTER OF TEXAS
91 91 0184 12 CA UNITED ANCIENT 940944825 UNITED ANCIENT ORDER OF DRUIDS
92 92 0185 110 CA ITALIAN CATHOLIC 940375826 ITALIAN CATHOLIC FEDERATION OF CALIF INC CENTRAL COUNCIL
93 93 0186 1 IL WESTERN CATHOLIC 370580740 WESTERN CATHOLIC UNION
94 94 0187 124 OH MYSTIC ORDER 361517737 MYSTIC ORDER OF VEILED PROPHETS OF ENCHANTED REALM SUPREME COUNCIL
95 95 0188 8019 TX KNIGHTS OF 060416470 KNIGHTS OF COLUMBUS
96 96 0189 41 NJ ORDER OF 221174669 GRAND CHAPTER ORDER OF THE EASTERN STAR OF NEW JERSEY
97 97 0190 419 TN ALPHA OMICRON 620950113 ALPHA OMICRON PI FRATERNITY INC
98 98 0191 9 VT ROYAL ARCH 030153944 ROYAL ARCH MASONS OF VERMONT GRAND CHAPTER
99 99 0192 65 TX KJZT FAMILY 740719305 KJZT FAMILY LIFE
100 100 0194 640 TX AMERICAN FEDERATION 530025740 AMERICAN FEDERATION OF GOVERNMENT EMPLOYEES

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE bmf_group_exemptions(
  gen TEXT,
  member_count INT,
  most_common_state TEXT,
  inferred_parent_hint TEXT,
  parent_ein TEXT,
  parent_name TEXT
);