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-1122102026-08-20T21:30:54ZBailey, Brian—····03/26/53UHC-51571-55··•••-••-4276(823) 960-1059brian.bailey@gmail.com4358 Indian School RoadLos AngelesCA90033GRP-6234CORE-HMO
ENRENR-1354802026-07-31T11:41:15ZSHARON··—MORRIS··10/17/75UHC-84047-90•••-••-2585327-577-2163SHARON.MORRIS@YAHOO.COM2447 BASELINE ROADDenverCO80219GRP-5647··NAVIGATE-HMO
ENRENR-1115582026-01-06T00:34:41Z—W··—07/07/1960··UHC-18558-36•••-••-57863716764022willie.rivera52@icloud.com9797 LAKE VIEW RDLos AngelesCA90018GRP-6048CORE-HMO
ENRENR-1287222026-07-24T18:42:58ZSARA—TRAN··2003-09-20UHC-06860-38•••-••-3199664.585.8422SARA.TRAN19@OUTLOOK.COM6688 Lincoln WayMesaAZ85294GRP-9471MEDICARE-ADV-B
ENRENR-1358432026-03-04T22:43:45ZDiana·Z.Lng··2007-11-05UHC-77612-55•••-••-60653562153840UNKNOWN7104 SAGE CT··HoustonTX-GRP-5500CORE-HMO
ENRENR-1032832026-09-26T15:41:04Z·Patricia—Greeen1972-05-23UHC-20173-02•••-••-7588703.548.9875patricia.green71@icloud.com4866 Market StTucsonaz··85782GRP-0462·CHOICE-PLUS-PPO
ENRENR-1316062026-07-02T02:54:40ZMADISON—EDWARDS1995-01-31UHC-69976-74•••-••-72444356830530····7010 MEADOW LANECharlotteNC28277·GRP-6526OPTIONS-PPO
ENRENR-1024012026-08-05T21:27:57ZRyyanDPalmer12/15/1964··UHC-75348-14•••-••-2077(442) 568-0312ryan.palmer97@proton.me452 Union StSeattleWA98167-0182GRP-6383NAVIGATE-HMO
ENRENR-1044972026-02-07T14:21:45ZANASGUERRERO1998-07-17UHC1191199······—ANA.GUERRERO@GMAIL.COM3235 Park PlSeattleWA98137GRP-1870CORE-HMO
ENRENR-1428382026-08-09T11:27:25ZMark—Walsh6/15/1980UHC-70851-53•••-••-8074646-230-3878mark.walsh11@yahoo.com9283 Bayshore DrAtlantaGeorgia30320GRP-2937CORE-HMO
ENRENR-1245822026-04-25T19:41:35ZOlson, Rachel——1989-10-28UHC-10292-12•••-••-0617nullrachel.olson@yahoo.com7502 Church StGlendaleAZ85375GRP-2495CORE-HMO
ENRENR-1183732026-06-03T15:00:56ZAlexanderD.Guzman1954-02-08UHC-51864-50•••-••-3410811.440.1953N/A6252 PINE DRIVEDallastx75250GRP-4099SELECT-EPO··
ENRENR-1098432026-09-16T06:52:33ZKennedy, AndreaQ—1959-07-01UHC-99655-87•••-••-3473+1 310 353 1687andrea.kennedy@hotmail.com7806 Market StreetPHOENIX·AZ85020GRP-1594CHOICE-PLUS-PPO
ENRENR-1155732026-08-18T08:20:15ZDORIS—HUNTER09/10/1960UHC-80869-40•••-••-7978(271) 899-3964—6060 Sage CtMinneapolisMN·55424GRP-4950MEDICARE-ADV-A
ENRENR-1190872026-06-12T10:54:09ZJERRY·PRICHARDS·1948-09-19UHC-20592-54•••-••-1487+1 213 652 2293jerry.richards@aol.com738 Mountain View DrPhoenixAZ85047GRP-1333OPTIONS-PPO
ENRENR-1158072026-08-31T10:55:58ZSantiago—Reed2005-06-26UHC-53248-15UNKNOWN682-433-7936santiago.reed96@aol.com5403 Central AveATLANTAGA30336GRP-2721MEDICARE-ADV-A
ENRENR-1248492026-01-20T06:53:47ZOmar—·Lee1956-02-14UHC-17270-62null2693595840·OMAR.LEE4@OUTLOOK.COM348 Palm DrJacksonvilleFL32252GRP-1900··NAVIGATE-HMO
ENRENR-1327792026-06-19T17:56:35ZJOSEF.—1944-12-07UHC-68537-23•••-••-76037116963335jose.kelley@hotmail.com·590 SUNSET BLVDMINNEAPOLISMN··55486GRP-2463OPTIONS-PPO
ENR ENR-1417632026-08-28T13:56:11ZgaryQpeters5/7/1974UHC-57117-44•••-••-5396+1 612 237 4597null157 Spring Street·ColumbusOH43230-6707GRP-5894MEDICARE-ADV-A
ENRENR-127148 2026-07-06T12:37:04ZGraecFNunez02/13/1978··UHC-46022-88•••-••-5595(357) 299-6240GRACE.NUNEZ14@YAHOO.COM7396 Forest AveNashville··TN37265GRP-9331CHOICE-PLUS-PPO
ENRENR-1104232026-08-16T19:52:09ZEUGENE····MURPHY3/13/1974UHC-80044-23N/A··397.866.1588eugene.murphy8@hotmail.com3306 Spring StNashvilleTN··UNKNOWN·GRP-5802OPTIONS-PPO
ENRENR-1006472026-06-12T02:49:05ZBETTY····CARLSON1950-10-23UHC-69561-36•••-••-9740·251.929.7704—5468 BroadwayTempeAZ85260·GRP-1661·NAVIGATE-HMO
ENRENR-1344132026-04-20T07:50:45Z·Ortiz, TomO—2003-10-15UHC-63591-98•••-••-2609(416) 685-4456THOMAS.ORTIZ@GMAIL.COM2226 Lincoln WayEDEN PRAIRIEMN55300-7996GRP-5530OPTIONS-PPO
ENR ENR-1419612026-01-30T19:22:01ZSANTIAGO—PENA·1975-07-25UHC-63606-39•••-••-31739499243466santiago.pena58@outlook.com6610 BROADWAYMesaArizona85285GRP-5889··MEDICARE-ADV-B
ENR ENR-1047892026-09-06T05:28:54ZWillieGMedina2006-07-04UHC-66180-38··•••-••-46329445763540willie.medina43@hotmail.com1180 BroadwayFresno·CA93749GRP-8821MEDICARE-ADV-B
ENRENR-1220082026-01-04T00:41:07ZSmith, Elijah——1976-05-04UHC-23137-21··N/A17994291390elijah.smith18@hotmail.com1889 Apache Blvd·PLANOTX75085GRP-2795MEDICARE-ADV-B
ENRENR-1179292026-09-02T08:59:22ZNicholasT··Powell1971-09-05UHC-23532-82•••-••-43892213006935nicholas.powell@gmail.com8378 Church St Apt 9MIAMIFL·33153GRP-4911SELECT-EPO
ENRENR-1361622026-06-23T02:30:50ZRalph—Peterson1995-08-04UHC-53260-05•••-••-3133+1 458 857 1984null1958 Market StreetSacramentoCA95883GRP-0505CORE-HMO
ENRENR-1400742026-02-13T04:54:14ZPhilip Z.—Stephens1940-02-17UHC-52177-38•••-••-8619(521) 826-1425PHILIP.STEPHENS@YAHOO.COM··145 CEDAR LNDALLASTexas75271GRP-8564CORE-HMO
ENRENR-1085102026-09-09T22:36:56ZCARLOS—WALSH1986-04-23UHC-10139-71NULL+1 567 880 5850carlos.walsh@proton.me1398 River RdFresnoCA—GRP-2973SELECT-EPO
ENRENR-1415062026-04-17T05:36:58ZGabrielBHall1996-05-27UHC-61296-58•••-••-95624369926288gabriel.hall@hotmail.com5838 Jefferson AveSAN ANTONIOTX78212··GRP-5335CHOICE-PLUS-PPO
ENRENR-1422282026-03-16T13:07:17Z·Fowler, Diane——1962-09-21UHC-21142-80•••-••-46856362236489DIANE.FOWLER76@ICLOUD.COM··2837 Park PlaceTampafl33665GRP-3127CORE-HMO
ENRENR-1084012026-09-11T13:06:06ZLoganH··Welch9/19/1964UHC-05742-56•••-••-17023956037null5903 Grand AveMinneapolisMinnesota55407GRP-5823MEDICARE-ADV-A
ENRENR-1377482026-04-30T06:26:27Zpaul—mendez1991-04-04UHC-11811-69•••-••-0934416-549-4405PAUL.MENDEZ39@GMAIL.COM6755 CENTRAL AVEGlendaleAZ85384-8007GRP-9636CHOICE-PLUS-PPO
ENR ENR-1268072026-05-11T14:38:43ZBEVERLYW.PAYNE··Jun 27, 2004UHC-24738-29··•••-••-9113(277) 221-4739—5544 Mountain View DrSacramentoCA95808GRP-2041CHOICE-PLUS-PPO
ENRENR-1397032026-08-26T14:07:10ZBETTY—SANTOS1959-02-22··UHC-59935-23•••-••-23605877515489····6648 Mountain View DrTucsonAZ85710GRP-1693CORE-HMO
ENRENR-1253482026-07-13T01:19:43ZJERRY··SMARTINFeb 7, 1990UHC-96383-74•••-••-55738807439708jerry.martin67@aol.com1696 Highland AveJacksonvilleFL32223GRP-8215CORE-HMO
ENRENR-1427172026-09-22T18:40:44ZDoris—McDonald06/19/77UHC-00910-81•••-••-765315318250759DORIS.MCDONALD29@ICLOUD.COM566 Church StreetChandlerAZ85203··GRP-5222OPTIONS-PPO
ENRENR-1335212026-07-13T23:22:12ZBRYAN—·SCHULTZ1947-12-11·UHC-81701-49•••-••-8270974-458-9103BRYAN.SCHULTZ79@AOL.COM905 Harbor BoulevardDALLASTX·75262GRP-9006MEDICARE-ADV-B
ENRENR-1359572026-09-18T01:51:02ZBradley—Murphy1978-06-26UHC-98942-64•••-••-76269729222247BRADLEY.MURPHY@GMAIL.COM8816 CANYON ROADSEATTLEWA98177GRP-6682CHOICE-PLUS-PPO
ENRENR-1203192026-07-07T10:54:20ZScottJ.Kelly05/26/1939UHC-81370-54•••-••-85057178255UNKNOWN6727 Park PlaceJacksonvilleFlorida32230GRP-9094OPTIONS-PPO
ENRENR-1287032026-04-10T14:58:21ZRyan—BurkeAug 12, 2000UHC-76409-12•••-••-3710(333) 378-6791RYAN.BURKE@ICLOUD.COM6464 CAMELBACK RDSan DiegoCalifornia92169-6188GRP-8153NAVIGATE-HMO
ENRENR-1114482026-08-25T01:00:34ZJEANHVASQUZE9/15/1972UHC-72732-38—7133433139jean.vasquez78@outlook.com447 OCEAN AVEJacksonville·Florida32204GRP-1520··SELECT-EPO
ENRENR-1254592026-08-30T05:18:46ZWILLIEFHARRISON9184-07-13UHC-17637-88—9515823willie.harrison@proton.me7270 HARBOR BLVDDallasTexas·75203GRP-4423OPTIONS-PPO
ENRENR-1259342026-09-11T12:00:18ZJeremy—HunterJun 27, 1942UHC-17184-54•••-••-13553078642965jeremy.hunter@yahoo.com·6322 Market StreetCharlotte··North Carolina28248GRP-4380MEDICARE-ADV-A
ENRENR-1027332026-06-18T13:05:06ZGREG····CHEN1201-02-02UHC-87310-18•••-••-3791—gregory.chen60@gmail.com8242 CANYON ROADMESAAZ85280GRP-1860MEDICARE-ADV-A
ENRENR-1060922026-06-13T10:22:56ZTERESA—MENDEZ1987-06-26UHC-99599-84UNKNOWN18074200818··—4688 Willow CourtChandleraz85258-5962·GRP-3178OPTIONS-PPO
ENRENR-1408142026-04-21T14:41:08ZMei—Vega2008-01-22UHC-96916-94•••-••-19324669632303MEI.VEGA@HOTMAIL.COM641 HIGHLAND AVEGilbertAZ85208GRP-7611MEDICARE-ADV-A
ENRENR-1279602026-02-13T05:38:45ZKatherine·VWillis1995-02-87UHC-08939-72•••-••-4187240-752-6608katherine.willis@hotmail.com7286 Market StTampaFL33675GRP-1543NAVIGATE-HMO
ENRENR-1121242026-06-12T16:34:56ZJACKWDELGADO1971-82-01UHC-17106-67•••-••-940816297836156jack.delgado@aol.com928 HARBOR BOULEVARDTucsonAZ85710GRP-7623OPTIONS-PPO
43,101 rows, page 244 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.626Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty