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-413500 2026-07-21T20:59:39Zlarry—·freeman1973-10-19·UHC-74769-25-—larry.freeman@aol.com8114 Sage CtTAMPAFL33688NULLNULL
ENRENR-1112182026-09-14T12:38:34ZEVELYN Z—VALDEZ1959-09-19UHC-12756-19•••-••-7339(298) 754-7342EVELYN.VALDEZ32@HOTMAIL.COM607 Highland Ave #498San AntonioTX78255GRP-8435··NAVIGATE-HMO··
ENRENR-104517 2026-06-06T05:20:10ZSharon·SBoyd1957-07-20UHC-93216-37•••-••-5720230-729-9847·sharon.boyd@outlook.com4822 Camelback RoadMINNEAPOLISMN55471GRP-4135··select-epo
CLMCLM-4101512026-10-06T15:32:52Z·HENRY—HUNTER06/03/1991UHC-15194-32——N/A1192 Oak StreetLas VegasNV89128GRP-1438CHOICE-PLUS-PPO
TPATPA-557322026-07-04T08:50:01ZKelly—Evans1964-05-28UHC-76873-84N/A—NULL9234 Lake View Rd #148Atlantaga30362UNKNOWNMEDICARE-ADV-B
CLMCLM-420124 2026-03-01T11:01:37ZJULIA—·RICE·04/10/1993UHC-46090-42NULL263-721-4551··NULLUNKNOWNNULL····--··NAVIGATE-HMO
PRVPRV-226852026-04-04T12:09:38ZNancy—Rios03-11-1945null—N/Anancy.rios19@outlook.com7547 Highland Avenue Apt 19COLUMBUSOH43286NULL—
ENRENR-1393782026-02-11T11:39:36ZDiaz, SharonB—1957-07-25UHC-05198-84•••-••-1471·16089609342sharon.diaz80@outlook.com4651 SAGE COURTNashville·TN37266GRP-7295CHOICE-PLUS-PPO
CLMCLM-4286902026-08-08T10:50:26ZRios, Lucia——1939-04-02UNKNOWN-nullLUCIA.RIOS@AOL.COM5436 CAMELBACK ROADDenverCO80248UNKNOWNMEDICARE-ADV-B
CLMCLM-4011762026-08-25T17:12:56ZJerry—West2005-09-21UHC-63267-01•••-••-5603UNKNOWN—-—N/A-—MEDICARE-ADV-B
TPATPA-570222026-04-07T10:15:45ZRaymondAThomas1966-03-27—null(827) 461-4635·raymond.thomas54@gmail.com7605 Harbor BlvdPHOENIXAZ85007—MEDICARE-ADV-A
ENRENR-1313552026-09-06T09:21:57ZFox, Roger——07/18/90UHC-96985-70•••-••-5715640-414-8100roger.fox@icloud.com5466 MAPLE AVETAMPAFL33680GRP-8956MEDICARE-ADV-A
ENR ENR-1240592026-03-02T18:23:21ZALBERTNFREEMAN·04/15/80UHC-90198-79—5023696716··N/A8360 CENTRAL AVECharlotteNC28241GRP-6167NAVIGATE-HMO
CLMCLM-4162032026-08-20T13:28:34ZPamela—Ruiz1973-02-23UHC-19463-21•••-••-5562(769) 541-4373NULL383 Meadow LnCharlotteNC28235GRP-3665—
TPATPA-55846 2026-06-03T20:27:52ZMaria—Dean2007-10-07—-N/A—6450 LINCOLN WAYTempeAZ85296——
TPATPA-626682026-07-21T23:41:45Zmelissa··Yphillips2008-08-03———UNKNOWN9369 Sage CtSeattle·WA98167—NULL
CLMCLM-4177372026-10-04T23:43:45ZWAYNE—CASTRO1950-09-06—•••-••-0212814-991-2985··-···2524 BASELINE RDSacramentoCA95862GRP-4266null
CLMCLM-432407 2026-02-25T06:50:05ZLori—Luna··2005-04-02UHC-97259-41•••-••-910117614348248··6738 MESA DRAtlantaGA30328GRP-8465CORE-HMO
TPATPA-620172026-01-08T18:03:56ZAlbert—Watkins09/26/08UNKNOWN—6938904629·albert.watkins@icloud.com6358 Ridge RdTucsonAZ85780··GRP-4384N/A
CLMCLM-4228452026-06-28T08:55:11ZANA—GILBERT1979-03-17UHC-96425-46··-·338-695-3263—3101 Ridge Rd·HoustonTexas··77068NULL—
CLMCLM-4156092026-05-17T02:15:04ZJoshua—Coleman1999-09-26UHC9776178•••-••-5293+1 524 527 8049·null3148 WILLOW COURTChandlerAZ85286··GRP-5210—
CLMCLM-4274532026-03-01T11:17:39ZKathryn—Hart1947-01-10UHC-34576-96··•••-••-29974636167714null—---—SELECT-EPO
ENRENR-1331852026-02-17T16:06:45ZArthurHWashington2000-07-27UHC-09983-59•••-••-294317256802731arthur.washington@proton.me7566 Willow Ct #300GilbertAZ85294GRP-1869CORE-HMO
CLMCLM-4151182026-06-15T11:25:45ZCharlie—Burke08-11-1955UHC-58990-73N/A·NULLnull5211 SUNSET BOULEVARD #664Atlanta··GA30354-5254GRP-8328··SELECT-EPO
ENRENR-1236802026-04-13T16:07:09Z·BettyYMartinez1968-04-26uhc-57515-46•••-••-0042——3912 Central AveLos AngelesCA90010GRP-4271MEDICARE-ADV-B
CLMCLM-4066202026-01-31T17:28:09ZBrendaTPorter0310-02-03-—448-807-9590—-NULL—N/A——
TPATPA-579332026-06-28T20:21:13ZALBERT—HERNANDEZ·11-09-1983UNKNOWN—5533754564··3177 Spring StLas VegasNevada89184—N/A
CLMCLM-4127772026-05-09T20:42:44ZERIC—BELL1947-07-17UHC-12364-05NULL16585341501UNKNOWN··5298 Highland AveLos AngelesCA90027GRP-9231··-
ENRENR-1098812026-05-28T09:25:04ZArjnu—Fisehr2/28/1939UHC-94678-19•••-••-5282·9027253627ARJUN.FISHER@AOL.COM8973 Elm StNashvilleTN37236··GRP-8234CHOICE-PLUS-PPO
ENRENR-1045412026-04-11T09:45:54ZMichaelKKelly04/04/1984UHC-55894-77•••-••-3550NULL—9662 Willow CtDallasTX75200GRP-6451choice-plus-ppo
CLMCLM-4196132026-07-14T01:29:40ZCynthia—Banks1996-04-05UHC2179389—-—8267 Ridge RdMinneapolisMN55489-2704GRP-3095CORE-HMO
CLMCLM-421078 2026-04-04T22:43:07ZLucia··Smith·1964-01-03UHC-39153-37•••-••-7762——866 BROADWAYTempeAZ85275-—
CLMCLM-4156142026-01-12T05:16:29ZSingh, Terry··——May 20, 1956UHC-09840-40•••-••-5041UNKNOWN—·7381 MAIN STREETSeattleWA—·GRP-5929—
ENRENR-1377812026-06-25T16:13:38ZGrace—Bishop9/18/2004UHC-67811-69•••-••-84054347343grace.bishop27@hotmail.com67 Sage CourtSeattleWA98126GRP-6035SELECT-EPO
CLMCLM-4156192026-10-14T06:35:10ZGREEN··D.THERESA1948-11-06UHC9772562—665-518-6500——UNKNOWNNULL-GRP-0897SELECT-EPO
ENRENR-1118032026-10-06T15:38:02Z·paulWwarren1988-02-11UHC-23202-90•••-••-7157(655) 898-6393PAUL.WARREN43@OUTLOOK.COM4438 Willow CourtLos AngelesCA90034GRP-9050MEDICARE-ADV-B
CLMCLM-4102492026-02-14T13:03:00ZVirginia—Hayes10/14/43UHC-15953-18null—NULL—UNKNOWNNULL——·NAVIGATE-HMO
ENRENR-1411602026-07-14T18:10:23ZRICHARD—MEDINA··1972-05-09UHC-46415-43•••-••-2574+1 936 413 5708richard.medina78@icloud.com·3811 Mesa Dr·ChandlerAZ85214·GRP-2329OPTIONS-PPO
TPATPA-548402026-02-01T20:45:58ZWILLIE—ROSS2004-05-19—N/A7869260····896 Lake View RoadFresnoCalifornia93720-8474GRP-5445null
ENRENR-1377562026-07-22T01:46:14ZANN—SANTIAGO1990-01-07UHC-72018-89•••-••-8268+1 431 341 4103ann.santiago@gmail.com4669 Main StreetGLENDALEAZ85338GRP-7405SELECT-EPO
CLMCLM-4222392026-02-23T02:11:12Z RUTH—OLSON10/19/1960—•••-••-1713694-413-6596—8833 Sage CtSEATTLEWA98120NULLOPTIONS-PPO
ENRENR-1221452026-09-29T18:23:34ZShirley—Miller1998-06-04UHC-10380-20··•••-••-67179636805989shirley.miller40@yahoo.com7852 LINCOLN WAYPHOENIXAZ85011GRP-5211SELECT-EPO
ENRENR-1154222026-06-30T16:01:37ZsharonD.··white9142-11-11UHC-18935-08•••-••-0733592-844-0081sharon.white@yahoo.com618 Desert Sky BlvdAustinTX78714GRP-7858NAVIGATE-HMO
CLMCLM-4070652026-06-29T12:50:39ZBrenda····Wells1997-08-04null•••-••-4167—NULL3625 Willow Court #221ScottsdaleAZ—GRP-7170SELECT-EPO
TPATPA-514432026-02-20T06:06:13Z·Carl—Gilbert·1968-12-05N/A•••-••-9320-———N/AN/A-OPTIONS-PPO
ENR ENR-1252002026-06-15T21:12:30Z Garrett, JasonB—1947-05-05··UHC1083758•••-••-3407851.995.4500jason.garrett24@aol.com··3428 HIGHLAND AVEAustintx·78767-1743GRP-6116OPTIONS-PPO
CLMCLM-4080402026-02-20T07:06:09Z JESSE—CLARK1997-05-22UHC-50171-70•••-••-7198-jesse.clark32@aol.comnull··null—nullGRP-0528—
CLMCLM-4089562026-04-08T08:46:26ZANDREA—CARROLL2007-19-88—•••-••-2034N/ANULL6828 OAK STSacramentoCA95878—CORE-HMO
TPATPA-627162026-02-15T23:09:37Zjacob—grant1969-10-22—•••-••-95534346185jacob.grant69@gmail.com3053 Harbor BoulevardTucsonAZ85724UNKNOWN—
TPATPA-510422026-01-31T10:15:51ZBEVERLY—MILLER01/27/1938—UNKNOWN·N/AUNKNOWN7645 CENTRAL AVESan DiegoCA92180··nullNULL
100,000 rows, page 48 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.777Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty