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
ENR ENR-1042102026-02-26T17:23:01Z·Kenneth····Martinez1966-11-26UHC-66774-91•••-••-0307+1 413 645 4750kenneth.martinez24@outlook.com6621 Sage CourtFRESNOCA93735·GRP-5749NAVIGATE-HMO
ENRENR-1371952026-10-08T19:05:40ZDenise··Dominguez1972-05-01UHC-13081-73NULL804.511.4895denise.dominguez73@hotmail.com··2833 Palm DrJacksonville··fl··32276GRP-5504·select-epo
ENRENR-1356562026-01-06T18:45:58ZLaura—Silva1989-04-13UHC-50366-19•••-••-0296·712-234-8745laura.silva@proton.me6004 Bayshore DrMIAMIFL33140GRP-2269CHOICE-PLUS-PPO
ENRENR-134571 2026-04-06T15:04:02ZHannah—Nguyen1939-07-28UHC-93448-83•••-••-59779458314352hannah.nguyen@proton.me8600 LINCOLN WAYLos AngelesCA·90071GRP-7070CHOICE-PLUS-PPO
ENRENR-1019182026-08-22T09:36:56ZGERALD P—·SULLIVAN1938-07-08UHC-32009-78•••-••-9044·+1 488 705 9377GERALD.SULLIVAN35@GMAIL.COM5553 Grand Avenue Apt 2DALLASTX75264GRP-3338CHOICE-PLUS-PPO
ENRENR-120666 2026-04-04T10:40:25ZJoeHJensen02/13/1986UHC-10382-91—(273) 492-0821JOE.JENSEN@YAHOO.COM3667 Camelback RoadPhoenixAZ85057GRP-4148CHOICE-PLUS-PPO
ENRENR-1029792026-08-01T11:03:49ZJessicaRDunn1951-04-06UHC-68316-98•••-••-6814(354) 262-6045null1328 Palm DrLos Angeles·CAN/AGRP-5759MEDICARE-ADV-B
ENRENR-1408572026-03-01T18:47:28ZOMARXJACOBS1995-09-22UHC-24754-97•••-••-0172(903) 465-6337··OMAR.JACOBS@OUTLOOK.COM6910 Meadow LnCharlotte·NC28216GRP-4950medicare-adv-b
ENR ENR-1227562026-05-18T09:01:12ZJacobs, Samantha——26-10-1952UHC-57057-69•••-••-3272+1 430 409 1805samantha.jacobs84@icloud.com··1353 Meadow LnMesaAZ85238GRP-3445··MEDICARE-ADV-A
ENRENR-125399 2026-03-08T00:55:58ZDixon, VincentC—1985-07-10UHC-85495-07•••-••-6002(216) 316-4367vincent.dixon@hotmail.com7753 PINE DRIVESeattle·WashingtonNULLGRP-3647MEDICARE-ADV-B
ENRENR-1000702026-05-05T12:24:06ZKARENAGREEN1978-04-13·UHC-50857-06•••-••-9055976.328.8295KAREN.GREEN@PROTON.ME6560 OCEAN AVENUEChandler·Arizona85253GRP-6404CHOICE-PLUS-PPO
ENRENR-1367202026-08-31T16:37:10ZAmy—Carter1974-11-08UHC-60876-16•••-••-65263575396AMY.CARTER@AOL.COM5782 Jefferson AveSEATTLEWA98132GRP-7860MEDICARE-ADV-B
ENRENR-1131342026-01-23T22:15:48ZPHILIPUMONTOGMERY11/16/47UHC-95197-13•••-••-5414+1 972 455 0747··PHILIP.MONTGOMERY@OUTLOOK.COM2672 Spring StSan AntonioTX—GRP-4618MEDICARE-ADV-B
ENRENR-134278 2026-09-23T08:27:50ZJoanKLong1997-04-21UHC-83158-92•••-••-0939(748) 941-9596joan.long53@aol.comUNKNOWN-UNKNOWN···GRP-0340SELECT-EPO
ENRENR-1311202026-02-17T22:52:34ZAnnaAThomas19580508UHC-06806-55•••-••-49315274791301ANNA.THOMAS84@AOL.COM-····—NULLGRP-1399CHOICE-PLUS-PPO
ENRENR-1321202026-02-03T07:51:10ZJOSEPHY.MURPHY1986-04-22UHC-65775-64null5418113743null3201 Park PlSan DiegoCA92122GRP-6384MEDICARE-ADV-B
ENRENR-1059572026-02-27T15:00:35ZCamila—Perez1974-09-02UHC-02092-18•••-••-05238224217416CAMILA.PEREZ76@GMAIL.COM3967 Highland AvenueLos AngelesCA90065GRP-5877NAVIGATE-HMO··
ENRENR-1078492026-04-05T09:01:16ZDONALD—MORENO03-11-1995UHC-24900-28•••-••-75453753515donald.moreno@yahoo.com5093 Pine Dr·TucsonAZ85796GRP-5322CHOICE-PLUS-PPO
ENRENR-1081692026-01-05T07:52:36ZFox, Noah——04/07/1999UHC-77666-11•••-••-0490nullnoah.fox49@icloud.com4470 MEADOW LANEDallasTX75286·GRP-1484MEDICARE-ADV-A
ENRENR-1026612026-03-26T17:17:34ZWalker, PeterI··1986-04-18—•••-••-5652309-507-4509PETER.WALKER@YAHOO.COM5541 Palm DrGlendaleAZ85386GRP-8113SELECT-EPO
ENRENR-1241212026-09-09T03:35:13ZAaronG.Torrees2005-10-11UHC-95701-02•••-••-2607+1 428 862 9887aaron.torres@gmail.com6393 MOUNTAIN VIEW DR Apt 3Minneapolismn55468GRP-6144·NAVIGATE-HMO
ENRENR-1118272026-04-09T00:04:44ZNicole—Perry1983-02-16UHC5984457·-(606) 551-8728NULL8679 JEFFERSON AVENUEPHOENIXAZ85068GRP-0758MEDICARE-ADV-A
ENRENR-115677 2026-04-25T01:21:25ZBruce—Santos··1938-03-13UHC-76917-53•••-••-7656(327) 800-8470bruce.santos@gmail.com9658 Pine DriveGilbertAZ85288GRP-1903NAVIGATE-HMO
ENRENR-1271272026-08-01T12:24:11ZTheresa—Murray19740813··UHC-57458-89•••-••-8040630.930.9580theresa.murray@icloud.com·7975 HILLCREST RD Apt 9San DiegoCA92157-7863GRP-2991OPTIONS-PPO
ENRENR-1050752026-10-02T12:16:59ZAbigailZRoss1995-08-04UHC-71602-30•••-••-12017324722608null6230 Mesa DrGlendale··AZ··85314GRP-9095MEDICARE-ADV-B
ENRENR-1116152026-09-12T22:21:24ZJIM—PARK04/11/08UHC-67554-44—8294995123james.park@icloud.com5255 CHURCH STSeattleWA98113··GRP-0516medicare-adv-b
ENRENR-1120192026-06-16T03:06:32ZDonald—Walker2002-06-26UHC-23250-48N/A2969652931donald.walker@gmail.com6076 Palm DriveTempe·az85264GRP-3131CORE-HMO
ENRENR-1033322026-05-12T23:36:19ZPAULY.SCOTT·1973-12-17UHC-74475-19•••-••-51962893297683··—3447 Maple AvenueJacksonvilleFL32272GRP-8492MEDICARE-ADV-A··
ENRENR-1067742026-10-02T19:07:52ZLindaRElliott1966-11-28UHC-90738-32•••-••-2798557.774.1928NULL6169 Lake View RoadATLANTAGA30323GRP-5208CHOICE-PLUS-PPO
ENRENR-1224172026-07-15T11:56:29ZHAROLDW.GUERREROMay 17, 1963UHC-12102-20null(284) 286-4128HAROLD.GUERRERO@HOTMAIL.COM1994 Pine DrAUSTINTX78780GRP-7289··NAVIGATE-HMO
ENRENR-1372242026-10-03T08:37:47ZTerryOMorales1963-09-09UHC-05396-60•••-••-3314NULLnull7651 Elm StPlanoTX75048GRP-7198OPTIONS-PPO
ENRENR-1335012026-07-30T16:38:55ZCharlesZMorales1996-07-06·UHC-79311-87•••-••-30963696264charles.morales@yahoo.com1061 MESA DRIVE·CharlotteNC28244··GRP-8778NAVIGATE-HMO
ENRENR-1002612026-03-28T19:33:26ZJANICEXRIVERA19750423UHC2787912•••-••-7312812-538-0707janice.rivera42@gmail.com708 Baseline RoadDENVER·Colorado80257GRP-8668CHOICE-PLUS-PPO
ENRENR-1324392026-05-06T09:55:31ZBell, John····—1957-01-01UHC-95187-29•••-••-84983195396419john.bell51@hotmail.com8461 UNION STLos AngelesCA90040··GRP-6748CORE-HMO
ENRENR-1189922026-06-28T13:19:46ZBRIAN—WARREN1997-05-09UHC-45028-86•••-••-70268218403552brian.warren84@aol.comN/AN/A—-GRP-5447SELECT-EPO
ENRENR-1366852026-01-10T18:07:31ZHelenK.Brooks10/17/1940UHC-28936-05•••-••-4837·6613048589helen.brooks@outlook.com1516 Main StreetEden PrairieMN55312GRP-9147CHOICE-PLUS-PPO
ENRENR-1218372026-04-25T01:59:36ZRonald—Mejia··03/14/06UHC-87089-23•••-••-06098055248988NULL7266 UNION STMINNEAPOLIS··MN55464GRP-2531SELECT-EPO
ENRENR-1204622026-06-09T18:36:14ZKeithDWalker1996-06-22··UHC-43588-39NULL4463337236keith.walker55@aol.com-N/AUNKNOWNNULLGRP-4159CORE-HMO
ENRENR-1286342026-01-19T10:42:00ZHAROOLD—RIVERA10/21/1954··UHC-92156-95•••-••-6089676-725-0850HAROLD.RIVERA93@PROTON.ME2799 Cedar Lane #734···OrlandoFlorida·32849GRP-9654OPTIONS-PPO
ENR ENR-1387512026-02-27T03:52:12ZBettyBMurray20-04-1986UHC-79482-59•••-••-11755942915107betty.murray@aol.com6683 MARKET STColumbusoh43273GRP-3211MEDICARE-ADV-B
ENRENR-1260352026-10-08T19:38:31ZDeborah—Sanders19570931UHC-37538-29•••-••-9897(742) 378-7788deborah.sanders6@gmail.com3107 Market StreetAtlantaGA—GRP-9195OPTIONS-PPO
ENRENR-1015422026-01-28T14:54:31Zfatima—davis1997-04-15UHC-77945-54•••-••-2824(933) 422-8741UNKNOWN··35 Cedar LnChandlerAZ-GRP-1195SELECT-EPO
ENRENR-1264072026-08-26T02:10:57Z·virginia—·wilson1999-05-18UHC8826797•••-••-80447818306virginia.wilson12@hotmail.com7763 Oak StreetSAN ANTONIOTX78268GRP-8161CORE-HMO
ENRENR-1384402026-07-11T20:39:58ZkimT·reynolds1958-05-25UHC-85504-11··—KIMBERLY.REYNOLDS@HOTMAIL.COM9123 Desert Sky BlvdMinneapolisMN55471·GRP-8561CORE-HMO
ENRENR-119650 2026-07-11T23:10:12ZScottH.Kim1962-07-02UHC-69089-17•••-••-358519322842075scott.kim@aol.com4664 Spring StreetChandlerArizona··85221GRP-3966select-epo
ENRENR-1287072026-08-31T13:33:01ZANDREABMARQUEZ10/18/08UHC-63854-86•••-••-0277(647) 361-8372ANDREA.MARQUEZ38@AOL.COM··7039 Grand AveHoustonTX77056·GRP-7386CORE-HMO
ENRENR-1032642026-09-12T03:04:37ZDiana··A.Hernandez11/2/1968UHC7730919UNKNOWN929-867-5262·diana.hernandez@proton.me2531 Indian School Road·TucsonAZ85707GRP-3000CORE-HMO
ENRENR-1199452026-05-24T15:54:47ZLoganSRomero1948-08-03UHC-29691-98·UNKNOWN216-338-6986logan.romero3@outlook.com3367 CENTRAL AVENUELos AngelesCA90020GRP-0201MEDICARE-ADV-A
ENRENR-1357312026-09-06T14:03:26Z·Isabella R—Wong2002-04-02UHC-26829-40—+1 214 393 1205ISABELLA.WONG@OUTLOOK.COM7567 SAGE COURTGilbertAZ85263GRP-7969CORE-HMO
ENRENR-120280 2026-07-29T04:50:20Z·WayneDRobinson03/08/81·UHC-81887-49•••-••-95539208112178N/A5518 Grand AvenueMiamiFL33132GRP-5428MEDICARE-ADV-A
43,101 rows, page 332 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:43.627Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty