← back to Commercialrealestate
scripts/__pycache__/fetch-dre-mlo.cpython-314.pyc
113 lines
+
i�j$ � �� � R t ^ RIt^ RIt^ RIt^ RIt^ RIt]P P ]P P ]P P ]
4 4 4 t]P P ]RR4 t
RtRtRt0 RkRkR kR
kRkRkR
kRkRkRkRkRkRkRkRkRkRkRkRkRkRkRkRkRkRkR kR!kR"kR#kR$kR%kR&kR'kR(kR)kR*kR+kR,kR-kR.kR/kR0kR1kR2kR3kR4kR5kR6kR7kR8kR9kR:kR;kR<kR=kR>kR?kR@kRAkRBkRCkRDkREkRFkRGkRHkRIkRJkRKkRLkRMkRNkROkRPkRQkRRkRSkRTkRUkRVkRWkRXkRYkRZkR[kR\kR]kR^kR_kR`kRakRbkRckRdkRekRfkRgkRhkRikRjkRkkRlkRmkRnkRokRpkRqkRrkRskRtkRukRvkRwkRxkRykRzkR{kR|kR}kR~kRkR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�kR�ktR�R�R�R�R�R�/tR�tR� tR� tR� t]R�8X d
]! 4 R# R# )�u�
fetch-dre-mlo.py — Ingest CA DRE's daily "MLO List" (individual real-estate licensees
with a SAFE Act / NMLS mortgage-loan-originator endorsement) into data/loan-officers.json.
PERMITTED SOURCE (DATA_POLICY.md rule 1 = official_bulk_download):
Page: https://www.dre.ca.gov/Licensees/ExamineeLicenseeListDataFiles.html
File: https://secure.dre.ca.gov/datafile/mlo_list.xls (updated daily by CA DRE)
SCOPE (Steve, 2026-08-20): ACTIVE, INDIVIDUAL (Broker/Salesperson), LA-County only.
COMPLIANCE:
- Business/license fields only. address_line_1/2 + zip are DROPPED (rule 3 — no home address).
- phone_number is kept: it is published by a government source in this public file (rule 3 carve-out).
- Every row carries a real NMLS # + CalBRE # + the DRE source_url it came from (rule 4).
- Merges with (never clobbers) the verified firm-roster officers already in the file; dedup by NMLS #.
Run: python3 scripts/fetch-dre-mlo.py [--download] (default reuses /tmp/mlo_list.xls if present)
N�datazloan-officers.jsonz/https://secure.dre.ca.gov/datafile/mlo_list.xlszChttps://www.dre.ca.gov/Licensees/ExamineeLicenseeListDataFiles.htmlz/tmp/mlo_list.xlszAGOURA HILLS�ALHAMBRA�ARCADIA�ARTESIA�AVALON�AZUSAzBALDWIN PARK�BELLzBELL GARDENS�
BELLFLOWERz
BEVERLY HILLS�BRADBURY�BURBANK� CALABASAS�CARSON�CERRITOS� CLAREMONT�COMMERCE�COMPTON�COVINA�CUDAHYzCULVER CITYzDIAMOND BAR�DOWNEY�DUARTEzEL MONTEz
EL SEGUNDO�GARDENA�GLENDALE�GLENDORAzHAWAIIAN GARDENS� HAWTHORNEz
HERMOSA BEACHzHIDDEN HILLSzHUNTINGTON PARK�INDUSTRY� INGLEWOOD� IRWINDALEzLA CANADA FLINTRIDGEzLA HABRA HEIGHTSz LA MIRADAz LA PUENTEzLA VERNE�LAKEWOOD� LANCASTER�LAWNDALE�LOMITAz
LONG BEACHzLOS ANGELES�LYNWOOD�MALIBUzMANHATTAN BEACH�MAYWOOD�MONROVIA�
MONTEBELLOz
MONTEREY PARK�NORWALK�PALMDALEzPALOS VERDES ESTATES� PARAMOUNT�PASADENAzPICO RIVERA�POMONAzRANCHO PALOS VERDESz
REDONDO BEACHz
ROLLING HILLSzROLLING HILLS ESTATES�ROSEMEADz SAN DIMASzSAN FERNANDOzSAN GABRIELz
SAN MARINOz
SANTA CLARITAzSANTA FE SPRINGSzSANTA MONICAzSIERRA MADREzSIGNAL HILLzSOUTH EL MONTEz
SOUTH GATEzSOUTH PASADENAzTEMPLE CITY�TORRANCE�VERNON�WALNUTzWEST COVINAzWEST HOLLYWOODzWESTLAKE VILLAGE�WHITTIERzNORTH HOLLYWOODzVAN NUYSzSHERMAN OAKSzSTUDIO CITY�ENCINO�TARZANAzWOODLAND HILLSzCANOGA PARK�RESEDA�
NORTHRIDGEz
GRANADA HILLS�
CHATSWORTHz
SUN VALLEYz
PANORAMA CITY�SYLMAR�PACOIMAz
MISSION HILLSzVALLEY VILLAGE�VALENCIAzSTEVENSON RANCH�NEWHALL�SAUGUSzCANYON COUNTRY�CASTAICzMARINA DEL REYzPLAYA VISTAz
PLAYA DEL REY�VENICE�WESTCHESTERzPACIFIC PALISADES� BRENTWOOD� HOLLYWOODz
WEST HILLS�WINNETKAzLAKE BALBOA�ARLETAzLA CRESCENTA�MONTROSE�TUJUNGA�ALTADENA�TOPANGA�ACTONz
AGUA DULCEzQUARTZ HILL�
LITTLEROCKzLAKE HUGHESzLEONA VALLEYz VIEW PARKz
WINDSOR HILLSzLADERA HEIGHTSzHACIENDA HEIGHTSzROWLAND HEIGHTS�VALINDAzWEST PUENTE VALLEY�CITRUSzCHARTER OAKzEAST LOS ANGELESz
WEST WHITTIERzSOUTH WHITTIER�WILLOWBROOK�FLORENCEzWALNUT PARK�LENNOXzDEL AIRE�WESTMONTzLAKEVIEW TERRACEzSHADOW HILLS�SUNLANDzPORTER RANCHzHARBOR CITY�
WILMINGTONz SAN PEDRO�Brokerz$Real Estate Broker (MLO endorsement)�Salespersonz)Real Estate Salesperson (MLO endorsement)�Officerz%Real Estate Officer (MLO endorsement)c � � \ V \ 4 '