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-545332026-02-02T03:41:40ZMatthew—Hunt1964-09-03-NULL·+1 548 511 3418matthew.hunt11@hotmail.com·7991 Sunset BoulevardSCOTTSDALEAZ85263GRP-5793medicare-adv-b
ENRENR-1107252026-05-05T19:35:28ZElizabeth··—Edwards2004-12-03UHC-73277-83•••-••-26136913411644elizabeth.edwards52@outlook.com2881 Bayshore Dr·PhoenixAZ85007GRP-2758select-epo
ENRENR-1334542026-06-29T03:31:23ZPeterUCunningham··04/19/49··UHC-72694-61•••-••-6332nullpeter.cunningham@gmail.com331 Church Street·NashvilleTN37293GRP-5915··CHOICE-PLUS-PPO
CLMCLM-4296812026-08-02T04:12:29ZCheryl—Howell1987-07-07—null9025578865··null—nullNULLUNKNOWNGRP-2402NULL
CLMCLM-4202432026-07-23T23:53:15ZEMMA—PENA·12/15/2007uhc-89588-48•••-••-22942135477737··—1716 Sunset BlvdAustinTX·78701nullCORE-HMO
CLMCLM-4128842026-07-08T11:47:01ZcynthiaValvarez1976-06-12····N/ANULLUNKNOWN··5389 Palm Dr··ColumbusOH43224GRP-3342··CORE-HMO
CLMCLM-4236342026-10-09T01:04:39ZFranklin, CarolM—·1938-04-22UHC-98866-30N/AN/A—8103 UNION STTempeaz85292-NAVIGATE-HMO
ENRENR-1341412026-09-17T04:36:24Zhannah····vega1981-07-15UHC-67004-11•••-••-8109·2776576095·hannah.vega@hotmail.com3709 SAGE COURTPLANOTX75062GRP-4496OPTIONS-PPO
TPATPA-565942026-02-06T22:36:42ZHernandez, George—··1955-03-23—····nullnull6868 Ridge RoadMesaAZ85297-4036GRP-6677—
CLM CLM-4320402026-10-05T04:20:01ZBrittany—Shaw·1961-00-84UHC4313016•••-••-0615507-617-0562N/A6327 RIDGE RDDenver·Colorado80299GRP-7431MEDICARE-ADV-B
CLM CLM-4020362026-08-25T02:44:46ZChavze, Thomas——21-01-1958UHC-08205-93-N/ANULL6626 Market StMiamiFL33199GRP-3762UNKNOWN
ENRENR-1050982026-06-19T09:38:08ZDonnaPGriffin10/13/1944··UHC-70525-73•••-••-02154248572041··DONNA.GRIFFIN71@HOTMAIL.COM9479 PINE DRIVECHANDLERAZ85257GRP-4582SELECT-EPO
ENRENR-1251302026-02-19T16:47:22ZSam—Johnstton··1951-06-13UHC-73743-62•••-••-7637936-422-9242null3367 DESERT SKY BLVD··SeattleWashington98113GRP-3473SELECT-EPO
CLMCLM-4110582026-05-31T10:01:04ZDORISE.YANG1968-12-03UHC0936979UNKNOWN2282448221—3736 Pine DrPHOENIXAZ85014GRP-0195MEDICARE-ADV-A
ENRENR-1118882026-08-05T11:04:15ZBrittanyZWheeler··9/5/1971UHC-55556-45•••-••-6414961-704-3830—1233 Forest AvenueMiamiFlorida33162GRP-7140SELECT-EPO
TPA TPA-519632026-07-20T23:57:04Z Charles—Jones06/21/1950UNKNOWN•••-••-5183—-1193 Ocean AveMesaAZ85209NULLMEDICARE-ADV-B
ENRENR-1328362026-07-06T16:14:31ZGeraldRWatson1599-09-14UHC-18562-31•••-••-8048(367) 531-4555NULL9473 Palm DriveChandlerAZ85276GRP-8564NAVIGATE-HMO
ENRENR-1060432026-02-26T19:30:19ZValentinaK.Roberts26-06-2004UHC-42409-18•••-••-4158910.439.5806-8848 BASELINE RD Apt 20CharlotteNC28222GRP-2669··MEDICARE-ADV-B
ENRENR-1402402026-08-22T03:33:42Z·SHARON—DAVIS·1996-09-05uhc-22421-51•••-••-9602(367) 570-3349sharon.davis17@outlook.com8337 CANYON RDPlano·TX75066GRP-5391MEDICARE-ADV-A
CLMCLM-4296262026-08-26T11:05:00ZARTHUR—DEAN2/4/1960UHC-82188-54NULL—UNKNOWN····-nullUNKNOWNN/AUNKNOWN
ENRENR-1072032026-04-18T20:15:43ZemilyR·lopez19431214UHC-00216-34•••-••-9192646-835-3919EMILY.LOPEZ@ICLOUD.COM6843 Camelback Rd Apt 4Chandler·AZN/AGRP-3410CORE-HMO
CLMCLM-4059082026-02-20T13:26:54ZSteven—Salazar1950-05-26UNKNOWNnull(438) 585-2568—694 BAYSHORE DRFresnoCA93798GRP-7140-
ENRENR-1119162026-07-20T12:26:20ZSARA—SCHMIDT1983-10-15UHC-29342-37•••-••-8709252-486-4766··sara.schmidt76@yahoo.com6820 Willow CourtNashvilleTN37275GRP-9290CORE-HMO
TPATPA-538592026-05-26T11:40:56ZJFF—GRIFFIN19440813-··•••-••-1749(630) 814-4980UNKNOWNNULL—-UNKNOWNGRP-0134NAVIGATE-HMO
ENRENR-1216832026-01-13T06:41:25ZJoshuaEYoung2003-09-05UHC-79976-16•••-••-93807109692931joshua.young88@outlook.com··8264 Bayshore DrHoustonTX77068GRP-5408MEDICARE-ADV-A
CLMCLM-4297482026-07-12T13:41:28ZBradley—Santiago02/23/1976UHC-26632-77—UNKNOWN··null7766 RIDGE ROADSan Antonio··TX78231GRP-0916MEDICARE-ADV-A
PRVPRV-280962026-08-20T19:11:44ZTYLER··—SANDERS1995-01-19NULL··UNKNOWN·(649) 724-4073tyler.sanders@aol.com1664 Forest Avenue·MINNEAPOLIS·MN55456——
ENRENR-1066632026-09-18T03:21:01ZEDWARDVLAWRENCE·1997-02-10UHC-75221-98UNKNOWN5408405914EDWARD.LAWRENCE@YAHOO.COM8760 Jefferson AveNashville··TN37288GRP-6609··MEDICARE-ADV-A
PRVPRV-279742026-03-14T19:29:42ZKENNETH—BURTON1950-06-10—N/A276-754-6196—8977 Central AveFRESNO·CA—·N/A—
ENRENR-1390252026-07-17T06:58:43Zjames—mills16-10-1982UHC-21607-68•••-••-8930-james.mills@yahoo.com9312 BroadwayLos Angeles··ca90068GRP-0224CHOICE-PLUS-PPO
ENRENR-1137112026-08-17T16:35:30ZDanielle—Wright4/6/1976UHC-97894-31•••-••-8417(886) 677-8019DANIELLE.WRIGHT22@AOL.COM4837 MESA DRDallasTX75281GRP-1055CORE-HMO
CLMCLM-4323242026-01-10T12:09:11Z Tyler—Daniels1980-04-06uhc-58970-27-—-1390 HILLCREST RD·LAS VEGASNV··89104··GRP-7770SELECT-EPO
ENRENR-1351822026-01-10T06:52:45ZCHARLOTTE··—MORENO12/24/1998··UHC-12520-87•••-••-0358(373) 636-6572··charlotte.moreno@yahoo.com2579 Sage CourtSeattleWA··98107GRP-4504CORE-HMO
ENRENR-1024582026-09-08T06:39:05Z Virginia··Ellis1954-12-02UHC-03401-62•••-••-7103+1 511 509 6230virginia.ellis@hotmail.com5174 Forest AvenuePhoenixAZ85032-5106GRP-9742OPTIONS-PPO
ENRENR-1056612026-06-04T11:24:43ZAna U—Espinoza1996-11-19UHC-35329-82•••-••-9741909-335-5723ana.espinoza@icloud.com9821 Ridge RdPhoenix·AZ85045GRP-2413NAVIGATE-HMO
CLMCLM-4103072026-05-02T12:58:09ZHelen··—Phillips1969-10-04UNKNOWN•••-••-114415747149073null1268 Church StScottsdaleAZ85207GRP-1432—
CLMCLM-4186982026-03-29T11:23:25ZGeorgeE.Shew1984-10-20UHC-36004-77-(799) 653-9568null6572 Bayshore DrTucsonAZ85780GRP-8580SELECT-EPO
ENRENR-1370522026-02-11T14:24:01ZNCIOLE I—VEGA1965-06-28UHC-90651-35•••-••-2028317-229-9941nicole.vega78@outlook.com7571 Palm DrMesaArizona85244GRP-4015MEDICARE-ADV-A
ENRENR-1395802026-10-01T02:14:54ZEthanE.··Gardner1961-03-01·UHC-07381-68•••-••-3849758-381-1982N/A8361 INDIAN SCHOOL RDNASHVILLETN37248··GRP-6155··MEDICARE-ADV-B
ENRENR-1069192026-05-28T16:45:41Z Nicholas··DLane1996-05-19UHC-57583-18•••-••-656312276288685nicholas.lane@yahoo.com7226 CAMELBACK RDTucsonArizona85765GRP-6116NAVIGATE-HMO
PRVPRV-294602026-05-13T19:23:22ZMelissa··Gibson03/15/46—•••-••-13429548196908·melissa.gibson@aol.com8469 Oak StCOLUMBUSOH43204UNKNOWN-
ENRENR-1134412026-02-20T18:31:13ZTeresaJ.Hanson1951-09-17UHC-21907-74•••-••-5591355-873-1205teresa.hanson@aol.com2999 Pine DriveJacksonvilleflUNKNOWNGRP-2734NAVIGATE-HMO
ENRENR-1049242026-09-02T10:05:48Z William—Ward·1984-05-17·UHC-96074-07•••-••-9851—N/A5716 Mountain View DriveHoustonTX77051GRP-7332CHOICE-PLUS-PPO
PRV PRV-223572026-07-12T22:10:00ZNathan—Hayes1951-10-28UHC-76338-71-(950) 436-7991—null-·---—
ENR ENR-1023282026-09-30T22:57:33Z Bobby—Kelly1975-04-25··UHC-98988-55•••-••-4939·387-583-2552bobby.kelly@proton.me5505 WASHINGTON STColumbusOH43298GRP-0854NAVIGATE-HMO
ENRENR-1424852026-07-21T07:05:56ZLINDAVPAYNE12/06/93UHC-07120-79•••-••-92618087800471linda.payne16@outlook.com321 MOUNTAIN VIEW DRIVEAtlantaGA30334-2743·GRP-5646MEDICARE-ADV-B
TPATPA-541982026-09-01T07:14:34Z GERALD—NICHOLS1956-12-02null—UNKNOWN—592 BroadwayLos AngelesCalifornia90092nullN/A
ENRENR-1398582026-04-30T15:05:38Z·ANDREA—·ORTIZ1980-09-18UHC-56559-86•••-••-49933729069609·andrea.ortiz@hotmail.com662 UNION STREETTUCSONAZ85792GRP-9784CORE-HMO
ENRENR-134180 2026-06-03T11:40:25ZMadisonOAndrews1950-08-12UHC-68811-47•••-••-8761(769) 481-3712madison.andrews@icloud.com8118 Cedar Ln··OrlandoFL32878·GRP-0252·CHOICE-PLUS-PPO
ENR ENR-1233812026-01-18T19:21:44ZSusanX.Burns0200-04-10UHC-68235-49NULLUNKNOWNsusan.burns@hotmail.com4393 Ridge RoadDenverCO80253GRP-3225NAVIGATE-HMO
100,000 rows, page 77 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.794Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty