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-1305552026-04-03T02:13:47ZYukkiZ.Wright1986-02-22UHC-59968-86•••-••-5612946.683.5588—9017 PINE DRIVEJacksonvilleFL32241GRP-6785SELECT-EPO
ENRENR-1242012026-10-03T11:24:01Zchristine—wilson22-04-1976UHC-06620-20•••-••-8736nullchristine.wilson@proton.me9378 Canyon RdCharlotte·nc—GRP-8285MEDICARE-ADV-A
ENRENR-1244432026-09-02T23:10:09ZsusanZalvarez1965-11-01UHC-58484-22•••-••-68218814367108susan.alvarez@proton.me8399 RIVER RD··San Diegoca92108GRP-1759NAVIGATE-HMO
ENRENR-1127042026-09-29T07:52:51ZCarol—Howell1942-02-16UHC-35472-34•••-••-4766+1 433 593 6242—7900 MESA DRIVEGlendaleAZ—GRP-3984SELECT-EPO
ENRENR-1290792026-10-06T09:23:58Z·PatrickCPerry03/14/41UHC-46043-58•••-••-9912·7205086916PATRICK.PERRY84@AOL.COM1482 Indian School RdMinneapolisMN55408··GRP-6710CORE-HMO
ENRENR-1283062026-08-22T16:29:36ZERICFREED··1963-01-18UHC-79375-83•••-••-67702111128null8032 Market St Apt 36DenverCO·80263GRP-0990MEDICARE-ADV-A
ENRENR-1146182026-02-28T03:37:23Z·JeanU.Thomas9/5/1942UHC-89179-46•••-••-6794(229) 920-8257JEAN.THOMAS@YAHOO.COM7194 Ocean AveScottsdaleAZ85242GRP-1854MEDICARE-ADV-B
ENRENR-1153662026-10-09T22:02:01ZJacob··Richards08/16/03UHC-68186-91•••-••-17014035636538N/A5371 Lincoln WayAUSTINTX78733GRP-2775MEDICARE-ADV-B
ENRENR-1216962026-03-26T04:40:28ZBrittany—Gilbert02/15/2002UHC-09613-64NULLUNKNOWNbrittany.gilbert19@hotmail.com4053 Ridge RdATLANTAGA··30382GRP-5128MEDICARE-ADV-A
ENRENR-1287572026-03-07T18:08:57ZHannah—Carlson1975-11-20UHC1489354•••-••-005317082454469HANNAH.CARLSON61@ICLOUD.COM2563 Forest AvenueCharlotteNC28277GRP-2002SELECT-EPO··
ENRENR-1423262026-04-18T18:41:08ZCARLZ.WEST1/6/1992·UHC4211204•••-••-5055·6097489464carl.west73@yahoo.com3663 GRAND AVEGlendaleaz85353GRP-1270NAVIGATE-HMO··
ENRENR-107336 2026-04-01T16:55:54ZAaron··UMorrison1970-05-11UHC-12185-91··•••-••-2776(757) 363-4652aaron.morrison30@hotmail.com6790 SAGE COURTNashvilleTN37223GRP-4365CHOICE-PLUS-PPO
ENRENR-1098132026-07-13T04:58:54ZMason—Ramirez03-05-1964UHC-58089-01··•••-••-01055642570MASON.RAMIREZ@GMAIL.COM3165 Spring StreetFresnoca93769··GRP-7674CHOICE-PLUS-PPO
ENRENR-1202522026-10-02T08:28:13Zbobyb—chapman14-07-1998UHC-34658-22null6199083428bobby.chapman12@gmail.com3244 Central AveSan Diego··ca92182·GRP-1118SELECT-EPO
ENRENR-1267972026-02-20T06:21:23ZKelly····Phillips6/3/1999UHC-92671-52•••-••-66417003394KELLY.PHILLIPS24@ICLOUD.COM7460 Sunset BlvdJacksonvilleFL32292GRP-8356MEDICARE-ADV-B
ENRENR-1262902026-10-17T02:22:42ZSOFIAQWILLIAMS1970-02-20UHC-94539-95•••-••-8854(256) 356-5103SOFIA.WILLIAMS@HOTMAIL.COM3918 Pine Drive··AustinTX78796GRP-3178··CHOICE-PLUS-PPO
ENRENR-1201852026-03-10T04:17:35ZteresaG.grdon1991-07-14UHC-38136-28•••-••-81219567337385TERESA.GORDON67@OUTLOOK.COM1022 Camelback RdEden PrairieMinnesota55372GRP-6360SELECT-EPO
ENRENR-1337942026-09-15T17:05:57ZPerry, Denise——1957-06-25UHC-72358-97•••-••-27219299768570denise.perry93@aol.com7200 Forest Ave··Orlando··FL32862GRP-0609MEDICARE-ADV-A··
ENRENR-1397942026-03-25T06:10:27ZBRIAN—BURKEJun 24, 2003uhc-91013-14··—9425866095brian.burke@gmail.com4636 Union StreetFresnoCAnullGRP-6879CHOICE-PLUS-PPO
ENRENR-1338882026-01-26T15:03:05ZSANTIAGO···HUNT19660321UHC6595430•••-••-4815(551) 613-1042santiago.hunt@aol.com8227 Apache BoulevardEden PrairieMN55369GRP-9147MEDICARE-ADV-A
ENRENR-1004662026-05-01T17:10:59ZAmberPNguyen02/06/74UHC-57730-01•••-••-4536(756) 306-8536amber.nguyen@gmail.com6177 MOUNTAIN VIEW DRIVESacramentoCA95815-1378GRP-4426SELECT-EPO
ENRENR-1052312026-10-11T13:00:23ZMaryD.Romero·04/13/43UHC-71438-17•••-••-9554(587) 970-0560NULL1277 RIVER RDDenverCO80265GRP-6185MEDICARE-ADV-B
ENRENR-1039732026-06-23T10:46:24ZJEAN·NSANTIAGO1943-08-12UHC-49960-87•••-••-1516578-661-3242jean.santiago@gmail.com3517 Highland AvenueLos AngelesCA90038GRP-6746CORE-HMO
ENRENR-1209562026-07-17T14:51:35ZJUDITH—·LUCAS19813208UHC-82017-35•••-••-2317428-405-0195judith.lucas47@hotmail.com5675 BAYSHORE DR #815OrlandoFL··32894GRP-6205options-ppo
ENRENR-1276522026-02-05T19:44:13Z joseJchapman1947-03-16UHC-16119-29•••-••-8839971.326.5250—3582 PINE DRIVESacramentoCalifornia95883GRP-2013CHOICE-PLUS-PPO
ENRENR-1017802026-06-23T03:11:01ZHanson, Thomas··L—19611203UHC-43892-40•••-••-0349(666) 610-5579thomas.hanson27@icloud.com226 Elm StDallasTX75212-4855GRP-2901NAVIGATE-HMO
ENR ENR-1192232026-09-23T16:02:59Z—K—Mar 15, 1971UHC-94640-27•••-••-2799(301) 239-0145terry.dixon50@icloud.com547 Oak StreetPlanoTexas75088GRP-1293CHOICE-PLUS-PPO
ENRENR-1313892026-01-26T20:02:36Z·CarlosRMason1958-05-03UHC-55182-09•••-••-2818·9574322791CARLOS.MASON@HOTMAIL.COM2022 Harbor Boulevard #504EDEN PRAIRIEMN··55352GRP-5929CHOICE-PLUS-PPO
ENRENR-1192962026-09-10T23:59:19ZCHRISTINAS.JENSEN19750508UHC-36910-95··•••-••-93265782657807christina.jensen38@hotmail.com6045 Cedar LaneNashville··TN37287GRP-0608MEDICARE-ADV-B
ENR ENR-1245912026-07-22T21:02:09ZHANNAHOWILLIS1953-07-05UHC9476684•••-••-8195·(894) 873-9282hannah.willis@outlook.com6978 MAPLE AVENUESan AntonioTX78297GRP-9890OPTIONS-PPO
ENRENR-1098472026-08-06T02:17:06ZJudyRRose1991-12-22UHC-66936-96N/A453.885.0988N/A2851 Sunset BoulevardMinneapolisMinnesota55417-5053GRP-0413MEDICARE-ADV-B
ENRENR-1192852026-02-15T10:30:09ZBrooks, AlbertW—1974-06-08UHC-42974-77•••-••-2140504-209-8908ALBERT.BROOKS67@GMAIL.COM883 Ocean AvenueSan AntonioTX78221GRP-6499MEDICARE-ADV-A
ENRENR-1426592026-08-13T05:27:28ZPamela—·Alvarado20030104UHC-72222-89•••-••-8376(692) 893-0604—144 Mountain View Dr Apt 2Eden PrairieMN··55355GRP-8286MEDICARE-ADV-B
ENRENR-1136932026-02-18T18:52:27ZkeellyP.miller23-09-1977UHC8744696•••-••-6318(774) 876-7147KELLY.MILLER@OUTLOOK.COM·1236 Sage CourtGilbertAZnullGRP-2462CORE-HMO··
ENRENR-1035912026-04-18T12:17:05ZAMANDA—·BURTON1974-06-26··UHC-03306-23•••-••-4010(860) 951-4650amanda.burton@yahoo.com··9383 Camelback Road #591SacramentoCA95828GRP-5064NAVIGATE-HMO··
ENRENR-1320332026-08-08T22:30:13ZDOUGLAS··SHAW··06/09/03·UHC-63265-53•••-••-7975(730) 360-2095DOUGLAS.SHAW@GMAIL.COM7808 UNION STREETSan DiegoCA92129-2056GRP-3642navigate-hmo
ENRENR-1061442026-07-13T07:17:05ZMARGARET····SMITH1976-01-15UHC2507163•••-••-5006334-259-1824····1446 Ridge RoadCHANDLERAZ85248GRP-4715OPTIONS-PPO
ENRENR-1069462026-05-16T00:47:09ZSandraA.Alvarado1/28/1982UHC-71767-16•••-••-5721887-902-7880UNKNOWN5572 Lake View RoadAustin··TXNULLGRP-6380SELECT-EPO
ENRENR-1279962026-01-13T04:36:21ZLoriQSantiago1993-02-12UHC-83318-54•••-••-13584878488971LORI.SANTIAGO54@GMAIL.COM3583 Hillcrest Rd·TEMPEAZ·85206GRP-4156SELECT-EPO
ENRENR-1167792026-05-21T13:20:08ZDiae—Torres1983-03-20UHC-21486-93•••-••-84053974765diane.torres41@yahoo.com8329 SUNSET BLVDPlanoTX75081GRP-0751·MEDICARE-ADV-B
ENRENR-1307522026-04-09T13:35:38ZReyes, RussellZ····1978-03-02UHC-38084-98•••-••-964217557756914····4693 SAGE CTTampaFL33696GRP-4733OPTIONS-PPO
ENRENR-1218762026-04-06T15:55:25ZISABELLA··—WALLACE·1940-01-09UHC2183917•••-••-52389137400231·ISABELLA.WALLACE75@AOL.COM2483 Bayshore DrDALLASTX75253-2361GRP-8128CHOICE-PLUS-PPO
ENRENR-1230602026-02-01T04:57:54ZYuki—Parker1978-11-15UHC-70943-90•••-••-670615495991759-6713 Forest AvenueGilbertAZnull·GRP-5279MEDICARE-ADV-B
ENRENR-1083242026-05-27T00:09:18ZYUKI—PERRY19861226UHC-54099-89•••-••-6815(204) 615-2118yuki.perry@outlook.com··2416 INDIAN SCHOOL RDSAN ANTONIOTX78299·GRP-3578SELECT-EPO
ENRENR-107999 2026-10-12T17:28:58ZSantiagoNPhillips11/01/1962UHC-37995-02•••-••-3636(549) 302-5584—9067 Forest AvenueSAN ANTONIOTX78242GRP-8708OPTIONS-PPO
ENRENR-1290952026-01-26T01:18:04ZCARLOS—SIMPSON··1987-11-11UHC-76249-46•••-••-333618092640377N/A5282 Lake View Road··SeattleWA98175GRP-9756SELECT-EPO··
ENRENR-138144 2026-08-01T04:18:30ZjonathanO·mendoza19970120UHC-18541-92•••-••-28576033249527—5911 Meadow LnDallasTX75203-1033GRP-6954·NAVIGATE-HMO
ENRENR-1190632026-03-09T11:02:47ZGEORGEW.LITTLE3/14/2001UHC-78943-67-4195680505george.little80@gmail.com9260 CEDAR LANEOrlandoFL32841GRP-7540OPTIONS-PPO
ENRENR-1187302026-07-11T01:30:23ZBryan—Graham1952-04-08UHC-91389-39•••-••-7202+1 773 355 9998bryan.graham87@yahoo.com238 Jefferson AvenueSan AntonioTX78204GRP-2969MEDICARE-ADV-B
ENRENR-1309532026-10-02T18:46:48ZJanice—Banks··1964-06-22UHC-81252-69··•••-••-3679721.618.3607janice.banks9@gmail.com··7977 ELM STOrlandoFL··—GRP-7782NAVIGATE-HMO
43,101 rows, page 27 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:34.784Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty