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-1113702026-07-04T19:39:17ZBetty—Le1953-07-25UHC-26618-68•••-••-7426607-747-3424betty.le@icloud.com9800 Mesa DrHoustonTX77009GRP-0565SELECT-EPO
CLMCLM-4081892026-05-18T19:26:06Z HeatherRFreeman2004-06-07UHC-21700-64•••-••-3197206-687-8379————UNKNOWNN/A—
ENRENR-1258212026-06-01T23:12:27ZFoster, Maria——1999-08-01UHC-34710-65•••-••-219718325077332—2348 Apache BlvdLas VegasNV89105GRP-1438SELECT-EPO
CLMCLM-4046022026-08-26T17:17:27ZRUSSELL··ELLIOTT2002-09-26UHC-72403-52NULL763-516-5615—nullN/A—NULLGRP-0951SELECT-EPO
ENRENR-1419922026-05-25T11:05:12ZGabreil—Hill1971-05-22UHC-71046-40•••-••-695019274713677gabriel.hill96@outlook.com··5941 Pine DrNASHVILLETN37221GRP-3370MEDICARE-ADV-A
CLM CLM-4310432026-05-23T02:51:20ZDorisT.Mendez1997-11-25UHC-89129-89null——4014 HARBOR BOULEVARDMiamiFlorida33178GRP-7243··NAVIGATE-HMO
CLMCLM-4270182026-09-05T16:06:46ZRICHARD F.—JAMES1974-11-02UHC-68219-53NULL685-467-6221—-—nullN/AnullCHOICE-PLUS-PPO
ENRENR-1160132026-07-03T03:33:38ZArjun—Cruz1941-01-12·UHC-83745-64•••-••-8511(280) 922-2156arjun.cruz56@hotmail.com2005 Indian School Road Apt 22DenverCO80240GRP-3790CHOICE-PLUS-PPO
PRVPRV-286712026-06-29T20:16:37ZKEVIN··—PATEL11/19/1986—UNKNOWN·380.359.8482kevin.patel@proton.me6854 PARK PLACESeattlewa98140UNKNOWNNULL
PRVPRV-278032026-02-27T02:48:10ZCarlson, Cynthia·D.—07/15/97N/AN/A3745851258NULL4545 Park PlaceChandlerAZ85297NULLN/A
TPATPA-511152026-05-20T22:15:07Z·RUSSELLU.LEE1958-12-22—•••-••-3389513-823-4161null3177 Grand AvenueColumbusOH43244N/A-
TPATPA-586872026-02-18T06:56:03ZISABELLA—·LI1948-04-28NULL•••-••-3607·+1 900 920 9380·NULL802 Ocean AveCharlottenc28270··——
ENRENR-1420102026-05-21T16:24:02ZLISA—KNIGHT··20000802··UHC-55792-79•••-••-68254128534894null2320 PALM DRIVEDallasTX75215GRP-0149OPTIONS-PPO
CLMCLM-4139202026-01-21T17:00:33ZGRACE—RAMMOS09-08-1991UHC-74116-69NULL····N/A683 HILLCREST RDCharlotteNC28231UNKNOWN—
CLMCLM-4115122026-06-12T18:22:03ZJudith—Castillo12-08-1984uhc-17837-26nullNULL··N/A5562 Pine DriveTucsonAZ85793GRP-8952·SELECT-EPO
ENRENR-1216742026-02-17T23:14:23Z AAN C.—SCOTT1949-04-18UHC-37761-03•••-••-56186664792125··alan.scott73@outlook.com7774 Forest AvenueChandlerArizona·85282GRP-4229CHOICE-PLUS-PPO
TPATPA-606312026-02-06T22:26:27Z Aisha—Cruz1972-02-22UHC-68226-65N/A+1 618 827 0355-5583 BAYSHORE DRAustinTX78767——
ENRENR-1190092026-06-09T15:15:18ZWEI—·WASHINGTON1938-12-18··UHC2718289—228-722-9709wei.washington@hotmail.com1983 Central AveJacksonvilleFL·32221GRP-2179NAVIGATE-HMO
CLMCLM-4113612026-06-02T08:37:27ZMarcus—Wong2006-10-05UHC-03574-75null—NULL8541 DESERT SKY BOULEVARDMesa··AZ85278NULLCORE-HMO
CLMCLM-4127362026-08-19T12:57:15ZJeffrey—Carlson1997-09-21UHC-10902-45•••-••-7785(754) 274-2574null6708 Market StFresno·California93724GRP-9476—
PRVPRV-246242026-03-28T08:02:49ZDEBORAH—HAMILTONMar 5, 1963nullNULL834-989-4965····4385 Highland AvenueAustinTX78721——
ENRENR-1155112026-06-11T06:59:16ZJoe—·Young1970-04-15UHC4720294•••-••-3795(493) 676-9926joe.young@gmail.com6460 Grand Ave #673SacramentoCA-GRP-1762medicare-adv-a
CLMCLM-4178432026-04-14T22:05:21Z Dominguez, Walter——03-11-1944UHC6857783-nullN/A7860 PALM DRIVEAtlantaGA30304-7881GRP-8567null
CLMCLM-4063772026-06-16T17:40:18ZMargaret—Lawrence1965-05-19uhc-37511-76—+1 794 744 2603———--GRP-2523MEDICARE-ADV-A
ENRENR-109889 2026-01-17T06:36:33ZABBY—KELLEYOct 27, 1987UHC-49343-30•••-••-2341·(232) 577-8514ABIGAIL.KELLEY5@YAHOO.COM3540 Harbor Blvd Apt 23··SeattleWashington98172-0751GRP-0689CORE-HMO
CLMCLM-4214382026-06-13T13:13:42ZPeterRFerguson1948-03-25—UNKNOWN—UNKNOWN1560 Central Avenue··HOUSTONTX77066GRP-0108—
CLMCLM-4251822026-08-09T08:47:09Z Henry—Ruiz1973-01-02UHC-65473-87•••-••-49708145226501UNKNOWN662 Willow CourtLas VegasNV89154UNKNOWN-
ENRENR-116397 2026-03-07T09:04:26ZCYNTHIAX.DUNN1973-06-23UHC0849502—7412417191—5109 River RoadNASHVILLETNUNKNOWNGRP-9886OPTIONS-PPO
PRVPRV-207712026-04-16T14:21:34Z·Ken—Perkins1996-07-07UHC-46973-89——KENNETH.PERKINS@HOTMAIL.COM6141 Maple AvenueGlendaleAZ··85301-8353·nullnull
ENRENR-1264272026-01-19T01:39:14ZANDREA—KIM05-04-1945UHC-46800-07—14242687065andrea.kim56@hotmail.com4014 Washington StreetCharlotteNC28255GRP-8367MEDICARE-ADV-A··
TPATPA-627802026-03-28T10:51:20ZMark····Wang1989-10-27NULL•••-••-7649(935) 487-9405mark.wang66@aol.com1548 River Road Apt 28TempeAZ85235—OPTIONS-PPO
ENRENR-1091412026-09-20T13:39:56ZCaorlRClark01/03/1989UHC-30064-04NULL8272257839carol.clark93@hotmail.com6078 Lincoln WayCOLUMBUSOH43226GRP-9795SELECT-EPO··
CLMCLM-4049342026-10-13T03:14:36ZVINCENTY.HOWARD1993-07-20UHC-15428-40—679-563-3875null1898 Meadow LaneFresnoCA93715GRP-5807NAVIGATE-HMO
CLMCLM-4095922026-04-27T00:07:53Z Evelyn O.—·Olson2005-11-27··NULL—6593857016null8984 Jefferson AveJacksonvilleFL32276N/AMEDICARE-ADV-B
CLMCLM-4178902026-06-25T09:17:59Z·ryan—wright03/20/1953UHC-72160-97•••-••-0957790.280.1373NULL2436 Maple Avenue·San DiegoCA92120GRP-6501CHOICE-PLUS-PPO
ENRENR-1047012026-08-24T16:24:43ZJoyceMCarroll1974-03-15UHC-18329-37•••-••-22837862004060joyce.carroll67@hotmail.com2079 Indian School RdHOUSTONTX77060GRP-0468SELECT-EPO
TPATPA-532292026-02-11T14:15:45ZGEORGE··MRPHYOct 14, 1998—•••-••-6270nullNULL2791 ELM STREET··FresnoCA93778··UNKNOWN—
ENRENR-1325702026-02-02T20:43:40ZERICELOPEZ2005-06-03UHC-22440-94—6334298860··UNKNOWN4847 MARKET STREETScottsdaleAZ85203GRP-2620medicare-adv-b
CLMCLM-4044592026-03-16T13:15:20ZKELLY—BAKER2006-08-28N/A——KELLY.BAKER74@OUTLOOK.COM4218 SUNSET BOULEVARD #126San DiegoCA92180-SELECT-EPO
ENRENR-1380212026-08-06T07:30:58ZSARA·DCONTRERAS··1993-05-20UHC-13108-62•••-••-0864-SARA.CONTRERAS@YAHOO.COM4754 Ridge Road Apt 32HOUSTONTX—GRP-9761MEDICARE-ADV-A
ENRENR-1090892026-09-24T12:05:52ZMICHELLEBVALDEZ1958-02-19·UHC-31066-98—(628) 769-9499MICHELLE.VALDEZ83@GMAIL.COM3473 INDIAN SCHOOL RD·MinneapolisMN55484GRP-5876OPTIONS-PPO
ENRENR-1318492026-02-10T19:06:50ZHELEN····FERNANDEZ1942-06-16UHC-17523-60•••-••-7828(918) 896-4154HELEN.FERNANDEZ57@GMAIL.COM5023 Grand AveATLANTAGA30344GRP-8865CORE-HMO
PRVPRV-215452026-01-29T01:57:33ZADAM—SPENCER1959-01-01-null··216.738.2345-8509 Mesa DriveColumbusOH43280NULLNULL
ENRENR-1409742026-05-22T08:46:08Z·AlanJLarson··11-01-1981UHC-15650-15NULL971-663-0158alan.larson42@gmail.com5025 BroadwayDenverCO··80213GRP-1618CHOICE-PLUS-PPO
ENRENR-1088052026-04-23T05:10:56Zjulia—webbApr 26, 1990·UHC-13256-28•••-••-9919565-327-4313JULIA.WEBB8@AOL.COM·5812 Oak StreetFRESNO·CA93767GRP-1120SELECT-EPO
CLMCLM-4162682026-04-18T20:54:40Zrichard—brooks1960-04-23···UHC-17374-35null——5687 HIGHLAND AVENUEHoustonTX77044—OPTIONS-PPO
ENRENR-1303192026-08-05T01:30:38ZBRANDON···BLONG1963-11-17UHC-49927-34-700-923-0695BRANDON.LONG@ICLOUD.COM6600 Ocean AvenueTAMPA·FL33649GRP-4692NAVIGATE-HMO
CLM CLM-4269512026-02-27T09:57:57ZPowell, Karen——1988-04-09—UNKNOWN19648633370--UNKNOWNNULLNULLGRP-1921···NULL
CLMCLM-4047242026-03-25T10:44:51ZROBERT····BROOKS1945-01-05UHC2106319•••-••-3026UNKNOWN—5786 Desert Sky BlvdLOS ANGELESCA90074GRP-8234—
PRVPRV-294032026-03-03T16:52:37ZChristianG.Meedina1970-02-20UHC-32287-16··null2992397827·christian.medina52@outlook.com·4608 PINE DRCharlotteNC28247-null
100,000 rows, page 112 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.682Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty