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-1287132026-03-11T06:39:05ZTERRYHPOWELL1971-06-24UHC-79657-29•••-••-96712657634139TERRY.POWELL@YAHOO.COM3918 MAPLE AVENUEAustinTX78731GRP-5709NAVIGATE-HMO
ENRENR-1056272026-09-13T01:15:16ZJacob·V.Patel20061219UHC-00417-59•••-••-6535311.402.5690·jacob.patel39@aol.com——-·-GRP-2752MEDICARE-ADV-A
ENRENR-1265372026-08-08T20:07:30ZJimenez, ChristineW.—08/25/00UHC-90658-11——CHRISTINE.JIMENEZ@OUTLOOK.COM7936 Mountain View Dr··EDEN PRAIRIEmn55324·GRP-2075MEDICARE-ADV-A··
ENRENR-1144592026-03-31T20:47:52ZGloriaZWalsh··03-11-1990UHC-28637-03—888-885-6591gloria.walsh@gmail.com73 Elm StreetAustin·TX·78750GRP-9126NAVIGATE-HMO
ENRENR-1123402026-01-29T01:04:16ZMatthew—Alexander1978-02-34UHC-01927-67•••-••-9282(968) 943-8789matthew.alexander@aol.com8271 Mountain View DrGlendaleArizona85328-1387GRP-3959MEDICARE-ADV-A
ENRENR-1263042026-08-26T11:43:54ZMaldonado, PeterV.—2003-08-14UHC-36176-16··•••-••-2869460.278.1707PETER.MALDONADO61@HOTMAIL.COM5647 Broadway #217DallasTX75234GRP-2426CORE-HMO
ENRENR-137253 2026-07-20T10:32:32ZGEORGEM—12/2/1956··UHC-50698-43•••-••-0961—george.munoz@gmail.com5175 Indian School RdATLANTAGAN/AGRP-3797MEDICARE-ADV-B
ENRENR-1329212026-09-19T09:02:57Z·KATHLEEN··SANTIAGO1974-09-25UHC-39717-03—16546989131null1897 VALLEY VIEW DRIVETempeAZnullGRP-8275CORE-HMO
ENRENR-1323232026-05-06T02:55:49ZScottMSingh·UNKNOWNUHC-17288-43•••-••-9011·17792045030N/A··1717 Hillcrest RoadSacramentoca95833GRP-1157·NAVIGATE-HMO
ENRENR-1280522026-01-02T23:32:29ZDENNIS—ROBINSON08/17/1991UHC-88911-21•••-••-2294·519-322-8912DENNIS.ROBINSON93@AOL.COM6591 Jefferson AvenueChandlerAZ85260GRP-5547MEDICARE-ADV-A
ENRENR-1285152026-09-25T22:59:20ZBarb—Martinez1961-08-20UHC-80756-39•••-••-2009309-442-8887barbara.martinez@outlook.com3302 SUNSET BOULEVARDFRESNOCA93706GRP-9961MEDICARE-ADV-A
ENRENR-1212812026-02-19T11:24:29ZDanielle—George19541116UHC-64557-14•••-••-8781(217) 905-1593danielle.george@outlook.com2035 CHURCH STEden PrairieMN55340GRP-0506SELECT-EPO
ENR ENR-1297262026-07-19T12:21:27ZChristina—Graham·1948-09-14UHC-81316-40•••-••-2227295-371-4632christina.graham60@aol.com1157 Elm StDenverCO80233GRP-9996OPTIONS-PPO
ENRENR-1195272026-04-30T02:27:13ZGeorgeMBell2008-02-09UHC-61073-83•••-••-62642425028549george.bell3@icloud.com··3580 Spring StSEATTLEWA98150-0900GRP-3194·MEDICARE-ADV-A
ENRENR-1408442026-03-16T21:18:08Zjanet—vazquez12/01/89··UHC-47351-63•••-••-5511387-918-3611janet.vazquez17@aol.com2641 PALM DRIVESeattleWA98110GRP-5361NAVIGATE-HMO
ENRENR-1158032026-03-03T17:57:42ZOBrienEDouglas1966-08-26UHC-37735-01NULL12259087231null5267 GRAND AVENUEGilbert··AZ85202GRP-3560CHOICE-PLUS-PPO
ENRENR-1170302026-03-22T06:02:48Z ScottUJordan02/17/65UHC-14875-55•••-••-2296·535-757-9210—2014 Pine DrMIAMIFL33190GRP-9051·MEDICARE-ADV-B
ENRENR-1266292026-03-07T06:16:46ZJOE—MORENO1979-11-20··UHC-55158-75•••-••-5735—joe.moreno48@hotmail.com8522 Main StreetAustinTX78796GRP-6023medicare-adv-a
ENRENR-1155002026-07-24T17:08:16ZSofa··Weaver1968-01-17UHC-57114-29•••-••-0790957-349-0682sofia.weaver1@outlook.com·8340 Spring StreetGlendaleAZ·85310·GRP-0976CORE-HMO··
ENRENR-1156782026-01-21T07:20:06ZGeorge—Tucker1943-03-16·UHC-44073-63—2544930839GEORGE.TUCKER@YAHOO.COM8913 Ocean AvenueAUSTINTXnullGRP-9574navigate-hmo
ENRENR-1181452026-09-13T15:37:13ZTeresa—·Meyer1962-09-10UHC-53988-81•••-••-8583715.812.4392teresa.meyer@yahoo.com9295 Apache BlvdLas VegasNV89197··GRP-2281NAVIGATE-HMO
ENRENR-1296572026-06-23T08:23:27ZMeganRHanson1977-05-04UHC-19714-34•••-••-5382—MEGAN.HANSON@PROTON.ME416 Meadow LnLos AngelesCA90095GRP-5291CORE-HMO
ENRENR-1347322026-03-29T11:17:19ZBran—Matthews1988-07-28UHC-23750-61··•••-••-849219246330012bryan.matthews71@hotmail.com8907 Harbor Boulevard··PLANOTexas75085GRP-2128··NAVIGATE-HMO
ENRENR-1072932026-02-19T10:51:45ZALANVPARK1991-05-20UHC9687742•••-••-2642+1 587 825 3468—·5012 Mountain View Dr Apt 17Nashville·TN37286GRP-7275OPTIONS-PPO
ENRENR-1221222026-06-09T13:00:55ZNICHOLAS····CASTILLOAug 7, 1963UHC-57647-09•••-••-5972UNKNOWNnicholas.castillo@outlook.com8065 Maple AvenueLas VegasNV··89194-1604GRP-3393·MEDICARE-ADV-A
ENRENR-1072772026-01-13T14:34:41ZDANIELLE—WALSH1984-02-04UHC-00298-63•••-••-70839459986966danielle.walsh45@gmail.com9278 River RoadColumbusOhio43250GRP-8955CORE-HMO
ENRENR-1137722026-03-25T20:04:55ZAUSTINAHERRERA2002-09-12UHC-67378-94•••-••-56228336976854AUSTIN.HERRERA30@GMAIL.COM3503 Oak StSan DiegoCA···92162GRP-4927OPTIONS-PPO
ENRENR-1114292026-01-02T06:30:58Zbryan—cox1964-01-65UHC-15669-80•••-••-7996888-733-1750-6142 Desert Sky BlvdSacramentoCA95812GRP-5917·SELECT-EPO
ENR ENR-1076682026-02-18T15:26:01ZZachary—Chen11-04-1955UHC-63377-58•••-••-2619865-991-2370ZACHARY.CHEN47@AOL.COM5574 Harbor BlvdPhoenixAZ·85012GRP-7223CHOICE-PLUS-PPO
ENRENR-1233442026-08-15T10:10:17ZBRANDONUCARPENTER1975-06-24UHC-41042-30•••-••-06275791030—7531 Cedar LnLos AngelesCA90067GRP-8981NAVIGATE-HMO
ENRENR-1254502026-10-09T18:53:11ZADAM····WHEELEROct 17, 1950UHC-22662-71•••-••-2794—adam.wheeler92@yahoo.com3569 Jefferson AvenueHoustonTX··77056GRP-6731CORE-HMO
ENR ENR-1126232026-01-13T04:00:31ZMasonMKelley9142-11-17UHC-29311-14•••-••-7643734.824.2923MASON.KELLEY@YAHOO.COM7144 Bayshore DrMIAMIFL—GRP-8749choice-plus-ppo
ENRENR-1051892026-05-19T00:24:08ZJohnson, Mariana——·10/16/2003UHC-15319-31•••-••-1882248-973-6384MARIANA.JOHNSON@YAHOO.COM9680 Park PlPLANOTX75040GRP-5228OPTIONS-PPO··
ENRENR-1294372026-02-08T10:00:18ZDianaECooper1992-02-21UHC-93659-24•••-••-34988206167600-855 Pine DrPhoenixAZ··85047-7751GRP-9380CHOICE-PLUS-PPO
ENRENR-1134482026-01-01T03:00:24ZHarvey, Diana··——1996-12-24UHC-74419-97•••-••-43965405581769diana.harvey69@gmail.com·8953 Baseline RoadOrlando·FL32885GRP-4787CORE-HMO
ENRENR-1168032026-09-25T12:32:08ZVINCENTXMITCHELL20040710UHC-38991-46•••-••-3788+1 331 580 1080vincent.mitchell75@proton.me9713 Spring Street··San DiegoCA92152GRP-6068MEDICARE-ADV-A
ENRENR-1379302026-04-19T15:24:36Zrussell·M.evans1983-11-13UHC-22065-13•••-••-3533(848) 834-5530russell.evans96@hotmail.com9073 Park PlSeattle·WA-GRP-7989SELECT-EPO
ENRENR-1402632026-03-06T22:26:32ZBettyTGriffin2/8/1956UHC-23779-75•••-••-9558+1 391 827 4461betty.griffin@aol.com4989 Central AveLas VegasNV89163GRP-1931CHOICE-PLUS-PPO
ENRENR-1021922026-09-29T13:48:36ZJOEULYNCH·May 17, 1939UHC-56172-67•••-••-8642(561) 228-3948null3000 Lake View RoadFresnoCA93719GRP-9343CHOICE-PLUS-PPO
ENRENR-1146932026-01-23T23:41:16ZELIZABETHJ.WATSONFeb 11, 1953UHC-09551-93•••-••-25717024295748N/A799 Forest Avenue·ScottsdaleAZ85235GRP-8401NAVIGATE-HMO
ENRENR-1274032026-05-21T22:30:16Z ANDREW··LVARGAS·19710425UHC-37792-68•••-••-1809614-920-1419ANDREW.VARGAS22@GMAIL.COM9409 CEDAR LN·DallasTX75283GRP-7422MEDICARE-ADV-A··
ENRENR-1087832026-08-15T06:04:31ZDouglas··—Fernandez1942-01-01UHC2008655—(605) 356-3787DOUGLAS.FERNANDEZ61@GMAIL.COM3013 SPRING STAustinTX·78736GRP-5381MEDICARE-ADV-B
ENRENR-1371572026-05-09T17:22:08Z—U.—1982-11-20UHC-21392-85•••-••-8920—benjamin.elliott57@proton.me··8890 CHURCH STREET·Las VegasNV89163GRP-2285SELECT-EPO
ENRENR-1025702026-05-06T14:33:01ZJoan—Morris2004-06-11—•••-••-742812747221561joan.morris37@icloud.com9160 MEADOW LNNashvilleTN37212GRP-1718OPTIONS-PPO
ENRENR-1272782026-06-04T16:04:20ZLAURA—LITTLE2001-07-05UHC-72641-27•••-••-0687832-477-1227laura.little@yahoo.com5519 Willow CtChandler·AZ85219-9473GRP-4787·CHOICE-PLUS-PPO
ENRENR-1075872026-02-20T16:26:49ZAustin··G.Riley··1992-12-27UHC-82443-76•••-••-1188(968) 258-8502—3160 Baseline RoadLos AngelesCA90042GRP-7961CHOICE-PLUS-PPO
ENRENR-1330962026-05-14T02:51:50ZSARAHTPARKER2/23/1990·UHC-71371-06•••-••-39322538286454—4806 Meadow LnMesaAZ85200GRP-8745NAVIGATE-HMO
ENRENR-1290392026-09-17T06:10:56ZSANTIAGOPJOHNSTON11/11/1951UHC-65660-37•••-••-016213096497686santiago.johnston@outlook.com2725 WASHINGTON STREET Apt 16Chandler·AZ85284GRP-9177select-epo
ENRENR-1270682026-02-12T17:33:47ZPena, Zachary——6/6/1950·UHC-45681-34•••-••-9021379.911.1696zachary.pena8@aol.com6126 Mountain View DriveGilbertAZ—GRP-1421CHOICE-PLUS-PPO
ENRENR-1077062026-05-03T06:34:18Zsara—king15-12-1996UHC-68504-05UNKNOWN··8344955511SARA.KING@ICLOUD.COM4661 Central AveTUCSONAZ85706GRP-0522CORE-HMO
43,101 rows, page 232 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.612Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty