bmf_group_members

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

401,894 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ ein name state gen affiliation_code parent_ein parent_name
1 1 000019818 PALMER SECOND BAPTIST CHURCH MA 3125 9    
2 2 000029215 ST GEORGE CATHEDRAL MA 2365 9    
3 3 001028397 UNITY IN THE CITY MA 2062 9    
4 4 002022084 ST ROSALIAS ROMAN CATHOLIC CHURCH NY 0928 9    
5 5 002045409 GENERAL COUNCIL OF ASSEMBLIES OF GOD FULL GOSPEL TABERNACLE NY 1678 9    
6 6 010018605 AMALGAMATED TRANSIT UNION ME 0155 9 536014540 AMALGAMATED TRANSIT UNION
7 7 010018922 AMERICAN LEGION ME 0964 9 350144340 AMERICAN LEGION AUXILIARY
8 8 010018923 AMERICAN LEGION POST 0019 THOMAS W COLE POST ME 0925 9 350144250 AMERICAN LEGION
9 9 010018927 AMERICAN LEGION POST 0005 BOURQUE LANIGAN ME 0925 9 350144250 AMERICAN LEGION
10 10 010018930 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
11 11 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE ME 0275 6 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE
12 12 010024455 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
13 13 010027415 ANCIENT FREE & ACCEPTED MASONS OF MAINE ME 0275 9 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE
14 14 010027741 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
15 15 010027746 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
16 16 010027747 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
17 17 010027748 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
18 18 010027751 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
19 19 010056995 NATIONAL KITCHEN & BATH ASSO ME 3379 9 231656462 NATIONAL KITCHEN & BATH ASSOC
20 20 010061300 FRATERNAL ORDER OF EAGLES ME 0102 9 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
21 21 010061310 FRATERNAL ORDER OF EAGLES ME 0102 9 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
22 22 010063057 FRATERNAL ORDER OF EAGLES ME 0102 9 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
23 23 010063430 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
24 24 010067817 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
25 25 010072838 FRATERNAL ORDER OF EAGLES ME 0102 9 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
26 26 010095329 IMPROVED ORDER OF REDMEN OF MAINE ME 0280 6 010095329 IMPROVED ORDER OF REDMEN OF MAINE
27 27 010095413 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
28 28 010095414 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
29 29 010095497 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
30 30 010095705 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS ME 0064 9 530088380 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS
31 31 010095740 INTERNATIONAL BROTHERHOOD OF TEAMSTERS ME 0320 9 530215427 INTERNATIONAL BROTHERHOOD OF TEAMSTERS
32 32 010095770 UNITED STEELWORKERS ME 0260 9 250818080 UNITED STEELWORKERS
33 33 010102346 KNIGHTS OF PYTHIAS OF MAINE GRAND LODGE ME 0012 6 010102346 KNIGHTS OF PYTHIAS OF MAINE GRAND LODGE
34 34 010112977 ANCIENT ACCEPTED SCOTTISH RITE OF FREE MASONRY NMJ ME 0259 9 041032821 ANCIENT ACCEPTED SCOTTISH RITE OF FREEMASONRY NMJ
35 35 010113840 AMERICAN FEDERATION OF LABOR & CONGRESS OF INDUSTRIAL ORGS ME 1338 9 530228172 AMERICAN FEDERATION OF LABOR & CONGRESS OF INDUSTRIAL ORGS
36 36 010116390 SHRINERS INTERNATIONAL ME 0229 9 362158164 SHRINERS INTERNATIONAL
37 37 010129660 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
38 38 010132625 ORDER OF THE EASTERN STAR OF MAINE ME 0302 6 010132625 ORDER OF THE EASTERN STAR OF MAINE
39 39 010133155 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
40 40 010142655 KNIGHTS OF COLUMBUS ME 0188 9 060416470 KNIGHTS OF COLUMBUS
41 41 010144835 ANCIENT ACCEPTED SCOTTISH RITE OF FREE MASONRY NMJ ME 0259 9 041032821 ANCIENT ACCEPTED SCOTTISH RITE OF FREEMASONRY NMJ
42 42 010152188 ROTARY INTERNATIONAL ME 0573 9 361707667 ROTARY INTERNATIONAL
43 43 010163098 NATIONAL SOCIETY UNITED STATES DAUGHTERS OF 1812 ME 2347 9 530116360 NATIONAL SOCIETY UNITED STATES DAUGHTERS OF 1812
44 44 010170013 ANAH SHRINERS ME 0229 9 362158164 SHRINERS INTERNATIONAL
45 45 010174648 ORDER OF THE EASTERN STAR OF NEW HAMPSHIRE GRAND CHAPTER NH 0005 6 010174648 ORDER OF THE EASTERN STAR OF NEW HAMPSHIRE GRAND CHAPTER
46 46 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES ME 9154 6 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES
47 47 010191837 AMERICAN LEGION 0002 FITZGERALD-CUMMINGS ME 0925 9 350144250 AMERICAN LEGION
48 48 010193088 VETERANS OF FOREIGN WARS OF THE UNITED STATES DEPT OF MAINE ME 9154 9 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES
49 49 010196124 ANCIENT FREE & ACCEPTED MASONS OF MAINE ME 0275 9 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE
50 50 010199224 VETERANS OF FOREIGN WARS OF THE UNITED STATES DEPT OF MAINE ME 9154 9 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES
51 51 010199895 AMERICAN LEGION POST 0147 THOS O CYR ME 0925 9 350144250 AMERICAN LEGION
52 52 010200646 VETERANS OF FOREIGN WARS OF THE UNITED STATES DEPT OF MAINE ME 9154 9 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES
53 53 010201854 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
54 54 010203373 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
55 55 010207282 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
56 56 010207850 AMERICAN LEGION GROVER HINCKLEY ME 0925 9 350144250 AMERICAN LEGION
57 57 010209532 ANCIENT FREE & ACCEPTED MASONS OF MAINE ME 0275 9 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE
58 58 010209784 DELTA TAU DELTA FRATERNITY ME 0124 9 350267650 DELTA TAU DELTA FRATERNITY
59 59 010210495 AMERICAN LEGION POST 0015 HENRY B PRATT ME 0925 9 350144250 AMERICAN LEGION
60 60 010210783 KAPPA DELTA PHI NATIONAL AFFILIATED SORORITY INC MA 9115 9 050392278 KAPPA DELTA PHI NATIONAL AFFILIATED SORORITY INC
61 61 010211489 BOY SCOUTS OF AMERICA ME 1761 9 221576300 BOY SCOUTS OF AMERICA
62 62 010211490 BOY SCOUTS OF AMERICA ME 1761 9 221576300 BOY SCOUTS OF AMERICA
63 63 010211492 CATHEDRAL CHURCH OF ST LUKE ME 3741 9    
64 64 010211499 MAINE CONFERENCE UNITED CHURCH OF CHRIST ME 1665 9    
65 65 010211501 EASTERN MAINE HEALTHCARE SYSTEMS ME 5247 9 010527066 EASTERN MAINE HEALTHCARE SYSTEMS
66 66 010211527 MAINE EPISCOPAL MISSIONARY SOCIETY ME 3741 9    
67 67 010211563 ABC OF MAINE ME 3125 9    
68 68 010211785 CHEVERUS HIGH SCHOOL ME 0928 9    
69 69 010211879 ST MARKS CHURCH ME 3741 9    
70 70 010212435 ST JOSEPH HOSPITAL ME 0928 9    
71 71 010212542 TRUSTEES OF ST JOSEPHS COLLEGE ME 0928 9    
72 72 010212546 ROMAN CATHOLIC BISHOP OF PORTLAND ME 0928 9    
73 73 010213360 CATHEDRAL OF THE IMMACULATE CONCEPTION ME 0928 9    
74 74 010213498 AMERICAN LEGION POST 0035 STEWART P MORRILL ME 0925 9 350144250 AMERICAN LEGION
75 75 010213667 KNIGHTS TEMPLAR OF THE UNITED STATES OF AMERICA ME 0266 9 237125380 KNIGHTS TEMPLAR OF THE UNITED STATES OF AMERICA
76 76 010214021 ST SAVIOURS PARISH ME 3741 9    
77 77 010214376 KNIGHTS OF COLUMBUS ME 0188 9 060416470 KNIGHTS OF COLUMBUS
78 78 010215607 GRAND ROYAL ARCH MASONS OF MAINE ME 1716 6 010215607 GRAND ROYAL ARCH MASONS OF MAINE
79 79 010215916 PENNEY MEMORIAL UNITED BAPTIST CHURCH ME 3125 9    
80 80 010215917 ST MARKS HOME FOR WOMEN ME 3741 9    
81 81 010216655 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
82 82 010217211 EASTERN MAINE HEALTHCARE SYSTEMS ME 5247 9 010527066 EASTERN MAINE HEALTHCARE SYSTEMS
83 83 010217327 STATE STREET CONGREGATIONAL CHURCH ME 1665 9    
84 84 010217620 ROTARY INTERNATIONAL ME 0573 9 361707667 ROTARY INTERNATIONAL
85 85 010220146 COURT STREET BAPTIST CHURCH ME 3125 9    
86 86 010220179 FRATERNAL ORDER OF EAGLES ME 0102 9 390920675 GRAND AERIE FRATERNAL ORDER OF EAGLES
87 87 010220348 UNIVERSITY OF MAINE SYSTEM INC ME 5930 9 016000769 UNIVERSITY OF MAINE SYSTEM INC
88 88 010221136 MAINE PARENT TEACHER ASSOCIATION INC ME 1076 6 010221136 MAINE PARENT TEACHER ASSOCIATION INC
89 89 010222956 UNITED BAPTIST CHURCH ME 3125 9    
90 90 010226195 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS ME 0064 9 530088380 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS
91 91 010226203 ST PETERS PARISH ME 3741 9    
92 92 010227743 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
93 93 010228109 COLUMBIA STREET BAPTIST CHURCH ME 3125 9    
94 94 010229553 BAKERY CONFECTIONERY TOBACCO WORKERS AND GRAIN MILLERS INTL UNI ME 0096 9 530231138 BAKERY CONFECTIONERY TOBACCO WORKERS AND GRAIN MILLERS INTL UNI
95 95 010229959 CHRIST CHURCH PARISH ME 3741 9    
96 96 010231248 FIRST CONGREGATIONAL CHURCH OF CALAIS MAINE ME 1665 9    
97 97 010233275 VETERANS OF FOREIGN WARS OF THE UNITED STATES DEPT OF MAINE ME 9154 9 010191822 DEPARTMENT OF MAINE VETERANS OF FOREIGN WARS OF THE UNITED STATES
98 98 010233284 BANGOR FIRST BAPTIST CHURCH ME 3125 9    
99 99 010234309 FAIRFIELD FIRST BAPTIST CHURCH ME 3125 9    
100 100 010234590 KNIGHTS TEMPLAR EDUCATIONAL FOUNDATION OF THE GRAND ENCAMPMENT ME 1178 9 362160540 KNIGHTS TEMPLAR EDUCATIONAL FNDN OF GRND ENCMPMNT KNIGHTS TEMPLAR

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE bmf_group_members(
  ein TEXT,
  name TEXT,
  state TEXT,
  gen TEXT,
  affiliation_code TEXT,
  parent_ein TEXT,
  parent_name TEXT
);
CREATE INDEX idx_bgm_gen ON bmf_group_members(gen);
CREATE INDEX idx_bgm_ein ON bmf_group_members(ein);
CREATE INDEX idx_bgm_state_gen ON bmf_group_members(state, gen);