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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1319452026-04-01T02:01:43ZArthurRPatterson1/12/1958UHC-86077-71UNKNOWN3344175193arthur.patterson@aol.com8490 Spring StSan AntonioTX·78241GRP-0360NAVIGATE-HMO
ENRENR-1089582026-04-15T05:47:45ZLaura—Fuller21-01-1966UHC-11283-32•••-••-973519274101292laura.fuller59@aol.com7731 CENTRAL AVENUEDallasTXNULLGRP-5436MEDICARE-ADV-B
ENRENR-1242072026-07-04T12:50:21Z MaryQFuller1963-10-05·UHC-43878-46—N/Amary.fuller16@hotmail.com6246 Church StSacramentoCA95834GRP-7950NAVIGATE-HMO
ENRENR-1149302026-02-06T03:07:45ZValentina····Young1949-12-11UHC3439705•••-••-799914905894663VALENTINA.YOUNG71@OUTLOOK.COM3093 Hillcrest RdTucsonaz85746GRP-2079CORE-HMO
ENRENR-1314212026-07-04T14:15:53ZMARAINA—DIXON1990-10-07UHC-48131-45—393-257-7303—6216 Camelback RoadScottsdaleAZ85224GRP-3752NAVIGATE-HMO
ENRENR-1295422026-04-02T22:26:13ZPayne, BobbyL—1988-08-17UHC-54861-76•••-••-7458·(231) 586-0318—7432 Palm Drive·ColumbusOH43248GRP-1588OPTIONS-PPO
ENRENR-1212402026-06-28T04:40:10ZLAUREN—MILLS08/18/2000UHC-36346-77—2845734604lauren.mills@hotmail.com1484 BroadwayAtlantaGA30362GRP-8114CORE-HMO
ENRENR-1348822026-09-23T22:47:19ZAngela—Perez12/21/1964UHC-15991-36•••-••-86812248778546·ANGELA.PEREZ46@HOTMAIL.COM3715 Mountain View DriveSeattleWA—GRP-3668CORE-HMO
ENRENR-1193482026-09-21T02:56:27ZMASONUPIERCE1970-10-14UHC-14486-45NULL758.418.3726mason.pierce75@aol.com5979 MAPLE AVENUESan AntonioTexas78271·GRP-1146CORE-HMO
ENRENR-1364822026-05-14T04:33:40ZSantiago—Hawkins5/25/1965UHC-55074-11•••-••-9374(622) 626-1917SANTIAGO.HAWKINS86@HOTMAIL.COM682 WASHINGTON STREETTampaFL33657·GRP-4685CORE-HMO
ENRENR-1112502026-04-28T06:04:57ZHELENU.RAY19590319UHC-68624-37•••-••-5646592.351.6637—8885 Church St·TEMPE·AZ85290GRP-3240MEDICARE-ADV-A
ENRENR-1186802026-01-19T09:34:15ZDonnaJ··Carroll19460715UHC-70612-09•••-••-2834-donna.carroll84@icloud.com7717 Palm DriveDallasTX75248GRP-3521MEDICARE-ADV-B
ENRENR-1295812026-08-22T01:29:25ZRebeca—Ward01/12/1961UHC-94236-72—UNKNOWNNULL8919 Lake View RoadCHANDLERAZ85218GRP-5893OPTIONS-PPO
ENRENR-1377792026-01-18T18:33:34ZEDWARDUSIMPSON09/14/1974NULL··•••-••-909212796159432-8389 Valley View DrScottsdaleAZ··GRP-0110OPTIONS-PPO
ENRENR-1248392026-03-19T12:08:03ZJosephP·Wbb2008-01-15UHC-44238-24·null19022505861N/A838 Washington StMINNEAPOLISMN55477··GRP-0298NAVIGATE-HMO
ENRENR-136573 2026-03-11T22:12:16ZEMILY—PALMER1961-07-18null•••-••-6235449-949-2838··EMILY.PALMER@YAHOO.COM2418 Oak StreetChandlerAZ85247GRP-9863MEDICARE-ADV-B
ENR ENR-1194512026-02-28T18:14:20ZJOYECVMARSHALL1976-07-15UHC-07317-76•••-••-986418167538710joyce.marshall16@icloud.com3182 River Rd··San Antonio·TX78287GRP-7176OPTIONS-PPO
ENRENR-1264492026-02-21T11:28:24ZGrace····Espinoza1/8/1963UHC-25192-82•••-••-88242886636749··466 WILLOW COURTLas Vegasnv89161-5178GRP-3734OPTIONS-PPO
ENRENR-1418532026-06-25T00:57:13ZNATHAN—MONTGOMERY1975-08-23UHC-62026-38•••-••-2024····nathan.montgomery@hotmail.com5989 Lake View RdPlanoTX75015GRP-1226NAVIGATE-HMO
ENRENR-1237522026-07-14T02:10:04ZDEBORAHVBRADLEY·Aug 20, 1959UHC-52323-53—(514) 902-2555DEBORAH.BRADLEY34@AOL.COM867 Mesa DrTEMPEAZ·85262GRP-4151··CORE-HMO
ENRENR-1154422026-02-12T17:01:25ZAlexanderABradley1945-09-17UHC-60815-26•••-••-3428939-877-9006alexander.bradley@yahoo.com···4988 Mountain View DrDENVERCO80288GRP-8995SELECT-EPO
ENRENR-1254772026-04-07T11:50:25ZDorisF.Mooore2006-12-13·UHC-59561-94•••-••-4148UNKNOWNnull··N/A—null·····GRP-6001OPTIONS-PPO
ENRENR-1430572026-02-07T06:12:54ZBenjamiinSLane01/05/1985UHC-09486-02•••-••-3006884-841-9114··benjamin.lane48@gmail.com6981 CEDAR LANEMIAMI···FL33114GRP-8879MEDICARE-ADV-B
ENRENR-1253782026-10-11T15:06:55ZJOSE··FLORES1941-03-05UHC-21719-50•••-••-4743+1 484 671 1010jose.flores57@aol.com7684 RIDGE RD Apt 17·DallasTX75273··GRP-1632CORE-HMO
ENRENR-1002442026-02-10T06:32:51ZRuthQ·Ferguson1945-10-09UHC-17845-36•••-••-7559874-449-7748ruth.ferguson@yahoo.com9177 JEFFERSON AVEMesaAZ85248GRP-4741··CORE-HMO
ENRENR-1081342026-07-19T20:30:39ZNANCYD.MENDDOZA1988-03-18UHC-66651-92•••-••-130416149331084··nancy.mendoza27@hotmail.com·994 Lincoln WayTucson··AZ—GRP-0174SELECT-EPO
ENRENR-1403372026-08-26T05:06:23ZMatthews, BradleyT—1992-07-15UHC-27612-44null377-497-6929bradley.matthews71@aol.com6175 Highland AvenueSan AntonioTX78274·GRP-6219SELECT-EPO
ENRENR-1113712026-09-28T05:28:03ZBETTY—LE1953-07-25UHC-26618-68•••-••-7426607-747-3424NULL9800 Mesa DrHoustonTX77009GRP-0565·SELECT-EPO
ENRENR-1115202026-08-15T01:07:49ZCarlQ.Willis1946-06-26UHC-20138-67•••-••-9442238-225-8133N/A3585 Desert Sky Blvd·AustinTX78750··GRP-2729SELECT-EPO
ENRENR-1188802026-10-09T23:36:27ZTylerA.Perez23-05-2003UHC-26538-21•••-••-73618603731NULL2874 MEADOW LNOrlandoFL32885GRP-2732NAVIGATE-HMO
ENRENR-1155492026-10-01T12:54:30ZRomero, Samantha·V—1976-08-07UHC-70881-28•••-••-7529(664) 550-2381SAMANTHA.ROMERO@AOL.COM909 LINCOLN WAY Apt 33MinneapolisMN55447GRP-3273SELECT-EPO
ENRENR-131314 2026-08-25T16:04:36ZHannah—WardJan 1, 1997UHC-07354-59•••-••-2837+1 485 594 7776HANNAH.WARD4@AOL.COM4451 Mesa DriveFresnoCA93701GRP-6689CORE-HMO
ENRENR-1296382026-07-04T15:23:21ZJUDITHSSIMMONS·1980-07-16UHC-35607-99N/A··(744) 390-3678judith.simmons29@aol.com8104 Maple AveFresnoCA93728GRP-1460OPTIONS-PPO
ENR ENR-1034832026-03-12T16:41:03ZJanetG.Alvarado·1977-01-01UHC-58974-74•••-••-88044749805830janet.alvarado9@icloud.com4558 Cedar LaneNashvilleTN37284GRP-0140NAVIGATE-HMO
ENRENR-1083312026-06-11T12:04:33ZAishaX.Gilbert1955-06-04UHC-91966-46—936-642-4814aisha.gilbert90@hotmail.com8948 HIGHLAND AVEColumbusOH43266GRP-0947SELECT-EPO
ENRENR-1264692026-03-07T19:26:16Z·Dorothy—Greene1965-11-01UHC-20965-16•••-••-18228868596637DOROTHY.GREENE@GMAIL.COM··1956 Indian School RoadGlendaleAZ85338GRP-2307SELECT-EPO
ENRENR-1198852026-05-22T18:24:18ZVirginia—Jackson1958-05-09UHC9603399•••-••-2624+1 302 599 0288-1576 Oak StAustin··TX78774GRP-1334CHOICE-PLUS-PPO
ENRENR-1292522026-02-19T07:37:16ZLaurenQGrham04/28/55UHC-60456-28•••-••-4177(651) 799-3955lauren.graham37@yahoo.com··1326 Palm DriveHoustonTX77091GRP-7308CORE-HMO
ENRENR-1412982026-01-20T03:52:15ZTerryZAguilar10/18/1967UHC-05876-64•••-••-5031581-278-3833-5644 Camelback Road Apt 37TucsonAZ85723-9014GRP-8527OPTIONS-PPO
ENRENR-1258322026-06-05T07:07:30ZAaron—Roajs1961-04-23UHC-87706-84•••-••-9010+1 497 307 8419—372 BASELINE ROADPlanoTX75085GRP-5891CHOICE-PLUS-PPO
ENRENR-1392422026-02-25T15:28:56ZAmy··RCarr1981-05-24UHC-43150-75—508-309-4157NULL5530 Bayshore DrEden PrairieMN55355GRP-8029SELECT-EPO
ENRENR-1007742026-08-17T15:25:32ZChavez, JudithJ—19470817UHC-03402-97•••-••-5644—JUDITH.CHAVEZ@HOTMAIL.COM3704 Sunset Blvd Apt 2ORLANDOFL32893-4263GRP-8431CORE-HMO
ENRENR-1401552026-06-23T05:36:11ZAndreaJRichards1960-01-07UHC-85331-38•••-••-5030834.844.3364····4521 Forest AveSan AntonioTX78294GRP-8481CHOICE-PLUS-PPO
ENRENR-118555 2026-10-01T02:32:12ZLarson, BettyK.—6/6/1944UHC-50271-71··•••-••-6275+1 695 863 6190-304 BASELINE ROADOrlandoFL32814-6653GRP-3047NAVIGATE-HMO
ENRENR-1063332026-01-22T00:55:01ZSimpson, Emma——03/13/66UHC-49747-10•••-••-2274+1 906 870 4129EMMA.SIMPSON@ICLOUD.COM2298 LAKE VIEW RDCharlotteNorth Carolina28232GRP-8522·options-ppo
ENRENR-1349612026-02-10T22:23:01ZHowell, Ralph——1949-02-06UHC-97218-30•••-••-6301+1 358 675 1431ralph.howell4@proton.me·6773 River RoadAustinTX78705GRP-3429OPTIONS-PPO
ENRENR-1253172026-09-10T08:37:30ZDAVIDNSCHULTZ·11/23/2002UHC-36109-07•••-••-1068471-470-7157DAVID.SCHULTZ@AOL.COM3708 Baseline RoadSan AntonioTX78257-4247GRP-4649··OPTIONS-PPO
ENRENR-1351232026-03-01T09:42:42ZMegan—Sandoval2004-12-05UHC-35590-27nullNULLmegan.sandoval84@yahoo.com8968 HIGHLAND AVENUEAtlantaGA30327·GRP-4117CHOICE-PLUS-PPO··
ENRENR-1303142026-04-28T12:44:18ZCox, Austin——1984-02-08UHC-69639-21•••-••-9600643-573-4823austin.cox49@hotmail.com9295 Union StAustinTX78795GRP-2244CHOICE-PLUS-PPO
ENRENR-1263722026-01-05T11:38:35ZMegan—Guerrero1963-08-27UHC-90598-75•••-••-53785893801480UNKNOWN370 FOREST AVE #232AUSTINTX78756GRP-4054NAVIGATE-HMO
43,101 rows, page 243 of 863PreviousNext

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:40.625Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty