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-4160602026-07-03T19:06:08ZNATHAN—POWELL2008-10-26UHC-52217-20··•••-••-3581null—4106 Cedar LanePhoenixAZ·85080GRP-8355·-
ENRENR-1189432026-09-20T22:39:30ZAhmed—Jones03/22/43uhc-81105-23•••-••-38333932081531UNKNOWN2851 Indian School RdMiamiFL33127GRP-3352NAVIGATE-HMO
TPATPA-621332026-03-31T19:50:40ZDonna—Graham·1976-06-12UHC-00728-71null7767305430donna.graham84@aol.com1770 Oak St··MiamiFL33104·-—
ENRENR-1104332026-05-24T03:26:45ZTURNRVDEBRA1994-08-06UHC-81707-43•••-••-7718+1 960 857 0465DEBRA.TURNER@HOTMAIL.COM906 CHURCH STREETNASHVILLE··TennesseeNULLGRP-4291SELECT-EPO
ENRENR-1248722026-08-03T04:36:25ZGloriaPFranklin1974-06-06UHC-58135-07•••-••-22352646625596gloria.franklin21@yahoo.com9640 Meadow LaneNashvilleTN37203··GRP-0257CHOICE-PLUS-PPO
ENRENR-1325582026-07-25T11:34:49ZDebraR.KnightApr 27, 1991UHC-42617-07•••-••-5793NULLdebra.knight38@yahoo.com4546 CHURCH STREETTampaFL33644GRP-3633NAVIGATE-HMO
ENRENR-1324142026-05-07T06:06:22ZKaren—Perez·1939-01-22UHC7140838•••-••-5297458-526-0815karen.perez82@yahoo.com5839 BROADWAYTucsonAZ85776GRP-1815NAVIGATE-HMO
ENRENR-1245672026-05-26T02:51:56ZJudithPGreen1960-11-26UHC-40902-13•••-••-7634432-864-0259JUDITH.GREEN10@PROTON.ME1436 Central AvenueAtlantaGAUNKNOWNGRP-7814CHOICE-PLUS-PPO
ENRENR-1327932026-05-06T20:04:34ZHall, Christopher——21-02-1951UHC-25937-42•••-••-1933562.961.5109CHRISTOPHER.HALL@ICLOUD.COM·1703 Spring StreetEDEN PRAIRIEMN55302GRP-7446CHOICE-PLUS-PPO··
ENRENR-1021472026-02-06T14:10:59ZNathanM.··Armstrong·02/06/42UHC-15778-11•••-••-1930N/Anathan.armstrong@outlook.com5140 Highland Ave·OrlandoFLNULLGRP-9651OPTIONS-PPO
PRVPRV-269202026-05-01T16:55:23ZYUKI—HARRIS1950-10-26UHC-23626-39•••-••-54709277018yuki.harris@gmail.com3874 SAGE COURTAustinTX78720-··NULL
CLMCLM-4168652026-05-20T07:18:55ZAngela—·Garrett·19480506-•••-••-52673277786956N/AUNKNOWNUNKNOWN——nullCHOICE-PLUS-PPO
PRVPRV-266222026-06-15T09:50:47Zdouglas—stevens2003-03-17—N/A—UNKNOWN7040 Oak StColumbusOhio43236NULLUNKNOWN
ENRENR-1154172026-06-06T10:57:29ZKAYLA—VARGAS1987-08-09UHC-09167-84•••-••-57726776316839··kayla.vargas52@gmail.com9824 Elm StreetSCOTTSDALEAZ85239GRP-4647NAVIGATE-HMO··
ENRENR-1347312026-02-05T15:57:35ZJULIE—FOX1939-08-04UHC-79877-01•••-••-1824692-294-6043julie.fox@yahoo.com···5009 WILLOW CTMinneapolismn55460GRP-4717OPTIONS-PPO
TPATPA-601352026-02-22T15:17:48ZHannah—·Santos1999-07-04N/A·UNKNOWN6293963219—UNKNOWNN/Anull—GRP-5276N/A
ENRENR-1389632026-05-26T05:37:41ZJoshua—Park1943-06-03UHC-09752-86··•••-••-6443+1 836 959 2846joshua.park@aol.com5944 Church StAustinTX78727GRP-8938··CHOICE-PLUS-PPO
CLMCLM-4059752026-04-01T03:25:54ZRomero, Zachary··—1987-08-21··UHC-63280-47•••-••-8360NULL··zachary.romero50@gmail.com7869 Camelback RdSacramentoCalifornia95833—CHOICE-PLUS-PPO
ENRENR-1268832026-04-29T10:08:44ZHelenUDominguez2000-05-20UHC9605746NULL2974512622HELEN.DOMINGUEZ88@AOL.COM320 Pine DrEden PrairieMN55369GRP-4144NAVIGATE-HMO··
CLMCLM-4103962026-07-03T22:38:03ZPhilipAWood1946-02-19—·nullnull——-····——CHOICE-PLUS-PPO
PRVPRV-215102026-10-18T15:30:58ZBRITTANY—CAMPBELL1954-04-18null•••-••-4729+1 827 851 7763—5105 VALLEY VIEW DRFresnoCA93759UNKNOWN-
ENRENR-1279822026-01-14T07:24:47ZABIGAILZCUNNINGHAM1939-09-28UHC-07249-40•••-••-69998772953074abigail.cunningham@outlook.com··4046 Oak StTAMPA··Florida33663GRP-7847NAVIGATE-HMO··
CLMCLM-4047692026-07-27T04:17:52ZLUIS·U.PARK1950-09-14UHC-72273-24UNKNOWN-—-—nullN/AGRP-0576null
ENRENR-1106172026-07-14T03:34:04ZDIANA····ROSE1953-12-09·UHC-04067-20•••-••-9655352-387-9342diana.rose17@proton.me653 Harbor BoulevardMESAAZ85227-6774GRP-3212·MEDICARE-ADV-B
PRVPRV-224782026-10-16T21:53:48ZArjun—Chavez19580721UHC-23529-51——ARJUN.CHAVEZ@OUTLOOK.COM—null—NULLN/AUNKNOWN
ENRENR-1121902026-01-02T16:00:46ZAndy··Salazar1982-11-12UHC-40525-97•••-••-2101+1 780 475 0049andrew.salazar@hotmail.com1044 OAK STScottsdaleAZ85246-8354·GRP-8667select-epo
PRVPRV-249232026-06-14T22:52:05ZJERRY—HALLApr 25, 2000·UHC-27759-66—977-604-6378—6492 Canyon RdCharlotteNC28212-null
ENRENR-1123022026-08-18T03:38:46ZmateoFpadilla04/21/1938UHC-63917-46•••-••-2430(268) 497-8011MATEO.PADILLA92@OUTLOOK.COM··8385 Forest Avenue··San DiegoCA92113GRP-7485··MEDICARE-ADV-B
ENRENR-1303692026-06-21T06:52:38ZedwardXvaldez··2006-10-03UHC-62382-43•••-••-7515(867) 836-5610EDWARD.VALDEZ@PROTON.ME608 CHURCH ST Apt 2ChandlerAZUNKNOWN···GRP-5042MEDICARE-ADV-A
ENRENR-1344022026-09-18T00:58:42ZVirginia··—Mjia2006-02-17UHC2901039•••-••-03172412314554VIRGINIA.MEJIA96@HOTMAIL.COM5994 Canyon Road Apt 22FresnoCA··93767GRP-1344SELECT-EPO
TPATPA-501842026-07-29T11:37:16ZEmma—Cox1996-05-09nullnullN/A—4137 Canyon RoadJacksonville··FL··—NULLnull
ENRENR-1173382026-08-16T04:21:26ZEmilyWHolmes9179-07-01UHC-72045-46•••-••-6055(772) 267-5177·EMILY.HOLMES59@PROTON.ME1886 Desert Sky BoulevardScottsdaleAZ85216GRP-4610MEDICARE-ADV-A
CLMCLM-4267572026-01-08T02:13:38ZKarenYHerrera6/10/1997N/Anull·214-789-7640———N/AUNKNOWNGRP-0554MEDICARE-ADV-A
TPATPA-610402026-10-07T16:08:29ZMARK—HUGHESMar 17, 1941—•••-••-2385NULLNULLN/AnullN/ANULL—-
CLMCLM-4054552026-06-05T00:43:28ZPHILIP··LAWRENCE1991-10-02UHC-27655-89•••-••-1678802-322-2072UNKNOWNUNKNOWN——·N/ANULLCHOICE-PLUS-PPO
CLMCLM-4032722026-07-11T15:05:02ZBrandon—Pierce1995-12-09null•••-••-7069····UNKNOWN1835 SPRING STCharlotteNC28289GRP-1585-
CLMCLM-4137512026-10-09T14:59:54ZGregory—Mendez05/15/47UHC-93422-08N/A——3586 HARBOR BLVDHoustonTX77003·GRP-3900OPTIONS-PPO
ENR ENR-1119612026-08-19T09:53:28ZkathrynSmorris1945-11-03UHC-54409-02•••-••-96314239564422kathryn.morris@icloud.com·2221 Forest AveJACKSONVILLEFL32234GRP-2986CHOICE-PLUS-PPO
ENRENR-1380962026-04-29T18:15:05ZThomas—Cruz1998-03-20UHC-85435-68•••-••-80036077454-5054 MAIN STREETPHOENIXAZ85085GRP-9585·OPTIONS-PPO
PRVPRV-233162026-10-11T09:37:45Z·yuki—hayes··1978-11-25UHC-85445-45-774-284-7603yuki.hayes@aol.com2971 Grand AveOrlandoFL32890——
ENRENR-1253282026-03-30T01:23:19ZMargaretSMartin2003-07-16UHC-04183-02•••-••-2861+1 722 399 8376MARGARET.MARTIN@OUTLOOK.COM8044 Pine DrFresnoCA93709GRP-7048NAVIGATE-HMO
PRVPRV-267612026-01-10T03:22:16ZCYNTHIA—ORETGAJul 8, 2002UHC-54454-59··2574457724null3415 CANYON ROADNashvilleTN37299····—
ENRENR-1400232026-09-07T20:29:44ZAlbert··—Weaver3/6/1950UHC-17326-17•••-••-3660+1 898 585 8206—4070 Forest AvenueSan AntonioTX78284GRP-1283OPTIONS-PPO
CLMCLM-4312332026-10-16T16:14:09ZJoan—Rivera1989-12-18UHC-22799-76UNKNOWN—UNKNOWN7244 OAK STREETMiami··FL33179-6183GRP-4230NAVIGATE-HMO
ENRENR-1104792026-03-06T01:01:40ZCastro, Madion——1960-12-26UHC2812860•••-••-7050227-566-7996madison.castro@proton.me5257 Hillcrest RoadORLANDOFloridaN/AGRP-7746CORE-HMO
CLMCLM-4325822026-08-20T06:01:03ZCharlotte—Ross2004-10-21UHC7460796—nullNULL3803 Willow Ct Apt 38HoustonTX77017GRP-0539NAVIGATE-HMO
ENRENR-1350232026-09-18T03:48:35ZSHARONC.GRAY01/01/60UHC-95468-33•••-••-3058(329) 659-5868SHARON.GRAY45@OUTLOOK.COM4386 Pine Dr··Eden Prairiemn·55363GRP-7911CHOICE-PLUS-PPO
TPATPA-637652026-03-03T01:27:54ZCarter—LarryOct 14, 1981—-UNKNOWNN/A1439 Maple AvenueScottsdaleAZ85256NULLCHOICE-PLUS-PPO
CLMCLM-4278452026-10-16T15:42:00ZBryanY.Mitchell1999-02-03nullNULL664.705.9422BRYAN.MITCHELL37@OUTLOOK.COM7660 Baseline RdSacramentoCalifornia95833-N/A
TPATPA-532842026-06-08T14:41:44ZTimothy··—Nichols1989-07-13UNKNOWN-··NULLNULL8409 Bayshore DrSan AntonioTX78268-UNKNOWN
100,000 rows, page 258 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:37.753Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty