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-1012022026-06-06T07:01:04ZRONALD—COOPER10/28/1946UHC-75874-34•••-••-7345····ronald.cooper@hotmail.com9401 UNION STREET··Las VegasNV89132GRP-7694MEDICARE-ADV-A
ENRENR-127354 2026-01-21T06:47:23ZMARIANAU.JACKSONNov 20, 1992UHC-36939-96NULL··(499) 631-0529—8346 Palm DriveAustintx78738GRP-7864OPTIONS-PPO
ENRENR-1243272026-04-29T03:11:18ZMEGAN—RYAN02/19/1962UHC-59968-26··•••-••-4553·7787820038megan.ryan92@outlook.com7424 Union StreetMiamiFL33161-5450GRP-7712MEDICARE-ADV-A
ENRENR-121120 2026-02-08T11:42:55ZSEAN··—ALLEN—UHC-74463-68—697-289-2673sean.allen93@gmail.com9243 UNION STREETSeattleWA98183·GRP-9838MEDICARE-ADV-A
ENRENR-1180792026-10-04T05:56:27ZSean····WrightSep 12, 1959UHC2300608•••-••-2542(569) 783-4276sean.wright@hotmail.com3748 Church StreetTempeAZ85297GRP-8165OPTIONS-PPO
ENR ENR-1178452026-06-06T13:39:53ZMcDonald, TheresaS—1945-11-19UHC-67029-07•••-••-3215·+1 722 987 6265·theresa.mcdonald69@gmail.com9572 Baseline RdGlendaleAZ85332GRP-1170MEDICARE-ADV-B
ENRENR-1243992026-01-24T19:24:41ZJacobT.Moreno1990-08-21··UHC-68222-61•••-••-8693(456) 685-3664jacob.moreno@icloud.com6877 Ocean AvenueOrlandofl32837GRP-7052MEDICARE-ADV-B
ENRENR-1050002026-03-19T10:08:35ZperezWronald1960-10-26UHC-55733-06•••-••-02957124833605RONALD.PEREZ@GMAIL.COM197 BroadwayEden PrairieMN55315GRP-5999MEDICARE-ADV-A
ENRENR-1322052026-05-15T08:01:31Zdebra—mendez·1960-06-24UHC4005684•••-••-2363+1 307 203 5142debra.mendez@yahoo.com4030 Palm DrCHARLOTTENC28247GRP-0158MEDICARE-ADV-B
ENRENR-1164262026-04-28T00:43:12ZJessica—Le02/20/01UHC9538227•••-••-1896396-713-2055jessica.le72@proton.me2209 HILLCREST ROAD #758··GlendaleAZUNKNOWNGRP-7352·MEDICARE-ADV-A
ENRENR-1049452026-05-26T16:12:21Z WILLIE—LEWRENCE·1981-01-26UHC-44326-19•••-••-6106(436) 248-9205willie.lawrence81@aol.com2641 FOREST AVENUEGilbertAZNULLGRP-3910CORE-HMO
ENRENR-1317912026-06-28T01:22:50ZsofiaI.··murray··1982-01-09UHC-35621-02•••-••-7871·(316) 591-2096sofia.murray@gmail.com679 Harbor BlvdSan DiegoCalifornia92150-6052GRP-6575NAVIGATE-HMO
ENRENR-1416302026-04-07T09:45:07ZDENISE—·ROBINSON7/23/1949UHC-87381-89•••-••-9527512-300-7821DENISE.ROBINSON23@AOL.COM2396 Washington StGilbertAZ85217-9663GRP-8844MEDICARE-ADV-B
ENRENR-1397372026-02-13T23:57:19ZSOFIA—MCCOY1945-07-01UHC-12731-65•••-••-243715383870124·UNKNOWN2722 Willow CourtScottsdaleAZ··85289GRP-2265CHOICE-PLUS-PPO
ENRENR-1209642026-07-20T15:14:33ZPamelaBRivera1959-06-01UHC-37756-28•••-••-317416346029670N/A6476 Baseline RoadAustinTX—GRP-9996MEDICARE-ADV-B
ENR ENR-1229712026-08-22T18:50:08Zwalter—·baker1999-03-23UHC-86359-86•••-••-93489879025711walter.baker79@yahoo.com8667 Hillcrest RoadSacramentoCA95810GRP-1742medicare-adv-b
ENRENR-1206102026-05-14T00:49:40ZalbertH.adams1948-07-19·UHC-15922-18•••-••-9996(514) 910-4821albert.adams30@aol.com8813 HIGHLAND AVENUEJacksonvilleFL32285GRP-0731SELECT-EPO
ENRENR-1261512026-08-16T04:09:55ZSANDRA—LEWIS2005-01-08UHC-17674-28•••-••-3262(679) 356-3349SANDRA.LEWIS@HOTMAIL.COM7524 Pine DrDallasTexas75290GRP-6182OPTIONS-PPO
ENRENR-1193092026-03-05T07:55:14ZBRENDA—SULLIVANJan 1, 1992UHC-04246-79•••-••-0201984.480.2930BRENDA.SULLIVAN@HOTMAIL.COM1728 Highland AveOrlandoFL·32890GRP-2453··NAVIGATE-HMO
ENRENR-1075752026-03-15T04:26:04ZMartha O.—Austin1992-04-23uhc-77689-57•••-••-65413203048096UNKNOWN4820 OCEAN AVENUEDenverCO80204GRP-1950NAVIGATE-HMO
ENRENR-1411902026-07-07T20:11:57Z·Bowman, Christna——10/08/90UHC-26516-08•••-••-4194·+1 547 589 1740—722 Cedar LnAustin·TX78724GRP-3774MEDICARE-ADV-B
ENRENR-1395172026-09-27T02:55:59ZKenHAustin··1999-05-12UHC-79067-76•••-••-9644(229) 559-8320kenneth.austin79@gmail.com9530 Forest AvenueMIAMIFL··33121-0992GRP-0615OPTIONS-PPO
ENRENR-1111332026-08-29T10:19:42ZAlicePHowardMay 11, 1990UHC-42065-41•••-••-0910+1 277 908 2283ALICE.HOWARD@GMAIL.COM8259 GRAND AVENUEFresnoCA93726GRP-7080SELECT-EPO
ENRENR-1187982026-06-21T16:13:08ZNoah—Padilla1965-09-11UHC-79799-16•••-••-816216376246682·NOAH.PADILLA87@YAHOO.COM6530 OAK STREETDenverCO80293-7864GRP-3451NAVIGATE-HMO
ENRENR-1044152026-09-23T23:51:14Z WayneHWang·1963-02-23UHC-60912-66•••-••-78154217820wayne.wang@hotmail.com9494 MARKET STJacksonvilleFL··32293GRP-5004··MEDICARE-ADV-B
ENRENR-1246752026-09-28T14:50:22ZMadisonK.Foster1997-01-06UHC-43664-25•••-••-7352884-669-2487NULL·954 Jefferson AvenueGilbertAZ85241GRP-9928MEDICARE-ADV-B
ENRENR-1226972026-03-19T05:49:26ZJORDANDVASQUEZ19920812UHC-45726-10•••-••-2816+1 942 499 7975jordan.vasquez@aol.comN/AUNKNOWN-NULLGRP-7788NAVIGATE-HMO
ENRENR-1079432026-07-17T14:56:49ZEmily—Wong1977-02-10UHC-39469-33•••-••-2151(527) 868-7953emily.wong11@outlook.com3028 MAPLE AVENUETampafl33624GRP-5146OPTIONS-PPO
ENRENR-1157512026-09-30T10:58:07ZFrances—Porter1962-08-20·UHC-44995-70•••-••-6710632.939.7159—5689 BAYSHORE DRLas Vegasnv··—GRP-1159OPTIONS-PPO
ENRENR-1322812026-03-09T07:31:15ZLAUREN····STONE··19601208UHC-98414-49•••-••-2338756-627-5581·lauren.stone@aol.com7831 Lincoln Way Apt 37MESAAZ85283GRP-6474·MEDICARE-ADV-A
ENRENR-111238 2026-01-20T01:35:27ZVazquez, GabrielQ··—Feb 21, 1954UHC-21481-63·NULL(439) 728-0630gabriel.vazquez83@yahoo.com529 Baseline RoadAustin·TX78780GRP-6292choice-plus-ppo
ENRENR-1290102026-08-19T17:28:14ZPrice, Danielle—····9/4/1967UHC-96670-88•••-••-4350868-523-7340··—1817 Union StMinneapolis·MN55422GRP-1869CORE-HMO
ENRENR-1156952026-06-22T16:49:13ZKim··I.Hunter1983-09-07UHC7574171NULL(728) 399-6473kimberly.hunter@gmail.com··3181 Forest AveSan AntonioTX78290GRP-0693MEDICARE-ADV-A
ENRENR-1386262026-09-08T07:23:01ZBRENDARNELSONNov 3, 1990UHC-48922-37•••-••-3408+1 513 964 6923brenda.nelson@yahoo.com2173 Indian School RoadTampaFL33643GRP-6353CORE-HMO
ENRENR-1369492026-05-08T00:51:25ZGregoryBRose1940-08-26UHC-54198-54•••-••-9639627-412-3865gregory.rose@aol.com7497 River RdTucson·az85766GRP-2983CHOICE-PLUS-PPO
ENRENR-1120652026-10-06T23:37:43ZHELEN—MASONNov 22, 1975UHC-65867-91•••-••-7192—HELEN.MASON68@ICLOUD.COM511 Cedar LanePhoenixAZ85009GRP-1792CORE-HMO
ENRENR-1236662026-02-09T15:29:18ZRachelQJacobs·1997-04-04UHC-30192-79UNKNOWN(473) 908-5402rachel.jacobs25@hotmail.com8448 Camelback RoadGilbert·AZ85206GRP-2237SELECT-EPO
ENRENR-1382762026-07-16T00:39:16ZKathleen—LeJun 8, 1987UHC-95340-31•••-••-66229124584030KATHLEEN.LE51@OUTLOOK.COM8323 BAYSHORE DRIVETucsonArizona85782GRP-8279SELECT-EPO
ENRENR-1247012026-04-08T21:02:17ZJoe—Fox1969-04-05UHC-72012-65•••-••-3467(558) 768-1049JOE.FOX@YAHOO.COM62 BROADWAYMesaAZ85295GRP-1293SELECT-EPO
ENRENR-1253002026-04-27T12:05:50ZBishop, CynthiaZ.—·1962-06-21UHC-36612-67•••-••-14316556477092CYNTHIA.BISHOP18@YAHOO.COM4621 PALM DROrlandoFL32872-1431GRP-3681··CHOICE-PLUS-PPO
ENRENR-1109952026-09-03T01:48:05ZShirleyM.Hamilton1967-04-03UHC-08692-04··•••-••-6407null—5292 Canyon RoadTempe·AZ85253GRP-7388MEDICARE-ADV-A··
ENRENR-1376192026-02-19T15:44:41ZRUSSELL—·BELL·1974-03-15UHC-78466-19•••-••-0713-russell.bell6@gmail.com2678 BroadwaySacramentoca95886GRP-7439CORE-HMO
ENRENR-1098102026-03-21T20:21:07ZSamantha·FGilbert8/28/1992UHC-63008-24•••-••-43832938126548—6946 Spring StLas VegasNevada89166GRP-7506MEDICARE-ADV-B
ENRENR-1121822026-06-05T09:01:44ZPAMELA·EHOAWRD1986-05-18UHC-75617-34•••-••-8761545-618-1209pamela.howard@aol.com4856 Meadow LaneSan DiegoCA92116GRP-6562MEDICARE-ADV-B
ENRENR-1392322026-02-19T13:45:04ZWells, TerryG—1979-08-25UHC-40621-57•••-••-9857476-468-3172terry.wells@hotmail.com818 Baseline RoadMinneapolisMinnesota55497GRP-0525CHOICE-PLUS-PPO
ENR ENR-111297 2026-05-17T07:05:47ZRACHELJBARNES03/17/1963UHC2800664—8755539012rachel.barnes@outlook.com1369 Park PlaceTampaFL33691GRP-4988OPTIONS-PPO
ENRENR-1022242026-07-18T07:12:05ZlindaO.weaver1977-09-12UHC-32789-96•••-••-4279(249) 203-9547null4204 WASHINGTON STTempeAZ85227GRP-2499SELECT-EPO
ENRENR-1407392026-04-01T07:24:30ZSarahS.··Dunn19660416UHC-26514-98•••-••-7421—-4136 Grand AveDallasTX·nullGRP-8424options-ppo
ENRENR-1366222026-10-02T06:32:13ZHELEN—LUCAS24-09-1961uhc-64236-44•••-••-9453675-501-0390HELEN.LUCAS@PROTON.ME1643 Washington StLos AngelesCA··90032GRP-3559·OPTIONS-PPO
ENRENR-1235482026-08-02T04:41:22ZBruceVHolmes03-02-1987··UHC-07074-32•••-••-3219841.409.3230bruce.holmes99@outlook.com4044 GRAND AVEMinneapolisMN55423GRP-1662SELECT-EPO
43,101 rows, page 330 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:43.625Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty