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-4004202026-04-27T03:46:11ZJEREMY····YOUNG20020520UHC-98919-85—(778) 588-9325-—UNKNOWNUNKNOWN-GRP-1383—
PRVPRV-216312026-06-07T11:18:23ZHeatherGBlack1983-01-18———N/A3321 WASHINGTON STLos AngelesCA90040—N/A
CLMCLM-4147682026-07-03T04:51:33Zcarlos—·ramos1967-06-09UHC-80608-77•••-••-2750nullN/A2238 Indian School RoadTempeAZ85255GRP-8156NAVIGATE-HMO
CLMCLM-4123792026-07-26T08:19:37ZLauren—Lynch1993-07-24UHC-13897-33N/AN/Alauren.lynch48@outlook.com1657 Ocean AvenueSan AntonioTX78237GRP-4211null··
PRVPRV-29102 2026-05-17T02:38:31ZDOROTHY—SPENCER6/15/1947·NULLN/A4604176622—8114 SAGE CTGilbertAZ85247N/A—
TPATPA-637062026-10-07T19:19:44Z Dunn, Madison····—2008-10-06UNKNOWNN/A878-822-8483—1892 Market StSeattleWA98184··——
ENRENR-1216562026-02-01T17:42:17Zkenneth····montgomery1985-06-02uhc-83340-37•••-••-75324746914631·N/A476 Harbor BoulevardTucsonArizona85704GRP-2284NAVIGATE-HMO··
TPATPA-557082026-01-27T05:55:03ZLUCIA—CLARK1974-07-01·-NULLnull—8782 Highland AvenueCHARLOTTENC·28288GRP-4903—
CLMCLM-4110662026-03-30T14:03:11ZMorgan, Sandra——1939-05-20—•••-••-8518··—1706 Palm DriveDenverCO80287UNKNOWNNAVIGATE-HMO
ENRENR-1429052026-05-21T10:13:16ZRayLBarnes1940-08-09UHC-22306-09•••-••-9398-··raymond.barnes12@yahoo.com5331 River Road Apt 33San Antoniotx78202GRP-0292CHOICE-PLUS-PPO
ENRENR-1065392026-07-08T12:42:54ZKELLYJ.WRIGHTAug 5, 1988UHC6612558•••-••-8805(364) 900-0823UNKNOWN4952 MESA DRSAN ANTONIOTX78282GRP-5393SELECT-EPO
CLMCLM-4033392026-05-21T17:17:48ZPaul····Little11/6/1984UHC-44878-82N/A12127981973-3698 Bayshore DrLos AngelesCA90010-9182NULL—
CLMCLM-4057642026-05-07T19:08:56Zpeter··—mendoza··08/05/59UHC-10519-63—733-648-8244··4978 VALLEY VIEW DRIVEAustinTX—GRP-3606NAVIGATE-HMO
ENRENR-1016992026-01-22T06:24:23ZRobertKWilsonFeb 19, 1960UHC-17370-86•••-••-0680+1 352 382 8856··—8227 Mesa DrEden PrairieMN55387-8695GRP-1420MEDICARE-ADV-A
CLMCLM-4017342026-07-18T17:38:30ZkyleKschultz1975-10-02UNKNOWNNULL—-8865 Baseline RdTempeAZNULLGRP-5102MEDICARE-ADV-B
ENRENR-1189242026-05-29T08:40:54ZSims, MeganB—12/24/54·UHC-08660-21•••-••-755216754320626MEGAN.SIMS54@PROTON.ME3383 Sunset BoulevardOrlandoFlorida32800GRP-3228MEDICARE-ADV-A
CLMCLM-407739 2026-02-06T15:05:11ZZacharyM.Butler1961-12-01UHC-71934-82··UNKNOWN203.532.7700·N/A7442 Central AvenueMiami·FL33140GRP-8487·NAVIGATE-HMO
CLMCLM-4232142026-01-15T22:14:43ZAna—Nunez12/7/2003··N/A—(977) 815-3177—183 Main StOrlandoFL·32840GRP-2441SELECT-EPO
ENRENR-1053752026-10-05T04:33:11ZJenkins, EmilyX—2001-03-17UHC-79681-97•••-••-7498843.649.4979···EMILY.JENKINS@OUTLOOK.COM7216 Canyon RdAUSTINTX78700GRP-6247CHOICE-PLUS-PPO
PRVPRV-279822026-04-11T15:33:45ZBurke, BryanO—15-09-1998UHC-45325-26—742-633-9903—8698 BAYSHORE DR·DallasTX75228····NULL
ENRENR-1245192026-01-31T22:18:16ZSOPHIAY.TRAN··Dec 7, 1957··UHC-25731-70•••-••-94814529664935··null5582 OCEAN AVENUEGlendaleAZ85303GRP-9242MEDICARE-ADV-A
CLMCLM-4291012026-06-12T07:13:54ZBrenda—Phillips06/05/1961UHC-75690-49•••-••-6804UNKNOWN-UNKNOWN—NULL··—GRP-1910OPTIONS-PPO
ENRENR-1064702026-08-05T09:01:13ZEugene—Hudson1988-09-02UHC-10757-21•••-••-6229338-531-1473eugene.hudson@outlook.com2392 BASELINE ROADOrlando··FL·32806GRP-0493MEDICARE-ADV-A
ENRENR-1225422026-08-14T16:55:16ZAngelaTPerkins·1990-37-07UHC-99820-91•••-••-05352482602208ANGELA.PERKINS6@YAHOO.COM7163 OAK STREETSan DiegoCA92125GRP-3628CORE-HMO
ENR ENR-1003302026-04-25T07:20:21ZEMMA—CRUZ1980-09-20UHC-00972-88—447-418-6681—169 Mesa DriveDenverCO80298GRP-2319OPTIONS-PPO
CLM CLM-4098162026-05-29T08:05:24ZHIROSHI—RICE··Sep 4, 1947N/A•••-••-8954+1 653 342 3667NULL··5783 OAK STREET··Jacksonville·Florida32271····MEDICARE-ADV-A
PRVPRV-235702026-05-10T11:10:42ZDEBV.GILBERT9166-05-12UHC-22494-09··NULL(715) 299-7127··5353 Church StreetMinneapolisMN55412——
ENRENR-1046532026-04-03T18:34:01ZJames—Gomez2000-10-26UHC3534643····(503) 525-7999—5032 BroadwayTempeAZ85218GRP-7306CHOICE-PLUS-PPO
ENRENR-1247142026-08-29T00:47:32ZDORIS··Z··POWELL1991-62-12UHC-43897-58•••-••-8290(343) 511-2823—2154 Main StSacramentoCA95825GRP-7955CHOICE-PLUS-PPO
CLMCLM-4216052026-09-20T16:01:19Zsantiago—washington8/2/1994UHC-82320-39····nullNULL—NULLNULLN/AGRP-5146N/A
ENRENR-1423192026-07-14T09:57:33ZJose··—Wallace1983-01-12UHC-92540-81•••-••-7618943-848-8384jose.wallace@outlook.com996 Lincoln WayDenverCO80247GRP-0941MEDICARE-ADV-B
ENRENR-1137602026-04-30T06:32:28ZHernandez, Ronald··W—1959-09-24UHC-70616-98—4314881127—4335 Main StreetLas VegasNV89189-8505GRP-3054OPTIONS-PPO
CLMCLM-4132012026-05-19T16:23:12ZJACQUELINE—LITTLE12/24/87UHC-07892-65•••-••-9457—UNKNOWN··8051 Camelback RoadEden PrairieMN·55303GRP-1164—
TPATPA-572862026-05-10T21:09:57ZAhmedQBlack11/24/1995—null—ahmed.black@proton.me4516 Indian School RdFresnoCA93720GRP-0439UNKNOWN
ENRENR-1381682026-10-09T21:41:58ZAguilar, Austin——1952-06-01UHC-59196-46•••-••-528816584565226austin.aguilar83@icloud.com4106 Hillcrest RdCharlotteNC·28268GRP-8655NAVIGATE-HMO
PRVPRV-269242026-07-19T01:24:59ZBillyAWatkins19901107·UHC-49351-53UNKNOWN·517-284-8724NULL4593 River Rd··Las VegasNV89153-8176—·UNKNOWN
CLMCLM-4258222026-07-17T16:49:00ZHarold····Porter·1942-05-01·UHC0958838•••-••-0802NULLUNKNOWN2658 GRAND AVENUEGlendaleAZ··85372GRP-7148OPTIONS-PPO
ENRENR-1414812026-05-23T22:42:56Z·ethanV.kim1972-01-09UHC-19660-26•••-••-4472436.757.9202ethan.kim@hotmail.com3734 GRAND AVENUEGilbertAZ85213GRP-6412medicare-adv-b
ENRENR-1069212026-05-06T10:11:54ZLaura·W.Davis1997-07-01UHC-05707-46•••-••-0515(986) 361-2157laura.davis78@outlook.com1357 MAPLE AVELOS ANGELESCA90079GRP-9236SELECT-EPO
PRVPRV-208902026-06-17T11:30:47ZchristianTrivera··04/11/00UHC-95771-57null5122835725··2617 Sage CtSeattleWA··NULLN/Anull
CLMCLM-4150122026-02-12T15:59:53Z·Soto, Walter——1956-03-07·UHC2471851•••-••-6714(904) 814-8344NULL-··UNKNOWN—GRP-9253-
CLM CLM-4215522026-05-01T09:17:31Z KEVINP.KING1980-12-17UHC-00010-37N/ANULLkevin.king@yahoo.com7344 Indian School Rd·SACRAMENTOCA95823GRP-2139··MEDICARE-ADV-A
ENRENR-1037222026-08-10T20:56:02ZTimWWatkins07-10-1975UHC8824969•••-••-30358034850839TIMOTHY.WATKINS47@ICLOUD.COM3720 River RdAtlantaGA30310GRP-3287MEDICARE-ADV-A
PRVPRV-280002026-01-04T02:08:13ZSullivan, CharlotteQ—1954-08-24UHC-97098-75N/A9856593353N/A1460 WILLOW CT··AUSTINTX··78770··UNKNOWN·choice-plus-ppo
ENRENR-1300652026-02-20T10:13:41ZMEELISSA—OWENS··3/18/1973UHC-20322-63—732-408-6024····7251 Sunset BlvdSan Antonio··TX78222GRP-3929OPTIONS-PPO
TPATPA-614192026-10-09T04:15:54ZBetty—Bennett1983-07-08—N/A·(778) 503-9119betty.bennett@outlook.com5946 Forest AvenueTEMPEAZ85205GRP-7488-
PRVPRV-209982026-09-28T15:54:28ZGary—Richardson8/3/1954UHC-77929-51—419-899-4903··5154 Mountain View DrEden PrairieMN55336NULL-
ENRENR-1361172026-02-23T08:52:48ZNancy····Alexander8/14/1950UHC-02077-35•••-••-5624423-521-1518nancy.alexander60@outlook.com—N/A—NULLGRP-6355CORE-HMO··
TPATPA-598672026-04-16T23:12:11ZLawrence, Danielle——1983-10-12N/A-(769) 866-3216-9652 Mesa Dr··HOUSTONTX77069··NULL—
PRVPRV-294152026-07-21T20:15:22ZNunez, AlexisT······UNKNOWN—·+1 292 983 2165NULL9582 Grand AveDenverCO80210··N/A··—
100,000 rows, page 90 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.801Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty