Skip to content

Instantly share code, notes, and snippets.

@pivcec

pivcec/returned.json

Created July 4, 2025 18:49
Show Gist options
  • Save pivcec/aa434dc40a77464ab38607b87995ce7d to your computer and use it in GitHub Desktop.
Save pivcec/aa434dc40a77464ab38607b87995ce7d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
returned.json
{
"profiles": [
{
"_id": "2620085",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 2620085, \"firstName\": \"Melissa\", \"middleName\": \"A\", \"lastName\": \"Herley\", \"otherNames\": [\"MELISSA ANNE HERLEY\", \"MELISSA ANNE MCCLAINE\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"11/23/2016\"}, \"currentEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"11/4/2022\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"10/20/2022\"}]}], \"currentIAEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"11/4/2022\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"10/20/2022\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"registrationBeginDate\": \"4/1/2021\", \"registrationEndDate\": \"10/25/2022\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"10418\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"10999\", \"firmId\": 705, \"firmName\": \"RAYMOND JAMES & ASSOCIATES, INC.\", \"city\": \"WESTPORT\", \"state\": \"CT\", \"registrationBeginDate\": \"5/22/2020\", \"registrationEndDate\": \"9/10/2020\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"16048\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"129\", \"firmId\": 361, \"firmName\": \"GOLDMAN, SACHS & CO.\", \"city\": \"NEW YORK\", \"state\": \"NY\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"4/22/1997\", \"registrationEndDate\": \"1/22/2001\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"31022\", \"firmId\": 372, \"firmName\": \"GRUNTAL & CO., L.L.C.\", \"city\": \"NEW YORK\", \"state\": \"NY\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"12/23/1996\", \"registrationEndDate\": \"4/15/1997\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}], \"previousIAEmployments\": [{\"iaOnly\": \"Y\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"country\": \"United States\", \"registrationBeginDate\": \"4/1/2021\", \"registrationEndDate\": \"10/25/2022\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 2, \"principalExamCount\": 0, \"productExamCount\": 3}, \"stateExamCategory\": [{\"examCategory\": \"Series 65\", \"examName\": \"Uniform Investment Adviser Law Examination\", \"examTakenDate\": \"1/12/2021\", \"examScope\": \"IA\"}, {\"examCategory\": \"Series 63\", \"examName\": \"Uniform Securities Agent State Law Examination\", \"examTakenDate\": \"8/20/2020\", \"examScope\": \"BC\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"Series 7TO\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"5/22/2020\", \"examScope\": \"BC\"}, {\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"9/30/2019\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"12/20/1996\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 4, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 43, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"Alabama\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"9/7/2023\"}, {\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Arkansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"District of Columbia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Idaho\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Indiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Kansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Kentucky\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Maryland\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Mississippi\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Montana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Nevada\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"New Mexico\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Oregon\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"South Dakota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"10/15/2024\"}, {\"state\": \"Tennessee\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Texas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Texas\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Utah\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Vermont\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}, {\"state\": \"Wisconsin\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/4/2022\"}], \"registeredSROs\": [{\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "2783663",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 2783663, \"firstName\": \"Kirk\", \"middleName\": \"A\", \"lastName\": \"Mullen\", \"otherNames\": [\"KIRK ALLAN MULLEN\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"12/10/1996\"}, \"currentEmployments\": [{\"firmId\": 79, \"firmName\": \"J.P. MORGAN SECURITIES LLC\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"3/12/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"3702\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"35008\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"516348\", \"street1\": \"231 Greenwich Avenue\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"01/09/2023\"}]}], \"currentIAEmployments\": [{\"firmId\": 79, \"firmName\": \"J.P. MORGAN SECURITIES LLC\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"3/14/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"3702\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"35008\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"516348\", \"street1\": \"231 Greenwich Avenue\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"01/09/2023\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"iaSECNumber\": \"29938\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"16514\", \"firmId\": 5393, \"firmName\": \"CHARLES SCHWAB & CO., INC.\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"registrationBeginDate\": \"9/11/2009\", \"registrationEndDate\": \"3/28/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"45465\", \"firmId\": 31299, \"firmName\": \"BANCNORTH INVESTMENT GROUP, INC.\", \"city\": \"FISHKILL\", \"state\": \"NY\", \"registrationBeginDate\": \"5/5/2008\", \"registrationEndDate\": \"6/26/2009\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"23292\", \"firmId\": 7784, \"firmName\": \"FIDELITY BROKERAGE SERVICES LLC\", \"city\": \"SCARSDALE\", \"state\": \"NY\", \"registrationBeginDate\": \"12/8/2005\", \"registrationEndDate\": \"5/6/2008\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"44112\", \"firmId\": 29106, \"firmName\": \"E*TRADE SECURITIES LLC\", \"city\": \"JERSEY CITY\", \"state\": \"NJ\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"6/14/2005\", \"registrationEndDate\": \"12/6/2005\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"60469\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"23395\", \"firmId\": 7870, \"firmName\": \"TD WATERHOUSE INVESTOR SERVICES, INC.\", \"city\": \"OMAHA\", \"state\": \"NE\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"9/25/1996\", \"registrationEndDate\": \"6/17/2005\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"INACTIVE\"}], \"previousIAEmployments\": [{\"iaOnly\": \"Y\", \"iaSECNumber\": \"29938\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"16514\", \"firmId\": 5393, \"firmName\": \"CHARLES SCHWAB & CO., INC.\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"country\": \"United States\", \"registrationBeginDate\": \"9/21/2009\", \"registrationEndDate\": \"3/28/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"Y\", \"bdSECNumber\": \"31826\", \"firmId\": 15340, \"firmName\": \"PRIMEVEST FINANCIAL SERVICES, INC.\", \"city\": \"FISHKILL\", \"state\": \"NY\", \"country\": \"United States\", \"registrationBeginDate\": \"5/5/2008\", \"registrationEndDate\": \"6/26/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"Y\", \"iaSECNumber\": \"13243\", \"iaSECNumberType\": \"801\", \"firmId\": 104555, \"firmName\": \"STRATEGIC ADVISERS, INC.\", \"city\": \"SCARSDALE\", \"state\": \"NY\", \"country\": \"United States\", \"registrationBeginDate\": \"1/5/2006\", \"registrationEndDate\": \"4/3/2007\", \"firmBCScope\": \"NOTINSCOPE\", \"firmIAScope\": \"ACTIVE\"}], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 2, \"principalExamCount\": 1, \"productExamCount\": 2}, \"stateExamCategory\": [{\"examCategory\": \"Series 65\", \"examName\": \"Uniform Investment Adviser Law Examination\", \"examTakenDate\": \"8/23/2001\", \"examScope\": \"IA\"}, {\"examCategory\": \"Series 63\", \"examName\": \"Uniform Securities Agent State Law Examination\", \"examTakenDate\": \"9/30/1996\", \"examScope\": \"BC\"}], \"principalExamCategory\": [{\"examCategory\": \"Series 8\", \"examName\": \"General Securities Sales Supervisor Examination (Options Module & General Module)\", \"examTakenDate\": \"5/13/1998\", \"examScope\": \"BC\"}], \"productExamCategory\": [{\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"9/24/1996\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 26, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 5, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/3/2016\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/12/2014\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"5/19/2016\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/4/2016\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/12/2014\"}, {\"state\": \"New Jersey\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"3/14/2014\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/12/2014\"}], \"registeredSROs\": [{\"sro\": \"BOX Exchange LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BYX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BZX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe C2 Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGA Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"Investors' Exchange LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Long-Term Stock Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"MEMX LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"MIAX Emerald, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"MIAX PEARL, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"MIAX Sapphire\", \"status\": \"APPROVED\"}, {\"sro\": \"Miami International Securities Exchange, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE Arca, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE National, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE Texas, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq BX, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq GEMX, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq ISE, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq MRX, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq PHLX LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "4016917",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 4016917, \"firstName\": \"Lea\", \"middleName\": \"A\", \"lastName\": \"Garraffa\", \"otherNames\": [\"ARIEL GARRAFFA\", \"LEA ARIEL GARRAFFA\", \"LEA ARIEL GARRAFFA\", \"Lea Ariel Johnson\", \"Lea Johnson\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"7/20/2001\"}, \"currentEmployments\": [{\"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"6/1/2018\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"92798\", \"street1\": \"2 PICKWICK PLZ\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"05/21/2018\"}]}], \"currentIAEmployments\": [{\"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"6/1/2018\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"92798\", \"street1\": \"2 PICKWICK PLZ\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"05/21/2018\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"bdSECNumber\": \"69640\", \"firmId\": 269923, \"firmName\": \"EF LEGACY SECURITIES, LLC\", \"city\": \"Foxboro\", \"state\": \"MA\", \"registrationBeginDate\": \"4/22/2016\", \"registrationEndDate\": \"8/8/2017\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"66300\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"38325\", \"firmId\": 20580, \"firmName\": \"SANDERS MORRIS HARRIS LLC\", \"city\": \"Foxboro\", \"state\": \"MA\", \"registrationBeginDate\": \"10/21/2014\", \"registrationEndDate\": \"4/22/2016\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"city\": \"PURCHASE\", \"state\": \"NY\", \"registrationBeginDate\": \"6/1/2009\", \"registrationEndDate\": \"11/11/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"15869\", \"firmId\": 8209, \"firmName\": \"MORGAN STANLEY & CO. INCORPORATED\", \"city\": \"PURCHASE\", \"state\": \"NY\", \"registrationBeginDate\": \"4/2/2007\", \"registrationEndDate\": \"6/1/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"14172\", \"firmId\": 7556, \"firmName\": \"MORGAN STANLEY DW INC.\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"registrationBeginDate\": \"10/11/2005\", \"registrationEndDate\": \"4/2/2007\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"53059\", \"firmId\": 107726, \"firmName\": \"UBS INTERNATIONAL INC.\", \"city\": \"NEW YORK\", \"state\": \"NY\", \"country\": \"USA\", \"registrationBeginDate\": \"6/3/2002\", \"registrationEndDate\": \"2/23/2005\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"7163\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"16267\", \"firmId\": 8174, \"firmName\": \"UBS PAINEWEBBER INC.\", \"city\": \"WEEHAWKEN\", \"state\": \"NJ\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"12/12/2001\", \"registrationEndDate\": \"6/3/2002\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"7163\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"16267\", \"firmId\": 8174, \"firmName\": \"UBS PAINEWEBBER INC.\", \"city\": \"WEEHAWKEN\", \"state\": \"NJ\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"8/14/2000\", \"registrationEndDate\": \"10/4/2001\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}, {\"iaOnly\": \"N\", \"bdSECNumber\": \"3953\", \"firmId\": 1287, \"firmName\": \"J.C. BRADFORD & CO.\", \"city\": \"NEW YORK\", \"state\": \"NY\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"2/29/2000\", \"registrationEndDate\": \"8/14/2000\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"NOTINSCOPE\"}, {\"iaOnly\": \"N\", \"iaSECNumber\": \"58085\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"49730\", \"firmId\": 42159, \"firmName\": \"DLJDIRECT INC.\", \"city\": \"JERSEY CITY\", \"state\": \"NJ\", \"country\": \"UNITED STATES\", \"registrationBeginDate\": \"11/22/1999\", \"registrationEndDate\": \"2/14/2000\", \"firmBCScope\": \"INACTIVE\", \"firmIAScope\": \"INACTIVE\"}], \"previousIAEmployments\": [{\"iaOnly\": \"Y\", \"iaSECNumber\": \"64567\", \"iaSECNumberType\": \"801\", \"firmId\": 113299, \"firmName\": \"EDELMAN FINANCIAL SERVICES, LLC\", \"city\": \"MANSFIELD\", \"state\": \"MA\", \"country\": \"United States\", \"registrationBeginDate\": \"10/27/2014\", \"registrationEndDate\": \"8/8/2017\", \"firmBCScope\": \"NOTINSCOPE\", \"firmIAScope\": \"INACTIVE\"}, {\"iaOnly\": \"Y\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"city\": \"PURCHASE\", \"state\": \"NY\", \"country\": \"United States\", \"registrationBeginDate\": \"7/1/2013\", \"registrationEndDate\": \"11/11/2014\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 2, \"principalExamCount\": 1, \"productExamCount\": 2}, \"stateExamCategory\": [{\"examCategory\": \"Series 66\", \"examName\": \"Uniform Combined State Law Examination\", \"examTakenDate\": \"7/1/2013\", \"examScope\": \"BOTH\"}, {\"examCategory\": \"Series 63\", \"examName\": \"Uniform Securities Agent State Law Examination\", \"examTakenDate\": \"12/20/1999\", \"examScope\": \"BC\"}], \"principalExamCategory\": [{\"examCategory\": \"Series 9\", \"examName\": \"General Securities Sales Supervisor - Options Module Examination\", \"examTakenDate\": \"9/22/2003\", \"examScope\": \"BC\"}], \"productExamCategory\": [{\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"11/20/1999\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 6, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 33, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/12/2018\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2018\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2018\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"District of Columbia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/19/2024\"}, {\"state\": \"Idaho\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/15/2021\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Indiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"10/2/2019\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Maryland\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/14/2022\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/7/2019\"}, {\"state\": \"Nevada\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/15/2020\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/5/2018\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Oregon\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"2/26/2019\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/18/2024\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Tennessee\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"12/19/2018\"}, {\"state\": \"Texas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Texas\", \"regScope\": \"IA\", \"status\": \"APPROVED_RES\", \"regDate\": \"6/5/2018\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/19/2024\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}, {\"state\": \"Wisconsin\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/4/2018\"}], \"registeredSROs\": [{\"sro\": \"Cboe BYX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BZX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "5042405",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 5042405, \"firstName\": \"SARAH\", \"middleName\": \"A\", \"lastName\": \"WILLIAMS\", \"otherNames\": [\"SARAH A NAGGAR\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"2/3/2006\"}, \"currentEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"6/1/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/04/2012\"}, {\"displayOrder\": 2, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408673\", \"street1\": \"500 Post Road East\", \"street2\": \"3Rd Floor\", \"city\": \"Westport\", \"cityAlias\": [\"SAUGATUCK\", \"WESTPORT\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06880\", \"latitude\": \"41.137996\", \"longitude\": \"-73.34415\", \"geoLocation\": \"41.137996,-73.34415\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"07/17/2017\"}]}], \"currentIAEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"6/1/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/04/2012\"}, {\"displayOrder\": 2, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408673\", \"street1\": \"500 Post Road East\", \"street2\": \"3Rd Floor\", \"city\": \"Westport\", \"cityAlias\": [\"SAUGATUCK\", \"WESTPORT\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06880\", \"latitude\": \"41.137996\", \"longitude\": \"-73.34415\", \"geoLocation\": \"41.137996,-73.34415\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"07/17/2017\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"iaSECNumber\": \"3387\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"8177\", \"firmId\": 7059, \"firmName\": \"CITIGROUP GLOBAL MARKETS INC.\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"registrationBeginDate\": \"2/3/2006\", \"registrationEndDate\": \"6/1/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"previousIAEmployments\": [{\"iaOnly\": \"Y\", \"iaSECNumber\": \"3387\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"8177\", \"firmId\": 7059, \"firmName\": \"CITIGROUP GLOBAL MARKETS INC.\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"country\": \"United States\", \"registrationBeginDate\": \"1/29/2007\", \"registrationEndDate\": \"6/1/2009\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 2, \"principalExamCount\": 0, \"productExamCount\": 3}, \"stateExamCategory\": [{\"examCategory\": \"Series 65\", \"examName\": \"Uniform Investment Adviser Law Examination\", \"examTakenDate\": \"12/17/2006\", \"examScope\": \"IA\"}, {\"examCategory\": \"Series 63\", \"examName\": \"Uniform Securities Agent State Law Examination\", \"examTakenDate\": \"2/25/2006\", \"examScope\": \"BC\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 3\", \"examName\": \"National Commodity Futures Examination\", \"examTakenDate\": \"3/28/2007\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"2/2/2006\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 4, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 43, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"Alabama\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"9/21/2023\"}, {\"state\": \"Alaska\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/25/2018\"}, {\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Arkansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/9/2018\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"District of Columbia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Hawaii\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Idaho\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Indiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/4/2023\"}, {\"state\": \"Kentucky\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Maryland\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Montana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/20/2018\"}, {\"state\": \"Nevada\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"2/27/2018\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"New Mexico\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/1/2009\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/29/2022\"}, {\"state\": \"Oregon\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/26/2022\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Tennessee\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Texas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Texas\", \"regScope\": \"IA\", \"status\": \"APPROVED_RES\", \"regDate\": \"8/7/2010\"}, {\"state\": \"Utah\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Vermont\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/6/2010\"}, {\"state\": \"West Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/12/2015\"}, {\"state\": \"Wisconsin\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"2/17/2012\"}], \"registeredSROs\": [{\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "5294326",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 5294326, \"firstName\": \"SARA\", \"middleName\": \"A\", \"lastName\": \"THORSON\", \"otherNames\": [\"SARA ANDREAS THORSON\", \"SARA THORSON\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"6/29/2008\"}, \"currentEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"5/5/2017\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"05/05/2017\"}]}], \"currentIAEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"5/5/2017\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"05/05/2017\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"registrationBeginDate\": \"6/30/2008\", \"registrationEndDate\": \"5/8/2017\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"previousIAEmployments\": [{\"iaOnly\": \"Y\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"city\": \"GREENWICH\", \"state\": \"CT\", \"country\": \"United States\", \"registrationBeginDate\": \"11/6/2008\", \"registrationEndDate\": \"5/8/2017\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 1, \"principalExamCount\": 0, \"productExamCount\": 2}, \"stateExamCategory\": [{\"examCategory\": \"Series 66\", \"examName\": \"Uniform Combined State Law Examination\", \"examTakenDate\": \"11/4/2008\", \"examScope\": \"BOTH\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"6/27/2008\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 4, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 33, \"approvedIAStateRegistrationCount\": 1}, \"registeredStates\": [{\"state\": \"Alabama\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"10/10/2022\"}, {\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/7/2023\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/14/2023\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"10/5/2022\"}, {\"state\": \"Hawaii\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/19/2020\"}, {\"state\": \"Kansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/7/2023\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/29/2019\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Montana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/14/2023\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/11/2022\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/7/2023\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"8/7/2024\"}, {\"state\": \"Oregon\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/14/2023\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/14/2023\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/26/2024\"}, {\"state\": \"Tennessee\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/2/2025\"}, {\"state\": \"Utah\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/10/2023\"}, {\"state\": \"Vermont\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/17/2019\"}, {\"state\": \"West Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2017\"}, {\"state\": \"Wyoming\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/24/2025\"}], \"registeredSROs\": [{\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "5299847",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 5299847, \"firstName\": \"ANTHONY\", \"middleName\": \"A\", \"lastName\": \"CARPENTIERI\", \"otherNames\": [\"ANTHONY ALAN CARPENTIER\"], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"12/14/2010\"}, \"currentEmployments\": [{\"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"12/15/2010\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"311465\", \"street1\": \"2 PICKWICK PLZ\", \"street2\": \"PBIG - GREENWICH\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"08/31/2013\"}]}], \"currentIAEmployments\": [{\"firmId\": 7691, \"firmName\": \"MERRILL LYNCH, PIERCE, FENNER & SMITH INCORPORATED\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"3/16/2011\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"14235\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"7221\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"311465\", \"street1\": \"2 PICKWICK PLZ\", \"street2\": \"PBIG - GREENWICH\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"08/31/2013\"}]}], \"previousEmployments\": [], \"previousIAEmployments\": [], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 1, \"principalExamCount\": 0, \"productExamCount\": 2}, \"stateExamCategory\": [{\"examCategory\": \"Series 66\", \"examName\": \"Uniform Combined State Law Examination\", \"examTakenDate\": \"3/15/2011\", \"examScope\": \"BOTH\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"12/14/2010\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 6, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 44, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Arkansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"2/24/2025\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/16/2011\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"3/16/2011\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"District of Columbia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"2/20/2014\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Hawaii\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Idaho\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/9/2018\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Indiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Iowa\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"7/9/2024\"}, {\"state\": \"Kansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Kentucky\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"10/8/2019\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/18/2016\"}, {\"state\": \"Maryland\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Montana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Nevada\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"New Mexico\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/23/2011\"}, {\"state\": \"Oregon\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"12/20/2018\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Tennessee\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Texas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Texas\", \"regScope\": \"IA\", \"status\": \"APPROVED_RES\", \"regDate\": \"10/16/2013\"}, {\"state\": \"Utah\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Vermont\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"West Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/27/2020\"}, {\"state\": \"Wisconsin\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}, {\"state\": \"Wyoming\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/22/2011\"}], \"registeredSROs\": [{\"sro\": \"Cboe BYX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BZX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "707476",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 707476, \"firstName\": \"DANIEL\", \"middleName\": \"A\", \"lastName\": \"SULLIVAN\", \"otherNames\": [], \"bcScope\": \"Active\", \"iaScope\": \"NotInScope\", \"daysInIndustryCalculatedDate\": \"4/23/1980\"}, \"currentEmployments\": [{\"firmId\": 7320, \"firmName\": \"SHEARMAN, RALSTON INC.\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"4/24/1980\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"bdSECNumber\": \"21190\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"557879\", \"street1\": \"333 GREENWICH AVENUE\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"03/17/2014\"}, {\"displayOrder\": 2, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"94945\", \"street1\": \"333 GREENWICH AVENUE\", \"city\": \"GREENWICH\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"UNITED STATES\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"04/24/1980\"}]}], \"currentIAEmployments\": [], \"previousEmployments\": [], \"previousIAEmployments\": [], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 0, \"principalExamCount\": 2, \"productExamCount\": 5}, \"stateExamCategory\": [], \"principalExamCategory\": [{\"examCategory\": \"Series 4\", \"examName\": \"Registered Options Principal Examination\", \"examTakenDate\": \"4/22/1982\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 24\", \"examName\": \"General Securities Principal Examination\", \"examTakenDate\": \"9/29/1980\", \"examScope\": \"BC\"}], \"productExamCategory\": [{\"examCategory\": \"Series 99TO\", \"examName\": \"Operations Professional Examination\", \"examTakenDate\": \"1/2/2023\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 57TO\", \"examName\": \"Securities Trader Exam\", \"examTakenDate\": \"1/2/2023\", \"examScope\": \"BC\"}, {\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"10/1/2018\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 55\", \"examName\": \"Limited Representative-Equity Trader Exam\", \"examTakenDate\": \"3/1/2000\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"4/19/1980\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 1, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 4, \"approvedIAStateRegistrationCount\": 0}, \"registeredStates\": [{\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"3/17/2014\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"1/17/2024\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"5/5/2004\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"9/7/1981\"}], \"registeredSROs\": [{\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"General Securities Principal\", \"Full Registration/General Securities Representative\", \"Operations Professional\", \"Registered Options Principal\", \"Securities Trader\"]}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "7577871",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 7577871, \"firstName\": \"Bader\", \"middleName\": \"A\", \"lastName\": \"Hijleh\", \"otherNames\": [], \"bcScope\": \"Active\", \"iaScope\": \"NotInScope\", \"daysInIndustryCalculatedDate\": \"1/5/2023\"}, \"currentEmployments\": [{\"firmId\": 665, \"firmName\": \"PIPER SANDLER & CO.\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"1/6/2023\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"108049\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"15204\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"721383\", \"street1\": \"1 Greenwich Plaza\", \"street2\": \"Suite 111\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"06/13/2022\"}]}], \"currentIAEmployments\": [], \"previousEmployments\": [], \"previousIAEmployments\": [], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 1, \"principalExamCount\": 0, \"productExamCount\": 4}, \"stateExamCategory\": [{\"examCategory\": \"Series 63\", \"examName\": \"Uniform Securities Agent State Law Examination\", \"examTakenDate\": \"11/14/2023\", \"examScope\": \"BC\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"Series 7TO\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"3/1/2024\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 86\", \"examName\": \"Research Analyst Exam - Part I Analysis Module\", \"examTakenDate\": \"1/6/2023\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 87\", \"examName\": \"Research Analyst Exam - Part II Regulations Module\", \"examTakenDate\": \"9/12/2022\", \"examScope\": \"BC\"}, {\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"8/19/2022\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 11, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 1, \"approvedIAStateRegistrationCount\": 0}, \"registeredStates\": [{\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/14/2023\"}], \"registeredSROs\": [{\"sro\": \"Cboe BYX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BZX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGA Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\", \"Research Analyst\"]}, {\"sro\": \"Investors' Exchange LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE Arca, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq ISE, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "7578236",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 7578236, \"firstName\": \"Jacob\", \"middleName\": \"A\", \"lastName\": \"Lubell\", \"otherNames\": [], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"11/14/2022\"}, \"currentEmployments\": [{\"firmId\": 665, \"firmName\": \"PIPER SANDLER & CO.\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"12/6/2023\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"108049\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"15204\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"721383\", \"street1\": \"1 Greenwich Plaza\", \"street2\": \"Suite 111\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/04/2023\"}]}], \"currentIAEmployments\": [{\"firmId\": 665, \"firmName\": \"PIPER SANDLER & CO.\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"1/31/2024\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"108049\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"15204\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"721383\", \"street1\": \"1 Greenwich Plaza\", \"street2\": \"Suite 111\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/04/2023\"}]}], \"previousEmployments\": [{\"iaOnly\": \"N\", \"iaSECNumber\": \"28543\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"16791\", \"firmId\": 6363, \"firmName\": \"AMERIPRISE FINANCIAL SERVICES, LLC\", \"city\": \"Minneapolis\", \"state\": \"MN\", \"registrationBeginDate\": \"10/31/2022\", \"registrationEndDate\": \"11/20/2023\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\"}], \"previousIAEmployments\": [], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 1, \"principalExamCount\": 0, \"productExamCount\": 3}, \"stateExamCategory\": [{\"examCategory\": \"Series 66\", \"examName\": \"Uniform Combined State Law Examination\", \"examTakenDate\": \"2/28/2023\", \"examScope\": \"BOTH\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"Series 57TO\", \"examName\": \"Securities Trader Exam\", \"examTakenDate\": \"1/8/2024\", \"examScope\": \"BC\"}, {\"examCategory\": \"Series 7TO\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"10/29/2022\", \"examScope\": \"BC\"}, {\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"8/3/2022\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 11, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 1, \"approvedIAStateRegistrationCount\": 1}, \"registeredStates\": [{\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"12/6/2023\"}, {\"state\": \"Minnesota\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"1/31/2024\"}], \"registeredSROs\": [{\"sro\": \"Cboe BYX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe BZX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGA Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Cboe EDGX Exchange, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\", \"Securities Trader\"]}, {\"sro\": \"Investors' Exchange LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"NYSE Arca, Inc.\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq ISE, LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
},
{
"_id": "7840016",
"data": {
"hits": {
"total": 1,
"hits": [
{
"_type": "_doc",
"_source": {
"content": "{\"basicInformation\": {\"individualId\": 7840016, \"firstName\": \"Eileen\", \"middleName\": \"A\", \"lastName\": \"Carbin\", \"otherNames\": [], \"bcScope\": \"Active\", \"iaScope\": \"Active\", \"daysInIndustryCalculatedDate\": \"2/25/2024\"}, \"currentEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"N\", \"registrationBeginDate\": \"2/26/2024\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/11/2023\"}]}], \"currentIAEmployments\": [{\"firmId\": 149777, \"firmName\": \"MORGAN STANLEY\", \"iaOnly\": \"Y\", \"registrationBeginDate\": \"4/15/2024\", \"firmBCScope\": \"ACTIVE\", \"firmIAScope\": \"ACTIVE\", \"iaSECNumber\": \"70103\", \"iaSECNumberType\": \"801\", \"bdSECNumber\": \"68191\", \"branchOfficeLocations\": [{\"displayOrder\": 1, \"locatedAtFlag\": \"Y\", \"supervisedFromFlag\": \"N\", \"privateResidenceFlag\": \"N\", \"branchOfficeId\": \"408128\", \"street1\": \"One Fawcett Place\", \"street2\": \"3Rd Floor\", \"city\": \"Greenwich\", \"cityAlias\": [\"BELLE HAVEN\", \"GREENWICH\"], \"state\": \"CT\", \"country\": \"United States\", \"zipCode\": \"06830\", \"latitude\": \"41.039806\", \"longitude\": \"-73.625848\", \"geoLocation\": \"41.039806,-73.625848\", \"nonRegisteredOfficeFlag\": \"N\", \"elaBeginDate\": \"12/11/2023\"}]}], \"previousEmployments\": [], \"previousIAEmployments\": [], \"disclosureFlag\": \"N\", \"iaDisclosureFlag\": \"N\", \"disclosures\": [], \"examsCount\": {\"stateExamCount\": 1, \"principalExamCount\": 0, \"productExamCount\": 2}, \"stateExamCategory\": [{\"examCategory\": \"Series 66\", \"examName\": \"Uniform Combined State Law Examination\", \"examTakenDate\": \"4/15/2024\", \"examScope\": \"BOTH\"}], \"principalExamCategory\": [], \"productExamCategory\": [{\"examCategory\": \"Series 7TO\", \"examName\": \"General Securities Representative Examination\", \"examTakenDate\": \"2/26/2024\", \"examScope\": \"BC\"}, {\"examCategory\": \"SIE\", \"examName\": \"Securities Industry Essentials Examination\", \"examTakenDate\": \"9/24/2023\", \"examScope\": \"BC\"}], \"registrationCount\": {\"approvedSRORegistrationCount\": 4, \"approvedFinraRegistrationCount\": 1, \"approvedStateRegistrationCount\": 41, \"approvedIAStateRegistrationCount\": 2}, \"registeredStates\": [{\"state\": \"Alabama\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Arizona\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Arkansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"California\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Colorado\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Connecticut\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/15/2024\"}, {\"state\": \"Connecticut\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"4/15/2024\"}, {\"state\": \"Delaware\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"District of Columbia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Florida\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Georgia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Hawaii\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"6/12/2025\"}, {\"state\": \"Illinois\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Indiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Kansas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Kentucky\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Louisiana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Maine\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Maryland\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Massachusetts\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Michigan\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Minnesota\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Missouri\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"11/11/2024\"}, {\"state\": \"Montana\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"9/3/2024\"}, {\"state\": \"Nevada\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"New Hampshire\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"New Jersey\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"New York\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"North Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Ohio\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/18/2024\"}, {\"state\": \"Oklahoma\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Pennsylvania\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Puerto Rico\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Rhode Island\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"South Carolina\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Texas\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Texas\", \"regScope\": \"IA\", \"status\": \"APPROVED\", \"regDate\": \"4/19/2024\"}, {\"state\": \"Utah\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Vermont\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Virginia\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Washington\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Wisconsin\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}, {\"state\": \"Wyoming\", \"regScope\": \"BC\", \"status\": \"APPROVED\", \"regDate\": \"4/17/2024\"}], \"registeredSROs\": [{\"sro\": \"FINRA\", \"status\": \"APPROVED\", \"CategoriesList\": [\"Full Registration/General Securities Representative\"]}, {\"sro\": \"NYSE American LLC\", \"status\": \"APPROVED\"}, {\"sro\": \"Nasdaq Stock Market\", \"status\": \"APPROVED\"}, {\"sro\": \"New York Stock Exchange\", \"status\": \"APPROVED\"}], \"brokerDetails\": {\"hasBCComments\": \"N\", \"hasIAComments\": \"N\", \"legacyReportStatusDescription\": \"Not Requested\"}}"
}
}
]
}
},
"currentEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
},
"currentIAEmploymentLocation": {
"type": "Point",
"coordinates": [
-73.625848,
41.039806
]
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment