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-607492026-03-05T14:54:21ZAmy—Parker1963-04-23UNKNOWN•••-••-0161——9756 Lincoln WayLOS ANGELES·CA90067--
CLMCLM-4100912026-06-10T04:40:33ZAISHA··—CHEN1944-10-03·UHC-11222-74•••-••-4187nullnull-NULL——GRP-1380SELECT-EPO··
PRVPRV-274932026-07-06T19:35:24ZAlexander—Guerrero1960-11-25N/ANULL638-569-9871UNKNOWN··N/A——UNKNOWN—CORE-HMO··
ENR ENR-1007912026-02-17T01:11:07ZJOSECPETERSON2007-07-18UHC-04323-58N/A424-761-0886jose.peterson@gmail.com6822 Baseline RdMesaAZ85247GRP-9365OPTIONS-PPO
ENRENR-1326732026-04-23T19:44:35ZralphQwright1942-07-13UHC-37104-79•••-••-9156(463) 481-7600RALPH.WRIGHT28@ICLOUD.COM9787 River RoadPhoenixAZ85064GRP-3227CHOICE-PLUS-PPO
CLMCLM-4295212026-05-18T02:14:09Zwalker—alexander1950-33-08UHC-93561-04•••-••-6258428.628.7492null545 DESERT SKY BLVDGilbertAZ85214GRP-0773CORE-HMO
PRVPRV-266192026-04-25T04:18:46ZCHHRISTIAN··LITTLE1980-06-27——+1 523 396 7937N/A··5811 Church St #309OrlandoFL32888N/A-
ENRENR-1335912026-03-31T09:45:53ZMatthewRMedinaApr 15, 1968··UHC-49080-58UNKNOWN—·matthew.medina@gmail.com8294 GRAND AVEChandlerAZ·85250GRP-6250MEDICARE-ADV-A
ENR ENR-1242792026-07-29T16:11:26ZVICTORIAVMEYER12/15/1945UHC-86900-91UNKNOWN2702328115victoria.meyer@yahoo.com2182 Sunset BlvdLas VegasNV89175GRP-3701CORE-HMO
TPATPA-553902026-10-11T00:52:14ZCarroll, Diego——1953-07-05—•••-••-1902nulldiego.carroll65@proton.meNULLUNKNOWNNULLNULLN/A—
CLMCLM-4074182026-04-12T00:26:04ZRachelOMunoz2004-03-17UNKNOWNN/A898-508-4666rachel.munoz60@aol.com··—-——GRP-5816CHOICE-PLUS-PPO
ENRENR-1144902026-06-20T06:38:53ZMARTHA—GOMEZMay 11, 1944UHC-87887-56•••-••-38394663797384—6080 Cedar LanePLANOTX75035GRP-8396MEDICARE-ADV-B
ENRENR-1419682026-08-27T06:34:18ZMatthew—Greene1950-01-01UHC-91766-10•••-••-11855744343927matthew.greene13@outlook.com2954 Willow CourtSeattleWA98128GRP-3082SELECT-EPO
ENRENR-1039222026-03-28T15:42:20ZMaartin, MasonM.—1938-09-20UHC-62733-27•••-••-2870(487) 791-1460MASON.MARTIN19@HOTMAIL.COM·8500 Apache BoulevardTUCSONAZ85718GRP-4013CORE-HMO
ENR ENR-1059132026-02-14T07:00:35ZJonathan··VCunningham1988-01-15UHC-32520-91•••-••-8456NULLjonathan.cunningham@proton.me8972 Union StMinneapolis··MN55470GRP-2576CORE-HMO
ENRENR-1349512026-03-20T06:40:38Z·AlexisU.Freeman1973-06-24UHC-97467-72•••-••-9785(258) 850-9352ALEXIS.FREEMAN3@GMAIL.COM5193 SAGE COURTMinneapolismn55433-6896GRP-8191·CORE-HMO
CLMCLM-4122002026-10-04T03:35:54ZJackson, Karen··Y—1949-11-02NULL•••-••-7416UNKNOWN—1976 Main StreetTempeAZ-GRP-4402options-ppo
ENRENR-1077482026-02-21T20:16:23ZAISHAI.GRANT1988-08-19UHC-55008-70•••-••-9151567-420-1497aisha.grant25@outlook.com627 River RoadDENVERCO·80285GRP-4207NAVIGATE-HMO
TPATPA-595152026-04-18T13:08:42Zheather—duncan5/5/1946-•••-••-6878793-988-1837-··7012 Central AvenueMesaAZ85231UNKNOWNNAVIGATE-HMO
TPATPA-624452026-01-07T00:03:55Zsantiago—adams12/7/1981··null—null·santiago.adams70@yahoo.com9625 Camelback RoadJacksonvilleFL32274-9640—·SELECT-EPO
ENRENR-141374 2026-07-31T17:06:17ZklyeN.gonzalez1940-12-07UHC-63081-75•••-••-8636860.617.2136KYLE.GONZALEZ35@AOL.COM7257 Highland AveLAS VEGASNV89149GRP-3133MEDICARE-ADV-B
ENRENR-1153962026-08-30T22:01:55ZRandy·ZMaldonado1999-08-04UHC-32441-24•••-••-03759193952834randy.maldonado19@aol.com·5269 CHURCH ST #762TucsonAZ85782··GRP-3490··MEDICARE-ADV-B
ENRENR-1108132026-09-26T17:26:21ZGrace··Webb1950-04-21UHC-94686-06•••-••-4258null·grace.webb26@aol.com2962 Maple AvenueSacramentoCA95873GRP-2751NAVIGATE-HMO
CLMCLM-4019452026-08-02T03:20:33ZChristina··—Nguyen2003-04-20UHC-52000-64null—null9150 Harbor Boulevard···San DiegoCA92182-4990··GRP-9381-
CLMCLM-4175922026-07-30T00:24:55ZDylan··N.·Meyer05-05-1984—UNKNOWN+1 983 640 6382N/ANULLNULL··—NULLNULLNAVIGATE-HMO
CLM CLM-4292432026-05-14T13:26:43ZNICOLE—JORDAN1958-06-05UHC-95049-23NULL665-214-2279—7092 Maple Ave Apt 7Houston··TX···77017GRP-7366null
PRVPRV-205902026-05-13T19:01:22ZMEI—ESTRADA91580613NULLN/A·(986) 775-0981MEI.ESTRADA@GMAIL.COM8211 Church StreetTempeAZ·85267-null··
CLMCLM-4126532026-02-02T09:17:07Z Charlotte··—Fox10-03-1978UHC-60940-57--N/A·657 Jefferson Ave Apt 31SAN ANTONIOTX78201-2632GRP-3881SELECT-EPO
ENRENR-106312 2026-10-13T11:49:52ZSchmidt, Bradley——·4/16/1954UHC-91040-77N/A957-353-5031bradley.schmidt33@aol.com7492 CAMELBACK RDEden Prairiemn55395-6099GRP-1574OPTIONS-PPO
TPATPA-522292026-02-15T01:04:38ZSOFIA—FULLER14-08-1956···N/A•••-••-7324N/Asofia.fuller@icloud.com9744 Cedar LnTUCSONAZ85784GRP-7381-
ENRENR-1235762026-03-06T04:33:13ZJudithH.West1965-07-26UHC7808357•••-••-7460(386) 812-8971judith.west37@hotmail.com9842 BROADWAYGilbertAZ··85238GRP-7381CORE-HMO
ENRENR-1048952026-10-17T14:45:43ZStephanieOGilbert1958-12-07UHC-50252-24•••-••-8524706-261-6752stephanie.gilbert10@gmail.com1392 Hillcrest RoadTempeAZ85254GRP-5920NAVIGATE-HMO
CLMCLM-4081872026-09-03T20:09:24ZAbigail—Woods6/22/1967UNKNOWN•••-••-3891N/AN/A8938 Camelback RoadJacksonville··FL32262-8231GRP-4361··OPTIONS-PPO
ENRENR-1032862026-03-03T10:20:53Z·Diana—Bennett1401-99-64UHC-02217-16•••-••-77486489880225diana.bennett@aol.com··7866 Sunset BoulevardMinneapolisMN··55487GRP-1937SELECT-EPO
CLMCLM-4306922026-08-12T04:28:23ZJOSE—HAVREY1970-03-26UHC-69584-36—494.531.3776NULLnullUNKNOWN··——GRP-2001CORE-HMO··
TPATPA-622922026-02-02T13:41:21ZDylan····Cole··2004-07-01UHC-93588-47—258-293-0050NULLN/A—NULL—GRP-8895NULL
ENRENR-1125032026-01-31T05:36:57Z JonathanGBowman·Sep 3, 2001UHC-40062-05•••-••-8645986-552-0170NULL·54 GRAND AVE Apt 7MIAMIFLN/AGRP-0102core-hmo
TPATPA-533902026-06-02T17:50:56ZMartinez, Jennifer——1975-04-05————3815 Highland Ave #906NashvilleTN37279-—
ENRENR-1210782026-02-13T16:11:04ZaishaUcampbell1997-01-28UHC-52441-29•••-••-0975255-827-6600UNKNOWN·9819 Indian School RoadMESAAZ85239GRP-2543CHOICE-PLUS-PPO
CLMCLM-4207022026-08-23T04:36:24ZLauren—Gutierrez·10/10/1942NULL—440.908.3769—5474 Indian School RoadChandlerAZ85220-5524N/AMEDICARE-ADV-A
PRVPRV-292752026-05-05T06:25:25ZArthur—Valdez1996-08-18UHC-18114-77null14296674000-8255 Ocean AvenueColumbus··OHNULLNULLNULL
ENRENR-1366472026-07-15T04:00:07ZPeterson, Brittany——14-04-1980UHC-26138-49•••-••-2786309.874.7741NULL4303 Elm StreetEden PrairieMinnesota55362GRP-6834MEDICARE-ADV-A
PRVPRV-220512026-02-24T04:26:34ZKnight, DanielleF.··—1957-08-19NULL-(899) 369-5753null8549 Jefferson AveGILBERTAZ··85220UNKNOWNMEDICARE-ADV-B
ENRENR-1194402026-03-15T20:31:00ZSCOTTFJONES1977-04-02UHC-43870-30•••-••-9457+1 363 710 5177scott.jones@icloud.com2441 Forest AveHoustonTX77022GRP-2908MEDICARE-ADV-A
ENRENR-1030742026-03-31T05:04:57ZFRANK··—SANTIAGO··1946-02-25UHC-15366-30•••-••-1455268-621-4170··UNKNOWN4144 Desert Sky BoulevardTAMPAfl33686GRP-0351NAVIGATE-HMO
CLMCLM-4122912026-03-18T16:52:23ZVirginiaF··Ross07/13/1999UHC-44106-88nullN/A—6241 Main StreetOrlandoFloridanullGRP-7113—
ENRENR-1011012026-08-02T01:22:39ZDon—Morrison11/26/1970UHC-52599-41•••-••-7589826-579-0735DONALD.MORRISON@PROTON.ME6285 PARK PLACEDenverCO80283·GRP-7842MEDICARE-ADV-A
ENRENR-1036672026-07-20T11:58:01ZWilliam—Chavez2002-04-28UHC-79231-34•••-••-0571947-793-8916WILLIAM.CHAVEZ38@GMAIL.COM8109 Valley View DrMinneapolisMN55491GRP-9296··SELECT-EPO
ENRENR-1234802026-01-13T20:04:49ZadamOrodriguez16-06-1997UHC-87609-65•••-••-4691+1 448 537 9656adam.rodriguez@icloud.com7818 Oak StSan DiegoCA92131GRP-9831MEDICARE-ADV-A
ENRENR-1113632026-08-20T02:53:32ZRios, Cheryl····—19471004UHC-04103-47—17477868492—·4133 River RoadMINNEAPOLISMinnesota55477GRP-9460CORE-HMO
100,000 rows, page 39 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.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty