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-1295012026-09-05T02:41:59Z ·TheresaKFranklin11/18/1944UHC-24902-41•••-••-2632(404) 686-2638—7509 Willow CourtSEATTLEWA98149GRP-7316NAVIGATE-HMO
ENRENR-1074692026-09-23T23:25:26ZLogaanO.·Miller2007-09-09UHC6441647•••-••-6869517-389-5683logan.miller@icloud.com1524 Cedar LnEden PrairieMN55325GRP-3664OPTIONS-PPO
ENRENR-1216892026-08-24T10:34:29ZEthan—Ramos1942-05-17UHC-43094-43•••-••-96676724027N/A8474 Harbor BlvdEden PrairieMN55378-4344GRP-2849NAVIGATE-HMO
ENRENR-1278992026-10-10T13:37:48ZBrittanyHMendez1946-05-27UHC-75234-10•••-••-28279825017689··brittany.mendez@hotmail.com5701 Baseline RdColumbusOhioUNKNOWNGRP-1502CORE-HMO
ENRENR-1356772026-08-05T10:31:09Zsantiago··Oweber1961-05-14UHC-98761-49•••-••-7000NULLSANTIAGO.WEBER9@ICLOUD.COM1914 Forest AvenueAustinTX78703··GRP-4744MEDICARE-ADV-A
ENRENR-1285872026-10-12T11:21:24ZBILLY—HAMILTON·12/26/1962UHC7751416•••-••-2975546-901-3469billy.hamilton@proton.me2692 Meadow LanePhoenixAZ85025·GRP-8574OPTIONS-PPO
ENRENR-124043 2026-07-08T14:58:26ZMendez, JoseK··1990-12-20UHC-00513-42•••-••-24944155419100UNKNOWN·9467 Spring StreetSan Diego·CA92142GRP-6764CORE-HMO
ENRENR-1201842026-08-10T17:09:53ZRandyL.Daniels1967-02-08UHC-43416-27•••-••-1848+1 982 743 6723randy.daniels@aol.com7140 MOUNTAIN VIEW DRTempeAZ—GRP-8886CORE-HMO
ENRENR-1236732026-08-18T04:12:21ZKatherine—Holmes1985-04-10UHC-14243-68•••-••-70734334280katherine.holmes17@icloud.com3359 Jefferson AveHoustonTX·77016GRP-1495MEDICARE-ADV-A
ENRENR-1303172026-09-18T03:54:20ZMejia, Jacqueline——1996-09-22UHC-84382-67•••-••-8884771-303-2057JACQUELINE.MEJIA87@PROTON.ME9852 BAYSHORE DRTempeAZ85254GRP-9133CORE-HMO
ENRENR-1109862026-02-05T08:35:03ZWright, Justin··Q—Nov 15, 1963UHC2523554nullnulljustin.wright@proton.me4940 Elm StreetPlanoTX75057GRP-8888MEDICARE-ADV-A
ENRENR-1057122026-02-08T13:13:20Z·CatherineARichardson1988-01-10·UHC0064121•••-••-3543424-822-3146CATHERINE.RICHARDSON42@PROTON.ME4471 Elm Street·SeattleWA98189-5373GRP-1029MEDICARE-ADV-B
ENRENR-131069 2026-04-21T12:37:51ZSANTIAGO—·WELCHMay 16, 2005UHC-58279-63•••-••-5529324-483-9393santiago.welch@gmail.com1935 Maple AveNashville··TN37219GRP-7107NAVIGATE-HMO
ENRENR-1087712026-08-23T18:45:31ZSarrahGJams1984-12-20UHC-76376-81•••-••-3903379-246-9344sarah.james@outlook.com3221 Spring StreetAtlantaGA30381-3869GRP-4143NAVIGATE-HMO
ENRENR-1427462026-02-23T14:06:37ZMEGANXSIMPSON05/18/1978UHC-48523-16•••-••-6029971-385-4023megan.simpson47@hotmail.com1714 MOUNTAIN VIEW DRIVENashvilleTennessee··37203GRP-2674choice-plus-ppo
ENRENR-1427582026-08-11T16:44:17ZJANEET··—HERRERA12/16/1962UHC-12904-90—UNKNOWNjanet.herrera@proton.me6086 HIGHLAND AVENUETampaFL33677GRP-9621CHOICE-PLUS-PPO
ENRENR-1407742026-06-02T16:41:24ZSeanVEdwards6/1/1986UHC-81044-89•••-••-9982NULLsean.edwards37@aol.com2719 BroadwayMiamiFL33155GRP-8627SELECT-EPO
ENRENR-1152672026-04-24T18:41:39ZKimberlyHWebb2001-10-11UHC-74710-86•••-••-92267238962839————NULLGRP-9621MEDICARE-ADV-A
ENRENR-1322442026-04-16T22:21:43ZWilliamZFlores·1982-09-18UHC-32542-28•••-••-9035(311) 318-8909william.flores@hotmail.com··4588 Sage CtSacramentoCA95831GRP-2055SELECT-EPO
ENRENR-1337002026-01-10T12:40:34ZERIC—SANDERS08/27/59UHC-95424-50•••-••-1122(954) 557-9690ERIC.SANDERS@HOTMAIL.COM2321 GRAND AVEOrlandoFL32817GRP-5655··CORE-HMO
ENRENR-1271392026-05-27T04:10:55ZBruce—Webb1949-11-27UHC-72042-29•••-••-6235NULLBRUCE.WEBB@ICLOUD.COM1823 Maple AveMESAAZ85221GRP-0968OPTIONS-PPO
ENRENR-1022162026-07-20T11:16:29ZWarren, Mateo—··19720218UHC-09427-02•••-••-466216628564848mateo.warren@outlook.com9718 ELM STSACRAMENTOCA95860GRP-1288CHOICE-PLUS-PPO
ENRENR-1303862026-03-14T07:55:07ZRalph····Owens2005-07-20UHC-90150-27•••-••-3996493-736-8961··RALPH.OWENS38@PROTON.ME5361 Highland AvenuePlanoTX··75016GRP-9295MEDICARE-ADV-B
ENRENR-1413622026-01-31T18:01:22ZJEFFREY—CONTRERAS1981-09-22UHC3377485•••-••-4816+1 766 697 5130jeffrey.contreras64@icloud.com2766 Mesa DriveTucsonAZ85721GRP-4519MEDICARE-ADV-A
ENRENR-1292932026-05-06T14:30:13ZJack—Dunn6/26/1944UHC-52947-29•••-••-0823(339) 346-9805jack.dunn53@aol.com5132 OAK STREETPlanoTX75084GRP-5146MEDICARE-ADV-A
ENRENR-1010552026-01-31T19:08:09Z DebraHBishop·1953-03-62UHC-74782-94•••-••-3035315-794-3023debra.bishop@yahoo.com·5514 Grand AveGilbertaz—GRP-6433SELECT-EPO
ENRENR-1024232026-07-05T22:12:14ZPATRICKP.OSLON4/6/1966UHC-86086-81•••-••-0510563-431-3528PATRICK.OLSON@OUTLOOK.COM6165 Main StreetSan DiegoCA92167-4713GRP-8566SELECT-EPO
ENRENR-1391572026-09-04T22:45:03ZNoahOCampbell19611201UHC-25272-68•••-••-8717+1 303 386 3621··-7910 Harbor Blvd·OrlandoFL32880GRP-0118SELECT-EPO
ENRENR-1173682026-10-12T09:00:47Zcharlotte—thomas1985-04-14UHC-46370-05N/AnullNULL8922 Spring StMesa··AZ··85232GRP-4424NAVIGATE-HMO
ENRENR-1103622026-06-29T09:36:58ZEvelynF.Herrera06/03/1973UHC-88451-95•••-••-0778-evelyn.herrera11@icloud.com2696 BASELINE ROADTampa··FL33643GRP-5413MEDICARE-ADV-B
ENRENR-1081272026-04-19T05:12:00ZHarris, MasonR···2004-01-22UHC-66482-78·N/A+1 363 725 6262MASON.HARRIS@PROTON.ME838 River RdTampaFL33678GRP-5391OPTIONS-PPO··
ENRENR-1347142026-07-25T12:49:09ZKathleen···V·Schultz0104-19-46UHC-54766-31null722.442.2726null··9642 Camelback RoadGilbertAZ85298GRP-4322SELECT-EPO
ENR ENR-1102602026-06-24T04:04:49ZPETERM.GONZALEZ1995-02-07UHC-67948-80•••-••-88974991647-6218 MESA DR Apt 12SCOTTSDALEAZ85246GRP-1731SELECT-EPO
ENRENR-1147352026-05-09T07:30:09ZMASONR.WAGNERApr 13, 1966UHC-90831-50•••-••-6666+1 229 768 1839mason.wagner@aol.com6319 Jefferson Avenue··MiamiFlorida33175·GRP-9042CHOICE-PLUS-PPO
ENRENR-1391162026-07-25T05:14:17ZBrandon—ValdezMar 13, 1941UHC-15383-35•••-••-64527915389560brandon.valdez@outlook.com6227 Apache BoulevardDenverco·80241GRP-3762SELECT-EPO
ENRENR-1421922026-09-23T15:11:40ZJUDITH—CARTER1963-03-07UHC-45269-15•••-••-0783(778) 857-3298—7167 Oak StreetGlendale··AZ85396GRP-1720select-epo
ENRENR-1090802026-06-24T22:50:34ZNATALIEC··RILEY1951-12-26UHC-39071-71··•••-••-8516+1 733 948 1649N/A··9343 Ridge RoadSeattleWA··GRP-8598··CORE-HMO
ENRENR-130359 2026-03-09T00:21:09ZelijahXwells2007-01-01UHC-60287-08•••-••-87558639396·elijah.wells@hotmail.com1081 Central AvenueTampaFL33644GRP-7842NAVIGATE-HMO
ENRENR-1187262026-09-28T22:59:56ZMariana—Marquez1987-06-25UHC-24318-21•••-••-19886053638MARIANA.MARQUEZ@GMAIL.COM42 Oak StreetChandlerAZ85238GRP-7655OPTIONS-PPO
ENRENR-1151262026-08-05T12:25:23ZJosha—Rmos04-07-1952UHC-74813-94•••-••-851113656675262UNKNOWN1749 BroadwayMinneapolisMN55489GRP-0650CORE-HMO
ENRENR-1401082026-05-04T10:35:19Zevelyn—santiagoNov 28, 1990N/A•••-••-6479207-459-9198evelyn.santiago4@gmail.com238 Lake View RdHoustonTX77029··GRP-0547options-ppo
ENRENR-1376602026-04-07T12:03:10ZRodriguez, Betty——01/02/08UHC-69967-28•••-••-5807(828) 457-5874betty.rodriguez@proton.me1339 Spring StreetPLANOTX75083GRP-7422SELECT-EPO
ENRENR-1207902026-02-07T00:33:05ZPorter, KatheenN—1945-12-06UHC-38152-21•••-••-45065145838584UNKNOWN4540 Harbor BoulevardLas VegasNV·N/AGRP-2848CORE-HMO
ENRENR-1167642026-08-22T06:39:59ZJERRYEPORTER··01/22/80UHC-55265-39··•••-••-9044785-546-2350jerry.porter@hotmail.com8480 Forest AvenueTEMPEAZ85215GRP-4319CORE-HMO
ENRENR-1361462026-02-19T07:59:48ZFATIMACWARREN1943-01-18uhc-57298-39UNKNOWN598.336.3300—9247 Oak StreetMINNEAPOLISMN55453GRP-1788CHOICE-PLUS-PPO
ENRENR-1053362026-05-09T05:05:31ZJONATHAN—REED19520294UHC-35512-91•••-••-4503946-738-4338jonathan.reed@icloud.com1324 Camelback Road Apt 1TucsonAZ85799GRP-8975CHOICE-PLUS-PPO
ENRENR-1366152026-03-15T23:36:12ZJustin—Ortiz05-06-1987UHC-24192-57··•••-••-2697922-634-5024—4394 MAIN STSCOTTSDALEArizona85281GRP-7790CORE-HMO
ENR ENR-116569 2026-02-03T00:53:35ZBRUCE—GARRETT1989-00-86UHC-03054-95•••-••-9513NULLbruce.garrett38@hotmail.com2966 Harbor BlvdGlendaleAZ·85324GRP-5850CHOICE-PLUS-PPO
ENRENR-1205782026-03-05T07:17:02ZBEVERLY—HUNTER1996-11-15UHC6157957•••-••-8654·(773) 672-2371N/A121 Desert Sky BoulevardPlanoTX75041-4058GRP-6340NAVIGATE-HMO
ENRENR-1137362026-02-11T04:15:00Z·PATRICKHSANCHEZ1955-04-09UHC-04893-31··•••-••-51482199865988PATRICK.SANCHEZ@PROTON.ME8588 CHURCH STDallasTX·75215GRP-5209MEDICARE-ADV-A
43,101 rows, page 234 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.614Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty