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
TPATPA-623822026-07-31T10:55:27Z·LAUREN—CASTILLO·1995-02-27UNKNOWNN/A583-830-2953—1958 Highland AvenueAUSTINTX78734-0935—UNKNOWN
TPATPA-522272026-10-09T12:47:12ZJacobs, Nathan——Jul 4, 1946··NULLUNKNOWNnullnathan.jacobs@aol.com3405 Pine DrSeattlewa98114N/AUNKNOWN
TPATPA-604012026-01-13T00:58:01ZJOANSKNIGHT1997-11-15··nullnull(941) 470-3845joan.knight19@outlook.com3802 Highland AveFresnoCA93796··GRP-2850N/A
PRVPRV-220062026-08-26T05:07:51ZCheryl—Rivera09/14/63—•••-••-3505·UNKNOWN—·7489 Apache BoulevardPhoenixAZ85039··N/A—
ENRENR-1242502026-03-30T08:32:12ZTurner, Kevin——04/04/1952UHC-45401-60•••-••-9508(622) 367-8928KEVIN.TURNER22@ICLOUD.COM·5027 OCEAN AVEColumbusOH··43240GRP-6603CHOICE-PLUS-PPO
ENRENR-1240612026-01-06T02:26:53ZDavid—VargsJan 14, 1987UHC-69891-28•••-••-8318(842) 641-3232DAVID.VARGAS@AOL.COM8035 LINCOLN WAYSan AntonioTX78208GRP-8345CHOICE-PLUS-PPO
ENRENR-1088462026-01-22T12:22:13ZCARL—·OWENS2001-01-10UHC2425002•••-••-0995(824) 307-1686CARL.OWENS57@PROTON.ME·1298 FOREST AVENUEMinneapolisMinnesotaUNKNOWNGRP-5075SELECT-EPO
ENRENR-1281912026-08-04T03:56:26ZDeborah—Santiago5/25/1961·UHC-35269-37•••-••-4460651-233-3945deborah.santiago89@yahoo.com8215 Washington StreetCHANDLER·AZ·85273GRP-5092OPTIONS-PPO
TPATPA-546042026-05-17T08:51:24ZDaniel—Hawkins15-06-2006N/A•••-••-4435—daniel.hawkins20@aol.com6882 Harbor BlvdGILBERTAZ85221-NULL
CLMCLM-4078812026-01-23T18:06:31ZJooseph—·Gardner2002-05-07UHC-79742-33—N/AN/A520 Ocean AvenueSan Diego··CA92120—CORE-HMO
ENRENR-1107962026-03-25T13:03:40ZCamilaW.SandovalSep 18, 1983UHC-60824-59—459-217-9167···camila.sandoval43@hotmail.com5221 BroadwaySeattleWA98142GRP-0386MEDICARE-ADV-A
CLMCLM-4044022026-07-26T20:21:19Zliisa—campbell10/22/1965N/ANULL673-271-7388lisa.campbell@icloud.com1629 PINE DR·DenverCO80275—UNKNOWN··
ENRENR-1352752026-01-10T13:46:54ZAmanda—Santiago1951-07-28UHC-25419-96•••-••-444718874936783amanda.santiago97@proton.me275 Park PlaceAustinTX78788GRP-2680MEDICARE-ADV-B
CLMCLM-4057052026-02-24T07:26:51ZDorothy·X.Stone2007-02-01UHC-43891-11UNKNOWN··—·UNKNOWN1753 Sage CtMiamiFL33122··GRP-1045MEDICARE-ADV-A
ENRENR-1327052026-10-15T04:28:18ZBenett, Austin—····Oct 24, 1948UHC9828993•••-••-402012318273358austin.bennett10@hotmail.com7038 MESA DRGILBERTAZ85223GRP-3185NAVIGATE-HMO
ENRENR-1029772026-03-04T21:55:06ZTerryT.Maldonado1978-09-25UHC-64891-84—+1 937 233 7375TERRY.MALDONADO@OUTLOOK.COM5556 Desert Sky Boulevard·GlendaleAZ—GRP-9776MEDICARE-ADV-A
ENR ENR-1079872026-03-10T07:41:46ZsaraW.burton1938-03-28UHC-95297-67·NULL529.976.8788·UNKNOWN2589 Canyon RdAtlantaGA30328GRP-0305CHOICE-PLUS-PPO
CLMCLM-430354 2026-04-07T02:55:45ZDaniel—·Castillo05/16/1949UHC-74193-54N/A—null—NULL-—GRP-0812SELECT-EPO
ENRENR-1392942026-02-02T10:25:10ZHelenX.Ellis1965-08-01UHC-88505-77—811-259-3769HELEN.ELLIS26@ICLOUD.COM7967 Church St #733EDEN PRAIRIEMN55306GRP-2725OPTIONS-PPO
CLMCLM-4274802026-05-27T11:21:05ZWayne X—Castillo03/05/57·UHC-95042-59—7266870—-nullNULLnullGRP-0218MEDICARE-ADV-A
ENRENR-1009362026-02-23T16:55:28ZAbigailHSimmons1953-06-10UHC-39038-39-··18013629545abigail.simmons@gmail.com749 CANYON ROADJacksonvilleFlorida32209-0817GRP-0893CHOICE-PLUS-PPO
ENRENR-1076592026-08-17T12:40:33ZWallace—Barbara2152-19-84UHC-80497-35UNKNOWN7297947—3506 WILLOW CTPhoenixAZ85081GRP-8003CORE-HMO
ENRENR-1366872026-05-31T15:43:37ZSaraN.Peters1940-02-05UHC-44196-57•••-••-23772386133189—795 BROADWAYColumbusOH43208GRP-3470SELECT-EPO
ENR ENR-1354142026-10-15T09:08:19ZGutierrez, NathanV.—1953-07-17UHC8933604•••-••-9107(222) 365-3337nathan.gutierrez91@icloud.com8953 Sunset BoulevardSeattleWA98198GRP-6600SELECT-EPO··
ENRENR-1346972026-09-28T13:56:12ZCYNTHIAD.CARLSON1997-07-15UHC-39422-61•••-••-11565851258cynthia.carlson@proton.me4545 Park PlChandleraz85297GRP-4627OPTIONS-PPO
CLMCLM-4072932026-08-13T03:02:25ZKimberly—White1944-07-03null-UNKNOWNnull6560 Camelback Road··San AntonioTX78255—MEDICARE-ADV-B
TPA TPA-619472026-05-24T20:13:56ZSantiago—Collins··2001-06-10N/A•••-••-8350(917) 405-3500····-—-··NULLGRP-6369—
ENRENR-1289702026-10-17T10:14:54ZGLORIAH.BROOKS1946-03-27UHC-73625-05•••-••-09613253953961N/A9448 Cedar LnOrlando·FL32813GRP-2290··MEDICARE-ADV-A
ENRENR-1416062026-03-15T05:30:13ZandreaC.·matthews1974-04-26·UHC-26184-74N/A(423) 402-3147andrea.matthews28@gmail.com·1602 Canyon RoadTempeAZ85203GRP-9817NAVIGATE-HMO··
TPA TPA-636992026-02-26T17:06:59ZDouglas··—Smith··1939-02-21--3554501225N/A6704 Valley View DriveSeattleWA98166-2375N/AMEDICARE-ADV-A
ENRENR-1122162026-05-15T18:52:01ZCarol, LaneS.—1956-06-01UHC1400002UNKNOWN(575) 749-9827—7896 WILLOW CTMesaArizona85250GRP-3416SELECT-EPO
PRVPRV-288482026-03-29T18:42:06ZJacobs, Omar——1943-10-14UHC-10426-17N/AUNKNOWNN/A1000 Washington StDallasTexas—N/A····
TPATPA-615492026-01-16T04:55:03Zrussell—schultz1964-07-04——(539) 281-5153RUSSELL.SCHULTZ@AOL.COM--····—GRP-1080-
CLMCLM-4116022026-07-25T01:25:48ZAmanda—Hansen1968-12-11—NULL··+1 392 829 8480N/Anullnull-null—NAVIGATE-HMO
ENRENR-1089442026-08-30T18:29:46Z virginia—clark··2/25/1948UHC-21787-94•••-••-9678+1 969 605 2278VIRGINIA.CLARK@PROTON.ME670 Sage CourtGlendaleArizona85356GRP-8363CORE-HMO
TPATPA-507202026-06-03T19:59:26ZHenryK.Powell2008-12-15——null··-9155 MOUNTAIN VIEW DRMinneapolisMN55442--
CLMCLM-4164872026-10-11T10:20:33ZBRIAN—BELL1960-31-06UHC-05015-78··N/AnullBRIAN.BELL@HOTMAIL.COM—·N/ANULLNULLGRP-1457MEDICARE-ADV-B
CLMCLM-4280022026-06-04T18:03:44ZGaria, Helen——1/28/1973UNKNOWN—9082605200null8801 Forest AvenueFresnoCA93720nullN/A
ENRENR-1167682026-03-16T15:01:49ZFields, DebraK—1973-06-12UHC-12024-33•••-••-5843(701) 527-9901debra.fields@yahoo.com1358 PINE DRIVE··PhoenixAZ85093··GRP-3147CORE-HMO
ENRENR-1112962026-03-17T04:15:07Zjacob—ramos1995-08-12UHC-33058-43•••-••-702616749511125JACOB.RAMOS89@AOL.COM1304 SAGE CTLas VegasNV89131GRP-5590OPTIONS-PPO
TPATPA-619282026-09-02T03:36:17ZCHRISTIAN—CLARK1953-09-17—N/A——2938 Maple AvenueCHANDLERAZ85239GRP-5516·MEDICARE-ADV-A
TPATPA-597512026-10-13T07:39:28ZSCOTT—SPENCER1986-04-25—•••-••-3324nullN/A8322 Apache BoulevardJacksonvilleFL32255-CHOICE-PLUS-PPO
TPATPA-605762026-08-16T11:12:50ZCruz, Kyle——May 2, 1947—UNKNOWN——·2342 Church St·JacksonvilleFL32226—-
TPATPA-569212026-04-24T23:06:46ZRANDY—GRIFFINnull—N/AN/AUNKNOWN3473 PINE DRIVESeattleWA98129GRP-1807UNKNOWN
ENRENR-1421492026-03-07T00:21:54ZHeather—Robinson2006-09-18UHC-35050-60•••-••-1057711-599-0097UNKNOWN··1313 Canyon RdLOS ANGELESCA90085GRP-1901CORE-HMO
CLMCLM-4054002026-07-02T03:43:32Z MarilynWNguyen1982-03-21—•••-••-13719505968736·N/A6415 Broadway Apt 31TempeArizona85256GRP-1167··CORE-HMO
ENRENR-1264582026-03-27T07:04:05ZDavid—Pteerson1982-03-16uhc-64170-21•••-••-288313687919880—1308 Apache BoulevardAtlantaGA30308GRP-0173··MEDICARE-ADV-B
TPATPA-520722026-06-27T05:57:44ZDan—Butler1953-12-10UHC-11269-20———5515 Maple AvenueLas VegasNV89179NULLUNKNOWN
TPATPA-609172026-10-11T14:38:22ZELIZABETH—JONES··02/25/96N/AnullUNKNOWN—9833 Oak StreetLOS ANGELES·CA90087-6424NULLN/A
CLMCLM-4110842026-01-29T06:05:34ZGibson, Mei——1977-07-16UHC-57095-09nullN/AUNKNOWN·4459 Mesa DrLos Angeles·California90095GRP-3366OPTIONS-PPO
100,000 rows, page 7 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-19T19:54:25.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty