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-4290772026-10-15T17:33:35ZMariana—Arnold1982-03-14UHC-39533-22—N/Amariana.arnold@aol.com··UNKNOWN—UNKNOWNUNKNOWNGRP-4128null··
CLMCLM-417660 2026-06-01T17:57:05ZLAUREN—SCOTT2001-02-27UHC-72511-19null2774887011-·4131 CENTRAL AVENUESan AntonioTX78235GRP-2654UNKNOWN
ENRENR-1214672026-04-23T15:49:56Z Beverly—Greene··1955-12-28UHC-77622-64•••-••-1265639-970-5417··N/A2041 Forest AvenueTempeAZ85203GRP-9481CHOICE-PLUS-PPO
ENRENR-131270 2026-05-25T05:54:12ZJulie—Cunningham2/7/1995UHC-66087-50•••-••-3866+1 761 404 3718julie.cunningham18@outlook.comnull····nullnullGRP-8766CHOICE-PLUS-PPO
TPATPA-536322026-06-12T13:34:41ZJaniceV.Stone1974-07-18N/Anull9638437888UNKNOWN6480 OCEAN AVE #122ChandlerAZ85290——
ENRENR-1181072026-08-02T01:52:13ZMARCUS—AGUILAR22-07-1977UHC-13029-18•••-••-68143238528253marcus.aguilar@proton.me4797 Cedar LnSacramentoCalifornia95887·GRP-4538NAVIGATE-HMO
ENRENR-1261482026-05-18T05:55:32ZKELLY—·VASQEUZ1994-11-02UHC-28576-12—836-826-8136-2110 Church StreetMesaAZ85274GRP-5196OPTIONS-PPO
ENRENR-1239962026-02-24T19:11:27ZElijah—Stephens2002-10-04UHC-28699-80—884-648-8345ELIJAH.STEPHENS@OUTLOOK.COM7755 RIDGE ROADJacksonvilleFlorida32240·GRP-9631MEDICARE-ADV-B
ENRENR-1221552026-01-06T21:36:59ZSamantha—·Tran1998-06-11UHC-34504-52•••-••-86993438300635null··null——nullGRP-5334MEDICARE-ADV-B··
CLMCLM-4256842026-07-09T03:03:38ZscottB.moreno·17-03-1943N/ANULL9416264149··2645 Park Place·SacramentoCA95841··UNKNOWN
ENRENR-1178072026-07-14T11:42:46ZBeverly—Elliott12/28/93UHC-59781-23•••-••-48534314943613BEVERLY.ELLIOTT@AOL.COM4808 Lincoln WayMinneapolisMN55464GRP-0848MEDICARE-ADV-B
ENRENR-1015702026-04-30T07:02:27ZMateo—Snyder1984-08-13UHC-26840-16•••-••-38467647397988mateo.snyder15@icloud.com7355 PINE DRIVE #524DallasTX75240-5842GRP-7832MEDICARE-ADV-B
CLMCLM-4239942026-05-11T08:19:58ZJoshua—Simpson09/01/1998UHC-82445-32UNKNOWN——1726 MOUNTAIN VIEW DRDenverCO80267——
CLMCLM-4273752026-09-29T05:23:44ZAnaA.··Cox1981-07-08—•••-••-0321—N/A8684 MAIN STTempeAZ85216-··null
ENRENR-1116352026-04-24T23:20:30ZVALENTINARNGUYEN1938-05-27UHC-21516-69•••-••-72636576986863-7640 Main StreetChandler·AZ85274GRP-6150CORE-HMO
CLMCLM-422033 2026-10-15T22:29:23ZBrian—Coleman··1948-01-28UHC-17963-76null(849) 786-0912NULL4479 Ocean AvenueSan AntonioTX78252—OPTIONS-PPO
ENRENR-1041542026-05-17T05:42:05ZANN—·SIMMONS19540913UHC-19311-66•••-••-0666(315) 437-2695ANN.SIMMONS77@OUTLOOK.COM3060 Market StreetGlendaleAZ85394-2845GRP-5520CHOICE-PLUS-PPO
ENRENR-1067562026-03-20T06:53:28ZEmmaO.Reed07-06-1991UHC-91196-41•••-••-71896332224385null5209 Desert Sky BoulevardPhoenixArizona85073GRP-2510MEDICARE-ADV-B
ENRENR-1290402026-01-30T11:03:24ZDIEGO—SINGH2008-10-21UHC-67990-40•••-••-1539767-465-0381·diego.singh2@outlook.com1486 BROADWAY Apt 39Las VegasNV89148GRP-4544MEDICARE-ADV-B
ENRENR-1266632026-06-01T04:04:53ZSTEPHANIE—LEE1958-09-17·UHC-99580-25•••-••-39755685265STEPHANIE.LEE66@ICLOUD.COM5666 Lake View RoadMinneapolisMinnesota·55423·GRP-7525select-epo
PRVPRV-237252026-02-17T16:54:10Zethan··ross05/11/78——869-377-9501ETHAN.ROSS@AOL.COM1589 CENTRAL AVEJacksonvilleFL32248null—
ENRENR-1290322026-04-29T16:05:42ZDOUGLAS—JENSENApr 27, 1974UHC-04832-19•••-••-201817262998344DOUGLAS.JENSEN43@AOL.COMN/A———GRP-0703·CHOICE-PLUS-PPO
ENRENR-1248342026-01-05T12:28:44ZAmy—Riley1957-03-05·UHC-09465-38•••-••-9674+1 699 559 0922····4668 Jefferson AveSeattleWA98123··GRP-8919OPTIONS-PPO
CLMCLM-4156692026-04-07T12:27:18ZSHARON—STEVENS1985-05-24UHC-10278-31—(762) 809-4049N/A—NULLN/A··NULL—N/A
CLMCLM-4221602026-05-16T01:31:34ZPAUL—ROMARO1971-11-27··UHC-28842-64—UNKNOWNN/A8261 Harbor Blvd·MiamiFL—GRP-3479NULL
TPATPA-573032026-03-05T11:08:23ZFrnk—Kelley1942-02-28UHC-40168-92—4224129873—4477 Sunset Blvd·JACKSONVILLEFlorida32204GRP-5333··
ENR ENR-1315342026-10-11T18:40:43ZWEIBSTEVENS1957-09-24UHC-61657-92•••-••-85312593872084WEI.STEVENS88@GMAIL.COM526 SAGE COURTAustinTX78788·GRP-6183OPTIONS-PPO
CLM CLM-4242532026-06-17T07:04:11ZKELLY—EVANS1943-06-21UHC-73587-33—18762546708—4317 Grand AvenueMiami·FL33188GRP-8370UNKNOWN
CLMCLM-4131702026-04-20T17:16:40ZBRYAN—SILVA1955-11-05N/A—391-606-1515-·612 Church StreetSan Antonio··TX78223GRP-0529MEDICARE-ADV-A
CLMCLM-4208432026-08-07T14:13:16Zkyle—silva··1968-07-18UHC-98556-49··UNKNOWN8197027654null4890 Bayshore Drive Apt 25PhoenixAZ··85019-CORE-HMO
CLMCLM-4252652026-03-18T13:08:48ZwayneYallenSep 4, 1970UHC8805422null602.376.0712-5414 Spring StreetTampaFL33698-2311GRP-5747·null
TPATPA-542462026-10-04T05:17:44ZZACHARY—HILL01/15/1958N/AN/A253.957.0730—7404 MARKET STSacramentoCalifornia95805UNKNOWNN/A
ENRENR-1272272026-04-11T10:28:10Z·SANDRAWOWENS1972-03-03UHC-34059-29•••-••-0203488-527-8152··SANDRA.OWENS79@HOTMAIL.COM7000 HARBOR BLVDCHANDLERAZ·-GRP-5273CORE-HMO
ENRENR-113255 2026-03-07T06:50:24ZPeterA.Myers1968-11-17·UHC-88337-04•••-••-4778905-859-2669peter.myers3@gmail.com5045 Church StreetGLENDALEAZ·85310GRP-7470OPTIONS-PPO
ENRENR-1281122026-02-09T01:00:24ZROGERF.·SLULIVAN01/21/41UHC-76081-48•••-••-69933587989838roger.sullivan18@yahoo.com9235 Hillcrest RdGlendaleArizona·85385GRP-8978CHOICE-PLUS-PPO
ENRENR-1278002026-04-08T01:25:45ZASHLEY—HOWARD1981-01-22UHC-68473-02N/A287-646-2150ashley.howard61@yahoo.com9460 WASHINGTON STREETGILBERTArizona85291GRP-6945··NAVIGATE-HMO
CLMCLM-4173242026-10-06T23:56:19Z Emily—·Bryant2003-02-21UHC-96529-14•••-••-0398—··6820 BroadwayMESAArizona85277GRP-2202SELECT-EPO
ENRENR-1156142026-05-27T07:54:57ZCAMILAKHUGHES19640215UHC-53890-36··•••-••-3948(986) 262-6835camila.hughes8@hotmail.com··8702 DESERT SKY BLVDAustinTX78788GRP-8620MEDICARE-ADV-B
ENR ENR-1355042026-09-06T02:10:14ZEugeneU.Martinez1977-07-22UHC-94632-57•••-••-86305557898981eugene.martinez99@outlook.com17 Pine DrivePLANOTX75043GRP-0738CHOICE-PLUS-PPO
TPATPA-631092026-09-01T09:45:21ZVincent—Hughes1978-01-02NULLnull+1 518 925 4297-8897 WILLOW CTMESAAZ85292GRP-2651—
ENRENR-1042322026-04-12T02:10:46ZJesse—Luacs1998-01-16··UHC-84275-95N/A(431) 622-6202jesse.lucas28@gmail.com1000 Mesa DrSeattleWA98146GRP-1466NAVIGATE-HMO
CLMCLM-4134372026-01-29T18:01:09ZAlan—Sanchez19661125UHC-35719-69•••-••-6013—-5421 HILLCREST RDPhoenixAZ··85064-9949··GRP-2042null··
ENRENR-1340442026-02-15T08:54:31ZEDWARDSMARSHALL1999-06-22UHC-05611-09•••-••-3952·+1 962 259 6928EDWARD.MARSHALL@AOL.COM9599 Central AveCHARLOTTENC28247GRP-6718SELECT-EPO
CLMCLM-4127382026-09-25T20:48:56ZHaroldP.Patterson03/26/1940UHC-04603-36•••-••-8241-—226 Harbor BlvdSan AntonioTX78260—SELECT-EPO
CLMCLM-414182 2026-06-16T22:30:40ZSophia—Cole1991-04-15—•••-••-0203(484) 370-2581UNKNOWNUNKNOWNUNKNOWN····N/A·NULLnull
ENRENR-1292562026-04-20T23:50:05ZBRIAN—HUNTER1942-01-08UHC-77779-46····276-275-9218brian.hunter42@hotmail.com9395 Ridge RdJacksonvillefl32211··GRP-1900CHOICE-PLUS-PPO
CLMCLM-4071162026-04-19T18:32:32ZJESSE—SPENCER·19431124N/A•••-••-9852577-770-4546—5080 Harbor BlvdSeattleWA98107GRP-3780··CORE-HMO
CLMCLM-4051582026-10-13T09:37:27ZAlexis—Fox2007-04-26UHC-32649-36•••-••-6417NULL—7627 Indian School RoadGilbertAZ85200—CHOICE-PLUS-PPO
ENRENR-1375092026-04-20T23:18:37ZSaraAVega1971-11-12UHC-61662-93··•••-••-91018964138417UNKNOWN3538 Elm St Apt 19CHARLOTTENC28298GRP-0946SELECT-EPO
TPATPA-613692026-01-24T19:55:45ZJUDITH—BANKS1949-01-10——969.225.8400N/A3720 Main StOrlandoFL32890-9927·NULLNULL
100,000 rows, page 227 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.735Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty