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-1088172026-02-04T09:43:29ZDOT—BURTON16-04-1977UHC-38127-12•••-••-6674·591-961-4445DOROTHY.BURTON@HOTMAIL.COM4833 Maple AvenueSeattleWA98168GRP-2342CHOICE-PLUS-PPO
CLM CLM-4006302026-06-12T09:03:41ZAlex—Thompson1999-03-02UHC-81966-47-——8452 CENTRAL AVENUEEden PrairieMN55317·GRP-5349SELECT-EPO
ENRENR-1157582026-08-10T04:03:34ZBrianJHoffmanJun 22, 1965UHC-35000-43··•••-••-5276582-811-4541brian.hoffman@aol.com3389 Baseline RdGilbertAZ·85245GRP-5665MEDICARE-ADV-B··
TPATPA-596502026-03-13T14:54:01ZDonald—Griffin··1954-05-14NULL—(337) 276-0907NULL··3360 Mountain View DriveAustinTX78704—-
ENRENR-1359672026-03-27T01:35:06ZERIC—LI··12/19/44UHC-57535-49•••-••-8112706.361.9511eric.li@hotmail.com7760 Union StreetJacksonvillefl··32249GRP-7904CORE-HMO
ENRENR-1331182026-09-12T14:30:00ZJeffrey··—Pena19410126null•••-••-54175476372732jeffrey.pena@gmail.com9350 Grand AveAustinTX78771GRP-4908CORE-HMO
ENRENR-1336702026-10-09T00:00:25ZLi—James2003-12-03UHC-11038-16•••-••-7505·594.942.0539UNKNOWN823 BAYSHORE DRHoustonTX77063GRP-7745MEDICARE-ADV-B
ENRENR-1238812026-04-10T18:45:05ZDorothy—Bailey04/04/64UHC-42273-50N/A—DOROTHY.BAILEY@AOL.COM9406 Church StPLANOTX75011GRP-4667SELECT-EPO
CLMCLM-4325602026-09-16T00:27:59ZAmanda—Bennett1/8/2004nullUNKNOWN·482-762-9839N/A6065 Union StColumbusOhio43251GRP-7664NAVIGATE-HMO
ENRENR-1264612026-06-15T07:42:07ZJanet····Harris10/06/98UHC-03351-82•••-••-2795—JANET.HARRIS@YAHOO.COM1529 Highland Avenue Apt 31TEMPEArizona85248GRP-0841·SELECT-EPO
ENRENR-1271222026-05-29T03:22:42ZMARCUSPSIMS2001-04-04UHC5425006•••-••-912719367211415··-·9274 Canyon RdMiamiFL33180GRP-9313MEDICARE-ADV-A
ENRENR-1231472026-05-31T22:44:14Z·JoyceC.Jenkins1994-12-27UHC-89318-82•••-••-0266+1 498 539 6573JOYCE.JENKINS@AOL.COM5673 Lincoln WayCharlotte·NC28235GRP-3433CORE-HMO
ENRENR-1007152026-07-21T05:34:57ZGeorgeINichols1992-08-10UHC-59529-24•••-••-1319559.596.0203··——-UNKNOWN—GRP-8811SELECT-EPO
PRVPRV-295842026-01-11T00:37:03ZDOROTHY—·MURRAY1977-09-16UHC-85837-03··nullUNKNOWN3760 Union StMiamiFL33195-—
CLMCLM-4098032026-10-01T18:52:28ZBETTY—MARTINEZ1996-03-10UHC1662119UNKNOWN732.493.0602N/A5975 Lake View RdJacksonvilleFL32274N/AOPTIONS-PPO
TPATPA-608732026-09-20T15:48:21ZElijah··—Webb1981-09-03null•••-••-0444————NULLNULLnullnull
CLMCLM-4324192026-04-20T18:35:25ZBarbara—Nichols1953-03-05-·NULL(907) 730-0078UNKNOWN8658 Mountain View DrMiamiFL33174GRP-0914-
ENR ENR-1425142026-02-13T12:18:02ZOrtega, NicoleK··—2003-03-20UHC-23371-21•••-••-1956830.503.7171nicole.ortega@aol.com2244 Maple Ave Apt 38FresnoCA93756GRP-9415SELECT-EPO
CLMCLM-4141552026-04-18T03:44:11ZBennett, DanielG—08/12/08null——·null—NULL··—UNKNOWNGRP-0753··-
ENRENR-1004812026-08-02T10:27:33ZBRUCE—HENRY02/18/2001UHC5968425•••-••-3731·9738491510N/A5877 Indian School RoadPlanoTX—GRP-9329MEDICARE-ADV-B
CLMCLM-4244692026-07-02T23:32:49ZWagner, Tyler—··1977-08-17UHC-29723-33•••-••-9390N/AN/A8116 Willow Ct··San AntonioTX78239·GRP-4611-
TPATPA-594832026-06-18T14:33:17ZTyler—Maldonado7/12/1948UNKNOWN•••-••-2521416-807-8675NULL7191 Mesa DrMinneapolisMN55480-CORE-HMO
CLMCLM-4272932026-04-02T05:14:57ZChristineRValdez1960-02-08UHC9561179null··8623587484———N/AUNKNOWNGRP-8401MEDICARE-ADV-A
ENRENR-1427842026-06-29T14:59:13ZJonathanL.Palmer1939-08-17UHC-36084-68•••-••-5392(693) 636-2100JONATHAN.PALMER34@AOL.COM7226 Market St Apt 24San DiegoCA··92160GRP-0651options-ppo
ENRENR-1260332026-06-15T23:02:11ZHannah—Chapman1953-05-01UHC-60650-87•••-••-6864683-961-3751HANNAH.CHAPMAN@GMAIL.COM6342 DESERT SKY BLVDPhoenixAZ85020GRP-3511MEDICARE-ADV-A
TPATPA-573652026-03-18T06:55:01ZRobert—Vargas1940-08-18——NULLUNKNOWNNULLNULL—-N/ASELECT-EPO
CLMCLM-4257502026-09-08T07:39:02ZSara—Robertson·04/12/1962UHC-65179-24•••-••-6258——·910 Forest AvePhoenixAZ85005GRP-3237NAVIGATE-HMO
PRVPRV-210842026-09-02T03:01:26Z·camila—walsh1956-04-22—····8404672·camila.walsh53@aol.com238 MARKET STREETMiamiFL33187-null
ENRENR-1208652026-10-10T05:27:00Z Camila—Beell5/5/1985UHC-78947-90•••-••-2603555-932-9342camila.bell62@aol.com4514 River RoadDallasTX75296GRP-6822·MEDICARE-ADV-B
ENRENR-1428722026-09-12T20:38:08ZMEIWMCCOY··1950-51-23UHC-65566-67•••-••-6195·+1 736 922 6577MEI.MCCOY69@ICLOUD.COM599 LINCOLN WAYGILBERTAZ85262GRP-4216SELECT-EPO
TPATPA-623222026-09-19T18:36:46ZMary—HerrearMar 20, 1973UHC-96852-32•••-••-6708NULLN/A7943 Palm DrHoustonTX·77040GRP-9075OPTIONS-PPO
ENRENR-1152472026-02-20T15:31:51ZNCOLE—·ORTIZ2004-08-17UHC-89420-73-(652) 570-7373nicole.ortiz23@proton.me8000 Harbor BlvdGlendaleAZ85328GRP-2170MEDICARE-ADV-A··
ENRENR-1008092026-01-10T13:15:38ZED—WILLIAMSON1960-06-18UHC-60200-80•••-••-7432(905) 750-5634EDWARD.WILLIAMSON@GMAIL.COM4053 Church StreetChandlerAZ·-GRP-2773··MEDICARE-ADV-B
ENRENR-1177882026-06-02T13:04:27ZJacquelineAPadilla19840725UHC-58059-62•••-••-49816917465292jacqueline.padilla@outlook.com8450 Cedar LaneFresnoCA··93782GRP-7679··NAVIGATE-HMO
CLMCLM-4028282026-08-25T07:06:06ZStephanie—MurrraySep 14, 1990UHC-72107-30—-N/A3576 Central AvenueEden PrairieMN55316N/AUNKNOWN
ENRENR-1279752026-07-05T21:36:46Z JonM.Mason1979-10-23UHC-65716-57•••-••-63177702168246jonathan.mason16@gmail.com7737 Desert Sky BlvdEden Prairie··Minnesota55384GRP-9173CORE-HMO
CLMCLM-4294182026-10-14T00:18:12ZDIANAJCLARK·1992-05-04UHC-38721-43•••-••-5754+1 919 569 7883-8490 Lincoln WayLAS VEGASNV89114-6463—·CORE-HMO
PRVPRV-273682026-01-03T02:01:11ZAaron—Lopez·20030410UHC-79349-76—283-200-8018··-2613 Palm DriveFresnoca93785—-
ENRENR-1071242026-08-11T04:00:58ZRoy—Sanders5/13/1990UHC-70646-62•••-••-4507N/Aroy.sanders@gmail.com4371 Oak StSAN DIEGOCA92164GRP-5837MEDICARE-ADV-A
CLMCLM-4177062026-01-24T15:40:50ZBETTY—KNIGHT··1943-04-12—•••-••-8926-null408 River RdChandlerAZ85205GRP-8490UNKNOWN
PRVPRV-214392026-05-06T22:52:13ZKimberly—·Willis1954-04-24UHC-79191-29—12274340284-N/Anull-NULLN/A·MEDICARE-ADV-A
TPATPA-501792026-08-22T08:20:40ZJEREMYKYOUNG5/20/2002··N/A•••-••-7061··-6020 JEFFERSON AVE #274ColumbusOH43287-1908—MEDICARE-ADV-A
TPATPA-576772026-09-09T00:04:53ZElijah—Burke26-03-1994UHC-30110-62UNKNOWNNULLelijah.burke72@outlook.com6133 Washington StGILBERTAZnullGRP-6103SELECT-EPO
ENRENR-1126542026-02-19T17:09:40ZDYLAN—JORDAN1949-05-05UHC4166788•••-••-8904(727) 880-6401dylan.jordan89@yahoo.com7294 Harbor BlvdSACRAMENTOCA95880-5625GRP-5205CHOICE-PLUS-PPO
ENRENR-1227582026-09-25T02:25:37ZChavez, RebeccaX.—1986-12-03UHC-60022-24•••-••-48543557102982—6705 Cedar LnMiamiFlorida33175GRP-9984SELECT-EPO
PRVPRV-243322026-09-13T09:16:56ZEugene—Crawford9/21/1980——(889) 495-1061—2129 INDIAN SCHOOL RD #429SCOTTSDALEAZ85202—CORE-HMO
CLMCLM-4181672026-10-08T14:30:40ZAna—Jackson1977-02-23N/A—-UNKNOWN347 Lincoln Way Apt 13·DallasTX75221··NULLCHOICE-PLUS-PPO
ENRENR-1133032026-08-25T16:34:47ZROYF.·GRAY1988-02-74UHC-24777-38•••-••-6657(729) 666-4724roy.gray@aol.com··7049 Cedar LnOrlandoFL32880GRP-1399MEDICARE-ADV-B
CLM CLM-4073712026-06-16T00:08:59ZJEREMY—HARVEY1965-06-25UHC5654603-—NULL3677 Pine DriveHOUSTONTX77046—NULL
ENRENR-1085062026-03-24T08:55:01ZHiroshiPNunez··1976-12-20UHC-91613-92•••-••-8749490-907-2204HIROSHI.NUNEZ50@YAHOO.COM9881 Forest AveGilbertAZ·85215GRP-3528navigate-hmo
100,000 rows, page 123 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.687Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty