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-4093352026-02-16T07:54:59Zscott——1954-07-22UHC-89192-22•••-••-6840370.495.4147—9154 Cedar LaneSEATTLEWA98102-3671GRP-1987SELECT-EPO
CLM CLM-4004172026-03-01T16:57:32ZStephen—Vasquez·08/23/57····NULL6998107538UNKNOWN7979 Canyon RdHoustonTX77029GRP-4414-
TPATPA-603402026-10-17T20:33:47ZCarr, Rachel··H—1969-09-16UNKNOWN—····N/A6128 Central AveSEATTLEWA··98165-1476GRP-5312NAVIGATE-HMO
ENRENR-1064152026-06-09T00:37:46ZVIRGINIAJMUNOZ08/23/1964UHC-21025-48•••-••-40826556513146virginia.munoz@hotmail.com4537 Oak StLOS ANGELESCA90018GRP-2537MEDICARE-ADV-A··
PRVPRV-206162026-09-05T12:16:06ZNANCY—CARR10/16/1981UHC-63787-77-3997255243nancy.carr91@proton.me489 MARKET STREETSacramento··CA95855N/A·navigate-hmo
TPATPA-557302026-08-10T14:09:04Zkayla—reid09/12/03uhc-98078-99•••-••-9592—·UNKNOWN2115 Market StSACRAMENTOCA··95845—N/A
CLMCLM-4098542026-05-05T12:36:39Zdenise—stephens19950816UHC-99350-16—19146849485N/A··2140 Baseline Road··TucsonAZ85752··GRP-6908···NAVIGATE-HMO
ENRENR-1074232026-03-10T18:29:12ZAngelaAWatkins1970-04-02UHC-18380-85•••-••-68489252754817angela.watkins14@hotmail.com429 Camelback RdAustintx78762GRP-2551CHOICE-PLUS-PPO
ENRENR-1377452026-04-11T14:16:21ZPamela—Ray12/14/2002UHC-77160-65•••-••-5535+1 587 865 6206·NULL8115 Forest AvenueMinneapolisMN55497·GRP-2562CORE-HMO
ENRENR-1415552026-08-09T04:19:26ZJAMES—KELLEY1963-11-03UHC-93869-95•••-••-70874744461093-8087 Sage CtPHOENIXAZ85098GRP-8564CORE-HMO
ENRENR-1162072026-01-02T03:35:59Zsamantha—mccoy1978-08-18UHC-93688-43•••-••-7215285-986-7106SAMANTHA.MCCOY@AOL.COM·6934 HARBOR BOULEVARDSan AntonioTX78239GRP-2898MEDICARE-ADV-B
PRVPRV-202092026-02-27T14:45:33ZMelissaH.Espinoza1953-11-24··N/ANULLN/A—7482 Mesa DrGLENDALEAZ85307null·NULL
TPATPA-618362026-01-24T21:13:31ZANGELA—ELLIS3/2/1949····UNKNOWN(446) 376-2583—9545 Apache BoulevardFRESNOCA93761-null
ENRENR-1403412026-03-23T22:07:26ZFATIMA—CUNNINGHAM··24-08-1968UHC-86786-27•••-••-7232655-767-3822··fatima.cunningham2@icloud.com3972 Washington StreetMinneapolisMN55441GRP-8387SELECT-EPO
ENRENR-1417302026-08-20T08:21:58ZHELENCPARK24-08-1961UHC-89899-49•••-••-9804316-645-9725HELEN.PARK@GMAIL.COM4055 BROADWAYSan DiegoCA92118GRP-4194SELECT-EPO
CLMCLM-4261252026-08-23T21:21:19ZLogan—Lucas21-09-1974UHC-41254-21•••-••-9495UNKNOWNNULL6921 HARBOR BLVD Apt 2PLANOTXNULLGRP-1114CORE-HMO
ENRENR-1125402026-02-11T10:17:44Z KELLYM.WAGNER19550301UHC-43037-05•••-••-43003002215476·null4324 Apache BlvdEden PrairieMN55352GRP-5659MEDICARE-ADV-A
ENRENR-1166212026-09-03T08:25:27ZgraceVarmstrong1956-04-27·UHC-82000-99UNKNOWN18414837781null··8239 Church StTempeAZ85230GRP-5352·MEDICARE-ADV-A
CLMCLM-4053832026-08-31T10:51:55ZArjun—Bradley·1959-04-16UHC-26745-33N/A—·NULL8435 BAYSHORE DRIVEGilbertAZ85222—UNKNOWN
ENRENR-1276252026-01-16T15:55:21ZAMBER—FIELDS10/14/1977··UHC-04870-75•••-••-5545787-661-3893·amber.fields@proton.me2847 Palm DriveSan AntonioTX78277GRP-8050··CHOICE-PLUS-PPO
ENRENR-1024172026-01-09T21:43:06Z·Emily—Warren1996-07-11UHC-27010-24•••-••-1956669-633-0066EMILY.WARREN@PROTON.ME8997 Maple Avenue··MESAAZ·85260GRP-5886OPTIONS-PPO··
ENRENR-1036512026-07-18T08:55:57ZMartha····Chapman11/6/1947·UHC3375750•••-••-5582·(564) 512-9782—6938 Lincoln WaySeattleWA98146GRP-7369OPTIONS-PPO··
CLM CLM-4192692026-02-09T14:27:32ZKaren—Greene1980-09-27UHC-00377-09•••-••-5808N/AnullN/ANULL——GRP-9633NULL
TPATPA-523432026-03-29T21:05:16ZEdward—Herrera1942-04-27—•••-••-27467516314351UNKNOWN8620 Harbor BoulevardTampaFL··33676-6569GRP-2612—
TPATPA-550932026-04-11T22:33:45ZBETTY—ROSE14-02-2004UNKNOWN—null—1454 Grand AvenueGlendaleAZ85332-9116UNKNOWNN/A
TPATPA-635482026-06-27T13:56:14ZDENNIS—DELGADO1991-08-14null•••-••-0846-—7235 Bayshore Drive·Fresno·CA93725—MEDICARE-ADV-A
ENRENR-1271712026-01-21T09:05:08Z Austin—Hawkins1984-05-25UHC-51169-55•••-••-7348(583) 315-2928austin.hawkins@proton.menullUNKNOWNnullnullGRP-7796SELECT-EPO
TPATPA-56828 2026-01-15T00:34:26ZHarold····Murray1982-06-10—•••-••-4984NULLN/A188 Baseline RoadAustinTX78753GRP-7015UNKNOWN
PRVPRV-20325 2026-08-01T01:25:31ZKimberly—Mejia1977-11-19——····—4850 Indian School RdMesaAZ85252-7856··-N/A
CLMCLM-4274962026-02-03T14:45:04ZLogan··—Ortiz··01-01-1975UNKNOWN•••-••-0952—·UNKNOWN2251 Grand AvenueLas VegasNV89141GRP-1592null
TPA TPA-522842026-01-30T07:09:12ZScottUGomez12/27/1994——3048528575N/A4489 UNION STREETLas VegasNV89155GRP-8741MEDICARE-ADV-B
ENRENR-1313492026-04-07T07:38:19ZDanielle··—Lee1963-06-15UHC-72052-89•••-••-7096616.915.2305NULL··5751 DESERT SKY BLVDDallasTX·75213GRP-0378OPTIONS-PPO
ENRENR-1397122026-05-29T04:41:08ZLaurenDBarnes09/09/1993UHC-56768-28•••-••-37405672444736lauren.barnes95@hotmail.com9543 Union StreetDenverCO80206GRP-4394··MEDICARE-ADV-B
TPATPA-574012026-08-15T11:59:58Z·Marcus—McDonald·9/22/2001null•••-••-0494+1 689 809 0179UNKNOWN6411 BroadwayHoustonTX77085—UNKNOWN
PRVPRV-211402026-08-11T08:16:53ZJeremy—Snyder1997-11-27UHC-72167-18——null4178 Park PlaceJacksonvilleFL32209null-
ENRENR-1245002026-05-12T17:50:37Z EddieB.Russell1991-02-21·UHC-31057-94NULL14029966099EDWARD.RUSSELL@OUTLOOK.COM7133 Meadow LnTucsonArizona85795GRP-3858SELECT-EPO
ENRENR-1295222026-08-11T06:28:56ZBettyPJohnston19770121UHC-31784-85•••-••-0812658.598.4154BETTY.JOHNSTON@HOTMAIL.COM4534 BASELINE RD··HoustonTexas77096GRP-3986··CORE-HMO
TPATPA-611212026-03-12T05:05:47ZHamilton, Jeryr··——1954-08-31—null209-670-7176UNKNOWN——UNKNOWN-——
CLMCLM-4284002026-08-31T05:01:00ZGreeen, Jeremy——1999-09-19-··•••-••-0742NULL-638 Meadow Ln Apt 14Gilbert·AZ85272GRP-9203—
ENRENR-1171732026-02-20T18:34:41ZKathryn—Moreno0212-91-88UHC-94649-01•••-••-2182—N/A9188 GRAND AVE Apt 13ColumbusOH43239GRP-8622SELECT-EPO
PRVPRV-220712026-08-03T02:07:52ZMunoz, Joshua——1994-01-20N/A—221.459.4792joshua.munoz@gmail.com4852 Washington StreetDallasTX——····
CLMCLM-4184952026-02-24T15:11:18Z·PETERU.·CRAWFORD1959-07-09UHC-41292-09•••-••-8989-null6013 Central AveNashvilleTN37242···UNKNOWNUNKNOWN
CLMCLM-4268102026-04-27T19:06:24ZRyan—Henry1997-02-08UHC-30848-72•••-••-9250940.797.7527UNKNOWN5813 Grand AveDallas··TX75225N/ANAVIGATE-HMO
TPATPA-542882026-09-19T18:10:12Z·RAYMOND—PAYNE6/1/1967UNKNOWNN/A380-847-8937null··7626 Broadway··DenverColorado··NULL—MEDICARE-ADV-B
ENRENR-1399862026-06-15T21:13:53ZkathrynJhall1944-12-23UHC-83097-10•••-••-8050720.832.2452kathryn.hall@proton.me9365 Grand AveMesaAZ85225GRP-2162CORE-HMO
TPATPA-531522026-05-28T10:23:38ZJanet—Boyd19670103—•••-••-910917848160075—711 Desert Sky BoulevardNashvilleTN37271NULL—
CLMCLM-4158032026-07-19T04:49:46Zbrian—daniels19910427UHC-77710-35•••-••-7420(298) 519-9675—1346 Grand Ave #369MesaAZ85253-2051—····
ENRENR-1056012026-02-17T07:06:53Zgabriel—watkins19560822UHC-85652-25UNKNOWN(428) 802-8816UNKNOWN8784 Highland AvenueGlendaleAZ85302··GRP-8094OPTIONS-PPO··
CLMCLM-4144382026-02-12T14:39:39ZWei—Washington19381218N/A•••-••-1540(228) 722-9709—UNKNOWN—-nullGRP-2179—
CLMCLM-4061072026-08-26T17:58:15ZADAMRCOLLINS1975-06-08N/Anull399-584-8023UNKNOWN2667 Canyon RoadTucsonArizona85765—N/A
100,000 rows, page 229 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:37.736Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty