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
CLM CLM-4114292026-03-12T20:11:20Zjeremy—holmesNov 21, 1969-•••-••-8040null—818 Central AvenueSAN DIEGOCA92195nullCORE-HMO
CLMCLM-4265992026-04-29T04:23:23ZDylan—Padilla1974-09-27UHC6499166·N/A+1 605 930 7896null8669 Meadow LnPlanoTX75018NULLMEDICARE-ADV-A
ENRENR-1151182026-01-20T09:19:12ZEdward—·Ward08/01/1939UHC-15071-61•••-••-2021(440) 360-0369edward.ward22@gmail.com4128 Washington StreetAtlantaGeorgia30301GRP-0328MEDICARE-ADV-A
TPATPA-551082026-06-11T06:17:12ZGabirel—Hunter19600228——6873444—7884 PINE DRIVESan DiegoCA92168N/ACORE-HMO
ENRENR-1067602026-07-21T23:32:51ZCarlosIRichardson1953-10-16UHC-10198-33•••-••-1773(532) 540-5981UNKNOWN7392 HIGHLAND AVELas Vegasnv89121GRP-8345MEDICARE-ADV-A
ENRENR-1314262026-04-21T09:14:57ZjordanQlaura1961-07-06UHC-59863-10•••-••-261819824877437NULL7326 ELM STREETPhoenixAZ85020GRP-7322NAVIGATE-HMO
ENR ENR-1393952026-06-20T20:29:53Z·GARYO··HARRIS—UHC-62653-03•••-••-0712(356) 579-1319—1821 Park PlGILBERTAZ85295GRP-7844MEDICARE-ADV-A
ENRENR-1220872026-07-01T04:58:38ZKevinAMarshall4/5/1962UHC-42645-56•••-••-432518177369229KEVIN.MARSHALL@HOTMAIL.COM6674 SAGE COURTTAMPA·FL33694GRP-8519navigate-hmo
ENRENR-1144022026-06-07T09:52:11ZWright, Gerald——·1998-09-24UHC-16903-15•••-••-4959-—223 Church StreetMiamiFL33114·GRP-9975NAVIGATE-HMO
CLMCLM-4171042026-09-14T17:03:15ZWest—Jacqueline11/06/01···UHC-85592-57··null—6379 Cedar LaneOrlandoFL32838·GRP-1436UNKNOWN
ENR ENR-1105132026-02-03T19:30:26ZHayes, JoshuaR—1956-04-13UHC-85275-22•••-••-48705918584128joshua.hayes2@icloud.com3463 MOUNTAIN VIEW DRSan DiegoCalifornia92149GRP-1321OPTIONS-PPO··
ENRENR-1060802026-02-26T09:45:47Z·Karen M.—Campbell1967-07-12UHC-50459-14•••-••-2417370.447.3086·karen.campbell49@outlook.com3013 Market StreetSan Antonio·tx78271GRP-3254NAVIGATE-HMO
ENRENR-1384672026-08-16T22:10:08ZBETTY—WRIGHT1996-05-07UHC-97501-96•••-••-92086076640120·-6345 Desert Sky Blvd #933Miamifl33102GRP-6455MEDICARE-ADV-B
ENRENR-1160042026-07-27T23:45:42ZRonaldFLopez12/10/1972UHC-48458-09•••-••-31549682469915ronald.lopez49@gmail.com168 CAMELBACK RD··San DiegoCA92132GRP-8088MEDICARE-ADV-A
CLMCLM-4280002026-09-09T16:59:57ZGilbert, DanielE—1938-08-24—•••-••-0983(265) 844-1156null·9403 Market StreetTampafl33624——
ENRENR-1125082026-02-13T18:59:13Z OMAR··WCARTER2002-04-05UHC-20223-76•••-••-5844—omar.carter@hotmail.com1110 BASELINE ROADHoustonTX··77090GRP-2290CHOICE-PLUS-PPO
ENRENR-1371362026-05-10T06:04:26ZHowell····Carlos1948-08-05UHC-56086-65•••-••-2299—null4636 Broadway·ORLANDOFL32873GRP-8900OPTIONS-PPO
CLMCLM-4077182026-06-02T23:34:54ZNatalie—Wallace19400815-nullUNKNOWNNULL406 Church StreetSacramentoCA95856nullSELECT-EPO
ENRENR-131247 2026-06-12T15:24:03ZKEVIN··—·HILL1944-10-03UHC-48379-37•••-••-26442326827516kevin.hill@yahoo.com1012 Bayshore DriveLas VegasNV89125GRP-3770MEDICARE-ADV-A
ENRENR-1116092026-07-27T14:06:14ZNANCY—SIMPSON1956-04-01UHC-55422-71•••-••-3431205-958-5506nancy.simpson@proton.me··5617 JEFFERSON AVENUESACRAMENTO·CA95828GRP-8771CHOICE-PLUS-PPO
ENRENR-1098822026-06-30T15:29:47ZVirginia—Yang8/28/1988UHC-41415-62•••-••-3537685-603-9563virginia.yang53@proton.me200 JEFFERSON AVEMesaAZ85287GRP-7669·MEDICARE-ADV-A
CLMCLM-4034472026-02-22T18:08:51ZMateo—Johnson·09/05/1986UHC-24566-34null9848169043null—UNKNOWN·N/AUNKNOWNGRP-5824NULL
CLMCLM-4271742026-05-29T01:55:48ZJeffrey—Lawrence1977-08-09UHC-33727-01•••-••-2734802.712.7733jeffrey.lawrence@outlook.com2828 Highland AveDallasTX75212——
TPATPA-602322026-03-17T23:18:11Z·Michelle—Mendez12/20/1967nullNULL··—N/A1553 HILLCREST RDSacramentoCA95820GRP-8762NULL
ENRENR-1088952026-02-19T08:13:58ZAmaanda—Evans2000-03-03UHC-14543-34··•••-••-0761—amanda.evans@yahoo.com3904 Ocean Avenue Apt 28San DiegoCA92154GRP-8578CHOICE-PLUS-PPO
ENRENR-1229352026-07-18T22:29:10ZDonna—Alvarez1998-03-26UHC-21436-41•••-••-77913057785217··donna.alvarez8@hotmail.com8538 Mountain View DriveFresnoCA93727GRP-2130OPTIONS-PPO
ENRENR-123558 2026-07-16T20:08:54Z·Fisher, Amanad——1970-08-21UHC-11517-28•••-••-4419(253) 444-3613—5090 Willow Court #652PhoenixAZ85007GRP-9920navigate-hmo
CLMCLM-4319062026-02-24T12:56:53Zmelissa—hudson2007-09-06UHC-49229-90····N/Anull1746 Grand AveGILBERTArizona85210··GRP-7518NAVIGATE-HMO
TPATPA-568502026-05-27T09:42:22ZBradley··X.Vazquez·1989-07-07NULLUNKNOWNnullbradley.vazquez@proton.me1527 Cedar Ln Apt 37PlanoTexas75044—····
TPATPA-522052026-01-17T00:18:28ZGABRIEL—SANDOVAL·1948-01-09UNKNOWNUNKNOWN697-693-4152—464 SUNSET BOULEVARD #832PlanoTX75063—null
CLMCLM-4266302026-03-20T08:57:12ZBARBARAICOOPER1993-09-17N/A·NULL4927428526N/A——-—null··—
CLMCLM-4266882026-05-28T22:32:19ZFRANCES—ROSS1987-12-11UHC-49985-38UNKNOWNnull—nullNULL—UNKNOWNN/AMEDICARE-ADV-A
CLMCLM-4179982026-07-22T10:11:31ZJOAN—JACKOSN2000-02-17UHC-61315-20null—-null········GRP-8570—
TPATPA-595472026-06-12T14:04:27ZMASON··—MURRAY1956-08-08———mason.murray@aol.com4142 Meadow LnTucsonAZ85783··—NULL
CLMCLM-4222732026-04-11T18:58:33ZJAMES—HANSONNov 23, 1984UHC-90765-54•••-••-26916222528462james.hanson@outlook.com6778 OCEAN AVEMiamiFL33117NULL··
ENRENR-1367562026-09-05T11:05:48ZSimmons, BenQ—1971-06-14UHC-86087-23UNKNOWN+1 665 369 1551BENJAMIN.SIMMONS38@PROTON.ME8450 CAMELBACK RDGilbertAZ··85224··GRP-5586MEDICARE-ADV-A
ENRENR-1373732026-03-11T04:44:29ZTYLERY.PETERS2001-11-01UHC-32643-22•••-••-6245NULLnull··1544 Market Street Apt 35FRESNOCalifornia··93738GRP-7412MEDICARE-ADV-B
TPATPA-522072026-06-13T08:48:15ZMartin, Anna——19660502UHC-56138-06•••-••-6430nullanna.martin40@proton.me766 PARK PLACECHANDLERAZ85261GRP-5745CHOICE-PLUS-PPO
ENRENR-1358452026-07-29T01:37:19ZWILLIE—GRANT22-07-2006UHC-22936-33•••-••-35645948590091UNKNOWN5784 BAYSHORE DRDallasTX75242GRP-2998CORE-HMO
PRVPRV-256562026-05-13T17:38:56ZRussell—Parker1970-08-10UHC-91285-73NULL(602) 727-6902····3317 Oak Street··LAS VEGAS··NV89180-NULL
CLMCLM-4234442026-01-06T16:36:13ZLarryNSalazar1/11/1959UHC-88293-04NULL617-397-5906NULL3354 Park PlGilbertArizona85257N/A····
ENRENR-1170062026-01-06T03:10:18ZpamelaHcollins1942-09-03UHC-20336-22N/A(341) 642-2463pamela.collins@yahoo.com··1992 Meadow LaneMESAAZ85242GRP-0445OPTIONS-PPO
CLMCLM-4133932026-06-28T14:24:53Zalexis··—rodriguez1984-05-12UHC-34207-12—16487817696—N/AN/AUNKNOWNN/AGRP-8397UNKNOWN
PRVPRV-281072026-07-23T07:32:10Z·Alexis—Bennett06/04/68UHC-65598-14•••-••-6548967-433-3853N/A8577 BroadwaySacramentoCA95882—OPTIONS-PPO
CLMCLM-4220302026-05-31T15:30:17ZJulie····Flores2005-12-02UHC-88438-07UNKNOWN7857529815N/A··354 Lake View Road·OrlandoFL32818UNKNOWNN/A
TPATPA-559422026-06-08T18:32:49ZWilliam—FowlerAug 11, 1940null•••-••-7045null····9182 Bayshore DriveSan DiegoCA··92186GRP-7211·UNKNOWN
TPATPA-592792026-01-11T03:11:56ZCAROL—LI·7/11/1982NULL—+1 211 693 3662UNKNOWN8392 Elm StreetJacksonvilleFL32262N/ACHOICE-PLUS-PPO
CLMCLM-409646 2026-01-29T20:17:52ZAISHA—SEPHENS17-04-1996·nullN/A-··—8800 Grand AvenueDallasTX75255null-
PRVPRV-277722026-07-26T12:16:42ZRaymondD··West1959-12-27——null-451 Union StColumbusOH43207N/A—
CLMCLM-4298922026-09-11T13:25:44ZLogan—·Payne1986-04-08UHC-81447-44N/AN/Anull279 Apache BoulevardOrlandoFL32830··N/A
100,000 rows, page 130 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:36.690Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty