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-1094922026-04-07T02:02:21ZCarlos··—Ruiz2005-04-19UHC-41536-90UNKNOWN4923701850UNKNOWN7823 HIGHLAND AVEFRESNOCA93704-4748GRP-3542MEDICARE-ADV-A
ENRENR-1362622026-06-17T05:59:51ZJosh—Hudson1955-09-05UHC-06238-41•••-••-567312865723716joshua.hudson@aol.com3049 Park PlGlendaleAZ85344GRP-6649MEDICARE-ADV-A
ENR ENR-1043872026-04-23T17:36:11ZSofiaMNelson1994-05-13UHC-95695-84•••-••-35345243131477SOFIA.NELSON@OUTLOOK.COM2083 Forest Ave Apt 12Los Angeles·CA90048GRP-5892CHOICE-PLUS-PPO
ENRENR-1150962026-04-07T08:56:34ZCYNTHIA—ELLIOTT1990-01-75UHC-89870-57•••-••-5269957.625.9400—8525 Sage Ct··Eden PrairieMN55386GRP-6385NAVIGATE-HMO
ENRENR-1391042026-09-18T01:43:34ZDONALD—CHAPMAN2003-08-09··UHC-60622-70•••-••-55324353948718—58 Palm DriveLAS VEGASNevada89145GRP-1216MEDICARE-ADV-A
ENRENR-1378422026-05-15T00:00:49ZCHRISTOPHER—THOMAS1967-09-07UHC-07566-18•••-••-699517079332783christopher.thomas96@aol.com4173 Spring StreetTucsonAZ85772GRP-5332CHOICE-PLUS-PPO
ENRENR-1119662026-02-23T02:56:06Z·Betty—Fields1990-09-12UHC7104507•••-••-1136(867) 251-1619BETTY.FIELDS@HOTMAIL.COM4666 BROADWAYCHARLOTTENorth Carolina28275GRP-4822SELECT-EPO
ENRENR-1247092026-03-04T06:18:21ZNichols, Luis·B—1947-03-14·UHC-85196-78•••-••-6305·(635) 475-6215NULL5706 Lincoln WayAtlantaGA·-GRP-4878SELECT-EPO
ENR ENR-1191342026-08-18T13:43:39ZCharles—Hanson1948-07-10UHC-29656-22•••-••-4591·678.766.5084—4807 Maple AveTempeAZ85267GRP-3253NAVIGATE-HMO
ENRENR-1168102026-06-17T11:27:30Z Amanda—Aguilar7/14/1999UHC-57660-55•••-••-7290(656) 489-0302—4164 BROADWAYTampaFL33658GRP-2095SELECT-EPO
ENRENR-1050332026-08-23T23:40:10Z·George··Graham·19890103UHC-02568-85•••-••-40237673057614george.graham@proton.me1521 Palm Drive··AustinTX78732GRP-0350CHOICE-PLUS-PPO
ENRENR-1213222026-01-24T17:56:21ZALEXANDER—·HENDERSON1944-12-26UHC-77798-88•••-••-79136288535alexander.henderson85@yahoo.com—nullUNKNOWN··N/AGRP-7166SELECT-EPO
ENRENR-1363512026-01-19T23:24:26ZMichell, Theresa——1972-06-08UHC-76361-55•••-••-84235598276905theresa.mitchell93@gmail.com8445 Harbor BoulevardAustinTX78787GRP-3903MEDICARE-ADV-A
ENRENR-1172852026-09-17T02:17:57Z KEVIN—·LE1955-05-21UHC-36777-51•••-••-47512615461KEVIN.LE84@AOL.COM·37 PARK PLAustinTXN/A·GRP-0848medicare-adv-b
ENRENR-1007642026-08-08T07:36:29ZArjun—Hughes9/25/1995UHC3229975—·864-225-8861ARJUN.HUGHES@GMAIL.COM9134 Canyon RoadNashvilleTN37280GRP-4167OPTIONS-PPO
ENRENR-1094472026-04-29T02:18:27Z DONNA—TURNERFeb 11, 1971·UHC-72021-36-·17269148081DONNA.TURNER3@YAHOO.COM··2213 CANYON ROADLos AngelesCA90055GRP-4579CORE-HMO
ENRENR-1244682026-05-30T14:46:12ZCatherine·H.Coleman2004-08-12UHC-75249-39•••-••-9269(550) 828-4224catherine.coleman@gmail.com4690 Camelback RoadSAN ANTONIOTXnullGRP-9124CORE-HMO
ENRENR-1425422026-07-27T12:45:33ZAnna··I.BennettSep 15, 1953··UHC-53468-90•••-••-2450988-511-3477anna.bennett@outlook.com·8268 HIGHLAND AVEGilbertAZ85263GRP-3829MEDICARE-ADV-B
ENRENR-1031562026-03-19T02:15:25Z·Randy·PRodriguezFeb 16, 2004UHC-13394-18•••-••-969014694491348RANDY.RODRIGUEZ@YAHOO.COM577 Central AvenueJacksonvilleFL32221GRP-5511MEDICARE-ADV-A
ENRENR-1022922026-08-11T05:03:33ZSOFIA—HUUNT2008-11-28UHC-72477-47··•••-••-5599+1 379 994 4854N/A7726 Lake View Rd··ScottsdaleArizona85228GRP-4930OPTIONS-PPO
ENRENR-1019662026-06-18T14:16:00ZMRAYN·MURRAYNov 5, 1980UHC-26594-26•••-••-97882116793407mary.murray@aol.com1000 Spring StMiami·FL33103GRP-1164choice-plus-ppo
ENRENR-1414822026-01-16T18:12:25ZHudson, Mary V.——19950114··UHC-28041-40•••-••-5740775-479-7193mary.hudson51@proton.me9385 Mesa DrSAN DIEGOCA92171GRP-4563CHOICE-PLUS-PPO
ENRENR-1028452026-10-05T04:33:35ZDEBRA—DUNCANApr 18, 1968UHC-01762-08•••-••-1845675-327-5374debra.duncan@aol.com259 APACHE BLVDMESAAZ85225GRP-7589select-epo
ENR ENR-1130622026-01-06T14:58:49ZRUSSELL—JOHNSTON1995-07-23UHC-95038-26•••-••-3731(498) 316-2404russell.johnston54@proton.me8266 Church StSan Diego·CA92177GRP-9755CHOICE-PLUS-PPO
ENRENR-139268 2026-05-20T15:35:48ZCarr, NancyL—03/15/1951UHC-37559-94•••-••-20823695548481nancy.carr74@gmail.com9697 Elm StreetEden PrairieMN55390GRP-3206OPTIONS-PPO
ENRENR-1350312026-01-26T02:59:00ZAdamCBrooks1975-03-10UHC-10931-33•••-••-2147+1 757 302 9551adam.brooks@hotmail.com3958 River RoadLas Vegasnv89102GRP-3060MEDICARE-ADV-A
ENRENR-104730 2026-01-10T19:39:20ZJustinK.Fox1999-09-25-•••-••-9736(245) 725-7977—5157 CEDAR LANENashvilleTN·37248GRP-4601CHOICE-PLUS-PPO
ENRENR-1272742026-04-24T06:19:06ZSueQVaqzuez09/06/2005UHC-65517-83•••-••-930817918100949N/A4082 Camelback RdMinneapolisMNUNKNOWNGRP-6702CHOICE-PLUS-PPO
ENRENR-1400002026-04-12T04:15:26ZEvelyn—Richardson1945-01-07··UHC-13286-06•••-••-2398831.534.3327—5570 Maple Ave·OrlandoFL32877-4773GRP-5305MEDICARE-ADV-A
ENRENR-1090492026-04-29T21:37:39ZDavidRPena1968-08-06UHC-27935-16•••-••-4720(586) 760-6556UNKNOWN1498 Lincoln WayNashvilleTN37256GRP-2149NAVIGATE-HMO
ENRENR-1288612026-01-27T00:55:08ZAlanP·Perry1958-11-22UHC-67699-54··2437354474N/A5216 Desert Sky BoulevardAUSTINTX78739GRP-8751·OPTIONS-PPO
ENRENR-1264802026-09-01T05:40:18ZHIROSHIF.LITTLE1951-07-08UHC-78883-18•••-••-0302(655) 740-4130hiroshi.little73@gmail.com8918 Jefferson AvenuePlano·TX75078·GRP-1118NAVIGATE-HMO
ENRENR-1238522026-01-14T09:21:12Z Mari··F.Webb1943-09-01·UHC-08787-13•••-••-3199·757.369.3709maria.webb@outlook.com8356 Maple AveMIAMIFL33120GRP-4300SELECT-EPO
ENRENR-1222792026-10-08T06:45:01Z·MichaelIFisher2008-03-22UHC-99907-59•••-••-8980(818) 302-2977——··—N/AGRP-8190OPTIONS-PPO
ENRENR-1223642026-01-13T16:30:30ZJANICE—WILSON1947-01-19UHC6324067•••-••-6145484.628.1626janice.wilson@yahoo.com3994 OCEAN AVE #412AustinTX78798-7638GRP-5827OPTIONS-PPO
ENRENR-1291602026-08-05T08:48:44ZBerry, Jordan····—6/19/1960UHC-30488-44•••-••-49222573331jordan.berry70@outlook.com6518 Harbor BlvdColumbusOH43281··GRP-4877CORE-HMO
ENRENR-1238512026-05-24T00:56:07ZPatrick—Ortega··Sep 9, 1990UHC-60327-76•••-••-9352(831) 565-4725patrick.ortega73@aol.com3527 Canyon RoadAtlantaGA30306GRP-8564CORE-HMO
ENRENR-1108492026-05-09T23:44:57ZNICHOLAS—WILLIAMSONJul 6, 1985UHC-32853-11—-nicholas.williamson@proton.me4949 Canyon RdMINNEAPOLISMN55472·GRP-3427NAVIGATE-HMO
ENRENR-1007232026-09-23T08:15:30ZARJUN—ELLIS1992-08-11UHC-70282-36•••-••-4295222-586-6144UNKNOWN4288 Main StreetDENVERCO80201GRP-7302MEDICARE-ADV-A
ENRENR-1013532026-01-28T12:01:27ZRonald—Sandoval2004-01-26UHC-92908-51•••-••-1133727.735.2193RONALD.SANDOVAL88@YAHOO.COM1135 Ridge RdDenver··CO—GRP-9223CORE-HMO
ENRENR-1011652026-07-22T04:03:49ZFerguson, Benjamin——·1996-09-01UHC-53731-76-709-478-1879benjamin.ferguson14@outlook.com7087 Washington StreetSan DiegoCA·92144GRP-6670CORE-HMO
ENRENR-1110992026-04-27T09:39:16ZdebraJsimpson··1967-03-13·UHC-13128-62•••-••-1711580.210.2889debra.simpson@hotmail.com1092 CEDAR LANEFresnoCA·93728·GRP-9737NAVIGATE-HMO
ENRENR-1235042026-01-18T04:58:05ZDanielle—Carter10/4/1959UHC-75129-77•••-••-28024913550DANIELLE.CARTER@GMAIL.COM1393 WILLOW CTGilbertAZ85205·GRP-7294NAVIGATE-HMO
ENRENR-1094412026-09-15T08:47:36ZMASONBHARPER19960508UHC-52064-23—462.998.9619N/A6142 Hillcrest Road·Fresnoca93764GRP-6440MEDICARE-ADV-B
ENRENR-1226642026-08-20T15:27:30ZSarah—Reed1967-03-14uhc-13928-11•••-••-6151-SARAH.REED93@HOTMAIL.COM3831 Grand AvenueSeattleWA98140·GRP-9320CHOICE-PLUS-PPO
ENRENR-1077722026-06-28T22:23:30ZAlexander—Reed08/02/1960UHC-32257-08•••-••-7592-—7671 Church StreetAUSTINTX·78717GRP-3471OPTIONS-PPO
ENRENR-1273152026-05-24T16:58:26ZELIJAHRGUTIERREZ1966-05-09UHC6965863•••-••-82292325738974ELIJAH.GUTIERREZ50@AOL.COM8582 WASHINGTON STSan AntonioTX78262GRP-8334MEDICARE-ADV-B
ENR ENR-1176552026-09-09T01:43:17ZGrace—Stephens·1970-07-10UHC1053778•••-••-8252(473) 601-7500grace.stephens@hotmail.com8937 Apache BlvdSeattleWA98189GRP-5607·MEDICARE-ADV-A
ENR ENR-1246052026-01-28T01:42:15ZMICHELLEEHUNTER·2004-12-09UHC-25175-77•••-••-1021NULLMICHELLE.HUNTER2@YAHOO.COM1209 UNION STTucsonAZ85789GRP-0587CHOICE-PLUS-PPO
ENRENR-114909 2026-05-14T15:10:16ZArthur—Tucker1946-10-11UHC-32251-37··-884-746-2189N/A·4796 Jefferson AvenueTucsonAZ85749GRP-9322NAVIGATE-HMO
43,101 rows, page 119 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.759Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty