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-1366452026-08-27T08:19:04ZBRUCEJ.COOK2008-02-14UHC-04730-06•••-••-90024388445588bruce.cook@gmail.com5720 Mesa DrSan DiegoCA92199GRP-2870MEDICARE-ADV-A
ENRENR-1320442026-05-14T19:20:19Z·KennethTDiaz2000-11-09UHC-01133-38•••-••-6498—kenneth.diaz@icloud.com5393 MOUNTAIN VIEW DROrlando·FLUNKNOWNGRP-6679OPTIONS-PPO
ENRENR-137130 2026-04-15T02:47:29Zheather—thomas06/10/1966··UHC-81325-84—(258) 316-4560HEATHER.THOMAS@GMAIL.COM1556 UNION STREETSCOTTSDALE·AZ85292·GRP-5394MEDICARE-ADV-B
ENRENR-1260532026-01-21T07:51:49ZMargaretIGutierrez6/5/1990UHC-61468-65•••-••-7216726-358-6525margaret.gutierrez@outlook.com6810 Ridge RoadFRESNOCA93792-8287GRP-9162·OPTIONS-PPO
ENRENR-1221682026-07-23T14:21:39ZKevin N—Reid1941-06-13··UHC-59417-37•••-••-5045273-434-0725kevin.reid@gmail.com7948 Meadow LaneScottsdaleAZ85232-2754GRP-6335MEDICARE-ADV-B
ENRENR-1354782026-04-08T18:28:03ZEDWARDN.RAY1980-01-04UHC-25720-33•••-••-7203(982) 447-3753EDWARD.RAY14@HOTMAIL.COM5698 Palm DrTEMPE··AZ85252GRP-6138··MEDICARE-ADV-B
ENRENR-1283652026-02-19T17:04:20ZEric······Dixon1991-11-09UHC-22960-96•••-••-76729947845UNKNOWN4973 Maple AveCHANDLERAZ85287-7615GRP-0242CORE-HMO
ENRENR-1110932026-02-24T20:49:33ZMARILYN—GRAHAM··1953-04-24UHC-90242-40•••-••-5611+1 842 366 9957MARILYN.GRAHAM@YAHOO.COM1606 Palm DrEden Prairie·Minnesota55342-3745·GRP-1635OPTIONS-PPO
ENRENR-1150992026-08-19T05:31:39ZMICHELLE··—RILEY1939-03-18uhc-95909-02•••-••-6859325-641-3894N/A888 Cedar LaneTucsonAZ··85741-3402GRP-7446select-epo
ENRENR-1011602026-06-16T15:56:59ZJessica F—·Webb02-12-1991UHC-33021-16··•••-••-99902382538105—6576 Market StreetLos AngelesCA90041GRP-0739CHOICE-PLUS-PPO
ENRENR-1072292026-02-03T06:53:26ZLnda—·Stevens05/21/49UHC-29670-57•••-••-3189693-302-2129linda.stevens33@outlook.com5554 Forest AveDALLASTexas·75220GRP-1824CHOICE-PLUS-PPO
ENRENR-1259652026-04-11T14:14:17ZRussell, Aisha——08/03/1961UHC-64455-52•••-••-0104+1 255 667 9446AISHA.RUSSELL69@AOL.COM824 INDIAN SCHOOL RDNASHVILLETN37239GRP-2467··MEDICARE-ADV-A
ENRENR-1077682026-03-07T05:06:57ZJOSEJELLIOTT11/26/2004UHC-09518-38—NULL·JOSE.ELLIOTT@ICLOUD.COM1677 Oak StSan DiegoCA92172GRP-0388CHOICE-PLUS-PPO
ENRENR-1068302026-08-27T14:22:30ZANADCONTRERAS2003-01-57UHC-79284-72—(618) 762-4848ana.contreras37@yahoo.com9416 Ridge RdAtlantaGA·30359GRP-5584MEDICARE-ADV-B
ENRENR-1272542026-06-09T03:44:12Z SANTIAGO—PARK1941-08-20UHC-48055-29•••-••-0697730-746-5276SANTIAGO.PARK@HOTMAIL.COM8358 RIVER ROADSAN ANTONIOTX78278GRP-0541MEDICARE-ADV-B
ENRENR-1092082026-01-01T12:42:12ZWayneYHerrera11/26/01UHC-59812-10•••-••-9629673-817-7492wayne.herrera32@aol.com2047 Central Ave··GilbertAZNULLGRP-0262OPTIONS-PPO
ENRENR-1066702026-06-11T18:24:20ZSARAH·EPARK06/27/64··UHC-57297-32•••-••-0364224-853-8438sarah.park@hotmail.com1654 Church StreetAtlantaGA··30343GRP-2618MEDICARE-ADV-A
ENRENR-1394402026-05-09T13:27:48ZmariaA.·williamson1992-07-22UHC-91254-21•••-••-91042792357MARIA.WILLIAMSON41@GMAIL.COM8729 Central AveNashvilleTN37226GRP-6551NAVIGATE-HMO
ENRENR-1071172026-09-11T00:07:24ZPatrick—Jones1979-01-25UHC-82955-40•••-••-19357088774452patrick.jones86@aol.com3668 Ridge RoadMesa··AZ85239GRP-3718MEDICARE-ADV-A
ENRENR-1056152026-07-31T08:10:45ZGibson, JenniferZ—1/23/1944UHC-49917-43UNKNOWN711-360-7567JENNIFER.GIBSON@ICLOUD.COM7719 Canyon RoadORLANDOFL32848GRP-2030MEDICARE-ADV-B
ENRENR-119849 2026-04-26T03:49:23ZHannahW.Little08/05/1946UHC-24374-25-443-657-1144hannah.little@hotmail.com·4540 APACHE BOULEVARDSan DiegoCA92193-2218GRP-7769medicare-adv-b
ENRENR-1271042026-06-18T10:04:59ZBenjaminBWeaver8/10/1996·UHC-20232-99NULL19635796913benjamin.weaver@gmail.com3047 Willow CtColumbusOH43204GRP-0132NAVIGATE-HMO··
ENRENR-122744 2026-05-12T21:50:47ZCARL—ROBINSON19920520··UHC-76163-71•••-••-7655null··CARL.ROBINSON@ICLOUD.COMnull—NULL—·GRP-1881SELECT-EPO
ENRENR-1404992026-01-18T16:54:54Z·AnaEKing1983-01-44UHC-25436-16•••-••-9727(380) 394-9632-5915 PARK PL #766ORLANDOFL32850GRP-4906··CHOICE-PLUS-PPO
ENRENR-1424052026-10-11T08:59:04ZAMYCBOWMAN19-08-2001··UHC-43285-35null305-440-8132·amy.bowman@yahoo.com6542 Valley View DrEden PrairieMN55368GRP-8999OPTIONS-PPO
ENRENR-139606 2026-06-08T15:56:15ZJuia—·Carroll1966-01-08UHC-78156-75•••-••-4502+1 929 487 3228julia.carroll93@icloud.com5514 Palm DriveMinneapolisMN55414GRP-3754··CHOICE-PLUS-PPO
ENRENR-1382702026-01-14T07:36:32ZBettyTOlson11-01-1978UHC-84839-17•••-••-4902805-696-0481—1066 GRAND AVENUE··Eden PrairieMN55322GRP-2878··CORE-HMO
ENRENR-1245302026-09-21T06:33:02ZJoeS.Rodriguez1980-02-23UHC-34607-55•••-••-6176386.644.4937null8483 DESERT SKY BOULEVARDNashvilleTN37262GRP-7771NAVIGATE-HMO
ENRENR-1183192026-05-25T07:44:42ZChristianWLynch19910917UHC-01124-43··•••-••-5245940.859.3122christian.lynch16@yahoo.com696 Maple AveLos AngelesCA90099GRP-3325MEDICARE-ADV-A··
ENRENR-1206922026-09-11T02:43:58ZLORI—RUIIZ7/8/1964uhc-65278-08•••-••-3708(731) 990-7561··—8718 Maple AveLas VegasNevada89114GRP-0120MEDICARE-ADV-B
ENRENR-1251852026-03-16T17:44:14ZGRAACEUMENDEZ07-12-1991··UHC-74605-10•••-••-0366—grace.mendez66@aol.com1490 Bayshore DrFresnoCA93758GRP-2989··SELECT-EPO
ENRENR-1392002026-01-04T19:43:45ZSusan—Thompson03/10/82UHC-71038-23•••-••-82422779975419susan.thompson@yahoo.com287 PALM DRTampaFL33619GRP-2810··OPTIONS-PPO
ENRENR-1272582026-01-29T20:20:03ZMARK··OWENS1967-02-07UHC-29187-20•••-••-8930(292) 473-3526mark.owens@hotmail.com··4095 MESA DRIVEPhoenixAZ85057GRP-5923OPTIONS-PPO
ENRENR-1406382026-03-15T19:02:28ZGraham, Chris····—1994-10-28UHC-01304-52•••-••-7200675-934-8647·N/A666 Oak StSan AntonioTX78265GRP-3443CORE-HMO
ENRENR-1160662026-01-26T00:17:55ZANDREW—GIBSON··1950-12-07UHC-50591-44··•••-••-4598(626) 210-8950ANDREW.GIBSON74@OUTLOOK.COM262 Sunset BoulevardDallasTX··75281GRP-4424··OPTIONS-PPO
ENRENR-126529 2026-06-27T17:25:55ZjasonUstephens1987-12-16UHC-53469-22•••-••-9141754-638-4882—3349 Main StreetMesaaz85207GRP-3899MEDICARE-ADV-A
ENRENR-1324762026-03-02T05:26:04ZJesseNDnn·1940-01-26UHC-75305-22•••-••-3886(409) 832-2813jesse.dunn@yahoo.com7126 SAGE COURTPhoenixAZ85029GRP-6544CORE-HMO
ENRENR-1058422026-05-14T20:57:19ZDOROTHYUBOWMAN10-04-2006UHC-69668-05•••-••-58383144859122··—3967 DESERT SKY BOULEVARDMinneapolisMN55480GRP-8664MEDICARE-ADV-B
ENRENR-137553 2026-01-12T23:20:30ZShirley—Reyes05/17/1940··UHC-10284-93—5454095040shirley.reyes87@yahoo.com2986 Cedar LnOrlandoFL32883GRP-8096CORE-HMO
ENRENR-1347872026-10-02T01:05:58ZANTHONY—PATTERSON1973-04-10UHC-17232-93•••-••-8710(211) 635-3926anthony.patterson64@hotmail.com8383 Spring StDallasTX··75296GRP-0158MEDICARE-ADV-A
ENRENR-1210102026-03-02T05:51:07ZMatthewFCruz1949-10-05UHC-75757-50•••-••-730019517601702MATTHEW.CRUZ52@HOTMAIL.COM1426 Sunset Boulevard·San AntonioTX78277GRP-1176MEDICARE-ADV-B
ENRENR-1185922026-09-02T08:51:02ZKing, RuthF—Oct 3, 1948UHC-11329-08•••-••-641212652254746ruth.king@outlook.com7809 HARBOR BOULEVARDSacramentoCA95821GRP-4880CORE-HMO
ENRENR-1198452026-01-12T05:17:01ZNOAHN.MORALES1945-08-19UHC-68220-74—(449) 692-7790noah.morales75@proton.me5678 DESERT SKY BLVDMiamiFL—GRP-8287NAVIGATE-HMO··
ENRENR-1236342026-09-05T17:25:47ZOlivia—Dunn1987-11-03UHC-71630-02•••-••-0261(840) 682-1643olivia.dunn48@gmail.com7178 Willow Ct Apt 30GilbertAZ85265GRP-0416CHOICE-PLUS-PPO
ENRENR-1303322026-07-26T08:14:49ZKarenVCampbell01/28/1942UHC-16103-42—(970) 641-3040N/A729 HILLCREST RDMinneapolisMN55454GRP-9573MEDICARE-ADV-A
ENRENR-1088332026-07-26T18:12:07ZKathy—Baker1991-09-15UHC3040908•••-••-2297227-597-7213kathleen.baker@aol.com1631 MARKET STREETColumbusOH43259GRP-8143MEDICARE-ADV-B
ENRENR-1172382026-01-07T12:29:09ZTylerUCampbell02-04-1970UHC-99970-10•••-••-2918····tyler.campbell@gmail.com·438 MEADOW LANELas VegasNV89153-5688GRP-5326MEDICARE-ADV-A
ENRENR-1403422026-01-31T19:25:13ZDANIELLE·LMORALES1995-01-12UHC-61737-79•••-••-98272159460820DANIELLE.MORALES@ICLOUD.COM4345 Willow CourtOrlandoFLN/AGRP-6638MEDICARE-ADV-A
ENRENR-1170052026-05-10T12:26:10Zwei—greene1940-12-16UHC-28116-44•••-••-9147·975-660-0014wei.greene33@hotmail.com9317 Bayshore DriveHouston··TX77095GRP-5935NAVIGATE-HMO
ENRENR-1162352026-01-27T21:37:13ZHELENPSTONE··1951-04-21UHC-85588-53•••-••-8365(782) 590-8080helen.stone@proton.me1478 OAK STSan DiegoCA92149GRP-3147MEDICARE-ADV-B··
43,101 rows, page 30 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:34.789Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty