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-1020742026-10-17T01:36:36ZLISA—STEWART19470124UHC-45005-81•••-••-7750(203) 253-7680lisa.stewart@gmail.com1205 APACHE BLVDMinneapolisMN55427-3983GRP-9572MEDICARE-ADV-A
CLMCLM-4038632026-04-04T13:25:15Z Arjun—Vargas··20060309UHC-30971-89•••-••-3011nullarjun.vargas@yahoo.comnullnullnull-GRP-2648UNKNOWN··
ENRENR-1128522026-06-09T02:30:23Z Le, Christopher·X··1978-05-01UHC-08988-75•••-••-094615232402971christopher.le@gmail.com5276 MESA DRLos AngelesCA90055GRP-4576SELECT-EPO
ENRENR-1342772026-10-05T06:55:59ZJeremyE.Watkins1971-01-23UHC-96761-53•••-••-6900766-944-3001jeremy.watkins@outlook.com9745 JEFFERSON AVEScottsdaleAZ85234-5048GRP-4947NAVIGATE-HMO··
ENRENR-1372832026-03-09T23:40:11ZDennis—Morales··1978-12-26UHC5252309•••-••-6920+1 664 646 6107DENNIS.MORALES99@OUTLOOK.COM9796 Highland AveDallasTX75261GRP-3113OPTIONS-PPO
CLMCLM-4004982026-10-17T18:28:21ZShaw, Mariana——19520214UHC-69035-21•••-••-6074576-555-0410MARIANA.SHAW@AOL.COM1064 Oak StreetDenverCO80287——
ENRENR-1165072026-09-02T07:03:48ZDebra······Powell1945-02-07·UHC-90874-75•••-••-4365(794) 810-1299debra.powell13@aol.com4358 Forest AveTAMPAFL33622-5145GRP-7169CORE-HMO
PRVPRV-212002026-07-13T13:04:54ZJULIA—HUNT1965-02-23—•••-••-6102UNKNOWNnull9025 Cedar LnSeattle·WA98161UNKNOWN··—
ENRENR-1009562026-08-18T02:32:12ZStephen—Mrphy10/14/1955uhc-00291-43•••-••-2125(683) 720-2601NULL9309 RIDGE RDNashville·TN37202GRP-2782OPTIONS-PPO
ENRENR-1255572026-03-28T01:14:43ZEdward··—Ward1954-05-07UHC3055603—257.501.3625—3932 Canyon RoadSacramentoCA95831GRP-4139SELECT-EPO
CLMCLM-402355 2026-01-19T07:56:37Z———May 10, 2006UHC-93207-47•••-••-6663NULL——UNKNOWN··-—GRP-7474—
CLMCLM-4253972026-10-09T15:19:21Zomar—castro12/7/1951UNKNOWNnullN/A—7219 Oak StMiamiFL33180-0126GRP-0442select-epo
CLMCLM-4258132026-10-16T06:18:17Z·Jean—Day1943-03-26UHC-32810-59-(218) 634-8777NULL7726 Church StDenverColorado80220GRP-5709choice-plus-ppo··
CLMCLM-4224882026-05-09T10:02:37ZPAUL—VAZQUEZ1995-01-08UHC-55634-10UNKNOWN(978) 262-0349—4886 Lake View RoadPlanoTexas75085GRP-4431MEDICARE-ADV-B
CLMCLM-4206742026-05-16T04:28:32ZMARY—WEBER1964-12-04UHC-98691-21-(694) 940-1767mary.weber@gmail.com8305 Ocean AveGlendaleAZ85301GRP-0323CORE-HMO
CLMCLM-4238802026-04-16T12:27:32ZDiane··Austin11/21/1955UHC-03189-68null864.444.6894N/A2127 Maple AveEden PrairieMN55302GRP-2775NAVIGATE-HMO
ENRENR-1061912026-07-20T14:13:15ZHarold—Montgomrey1991-04-16UHC-70008-95•••-••-80735556509492··HAROLD.MONTGOMERY@OUTLOOK.COM8521 River RdDenver··CO80269··GRP-6253NAVIGATE-HMO
ENRENR-1261202026-06-08T07:55:34ZMei Y··—WhiteAug 20, 1958UHC-19755-67•••-••-8968-MEI.WHITE@YAHOO.COM3997 CENTRAL AVENUE Apt 39··Eden PrairieMN55329GRP-3099OPTIONS-PPO
ENRENR-1179232026-10-14T15:30:10ZMaryF.Marquez2010-19-81UHC-65462-14•••-••-7903—mary.marquez42@outlook.com9126 UNION STAtlantaGAN/AGRP-9944CHOICE-PLUS-PPO
PRVPRV-235682026-10-04T07:33:58ZHaroldU.Rogers2005-10-51UHC-54307-35·UNKNOWN466-651-8737harold.rogers@proton.me955 LAKE VIEW ROADEden PrairieMN55301-null
TPATPA-609582026-09-10T03:18:05ZJUDITH—MARTINEZ1993-09-16-NULL660-829-4651N/A—UNKNOWNUNKNOWN—GRP-4866—
CLMCLM-4213862026-01-16T01:16:37Z Diane—Nguyen03/10/1961null—(709) 335-2459N/AUNKNOWN—·nullN/AGRP-4909OPTIONS-PPO
ENRENR-1284992026-05-30T00:49:33Z Allen, Henry——1971-08-01UHC-76663-03•••-••-70147768212HENRY.ALLEN@GMAIL.COM8503 Pine Dr··ColumbusOH—GRP-8478··SELECT-EPO
TPATPA-575662026-03-01T10:18:26ZphilipC.··ross1944-12-11—-3545478928UNKNOWN3455 Park PlaceTucsonAZ85773····
CLMCLM-4202572026-07-14T05:10:39Z·joe—olson1986-02-15UHC-47916-67N/A—N/A8847 Market StScottsdaleAZ85245GRP-6373OPTIONS-PPO
PRVPRV-216122026-09-06T15:33:31ZGabrielP.Salazar02/04/43—NULL2378144343····null-null··null—N/A
CLMCLM-4159812026-05-17T19:23:47ZCHRIS—HARVEY·03/09/97UHC-40603-08•••-••-0673379.326.1896N/A····—N/A—GRP-2866N/A
ENR ENR-1172442026-03-12T04:31:21ZSTEVEN—KELLY1988-03-01UHC-47460-74•••-••-6785313-802-1811steven.kelly@outlook.com1297 SPRING STScottsdaleAZ85209··GRP-4872CHOICE-PLUS-PPO
ENRENR-1166672026-06-11T18:46:00ZDennisMWalsh1974-02-22UHC-09808-11•••-••-7501—·DENNIS.WALSH37@GMAIL.COM7890 Desert Sky BlvdMinneapolisMN55425GRP-2404·CHOICE-PLUS-PPO
PRVPRV-261332026-01-21T10:56:48ZPamela·XRodriguezNov 7, 1996··UHC6391360—461.680.4801pamela.rodriguez35@proton.me1749 Hillcrest RoadFresnoCA93795nullUNKNOWN
PRVPRV-260552026-01-18T07:52:17Zgloria—tran19450504——5176778499—403 LAKE VIEW ROADTampaFL33674—-
ENRENR-1415852026-04-01T20:15:32ZDrewQMarshall·-UHC9534043-(744) 308-6912andrew.marshall@outlook.com6828 Meadow LnSan DiegoCA92120GRP-5809SELECT-EPO
ENRENR-1185442026-04-17T14:06:16ZMARIANLITTLE08/17/1995UHC6563058•••-••-339917919203011MARIA.LITTLE@GMAIL.COM8543 Ridge Road···CharlotteNC28284GRP-1184NAVIGATE-HMO
CLMCLM-4154062026-08-09T00:07:08ZMichelle—Wong10/18/1959UHC-75999-90•••-••-3742+1 475 201 9065NULL1501 Indian School Rd #627JacksonvilleFL·32250GRP-0894·SELECT-EPO
ENR ENR-1281282026-06-28T21:14:01ZBETTY—·COOPER2000-08-23UHC-83087-08N/A(849) 867-2884betty.cooper70@aol.com2201 BROADWAY Apt 29Miami·FL33145GRP-2363CHOICE-PLUS-PPO
PRVPRV-250372026-02-04T18:47:02ZWilliamX.Gonzales1977-08-17·UHC-92544-37—(462) 939-1825—2689 MARKET STREETMINNEAPOLISMN55475nullNULL
CLMCLM-4199742026-02-23T20:07:04ZWeaver, AnnM.—Nov 21, 1980UHC-46632-16—909-239-1968—2201 APACHE BLVDMiamiFL33157-7517—SELECT-EPO
CLM CLM-4151592026-02-23T23:35:17ZEdward—Garcia1942-12-09null•••-••-568414818602544N/A5691 LINCOLN WAYAustinTexas78786GRP-2285CHOICE-PLUS-PPO
ENRENR-1103352026-03-31T10:07:41ZAelxander··Perry25-08-1975UHC-24848-99•••-••-144213988230383—2228 Valley View Dr Apt 6··EDEN PRAIRIEMN55396··GRP-0284MEDICARE-ADV-B
CLMCLM-4169132026-04-13T01:28:15Zraymond—stewart8/23/2008UHC-81012-14•••-••-8664—NULL7962 Hillcrest RoadTampaFL·33618-6186·GRP-4733OPTIONS-PPO
ENRENR-1002072026-10-06T08:48:47ZCHERYL··—MILLER12/23/1961UHC-60441-39•••-••-5436(774) 222-9884cheryl.miller@icloud.com4059 Harbor BoulevardDenverCO··80273GRP-4170·NAVIGATE-HMO
ENRENR-1146142026-08-01T17:39:32Z sandra··—ellys··1980-07-09UHC-93359-09-301-583-7640SANDRA.ELLIS9@HOTMAIL.COM8611 Oak StreetScottsdaleAZ85258GRP-4401MEDICARE-ADV-B
TPATPA-559242026-05-29T19:57:48ZCamlia—Marshall08-01-1940N/A··N/A-UNKNOWN3494 Ridge RdMiamiFL33128GRP-9581-
CLM CLM-4243262026-05-31T13:53:10Z MarcusEMyers08/13/89NULL•••-••-3811·(481) 577-6632nullN/A--UNKNOWNGRP-8793CORE-HMO
ENRENR-1209962026-09-23T05:26:58ZAlexanderEHikks1946-12-18··UNKNOWN·NULL(729) 239-4376alexander.hicks70@proton.me1076 Sunset BoulevardPhoenixAZ85027GRP-9426CHOICE-PLUS-PPO
TPATPA-582282026-10-01T01:39:19ZBurce—Gray1997-05-17—··—NULL3961 BASELINE RDMinneapolis··MN55410GRP-5426NULL
PRVPRV-215852026-07-29T01:33:02ZMARILYN—FISHERApr 16, 1985UNKNOWNUNKNOWN(632) 788-1364marilyn.fisher93@icloud.com··4815 SAGE CTSan AntonioTexas78201--
CLMCLM-4075532026-08-08T15:34:42ZJOSH—TURNER2005-08-27UHC-57288-86UNKNOWN——7345 Cedar Lane #264EDEN PRAIRIEMN55377GRP-0508··CORE-HMO
ENRENR-126282 2026-03-23T01:51:55ZROBERTQ.PRICE04/12/1967UHC-60747-77•••-••-41912549092832-1156 Meadow LaneATLANTAga30313GRP-6023SELECT-EPO
TPATPA-583882026-02-26T14:03:34ZHiroshi—Espinoza09-12-1997NULL—(925) 849-5433null2482 Mesa Dr #998··TEMPEAZ85226GRP-4095SELECT-EPO
100,000 rows, page 157 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.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty