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
ENR ENR-1157542026-04-28T21:21:31ZMeganS.Herrera····UHC-91109-19-(708) 717-2970null4453 Indian School Rd Apt 6DENVERCO80228GRP-7446SELECT-EPO
ENRENR-1367032026-07-04T03:01:35ZRobinson, Evelyn··—1941-09-14UHC-32766-97•••-••-3422233-424-5704—8735 Market StreetDallasTX75297GRP-3594CORE-HMO
CLMCLM-4022982026-05-08T16:50:12ZFatima—Carlson1980-12-19UHC-32664-63—214-566-4632null8974 Spring StLos AngelesCA90048GRP-8557OPTIONS-PPO
CLMCLM-4178952026-06-28T22:07:30ZMark—Arnold1983-10-25NULL—7446563855——N/AUNKNOWN-UNKNOWN—
ENRENR-1189452026-05-26T06:49:45ZLawrence····Edwards20030921UHC-37501-93•••-••-5889506-909-9306lawrence.edwards63@proton.me2632 Sunset BoulevardScottsdaleAZ85225GRP-9444··MEDICARE-ADV-B
ENRENR-1078352026-02-22T06:14:21ZdorisRsanders1979-10-14UHC-68041-75•••-••-60513421009—6462 Central Ave·GLENDALEAZ··85326GRP-5677··CORE-HMO
TPATPA-573582026-10-07T18:13:39Zrilay—donna1995-08-28nullUNKNOWN—N/A4358 Forest AveTucsonAZ—UNKNOWN—
ENRENR-1220482026-02-20T16:17:41ZChuck—Fernendez·1968-06-02UHC-67743-02•••-••-0630557.567.9794charles.fernandez95@hotmail.com3419 Lake View Rd #668MESAAZ85280GRP-5437···CHOICE-PLUS-PPO
CLMCLM-4004132026-06-16T05:10:50ZJohn—Gardner1947-11-06··-NULL·N/A6299 Desert Sky Blvd #266Austin··TX78722—CORE-HMO
CLMCLM-4221172026-08-26T08:57:45ZLucia—Stone1995-04-04—UNKNOWNN/Anull2092 BAYSHORE DRTempeAZ85240GRP-1909·SELECT-EPO
CLMCLM-4210192026-04-17T18:35:30ZALICED.WEBB1998-06-27·N/AN/AUNKNOWN—2190 OAK STREETCHARLOTTEnc··28256GRP-3189OPTIONS-PPO··
CLMCLM-4239282026-03-17T11:14:01ZEthan—Wood1961-04-06UHC-73564-91UNKNOWN——5108 Lincoln WayNashvilleTN37258GRP-3279CHOICE-PLUS-PPO
PRVPRV-293582026-07-08T01:09:59ZTheresa—SimsJan 16, 1984UHC-55226-19—+1 521 885 1317NULL9244 Canyon RoadJacksonvilleFL32261—MEDICARE-ADV-A
TPATPA-522862026-01-15T22:49:19Z ·DOROTHY—GRY·1945-08-20—N/A——UNKNOWNN/Anull—UNKNOWNMEDICARE-ADV-B
ENRENR-1047042026-06-19T07:35:08ZMiills, MaryB—1967-01-21nullN/AUNKNOWNmary.mills78@hotmail.com2271 CENTRAL AVETampaFL33666GRP-7910··CORE-HMO
ENRENR-1030162026-02-15T19:13:11ZKenneth—Wallace28-11-1958UHC0056350·-+1 258 824 3229kenneth.wallace38@icloud.com4932 INDIAN SCHOOL ROADMIAMIFL—GRP-5772NAVIGATE-HMO
PRVPRV-219852026-08-10T18:17:09ZAlexander, JaniceK—2008-05-23····•••-••-6818887-452-3752UNKNOWN··8708 Central AvenueSacramentoCA95832-1512N/ANULL
ENRENR-1181252026-08-25T22:36:35ZsandraL.·cruz1939-07-06UHC-26778-24•••-••-0535(295) 845-2158—649 Elm StSAN DIEGOCA92101GRP-2161OPTIONS-PPO
ENRENR-1304392026-01-27T00:29:54ZHeatherNChavez1955-08-17UHC-89788-22•••-••-8832326.337.5755heather.chavez48@gmail.com1163 Ocean Avenue #209NASHVILLETN37224GRP-2602MEDICARE-ADV-A
CLMCLM-4219182026-08-05T02:18:33ZVINCENTQHART19590715UHC-21987-76—4755130697—·2540 Meadow LnNashvilleTN37236GRP-9030MEDICARE-ADV-B
CLMCLM-4149732026-09-30T15:41:03ZAmanda—Parker1947-02-27UHC-47167-27—nullUNKNOWN2487 Apache BlvdDenverCO-N/ASELECT-EPO
ENRENR-1089282026-09-28T00:59:23ZSandoval, RandyL····11/13/51UHC-38306-80•••-••-4024944-351-5197randy.sandoval99@proton.me5598 Canyon Road··DenverCO80235GRP-3867OPTIONS-PPO
CLMCLM-4027912026-09-28T02:21:41ZDaniel··Rios1954-08-24UHC-16351-42•••-••-7411(969) 695-4297N/A6945 PINE DRIVESan DiegoCA92196-5792GRP-8827MEDICARE-ADV-B
ENRENR-1377502026-07-15T17:39:26Z JacobWGrant1969-10-22UHC-57440-22•••-••-95533084346185··jacob.grant69@gmail.com3053 Harbor BlvdTUCSONAZ85724-9888GRP-5693NAVIGATE-HMO
CLMCLM-4137802026-08-15T08:07:55Z Gloria—·Ray1982-06-02—-823-277-3658UNKNOWN64 Central AvenueTucsonArizona85712·GRP-6219MEDICARE-ADV-A
CLMCLM-4221672026-02-04T07:47:06ZHaroldE.Castillo05/28/1949UHC-59339-91N/A-N/A1101 Church StreetDallasTX75244·GRP-1845OPTIONS-PPO
CLMCLM-4209772026-02-15T16:03:34Z·Ronald—Williammson1983-02-23UHC-04062-47UNKNOWN—N/A3583 BroadwayNashvilleTN37278GRP-4267CORE-HMO
ENRENR-1045262026-10-06T09:57:32ZJerryTFranklin1994-09-15UHC-31529-37•••-••-83674886563226null3181 RIDGE ROAD·ColumbusOH43237GRP-0693MEDICARE-ADV-A
PRVPRV-29344 2026-05-21T00:44:13ZMICHAEL—GARRETT2003-11-10UHC-15377-59NULL419-682-7958-63 Harbor Boulevard Apt 8Scottsdale·AZ85285N/ANAVIGATE-HMO
ENRENR-113683 2026-05-05T11:22:19ZJudy··YMatthews1986-08-25UHC-80695-58•••-••-89565897106768judy.matthews52@yahoo.com3336 Mountain View Dr Apt 10San DiegoCA92198GRP-6170MEDICARE-ADV-B
ENRENR-1099542026-06-29T05:25:38Zjoe··G·cole07-08-1985··UHC4617266NULL(498) 912-4773joe.cole@icloud.com7865 Maple Avenue Apt 35GILBERTAZ85294GRP-5338OPTIONS-PPO
CLMCLM-4137132026-02-08T17:01:58ZSamanthaT.Diaz1998-08-23··UHC-92123-72UNKNOWN7985037N/A1859 Meadow LnTucsonAZ85789-3719UNKNOWNMEDICARE-ADV-A
CLMCLM-4290172026-08-03T07:04:56ZBrenda—Green1966-08-06UHC-46437-60—246.461.9923brenda.green22@hotmail.com4014 Canyon RoadEDEN PRAIRIEMN55348GRP-1377··NAVIGATE-HMO
ENRENR-1384692026-02-24T00:24:14Zjoseph·Nhanson1999-12-05UHC-34231-96UNKNOWN+1 941 523 3664JOSEPH.HANSON80@PROTON.ME3879 Mountain View DrAtlantaGA··30389GRP-2903··MEDICARE-ADV-B
CLMCLM-4172712026-06-02T23:47:50ZDanielle—Jordan1973-12-20UHC-72650-33UNKNOWN8554587156danielle.jordan49@outlook.com··2275 Hillcrest RdSacramentoCA···95836—····
CLMCLM-4202532026-05-07T14:06:09Z Andrew—McCoy1999-11-03UHC-29060-53N/A—NULL184 BroadwayHoustonTX77031GRP-4420CORE-HMO
TPATPA-598132026-04-01T11:40:49ZHeather—Cox19570925N/A—NULL—613 Ridge RoadLos AngelesCA90008GRP-2435MEDICARE-ADV-A··
TPATPA-574492026-08-18T06:22:31ZkathrynE.willis1976-11-17N/AUNKNOWN9825227898—·1590 Sunset BoulevardColumbusOH43228GRP-7218CORE-HMO
ENRENR-1087912026-04-03T15:27:00ZBarbaraUWarren1979-06-15UHC-54834-89—4519681684barbara.warren93@icloud.com·9804 OCEAN AVENUE #833AustinTX78763GRP-4001CORE-HMO
TPATPA-644312026-02-28T09:16:16ZJoseph—Payne07/21/1971--(860) 336-9247NULL8176 HILLCREST ROADORLANDOfl32897UNKNOWNN/A
CLMCLM-4109432026-09-30T16:04:58Z Ray, ValentinaC.—2000-05-10UNKNOWN•••-••-05145616824492NULL3346 SUNSET BLVDFresnoCA93750GRP-4931—
TPATPA-500772026-07-14T21:31:42ZTeresa—FranklinSep 27, 2006UHC-79947-46•••-••-98274965056080teresa.franklin45@aol.com4892 BROADWAYOrlandoFL··32896UNKNOWN·MEDICARE-ADV-A
ENRENR-1012462026-09-09T01:32:45ZElliott, Santiago····—1978-11-02·UHC-15961-44•••-••-9853UNKNOWNsantiago.elliott76@aol.com3870 Willow Ct··MesaArizona85257GRP-0455CHOICE-PLUS-PPO
TPATPA-545032026-06-03T04:06:07ZJoan—Brown2002-09-03UHC-09520-95—+1 453 697 7100··--—null·-null-
ENRENR-1404792026-08-21T10:23:18ZKeith—Li2003-11-15UHC-64482-19•••-••-2748+1 240 318 1848·N/A·513 Park PlaceDenverCO80286GRP-8478OPTIONS-PPO··
TPATPA-541882026-05-13T04:01:09ZJoan—Garrett3/20/1950—N/A····—9201 Cedar LaneAustinTX78750—null
ENRENR-1135922026-05-05T11:48:48Z·Angela—Moreno1984-07-14·UHC-73326-27UNKNOWN5859151angela.moreno81@hotmail.com5944 Park PlHoustonTX··77001GRP-0327OPTIONS-PPO
ENRENR-1233062026-04-12T19:47:50Z·Martinez, SophiaB.—1950-04-27UHC-22861-85•••-••-9482—SOPHIA.MARTINEZ77@PROTON.ME9261 Lake View Road #553MesaAZ85258·GRP-4219MEDICARE-ADV-B
CLMCLM-4266932026-02-05T16:35:59Z·Lucya—Torres1981-05-24UHC-10261-77-(807) 886-0849N/A7826 WILLOW COURTChandler·AZ85240N/AN/A
ENRENR-1134572026-08-03T23:11:26ZLUISFWARREN1947-05-20UHC-32432-18•••-••-2295(551) 620-0311UNKNOWN6684 Elm Street··HoustonTX77071GRP-2918NAVIGATE-HMO
100,000 rows, page 160 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.704Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty