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-1097622026-01-30T02:36:28Z·EVALYN—BURKE1951-03-08UHC-50936-17•••-••-3043·+1 865 783 1045EVELYN.BURKE@AOL.COM9253 VALLEY VIEW DRAtlantaGA30365GRP-7550MEDICARE-ADV-A
ENRENR-1043802026-08-06T06:32:30Z·JerryUFranklin1983-12-02UHC-03734-38•••-••-8523——4800 Oak StSan DiegoCA92169GRP-0829MEDICARE-ADV-A
ENRENR-1078472026-09-11T08:06:57ZDIEGOFLAWRENCE1973-07-13UHC-54929-35•••-••-184114054655253UNKNOWN7690 Park PlaceColumbusOhio43263··GRP-7992CHOICE-PLUS-PPO
ENRENR-1215932026-07-24T15:02:50ZAnnaF.Bakar··1944-10-27UHC-10154-58•••-••-4609(722) 788-7847anna.baker57@icloud.com3705 PALM DRChandlerAZnullGRP-3642OPTIONS-PPO··
ENRENR-1330422026-03-19T06:21:53Z ZacharyV.FloresMay 17, 1966UHC-91931-94•••-••-34854456029752·ZACHARY.FLORES@GMAIL.COM138 Mesa Drive··AustinTX78720-5646GRP-9103OPTIONS-PPO
ENRENR-1226432026-09-08T19:20:05ZWilliam—Jimenez1982-03-19UHC-21086-40•••-••-0315·6999095822william.jimenez60@aol.com8031 Hillcrest RdORLANDOFL32852GRP-0634··CHOICE-PLUS-PPO
ENR ENR-1267522026-09-30T05:29:27ZSEANRPADILLA1952-08-23UHC-71398-04—(280) 239-6017UNKNOWN1293 HARBOR BLVDEDEN PRAIRIEMN55346GRP-4620MEDICARE-ADV-A
ENRENR-1244772026-05-15T04:26:19ZtheresaGgarrettJun 24, 2007UHC-01910-21•••-••-1665——2521 Willow CourtGilbertAZ85251·GRP-7120SELECT-EPO
ENRENR-1376552026-02-08T21:37:04ZANGELA—CHAPMAN2005-12-21UHC-61148-24•••-••-22942188197066ANGELA.CHAPMAN@GMAIL.COM4051 VALLEY VIEW DRIVEChandlerAZNULLGRP-8642·medicare-adv-b
ENRENR-1274562026-03-03T02:55:01ZnathanH.hicks1968-03-17UHC-64070-56•••-••-5722(742) 906-0359nathan.hicks@hotmail.com1790 Jefferson AveSACRAMENTO··CA95840GRP-1190OPTIONS-PPO
ENRENR-1088562026-02-20T11:13:20ZLisaQMcCoy1991-08-11UHC7903957•••-••-1460-lisa.mccoy@proton.me977 INDIAN SCHOOL RDGlendaleAZ··85359GRP-0261OPTIONS-PPO
ENRENR-1382452026-02-24T14:04:28ZSARHAD.GREENFeb 6, 2005UHC8292401•••-••-1010(557) 258-0730sarah.green@aol.com6549 Apache BoulevardColumbusOhioNULLGRP-8679OPTIONS-PPO
ENRENR-1293462026-05-06T08:35:07ZHiroshiVGonzales1986-06-12UHC-70398-64··•••-••-6067+1 293 621 7265hiroshi.gonzales@aol.com1483 Canyon RdHOUSTONTX77002-5591GRP-1686CORE-HMO
ENRENR-1343642026-07-27T05:06:44ZTylerX.DixonJul 9, 1997UHC-85200-63•••-••-0853907-605-0899····8822 Grand AvenueGILBERT··AZ85230GRP-8291CORE-HMO
ENRENR-1421222026-04-07T21:37:00ZJake—Garcia1988-02-20UHC-83504-38··•••-••-9532(335) 627-1115·JACOB.GARCIA89@GMAIL.COM4780 Meadow LnSeattleWA98126GRP-4114SELECT-EPO
ENRENR-1042972026-09-25T20:31:51ZJustin—Palmer1950-09-24UHC-44225-20•••-••-9348841.720.9064—7502 Pine DrPhoenixAZ85043GRP-8364MEDICARE-ADV-B
ENRENR-1204192026-02-22T12:29:53ZJaniceS·Snyder1938-10-28UHC-41575-25•••-••-1960null-3113 Ridge Rd·TEMPEAZ85222GRP-6720CHOICE-PLUS-PPO
ENRENR-1296582026-03-06T11:38:09Z·KATHRYN—VALDEZ12-01-2002UHC-66093-72•••-••-1081(520) 657-4017kathryn.valdez@gmail.com2666 Union StGlendaleAZ85349GRP-5210MEDICARE-ADV-B
ENRENR-1127322026-10-04T00:12:12ZBruce—·Richardson1953-03-23UHC-31294-01UNKNOWN678.277.5236bruce.richardson@outlook.com8100 Mesa DriveMINNEAPOLISMN55476GRP-2420MEDICARE-ADV-B
ENRENR-1126302026-07-27T16:04:16ZVazquez, Donald——26-05-1960UHC-40919-31•••-••-1472355-612-6829donald.vazquez@yahoo.com1869 MESA DRIVESCOTTSDALE··AZ85210GRP-2910NAVIGATE-HMO
ENRENR-1159362026-07-08T05:49:10ZRALPHYPRICE··1978-07-26UHC-91457-63—(417) 902-0767UNKNOWN·1502 Lake View RdMinneapolisMN55424GRP-3980CHOICE-PLUS-PPO
ENRENR-1358042026-04-26T18:39:45ZBrendaYGonzalez12/25/66UHC-48692-65•••-••-5109·820-214-1642null3145 Apache BlvdHoustonTX77084GRP-6266OPTIONS-PPO
ENRENR-1388222026-03-17T22:34:06Z·Marcus·KRussellnull··UHC-96252-01•••-••-8745(708) 462-8688marcus.russell85@icloud.com3158 Jefferson AvenueTAMPAFL33688GRP-1986CHOICE-PLUS-PPO
ENRENR-1018992026-01-31T04:03:46Z·DianaSMyers04/19/1994··UHC-65881-90•••-••-1063(766) 506-2301—4782 Sage Court #409PLANOTX75060GRP-8889··CHOICE-PLUS-PPO
ENRENR-1230032026-03-03T22:35:11ZChristopherE.Guerrero19900804UHC-94197-05•••-••-420215863839700··null7502 Forest AvenueScottsdaleAZ85226GRP-5723CORE-HMO
ENRENR-1036732026-07-13T12:31:14Z·BRADLEY—GREEN·1991-09-02UHC-95586-02··•••-••-5909667-682-4526bradley.green@outlook.com5243 Meadow LaneTempeAZ85236GRP-4975CHOICE-PLUS-PPO
ENRENR-1149082026-06-24T02:06:40ZStephen—Lawson1977-11-05UHC-77369-17•••-••-4517247-270-7772stephen.lawson30@hotmail.com8901 MEADOW LNNashvilleTN37200GRP-7371·CHOICE-PLUS-PPO
ENRENR-1312852026-06-16T07:10:57ZEVELYNU.CONTRERAS··1977-01-11UHC-14598-48•••-••-1088807-272-4415evelyn.contreras39@hotmail.com8517 Sunset BlvdJACKSONVILLEFL32240GRP-0433OPTIONS-PPO
ENRENR-1224892026-04-04T15:46:03ZRUTHZPRICE1971-01-26UHC-45620-36•••-••-43493438950785UNKNOWN4460 Mesa DriveLas VegasNV89187··GRP-8627MEDICARE-ADV-A··
ENRENR-1245722026-09-20T01:38:21ZPATRICA····SILVADec 22, 2005UHC-24196-87•••-••-33309607109null··5391 Harbor Blvd·LAS VEGAS·NV89117GRP-0392MEDICARE-ADV-A
ENRENR-1045972026-09-03T02:13:23ZGabrielDLeeAug 3, 1950··UHC-80814-15•••-••-401413437463422GABRIEL.LEE@ICLOUD.COM6013 CAMELBACK RDDENVERCO80248-3005GRP-8131·CORE-HMO
ENRENR-1213962026-01-30T09:34:55ZJeremy·Z.Roberts1957-11-11UHC-07810-03•••-••-2290470.917.0656jeremy.roberts68@proton.me897 Oak StMiamiFlorida33130GRP-4864MEDICARE-ADV-A
ENRENR-1057502026-08-21T15:50:16ZISABELLAABURNS1948-08-20UHC-10907-04•••-••-93534113601184isabella.burns37@hotmail.com709 MOUNTAIN VIEW DRAtlantaga··30397GRP-4275NAVIGATE-HMO
ENRENR-1115302026-10-09T11:44:21ZALBERT—BURTON01-07-2004UHC-40536-65•••-••-6842(279) 771-0596null8988 PINE DR #495Tucson··AZ85745GRP-0642MEDICARE-ADV-A
ENRENR-1198382026-09-06T03:53:10ZHiroshi—Sandoval1983-04-18UHC-59762-37•••-••-5369+1 229 221 7009HIROSHI.SANDOVAL12@PROTON.ME6334 Baseline RoadMiamiFL33143GRP-6106SELECT-EPO
ENRENR-1198522026-05-21T02:28:59ZLawson, Janet——19841118UHC-13690-62•••-••-4973(512) 669-4176JANET.LAWSON90@GMAIL.COM6354 Park PlSeattleWA98159GRP-7489NAVIGATE-HMO
ENRENR-1383052026-01-15T19:30:15ZBlack, EmmaR—27-09-1975UHC-75057-97··•••-••-1210(304) 480-7996N/A9463 SAGE COURT··Los AngelesCA90001GRP-8573CORE-HMO
ENRENR-1323012026-08-30T19:49:42ZPatriciaXMorales1986-12-04UHC-47601-34•••-••-0421497-399-5419N/A842 Baseline RdCHARLOTTENC28290GRP-8526MEDICARE-ADV-B
ENRENR-1137972026-01-21T12:09:51ZMyers, EthanV—1989-09-21UHC-42828-10•••-••-98319585583071—3475 HIGHLAND AVENUEScottsdaleAZ85280··GRP-4493·SELECT-EPO
ENRENR-1188842026-03-01T23:37:27Z Kayla··Knight1945-02-22UHC-65232-63•••-••-3841476-834-9187kayla.knight82@icloud.com··3353 Highland AveMesaAZ85246GRP-9793SELECT-EPO
ENRENR-1098352026-07-22T08:09:20ZSHIRLEYE··RICE·1/14/1955UHC-46384-12•••-••-855317628816467-··9570 Harbor BoulevardHoustonTX77069GRP-6661MEDICARE-ADV-A
ENRENR-1211522026-05-01T21:11:03ZANGELAEBAILEY09/23/1948uhc-80041-28•••-••-9021742-640-5263ANGELA.BAILEY@PROTON.ME8818 LINCOLN WAYATLANTAGA··30327··GRP-9632CORE-HMO
ENRENR-1122942026-05-06T06:22:36ZShirley U—Mills10/7/1949UHC6688315—16609816753shirley.mills@outlook.com2854 Bayshore DriveChandlerAZ85213GRP-8736MEDICARE-ADV-A
ENRENR-1202012026-04-27T00:08:10ZEthanMMoore1989-05-21UHC-12841-43•••-••-2441(405) 738-5866ethan.moore@icloud.com9862 Grand AvenueSan DiegoCA92134GRP-6812MEDICARE-ADV-A
ENRENR-1304062026-08-31T08:06:23ZPETER··RPATTERSON1938-02-12UHC-73004-82NULL(269) 299-8112PETER.PATTERSON@ICLOUD.COM209 Elm St Apt 15Eden Prairie··MN55397GRP-0719·NAVIGATE-HMO
ENRENR-1110332026-06-15T03:46:21ZAnna—Li1986-09-07UHC-60433-73•••-••-4866(755) 906-3279N/A8326 Lake View RdSan DiegoCalifornia92121·GRP-7832MEDICARE-ADV-A
ENRENR-1340292026-07-27T11:33:46ZMADISON—COLLINS1977-02-18UHC-42951-30•••-••-5662+1 489 572 7061··UNKNOWN8373 LINCOLN WAYScottsdaleAZ85211GRP-9658MEDICARE-ADV-B
ENRENR-1319242026-06-04T06:47:50Z———1969-04-08UHC-67629-21··(286) 908-2940·null95 MAPLE AVEHoustonTX77023GRP-1927CORE-HMO
ENRENR-1401742026-05-11T11:39:21ZNANCY—LE02/27/85UHC-53754-11•••-••-6501(636) 235-4894nancy.le@hotmail.com···9375 Washington StreetScottsdaleAZ—GRP-9776CORE-HMO
ENRENR-1154362026-08-25T08:07:56Z JEFFREYWWALSH1975-11-19UHC-39012-33•••-••-1035(599) 252-7257jeffrey.walsh@icloud.com2692 Park PlaceFresnoCA93749GRP-8906NAVIGATE-HMO
43,101 rows, page 212 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.354Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty