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-1374162026-04-18T18:22:25ZJULIAOORTEGA04/12/1949UHC-48319-96N/A——2489 CAMELBACK ROAD #902OrlandoFL32874GRP-7337CORE-HMO
ENRENR-1275462026-05-04T18:28:04ZArthur··Kelley·12-10-1973UHC-35949-93•••-••-6351(426) 671-4227—·5723 WASHINGTON STJacksonvilleFL32202GRP-2789CHOICE-PLUS-PPO
ENRENR-1064592026-06-20T05:48:58ZJaccquelineR.Simmons2004-06-06UHC-43996-60•••-••-8444355-771-8495JACQUELINE.SIMMONS30@PROTON.ME50 Indian School Rd Apt 39HoustonTX··77019-8856·GRP-7106·NAVIGATE-HMO
ENRENR-1268312026-04-17T22:18:00ZBrandonY.Hill19801120UHC-54694-59•••-••-6373(342) 825-9762··brandon.hill@gmail.com5926 HILLCREST RDHoustonTX77049GRP-7872NAVIGATE-HMO··
ENRENR-1371602026-08-30T16:36:17ZMichelleGHarrison2000-04-28UHC0455201N/A··(789) 930-7291michelle.harrison@aol.com2767 INDIAN SCHOOL ROADJACKSONVILLEFL32204·GRP-4580navigate-hmo
ENRENR-1193982026-06-19T23:48:15ZLoir··Jones1965-11-17UHC-48852-57•••-••-62068696786494lori.jones@proton.me7860 MESA DRIVEAtlantaGA30367GRP-1543CHOICE-PLUS-PPO
ENRENR-1429022026-01-20T21:19:58ZRACHEL—ESPINOZA1979-08-22UHC-88110-90•••-••-7827(299) 808-7562rachel.espinoza34@hotmail.com7895 PARK PLACEGILBERT·AZ85219GRP-5624OPTIONS-PPO
ENRENR-1111912026-05-11T05:21:59ZJustin—Dean2006-03-28UHC-95839-67•••-••-66756638926850justin.dean61@gmail.com·4096 Maple Ave #755HoustonTX77065GRP-9970CHOICE-PLUS-PPO
ENRENR-1202232026-06-13T18:32:02ZDianaAAguilar1958-08-04UHC-33485-42•••-••-8708(777) 400-6191DIANA.AGUILAR85@GMAIL.COM4656 ELM ST Apt 6ChandlerAZ85277GRP-6690SELECT-EPO
ENRENR-1146272026-09-04T19:03:50ZHughes—Nicole2001-10-12UHC-13273-39•••-••-9981430-577-0794·NICOLE.HUGHES@YAHOO.COM5263 WILLOW COURTColumbusOhio43271·GRP-7719options-ppo
ENRENR-1193662026-03-01T13:26:36ZGabriel····Turner04/09/1979UHC-56012-02•••-••-09958725506548GABRIEL.TURNER@OUTLOOK.COM3298 Pine DrMiamiFL33184··GRP-4381MEDICARE-ADV-A
ENRENR-1063192026-09-15T14:42:58ZLORIECARR14-04-1955UHC-65779-97•••-••-67493584405538lori.carr80@icloud.com994 Apache Blvd··TempeAZ··85298GRP-6952SELECT-EPO
ENRENR-1083612026-08-07T04:21:03ZCARLOSTAUSTIN1990-08-02UHC-10686-47•••-••-1174749-762-1933null7112 MESA DRIVEPhoenixAZ85026GRP-8025OPTIONS-PPO
ENRENR-1202202026-02-02T16:22:34ZNATALIE·XHUGHES7/3/1940··UHC-87123-66•••-••-7937684-225-2901··natalie.hughes13@aol.com4686 Sage Ct #702ChandlerAZ85237GRP-1583CHOICE-PLUS-PPO
ENRENR-1314382026-09-20T03:52:41Zalexander—·robertson1986-05-01UHC-20832-08•••-••-9510(556) 686-5045alexander.robertson41@yahoo.com7728 LINCOLN WAYChandlerAZ85222GRP-1960MEDICARE-ADV-A
ENRENR-1342412026-03-06T18:09:29ZGaryJ·Day1941-04-28UHC9475445··-(949) 247-5260gary.day81@outlook.com4569 Spring StreetColumbusOH43209··GRP-9626MEDICARE-ADV-B
ENRENR-1020762026-08-07T09:43:52ZAlice—Milelr19840108·UHC-81130-30•••-••-1155670-758-2223alice.miller@icloud.com2028 Lincoln WayGLENDALEAZ85311GRP-3980CORE-HMO
ENRENR-1081352026-05-31T16:00:48Z·Jose—Rose·2005-02-22UHC-51129-80•••-••-06442743127133JOSE.ROSE11@OUTLOOK.COM2997 MESA DRIVEOrlandoFL32888GRP-4420NAVIGATE-HMO
ENRENR-1134882026-02-09T15:55:38Z Carter, Frank——02/18/1947UHC-10287-51•••-••-0190NULLFRANK.CARTER@YAHOO.COM8754 Meadow LnTempeAZ85277GRP-0813OPTIONS-PPO
ENRENR-136926 2026-09-24T10:22:07ZSHARON··—BLACK1984-11-25UHC-78692-93•••-••-7578(357) 616-2237null3564 Palm DriveSacramentoca95897GRP-0166MEDICARE-ADV-A
ENRENR-1322262026-04-23T01:40:30ZMarcusOParker1940-09-01UHC-00441-29•••-••-7856426.624.1266marcus.parker@outlook.com7772 PARK PLACE Apt 30GlendaleAZ85322GRP-7038NAVIGATE-HMO
ENRENR-1378742026-08-21T16:14:17ZJUDITH—CARLSON08/13/1962UHC-82292-64—636.955.5002judith.carlson@yahoo.com9441 Canyon RoadSAN DIEGOCA92110-4763GRP-6589OPTIONS-PPO
ENRENR-127502 2026-02-26T09:00:59ZDoris—Santiago·1986-07-04UHC8513697•••-••-9129(758) 881-6808doris.santiago29@hotmail.com6004 Forest AveTucsonAZ85771GRP-4729·CORE-HMO
ENRENR-1109022026-03-06T20:18:04ZNATHANSOLSON19790503UHC-76259-79•••-••-8115390-674-5015nathan.olson21@icloud.com4560 Oak St·MesaAZ85218-7110GRP-1304OPTIONS-PPO
ENRENR-1144492026-04-17T18:36:56ZTeresa—·Richards1985-08-22UHC8311134-268-987-0712·TERESA.RICHARDS9@YAHOO.COM808 Canyon RoadTampaFL33661··GRP-3124OPTIONS-PPO
ENRENR-1191902026-06-02T06:44:31ZRobertson, Nicole··—12-07-1976UHC-67797-47•••-••-405714732463823nicole.robertson36@aol.com3505 SAGE COURT·LOS ANGELESCAnull·GRP-2362NAVIGATE-HMO
ENRENR-1332582026-07-28T20:01:22Z ·JASONUYANG··08/12/2005UHC-26238-79•••-••-2226(717) 509-5041—786 MAIN STREETSan AntonioTX·78295GRP-9045MEDICARE-ADV-A
ENRENR-1032882026-07-31T13:49:30ZchristianKwebb3/12/1970UHC-18196-25··null930.645.1616···-2076 Mountain View DrSan AntonioTX78259GRP-5435CORE-HMO
ENRENR-1293382026-05-23T17:18:35ZbruceI·deanMay 7, 1983UHC-92761-61-450-375-4132BRUCE.DEAN@OUTLOOK.COM1899 Oak StreetHoustonTexas77033-9193GRP-7502OPTIONS-PPO
ENRENR-1174102026-03-24T23:52:01ZJOAN—HAMILTON2005-09-16UHC-96999-97—322-420-9838JOAN.HAMILTON@YAHOO.COM9063 Central AveColumbusOH-GRP-9849MEDICARE-ADV-A
ENRENR-1281332026-06-15T08:58:59ZCox, RyanM.—1963-09-19nullN/A(672) 976-4042ryan.cox41@aol.com3541 Highland AveChandlerArizona85262GRP-4428MEDICARE-ADV-B
ENRENR-1012572026-04-12T09:13:55ZJosephP.Lucas1997-08-08UHC-25670-12•••-••-7553(254) 234-6012joseph.lucas@proton.me6558 MAPLE AVE··PhoenixAZ85001GRP-6735NAVIGATE-HMO
ENRENR-1257732026-10-09T23:54:23ZMaryP.Franklin1942-09-17UHC-63571-51•••-••-6455nullMARY.FRANKLIN78@GMAIL.COM728 Washington StreetAustinTXN/AGRP-1552SELECT-EPO
ENRENR-1201342026-04-09T16:21:06ZRojas, RussellC—19620727UHC-73593-85•••-••-4222(369) 296-7901russell.rojas84@icloud.com3739 BroadwayPlanoTX75062GRP-9857NAVIGATE-HMO
ENR ENR-1408512026-06-19T20:22:15Z Walsh, Cynthia··—10/18/41UHC-88080-45•••-••-0129(414) 970-4324cynthia.walsh@aol.com4910 Oak StTucsonAZ··85775GRP-4322CORE-HMO
ENRENR-1268392026-04-05T15:41:28Zjulie—hudson1997-12-10UHC-36730-68•••-••-41166038443680julie.hudson27@aol.com3395 Ocean AveTampaFL33662GRP-6762·OPTIONS-PPO
ENRENR-1365852026-04-11T21:44:52ZKyleLWeber1987-08-09UHC-48005-03•••-••-3251968-364-5938kyle.weber@icloud.com9279 Forest AvenueSan DiegoCA92182··GRP-1591MEDICARE-ADV-A
ENRENR-1273552026-05-14T22:08:43Zmariana—jackson1992-11-20UHC-36939-96—(499) 631-0529··N/A··8346 Palm DriveAustinTX78738-6998GRP-7864NAVIGATE-HMO
ENRENR-1103412026-09-13T06:14:08ZCheryl··ZRodriguez2007-11-06UHC-52111-29•••-••-15069836704214NULL5851 Jefferson AveFresnoCA93790··GRP-1575MEDICARE-ADV-A
ENRENR-1257012026-01-17T22:47:14Z Angela—Flores19850407UHC-81159-03•••-••-9090—ANGELA.FLORES57@AOL.COM9795 Washington St Apt 26Los AngelesCA90021GRP-2027CHOICE-PLUS-PPO
ENRENR-1214472026-06-29T20:58:39ZWILLIE—LI9190-06-18UHC8120823N/A798-639-4227willie.li6@icloud.com8736 JEFFERSON AVENUELos AngelesCA90075··GRP-5086··OPTIONS-PPO
ENRENR-132886 2026-06-11T05:38:17ZkaylaEedwards2803-19-46UHC-75544-45•••-••-53916002520497-8770 Lake View Rd #676MesaAZ85288GRP-9289NAVIGATE-HMO
ENRENR-1171472026-04-27T03:31:43ZTerryC.··Stephens··1984-10-28UHC-48127-37•••-••-1534725-281-9511terry.stephens@hotmail.com8275 Ocean AvenueSan AntonioTX78277GRP-0564NAVIGATE-HMO
ENR ENR-1054532026-06-29T17:15:34ZSteven—Little22-12-1957UHC1426665•••-••-4407—STEVEN.LITTLE14@YAHOO.COM5404 Market StHOUSTONTX··77069GRP-6357OPTIONS-PPO
ENRENR-1226892026-10-07T11:00:59ZJACQUELINE—JAMSE1991-03-25UHC4565348•••-••-5352UNKNOWNN/A4971 Desert Sky BlvdPlanoTX75087GRP-5203NAVIGATE-HMO
ENRENR-1030122026-06-29T15:27:25Z·FrancesIPorter19490113UHC2399316•••-••-6463(607) 697-7962··frances.porter22@gmail.com173 Broadway #318TempeAZN/A·GRP-5620MEDICARE-ADV-A
ENRENR-1109622026-08-23T10:14:32ZLinda—Lopez1984-05-27·uhc-66609-08····957-308-2904linda.lopez@icloud.com5877 Washington StTucsonAZ85724-6625GRP-6802·CHOICE-PLUS-PPO
ENRENR-1279872026-10-01T05:46:38ZJudy—Spencer1971-11-06UHC5921216•••-••-9502(494) 815-7411judy.spencer75@yahoo.com4397 MESA DRIVENashvilleTN37239-5465GRP-7767SELECT-EPO
ENRENR-1360252026-09-23T18:16:43ZEmily—Duncan1995-02-28UHC-52565-95•••-••-4963309-960-4838-··9117 Harbor BlvdSACRAMENTOCA95818-6192GRP-8505SELECT-EPO
ENRENR-1334242026-04-23T11:09:07ZNUNEZA.THERESA1992-07-19UHC-41718-56··•••-••-7942694-872-9574—5585 Harbor BlvdTucsonAZ85734GRP-5476CORE-HMO
43,101 rows, page 161 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.489Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty