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-1189962026-06-15T01:48:37Z Nicole—Banks1996-12-26UHC-03903-87•••-••-319415514045899nicole.banks@gmail.com2517 Mountain View DrMesaAZ85200GRP-5995CORE-HMO
ENRENR-1284732026-01-27T13:05:33Zhelen—henry1950-07-05UHC-47591-64•••-••-330516467528838NULL588 Central AvenueLOS ANGELESCA90092GRP-2044OPTIONS-PPO
ENRENR-1296802026-05-16T07:23:55ZGary··Myers··1981-04-13UHC-24954-02—(529) 223-9926—5636 Ridge RdFRESNOCalifornia··93701GRP-6479SELECT-EPO
ENRENR-1335422026-04-13T09:37:58ZLoganRGibson1961-12-08UHC-11992-08•••-••-6618554-902-5162N/A5444 Union StreetSacramentoCA95815GRP-6159SELECT-EPO
ENRENR-1209722026-10-14T20:28:06ZRussell·UJimenez26-08-1972UHC-20971-83•••-••-3723331-714-0263russell.jimenez64@aol.com8370 Harbor BlvdATLANTA··GA—GRP-7029CORE-HMO
ENRENR-1163462026-04-26T09:53:48Z Jason S.—Wang1998-11-22UHC-62361-29•••-••-53478538654878··jason.wang@gmail.com6287 Washington Street··HOUSTON·TX77024··GRP-5261CHOICE-PLUS-PPO
ENRENR-1017952026-03-17T20:24:01Z kaylaV.mendez20-11-2006·UHC-70644-98•••-••-08268705351750—9792 MEADOW LNSan AntonioTX78217·GRP-4879NAVIGATE-HMO
ENRENR-1186382026-03-04T21:48:07ZDANIELLEVADREWS2006-04-02UHC-00916-15•••-••-8618(588) 832-8982DANIELLE.ANDREWS@AOL.COM621 LINCOLN WAY···ScottsdaleAZ85265GRP-0583OPTIONS-PPO
ENRENR-1273402026-10-18T21:38:08ZAguilar, DianeL—1956-07-17UHC-44282-26•••-••-86108316017296DIANE.AGUILAR@HOTMAIL.COM2266 Park PlSacramentoca··UNKNOWNGRP-2865navigate-hmo
ENRENR-1084242026-04-14T10:42:12ZChristina—Dominguez1943-07-16UHC5510853•••-••-9086(241) 633-6743CHRISTINA.DOMINGUEZ29@YAHOO.COM2619 Highland AvenuePhoenixAZ·85069GRP-2871OPTIONS-PPO
ENRENR-1290192026-02-08T21:04:32ZPamela—Sullivan1963-04-28UHC-72817-47··•••-••-40067663120309PAMELA.SULLIVAN@OUTLOOK.COM5284 Harbor BoulevardMiamiFL··33144GRP-7763SELECT-EPO
ENRENR-1222112026-08-07T03:54:05Z·Tucker, DouglasQ.—1971-11-13UHC-69945-91•••-••-39236739321900douglas.tucker12@proton.me7086 Cedar LnSan AntonioTexas78281GRP-2653MEDICARE-ADV-B
ENRENR-1119392026-07-21T07:21:28ZEMILYWMURRAY08/23/1963UHC-02083-82•••-••-2768(901) 566-4820emily.murray@outlook.com7357 Mesa DrAustinTexas78760GRP-8609CHOICE-PLUS-PPO
ENRENR-1068812026-06-05T03:36:52ZRANDY····NICHOLS25-09-2004UHC-80809-06•••-••-2628(604) 871-1724randy.nichols@yahoo.com3698 Forest AvenueScottsdaleAZ·85243GRP-8506SELECT-EPO
ENRENR-1393722026-06-30T02:45:50ZROGERDKELLEY01/26/69UHC-99844-35•••-••-21726528001976roger.kelley32@yahoo.com8484 CANYON ROADMesaaz85248GRP-1720OPTIONS-PPO··
ENRENR-1323242026-03-22T12:04:12ZRachelN.Daniels1994-12-06·UHC5388676•••-••-97459305162541—1557 Cedar LnSAN ANTONIO··TX··78225GRP-1329SELECT-EPO
ENRENR-1418672026-08-06T16:16:33ZMARIANA—LITTLE19430905UHC-08311-83•••-••-9748·UNKNOWNmariana.little@icloud.com4453 Market StCHANDLER·AZ85286GRP-7316MEDICARE-ADV-B
ENRENR-1388892026-06-24T20:42:13ZSantiago I—Sanchez1984-05-28··UHC-26057-10•••-••-6990(615) 525-7468santiago.sanchez40@outlook.com·4447 Canyon RoadSan DiegoCA92171GRP-6358CORE-HMO
ENRENR-1164192026-06-03T18:57:46ZGrace····Welch1939-04-17UHC-28155-26N/A··527.773.8860grace.welch86@proton.me··1665 Desert Sky Boulevard··AtlantaGA30390··GRP-8626MEDICARE-ADV-B
ENRENR-1421572026-05-07T20:38:46ZBarbara—·Willis1983-05-09UHC-77515-78•••-••-7780(886) 976-8059barbara.willis93@proton.me8672 Washington StPlanoTexas-GRP-1078NAVIGATE-HMO
ENRENR-1416392026-08-02T03:04:51ZRios, DylanT—1963-10-11UHC-19892-73•••-••-053818959144169dylan.rios66@outlook.com2747 SUNSET BOULEVARDPhoenixAZ85033GRP-5809NAVIGATE-HMO
ENRENR-1045082026-08-22T12:57:53ZAndrea—Scott··Feb 12, 1947UHC-70977-09··•••-••-6606·5432865021ANDREA.SCOTT@AOL.COM2266 Lincoln Way Apt 22ChandlerAZ··85274GRP-5913SELECT-EPO
ENRENR-1104022026-07-07T05:42:13Zjeremy—nunez26-02-1971UHC-54560-44•••-••-0300(764) 238-2750N/A8260 Lincoln WayNashvilleTN37271-4751GRP-1735CHOICE-PLUS-PPO
ENRENR-1289032026-09-30T10:08:31Z·Rose, StephenD—nulluhc-80010-57•••-••-6832UNKNOWN—8862 Park PlPlanoTX75069GRP-6350·SELECT-EPO
ENRENR-1039302026-01-11T03:58:31ZMorales, Keith——1973-08-27UHC-51608-34•••-••-4885—KEITH.MORALES@YAHOO.COM8899 Park PlaceLas VegasNV89194GRP-8759NAVIGATE-HMO
ENRENR-1322172026-10-02T20:50:33ZAlexander, Mei——1941-04-04UHC2164314•••-••-5719924.271.5819mei.alexander@icloud.com9152 CAMELBACK ROADJacksonvilleFL32279··GRP-3254CORE-HMO
ENRENR-106183 2026-07-01T08:58:24ZmarthaEgarrett1938-08-15UHC-05777-33•••-••-5994688-732-0887martha.garrett@hotmail.com7161 Union St Apt 17JacksonvilleFL32231GRP-3188SELECT-EPO
ENRENR-1283532026-01-15T07:33:53ZSamantha—Dominguez27-01-1983UHC-55189-26•••-••-8836+1 310 302 3238··NULL1012 Bayshore Drive #259ColumbusOH43249GRP-6630MEDICARE-ADV-B
ENR ENR-1392032026-05-13T03:10:32ZDIEGOMKNIGHT1939-10-11UHC-87115-85-311-528-4149DIEGO.KNIGHT@ICLOUD.COM··7285 VALLEY VIEW DRIVEDALLAS··TX75271GRP-5073SELECT-EPO
ENRENR-1054292026-05-19T10:28:32Z ZACHARY··R.LUNA3/4/1949UHC-56365-90•••-••-2682(499) 382-5921—8165 Harbor BoulevardGlendaleAZ85350GRP-7241SELECT-EPO
ENRENR-1189622026-02-15T09:29:34ZCHRISTIANDORTEGA19891028UHC-60388-18•••-••-7825368.361.9780UNKNOWNUNKNOWNNULL——GRP-7093·OPTIONS-PPO
ENRENR-1325172026-10-14T21:39:29ZKelly—·Carpenter2004-07-26UHC-64131-81•••-••-4358+1 901 559 7621kelly.carpenter@outlook.com9304 Mountain View DriveORLANDOFlorida··32878GRP-0812SELECT-EPO
ENRENR-1007982026-06-20T09:45:34ZALAN—CONTRERAS1939-06-09UHC9686671•••-••-5516539.429.1294alan.contreras29@gmail.com··7196 BAYSHORE DRIVETampa·FL33627GRP-7998CHOICE-PLUS-PPO
ENRENR-1367892026-07-19T10:48:00ZSharon·KTorres1996-03-18UHC-27817-88•••-••-5806(258) 728-1043SHARON.TORRES22@AOL.COM2398 Highland Ave #363DallasTX75299GRP-8284SELECT-EPO
ENRENR-1386942026-05-30T14:20:15ZMELISSA—SOTO2005-02-14UHC-93543-82•••-••-5540364-525-1963-8505 Valley View DriveEden PrairieMN55350GRP-2615OPTIONS-PPO
ENRENR-1367702026-05-25T00:58:15Zdonald—santos91590811UHC-53519-21•••-••-7641+1 511 516 1080DONALD.SANTOS39@YAHOO.COM2431 Indian School RoadColumbusOhio43292GRP-9094MEDICARE-ADV-B
ENRENR-1206052026-06-22T11:37:05ZRonaldJ.Wilson1978-08-14UHC-62608-94•••-••-4621863.560.6194NULL7705 Desert Sky Boulevard·OrlandoFL32822GRP-7036MEDICARE-ADV-B
ENRENR-1016612026-10-17T11:31:46ZChristopher—Coleman1950-04-12UHC-32322-15•••-••-6233597.288.6469null1911 OCEAN AVEMIAMIFL··33172··GRP-3054SELECT-EPO
ENRENR-1411852026-02-12T02:06:01ZCook, Kyle——2001-09-07UHC-25023-44•••-••-448212166147611N/A9327 BroadwaySCOTTSDALEAZ85241GRP-3240MEDICARE-ADV-B
ENRENR-1048192026-09-20T15:37:14ZKarenCSanders1938-12-05UHC-22618-73•••-••-1217(583) 394-0764KAREN.SANDERS15@PROTON.ME2097 Union StreetChandlerAZ85273GRP-2110SELECT-EPO
ENRENR-1000302026-08-07T11:50:56ZEmmaFScott1975-09-03UHC-71092-24•••-••-4270(789) 271-1737emma.scott@outlook.com1376 Hillcrest RoadPhoenixAZNULLGRP-6069MEDICARE-ADV-A
ENRENR-1014762026-02-10T10:48:41ZLOGAN—SIMS1982-02-26UHC-95454-32•••-••-5010(253) 818-0435logan.sims63@hotmail.com539 MEADOW LANEHouston·TX77006GRP-1881NAVIGATE-HMO
ENRENR-1403322026-06-27T01:07:29ZBanks, Brittany—··1948-07-03UHC-86957-86•••-••-30809155051099brittany.banks@aol.com493 Camelback RdOrlandoFL32858GRP-3018OPTIONS-PPO
ENRENR-1378772026-05-08T12:41:45Z Perez, Luis··——2002-08-15UHC-57144-77•••-••-1347883-933-8205luis.perez@icloud.comnullNULLnull—GRP-7436OPTIONS-PPO
ENRENR-1124892026-08-03T05:30:12Z BRANDON··B···RYAN1973-09-13UHC-38669-58•••-••-9160(318) 253-9892UNKNOWN8174 BroadwayEDEN PRAIRIEMN55311··GRP-5707··SELECT-EPO··
ENRENR-1003932026-01-21T05:06:44Z Alan—Herrera1946-03-09UHC-14048-79•••-••-7482(221) 540-3363alan.herrera@gmail.com6548 Sunset BlvdCOLUMBUS··OH43272GRP-9012CORE-HMO
ENRENR-1307412026-03-13T19:52:50ZCATHERINE—DUNN01/15/2006UHC-47487-63•••-••-9450(365) 445-6298CATHERINE.DUNN@AOL.COM3644 Elm St·Las VegasNV89147GRP-8345·SELECT-EPO
ENR ENR-1124582026-09-26T19:20:53ZEmilyWBurns1967-05-03UHC-65846-64null289-339-6858emily.burns76@hotmail.com3055 DESERT SKY BOULEVARDCharlotteNC28265GRP-6280OPTIONS-PPO
ENRENR-1030012026-08-25T13:47:18ZSoto, FrankD—Nov 14, 2007UHC-53783-50•••-••-5786(806) 552-7556frank.soto@gmail.com4673 Bayshore DrMIAMIFL33121-5295GRP-7495NAVIGATE-HMO
ENRENR-1306112026-04-10T02:17:24Zalexander—warren20020427UHC-79134-14•••-••-93095516451719NULL8072 DESERT SKY BOULEVARDColumbus··OH43265GRP-6667MEDICARE-ADV-B
43,101 rows, page 47 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.678Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty