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
CLMCLM-4242462026-08-10T22:13:29ZkatherineI.hart1992-03-19····NULL-NULL5857 Ridge RdDallasTX75204GRP-5706UNKNOWN
TPATPA-522062026-05-21T02:23:05ZJonathan··Dunn1982-02-24UHC-83711-02•••-••-9424—jonathan.dunn99@outlook.com6904 Forest AveMIAMIFL33149-NULL
CLMCLM-4107792026-10-05T15:46:56ZJUDY····MARTIN··1977-07-26UHC-75557-23•••-••-45809288111335—9886 HIGHLAND AVEGilbertAZ85203-N/A
ENRENR-1235022026-01-27T11:24:52ZHeetherMSanchez1996-06-03UHC-14155-80•••-••-7781386-731-4497—3323 Park PlChandlerAZ85293GRP-4514OPTIONS-PPO
PRVPRV-24565 2026-03-06T19:22:38ZTyler—Luna1977-07-09-N/A856.915.8143—1937 Meadow LnAtlantaGA30361-5825—NAVIGATE-HMO
ENR ENR-1268562026-08-31T10:55:25ZJessica—Miller08-02-1952UHC-28040-04•••-••-2097NULLjessica.miller@proton.me8223 Jefferson AvenueJACKSONVILLEFL32252GRP-1288MEDICARE-ADV-B
ENRENR-1288092026-09-02T08:05:49ZPriya—Ortiz1943-10-11UHC-82529-11•••-••-0960(622) 835-8243PRIYA.ORTIZ35@YAHOO.COM9244 Mesa DrPhoenixaz85012GRP-1507OPTIONS-PPO
ENRENR-1216362026-03-10T18:52:07ZDonnaFBurton1941-04-09UHC-76175-26•••-••-6248564-618-1356donna.burton@outlook.com4192 Forest AveTucsonArizona85793GRP-8997OPTIONS-PPO··
PRVPRV-226322026-07-20T10:30:30ZJames, CarolU.—1996-11-22—NULL7094556—5225 UNION STTUCSON·AZ85723-—
ENRENR-1109562026-05-09T11:36:08ZNguyen, DiegoD.—1985-12-09···UHC-13195-60-306-849-2793diego.nguyen@outlook.com7290 Hillcrest RdTempeArizona85278GRP-5205SELECT-EPO
ENRENR-1047172026-09-19T14:44:07ZAARON—SNIGH··1967-11-06UHC-35905-29—-aaron.singh@icloud.com8060 BroadwaySeattle·WA98153GRP-3721··CORE-HMO
ENRENR-1328212026-04-20T22:07:47ZcynthiaVmcdonaldN/AUHC3332797•••-••-51736929645537cynthia.mcdonald@icloud.com1243 Bayshore Drive Apt 14DenverCO80265GRP-4230NAVIGATE-HMO
CLMCLM-4067962026-05-20T01:42:11ZEstrada, Glorya——1945-01-03UHC-90670-68•••-••-9140(915) 939-4695—9236 SPRING STREETHoustonTX77013GRP-8927-
PRVPRV-234322026-05-15T00:09:01ZAdams, Julia——04/13/1962UHC-29398-05•••-••-6311·(620) 827-4753null-——-UNKNOWN····
CLMCLM-4094242026-10-14T06:52:49ZHarold—Bishop2006-05-25UHC5828464-595-697-2075N/A1322 Willow CourtSeattleWA98103—null
CLMCLM-4038012026-02-22T23:11:11ZFrances—Jacobs1986-09-08—•••-••-1981——9439 Baseline Road Apt 31AtlantaGA30373GRP-9791CHOICE-PLUS-PPO
ENR ENR-1176042026-09-07T02:23:46ZhamiltonUdoris···1949-03-21UHC-29716-43•••-••-02638755174672··-8807 INDIAN SCHOOL RD Apt 14Los AngelesCA··90063-1184GRP-4303CORE-HMO
ENRENR-1281312026-05-31T19:35:23Zahmed·Ecunningham1967-12-02UHC-90142-41-5813223773·ahmed.cunningham1@proton.me9547 Baseline RdDALLASTX75238-7046GRP-0991·select-epo
PRVPRV-249392026-08-14T21:37:31Z·MATTHEW—CRUZ1944-06-17··UHC-91463-54N/A·(213) 422-5293N/A7979 Pine DriveEden PrairieMN55374-UNKNOWN
ENRENR-1263332026-06-27T21:48:11ZBrittanyO.Adams2005-06-11UHC-46200-50•••-••-52465989978463—7123 Lincoln WayCOLUMBUSOH43226GRP-5373NAVIGATE-HMO
TPATPA-534412026-03-03T14:37:37ZJordan—Ferguson1969-08-05UNKNOWN··null19746705648-5600 Palm DriveEden PrairieMN55336-6535—OPTIONS-PPO
CLMCLM-4012762026-06-24T10:23:39ZALBERTP.CLARK15-05-1977UHC-36686-91N/A18862532948UNKNOWNnullnullN/AN/A··GRP-6361NULL
TPATPA-514262026-03-31T20:32:23ZJudithE.Gilbert1955-10-23UHC-52805-66•••-••-9587N/AUNKNOWN—·NULLNULLNULLNULLMEDICARE-ADV-B
CLMCLM-4244772026-08-05T18:59:02ZDIANA—TURNER19701106UHC-55479-79NULL+1 793 969 0217UNKNOWN3212 Lake View RoadGilbertAZ85235NULLNULL
PRVPRV-278732026-07-13T05:44:19ZChristinaTLawrence2006-09-09——+1 924 709 9607—8599 Sage CourtChandlerAZ85279UNKNOWN—
ENRENR-1429092026-02-27T23:02:04ZHELENPNGUYEN1992-11-19uhc-32465-91•••-••-3356+1 419 847 6611helen.nguyen66@aol.com9835 MEADOW LANE #392··NashvilleTN37205GRP-3434MEDICARE-ADV-B
ENRENR-1397672026-08-19T03:42:50Z HELENXELLIS2008-02-12UHC-73490-52··-638-970-3302helen.ellis21@aol.com2899 BroadwayDenverCO80259-2437GRP-2592NAVIGATE-HMO
CLMCLM-4220402026-02-27T21:45:30ZPATRICK··NICHOLS1945-08-01UNKNOWNN/A··(587) 569-0437N/A6749 HILLCREST RDSacramentoCA95837GRP-0745NAVIGATE-HMO
CLMCLM-4233672026-08-14T21:01:07Zyuki—wright1986-02-22UHC-59968-86-946-683-5588—·9017 Pine Dr #800JACKSONVILLEFL32241-1287GRP-6785—
ENRENR-1126492026-10-18T02:30:55Zcatherine—mendez20060323UHC-12032-61•••-••-7500(448) 675-7724—2046 Lake View RoadHOUSTONTX77047GRP-5672OPTIONS-PPO
CLMCLM-4311972026-08-05T00:26:35Zscott—stnoe19860626UHC-07176-62—3568083476NULLN/A—UNKNOWN··—GRP-8565····
TPATPA-570792026-05-18T16:34:53ZAlice—·Bailey1980-08-28UNKNOWN··•••-••-4037—UNKNOWN9752 WILLOW COURTGlendaleAZ···85322N/AN/A
ENRENR-1037792026-09-25T15:35:15ZSofiia—·Pena1939-02-19UHC9467399•••-••-0370(324) 303-0405sofia.pena92@hotmail.com2640 Ocean AveAustin··TX78733GRP-8722CORE-HMO
CLMCLM-4189572026-06-24T22:45:41ZVINCENT—LE1947-02-13···N/A•••-••-1130920-289-8359VINCENT.LE78@OUTLOOK.COM1141 Ocean AvenueTempeAZ85219GRP-7235—
ENRENR-1268062026-07-27T14:10:08ZEspinoza, RonaldP.—1971-03-13UHC-53546-06•••-••-9465N/Aronald.espinoza@hotmail.com1715 HIGHLAND AVENUEGilbertAZ85270GRP-4402CHOICE-PLUS-PPO
CLMCLM-4261922026-01-16T20:59:44Z ·Karen—Myers1996-06-23UHC-60681-55-9159541863null2203 Washington St #840SAN ANTONIOTX78274GRP-6507·CORE-HMO
CLMCLM-4242142026-02-15T19:21:26Zroy··—campbell1965-02-19UHC-44341-02—802-294-7510—4888 Union StreetPhoenixAZ··85060GRP-8562··CHOICE-PLUS-PPO
PRVPRV-288392026-07-30T23:43:50ZMike—George6/24/1955NULL-(684) 803-1192—3589 BASELINE RDMIAMIFL33173N/A—
ENR ENR-1209762026-02-02T21:00:47ZWeber, Donna——1951-08-05UHC-68630-22•••-••-8266UNKNOWNdonna.weber19@hotmail.com3086 Sunset BoulevardScottsdale·AZ85243GRP-6276SELECT-EPO
CLMCLM-4170642026-10-14T00:52:18ZRUTH—MARTIN··1995-04-11UHC1418210—null—3526 Maple AveTucsonAZ85762GRP-3109NULL
PRV PRV-248872026-02-13T07:17:35ZMeganR.·Lee11-08-1974UHC-53262-83-····null1493 HIGHLAND AVENUEDENVERCO80254-6189—-
ENRENR-1305442026-07-21T07:36:40ZTeresaG.Park1963-11-24UHC-72389-20UNKNOWNNULLTERESA.PARK@GMAIL.COM6714 Highland AvenueFresnoca93739GRP-6345CORE-HMO
ENRENR-1115292026-01-10T05:49:51ZDeniseKSullivan1956-06-18UHC-15075-42•••-••-4959(421) 529-4171DENISE.SULLIVAN@PROTON.ME393 Market StPlanoTX··75003GRP-4023SELECT-EPO
CLMCLM-4242672026-01-19T16:23:59ZBarnes, Jack········1940-07-25NULLNULLNULLnull5734 Washington StreetAtlantaGeorgia·30356GRP-9378NAVIGATE-HMO
CLMCLM-4321752026-08-03T10:43:16ZANTHONY—PARK02/22/01UHC-76242-39null(276) 313-9632anthony.park@yahoo.com379 Oak StreetDallas·TX75231NULL—
CLMCLM-4276512026-05-28T20:57:00ZRaymond—Phillips1995-01-28·UHC3431911—nullUNKNOWNNULL———GRP-7940UNKNOWN
ENRENR-1146682026-03-14T07:23:25Z·Kenneth—Fuller10/21/68UHC-48254-48•••-••-5722512-756-2363—7076 Lake View RdSEATTLEWA98176GRP-4541MEDICARE-ADV-A
CLMCLM-4097562026-04-22T21:23:39Z·WILLIE—REED19990202UHC-69931-09•••-••-8487UNKNOWN—N/AN/A—UNKNOWN—null
CLMCLM-4280742026-04-18T17:13:08ZChrisian—King1952-07-18UHC-48234-46··•••-••-4201+1 308 767 3267—5526 SUNSET BOULEVARDTempeAZ85215GRP-1478—
CLMCLM-4317532026-06-04T10:24:49ZWilliamIVargaas1981-12-28UHC-52456-25——UNKNOWN5990 Apache BlvdNashvilleTN37247-0881N/AMEDICARE-ADV-B··
100,000 rows, page 46 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:34.776Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty