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-1085302026-07-08T10:25:33ZGLORIALMONTGOMERY04/02/1962·UHC-80406-18•••-••-18269279450002GLORIA.MONTGOMERY7@HOTMAIL.COM4288 Sage CtCHARLOTTENC··28213GRP-5382SELECT-EPO
ENRENR-1012702026-09-05T19:51:44ZBETTYN.PENA1946-08-14UHC1190451•••-••-2024(684) 431-6552betty.pena@hotmail.com547 Pine DriveFresnoCA··93749GRP-0859·SELECT-EPO
ENRENR-1223172026-01-29T17:13:51ZWeiLBailey1975-02-24UHC-28230-33•••-••-5897352-615-1031—609 Hillcrest RdMinneapolisMN55431GRP-4446SELECT-EPO
ENRENR-1293082026-04-02T04:48:11ZARJUNLHUGHES1992-06-19UHC-93331-57•••-••-3386+1 294 607 7681arjun.hughes80@outlook.com7089 CAMELBACK ROADAustintx—GRP-0845SELECT-EPO
ENRENR-1120122026-03-15T17:08:03Z·EMMA—CARTER02/15/1943UHC-30598-22•••-••-4986920-978-3981emma.carter@yahoo.com2898 Church StreetAustinTX78758-6585GRP-4936MEDICARE-ADV-A
ENRENR-1382142026-09-01T03:58:00ZjacquelineAgomez1965-01-25··UHC-52995-60•••-••-6844(436) 623-2089-7809 PALM DRPlanoTexas75046GRP-1284MEDICARE-ADV-A
ENR ENR-1204862026-06-26T01:45:47ZWallae, Jack——1988-04-23UHC-64103-89-+1 595 220 3699jack.wallace23@aol.com3117 RIVER ROADPlanoTXNULLGRP-2036MEDICARE-ADV-B
ENRENR-1039012026-08-26T04:42:18ZBettyL.Sullivan1949-01-03UHC-92313-03•••-••-14237915438656null14 Lake View RoadMinneapolisMN55416GRP-6547options-ppo
ENRENR-1328492026-05-08T19:29:36ZRichards, Amanda——19402602UHC-51387-40•••-••-706716545023050amanda.richards@outlook.com7205 CEDAR LANE #712TEMPE··Arizona85228GRP-6880MEDICARE-ADV-B
ENRENR-1208202026-05-26T15:19:35ZLisaY.Gray2004-05-26UHC9683503—15925444149lisa.gray56@aol.com4142 WASHINGTON STPhoenixAZ85007GRP-5238SELECT-EPO
ENR ENR-1205182026-09-18T10:08:20ZJAN·W.SIMPSON1954-09-27UHC-60353-59•••-••-10236732010551joan.simpson@yahoo.com2287 CENTRAL AVE Apt 29ScottsdaleAZ85223GRP-7110MEDICARE-ADV-A
ENRENR-1027192026-04-03T12:26:58Z DIANAD··BUTLER9144-05-24UHC-83959-10•••-••-3675349-756-6507DIANA.BUTLER70@AOL.COM1810 Indian School RoadScottsdaleAZ85294GRP-5742·SELECT-EPO
ENRENR-1019652026-04-02T08:35:51ZMarianaOFox1973-08-19UHC-10297-93—6068040409mariana.fox27@icloud.com7850 Baseline RdNashvilleTN··37227·GRP-0437OPTIONS-PPO
ENRENR-1150242026-01-16T04:37:41ZRANDYN.STEVENS24-10-1988UHC-04898-82—·918-395-3557null·7288 JEFFERSON AVELOS ANGELESCA90071GRP-0308OPTIONS-PPO
ENR ENR-1275252026-10-07T07:16:30ZThommas—Banks1970-05-19·UHC-86634-53•••-••-9572215-510-8126··707 Meadow LaneSan AntonioTexas78210GRP-9439·MEDICARE-ADV-B
ENRENR-1292552026-05-07T02:15:30ZVincentH.Thomas10/15/04··UHC-37542-71•••-••-18526456622624—4712 Willow CourtNASHVILLETN37264GRP-7541NAVIGATE-HMO
ENRENR-1112492026-04-21T17:52:41Z·cheryl—gonzalez8/23/1949UHC-13571-26•••-••-2138404-303-1125-5689 Spring StreetPHOENIX··AZUNKNOWNGRP-7560·MEDICARE-ADV-B
ENRENR-1282902026-10-04T23:54:03ZNuunez, Jesse——1945-10-24UHC-74574-18··•••-••-74897625628326—6383 GRAND AVENUESacramento·CA·95861GRP-3905SELECT-EPO
ENR ENR-1100692026-03-20T05:16:33ZElizabeth—Hill2002-09-20UHC-03957-05•••-••-4677+1 971 570 2551elizabeth.hill@hotmail.com7340 Pine DrivePlanoTX75015GRP-3106CORE-HMO
ENRENR-1234142026-10-10T05:05:05ZDEBRAV.OLIVER11/05/05·UHC-96451-85•••-••-0369(747) 499-8161debra.oliver97@icloud.com676 Washington StColumbusOhio43236GRP-2390·CORE-HMO
ENRENR-1270462026-03-06T08:06:50ZCHARLOTTE··GUZMAN1963-03-01UHC-27658-01•••-••-0778862-259-7123·charlotte.guzman31@aol.com9733 BroadwayCHANDLERAZ85271-8623GRP-0416··MEDICARE-ADV-B
ENRENR-1204332026-09-02T12:00:27ZMARIAJ·VAZQUEZOct 10, 1954UHC-60301-52•••-••-21112385506675··MARIA.VAZQUEZ55@YAHOO.COM891 Canyon Rd Apt 19LOS ANGELESCA90042GRP-7124SELECT-EPO
ENRENR-1055062026-10-03T00:43:00Z·Daniel—Matthews19421106UHC-84431-15•••-••-59657993957727DANIEL.MATTHEWS87@ICLOUD.COM·2893 Church Street #942Tucson·AZ85714-3647GRP-1133CORE-HMO
ENRENR-1336932026-06-21T01:50:24ZRobert—Brooks1940-10-26UHC-17255-13—4639481486ROBERT.BROOKS36@ICLOUD.COM6515 Baseline Rd Apt 22···DenverCO80209GRP-9273CHOICE-PLUS-PPO
ENRENR-1219912026-02-10T07:46:49Z amberNhudson05/20/1994·UHC-34157-71•••-••-41833163335148N/A8194 Maple AvenueScottsdaleAZ85259GRP-7522MEDICARE-ADV-B
ENRENR-1072352026-09-22T16:24:26ZBARBARAM.MORRISON9184-11-19UHC-50934-44·UNKNOWN2536635827BARBARA.MORRISON61@PROTON.ME8780 SAGE CTEden PrairieMinnesota55342-8359GRP-8994MEDICARE-ADV-A
ENRENR-1170712026-01-22T08:38:46ZVictoriaJFoster1966-07-05UHC-18869-45•••-••-6938+1 518 898 3973victoria.foster@icloud.com··1682 Main StreetSacramentoCA95820GRP-0933CHOICE-PLUS-PPO
ENRENR-1324042026-02-13T13:34:26Z·JEREMYN.HUGHES1996-01-02UHC-57648-15•••-••-1239nullJEREMY.HUGHES10@PROTON.ME2944 Elm StCharlotteNC28248GRP-6529CHOICE-PLUS-PPO
ENRENR-106400 2026-01-09T17:13:06ZRUSSELL M.—ELLIOTT2003-09-13UHC-96694-14•••-••-67004856780673russell.elliott@proton.me1646 Grand AvenueAtlantaGA30330GRP-3948·OPTIONS-PPO
ENRENR-1025722026-01-25T07:00:13ZMeiFEstradaJun 13, 1958UHC8996596•••-••-30669867750981mei.estrada@gmail.com8211 CHURCH STREETTempeaz85267GRP-5817MEDICARE-ADV-B
ENRENR-1225322026-06-26T08:59:02ZWeiF.Gordon1959-11-16UHC-30367-16•••-••-72119348195279WEI.GORDON3@GMAIL.COM2419 Baseline RdColumbusOH43258GRP-1123MEDICARE-ADV-A
ENRENR-1076032026-09-04T23:47:27ZPETERBLANE·2007-09-23UHC-22452-89•••-••-35585133260978peter.lane@yahoo.com4231 RIDGE ROADGilbertAZ85222GRP-1382CHOICE-PLUS-PPO
ENRENR-1232702026-06-05T15:19:09ZMrak—Edwards2001-10-26UHC-99615-18•••-••-0177631.571.2522mark.edwards@hotmail.com8838 Mesa DriveSan AntonioTX78247-6546GRP-7652SELECT-EPO
ENRENR-1244392026-02-11T22:07:19ZAdams, SeanY.—12/24/68UNKNOWN··•••-••-7072+1 835 762 6925null6127 INDIAN SCHOOL RDLos AngelesCalifornia90001GRP-4430MEDICARE-ADV-A
ENRENR-1048252026-10-03T03:21:25ZJOSH—ROEJul 10, 1976UHC-06457-96•••-••-9825—joshua.rose@aol.com6255 Meadow LaneLOS ANGELESCA··90054GRP-3615CORE-HMO··
ENRENR-1104412026-05-23T12:44:28ZEMILY····LANE01/12/1997UHC-94743-75•••-••-0106733-594-6690emily.lane36@yahoo.com3150 Palm DrJacksonvilleFL32218GRP-4551OPTIONS-PPO
ENRENR-1267612026-03-03T21:16:49ZJesse—Phillips07/09/87UHC-17172-85•••-••-4075218-683-9901jesse.phillips30@icloud.com2747 Baseline RdFresnoCA93720GRP-1292OPTIONS-PPO
ENRENR-1423012026-02-27T07:57:56ZKathrynVBryant1968-01-25UHC-78247-83•••-••-8496·3027216377kathryn.bryant60@gmail.com4127 Pine DrivePLANOtx75066GRP-8495MEDICARE-ADV-B
ENRENR-1016552026-07-26T23:56:34ZPhilip—Rojas1999-06-04UHC-24475-83•••-••-5465N/A—2491 Baseline RdLos Angeles·CA90098GRP-5949MEDICARE-ADV-B
ENR ENR-1267192026-02-21T17:13:39ZAmber·VSantiago02/02/59UHC-91241-75•••-••-5660296-296-5469amber.santiago77@hotmail.com···4880 Indian School RdSeattleWA98113GRP-3828CORE-HMO
ENRENR-1015032026-04-28T15:24:18ZHenry V.—Mills08/19/66UHC-95628-44•••-••-3299(489) 783-6199henry.mills@yahoo.com5038 HILLCREST RD Apt 11MesaAZ85261GRP-8726··SELECT-EPO
ENRENR-1170132026-08-08T03:17:43ZKyleP.Phillips1999-01-04UHC-66079-97··•••-••-4086235-749-4646kyle.phillips67@hotmail.com··2516 Harbor BlvdAustinTX78735GRP-8086MEDICARE-ADV-A
ENRENR-1277982026-03-18T08:03:15ZRoy—Fowler20020928UHC2632154··•••-••-8522(459) 921-7744roy.fowler99@outlook.com···6743 Apache Blvd #496AustinTX78779-5058GRP-7259SELECT-EPO
ENRENR-1344452026-08-26T10:21:51ZNATHAAN—CRAWFORD2002-06-03UHC-83107-81—8377377459nathan.crawford80@yahoo.com·9803 Baseline RoadTempeAZNULLGRP-1457MEDICARE-ADV-A
ENRENR-1295472026-06-17T16:08:31ZLarryABrown4/6/1950UHC-42189-15•••-••-491619824133327LARRY.BROWN@GMAIL.COM9380 Meadow LnMiamiFL33113GRP-0892CHOICE-PLUS-PPO
ENRENR-1056422026-09-26T10:09:02ZRandyQSnyder19890616UHC-66632-26•••-••-7888431-818-6468-··398 BROADWAYSan AntonioTX78213-0945GRP-5088CORE-HMO
ENRENR-1235112026-04-28T08:29:56ZDonnaALi1954-11-28··UHC-57650-66•••-••-5771NULL··—301 UNION STAtlanta··GA30384GRP-5578·MEDICARE-ADV-B
ENR ENR-1229522026-02-09T18:08:32ZCarter, PriyaD—24-03-1997UHC-13058-44•••-••-2826—UNKNOWN·6305 Main StHoustonTX77094GRP-7193OPTIONS-PPO
ENRENR-1285382026-10-10T21:17:00Ztyler—shaw2000-01-22UHC-07105-17•••-••-16845016323481tyler.shaw@gmail.com7252 Market StCHANDLERAZ85212GRP-8764CORE-HMO
ENRENR-1201422026-02-14T00:40:05ZJaniceUEdwardsMar 3, 1951UHC-49570-05•••-••-08882073584379—207 PARK PLACE Apt 30DallasTX75239GRP-7132··CORE-HMO
43,101 rows, page 172 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:38.502Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty