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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1018882026-09-19T16:20:00ZAMANDA—MARSHALL1952-06-22UHC-03865-31•••-••-73489524022435UNKNOWN1064 Ocean AveGILBERTArizona··85283GRP-7146CORE-HMO
ENRENR-1290862026-01-27T04:53:17ZSean—Yang··1978-12-20UHC-75066-21•••-••-2096698-901-9021··sean.yang@hotmail.com7871 Desert Sky BoulevardMIAMIFL·33194GRP-0605OPTIONS-PPO
ENRENR-1252932026-02-16T01:02:16ZGLORIAQROSS08/24/1983··UHC-95778-74•••-••-1502NULLUNKNOWN·4616 Forest Ave #308MinneapolisMN·55498GRP-3774MEDICARE-ADV-B
CLMCLM-4057892026-01-04T13:03:23ZSTEPHEN—LEWIS1958-03-04UHC-80754-67UNKNOWNUNKNOWN-··7899 Church StMiamiFlorida··33177GRP-5956—
CLMCLM-4287052026-05-18T04:23:58ZCarlson, Kathryn——12/07/1939—•••-••-08845548083216··—2320 Highland AvenueLas Vegas··NV89109··GRP-9965·CORE-HMO
ENRENR-1172922026-06-12T09:19:28ZLoganAPhillips1966-04-21UHC-58593-18····460.919.6479logan.phillips87@icloud.com3710 Mountain View Dr Apt 32OrlandoFL32851GRP-9869NAVIGATE-HMO
CLMCLM-4070172026-09-08T04:51:23ZdavidG.henry01/25/1964UHC-48679-36—N/AN/A·4431 HARBOR BOULEVARDCharlotteNC28202-5659GRP-4908OPTIONS-PPO
ENRENR-1094782026-03-09T14:14:20ZLewis, Roger——02/03/56UHC-29701-15•••-••-6736(861) 490-5018—5339 Ridge RdDallasTX75210GRP-3957CORE-HMO
ENRENR-1201142026-07-11T13:54:59ZseanSmeyer1949-11-03UHC-75769-78—4655735390null158 Mesa DriveTucsonAZ85781GRP-9708MEDICARE-ADV-A
CLMCLM-4134792026-02-26T03:08:42Z·Carol··Gonzalez12/08/89N/A—(549) 461-4146··carol.gonzalez@yahoo.com6677 Cedar LnPhoenixAZ85098GRP-6923NAVIGATE-HMO
CLMCLM-4310352026-02-04T16:23:38ZRobert—Patterson1982-10-18UHC-46621-18null·803-870-0883UNKNOWN··8502 Ridge RdPHOENIXAZ85004-6334GRP-0612CHOICE-PLUS-PPO
TPATPA-626262026-10-18T14:14:33ZJohnston, Gerald——19380521NULLN/A3935165250N/A—UNKNOWN—N/A-OPTIONS-PPO
ENRENR-1046552026-03-03T07:40:24Z Andrew—Padilla1984-08-21UHC-80718-14•••-••-0102745-251-9577ANDREW.PADILLA@GMAIL.COM902 MARKET STDallasTX75267GRP-5650core-hmo
ENRENR-1142212026-06-17T02:47:48ZANDREACMARSHALL1975-04-27UHC1110001•••-••-7328597-745-3596ANDREA.MARSHALL12@HOTMAIL.COM3932 Mesa DrMiamiFL33180·GRP-4878CHOICE-PLUS-PPO
CLMCLM-4261712026-03-13T00:10:05ZRyan—·Nunez1992-02-02UHC-99721-27—-UNKNOWN—-null—UNKNOWN····
ENRENR-1186392026-02-10T11:59:51ZWEIKFLORES1946-10-15UHC-45273-71•••-••-23798686401554N/A2163 Union StreetEDEN PRAIRIEMinnesota55343GRP-2280SELECT-EPO
TPATPA-570052026-08-29T03:54:14ZAlexander—Johnston2006-02-24-—N/AALEXANDER.JOHNSTON@AOL.COM·3793 Lake View Rd Apt 3GilbertAZ85247-0887GRP-4198MEDICARE-ADV-B
CLMCLM-4086892026-07-11T16:10:01ZEugene—Watkins17-10-1997UHC-86450-26-701.829.3443UNKNOWN9178 PARK PLACESCOTTSDALE·Arizona85294GRP-1587MEDICARE-ADV-A
ENRENR-135578 2026-06-01T14:39:45ZMATTHEWPSANCHEZ05/13/75UHC-20584-91•••-••-1694838.733.2068MATTHEW.SANCHEZ74@ICLOUD.COM1626 Park Pl Apt 23TempeAZ85298GRP-8919MEDICARE-ADV-B
CLMCLM-4212432026-04-16T21:06:19ZBarbara—Aguilar1997-08-24UHC-82036-55—-—4233 Ocean AvenueSeattleWA98179GRP-5733—
ENRENR-1161132026-01-17T07:15:49Z LarryM·Lna1971-06-18UHC-37316-70··•••-••-4016946.962.3959larry.luna79@icloud.com9021 WILLOW CTColumbusOH43275GRP-3342MEDICARE-ADV-A
ENRENR-1425602026-03-07T04:30:16ZHANNAHX.DOMINGUEZ1942-05-23··UHC-10928-36•••-••-969719067238081HANNAH.DOMINGUEZ1@YAHOO.COM2610 MAPLE AVEGilbert··AZ85234GRP-9386OPTIONS-PPO
ENRENR-1359232026-10-05T12:25:50Z·RUSSELLEMURRAY06/02/1946UHC6088205•••-••-61683746386—2644 Ridge RoadPHOENIXAZ85034GRP-2456NAVIGATE-HMO
PRVPRV-218582026-07-12T18:52:12ZRamos, Betty——19440117·uhc-55325-32null882-660-6445—9450 Valley View DriveTucsonAZ85774—SELECT-EPO
ENRENR-1365392026-07-16T17:01:17ZLganQTranMay 11, 1997UHC2636290•••-••-6517729-650-0155logan.tran22@yahoo.com4762 CANYON ROADPlanoTX75057-0040GRP-9638CORE-HMO
ENRENR-1269162026-03-19T18:01:04ZKnight, RobertG—2008-07-21UHC-16048-80··•••-••-070314059524641robert.knight22@proton.me2299 Lincoln WayMiamiFL33146-1658GRP-4887MEDICARE-ADV-B
TPATPA-503392026-09-06T20:30:34ZMargaret—Pena1985-10-06-null(935) 832-8314-978 Market StreetEden PrairieMN55319N/AOPTIONS-PPO
CLMCLM-4300862026-06-12T20:23:57ZButler, Amy——·Jun 20, 1959—•••-••-2753nullnull··1003 Harbor BoulevardTUCSONAZ85753UNKNOWNMEDICARE-ADV-A
ENRENR-1125592026-01-18T13:26:13ZKennedy, Randy——11/01/54UHC-29773-41····(973) 227-4314RANDY.KENNEDY@YAHOO.COM5003 Union StreetLas VegasNV·89159GRP-9958MEDICARE-ADV-A
ENRENR-1246772026-05-20T10:02:32ZETHANV.REID19580210UHC9352279•••-••-1047742-332-8602ethan.reid@yahoo.com123 Park PlaceLos AngelesCA90017GRP-9512choice-plus-ppo
CLMCLM-4109092026-09-07T16:42:08ZCarol—HughesFeb 28, 1979NULL···NULL—UNKNOWN2280 Bayshore DrSeattle·WA98128·NULLN/A
ENRENR-1120532026-05-30T17:28:07ZSean·Z.Sims10/5/1966UHC-28541-23•••-••-6294+1 887 541 5263sean.sims34@icloud.com··5018 Elm StreetMESAAZ85281GRP-1689OPTIONS-PPO
TPATPA-596982026-09-19T18:15:32ZNancy—Ryan1989-03-05—UNKNOWN(599) 455-8400————NULL—null
ENRENR-1231262026-01-15T03:15:25ZGeraldBDixon1986-01-13UHC-04299-88•••-••-8361(342) 312-2740gerald.dixon27@hotmail.com2943 Central AvenueLas VegasNevada89158GRP-1258choice-plus-ppo
CLMCLM-4301622026-01-09T08:01:06Z·Matthesw—AlexisJul 24, 1973UNKNOWN•••-••-7720(425) 542-7194—676 Main StAtlantaGA30391GRP-8658NAVIGATE-HMO
CLMCLM-4126622026-06-29T23:25:25ZKATHLEEN—WRIGHT1949-05-25UHC-81490-13nullN/A—4168 Oak StreetFresnoCA93768GRP-9323MEDICARE-ADV-B
CLMCLM-4170422026-08-28T18:01:35Z Joe—Turrner01-12-1987UHC-14898-27•••-••-520713745157975joe.turner@hotmail.com··55 UNION STCharlotteNC28296GRP-7875····
ENRENR-1409942026-07-25T16:25:34ZSusan—·Contreras19630401UHC-06057-20•••-••-61783228934susan.contreras22@proton.me7437 SAGE COURTColumbusOH43295-6505GRP-5769medicare-adv-a
CLMCLM-4178682026-06-23T00:04:16ZAndrea··—Hanson1971-11-09UHC8958764··533-746-5441andrea.hanson@hotmail.com8510 CAMELBACK ROADPLANOTX75012GRP-7933MEDICARE-ADV-A
PRVPRV-207902026-07-01T08:59:24ZLINDATWEAVER1945-04-12uhc-05696-37—5934093369N/A8132 GRAND AVE··SeattleWA98145NULL··N/A
ENRENR-1039272026-03-30T04:25:00ZAUSTIN—WARREN7/28/2008UHC-54396-70—369-814-8462austin.warren@yahoo.com5121 Mesa Drive Apt 30TampaFlorida33625GRP-9465MEDICARE-ADV-A
ENRENR-103279 2026-05-02T17:16:12ZJamesJRios—UHC-97343-03•••-••-6006239-732-6867james.rios61@hotmail.com4070 WILLOW CT··PHOENIXAZ85043GRP-3865NAVIGATE-HMO
PRVPRV-273412026-05-03T00:00:45Z Alan··—Mendez04/23/99nullN/A·270-510-0280alan.mendez4@hotmail.com9237 LINCOLN WAYLas VegasNV89135—·UNKNOWN
ENRENR-1085942026-06-14T09:37:19ZCARLS.PENA·1939-07-24UHC-49648-62•••-••-873614377911630CARL.PENA75@GMAIL.COM2430 Jefferson AvenueMesaAZ85240GRP-2551MEDICARE-ADV-A
TPATPA-501322026-02-25T11:41:11ZCynthia··—Hraris19790410UNKNOWNUNKNOWN———-null--—
PRVPRV-268702026-09-17T05:08:12ZKARENP.HOFFMMAN1997-12-06—N/A839-356-2660-··7045 Mesa DrLas VegasNV89150—-
TPATPA-557622026-04-25T19:09:50ZANTHONY—JOHNSTON1976-01-26UNKNOWNnullN/ANULL6353 Cedar LnTampa·FL33619N/AUNKNOWN
CLMCLM-4207352026-07-04T02:35:33Zchristopher—lucas1946-01-07null——christopher.lucas@hotmail.com6316 Lincoln WayMinneapolisMN55429NULLUNKNOWN
CLMCLM-4123732026-06-24T00:27:22ZMateo—OBrien1969-03-09UHC-64674-51—UNKNOWNnull····—UNKNOWN··GRP-3392null
ENR ENR-1066502026-02-19T16:19:17ZGabrielTSandoval1948-01-09UHC-73342-13•••-••-619016976934152··GABRIEL.SANDOVAL49@OUTLOOK.COM464 SUNSET BLVDPlanoTX75063GRP-0996MEDICARE-ADV-A
100,000 rows, page 121 of 2,000PreviousNext

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:36.686Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty