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-1018512026-04-24T14:26:04ZLuisC.Lawrence1957-07-24UHC-89669-02•••-••-8601—·luis.lawrence83@hotmail.com124 LINCOLN WAYFresnoCA93777GRP-9794MEDICARE-ADV-B
ENRENR-1190172026-09-13T19:08:18Zgeorge—jensen1951-03-02UHC-18575-03—430-315-0474-4915 HIGHLAND AVEColumbus··OH43237GRP-0277MEDICARE-ADV-B
ENRENR-1098292026-03-17T00:36:27ZSandoval, CamilaA—1972-06-25UHC-86804-48—615-386-1685camila.sandoval@yahoo.com7717 OCEAN AVEJacksonville·Florida32220-9813GRP-7497MEDICARE-ADV-A
ENRENR-1085432026-08-12T22:34:53ZKaylaSHenry11/11/1969UHC-88085-99•••-••-2236(729) 834-8501··KAYLA.HENRY@HOTMAIL.COM5247 Spring StColumbusOH43222GRP-6746MEDICARE-ADV-A
ENRENR-1067682026-01-05T20:04:06ZPierce, Chaarlotte——1952-11-13UHC-17584-88•••-••-505616294984862—·6045 MEADOW LANESan AntonioTexas78265GRP-9654SELECT-EPO
ENRENR-1410722026-01-29T08:32:38ZKELLY··—FOOWLER9142-10-03UHC-70294-56•••-••-8236(821) 974-9261kelly.fowler97@yahoo.com4775 Washington Street #735MesaAZ85242GRP-4555NAVIGATE-HMO
ENRENR-1377182026-05-14T06:31:58Zann—thomas2002-03-03UHC-82233-43•••-••-5357885-498-6900-9385 HILLCREST ROADFRESNOCA93727GRP-5052OPTIONS-PPO
ENRENR-1257432026-04-13T14:17:08ZJEREMYA.CHEN19680804UHC-98905-98•••-••-3909(901) 642-5683jeremy.chen@hotmail.com6714 Grand AveGlendaleAZ85327GRP-0479MEDICARE-ADV-A
ENRENR-102457 2026-05-10T18:05:14ZPeter—Sullivan07/23/53—•••-••-6254(684) 910-6239peter.sullivan@gmail.com178 Desert Sky BoulevardSan AntonioTX78259GRP-9804··OPTIONS-PPO
ENRENR-1178822026-03-05T05:04:46ZCarol—Gutierrez9/8/1999UHC-45287-35•••-••-6527869-542-7797CAROL.GUTIERREZ97@AOL.COM5447 Church StPLANO·Texas·75085GRP-8694OPTIONS-PPO
ENRENR-1088902026-06-07T04:50:54ZMarthaSWakler1980-04-09UHC-95006-84•••-••-0134(669) 943-8139martha.walker@hotmail.com3756 Indian School Road··AustinTexas78766GRP-3008CHOICE-PLUS-PPO
ENRENR-1001902026-02-21T22:54:25ZKayla—Rodriguez11/15/1983UHC-42876-24•••-••-7099689-798-0668—5184 Valley View DrTucsonAZ85780GRP-1577·SELECT-EPO
ENRENR-1430772026-05-23T05:22:49ZJenniferSCunningham1940-02-25UHC-08687-94•••-••-5106(651) 369-5982··jennifer.cunningham5@yahoo.com9866 HARBOR BLVDGilbertArizona85228GRP-3963MEDICARE-ADV-B
ENRENR-1264972026-03-08T01:30:12ZAlexanderVPatterson14-06-1965UHC-10024-45•••-••-1110(389) 692-3155—5599 Desert Sky BoulevardGlendale·AZ85346GRP-9666SELECT-EPO
ENRENR-1117712026-09-10T19:38:05ZBrandon··GJacobs19550805UHC-10592-72•••-••-7332(851) 973-8549brandon.jacobs@yahoo.com·9500 GRAND AVEOrlandoFL32825GRP-1738··MEDICARE-ADV-A
ENRENR-1324452026-06-29T23:18:39ZCAROLYNX.ADAMS2007-05-26·UHC-88317-80—nullcarolyn.adams90@aol.com6899 CHURCH STREETColumbusOH··43297GRP-5632MEDICARE-ADV-A
ENRENR-1245022026-06-24T06:22:29ZLi, MatthewB.—1961-10-17UHC-62155-73•••-••-4710·16165322624matthew.li@proton.me1754 HILLCREST RDAustinTX78792GRP-3290SELECT-EPO
ENRENR-1426512026-04-23T10:55:58ZOmar·IBryant03/17/1987·UHC-89172-02•••-••-5263251-664-5331omar.bryant14@outlook.com·3274 Willow CourtChandlerAZ85207GRP-8678CORE-HMO
ENRENR-1089772026-04-01T22:07:01ZAmanda—·Hicks1972-10-09UHC-66518-56•••-••-2126595.886.4136—5918 Forest AveMINNEAPOLISMN55439GRP-2110CORE-HMO
ENRENR-1008542026-01-18T01:13:41ZRamirez, Logan··—1944-05-18UHC-91651-40-6686301068NULL3552 Lincoln WayMinneapolisMN55429GRP-4948·MEDICARE-ADV-A
ENRENR-1187502026-08-12T06:15:16ZjeremyAgarrett·1986-01-16UHC-44233-89•••-••-78462268690219JEREMY.GARRETT61@PROTON.ME2598 Cedar LnOrlandoFL32878GRP-1669CHOICE-PLUS-PPO
ENRENR-1030682026-07-16T05:53:26ZBRITTANYSWATKINS1940-07-23-•••-••-5091+1 522 790 7510null642 SAGE COURTChandlerAZ·85280GRP-1503CHOICE-PLUS-PPO
ENRENR-1075892026-01-24T00:45:15ZKelly—WongJun 1, 2008UHC-18814-73•••-••-1011566-456-2492—7943 Pine DriveDallasTX75262GRP-0328MEDICARE-ADV-B
ENRENR-1372082026-07-10T02:03:21Z·Michael—Nunez1991-12-07UHC-34718-24•••-••-5569(370) 498-8608·michael.nunez@hotmail.com6691 Palm DriveAustinTX78728GRP-7165OPTIONS-PPO
ENRENR-1319872026-07-10T06:53:42ZBradleyEFord1988-03-20UHC-73205-59•••-••-75322658032193—4178 MARKET STSeattleWA98147-5246·GRP-7828SELECT-EPO
ENR ENR-1364772026-08-31T22:06:21ZDonna··—Ramos06-10-1995UHC-64152-85•••-••-2829782-723-6431donna.ramos17@hotmail.com·428 Main StreetScottsdaleAZ85253GRP-9368NAVIGATE-HMO
ENRENR-1360952026-09-08T08:53:43ZRONALD—MORENO1997-04-28UHC-09827-65•••-••-2742449.682.5674RONALD.MORENO1@AOL.COM9184 Bayshore Dr··TempeAZ85250·GRP-3702MEDICARE-ADV-B
ENRENR-1405802026-09-01T04:30:41ZELIJAHADANIELSJan 14, 1974UHC-88490-81•••-••-7499327-656-7935··elijah.daniels54@outlook.com3484 Union Street··DENVERCO·80252GRP-2410MEDICARE-ADV-A
ENRENR-1309182026-02-03T16:17:52ZAnthonyP.Median12-02-1995UHC-86103-32•••-••-8655+1 820 397 5478anthony.medina@hotmail.com7982 Park PlOrlandoFL32864-1787GRP-5334MEDICARE-ADV-A
ENRENR-1317452026-04-13T11:39:18ZAlexander—Bryant1960-11-28·UHC-33417-80•••-••-06809542757848alexander.bryant6@yahoo.com4624 CENTRAL AVENUETUCSONAZ85718GRP-4928··CORE-HMO
ENRENR-1050132026-09-22T20:15:36ZEdwards, Kathryn··Z—1960-06-06UHC8767176•••-••-187015299504613kathryn.edwards73@aol.com4681 OCEAN AVENUEAtlantaGA30382-6987GRP-8754MEDICARE-ADV-B
ENRENR-106675 2026-06-23T22:52:22ZJASON··—WALKERJul 11, 1958UHC5285840—9198299272jason.walker65@aol.com8763 Lincoln WayOrlandoFL32826GRP-7686SELECT-EPO
ENRENR-1123592026-04-25T20:56:17ZAbigail—Holmes1990-43-16UHC-14169-27•••-••-4816408-359-6951ABIGAIL.HOLMES@PROTON.ME6461 Main StreetDenverCO80200GRP-8488OPTIONS-PPO
ENRENR-1426632026-05-02T13:57:16ZSusanGPerez1938-06-23·UHC-09172-06•••-••-45848805255677susan.perez@proton.me8072 SAGE COURTChandlerAZ85239GRP-5822CORE-HMO
ENRENR-1214082026-09-13T02:10:23ZCheryl—Torres2005-12-27UHC-89837-37•••-••-9574UNKNOWNcheryl.torres47@proton.me7429 HARBOR BLVDTucsonAZ85713··GRP-5501medicare-adv-a
ENRENR-1373942026-09-10T02:52:00ZSarrah—OBrien03/22/79UHC-18352-69•••-••-195312833381593sarah.obrien31@outlook.com5148 MAPLE AVEMinneapolisMN55474GRP-9618·MEDICARE-ADV-B
ENRENR-1048642026-04-08T18:13:59ZGriffin, Mei——1/25/1958UHC-58308-51•••-••-103919586774686mei.griffin@aol.com7654 Mesa DrSacramentoCA95860GRP-4676·OPTIONS-PPO
ENRENR-1094312026-01-07T01:47:12ZAlan—Lynch1971-03-12UHC9405527•••-••-48083114186759alan.lynch36@outlook.com1005 Desert Sky BoulevardOrlandoFL32837GRP-9645SELECT-EPO
ENRENR-1051362026-08-03T09:10:11ZyukiX.fox1944-10-15UHC-24074-48•••-••-1268+1 935 889 2383yuki.fox91@gmail.com3744 Park Pl #656Denver·CO80247GRP-2083NAVIGATE-HMO
ENRENR-1226832026-08-19T07:53:29ZKatherine—Murphy9/2/2001UHC-54423-95N/A(344) 626-2127-5536 Main StMiamiFL·33178GRP-3523MEDICARE-ADV-B
ENRENR-1217852026-09-29T18:43:48ZSandraR.Dean1964-04-17UHC-04619-87•••-••-23578359641539sandra.dean11@gmail.com8136 LINCOLN WAYEden PrairieMN55349GRP-7884MEDICARE-ADV-B
ENRENR-1059382026-08-13T11:30:30ZGregoryOMeyer06/23/1996·UHC-69051-57—18115237263gregory.meyer@yahoo.com2113 BASELINE RDChandlerAZ85259GRP-8765··core-hmo
ENRENR-1256472026-08-15T06:36:39ZDunn, OliviaB—1956-09-23UHC-37209-76•••-••-6701250-511-1244··7987 Central AveColumbusOH43235-9407GRP-7109···MEDICARE-ADV-B
ENRENR-1368862026-02-14T15:15:18ZBARBARA····HOWELL16-03-1968UHC-00518-51N/A(389) 943-8546··6495 Mountain View DrLos Angelesca90062GRP-1915MEDICARE-ADV-B
ENRENR-1232422026-02-09T20:05:31ZdianaSbailey21-10-1999UHC-96404-93•••-••-2932—diana.bailey74@proton.me3860 SPRING STREETMiamiFL—GRP-8968MEDICARE-ADV-B
ENRENR-1046862026-07-31T21:28:21ZOlivia·NDaniels1944-04-16·UHC-90141-53•••-••-0811299-652-9031OLIVIA.DANIELS26@GMAIL.COM6761 Jefferson AvenueLas VegasNV89183GRP-0873MEDICARE-ADV-B
ENRENR-117233 2026-03-18T03:03:45ZFrank—Howard·1971-07-01UHC-33748-51null(254) 668-3803—5872 Jefferson AvenueNashvilleTN37253-2311GRP-3469OPTIONS-PPO
ENRENR-1325342026-03-10T20:38:22ZJacquelineZ.·Garza20060615UHC-87521-71•••-••-9287(820) 770-7369-5168 Mountain View DriveDenverColorado80237GRP-5212NAVIGATE-HMO
ENRENR-1159072026-07-15T01:28:15ZJENNIFER·A.BOWMAN09/02/1963NULL•••-••-6755—-2036 Sunset BlvdChandlerAZ85290-6450GRP-5037OPTIONS-PPO
ENRENR-1176392026-06-16T23:39:12Z JNETUJONES06/08/81UHC-89184-92•••-••-9937402-733-2026janet.jones84@icloud.com··6096 Lake View Rd··AustinTX78795GRP-0606NAVIGATE-HMO
43,101 rows, page 223 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.601Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty