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-1229662026-06-02T15:13:34Z CHARLOTTE—DUNCANNov 8, 1989UHC-98897-59•••-••-6459·454-918-3873charlotte.duncan@yahoo.com9268 VALLEY VIEW DRColumbusOH··43264GRP-5933OPTIONS-PPO
ENRENR-1251752026-09-09T08:35:30ZSimpson, Terry——1/10/1955··UHC-34152-23•••-••-45676476193420—292 RIVER ROADCOLUMBUSOH43209·GRP-9183CHOICE-PLUS-PPO
ENR ENR-1209922026-01-28T18:28:56ZFuller, Billy··M—1961-03-05UHC5023264NULL247.398.7039··billy.fuller29@aol.com4442 Ocean AveEDEN PRAIRIE··MN55326-6299GRP-4863SELECT-EPO
ENRENR-1223582026-02-21T19:15:01ZWILLIE—RAY1962-02-03UHC-57120-48•••-••-73023673968182willie.ray41@icloud.com4022 Grand AvenueDenver·CO80234GRP-2967CORE-HMO
ENRENR-1353532026-09-29T22:34:23Z·Elizabeth—VasquezFeb 27, 1976UHC9318018•••-••-8766N/AUNKNOWN2167 Mountain View DriveEden PrairieMN55329GRP-9798··NAVIGATE-HMO
ENRENR-1239842026-03-20T02:55:05ZGERALDRROBERTSON1948-03-12UHC-37731-83•••-••-5577····gerald.robertson@hotmail.com·9743 Canyon RoadScottsdale·AZ·85234GRP-8897CHOICE-PLUS-PPO
ENRENR-1155422026-01-05T18:57:30ZParker, Roy A.——01/16/98UHC-22953-37•••-••-8257·(522) 603-2479roy.parker87@icloud.com5194 Cedar Ln··San DiegoCA92158GRP-1816NAVIGATE-HMO
ENRENR-1112572026-04-19T19:12:09ZLisa—Rose-UHC-08980-34•••-••-11684196439762UNKNOWN4673 CHURCH STColumbusOH43243GRP-1181CHOICE-PLUS-PPO
ENRENR-1126782026-07-05T20:47:33ZVirginiaTRiceDec 26, 1942·UHC-60262-09•••-••-2105UNKNOWNN/A6678 LINCOLN WAYFresnoCA93726-6246GRP-8220NAVIGATE-HMO
ENRENR-1106292026-01-05T10:09:30ZAisha··—Myers··1995-02-19UHC-16370-77•••-••-9814nullAISHA.MYERS55@AOL.COM5623 Sage CourtFRESNO·CA93744GRP-7046core-hmo
ENRENR-1012332026-09-02T00:30:00ZJOHN—TAYLOR1791-08-28UHC-19378-10•••-••-6348(467) 385-7651john.taylor@proton.me··8613 Washington Street #791ATLANTAGeorgia30374GRP-5259CORE-HMO
ENRENR-1162292026-07-18T09:11:31ZEdward—Coleman·9171-11-17UHC-77392-61—(632) 970-0454edward.coleman@proton.me7471 Washington StDENVERCO·80222GRP-8962MEDICARE-ADV-B
ENRENR-1064152026-06-09T00:37:46ZVIRGINIAJMUNOZ08/23/1964UHC-21025-48•••-••-40826556513146virginia.munoz@hotmail.com4537 Oak StLOS ANGELESCA90018GRP-2537MEDICARE-ADV-A··
ENRENR-1074232026-03-10T18:29:12ZAngelaAWatkins1970-04-02UHC-18380-85•••-••-68489252754817angela.watkins14@hotmail.com429 Camelback RdAustintx78762GRP-2551CHOICE-PLUS-PPO
ENRENR-1377452026-04-11T14:16:21ZPamela—Ray12/14/2002UHC-77160-65•••-••-5535+1 587 865 6206·NULL8115 Forest AvenueMinneapolisMN55497·GRP-2562CORE-HMO
ENRENR-1415552026-08-09T04:19:26ZJAMES—KELLEY1963-11-03UHC-93869-95•••-••-70874744461093-8087 Sage CtPHOENIXAZ85098GRP-8564CORE-HMO
ENRENR-1162072026-01-02T03:35:59Zsamantha—mccoy1978-08-18UHC-93688-43•••-••-7215285-986-7106SAMANTHA.MCCOY@AOL.COM·6934 HARBOR BOULEVARDSan AntonioTX78239GRP-2898MEDICARE-ADV-B
ENRENR-1403412026-03-23T22:07:26ZFATIMA—CUNNINGHAM··24-08-1968UHC-86786-27•••-••-7232655-767-3822··fatima.cunningham2@icloud.com3972 Washington StreetMinneapolisMN55441GRP-8387SELECT-EPO
ENRENR-1417302026-08-20T08:21:58ZHELENCPARK24-08-1961UHC-89899-49•••-••-9804316-645-9725HELEN.PARK@GMAIL.COM4055 BROADWAYSan DiegoCA92118GRP-4194SELECT-EPO
ENRENR-1125402026-02-11T10:17:44Z KELLYM.WAGNER19550301UHC-43037-05•••-••-43003002215476·null4324 Apache BlvdEden PrairieMN55352GRP-5659MEDICARE-ADV-A
ENRENR-1166212026-09-03T08:25:27ZgraceVarmstrong1956-04-27·UHC-82000-99UNKNOWN18414837781null··8239 Church StTempeAZ85230GRP-5352·MEDICARE-ADV-A
ENRENR-1276252026-01-16T15:55:21ZAMBER—FIELDS10/14/1977··UHC-04870-75•••-••-5545787-661-3893·amber.fields@proton.me2847 Palm DriveSan AntonioTX78277GRP-8050··CHOICE-PLUS-PPO
ENRENR-1024172026-01-09T21:43:06Z·Emily—Warren1996-07-11UHC-27010-24•••-••-1956669-633-0066EMILY.WARREN@PROTON.ME8997 Maple Avenue··MESAAZ·85260GRP-5886OPTIONS-PPO··
ENRENR-1036512026-07-18T08:55:57ZMartha····Chapman11/6/1947·UHC3375750•••-••-5582·(564) 512-9782—6938 Lincoln WaySeattleWA98146GRP-7369OPTIONS-PPO··
ENRENR-1271712026-01-21T09:05:08Z Austin—Hawkins1984-05-25UHC-51169-55•••-••-7348(583) 315-2928austin.hawkins@proton.menullUNKNOWNnullnullGRP-7796SELECT-EPO
ENRENR-1313492026-04-07T07:38:19ZDanielle··—Lee1963-06-15UHC-72052-89•••-••-7096616.915.2305NULL··5751 DESERT SKY BLVDDallasTX·75213GRP-0378OPTIONS-PPO
ENRENR-1397122026-05-29T04:41:08ZLaurenDBarnes09/09/1993UHC-56768-28•••-••-37405672444736lauren.barnes95@hotmail.com9543 Union StreetDenverCO80206GRP-4394··MEDICARE-ADV-B
ENRENR-1245002026-05-12T17:50:37Z EddieB.Russell1991-02-21·UHC-31057-94NULL14029966099EDWARD.RUSSELL@OUTLOOK.COM7133 Meadow LnTucsonArizona85795GRP-3858SELECT-EPO
ENRENR-1295222026-08-11T06:28:56ZBettyPJohnston19770121UHC-31784-85•••-••-0812658.598.4154BETTY.JOHNSTON@HOTMAIL.COM4534 BASELINE RD··HoustonTexas77096GRP-3986··CORE-HMO
ENRENR-1171732026-02-20T18:34:41ZKathryn—Moreno0212-91-88UHC-94649-01•••-••-2182—N/A9188 GRAND AVE Apt 13ColumbusOH43239GRP-8622SELECT-EPO
ENRENR-1399862026-06-15T21:13:53ZkathrynJhall1944-12-23UHC-83097-10•••-••-8050720.832.2452kathryn.hall@proton.me9365 Grand AveMesaAZ85225GRP-2162CORE-HMO
ENRENR-1056012026-02-17T07:06:53Zgabriel—watkins19560822UHC-85652-25UNKNOWN(428) 802-8816UNKNOWN8784 Highland AvenueGlendaleAZ85302··GRP-8094OPTIONS-PPO··
ENRENR-1068222026-06-20T03:49:39ZWillie Z.—Ortiz1958-11-10UHC-48413-91•••-••-1584-willie.ortiz5@yahoo.com1352 Canyon Rd·Eden PrairieMN55301GRP-7026MEDICARE-ADV-B
ENRENR-1267382026-10-18T04:32:47ZHENRYEPAYNE20021025UHC-54738-64•••-••-7902(624) 422-2401·henry.payne@yahoo.com8180 BROADWAY Apt 6Las Vegas··NV89140GRP-7521MEDICARE-ADV-B
ENRENR-1370052026-04-19T16:29:02ZJACQUELINEM.JACCKSON·7/7/1952UHC-10320-15•••-••-93186553373931jacqueline.jackson18@yahoo.com593 Sunset Boulevard·JACKSONVILLEFL32219GRP-2867OPTIONS-PPO
ENRENR-126798 2026-04-12T04:21:52ZPatrick L—Chavez09/23/57UHC-06289-61•••-••-2216(414) 681-3859PATRICK.CHAVEZ@HOTMAIL.COM6009 BASELINE RDDenverCO80283-8628GRP-7985CORE-HMO
ENRENR-1238172026-10-04T21:34:51ZDONNASBELL1944-10-23UHC-52060-01•••-••-97959166127donna.bell@gmail.com2480 CANYON RD·JacksonvilleFL32238GRP-6112·MEDICARE-ADV-A
ENRENR-1250562026-02-14T13:00:31Zcarol—montgomery5/15/1947UHC-11604-54NULL—carol.montgomery16@gmail.com5080 Market St #934FresnoCA93771GRP-4194NAVIGATE-HMO
ENRENR-1128622026-01-08T09:49:41ZGloria—Snyder··1959-11-08UHC-20521-89•••-••-57298993533459NULL8929 Mountain View DriveFRESNOCA93788GRP-3796MEDICARE-ADV-B
ENRENR-1301292026-04-30T18:16:32ZJEN—COOPER1983-07-28UHC-07292-09•••-••-4196(690) 810-8370JENNIFER.COOPER80@AOL.COM8673 Elm St #583DenverCO80270-8338GRP-6082MEDICARE-ADV-B
ENRENR-1397512026-07-05T06:00:53ZRyanT.Hansen1974-02-25UHC-08451-93•••-••-8010461.690.8946RYAN.HANSEN@YAHOO.COM871 Meadow LnSan AntonioTX·78250GRP-7699MEDICARE-ADV-B
ENRENR-1150652026-06-27T06:13:20ZOliviaI.Coleman1966-06-19UHC-80313-12•••-••-22499616464997olivia.coleman@proton.me1107 OAK STREETSan AntonioTexas·78250GRP-7052CHOICE-PLUS-PPO
ENRENR-1018262026-04-16T02:49:15ZCherylKDelgado19-11-1945UHC-94153-76•••-••-1840N/Acheryl.delgado95@yahoo.com4867 Highland AveLas VegasNV89114-3185GRP-5448MEDICARE-ADV-A
ENRENR-1241762026-09-14T20:25:58ZKenQ.Fisher1957-09-07UHC-65531-04•••-••-0862818.997.0147kenneth.fisher25@icloud.com8808 HARBOR BOULEVARDTucsonAZ85745GRP-7229CHOICE-PLUS-PPO
ENRENR-1043852026-10-08T14:31:07ZRachelKHughes06/06/1969UHC-06997-78•••-••-0066(538) 412-6473rachel.hughes@icloud.com3782 MEADOW LNGlendaleAZ85328·GRP-1331medicare-adv-b··
ENRENR-135622 2026-09-11T12:15:50ZNicholasH.Le1977-05-15UHC-49251-67•••-••-4016·8577396860NICHOLAS.LE@HOTMAIL.COM4494 SPRING STOrlandoFL32812GRP-9488CHOICE-PLUS-PPO
ENRENR-1303452026-03-27T08:40:58ZWayne····Munoz01/14/67UHC-01248-01•••-••-9707(769) 676-4295wayne.munoz78@aol.com4772 Church Street #691LAS VEGASNV89109GRP-4365··CHOICE-PLUS-PPO
ENRENR-1036532026-05-04T05:57:38ZAhmedD.Long1959-03-10UHC-80039-45•••-••-1254N/A··AHMED.LONG@OUTLOOK.COM2693 MARKET STREETGilbertAZ85252GRP-8442OPTIONS-PPO
ENRENR-1398942026-09-15T00:20:10ZSophiaH.Richardson··11-02-2005UHC-03647-35•••-••-6316885.316.0073sophia.richardson@icloud.com8204 MEADOW LNSan Diego·CA92131GRP-8130··SELECT-EPO
ENRENR-1259562026-09-15T08:05:58ZMARILYNK.BAKER1953-01-18UHC-56323-85···UNKNOWN·(827) 339-7994marilyn.baker56@outlook.com7712 MESA DRMiamiFL33137GRP-5180MEDICARE-ADV-B··
43,101 rows, page 100 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:37.736Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty