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-1165162026-02-12T22:04:50ZTHOMAS—WEBB1966-07-03UHC-04914-27•••-••-0748248-319-6321··5126 Cedar LaneScottsdaleAZ85220GRP-4238·MEDICARE-ADV-A
PRVPRV-240072026-07-02T10:14:03ZRussellJ.Le1978-09-17UNKNOWNnull483-292-6556russell.le@yahoo.com5812 SPRING STAustintx78725NULL—
ENRENR-1217442026-02-02T11:05:45ZvincentWsantosSep 20, 1956UHC-03098-68•••-••-2312692-880-3919vincent.santos72@gmail.com8963 BROADWAYAustinTX78759-8522GRP-1470OPTIONS-PPO
CLMCLM-4066162026-01-23T09:53:00ZDeniseTHenderson19690406UNKNOWN•••-••-1067—denise.henderson@proton.me5931 JEFFERSON AVENUE Apt 30TampaFL33611GRP-3433OPTIONS-PPO
CLMCLM-4212252026-01-11T19:29:29ZJOEN—GONZALESOct 28, 1986UHC-02734-71nullUNKNOWN-4751 Cedar LaneDallasTX75285GRP-3596CORE-HMO
PRVPRV-215392026-01-29T01:57:23ZLAWRENCE—·HAMILTON1949-01-17N/A•••-••-0559·+1 366 226 8827lawrence.hamilton18@proton.me·8701 Sunset BoulevardSACRAMENTOCaliforniaUNKNOWN—-
CLMCLM-4151512026-09-02T22:13:08ZLinda—McDonald··19870312uhc-89393-86-N/Anull4266 BROADWAYMiamiFlorida33192UNKNOWNMEDICARE-ADV-B
CLM CLM-4237582026-10-18T02:02:37Zraymond—washington1968-08-17UHC-78812-89—754-305-9283raymond.washington43@aol.com4238 BROADWAYMESAAZ·85246GRP-1487··
CLMCLM-4314852026-10-05T08:43:58ZPATRICIA—·ROBERTSON1972-02-10UHC-63151-88•••-••-1772834-267-6995-523 Desert Sky BoulevardEDEN PRAIRIEMN55365nullNULL
ENRENR-1173062026-09-18T09:52:04ZROYPSMITH1945-01-07UHC-64287-90•••-••-6799NULL—·5453 MARKET STREETScottsdaleArizona85283GRP-7075CHOICE-PLUS-PPO
CLM CLM-4079992026-06-07T15:44:39ZWaatkins, Jean—····1990-03-21NULL•••-••-8233—NULL5101 Mountain View DrSeattle·WashingtonNULLGRP-4147MEDICARE-ADV-A
ENRENR-1168712026-02-17T18:54:59ZLi, Mei··N—1953-11-28··UHC-98792-36•••-••-2459—mei.li54@yahoo.com9840 Palm DriveJacksonvillefl32255GRP-8290OPTIONS-PPO
PRVPRV-275202026-03-29T10:48:20ZAdnrea—Salazar·9156-08-17N/A•••-••-72056068865263—8269 MESA DRIVEColumbusOH43270UNKNOWN—
ENRENR-1267002026-07-01T12:23:33ZGERALDYGARDNERJun 1, 1952UHC-17504-13•••-••-27073414882720gerald.gardner@proton.me2245 Meadow LaneCharlotteNC28269GRP-2965CORE-HMO
ENRENR-1271522026-06-05T20:58:31ZDanielGCarroll1970-06-20UHC-02920-79··933-810-3677DANIEL.CARROLL79@OUTLOOK.COM6778 ELM STCharlotteNorth Carolina28218-8657GRP-7196CHOICE-PLUS-PPO
ENRENR-1330642026-01-24T03:28:14ZMargaret·IPhillips9/19/2005UHC-64204-80•••-••-3317+1 611 432 8254margaret.phillips@yahoo.com7376 Sage CourtNASHVILLETennessee37207GRP-4659CORE-HMO
ENRENR-1153362026-06-29T11:19:29ZAdam·PAlvarado02/23/41UHC-25176-33-593-899-6010-··-nullUNKNOWN-·GRP-4484·SELECT-EPO
ENRENR-1060392026-04-18T19:41:13ZBradleyZThhomas1941-07-28UHC-73766-30•••-••-27013945141766bradley.thomas21@aol.com6512 Ridge RdGlendaleAZ85322GRP-4080CORE-HMO
PRVPRV-284072026-03-04T07:26:50ZDOUGLAS····KELLY1995-05-25nullnull+1 964 442 4332·-9857 Washington StCharlotte·NC28231N/AN/A
PRV PRV-220162026-03-20T00:15:54ZSpencer, NancyH.—2008-09-06UHC-62462-17UNKNOWN680-376-1098—·NULLnullNULL-—null
CLMCLM-4053002026-05-23T23:03:58ZAustin··Valdez1987-09-12N/A—593-381-6745—1588 Apache BlvdTempeAZ85290GRP-9432-
ENRENR-1403962026-02-10T14:14:24ZBrittany—·Mendez1964-08-09UHC-52889-10•••-••-90683704665917brittany.mendez80@icloud.com6649 PALM DRIVESan DiegoCA92150GRP-5976NAVIGATE-HMO
CLMCLM-424148 2026-09-10T14:06:53ZANGELA—WOODS1978-01-03null•••-••-2477UNKNOWN—-··nullN/A—N/ACHOICE-PLUS-PPO
PRVPRV-20921 2026-05-30T08:26:40ZFATIMA—SCHMIDT08-10-1943UNKNOWNUNKNOWN3442240097fatima.schmidt@aol.com3998 PALM DRDENVER·CONULL—-
CLMCLM-4002702026-10-18T09:20:24Zbrian—gonzalez1967-08-14UHC-11415-22——N/A7198 Mountain View DriveEden PrairieMN55365GRP-9894··SELECT-EPO
TPATPA-638812026-01-20T04:12:30ZCHRISTINA—MALDONADO1968-01-13UHC-10398-30—(641) 550-0800UNKNOWN7835 GRAND AVENUE Apt 31AUSTIN··Texas78763null—
CLMCLM-4226932026-01-09T04:24:06ZRICHARD—SANTIAGO1986-05-09UHC-26774-18—16607451570——NULLNULL—GRP-3077··medicare-adv-a
PRVPRV-226972026-09-16T15:37:04ZArjun—·Mason1976-04-14NULL•••-••-1179·329-413-4279ARJUN.MASON39@GMAIL.COM9507 Meadow LaneLAS VEGASNV89152-NULL
ENRENR-1017962026-03-22T18:08:32ZEmilyXPeterson11/16/1969UHC-84259-62-900.540.0983emily.peterson30@gmail.com5650 Mesa DriveDenverCO-GRP-9233··MEDICARE-ADV-A
ENRENR-1374552026-09-02T00:23:54Zmegan—morgan1997-09-07UHC-81877-49—3702014986··megan.morgan39@gmail.com5484 Ridge RoadAtlantaGA30374GRP-1135CORE-HMO
TPATPA-589012026-03-11T07:42:55ZDiego—Lawrence2005-03-13UHC-68548-08N/A—DIEGO.LAWRENCE91@AOL.COM1001 HILLCREST ROADTempeAZ85203—OPTIONS-PPO
ENRENR-1006342026-09-01T17:09:44ZMeganQPorter1973-10-21UHC6693790NULL(262) 770-2901megan.porter15@proton.me··8071 MAPLE AVENUETucsonAZ85797GRP-8739MEDICARE-ADV-A
CLMCLM-4000282026-08-27T21:35:10ZKathryn—Austin19550327UHC-56978-49•••-••-1319(201) 376-6235UNKNOWN8582 Union StreetTampaFlorida33603-3836-CORE-HMO
TPATPA-500502026-10-11T19:30:18ZDylaan—Reed1950-04-23N/A—540-981-8923N/A5538 PARK PLACEGILBERTAZ85209—NULL
PRVPRV-224792026-03-20T04:08:25ZLOGAN—COX1948-02-15UHC-10803-30NULL-—8242 Valley View Dr·AtlantaGA30314NULL—
PRV PRV-244962026-08-16T22:34:44Zjudy—ortega1997-11-23null—2342283457·N/A2089 Camelback RoadSAN DIEGOCA92136--
CLMCLM-4101332026-03-10T13:55:11ZAndrew—Little1972-07-06····—UNKNOWNN/A3646 Sunset Boulevard #675··TempeAZ85217GRP-8461····
ENRENR-1046942026-05-30T02:47:51ZBellUBenjamin··May 19, 1987UHC-88671-74•••-••-0410(487) 943-7971benjamin.bell94@outlook.com8479 CAMELBACK ROADMinneapolismn55428··GRP-5593NAVIGATE-HMO
TPATPA-502282026-02-20T07:30:32Z heather—hawkins1980-04-27·-•••-••-2045null-9203 Church StEden PrairieMN55316—····
CLMCLM-4078532026-01-10T13:15:42Zcarroll—carolyn1958-08-14NULL··•••-••-5730792.522.8582—3600 PINE DRIVESacramentoCA95890GRP-4978NAVIGATE-HMO
ENRENR-1410362026-08-10T01:42:11ZBenjamin—Banks19750109UHC-28318-64•••-••-6848-benjamin.banks91@aol.com5463 BroadwayPhoenixAZ85080GRP-3970CORE-HMO
TPATPA-583702026-08-19T00:31:56ZLius··—Murphy20-02-1981··UHC0129890··null2797178··LUIS.MURPHY25@AOL.COM299 Sage CtJacksonville··Florida32278nullNAVIGATE-HMO
ENRENR-1296392026-05-02T05:50:23ZSTEPHANIEFDAY05/02/1968UHC-13402-27•••-••-8668576.483.8525STEPHANIE.DAY@OUTLOOK.COM··5173 Highland AveAtlantaGA30361-2007GRP-5563MEDICARE-ADV-B
TPATPA-506112026-09-26T02:24:28ZBanks, ArthurB—1955-09-13—•••-••-4984NULLUNKNOWN5876 BAYSHORE DRSEATTLEWA98111-—
CLMCLM-4115812026-02-03T15:04:35ZSAMUEL—WILLIAMSONAug 28, 1960UHC-39070-93·····+1 853 941 9914·N/A———UNKNOWN——
CLMCLM-4170742026-05-24T01:53:17ZHANNAH—WILLIAMS05-04-1972——6812021493—7890 OAK STREETSAN DIEGOCAUNKNOWNN/ASELECT-EPO
ENRENR-1386972026-05-31T04:09:50ZMaldonado, Cheryl·S—1999-06-11UHC-13415-08•••-••-7463317.427.8811—6974 Hillcrest RdPhoenix·Arizona85037··GRP-8384SELECT-EPO
PRVPRV-29539 2026-05-08T19:13:09Zsaen—peters10/05/2001UNKNOWN—340.415.8757—4637 SAGE CT Apt 5HoustonTX77053·-MEDICARE-ADV-B
TPATPA-564382026-07-03T02:39:57ZJoshua··Ford1972-90-26UNKNOWN-(477) 436-4619—7167 Camelback RoadTampaFL33641——
ENRENR-1132002026-01-29T21:58:57Zteresa··—santos22-12-1959UHC-28319-23•••-••-9469957-635-9236TERESA.SANTOS25@HOTMAIL.COM194 Oak StreetDallasTX75256-3144GRP-2012NAVIGATE-HMO
100,000 rows, page 145 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:36.697Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty