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-1004802026-09-27T04:31:14ZJason··—Marquez1950-12-14UHC8342995·null(756) 497-2007JASON.MARQUEZ@OUTLOOK.COM8824 OCEAN AVECharlotteNC28294GRP-0152CHOICE-PLUS-PPO
ENRENR-1109202026-08-27T00:56:05ZGrace—HudsonJan 18, 1965UHC-67791-66•••-••-9662620-346-5928—9700 Pine DriveAustinTX78798-9959GRP-0401MEDICARE-ADV-B
ENRENR-1187152026-10-01T18:27:05ZjuanP.park1958-06-03UHC-21610-17•••-••-65034443796223—2614 Grand AvenueTempeAZ85238GRP-9368CHOICE-PLUS-PPO
ENRENR-1318992026-05-14T14:06:41ZHenryK.Dominguez1996-06-23UHC7129618•••-••-47506459976145henry.dominguez26@aol.com4844 Washington StMesaAZ85281GRP-8512··CHOICE-PLUS-PPO
ENRENR-1386842026-03-01T05:14:26ZStephenZKing1969-01-20UHC-15796-58•••-••-8348(219) 977-9871STEPHEN.KING47@GMAIL.COM5493 Meadow LaneLos AngelesCA90019GRP-2317CHOICE-PLUS-PPO
ENR ENR-1357502026-05-21T18:03:40ZJeffreyXFernandez19671226UHC-50567-88•••-••-83922702394330JEFFREY.FERNANDEZ5@ICLOUD.COM1440 MARKET STREETTucsonAZ85737-3138··GRP-8217SELECT-EPO
ENRENR-1330152026-07-25T14:52:48ZCarol··YWeber··09/28/88UHC-25986-60-+1 561 747 1574NULL21 Indian School RdColumbusOH43229··GRP-5431CORE-HMO
ENRENR-1419732026-04-20T12:20:43ZJames—Parker28-05-2000UHC-18847-68•••-••-4826225.602.5860-·4105 Central Avenue Apt 23AtlantaGA30304GRP-3055SELECT-EPO
ENRENR-1289152026-01-03T03:51:50Zanthony—james19870241UHC-64793-65—+1 979 414 7274-2390 Church StGlendaleAZ··85385-2593GRP-2337SELECT-EPO
ENRENR-1333772026-08-13T20:23:09ZARTHURO.CONTRERAS1948-04-08uhc-49476-50•••-••-0843·303-452-1490arthur.contreras@gmail.com1470 Canyon RoadCharlotte··NC28299GRP-8152MEDICARE-ADV-A
ENRENR-1043412026-07-01T02:43:54Z·RACHEL—·GONZALEZ1973-10-17UHC-89828-42•••-••-3008344-409-4592—2830 Valley View Drive··OrlandoFlorida32893GRP-5449CHOICE-PLUS-PPO
ENRENR-1165282026-08-21T03:08:20ZMartin, Ryan——09/08/2008·UHC-11874-06•••-••-4217410-814-3067ryan.martin@proton.me·678 Palm Drive Apt 28MiamiFlorida33187··GRP-1224MEDICARE-ADV-B
ENRENR-1043132026-07-01T04:52:43ZTeresa—Tran1997-11-01UHC4490109•••-••-05868853851323teresa.tran@aol.com9048 Grand AveCharlotteNC28221GRP-9670MEDICARE-ADV-A
ENRENR-1000562026-02-23T17:41:20Zolivia··mejia1996-01-27UHC-99227-11•••-••-7650624-889-4352N/A1802 Forest AveATLANTAGA—GRP-2066MEDICARE-ADV-A
ENRENR-1245972026-07-28T15:34:10ZcarlWbanks07/28/1979UHC-44122-85··•••-••-3427779-571-5705CARL.BANKS48@GMAIL.COM7792 Jefferson AvenueFresnoCA93782-1256GRP-0304NAVIGATE-HMO
ENRENR-1371992026-08-29T16:27:03ZMeganE.··Maldonado1998-02-15UHC-60375-59•••-••-97054149493416UNKNOWN5147 Ocean AvenueAustintx78764GRP-5259MEDICARE-ADV-A
ENRENR-1321592026-04-10T05:13:35Z MARGARET—FORD2008-01-08UHC-83967-28•••-••-1683(372) 776-4500margaret.ford29@aol.com7510 Washington StreetMIAMI··FL33131GRP-0421CORE-HMO
ENRENR-1379182026-06-12T09:38:28ZLucas, Kaayla——1977-08-04UHC-47421-09•••-••-1191·653-797-3895kayla.lucas12@hotmail.com8456 VALLEY VIEW DRIVEEden PrairieMN55377GRP-1042MEDICARE-ADV-B
ENRENR-1322402026-06-06T00:53:29ZJACOB—SANDOVAL1949-10-13··UHC-08097-20N/A··19188184859NULL7354 Mountain View DriveCharlotteNC28213GRP-7004CHOICE-PLUS-PPO
ENRENR-1415152026-06-12T20:46:48ZFullerB.·Christna·06/02/2002uhc-61826-02··•••-••-5665(810) 767-2507christina.fuller@gmail.com24 Bayshore DrDallasTX75257GRP-9949CHOICE-PLUS-PPO
ENRENR-1289252026-01-19T23:38:22ZDanielleHNelson·1986-04-06UHC-74029-67•••-••-7415—DANIELLE.NELSON@AOL.COM1290 Camelback RdORLANDOFL32877GRP-7807MEDICARE-ADV-B
ENRENR-1322532026-09-22T02:40:33ZJuliaFDean1987-60-17UHC-21980-71•••-••-3212(640) 830-2752UNKNOWN5101 Central AveGilbertAZ85221GRP-7190MEDICARE-ADV-A
ENRENR-1286012026-04-11T22:27:39ZDORIS—DOMINGUEZ20060406UHC-59186-32•••-••-822815869387659NULL2312 Canyon RoadLos AngelesCA90011GRP-7095SELECT-EPO
ENRENR-1426982026-06-17T06:42:29ZAnaKMurphy1949-09-21UHC-16418-56•••-••-6227695.817.5225—2678 BAYSHORE DRTempeAZ85265GRP-3255MEDICARE-ADV-B
ENRENR-1117302026-06-23T04:56:11ZWillieQ·Grahem2001-04-23··UHC-19939-09—+1 416 864 1075WILLIE.GRAHAM57@PROTON.ME7899 Willow CtMinneapolis·Minnesota55468GRP-6956NAVIGATE-HMO
ENRENR-1348462026-04-02T20:19:04ZAhmed—Fisher1970-04-26UHC-88024-63•••-••-31927932106193AHMED.FISHER@GMAIL.COM3622 Church StreetSan DiegoCA92106GRP-1265CORE-HMO
ENRENR-1359602026-03-04T01:22:31ZDanielleKCrawford2002-09-25UHC-73270-57•••-••-3139+1 665 583 5578DANIELLE.CRAWFORD26@OUTLOOK.COM··3798 DESERT SKY BOULEVARDPhoenixAZ85033-5963GRP-3252SELECT-EPO
ENRENR-1209212026-08-18T16:27:53ZCHRISTOPHERYNGUYEN1994-01-27UHC-96313-19•••-••-0405(887) 817-5500christopher.nguyen@hotmail.com8876 Desert Sky BlvdDallasTX··75203GRP-8874CHOICE-PLUS-PPO
ENRENR-1380152026-06-15T08:45:39Z·mason—parkins1994-10-14UHC-30649-64•••-••-3452(383) 989-0583null9500 Apache BlvdOrlandoFL32833GRP-6708CHOICE-PLUS-PPO
ENRENR-1148332026-01-10T09:51:54ZAlexisD.West1988-07-16UHC-45209-44•••-••-4533545-623-7135alexis.west90@hotmail.com·3085 RIDGE RDLos Angelesca90031GRP-2053OPTIONS-PPO
ENRENR-1199752026-08-19T15:27:04ZCarolUPena26-03-1995UHC-31476-15•••-••-0167457-609-1072—2755 Palm DriveJacksonvilleFL32245GRP-6523MEDICARE-ADV-B
ENRENR-1210912026-04-09T12:10:46Z·ETHAANJWARREN03/11/1983UHC-72208-50•••-••-98615218903019ethan.warren15@proton.me3131 Elm StreetSacramentoCA95803GRP-6356··CHOICE-PLUS-PPO
ENRENR-1195782026-07-18T14:19:10ZjoshuaV··wallace1990-03-27UHC-69314-99•••-••-7631(814) 986-5870JOSHUA.WALLACE10@YAHOO.COM2783 Oak St·JacksonvilleFL32215··GRP-6113NAVIGATE-HMO
ENRENR-1131882026-08-23T09:06:31ZKevniEMorris1995-12-22UHC4744206—-kevin.morris@icloud.com2467 Indian School RoadTucson·AZ85769GRP-3649SELECT-EPO··
ENR ENR-1226332026-02-14T08:06:28ZShyrleyBGrantAug 11, 1947UHC-92680-53•••-••-1290949-818-9244UNKNOWN122 FOREST AVENUEScottsdaleAZ85240GRP-9500MEDICARE-ADV-B
ENRENR-1119112026-03-11T17:25:45ZAliceB··Reid1950-07-06uhc-19821-29•••-••-65932507012884N/A3716 Harbor BlvdOrlandofl32861GRP-0161CORE-HMO
ENRENR-1285132026-01-22T04:07:52ZRoger—Dominguez1944-05-15UHC-71838-89•••-••-520017204121553—527 Sage CourtGlendaleAZ85391GRP-9586CORE-HMO
ENRENR-1237002026-03-01T09:28:18Zsam—brown1943-06-26··UHC-13988-27•••-••-6046799-503-7961samantha.brown@yahoo.com5214 Park PlaceHoustonTX77094-9961GRP-7526OPTIONS-PPO
ENRENR-133387 2026-10-10T05:48:57ZJeanLKennedy1943-08-20UHC-41234-29N/A19806639181NULL3458 MAPLE AVEPHOENIXAZ—GRP-4644CORE-HMO
ENRENR-1207392026-04-15T08:45:44ZPhillips, AlexisF—1958-08-10uhc-25166-11•••-••-828914934434378alexis.phillips@proton.me3344 Ridge Rd Apt 2Sacramento··CA95806-0547GRP-2851·CHOICE-PLUS-PPO
ENRENR-1274532026-04-25T10:43:53ZVincent—Medina1948-06-23UHC-92687-42•••-••-7562423-376-2353vincent.medina@outlook.com··3531 Ocean AvenueNASHVILLE·TN37206··GRP-3109CHOICE-PLUS-PPO
ENRENR-1257962026-08-03T22:07:11ZjanetNmdeina1946-07-22·UHC-79714-34•••-••-8679414.776.0228JANET.MEDINA86@ICLOUD.COM4997 MAIN ST··SEATTLE··WA98104-5150GRP-1490CHOICE-PLUS-PPO
ENRENR-1193952026-08-11T08:04:01ZDennisI.RuizJan 21, 1997UHC-60808-71•••-••-3888264.953.4678null-N/A—nullGRP-7325NAVIGATE-HMO
ENRENR-1297022026-08-13T05:01:41Z·JERRYNSTEVENS19410525UHC-14916-97•••-••-2066622-786-3129jerry.stevens28@yahoo.com7905 Oak StSan AntonioTX78215GRP-1735CHOICE-PLUS-PPO
ENRENR-1268842026-01-08T01:24:26Z Dominguez, HelenU—2000-05-20UHC-96057-46•••-••-0466297-451-2622helen.dominguez88@aol.com320 PINE DREden PrairieMN55369GRP-4144NAVIGATE-HMO
ENRENR-1009572026-03-01T04:13:51ZJACCOB—LEE1973-06-25UHC-20280-16•••-••-1180427-579-5494JACOB.LEE@HOTMAIL.COM9622 Willow Ct Apt 25ColumbusOH43239GRP-6301CHOICE-PLUS-PPO··
ENRENR-1128412026-05-27T10:03:09ZJordanQ··Berry1957-06-15·UHC-06988-44•••-••-0558789.734.0176-7121 Willow CourtColumbusOH43288GRP-5151SELECT-EPO
ENRENR-1220112026-04-19T04:50:33ZJames, Judy——1967-12-18UHC-80361-61•••-••-488612046686116judy.james90@icloud.comnullNULL—NULL·GRP-7306OPTIONS-PPO
ENR ENR-1324582026-08-31T07:11:42ZLORI—GARRETT·1961-08-22UHC-49310-16•••-••-4122803-941-7996lori.garrett85@yahoo.com4162 Cedar Ln··TucsonAZ85713GRP-7322NAVIGATE-HMO
ENRENR-107050 2026-07-08T04:51:16ZSaraMRay1970-06-23UHC-20937-43•••-••-6774(550) 480-0879null·2228 Jefferson AveLas VegasNV·89120GRP-3895CORE-HMO
43,101 rows, page 322 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.617Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty