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-1350322026-02-18T01:39:48ZMATEO—LEE1940-42-24UHC-39222-72•••-••-1699N/Amateo.lee81@hotmail.com9241 Baseline RoadSeattlewa98157GRP-9758core-hmo
ENRENR-1430132026-03-19T10:58:57ZJessica E—Sandoval26-04-1991UHC-21043-30UNKNOWNUNKNOWNJESSICA.SANDOVAL@PROTON.ME5220 Highland AveColumbusOH43210-4173GRP-7511CHOICE-PLUS-PPO
ENRENR-1332282026-09-30T01:54:30ZRICHARDJJENKINS1953-09-25UHC-62559-30•••-••-21404009793863UNKNOWN1374 Forest AveAustinTX78715GRP-0254NAVIGATE-HMO
ENRENR-1346502026-09-30T23:29:53ZJermyOBoyd1997-12-10UHC-68817-15··•••-••-2781973.269.3277jeremy.boyd@gmail.com9081 Lake View RoadMiamiFL33119·GRP-8556MEDICARE-ADV-A
ENRENR-1261872026-07-27T00:49:35ZBurton, RonaldY.—12/05/38UHC-06575-07•••-••-0685(606) 613-1901ronald.burton70@hotmail.com8308 Washington StreetDenverCO80243GRP-2253medicare-adv-b
ENRENR-1138702026-04-03T15:32:51ZJUUSTINDWEVAER01/26/75·UHC-21503-23•••-••-5438(203) 683-5867JUSTIN.WEAVER62@HOTMAIL.COM7373 PALM DRSACRAMENTOCA95870GRP-9308SELECT-EPO
ENRENR-1152592026-09-05T14:34:17ZRuth—MeyerJan 14, 1983UHC-87456-19•••-••-91186576271761ruth.meyer14@yahoo.com7113 Main St··Eden PrairieMN55361GRP-9166SELECT-EPO
ENRENR-1042772026-09-21T04:46:14ZBrenda—Robertson1943-11-07··UHC-15434-80•••-••-697712882367132brenda.robertson@gmail.com·8721 River RoadMinneapolisMN55402GRP-0913NAVIGATE-HMO
ENRENR-1318392026-02-09T14:40:59ZPAMELA—HAYES1967-07-20UHC-15386-32—9569671033PAMELA.HAYES@PROTON.ME3336 Valley View DrAtlantaga30325GRP-8427OPTIONS-PPO
ENRENR-1320372026-05-03T22:49:22ZVIRGINIA—HARPER1971-08-20UHC2858358•••-••-3202+1 743 666 4876-··9462 Valley View Drive #997GlendaleAZ·85387GRP-2026NAVIGATE-HMO
ENRENR-1001142026-10-17T11:49:21Z·NancyBMorrison1972-05-15UHC-87778-78•••-••-8032598.516.4419nancy.morrison@yahoo.com6308 Palm Dr #174Seattle·WA98144··GRP-8495CHOICE-PLUS-PPO
ENRENR-1248872026-03-06T02:42:43ZjosephUschultz··8/16/1973UHC9269354•••-••-8269487-452-5606·joseph.schultz84@outlook.com7373 MAIN STREETLos Angeles··California90039GRP-5791CHOICE-PLUS-PPO
ENRENR-1123492026-02-09T15:42:58ZEthan—Webb1965-03-24UHC-36251-40•••-••-7915760-915-2143ethan.webb@yahoo.com··6790 ELM STHoustonTX77029GRP-9146NAVIGATE-HMO
ENRENR-1381872026-08-09T11:07:30ZRALPH—HOWARD12/26/40UHC-26532-61•••-••-08022154523917RALPH.HOWARD76@ICLOUD.COM9125 Apache Blvd Apt 31GilbertAZ85250GRP-7197NAVIGATE-HMO
ENRENR-1003572026-08-18T03:01:49ZPerez, MateoT··01/11/87UHC-84161-20•••-••-2255228-851-2438MATEO.PEREZ16@AOL.COM3898 Palm DriveDallasTexas75288GRP-1532SELECT-EPO
ENRENR-1158352026-02-03T20:56:28ZAndrea—WeaverSep 2, 2004UHC-37102-61•••-••-8067533.747.1380andrea.weaver@gmail.com7005 UNION STColumbusOHNULLGRP-5996OPTIONS-PPO
ENRENR-1409192026-10-07T09:20:17Z·SHIRLEY····LEE01/13/55UHC-46809-42•••-••-3745—NULL429 Camelback RoadChandlerAZ85230GRP-6089CHOICE-PLUS-PPO
ENRENR-1032022026-03-15T04:32:39ZBishop, DanielleB.····1974-09-14UHC-38178-59•••-••-4646919.344.9787NULL5050 DESERT SKY BLVDHoustonTX77067·GRP-5529MEDICARE-ADV-A
ENRENR-1298232026-03-14T15:29:19ZCARLOSI.EVANS1979-12-27UHC-89882-16··-6617140876carlos.evans53@proton.me···9503 Desert Sky BoulevardPLANO···TX75067-3536GRP-2179MEDICARE-ADV-A··
ENRENR-1136032026-08-21T22:54:39ZMartinez, AbigailY—1967-03-08UHC-84886-97•••-••-218317512522900·ABIGAIL.MARTINEZ56@YAHOO.COM2815 River RoadMesaArizona85212GRP-3004NAVIGATE-HMO
ENRENR-1374762026-10-07T11:39:40ZANGELAOHERRERA1958-01-18UHC-17382-71•••-••-5061(515) 482-2420ANGELA.HERRERA@YAHOO.COM3209 MOUNTAIN VIEW DRFresnoca93716GRP-2012MEDICARE-ADV-A
ENRENR-1062962026-01-11T01:52:25Z·Wright, Christian—···09/08/69UHC-52356-45•••-••-64339665428328null6460 Sage CtTucsonAZ85757GRP-7226OPTIONS-PPO
ENRENR-1054892026-05-19T12:27:42ZJonathanE.Richards19860907UHC-51651-96N/A·(691) 434-2207-4292 Camelback RoadCharlottenc28231GRP-9420··MEDICARE-ADV-A
ENRENR-1394332026-04-04T03:35:07ZLong, Barb····—1963-04-08UHC-77610-75•••-••-8210·8896914770barbara.long85@icloud.com3334 Pine DrNashvilleTN·37223GRP-4927MEDICARE-ADV-B
ENRENR-1167202026-03-21T21:45:33Zlogan—james03-04-1956UHC-60646-20•••-••-57704083337521logan.james@gmail.com2483 WILLOW COURTFresnoCA·93737GRP-5911OPTIONS-PPO
ENRENR-1289272026-09-19T18:52:51ZJoyceIDuncan1994-06-08UHC-27486-99•••-••-23038044194490JOYCE.DUNCAN@GMAIL.COM1676 Baseline Rd·SeattleWA98139-1030GRP-0928·MEDICARE-ADV-A
ENRENR-1315662026-01-06T19:36:43ZannMsims19601004UHC-83699-47•••-••-06632033836811ANN.SIMS65@PROTON.ME7084 Elm StNashvilleTN37232GRP-6682MEDICARE-ADV-B
ENR ENR-1241812026-02-08T17:36:10ZJack—Schultz1958-03-23··UHC-16669-60··•••-••-670615696345222null1433 UNION STREETOrlandoFL32847GRP-6054MEDICARE-ADV-A
ENRENR-1086992026-03-17T02:43:31ZJulie—Burton1953-11-27UHC9680989•••-••-2747+1 683 866 5687··julie.burton7@yahoo.com7290 Central AveOrlando··FL32892GRP-0961NAVIGATE-HMO
ENRENR-1237162026-10-16T01:16:47ZSalazar M—Julie1945-11-07UHC-75947-68•••-••-6054(456) 825-3507·julie.salazar@hotmail.com7977 Forest AveSacramentoCAUNKNOWN·GRP-3876MEDICARE-ADV-A
ENRENR-1413312026-02-08T20:22:19Z RebeccaQJones1967-05-27UHC-46908-53•••-••-31747535833803rebecca.jones36@yahoo.com7642 LINCOLN WAYSeattleWA98182GRP-0894CHOICE-PLUS-PPO
ENRENR-1177932026-06-30T18:08:43ZHayees, Ahmed—··1995-10-01UHC-59600-25··—240.772.3846N/A1557 Baseline RoadFresno··CA93702-8526GRP-4401CHOICE-PLUS-PPO
ENRENR-1398452026-07-11T08:06:10ZRaymond··—Dixon19700821UHC-79273-76•••-••-3813709-692-4889raymond.dixon13@outlook.com··4161 Spring StDallasTX75294GRP-4539medicare-adv-b
ENR ENR-1208172026-02-23T10:08:25ZMaryQMiller10-10-1975UHC-94480-70•••-••-3354+1 664 908 0750mary.miller@icloud.com3851 Cedar LaneHOUSTONTX77027GRP-8374NAVIGATE-HMO
ENRENR-1244442026-09-02T23:10:09ZsusanZalvarez1965-11-01UHC-58484-22•••-••-68218814367108susan.alvarez@proton.me8399 RIVER RD··San Diegoca92108GRP-1759NAVIGATE-HMO
ENRENR-1420392026-04-07T08:03:29ZLAURA—HART·1996-02-09UHC-13512-18•••-••-6187689-914-7239··—4629 Broadway·TucsonAZ85785GRP-4548MEDICARE-ADV-B
ENRENR-1286512026-08-29T11:59:08ZJames—Shaw06/02/59UHC-36302-81•••-••-6989276-637-5529james.shaw70@hotmail.com177 Ocean AveSacramentoCA95887GRP-8567OPTIONS-PPO
ENRENR-137952 2026-03-29T07:20:56ZJEAN—STONE·11/17/95UHC2631957•••-••-8108-jean.stone11@proton.me8896 Sunset BlvdTucson···Arizona85711GRP-9711MEDICARE-ADV-A
ENRENR-1308992026-10-07T15:18:19ZTeresa—Martin·1949-10-15UHC-68819-37•••-••-3165(292) 699-0899·TERESA.MARTIN14@OUTLOOK.COM8826 MESA DRIVESeattleWA98131GRP-2507CHOICE-PLUS-PPO
ENRENR-1168542026-07-17T04:23:08ZYuki—Scott1981-05-13UHC-24168-55•••-••-8313759-860-3511yuki.scott@icloud.com8031 LAKE VIEW RDScottsdaleAZ85212GRP-4228OPTIONS-PPO
ENRENR-132054 2026-05-05T05:19:04ZJORDANAGUERRERO2008-02-22UHC-48042-97•••-••-65433663061jordan.guerrero@icloud.com8988 Cedar LnLos AngelesCA90008GRP-1497MEDICARE-ADV-A
ENRENR-1186702026-04-12T11:24:41ZEdwardHJohnson1939-11-22UHC-76488-67•••-••-31926199938636edward.johnson@gmail.com··202 Lincoln WayGilbertAZ85288GRP-2680MEDICARE-ADV-A
ENRENR-1055072026-03-05T09:48:35ZBRANDON—WHEELER··1991-04-27uhc-86735-24•••-••-5283523.730.7219N/A1886 LAKE VIEW ROADAtlantaGA30395GRP-3391CHOICE-PLUS-PPO
ENRENR-1137232026-05-06T19:20:40ZJOEA.CRAWFORD1963-08-24UHC-30566-32•••-••-8440(744) 577-0247JOSEPH.CRAWFORD28@OUTLOOK.COM4920 Sunset Boulevard·CharlotteNC—GRP-6594··OPTIONS-PPO
ENRENR-1378592026-04-03T21:24:36ZKyleFKelly1961-11-14UHC-76124-01•••-••-6702(413) 390-6145UNKNOWN3440 Park PlaceMiamiFL·33152GRP-1417OPTIONS-PPO
ENRENR-1192982026-06-24T19:21:40ZSANDRA—TAYLOR2006-11-26UHC-73410-51•••-••-4227(486) 278-1967·null93 Church StreetAustinTX78750GRP-5737OPTIONS-PPO
ENRENR-1118702026-03-29T19:55:22ZWayneY··Armstrong2005-12-22UHC-55770-22•••-••-6219-wayne.armstrong@gmail.com·1981 MOUNTAIN VIEW DRColumbusOH·NULLGRP-6033OPTIONS-PPO
ENRENR-1037862026-06-07T14:20:33ZSARAHCREED1980-11-17UHC-18430-46•••-••-0292428-882-6213NULL·6096 Hillcrest RoadTempeAZ85242GRP-5345SELECT-EPO··
ENRENR-1346042026-04-28T14:20:05ZGrant, Carol——1939-07-13UHC-58128-35•••-••-32672563778166CAROL.GRANT88@OUTLOOK.COM9824 Sunset BlvdSAN DIEGOCA92139GRP-3592CHOICE-PLUS-PPO
ENRENR-1185572026-03-18T01:15:02ZJESSCAJBARNES1985-08-04UHC-72934-50•••-••-71745478143272jessica.barnes@hotmail.com·2452 Oak StDallastx75209-9087·GRP-7484CHOICE-PLUS-PPO
43,101 rows, page 320 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.614Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty