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-1162612026-03-17T06:42:50ZMarcusI·Hall·1969-12-13UHC1356326•••-••-4389·7726439222NULL3635 VALLEY VIEW DRGilbertAZ—GRP-3504MEDICARE-ADV-B··
ENRENR-1410052026-09-30T22:45:44ZBRUCE T··—GARRETT1962-07-12··UHC-64079-01•••-••-0032822.330.4412—383 CENTRAL AVENUEMiamiFL33114GRP-9000OPTIONS-PPO
ENRENR-1356742026-07-02T15:31:51ZAliceM.Payne9/21/1938UHC-18304-48•••-••-2988(493) 501-7101··-·143 Cedar LnHoustonTX—GRP-8454·OPTIONS-PPO
ENRENR-1391252026-06-07T06:44:27Z Cynthia—Bowman1939-03-23UHC-47047-03•••-••-1627(440) 450-7473CYNTHIA.BOWMAN@GMAIL.COM9189 ELM STREETCharlotteNC-GRP-2109SELECT-EPO
ENRENR-1346592026-06-13T14:02:40ZAaronIWard1982-08-16UHC-75003-39•••-••-5616N/Aaaron.ward@hotmail.com2832 Grand AvenueCharlotteNC28281GRP-2559OPTIONS-PPO
ENRENR-1214272026-06-26T05:33:40ZAngela·VSantos02/03/00·UHC-19477-69•••-••-9472nullangela.santos@icloud.com4704 Hillcrest RdSacramentoCA95867··GRP-4497·CORE-HMO
ENRENR-118277 2026-01-27T23:51:22ZSmith, Maatt——0410-19-96UHC-06789-82•••-••-9761581-515-6902MATTHEW.SMITH@YAHOO.COM8352 Ridge RdSacramento·CA95867GRP-3808··NAVIGATE-HMO
ENRENR-1201582026-08-26T05:20:46ZBrandonG.Watson08/03/99UHC-65481-98•••-••-1692(657) 244-9338·BRANDON.WATSON@ICLOUD.COM3953 River RdFRESNOCalifornia93756GRP-4482NAVIGATE-HMO
ENRENR-1336402026-09-24T14:51:08ZRAY—·GRANT1998-01-11UHC-10097-39•••-••-6075637-575-6524raymond.grant@proton.me5570 Ocean AveMiamiFL33120GRP-9007OPTIONS-PPO
ENRENR-1049532026-08-30T20:33:21ZGRACEBWELCH1951-12-11UHC-39042-44-(969) 816-2203GRACE.WELCH24@HOTMAIL.COM5334 Lake View RoadCharlotteNC28299GRP-5127SELECT-EPO
ENR ENR-1321912026-05-26T23:28:27ZJUAN—CARTER1949-07-13UHC4684258•••-••-89445979309913··—7349 PINE DRCharlotteNorth Carolina··28229GRP-4809CHOICE-PLUS-PPO
ENRENR-1362682026-04-29T18:13:24ZPamelaU.Harvey11/17/1953·UHC-71603-21•••-••-7929(418) 793-5480PAMELA.HARVEY23@ICLOUD.COM5210 RIVER RD Apt 20··San AntonioTX78252GRP-7581MEDICARE-ADV-A
ENRENR-1379802026-03-18T20:47:27Z MadisonS.Mendoza28-10-1979UHC-78916-73•••-••-96268188040770MADISON.MENDOZA@YAHOO.COM7638 LAKE VIEW RDDallasTexas75215GRP-5697SELECT-EPO
ENRENR-1255152026-05-22T12:27:52ZSOFIAYWLLACE1989-07-10UHC-07269-10•••-••-3235951-653-2110—1093 Ocean AveOrlandoFL32845GRP-8516MEDICARE-ADV-A
ENRENR-1382432026-07-30T19:31:55Zlogan—george11/4/2001··UHC-61499-96··651-608-0473logan.george8@gmail.com8208 GRAND AVE Apt 20Fresno·CA93761GRP-5394CHOICE-PLUS-PPO
ENRENR-1159452026-10-15T12:12:59Zaustin—menoza1981-06-10UHC-84847-46•••-••-4421+1 750 488 9876null7071 Indian School RoadFresnoCA·93734-7333GRP-7002··CORE-HMO
ENRENR-1354452026-04-08T02:12:19ZHenrySAlvarado1960-08-24UHC-71930-79•••-••-3810(989) 879-5800henry.alvarado45@aol.com569 Highland AveAUSTINTX78726GRP-9513SELECT-EPO
ENRENR-1420062026-08-02T00:14:04ZSpencer, Karen··——12/21/69UHC-79017-46•••-••-4782(913) 569-8106karen.spencer54@gmail.com1338 Cedar Ln Apt 27Phoenixaz85004-8211GRP-8337OPTIONS-PPO
ENRENR-1391212026-10-03T07:45:42ZChristian—Alexander·20-12-2001UHC-31569-90··N/A(431) 564-5251christian.alexander@yahoo.com6081 Market StDallasTX75291GRP-1960MEDICARE-ADV-B
ENRENR-1165582026-09-16T01:24:16ZLisa—Myers1975-08-10UHC-30198-60•••-••-2917509-288-3210lisa.myers9@hotmail.com6220 Willow CtFresnoCalifornia93710GRP-9741NAVIGATE-HMO
ENRENR-1161072026-05-21T23:49:26ZBRITTANY—MILLER·1938-03-11·UHC-69337-62•••-••-25522285860072BRITTANY.MILLER40@PROTON.MEUNKNOWN-nullnullGRP-0649CHOICE-PLUS-PPO
ENRENR-1159802026-04-15T15:50:53ZLisaPGreene1988-06-07UHC-87282-24•••-••-0702586.805.9584LISA.GREENE@GMAIL.COM2802 Lincoln WayColumbusOH43298GRP-4693MEDICARE-ADV-A
ENRENR-1413342026-08-11T14:52:04ZJacobs, HenryM··1962-05-18UHC-84856-83•••-••-6286645-666-2726null6411 Forest Avenue··Las VegasNV89188GRP-2349CORE-HMO
ENRENR-136702 2026-06-08T05:12:56Z·Randy—Anderson1961-08-19UHC-40734-95•••-••-9475(245) 345-4586RANDY.ANDERSON73@GMAIL.COM8534 Union Street··TampaFL33645GRP-4436SELECT-EPO
ENRENR-1368992026-06-20T06:27:10ZSARA—FULLER1981-12-28UHC-29998-63•••-••-8879205-933-9536SARA.FULLER@OUTLOOK.COM··7171 Sage CourtAtlantaGA30308-7145GRP-9875navigate-hmo
ENR ENR-1231622026-07-15T15:16:24ZLUCIA—HERNANDEZ2003-08-05uhc-88709-12•••-••-0732296.607.6326lucia.hernandez91@outlook.com5947 BAYSHORE DRTempeAZ85287GRP-5778CHOICE-PLUS-PPO
ENRENR-1188272026-06-16T21:30:14ZsteveBhayes03/09/45UHC-96739-90•••-••-6995+1 871 275 2032····5994 Willow CourtScottsdaleaz85264GRP-8871CORE-HMO··
ENRENR-1143372026-05-06T11:25:25ZHolmes, Betty——1947-02-20UHC-36733-86—389-714-3457betty.holmes71@proton.me7379 Grand AvenuePLANO··TX75077GRP-7874CORE-HMO
ENRENR-1349722026-05-21T17:28:41ZRussellQ.Mitchell1960-02-05UHC-20148-03•••-••-5552··russell.mitchell@aol.com4627 HARBOR BOULEVARDAtlantaGA30301GRP-9650NAVIGATE-HMO
ENRENR-1424482026-07-22T08:04:32ZWalter—Alvarez1993-06-09UHC-53497-10N/A(416) 864-7768walter.alvarez60@aol.com3234 Grand AvenueGLENDALEAZ85323GRP-5116SELECT-EPO
ENRENR-1211152026-01-14T02:35:14ZVirginia—Harvey1957-05-13UHC-73952-53•••-••-3286+1 731 289 5539virginia.harvey68@outlook.com5319 Indian School RdSeattle··WA98101GRP-6759SELECT-EPO
ENRENR-1396692026-08-02T07:08:15ZAlexanderURiley1978-11-15UHC-56118-74•••-••-952617774441895alexander.riley@proton.me1212 HARBOR BOULEVARDGilbertAZ85236GRP-5181CORE-HMO
ENRENR-1017162026-09-26T17:34:04ZGeorge··—Chavez20-05-1946UHC-50144-19•••-••-81748123095808george.chavez@gmail.com·7259 Sage Court·DenverCO80275··GRP-5605CHOICE-PLUS-PPO
ENRENR-1158932026-09-14T13:29:48ZOMAR·SREID1989-05-21UHC-53161-33—+1 680 921 3963null6103 Baseline RdDallasTX75203··GRP-9145SELECT-EPO
ENRENR-1086812026-07-05T21:30:12ZGonzales, LauraX—1962-09-03UHC-04399-76null6732664540laura.gonzales12@aol.com·6818 Camelback Road·Las VegasNV··89113GRP-9090CORE-HMO
ENRENR-1070352026-06-12T10:38:19ZRoy—Sullivan2003-08-27UHC-76918-42•••-••-3231507-704-7747ROY.SULLIVAN53@OUTLOOK.COM8596 Apache BoulevardLas VegasNevada···-GRP-5668MEDICARE-ADV-B
ENRENR-1414372026-05-28T07:43:03Zjoyce—contreras04/24/38UHC-80912-70•••-••-59907424853·joyce.contreras@gmail.com675 CHURCH STEden PrairieMN55399GRP-5610NAVIGATE-HMO
ENRENR-1174322026-03-04T15:44:31ZPierce, Jonathan·I—1493-09-18··UHC-45594-56•••-••-8551274-715-8996JONATHAN.PIERCE70@GMAIL.COM·4558 Ocean AvenueChandlerAZ··85237GRP-1156NAVIGATE-HMO
ENRENR-137724 2026-09-19T17:45:06ZDebraZHenry1956-03-09UHC-75978-52•••-••-61549643798020debra.henry1@yahoo.com610 Indian School RdColumbusOH43209GRP-9161OPTIONS-PPO
ENRENR-1163262026-02-19T07:47:17ZAustin—Robertson11/08/1968UHC-21088-14•••-••-473716407955327AUSTIN.ROBERTSON98@HOTMAIL.COM169 Valley View DriveGilbertAZ85284GRP-8811CHOICE-PLUS-PPO
ENRENR-1140182026-07-11T07:20:36ZEllis, James——1954-09-19UHC-94888-30··•••-••-6934+1 373 824 7195james.ellis@yahoo.com7848 LINCOLN WAYDALLASTX75238·GRP-5246CORE-HMO
ENRENR-1385472026-04-13T13:10:07ZVictoria—KellyJan 9, 1973···UHC-21186-40•••-••-4251·(795) 720-5043victoria.kelly@yahoo.com·3621 Sage CourtLos AngelesCA··90025GRP-2760select-epo
ENRENR-1019322026-10-06T01:15:56ZMARYBSIMMONS··9/6/1941UHC-87003-66•••-••-7782555-949-9580mary.simmons@outlook.com5610 River RdSan DiegoCA—GRP-5470SELECT-EPO
ENRENR-1397992026-04-03T09:21:46ZtheresaMmunoz1962-04-06UHC-44745-77•••-••-64368933039828theresa.munoz88@hotmail.com2470 Camelback RdAtlanta·GA30364GRP-8256··MEDICARE-ADV-A
ENRENR-1060222026-05-10T12:13:41ZlawrenceRtucker··2006-11-20UHC-25152-82N/A(629) 579-0626lawrence.tucker98@gmail.com9094 OAK STREETAtlantaGA·30304GRP-8099SELECT-EPO
ENRENR-1272362026-04-07T17:15:52Z Gregory—Pena1998-08-02UHC-97760-95•••-••-90976476280949GREGORY.PENA31@GMAIL.COM8328 BAYSHORE DRDallasTX—GRP-2982CORE-HMO
ENRENR-1370542026-10-03T07:17:07Zmark—ferguson06/06/06UHC-22617-37•••-••-0989866-799-1352-·8257 INDIAN SCHOOL ROADTampaFL33606GRP-5861SELECT-EPO
ENRENR-1231852026-01-07T23:51:01ZDylanNMeyer1984-05-05··UHC-95805-53•••-••-39489836406382dylan.meyer@outlook.com6395 PARK PLScottsdaleAZ·85238GRP-6795NAVIGATE-HMO
ENRENR-1021492026-06-07T08:54:17ZMcCoy, ArjunS—1954-05-11UHC5286482•••-••-233917072696885—3672 Camelback RdOrlandoFL32804GRP-3466CORE-HMO
ENRENR-1195912026-03-26T15:49:07ZJeanIWang1960-03-11··UHC-24681-22•••-••-9859·19645305603JEAN.WANG@AOL.COM501 Church StSan AntonioTX78236-5919GRP-2044···MEDICARE-ADV-A
43,101 rows, page 227 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.606Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty