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-1217712026-05-02T07:36:21ZEhtan—Welch9/13/1949UHC-59122-39•••-••-1343(531) 747-3232N/A1962 MESA DRIVESan AntonioTX78221··GRP-3894CORE-HMO
ENR ENR-1322912026-07-09T01:48:10ZJoan—Weber1940-06-07UHC-41593-57•••-••-1547(862) 619-8648JOAN.WEBER@OUTLOOK.COM2151 CANYON ROADLos AngelesCA90083GRP-5854MEDICARE-ADV-B
ENRENR-1352722026-09-27T09:24:13ZJASONVMURRAY19910818UHC-05054-69•••-••-4436+1 579 557 2501jason.murray@gmail.com6816 WILLOW CTCharlotteNC28277GRP-1931OPTIONS-PPO
ENRENR-1294582026-05-28T10:38:23ZZACHARY—GEORGE1982-02-19UHC6838452··•••-••-7465(400) 482-2708zachary.george4@gmail.com8626 Ridge RdSeattle··WA98123GRP-2878OPTIONS-PPO
ENRENR-1128022026-03-26T06:33:28Zlogan—lewis··1969-06-02uhc-66714-96—(575) 792-6798logan.lewis40@hotmail.com5160 Church StreetDallasTexas75205GRP-4452NAVIGATE-HMO
ENRENR-129902 2026-08-13T07:37:21ZDianaK.Santiago1990-12-02UHC-76606-90•••-••-64742425485707diana.santiago59@hotmail.com7726 Oak St·TempeAZ85202GRP-2721NAVIGATE-HMO
ENRENR-1362032026-08-31T15:56:20ZkyleDberry19740304··UHC-50009-25•••-••-8913748-340-0614UNKNOWN8080 JEFFERSON AVENUEChandlerArizona··85226GRP-6891NAVIGATE-HMO
ENRENR-1266482026-04-25T22:22:50ZCatherine—Li1990-10-07UHC-53926-42•••-••-1008250.463.0938—6378 Cedar LaneFresnoCalifornia93797GRP-1718CHOICE-PLUS-PPO
ENRENR-1424972026-01-30T18:24:03ZjeffreyVhayes1969-04-15UHC-08387-10•••-••-0056(204) 236-9588JEFFREY.HAYES64@HOTMAIL.COM6799 Pine DrFresnoCA93774GRP-8508CHOICE-PLUS-PPO
ENRENR-1034932026-04-30T13:17:05ZAmberUGraham1969-10-14UHC-21649-01—(672) 935-0845··amber.graham@yahoo.com1919 Park PlScottsdale··AZ85253GRP-0946CHOICE-PLUS-PPO
ENRENR-1263992026-04-25T11:05:39ZMarkULewis1995-06-14UHC-34718-55•••-••-6367·+1 390 311 3806—1859 Indian School Rd·AustinTX78766-6129GRP-1050CHOICE-PLUS-PPO
ENRENR-1298742026-10-17T05:49:25ZSamuelMGarcia2006-02-21UHC-77843-57—(781) 527-3672UNKNOWN6719 Pine DriveMinneapolisMinnesota55443GRP-7737NAVIGATE-HMO
ENRENR-1399252026-10-16T14:38:58ZWilliam, BanksW.··1991-07-21UHC-22405-80•••-••-0766(672) 740-8804william.banks74@aol.com8775 VALLEY VIEW DRColumbusoh-GRP-6264MEDICARE-ADV-A
ENRENR-1270812026-01-29T19:39:36ZWILLIE—DANIELS2006-11-01·UHC-73258-28•••-••-2565292-957-0764·willie.daniels@yahoo.com604 BroadwaySan AntonioTX78218GRP-0119SELECT-EPO
ENRENR-1399402026-09-30T13:35:18ZWatkins, James——1968-03-23uhc-33571-64•••-••-8460889-579-3837JAMES.WATKINS12@HOTMAIL.COM5967 Willow CtEden Prairie··MN55329GRP-2503NAVIGATE-HMO
ENRENR-1130022026-08-03T15:24:29ZBryan—·Williams2007-08-09UHC-08951-32•••-••-17592198365668··——UNKNOWNN/AGRP-4659MEDICARE-ADV-A
ENR ENR-1250572026-09-09T05:29:14ZCHARLOTTE—FOWLER1973-02-10UHC-87423-71•••-••-0385·+1 411 702 7036—5221 Sage CourtTucsonAZ·UNKNOWNGRP-0871··MEDICARE-ADV-B
ENRENR-1333602026-07-17T01:30:04ZNancyJBowman··1995-10-06UHC-51135-38•••-••-02216344900418nancy.bowman52@outlook.com2268 Camelback RdChandlerArizona85212GRP-5639CHOICE-PLUS-PPO
ENRENR-1159832026-03-02T23:55:11ZFlores, BryanO—·1969-04-28UHC-43147-53•••-••-5719846-451-8193bryan.flores@aol.com8493 Market StSan AntonioTX78273GRP-7266SELECT-EPO
ENRENR-1124542026-05-06T13:40:50ZWAYNET.DIEZ1965-01-23UHC-82176-57•••-••-1199971.599.1876wayne.diaz@yahoo.com·4739 Harbor BlvdLas VegasNevada89147GRP-4088MEDICARE-ADV-A
ENRENR-1313922026-02-02T13:35:45ZBRENDA—PATTERSON2003-09-07UHC-55114-04•••-••-58582319647720·BRENDA.PATTERSON58@AOL.COM6271 Willow CtDALLASTX75248·GRP-2445OPTIONS-PPO
ENRENR-1190622026-08-28T17:40:39Zethan—wilson··11/13/1958UHC-81403-98•••-••-750319709564152ethan.wilson@icloud.com··8833 Pine Drive·PhoenixAZ85009GRP-9830··CORE-HMO··
ENRENR-1158652026-05-17T05:37:16ZAmanda—Thompson·1968-12-06UHC-13024-59··•••-••-8227nullamanda.thompson92@icloud.com2452 Hillcrest RdORLANDOFL32800GRP-7479CORE-HMO
ENRENR-1315382026-06-03T13:33:26ZJACK—ROSEFeb 2, 1954UHC3795845•••-••-2417827.478.7053·-1069 PARK PLChandlerAZ·85231GRP-7936NAVIGATE-HMO
ENRENR-1365892026-01-06T14:25:36ZEvans, PaamelaK—1982-04-03UHC-26032-41•••-••-1356566-258-4815PAMELA.EVANS@PROTON.ME2330 Sage CtEden PrairieMN·55322-5777GRP-1662MEDICARE-ADV-A
ENRENR-1300002026-03-21T03:10:10ZbenjaminHrozsDec 11, 1945UHC-24918-60•••-••-3068361-854-9079benjamin.ross@outlook.com8110 Spring Street Apt 38DENVERCO80295GRP-0562MEDICARE-ADV-A
ENRENR-1344812026-09-24T22:41:39ZRobinson, CynthiaT.—08/26/69UHC-25770-44•••-••-628512334150499-1360 Meadow LaneHOUSTONTX77037GRP-4841MEDICARE-ADV-A
ENRENR-1115022026-04-09T11:49:37ZMegan—Montgomery19971107UHC-78243-35-531-804-6103megan.montgomery62@gmail.com··1236 Valley View DrLos AngelesCA90079GRP-8597SELECT-EPO
ENRENR-1420462026-05-27T17:31:31ZRandyWScott03/08/1973UHC-99947-20NULL432-617-8920null2010 Sunset BoulevardTampaFL33625·GRP-0945NAVIGATE-HMO
ENRENR-1372922026-05-16T17:38:07Z christopherPperyr1970-09-16UHC-57512-28——NULL3152 Willow CourtPhoenixAZ85086-8951GRP-2688SELECT-EPO
ENRENR-1247652026-02-19T05:58:24Zkayla A—garrett1993-01-02UHC-84412-04•••-••-8628595-271-1400KAYLA.GARRETT@ICLOUD.COM3765 DESERT SKY BLVDFresnoCA93773GRP-5219NAVIGATE-HMO
ENRENR-1001372026-05-09T18:32:41ZFRANKL.BELL5/3/1985UHC-66685-99•••-••-6778937-893-6329FRANK.BELL75@AOL.COM3666 Elm Street·SEATTLEWashington98196GRP-5741CHOICE-PLUS-PPO
ENRENR-1084022026-04-14T13:03:05ZDorothy—Roe1979-11-05UHC-42865-97•••-••-0598·781-580-0226dorothy.rose63@outlook.com1083 Market StFresnoCA·93779GRP-3770·MEDICARE-ADV-A
ENRENR-1339562026-09-25T21:01:31Z JustinGBennett1996-11-06UHC-31433-79•••-••-8939536-833-6101JUSTIN.BENNETT@AOL.COM7156 BroadwayTampaFL33667GRP-7759OPTIONS-PPO··
ENRENR-1389012026-03-15T10:53:20ZDianeP·Snyder·May 14, 1952UHC-24704-03•••-••-628714466455108diane.snyder56@gmail.com2666 Spring St··AUSTINTX78738GRP-3694NAVIGATE-HMO
ENRENR-1399242026-04-22T21:24:31ZMatthew—·Guerrero1957-02-20UHC-41469-99•••-••-50628762691295N/A1771 Apache BlvdDallasTexas75246GRP-9126MEDICARE-ADV-A
ENRENR-1150982026-04-08T22:20:53ZLAWRENCEHELLIOTT1963-11-23UHC-91149-33•••-••-8849570.777.0831lawrence.elliott97@hotmail.com9034 HARBOR BLVD··DallasTX75278GRP-5162··OPTIONS-PPO
ENRENR-1403012026-09-21T07:05:56ZNOAH—BAILEY1959-02-12UHC-08608-06•••-••-7912439-599-2610noah.bailey@outlook.com2558 Mesa DriveDenverColorado80261GRP-4457CORE-HMO
ENRENR-1089532026-03-11T08:15:07ZEMILY—MURRAY26-04-1939UHC-72032-01•••-••-665314855819334NULL7178 Main St·JACKSONVILLEFL32263GRP-9039·CORE-HMO
ENRENR-1159302026-01-31T19:05:51ZMICHAEL·TMILLSNov 5, 1943UHC2206620nullN/AMICHAEL.MILLS65@GMAIL.COM5025 Highland AvenueLas VegasNV89191GRP-1164··SELECT-EPO
ENRENR-1314832026-10-03T08:49:10ZSharon··WDay03/25/51—•••-••-79253186771··SHARON.DAY@PROTON.ME2905 CHURCH STPlanoTX75072-6991GRP-2452MEDICARE-ADV-A
ENRENR-1096232026-03-26T23:09:12ZAishaDSims9/12/1946UHC-46665-12—17217420187aisha.sims@yahoo.com7274 MARKET STREETEden Prairiemn55336··GRP-1784CHOICE-PLUS-PPO
ENRENR-1296912026-10-17T12:20:25ZseanI.·watkins1968-09-15UHC-94342-84•••-••-5513NULL—3719 Lake View Rd #288PlanoTX-GRP-4608··MEDICARE-ADV-B
ENRENR-1243562026-09-25T13:17:47ZSARAHTBOWMAN2/21/1997UHC-34402-83··•••-••-4956809-450-1550sarah.bowman@yahoo.com8490 Spring StSCOTTSDALEaz85206GRP-9509MEDICARE-ADV-A
ENRENR-1267242026-04-12T11:25:03ZLori—Black1953-07-21UHC-24306-35•••-••-2005(408) 953-3436LORI.BLACK67@OUTLOOK.COM··4320 River RdFresnoCA·93743GRP-0549MEDICARE-ADV-B
ENRENR-1005052026-06-27T19:12:19ZAmanda··IBurke·2002-06-26UHC-78249-63•••-••-14357262857235amanda.burke@outlook.com1132 Forest Avenue Apt 10CHARLOTTENC28298GRP-7432SELECT-EPO
ENRENR-1060182026-07-22T00:38:21ZCharlotteMMoore1976-04-16UHC-23042-69•••-••-8257NULLCHARLOTTE.MOORE63@ICLOUD.COM1479 BROADWAY #575Nashville·TN·37299GRP-9323NAVIGATE-HMO
ENRENR-1293992026-07-12T10:10:33ZRALPHABOYD1/1/1968UHC-61154-85•••-••-3769773-528-0488NULL5343 Bayshore DrNASHVILLETN··37283GRP-8639core-hmo
ENR ENR-1248252026-05-03T07:14:27Z·deniseV.garza10/16/1982UHC-77826-78NULL(413) 559-3814denise.garza94@hotmail.com7798 Central AvenuePhoenixArizona85027GRP-3856CHOICE-PLUS-PPO
ENRENR-1110322026-02-15T16:22:10ZSean···Owens1984-01-05UHC-64788-47UNKNOWN641-704-3423null5632 BASELINE RDSan DiegoCA92137-1702GRP-8392SELECT-EPO
43,101 rows, page 303 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.595Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty