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-1324812026-02-05T08:23:03ZStephanie—Luna13-06-1938UHC-73709-69•••-••-9050800-478-3169stephanie.luna@hotmail.com7852 River RoadGlendaleAZ85319GRP-6460SELECT-EPO
ENRENR-1107742026-05-05T11:47:38Z·Johnson, Kayla——1990-01-07UHC-82773-21•••-••-62526019714583kayla.johnson@hotmail.com9081 RIVER RDTampaFL··33639GRP-5902MEDICARE-ADV-A
ENRENR-1139822026-06-04T13:39:17ZKim··W··Mitchell05/17/1974UHC-12677-61•••-••-5046791-365-9238NULL5817 Indian School RdMiamiFL33171GRP-8325OPTIONS-PPO
ENRENR-1355192026-09-07T17:47:58ZJeffrey—Morrison1995-06-04UHC-29783-92•••-••-5052987.870.8578jeffrey.morrison@icloud.com·2743 FOREST AVEMinneapolis·MN55419GRP-5654·CHOICE-PLUS-PPO
ENRENR-1257572026-08-16T17:18:57ZCooper, GeorgeJ.—1988-06-04UHC-06641-62··•••-••-0282467-809-1401george.cooper@aol.com5636 WILLOW COURTTampaFL33669GRP-8104SELECT-EPO
ENRENR-1260292026-03-28T19:59:49Z———9/6/1959UHC2171099•••-••-4294780-590-7279priya.foster@hotmail.com5221 Canyon RoadCOLUMBUS··OH43297GRP-9382NAVIGATE-HMO
ENRENR-1404292026-03-25T11:16:35Z GeraldESimpson12/15/1942UHC-08297-98•••-••-6254NULLGERALD.SIMPSON@HOTMAIL.COM4029 FOREST AVENUELAS VEGAS·NV89116GRP-7412MEDICARE-ADV-B
ENRENR-1325192026-04-19T20:45:55ZHenry F··Brooks1958-12-21UHC-71727-36•••-••-6872·14323834999henry.brooks@yahoo.com562 Sage CourtChandlerAZ85215GRP-3591·MEDICARE-ADV-A
ENRENR-1064942026-04-28T19:38:32ZJONU.MCCOY··2/22/2006uhc-37349-81•••-••-00896152772005jonathan.mccoy63@yahoo.com6840 Ridge RoadPhoenixAZ85056GRP-0530·SELECT-EPO
ENRENR-1321682026-06-14T22:54:11Ztheresa—·wagner1949-12-07··UHC-14843-25•••-••-5711681-312-8405theresa.wagner80@icloud.com795 Central AvenueFresnoCA··93772GRP-6742NAVIGATE-HMO
ENRENR-1082372026-09-01T20:55:29Z·JESSICAV.BOWMAN1947-05-09UHC-38996-73•••-••-5294(525) 289-5295jessica.bowman@proton.me8892 Ridge RoadTucsonAZ·85715GRP-5720MEDICARE-ADV-B
ENR ENR-1173722026-07-05T18:50:22Z·Walker, Dorothy——1980-01-28UHC-09439-74•••-••-8605783.792.5892—3726 Canyon RoadChandlerAZ·85226GRP-1743SELECT-EPO
ENRENR-1047632026-08-12T16:28:02ZBishop, Joe····—1987-04-18UHC-19037-06•••-••-1687(706) 287-7314joe.bishop60@outlook.com69 Highland Avenue Apt 8TampaFL33678GRP-8230··navigate-hmo
ENRENR-1344962026-08-15T03:34:24ZGuzman, GloriaB.—1939-05-23UHC-99703-83•••-••-3771772-501-4783—5838 Pine DrGlendaleAZ85394GRP-7350MEDICARE-ADV-A
ENRENR-1079182026-10-08T12:36:33Z JaniceKRoberts1981-08-28UHC-08282-28null9005793777janice.roberts@yahoo.com1097 MOUNTAIN VIEW DREden PrairieMN55330GRP-0510MEDICARE-ADV-B··
ENRENR-1126112026-07-25T03:03:37ZAMYGFORD1983-07-17UHC-89106-69•••-••-8864336.284.5635AMY.FORD@GMAIL.COM1552 Lincoln WayPHOENIXAZ-GRP-6713NAVIGATE-HMO··
ENRENR-1424742026-07-07T18:16:07ZJeremy—Mendez1987-09-14UHC-21632-60•••-••-8589(666) 979-5351jeremy.mendez@hotmail.com9776 Harbor Blvd··Las VegasNV89151GRP-5723OPTIONS-PPO
ENRENR-1138892026-04-09T05:33:52ZTERRYWCUNNINGHAMOct 11, 1966UHC-72436-57•••-••-4968+1 661 842 1003terry.cunningham47@hotmail.com1040 Baseline RoadAustinTX78784GRP-3925MEDICARE-ADV-B
ENRENR-1046412026-07-23T22:46:27ZCYNTHIA—RODRIGUEZ19770127··UHC1755320•••-••-98025005479875cynthia.rodriguez@yahoo.com9288 Oak StAUSTINTX78757-0345GRP-5490NAVIGATE-HMO··
ENRENR-1123522026-04-28T23:26:15ZYUKI—SOTO1944-05-12UHC-03062-76•••-••-1958(232) 303-9084-1250 Hillcrest RdCHARLOTTENorth Carolina28205GRP-1056OPTIONS-PPO
ENRENR-1037742026-07-01T01:20:16ZJONATHANRGREENE11/14/1952UHC-34595-69•••-••-0223NULLJONATHAN.GREENE@OUTLOOK.COM5540 BroadwayAtlantaGA30384GRP-2838NAVIGATE-HMO··
ENRENR-1147532026-07-10T04:36:06ZMELISSAZMARSHALL05/16/1955UHC-17224-35—820-337-3837N/A2349 HARBOR BOULEVARD·GilbertAZ85222GRP-2802CORE-HMO
ENRENR-1226602026-09-22T06:01:31Zanna—romero1956-07-16UHC-31853-94··•••-••-51882327911188··anna.romero68@outlook.com2560 Lake View RdMIAMIFlorida33188GRP-9347MEDICARE-ADV-A
ENRENR-1187382026-04-29T18:19:09ZRONALDH.VALDEZ19951113UHC-22229-49•••-••-4696(670) 908-5317ronald.valdez@proton.me1195 Jefferson AvenueNashvilleTN37231GRP-4017navigate-hmo
ENRENR-1424362026-05-10T04:54:57ZBryan—Kennedy3/13/1979··UHC-75628-97•••-••-4221786.467.7770bryan.kennedy@hotmail.com1527 Maple AveTAMPAFL33687·GRP-4505MEDICARE-ADV-A
ENRENR-1155162026-07-08T13:23:52ZLaurenN.CrawfordJan 23, 2005UHC-07528-59•••-••-1940+1 500 633 8568lauren.crawford@icloud.com··3185 WASHINGTON STMiamiFL33164GRP-2948OPTIONS-PPO
ENRENR-1368602026-07-25T12:24:45ZPriyya—Lopez1947-04-09UHC-53383-79•••-••-2663-priya.lopez@aol.com6000 Harbor Blvd·ChandlerAZ··85296GRP-4231OPTIONS-PPO
ENRENR-1347482026-07-18T05:40:13ZEHTAN··Y.FOSTER08/06/1941UHC-36897-68•••-••-0772438-255-5960ethan.foster@aol.com7698 Lincoln WayMINNEAPOLIS··MN55426GRP-9592MEDICARE-ADV-A
ENRENR-1256652026-05-02T00:18:26Z CarrT.Joan7/2/1967UHC-62574-99•••-••-6466476-492-0390UNKNOWN··2532 LINCOLN WAYAtlantaGA30380GRP-0965·choice-plus-ppo
ENRENR-1080382026-01-20T18:38:48ZTeresa—Reid1988-07-24UHC-23512-04•••-••-7599616-632-5139TERESA.REID64@GMAIL.COM7882 MARKET ST #374NASHVILLE·TN37257GRP-9902NAVIGATE-HMO
ENRENR-1153392026-03-01T04:41:55ZMarianaYMeyer1999-10-19UHC-90494-02•••-••-5554401-839-5243mariana.meyer@icloud.com1132 RIDGE RD·SacramentoCA95819GRP-7473OPTIONS-PPO
ENRENR-1154802026-07-17T18:01:02ZKimKDavis2170-19-75UHC-16619-94•••-••-82316874605584KIMBERLY.DAVIS@HOTMAIL.COM619 Baseline RoadCOLUMBUSOH43206GRP-6993MEDICARE-ADV-A
ENRENR-1103562026-01-26T21:35:51ZJudith—Gardner1996-07-24UHC-21987-43•••-••-8200743-902-8198JUDITH.GARDNER29@PROTON.ME9762 Main St··PhoenixArizona85077-4585GRP-1688MEDICARE-ADV-A
ENRENR-1417992026-03-25T10:31:15Zdeb—alvarado28-10-1965UHC-06173-13N/A3038175263deborah.alvarado20@yahoo.com7795 Palm DrMINNEAPOLISMN55448GRP-3382SELECT-EPO··
ENR ENR-1195182026-08-18T05:23:31Z ·RaymondCChen19830610UHC-81169-12•••-••-5136(462) 843-4943raymond.chen21@gmail.com992 Main StJACKSONVILLE·Florida32215GRP-8631CHOICE-PLUS-PPO··
ENRENR-1022452026-01-15T21:15:01ZBrittanyRLe06/11/75UHC9017459•••-••-6855523-939-7428BRITTANY.LE10@GMAIL.COM··2015 Camelback RdScottsdale·AZ85231GRP-1380OPTIONS-PPO
ENRENR-1387672026-01-18T07:51:44ZKEITH····AGUILAR19781016UHC-78507-49•••-••-4321(207) 993-0953keith.aguilar53@outlook.comN/AN/AnullUNKNOWNGRP-9328OPTIONS-PPO
ENRENR-1319982026-05-08T18:55:14Z carolMfreeman1950-09-10UHC-15773-89•••-••-57448808793470carol.freeman55@aol.com7771 Ridge RdScottsdaleAZ85233GRP-1061CHOICE-PLUS-PPO
ENRENR-1236902026-03-17T06:30:56ZHenry D—Herrera1938-02-16UHC-94664-39•••-••-2905821-968-6218henry.herrera@gmail.com···8570 Ocean AveMesa··AZ·85218GRP-8395MEDICARE-ADV-A
ENRENR-1230192026-01-09T05:16:39ZWilliamHPatterson1974-02-18·UHC-70673-52•••-••-6258(966) 248-3732WILLIAM.PATTERSON19@AOL.COM5907 OCEAN AVENUE·Los AngelesCA90015GRP-5114medicare-adv-b
ENRENR-1342522026-08-06T04:02:31ZDiana··Mills02/06/1989UHC-78735-87•••-••-2324(960) 574-2578NULL5029 Union StreetLos AngelesCA90053·GRP-3110MEDICARE-ADV-B
ENRENR-1086512026-09-03T18:00:04ZNancyLAndrews12/26/1983UHC-15983-34•••-••-17359302724103nancy.andrews55@proton.me627 GRAND AVENUEGlendaleAZ85355GRP-2685MEDICARE-ADV-B
ENRENR-1077972026-10-03T16:26:18ZVALENTINASKNIGHT··03/19/1972UHC-33721-28•••-••-9814938.533.1839VALENTINA.KNIGHT41@ICLOUD.COM8232 ELM STMiamiFL33166GRP-2478CORE-HMO
ENRENR-1394372026-01-30T03:40:33ZJoshua·LCastro15-09-1953UHC-29191-46•••-••-4466nulljoshua.castro@hotmail.com6484 Jefferson AveATLANTAGA30355GRP-7190SELECT-EPO
ENRENR-1088142026-05-07T01:00:47Z Janice—Alexander05/23/08UHC-43589-03•••-••-68188874523752janice.alexander83@aol.com8708 CENTRAL AVENUESacramento·CA95832GRP-8747CORE-HMO
ENRENR-1236412026-01-27T22:20:30Z bradley—carroll1955-08-16UHC-36238-02•••-••-4096641-483-5406BRADLEY.CARROLL53@OUTLOOK.COM3597 Union StreetSan Antonio·TX78288GRP-8005SELECT-EPO
ENRENR-1033572026-04-26T01:30:39ZAlexanderA.Wong1995-03-13UHC-68376-71•••-••-8036907-380-5114—·2497 Highland AveTucsonAZ85740GRP-1022medicare-adv-a
ENRENR-1033162026-01-23T00:44:34ZEricWWright1939-06-11UHC-72315-78•••-••-13859046175509ERIC.WRIGHT@OUTLOOK.COM5338 Main St Apt 14MESA·Arizona85239GRP-2680select-epo
ENRENR-1193522026-05-10T18:50:46ZMEI··T.HOWARD07/20/49UHC-96248-06•••-••-41908177628784mei.howard11@aol.com314 PARK PLACE··Phoenix··AZ85043GRP-2400SELECT-EPO
ENRENR-1289912026-02-22T07:58:35ZSantiago—James1945-09-07UHC-43373-39•••-••-7502nullSANTIAGO.JAMES46@ICLOUD.COM6714 Church StDENVERCO80272GRP-5285NAVIGATE-HMO
43,101 rows, page 263 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.417Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty