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-4233832026-04-16T23:58:43ZSean·IGuerrero1950-04-09·UHC7819888—366-936-1407UNKNOWN86 Market StreetTampa··FL··33617—NAVIGATE-HMO
TPATPA-623882026-06-03T21:21:33Z·Jimmy—Reed1945-03-19··—•••-••-6251N/AN/A4459 WASHINGTON ST Apt 22·TEMPEArizona85220UNKNOWNSELECT-EPO
ENRENR-1345962026-02-21T15:42:17ZALBERTQDOMINGUEZ24-10-1962UHC-79602-45•••-••-659512636157292albert.dominguez@gmail.com299 Bayshore DrHouston··tx77007GRP-2578NAVIGATE-HMO
CLMCLM-4155132026-08-17T04:11:27ZOLIVIA—PARKER1982-07-27—UNKNOWN+1 607 977 7656———N/A··GRP-4741NAVIGATE-HMO
CLMCLM-4213382026-02-23T11:29:22ZSTEPHANIE—ALVARADO1994-11-24—•••-••-2016921-791-9909—7956 CAMELBACK RDLAS VEGASNV89197GRP-6826····
TPATPA-632902026-09-08T05:15:54ZAlexis—Weber1980-03-26null—NULLUNKNOWN5247 Market StreetCOLUMBUSOH43208GRP-9991MEDICARE-ADV-B
CLMCLM-4170092026-02-02T08:10:42ZCharles—Porter2004-04-09UHC-37973-20··-·NULLN/A9313 Forest AvenueSacramentoCalifornia95829—OPTIONS-PPO
PRVPRV-223202026-09-03T10:30:16Z·Ahmed—Vega1991-05-16-UNKNOWN391-433-2193—1975 Jefferson AvenueSan Diego·CA92114-—
ENRENR-1266172026-02-02T05:51:31ZJacqueline—Bennett2004-07-10UHC-17708-15•••-••-2064896-286-7056··jacqueline.bennett@aol.com8163 Palm DriveChandlerAZ85258GRP-4846CORE-HMO
CLMCLM-4013872026-06-02T02:24:49ZGrant, Katherine——Apr 28, 2008N/A··—(343) 978-2209null7447 Valley View DriveTempeAZ·85289GRP-6993-
CLMCLM-4282132026-04-30T22:46:44ZCarlGMurray1/19/1998UHC-43401-37—(885) 787-4803—1170 ELM STREETPhoenixAZ85048GRP-7951CHOICE-PLUS-PPO
CLMCLM-4274602026-04-05T15:26:28ZLoriU.Ellis10/21/1947UHC-66036-03null664-784-1979··—7470 Bayshore DriveScottsdaleAZUNKNOWNnull—
CLMCLM-405381 2026-05-12T10:20:02ZAnthony····Banks1996-05-13UHC-83550-98UNKNOWN———··—-GRP-4419MEDICARE-ADV-B
ENRENR-1300372026-06-27T10:51:20ZBetty—Evans1998-04-26UHC-40645-66•••-••-39195924058betty.evans81@aol.com5941 Apache BoulevardMiamiFL33166GRP-7514CHOICE-PLUS-PPO
CLMCLM-4128262026-07-27T14:25:05ZTHOMAS··LRSOE1951-06-06UHC-81794-28—935-235-9096——·-—··GRP-6828CORE-HMO
ENRENR-1181572026-05-09T05:44:33Z·jonathan—evans10/24/38UHC-49583-74—8563434896jonathan.evans@proton.me1311 PALM DRAustinTX78722GRP-0696CHOICE-PLUS-PPO
ENRENR-1420612026-05-14T13:27:28ZRALPH··MORALES2006-07-13··UHC-26733-64•••-••-6237+1 944 514 9745—2543 LAKE VIEW ROADGlendaleAZ85327GRP-1601NAVIGATE-HMO
ENRENR-1232672026-06-28T20:10:41Z·JACK—MEYER19960612UHC-47355-03•••-••-90338493974JACK.MEYER@GMAIL.COM8203 Mesa DriveSan DiegoCA92140GRP-9085NAVIGATE-HMO
ENR ENR-1305702026-07-07T04:13:50ZPorter, TerryS—1985-12-08····—(673) 562-0045TERRY.PORTER@PROTON.ME6723 Indian School RdTucsonAZ85768-6347GRP-7059SELECT-EPO
ENRENR-1255292026-06-21T00:11:03ZAlbert··—Ellis—UHC-85432-06•••-••-22049452836060ALBERT.ELLIS6@YAHOO.COM·860 Ocean AveHOUSTONTX77050GRP-0344navigate-hmo··
ENRENR-1074922026-07-21T21:18:28Z·SCOTTTMARTIN24-02-1968-•••-••-7555—SCOTT.MARTIN23@HOTMAIL.COM9285 Washington StLas VegasNV89108GRP-2575CORE-HMO
PRVPRV-274472026-04-23T06:09:55ZRICHARD—·CRUZ2008-02-16UHC-30512-30-+1 663 939 9759-9194 Mesa DrHoustonTX77008—-··
CLMCLM-4297192026-09-13T03:00:47ZDaniel··Martinez··May 21, 1964nullnull9676271166—NULL——null—MEDICARE-ADV-A
ENRENR-1117112026-03-30T01:42:03ZBradley··IBaker1997-02-18UHC-79476-20null··268-791-6853BRADLEY.BAKER66@YAHOO.COM·5704 Broadway #750SacramentoCA95852GRP-1436NAVIGATE-HMO
CLMCLM-4222332026-03-30T05:35:23ZPatrick··—Phillips08-04-2007-•••-••-81607923964622-1604 Church StreetChandlerAZ85262—CORE-HMO
CLMCLM-4221652026-06-29T13:31:30ZBILLYRCOLLINS19410606NULL•••-••-0654UNKNOWNnull1834 MOUNTAIN VIEW DRAustinTX78762GRP-1665MEDICARE-ADV-A··
ENRENR-1417682026-02-15T07:37:38ZMaria—Hart6/22/1957UHC-81705-80•••-••-1876+1 883 416 9940maria.hart@hotmail.com6164 Oak StreetTempeAZ85263GRP-8325CORE-HMO
ENRENR-1079882026-04-26T09:53:11ZJOSEPHF.HENDERSON07/25/1940··UHC-18059-43•••-••-6740986-745-4693··null3798 Market StAtlantaGA30310GRP-1499SELECT-EPO
TPATPA-614842026-08-09T18:54:52ZMark—Padilla28-04-1968UNKNOWN—N/Amark.padilla95@proton.me7838 HARBOR BLVDFresnoCA93748UNKNOWNCORE-HMO
CLMCLM-4142992026-04-04T18:09:36Z MARILYN—HICKS02/26/43UHC-38790-56•••-••-4656·202-989-0959null·4833 Mountain View Drive Apt 30Austin·TX78799—CHOICE-PLUS-PPO
CLMCLM-4073862026-04-09T01:32:21ZKatherine—James2001-09-14·UHC-01774-66•••-••-5880-UNKNOWN6636 Highland AvenueMiamiFL33180-7593nullnull
CLMCLM-4177002026-01-18T12:33:46ZNOAH—ROGERS1958-04-08——8824235999—NULL———nulloptions-ppo··
CLMCLM-4123082026-08-01T16:34:55ZRichardson, AngelaT—1947-10-24UHC-54092-76-—null7082 Oak StreetHoustonTexas77046GRP-8505·NULL
TPATPA-569332026-01-23T23:31:33ZJeremy····Duncan1969-05-17—UNKNOWNNULLN/A6026 Main StreetFRESNO·CA93731-SELECT-EPO
PRVPRV-272812026-03-20T13:20:52ZSAMANTHAS.ADAMS1997-01-12UHC-60115-83NULL——6922 SAGE CT #957FresnoCA93727N/ASELECT-EPO
ENR ENR-1149962026-05-24T12:13:42ZTimothy—Howeell1969-12-13··UHC-99708-59•••-••-360115867772438N/A831 Washington StSacramento··CA95835-7467GRP-7270OPTIONS-PPO
PRVPRV-248782026-03-13T23:19:22ZBRANDON··—STEVENS11/18/1976—UNKNOWN6343461500brandon.stevens@hotmail.comUNKNOWN-UNKNOWNUNKNOWN——
ENRENR-1128922026-07-27T14:52:14ZHernandez, Joseph——1973-03-03UHC-40659-34•••-••-0579nullNULL4451 Canyon RoadSan DiegoCalifornia92169GRP-0601MEDICARE-ADV-A
ENRENR-1384032026-03-07T21:54:51ZKELLY—ESTRADA19380412UHC-02997-73•••-••-4051(926) 435-4007kelly.estrada22@icloud.com··4645 Baseline RdLos AngelesCA90088GRP-0282CORE-HMO
ENRENR-1009592026-08-06T06:30:16ZJanet—Pena1944-10-07UHC-61706-54··•••-••-27548356548050JANET.PENA@ICLOUD.COM3537 Valley View Dr Apt 3MinneapolisMN55462GRP-3762OPTIONS-PPO··
ENRENR-1315932026-10-04T21:40:51ZGregoryXPrice0724-19-91·UHC-11694-58•••-••-73166752818221gregory.price64@proton.me3676 HARBOR BOULEVARDTampaFL33699GRP-5557CORE-HMO
TPATPA-638432026-01-02T09:47:35Zjohn—holmes19831010—•••-••-508313549491986UNKNOWN1760 FOREST AVEDALLASTX75231-1292GRP-8874MEDICARE-ADV-A
ENRENR-1018872026-06-05T16:11:06ZKeithM.Payne2/13/1997UHC-82936-46NULL8374687938····8137 Cedar LnOrlando··FL32808GRP-9970options-ppo··
CLMCLM-4304152026-08-17T00:38:46ZValentina—Guerrero··1977-09-18—•••-••-1057(568) 666-8856—7765 Grand AvenueColumbusOH43232GRP-1522OPTIONS-PPO
PRVPRV-291282026-07-24T12:44:51ZSEANZFLORES4/12/1975-——UNKNOWN8026 Camelback RdMiamiFL33122UNKNOWN-
CLM CLM-4036592026-09-21T06:21:47ZMelissa—Kennedy10-04-1958uhc-01988-89N/A568-277-1981melissa.kennedy@yahoo.com————NULLMEDICARE-ADV-B
CLMCLM-4105202026-06-18T06:04:11ZEvelyn··—West12/24/1995UHC-84463-14•••-••-6952NULLUNKNOWN1337 FOREST AVENUETempeArizonaNULLGRP-5684—
ENRENR-1301582026-04-05T16:56:28ZdeniseGsantos1941-05-09·UHC-13629-11null3186096823—5275 MAPLE AVENUEAtlantaGA30372GRP-3765MEDICARE-ADV-A
CLMCLM-4142412026-03-26T09:06:53ZGabrielB.·Roberts20-03-1981UHC7071512•••-••-7165NULLNULL5611 MAPLE AVENashvilleTN—GRP-6060NAVIGATE-HMO
ENRENR-1186952026-05-16T21:03:29ZLoriIAustin2003-07-23UHC-45897-76•••-••-73986905672213UNKNOWN··3574 CEDAR LANEFresnoCA93760GRP-2336MEDICARE-ADV-A
100,000 rows, page 132 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.691Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty