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-122284 2026-06-20T11:15:24ZKARENW.NUNEZ1964-07-26UHC-53022-61•••-••-26393893833489—315 Indian School Rd #671Atlanta··ga··30324GRP-3050CHOICE-PLUS-PPO
ENRENR-1141482026-05-23T16:46:14ZWilliam—·Dominguez19440221UHC-29789-20··•••-••-15328795196575—716 MAPLE AVEFresnoCA93759GRP-7546choice-plus-ppo
CLMCLM-4164812026-05-09T08:54:45ZArthur—Guzman1951-01-13UHC7238209NULL12469255618—3798 WILLOW CTFresno·CA93717-CHOICE-PLUS-PPO
TPATPA-582232026-02-01T10:46:35ZScott—Hicks21-05-1975N/Anull—null3977 WASHINGTON STSeattlewa98149GRP-3508—
ENRENR-1130032026-08-09T03:47:39ZNICOLE—WOODS2007-07-16UHC-32255-61•••-••-29959458684626-8309 Washington StreetPlanoTX75096GRP-1934CORE-HMO
PRVPRV-255992026-03-13T01:57:02ZYoung, Carlos——1985-03-14UHC2206837—7564710943··8579 Spring StTAMPAFL33678-null
CLMCLM-405262 2026-06-11T06:21:24ZHELEN—SIMMMONSUNKNOWNUNKNOWNN/A·4919270856N/A711 Oak StreetEDEN PRAIRIEMN55377—null
ENRENR-107022 2026-07-12T12:35:03ZHansen··MBrandon03/20/79··UHC-59196-09•••-••-0999795-948-0557NULL4589 MESA DR Apt 31·ChandlerAZnullGRP-5104CHOICE-PLUS-PPO
ENRENR-1301882026-06-30T16:31:37ZBeverlyX.Valdez10/24/1989UHC-20571-96•••-••-7566(201) 703-3754beverly.valdez@aol.com9115 Canyon RoadCharlotteNC28227-8226GRP-1962CORE-HMO
ENRENR-1198772026-10-05T08:19:44ZCarolyn—Greene··6/9/1943UHC-92702-38•••-••-3839280-701-8511carolyn.greene97@icloud.com3861 Baseline RoadSeattleWashington98112GRP-3856MEDICARE-ADV-A
ENRENR-1189582026-06-24T07:25:31ZAMANDA—OLSON07/06/1996UHC-71463-79•••-••-8007692-543-4781amanda.olson14@proton.me4130 Hillcrest RdColumbusOH43220GRP-8009OPTIONS-PPO
ENRENR-1195162026-04-04T01:21:58ZDylanR.Estrada1978-05-03··UHC-11312-21•••-••-0619+1 303 500 9201dylan.estrada@proton.me692 Forest AvenueHoustonTX77027GRP-9610OPTIONS-PPO
PRVPRV-213082026-07-01T14:59:42ZJudith—Carroll1939-03-06UNKNOWNnull(220) 253-8358N/A-N/A—·N/A-NULL
TPATPA-605382026-09-25T08:43:39ZSandra—Reed04/05/85—UNKNOWN(421) 761-0275UNKNOWN····N/A—NULL·-CHOICE-PLUS-PPO
ENRENR-1236992026-08-11T08:53:07ZReyd, MarianaM.—1962-08-21UHC7962960•••-••-9606617-287-8659mariana.reid@aol.com8707 MAIN ST··GLENDALEAZ85384GRP-4726MEDICARE-ADV-B
TPATPA-574342026-04-18T18:51:02ZBeverly—Bennett1948-08-14·N/Anull13645788323beverly.bennett@gmail.com4158 INDIAN SCHOOL RDDENVERCO80291····MEDICARE-ADV-A
CLMCLM-4249382026-02-13T20:24:20ZWard, Wayne——1940-05-22UHC-86507-79•••-••-8555—-·8946 Apache BlvdPlanotx75025GRP-5557SELECT-EPO
ENRENR-1205792026-01-29T17:28:37ZTerry—Singh1956-05-20uhc-09840-40•••-••-50414692871terry.singh59@yahoo.com-null——GRP-5929medicare-adv-b
ENRENR-1320912026-09-18T22:02:50Z———10-10-1954UHC-35421-78•••-••-3107·959-917-9021santiago.franklin72@icloud.com8938 Union StreetGILBERTAZ85212-9446GRP-8874MEDICARE-ADV-A
ENRENR-1050672026-06-05T01:01:45ZSTEPHENQ.SCOTT08/22/43UHC-90161-54•••-••-6836·792-348-2814—8180 Hillcrest RdSeattleWashington98104GRP-5932MEDICARE-ADV-A
ENRENR-1195222026-04-30T18:39:51ZOwens, LawrenceT—·9198-01-03UHC-66059-99•••-••-0377(524) 531-1349lawrence.owens@outlook.com2445 Grand Ave·ScottsdaleAZ85205GRP-9927CORE-HMO
ENRENR-1271552026-06-24T17:28:58ZMegan··C.Graam6/18/1962··UHC-96401-51•••-••-35952938348107megan.graham47@aol.com3627 Highland AvenuePlanoTX75060GRP-0951CORE-HMO
CLMCLM-4199582026-04-29T15:18:39ZEMMAX.MEYER1950-04-22UHC-01738-01—-——null———OPTIONS-PPO
CLMCLM-4260082026-05-04T04:54:31ZDavid—Jacobs19990103UNKNOWN•••-••-7734-—null—nullNULL—CORE-HMO
TPATPA-586922026-04-16T16:50:16ZJONATHAN—PETTERS1994-07-26—•••-••-2548NULL—4899 Indian School RdLos AngelesCA90066null—
PRVPRV-256202026-05-31T11:37:25ZCARL··—MARSHALL22-07-1963UHC-27566-03····+1 689 452 7111carl.marshall@hotmail.com1078 Forest Ave··GilbertAZNULL——
ENRENR-1147432026-04-06T11:13:56Z·NATALIE—POWELL1985-12-22UHC-10257-01-19074525869NULL9673 Jefferson AvenueTampaFL·33687GRP-8571OPTIONS-PPO
PRVPRV-257062026-03-02T09:48:19Zelijah—munoz11/23/1957——16608676097—7576 Jefferson AveHoustonTX77004N/AMEDICARE-ADV-B
PRVPRV-259292026-08-04T14:39:35ZPeter—Reyes·1944-10-12·UHC-30205-67—(945) 696-9470UNKNOWN6145 BROADWAYDenverco80228nullN/A··
CLMCLM-4217522026-08-20T16:16:42ZlindaT··johnonUNKNOWNNULL—(878) 724-5719NULL3980 Baseline RoadColumbusOH43215GRP-6065-
PRVPRV-256882026-06-20T22:16:27Z Helen—Estrada1945-12-08UHC6382595N/A286-599-9236-5639 Spring StLas VegasNV89134···nullnull
ENR ENR-1315192026-01-27T22:26:10ZLawrence, Frank····—1992-06-14UHC-54403-51•••-••-5200(234) 412-2544FRANK.LAWRENCE18@PROTON.ME4496 River RoadTUCSONAZ85735GRP-4511CORE-HMO
ENRENR-1411822026-07-29T17:18:40ZsharonAreid1959-02-26UHC-09861-29•••-••-0449553-256-4040UNKNOWN2290 Meadow Lane·OrlandoFLUNKNOWNGRP-9718MEDICARE-ADV-B
ENRENR-111152 2026-01-07T20:54:01ZmariTwang19760407UHC-01269-47NULL8197400242··maria.wang35@yahoo.com6033 Mesa DrPhoenixAZ85004··GRP-9674CHOICE-PLUS-PPO
TPATPA-580222026-07-27T07:08:21Z·Ronald—Hoffman3/11/1979—•••-••-0770(865) 215-9800—4022 Park PlaceAustinTX78792-0443GRP-6141··MEDICARE-ADV-A
PRVPRV-202332026-07-06T05:51:40ZArthur·WStephens19500225—NULL(933) 610-6282—8084 Union StORLANDOFL32888—··
ENRENR-1224372026-08-20T06:25:22ZMartha—Stewart1962-03-10UHC-88680-16•••-••-71127779902724martha.stewart@yahoo.com194 MARKET STCharlotte·NC28288-4218GRP-0645CHOICE-PLUS-PPO
ENRENR-1001412026-09-30T15:07:27ZDENNISVBERRY22-03-1965UHC-82134-43•••-••-2264—DENNIS.BERRY97@AOL.COM·384 BAYSHORE DREden PrairieMN··55352GRP-4273MEDICARE-ADV-B
ENRENR-1181322026-08-07T17:46:44ZLucia—·Fox2001-05-26UHC5407115•••-••-8922+1 652 293 8424N/A7938 RIDGE RDLos AngelesCA90052GRP-2011MEDICARE-ADV-A
PRVPRV-241632026-04-10T22:14:43Zrachel—kellly1944-02-27UHC-94298-23··null+1 856 402 6237—572 MARKET STREETChandler·AZ85231··-····
CLMCLM-4265152026-09-01T08:48:15ZKevin—Freeman··1953-09-01UHC-75530-98—(546) 580-2416··—7508 Oak StreetMesaAZ85247UNKNOWNCORE-HMO
TPATPA-535462026-07-01T23:27:11ZSTEPHANIE—RYAN1999-09-22——+1 303 752 5432—4072 MARKET STREETMiamiFL33185—OPTIONS-PPO
ENRENR-1306422026-03-02T13:10:00ZMARIENATSNYDER1982-04-19UHC-99299-91•••-••-4144(465) 223-6941mariana.snyder@proton.me3949 FOREST AVEHoustonTX77098GRP-5870MEDICARE-ADV-A
CLMCLM-4031272026-03-19T14:53:18ZHowrad, Sean——·03/02/03UHC-69785-40•••-••-9834NULL—1024 LINCOLN WAYGILBERTAZ85274GRP-1475CHOICE-PLUS-PPO
CLMCLM-4239452026-07-29T13:48:53ZSandra—Reed4/5/1985—NULL—sandra.reed@proton.me4807 Central AvenueColumbusOH43264NULLUNKNOWN
ENR ENR-1307232026-06-30T14:09:15ZVICTORIAE.CLARK··1997-12-28··UHC-04405-72•••-••-91397023078648NULL7958 Indian School RoadSCOTTSDALEAZ85247GRP-6740MEDICARE-ADV-A
CLMCLM-4107032026-09-26T13:02:25ZSarah·DBowman1983-04-27UNKNOWN•••-••-3711(343) 667-9817·UNKNOWN3180 Apache BoulevardLos AngelesCA90041····UNKNOWN
CLMCLM-4300112026-07-22T01:43:00ZLARRY—GARCIA9/11/1952uhc-62291-99-null··—3651 HARBOR BLVD·FresnoCA93741—core-hmo
ENRENR-1083972026-10-12T08:10:33ZGloriaKElliott9/6/1962UHC-53305-41•••-••-8168580.266.1350GLORIA.ELLIOTT93@AOL.COM9566 HILLCREST RDHoustontx77008GRP-3799OPTIONS-PPO
CLMCLM-4305962026-07-25T22:32:27ZRojas, Stephanie·O—NULLUHC-23206-48•••-••-4620580-934-2163—3938 Main StreetJacksonvilleFL32217-3520GRP-5421SELECT-EPO
100,000 rows, page 159 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.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty