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
ENR ENR-1037682026-06-23T18:34:23ZZachary··A·Wheeler1991-01-13UHC-43929-28•••-••-4542+1 299 318 5230zachary.wheeler20@aol.com3086 Sage CourtMesaArizona85243GRP-3528MEDICARE-ADV-A
ENRENR-1249792026-03-24T07:28:09ZPowell, SamuelF.····1952-04-19UHC-90652-31•••-••-1780(326) 334-8253SAMUEL.POWELL@PROTON.ME7828 Willow Ct·SCOTTSDALEAZ—·GRP-4852OPTIONS-PPO
ENRENR-1230122026-03-17T22:22:13ZPATRICIAR.—08/25/92UHC-68939-94•••-••-3082908.976.1394patricia.sandoval77@gmail.com5270 Highland AvenueChandlerAZ85227GRP-5647MEDICARE-ADV-A
ENRENR-1038872026-07-28T23:22:39ZSaraO.YangMay 7, 1990UHC-30052-60•••-••-69776386788933SARA.YANG@PROTON.ME2605 PARK PL··ATLANTAGA30351GRP-8430CORE-HMO
ENRENR-1000992026-07-17T18:53:15ZAARONWWEBBOct 7, 2008UHC-75621-63··•••-••-83484588466333·UNKNOWN6397 GRAND AVENUETempeAZ·85260GRP-8847CORE-HMO
ENRENR-1407672026-03-25T09:29:33ZPHILIP—RUSSELL2000-05-17UHC-68991-80•••-••-9967(581) 373-2144UNKNOWN1105 Maple AvenueTAMPAFL33676GRP-5365NAVIGATE-HMO
ENRENR-1068422026-05-18T11:40:09Zjanice··jenkins05-05-1966UHC-48581-90•••-••-9299775-733-8773janice.jenkins@proton.me8757 Highland AveScottsdaleAZ85226GRP-7354CHOICE-PLUS-PPO
ENRENR-1324052026-05-27T07:41:26ZCHARLESW.REEID1969-06-14··UHC-11944-53•••-••-73303702182011charles.reid@proton.me3202 Lincoln WayTEMPEAZ85211-8426GRP-1066··OPTIONS-PPO
ENRENR-1399352026-05-01T17:38:22ZValentinaTGuerrero1977-09-18UHC-71193-02N/A(568) 666-8856valentina.guerrero@icloud.com7765 Grand Avenue #115ColumbusOH43232GRP-1522·OPTIONS-PPO
ENRENR-1186932026-07-16T15:53:59ZJuan··Gutierrez1975-02-27UHC-97030-07•••-••-7176709.913.4689juan.gutierrez68@outlook.com4751 Washington StreetLas VegasNevada89139GRP-5447MEDICARE-ADV-B
ENRENR-1375082026-08-25T00:39:35ZLauraZJacobs3/21/1986UHC-87411-82•••-••-4240791-922-6255LAURA.JACOBS19@OUTLOOK.COM··2503 Lincoln WayAtlantaGA30384GRP-5449MEDICARE-ADV-B
ENRENR-1398212026-05-11T09:00:48ZAnn—Williamson1963-02-12UHC-79164-18•••-••-59385907757710ann.williamson@outlook.com567 Meadow LaneAtlantaGeorgia30322-4503GRP-9039MEDICARE-ADV-B··
ENRENR-1307002026-02-14T17:24:20Z JEANOHOLES··1977-09-23··UHC-90160-52•••-••-6418(808) 572-8724JEAN.HOLMES42@PROTON.ME··-NULL··UNKNOWNGRP-8680CHOICE-PLUS-PPO
ENRENR-1380802026-01-24T20:29:20ZBRITTANYA··CLARK1939-07-10··UHC-13013-67·N/A3792207980—4887 River RdSEATTLEWA98184GRP-4130choice-plus-ppo
ENRENR-1331892026-04-03T01:20:50Zlogan—campbell1983-12-26UHC-12459-58··•••-••-02913486926379·logan.campbell98@icloud.com201 Central AveAtlanta·GA30336··GRP-0245CORE-HMO
ENRENR-1180452026-02-10T08:20:02ZSaraT·Cruz1946-01-02···UHC-66353-35•••-••-9074(687) 287-8295—2076 Elm StreetScottsdaleAZ85274GRP-9343SELECT-EPO
ENRENR-1234832026-08-13T17:02:23ZMichaelQSantiago03/19/82UHC-18032-12•••-••-7869247-294-4322michael.santiago89@hotmail.com6144 Indian School Road #650ATLANTAGA30313GRP-4560MEDICARE-ADV-B
ENRENR-1270402026-09-24T11:00:21ZRichards, Kevin·G—12/08/63UHC-68933-71•••-••-3662309-777-8767kevin.richards38@aol.com8866 Union StreetLos AngelesCA90044GRP-5208SELECT-EPO
ENRENR-1290462026-04-28T06:38:19Z Anderson, Matthew——1991-06-22UHC-25095-70•••-••-4010(955) 368-1219matthew.anderson45@aol.com1620 BroadwayTAMPAFL33697-1285GRP-3901MEDICARE-ADV-B
ENR ENR-1423672026-01-30T02:56:26ZCHRISTOPHERY.JIMENEZ1997-02-09UHC-76682-92··-4459913882christopher.jimenez76@gmail.com4012 MOUNTAIN VIEW DRScottsdaleAZ85241GRP-3835MEDICARE-ADV-B
ENRENR-1260152026-04-18T14:45:58ZCoopar, Alan——17-10-2001UHC-35629-61•••-••-0784955.500.1573ALAN.COOPER@YAHOO.COM8530 CANYON ROADLas VegasNV89175GRP-4387SELECT-EPO
ENRENR-1422812026-06-10T04:52:39ZOrtiz, Justin——01/21/79UHC8575715•••-••-90982407956489JUSTIN.ORTIZ90@YAHOO.COM·6818 Ridge RdCharlotteNC··28209GRP-0753select-epo
ENRENR-1181772026-08-18T07:03:25ZJudith·PCooper11/05/87UHC-87105-36—688.730.1195JUDITH.COOPER@GMAIL.COM1575 Pine DrJacksonvilleFL32210GRP-7302MEDICARE-ADV-A
ENRENR-1015022026-06-27T19:50:32ZNatalie—Chavez1950-11-12UHC-93945-67•••-••-860714102128078NATALIE.CHAVEZ24@PROTON.ME2832 Jefferson AvenueAustinTX78789-5489GRP-7994MEDICARE-ADV-A
ENRENR-1157152026-06-22T08:47:59ZDEBORAHV.·GOMEZ1998-09-10UHC1390247•••-••-4965263-634-4023deborah.gomez@proton.me7563 Canyon RdAtlantaGA30397GRP-3315MEDICARE-ADV-A
ENRENR-1310582026-08-31T22:29:21ZJACQUELINE—WANG06/12/50UHC-56688-73•••-••-4987N/Ajacqueline.wang@aol.com3858 Park PlMiamiFL·33108GRP-7604MEDICARE-ADV-B
ENR ENR-1063962026-08-11T13:06:14Z ·FRANK—RICHARDS20-06-1949UHC-87366-39•••-••-9031——7427 Union StChandleraz85261GRP-1344SELECT-EPO
ENRENR-1123742026-01-16T11:21:56ZIsabella··—Berry19450401UHC-10949-47•••-••-1932·686-392-8550—8659 Sage CourtTucsonArizona85722-0803GRP-0979MEDICARE-ADV-A
ENRENR-1249842026-03-14T04:29:53ZLogan—Luna1942-09-06UHC-90592-70•••-••-980118793092186logan.luna@aol.com8848 Cedar LnScottsdaleAZ85297GRP-6855MEDICARE-ADV-A
ENRENR-1345152026-07-30T01:52:25ZOmarNWeaver2001-02-28UHC-71491-85•••-••-548217039799708omar.weaver63@outlook.com4595 SAGE COURTFRESNOCalifornia93782GRP-1335NAVIGATE-HMO
ENRENR-1298562026-04-19T19:19:36ZTerry—Walsh1960-07-19UHC-43582-43•••-••-603218695095746terry.walsh@gmail.com1234 Desert Sky Blvd Apt 22Los AngelesCA90071-9802GRP-7206OPTIONS-PPO
ENRENR-1381482026-07-06T23:12:20ZEmilyURamirez1959-12-05UHC-37730-93•••-••-7837579-331-2324emily.ramirez@gmail.com2364 BroadwayTempeAZ85294GRP-9873CORE-HMO
ENRENR-1156742026-04-12T13:56:02ZjudyYmccooy1962-11-06UHC-96024-70•••-••-2178(442) 887-9655-975 SUNSET BLVDDallasTX75269GRP-0358OPTIONS-PPO
ENRENR-1365902026-01-19T08:32:39ZRyanBLane10/18/1990UHC-41604-71•••-••-5185313.413.8409·ryan.lane@hotmail.com8855 Park PlSeattleWA98134·GRP-9640CHOICE-PLUS-PPO
ENRENR-1101522026-02-24T23:03:20ZWAYNE—MATTHEWS2002-04-24UHC-65459-63•••-••-9582+1 431 329 0000WAYNE.MATTHEWS13@AOL.COM3219 Desert Sky Boulevard··LOS ANGELESCA··90027GRP-2598CHOICE-PLUS-PPO
ENRENR-1197272026-07-29T00:03:51ZCheryl—Castro1950-02-04UHC-39022-48•••-••-30394342305814cheryl.castro33@proton.me570 BroadwayPHOENIXArizona85002GRP-7936··CHOICE-PLUS-PPO
ENRENR-1176832026-04-01T10:28:05ZWRIGHTUJOSHUA3019-19-65UHC-71174-31N/A3802215070joshua.wright33@hotmail.com··7265 Desert Sky BlvdChandlerAZ85273GRP-4976NAVIGATE-HMO
ENRENR-1175872026-01-28T12:49:33ZCAMILABSNYDER11/11/51UHC-68703-09•••-••-84593255531780camila.snyder@hotmail.com8443 Valley View Dr··AustinTexas78762GRP-6596CHOICE-PLUS-PPO
ENRENR-1322282026-07-19T07:16:29ZValentina—Kennedy08/06/43UHC-03137-73•••-••-961813525145253valentina.kennedy75@outlook.com5500 Ocean AvenueGlendaleArizona85369GRP-3682SELECT-EPO
ENRENR-1176492026-09-24T05:52:57ZJohnston, Jason——Jul 21, 1987UHC-86002-96•••-••-1146(965) 565-5802jason.johnston89@hotmail.com5392 HIGHLAND AVESan DiegoCA92102-9254GRP-0375SELECT-EPO
ENRENR-1227362026-06-18T09:48:48ZRICHARD·NYANG2030-02-05UHC-13935-20•••-••-8422N/ARICHARD.YANG97@YAHOO.COM··5832 Jefferson AveFresnoCA93795GRP-9975·OPTIONS-PPO
ENRENR-128599 2026-09-22T04:18:47ZKatherineZ.Wilson··1991-03-22UHC6526865•••-••-62395943182924katherine.wilson@yahoo.com··9140 Union StreetNashvilleTN37272GRP-8069SELECT-EPO
ENRENR-1353822026-07-26T08:43:49ZdylaanQsanders··1945-01-11UHC-30628-72•••-••-52387538175011dylan.sanders@aol.com8412 BroadwayMIAMIFL33164GRP-8185··MEDICARE-ADV-B··
ENRENR-135262 2026-04-15T09:16:02ZAHMED—MURRAY··20050622UHC-20996-25•••-••-7460685-223-6051ahmed.murray6@icloud.com2167 Hillcrest RdAustinTX··78777GRP-1191MEDICARE-ADV-B
ENRENR-1208072026-08-31T08:00:29ZCHARES—WALKER1520-19-52UHC-36240-36•••-••-69474335898997charles.walker32@yahoo.com2543 Oak StOrlandoFL··32828GRP-6625CHOICE-PLUS-PPO
ENRENR-1162692026-08-03T09:30:38ZHEATHER··BERRY1949-09-19uhc-91586-85•••-••-0812842.708.4547heather.berry@yahoo.com1192 HILLCREST ROADScottsdaleAZ85284GRP-7481SELECT-EPO··
ENRENR-1018842026-01-13T15:19:45ZALBERT·VCASTRO1982-05-10··UHC-91693-71•••-••-6153(390) 344-3809albert.castro20@icloud.com··3576 Desert Sky BlvdSacramentoCA-GRP-0454medicare-adv-a
ENRENR-1024732026-05-31T18:00:43Z ·AishaFWeaver10/25/99UHC4571340NULL-AISHA.WEAVER20@HOTMAIL.COM6879 JEFFERSON AVELas VegasNevada89110GRP-6697MEDICARE-ADV-B
ENRENR-1142162026-04-27T22:53:46ZEDWARDYDANIELS1985-10-27UHC-52432-11•••-••-2386334-317-2163edward.daniels97@yahoo.com8035 Central AvenueTampaFL33615GRP-8906MEDICARE-ADV-B
ENRENR-1352502026-08-24T03:07:19ZJORDAN··—FERGUSON1942-00-69UHC-68665-03•••-••-6251·(325) 491-9247·UNKNOWN6753 SAGE COURTSeattleWA98133GRP-4330MEDICARE-ADV-B
43,101 rows, page 86 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:36.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty