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-1316822026-01-26T05:48:36ZSandra—Harrison1957-10-15UHC-67070-46•••-••-05314985179661sandra.harrison@outlook.com4297 Sage CtPHOENIXAZ85071GRP-9249MEDICARE-ADV-A
ENRENR-1302142026-07-14T15:04:35Z·Mateo—Lawson11/14/1952uhc-72989-27•••-••-6912UNKNOWNmateo.lawson@gmail.com123 Forest AveJacksonvilleFL32246··GRP-4663CORE-HMO
ENRENR-1166202026-09-03T08:25:27ZgraceVarmstrong1956-04-27·UHC-82000-99UNKNOWN18414837781null··8239 Church StTempeAZ85230GRP-5352·MEDICARE-ADV-A
ENRENR-1002862026-05-21T05:25:40ZKaylaXMrogan1972-12-05UHC-94672-93•••-••-8512742-695-8646—2754 Church StPlanoTX75033GRP-5656SELECT-EPO
ENRENR-1161382026-10-07T09:26:23ZCharlotte·Q.Espinoza2002-11-21UHC-63127-60•••-••-6685398.608.5252—·2513 OAK STREET·Los AngelesCA90042GRP-2460CORE-HMO
ENRENR-1004062026-03-29T15:49:09ZBrianDRyan1973-08-28UHC-30695-21•••-••-5071—BRIAN.RYAN33@YAHOO.COM726 Ocean AvenueDENVERCO80291·GRP-9279MEDICARE-ADV-A
ENRENR-1278862026-06-08T06:16:21ZMarianaAPark··02-07-1948·UHC-45550-71•••-••-9642(391) 595-6107NULL9835 Canyon RdSCOTTSDALE··AZ85216GRP-2297NAVIGATE-HMO
ENRENR-1100262026-04-06T22:15:57ZBettyKButler1956-11-26UHC-72899-24•••-••-3003—N/A1390 Jefferson Avenue··DallasTX··75228GRP-5697MEDICARE-ADV-A
ENRENR-1209752026-05-07T22:12:07ZKARENOMONTGOMERY10/28/1949uhc-84155-80•••-••-8177(513) 286-2299karen.montgomery@aol.com6291 Oak StLas VegasNV89185-6912GRP-1050OPTIONS-PPO
ENRENR-1381862026-08-30T09:17:21ZKevinQ.Perez19890924UHC-61731-59•••-••-182113204814309·kevin.perez@gmail.com6212 Ocean AveGlendaleArizona85377GRP-0756MEDICARE-ADV-B
ENRENR-1226512026-03-11T06:33:38ZALANCGARRETT1989-09-20·UHC-39357-72•••-••-2937805-853-9740alan.garrett@hotmail.com1894 Maple Avenue·SeattleWA98168GRP-2957SELECT-EPO
ENRENR-1213832026-08-19T15:25:32ZEdwardKCox19780711UHC-66170-72•••-••-2682+1 429 891 3946—8251 Sage Court···Houston·TX77023GRP-4730SELECT-EPO··
ENRENR-1282862026-10-11T09:40:46ZZACHARY—SNYDER1960-12-15UHC-27124-93•••-••-0230459-653-5306zachary.snyder26@gmail.com6294 Ocean AvenueSacramentoCA95875GRP-2511NAVIGATE-HMO
ENRENR-1001272026-03-31T04:59:35Zmei—arnold07/03/77UHC-42188-83•••-••-1108(252) 525-9720MEI.ARNOLD55@AOL.COM4985 Church StMIAMIFL33165GRP-7104SELECT-EPO··
ENR ENR-1043862026-04-10T12:46:17ZRachelKHughes1969-06-06UHC-06997-78•••-••-0066·538-412-6473-3782 MEADOW LNGlendaleAZ85328GRP-1331CHOICE-PLUS-PPO
ENRENR-1017592026-08-07T20:56:19Znicole—simpson11/11/1969UHC-07493-84•••-••-89473016101518nicole.simpson@hotmail.com802 Ridge RoadNASHVILLETennessee37233GRP-8929MEDICARE-ADV-A
ENR ENR-1090232026-03-30T00:53:23ZJonathanA.Johnson1946-02-08UHC-35364-89•••-••-7367442-858-6235jonathan.johnson@outlook.com2808 BroadwayDallasTX75208GRP-8559MEDICARE-ADV-B
ENRENR-1226922026-09-08T22:34:30ZLAWRENCEZALEXANDER1942-01-01UHC-22677-64•••-••-71722714507162lawrence.alexander@outlook.com3342 CAMELBACK ROADFresnoCA93764GRP-6896SELECT-EPO
ENRENR-1103792026-05-07T02:43:57ZMARIANA—TAYLOR1987-02-21UHC-86198-41•••-••-3674497-611-2265—2427 Union StGilbertAZ85201GRP-2416·NAVIGATE-HMO
ENRENR-1166792026-08-18T01:54:33Z TyerV.Ramos·1991-06-10UHC-39669-09•••-••-28369033695033tyler.ramos@yahoo.com-N/A——GRP-2804OPTIONS-PPO
ENRENR-1329222026-08-15T01:44:48ZMarianaPSullivan1979-11-09UHC9557794•••-••-5107nullmariana.sullivan22@hotmail.com634 UNION STREETJacksonvilleFL32227GRP-2119MEDICARE-ADV-B
ENRENR-1114242026-05-30T10:52:39ZISABELLAB··LIMar 28, 1992UHC-81197-69•••-••-27715087870535ISABELLA.LI@OUTLOOK.COM2254 PALM DRFRESNOCA93780GRP-7472CORE-HMO
ENRENR-1003562026-01-05T23:17:42ZNoah—Avlarez19520324UHC-34963-51··•••-••-0034·(908) 328-2125·noah.alvarez@gmail.com7184 Sunset BlvdFRESNOCalifornia93715GRP-5162CHOICE-PLUS-PPO
ENRENR-1423792026-01-03T22:15:16ZJOHN··DLUNA1982-01-25UHC-17026-93•••-••-1762(519) 817-3775john.luna@proton.me2837 Jefferson AvenueMesaAZ85294GRP-6605OPTIONS-PPO
ENRENR-1399322026-10-12T09:03:45ZCARLOS—HUNTER—UHC-80261-25null5566620380carlos.hunter4@hotmail.com1875 Church StreetAustinTX78747GRP-9790NAVIGATE-HMO
ENRENR-1398842026-04-06T13:06:01ZMariaRGreene03/10/1981UHC-79831-39•••-••-1461693-407-8883—2309 Market StLas VegasNV··89167GRP-7766CHOICE-PLUS-PPO
ENRENR-1270192026-08-07T22:22:17ZLarry····Burton2005-06-17UHC-70176-42··•••-••-0782(565) 518-2697—1949 Cedar LnTucsonAZ85722-7495GRP-8821SELECT-EPO
ENRENR-1133362026-08-14T18:55:17Z benjaminR.guerrero1983-12-14UHC-15470-67•••-••-5722NULLN/A7051 Central Avenue #523·FRESNOCA93731GRP-9879MEDICARE-ADV-A
ENRENR-1025122026-06-10T15:17:10ZralphRperry2003-07-19UHC-41084-85•••-••-8262+1 849 500 4457RALPH.PERRY59@GMAIL.COM775 Union StreetPHOENIXaz85069GRP-9697CHOICE-PLUS-PPO
ENRENR-1047152026-08-21T22:58:59ZYUKINMCDONALD0771-19-41··UHC-33344-40•••-••-8962UNKNOWNYUKI.MCDONALD66@HOTMAIL.COM8386 SPRING STREETSacramentoCA···95893GRP-9215·CHOICE-PLUS-PPO
ENRENR-1080172026-08-27T23:30:46Z AdamR.Collins1975-06-08UHC1443870•••-••-0906399-584-8023ADAM.COLLINS35@HOTMAIL.COM2667 Canyon Rd·TucsonAZ85765-5842GRP-6152MEDICARE-ADV-B
ENRENR-1240822026-08-04T02:19:27ZEMMAXBERRY16-12-1961UHC-48557-53•••-••-74252518961167emma.berry@aol.com5470 Jefferson AvenueAUSTINTX78763GRP-9685MEDICARE-ADV-A
ENRENR-1043912026-06-24T08:04:03ZDorothyWRogers9176-08-24UHC-06003-66•••-••-6095340-719-9887—NULL--N/AGRP-2523CHOICE-PLUS-PPO
ENRENR-1398722026-02-15T12:12:12ZKarenNMitchell02-09-1949UHC8073037•••-••-639317896356262—5453 Spring StLOS ANGELESCA90075GRP-9293CHOICE-PLUS-PPO
ENRENR-1249662026-06-22T04:59:30ZAshleyDHall·03/15/2002UHC-12898-35•••-••-2866268-597-7492UNKNOWN5373 Jefferson Avenue Apt 27·NashvilleTN37281GRP-8893SELECT-EPO
ENRENR-1397252026-08-07T07:14:47ZHannahOArnold19890616uhc-81185-17•••-••-1328(369) 956-2370HANNAH.ARNOLD89@AOL.COM4860 Desert Sky BlvdCharlotteNC28277-1264GRP-1000··NAVIGATE-HMO
ENRENR-1014802026-06-20T05:39:46ZVictoriaI.Wilson1951-06-12UHC-11161-09•••-••-9480934.663.1750-9848 INDIAN SCHOOL RDJacksonvilleFL32289GRP-4347·OPTIONS-PPO
ENRENR-1339742026-01-17T22:58:48ZCHRISTINAFJACOBS1961-08-11UHC-68007-46•••-••-78892420275··CHRISTINA.JACOBS@ICLOUD.COM2890 Central AvenueFresnoCA93736GRP-9501MEDICARE-ADV-A
ENRENR-1315492026-09-06T05:44:33ZLoriW—19510315··UHC-50744-71•••-••-2750445-651-7797lori.evans42@hotmail.com3221 Canyon Road·MinneapolisMN55406GRP-9124OPTIONS-PPO
ENRENR-1019022026-04-15T14:39:35ZScott····Schmidt1974-11-14UHC-45714-72•••-••-8452(440) 865-0735SCOTT.SCHMIDT@OUTLOOK.COM8648 WASHINGTON STREETMesa··AZ85226GRP-2969OPTIONS-PPO
ENRENR-1345282026-01-14T17:14:12ZGloriaAFernandez1954-01-05UHC-87618-90•••-••-1402+1 748 438 0394GLORIA.FERNANDEZ34@HOTMAIL.COM··615 Lake View RdDallasTX75279GRP-3535navigate-hmo
ENRENR-1299662026-05-18T17:26:38ZFranecsKHowell09/20/89UHC-41842-16•••-••-8661(875) 654-8544frances.howell@icloud.com·5564 Union St·Tampa·FL33694··GRP-6013MEDICARE-ADV-B
ENRENR-1160092026-05-26T00:49:43ZNancy—Lewis1984-11-14UHC-97623-93··•••-••-9718299-527-2899N/A6223 VALLEY VIEW DRIVEAustinTX78732GRP-0800NAVIGATE-HMO
ENRENR-1125882026-04-15T01:52:56ZStephenKSoto05/05/40UHC-60749-62•••-••-2535(954) 515-7177stephen.soto34@outlook.com3987 Sage CourtCOLUMBUSOH43295GRP-8143CHOICE-PLUS-PPO
ENRENR-1218552026-07-09T21:04:02Z·MARCUS—NGUYEN1981-01-17UHC-61216-08•••-••-3109(604) 421-1221marcus.nguyen@hotmail.com8499 FOREST AVENUEHoustonTexas·77037GRP-3581OPTIONS-PPO
ENRENR-1243672026-10-07T15:29:28Z LuciaIGuerrero1979-04-01UHC-85694-87•••-••-9799446-919-7984LUCIA.GUERRERO@GMAIL.COM8907 Mountain View DriveGlendaleAZ85379GRP-0747MEDICARE-ADV-A
ENRENR-1146002026-01-12T11:20:10ZMichaelR.Davis8/5/1954uhc-14997-20•••-••-0872(906) 463-1628null9821 Hillcrest RoadTampaFL—GRP-3902NAVIGATE-HMO
ENR ENR-1232262026-03-20T02:32:08ZVincentCBanks16-03-1946UHC-27226-33•••-••-0014857-389-6885vincent.banks@hotmail.com1385 MEADOW LANECharlotteNC28264GRP-0903SELECT-EPO
ENRENR-1203462026-08-30T21:26:51ZRANDYKSOTO03-03-1969UHC7980096•••-••-568817264909914randy.soto22@hotmail.com368 Ridge RoadTucsonAZ85782GRP-6669NAVIGATE-HMO
ENRENR-1370592026-10-08T20:36:19ZPatrickBJacoobs1971-01-09UHC-46572-14•••-••-7181921-329-8293patrick.jacobs5@hotmail.com2987 Elm StreetEden PrairieMN55389GRP-2816·SELECT-EPO
43,101 rows, page 123 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:37.764Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty