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-1202212026-04-19T20:46:17Zamanda—salazar1956-06-08·UHC-64655-75null··UNKNOWNNULL5103 Desert Sky BoulevardEden PrairieMN55369GRP-0451··CHOICE-PLUS-PPO
ENRENR-1200752026-06-16T06:46:59Zcarlos—henderson1938-09-10uhc-04658-83•••-••-4644888-773-4314carlos.henderson@aol.com3916 Washington StreetPlanoTX75093GRP-8561CHOICE-PLUS-PPO··
ENRENR-1345982026-06-25T09:28:25ZHarold—Aguilar··1944-03-18UHC-68897-39•••-••-1255240.754.0376harold.aguilar@aol.com··1195 Desert Sky BlvdLas VegasNevadaUNKNOWNGRP-4431CORE-HMO
ENRENR-1006862026-01-25T10:08:57ZMariana—Shwa1952-02-14UHC-69035-21UNKNOWNUNKNOWN-1064 Oak StDenverCO80287-1432GRP-6082CHOICE-PLUS-PPO
ENRENR-1244002026-06-03T08:59:55ZHoffman, Walter——1965-04-17UHC-83616-67•••-••-948413763337955walter.hoffman@hotmail.com1445 MEADOW LANETEMPEAZ··85232GRP-4236NAVIGATE-HMO
ENRENR-1284122026-04-19T15:46:43ZLauren··D.Montgomery·Dec 10, 1963UHC-09615-90•••-••-1002(742) 835-5449LAUREN.MONTGOMERY@PROTON.ME2528 DESERT SKY BOULEVARDMinneapolisMN55495GRP-6170NAVIGATE-HMO
ENRENR-1196542026-03-05T05:13:00ZBenjamyn——1980-06-23UHC-74433-78•••-••-9857(946) 455-5695BENJAMIN.CONTRERAS@YAHOO.COM··7408 Sage CtGilbert·AZ85210··GRP-9082NAVIGATE-HMO
ENRENR-1429142026-05-30T11:38:55Zroger—knight1977-11-15UHC-48816-54•••-••-3245UNKNOWN····6386 River RdCHANDLERAZ··85280GRP-8539CHOICE-PLUS-PPO
ENRENR-1404172026-03-12T20:45:03ZZACHARY··QBAKER1952-04-10UNKNOWN•••-••-6809958-503-5297N/A9465 Grand AvenueEden PrairieMN55345·GRP-5121NAVIGATE-HMO
ENR ENR-1188902026-08-10T07:54:09ZAnaPWong1980-05-82UHC-13625-76•••-••-7161395-595-9376ANA.WONG@GMAIL.COMnullnull—NULLGRP-9954MEDICARE-ADV-A
ENRENR-1307392026-03-18T03:27:01ZTYLERG.··HARVEY1/21/1949UHC-03044-42NULL241-282-4433TYLER.HARVEY@GMAIL.COM4173 Elm Street·TampaFL33635GRP-5950select-epo
ENRENR-1010132026-09-21T03:43:13Zpriya—collins··1938-70-18UHC-14575-37•••-••-4208217-371-3753N/A2440 Sage Ct··HoustonTexas77014GRP-2220··CORE-HMO
ENRENR-1317412026-03-09T13:26:13Zdebra··—morris19741216·UHC-37271-04•••-••-7913435.430.7579·DEBRA.MORRIS27@HOTMAIL.COM8365 Valley View DrJACKSONVILLEFL-GRP-7790CORE-HMO
ENRENR-1126072026-04-04T09:30:31Z·AhmedIMcDonald3/4/1957···UHC-84142-68•••-••-84153986554503··NULL2796 ELM STPlanoTX·75003GRP-4131MEDICARE-ADV-B
ENRENR-1163792026-05-12T10:24:45ZElizabeth—Shaw1951-01-16UHC-97264-88··•••-••-49953456900956·N/A4539 OAK STGILBERTAZ85281GRP-8299MEDICARE-ADV-A
ENRENR-115303 2026-05-04T14:06:17ZJean··W.Hawkins1953-02-22UHC-21053-88•••-••-3093414-979-3135null2770 LINCOLN WAYSacramento·CA95863GRP-5842OPTIONS-PPO
ENRENR-1173782026-08-22T10:13:37ZGreene, Omar——1983-10-05UHC-20535-09UNKNOWN··(305) 904-5568OMAR.GREENE88@PROTON.ME1583 Mountain View DriveLos AngelesCA··90045GRP-7673NAVIGATE-HMO
ENRENR-1357982026-08-07T10:52:44ZLarryELee·2005-12-19UHC-32257-04N/A258.488.2781··3908 Canyon RoadNashvilleTN37218GRP-4378NAVIGATE-HMO
ENRENR-119785 2026-04-21T07:13:34ZBRANDONTMASON19430306UHC-06018-39—508-850-5003—2976 PALM DRIVEMinneapolisMN55487GRP-8235MEDICARE-ADV-A
ENRENR-142544 2026-07-20T17:43:28ZHaroold—Mendez1953-09-17··•••-••-9872—harold.mendez19@icloud.com9893 Jefferson Avenue··Gilbertaz·85229GRP-5964OPTIONS-PPO
ENRENR-1256102026-04-19T02:18:27ZAMANDA—ROSE1947-08-17UHC-36954-02··•••-••-79419362420799AMANDA.ROSE@YAHOO.COM3906 BAYSHORE DRPlanoTX75047GRP-4898CHOICE-PLUS-PPO
ENRENR-139639 2026-05-08T07:31:53ZAUSTINTMILLER2000-11-16UHC-05857-13•••-••-4256N/Aaustin.miller82@hotmail.com1627 Church St #885MinneapolisMN55476GRP-9687SELECT-EPO
ENRENR-1341742026-03-28T12:25:52ZBradley··—·Larson1956-06-02UHC-08086-72··•••-••-0213420.871.1452BRADLEY.LARSON88@HOTMAIL.COM8737 Market StreetDenverCO80200GRP-3624NAVIGATE-HMO
ENRENR-1308972026-01-02T18:23:15ZDENISEERILEY11/12/1978UHC3567083•••-••-8781622-423-2185-8523 Jefferson AvenueAtlantaGeorgia30341GRP-0903MEDICARE-ADV-B
ENRENR-1204982026-05-02T07:27:06ZKATHLEEN—CRAWFORD···1999-06-01UHC-99013-43•••-••-2511307-823-5692kathleen.crawford@outlook.com5269 Jefferson AveGlendaleAZ85356-7841GRP-6836CORE-HMO
ENRENR-1039702026-04-22T10:32:42ZPhlipYReynolds06/13/54UHC-22824-91•••-••-1390(404) 224-1947PHILIP.REYNOLDS3@YAHOO.COM6356 Spring StLOS ANGELESCA·90062GRP-4913MEDICARE-ADV-A
ENRENR-1185052026-02-17T21:38:55Z·Chris—GarzaOct 8, 1981UHC-88047-35•••-••-8751N/Achristopher.garza46@aol.com9802 Maple AveColumbusoh43244GRP-9303CORE-HMO
ENRENR-1348752026-08-30T07:10:14ZAmanda—Patterson··1977-02-24UHC-12161-92UNKNOWN8496016514AMANDA.PATTERSON@YAHOO.COM5482 Desert Sky BoulevardChandlerAZ85234GRP-2400NAVIGATE-HMO
ENRENR-1257142026-01-20T17:33:16ZMunoz, AshleyB.—02/26/1962UHC-16662-97•••-••-2074(510) 280-9704ashley.munoz91@aol.com··776 Apache BlvdNashvilleTN37282GRP-5113NAVIGATE-HMO
ENRENR-1383232026-02-18T13:34:24ZKenneth—McDonald·20021223UHC2388038•••-••-4501234-235-6337kenneth.mcdonald84@proton.me1501 RIVER ROAD #192·TampaFL33610GRP-9920CHOICE-PLUS-PPO
ENR ENR-1096422026-09-20T04:39:07ZHenderson, Sofia——1998-04-15UHC-82416-11•••-••-0818(399) 453-8678SOFIA.HENDERSON@HOTMAIL.COM6222 CEDAR LNEden PrairieMN55314-5776GRP-1291SELECT-EPO
ENRENR-1203502026-09-06T01:39:44Zlawrence—richards1964-11-21UHC-84652-73UNKNOWN(455) 655-8005····6040 Main StreetColumbusOH43236-9165GRP-6573SELECT-EPO
ENRENR-1077112026-06-17T07:53:06ZJAMESW.BARNES12/7/1989·UHC-76680-76•••-••-78034695387610james.barnes14@gmail.com5095 MEADOW LNEDEN PRAIRIEMN···55362GRP-7036MEDICARE-ADV-B
ENRENR-1197242026-08-02T19:59:53ZEdward—VargasAug 28, 1964UHC-86522-24•••-••-91272962771433edward.vargas@gmail.com6638 Bayshore Dr #602ScottsdaleAZ85260GRP-1155·MEDICARE-ADV-A
ENRENR-1240832026-03-14T10:37:31ZARJUNY··COOK1976-04-22UHC-87493-59—830-406-8451UNKNOWN··1438 CHURCH STSeattleWashington98101GRP-9606·SELECT-EPO
ENRENR-1421952026-06-15T05:53:24ZCarlosU.FranklinNULLUHC-62891-95•••-••-2735(788) 448-7667UNKNOWN9563 Highland AveJacksonvilleFL32262GRP-3316CORE-HMO
ENRENR-1318722026-06-18T12:16:21ZjacquelineIlewis1979-05-16UHC-55213-66•••-••-30637799006498jacqueline.lewis80@icloud.com5522 Lake View RoadDallas··TX·75281GRP-2675CHOICE-PLUS-PPO
ENRENR-1149362026-08-29T03:35:41Z willie—hanson··1960-07-08UHC-03195-84•••-••-3476····—162 Mesa Drive·AustinTX78768GRP-9573SELECT-EPO
ENRENR-1211372026-04-12T02:52:15ZRalph—Myers1966-04-05UHC-48858-85•••-••-7857409.398.3582—3366 HILLCREST RDGlendaleAZ85335GRP-6653SELECT-EPO
ENRENR-1204682026-08-10T07:19:30ZJacob—Young2000-11-25UHC8116201•••-••-6013979-246-3169jacob.young@icloud.com8831 GRAND AVE Apt 34AtlantaGA·30339GRP-1106MEDICARE-ADV-B··
ENRENR-1020882026-06-23T14:25:18ZKIMBERLY—KELLYNov 10, 1952UHC-98104-97•••-••-45817468043087kimberly.kelly@outlook.com4536 Market StreetDenverCO80286·GRP-0125SELECT-EPO
ENRENR-1032362026-08-12T13:47:54ZJoyceRBurton1954-01-07UHC-86194-82•••-••-651716535402746joyce.burton@yahoo.com6488 VALLEY VIEW DR·PhoenixAZ85097GRP-6877CHOICE-PLUS-PPO
ENRENR-1315102026-03-04T19:24:33ZOmar—AlvaradoOct 15, 1989UHC-98668-16—217-547-9648OMAR.ALVARADO@ICLOUD.COM561 Church StreetPlanoTX75066GRP-6185SELECT-EPO
ENRENR-1389042026-10-05T07:34:44ZSHIRLEY—CLARK1938-09-08UHC-46312-35•••-••-8535····shirley.clark@yahoo.com5817 WILLOW COURTDALLASTX75234GRP-4143NAVIGATE-HMO
ENRENR-1033632026-08-16T03:07:16ZAustinY.Mitcchell6/27/1972UHC-66264-69•••-••-8569321.225.4436austin.mitchell39@hotmail.com8995 Ocean Ave Apt 28Sacramentoca95880GRP-7906MEDICARE-ADV-B
ENRENR-1154092026-02-16T23:14:08Z RONALDH.CHAPMANAug 27, 2004UHC-24181-32null2117593716ronald.chapman@icloud.com··9311 Harbor BoulevardGilbertAZ85275GRP-6322OPTIONS-PPO
ENRENR-1136922026-06-30T05:40:47ZJACQUELINEWGILBERT··2/20/1982UHC-34579-75•••-••-5686247-522-3373·JACQUELINE.GILBERT10@ICLOUD.COM9819 Pine DrSacramentoCA95834GRP-8487CHOICE-PLUS-PPO
ENRENR-1327472026-07-23T16:06:16ZMarkY.Hughes1941-03-17UHC-85022-19•••-••-2385445-449-0533mark.hughes65@icloud.com6407 SPRING STJacksonvilleFL32232GRP-9934CORE-HMO
ENRENR-1398932026-02-14T01:25:01Z·Sophia H.—Richardson2005-02-11UHC-03647-35•••-••-6316+1 885 316 0073-8204 Meadow LaneSan Diego··CA92131GRP-8130SELECT-EPO
ENRENR-1023902026-02-13T17:22:21ZAnthonyV·Hernandez2003-01-03··UHC-96290-74•••-••-02036682370943anthony.hernandez32@gmail.com8512 MESA DRIVEScottsdaleAZ85269-2569GRP-1908CHOICE-PLUS-PPO
43,101 rows, page 267 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:43.422Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty