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-624332026-03-24T11:31:15ZJUDITH—ESPIINOZA1987-06-10-null16165697187N/A403 SPRING STREET Apt 22MesaArizona··85249—NAVIGATE-HMO
ENRENR-103723 2026-03-18T12:47:50ZGloria·F.Flores06/18/49UHC-00099-58•••-••-9582(702) 313-5329GLORIA.FLORES@HOTMAIL.COMN/A·NULLUNKNOWN-GRP-8350MEDICARE-ADV-A
ENRENR-1104462026-08-21T04:21:11ZBEVERLYULEWIS1979-09-21··UHC-51806-33•••-••-9505NULLBEVERLY.LEWIS@GMAIL.COM1731 Sunset BoulevardTempeArizona85252GRP-1037·CORE-HMO
PRVPRV-251272026-05-22T06:59:14ZDOROTHYUDIAZ1979-02-20—•••-••-7399—NULL8960 WILLOW CTAUSTINTX78767null—
CLMCLM-4161052026-10-10T17:49:12ZJonathanH.Oliver1972-10-17null•••-••-0481+1 376 918 5738UNKNOWN708 FOREST AVESan AntonioTX78224GRP-5628—
PRV PRV-252722026-05-13T04:16:16ZJUSTIN—JOHNSON1991-03-02UHC-90635-30—(654) 795-9197JUSTIN.JOHNSON@GMAIL.COM3789 Valley View DrEden PrairieMN55304N/ANULL
TPATPA-580282026-04-15T23:33:34Zrachel—maldonado16-09-1992——932-610-9587—7516 Meadow Lane··Scottsdale··AZ85254—null
CLMCLM-4078732026-06-23T22:49:27ZRussell—Jenkins··Jan 19, 1981UHC-53169-39UNKNOWN13286834487N/A·3948 CHURCH STSacramentoCA95868GRP-5295—
PRVPRV-230582026-03-19T10:29:39ZChristina—Hart1954-04-21—NULL8399833023CHRISTINA.HART88@OUTLOOK.COM6532 Bayshore DriveLas VegasNV89144-4043UNKNOWNCORE-HMO
ENR ENR-1362492026-06-01T13:15:39ZTerry—DuncanJun 12, 1952UHC-13353-55•••-••-4975577-834-9323—7465 RIVER ROADSan Antonio·TX78270·GRP-4020CHOICE-PLUS-PPO
CLMCLM-4049532026-07-15T03:12:51ZStephenTPeterson1980-01-06UHC-33520-06•••-••-3662·NULLUNKNOWN9687 Central AveDALLASTX75221··GRP-1313null
CLMCLM-4276352026-01-10T08:54:16ZMoore, Hiroshi——09/08/1950UHC-19734-64•••-••-31139456011null952 Union Street··GLENDALEAZ85388NULL—
CLM CLM-4230832026-03-14T08:56:17Zmark—·day0607-91-89UHC4088326—+1 869 476 2010-9298 BAYSHORE DRIVECHARLOTTENC28276GRP-2776null
ENRENR-1244882026-09-05T19:14:08Z virginia—cooper1942-04-16UHC-28150-15•••-••-6849485.474.2524—3201 Mesa DriveGilbertAZ85253-1104GRP-9634MEDICARE-ADV-B
CLMCLM-4307082026-08-27T14:47:42ZFATIMAMDELGADO1985-05-02—N/A16523384502··UNKNOWN4355 BroadwayPlanoTX75006GRP-3668CHOICE-PLUS-PPO
ENRENR-1011582026-05-06T15:00:15Z CATHERINEZANDERSON1980-11-28UHC-79718-58—(952) 743-4729catherine.anderson9@proton.me2226 OAK STREETSAN ANTONIOTX78272GRP-8337OPTIONS-PPO
PRV PRV-205802026-02-20T21:23:21Zeevlyn··—lee2007-02-22·UHC-62339-83-+1 701 338 4967-7247 River RoadNashvilleTN37293null—
ENRENR-1129222026-01-28T20:46:10ZDanielleURyanMar 6, 1999UHC8396696•••-••-3899(426) 904-1568UNKNOWN7283 Ocean AvenueSAN DIEGOCA—GRP-8762SELECT-EPO
ENRENR-1223932026-04-01T16:27:16ZStone, ChristinaG.····1983-04-02UHC-45212-97•••-••-7934677-440-8686null2805 HIGHLAND AVE··Fresno··CA93799GRP-4231SELECT-EPO
PRVPRV-223642026-03-29T16:42:38ZCHRISTINE—CHEN1/2/1943-··—·(901) 293-7786christine.chen@aol.com7525 APACHE BOULEVARDAtlantaGA30397—UNKNOWN
ENRENR-1111502026-08-06T11:15:25ZZacharyZ.Anderson1946-11-23··UHC-40167-32··•••-••-24135077621452zachary.anderson@aol.com650 Mountain View Drive Apt 30Los AngelesCA90069GRP-4767MEDICARE-ADV-A
CLMCLM-4153002026-03-24T19:31:36ZLAWRENCE—NICHOLS19410326UHC-23434-16•••-••-3265(598) 597-0939NULL2895 Canyon RoadLAS VEGAS··NV89183nullSELECT-EPO
CLMCLM-4217532026-05-25T21:23:11ZLinda—Johnson1994-09-18····nullUNKNOWNLINDA.JOHNSON@YAHOO.COM3980 Baseline RoadColumbus··OH43215GRP-6065MEDICARE-ADV-A
CLMCLM-4243812026-04-03T13:02:47ZHEATHER—BROOKS07/08/78UHC6222754NULL·822.587.8741—8233 INDIAN SCHOOL ROADPlanoTX-nullNULL
CLMCLM-4321842026-02-03T22:54:30Zmadson—allen10/23/1995—•••-••-3610249-643-9303—N/A———NULL—
ENRENR-1255902026-02-23T12:21:51ZJENNIFER—·DEAN1954-01-02UHC-62336-89•••-••-4319+1 620 542 1689jennifer.dean@outlook.com8007 Indian School RdJacksonvilleFL32204GRP-2382MEDICARE-ADV-A
ENRENR-1075542026-09-03T01:00:06ZKeith··Long1947-10-25—·N/A·+1 615 973 8489keith.long82@icloud.com7989 MAPLE AVENUEMiamifl33196GRP-9336MEDICARE-ADV-A
ENRENR-1004742026-06-20T17:09:34ZLauraD.Henderson1939-09-02UHC-08977-16•••-••-4530nulllaura.henderson@proton.me··6222 UNION STTampaFlorida33684GRP-2687SELECT-EPO
CLMCLM-4021602026-07-06T14:36:30ZSOHPIA—PENA··1952-07-16UHC-35707-30•••-••-3201+1 236 434 3588—--—N/AGRP-6759—
PRVPRV-261812026-02-20T20:14:58ZJANICE—SANDOVAL2003-12-23UHC-66768-58-367-284-8392janice.sandoval68@gmail.com8538 Highland AveORLANDOFL32852—CORE-HMO
ENRENR-1358922026-03-27T18:25:38ZReyes—·Madison19460418UHC-15905-97•••-••-8736383-929-4814····6130 Elm StreetOrlandoFL32897·GRP-1492MEDICARE-ADV-A
CLMCLM-4209672026-01-04T06:50:03ZMelissa—Marshall·1998-06-13UHC-73960-39UNKNOWN··-UNKNOWN4529 GRAND AVEMinneapolisMN55492GRP-0971CORE-HMO
ENRENR-1318402026-04-04T10:52:10ZYoung, Logan—··1962-05-02UHC-67733-21•••-••-43684048507011logan.young@outlook.com7731 Main StDallastx75285-0292GRP-7185NAVIGATE-HMO
CLMCLM-4075032026-04-23T12:52:04ZCamila—·Sandoval·1972-06-25UHC-86804-48—NULL-—NULLnull-UNKNOWNMEDICARE-ADV-A
ENRENR-1162362026-03-31T10:53:41Z CatherineY.·Jamse·09/11/88UHC-83902-40•••-••-8841N/Acatherine.james50@yahoo.com6878 Ridge RoadAustinTexas78756-6575GRP-8919CHOICE-PLUS-PPO
ENRENR-1230232026-02-08T14:49:13ZAmberP.Ortega1979-12-23··UHC-28858-52•••-••-2227724-875-1916····8545 Indian School RdHoustonTX77009-1779GRP-2249OPTIONS-PPO
TPATPA-501012026-03-27T13:09:57Z·Maria—Jenkins19770406UHC-71956-21N/A··925-202-9296NULL9603 Elm StCHANDLERAZN/A·GRP-2841CORE-HMO
ENR ENR-122198 2026-06-17T23:22:58Zdiana··Ljackson18-10-1993UHC-98330-94•••-••-5113+1 680 361 1932diana.jackson52@icloud.com3095 Union StreetSeattleWashington98120GRP-0412MEDICARE-ADV-B
TPATPA-557332026-08-14T11:52:04ZDylan—Hicks1950-10-04null•••-••-7729null—4675 WILLOW COURTTempeAZ85277N/A—
ENRENR-1040072026-02-08T06:18:32ZCynthiaI··NelsonOct 25, 2004UHC-03140-26•••-••-0829(767) 856-7650null1911 LAKE VIEW RDJacksonvilleFL32236GRP-1748CORE-HMO
ENR ENR-1341552026-02-04T23:44:18ZADAMR.VASQUEZ04/07/73UHC-36719-47•••-••-2454941.729.6737—5966 CEDAR LANECHARLOTTENC28288GRP-5346CORE-HMO
PRVPRV-265832026-04-16T09:04:11ZPEER—PAYNE1994-06-07—•••-••-4281(238) 512-8845PETER.PAYNE33@YAHOO.COM4592 MAPLE AVEAtlantaGA30378-7090··-
ENRENR-1148402026-04-25T20:25:58ZAMYP·SALAZAR1945-03-10uhc-32557-38•••-••-6808UNKNOWNAMY.SALAZAR52@AOL.COM·354 OAK STSan DiegoCA··92158GRP-1768NAVIGATE-HMO
CLMCLM-4151212026-04-30T13:46:56Z·Timothy—·Brooks·3/15/1978UHC-96249-54—6567818224UNKNOWN9727 MAPLE AVETEMPEAZ85257NULL—
ENRENR-1138822026-10-12T16:28:52ZCamilaVHayes03/02/82··UHC6179518•••-••-72848904714263camila.hayes8@hotmail.com2645 Willow CtChandlerAZ85232··GRP-9447MEDICARE-ADV-A
ENRENR-1303962026-05-16T00:24:56Z·KYLEXHARPER19970803UHC-68942-57•••-••-8175(267) 980-1331KYLE.HARPER94@HOTMAIL.COM--N/A··NULLGRP-0717OPTIONS-PPO
ENRENR-1204252026-05-17T05:59:10ZPAMELAXSANTIAGODec 17, 1980UHC1126120•••-••-2173·9189099029pamela.santiago@icloud.com3766 Palm DriveAtlanta·GA30373GRP-1707MEDICARE-ADV-B
ENRENR-1287902026-06-14T08:42:30ZCharlieHAnderson2000-08-09UHC-80354-11—841-259-0730charles.anderson56@icloud.com4353 Baseline RoadPhoenixAZ85057GRP-1446CORE-HMO··
ENRENR-1051522026-05-07T22:45:43ZEmily—Montgomery1940-11-03··UHC-50496-48•••-••-0401(620) 710-0493—8482 BAYSHORE DRIVEDallasTX75212GRP-9319options-ppo
ENRENR-1125772026-08-02T16:04:55ZAustin··PMoore2001-02-07UHC-97161-95•••-••-5035715-603-7257austin.moore62@yahoo.com829 Meadow LnPlanoTX75005GRP-1055choice-plus-ppo
100,000 rows, page 127 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.689Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty