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-4128302026-06-22T07:58:16ZDanielle—Jordan12/5/1998UHC-52043-50nullUNKNOWNNULL5513 Market StPhoenixAZ85087GRP-0783—
ENRENR-1202342026-06-18T00:42:06Zpamela··—wilson1942-07-21UHC-01249-68•••-••-8814(967) 834-9119PAMELA.WILSON@AOL.COM·175 CAMELBACK ROADSan AntonioTX78280··GRP-3873··OPTIONS-PPO
ENRENR-1097542026-04-19T11:30:40Zchristopher·X.adams26-06-1956UHC-88794-67•••-••-39373212790christopher.adams@aol.com4764 SPRING STREET·AtlantaGA30333GRP-5259MEDICARE-ADV-B
CLMCLM-402702 2026-05-17T17:43:30ZJUDY—TURNER1957-08-03UHC-54618-59-—N/A5845 Central AvenueDenverColorado··80296··UNKNOWNMEDICARE-ADV-B
TPA TPA-531182026-02-06T13:32:36ZALICE—SENCER··1967-03-01nullNULL——-N/ANULLN/AGRP-1509MEDICARE-ADV-B
CLMCLM-4197922026-09-12T21:59:49ZRonald—Fowler04/05/2001UHC-11532-40N/ANULL-N/ANULL—UNKNOWNGRP-8572SELECT-EPO
CLMCLM-4010072026-04-08T11:15:58Zbeverly—dominguez1963-06-01-•••-••-57599233500104nullNULL—null—GRP-7759NULL
ENRENR-1274002026-02-25T06:06:01ZBaker, Donald··Z.—01/10/1982UHC-82382-16•••-••-01528504186524donald.baker21@aol.com9253 APACHE BOULEVARD #996SeattleWA98135GRP-9731MEDICARE-ADV-B
CLMCLM-4238182026-03-18T09:48:13ZYUKI··JOHNSON1960-07-06·NULL—256-802-8066··null—UNKNOWN—null····
ENRENR-140473 2026-08-02T00:18:54ZPamelaBMorrison1982-10-21·UHC-42829-49NULL493-308-6896—3466 DESERT SKY BLVDColumbusOH43274GRP-0856MEDICARE-ADV-B
ENRENR-129213 2026-01-20T00:20:02ZJeremyD·Richads1952-10-11UHC-56171-40•••-••-6437948.784.9432UNKNOWN2676 Highland AveTempeAZ85293GRP-7837MEDICARE-ADV-A
CLM CLM-4304212026-07-25T11:32:55ZDENNIS—NELSON19920902N/A•••-••-1692NULL—8076 VALLEY VIEW DRIVEScottsdaleAZ··85218GRP-1540CORE-HMO
ENRENR-1060542026-09-12T23:56:48ZSTEPHANIE····REED02/26/94UHC-72165-55•••-••-160418794793904—7279 BAYSHORE DRIVESeattleWA98103-8014GRP-1330MEDICARE-ADV-A
CLMCLM-4031962026-09-09T02:08:02ZDENNIS—HUNT1993-03-07UHC-89275-42—702-204-7001·UNKNOWN9777 Mountain View DrCOLUMBUSOH43245GRP-7338medicare-adv-b
CLMCLM-4037872026-04-21T09:54:20ZMATEO—MYERSJul 16, 1976uhc-90347-43•••-••-46916369344236—·5802 RIDGE RDGlendaleAZ85308-4677—NAVIGATE-HMO
ENRENR-121280 2026-06-11T02:05:04ZThomasE··Harvey1977-10-25UHC-55914-02•••-••-6366·(967) 229-3694thomas.harvey14@icloud.com6330 CEDAR LANEPlanoTX75096GRP-6065core-hmo
TPATPA-625522026-06-02T06:44:06ZJoyce····Murray04/01/1984——(466) 327-3964N/A3758 Jefferson AveTempeAZ85206-null··
CLMCLM-4221682026-03-18T13:41:01ZVirginia—Hawkins1945-06-12————5939 MARKET STREETSeattleWA··98169-NAVIGATE-HMO
ENRENR-1313022026-06-30T23:40:13Zethan—wood1961-04-06UHC-73564-91—(381) 922-8901ETHAN.WOOD60@AOL.COM··5108 LINCOLN WAYNashvilleTNnullGRP-3279CHOICE-PLUS-PPO
ENRENR-1278102026-08-12T13:41:01Zalice··Agonzalez1968-02-14UHC-10661-45•••-••-4801(910) 824-8546alice.gonzalez@gmail.com8376 RIDGE RDSeattle·WA98132·GRP-4208CHOICE-PLUS-PPO
CLMCLM-4159662026-04-05T00:55:45ZJean—Yang1955-02-15UHC-55015-07UNKNOWN·768-308-9428—5899 Main StreetAtlantaGeorgia30303-3253GRP-0120SELECT-EPO
CLMCLM-4064172026-03-30T01:06:00ZHeather—Singh1984-01-09UHC-61064-10•••-••-31064244339075UNKNOWN6811 Elm StreetPlanoTX75098··nullCHOICE-PLUS-PPO
ENRENR-1318922026-10-08T05:04:42ZAmyIParker1963-04-23UHC-88714-34•••-••-0161(339) 401-0900—9756 Lincoln WayLos AngelesCA90067-4590·GRP-4891OPTIONS-PPO
CLMCLM-4130382026-03-01T19:06:49ZJESICA—SNYDERJul 6, 1964UHC-92417-51-209.537.1111·UNKNOWN7170 Desert Sky BlvdSacramentoCA95866—select-epo
ENRENR-1110772026-03-13T03:20:42ZClark, LoganJ—1938-12-28UHC-88925-67•••-••-4218·521-738-8404logan.clark@gmail.com217 Elm StreetGilbertAZ85265-7262GRP-2639MEDICARE-ADV-A
TPATPA-571772026-01-10T01:54:07ZWilliamSCarpenter1954-02-11nullnullN/AN/A2934 APACHE BLVDDenverCON/AN/A·NULL
CLMCLM-4113832026-06-10T07:21:24ZVazquez, Brandon——1956-10-03·UHC2270162•••-••-1986-brandon.vazquez@icloud.com·2328 Elm StAustinTexas78789GRP-4945NULL
PRVPRV-236592026-03-21T21:31:55ZBRENDA—HENRY05-01-2004N/A—·699-812-6106brenda.henry45@gmail.com2034 CEDAR LANE Apt 18CHANDLERAZNULL-null
TPATPA-573362026-05-27T18:33:20ZVALENTINAYJOHNSON1952-12-16—-—-9880 Canyon Rd···San DiegoCA92191GRP-9114—
CLM CLM-4301122026-07-04T22:00:52ZWILLIAME.RAYOct 22, 1943uhc-70885-47•••-••-0490N/A—-UNKNOWN—··GRP-9614UNKNOWN
ENRENR-1247152026-08-01T11:09:04ZPHILIPM.DANIELS1954-01-19UHC-38699-45•••-••-0744248.522.7287PHILIP.DANIELS@GMAIL.COM6156 UNION STSacramentoCA95885GRP-6236MEDICARE-ADV-A
ENRENR-1423132026-09-28T04:25:37Z·PRIYAU··BURKE19750215UHC-37641-26•••-••-9131956-665-9500PRIYA.BURKE50@AOL.COM1398 Ridge RoadChandlerAZ—GRP-9306SELECT-EPO
ENRENR-1198192026-01-11T00:58:25Zalbert—·tran2004-12-08NULL—741-842-7978albert.tran@hotmail.com2632 CEDAR LN #907··AustinTX78779GRP-4529CHOICE-PLUS-PPO
ENRENR-1335972026-03-12T13:33:59ZPriyaA.···Sims1966-12-18UHC-97920-34•••-••-6190880-390-2513·priya.sims18@yahoo.com9306 JEFFERSON AVEAustinTX78761GRP-5033CORE-HMO··
ENRENR-1095962026-09-26T22:01:39ZVirginiaWWeber19730404UHC1063506•••-••-6321-virginia.weber1@hotmail.com2954 Oak StreetColumbusOH43204GRP-2307OPTIONS-PPO
ENRENR-1180962026-05-28T21:10:15ZKathryn—Hart1950-12-82UHC8738434•••-••-0556(706) 600-7087kathryn.hart@hotmail.com1571 MAIN STREETScottsdaleAZ85287GRP-3678MEDICARE-ADV-A
ENRENR-1052642026-04-14T03:38:23ZGEORGE—HOFFMAN1962-10-01uhc-52151-87•••-••-3591(559) 311-7743GEORGE.HOFFMAN53@OUTLOOK.COM1238 Palm DrHOUSTONTX77012GRP-8825SELECT-EPO
TPATPA-616062026-02-20T19:01:50ZCAMILA····CHEN1977-01-12uhc-66437-32null··416-684-0302·camila.chen38@aol.com130 Harbor Boulevard Apt 23GlendaleAZ85327GRP-4766—
CLMCLM-4073942026-04-18T17:06:54ZMadson—Morneo1/4/1969-•••-••-7960578-963-1746NULL4876 BroadwayLAS VEGASNV89140UNKNOWNNULL
PRVPRV-219922026-06-09T03:26:50ZZachary—PalmerFeb 28, 1947··UHC-29115-60—NULL-5230 Apache BlvdDallasTX75225N/A—
ENRENR-1010512026-08-02T09:05:01ZChristinaUMurray·1960-08-14UHC-86579-18•••-••-39403178013932christina.murray@hotmail.com1957 Sunset BoulevardMiamiFL33170GRP-0526MEDICARE-ADV-A
CLMCLM-4154272026-02-28T21:36:16ZWalker, CherylQ.—1944-07-15UHC-28401-80•••-••-2587(736) 208-1269NULL7688 Valley View DrSan AntonioTX78256—-
CLMCLM-4245062026-01-08T05:48:54ZJOEY—OWENS1949-05-26UHC-88512-73•••-••-23339951077-nullnull—nullnullOPTIONS-PPO
CLMCLM-4138902026-05-23T22:37:27Z Tony—Davis1950-09-01··——+1 515 697 4317NULL6352 Bayshore DrGILBERTaz85292·GRP-8219UNKNOWN
CLMCLM-4102312026-08-09T08:57:35ZPalY.Bryant1941-11-16-—12903752486null—UNKNOWNnull—GRP-8039—
TPATPA-563522026-05-18T06:34:27ZDouglas—Mendez··12/11/47UHC-96845-13N/A—N/A··5921 Washington StMiamiFlorida33188-3109GRP-9992NULL
ENRENR-1220382026-01-27T11:37:29ZKimberly—Morrison1978-02-03··UHC-53270-68•••-••-74427077390896—·5491 WILLOW CTPlanoTX75030GRP-9407choice-plus-ppo
PRVPRV-210332026-08-27T06:08:38ZSarahM.Alvarado··4/16/1963NULLnull209-558-1648-6407 GRAND AVENUEOrlandoFL32893—·UNKNOWN
ENRENR-1398062026-09-14T19:58:32ZOmarIDaniels1928-04-27UHC-69239-50•••-••-0036368-632-9394omar.daniels@aol.com5275 Park PlGILBERTAZ85219GRP-5773NAVIGATE-HMO
PRVPRV-240312026-07-27T21:29:30ZRamos, GraceI—1991-08-09UHC-74116-69null(793) 324-5860N/A683 HILLCREST RDCharlotteNC28231·UNKNOWN—
100,000 rows, page 129 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.690Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty