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-4001582026-02-12T00:19:01ZElizabeth··Castro19950522—N/A443-409-7676ELIZABETH.CASTRO@ICLOUD.COM2577 HIGHLAND AVENUEAtlantaGeorgia30314GRP-9959MEDICARE-ADV-B
ENRENR-1165412026-03-18T11:21:57ZSophiaHVazquez11/26/1985UHC-13356-05•••-••-60322132198431sophia.vazquez@proton.me5272 Park PlGlendaleAZ85310GRP-5204CORE-HMO
TPATPA-631032026-10-07T09:53:35ZZachary—Ellis06/07/01nullUNKNOWN——2174 CEDAR LANEGlendaleAZ··85349GRP-1890OPTIONS-PPO
CLMCLM-4312392026-09-01T02:00:00Z Nick—Walsh1996-07-04null•••-••-3189N/A—3420 OAK STREETTempeAZ85261-····
ENRENR-1233922026-01-25T10:54:25ZValentinaQRoss1951-07-23UHC-49963-74•••-••-1816+1 436 492 8002valentina.ross34@yahoo.com2172 Hillcrest RoadCharlotteNC··28209GRP-8953NAVIGATE-HMO
ENRENR-1225082026-04-07T02:22:57ZTylerW.Boyd07/04/75UHC-60519-12•••-••-623615943139002tyler.boyd@aol.com2235 Highland AveLos AngelesCA90092GRP-6253CORE-HMO
ENRENR-1282172026-03-27T22:54:08Z DONALD—STEWART07/06/00UHC-62097-19•••-••-60242256334194—5415 Highland AvenueMinneapolisMN55498·GRP-3969choice-plus-ppo
TPATPA-639342026-08-14T17:30:17ZJESSICA—HILLDec 16, 1990-•••-••-6220nulljessica.hill@outlook.com4977 CHURCH ST··CharlotteNC28254——
CLMCLM-4013222026-05-07T16:29:28ZANTHONY—SIMPSON1952-11-27UHC-67870-89———NULL-··UNKNOWN—NULLOPTIONS-PPO
TPATPA-644292026-03-31T00:41:39ZWells, Patrick—··1969-09-19NULLNULL——8113 Church StreetNashvilleTN37297—-
TPATPA-548712026-07-06T11:29:18ZSullivan, Elijah——1941-04-26——+1 349 599 2944elijah.sullivan66@outlook.com7717 LAKE VIEW RDEden Prairie·MN55373GRP-8028—
CLM CLM-4287542026-09-02T08:48:03ZJOAN—COLEMAN2003-05-25UHC-76680-53—551-424-6119UNKNOWN6592 Willow Court·TAMPAFL33636N/A—
PRVPRV-237712026-10-14T17:23:19ZReid, Kayla—····12-09-2003null····927.725.6579null2115 Market StSacramentoCA95845-8479——
TPATPA-584122026-01-31T03:45:59Z·Elizabeth—Simmons1985-06-17nullUNKNOWN—null9041 Baseline RoadFresnoCA93797——
ENRENR-1246932026-01-21T04:57:49ZStephens, Nicholas··N—1981-02-16··UHC-10068-73•••-••-2364795-402-9162··NICHOLAS.STEPHENS@HOTMAIL.COM··6724 River RdHoustonTX77097GRP-5867CHOICE-PLUS-PPO
ENRENR-1241852026-04-29T06:03:09ZpaulOadams1949-07-24UHC-57445-61•••-••-0110+1 867 640 1545paul.adams@aol.com1547 DESERT SKY BLVD·OrlandoFL32848GRP-9486CHOICE-PLUS-PPO
CLMCLM-4019752026-09-14T02:45:51ZBrittany—Warren2008-09-09UHC2215907—611-730-4680—4501 Park PlAustinTX78721·-UNKNOWN
TPATPA-604792026-03-27T13:43:45ZANDREA—GUZMANMay 15, 1992N/A·null—NULL4778 SAGE COURT #158TUCSONAZN/AGRP-6054-··
PRVPRV-215552026-02-13T09:09:19ZArjun—Bradley1959-04-16UNKNOWNUNKNOWN741.957.3764ARJUN.BRADLEY39@PROTON.ME8435 Bayshore DriveGilbert·Arizona—--
ENRENR-1368342026-07-07T21:39:20ZMARGARETJJORDAN21-06-1966UHC-24141-95•••-••-6034708-791-1723MARGARET.JORDAN@PROTON.ME3038 SAGE CTTempeAZ85286GRP-1378MEDICARE-ADV-B
ENRENR-1081942026-09-22T17:23:18ZIsabellaGHoward03/14/1999UHC-57509-85•••-••-3145733-898-8494isabella.howard@hotmail.com8125 MESA DRIVEEden PrairieMN·55326-5866GRP-5548CORE-HMO
CLMCLM-4193292026-06-01T17:53:01ZAnn—HudsonSep 6, 1947N/AN/A—UNKNOWN·2748 Palm DrEden PrairieMN55320GRP-8152CHOICE-PLUS-PPO
ENRENR-1041862026-03-07T07:43:03ZMeganZPerkinsSep 3, 1985UHC-28097-08•••-••-31499665580892—3220 Camelback RdSeattleWA—GRP-2327MEDICARE-ADV-B
CLMCLM-4024812026-03-17T07:32:51ZAlexander—Gonzales1989-02-09UHC1125710•••-••-5705-alexander.gonzales12@hotmail.comN/AUNKNOWN····—GRP-3802MEDICARE-ADV-A
CLMCLM-4278632026-08-17T19:19:38ZWAYNE····WRIGHT1941-11-15-UNKNOWN—NULL6124 Bayshore DriveTucsonAZ85720-CORE-HMO
ENRENR-1342082026-04-04T04:35:49ZYukiIDaniels3/2/1971··UHC-57335-08•••-••-1091+1 466 384 4831yuki.daniels32@hotmail.com1842 Maple Avenue·CharlotteNC-GRP-1312SELECT-EPO
ENRENR-1401662026-06-11T13:28:20ZJonathan—Thompson··10-02-1997··UHC-39861-05-·567-460-3208UNKNOWN6515 Pine Drive #502JacksonvilleFL32264GRP-4778MEDICARE-ADV-A··
ENRENR-1229662026-06-02T15:13:34Z CHARLOTTE—DUNCANNov 8, 1989UHC-98897-59•••-••-6459·454-918-3873charlotte.duncan@yahoo.com9268 VALLEY VIEW DRColumbusOH··43264GRP-5933OPTIONS-PPO
TPATPA-640522026-05-06T17:17:31ZNATALIE—DANIELS11/18/1951-··—-····1690 Pine DriveEDEN PRAIRIEMN55375GRP-8260SELECT-EPO
CLMCLM-4135882026-01-29T06:16:35ZMelissa—White5/10/2000UNKNOWN--UNKNOWN··UNKNOWN—NULL··NULLGRP-1135NAVIGATE-HMO
ENRENR-1251752026-09-09T08:35:30ZSimpson, Terry——1/10/1955··UHC-34152-23•••-••-45676476193420—292 RIVER ROADCOLUMBUSOH43209·GRP-9183CHOICE-PLUS-PPO
ENR ENR-1209922026-01-28T18:28:56ZFuller, Billy··M—1961-03-05UHC5023264NULL247.398.7039··billy.fuller29@aol.com4442 Ocean AveEDEN PRAIRIE··MN55326-6299GRP-4863SELECT-EPO
ENRENR-1223582026-02-21T19:15:01ZWILLIE—RAY1962-02-03UHC-57120-48•••-••-73023673968182willie.ray41@icloud.com4022 Grand AvenueDenver·CO80234GRP-2967CORE-HMO
ENRENR-1353532026-09-29T22:34:23Z·Elizabeth—VasquezFeb 27, 1976UHC9318018•••-••-8766N/AUNKNOWN2167 Mountain View DriveEden PrairieMN55329GRP-9798··NAVIGATE-HMO
ENRENR-1239842026-03-20T02:55:05ZGERALDRROBERTSON1948-03-12UHC-37731-83•••-••-5577····gerald.robertson@hotmail.com·9743 Canyon RoadScottsdale·AZ·85234GRP-8897CHOICE-PLUS-PPO
ENRENR-1155422026-01-05T18:57:30ZParker, Roy A.——01/16/98UHC-22953-37•••-••-8257·(522) 603-2479roy.parker87@icloud.com5194 Cedar Ln··San DiegoCA92158GRP-1816NAVIGATE-HMO
TPATPA-594502026-01-16T01:28:55ZJESSE—CUNNINGHAM1960-86-09-··813-706-4995—7036 Grand AveTampaFloridaNULL——
CLMCLM-4175662026-01-21T07:13:44Z donald—richardsonJun 11, 2000nullUNKNOWN——3305 Valley View DrTampaFL33682·-CHOICE-PLUS-PPO
ENRENR-1112572026-04-19T19:12:09ZLisa—Rose-UHC-08980-34•••-••-11684196439762UNKNOWN4673 CHURCH STColumbusOH43243GRP-1181CHOICE-PLUS-PPO
CLMCLM-4140502026-03-23T05:58:01ZOMARDNGUYEN·06/08/97UHC-18431-18NULLNULLUNKNOWN5478 Lake View Road Apt 21TampaFL33621GRP-0816CHOICE-PLUS-PPO
TPATPA-502262026-09-02T07:08:23ZSANDRA—WARRENAug 1, 1993·UHC-88298-78•••-••-2841nullnull2427 SPRING STREETSacramentoCA··95864GRP-3820NULL
ENRENR-1126782026-07-05T20:47:33ZVirginiaTRiceDec 26, 1942·UHC-60262-09•••-••-2105UNKNOWNN/A6678 LINCOLN WAYFresnoCA93726-6246GRP-8220NAVIGATE-HMO
ENRENR-1106292026-01-05T10:09:30ZAisha··—Myers··1995-02-19UHC-16370-77•••-••-9814nullAISHA.MYERS55@AOL.COM5623 Sage CourtFRESNO·CA93744GRP-7046core-hmo
TPATPA-60963 2026-06-30T21:13:40ZJESSEN.DUNN1939-01-26-•••-••-38864098322813—7126 Sage CtPhoenixaz85029-4568GRP-6544—
ENRENR-1012332026-09-02T00:30:00ZJOHN—TAYLOR1791-08-28UHC-19378-10•••-••-6348(467) 385-7651john.taylor@proton.me··8613 Washington Street #791ATLANTAGeorgia30374GRP-5259CORE-HMO
ENRENR-1162292026-07-18T09:11:31ZEdward—Coleman·9171-11-17UHC-77392-61—(632) 970-0454edward.coleman@proton.me7471 Washington StDENVERCO·80222GRP-8962MEDICARE-ADV-B
PRV PRV-228492026-01-21T17:46:17ZMASON—WOOD2006-11-17N/A—·3712343111NULL9111 Cedar LnSAN DIEGOCalifornia··NULL—UNKNOWN
PRVPRV-200012026-10-05T10:47:39ZLaura—Alvarado1939-03-06··-—nullN/A4347 CHURCH ST Apt 36PlanoTX75086—·NAVIGATE-HMO
CLMCLM-4006382026-02-27T07:35:06Z Jeremy—Wilson1983-10-25·UHC-59488-37•••-••-8850N/AJEREMY.WILSON@OUTLOOK.COM4960 GRAND AVENUEMiamiFL33138nullOPTIONS-PPO
TPATPA-510912026-07-31T19:25:15ZJazon—·Garza2003-03-24null—····nullN/A——NULL····N/A
100,000 rows, page 228 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