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-628172026-10-17T21:12:23ZGeorge—Berry··1987-02-04NULL····948.219.1848—-NULL—-null—
TPATPA-616362026-08-17T19:29:07ZJoyce—Perez··1977-06-24UHC-21788-68—5748435293—9017 Washington StDallasTX75245-3121NULLMEDICARE-ADV-A
ENRENR-1245982026-03-10T06:20:42ZMARTAN.WARREN1954-11-19UHC-61710-65•••-••-6345796-715-3651martha.warren44@gmail.com3383 Lake View RoadScottsdaleAZ85239GRP-0565SELECT-EPO
TPATPA-635662026-04-01T01:08:59ZFATIMA—SCHMIDT1595-10-17—•••-••-0358UNKNOWNNULL6559 HIGHLAND AVELos AngelesCA··90068UNKNOWNN/A
CLMCLM-4014312026-05-09T23:11:07ZPierce, Sophia——1973-09-23UHC0450142UNKNOWN476-669-3777··-6744 DESERT SKY BLVDGLENDALEAZ··85382—SELECT-EPO
PRVPRV-242282026-08-16T00:26:23ZsaraFmurphy1/24/2008———SARA.MURPHY@OUTLOOK.COM7201 Cedar LnLas VegasNV89184-—
ENRENR-1029072026-07-18T06:29:37Z·Vincent—Delgado1985-10-16UHC-73386-28•••-••-1786765-791-5969vincent.delgado33@gmail.com·8194 Mountain View Drive #824Orlando·FL32888GRP-7605·MEDICARE-ADV-B
CLMCLM-4316492026-04-17T13:23:20ZSAMUEL—RYAN··11/16/1967—•••-••-8882(853) 439-2817····UNKNOWNNULLNULLnullGRP-4204NAVIGATE-HMO
ENRENR-1144092026-09-24T07:40:00ZPatrickP··HendersonApr 8, 1943UHC-99656-49•••-••-0604NULLpatrick.henderson30@aol.com7023 Lake View RoadTAMPAFL33661-4494GRP-0704CORE-HMO··
PRVPRV-258872026-03-21T07:47:09ZSantiagoP·OBrien1991-08-09—•••-••-55974775862551NULLN/A—N/A····-NULL
CLMCLM-4211612026-09-08T05:13:53ZTERESA—HARRSION1951-12-01UHC-43377-08—+1 682 636 9415NULL2348 INDIAN SCHOOL RDGlendale·az85394GRP-6984—
CLMCLM-4210402026-02-03T10:12:35ZsantiagoEpatterson·1978-05-19UHC-98029-22UNKNOWN—N/A6551 Mesa DrCharlotteNC·28248GRP-0106UNKNOWN
ENRENR-1400362026-02-07T06:55:18ZBennett, JeffreyT.—1990-09-06UHC4901133•••-••-2653280.906.9485jeffrey.bennett18@outlook.com2845 Ocean AvenueTucsonAZ··85744GRP-7744CHOICE-PLUS-PPO
CLMCLM-4243732026-02-25T11:42:34Z BobbyUTorres1951-01-21UHC-79343-32NULLN/Anull2970 Grand AvenueDallas··TX75267·GRP-7325N/A
ENRENR-1267642026-10-17T12:55:48ZDOUGLAS—ALLEN1953-09-02··UHC-14793-72··•••-••-8463731-723-5113douglas.allen@icloud.com3383 Meadow Ln·San AntonioTX78245-5353GRP-6022CORE-HMO
TPATPA-609292026-06-25T15:09:14ZFatima—Ford1971-04-08nullN/AN/A··FATIMA.FORD31@PROTON.ME—null-N/AnullOPTIONS-PPO
PRVPRV-248312026-04-06T17:55:57ZCarlos—Kennedy2/5/1976··UHC-61491-38•••-••-8923901-489-6388N/A4777 Palm DrOrlandoFL32867—null
ENRENR-1409872026-09-09T16:52:25ZARJUNX.·CRAWFORD1971-06-23UHC-35273-61•••-••-4655·14133761866arjun.crawford@aol.com8223 Highland AveEden Prairie·Minnesota55372GRP-2439NAVIGATE-HMO
ENRENR-1349822026-10-06T09:18:11ZJANETR.OWENS1981-08-15UHC-62051-86null768-564-1982janet.owens@aol.com4116 Sunset Boulevard #285ORLANDOFL32884GRP-6020NAVIGATE-HMO
ENRENR-1361332026-04-18T08:59:04Zwillie—valdez1988-02-17UHC-39473-35•••-••-7609·6848812897—·5816 Washington StCHARLOTTENC28254GRP-8452CHOICE-PLUS-PPO
CLMCLM-429525 2026-09-04T01:53:09ZCAROL A—SHAW·2002-10-06UHC-74988-59•••-••-3346544-717-3992—1968 WILLOW CTOrlandoFL32826GRP-2897NAVIGATE-HMO
TPATPA-559612026-04-05T18:01:59ZIsabellaUPayne19900609N/A•••-••-6688-isabella.payne16@outlook.com2458 Forest AvenueHoustonTX77019UNKNOWN·N/A
ENRENR-1082252026-05-26T09:39:31ZLucas, LoganL—1985-09-26UHC-61131-87•••-••-55799295223998—3084 Desert Sky BoulevardMesaAZ85281GRP-7543NAVIGATE-HMO
ENRENR-1067552026-08-21T13:48:58ZAlexisQRamirez04/18/1964UHC-68210-89•••-••-5017—alexis.ramirez@icloud.com7736 OCEAN AVEGILBERTAZ85257-0978GRP-4541CHOICE-PLUS-PPO
ENRENR-1244572026-05-15T22:16:46ZRoyB.Rios02/26/1972UHC-25856-56•••-••-3420+1 713 318 7215NULL7323 INDIAN SCHOOL RDNASHVILLETNNULL·GRP-1844NAVIGATE-HMO
CLMCLM-407527 2026-02-26T14:24:24ZALICE—YANG18-02-1997UHC-22171-25-7826753—3250 FOREST AVESacramentoCANULL-UNKNOWN
TPATPA-599302026-02-09T13:06:39ZRyan, Julie····—2000-03-26··•••-••-6201UNKNOWNN/A9125 Bayshore DriveGilbertAZ85295N/Anull
CLMCLM-4082882026-09-26T16:51:03ZRussell—Meyer02/15/1974UHC-54061-64•••-••-60369374545520N/A9097 Elm StreetAustinTX78738—NULL··
ENRENR-1090262026-06-14T21:50:47ZBrianJTaylor1941-09-09UHC-39486-76•••-••-9406287.278.4657BRIAN.TAYLOR@ICLOUD.COM3111 MESA DRIVEColumbusOH43207GRP-5834·OPTIONS-PPO
CLM CLM-4057872026-06-21T16:04:57ZFrnaces—Stone1984-07-14null•••-••-2846——206 Sage CtPlanoTX75059—NULL
CLMCLM-4203312026-02-23T22:39:07ZKyleH.Smith1984-10-21UHC-47052-61UNKNOWN—-2161 Jefferson AvenueORLANDOFL32827-8205—null
CLMCLM-4231542026-07-27T18:04:28Z Matthew—Ferguson03/20/95UHC6612548NULL—NULL1582 CAMELBACK ROADHoustonTX77086GRP-6252navigate-hmo
ENRENR-1051672026-10-08T04:00:35ZPhilipFPrice1999-11-07UHC-90654-46•••-••-0639+1 554 834 2963PHILIP.PRICE@YAHOO.COM1953 HILLCREST ROADGILBERT·AZ85296GRP-4964MEDICARE-ADV-B
PRVPRV-245062026-07-09T05:40:05ZAmanda—Gomez2008-04-23UHC-45484-57—(842) 311-3025UNKNOWNNULL—N/A———
PRVPRV-295622026-07-16T14:58:15Zmary—mccoy··19-02-2002UHC-45825-03··UNKNOWN755-393-6940UNKNOWN52 HARBOR BOULEVARDPHOENIXAZ85079——
ENRENR-1074962026-03-22T00:50:46ZAnn—Pierce1953-08-08UHC-55298-56•••-••-7943387-864-9646ANN.PIERCE@ICLOUD.COM6418 Main StreetColumbusOH43287GRP-2860··CORE-HMO
CLMCLM-4275012026-09-20T19:48:29ZYUKI—BURTON2001-06-17··UHC-06392-96•••-••-2105-null——NULL··N/AGRP-7668····
CLMCLM-4245392026-05-21T09:29:20ZDeborah—Fernandez··1954-02-16UHC-57733-64NULL574-907-1306UNKNOWN——null——MEDICARE-ADV-A
ENR ENR-1297222026-03-02T06:34:43ZRichardO.SantiagoMay 9, 1986UHC-26774-18•••-••-983016607451570N/A9782 Bayshore DriveAUSTINTX78722GRP-3077MEDICARE-ADV-A
CLMCLM-4001362026-03-21T12:22:11ZGLORIATWALSH1941-06-11UHC-92335-10N/A8487982440—7387 Elm StreetChandlerAZ85204GRP-9171NULL
TPATPA-641552026-04-15T07:58:56ZcoxI.edward9174-10-04N/A—913.648.9708NULL3714 Meadow LaneTUCSONAZ85712GRP-0403·MEDICARE-ADV-B
TPA TPA-582822026-08-08T23:53:47ZCatherine··Smith1969-04-03·UHC-24248-33-—·nullN/ANULL—nullGRP-4431OPTIONS-PPO
ENRENR-1291192026-06-06T05:33:30ZShirleyOThomas1948-01-12UHC-72311-42•••-••-0727·UNKNOWNshirley.thomas60@gmail.com·9291 Mountain View Dr·MiamiFL33127GRP-6211MEDICARE-ADV-A
CLMCLM-4279632026-08-23T19:12:52ZJEFFREYB.HUNTER07/13/74·UHC-42787-34——null3234 SAGE COURTSan DiegoCA92176GRP-5522CORE-HMO
ENRENR-1302192026-08-25T04:22:58ZVIRRGINIAFPADLILA1973-02-07UHC-44228-34•••-••-5920950-954-0358virginia.padilla37@hotmail.com1491 Highland AveSacramentoCA95806-6193·GRP-6821MEDICARE-ADV-A
ENRENR-1315202026-03-17T06:33:07ZJudyWWatkins1973-04-08UHC-12017-24•••-••-55077947686283judy.watkins42@icloud.com5633 Market StreetColumbusOH43270-5700GRP-8024MEDICARE-ADV-A
TPATPA-565012026-09-15T07:42:49ZJUAN··—LOPEZ10/05/68UHC-13601-93—(279) 576-3102N/A8639 Highland AveColumbusOH43244NULLMEDICARE-ADV-A
CLM CLM-4021962026-02-17T15:06:59ZSusan—Morris1958-03-10N/A•••-••-9792(800) 294-3029—6814 Baseline RoadJacksonvilleFL32291-9457GRP-8977UNKNOWN
TPATPA-628742026-07-20T07:44:46ZSTEVEN—HENDERSON··19950516··-——····3009 River RoadSan AntonioTX78260N/A—
PRVPRV-282882026-06-10T08:32:31ZLAURA—THOMAS1940-04-21UHC6347740N/A810-480-4448—2534 CENTRAL AVENUEColumbusOH43227··—null
100,000 rows, page 240 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.742Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty