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
TPATPA-637722026-05-23T09:32:17ZLIZDMYERS1981-12-18N/Anull—elizabeth.myers98@outlook.com·9332 Ridge RoadDallas···TX75292GRP-2558—
PRVPRV-273252026-06-22T17:15:02ZANGELA··CARPENTER07/20/90—-4867873—·4829 Jefferson AvenueAustinTX78752··—··
CLMCLM-4115032026-01-05T04:48:06ZJeffreyY·Valdez·1998-02-08UHC-15233-48•••-••-2601-—5176 Baseline RoadAtlantaGA30310GRP-3738NULL
CLMCLM-4092832026-10-03T15:20:25ZJANICE—MONTGOMERY2005-11-28UHC-33646-35—·(843) 748-4101—5292 Union StreetJacksonvilleFL32272N/AOPTIONS-PPO
ENRENR-1005502026-05-18T20:35:47ZARONUHARPER2008-11-02UHC-06862-81•••-••-1174(289) 634-1496N/A3658 Market StScottsdaleAZ··85237-1815GRP-7940NAVIGATE-HMO
ENRENR-1083322026-10-13T11:18:42ZLawrenceRLi1998-10-05UHC-16606-42•••-••-7459+1 948 978 2199—2792 SAGE CTSacramentoCA95831GRP-4736CHOICE-PLUS-PPO
TPATPA-605742026-01-21T00:54:09ZSteven—Carter1995-08-08null····(238) 726-4090—3793 Bayshore DriveSAN ANTONIOTX78250nullnull
ENRENR-1062052026-01-20T19:03:35ZRice, Charlse——1968-08-21UHC-28560-68-—charles.rice@proton.me7601 Spring StTampaFL33662-3865GRP-7732·CHOICE-PLUS-PPO
CLMCLM-4030752026-03-24T07:39:58ZKathleen··Gibson2007-07-19UHC-89929-38N/A335-247-3029N/ANULL—N/AUNKNOWNGRP-6274MEDICARE-ADV-A
TPATPA-603032026-05-26T11:50:27ZNicole—Arnold··19790510—•••-••-37445623336184—3165 Mesa DriveChandler·AZ85231—·null
PRVPRV-211642026-10-12T14:14:43ZPerez, AhmedY··9141-05-09····—9662242443N/A3435 BroadwaySACRAMENTO·CA95811—SELECT-EPO
ENRENR-1287372026-07-18T02:30:29ZWeiP.Feilds·Dec 24, 1959UHC-62961-20UNKNOWN(218) 678-4775WEI.FIELDS44@AOL.COM5344 Church StreetLOS ANGELESCA90051GRP-4190MEDICARE-ADV-B
ENRENR-1033692026-01-14T15:03:27Zruht—vargas20010409UHC-73294-75··•••-••-94618469270847ruth.vargas57@proton.me7794 Union StreetGLENDALEAZ·85336GRP-5891SELECT-EPO
ENRENR-1068392026-08-26T23:26:18ZDorothyAGray1945-08-20UHC-28039-87-+1 797 663 4776dorothy.gray@outlook.com9607 Meadow LaneLas VegasNV89155GRP-6117MEDICARE-ADV-B
CLMCLM-4010892026-02-02T00:06:57ZAmy—Vargas09/27/1949NULL—+1 789 717 7898null8448 Mesa DriveChandlerArizona85295-6822·····OPTIONS-PPO
TPATPA-554602026-06-12T13:57:21ZBRANDON—MUNOZ··08/13/1954——N/Anull7696 Highland AveTEMPEAZ85265GRP-3223—
ENR ENR-1151362026-01-05T06:29:59Z·LindaLSmith1989-09-17UHC-68199-20•••-••-68898909450678N/A6905 Hillcrest RoadTempeAZ85222GRP-6601MEDICARE-ADV-A
ENRENR-1106322026-01-12T03:26:02Zgregory—franklin2000-06-12—N/A+1 902 372 7137gregory.franklin94@aol.com5586 Pine DriveLos Angeles··CA90053GRP-8956MEDICARE-ADV-A
CLMCLM-4271612026-08-20T21:44:37ZSUSAN—OWENS1941-08-12UHC-37768-97··-UNKNOWNN/A82 PINE DRFresnoCA93758GRP-7609N/A··
ENRENR-1293882026-04-11T04:01:02ZDANIELZBLACK2005-02-09UHC-29762-38•••-••-00799508577341daniel.black12@aol.com4370 SPRING STPHOENIXAZ85078GRP-0848CHOICE-PLUS-PPO
ENRENR-1369882026-01-01T02:43:55ZGeorge—Herrera1952-10-09UHC-45914-08•••-••-9096UNKNOWN—337 MESA DRATLANTAGA30307GRP-1713MEDICARE-ADV-B
CLMCLM-4327472026-07-26T12:17:11ZPHILIP—RIOS1974-06-24—NULL730-488-0125—7523 Bayshore DrSan DiegoCA92191GRP-4153SELECT-EPO··
ENRENR-1231032026-10-11T00:47:01ZSingh, JeffreyK—Oct 28, 2008UHC-30073-49•••-••-5216905.458.8942UNKNOWN3844 CEDAR LANELas VegasNVnullGRP-3182MEDICARE-ADV-B
ENRENR-1426622026-05-02T13:57:16ZSusanGPerez1938-06-23·UHC-09172-06•••-••-45848805255677susan.perez@proton.me8072 SAGE COURTChandlerAZ85239GRP-5822CORE-HMO
ENRENR-1179122026-06-17T06:34:30Zandrea—patterson1943-10-02UHC-20066-43•••-••-7227(432) 298-9936ANDREA.PATTERSON62@YAHOO.COM6818 HILLCREST ROADSan DiegoCA—GRP-8831OPTIONS-PPO
TPATPA-520252026-06-21T15:42:47ZBILLY··—TUCKER··1987-12-20null··—NULLNULL1246 Hillcrest RoadTampaFL33679N/A····
CLMCLM-4037152026-09-06T23:29:32ZRoy—Jacoobs19460708UHC-04300-32•••-••-80632164555149null2177 Sage CtSan AntonioTX·78233N/Anull
ENRENR-1312812026-03-24T10:56:46ZRUSSELLSWARD09/05/1968UHC-88290-82—8239992782—1653 Maple AvenueGlendaleAZ85323GRP-1182CORE-HMO
PRVPRV-206392026-01-10T18:02:51ZAshley····Turner1982-08-20UHC-15343-73N/A5857597815··ashley.turner44@aol.com7867 Elm StreetAtlantaGA30390nullNULL
PRVPRV-287092026-01-15T02:22:34ZMichael—Romero4/1/1944·-null9586948183UNKNOWN118 Washington StreetTUCSONAZN/ANULLMEDICARE-ADV-A
TPATPA-590612026-09-28T02:25:36ZNichols, Aisha——14-07-1996NULL•••-••-1318—null9422 Baseline RoadOrlandoFL32826-0596NULLN/A
CLMCLM-4210182026-02-25T05:01:35ZJOYCE—RODRIGUEZ1961-10-22UHC-59693-27··•••-••-2006545-391-2666joyce.rodriguez@proton.me——N/A—NULL—
ENRENR-1044232026-04-11T06:08:03ZMarshall, Kate——1943-08-16UHC-61716-65•••-••-0166(571) 988-6069UNKNOWN6981 Grand Ave··Fresno·CA93735GRP-2747NAVIGATE-HMO
ENRENR-1175692026-09-30T15:58:57ZPHILIP··SHARVEY1960-11-20UHC9003644•••-••-378917964360147—7673 Union StreetDallasTX75200GRP-2771NAVIGATE-HMO
PRVPRV-264302026-08-15T22:50:42ZEvans, Arjun······2/19/1979——(291) 357-4271—5961 BROADWAYSCOTTSDALEAZ85235—medicare-adv-b
ENRENR-137334 2026-02-13T02:21:20ZKYLLE····PETERSNULLUHC-90273-30•••-••-515719627644449kyle.peters@outlook.com··6379 WILLOW COURTOrlandoFLN/AGRP-2505CORE-HMO
ENRENR-1100522026-08-22T09:28:35ZSarahBFord1998-10-01UHC-23807-49•••-••-878918177010911SARAH.FORD@YAHOO.COM7721 MAPLE AVENUEPHOENIXAZ85088GRP-2306·OPTIONS-PPO
ENRENR-1049662026-02-28T15:35:00ZCarlson, StephaineG—16-04-1977UHC-71608-01•••-••-2228488.981.7882stephanie.carlson@yahoo.com9790 Cedar LnGilbertAZ85205GRP-1259OPTIONS-PPO
PRVPRV-24348 2026-08-19T02:30:14Z·Patrikk—Nguyen11/21/2001UHC6212412null6962571225PATRICK.NGUYEN@OUTLOOK.COM4943 ELM STREETSacramentoCA95809NULL··
ENRENR-1153762026-04-25T23:40:03ZDonna·IStephens03/07/1984UHC-67995-44•••-••-4857545-827-6708—1758 Mountain View DrPlanoTX75067GRP-7778CHOICE-PLUS-PPO
CLM CLM-4285372026-05-24T09:29:49ZDEBORAH·····WOOD1952-03-25UHC-17825-21NULL(262) 356-6152NULL9553 Palm DrHOUSTONTX·77080GRP-5514—
ENRENR-1399952026-08-05T18:49:04ZSandraN.Reynolds1971-06-18UHC-49352-15•••-••-0590479-307-2564SANDRA.REYNOLDS@AOL.COM5740 INDIAN SCHOOL ROADScottsdaleAZ85229··GRP-1608MEDICARE-ADV-A
PRVPRV-283622026-04-26T00:11:56ZLORI—STEWART1945-01-20UHC-49995-63—817-570-8003-5044 BroadwayATLANTAGAUNKNOWN—UNKNOWN
CLMCLM-4055062026-03-24T09:16:22Zmadison··montgomery1976-10-17UHC-92303-01UNKNOWNnullNULL9194 Broadway #691··GilbertArizona85219-8563·····NAVIGATE-HMO
ENRENR-1052042026-09-05T22:59:28ZMark—Hudson2002-05-17··UHC-88797-59•••-••-6029(332) 377-2261mark.hudson61@aol.com2758 BroadwayGilbertArizona85283GRP-0571OPTIONS-PPO
CLMCLM-4175262026-07-14T18:02:56Zking—marilyn19701014UHC-52925-80•••-••-2715—nullUNKNOWNN/A—-nullUNKNOWN
CLMCLM-4281582026-07-30T15:50:39ZLogan—Larson·04/19/1945UNKNOWN•••-••-5682null—NULL-··nullN/AGRP-1264OPTIONS-PPO
CLMCLM-4192232026-09-15T13:33:06ZAmy—Carroll1993-12-13UHC6361361NULLNULLUNKNOWN3972 River RdAtlantaGeorgia30398GRP-4384UNKNOWN
ENRENR-1054322026-09-06T20:30:30ZSamuel··Bailey19510903UHC-84204-56•••-••-3291(212) 873-4571samuel.bailey@proton.me8625 Grand AvenueNashvilleTN37227GRP-6486MEDICARE-ADV-A
ENRENR-1113522026-08-10T04:55:55ZRalph—Le1950-06-26UHC-25349-55•••-••-7396428-534-6230ralph.le@outlook.com513 Highland AveEden PrairieMinnesota55341··GRP-7304MEDICARE-ADV-B
100,000 rows, page 94 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:34.803Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty