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-1037002026-05-20T07:00:04ZDanielleIRuiz1986-03-25uhc-31158-95•••-••-0095(243) 772-4978danielle.ruiz@aol.com754 PARK PLLAS VEGASNV89143GRP-3243CHOICE-PLUS-PPO
ENRENR-1046382026-06-13T21:05:19Z·MarthaZTurner1962-05-24UHC-64123-35•••-••-7999329-956-5867martha.turner@hotmail.com4111 Lake View RoadMinneapolisMN···55432GRP-4876MEDICARE-ADV-A
ENRENR-1419452026-06-16T18:10:58Z Weber, CarlosY—13-02-1951··UHC-41704-07•••-••-4951+1 332 584 3106CARLOS.WEBER@OUTLOOK.COM9779 Main StreetTucsonAZ85731GRP-0197CHOICE-PLUS-PPO
ENRENR-1072832026-05-21T03:16:05Zhelen Y.—nichols1953-01-22UHC-51783-98•••-••-86552822684718HELEN.NICHOLS@HOTMAIL.COM··3877 Washington StreetPlanoTX75016-4134GRP-8762MEDICARE-ADV-B··
ENRENR-1252402026-07-01T17:38:07ZTheresa—McDonald2006-06-14UHC-82860-66•••-••-341217657923963THERESA.MCDONALD@AOL.COMNULLUNKNOWNNULL—GRP-5254CHOICE-PLUS-PPO
ENRENR-1338252026-03-28T09:28:14ZRICHARD—ALVAREZ1952-08-20—•••-••-527612852452763NULL7885 SUNSET BOULEVARDPhoenixaz85080-1048GRP-9148SELECT-EPO
ENRENR-121337 2026-03-07T13:20:03ZChristianILarson··05/02/06UHC-67827-03•••-••-9986+1 332 809 3429christian.larson@aol.com4251 Ocean AvenueGILBERTAZ··85285GRP-3002MEDICARE-ADV-A
ENRENR-109475 2026-06-16T22:57:54Zbrue·O.—1963-04-13UHC-75859-83•••-••-842618042921422bruce.hart@aol.com8947 Market St··ChandlerAZ85288GRP-1286MEDICARE-ADV-A
ENRENR-1069252026-10-12T13:59:44ZSHIRLEYAAGUILAR1942-06-07UHC-40159-36•••-••-7668+1 446 376 8663—1882 BroadwayChandlerAZ85241··GRP-0560MEDICARE-ADV-B
ENRENR-1374602026-04-10T01:29:44ZRamos, HiroshiJ—11/16/99UHC-35776-22•••-••-67804739190104hiroshi.ramos13@aol.com2146 CEDAR LNPhoenixAZ85029GRP-5033CHOICE-PLUS-PPO··
ENRENR-1103252026-09-16T16:30:04ZKEIVNJCHAPMAN·1968-09-13UHC-72065-17•••-••-333813668072920KEVIN.CHAPMAN@PROTON.ME3206 Meadow LaneScottsdaleAZ··85205-4894GRP-1525·MEDICARE-ADV-A
ENRENR-1341212026-08-04T23:21:18ZSofiaGFord·1963-07-11·UHC-08071-66·UNKNOWNN/Asofia.ford98@hotmail.com6650 Lincoln WayChandlerAZ··85278GRP-2600NAVIGATE-HMO
ENRENR-1351062026-07-21T18:26:26ZCHRISTIAN·VNICHOLS19820102UHC-34917-20•••-••-6261637.473.3033christian.nichols@gmail.com··4721 Indian School RoadAtlantaGA30371GRP-6947OPTIONS-PPO
ENR ENR-1384212026-07-11T13:21:10ZBRITTANYJRICHARDSON19521202UHC-80551-30•••-••-1206591-771-0659BRITTANY.RICHARDSON@PROTON.ME4734 Baseline RdPLANOTX75079GRP-1357CORE-HMO
ENRENR-1286702026-05-20T13:35:16ZCatherine—Peterson08/10/54··UHC-33326-02•••-••-95316258836765—4080 Canyon RdPhoenixAZ85057-1103GRP-3840OPTIONS-PPO
ENRENR-1405242026-08-13T03:37:33ZMateoL.Grant10/22/1969UHC-05095-06•••-••-9878(732) 380-3755mateo.grant@hotmail.com2240 Hillcrest RdFresnoCA93736-5866GRP-8215MEDICARE-ADV-B
ENRENR-1428882026-09-24T14:23:44ZAhmed—Luna12/09/64UHC-66164-08—9086134201N/A6240 Union StLos AngelesCA90065GRP-9853medicare-adv-a
ENRENR-1030792026-09-13T06:19:57ZLARRYSWASHINGTON12/10/1982UHC-42860-77•••-••-9060909.625.5792LARRY.WASHINGTON93@AOL.COM475 SPRING STREETGlendaleAZ85372GRP-7298MEDICARE-ADV-B
ENRENR-1346612026-09-26T23:15:40ZABIGAILWBANKS09/20/1942UHC-27644-46•••-••-5863—UNKNOWN9274 OAK STTempeaz85200GRP-8019MEDICARE-ADV-A
ENRENR-1115822026-04-19T08:28:45Z·DeniseQ.Williams1797-03-28UHC-36325-58•••-••-21532975597302denise.williams44@gmail.com··3684 INDIAN SCHOOL RDJACKSONVILLEFL32290GRP-0329OPTIONS-PPO
ENRENR-142200 2026-02-28T21:24:32ZJuliaN.OwensOct 15, 1948UHC-06290-38•••-••-5893--9236 BroadwayPLANOTX75087GRP-4827MEDICARE-ADV-B
ENRENR-1157312026-02-07T00:17:40ZJulieWHoward1981-12-13UHC-57228-80•••-••-60272648095JULIE.HOWARD@PROTON.ME7117 Lake View Rd Apt 35TempeAZ85231GRP-7770CORE-HMO
ENRENR-1391682026-07-09T13:00:26ZAmber—JemesFeb 27, 1942UHC-46412-55•••-••-4350(839) 860-7413amber.james@proton.me3347 FOREST AVESacramentoCANULLGRP-4899·NAVIGATE-HMO
ENRENR-1256352026-09-06T10:22:22Zbrandon··sanders8/17/1993UHC-71390-78•••-••-7198+1 258 662 9641BRANDON.SANDERS@YAHOO.COM9596 Mountain View DrPHOENIXAZ85027GRP-3547medicare-adv-b
ENRENR-1015922026-02-05T19:19:30ZCHARLES—ALEXANDER1967-06-27UHC-20262-22•••-••-9137318.585.3630UNKNOWN1535 Washington StPlanoTX75071GRP-8204MEDICARE-ADV-B
ENRENR-1303852026-06-28T22:16:50ZYuki—Mitchell1949-10-22UHC-96258-27··•••-••-7599(758) 260-4838yuki.mitchell@yahoo.com4916 RIVER ROADNASHVILLETN37251GRP-5262NAVIGATE-HMO
ENRENR-1116922026-01-07T14:31:21ZMARIANA—MASON·17-12-1965·UHC-25369-28UNKNOWN4572467847··—7478 Mountain View DriveJacksonvilleFL32270-6239GRP-9760SELECT-EPO
ENRENR-1414082026-02-04T00:28:08ZShirley—Perez1954-06-19·UHC-31141-31NULL455-754-5893nullUNKNOWN··-NULLUNKNOWNGRP-4282MEDICARE-ADV-B
ENRENR-1071352026-03-04T16:10:43Z Brian··—Lopez1975-12-14UHC-54662-88-—brian.lopez78@icloud.com3821 CENTRAL AVENUEOrlandoFL32825·GRP-0195NAVIGATE-HMO
ENRENR-1076422026-05-01T20:11:56ZFREEMANQKENNETH··19570919UHC-86967-68•••-••-5977(628) 400-5044kenneth.freeman20@icloud.com8864 Palm DrivePlanoTX75032GRP-0318NAVIGATE-HMO
ENRENR-1041122026-04-01T01:48:04Z ·Devis, CarlosZ—1969-10-11UHC-97594-71•••-••-8560-carlos.davis96@proton.me7596 Indian School RdPhoenixAZ85098GRP-1240MEDICARE-ADV-A
ENRENR-1424552026-01-18T01:24:17ZRebecca—OBryen·19920213·UHC-36142-71•••-••-12443202513113··—9549 CEDAR LNTampaFL33654GRP-4115SELECT-EPO
ENRENR-115184 2026-01-23T06:33:03ZMichael—Parker8/22/1942UHC-39601-87—922-775-9439MICHAEL.PARKER@AOL.COM2195 CHURCH STREETSeattleWA98158GRP-8729CHOICE-PLUS-PPO
ENRENR-1375142026-05-02T10:05:38ZAnaFJimenez19580901UHC-89148-48•••-••-8427NULLana.jimenez60@hotmail.com3228 Mountain View DriveCharlotteNC28278··GRP-3896SELECT-EPO
ENRENR-1343672026-08-29T19:11:17ZSandra—Evans1977-08-19UHC7412121•••-••-1914467.822.6975sandra.evans@icloud.com4678 SPRING STTampaFL33684·GRP-5789MEDICARE-ADV-B
ENRENR-1135782026-07-15T12:25:54ZBRITTANYHALLEN1982-06-22UHC-24335-94UNKNOWN7912226329brittany.allen93@icloud.com6472 Desert Sky BoulevardPhoenixAZ85083GRP-3777OPTIONS-PPO
ENRENR-1211102026-01-06T21:47:13ZFlores, Rth·W—2008-03-05··•••-••-4559(907) 368-1366ruth.flores53@icloud.com2065 Elm StColumbusOH43214GRP-8809MEDICARE-ADV-A
ENRENR-1193972026-04-03T05:15:35Zlori—jones11/17/64UHC-48852-57•••-••-6206869-678-6494LORI.JONES@PROTON.ME7860 Mesa Dr·Atlanta·GA30367GRP-1543CHOICE-PLUS-PPO
ENR ENR-1045912026-09-18T19:48:13ZHeatherNRoss1991-12-27UHC-78235-70··•••-••-51579252842084null6031 Forest AvenuePlanoTX75048GRP-8687MEDICARE-ADV-B
ENRENR-1351632026-04-24T06:08:16ZAlexisLHoward1982-01-11UHC6164873•••-••-1422UNKNOWN--UNKNOWNUNKNOWNnullGRP-7323MEDICARE-ADV-B
ENRENR-1025172026-03-16T15:35:06ZRachel T—Burns1978-10-24UHC7780001•••-••-7630787.281.1378—47 UNION STREETColumbusOhio43255GRP-8680core-hmo
ENRENR-1338472026-03-29T13:12:59ZAndreaD.Vazquez1968-06-26UHC-21934-77•••-••-6809(251) 926-0884····7940 Lake View RoadJacksonvilleFL32207GRP-0586CHOICE-PLUS-PPO
ENRENR-1057272026-10-05T00:06:33ZSANTIAGOU.FERGUSON·03/12/66UHC-76518-54•••-••-23157278331495SANTIAGO.FERGUSON@OUTLOOK.COM··733 Spring StreetLos AngelesCA90089GRP-0212MEDICARE-ADV-A
ENRENR-1224612026-01-21T09:40:34ZMatthewC.Alexander05/08/88uhc-16478-31•••-••-0962—null9294 HIGHLAND AVEMiami·FL—GRP-3086SELECT-EPO
ENRENR-1345162026-08-27T01:13:23ZCarolynJWilson19640424UHC-81583-75··•••-••-7448475-689-6287carolyn.wilson24@proton.me2570 Valley View DrJacksonvilleFL32243GRP-2624MEDICARE-ADV-B
ENRENR-1175162026-02-09T17:24:05Z Dennis··Boyd19900209UHC-62213-03•••-••-0328(397) 613-5821dennis.boyd@icloud.com614 HILLCREST ROADPlanoTexas75077GRP-3209CORE-HMO
ENR ENR-1361152026-06-30T20:24:07ZKIMBERLY·QELLIOTT1980-04-02—•••-••-866912869472180KIMBERLY.ELLIOTT@YAHOO.COM5434 HILLCREST ROADSeattleWA98157GRP-5702NAVIGATE-HMO
ENRENR-1087132026-02-08T02:04:30Zdonald··—torres1963-09-18UHC-28843-56•••-••-0657+1 758 748 5754DONALD.TORRES28@AOL.COM4999 JEFFERSON AVENUE·CharlotteNC28240GRP-8974NAVIGATE-HMO
ENRENR-1275712026-09-21T01:20:42Z·CHRISTIAN—SALAZAR··1972-06-19UHC-51574-82•••-••-974915026391812christian.salazar@gmail.com7422 Camelback RdMiamiFL33146-7352GRP-9973CHOICE-PLUS-PPO
ENRENR-1337132026-07-04T03:03:15ZPhilip—Graham1968-07-26UHC-18122-45•••-••-6629(784) 975-7003philip.graham@proton.me9561 Grand AvePhoenix·AZ85028GRP-5297options-ppo
43,101 rows, page 138 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:38.461Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty