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-1169952026-05-27T16:45:50Z·Cheryl—Guzman10/9/2008UHC-71613-42—967-716-6258cheryl.guzman95@proton.me9620 Main Street #128MinneapolisMN—GRP-1703NAVIGATE-HMO
ENRENR-1254892026-04-07T03:52:37ZMARCUS—MURRAY03/02/2007UHC-72241-88•••-••-5181—marcus.murray35@outlook.com2029 Mountain View DrColumbusOH··43220-7689GRP-8630NAVIGATE-HMO
ENRENR-1030642026-04-09T10:13:17ZJensen, Pamela——1984-10-04UHC-45453-81•••-••-7578(634) 477-5907pamela.jensen@hotmail.com5245 Market Street·LAS VEGASNV89112GRP-9729SELECT-EPO
ENRENR-1197452026-10-14T15:26:41ZBowman, Bobby——1956-08-05UHC-05130-58—244-504-7058··bobby.bowman9@aol.com362 Indian School Rd Apt 32Las VegasNV89191GRP-5003CHOICE-PLUS-PPO··
ENRENR-1282272026-03-26T11:13:10ZMark—Allen1992-04-16UHC6309462•••-••-924516985814132mark.allen35@hotmail.com··2967 Washington StGilbertAZ85267GRP-3524NAVIGATE-HMO
ENRENR-1215212026-03-23T07:52:40Z Simmons, CharlesH.—1970-12-02UHC-73593-30•••-••-5121+1 511 272 2012··charles.simmons35@outlook.com9267 Union StPlanoTX75074GRP-5860OPTIONS-PPO
ENRENR-1299212026-07-05T13:46:52Z Gabriel—Price1959-11-11UHC7902188··-gabriel.price65@aol.com9889 WASHINGTON STREETMinneapolisMN55445GRP-8771navigate-hmo
ENRENR-1360802026-03-10T13:34:00ZValentinaJSanders10/26/1978UHC-31727-34-15092234847valentina.sanders@icloud.com8277 Indian School Rd··ScottsdaleAZ—GRP-5626NAVIGATE-HMO
ENRENR-1324002026-07-26T19:55:53ZMARTHA—HART··Aug 9, 1992·UHC-75199-01•••-••-03662168218martha.hart@outlook.com8285 OAK STORLANDOFL32874GRP-6606MEDICARE-ADV-A
ENRENR-1260052026-09-19T06:29:10ZMartin, Andrew——27-06-1971UHC-32419-05•••-••-9736·(218) 347-7931andrew.martin@icloud.com2187 River RdPlanoTX75003GRP-7327OPTIONS-PPO
ENRENR-1091882026-01-14T00:40:00ZHEATHER·P.WAGNER1991-12-14UHC-68131-47•••-••-53134473470816heather.wagner68@yahoo.com4720 CANYON RDMiamifl33174-4781GRP-9903SELECT-EPO··
ENRENR-1381552026-04-28T00:18:20Zsusan—nguyen2002-08-28UHC-21030-32•••-••-2614(566) 246-1153—5563 Bayshore Drive··Charlotte··NC28259GRP-3296·SELECT-EPO
ENRENR-1104892026-05-22T12:03:19Zahmed—phillips01/07/44UHC-63412-32•••-••-0221(986) 831-2555AHMED.PHILLIPS@GMAIL.COM324 PARK PLACEGilbertAZ85273GRP-4182OPTIONS-PPO
ENRENR-1007172026-08-10T13:33:11ZDorothyNHill19990803UHC5201353•••-••-0702270-768-8647UNKNOWN7095 Elm StreetOrlandoFlorida32863GRP-0711CHOICE-PLUS-PPO
ENRENR-1397112026-09-27T15:04:10ZStephanieP.Lawrence1998-07-25UHC-42071-35—(868) 937-0186··stephanie.lawrence46@outlook.com2643 PARK PLDenverCO80229GRP-6954NAVIGATE-HMO
ENRENR-1333342026-03-19T01:46:21ZBarnes, Patrick·I—1970-06-10UHC-32707-31•••-••-056713603931957PATRICK.BARNES@AOL.COM1678 Ridge RoadGilbertAZ85298GRP-6104OPTIONS-PPO
ENRENR-1044492026-04-11T12:50:57ZDYLANODOMINGUEZ1988-03-25UHC-56390-60•••-••-3390707-639-9934dylan.dominguez28@aol.com3895 Palm DriveGilbertAZ85279GRP-3042MEDICARE-ADV-B
ENRENR-1260522026-08-22T19:57:27ZGraceMNunez1977-07-16UHC-08189-27•••-••-377015285502321grace.nunez66@outlook.com100 MAPLE AVENUELas VegasNV89173GRP-3072OPTIONS-PPO
ENRENR-1113482026-07-20T07:53:32ZJulie—Hall02/10/08UHC-86527-90•••-••-5995(521) 209-5610JULIE.HALL38@ICLOUD.COM6710 Mesa DriveSan AntonioTX78249··GRP-2195NAVIGATE-HMO
ENRENR-1154822026-05-01T13:32:23ZJuan··Kelly2001-07-25UHC-79297-20•••-••-6637UNKNOWNNULL1899 Maple AvenueDallasTX75268GRP-8846MEDICARE-ADV-A
ENRENR-1039362026-08-20T19:36:26ZAmberDWoods2002-02-01UHC-14388-64•••-••-67767645596905amber.woods89@yahoo.com7758 Sunset BoulevardMinneapolismn55494GRP-6438SELECT-EPO··
ENR ENR-1304112026-08-28T11:21:36ZLawrenceABurke04-05-1977UHC6181732•••-••-85812115463780—4645 Pine DriveHoustonTX77092GRP-1109CORE-HMO
ENRENR-1038352026-03-26T00:06:21ZPRIYA—FERGUSON1958-03-28UHC-74794-31•••-••-4000745-891-2367—316 Washington StColumbusOH43219GRP-2293SELECT-EPO
ENRENR-1269912026-03-25T10:34:10ZCooper, MarianaZ—19910118UHC-00105-56—4358986576mariana.cooper@yahoo.com3910 Willow CourtSeattleWA98127GRP-7660OPTIONS-PPO
ENRENR-1251712026-03-25T22:47:55Z Dylan—ParkerNov 14, 1995UHC-90290-34•••-••-1097·+1 240 411 8581dylan.parker77@hotmail.com6764 Main StPHOENIXAZ—GRP-8041MEDICARE-ADV-B
ENRENR-1231582026-06-05T13:55:47ZMariana·V.Freeman1968-12-20UHC-39956-01•••-••-13368975461539null7185 VALLEY VIEW DRIVELas VegasNV89109GRP-1851··SELECT-EPO
ENRENR-1305072026-03-28T06:33:40ZThomasCAnderson1986-09-24UHC-91978-85··•••-••-8303(971) 931-1977thomas.anderson25@proton.me··1173 Willow CtOrlandoFL32865GRP-0935CHOICE-PLUS-PPO
ENRENR-1375242026-02-18T20:03:06ZBryan··QFernandez2008-11-21UHC3516293•••-••-24153783917168BRYAN.FERNANDEZ81@OUTLOOK.COM3502 Spring Street·FresnoCA93789GRP-4651MEDICARE-ADV-A
ENRENR-1205432026-03-01T12:40:18Zeugene—simmons1980-05-22·UHC-26366-37•••-••-37213665276959N/A9297 Camelback RoadSeattleWA98194GRP-8949··OPTIONS-PPO
ENRENR-137318 2026-01-01T10:59:16ZJamesY.Montgomery1986-03-20··UHC-55149-63•••-••-5487788-671-0568-·8520 River Rd Apt 10DenverCO80246GRP-4458NAVIGATE-HMO
ENRENR-1088252026-03-28T16:29:40ZKelly—Cruz1993-11-26UHC-96098-11··null(567) 281-0276-··1892 VALLEY VIEW DRNashvilleTN37244GRP-9347MEDICARE-ADV-A
ENRENR-1127782026-07-18T17:59:36ZDiana—Little1993-06-27UHC-18143-49•••-••-4689·4779766365diana.little@proton.me9851 MOUNTAIN VIEW DRLOS ANGELESCA90083GRP-6804·SELECT-EPO
ENRENR-1242682026-02-13T17:34:45ZHerrera—Catherine··1940-10-01UHC-68057-57•••-••-098416242331714null8225 Hillcrest RdAustinTX78714GRP-5503SELECT-EPO
ENRENR-1042802026-06-26T13:20:44ZVincentFHansoon1943-12-03UHC-95245-95null·899.710.1664VINCENT.HANSON@PROTON.ME6526 Camelback RdAtlantaGA·30302GRP-9473OPTIONS-PPO
ENRENR-1130082026-03-09T06:10:47Z CAMILAM.ALLEN2008-03-09UHC-26089-86•••-••-7443N/Acamila.allen@gmail.com2209 BROADWAYPlanoTX75028··GRP-0799CHOICE-PLUS-PPO
ENRENR-1167832026-06-06T07:32:31ZCarolynQ.Dominguez12/10/1989UHC4370675UNKNOWN3992684384-7381 Park PlAtlantaGA30370GRP-1906OPTIONS-PPO
ENRENR-1213552026-05-09T03:04:48ZBobby—Medina1984-09-10UHC-81842-81•••-••-8596293-615-4214bobby.medina23@hotmail.com552 VALLEY VIEW DRJACKSONVILLEFL32250GRP-0632NAVIGATE-HMO
ENRENR-1098562026-02-23T13:08:33ZomarEmiller06/22/1959UHC0474542•••-••-3073nullNULL1055 Grand AvenueMESAAZ··85212GRP-6209CORE-HMO
ENRENR-1000592026-10-15T01:58:52ZDorisFGarza1957-12-18UHC-03918-71•••-••-4697559-749-5345··DORIS.GARZA40@HOTMAIL.COM5194 Desert Sky BlvdLos AngelesCA90000GRP-8008CORE-HMO
ENRENR-1127692026-06-09T11:21:25ZElijah·JParker1980-01-01UHC-21161-41··•••-••-46452143932317—2811 OCEAN AVESan AntonioTX78278GRP-3154·MEDICARE-ADV-B
ENRENR-1299632026-06-09T11:33:33Z·AngelaDCarlson19680922UHC-78453-72•••-••-74067955642339UNKNOWN4333 CHURCH ST #900SeattleWashington98134··GRP-2049SELECT-EPO
ENRENR-1141372026-01-29T02:04:28ZLauren—Perry1954-10-27UHC-79257-94-966-432-6969—1166 Camelback Rd·EDEN PRAIRIEMN55300GRP-8845MEDICARE-ADV-B
ENRENR-1167892026-10-03T12:12:54ZBETTYC.··LEWIS·1942-08-12UHC-43209-07•••-••-5313(247) 903-9522BETTY.LEWIS@AOL.COM·7367 Highland AvenueMiamiFL33176GRP-2344SELECT-EPO··
ENRENR-1120912026-03-27T01:15:16ZMaryTRivera·1951-04-24UHC-91758-33•••-••-8574·913.316.3665MARY.RIVERA21@YAHOO.COM3566 Central AveLas VegasNV89152··GRP-7121·CHOICE-PLUS-PPO
ENRENR-1379262026-05-12T06:41:50ZBEVERLY—DAVIS1976-12-19UHC-39550-29•••-••-7894264-285-4470beverly.davis@aol.com9037 CEDAR LNHoustonTX77065GRP-7022SELECT-EPO
ENRENR-1303512026-06-12T03:01:14ZBRENDA—TUCKER1977-08-28UHC-97550-61•••-••-5628-brenda.tucker13@yahoo.com7764 CENTRAL AVEChandlerAZ85228GRP-9844CHOICE-PLUS-PPO
ENRENR-1332132026-03-31T19:15:05ZSamantha F—Gomez1978-10-28UHC-85750-01—6956281265·samantha.gomez@hotmail.com2653 Jefferson AvenueORLANDOFL32836·GRP-4528NAVIGATE-HMO
ENRENR-1216882026-08-05T09:31:11ZLOGAN—JORDAN01/14/1963UHC-31361-69•••-••-23622243560UNKNOWN3273 Hillcrest RoadLos Angeles··CA90039GRP-0941SELECT-EPO
ENRENR-1185002026-06-18T15:07:57ZHannahS.Robertson12/15/1957UHC7040039•••-••-1399·17626412917—6030 HILLCREST ROADHOUSTONTX77047GRP-6832MEDICARE-ADV-B··
ENRENR-1388832026-05-14T20:18:38Z·Patrick··Gutierrez1945-07-15UHC-23084-68•••-••-727212734832484PATRICK.GUTIERREZ90@OUTLOOK.COM···7750 CAMELBACK RDAustintx78726·GRP-1939MEDICARE-ADV-B
43,101 rows, page 259 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.645Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty