bmf_group_members

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

394,940 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 010027748 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
17 17 010027751 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
18 18 010056995 NATIONAL KITCHEN & BATH ASSO ME 3379 9 231656462 NATIONAL KITCHEN & BATH ASSOC
19 19 010063430 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
20 20 010067817 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
21 21 010095329 IMPROVED ORDER OF REDMEN OF MAINE ME 0280 6 010095329 IMPROVED ORDER OF REDMEN OF MAINE
22 22 010095413 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
23 23 010095414 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
24 24 010095497 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
25 25 010095705 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS ME 0064 9 530088380 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS
26 26 010095740 INTERNATIONAL BROTHERHOOD OF TEAMSTERS ME 0320 9 530215427 INTERNATIONAL BROTHERHOOD OF TEAMSTERS
27 27 010095770 UNITED STEELWORKERS ME 0260 9 250818080 UNITED STEELWORKERS
28 28 010102346 KNIGHTS OF PYTHIAS OF MAINE GRAND LODGE ME 0012 6 010102346 KNIGHTS OF PYTHIAS OF MAINE GRAND LODGE
29 29 010112977 ANCIENT ACCEPTED SCOTTISH RITE OF FREE MASONRY NMJ ME 0259 9 041032821 ANCIENT ACCEPTED SCOTTISH RITE OF FREEMASONRY NMJ
30 30 010113840 AMERICAN FEDERATION OF LABOR & CONGRESS OF INDUSTRIAL ORGS ME 1338 9 530228172 AMERICAN FEDERATION OF LABOR & CONGRESS OF INDUSTRIAL ORGS
31 31 010116390 SHRINERS INTERNATIONAL ME 0229 9 362158164 SHRINERS INTERNATIONAL
32 32 010129660 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
33 33 010132625 ORDER OF THE EASTERN STAR OF MAINE ME 0302 6 010132625 ORDER OF THE EASTERN STAR OF MAINE
34 34 010133155 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
35 35 010142655 KNIGHTS OF COLUMBUS ME 0188 9 060416470 KNIGHTS OF COLUMBUS
36 36 010144835 ANCIENT ACCEPTED SCOTTISH RITE OF FREE MASONRY NMJ ME 0259 9 041032821 ANCIENT ACCEPTED SCOTTISH RITE OF FREEMASONRY NMJ
37 37 010152188 ROTARY INTERNATIONAL ME 0573 9 361707667 ROTARY INTERNATIONAL
38 38 010163098 NATIONAL SOCIETY UNITED STATES DAUGHTERS OF 1812 ME 2347 9 530116360 NATIONAL SOCIETY UNITED STATES DAUGHTERS OF 1812
39 39 010168122 SHRINERS INTERNATIONAL ME 0229 9 362158164 SHRINERS INTERNATIONAL
40 40 010170013 ANAH SHRINERS ME 0229 9 362158164 SHRINERS INTERNATIONAL
41 41 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
42 42 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
43 43 010191837 AMERICAN LEGION 0002 FITZGERALD-CUMMINGS ME 0925 9 350144250 AMERICAN LEGION
44 44 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
45 45 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
46 46 010199895 AMERICAN LEGION POST 0147 THOS O CYR ME 0925 9 350144250 AMERICAN LEGION
47 47 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
48 48 010201854 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
49 49 010203373 AMERICAN LEGION ME 0925 9 350144250 AMERICAN LEGION
50 50 010207282 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
51 51 010209532 ANCIENT FREE & ACCEPTED MASONS OF MAINE ME 0275 9 010019705 ANCIENT FREE & ACCEPTED MASONS OF MAINE GRAND LODGE
52 52 010209784 DELTA TAU DELTA FRATERNITY ME 0124 9 350267650 DELTA TAU DELTA FRATERNITY
53 53 010210495 AMERICAN LEGION POST 0015 HENRY B PRATT ME 0925 9 350144250 AMERICAN LEGION
54 54 010210783 KAPPA DELTA PHI NATIONAL AFFILIATED SORORITY INC MA 9115 9 050392278 KAPPA DELTA PHI NATIONAL AFFILIATED SORORITY INC
55 55 010211489 BOY SCOUTS OF AMERICA ME 1761 9 221576300 BOY SCOUTS OF AMERICA
56 56 010211490 BOY SCOUTS OF AMERICA ME 1761 9 221576300 BOY SCOUTS OF AMERICA
57 57 010211492 CATHEDRAL CHURCH OF ST LUKE ME 3741 9    
58 58 010211499 MAINE CONFERENCE UNITED CHURCH OF CHRIST ME 1665 9    
59 59 010211501 EASTERN MAINE HEALTHCARE SYSTEMS ME 5247 9 010527066 EASTERN MAINE HEALTHCARE SYSTEMS
60 60 010211527 MAINE EPISCOPAL MISSIONARY SOCIETY ME 3741 9    
61 61 010211563 ABC OF MAINE ME 3125 9    
62 62 010211785 CHEVERUS HIGH SCHOOL ME 0928 9    
63 63 010211879 ST MARKS CHURCH ME 3741 9    
64 64 010212435 ST JOSEPH HOSPITAL NH 0928 9    
65 65 010212542 TRUSTEES OF ST JOSEPHS COLLEGE ME 0928 9    
66 66 010212546 ROMAN CATHOLIC BISHOP OF PORTLAND ME 0928 9    
67 67 010213360 CATHEDRAL OF THE IMMACULATE CONCEPTION ME 0928 9    
68 68 010213498 AMERICAN LEGION POST 0035 STEWART P MORRILL ME 0925 9 350144250 AMERICAN LEGION
69 69 010213667 KNIGHTS TEMPLAR OF THE UNITED STATES OF AMERICA ME 0266 9 237125380 KNIGHTS TEMPLAR OF THE UNITED STATES OF AMERICA
70 70 010214021 ST SAVIOURS PARISH ME 3741 9    
71 71 010214376 KNIGHTS OF COLUMBUS ME 0188 9 060416470 KNIGHTS OF COLUMBUS
72 72 010215607 GRAND ROYAL ARCH MASONS OF MAINE ME 1716 6 010215607 GRAND ROYAL ARCH MASONS OF MAINE
73 73 010215916 PENNEY MEMORIAL UNITED BAPTIST CHURCH ME 3125 9    
74 74 010215917 ST MARKS HOME FOR WOMEN ME 3741 9    
75 75 010216655 INDEPENDENT ORDER OF ODD FELLOWS ME 0028 9 520363509 INDEPENDENT ORDER OF ODD FELLOWS
76 76 010217211 EASTERN MAINE HEALTHCARE SYSTEMS ME 5247 9 010527066 EASTERN MAINE HEALTHCARE SYSTEMS
77 77 010217327 STATE STREET CONGREGATIONAL CHURCH ME 1665 9    
78 78 010217620 ROTARY INTERNATIONAL ME 0573 9 361707667 ROTARY INTERNATIONAL
79 79 010220146 COURT STREET BAPTIST CHURCH ME 3125 9    
80 80 010220348 UNIVERSITY OF MAINE SYSTEM INC ME 5930 9 016000769 UNIVERSITY OF MAINE SYSTEM INC
81 81 010221136 MAINE PARENT TEACHER ASSOCIATION INC ME 1076 6 010221136 MAINE PARENT TEACHER ASSOCIATION INC
82 82 010222956 UNITED BAPTIST CHURCH ME 3125 9    
83 83 010226195 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS ME 0064 9 530088380 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS
84 84 010226203 ST PETERS PARISH ME 3741 9    
85 85 010227743 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
86 86 010228109 COLUMBIA STREET BAPTIST CHURCH ME 3125 9    
87 87 010229553 BAKERY CONFECTIONERY TOBACCO WORKERS AND GRAIN MILLERS INTL UNI ME 0096 9 530231138 BAKERY CONFECTIONERY TOBACCO WORKERS AND GRAIN MILLERS INTL UNI
88 88 010229959 CHRIST CHURCH PARISH ME 3741 9    
89 89 010231248 FIRST CONGREGATIONAL CHURCH OF CALAIS MAINE ME 1665 9    
90 90 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
91 91 010233284 BANGOR FIRST BAPTIST CHURCH ME 3125 9    
92 92 010234309 FAIRFIELD FIRST BAPTIST CHURCH ME 3125 9    
93 93 010234590 KNIGHTS TEMPLAR EDUCATIONAL FOUNDATION OF THE GRAND ENCAMPMENT ME 1178 9 362160540 KNIGHTS TEMPLAR EDUCATIONAL FNDN OF GRND ENCMPMNT KNIGHTS TEMPLAR
94 94 010234952 KIWANIS INTERNATIONAL INC ME 0026 9 361327510 KIWANIS INTERNATIONAL INC
95 95 010236928 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA ME 1156 9 360793011 BENEVOLENT & PROTECTIVE ORDER OF ELKS OF THE USA
96 96 010237050 UNITY CHURCH OF TRUTH ME 2062 9    
97 97 010237756 NORTH HAVEN BAPTIST CHURCH ME 3125 9    
98 98 010240618 SAINT ALBANS EPISCOPAL CHURCH ME 3741 9    
99 99 010240898 AMERICAN LEGION POST 0088 RAY GODING ME 0925 9 350144250 AMERICAN LEGION
100 100 010242142 ANCIENT ACCEPTED SCOTTISH RITE OF FREE MASONARY NMJ ME 0259 9 041032821 ANCIENT ACCEPTED SCOTTISH RITE OF FREEMASONRY NMJ

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