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-1037382026-04-17T09:20:09ZCheyrlT··Carlson—UHC-21115-04•••-••-5871691-363-0878cheryl.carlson@aol.com3405 WASHINGTON STPhoenixAZ85084GRP-1590··CHOICE-PLUS-PPO
ENRENR-1407932026-01-27T09:08:13ZJonathanY.··Hunt1991-05-28UHC-20299-86•••-••-6936233-893-2043····8273 Palm DriveTampaFL33613-2824GRP-6553NAVIGATE-HMO
ENRENR-1403922026-07-26T17:13:02ZALEXANDERRSTEPHENS1991-02-08UHC-60942-55·null7186255194·NULL7415 Oak StGLENDALEAZ85319GRP-3478MEDICARE-ADV-B
ENRENR-1256432026-05-08T20:17:19ZTIMOTHY—STONE1967-10-14UHC-14772-70•••-••-8638(533) 568-7358TIMOTHY.STONE@HOTMAIL.COM8372 Ocean Ave···OrlandoFL32813GRP-6416MEDICARE-ADV-B
ENRENR-1219032026-04-02T22:46:58ZRichard—Burke27-09-2002UHC-80410-81null(970) 726-2675richard.burke81@yahoo.com3768 Washington StreetCharlotteNC28295GRP-3750options-ppo
ENRENR-1236822026-10-01T13:46:08ZBettyYMartinnez19680426UHC-57515-46•••-••-0042579-348-9459betty.martinez30@aol.com3912 CENTRAL AVE··LOS ANGELESCalifornia··90010GRP-4271MEDICARE-ADV-B
ENRENR-1017202026-05-28T07:37:25ZTyler—Estrada4/19/1977··UHC-86807-20•••-••-6170··TYLER.ESTRADA@OUTLOOK.COM5571 Central AvenueGilbert·AZ85223GRP-0498SELECT-EPO
ENRENR-1402952026-03-22T15:43:00ZKathleenZFisher·1953-08-12UHC-98423-32•••-••-3194975-626-9555KATHLEEN.FISHER24@OUTLOOK.COM5400 Sunset Boulevard··NashvilleTN37219GRP-7917··CORE-HMO
ENRENR-1385532026-03-25T13:51:39ZLoganPSanders1962-11-27UHC-91805-80•••-••-6659UNKNOWN·-5114 Forest Ave Apt 26Fresnoca93769-7081GRP-4319CORE-HMO
ENRENR-142632 2026-07-18T14:11:44ZWillie—Bennett2501-19-96UHC-41101-83··•••-••-63125868623willie.bennett9@gmail.com1924 HIGHLAND AVEColumbusOH43225GRP-9377MEDICARE-ADV-A
ENRENR-1057992026-04-22T01:09:27ZSimmons, Dennis··W—1983-04-07UHC-42851-62•••-••-1362(840) 904-3209N/A2133 Apache BoulevardAustinTX78720GRP-2144··MEDICARE-ADV-A
ENRENR-1127422026-07-05T20:26:30Z VINCENTOWILLIS1996-09-12UHC-25785-40•••-••-99689715724870vincent.willis@yahoo.com7913 Sunset BoulevardLas VegasNV89110-2424··GRP-7072NAVIGATE-HMO
ENRENR-1280462026-05-07T02:39:06ZSantiagoNFields01-03-1976UHC-02720-67•••-••-2373+1 209 293 7863santiago.fields@aol.com1120 Oak StreetFresnoCA·93778GRP-0327MEDICARE-ADV-B
ENRENR-1383622026-03-26T02:38:13Z·Sandra—Brown2000-52-05·UHC-38120-34•••-••-5620(706) 459-4971—4287 Central AveMesaaz85278GRP-5227CHOICE-PLUS-PPO
ENRENR-1335572026-07-19T01:13:27ZChritian··B··—Jul 24, 2007UHC-28089-14•••-••-6729UNKNOWNchristian.singh@aol.com9378 WILLOW CTScottsdale··AZ—GRP-0647NAVIGATE-HMO
ENRENR-1268942026-02-07T09:36:51ZChristine—Jackson01/19/56UHC-72896-59•••-••-2966·236.663.1910christine.jackson21@proton.me5956 Bayshore DriveTucsonAZnullGRP-5228SELECT-EPO
ENRENR-115191 2026-08-23T12:09:09ZMATEOFKING1973-12-26UHC-75351-22•••-••-79067786723376mateo.king@hotmail.com709 LINCOLN WAY··PhoenixAZ85068GRP-9478MEDICARE-ADV-A
ENRENR-1232892026-10-14T09:11:24ZJANICE·A.TUCKER2005-12-03UHC-89062-43NULL792-928-5931NULL1178 Palm DrSacramentoCA95825GRP-5746options-ppo
ENRENR-1306322026-04-13T04:36:26ZDominguez, AaronV—1997-03-20UHC-79317-75•••-••-4021+1 603 288 1044AARON.DOMINGUEZ@GMAIL.COM·1494 UNION STREETSan AntonioTX78220GRP-4402·NAVIGATE-HMO
ENRENR-1153582026-04-05T10:07:21ZAlexander—Cruz1960-08-82UHC-39381-75•••-••-0585-N/A1838 Sunset BoulevardHoustonTX77078GRP-2024CHOICE-PLUS-PPO
ENRENR-1206942026-03-13T22:19:06ZMeyer, AhmedL.—10/19/1981UHC-94500-92•••-••-4869·255-521-1062ahmed.meyer@hotmail.com5017 Canyon Road··MiamiFL33130GRP-2318core-hmo
ENRENR-1347412026-07-21T01:51:53ZAhmedJHoffman1987-02-08UHC-49328-82•••-••-8294769.688.9136·-7858 Spring St·GilbertAZ85296GRP-3135CHOICE-PLUS-PPO
ENRENR-1376792026-09-29T10:02:45Zvictoria—peters1974-07-28-•••-••-6309(681) 906-1533victoria.peters48@hotmail.com··2121 Sage CtMiamiFloridaUNKNOWNGRP-6585MEDICARE-ADV-B
ENRENR-1040912026-06-24T09:10:28ZPatrick—Carter1994-02-05UHC7206079•••-••-9292·657-644-5617PATRICK.CARTER31@GMAIL.COM6994 Cedar Ln·MIAMI·FL33135··GRP-2873NAVIGATE-HMO
ENRENR-1283412026-08-25T20:08:08ZAguilar, DonnaT—1991-06-09·UHC-53014-02•••-••-4014277-543-5026donna.aguilar95@proton.me3600 CENTRAL AVENUESan DiegoCA·92164-3631GRP-3646··SELECT-EPO
ENRENR-1029852026-06-12T04:10:59ZHENRYYPORTER1953-10-23UHC-33730-64•••-••-3409424-377-3198henry.porter@hotmail.com5986 MOUNTAIN VIEW DRJacksonvilleFL32232GRP-5394··CHOICE-PLUS-PPO
ENRENR-1354732026-05-26T06:13:20ZKYLEN.COOK··1963-06-20UHC-80562-19•••-••-84469472163495kyle.cook56@icloud.com8422 Hillcrest RoadTampa·FL33671GRP-9648NAVIGATE-HMO
ENRENR-1071752026-02-17T05:08:06ZCamilaL.Knight1977-12-26UHC-37268-86•••-••-372518666637272—9815 Harbor BoulevardPhoenixArizona85062GRP-1847SELECT-EPO
ENRENR-1341832026-07-05T18:48:24ZmateoM.burke08/20/07UHC4319661•••-••-2178(453) 318-6571—7355 Sunset Boulevard··Los AngelesCalifornia90086GRP-6691MEDICARE-ADV-B
ENRENR-1424802026-02-09T05:29:08ZTERRYOSILVA1957-04-21UHC-77066-08•••-••-931515286699634-5292 JEFFERSON AVEDenverCO80227-0526GRP-2261SELECT-EPO
ENRENR-1195342026-06-30T20:28:52Z BILLY—ROSE2005-06-02UHC-73662-77—787.289.4075billy.rose@aol.com4654 Canyon RoadSacramentoCalifornia95813GRP-0302CORE-HMO
ENRENR-1079052026-02-11T18:42:25ZLAUREN—TAYLOR1984-08-28UHC-85275-26•••-••-0465924-410-3628—8577 INDIAN SCHOOL ROADJacksonvilleFL32252·GRP-8519OPTIONS-PPO
ENRENR-1353992026-03-11T06:54:08ZMatthew—Porter24-07-1993UHC-37399-93•••-••-1215(233) 876-4649matthew.porter32@aol.com155 PALM DRTucsonAZ85728GRP-5051CORE-HMO
ENRENR-1186902026-05-12T22:20:44ZADAM—GEEN2003-05-12UHC-08215-14•••-••-680419595158897··adam.green@aol.com731 Market StreetAustinTX78743-7969GRP-6348SELECT-EPO
ENRENR-1155042026-10-10T05:21:18ZAARONY.FREEMAN1971-12-14UHC5413937•••-••-6528(683) 959-8882aaron.freeman@hotmail.com3900 Main StGlendaleAZ85369GRP-8284options-ppo
ENRENR-1342282026-05-21T01:34:04Z·MIKEHTHOMAS02/23/62UHC-85355-01•••-••-9676N/Amichael.thomas@hotmail.com3630 HIGHLAND AVEJacksonvilleFL32220GRP-1481SELECT-EPO
ENR ENR-1106702026-09-01T16:37:01ZCarlos—Thomas01/24/83UHC-38646-89•••-••-32977752654413carlos.thomas52@proton.me1777 HIGHLAND AVEHoustonTX77034GRP-1505CORE-HMO
ENRENR-1152612026-03-03T13:07:24ZRuthZSmith1970-01-07···UHC-60292-14•••-••-7792(767) 422-2908ruth.smith63@aol.com9811 Highland AvenueTampaFL33651GRP-4780NAVIGATE-HMO
ENRENR-1131072026-10-13T04:40:15ZCherylZ.Lawrence1980-03-17uhc-30888-91•••-••-06948297099511—667 Forest AvenueGilbertAZ85241GRP-4387select-epo
ENRENR-1081532026-06-21T17:45:54ZRyanOMaldonado—UHC-48920-84·-—N/A3211 LINCOLN WAYAustinTX78767GRP-7497OPTIONS-PPO
ENR ENR-1146412026-01-31T14:04:32Zsean—spencer1985-12-18UHC-10796-74•••-••-0014739-562-2921sean.spencer69@proton.me573 Indian School RoadGilbertAZ85299GRP-0302MEDICARE-ADV-B
ENRENR-1212252026-04-08T19:20:28ZTaylor, Stephen·Q—1995-01-19UHC-02047-87•••-••-0974716-325-8971stephen.taylor@aol.com2493 DESERT SKY BOULEVARDFresnoCA93781GRP-3517MEDICARE-ADV-B
ENRENR-1160822026-09-02T06:48:34ZJulia—Dunn1940-03-18·UHC-20537-59•••-••-5857(580) 935-2925julia.dunn@hotmail.com4390 Desert Sky BoulevardMinneapolisMN55489GRP-9858MEDICARE-ADV-B
ENRENR-1297342026-03-17T16:00:58ZPRIYAJPRICE1991-09-09UHC-86266-54·NULL13308573968··priya.price83@gmail.com7015 Sage CourtLas VegasNV89161GRP-4104SELECT-EPO··
ENRENR-1149732026-02-15T07:01:13ZGutierrez, NthanR.—nullUHC-41662-03•••-••-9222573-519-0216nathan.gutierrez47@hotmail.com834 PINE DR·ScottsdaleAZ·85275GRP-5117MEDICARE-ADV-A
ENRENR-1357962026-03-08T21:03:35ZVIRGINIA··MGRAY07-06-1958UHC-14215-78•••-••-2117(683) 541-8817virginia.gray42@hotmail.com9058 Bayshore DrTempeAZ85256GRP-4648CORE-HMO
ENRENR-1418082026-04-20T13:59:49ZPETERSALEXANDER19610520·UHC-95104-59•••-••-5665(398) 769-7238peter.alexander@yahoo.com6695 MARKET STOrlandoFL32821GRP-3609MEDICARE-ADV-A
ENRENR-1353112026-10-16T15:10:18ZDIEGO··POBRIEN1972-10-23·UHC-18192-84•••-••-6047(988) 970-1161-5933 Camelback RdMinneapolisMNN/AGRP-8891SELECT-EPO
ENRENR-111267 2026-08-12T23:31:14ZLawrence, Ronald——1981-05-22UHC-29293-43•••-••-4885·484-337-9322RONALD.LAWRENCE@PROTON.ME3578 Central AvenueScottsdaleArizona85283GRP-4484NAVIGATE-HMO
ENRENR-1199232026-07-15T14:56:57ZGeraldZ··Valdez2005-10-20UHC-54744-88•••-••-1537(734) 473-7064N/A7970 Lake View RoadMINNEAPOLISMN·55412GRP-4402CORE-HMO··
43,101 rows, page 95 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.730Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty