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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1036782026-06-30T13:19:49Zrobert—·contrerasApr 8, 2000UHC-89869-73•••-••-1306(407) 833-7462robert.contreras15@gmail.com4976 Harbor BlvdLas VegasNV89119GRP-4461OPTIONS-PPO
CLMCLM-4270622026-04-30T11:44:35ZANGELA—ELLIS19990303UHC-22805-77—4063992692-9680 Hillcrest RdPhoenixAZ85054GRP-1039CHOICE-PLUS-PPO
ENRENR-1054672026-02-26T05:01:57ZSharonBSantos1990-01-28UHC-46936-59•••-••-406219059848621sharon.santos9@aol.com6404 BAYSHORE DRIVEDenverCO80272GRP-7557CHOICE-PLUS-PPO
TPATPA-612742026-09-23T08:20:50ZPerez, Cheryl····—03-04-1990UNKNOWN•••-••-6916NULLCHERYL.PEREZ@OUTLOOK.COM260 Lake View RoadSAN DIEGOCA·92101——
TPATPA-591982026-05-18T11:49:34ZDENISE—LUCAS06/10/97—NULLN/A—1042 Sunset BoulevardTampaFL33607—MEDICARE-ADV-A
ENRENR-1204672026-02-01T21:57:54ZKim, Wei——1968-03-07UHC-37453-94•••-••-457617787425992NULL7066 Hillcrest RoadHoustonTexas77052GRP-2960SELECT-EPO
TPATPA-549342026-01-12T08:29:59ZBetty—Wood04/12/1950—UNKNOWN(558) 980-6735N/A7551 LINCOLN WAYSeattle·WA98176null·CORE-HMO
CLMCLM-4317042026-09-24T01:59:17ZCHRIS—WALLACEAug 25, 1962UHC5687541N/A-··UNKNOWN8665 Camelback RdEDEN PRAIRIEMN55309GRP-1855OPTIONS-PPO
PRVPRV-205152026-05-22T21:03:49Z·DOROTHY··JACOBS02/04/1942——(432) 201-1656UNKNOWN2626 River RoadFRESNOCA93771N/A—
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
CLMCLM-4214612026-09-01T07:42:14ZKelly, Juan··——1945-10-24—•••-••-2604896-376-2803NULL2386 Central Avenue Apt 30PhoenixAZ85057-MEDICARE-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
PRVPRV-204642026-01-30T12:09:15Z·MARY—MURRAY1980-11-05··NULL—211-679-3407mary.murray@aol.com1000 SPRING STREETMiamifl33103··—-
CLMCLM-4218892026-09-04T22:13:52ZSara—Kelley·2008-09-20UHC-40791-63—-—1277 Willow CourtTucsonAZ85786—MEDICARE-ADV-A
TPATPA-618512026-01-26T09:29:06ZCarolyn—Jimenez1945-05-14UHC-56314-20•••-••-5235nullN/Anull-·NULL-—UNKNOWN
CLMCLM-4211472026-08-07T00:40:43ZMariaIHoffman2000-05-27··UHC-58570-09N/A-NULL6203 INDIAN SCHOOL RDTampaFL33658UNKNOWNOPTIONS-PPO
CLMCLM-4196342026-01-25T16:43:49ZNicoleD··Carlson··1941-10-20UHC-64211-07•••-••-3917—N/A8802 Pine DriveTAMPA··FL33663—NULL
CLMCLM-4188242026-04-20T10:41:35ZCarlos—Young1958-03-14UHC-22068-37UNKNOWN(756) 471-0943—·-—UNKNOWN—GRP-9402NULL
TPATPA-631432026-01-19T10:05:34ZAHMEDW.CAMPBELL1939-09-19—null····-—NULL·UNKNOWNnull··UNKNOWN—
PRVPRV-240642026-03-14T06:36:46ZMARIANA··—SANTIAGO2007-11-22UHC-36282-56•••-••-88035317807023UNKNOWN4386 Jefferson Avenue··TucsonAZ85737-—
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
CLMCLM-4282632026-05-21T06:24:02Zjason—morgan2006-04-10UHC3145791N/A·504-271-8566—2752 Hillcrest RdTampaFL··GRP-2075OPTIONS-PPO
ENRENR-1171262026-04-14T21:41:20Z·DEBORAHO··GORDON1941-05-26UHC2506901•••-••-268213398306272··deborah.gordon91@proton.me6829 Ridge RdHoustonTX77007GRP-0932CORE-HMO
TPATPA-585152026-05-12T05:36:20ZGABRIEL—DIXON2007-08-13—null575-221-3244null····NULL——NULL—
CLMCLM-4089572026-03-30T18:42:22Z—··—02-07-1988—NULL—andrea.carroll35@proton.me6828 OAK STREETSacramentoca95878··GRP-8898NULL
CLMCLM-4121902026-05-12T05:39:54ZArjun—Wong1993-08-22UHC-77127-41•••-••-5604——null—N/ANULLGRP-9980—
ENRENR-1411192026-02-23T04:03:46ZBradleyLSilva2006-03-08UHC-52424-70•••-••-47138055883195UNKNOWN7257 Broadway·MESAArizona85235GRP-4204OPTIONS-PPO
CLMCLM-4253162026-04-30T22:31:48ZJulia—RyanApr 8, 1988UHC-57990-23·UNKNOWN712-387-4597NULL2161 Hillcrest RdSacramentoCA95881··--
CLMCLM-4324202026-03-09T11:31:14ZBarbara—Nichols05-03-1953UHC-25443-03•••-••-0446907-730-0078null8658 Mountain View Drive··MiamiFL33174GRP-0914NULL
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
CLMCLM-4082272026-01-03T18:13:10ZJULIA—CARROLL07/10/1972NULLUNKNOWN8312837561null——UNKNOWNN/A··UNKNOWN
TPATPA-501482026-09-30T17:18:02ZAISHA—HENRY2005-07-22UHC5604479•••-••-4194246.961.5696··—2707 Market St··San AntonioTX78268——
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··
CLMCLM-4125732026-02-05T07:18:12ZDOUGLAS··NUNEZ1959-01-02UHC-04096-41··NULL8067198149null4598 SPRING STREETDALLASTX75262GRP-3068NULL
ENRENR-1379212026-07-03T14:58:27ZSEAN—MILLERSep 4, 1994UHC-14551-01•••-••-2824541.807.4470sean.miller42@outlook.com1209 APACHE BOULEVARDAtlantaGA·30318GRP-1706NAVIGATE-HMO
CLMCLM-4301992026-05-31T19:39:26ZPhilip—Olson2007-09-07null•••-••-28258858086728-4297 Indian School RoadNashvilleTN37257GRP-7255SELECT-EPO
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
CLMCLM-4169262026-03-03T11:46:30ZDORIS—RICHARDS1980-11-26UHC-30582-10•••-••-9110NULLUNKNOWN9764 Cedar LaneHoustonTX77004NULL·NAVIGATE-HMO
CLMCLM-4115102026-07-11T17:38:48ZLinda—Smith09/17/89UHC6819920•••-••-6889NULLnull—N/A—-GRP-6601-
TPATPA-564872026-05-19T18:32:38ZSantos, Keith——12/12/1994····null(923) 656-5752—153 RIDGE ROADChandlerArizonaNULL—UNKNOWN
PRVPRV-251042026-01-10T04:06:09ZJordanD.Vasquez1992-08-12null•••-••-2816942.499.7975jordan.vasquez@aol.comNULLNULL—null·-UNKNOWN
TPATPA-580722026-02-27T08:30:29ZLane, Lawrence——2006-08-09—-9502398303lawrence.lane@icloud.com2237 CAMELBACK RD··Los AngelesCA90083null—
ENRENR-1044482026-03-24T10:40:28ZCarr, Bruce——19960221UHC-44424-97•••-••-35476935033122—null··—--GRP-2228OPTIONS-PPO
TPATPA-527992026-02-09T09:44:38ZMegan—Santiago··1948-05-15UHC-27734-09•••-••-968918463227078null4521 Ridge RdGLENDALEAZ85384GRP-7968CHOICE-PLUS-PPO··
100,000 rows, page 241 of 2,000PreviousNext

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