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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1039792026-01-15T01:24:23ZJean U.—Stone··19770322UNKNOWN•••-••-8310nulljean.stone75@icloud.com2544 Market StreetSeattleWashington98195GRP-7221MEDICARE-ADV-A
ENRENR-1053052026-05-16T10:47:46ZangelaO··wood2008-09-26UHC-49670-68•••-••-6527687-793-9048··9642 Apache BlvdJacksonvilleFL32264GRP-7768·MEDICARE-ADV-A
ENRENR-1369762026-07-07T04:18:43ZalbertR.··brown1992-04-21·uhc-45592-15•••-••-6016-albert.brown@aol.com1776 Grand AvenueTucsonAZ85787GRP-5128MEDICARE-ADV-B
ENRENR-1191272026-03-30T18:15:01ZLynch, Mei——Dec 25, 1959UHC-40531-35•••-••-9040+1 249 967 1102mei.lynch@proton.me1834 Washington StPlanoTX75091GRP-4660OPTIONS-PPO
ENRENR-1078702026-02-01T12:54:36ZPAMELATWAGNER1960-06-10UHC-90245-31•••-••-8277·2434635405PAMELA.WAGNER32@ICLOUD.COM5087 Sage CtORLANDOFlorida32879GRP-1748SELECT-EPO
ENRENR-1043992026-09-23T13:24:14ZVazquez, Heather——1997-06-06·UHC-76189-52•••-••-7352—HEATHER.VAZQUEZ66@AOL.COM2802 PARK PLSan AntonioTX78238GRP-2992MEDICARE-ADV-A
ENRENR-1193022026-09-21T05:00:29ZROEGR—FERGUSON1964-08-03UHC-10656-36•••-••-1310(282) 202-3973—3919 Cedar LaneHouston·TX77068GRP-3678CHOICE-PLUS-PPO
ENRENR-1297862026-05-04T20:19:53ZLittle, MarianaR—Dec 11, 1994UHC-63829-18•••-••-0562(389) 878-5026mariana.little39@proton.me1124 Ocean Avenue··SeattleWashington98196GRP-2574CHOICE-PLUS-PPO··
ENRENR-1348912026-03-24T16:43:00ZMARIA—PATTERSON1976-09-05UHC-64057-21•••-••-7084205-842-0832··maria.patterson21@yahoo.com6781 Market StSacramentoca95831GRP-3940OPTIONS-PPO
ENR ENR-1135522026-07-30T16:54:20Z KimberlyLLopez06/13/1943UHC-28888-07—+1 726 458 4117kimberly.lopez47@gmail.com8071 Church Street··PhoenixAZ85026-2884GRP-7922··NAVIGATE-HMO
ENRENR-1374892026-07-21T07:31:47Zkimberly—harvey··19870603UHC-59290-66•••-••-4561(804) 860-8885kimberly.harvey85@yahoo.comUNKNOWN-—·UNKNOWNGRP-5536OPTIONS-PPO
ENR ENR-1324022026-08-07T05:41:49ZDIANEBHENDERSON1986-05-23UHC-72231-84•••-••-8079(758) 646-6235diane.henderson@proton.me1581 Valley View DriveSacramento·CA95817GRP-9869MEDICARE-ADV-B
ENRENR-112579 2026-07-02T07:47:39ZDiego—Lawson12/19/96UHC3310305•••-••-4724506-447-5014N/A-——nullGRP-7264MEDICARE-ADV-B
ENR ENR-122790 2026-09-28T01:53:40ZLawrenceZChapman1975-10-20UHC-16649-11•••-••-6989876.400.1961·LAWRENCE.CHAPMAN22@YAHOO.COM3172 OCEAN AVEAustin·TX78770GRP-1895OPTIONS-PPO
ENRENR-1428992026-05-17T12:27:17ZaliceDalvarado1971-06-06··UHC-97558-28•••-••-3882-alice.alvarado3@outlook.com8143 Desert Sky Blvd··OrlandoFL32838GRP-0442core-hmo
ENRENR-1406632026-09-10T01:09:35ZTalor, Kayla——1214-19-62UHC-97205-63•••-••-54734676405791··KAYLA.TAYLOR37@AOL.COM4019 Grand AveLos AngelesCA90098GRP-8720NAVIGATE-HMO
ENRENR-1093132026-05-24T11:10:16ZJACQUELINEHPOWELL10-10-1951UHC1653848•••-••-395318682768132null7462 Palm DriveLas VegasNV89115GRP-5311CORE-HMO
ENRENR-1089832026-09-01T09:59:57ZVIRGINIANCARR1959-09-19UHC-61614-40NULL(325) 445-1452virginia.carr39@gmail.com··9085 CHURCH STREETDallasTX75283GRP-3616MEDICARE-ADV-B
ENRENR-1168052026-07-18T01:10:44ZAlan—Evans··1951-02-22UHC-37825-51•••-••-58955864794NULL3815 DESERT SKY BLVDTucsonAZ85779GRP-1637CORE-HMO
ENR ENR-1300242026-06-14T03:44:30ZTylerAWilliamson·1964-09-15UHC-85579-51•••-••-2526514-415-0235——NULL··NULLUNKNOWNGRP-9362CORE-HMO
ENRENR-1364322026-08-29T02:43:43ZALEXANDERKRAMOS23-02-1952UHC-16972-69•••-••-8889·16829910614alexander.ramos56@gmail.com7874 Central AvenueAtlantaGeorgia30394·GRP-4727MEDICARE-ADV-A··
ENRENR-1041572026-10-08T19:34:26ZmariaB.davis1996-12-03UHC-39155-11•••-••-7541(424) 618-3932maria.davis@aol.com8013 Union StreetMiamiFL··33132GRP-1293MEDICARE-ADV-A
ENRENR-1346292026-03-28T10:30:51ZAlan—Ryan1940-06-15UHC-68642-08•••-••-9571(722) 348-4375-··5901 Grand Avenue #845San DiegoCA92174GRP-4884NAVIGATE-HMO
ENRENR-1364342026-05-21T05:03:57Z·DANIELLE—MENDOZA··11/04/1992UHC-12708-48•••-••-9150(752) 736-3466danielle.mendoza@icloud.com4734 Baseline RdMiamiFL33155GRP-4136OPTIONS-PPO
ENRENR-1157842026-06-12T03:36:38ZMichelle—Hansen19520309UHC-96691-01··•••-••-1556+1 587 236 4637null4178 Baseline RdCharlotteNC28274GRP-5946OPTIONS-PPO
ENRENR-1293482026-01-30T03:57:42ZBrianA.Tucker1990-05-23UHC-84666-16•••-••-3949731-657-8381BRIAN.TUCKER37@HOTMAIL.COM1933 BroadwayCharlotte··NC28269GRP-8646CORE-HMO
ENRENR-1141752026-05-30T23:13:18ZThomasG··Berry2008-05-13UHC-53888-98•••-••-64386187841959THOMAS.BERRY@AOL.COM5287 Jefferson AvenueSACRAMENTOCA95821GRP-3951OPTIONS-PPO
ENRENR-1191642026-06-15T06:50:03Z Billy—Wells1979-07-19UHC-39302-23•••-••-7224(472) 612-8768billy.wells@icloud.com1325 Church StPHOENIXAZ85091GRP-4485NAVIGATE-HMO
ENRENR-1298112026-05-21T00:10:57ZTeresaPFernandez1961-02-16UHC-69915-73null(401) 435-4329-5632 Indian School RoadColumbusOH43229GRP-3970OPTIONS-PPO
ENRENR-1155652026-06-27T10:36:40ZCynthiia A—Matthews1985-07-10UHC-07332-56•••-••-1422605.917.7917cynthia.matthews@proton.me4039 Willow CtMiamiFL33145GRP-3434CORE-HMO
ENRENR-1043812026-06-06T19:53:38ZMichelle—Carroll2006-03-04UHC-82924-06··N/A6109801666—6882 Valley View DrNashvilleTN37265-0426GRP-7424options-ppo
ENRENR-1351322026-06-11T23:16:25Z·SamanthaC.Marshall20021104UHC-35254-25•••-••-26715387852236SAMANTHA.MARSHALL@OUTLOOK.COM·1627 BROADWAYMINNEAPOLISMinnesota55490GRP-6181CORE-HMO
ENR ENR-1339482026-05-23T17:04:25Z·Ralph—Andrews1953-09-20UHC-85599-20-—ralph.andrews64@icloud.com8747 Desert Sky Blvd #928MiamiFL33144GRP-8142MEDICARE-ADV-B
ENRENR-1287332026-01-22T18:32:58ZBeverlyZVasquez1980-01-13UHC1458630•••-••-57352784063649···beverly.vasquez82@icloud.com3211 MEADOW LANEDENVERCO80216-5030GRP-1181MEDICARE-ADV-B
ENRENR-1393912026-04-17T02:16:38ZDickSMurray2000-05-02UHC-12024-59··•••-••-2415(598) 917-0581richard.murray@yahoo.com958 Pine DrSeattle·WA—GRP-4622MEDICARE-ADV-B
ENRENR-1353102026-03-19T15:41:07ZChristina—Washington11/22/1966UHC-41326-42•••-••-13758389215536·····317 BroadwaySEATTLEwa98187GRP-4077OPTIONS-PPO
ENRENR-1430672026-10-11T11:50:25ZZachary—OBrien1948-08-01UHC-85761-47•••-••-28112074450059zachary.obrien37@hotmail.com3899 Main StreetSeattleWashington··98129GRP-2399CORE-HMO
ENRENR-1065872026-05-28T01:35:58Zjulia··—meyer1974-10-05UHC-32929-28•••-••-8629·(450) 833-3637julia.meyer@aol.com2629 Bayshore Dr··SACRAMENTOCA—GRP-1417CORE-HMO
ENRENR-1315302026-02-27T14:08:18Zjustni··boyd20070917UHC-90970-56•••-••-3556NULLJUSTIN.BOYD68@GMAIL.COM3999 Pine DrTempeAZ·85268GRP-4619SELECT-EPO
ENRENR-1174982026-01-05T05:42:58ZDouglas··THenderson10-01-1997UHC-07476-51•••-••-3354+1 770 938 6490douglas.henderson51@proton.me1129 MARKET STEden PrairieMN55365GRP-6336CHOICE-PLUS-PPO
ENRENR-1390142026-04-22T22:18:48ZStevenCMorgan2008-03-28UHC-62140-91•••-••-2566·+1 814 658 3799UNKNOWN622 OCEAN AVENUEGilbertAZ85220GRP-1246CORE-HMO
ENR ENR-1127172026-07-06T14:56:06ZalexanderLwells19630607··UHC-58614-40•••-••-93442883575441alexander.wells62@icloud.com6815 Harbor Boulevard #213SacramentoCA95852GRP-3935MEDICARE-ADV-B
ENRENR-1125422026-01-05T05:04:41ZMARIA·MGIBSON07/08/1961UHC-66677-72•••-••-2572null—5131 OAK ST·SeattleWA98103GRP-6242··NAVIGATE-HMO
ENRENR-1388462026-07-31T04:38:16ZDYLAN—FERNANDEZ20060809UHC-35577-71•••-••-689218673533307null467 INDIAN SCHOOL ROAD #103DenverColorado80234GRP-0792MEDICARE-ADV-A
ENRENR-1177782026-03-26T18:47:59ZBrandon—·Peterson1974-03-12UHC-68516-24•••-••-7639UNKNOWN·brandon.peterson92@yahoo.com8586 Central AvenueGlendale···AZ85392GRP-6540OPTIONS-PPO
ENRENR-1074382026-08-23T07:26:52ZKevinRMills1953-02-28··UHC-89187-11•••-••-75843029913291kevin.mills71@gmail.com7001 Meadow LnSan AntonioTX78233GRP-6184MEDICARE-ADV-B
ENRENR-1380442026-09-21T14:31:38ZNANCY—MARTIN·1947-07-28UHC-66350-74•••-••-6866(818) 544-9260nancy.martin37@proton.me7326 Highland AvenueTEMPEAZ··85243GRP-9879CORE-HMO
ENRENR-120269 2026-09-21T14:54:33ZRonaldG··Flores1996-04-24UHC-43464-13•••-••-072419415542057—7090 Canyon RdSacramentoca95850GRP-9186CORE-HMO
ENRENR-1418852026-01-03T08:44:53ZARTHURSKENNEDY1983-12-05uhc-39550-85—+1 615 303 0100arthur.kennedy@yahoo.com1114 River Road #901·ScottsdaleAZ85215GRP-7501MEDICARE-ADV-B
ENRENR-106221 2026-07-26T05:06:49ZMDonald, Thomas—··May 10, 1970UHC-31865-33•••-••-07848435442205THOMAS.MCDONALD@AOL.COM3061 MARKET STREETNashville·TN37242GRP-2747NAVIGATE-HMO
43,101 rows, page 256 of 863PreviousNext

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:40.642Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty