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
CLMCLM-4056382026-07-20T07:30:09ZSnyder, Brandon—··1968-21-04UHC-55662-93-—brandon.snyder@aol.com8063 PINE DRNASHVILLE··TN37248··—-··
ENRENR-1255682026-09-28T11:48:44ZCHARLOTTE—WEBER1960-43-02UHC-81561-06•••-••-9360744.532.8343charlotte.weber67@gmail.com6065 SAGE COURTScottsdaleAZ85265GRP-6824NAVIGATE-HMO
CLMCLM-4058472026-01-11T17:13:01ZLori—Allen1972-01-06UHC-66446-36—16232845986NULL8219 Bayshore DriveDenverCO·80213GRP-2314NULL
CLMCLM-4041502026-04-14T01:16:59ZCrawford, Paul··—1973-04-11UHC-49265-38N/AN/A——null-·N/A—UNKNOWN
TPATPA-570622026-07-30T15:52:51ZCARL—SCHMIDT0905-91-63-NULL7774573348-1359 PINE DRIVEMesaArizona85254GRP-2498··
CLMCLM-4087002026-08-20T00:23:04ZJACQUELYNEN.··PIERCE1939-11-08UHC-89578-74NULLUNKNOWNjacqueline.pierce5@outlook.comN/A-···-——CORE-HMO
ENRENR-1089002026-01-10T05:06:20ZLarryS.Gibson28-12-1958UHC-74898-55•••-••-13899375549069··LARRY.GIBSON53@OUTLOOK.COM7539 Cedar LaneDallasTX··75298GRP-6391·NAVIGATE-HMO
CLMCLM-4152002026-09-16T02:36:57ZSantiago—Padilla11/04/82UHC-48047-31•••-••-57557254187784NULL6082 GRAND AVESAN DIEGO·CA—GRP-7280-
ENRENR-1061902026-10-18T23:52:50ZCharles—Chapman1947-07-13UHC-47214-68•••-••-18944886556297charles.chapman36@icloud.com884 CANYON ROADTempeAZ85266GRP-3815CORE-HMO··
CLMCLM-4071602026-05-05T14:04:00ZDYLAN—STEWART11/13/69UHC-17496-87•••-••-6937——1139 WILLOW CTMesaAZ85254·GRP-5312MEDICARE-ADV-B
TPATPA-525882026-03-26T06:37:04Zdylan—stone08/01/1980N/A—4733786248NULL9835 Jefferson AveTampaFL··33640-—
CLMCLM-4109262026-03-27T09:24:52ZRachel—WillisDec 3, 1975UHC-19492-19-N/AN/A12 Ocean AveCharlottenc28279-1286nullNAVIGATE-HMO
ENRENR-1378442026-04-18T03:52:12ZDaniel—Marshall1940-12-06UHC-91743-60•••-••-55968664121691···daniel.marshall@gmail.com6761 HILLCREST ROADNashville··Tennessee37286·GRP-3606CHOICE-PLUS-PPO
CLMCLM-4264842026-01-21T12:42:42ZJENNIFERZWILLIAMSON1977-00-12··UHC-04711-37•••-••-6995-JENNIFER.WILLIAMSON35@YAHOO.COM5587 Apache BlvdDenverCO80290GRP-0260CORE-HMO
ENRENR-1427852026-01-19T22:19:44ZBILLYZ.SIMS1985-06-01UHC-33994-41•••-••-102118147959905billy.sims@hotmail.com4686 Grand AvenueTAMPAFL33684GRP-2478OPTIONS-PPO
ENRENR-1239672026-01-06T04:11:18ZTerry·AMedina1966-02-08UHC-89474-97··•••-••-59855184330047TERRY.MEDINA99@OUTLOOK.COM9633 Sage CtEden PrairieMinnesota55316GRP-9759··MEDICARE-ADV-A
ENRENR-1227332026-06-21T05:47:55ZMARIAESALAZAR1949-00-81UHC-89268-42•••-••-1808+1 840 961 0770maria.salazar@aol.com74 Valley View DrJacksonvillefl32288GRP-1351CORE-HMO
CLMCLM-4127222026-06-09T01:37:15ZSTEVEN—SCHMIDT1986-09-25UHC-10816-62—UNKNOWNNULL5175 Market StLas VegasNV89123NULL—
ENRENR-1146152026-09-30T13:48:10ZSEANUFIELDS1971-03-17UHC-34368-01•••-••-7983(469) 415-6981sean.fields@gmail.com··8945 Baseline RdChandlerArizona85275GRP-7230CHOICE-PLUS-PPO
ENRENR-1178802026-09-21T10:34:07ZCAROLMGUTIERREZ2000-09-08UHC-45287-35•••-••-6527869.542.7797CAROL.GUTIERREZ97@AOL.COM5447 Church StreetPlanoTXN/AGRP-8694OPTIONS-PPO
PRVPRV-213592026-10-05T14:12:58ZJanet—Arnold1962-08-10—•••-••-5410+1 393 353 3885JANET.ARNOLD36@ICLOUD.COM2671 Palm DriveJacksonville··FL32296N/AN/A
CLMCLM-4300972026-06-13T11:46:00Zvalentina·Xwilliams·1982-09-21UHC-42568-28NULL9286512546—NULLN/A—NULLGRP-7325NAVIGATE-HMO
ENRENR-1171802026-07-22T02:58:37ZSophiaOBowman1968-08-22UHC-14385-23•••-••-43355154684263sophia.bowman@icloud.com4709 Highland AveDenver·CO80233GRP-9721MEDICARE-ADV-B
TPATPA-634482026-01-05T04:22:19ZRalph—Phillips1983-08-09—•••-••-188314636004576··6178 PARK PLACE Apt 29AustinTX78712GRP-6296—
PRVPRV-279392026-09-02T11:27:34ZBenjamin F····Jones2000-11-10null•••-••-5143417-628-5515UNKNOWN3840 Palm DrNASHVILLETN37240-5539-—
TPATPA-521472026-02-09T00:03:35ZJESSICA—·TORRES·07/02/1971UHC-04919-14-707.916.4172null·1126 Elm StreetATLANTAGA30368GRP-1970··CHOICE-PLUS-PPO
ENRENR-1210562026-08-31T14:30:25ZPATRICK····FISHER03-08-1985UHC-27825-83•••-••-4357(777) 329-5953-··7715 BASELINE RDMESAAZ85289··GRP-7287navigate-hmo
ENRENR-1181492026-04-06T01:48:54ZDianaVBowman1949-07-02UHC-94241-40•••-••-3091837-605-7654diana.bowman@yahoo.com3258 Forest AvenueTucsonaz85742GRP-9919MEDICARE-ADV-A
ENRENR-1097072026-05-06T17:41:58ZPadilla—Susan··1981-03-01UHC-73638-75•••-••-2986213.834.9397SUSAN.PADILLA46@GMAIL.COM2782 Central AvenueSeattleWA98182GRP-4147NAVIGATE-HMO
TPATPA-606762026-05-07T22:17:56ZSue—Vazquez2007-09-06UHC-84134-22UNKNOWN··+1 320 698 7761null·7588 APACHE BOULEVARDEden PrairieMN55378—UNKNOWN
ENRENR-1096882026-10-15T08:28:21ZWalsh, WillieI.—1992-07-21UHC-23657-23•••-••-5706(975) 270-5924—8861 RIDGE ROADEden PrairieMN55313GRP-6210MEDICARE-ADV-B
ENRENR-136632 2026-02-06T18:47:25ZNicholasMGarcia·11/11/1964UHC-63689-60•••-••-3877NULLnicholas.garcia@gmail.com··9584 Hillcrest RdEden Prairie··MN55370GRP-1861CHOICE-PLUS-PPO
PRVPRV-267492026-06-17T17:47:10ZBRUCE—WELLS1977-11-17NULLUNKNOWN··545-799-8325null7373 Pine DriveCharlotteNC··28233-3214—-
PRVPRV-201212026-06-13T13:42:55ZFatima—Kim1966-06-26UHC-47643-05null9889443477N/A8544 Camelback RdSacramentoCA95882··—
ENRENR-1312252026-03-08T07:51:43Z·Mariana—Peterson1998-12-07UHC-91604-29•••-••-7206770.636.2001mariana.peterson72@hotmail.com9813 Union StreetJacksonvilleFL··32205GRP-9145OPTIONS-PPO
ENRENR-1277102026-03-30T05:31:59ZRYAN—LI··10-09-1963UHC-59343-89•••-••-1924239.354.9599·ryan.li@icloud.com5648 Elm St··Fresno··CA93735GRP-6378CHOICE-PLUS-PPO
ENRENR-1057332026-03-26T05:39:53ZPAMELAJCONTRERAS··1991-04-02UHC-42414-79•••-••-7836(977) 716-6114pamela.contreras24@aol.com8748 ELM STLas VegasNV89196-0497GRP-4096CORE-HMO
ENRENR-1305382026-04-19T09:59:34ZJON—PETERSUN09/11/1958UHC-98787-15—13702107906·-8169 SUNSET BOULEVARDHoustonTexas77071-8490GRP-9677··SELECT-EPO
ENRENR-114797 2026-08-05T03:27:25ZCatherineQLe1988-06-17UHC-69971-20•••-••-45896457755746CATHERINE.LE67@GMAIL.COM8732 Hillcrest RoadGilbertAZ85205GRP-7944CORE-HMO
ENRENR-1397812026-07-19T08:53:18ZTerryCPayne04/07/2007UHC-95731-30··•••-••-8098730-329-4495terry.payne@gmail.com1535 Apache BoulevardAtlantaGA30323GRP-6109NAVIGATE-HMO
ENRENR-1370912026-04-18T15:12:12Z·PAMELAX·EDWARDS2002-04-27UHC5628229•••-••-6074nullNULL6075 Meadow LaneMesaAZ85215··GRP-0549MEDICARE-ADV-A
CLMCLM-4153922026-07-09T08:35:51ZMariana—Valdeez11/22/1982-—914-266-6728NULL1961 APACHE BLVDDallasTX75267-3106GRP-8742-
CLMCLM-4045062026-06-04T06:44:26ZNathanWClark1967-04-01UHC-59130-67—15022298147UNKNOWN9074 Hillcrest RoadDenverColorado80202——
CLMCLM-4069722026-02-24T17:37:12ZMargaret··—Anderson1995-02-21UHC-40281-84—731-226-4054—4717 Jefferson Avenue #351MiamiFL·33143N/AMEDICARE-ADV-B
ENRENR-1165512026-08-18T07:59:45ZNatalieC.Nelson1944-03-01UHC-35218-06•••-••-7367(800) 939-7909natalie.nelson@yahoo.com402 RIDGE RDPlanoTX75056GRP-2602MEDICARE-ADV-B··
CLMCLM-4290982026-04-02T10:50:09ZEmily—Ramirez12/05/59nullN/A····—2364 BROADWAYTempeArizona85294—CORE-HMO
PRVPRV-221402026-02-23T18:34:16ZLauren—Howard10/01/02UHC-36100-80-918-679-6560NULL5084 RIVER RDGilbertAZ85251N/A-
ENRENR-1022062026-03-09T14:24:06Z arthurN.mason1975-07-11UHC9578974•••-••-9442(337) 397-4367arthur.mason65@gmail.com5652 JEFFERSON AVENUE #776SAN ANTONIOtx78266·GRP-4362CHOICE-PLUS-PPO
PRVPRV-292472026-09-20T05:24:22ZTerry—Hansen1994-10-11NULL-+1 869 677 1414TERRY.HANSEN59@YAHOO.COM213 PINE DRColumbusOH··43272——
TPATPA-517292026-08-08T14:25:37ZArjun—Ray19630312N/AUNKNOWNUNKNOWN—5602 CAMELBACK ROAD··AtlantaGA30305null—
100,000 rows, page 100 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.806Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty