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-1144092026-09-24T07:40:00ZPatrickP··HendersonApr 8, 1943UHC-99656-49•••-••-0604NULLpatrick.henderson30@aol.com7023 Lake View RoadTAMPAFL33661-4494GRP-0704CORE-HMO··
ENRENR-1400362026-02-07T06:55:18ZBennett, JeffreyT.—1990-09-06UHC4901133•••-••-2653280.906.9485jeffrey.bennett18@outlook.com2845 Ocean AvenueTucsonAZ··85744GRP-7744CHOICE-PLUS-PPO
ENRENR-1267642026-10-17T12:55:48ZDOUGLAS—ALLEN1953-09-02··UHC-14793-72··•••-••-8463731-723-5113douglas.allen@icloud.com3383 Meadow Ln·San AntonioTX78245-5353GRP-6022CORE-HMO
ENRENR-1409872026-09-09T16:52:25ZARJUNX.·CRAWFORD1971-06-23UHC-35273-61•••-••-4655·14133761866arjun.crawford@aol.com8223 Highland AveEden Prairie·Minnesota55372GRP-2439NAVIGATE-HMO
ENRENR-1349822026-10-06T09:18:11ZJANETR.OWENS1981-08-15UHC-62051-86null768-564-1982janet.owens@aol.com4116 Sunset Boulevard #285ORLANDOFL32884GRP-6020NAVIGATE-HMO
ENRENR-1361332026-04-18T08:59:04Zwillie—valdez1988-02-17UHC-39473-35•••-••-7609·6848812897—·5816 Washington StCHARLOTTENC28254GRP-8452CHOICE-PLUS-PPO
ENRENR-1082252026-05-26T09:39:31ZLucas, LoganL—1985-09-26UHC-61131-87•••-••-55799295223998—3084 Desert Sky BoulevardMesaAZ85281GRP-7543NAVIGATE-HMO
ENRENR-1067552026-08-21T13:48:58ZAlexisQRamirez04/18/1964UHC-68210-89•••-••-5017—alexis.ramirez@icloud.com7736 OCEAN AVEGILBERTAZ85257-0978GRP-4541CHOICE-PLUS-PPO
ENRENR-1244572026-05-15T22:16:46ZRoyB.Rios02/26/1972UHC-25856-56•••-••-3420+1 713 318 7215NULL7323 INDIAN SCHOOL RDNASHVILLETNNULL·GRP-1844NAVIGATE-HMO
ENRENR-1090262026-06-14T21:50:47ZBrianJTaylor1941-09-09UHC-39486-76•••-••-9406287.278.4657BRIAN.TAYLOR@ICLOUD.COM3111 MESA DRIVEColumbusOH43207GRP-5834·OPTIONS-PPO
ENRENR-1051672026-10-08T04:00:35ZPhilipFPrice1999-11-07UHC-90654-46•••-••-0639+1 554 834 2963PHILIP.PRICE@YAHOO.COM1953 HILLCREST ROADGILBERT·AZ85296GRP-4964MEDICARE-ADV-B
ENRENR-1074962026-03-22T00:50:46ZAnn—Pierce1953-08-08UHC-55298-56•••-••-7943387-864-9646ANN.PIERCE@ICLOUD.COM6418 Main StreetColumbusOH43287GRP-2860··CORE-HMO
ENR ENR-1297222026-03-02T06:34:43ZRichardO.SantiagoMay 9, 1986UHC-26774-18•••-••-983016607451570N/A9782 Bayshore DriveAUSTINTX78722GRP-3077MEDICARE-ADV-A
ENRENR-1291192026-06-06T05:33:30ZShirleyOThomas1948-01-12UHC-72311-42•••-••-0727·UNKNOWNshirley.thomas60@gmail.com·9291 Mountain View Dr·MiamiFL33127GRP-6211MEDICARE-ADV-A
ENRENR-1302192026-08-25T04:22:58ZVIRRGINIAFPADLILA1973-02-07UHC-44228-34•••-••-5920950-954-0358virginia.padilla37@hotmail.com1491 Highland AveSacramentoCA95806-6193·GRP-6821MEDICARE-ADV-A
ENRENR-1315202026-03-17T06:33:07ZJudyWWatkins1973-04-08UHC-12017-24•••-••-55077947686283judy.watkins42@icloud.com5633 Market StreetColumbusOH43270-5700GRP-8024MEDICARE-ADV-A
ENRENR-1036782026-06-30T13:19:49Zrobert—·contrerasApr 8, 2000UHC-89869-73•••-••-1306(407) 833-7462robert.contreras15@gmail.com4976 Harbor BlvdLas VegasNV89119GRP-4461OPTIONS-PPO
ENRENR-1054672026-02-26T05:01:57ZSharonBSantos1990-01-28UHC-46936-59•••-••-406219059848621sharon.santos9@aol.com6404 BAYSHORE DRIVEDenverCO80272GRP-7557CHOICE-PLUS-PPO
ENRENR-1204672026-02-01T21:57:54ZKim, Wei——1968-03-07UHC-37453-94•••-••-457617787425992NULL7066 Hillcrest RoadHoustonTexas77052GRP-2960SELECT-EPO
ENRENR-1130432026-07-20T10:04:29ZAnna U····Montgomery8/20/1975UHC-65162-84—321.282.2059anna.montgomery@proton.me2502 JEFFERSON AVECharlotteNC28238GRP-6962SELECT-EPO
ENRENR-1133672026-07-10T01:55:06ZMorales, Mariana····—09/22/1966UHC-90870-54•••-••-7141321.597.6007mariana.morales4@yahoo.com212 DESERT SKY BLVDSan AntonioTX78212GRP-1508MEDICARE-ADV-A
ENRENR-1334332026-05-17T08:54:11ZTylerL.Meyer1977-10-09UHC-28108-92•••-••-8588·877-296-1996tyler.meyer14@yahoo.com2624 Elm StJACKSONVILLEFL··32221GRP-9451MEDICARE-ADV-B
ENRENR-1149272026-05-19T12:27:37ZNICHOLAS····SANDERSJun 19, 1987UHC-13695-16nullN/Anull7213 Pine DrHoustonTX77036GRP-8393MEDICARE-ADV-B
ENRENR-1214632026-09-15T13:53:36ZNicoleULittle1984-04-07UHC-13450-33•••-••-73842072563145nicole.little45@aol.com4572 GRAND AVEHoustonTX77011GRP-0775MEDICARE-ADV-B
ENRENR-1171262026-04-14T21:41:20Z·DEBORAHO··GORDON1941-05-26UHC2506901•••-••-268213398306272··deborah.gordon91@proton.me6829 Ridge RdHoustonTX77007GRP-0932CORE-HMO
ENRENR-1411192026-02-23T04:03:46ZBradleyLSilva2006-03-08UHC-52424-70•••-••-47138055883195UNKNOWN7257 Broadway·MESAArizona85235GRP-4204OPTIONS-PPO
ENRENR-1118002026-03-15T02:24:38ZEmilyYScott1987-08-19UHC-19898-07•••-••-721419332972501emily.scott30@icloud.com··5675 Oak StreetTampaFL33610GRP-8898OPTIONS-PPO
ENRENR-1426782026-09-24T05:45:54ZGordon, Isabbella——08/24/07UHC-44059-85•••-••-3740—isabella.gordon34@aol.com752 Mountain View DrLos AngelesCANULLGRP-7921·MEDICARE-ADV-B
ENRENR-1378182026-10-12T15:23:29ZJanet—·Roberts02/27/1979UHC7328948—711-843-1152janet.roberts42@aol.com1058 Union StChandlerAZ85238GRP-1108select-epo
ENRENR-107240 2026-09-19T14:00:33Z·THERESA—HARVEY1953-09-10UHC-27595-69N/A8924151theresa.harvey@gmail.com1065 Lake View RdMesaAZ85219GRP-6085SELECT-EPO··
ENRENR-1379212026-07-03T14:58:27ZSEAN—MILLERSep 4, 1994UHC-14551-01•••-••-2824541.807.4470sean.miller42@outlook.com1209 APACHE BOULEVARDAtlantaGA·30318GRP-1706NAVIGATE-HMO
ENRENR-133586 2026-01-14T18:27:53Zangela··gonzalez1964-02-05UHC-81998-51•••-••-8334+1 292 305 9509angela.gonzalez@gmail.com·1263 Meadow LaneTempeAZ85255GRP-5059CORE-HMO
ENRENR-1040492026-01-25T22:45:58ZsofiaOjordan2004-12-20UHC6402040•••-••-4429(432) 243-7969sofia.jordan33@outlook.com8382 CHURCH ST··PlanoTX—GRP-2050MEDICARE-ADV-B
ENRENR-1222042026-06-08T09:38:22Zmichelle—chavez1992-04-26UHC-36979-40•••-••-2758(764) 418-0305michelle.chavez@proton.me·5832 Sunset Boulevard·ScottsdaleArizonaUNKNOWNGRP-5925CORE-HMO
ENRENR-1044482026-03-24T10:40:28ZCarr, Bruce——19960221UHC-44424-97•••-••-35476935033122—null··—--GRP-2228OPTIONS-PPO
ENRENR-1086722026-03-07T11:15:47ZJeffreyCPorter1976-06-15UHC-09227-06UNKNOWNN/Ajeffrey.porter@aol.com7361 Lake View RoadMiamiFL33114GRP-2490MEDICARE-ADV-A
ENRENR-1067342026-10-11T14:05:06ZDavis, Carl··—1987-07-12UHC-93283-17•••-••-4475509-881-0468CARL.DAVIS@YAHOO.COM——null-GRP-7301··CORE-HMO
ENRENR-1274482026-09-27T12:32:16ZDianaK.Burns2006-11-17·UHC-40188-10NULL19317421158DIANA.BURNS7@OUTLOOK.COM2843 JEFFERSON AVEMiami··FL33120GRP-3530NAVIGATE-HMO
ENRENR-1424292026-09-27T16:08:41ZASHLEY—SILVA1993-05-16UHC-35129-23null3524334723·ashley.silva@aol.com7620 Sunset Blvd··ChandlerAZ85281GRP-2361CHOICE-PLUS-PPO
ENRENR-1369792026-08-21T09:14:04ZChristina—Hawkins03/20/1999UHC-88607-22•••-••-3189(448) 526-2978UNKNOWN4653 Lincoln WayLAS VEGASNevada89117·GRP-9100SELECT-EPO
ENRENR-1224492026-05-09T21:11:05ZTHOMASHCHEN08/09/04UHC-89520-20•••-••-064012769787965thomas.chen@gmail.com5392 Jefferson AvenueChandlerAZ··-GRP-0399MEDICARE-ADV-A
ENR ENR-112178 2026-08-05T13:23:32ZFrancesTSimpson·2006-12-03UHC-33828-41•••-••-1752(344) 789-4435frances.simpson@hotmail.com4657 Forest AvenuePlanoTX75084GRP-6641SELECT-EPO
ENRENR-1273902026-06-20T21:05:31ZSOPHIAXFRANKLIN12/01/1938UHC4325464•••-••-0109774-817-5753UNKNOWN2156 OCEAN AVETampafl33622GRP-6347MEDICARE-ADV-A
ENRENR-1383132026-08-21T01:23:50ZHudson, Marcus——1977-06-02UHC-54432-48•••-••-7226717-734-1686marcus.hudson91@proton.me4570 Oak StreetMinneapolismn55467-4509GRP-7587OPTIONS-PPO
ENRENR-1367872026-06-22T23:12:32ZCHARLES—LYNCH1942-12-21UHC-82241-22•••-••-65385698153582·charles.lynch@outlook.com9784 Park PlTEMPEAZ85202GRP-4246MEDICARE-ADV-B
ENRENR-1195942026-10-09T05:44:49ZSandraGSinh10/23/1975UNKNOWN•••-••-956816847308043sandra.singh@proton.me··1491 JEFFERSON AVEGilbertAZ85269GRP-4823OPTIONS-PPO
ENRENR-1053972026-02-15T03:44:15ZChristineOGarrett1981-04-04··UHC-81591-26•••-••-4770(575) 324-2411·christine.garrett68@outlook.com829 BASELINE ROADLas VegasNV89182GRP-1605medicare-adv-a
ENRENR-1382912026-06-06T18:34:37ZLisaH.Taylor1983-09-14UHC2068686•••-••-6237241-847-3837LISA.TAYLOR@GMAIL.COM1069 BASELINE ROADEden PrairieMN55389GRP-4158OPTIONS-PPO
ENRENR-1414382026-03-25T23:34:53ZWayne—Rios1985-10-01UHC-02895-59•••-••-21017018798wayne.rios@proton.me134 Valley View DriveOrlandoFL32802GRP-8816SELECT-EPO
ENRENR-1289642026-01-17T13:27:04ZMegan—·Park04-12-1948·UHC-97248-72•••-••-97335642837294megan.park29@icloud.com3187 Maple AvenueSeattleWashington98184GRP-2902MEDICARE-ADV-B··
43,101 rows, page 105 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:37.742Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty