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-1127072026-02-13T19:25:39ZBISHOP—KATHLEEN1956-12-25UHC-56849-46•••-••-4511·453.299.3828—9143 Grand AvenueSAN ANTONIOTX78206··GRP-0976OPTIONS-PPO
PRVPRV-241502026-08-21T15:14:06ZHelen—Mitchell12/3/1956UHC-66688-12—276-579-6551HELEN.MITCHELL21@PROTON.MEN/A·N/AUNKNOWN--—
CLMCLM-4284392026-07-22T04:42:31ZTyler—Meyer1964-04-20N/A-UNKNOWN—2469 Harbor BoulevardMesaAZ85268··GRP-3800N/A
CLMCLM-4202902026-09-14T12:28:08ZSARAH—ADAMS09-06-2006UHC5710630•••-••-1491NULL—2699 Canyon Road #140FresnoCA93784—UNKNOWN
ENRENR-1224812026-01-15T19:58:59ZLogan—Delgado1956-09-17UHC-87471-01•••-••-7800902-367-9360NULL5217 Indian School RdAtlantaGA·30342GRP-7610MEDICARE-ADV-B
CLMCLM-4223402026-07-22T00:44:25ZDnun, Jack····—06/26/1944UHC-52947-29··nullUNKNOWN5132 Oak StPlanoTX75084—null
ENRENR-1029912026-01-23T11:08:24ZAISHA—SIMMONS1944-04-21UHC-46654-44•••-••-8175·(229) 351-5885NULL774 Lincoln WayPhoenixAZ85014GRP-9597NAVIGATE-HMO··
TPATPA-624612026-02-28T16:26:08ZdylanA.greene1964-02-10null——null8214 MESA DRGilbertAZ———
CLMCLM-4061422026-01-24T07:32:33ZTyler—Knight2002-04-27uhc-41760-41NULL905-510-0879NULL6690 Elm StDallasTX75215-8654··UNKNOWN
CLMCLM-4313152026-08-18T17:34:05ZEdward····Bruton2004-01-20UHC-96686-35null833-908-9193—1763 Palm DriveMesaAZ85244GRP-2247MEDICARE-ADV-B
ENRENR-1312622026-09-11T07:17:03ZPaul····Castillo1991-03-22·UHC-57719-17•••-••-3709·4906569580paul.castillo@outlook.com7965 CAMELBACK ROADCharlotte··NC28228GRP-5712MEDICARE-ADV-B
ENRENR-1190462026-10-03T08:45:23ZEugene····Shaw·2004-11-24UHC-47201-99•••-••-69312788236660eugene.shaw48@proton.me——·UNKNOWNNULLGRP-9897SELECT-EPO
ENRENR-1240262026-02-04T02:47:07ZLuciaRJensen1961-09-25UHC-79734-63•••-••-3783581.887.0999lucia.jensen11@proton.me217 Park PlaceSan DiegoCA92124GRP-8229SELECT-EPO
TPATPA-641272026-07-16T16:27:50ZAlexander—Woods1950-12-07UHC-66071-50-+1 475 213 6315—-NULL——NULL··null
ENRENR-1283452026-06-19T11:24:31ZKATHRYN—FORD1995-01-12·UHC6610947•••-••-6488310-638-3894—779 Valley View DrSeattleWA··98108·GRP-4652MEDICARE-ADV-B
ENRENR-1410092026-07-01T04:20:57ZNiocleBMorales15-02-2002UHC-15042-40•••-••-6208527.756.3759—9553 BroadwayFRESNO··California93763GRP-0138NAVIGATE-HMO
TPATPA-604302026-07-09T11:46:34ZJerry··WhiteDec 23, 1996-UNKNOWN4647922··-2285 Sage CtSeattleWA98181GRP-7361UNKNOWN
TPATPA-603972026-02-18T20:07:13ZHarvey, Austin——2/2/1988NULLN/A—N/A8260 Main StreetDENVERCO80245N/A·null
ENRENR-1368422026-08-24T14:56:21ZDEBORAH—FOX·0604-18-92UHC-40257-90•••-••-4983NULLnull3808 Highland AvenueHoustonTX77059GRP-3223··MEDICARE-ADV-A
CLMCLM-4318002026-01-25T10:14:58Z JUDY—BANKSOct 25, 1995—-——6291 Canyon RdTempeAZ85204··GRP-4708null
ENRENR-1257262026-08-18T03:22:43Z ABBY····STEWART11/04/50·UHC2323380•••-••-6530246-560-1392abigail.stewart@hotmail.com3674 Harbor BoulevardOrlandoFL32894GRP-3546CORE-HMO
ENRENR-1001442026-09-03T13:49:48ZJosephUSimpson··1997-04-14··UHC-40911-71•••-••-817117684184471joseph.simpson@yahoo.com··9890 Canyon RdNASHVILLETennessee37266GRP-6606MEDICARE-ADV-B
CLMCLM-4182772026-06-18T07:26:29ZCharlotte—Fisher1984-08-28UHC-47722-90····974-990-1508null··7926 Spring StreetCHANDLERAZ85287GRP-8079·N/A
ENRENR-1193612026-04-24T03:31:50ZSofia—Stone1957-07-25UHC-26887-79•••-••-3990UNKNOWNsofia.stone18@hotmail.com9671 HIGHLAND AVENUETUCSONAZ-GRP-6316··options-ppo··
TPATPA-508772026-02-23T16:42:28ZBRIANK.WONG09/25/1946nullN/A—NULL2639 Canyon RoadPlanoTX75033—SELECT-EPO
ENRENR-1398232026-01-08T07:06:15ZAbigailDPerez25-10-1996UHC-81326-41—662.964.4810abigail.perez47@proton.me3454 Bayshore DriveLas Vegas··NV89114GRP-0863CORE-HMO
TPATPA-537192026-02-06T05:36:50ZJudy—Payne1950-01-20--——1141 Indian School RoadMinneapolisMN55402·nullOPTIONS-PPO
ENRENR-1172412026-08-24T06:43:53ZHELENKMORALES23-10-1959uhc-42089-79•••-••-6087325-291-7069helen.morales9@hotmail.com··3155 APACHE BOULEVARDLos Angeles·CA90026-6313GRP-1276OPTIONS-PPO
CLMCLM-4307342026-02-18T02:03:27ZJESSE—BRYANT7/25/1948UHC-24474-58-(571) 428-2738—9551 Sunset BoulevardLos AngelesCA90089GRP-3212SELECT-EPO
CLMCLM-4169002026-09-20T03:08:46ZDOUGLAS—TUCKER11/13/71UNKNOWNUNKNOWN··N/Adouglas.tucker12@proton.me7086 Cedar Lane·San AntonioTexas78281-4281N/A····
TPATPA-616892026-05-28T06:19:08ZWeaver, MargaretF—04/17/1989UHC-13952-43UNKNOWN—-—NULLUNKNOWNUNKNOWN-··OPTIONS-PPO
CLMCLM-4071782026-10-18T13:45:04ZAhmed—Wallace1970-70-11UHC-37460-16——·-4100 Cedar LaneScottsdaleAZ85220GRP-3527N/A
ENRENR-1297242026-09-22T01:45:34ZRobertQTorres9/5/1954UHC0483405•••-••-3243502.346.9011ROBERT.TORRES85@GMAIL.COM··5873 Lake View Rd #793ChandlerAZ85254-1092GRP-4916MEDICARE-ADV-B
ENRENR-130975 2026-06-24T15:04:56ZOlivia·F.Dominguez1949-04-07UHC-41435-77•••-••-2042·+1 423 374 8544olivia.dominguez78@icloud.com1500 Palm DrPhoenixAZ85001·GRP-8168CHOICE-PLUS-PPO
CLMCLM-4128362026-05-21T10:30:10Z Arjun—Marshall1990-03-22N/A—UNKNOWNUNKNOWN8882 MEADOW LN Apt 21Austin·TX78727····null
CLMCLM-4094362026-01-07T15:05:23Zevelyn—owens10/17/1967UHC-31790-37null(747) 820-4284null9133 River RdGilbert·Arizona85224GRP-7873CHOICE-PLUS-PPO··
CLMCLM-4218672026-04-27T21:32:39ZNoah—·Griiffin1967-08-20null•••-••-4088(584) 383-4338UNKNOWN6453 JEFFERSON AVEPLANOtx75054GRP-4886N/A
ENRENR-1308042026-07-24T03:34:14ZSarah—Fuller02/01/1955UHC-33174-34•••-••-5930276-363-3844—9462 LINCOLN WAYDenverCO·80276GRP-6619CHOICE-PLUS-PPO
CLMCLM-4141232026-09-03T03:42:00Z Henry—Reynolds2002-08-03UHC-89188-18—(976) 488-8719—698 MOUNTAIN VIEW DRDallasTX75273GRP-4166—
TPATPA-574302026-08-19T00:05:54ZRychardson, Terry——07/04/1984UHC-96410-44•••-••-4834UNKNOWN-6145 Park PlSan AntonioTX78286—-
CLMCLM-4228232026-01-11T14:10:54ZBenjemin—Brooks2008-12-09····—nullbenjamin.brooks94@outlook.com9416 DESERT SKY BOULEVARDSan DiegoCA92148··—SELECT-EPO
CLMCLM-4109832026-06-22T01:26:18ZLAURAX.DANIELS1978-04-28UNKNOWN———2172 Lincoln WayChandlerAZ85281GRP-8240CORE-HMO
ENRENR-1188342026-03-05T11:57:40ZDean, AndrewK.··03/23/43UHC-47206-76•••-••-2586(358) 581-7310ANDREW.DEAN52@HOTMAIL.COM5529 Church StHoustonTX77018GRP-9536CHOICE-PLUS-PPO
CLMCLM-4041622026-06-04T23:46:17ZKenneth—OBrien··1948-04-17UHC1710944•••-••-0961UNKNOWN—8106 CEDAR LNCharlotteNC28212GRP-5298CHOICE-PLUS-PPO
ENRENR-1056762026-07-22T09:16:36ZMarcus··—Porter28-01-2006UHC-50158-19•••-••-7815NULL—5998 Mountain View DrHOUSTONTX77036GRP-3242CORE-HMO
CLMCLM-4053822026-10-03T17:48:11ZARJUN—BRADLEY1959-04-16UNKNOWN•••-••-88197419573764null1459 Ocean AvenueDALLASTXUNKNOWN——
TPATPA-535322026-02-19T20:53:44ZYUKI—DOMINGUZ1982-09-13UHC2011023·UNKNOWN5733552265—2794 CAMELBACK ROADNashvilleTN37291NULLnull
TPATPA-501182026-10-03T01:29:12ZVargas, Jean····—·1994-08-16UNKNOWNnullNULLJEAN.VARGAS@OUTLOOK.COM8065 MEADOW LANEChandlerAZ85265-—
CLMCLM-4111502026-07-08T17:21:01ZPark, Austin····—1987-07-24uhc-57701-65UNKNOWN··(976) 870-3257—8843 Forest AveSeattleWA·98131nullMEDICARE-ADV-B
ENRENR-1109612026-04-25T16:32:12ZFRANCES O—BURNS07-06-1977UHC-13404-99—3435486143frances.burns@icloud.com·9458 Pine Drive Apt 23GlendaleAZ85305GRP-5425CORE-HMO
100,000 rows, page 225 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:37.734Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty