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-1428172026-10-01T13:07:44ZJacquelineXRogers1972-07-03UHC-40625-48··null(917) 858-7586jacqueline.rogers57@outlook.com8721 Ridge RoadScottsdaleAZ85297GRP-1462NAVIGATE-HMO
ENRENR-1282982026-03-13T01:06:05ZMarkSSilva1987-12-04UHC6051326-+1 905 856 2644····7641 Ocean AveChandlerAZ85251GRP-3362··CORE-HMO
ENRENR-1407362026-03-12T23:13:46ZDaniels, Chritsian··——3/19/1983UHC-49258-37•••-••-2513901-384-2880UNKNOWN3457 Union StLOS ANGELESCA90059GRP-2282MEDICARE-ADV-A··
ENRENR-1239852026-10-16T00:49:11ZSara—Grant01/24/1987UHC-93199-12N/A··12103494927sara.grant@yahoo.com··5202 Cedar LanePlanoTX75050··GRP-0486CORE-HMO
ENRENR-1174882026-09-26T23:45:07ZRyanPOliver1938-02-21UHC-22699-46•••-••-2185(391) 288-4283null··6924 Valley View DriveTempeAZ85214GRP-5094NAVIGATE-HMO
ENR ENR-1402092026-09-05T21:36:27ZWILLIE—SOTO2006-09-19UHC5360087•••-••-73689745816681WILLIE.SOTO@ICLOUD.COM··8204 CENTRAL AVENUESCOTTSDALE··AZ85249-8479GRP-1164NAVIGATE-HMO
ENRENR-137925 2026-06-08T02:44:44ZSHIRLEYPSIMS19551016UHC-17492-34•••-••-0353N/Ashirley.sims95@gmail.com6513 Sunset BoulevardGilbertAZ85201GRP-8959core-hmo
ENRENR-128471 2026-02-05T13:10:02ZDON··FOWLER2007-08-25UHC-43583-77—(910) 284-8990—1038 MAPLE AVENUEMiamiFL33197GRP-8089MEDICARE-ADV-A
ENRENR-1020962026-08-18T03:59:33ZArthurX.Woods1949-02-10UHC-87342-43•••-••-8399508-805-5760ARTHUR.WOODS27@PROTON.ME7951 Canyon Road Apt 32ChandlerAZ85217GRP-6476MEDICARE-ADV-A··
ENRENR-1399932026-03-09T05:01:48ZDonna—Montgomery··19780621UHC6998827•••-••-7369+1 759 819 1298·donna.montgomery27@proton.me·2654 RIVER ROADPhoenixAZ85095GRP-1380CHOICE-PLUS-PPO··
ENRENR-1319742026-08-27T19:44:59ZAngela—Coleman1928-06-02uhc-49296-52——angela.coleman@hotmail.com38 Lincoln Way·SacramentoCA95830GRP-3614SELECT-EPO
ENRENR-1243052026-08-15T22:47:35ZTylerP.Perez2008-08-23UHC-99222-11•••-••-9629683-977-2929tyler.perez@outlook.com5578 Bayshore DrATLANTAGA30305GRP-1958··OPTIONS-PPO
ENRENR-1397972026-09-14T23:37:52ZSOFIAY.·BOWMAN1964-11-20UHC-32544-49•••-••-26196384139UNKNOWN3843 Baseline RoadScottsdaleArizona··—GRP-3659options-ppo
ENRENR-1416842026-08-15T02:10:15ZAshley—Singh1989-04-01UHC-07698-10•••-••-7574··ashley.singh@yahoo.com2149 DESERT SKY BLVDTucsonAZ85766GRP-6312CORE-HMO
ENRENR-1311502026-01-22T04:00:21Z Black, Jeremy—····26-06-1991UHC-57324-01•••-••-7748331-381-7603—6364 Harbor BlvdMesaAZ85292GRP-6275··MEDICARE-ADV-B
ENRENR-1272532026-09-21T11:20:29ZShaw, AshhleyQ.—1989-09-26UHC-49013-03•••-••-3929401-586-2592ashley.shaw@proton.me3813 INDIAN SCHOOL ROADHoustonTX77046GRP-0154MEDICARE-ADV-A
ENRENR-1391442026-07-24T17:58:51ZSAMUEL·LDANIELSNov 16, 1977N/A•••-••-0481872-777-0271UNKNOWN8484 Meadow LnTampaFL33641-4598GRP-7152SELECT-EPO
ENRENR-1052952026-08-01T08:34:45ZYUKIF.GRIFFIN1995-09-12·null—(976) 274-1990yuki.griffin97@outlook.com··2759 WASHINGTON STSacramento··CA95805-8869GRP-3933OPTIONS-PPO
ENRENR-1217012026-08-22T12:56:40ZCHRISTIAN··T··FERGUSON·Aug 19, 1949UHC-15332-76•••-••-5610(486) 958-3442CHRISTIAN.FERGUSON@YAHOO.COM7562 INDIAN SCHOOL RDFresno··CA93733-3142GRP-9004options-ppo
ENRENR-1028642026-07-15T21:21:05ZWILLIAM—TAYLOR·2007-10-14UHC-44116-66•••-••-1748971-494-4605··N/A··5581 Ridge RdLas VegasNV··89142GRP-7833NAVIGATE-HMO
ENRENR-1407192026-05-25T08:53:10ZPaul··IOBrien1946-06-15··UHC-02729-37•••-••-4220UNKNOWNPAUL.OBRIEN46@OUTLOOK.COM9081 BroadwayDENVERCO80282GRP-2755CHOICE-PLUS-PPO
ENRENR-1418102026-09-22T08:31:37ZAlan··GGuzman1939-12-13UHC-08812-07N/A+1 417 889 5294ALAN.GUZMAN@PROTON.ME6807 Sage CourtORLANDOFL·32829GRP-4256OPTIONS-PPO
ENRENR-1342592026-01-27T22:32:51Z·ruth—mendoza05/11/1961UHC-36365-03•••-••-3477+1 619 424 9710—3466 Ocean AvenuePhoenixAZ85069GRP-6420SELECT-EPO
ENRENR-1107452026-05-21T00:52:07ZKathryn··—Cook1991-07-01UHC-98013-38•••-••-2571300.914.7958kathryn.cook@gmail.com-UNKNOWNUNKNOWN—GRP-7366·MEDICARE-ADV-A
ENRENR-1116522026-05-28T06:39:12ZGLORIA·V.KING1974-01-14UHC-75859-42-5122920811—9840 Spring St··HoustonTX77055GRP-8504SELECT-EPO
ENRENR-1193372026-08-04T04:04:45ZRonaldP··Jensen1993-08-18·UHC-79968-76•••-••-7623(536) 569-7663RONALD.JENSEN@HOTMAIL.COM6948 ELM STFRESNOCA93771GRP-6517MEDICARE-ADV-B
ENRENR-1056962026-03-28T03:12:25ZMason—Morales1953-02-70UHC-84582-98•••-••-1006796-603-5630MASON.MORALES95@GMAIL.COM2969 SAGE COURT··LOS ANGELESCA90042GRP-7274core-hmo
ENRENR-1338412026-03-14T02:49:46ZScottZDuncan1970-06-06UHC-34340-60•••-••-7686·(201) 442-1258·SCOTT.DUNCAN35@GMAIL.COM71 Bayshore Dr Apt 3·Los AngelesCA···90071GRP-0102CORE-HMO
ENRENR-1248472026-09-29T06:12:21Z Joseph—Greene··1984-02-23UHC-40015-39•••-••-1138325-719-5855joseph.greene@icloud.com7639 Canyon Road·Los AngelesCA90018GRP-5762NAVIGATE-HMO
ENRENR-1140772026-01-02T22:14:21ZANTHONYXBURTONNov 9, 1955UHC-76511-82•••-••-6990+1 922 634 0929anthony.burton@outlook.com—UNKNOWN-—GRP-1863NAVIGATE-HMO
ENRENR-1243792026-02-17T12:10:25Z·douglasAcuningham·1943-09-28UHC-40488-95•••-••-3348689.604.2034douglas.cunningham85@proton.me4245 Camelback RoadSAN DIEGOCA92189GRP-6475CORE-HMO
ENRENR-1189722026-07-17T16:31:56ZWalter··Andrews1962-06-20UHC-25990-64-972-595-0422—7531 OCEAN AVENUEPhoenixAZ··85084GRP-2330MEDICARE-ADV-A
ENRENR-1099312026-03-13T06:14:33ZLAURA—BAKER1972-07-17UHC-35298-05•••-••-69269398397laura.baker93@aol.com6997 SUNSET BOULEVARDORLANDOFL32879··GRP-8315CORE-HMO
ENRENR-1218822026-06-11T05:56:59ZHANNAH·KMCDONALD12/15/1947UHC-37231-04•••-••-8226380-212-4342—6505 ELM STREETTampaFL33608GRP-9916·NAVIGATE-HMO
ENRENR-1136422026-06-21T20:16:47ZMATTHEW—PEREZ·1960-08-09UHC-75217-59•••-••-976316827098770matthew.perez61@yahoo.com4081 Lake View RoadAustinTX··78734GRP-6910CHOICE-PLUS-PPO
ENRENR-1373402026-08-15T10:42:07ZLISA—ELLIOTT1988-08-19··UHC-42505-65UNKNOWN(773) 254-7080lisa.elliott@aol.com9680 MARKET STREETSEATTLEWA98131GRP-8784MEDICARE-ADV-A
ENRENR-1018252026-05-10T07:07:35ZLopez, BillyM.—1955-10-08UHC-82058-85•••-••-16394153972520BILLY.LOPEZ@ICLOUD.COM··9153 Spring St··MESAAZ85288·GRP-3171MEDICARE-ADV-A
ENR ENR-1204792026-06-22T05:41:32ZKATHRYNTDUNN2003-01-17UHC-91234-39··•••-••-2054758-932-5966kathryn.dunn@gmail.com6922 PARK PLACEDENVERCO80261GRP-7919OPTIONS-PPO
ENRENR-1149222026-01-09T18:49:04ZPeggyY.Roberts1962-05-20UHC-10370-08•••-••-8564NULLmargaret.roberts@icloud.com6363 Highland Ave Apt 30Los AngelesCA90039GRP-8307NAVIGATE-HMO
ENRENR-1273762026-02-28T06:07:36ZElizabethIWallace6/8/1976UHC-00524-84•••-••-8265·18558049065elizabeth.wallace1@outlook.com6933 Oak StreetHoustonTexas77028GRP-5379CORE-HMO
ENRENR-1290212026-09-07T04:36:07ZHenryOClark19850423UHC-79767-43•••-••-6097(824) 907-5055HENRY.CLARK@YAHOO.COM7061 Canyon RdCOLUMBUS·OH43272-1112GRP-2185OPTIONS-PPO
ENRENR-1150532026-09-06T18:29:28ZNunez, Jack·J—1941-11-25UHC-98297-44•••-••-0142(596) 440-7584NULL337 Lake View Road Apt 8·NASHVILLETN37249-5115GRP-1276CORE-HMO
ENRENR-1410012026-10-16T15:05:50Zmadison—flores1989-04-22UHC-85495-26•••-••-10344135983004madison.flores@yahoo.com2683 PARK PLSeattle·WA98119GRP-3526MEDICARE-ADV-B
ENRENR-1137432026-07-18T23:42:30ZRoyMCrawfordJun 4, 2004UHC-12133-87—856-486-5015N/A1696 Park PlMesaAZ85297GRP-6464SELECT-EPO
ENRENR-1426482026-10-06T23:25:10Zkelly··—gonzalez1990-11-16·UHC-45875-06•••-••-8784867-553-1899KELLY.GONZALEZ@HOTMAIL.COM—N/A-N/AGRP-2548··SELECT-EPO
ENRENR-1189042026-06-02T16:31:10Z DIANE—WEAVER·12-05-1964UHC-06730-84•••-••-0420652-384-9284diane.weaver@outlook.com2791 Maple Avenue Apt 3AtlantaGeorgia30319GRP-3611MEDICARE-ADV-B
ENRENR-1378472026-04-20T16:56:12ZSilva, SofiaG—03/10/1988UHC-76570-40•••-••-3002240-356-3067-··4216 Lincoln WayEden PrairieMN55397GRP-8556MEDICARE-ADV-A
ENRENR-1301842026-05-09T17:56:03ZJanice—Rice2006-06-26··UHC1186152-406-859-9559—7691 Forest AvenueGlendaleAZ85325GRP-7509MEDICARE-ADV-A
ENRENR-1190532026-02-18T02:23:12ZjeanAmarquez1976-10-18UHC-24571-43•••-••-0569(525) 899-6880JEAN.MARQUEZ@AOL.COM5307 Desert Sky BlvdCOLUMBUSOH43220GRP-6328OPTIONS-PPO
ENRENR-1407972026-05-28T09:27:55ZMADISON—JOHNSON1985-03-26uhc-26396-77•••-••-6456nullmadison.johnson15@hotmail.com1279 BroadwayTUCSONArizona85702GRP-2168MEDICARE-ADV-B
43,101 rows, page 331 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.626Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty