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-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
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
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
ENRENR-1032862026-03-03T10:20:53Z·Diana—Bennett1401-99-64UHC-02217-16•••-••-77486489880225diana.bennett@aol.com··7866 Sunset BoulevardMinneapolisMN··55487GRP-1937SELECT-EPO
ENRENR-1125032026-01-31T05:36:57Z JonathanGBowman·Sep 3, 2001UHC-40062-05•••-••-8645986-552-0170NULL·54 GRAND AVE Apt 7MIAMIFLN/AGRP-0102core-hmo
ENRENR-1210782026-02-13T16:11:04ZaishaUcampbell1997-01-28UHC-52441-29•••-••-0975255-827-6600UNKNOWN·9819 Indian School RoadMESAAZ85239GRP-2543CHOICE-PLUS-PPO
ENRENR-1366472026-07-15T04:00:07ZPeterson, Brittany——14-04-1980UHC-26138-49•••-••-2786309.874.7741NULL4303 Elm StreetEden PrairieMinnesota55362GRP-6834MEDICARE-ADV-A
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
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
ENRENR-1221842026-02-16T05:27:55ZAISHA—GERCIA1994-04-27UHC-35298-45•••-••-1534—aisha.garcia@gmail.com·6404 Union StSacramentoca95876GRP-6218SELECT-EPO
ENRENR-1253232026-09-17T06:54:37Z·Mei—West1967-06-26UHC8942495•••-••-0631686.885.2208MEI.WEST@GMAIL.COM9560 Lincoln WayAUSTINTX78729GRP-7786SELECT-EPO
ENRENR-1338732026-05-18T15:54:47ZamyJjacobs1952-01-01UHC-84427-31•••-••-480613709816363·amy.jacobs74@outlook.com5267 Main Street··San DiegoCA92158GRP-6221··CHOICE-PLUS-PPO
ENRENR-1139242026-01-22T04:24:32ZMarquez, Gregory——2005-03-18UHC1999931—18656524871gregory.marquez14@hotmail.com7419 OAK STFresnoCA93772GRP-8523SELECT-EPO
ENRENR-1408952026-05-21T21:45:30ZValentina···IAsutin1988-08-03-UNKNOWN+1 965 778 4466VALENTINA.AUSTIN11@HOTMAIL.COM1695 Grand AvenueTucsonAZ85774GRP-4516···MEDICARE-ADV-A
ENRENR-1312612026-06-10T19:03:16ZWAYNE—GREENE1965-06-25UHC-20352-89•••-••-8600(474) 291-8899NULL1458 Indian School RoadAustinTX78781GRP-6555OPTIONS-PPO
ENRENR-1037122026-08-21T10:45:37ZHEATHERO.··LAWRENCE1964-05-06UHC-82881-79—890.447.9951heather.lawrence34@proton.me1794 Elm StreetGlendaleAZ85376GRP-3993SELECT-EPO
ENRENR-1119892026-06-06T01:58:35ZGaryXReynolds11/01/1968UHC-12263-87•••-••-1352390-961-9471GARY.REYNOLDS@HOTMAIL.COM5823 Elm StreetTampaFL33608GRP-5298CHOICE-PLUS-PPO··
ENRENR-1032152026-05-07T22:53:31ZHeather··—Howard1954-04-18UHC-56509-49•••-••-6968818-539-4398HEATHER.HOWARD@AOL.COM784 Forest Avenue #867HoustonTX77048-0148GRP-3368CHOICE-PLUS-PPO
ENRENR-1168672026-02-13T21:50:25ZWilliamP.Black1967-03-21UHC-48987-35•••-••-2878210-934-2109william.black@proton.me5405 Sunset BlvdJACKSONVILLEFL32243GRP-0440OPTIONS-PPO··
ENRENR-1183332026-04-13T21:22:10ZKATHRYNAORTEGA1944-08-18·UHC-71038-15•••-••-6815·8819934947null7208 Union StreetPlanoTX75025GRP-4846MEDICARE-ADV-B
ENRENR-1382922026-06-25T14:40:14ZLisaH.Taylor9183-09-14—•••-••-6237·(241) 847-3837LISA.TAYLOR@GMAIL.COM1069 Baseline RdEDEN PRAIRIEMN55389-0152GRP-4158options-ppo
ENRENR-108202 2026-07-24T12:29:31ZJEREMY··WELKERMay 11, 1958UHC-68255-89•••-••-1537N/AUNKNOWN7404 Lincoln WaySeattleWA98133-3716GRP-2826SELECT-EPO
ENRENR-1348402026-09-27T13:30:51ZPAUL—LUNA1961-02-24UHC7199441•••-••-7538(379) 650-4133··paul.luna@outlook.com9527 GRAND AVEFresnoCA93765GRP-0457NAVIGATE-HMO
ENRENR-1117942026-06-03T00:43:17ZCHRISTINA—GONZALES·11/26/1963UHC-49127-77•••-••-1587NULLchristina.gonzales83@yahoo.com3686 Lake View RdSCOTTSDALEAZ85219GRP-0404NAVIGATE-HMO
ENRENR-1115512026-05-27T10:43:03ZWILLIE F—WOOD12-05-1977UHC-01701-76•••-••-2790(953) 435-3831WILLIE.WOOD@YAHOO.COM8425 Ridge RdMesaAZ-GRP-1866OPTIONS-PPO
ENRENR-1108282026-05-08T21:17:02ZDAVIDYCOOK1981-11-05UHC-17459-59•••-••-4845899-764-3225null9354 Valley View DrDallasTX75223GRP-8882MEDICARE-ADV-A
ENRENR-1191742026-09-02T04:33:47ZMASONY.·WEAVER1946-08-27UHC-94503-02•••-••-1652328-708-4598MASON.WEAVER31@PROTON.ME248 Palm DrFresnoCA93706-3675GRP-4446MEDICARE-ADV-A
ENRENR-1296642026-10-01T16:46:29Z·TIMOTHY··RIOS1947-03-18UHC-68272-84•••-••-6250411.598.8712TIMOTHY.RIOS74@GMAIL.COM8728 Sage Court Apt 36Miamifl33123GRP-0521CORE-HMO··
ENRENR-1092972026-07-06T15:38:25ZRogers, Sharon——Mar 15, 1971UHC-06338-10•••-••-4191-N/A6906 Apache BlvdHoustonTX77080GRP-9468OPTIONS-PPO
ENRENR-1085952026-10-16T15:38:41ZRalph—·Rice1946-07-03UHC-00945-46•••-••-213712046802370RALPH.RICE91@HOTMAIL.COM7218 River RdAustinTX78726GRP-1068SELECT-EPO
ENRENR-1064952026-05-19T11:35:09ZVincentHHart4/5/1976··UHC9916301•••-••-7483860-939-0189—3166 OAK STMinneapolis··MN55413GRP-8250CHOICE-PLUS-PPO
ENRENR-1127342026-06-03T03:17:02Zchristopher—ruiz1946-03-21UHC-69936-01•••-••-0589+1 985 440 4038christopher.ruiz@icloud.com7578 OCEAN AVENUESACRAMENTOCA95811GRP-8920CORE-HMO
ENRENR-1131162026-08-20T05:19:58ZgeraldZcarpenter5/7/1978UHC-74053-63•••-••-06925949028540····6030 Meadow Ln··TucsonAZ85772GRP-7822MEDICARE-ADV-A
ENRENR-1268042026-06-10T09:03:09ZValentinaOWheeler1953-05-22UHC-44407-74•••-••-8271(964) 527-5872··N/A4300 VALLEY VIEW DRNashvilleTN37203GRP-4683SELECT-EPO··
ENRENR-1046202026-08-08T04:55:34ZSharon—·Welch1939-01-15UHC-81282-68•••-••-813412978056533sharon.welch@icloud.com1841 Sunset BoulevardSan AntonioTX78225GRP-8033··MEDICARE-ADV-A
ENRENR-1142922026-08-16T21:12:11ZTheresa—Murray20040925UHC-22222-28•••-••-9012(365) 922-0740—799 Willow CourtScottsdaleAZ··85261GRP-6119MEDICARE-ADV-B
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
ENRENR-1057782026-03-03T15:57:29ZElizabeth—Lane12-12-2001UHC-44016-48•••-••-8583-ELIZABETH.LANE@ICLOUD.COM6454 Meadow LnPhoenix·AZ85013GRP-6254CORE-HMO
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
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
43,101 rows, page 18 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.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty