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-1185032026-07-27T15:49:15ZMELISSAQ.REED··06/23/02UHC-35854-27NULL—melissa.reed@proton.me·5544 CEDAR LNDallasTX75272GRP-0678MEDICARE-ADV-B
ENRENR-1164212026-09-26T06:45:50ZCheryl—Pierce1939-01-25null•••-••-0942·299.626.6409cheryl.pierce@proton.me——NULLN/AGRP-0555··select-epo
ENRENR-1332342026-09-20T11:41:37ZWillieL.Roberts05/25/1980UHC-15064-57•••-••-068012079058104willie.roberts33@outlook.com5222 Ridge RoadMiamiFL33107GRP-0926navigate-hmo
ENRENR-1218962026-09-20T07:48:53ZYang, BenjaminY—1944-10-04uhc-43975-07•••-••-1990705.909.2295BENJAMIN.YANG53@HOTMAIL.COMnull····N/AnullGRP-7756MEDICARE-ADV-B
ENRENR-1258972026-06-20T03:34:41ZBEVERLYPLYNCH1991-04-16uhc-58484-01null(835) 314-7482BEVERLY.LYNCH@GMAIL.COM7879 Washington StSacramentoCA95867GRP-5959NAVIGATE-HMO
ENRENR-1156352026-04-25T04:25:00ZANAO.ROBERTS04/15/2005UHC-47420-21•••-••-8677(719) 231-9687N/A8898 Sage CourtNashvilleTN37207-0660GRP-5577NAVIGATE-HMO
ENRENR-1216922026-05-06T13:52:32ZLarson, Susan····—Jul 24, 1945UHC-95867-74•••-••-66659335486323susan.larson94@outlook.com7476 River RdOrlandoFL32830GRP-9999OPTIONS-PPO
ENRENR-1085322026-02-19T15:32:30ZBARBARARLYNCH1958-02-01UHC-29653-61•••-••-853612557232605··-8824 Maple Avenue··AUSTINTX78742GRP-6488SELECT-EPO
ENRENR-1305822026-04-21T04:38:25ZMatthew—Bradley6/22/1974UHC-67838-83•••-••-6052477-602-4405··matthew.bradley@yahoo.com8537 Baseline RoadGLENDALEAZ85300GRP-3843MEDICARE-ADV-A
ENRENR-1339042026-07-26T19:59:59ZMoore, Julie····—2003-01-20UHC7527421•••-••-0174206.724.1656NULL4949 SAGE CTHoustonTexas77072-9387GRP-1183MEDICARE-ADV-A
ENRENR-1308952026-07-20T00:31:16ZHeather—Hamilton5/16/2007UHC5645278•••-••-5036(986) 628-0710heather.hamilton57@aol.com144 Highland AvenueHOUSTONTX77031GRP-8248NAVIGATE-HMO
ENRENR-1293912026-03-15T09:27:29ZTHOMASUBAKER1955-02-04UHC-94453-11•••-••-6761+1 360 244 3718NULL9431 Desert Sky Boulevard··Eden PrairieMN·55392GRP-3469MEDICARE-ADV-A
ENRENR-1144732026-06-25T00:46:16ZZacharyVGray1950-11-27UHC-20003-11•••-••-1038854.619.3731-3317 GRAND AVENUE Apt 9AustinTX78716GRP-9405MEDICARE-ADV-A··
ENR ENR-1045522026-08-26T14:46:16ZKELLYNMORRISON1941-02-03UHC-19138-15•••-••-47766017928052KELLY.MORRISON81@PROTON.ME——N/A-GRP-5107OPTIONS-PPO
ENRENR-1124782026-04-10T14:05:44ZSarahKNunez19720921UHC-98659-08•••-••-918213636441853—3578 Apache BlvdEden PrairieMN55370GRP-6801MEDICARE-ADV-A
ENRENR-1018822026-10-15T01:50:41Z TeresaCHill1990-08-22UHC-82145-43•••-••-4676(731) 517-0560teresa.hill@aol.com8639 MEADOW LNSeattleWA98178GRP-5204··SELECT-EPO
ENRENR-1209132026-04-24T05:13:48ZHarold—Tran4/5/1979UHC-22901-61•••-••-40004353993296N/A9620 BROADWAYCHANDLERAZ85240GRP-8652NAVIGATE-HMO··
ENRENR-1237062026-08-30T22:19:57ZJESSICA—GORDON14-09-1965UHC-38164-21·N/A9532635493jessica.gordon94@hotmail.com7519 Pine Drive Apt 35SacramentoCA—GRP-4546SELECT-EPO
ENRENR-1090442026-05-21T12:19:43ZLAURENGMASON·May 25, 1953UHC-58084-93null(282) 495-6976UNKNOWN2872 Church StreetTEMPEAZ85205GRP-7889CHOICE-PLUS-PPO
ENRENR-1202082026-03-05T23:25:07ZElijahTMorgan24-01-1938UHC-00837-05•••-••-3856261-530-5850elijah.morgan54@outlook.com7632 MARKET ST·FresnoCA93716GRP-5391MEDICARE-ADV-A
ENRENR-1032482026-07-13T12:19:48ZJason—HarveyFeb 16, 1967UHC-58543-46··2644061393jason.harvey@gmail.com7451 Desert Sky BoulevardTampaFL—·GRP-4489OPTIONS-PPO
ENRENR-1336202026-04-20T21:00:18ZweiS.gray1964-01-16UHC-54980-80•••-••-54044453404526··N/A742 Spring StSeattleWA98188GRP-8771NAVIGATE-HMO
ENRENR-1093002026-08-04T11:41:59ZFrankK.Bowman1976-05-12UHC0589840—(840) 341-2160frank.bowman@icloud.com·8692 Desert Sky BoulevardJacksonville··FL32209GRP-5261OPTIONS-PPO
ENR ENR-1124132026-02-19T22:40:10ZGABRIELISCOTT1/17/1981··UHC-48883-22•••-••-6984··NULL··8310 Main StreetSAN ANTONIOTX78235GRP-6113CORE-HMO
ENRENR-1122472026-06-24T20:45:19ZEmma·QEstrada19780301UHC-30271-36•••-••-0506469-690-8266EMMA.ESTRADA52@PROTON.ME7700 Sage CtCharlotte·NC28269-8953GRP-0282SELECT-EPO
ENRENR-1378482026-08-26T12:02:36ZRichard—Parker9/1/1959UHC-64387-14•••-••-3794793-970-5952richard.parker@aol.com5240 Hillcrest RdFresnoCA93784GRP-6526MEDICARE-ADV-A
ENRENR-1187482026-07-18T15:41:18ZSTEVENN.ORTIZ··1795-12-16UHC-23902-47•••-••-767818149220156steven.ortiz99@aol.com8017 Valley View DrSan AntonioTX78260GRP-1874OPTIONS-PPO
ENRENR-1060572026-01-30T20:02:38ZLawrenceC·Ray2003-02-01UHC-13779-44•••-••-34463947482986—2388 OAK STHoustonTX77047GRP-0778NAVIGATE-HMO
ENRENR-1051952026-08-18T15:45:55Zsharon—masson1939-03-23UHC-64168-51—347-720-0972SHARON.MASON@OUTLOOK.COM6653 Park Pl #118ChandlerAZ85209··GRP-6610MEDICARE-ADV-B
ENRENR-1419812026-04-19T09:47:29ZBrandon—Cox02/23/69UHC-48544-40··—714-997-9450-9247 Mountain View Drive·AUSTINTX78796··GRP-6708navigate-hmo
ENRENR-1175932026-09-17T04:13:36Zkathleen—gutierrez·2/19/2005UHC-47968-83··•••-••-3018·(931) 200-4744—8177 PALM DRAtlantaga30319-3517GRP-5126OPTIONS-PPO
ENRENR-1125642026-03-30T11:52:43ZStephanie—Ncihols1973-03-28UHC-36102-54•••-••-15519858213113··stephanie.nichols14@icloud.com6263 Ocean AveGilbertaz85252GRP-6122NAVIGATE-HMO
ENR ENR-1239302026-09-07T19:08:56ZThomas—Barnes1958-12-14UHC-50248-95•••-••-2218757-446-9445thomas.barnes@icloud.com4530 Ridge RdPlanoTX—GRP-9899··MEDICARE-ADV-A
ENRENR-1149532026-01-26T22:10:45ZWheelar, JonathanE.—2007-10-20UHC-72162-77•••-••-91159602096387JONATHAN.WHEELER36@OUTLOOK.COM8429 Hillcrest RoadScottsdaleAZ····GRP-4743OPTIONS-PPO
ENRENR-1351762026-05-25T20:13:56ZRebecca—Rodriguez11/20/1964UHC-98034-10··•••-••-264016947712326rebecca.rodriguez71@outlook.com9840 Ridge Rd #887PlanoTX75077GRP-5454··CORE-HMO
ENRENR-1374172026-07-20T09:15:14ZJohnBBishop1996-08-02UHC-84627-19··•••-••-5893NULLjohn.bishop80@outlook.com3832 Lake View RdNashvilleTN37209·GRP-3958MEDICARE-ADV-A
ENRENR-1060962026-08-26T04:26:55ZlarryQbarnes1983-06-16UHC4405364N/AN/ALARRY.BARNES@YAHOO.COM2439 OAK STGilbertaz··85247GRP-8579··OPTIONS-PPO
ENR ENR-1283332026-08-08T22:11:10ZMelissa—Roberts2003-02-12UHC-97834-07•••-••-2892+1 243 679 7695UNKNOWN8512 Highland AveGlendaleAZ··85370GRP-9316CHOICE-PLUS-PPO
ENRENR-1374692026-05-07T05:41:45ZJoshua—Castro1939-02-12UHC-23978-17··•••-••-1690(459) 977-8642—2052 RIVER ROAD··TUCSONAZ85787GRP-4637OPTIONS-PPO
ENRENR-1077802026-05-01T19:41:40Z BRITTANYBHALL3/6/1964UHC-67985-87··•••-••-72787822663285brittany.hall@aol.com6962 Desert Sky BlvdHoustonTX77081GRP-7779·SELECT-EPO
ENR ENR-1405872026-07-12T20:36:52ZDiane··TMejia·Nov 10, 1969UHC-22232-12··•••-••-720916589315970diane.mejia@gmail.com5573 Ridge RdMiamiFL33155GRP-8843core-hmo
ENRENR-1207692026-03-26T06:26:03ZArjunJCox1972-04-21UHC-56323-03•••-••-0918721.832.2261··arjun.cox@hotmail.com1036 Desert Sky BlvdAtlantaGA30393GRP-5458MEDICARE-ADV-B··
ENRENR-132863 2026-08-10T02:55:29ZJordanXBarnes1939-02-03UHC-71584-67•••-••-8370+1 275 229 7252jordan.barnes64@hotmail.com6024 Main StreetScottsdaleAZ·85298GRP-3416NAVIGATE-HMO
ENRENR-1159062026-03-26T18:53:59ZLeeVJoan1984-11-22uhc-28497-10•••-••-7377796-478-2947JOAN.LEE@AOL.COM7316 Elm StreetSAN ANTONIOTX·78218-2040GRP-4947·MEDICARE-ADV-B
ENRENR-1296122026-09-26T20:33:37ZcharlotteRwelch2005-01-91UHC8603330•••-••-5211(471) 746-3433charlotte.welch@proton.me3149 CEDAR LANEPLANO··Texas75039GRP-4565OPTIONS-PPO
ENRENR-1426882026-05-07T01:10:14ZNunez, Sara——09-06-1940UHC-01441-42null891-719-8125sara.nunez@proton.me3337 Market StLOS ANGELESCA90049GRP-8431CHOICE-PLUS-PPO
ENRENR-1126742026-09-15T17:17:05ZZACHARYKHERNANDEZ1997-06-13UHC-85614-68•••-••-1953+1 927 848 0458—5390 Palm DriveJacksonvilleFL32288GRP-4017MEDICARE-ADV-B
ENRENR-1139542026-08-27T08:28:20ZBenjaminGTran1956-10-03UHC-71519-79•••-••-2771+1 683 281 3198BENJAMIN.TRAN@AOL.COM·8544 Indian School RoadMesaAZ85233GRP-0440OPTIONS-PPO
ENRENR-1405882026-10-13T02:39:27ZBrianJ.Jones1972-02-08UHC-30421-77•••-••-6048(686) 287-8776brian.jones@outlook.com··7746 Canyon Rd #731OrlandoFL32867GRP-7211MEDICARE-ADV-A
ENRENR-1219902026-07-29T13:00:28ZSANTIAGO—PATTERSON···6/28/1960UHC-88650-70•••-••-8375591.342.0133SANTIAGO.PATTERSON@HOTMAIL.COM9129 OCEAN AVETampaFloridanullGRP-1957OPTIONS-PPO
43,101 rows, page 163 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:38.491Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty