bmf_group_exemptions

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

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

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);