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
TPATPA-578642026-06-27T18:14:09ZAMY—FERGUSON1944-01-22··—12068895002-NULL——UNKNOWNnull-··
ENRENR-1371232026-01-16T03:32:15ZAlbert—Hawkins2000-08-08UHC-89653-70•••-••-4581(684) 397-5202N/A6537 MESA DRIVEDallasTX75254GRP-1286MEDICARE-ADV-A
PRVPRV-203782026-05-13T10:31:21ZDonald—·Brown2007-05-16—-500-960-2474·-N/A··N/ANULLnullSELECT-EPO
ENRENR-1294782026-06-03T09:47:26ZRACHLE—GARZA1978-11-27UHC9707757•••-••-51485313933194rachel.garza13@hotmail.com3933 SUNSET BOULEVARDMinneapolis··MNUNKNOWNGRP-6101MEDICARE-ADV-A
CLMCLM-4284672026-03-28T14:50:42ZDanielle—Hayes1960-03-09N/ANULL··—null4866 HILLCREST RDGlendaleAZ85327——
CLMCLM-4238502026-10-03T02:17:11ZOmar—Nunez19821016UHC-16297-37•••-••-0342N/AUNKNOWN518 Baseline Rd #798MESAAZ85227GRP-5397OPTIONS-PPO
PRVPRV-205972026-08-23T15:03:46ZBryan—Davis1959-09-09NULLUNKNOWN278-799-2735-2320 UNION STREET·MiamiFL33104nullMEDICARE-ADV-B
ENRENR-1353182026-01-22T23:10:52ZElijah—Campbell1959-10-22UHC-67267-58•••-••-4721340.967.8447··elijah.campbell90@gmail.com6580 Central Ave #332SacramentoCalifornia95886GRP-5192CORE-HMO
TPATPA-537932026-05-11T06:23:12ZAmanda····Colle1965-07-03N/A—N/AUNKNOWN4164 BroadwaySacramentoCA95819GRP-2892MEDICARE-ADV-B
ENRENR-1219762026-04-14T07:19:08ZKathrynI.Henderson19531128UHC-09847-52•••-••-7734312-484-6062—4192 Market StLas Vegas·Nevada89134GRP-6665OPTIONS-PPO
TPATPA-552512026-07-10T04:06:43Z·Kenneth—Kim12-06-1977NULL—·nullNULL—····-—UNKNOWN-
TPATPA-541632026-03-21T08:28:45Zjessica—bennett1991-05-02—•••-••-2361NULLJESSICA.BENNETT@AOL.COM5439 CAMELBACK RDDenverColorado80206UNKNOWN-
CLMCLM-4048932026-02-20T06:25:20ZWei—Harrison··1954-03-02UHC-67650-36—450-968-9142UNKNOWN—-N/AnullNULL·N/A
CLMCLM-4292202026-08-15T19:40:47ZAisha—Larson1949-09-22··UNKNOWN•••-••-8638-aisha.larson@gmail.com3250 BroadwayEden PrairieMNN/AGRP-1530—
CLMCLM-4057972026-05-06T23:41:18ZJORDAN—DUNCAN1993-06-11UHC-11088-69NULL(786) 319-0096—4713 Indian School RoadHoustonTX77066GRP-9330NULL
ENRENR-1234292026-06-18T21:02:07Zralph—gibson1987-03-21UHC-51268-55-—null2194 Baseline RdMiamiFL33143GRP-6802MEDICARE-ADV-B
TPATPA-629142026-03-20T05:39:58Zmarcus—turner·1939-12-12··NULL—··8916 PALM DRIVE·San AntonioTX78257GRP-0980OPTIONS-PPO
ENRENR-1314442026-05-20T10:40:37ZNICCOLEY·MASON·10/14/1947UHC-61409-91•••-••-4940(257) 916-8716nicole.mason57@yahoo.com182 JEFFERSON AVEChandlerAZ85237GRP-8002SELECT-EPO
ENRENR-1327672026-02-27T09:56:06ZMARIA—TAYLOR1987-06-06UHC-04823-97•••-••-7832929-282-6749MARIA.TAYLOR85@ICLOUD.COM2393 Valley View Drive···FresnoCA93732GRP-6292SELECT-EPO
CLMCLM-4310232026-02-19T20:40:50ZAaron—Freeman1944-07-07·NULL—null-6995 Oak St Apt 8MesaAZ85216—NAVIGATE-HMO
ENRENR-1414162026-06-01T03:46:02ZMARY·MFREEMAN1989-10-16UHC-37577-98•••-••-2076+1 880 500 1708mary.freeman72@yahoo.com2156 Highland AvenueSACRAMENTOca95892GRP-2282MEDICARE-ADV-A
ENRENR-1046162026-04-14T03:08:28ZDorothy L.—Holmes2006-10-05UHC-62284-90•••-••-5072741.937.7608dorothy.holmes@aol.com6486 Palm DriveJacksonvillefl··32266GRP-4850CORE-HMO
ENRENR-1419752026-10-05T14:04:13ZRUSSELL—SCOTT2006-07-06UHC6206874•••-••-3008582-215-7597—nullnull-—·GRP-9322MEDICARE-ADV-A
CLM CLM-4323842026-07-19T21:45:07ZGaryFSantos03/08/1957UHC-60618-10—2328547760N/A947 Grand AvenueMiamiFL33168GRP-1203NAVIGATE-HMO
PRVPRV-215782026-05-07T10:04:06ZBRYAN—STEVENS1/4/1944—•••-••-18212625639406bryan.stevens@hotmail.com—-·UNKNOWNNULL—OPTIONS-PPO
CLMCLM-4011552026-06-28T20:23:34ZJackie··Weber01/06/1980··UHC-14018-87•••-••-8998(300) 537-0105NULL·2662 CAMELBACK ROADMesaAZ85260GRP-2001NAVIGATE-HMO
ENRENR-1324372026-07-04T11:53:17ZALANVDEAN1956-02-21UHC-46690-93UNKNOWN942-768-4964alan.dean17@gmail.com·8424 Central AvenueChandlerAZ85266GRP-0876CHOICE-PLUS-PPO
ENRENR-1032082026-03-02T10:55:22ZBrandonN.··Jenkins19940801UHC-34796-81··•••-••-76316559348279brandon.jenkins@yahoo.com1660 PALM DRSCOTTSDALEArizona85209·GRP-8564OPTIONS-PPO
TPATPA-626652026-03-12T09:07:22ZMargaret—Bradey1966-09-13-NULL——2445 Spring StreetGlendaleAZ85314GRP-0483··NULL
CLMCLM-4312532026-02-05T17:11:20ZHill, KimberlyO—1945-12-18nullNULL770.748.2301—6792 OCEAN AVENUEMesaAZ85234GRP-6582—
ENRENR-1061382026-07-06T13:37:28ZSandra··—Lwis1994-04-02UHC-69787-06•••-••-2438(956) 532-9294UNKNOWN2873 Maple Avenue Apt 22JACKSONVILLE·FLNULLGRP-3276CORE-HMO
PRVPRV-212492026-08-08T22:00:45ZJEFFREY—LARSON·09/24/1955UHC-00373-95N/A289-551-4159UNKNOWN5242 Jefferson AvenueScottsdaleAZ85236null·NULL
ENRENR-1104832026-07-31T13:45:15ZBowmanB.Carol1957-09-26UHC-30482-16•••-••-3112309-739-3297CAROL.BOWMAN84@YAHOO.COM1679 BAYSHORE DRLas VegasNV89196GRP-6357MEDICARE-ADV-A
ENRENR-1025562026-05-23T00:44:43ZStephanieW.·Berry19450506UHC-73453-17•••-••-5967606.440.4132—7425 MAIN STREETTucsonAZ85748-8739GRP-9065CHOICE-PLUS-PPO
CLMCLM-4276362026-02-25T09:12:32ZSTEVEN—COLE3/7/1970UHC-33866-79•••-••-0993N/A·NULL8077 Willow CtTempeAZ··85258GRP-6033SELECT-EPO
CLMCLM-4314592026-08-17T22:43:43ZShirley—Jenkins1973-05-17UHC-29779-72—(909) 592-1322N/A7004 Washington St··NashvilleTN37207—CHOICE-PLUS-PPO
CLMCLM-4127972026-01-29T06:00:34ZAMANDA—AGUILAR14-07-1999UHC-57660-55——null·4164 BroadwayTampaFL—-null
ENRENR-1064712026-06-24T13:09:18ZNANCYEKENNEDY22-04-1980UHC-57453-80UNKNOWN··NULL—6832 Park PlacePhoenix··AZ85089GRP-0684CHOICE-PLUS-PPO
TPATPA-544712026-07-14T02:30:22ZDanielle—Bell1959-12-08N/A—UNKNOWNnull7586 Spring StreetOrlandoFL32807-8800GRP-2091—
TPATPA-535172026-03-08T18:20:22Z·Charles—Burton1975-07-25N/A•••-••-2710nullcharles.burton12@aol.com—-—·-GRP-2740MEDICARE-ADV-A
ENRENR-1171002026-08-28T09:36:13ZBRITTANY—LUCAS2000-03-27··UHC-42291-53•••-••-4458·540-848-3129—1258 Park PlPlanoTX75017GRP-2696CORE-HMO··
TPATPA-535452026-09-19T03:05:27ZMegan····Henry1944-01-14UNKNOWN—NULL—4325 Hillcrest RdLas VegasNevada··89153-2084null—
TPATPA-559562026-06-02T11:45:29ZJesse—Pierce1947-07-27-··•••-••-86059144228848—4125 CANYON ROADTucsonAZ85703—-
ENRENR-1052002026-04-25T19:17:33ZCynthia····Burton19600726UHC-26454-12•••-••-0797511-600-6211CYNTHIA.BURTON13@PROTON.ME7275 APACHE BOULEVARD··CharlotteNorth Carolina28216GRP-9390CORE-HMO
CLMCLM-4115262026-01-02T03:25:12ZJOSE—BARNES07/16/1979UHC-53140-13•••-••-4836235.460.6618NULL7290 CEDAR LNAustinTX·78722—MEDICARE-ADV-B
ENRENR-1405342026-10-05T13:37:22ZBENJAMINK.VASQUEZ··2006-04-10·UHC-82637-55·N/A3042095884benjamin.vasquez80@proton.me5631 Mountain View DrOrlandoFL32879··GRP-8235options-ppo
ENRENR-1074812026-08-11T11:48:26ZHiroshi—Woods03-09-1942UHC-03483-36•••-••-47949445652071hiroshi.woods@aol.com··5837 CANYON RDMESAAZ85256GRP-0499NAVIGATE-HMO
ENRENR-1139672026-05-30T12:59:22ZHiroshi—Lynch1965-10-25UHC-75411-44•••-••-1402NULLhiroshi.lynch@aol.com581 Cedar Lane·TAMPAFL33626··GRP-4345OPTIONS-PPO
ENRENR-1372992026-03-19T23:37:04ZFernandez, RogerR—1950-07-03UHC-87047-92—8934818059roger.fernandez3@gmail.com3486 BroadwayDALLASTX75214GRP-9451MEDICARE-ADV-A
TPATPA-532022026-06-28T01:20:57Z PAUL—FOSTER1983-02-05-•••-••-7058+1 816 310 3032—4047 Washington St··SAN ANTONIOTX78240GRP-9067MEDICARE-ADV-B
100,000 rows, page 30 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:34.767Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty