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-1099192026-08-16T16:46:38ZMarySHoward1996-01-03UHC-75232-54•••-••-6238+1 678 543 5829MARY.HOWARD@YAHOO.COM3561 Desert Sky BoulevardColumbus·OH43253GRP-8124SELECT-EPO
ENRENR-124526 2026-08-24T12:44:43ZCamila··Goez·19640701UHC-71049-16•••-••-7195894-840-2210camila.gomez@aol.com995 Indian School RoadGLENDALEAZ···85364GRP-7470CORE-HMO
ENRENR-1312732026-06-28T10:08:33ZSANDRA····SANTIAGO1951-04-21UHC-18065-04N/A5845297564SANDRA.SANTIAGO81@GMAIL.COM94 Maple Avenue·Las VegasNV89172GRP-7352MEDICARE-ADV-B
ENRENR-1215582026-08-10T11:49:00ZHeatherGHill1993-10-17UHC-75926-35•••-••-7550340.903.3399heather.hill51@outlook.com8353 WASHINGTON STREETAtlantaGA30384GRP-5621SELECT-EPO
ENRENR-1160402026-02-18T09:34:28ZREYNOLDS—CHRISTIAN1969-06-13UHC-89526-48null891.737.7096····1150 MEADOW LANE·Plano·TX75080GRP-6876MEDICARE-ADV-A
ENRENR-1150412026-03-31T02:13:22ZHAROLD—NGUYEN··1994-06-13UHC-06434-75··•••-••-8889(329) 229-1517N/A4469 Union StPLANOtx75049-2313GRP-6605MEDICARE-ADV-A
ENRENR-1316752026-09-07T20:53:42ZAdamX.Webb1997-06-22UHC-33054-21•••-••-73656994920995adam.webb@hotmail.com8139 LINCOLN WAYMinneapolisMN55487GRP-0952MEDICARE-ADV-B
ENRENR-1186872026-01-24T18:18:07ZPHILIP—VALDEZ1996-03-02UHC-84631-45—7198936030N/A713 CAMELBACK RDDenverCO80234GRP-6556SELECT-EPO
ENRENR-1022812026-04-12T08:28:19ZBetty—Lonng19651014UHC-18001-61•••-••-4728(604) 289-6360·betty.long68@icloud.com6155 Baseline RdCOLUMBUSOH43230GRP-9142NAVIGATE-HMO
ENRENR-1110592026-02-02T09:17:02ZSARA—·GREENE04/04/87UHC-84724-26—212.919.2051sara.greene32@icloud.com2557 Main StreetLAS VEGASNV89166GRP-3314MEDICARE-ADV-B
ENRENR-1211092026-09-10T19:18:29ZBrendaOWong1952-02-16UHC-83913-18UNKNOWN··2307310131BRENDA.WONG@ICLOUD.COM2021 Willow CtMiamiFL33163GRP-0403OPTIONS-PPO
ENRENR-1126572026-06-13T19:08:51ZEugene—·Porter26-12-1994UHC-67777-01•••-••-2815442.512.4186EUGENE.PORTER21@OUTLOOK.COM9018 Church StreetDallasTX75232GRP-3816MEDICARE-ADV-B
ENRENR-1126982026-08-24T16:50:42ZHanesn, Grace··——1950-10-13UHC-18693-71··NULL3876468345grace.hansen35@icloud.com5330 Harbor BoulevardHOUSTONTX77056GRP-9979SELECT-EPO
ENRENR-1014172026-06-19T05:51:01ZMARTHAC.MURPHYFeb 1, 1950UHC-96988-57•••-••-4635(618) 776-0369martha.murphy1@gmail.com··8376 Camelback RoadScottsdaleAZ··85232GRP-2962·CORE-HMO
ENR ENR-1206832026-01-01T04:43:51ZBell, Amy——·Nov 17, 1952UHC-13517-15•••-••-9187(835) 706-7795AMY.BELL51@HOTMAIL.COM588 CHURCH STREETPlanoTX75054GRP-1602CORE-HMO
ENRENR-1301342026-08-19T12:01:25ZkimberlyP.··gutierrez20070214uhc-33455-54•••-••-63067488836952··—7415 Ridge RoadJACKSONVILLEFL32204GRP-4760SELECT-EPO
ENRENR-1314972026-03-03T18:22:07ZCarolyn····Green1977-10-04UHC-59779-76•••-••-8804(296) 614-1245··N/A6755 Union StMesaAZ·85235GRP-4172OPTIONS-PPO
ENRENR-1086322026-04-20T03:15:37Z·Alexis—Schultz1942-08-23UHC-14389-28null··—ALEXIS.SCHULTZ65@HOTMAIL.COM4330 Sage CourtMinneapolisMN55467GRP-6831CORE-HMO
ENRENR-1107792026-06-12T19:36:44ZDavis, AishaV—2006-03-03UHC-31947-84•••-••-5404314-394-0177null·9578 SPRING STNashvilleTN37229GRP-6238CORE-HMO
ENRENR-130414 2026-02-17T09:37:06ZDeniseTVargas10/23/1949UHC-01600-93null614-673-0135DENISE.VARGAS@YAHOO.COM4158 CENTRAL AVENashvilleTNNULL·GRP-6359SELECT-EPO
ENRENR-1012622026-03-10T10:50:36Z Isabella—Robertson··1980-12-15UHC-11727-04•••-••-7490320-877-5406-138 Sunset Blvd··TempeAZ85236GRP-6262MEDICARE-ADV-B
ENRENR-137467 2026-09-13T07:54:34ZEdward··—Shaw02/19/1980UHC-85465-64-5336805777edward.shaw@icloud.com1063 Cedar LnSCOTTSDALEAZ85268GRP-2609OPTIONS-PPO
ENRENR-1186072026-01-09T08:29:26ZSantiago—Aguilar1970-06-16UHC-15363-06•••-••-6978—null·7696 Bayshore DrSan AntonioTX78241GRP-7555·CHOICE-PLUS-PPO
ENRENR-1249282026-09-15T15:05:49ZSofia—Gilbert25-09-1951UHC4478624•••-••-9418(848) 362-9635sofia.gilbert38@gmail.com4420 CENTRAL AVEGlendaleAZ—GRP-7313OPTIONS-PPO
ENRENR-1428332026-02-04T12:37:03ZJOANN.SILVA1968-06-25UHC-84623-38•••-••-6870725-858-9637joan.silva23@aol.com5289 Mountain View DrColumbusOhio43287·GRP-5187SELECT-EPO
ENRENR-1346822026-04-20T12:49:22ZPalmer, EvelynP—1990-74-03UHC-50583-39—609-239-0924EVELYN.PALMER@AOL.COM8011 CHURCH STREETTUCSON·az85758GRP-8990NAVIGATE-HMO
ENRENR-1258352026-08-01T22:17:45ZJustin—Butler19531108UHC-04020-20—6109317064··justin.butler33@proton.me2044 Mountain View DriveAUSTINTexas78706GRP-5801medicare-adv-a
ENRENR-1115702026-02-05T21:28:26ZANDREA—BELL2007-01-24··UHC-97155-64•••-••-5393223-457-2865ANDREA.BELL@AOL.COM4106 BASELINE ROADAustinTX78713GRP-1937OPTIONS-PPO
ENRENR-1422782026-07-07T09:15:23ZPATRICIAUEDWARDS1976-12-14UHC9817336•••-••-122419783003273patricia.edwards87@proton.me7988 Sage Ct··SAN ANTONIOTX78271GRP-1649select-epo
ENRENR-1263672026-04-08T16:48:17ZAlice···YWillis1944-06-18UHC-52240-26•••-••-1264+1 708 805 4449—5380 Willow CtNashvilleTN37241GRP-1902SELECT-EPO
ENRENR-1017342026-10-13T17:45:34ZJAMESPWEAVER1945-03-05·UHC-45993-08•••-••-4488(896) 456-7385·-7387 Bayshore Dr Apt 6··NashvilleTN37261GRP-3427MEDICARE-ADV-A
ENRENR-1410182026-06-10T20:17:34ZNicholas—Holmes1951-03-17UHC-73414-91•••-••-9099976.740.1116··UNKNOWN6938 Bayshore Drive #941Eden PrairieMN55373GRP-7436SELECT-EPO
ENR ENR-1113082026-06-15T18:59:25ZTim—George04/03/1951·UHC-97376-17—6778141778··timothy.george@aol.com397 Sage Court Apt 38Denverco··80240GRP-8174CHOICE-PLUS-PPO
ENRENR-1413542026-02-16T19:11:36ZPATRICIAEROBERTSON02/10/1972UHC-63151-88•••-••-1772834-267-6995··—523 Desert Sky BlvdEden PrairieMN55365GRP-2345CHOICE-PLUS-PPO
ENRENR-1396852026-08-25T14:31:56ZAlexander, KarenM—1975-02-26UHC-57783-27•••-••-90635069389902karen.alexander@aol.com6849 CEDAR LNNASHVILLE·Tennessee·37254GRP-0489··medicare-adv-a
ENRENR-1016982026-08-09T10:55:25ZAhmedCSchultz2005-09-27UHC-98286-73··•••-••-91416079607108AHMED.SCHULTZ92@GMAIL.COM6157 Hillcrest RdLas VegasNV··89173GRP-4865CHOICE-PLUS-PPO
ENRENR-1111782026-07-11T11:39:42ZDONALD—FIELDS5/24/1981uhc-22806-16•••-••-0799(497) 374-7885null-NULL-—GRP-9287NAVIGATE-HMO
ENRENR-1184232026-04-09T05:55:16ZARJUN—HUDSON17-06-1938UHC-28802-41•••-••-29893532757110··arjun.hudson@gmail.com9487 Lake View RdFresnoCA··N/AGRP-7411MEDICARE-ADV-A··
ENRENR-1419512026-01-15T09:28:44ZCAROLYNC.JACOBS1954-07-07UHC-51019-83•••-••-8352·4862489373carolyn.jacobs46@icloud.comnullNULLnull····GRP-4811··SELECT-EPO
ENRENR-1108682026-08-14T23:54:43ZWood, VincentV—1955-11-02·UHC-85308-41•••-••-53025997044390vincent.wood89@hotmail.com3500 Camelback RdSan DiegoCA92162·GRP-1258OPTIONS-PPO
ENRENR-1040402026-05-29T03:32:38ZKeithJ.·Williamson1975-08-07UHC-10224-17•••-••-5877958-318-6482keith.williamson82@aol.com3014 Pine DriveCharlotte·NC28207-1996GRP-3950OPTIONS-PPO
ENRENR-1004772026-03-18T06:32:17ZPriya—Alexander1983-03-13UHC-44374-67•••-••-58469104976priya.alexander62@proton.me1179 CANYON ROADTempeAZ85292GRP-6588MEDICARE-ADV-A
ENRENR-1246662026-03-17T16:02:10ZETHAN—WEAVER··1967-06-05UHC2603352•••-••-189414762445631ethan.weaver73@aol.com8731 WASHINGTON STREETMesaAZ85268GRP-6773SELECT-EPO
ENRENR-1182642026-01-27T17:08:46ZWebb, Mariana—····Jan 23, 1981UHC-95353-72•••-••-3284—-4877 Mountain View Dr Apt 21SeattleWashington98119GRP-8375SELECT-EPO
ENRENR-1060692026-07-07T09:19:28ZGaryPMendezMar 27, 2008UHC-40628-36•••-••-3833-gary.mendez@proton.me9612 WASHINGTON STColumbus··oh43238GRP-4940NAVIGATE-HMO
ENRENR-1240502026-05-21T13:21:44ZchristineDsilva··1994-08-04UHC-39736-97··•••-••-9076NULLCHRISTINE.SILVA61@YAHOO.COM6004 Mesa Drive #184OrlandoFL32894·GRP-7606CHOICE-PLUS-PPO··
ENRENR-1363802026-07-15T17:44:18ZSAMNTHAU.·SILVAOct 7, 1970UHC-21618-98•••-••-91905665738325SAMANTHA.SILVA70@AOL.COM1525 Willow CourtTucsonAZ85733GRP-3313MEDICARE-ADV-B
ENRENR-1275982026-03-13T18:26:47ZCHRISWRYAN2008-03-02··UHC-27959-29•••-••-1100(215) 793-1090null4424 Church St·Las VegasNV89108GRP-6922CORE-HMO
ENRENR-1127292026-10-15T15:36:45ZGrace—Washington·21-11-1956UHC-52191-23•••-••-742116404268587grace.washington81@yahoo.com7178 MEADOW LANEHoustonTX77051GRP-8380··CORE-HMO
ENRENR-1032272026-03-02T22:10:48ZCatherne··PNelson10/12/1954UHC6177181··•••-••-3979481-787-5132UNKNOWN7047 Oak StreetLos AngelesCA90001-2389GRP-6358CORE-HMO··
43,101 rows, page 224 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:40.602Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty