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-1016312026-08-21T13:40:43ZJessica—Weaver1990-02-13UHC-56598-09•••-••-78767916246jessica.weaver@icloud.com5857 HARBOR BLVDChandlerAZ85230GRP-0648MEDICARE-ADV-A
CLMCLM-4203622026-06-13T01:43:09ZDENNIS—COLE01/09/50UHC-96366-62NULL(750) 924-8916-4920 Pine Dr·PhoenixAZUNKNOWNGRP-7823NAVIGATE-HMO
TPATPA-620002026-03-09T16:00:35ZHicks—Amy1960-03-21—•••-••-3007N/A—6886 Palm DrGilbertAZ85277—-
ENRENR-108333 2026-07-18T14:39:03Zsteven—rivera19-04-1957UHC-73623-40•••-••-9344(426) 332-1532steven.rivera86@aol.com5363 Hillcrest RoadLas VegasNV89149GRP-6797SELECT-EPO
TPATPA-579902026-04-25T21:18:27ZEMILY—CHENMar 7, 1949UHC-23290-49—662.385.9741EMILY.CHEN@GMAIL.COM8476 Palm DrGlendaleArizona85381nullCHOICE-PLUS-PPO
ENRENR-1303642026-09-23T01:54:23Z·CAROLYN—EVANS0051-19-80UHC-34615-37•••-••-4150452-239-3819carolyn.evans@outlook.com2666 BroadwayScottsdaleAZ85203GRP-1688CHOICE-PLUS-PPO··
CLMCLM-4224442026-03-25T15:56:18ZAmanda—Alexander1938-02-27UHC-10695-82•••-••-6567(933) 683-2337null··879 SUNSET BLVD Apt 23HoustonTX77027GRP-9538null
CLMCLM-4288602026-10-08T13:49:54ZCarulyn—Sullivan27-04-1960UHC-93054-21N/A·NULL-3287 Washington Street··Tampafl33607GRP-8451—
TPATPA-51399 2026-04-21T14:28:03Z———05-07-1992NULLUNKNOWN(837) 637-2772—3824 Harbor BoulevardJacksonvilleFL32263GRP-4733—
CLMCLM-4096062026-08-22T10:25:08ZCatherine—Mendez2006-03-23UHC-12032-61—448-675-7724N/AN/AN/AUNKNOWN—GRP-5672—
CLMCLM-4036432026-06-16T04:56:48ZElijah····Stephens1961-12-16·UHC-35712-96•••-••-29539421924null6193 Cedar LaneEden PrairieMN55393·GRP-8191—
ENRENR-1350152026-05-28T13:10:55ZCATHERINEGDEAN1945-09-01UHC-42593-03•••-••-5987(287) 347-6345catherine.dean47@icloud.com417 Union StOrlandoFL·32866GRP-7189·CORE-HMO
CLM CLM-4313722026-09-03T07:02:54ZWilliam—Collins1973-01-09—N/AUNKNOWNnullnull———N/AN/A
ENRENR-1151992026-08-10T00:43:16Z Green, Gary——1981-07-19UHC3902135•••-••-1771355-913-8172——UNKNOWNN/A—GRP-4259SELECT-EPO
CLMCLM-4327202026-03-08T19:13:50ZMARCUS—CARTER·12/2/1973UHC-88098-45•••-••-0210(292) 271-9033—2539 Desert Sky BoulevardColumbusOH43272—MEDICARE-ADV-B
ENRENR-1380572026-08-09T01:31:12ZLuisWBlack1993-12-20UHC-95533-43•••-••-9364865-394-1391luis.black@aol.com6457 BroadwayTempeAZ85276GRP-9518CHOICE-PLUS-PPO
ENRENR-1059612026-04-07T18:27:27Z HeatherO.Griffin1987-08-11UHC6065931•••-••-0198(824) 822-9092—8521 PALM DRIVEJacksonvilleFlorida32278-6172GRP-1193SELECT-EPO
ENRENR-1068802026-09-18T18:21:30ZWatkinsMMegan··1997-10-10·UHC-36574-72•••-••-108012086708343megan.watkins39@proton.me2995 Mountain View DrSAN DIEGOCA—GRP-9250MEDICARE-ADV-B
ENRENR-1332652026-08-17T22:34:49ZKATHLEENPRICHARDSON1961-04-10UHC-65298-57N/A(832) 673-4539kathleen.richardson66@proton.me3562 ELM STOrlandoFL32868GRP-6362CHOICE-PLUS-PPO
CLMCLM-4261752026-06-10T19:01:20ZKENNETHR·GARZA1982-07-11UHC-59034-04——UNKNOWN9788 SPRING STREETORLANDOFL32821GRP-6301OPTIONS-PPO
CLMCLM-4248912026-07-22T16:12:00ZBrandonNSmith·1958-10-14UHC-72514-77•••-••-6972-NULL1746 BAYSHORE DRIVEDALLASTXUNKNOWNGRP-6791N/A
PRVPRV-225872026-01-12T22:48:40ZCatherineQMarquez2000-01-20——NULLN/A——··null—·N/A
TPATPA-639742026-04-14T07:34:55ZChristianD.Wells7/26/1946·UNKNOWN•••-••-6984(374) 546-6544N/A·null·null—NULLGRP-2250NULL
CLMCLM-4304222026-04-22T13:33:19ZJacqueline—Mendoza1990-02-14UHC-51173-49null6345392198—6121 Cedar LaneLas VegasNV89110GRP-1741OPTIONS-PPO
PRVPRV-228512026-02-07T06:17:58ZHANNH—·LEWIS·2002-06-28-UNKNOWNnull····236 Church Street··DENVERco80227N/ANULL
ENRENR-1029562026-04-20T20:44:22ZAaron—Chapan06/11/68·UHC-88093-65•••-••-54638024873015·aaron.chapman87@outlook.com7379 Grand AveMINNEAPOLISMN55482··GRP-0900CORE-HMO
CLMCLM-4150792026-08-29T10:16:06ZGARYLMORGAN1956-05-06UHC-94931-37—·-·N/A8136 Oak StJacksonvilleFL32203GRP-1819null
ENRENR-1079502026-09-04T09:33:21ZGERALDV.SANTOS1975-06-28UHC-52170-31—730-882-6264··GERALD.SANTOS22@AOL.COM·3172 BAYSHORE DRScottsdaleAZ85211-5731GRP-7726MEDICARE-ADV-B
TPATPA-530272026-10-13T23:32:37ZGace—Vargas19540526NULL•••-••-7896+1 590 528 9339NULL955 OCEAN AVENUE #337Minneapolis·MN—GRP-4538—
ENRENR-1178312026-03-08T17:55:19ZWalsh, Teresa··H—1949-10-07UHC-14924-54•••-••-31318586571916teresa.walsh7@hotmail.com1450 MEADOW LANELas Vegasnv89156-4242GRP-1653··MEDICARE-ADV-A
ENRENR-1228212026-01-27T16:04:28ZKyle—Sims—UHC-87960-22•••-••-9414723-360-6875kyle.sims42@outlook.com4312 Oak StCharlotteNC··28288-3064GRP-6707MEDICARE-ADV-B
CLMCLM-4153082026-09-16T20:05:01ZPierce, Christine——2000-10-11null—UNKNOWNchristine.pierce97@yahoo.com-nullN/ANULLGRP-0486NULL
ENRENR-1426202026-03-05T12:58:22ZmichaelY.stewart1989-02-11·UHC-09021-38•••-••-95072963423490-·6202 WASHINGTON STREETSan DiegoCA92163GRP-5540MEDICARE-ADV-B
ENRENR-1186342026-03-20T08:39:51ZFrank—·Patel1793-02-25··UHC-94541-33•••-••-1094521.495.8016frank.patel@outlook.com—NULL——GRP-4126MEDICARE-ADV-B
ENRENR-1274552026-06-08T08:59:10ZDEBBIE—WONGMar 7, 1963UHC-84219-67•••-••-8507640.526.9778deborah.wong@yahoo.com·7735 Main StGlendaleAZ85345GRP-1802CHOICE-PLUS-PPO
TPATPA-552552026-05-23T03:47:24ZWILLIAM—DELGADO1946-03-23UHC3316180null14068171785null9138 SUNSET BOULEVARDFresnoCA93734-··CORE-HMO
ENRENR-1164752026-08-03T09:02:04ZEmilyUFord1944-05-25NULLNULL7799506879emily.ford32@hotmail.com8358 Valley View DrMESAAZ85204GRP-4260NAVIGATE-HMO
CLMCLM-4011622026-04-29T15:09:07ZBRENDATBRADLEY1946-05-19null•••-••-5771960-452-3025—7376 Bayshore DrChandlerAZ85281GRP-8746choice-plus-ppo
ENRENR-1284852026-04-01T00:59:26ZISABELLAB.KENNEDY1951-08-10UHC-97057-97•••-••-60424052366527isabella.kennedy@gmail.com2989 RIDGE RDChandleraz85217GRP-9841MEDICARE-ADV-A
CLMCLM-4105332026-07-01T22:09:29ZAHMED—BURKE1958-06-22··UHC-38144-72NULLnull—2720 Spring StMinneapolis···MN55435GRP-3216CORE-HMO
TPATPA-524912026-02-21T06:07:11ZRay—Patel1947-12-18UNKNOWN··•••-••-5174··-5334 Meadow LaneDenverCO80292—UNKNOWN··
ENRENR-1361192026-02-08T15:07:13ZMichaelBRobertson1983-03-07UHC-50054-48•••-••-9834(361) 784-2407michael.robertson41@hotmail.com5167 Valley View DriveDenverCO80232GRP-1763OPTIONS-PPO
CLMCLM-4294582026-10-15T10:07:03ZVictoria—Gray1978-09-01UHC-19111-25-··——580 Sage CtEden Prairie·MN-nullOPTIONS-PPO
ENRENR-1256002026-08-10T14:22:56Zbrenda—lewis1977-10-20UHC-78243-99•••-••-46539142238628·brenda.lewis51@gmail.com4565 CHURCH STREETLas VegasNVnullGRP-8608·CORE-HMO
CLMCLM-4293462026-07-30T22:29:14ZJoyce—Spencer9/14/1967UHC-65674-90—(314) 863-9728··—9339 Oak StreetEden PrairieMN55317GRP-4743SELECT-EPO
CLMCLM-4121112026-03-27T20:33:57ZPatricia—Ford03/04/1988·UHC-44592-27-N/A····nullN/A·UNKNOWNN/AGRP-8568NAVIGATE-HMO
TPATPA-627132026-08-20T04:19:46Zgabriel—sanders2006-05-23··UNKNOWN•••-••-10199645939670—1842 Broadway··JacksonvilleFL32249—N/A
CLMCLM-4163392026-06-14T09:36:23ZjuanHbradleySep 17, 1979UHC-92505-70UNKNOWN—NULL2720 CENTRAL AVE·SAN ANTONIOTX78213——
ENRENR-1144472026-07-08T14:31:24ZJEFFREY Y.··STEWART··1995-03-24UHC-18721-55•••-••-16832069538887jeffrey.stewart@proton.me6049 Grand AveColumbusOH43289·GRP-7650MEDICARE-ADV-B
PRVPRV-211622026-01-08T06:14:34ZFatima—Elliott11/5/1950···UNKNOWN·NULL——5297 INDIAN SCHOOL ROADSan DiegoCA92115UNKNOWN—
100,000 rows, page 255 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.752Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty