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-1227332026-06-21T05:47:55ZMARIAESALAZAR1949-00-81UHC-89268-42•••-••-1808+1 840 961 0770maria.salazar@aol.com74 Valley View DrJacksonvillefl32288GRP-1351CORE-HMO
ENRENR-1146152026-09-30T13:48:10ZSEANUFIELDS1971-03-17UHC-34368-01•••-••-7983(469) 415-6981sean.fields@gmail.com··8945 Baseline RdChandlerArizona85275GRP-7230CHOICE-PLUS-PPO
ENRENR-1178802026-09-21T10:34:07ZCAROLMGUTIERREZ2000-09-08UHC-45287-35•••-••-6527869.542.7797CAROL.GUTIERREZ97@AOL.COM5447 Church StreetPlanoTXN/AGRP-8694OPTIONS-PPO
ENRENR-1171802026-07-22T02:58:37ZSophiaOBowman1968-08-22UHC-14385-23•••-••-43355154684263sophia.bowman@icloud.com4709 Highland AveDenver·CO80233GRP-9721MEDICARE-ADV-B
ENRENR-1210562026-08-31T14:30:25ZPATRICK····FISHER03-08-1985UHC-27825-83•••-••-4357(777) 329-5953-··7715 BASELINE RDMESAAZ85289··GRP-7287navigate-hmo
ENRENR-1181492026-04-06T01:48:54ZDianaVBowman1949-07-02UHC-94241-40•••-••-3091837-605-7654diana.bowman@yahoo.com3258 Forest AvenueTucsonaz85742GRP-9919MEDICARE-ADV-A
ENRENR-1097072026-05-06T17:41:58ZPadilla—Susan··1981-03-01UHC-73638-75•••-••-2986213.834.9397SUSAN.PADILLA46@GMAIL.COM2782 Central AvenueSeattleWA98182GRP-4147NAVIGATE-HMO
ENRENR-1096882026-10-15T08:28:21ZWalsh, WillieI.—1992-07-21UHC-23657-23•••-••-5706(975) 270-5924—8861 RIDGE ROADEden PrairieMN55313GRP-6210MEDICARE-ADV-B
ENRENR-136632 2026-02-06T18:47:25ZNicholasMGarcia·11/11/1964UHC-63689-60•••-••-3877NULLnicholas.garcia@gmail.com··9584 Hillcrest RdEden Prairie··MN55370GRP-1861CHOICE-PLUS-PPO
ENRENR-1312252026-03-08T07:51:43Z·Mariana—Peterson1998-12-07UHC-91604-29•••-••-7206770.636.2001mariana.peterson72@hotmail.com9813 Union StreetJacksonvilleFL··32205GRP-9145OPTIONS-PPO
ENRENR-1277102026-03-30T05:31:59ZRYAN—LI··10-09-1963UHC-59343-89•••-••-1924239.354.9599·ryan.li@icloud.com5648 Elm St··Fresno··CA93735GRP-6378CHOICE-PLUS-PPO
ENRENR-1057332026-03-26T05:39:53ZPAMELAJCONTRERAS··1991-04-02UHC-42414-79•••-••-7836(977) 716-6114pamela.contreras24@aol.com8748 ELM STLas VegasNV89196-0497GRP-4096CORE-HMO
ENRENR-1305382026-04-19T09:59:34ZJON—PETERSUN09/11/1958UHC-98787-15—13702107906·-8169 SUNSET BOULEVARDHoustonTexas77071-8490GRP-9677··SELECT-EPO
ENRENR-114797 2026-08-05T03:27:25ZCatherineQLe1988-06-17UHC-69971-20•••-••-45896457755746CATHERINE.LE67@GMAIL.COM8732 Hillcrest RoadGilbertAZ85205GRP-7944CORE-HMO
ENRENR-1397812026-07-19T08:53:18ZTerryCPayne04/07/2007UHC-95731-30··•••-••-8098730-329-4495terry.payne@gmail.com1535 Apache BoulevardAtlantaGA30323GRP-6109NAVIGATE-HMO
ENRENR-1370912026-04-18T15:12:12Z·PAMELAX·EDWARDS2002-04-27UHC5628229•••-••-6074nullNULL6075 Meadow LaneMesaAZ85215··GRP-0549MEDICARE-ADV-A
ENRENR-1165512026-08-18T07:59:45ZNatalieC.Nelson1944-03-01UHC-35218-06•••-••-7367(800) 939-7909natalie.nelson@yahoo.com402 RIDGE RDPlanoTX75056GRP-2602MEDICARE-ADV-B··
ENRENR-1022062026-03-09T14:24:06Z arthurN.mason1975-07-11UHC9578974•••-••-9442(337) 397-4367arthur.mason65@gmail.com5652 JEFFERSON AVENUE #776SAN ANTONIOtx78266·GRP-4362CHOICE-PLUS-PPO
ENRENR-1124632026-01-08T11:59:42ZEMILYTLITLTE02/24/1940UHC-13577-79•••-••-9844242.551.1162EMILY.LITTLE@YAHOO.COM6250 Willow CtLAS VEGASNV89138·GRP-1041MEDICARE-ADV-B
ENRENR-1296482026-07-17T12:06:19ZWheeler, TimothyN—1939-02-03UHC-43507-18•••-••-3464·2362790687timothy.wheeler36@gmail.com3238 Jefferson AveSan AntonioTX78239·GRP-7896·CORE-HMO
ENRENR-1254272026-10-03T10:12:01ZCunningham, Mason——19940609UHC-61288-67•••-••-52785032429mason.cunningham@aol.com5701 APACHE BLVDSan DiegoCA92112-1479GRP-4572···options-ppo
ENRENR-1132382026-05-06T21:27:43ZAngelaJNelson1952-06-24UHC-53462-83•••-••-3900—ANGELA.NELSON19@ICLOUD.COM9254 Forest AveMinneapolisMN55497GRP-0955··options-ppo
ENRENR-1417152026-03-12T03:08:20ZSAMANTHA—GIBSON1957-09-02··UHC-11351-96•••-••-9421821-201-5556SAMANTHA.GIBSON41@OUTLOOK.COM6973 Camelback RdPlanoTX··N/AGRP-1705CORE-HMO
ENRENR-1085372026-03-21T16:25:40ZOliver, WayneP—1976-04-07UHC-87651-90··•••-••-463417625235720wayne.oliver@yahoo.com365 Church Street··SacramentoCA95831GRP-8343MEDICARE-ADV-B
ENRENR-1266722026-05-29T11:49:41ZETHANBMARQUEZ2/26/1940UHC-16341-34•••-••-6602-ethan.marquez60@outlook.com··513 WASHINGTON STREETPHOENIXAZ85008GRP-0137NAVIGATE-HMO
ENRENR-1081972026-09-30T08:55:46ZVictoriaZSchmidt1988-06-12UHC-00189-24•••-••-44885377627244-4939 Church StGilbertArizona85276GRP-5352MEDICARE-ADV-A
ENRENR-1296312026-03-21T09:58:30ZMEGANVCARTER09/14/53UHC-16129-53·null467.407.1961megan.carter@yahoo.com2354 Canyon RdTUCSONArizona-GRP-0695CORE-HMO
ENRENR-1151332026-06-21T22:07:53ZJUANPBELL1953-01-03UHC-73306-19•••-••-2546·661-791-3840juan.bell@hotmail.com8862 HILLCREST ROADPHOENIX··AZ85021GRP-5579NAVIGATE-HMO
ENRENR-1329612026-05-01T09:55:22ZJulia—Hudson1988-05-01UHC-12835-65··•••-••-7331UNKNOWNJULIA.HUDSON18@AOL.COM3484 Maple AveEden Prairie··MN55357GRP-6656SELECT-EPO
ENRENR-1197902026-10-10T13:13:09Z·Benjamin—Garcia1939-10-07UHC6256650··•••-••-3849·7166680938BENJAMIN.GARCIA65@ICLOUD.COM5928 Market StJacksonvilleFL32254··GRP-1465NAVIGATE-HMO
ENRENR-1313752026-01-23T06:12:43ZMikeCHowell··1957-08-13UHC-32931-18•••-••-77048265136717michael.howell@outlook.com9001 Washington StreetJacksonvilleFLUNKNOWNGRP-3760MEDICARE-ADV-A
ENRENR-1162642026-09-02T12:44:20Z·AmebrGLawson09/26/62UHC-27031-71•••-••-57439679214070amber.lawson45@yahoo.com2988 Sunset BoulevardOrlandoFL32837GRP-9520MEDICARE-ADV-A
ENRENR-1233002026-07-27T03:28:44ZJackFLawson03/07/1992UHC-45514-20•••-••-8340205-940-5754JACK.LAWSON4@OUTLOOK.COM5849 CEDAR LN·ColumbusOhio43207GRP-0708MEDICARE-ADV-A
ENRENR-1241322026-05-21T08:37:54ZGregory—Campbell19-07-1994·UHC-68048-71UNKNOWN563-879-1987GREGORY.CAMPBELL79@GMAIL.COM3056 Lincoln WayScottsdaleAZ··85298GRP-2823CHOICE-PLUS-PPO
ENRENR-1097512026-04-04T19:37:56ZBRANDON—VARGAS1940-09-03UHC-62219-78•••-••-0956UNKNOWNUNKNOWN1647 Maple AveDallasTX75242GRP-9277·CHOICE-PLUS-PPO
ENRENR-1091422026-01-28T08:05:26ZCAROLR.CLARKUNKNOWNUHC-30064-04•••-••-87638272257839carol.clark93@hotmail.com··6078 LINCOLN WAYColumbusOH43226GRP-9795SELECT-EPO
ENRENR-1136162026-04-28T22:21:49ZLindaVMartin—UHC-10140-61•••-••-9398(218) 880-8792linda.martin27@gmail.com318 VALLEY VIEW DRIVEAUSTINTX78783GRP-1263MEDICARE-ADV-B
ENRENR-1405982026-04-30T15:55:08ZJeanG.Scott7/28/2008UHC-21473-47•••-••-6776824-350-1357·jean.scott@outlook.com8015 River RdMinneapolisMN55419GRP-9630core-hmo
ENRENR-1320962026-01-19T17:44:05Zbarbara··—bell··1978-10-25UHC-53380-72•••-••-16845579080129barbara.bell@yahoo.com9869 Lincoln WayMIAMI··FL33119GRP-5279OPTIONS-PPO
ENRENR-1384572026-01-19T16:51:14Z Julia···HThomas15-07-1956UHC-31006-41•••-••-2622(391) 323-8352julia.thomas@yahoo.com8342 Hillcrest RoadGlendaleAZ85348GRP-2264NAVIGATE-HMO
ENRENR-1079562026-09-14T22:58:03ZGary·AHernandez1973-05-06UHC-48744-09•••-••-9279(336) 971-1247gary.hernandez90@icloud.com8374 Central AveTempeAZ85208GRP-7317·OPTIONS-PPO
ENRENR-1108772026-01-13T16:54:26Zroy—ryan19971127NULL•••-••-2710(978) 704-6584roy.ryan@icloud.com4248 Union StGLENDALEAZ85310GRP-6103CORE-HMO··
ENRENR-1291412026-09-14T09:01:36Z PATRICK—ORTEGAJul 20, 2001UHC-45462-68•••-••-16132622405NULL··348 Cedar LnAtlantaGeorgia30305GRP-5629CHOICE-PLUS-PPO
ENRENR-1323252026-05-22T03:16:57ZChristineH.·Jensen1948-08-09UHC-15768-95•••-••-5567(665) 295-1829-1765 Mesa Dr··MINNEAPOLIS··MN55462GRP-2412CHOICE-PLUS-PPO
ENRENR-1028412026-02-21T02:30:19ZnoahLwillis1998-08-17UHC-64010-59•••-••-51347638263661noah.willis@aol.com916 Baseline RoadCharlottenc28225GRP-2082NAVIGATE-HMO
ENRENR-1317602026-09-27T15:26:18ZSAMUEL··—WALKER09/03/60UHC-47130-43•••-••-3401+1 595 242 5340samuel.walker@outlook.com2385 Lincoln WayGILBERTAZ85216GRP-2646MEDICARE-ADV-A
ENRENR-1081602026-10-13T16:24:29ZDAVIDVBURNS1955-03-06UHC-51090-99•••-••-9207(977) 924-0110david.burns87@yahoo.com3663 Park PlaceLos AngelesCA90007GRP-3029·NAVIGATE-HMO
ENRENR-1112402026-07-05T15:46:06ZGABBRIELQVAZQUEZ··Feb 21, 1954UHC2148163•••-••-19064397280630gabriel.vazquez83@yahoo.com529 BASELINE ROADAustinTexas78780GRP-6292CHOICE-PLUS-PPO··
ENRENR-1037772026-07-31T08:21:50ZYoung, Ruth——19890111UHC-18250-65null(678) 443-3901RUTH.YOUNG@YAHOO.COM3975 Ridge Rd #435NashvilleTN37244GRP-7747SELECT-EPO
ENRENR-1320072026-03-11T01:14:00ZBradley—Martinez1965-03-12UHC-69554-89•••-••-15505345007BRADLEY.MARTINEZ8@HOTMAIL.COM1459 BROADWAYSacramentoCA95889GRP-8468OPTIONS-PPO
43,101 rows, page 45 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:34.807Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty