Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1089662026-07-11T23:47:30ZRebecca—Yang1938-01-02UHC-57862-85•••-••-163012785521609REBECCA.YANG@AOL.COM8845 Harbor BlvdLos AngelesCA90063GRP-1137SELECT-EPO
ENRENR-1174002026-07-26T03:59:52ZMartha··Fields1956-06-15UHC-93213-28•••-••-51614936616773martha.fields@icloud.com3247 Washington StAtlantaGA30310GRP-0801CORE-HMO
ENRENR-1098502026-09-15T07:52:44ZROYN.PALMER1945-02-26UHC-28102-09•••-••-1728·(777) 780-4815UNKNOWN9448 CHURCH STREETAUSTINTX78703GRP-4126·NAVIGATE-HMO
ENRENR-1277912026-01-05T06:08:24Zsarah C—murphy06/03/1964UHC-01157-30•••-••-0708547-354-9016—7273 PALM DRIVEScottsdaleAZ85237GRP-5136CHOICE-PLUS-PPO
ENRENR-1158212026-09-01T02:41:58ZJESSICAV.·CARPENTER19530608UHC-87434-60•••-••-9326N/AJESSICA.CARPENTER28@HOTMAIL.COM6742 Spring StreetMesaAZ85254GRP-7534MEDICARE-ADV-B
ENRENR-1032632026-08-07T00:38:07ZIsabellaH.Rice1960-09-07UHC-61073-78•••-••-62077652548767ISABELLA.RICE@OUTLOOK.COM6681 HARBOR BLVDChandlerAZN/AGRP-6334MEDICARE-ADV-B
ENRENR-1300972026-01-24T11:25:49Znatalie—jimenez—·UHC-11572-90UNKNOWN9358354476·-1836 River Rd··TEMPEAZ85249GRP-0687MEDICARE-ADV-B
ENR ENR-1305692026-05-26T01:14:53ZAlexander—Gardner2008-02-04UHC-74846-25—726-771-0646ALEXANDER.GARDNER73@HOTMAIL.COM8565 Indian School RoadDallastx75234GRP-9451OPTIONS-PPO
ENRENR-120072 2026-06-03T01:06:29ZJacob··Q.Allen2001-04-10·UHC-64592-60•••-••-2929(762) 917-3677JACOB.ALLEN44@ICLOUD.COM6594 Meadow LnMinneapolisMN55458GRP-2005NAVIGATE-HMO··
ENRENR-1205702026-07-28T15:50:35ZJeffreyWBlack06/10/1965UHC-98383-43NULL950-701-0525·jeffrey.black12@gmail.com3498 Ridge Rd··TucsonAZ··85779GRP-2285CHOICE-PLUS-PPO
ENRENR-1373552026-04-20T17:59:56ZDylanNOBrien1987-05-24UHC-78877-94•••-••-2474—dylan.obrien@outlook.com1413 Forest AvenueSeattleWA98124GRP-2615MEDICARE-ADV-A
ENRENR-1087332026-06-30T21:23:00ZDONALD—CASTILLO19420726UHC-10489-73•••-••-392015183424288NULL2970 Market StPhoenixArizona85095GRP-4492··SELECT-EPO
ENRENR-1415912026-09-20T14:10:07ZcarolynHcoleman1983-04-25UHC-26718-50•••-••-6701804-409-9216CAROLYN.COLEMAN@AOL.COM9842 Mesa DriveMiamiFL33199··GRP-3912MEDICARE-ADV-A
ENRENR-1293132026-05-28T15:28:36ZMarcusX.Yang1959-05-24··UHC-58969-79•••-••-3159932-615-2816marcus.yang86@hotmail.com4981 LAKE VIEW RDColumbus·OH43250GRP-5083NAVIGATE-HMO
ENRENR-1247352026-03-10T22:08:08ZBrian—Warren··1988-04-15UHC-45150-53null675-786-5821brian.warren5@yahoo.com3951 CENTRAL AVEChandlerAZ85206GRP-7445NAVIGATE-HMO
ENRENR-1261042026-08-17T01:59:28ZRANDYJGUZMAN1967-11-04UHC-25385-67•••-••-1430536.828.5274randy.guzman75@aol.com5574 Elm St #116HoustonTX77011GRP-5675medicare-adv-b
ENRENR-1023862026-01-01T16:24:12ZVirginia··—Vazquez1995-03-27··UHC3174521•••-••-07054975459151·virginia.vazquez77@gmail.com7732 Palm DrMesaAZ85230GRP-5319MEDICARE-ADV-B
ENRENR-1092612026-07-29T17:24:53ZBRIANEVAZQUEZ24-09-1961UHC-59626-83•••-••-1073(716) 468-9741N/A7029 CENTRAL AVE··Los AngelesCA90048GRP-6373NAVIGATE-HMO
ENRENR-1410832026-09-30T16:45:47ZSTEPHANIE—BROWN11/2/1980UHC-58523-40•••-••-4153·662.560.5636stephanie.brown67@outlook.com·7753 Desert Sky BoulevardJacksonville··FL32297GRP-9462CORE-HMO
ENRENR-101608 2026-09-21T04:24:24Z·FrancesSEspinoza1952-10-13UHC4154416•••-••-0279516-228-6927frances.espinoza@proton.me3576 Highland AveDallasTX75226GRP-6015CHOICE-PLUS-PPO
ENRENR-1300212026-04-01T08:04:43ZAustin····Cox2005-07-02UHC-98527-54•••-••-70435713295676-9511 Oak St Apt 20··Los AngelesCalifornia90013GRP-1502··SELECT-EPO··
ENRENR-1392822026-02-21T19:45:55ZDorothyULuna19811121UHC-96492-82•••-••-777819006863623dorothy.luna55@gmail.com8546 BASELINE ROAD Apt 6NashvilleTennessee37275GRP-6977SELECT-EPO
ENRENR-1305432026-05-05T15:51:37ZshirleyR.burns12/9/2007UHC-16290-25•••-••-00824508159234—227 RIVER RDMesaAZ85205GRP-7662··MEDICARE-ADV-A
ENRENR-1367292026-08-05T03:38:03ZCAMILAR··WELCH11/5/1978UHC-92057-12•••-••-9128+1 223 484 8121··camila.welch84@icloud.com8177 Central AvenueSeattleWA98197GRP-9995CHOICE-PLUS-PPO
ENRENR-1062262026-07-05T01:43:59ZAliceK.Chavez10/20/1956UHC-55445-57•••-••-8025(264) 578-0748ALICE.CHAVEZ6@GMAIL.COM4954 WILLOW COURTLas VegasNV89181GRP-3433CHOICE-PLUS-PPO
ENRENR-1010432026-06-24T17:17:23Z Freeman, MarkY.—2006-04-11UHC-14472-19NULL648-326-3859MARK.FREEMAN59@OUTLOOK.COM8601 Jefferson AveScottsdaleaz85277GRP-2809NAVIGATE-HMO··
ENRENR-1292072026-03-02T18:49:42ZLuisB··Thompson1969-01-01·UHC1069832•••-••-4761(607) 911-6912LUIS.THOMPSON@HOTMAIL.COM5642 Indian School RoadChandlerArizona85262-2991GRP-2902MEDICARE-ADV-A
ENRENR-1270162026-02-28T09:13:28ZJOHN··—HILLnullUHC-16787-11•••-••-86122995697305john.hill22@outlook.com4035 Ocean AveDenverCO80238GRP-9454CORE-HMO
ENRENR-128334 2026-06-27T22:20:55ZVictoria·QBarnes11/26/03UHC-54618-10•••-••-4676301-980-1147victoria.barnes@proton.me1900 OCEAN AVE··CharlotteNorth Carolina28251GRP-2183OPTIONS-PPO
ENRENR-1213872026-04-08T23:28:33ZBILLY—ROJAS12/16/1964UHC-53147-08•••-••-9492260-863-9450billy.rojas14@gmail.com9252 Market StTucsonAZ85708GRP-1817CORE-HMO
ENRENR-1042692026-08-22T05:53:28Zshirley—harvey··1994-12-25UHC-81817-78•••-••-7377(304) 415-2492SHIRLEY.HARVEY78@AOL.COM7830 Pine DrChandlerAZ85217-5898GRP-2524MEDICARE-ADV-B
ENRENR-1144282026-07-07T15:02:27ZMARCUSCREED1954-10-05UHC-81582-37NULL16823639021-9817 OAK STREET Apt 6ChandlerAZ85297GRP-6888SELECT-EPO
ENRENR-1093092026-06-04T16:10:54ZGrace I—Rice1/14/1947UHC-38233-38•••-••-4430nullGRACE.RICE53@ICLOUD.COM8097 Indian School Road··GlendaleAZ85337GRP-2565CHOICE-PLUS-PPO
ENRENR-1179962026-06-07T17:45:26ZJudyTGreen1954-03-23·UHC-95142-63•••-••-5208(839) 750-5599··-278 ELM STREETGlendaleAZ85377GRP-6354OPTIONS-PPO
ENRENR-1190542026-05-14T00:42:03ZKATHLEENZ···PARK08/09/94UHC-09672-42•••-••-2112263.628.9409KATHLEEN.PARK11@HOTMAIL.COM5014 Mountain View DriveSeattleWA98144GRP-8344CORE-HMO
ENRENR-1225112026-02-06T23:19:07ZHannahN.Graham··01/26/05UHC-42390-49•••-••-2703UNKNOWNHANNAH.GRAHAM@PROTON.ME3757 MEADOW LANEEden PrairieMN55364GRP-9133CHOICE-PLUS-PPO
ENRENR-1419902026-06-29T07:13:43ZTheresaJ.Sims01/16/1984UHC-55226-19··-(521) 885-1317UNKNOWN9244 Canyon RdJacksonvilleFL32261GRP-2973MEDICARE-ADV-A
ENRENR-1376022026-03-18T08:24:14ZKevin—Hunt1991-04-08UHC-33272-12··•••-••-670717133598236UNKNOWN3595 INDIAN SCHOOL RD #596Las VegasNV89118GRP-3164CORE-HMO
ENRENR-1003242026-05-11T08:40:41ZWei··—Murphy2/6/1978UHC-71874-98•••-••-51353379221307··wei.murphy@aol.com4588 Baseline RoadSeattleWA98151GRP-7582MEDICARE-ADV-A
ENR ENR-1094942026-04-03T12:18:56ZDonaldEPerry12-11-1982UHC-70218-31—(383) 411-5411donald.perry@yahoo.com243 Oak StreetTucsonAZ85794GRP-3875CHOICE-PLUS-PPO
ENRENR-1212062026-04-08T16:09:14ZCarlE.Schmidt09-05-1963UHC-97348-98•••-••-7596777-457-3348CARL.SCHMIDT18@OUTLOOK.COM1359 PINE DRIVEMesa·AZ85254-8854··GRP-2498SELECT-EPO
ENRENR-1316992026-05-29T22:16:11ZBarbaraQMendoza2007-01-02UHC-03073-98•••-••-44218963725268BARBARA.MENDOZA69@ICLOUD.COM8073 Sage CtLas VegasNevada89102-7575··GRP-5858CORE-HMO
ENRENR-1329642026-08-06T19:55:18ZDIANA—LITTLE7/5/1976UHC-64760-52•••-••-7805704.361.9723null346 JEFFERSON AVENUEEden PrairieMN55312-4729GRP-2681OPTIONS-PPO
ENR ENR-1215502026-05-26T12:47:42Z·Logan—Wang11/20/2000UHC-37033-56•••-••-3005(496) 628-9444LOGAN.WANG59@GMAIL.COM7493 Ridge Road·ScottsdaleArizona85245GRP-9175NAVIGATE-HMO
ENRENR-1313612026-07-21T10:25:46ZASHLEYZPHILLIPS1950-11-17UHC-94781-11•••-••-8256853.334.2954ashley.phillips83@icloud.com8536 Forest AveEden PrairieMN55380GRP-2856navigate-hmo
ENRENR-1230982026-08-27T16:27:29ZZacharyM·Jenkins5/23/1993UHC-94606-11•••-••-4841469-870-8876null3919 Bayshore DriveAtlantaGA30364GRP-6983select-epo
ENRENR-1313082026-09-12T11:39:48ZBRADLEY······MASON6/15/1974UHC-79120-53-936.401.0738bradley.mason@aol.com1000 RIDGE RD Apt 28San DiegoCA92152GRP-3171CHOICE-PLUS-PPO
ENRENR-1289192026-05-22T09:51:33Z RandyO.··Hlil1960-06-02UHC-78409-32•••-••-64016329036RANDY.HILL8@OUTLOOK.COM2962 Washington StColumbusOH—GRP-3212OPTIONS-PPO
ENRENR-1164712026-04-10T13:23:27ZKYLE—JENSEN08/01/54UHC-25407-01•••-••-1889334-422-9991·kyle.jensen31@hotmail.com5279 SPRING STREETLas Vegas·NV89131GRP-5980SELECT-EPO
ENRENR-1010402026-01-04T16:17:38ZAlexKMurphy8/22/1960UHC-07023-35•••-••-48276831073ALEXANDER.MURPHY@AOL.COM2012 Palm Dr··Eden PrairieMN55302GRP-1136MEDICARE-ADV-B··
43,101 rows, page 258 of 863PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:40.644Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty