comment_org_entities

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

21,643 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, hub, match_method

Link rowid ▼ name_key entity_id canonical_name entity_type ein cik hub match_method
1 1 '47 BRAND, LLC 2171153 '47 BRAND, LLC private_company       alias_name
2 2 (AJ CONGRESS) - AMERICAN JEWISH CONGRESS 84594 AMERICAN JEWISH CONGRESS INC nonprofit 131679610   nonprofit normalized_name
3 3 (FIRST NAME NOT AVAILABLE) HALEY 889415 HALEY GROUP INC nonprofit 471716823   nonprofit normalized_name
4 4 (NAME ILLEGIBLE) SUN COMPANY 2055196 Sun private_company       normalized_name
5 5 (NAME ILLEGIBLE), BASF CORPORATION 2154413 BASF CORPORATION private_company       normalized_name
6 6 (NAME ILLEGIBLE); PINNACLE PROPANE LLC 2242869 PINNACLE PROPANE, LLC private_company       alias_name
7 7 (NO FIRST NAME GIVEN) CANNON 2348513 THE CANNON CORPORATION federal_contractor       normalized_name
8 8 (NO FIRST NAME GIVEN) DUDLEY 172059 CASA DE ADORACION nonprofit 205421808   nonprofit alias_name
9 9 (NO FIRST NAME GIVEN) GORDON 877222 NEBRASKA STATE EDUCATION ASSOCIATION union 470740371   nonprofit alias_name
10 10 (NO FIRST NAME PROVIDED) EVANS 2337092 EVANS INCORPORATED federal_contractor       normalized_name
11 11 (NO FIRST NAME PROVIDED) KINLEY 1991812 Kinley Holdings, LLC private_company       alias_name
12 12 (NO FIRST NAME PROVIDED) SHEPARD 2001027 Shepard LLC private_company       alias_name
13 13 (PRESIDENT); HUNTERDON COUNTY FIRE CHIEFS ASSOCIATION 1470762 HUNTERDON COUNTY FIRE CHIEFS ASSN nonprofit 842586323   nonprofit normalized_name
14 14 (RETIRED) SALT LAKE COUNTY (UTAH) 2344405 SALT LAKE COUNTY federal_contractor       normalized_name
15 15 ,COMMUNITIES RESIST, INC. 1461667 COMMUNITIES RESIST nonprofit 841899350   nonprofit normalized_name
16 16 1260 HOUSING DEVELOPMENT CORPORATION 224181 1260 HOUSING DEVELOPMENT CORPORATION nonprofit 232536730   nonprofit normalized_name
17 17 1854 TREATY AUTHORITY 2363397 1854 TREATY AUTHORITY federal_contractor       normalized_name
18 18 1930 1851466 INTERNATIONAL ASSOCIATION OF MACHINISTS & AEROSPACE WORKERS union 951759162   nonprofit alias_name
19 19 1959 1994190 1959 Holdings, LLC private_company       normalized_name
20 20 1977 2211311 1977 HOLDINGS, LLC private_company       normalized_name
21 21 1ST SECURITY BANK OF WASHINGTON 2081717 1st Security Bank of Washington private_company       alias_name
22 22 1ST UNITED CREDIT UNION 1825278 1ST UNITED CREDIT UNION nonprofit 940335800   nonprofit normalized_name
23 23 20/20 GENESYSTEMS, INC. 2074931 20/20 GENESYSTEMS, INC. private_company       alias_name
24 24 21ST CENTURY LEADERSHIP PAC 2282294 21ST CENTURY LEADERSHIP PAC pac       normalized_name
25 25 21ST CENTURY SCHOOL FUND 986464 21ST CENTURY SCHOOL FUND INC nonprofit 522139122   nonprofit normalized_name
26 26 21ST MORTGAGE CORP. 2246497 21ST MORTGAGE CORPORATION private_company       alias_name
27 27 22ND CENTURY GROUP, INC. 2882 22nd Century Group, Inc. public_company 980468420 1347858 company alias_name
28 28 3-A SANITARY STANDARDS, INC. 989434 3-A SANITARY STANDARDS INC nonprofit 522378822   nonprofit normalized_name
29 29 350 SEATTLE 855108 350 SEATTLE nonprofit 464201865   nonprofit normalized_name
30 30 360 PRIVACY 2387071 360 PRIVACY, LLC federal_contractor       normalized_name
31 31 3M 277 3M CO public_company 410417775 66740 company alias_name
32 32 3M COMPANY 277 3M CO public_company 410417775 66740 company alias_name
33 33 3M COMPANY (3M) 277 3M CO public_company 410417775 66740 company alias_name
34 34 3M CORPORATION 277 3M CO public_company 410417775 66740 company alias_name
35 35 3V SIGMA USA INC. 2072304 3V SIGMA USA INC. private_company       alias_name
36 36 40 1963751 40, LLC private_company       normalized_name
37 37 400 CAPITAL MANAGEMENT LLC 2159566 400 CAPITAL MANAGEMENT LLC private_company       alias_name
38 38 410 WATER SUPPLY CORPORATION 1217571 410 WATER SUPPLY CORPORATION nonprofit 751321722   nonprofit normalized_name
39 39 4GENERATIONS, LLC 1385352 4GENERATIONS INC nonprofit 824829275   nonprofit normalized_name
40 40 4MYCITY INC. 1475059 4MYCITY INC nonprofit 842908913   nonprofit normalized_name
41 41 504 CORPORATION 2133202 OF 504 LLC private_company       normalized_name
42 42 7-ELEVEN, INC 2168748 7-Eleven, Inc. private_company       alias_name
43 43 7-ELEVEN, INC. 2168748 7-Eleven, Inc. private_company       alias_name
44 44 A 1 (NO SURNAME PROVIDED) 1558391 A-1 CORPORATION nonprofit 861139441   nonprofit normalized_name
45 45 A B (NO FULL NAME PROVIDED) 2195240 A HOLDINGS - B LLC private_company       alias_name
46 46 A BETTER BALANCE 156824 A BETTER BALANCE nonprofit 203664771   nonprofit normalized_name
47 47 A G (NO SURNAME PROVIDED) 2127696 A&G, LLC private_company       alias_name
48 48 A H (NO SURNAME PROVIDED) 2091236 A&H HOLDING LLC private_company       alias_name
49 49 A H. (NO SURNAME PROVIDED) 2091236 A&H HOLDING LLC private_company       alias_name
50 50 A O SMITH CORP 2244804 A. O. SMITH CORPORATION private_company       alias_name
51 51 A PASSION FOR PAWS RESCUE INC 164415 A PASSION FOR PAWS RESCUE INC nonprofit 204546959   nonprofit normalized_name
52 52 A VEGAN LIFE, INC. 1280493 A VEGAN LIFE INC nonprofit 810890144   nonprofit normalized_name
53 53 A VOICE FOR CHOICE ADVOCACY 917309 A VOICE FOR CHOICE ADVOCACY INC trade_association 473992088   nonprofit normalized_name
54 54 A W (NO SURNAME PROVIDED) 2400524 A&W GROUP LLC federal_contractor       normalized_name
55 55 A WORLD FIT FOR KIDS! 474730 A WORLD FIT FOR KIDS nonprofit 330550994   nonprofit normalized_name
56 56 A&K EARTH MOVERS, INC. 2351483 A & K EARTH MOVERS INC federal_contractor       normalized_name
57 57 A+ FEDERAL CREDIT UNION 2116754 A+ Federal Credit Union private_company       alias_name
58 58 A-TEK, INC. 2241232 A-TEK, Inc. private_company       alias_name
59 59 A. (LAST NAME NOT AVAILABLE) 2180126 "A" Company, Inc. private_company       normalized_name
60 60 A. B. (NO SURNAME PROVIDED) 2195240 A HOLDINGS - B LLC private_company       alias_name
61 61 A. COMPANY 2180126 "A" Company, Inc. private_company       normalized_name
62 62 A. G. (NO SURNAME PROVIDED) 2127696 A&G, LLC private_company       alias_name
63 63 A. H. (NO SURNAME PROVIDED) 2091236 A&H HOLDING LLC private_company       alias_name
64 64 A. M. (NO SURNAME PROVIDED) 2220357 A&M Holdings, LLC private_company       alias_name
65 65 A. O. SMITH CORPORATION 2244804 A. O. SMITH CORPORATION private_company       alias_name
66 66 A. P. (NO FULL NAME PROVIDED) 1953052 A & P Holdings LLC private_company       alias_name
67 67 A. P. (NO SURNAME PROVIDED) 1953052 A & P Holdings LLC private_company       alias_name
68 68 A. V. (NO SURNAME PROVIDED) 1965201 A&V HOLDINGS LLC private_company       alias_name
69 69 A. W. (NO SURNAME PROVIDED) 2400524 A&W GROUP LLC federal_contractor       normalized_name
70 70 A.B. WON PAT INTERNATIONAL AIRPORT AUTHORITY, GUAM 2336522 A.B. WON PAT INTERNATIONAL AIRPORT AUTHORITY, GUAM federal_contractor       normalized_name
71 71 A.E.C. 1153490 ASOCIACION DE ESTUDIANTES DE CONTABILIDAD nonprofit 660918832   nonprofit alias_name
72 72 A.R. NORTH AMERICA, INC. 2272437 A.R. North America, Inc. private_company       alias_name
73 73 AA CORPORATION 1505132 PEO SISTERHOOD INTERNATIONAL CHAPTER trade_association 846051949   nonprofit alias_name
74 74 AAAP (AMERICAN ASSOCIATION OF AVIAN PATHOLOGIST) 1471761 AAAP CORP nonprofit 842661379   nonprofit normalized_name
75 75 AAI CORPORATION 2347275 AAI CORPORATION federal_contractor       normalized_name
76 76 AAMC (ASSOCIATION OF AMERICAN MEDICAL COLLEGES) 2235322 AAMC, INC. private_company       alias_name
77 77 AANP 1767355 AMERICAN ASSOCIATION OF NATUROPATHIC PHYSICIANS INC trade_association 930936256   nonprofit alias_name
78 78 AAON INC. 955 AAON, INC. public_company 870448736 824142 company alias_name
79 79 AAON, INC. 955 AAON, INC. public_company 870448736 824142 company alias_name
80 80 AARCHER INC. 2377365 AARCHER, INC. federal_contractor       normalized_name
81 81 AARP 2274638 AARP private_company       alias_name
82 82 ABA 844667 ABA nonprofit 463357338   nonprofit normalized_name
83 83 ABATE OF IOWA, INC. 736196 ABATE OF IOWA INC trade_association 421236906   nonprofit normalized_name
84 84 ABATE, OF IOWA, INC. 736196 ABATE OF IOWA INC trade_association 421236906   nonprofit normalized_name
85 85 ABB INC. 2117244 ABB INC. private_company       alias_name
86 86 ABB INC. (ABB) 2117244 ABB INC. private_company       alias_name
87 87 ABB INSTALLATION PRODUCTS INC. (FORMERLY KNOWN AS THOMAS & BETTS) 2106332 ABB Installation Products Inc. private_company       alias_name
88 88 ABBOTT 26149 ABBOTT GROUP INC nonprofit 030327048   nonprofit normalized_name
89 89 ABBOTT (COVINGTON & BURLING LLP) 26149 ABBOTT GROUP INC nonprofit 030327048   nonprofit normalized_name
90 90 ABBOTT CORPORATION 26149 ABBOTT GROUP INC nonprofit 030327048   nonprofit normalized_name
91 91 ABBOTT LABORATORIES, INC. 2 ABBOTT LABORATORIES public_company 360698440 1800 company alias_name
92 92 ABBOTT MOLECULAR, INC. 2337490 ABBOTT MOLECULAR INC. federal_contractor       normalized_name
93 93 ABBVIE INC. 4014 AbbVie Inc. public_company 320375147 1551152 company alias_name
94 94 ABBVIE, INC. 4014 AbbVie Inc. public_company 320375147 1551152 company alias_name
95 95 ABCAM INC. 2389298 ABCAM INC federal_contractor       normalized_name
96 96 ABEONA THERAPEUTICS INC 528 ABEONA THERAPEUTICS INC. public_company 830221517 318306 company alias_name
97 97 ABIGAIL ALLIANCE FOR BETTER ACCESS TO DEVELOPMENTAL DRUGS 21715 ABIGAIL ALLIANCE FOR BETTER ACCESS TO DEVELOPMENTAL DRUGS INC nonprofit 020626386   nonprofit normalized_name
98 98 ABIGAIL WRIGHT (9.16.9 3:52 PM) 1276161 GOLDEN SUN FOUNDATION FOR WORLD CULTURE nonprofit 810573919   nonprofit alias_name
99 99 ABILITY ALLIANCE OF WEST ALABAMA 1123686 ABILITY ALLIANCE OF WEST ALABAMA INC nonprofit 621579060   nonprofit normalized_name
100 100 ABIOMED INC. 2068414 ABIOMED, INC. private_company       alias_name

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE comment_org_entities(
  name_key TEXT,
  entity_id INT,
  canonical_name TEXT,
  entity_type TEXT,
  ein TEXT,
  cik INT,
  hub TEXT,
  match_method TEXT
);
CREATE INDEX idx_coe_entity ON comment_org_entities(entity_id);