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-1403462026-05-31T04:59:21ZEUGENEF.REYES05/18/1966UHC-92197-11•••-••-1420+1 566 906 2931-9300 MAPLE AVENUELos AngelesCANULLGRP-7486CORE-HMO
ENRENR-1296692026-06-13T19:00:34ZDuncan, DanielleI—2008-05-08··UHC-27925-26—19545299043danielle.duncan29@proton.me4624 CENTRAL AVEJACKSONVILLEFL··32294GRP-0746navigate-hmo
ENRENR-1151872026-10-11T21:07:19ZEVELYN—MARTINEZ··1976-09-16UHC-04589-33•••-••-7921(914) 850-7710evelyn.martinez@icloud.com1377 Mesa DriveTempeAZ85276GRP-0983options-ppo
ENRENR-1142402026-06-03T22:18:59ZRACHELMPORTER10/07/45UHC-27719-91•••-••-47243962702662RACHEL.PORTER59@YAHOO.COM3895 Cedar LaneJACKSONVILLEFL32246GRP-9959SELECT-EPO
ENRENR-1055602026-01-27T04:50:38ZTERRYNGRAY08/14/1939UHC-40056-35•••-••-5512·663.786.7528terry.gray82@outlook.com1181 APACHE BLVDPlanoTX75083-3035GRP-3822MEDICARE-ADV-A
ENRENR-1331122026-07-01T08:34:56Z·Jon—Vargas12/09/1938UHC-70773-53—(980) 736-2296jonathan.vargas@outlook.com6222 MEADOW LANEMesaAZ85276GRP-6022SELECT-EPO
ENRENR-1261282026-02-19T03:51:07ZLe, Paul·S.—11/08/92UHC-35140-55•••-••-44633597307891····3605 Oak StMinneapolisMN55455··GRP-7103MEDICARE-ADV-B
ENRENR-1222162026-02-24T13:04:27ZbobbyH.gutierrez1954-09-11uhc-90316-10•••-••-3130577-586-0113bobby.gutierrez@yahoo.com4638 BROADWAYGilbertAZ85238GRP-0735CORE-HMO
ENRENR-106714 2026-05-27T11:07:56ZWALTERSWALLACE1947-11-07UHC-21909-81•••-••-6501611-753-5138walter.wallace39@gmail.com4602 Washington StreetTAMPAFL33666GRP-5602SELECT-EPO
ENRENR-1069952026-01-14T15:46:48ZARJUNFNUNEZ1967-01-13UHC-00482-13•••-••-7343—ARJUN.NUNEZ@YAHOO.COM4496 Willow CourtTampaFL33655GRP-4474NAVIGATE-HMO
ENRENR-1270992026-07-08T04:07:08ZHiroshi—Perkins1953-07-22UHC-25508-36·-16242744204hiroshi.perkins9@gmail.com5309 OCEAN AVEScottsdaleAZ85280GRP-0966MEDICARE-ADV-B
ENRENR-1425002026-08-21T20:49:23ZBlily—Chapman1967-07-28UHC-98525-46•••-••-1979(944) 529-7700billy.chapman@yahoo.com4007 Grand AveCharlotteNC28283GRP-7959MEDICARE-ADV-B
ENRENR-1202362026-07-19T03:03:34ZSTEVE—MEDINA1986-04-03UHC-17398-49··•••-••-2792933.751.7844-6462 LINCOLN WAYAustinTX78793GRP-1467SELECT-EPO
ENRENR-1281632026-07-29T09:15:07ZMason—·Williams1955-10-23UHC-02946-12•••-••-3841(293) 869-1036·mason.williams11@icloud.com746 River Road··EDEN PRAIRIEMN55343GRP-5252SELECT-EPO
ENRENR-1340022026-02-10T10:50:46ZWillis—Edward11/25/1999·UHC-06109-86——edward.willis95@hotmail.com6430 Willow Court··San AntonioTX78246·GRP-5462OPTIONS-PPO
ENRENR-1263522026-09-30T23:31:36ZRyan—Parker1971-03-17UHC-84299-32•••-••-1765369-902-1863ryan.parker@aol.comN/ANULL—-·GRP-5427·SELECT-EPO
ENRENR-1121762026-05-03T15:49:27ZJaniceCMendoza1998-10-04·null•••-••-7308-UNKNOWN8684 MAIN STSCOTTSDALEAZ85226GRP-8236CHOICE-PLUS-PPO
ENRENR-1103392026-09-08T13:10:50ZRussell—Little1952-07-01UHC-66311-10•••-••-8744nullRUSSELL.LITTLE52@PROTON.ME9059 INDIAN SCHOOL ROADMesaAZ··85210·GRP-5885SELECT-EPO
ENRENR-1186752026-02-17T08:01:36ZABIGAILY.WONG1966-03-17UHC0161284··•••-••-9083—abigail.wong7@outlook.com8639 Market St·ChandlerAZ85250GRP-8688SELECT-EPO
ENRENR-1240972026-06-09T06:05:42ZEmily—Boyd19980624UHC-29831-34•••-••-3164NULLEMILY.BOYD@HOTMAIL.COM547 WILLOW CTTUCSON·Arizona—GRP-1629MEDICARE-ADV-A
ENRENR-1331882026-10-11T16:42:17ZEVELYN—ROJSA1973-03-24UHC-01492-83-+1 618 395 2166evelyn.rojas@hotmail.com·4707 Lincoln WayMesaArizona85263GRP-3200··NAVIGATE-HMO··
ENRENR-1396462026-01-28T02:44:22ZVirginia—HansenJul 6, 1944UHC-14278-08•••-••-8344838-671-8672virginia.hansen@outlook.com3692 Sunset BlvdJacksonvilleFL32220-0225GRP-7263NAVIGATE-HMO
ENRENR-1216912026-06-04T14:50:24ZETHAN—RAMOS1942-05-17UHC-43094-43•••-••-96676724027··null8474 Harbor BoulevardEden Prairie··MN55378GRP-2849NAVIGATE-HMO
ENRENR-1072562026-01-22T05:13:47Z·MadisonXMontgomery1976-10-17UHC-92303-01•••-••-07196695928madison.montgomery82@proton.me9194 BROADWAY·GilbertAZ85219GRP-4278NAVIGATE-HMO
ENRENR-1359832026-10-06T01:12:53ZTHOMPSON—·GARY3/11/1995UHC0178592•••-••-2439·(864) 352-9660—9781 Jefferson AvenueFRESNOCA93734·GRP-8155MEDICARE-ADV-B
ENRENR-1344902026-02-08T20:40:35ZPhilip—Freeman1952-09-19UHC-56132-61•••-••-3508(967) 622-0530philip.freeman@icloud.com8036 Camelback RoadColumbusOH43224··GRP-8677MEDICARE-ADV-A
ENRENR-1250812026-08-12T03:35:19ZCatherine—Fuller1961-02-27UHC-08698-57•••-••-949819046520459catherine.fuller@aol.com3944 OAK STREETDenverColorado80224GRP-1990·SELECT-EPO
ENRENR-1356782026-02-23T15:54:03ZcarlMduncan20020521UHC-50959-59•••-••-2614(400) 904-5955carl.duncan@yahoo.com6668 Main StreetSeattleWA98184-8722GRP-5141CORE-HMO
ENRENR-1071002026-07-08T06:10:56ZCATHERINEBBAKER1961-01-05UHC-89089-25•••-••-3455866-908-1451CATHERINE.BAKER52@ICLOUD.COM8109 Sunset BlvdSAN DIEGOCA92152GRP-0377MEDICARE-ADV-A··
ENRENR-1390372026-09-13T17:53:36Zkathryn—fields1981-08-22UHC-93948-39•••-••-449418478402736KATHRYN.FIELDS@AOL.COM7747 Park PlPlano··TXN/AGRP-9536MEDICARE-ADV-A
ENRENR-1315392026-02-10T11:38:14ZGABRIEL—CHEN12/11/1943UHC-95467-99•••-••-07814657267GABRIEL.CHEN87@AOL.COM—-nullNULLGRP-8623MEDICARE-ADV-A
ENRENR-1410672026-06-21T09:44:21ZchristopherOprice10/23/50UHC-95549-18•••-••-7652203-545-5987christopher.price@hotmail.com9397 Apache Blvd·MIAMIFL33103GRP-2391OPTIONS-PPO
ENRENR-1180642026-04-05T12:44:32ZMarillyn—Gomez1956-05-22UHC-73626-55•••-••-8047903.782.7253marilyn.gomez@icloud.com3407 Church StGLENDALEAZ85313GRP-5945CHOICE-PLUS-PPO
ENRENR-1013682026-09-11T23:21:35ZHeather—Ramos1952-08-23·UHC-63011-28•••-••-1277499-336-9586heather.ramos91@hotmail.com8971 Canyon Rd·San DiegoCA··92135GRP-2730MEDICARE-ADV-A
ENRENR-105391 2026-06-03T21:11:19ZAnthony···Vazquez1972-01-07UHC-50620-93•••-••-836116717137525—5806 SAGE COURT··TucsonAZ85797GRP-5592NAVIGATE-HMO
ENRENR-1297032026-05-06T22:13:53ZRamirez, Julia——1960-11-26UHC-27498-24•••-••-85248508208300julia.ramirez@gmail.com4822 Sage CtNashvilleTN37236GRP-6569CORE-HMO
ENRENR-1258422026-06-17T11:55:47ZDonnaPYoung··1959-04-09UHC-09777-54•••-••-8056(205) 222-1233DONNA.YOUNG@ICLOUD.COM9562 Grand Ave #393TampaFL·33640GRP-9548·options-ppo
ENRENR-1227752026-04-03T01:51:06ZMATEOIJAMES01/13/08UHC-62158-56··•••-••-82266355004806MATEO.JAMES@OUTLOOK.COM4536 Canyon RdOrlandoFL·32863GRP-9480MEDICARE-ADV-A
ENR ENR-1362792026-07-30T20:21:38ZChavez, Thomas——19641124—•••-••-86788137306586thomas.chavez82@aol.com146 SUNSET BOULEVARDColumbusOH43282··GRP-5335MEDICARE-ADV-A
ENRENR-1226302026-01-12T12:53:37ZMariana—Matthews13-02-1963·UHC-97332-82•••-••-7614·755-815-9844mariana.matthews25@hotmail.com7420 Jefferson AveTampaFL33657·GRP-9969SELECT-EPO
ENRENR-1118422026-09-20T18:55:09ZGaryGRichards1994-12-26UHC-04217-05•••-••-3460(665) 229-6999GARY.RICHARDS@GMAIL.COM720 Union StMesaAZ85208GRP-6291CHOICE-PLUS-PPO
ENRENR-1068132026-03-08T11:08:31ZEMMA··W·SMITH1968-07-13UHC-75488-97•••-••-8383(927) 687-1215EMMA.SMITH@OUTLOOK.COM7591 Highland Ave #424OrlandoFL32888GRP-1345NAVIGATE-HMO
ENRENR-1415442026-09-22T20:58:53ZROYW.COEL1963-09-07UHC5809591•••-••-1641(617) 279-2682roy.cole19@outlook.com5514 UNION STREETLas Vegas·NV89125GRP-2179CORE-HMO
ENRENR-122373 2026-04-21T17:20:50Z·DANIELXJIMENEZ·Jan 18, 1959UHC-38087-84•••-••-256812503385724-5471 Sage CourtEden Prairiemn55340GRP-4943··NAVIGATE-HMO
ENRENR-1183372026-01-20T17:41:49Z NancyW··Mlils1981-07-20UHC-00702-28··•••-••-67094706389323nancy.mills@gmail.com7380 OAK STREET #505CharlotteNCnullGRP-2734··SELECT-EPO
ENRENR-1245482026-08-09T17:33:42ZBrian—Watson1975-03-19UHC0161426•••-••-16675452026N/A3215 Sage CourtLAS VEGASNV89184GRP-8817CHOICE-PLUS-PPO
ENRENR-1328562026-01-25T09:58:08ZStephanie—Evans1957-09-08UHC-75128-15—4622188704·stephanie.evans@outlook.com9070 Mesa Drive Apt 24SeattleWA··98158·GRP-9678CHOICE-PLUS-PPO
ENRENR-138375 2026-09-12T05:03:38ZCarlos—Bailey1965-04-06UHC-97041-61•••-••-0761215-441-5310—·3595 Mountain View DriveLas VegasNV89180GRP-7462MEDICARE-ADV-B
ENRENR-1224992026-08-01T08:50:21ZAaron—Willis1956-08-01null•••-••-222417356491243aaron.willis@proton.me7533 CEDAR LANECHARLOTTENC··28215GRP-1616··SELECT-EPO
ENR ENR-1326192026-07-05T07:34:26ZNancyZ.Rios1977-08-03UHC-35917-23•••-••-3518623-358-7537—5048 Hillcrest Road·JACKSONVILLEFL—·GRP-7919MEDICARE-ADV-B
43,101 rows, page 308 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:43.601Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty