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-599012026-10-06T05:44:31ZSsanQSandoval02/16/87—•••-••-5792—susan.sandoval@hotmail.com5988 River RdTempeArizona85250-CHOICE-PLUS-PPO
TPATPA-625292026-06-22T18:53:49ZJUAN—MARSHALL1938-10-26—··-·nullNULLnull——GRP-4061MEDICARE-ADV-A
PRVPRV-204062026-04-13T00:09:09ZNANCY····GEORGE1946-06-28-•••-••-3998313-424-1295NULL6342 Forest Ave #511··Scottsdale·AZ85290····—
CLMCLM-4133332026-06-10T04:04:25ZHenderson, Douglas——1997-01-10—-NULLnullN/A—N/AUNKNOWN——
ENRENR-1313972026-06-04T18:11:23Z CHRISTOPHERPWANG2006-07-22UHC-85700-16•••-••-3545(611) 880-0871CHRISTOPHER.WANG11@PROTON.ME6764 Main StMesaAZ85240GRP-8984select-epo
ENRENR-1289772026-04-22T05:15:46ZERIC Q.··—HUDSON2008-12-03UHC-87974-59•••-••-00357305204618eric.hudson@outlook.com8745 Church Street #311·MinneapolisMNN/AGRP-6377CORE-HMO··
ENRENR-1067182026-08-30T16:15:19ZDanielQGardner02/02/53UHC-59419-25•••-••-0754675-862-1562DANIEL.GARDNER81@HOTMAIL.COM4731 Central Avenue Apt 26··ORLANDOFL—GRP-3727MEDICARE-ADV-A
ENRENR-1216862026-05-24T16:34:16ZAnthony—Cox··1949-08-20UHC-92965-58•••-••-20863599359436anthony.cox@hotmail.com7541 Maple AvenueSan AntonioTX78272GRP-7926MEDICARE-ADV-B
CLMCLM-4071182026-05-12T09:15:39ZAllen, Gloria——1992-09-12N/A··UNKNOWNNULLN/A6590 Lake View RdAustinTX78719-2888—CHOICE-PLUS-PPO
CLMCLM-4070222026-07-08T13:49:03ZDavid—Heenry1964-01-25UHC-48679-36•••-••-5281——4431 Harbor Blvd··CharlotteNC28202-3106GRP-4908UNKNOWN
PRVPRV-228322026-09-21T11:24:05ZGabriel—Wagner1959-04-13··•••-••-67794998731225GABRIEL.WAGNER35@OUTLOOK.COMUNKNOWNUNKNOWN··null····—NULL
ENRENR-1057782026-03-03T15:57:29ZElizabeth—Lane12-12-2001UHC-44016-48•••-••-8583-ELIZABETH.LANE@ICLOUD.COM6454 Meadow LnPhoenix·AZ85013GRP-6254CORE-HMO
CLMCLM-4084222026-03-11T03:53:13ZLauren—Roberts1985-08-02UHC-80177-29•••-••-5850—lauren.roberts@yahoo.com2732 Palm Drive·DenverColoradoUNKNOWNUNKNOWNOPTIONS-PPO
ENRENR-1068702026-09-28T23:36:16ZAlexander····NicholsJun 26, 1970UHC-54969-27··•••-••-8710332-253-7883alexander.nichols@hotmail.com621 Indian School RdSan DiegoCA92184·GRP-3345SELECT-EPO
ENRENR-1081752026-03-22T08:18:08ZLaurenO.Porter09/10/07UHC2056529•••-••-836016206198383lauren.porter13@gmail.com1895 Elm StGlendale··Arizona85335-7398··GRP-8376NAVIGATE-HMO
CLMCLM-4162012026-04-24T10:02:35ZBETTYTGREEN1957-02-08UHC3246884-6344023599N/A7997 Lake View RoadJacksonville·FL32235··GRP-8572CORE-HMO
TPATPA-567742026-09-25T04:26:57Z Gilbert, Hiroshi——1/9/1958—nullNULL—1631 Sunset Boulevard Apt 3San AntonioTX78207null—
CLMCLM-4277672026-04-18T16:09:11ZANTHONY—·HARRIS2002-11-20UHC-93261-88•••-••-6072(836) 439-0145····6767 Palm DriveORLANDOFL32833NULLSELECT-EPO
TPATPA-588052026-05-02T05:51:28Zemma—gardner19-08-1951—•••-••-5075(749) 954-9025—6009 MAPLE AVEMiamiFL33192·NULLSELECT-EPO
CLM CLM-4255592026-09-12T02:05:09ZDonan—Cole1963-10-15UHC-91826-55——-5655 Apache BoulevardCHANDLERArizona85231GRP-5507—
ENRENR-1358612026-09-18T19:29:54ZValentina·V.Griffin9/4/1968UHC-04517-60•••-••-5634+1 371 607 4751valentina.griffin39@icloud.com6018 Washington Street··NashvilleTN37286GRP-3150CHOICE-PLUS-PPO
CLMCLM-4097982026-04-11T05:10:47ZJustinO.Vargas2004-09-15NULLnull(580) 888-0906—3263 HILLCREST ROADLos Angeles·CA90035GRP-2589—
CLMCLM-4153832026-03-22T11:22:57ZTayllor, Santiago——2007-08-18NULLNULL6325400——UNKNOWN-·-null—
ENR ENR-1407112026-05-07T07:04:54ZBillyP·Jenkins09/02/1938UHC-06309-81•••-••-4607NULLBILLY.JENKINS@GMAIL.COM9103 LINCOLN WAYMINNEAPOLISMN55435GRP-4209OPTIONS-PPO
ENRENR-1166072026-06-07T21:44:34ZAmandaUSantos·nullUHC-26059-18•••-••-5858348.671.2651—723 MEADOW LANEAustinTX78729GRP-0850OPTIONS-PPO
PRVPRV-255722026-08-17T09:13:37ZTHERESA··—AUSTIN22-09-1996UHC-47101-37·-18906088000theresa.austin@hotmail.com·8576 CANYON RDMesaAZ85245nullSELECT-EPO
TPATPA-623812026-08-31T21:13:35ZAnthony—GuerreroDec 24, 1953UHC-05111-02•••-••-3970356.778.5681anthony.guerrero@gmail.com1641 Central Avenue #871Los AngelesCA90081—SELECT-EPO
PRVPRV-223942026-04-07T20:02:43ZrebeccaZ.burns1988-10-20··—8017363234rebecca.burns34@outlook.com3762 CEDAR LNEDEN PRAIRIEMN——CORE-HMO
ENRENR-1284372026-04-27T08:07:23ZlarryYmendez··1941-10-16UHC2832436•••-••-86526084636862—5087 Indian School RoadSeattleWA98139GRP-9024OPTIONS-PPO
ENRENR-1253632026-09-02T05:41:17ZChen, MargaretM.—2006-03-02UHC-30588-83•••-••-26699397831372margaret.chen67@outlook.com5495 River RoadSeattleWA98135GRP-9660MEDICARE-ADV-B
CLMCLM-4271942026-07-24T17:59:32ZALBERT··WATKINS2008-09-26··UHC-76579-96UNKNOWN·16938904629NULL6358 RIDGE ROADTucsonAZ85780····OPTIONS-PPO
PRVPRV-228662026-01-17T06:25:32Z·Burton, GaryL—19631018—UNKNOWN926-762-4480—9473 Harbor BoulevardTucsonAZNULLnull—
ENRENR-1022882026-02-15T04:27:30ZEDWARD—CASTRO1947-09-12UHC-16241-24•••-••-120917566232347·edward.castro@yahoo.com1337 HIGHLAND AVENUE #492TempeAZ85210GRP-4391CHOICE-PLUS-PPO
PRVPRV-23052 2026-03-25T12:43:27ZWalter—Griffin1960-02-26—UNKNOWN(400) 734-1691walter.griffin42@outlook.com6093 Hillcrest RdColumbusOH·43295UNKNOWN-
CLMCLM-4171412026-09-27T08:05:37ZDeborah—JonesJul 11, 1987UHC-84110-46null12157087940NULL145 RIVER ROADSeattleWA98135GRP-7183CORE-HMO
ENRENR-1213782026-06-08T11:06:43ZJerryFHarris2005-02-13UHC-28193-95•••-••-7553(269) 983-3932JERRY.HARRIS@AOL.COM5399 Mesa DriveMinneapolisMN55408GRP-2908CORE-HMO
CLMCLM-4317512026-02-28T01:39:37ZAlan—Gilbert··1966-08-18UHC-57392-18NULLUNKNOWNUNKNOWN5697 Camelback RoadCharlotte·NC28248-8592GRP-5262null
ENRENR-1132542026-09-18T08:16:44ZAhmedJSimmons2003-11-04UHC-02922-05—9834899570ahmed.simmons10@outlook.com4902 Main StreetDallasTXNULLGRP-0417select-epo··
ENRENR-1170152026-04-02T02:24:23ZAngelaTTran1994-07-21UHC-81869-94•••-••-8081431-619-4026ANGELA.TRAN@YAHOO.COM6433 Elm StreetTampaFL·33698GRP-7020·MEDICARE-ADV-B
CLMCLM-4043612026-04-11T01:52:42Z·Burns, Isabella——1948-08-20UHC-10907-04NULL—UNKNOWN709 MOUNTAIN VIEW DRAtlantaGeorgia··30397GRP-4275—
TPATPA-620922026-08-02T19:41:30ZHIROSHI—MATTHEWS1980-11-17null-N/AN/A··3697 Sunset BlvdMESAAZ85243GRP-8380null
CLMCLM-4241972026-02-15T11:11:37ZValentinaMHarvey28-03-1943UHC-49991-78—N/A—7433 BroadwayScottsdaleAZ85261GRP-9644null
CLMCLM-4225452026-02-07T22:48:34ZDunn, Edward———UHC-83791-65•••-••-2763—-4734 Cedar LnLos AngelesCA90061NULLNAVIGATE-HMO
CLMCLM-4147092026-08-18T01:57:34ZTYLER—JONES1946-04-21—•••-••-173814602508316—4500 INDIAN SCHOOL RDPhoenixAZ85069—OPTIONS-PPO
ENRENR-1345762026-01-15T10:53:04Zwei—silva1998-02-01UHC-71426-03•••-••-3229+1 607 387 4740··8972 INDIAN SCHOOL RDNASHVILLE··TN37231GRP-8987MEDICARE-ADV-B
ENRENR-1264282026-01-02T09:28:01ZShirley—Green9/17/1983UHC-09476-10—(527) 607-8623SHIRLEY.GREEN@OUTLOOK.COM9877 Maple AveNashvilleTN37213GRP-9616NAVIGATE-HMO
TPATPA-605842026-01-10T08:52:40ZMariana—Dixon10/07/90null•••-••-3976393.257.7303N/A·6216 Camelback Rd·ScottsdaleAZ85224-1833—NAVIGATE-HMO··
ENRENR-1101132026-06-24T02:05:54Z Frank—Lynch12-08-1967UHC8269128•••-••-38606449173025FRANK.LYNCH@ICLOUD.COM6689 Cedar LaneNashvilleTN37227GRP-8152CHOICE-PLUS-PPO
ENRENR-1242382026-08-18T06:12:26ZJudyDSoto1981-01-26··UHC-64354-17•••-••-43366219908463JUDY.SOTO73@ICLOUD.COM9496 Ridge RoadGlendaleAZ85322·GRP-4402OPTIONS-PPO
TPATPA-605042026-01-14T11:18:26ZASHLEY—NUNEZ1990-04-28UNKNOWN—N/A—-·null——GRP-4718MEDICARE-ADV-A··
100,000 rows, page 41 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.773Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty