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
ENRENR-1316622026-05-10T13:55:05Z JESSICA—HARTNov 11, 1995UHC-59133-55•••-••-5483419.535.8510·jessica.hart@aol.com3161 Meadow LaneTampaFL33677GRP-8610CHOICE-PLUS-PPO··
ENRENR-1374112026-08-16T07:39:18Z·Stone, ElyjahC—02/20/1948UHC-19400-84•••-••-2379(515) 936-9386—1563 Forest AvePLANOTX75022··GRP-8791SELECT-EPO
ENRENR-1208332026-01-01T14:34:24ZWILLIAM—SCOTT1938-04-20··UHC-86572-89•••-••-5496932-967-0138william.scott42@yahoo.com2049 River RoadDallasTX-GRP-6226MEDICARE-ADV-B
PRVPRV-264232026-01-28T01:17:49ZKahtleenCTran1975-04-20UHC-59783-86—(362) 359-9237KATHLEEN.TRAN84@GMAIL.COM4373 Central AvenueMiamiFL33166NULLnull
ENRENR-1189232026-08-08T13:11:32ZVALENTINAWBROOKS··15-12-1954UHC-68658-61•••-••-8176(801) 520-4532·valentina.brooks@hotmail.com45 HILLCREST ROADMinneapolisMN55434GRP-5531OPTIONS-PPO
CLMCLM-4204462026-09-23T08:13:22ZPatrick—Boyd24-05-1977UHC-93836-29UNKNOWN218.891.3290NULL7545 Mesa DriveMESA·AZ85230GRP-2893—
CLMCLM-4295702026-04-02T07:01:02Z·Matthews, JustinK····2/18/2008UHC-38023-50NULLN/AN/A5546 Maple AveCharlotteNC28255-··navigate-hmo
ENRENR-142406 2026-06-02T01:05:06ZPerkins, DianeP—Mar 17, 1983UHC-00538-27•••-••-356315653158527·DIANE.PERKINS14@ICLOUD.COM4580 Hillcrest RoadGlendaleAZUNKNOWNGRP-3888options-ppo
ENRENR-1395232026-06-23T05:47:35ZGrant, Amanda····—1985-09-24UHC-63557-36•••-••-449315774067108amanda.grant@icloud.com6065 Willow CtJacksonvilleFL32277GRP-0257MEDICARE-ADV-A
PRVPRV-200332026-03-27T06:42:17ZDIANAYRAMOS9179-07-02UHC-92145-59•••-••-76406418418084—-———N/AN/A··
PRVPRV-224512026-07-15T08:22:25Z·Julia—Jensen1958-06-21UHC-89834-38UNKNOWN13894618707JULIA.JENSEN@HOTMAIL.COM8583 Sage CourtFresnoCA93784-8989——
TPATPA-575572026-09-28T22:07:18Z TIMOTHY····WONG0808-19-56UNKNOWN•••-••-0126683.410.9706··N/A3169 Camelback RoadFresnoCA93793nullNULL
TPATPA-526052026-07-13T12:49:56ZANDREA—WASHINGTON1981-01-01—null—NULL912 PALM DRIVECharlotte··NC28285GRP-5022UNKNOWN
CLMCLM-4060062026-01-13T21:25:35ZAdrea—Wood·2008-06-21UHC-17270-65•••-••-7869865.695.2746null2241 Desert Sky BlvdMINNEAPOLISMN55405GRP-0966CHOICE-PLUS-PPO
CLMCLM-4171562026-06-27T23:52:23ZJESSE—DEAN1985-05-24UHC-90899-50———8179 Ridge RdChandlerAZ85206-5782UNKNOWN—
CLMCLM-4089282026-04-23T12:44:27ZPaul—Warren11-02-1988UHC-23202-90•••-••-715716558986393NULL4438 Willow CourtLos AngelesCA90034UNKNOWNMEDICARE-ADV-B
ENRENR-1418572026-04-26T08:57:22ZCYNTHIADLE1946-09-14UHC-82199-46•••-••-1020(928) 590-1949CYNTHIA.LE@PROTON.ME3532 PINE DRIVEChandlerAZ··85275··GRP-7934CHOICE-PLUS-PPO
CLMCLM-4209922026-03-22T23:59:26Zdoris··—gilbert07/11/1945N/A—12979854632UNKNOWN8676 Canyon RdLAS VEGASNevada89190-3559GRP-2508CORE-HMO
ENRENR-115506 2026-04-09T05:21:16ZKnight, Teresa··——10/26/1969null•••-••-41556985405208teresa.knight4@outlook.com9898 Apache BoulevardMESAAZ85208GRP-0124MEDICARE-ADV-B
ENRENR-1119832026-03-30T11:24:03ZDotC.·Ryan1989-05-02·UHC-88157-97•••-••-2701+1 560 643 2005dorothy.ryan@outlook.com7322 Cedar LaneLOS ANGELES·CA90056··GRP-4891CHOICE-PLUS-PPO
CLMCLM-4298882026-04-05T10:16:59ZAlan—Olson1953-01-19—•••-••-7308(403) 224-9395ALAN.OLSON@OUTLOOK.COM9036 Ridge RoadSan AntonioTX78201GRP-4577UNKNOWN
CLMCLM-415225 2026-04-08T21:45:41ZTeresa—Le1961-11-04UHC-37931-16·-2303182685N/A76 Park PlTempeAZ85208GRP-5752MEDICARE-ADV-A
CLMCLM-4300042026-05-17T01:12:54ZYUKI····VASQUEZ19761023··nullNULL(581) 363-5194UNKNOWNUNKNOWNUNKNOWN—NULLGRP-2038OPTIONS-PPO
CLMCLM-4313162026-10-06T06:56:49ZEdwardKBurton10/20/2004UHC-96686-35N/Anull-1763 Palm DrMesa·AZ85244N/AMEDICARE-ADV-B
ENRENR-1360312026-06-10T21:43:14ZLAURENEHOWELL·1955-11-11·UHC-02859-87N/A·+1 716 401 9163lauren.howell@outlook.com5487 Meadow LaneSacramentoCalifornia95899GRP-9068MEDICARE-ADV-A
ENRENR-1167352026-01-17T08:00:22ZJoseP.Bryant1974-02-01·UHC-24385-05•••-••-6460591-976-5784JOSE.BRYANT59@OUTLOOK.COM··7395 Harbor BlvdSan AntonioTX78238GRP-2401CHOICE-PLUS-PPO
ENRENR-1377492026-09-21T05:09:03Z AARONHROJAS1962-10-06UHC-33961-52•••-••-0118+1 788 291 7186aaron.rojas80@yahoo.com2380 Central AvenueAustin·TX78766GRP-4290SELECT-EPO
ENRENR-1047752026-01-22T12:34:46ZJacquelineC.Walssh··4/12/1977UHC-85901-07•••-••-91682560860UNKNOWN9862 Lincoln WayLOS ANGELESCA·90004GRP-9370SELECT-EPO··
TPATPA-51836 2026-03-30T10:17:23ZJANET—ROSS2007-08-11NULL—null-4119 Bayshore DriveCharlotteNC28251GRP-5499N/A
ENRENR-1060262026-01-29T09:56:47ZGrace—Gardner12/10/1961··UHC-54937-30•••-••-139516323031694grace.gardner@icloud.com4389 Mesa DriveEden PrairieMN55324GRP-8120SELECT-EPO
CLMCLM-4232982026-09-23T20:10:55ZNATHAN—TURNER1987-05-06UHC0855762———528 Market StreetGilbertAZ85275GRP-4888CORE-HMO
ENRENR-1028532026-08-19T21:25:13ZHeather—Valdez1966-03-06UHC-93047-86null··711-395-1690heather.valdez88@icloud.com8589 Mountain View DriveTampa··Florida33638GRP-2416·SELECT-EPO
PRVPRV-242732026-09-28T14:53:39ZOlivia—Espinoza1945-12-04N/A·null205-405-4111UNKNOWN··1329 Meadow LnSan DiegoCA92101—NULL
ENRENR-1065242026-06-13T19:08:39ZNicoleXRice··3/17/1995UHC-22461-47—(278) 963-1747nicole.rice7@outlook.com8696 CANYON RDFresnoCA93785·GRP-0719MEDICARE-ADV-B
CLMCLM-4302402026-10-13T18:18:31ZAustin—Robinson1955-04-05UHC-83901-95-2439902597··1519 RIDGE ROADTampaFlorida33661-9642·GRP-6693-
PRVPRV-219102026-08-24T11:09:19ZcarlosLgordon4/28/1983UHC-62783-16—+1 574 515 5263—5917 MAPLE AVENUEPlanoTX75040nullOPTIONS-PPO
ENRENR-1084772026-01-23T05:12:35Zalexander·Hcrawford19981218··UHC-67276-23•••-••-3843N/AALEXANDER.CRAWFORD@AOL.COM8464 WASHINGTON STMinneapolisMN55472GRP-8834CORE-HMO
TPATPA-576272026-09-03T19:04:55ZScott—Gonzales1994-01-25—•••-••-56104427706629-7746 Pine DriveTAMPAFL33642GRP-3992MEDICARE-ADV-A
CLMCLM-405470 2026-04-22T09:03:10ZNATHAN—OBRIEN1939-90-27UHC-35857-33•••-••-0107UNKNOWNN/A9887 APACHE BLVDTempeArizona85200GRP-5221UNKNOWN
ENRENR-1142722026-08-08T21:39:41Zhiroshi—munoz19760614·UHC-47517-65•••-••-42083346043875HIROSHI.MUNOZ@PROTON.ME7710 ELM STTampaFL33620GRP-9924CHOICE-PLUS-PPO
PRVPRV-239882026-09-02T08:54:10ZTheresa—MendezDec 25, 1976——null—7707 River Road #553MIAMIFL—NULLUNKNOWN
CLMCLM-4106102026-10-12T02:03:13ZAustinLPena19730508··uhc-44306-49null569-240-6719N/A5302 Mountain View DrGlendaleAZ85328UNKNOWNN/A
ENRENR-1169682026-01-19T13:27:01ZMARGARET···DUNCAN1950-08-15UHC7835392•••-••-39218348817889margaret.duncan74@gmail.com569 MARKET STREETTampaFL33643GRP-3609SELECT-EPO
CLMCLM-4007942026-09-28T16:30:58ZBRITTANYXESTRADA02/12/67N/A•••-••-145614737247689null—NULL—nullGRP-3927-
CLMCLM-4080362026-09-21T08:08:15Z·CarlosPStewart06/01/96UHC-94711-24•••-••-0629····carlos.stewart56@icloud.com8243 Highland AveMiamiFL33144UNKNOWNnull
CLMCLM-4207012026-08-24T08:40:44ZLAUREN—GUTIERREZ·1942-11-00·UHC-72049-97•••-••-2031nullNULL5474 Indian School RdChandlerAZ85220—MEDICARE-ADV-A
ENRENR-1237722026-05-22T11:35:38Z KennethYMarshall1977-11-20UHC-46864-77•••-••-0344394.219.9966—1786 Willow CtColumbusoh43226-9499GRP-6425MEDICARE-ADV-B
ENRENR-1356502026-07-02T13:05:30Zcarol—murray·1697-04-06UHC-75188-27•••-••-90968755683662carol.murray18@icloud.com91 Spring StEDEN PRAIRIEMN55327GRP-8207MEDICARE-ADV-A
TPATPA-576532026-02-11T20:46:05ZKEITHGFORD1947-04-21——null····6215 Central AvenueORLANDOFL32811-MEDICARE-ADV-A
ENRENR-1062902026-08-13T10:26:38ZARTHUR—GUTIERREZ1986-02-04UHC-23437-15•••-••-4060+1 665 691 9130·arthur.gutierrez18@proton.me6824 Palm DriveEden PrairieMN55397GRP-5850NAVIGATE-HMO
100,000 rows, page 28 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.766Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty