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-1025392026-02-24T01:10:19ZIsabellaYPrice9164-03-25UHC-41557-49—473-449-5502null7692 Meadow LnSan AntonioTX78235GRP-6999MEDICARE-ADV-A
ENRENR-1197552026-05-10T02:26:45ZJOE··AWOODS08/19/1941uhc-46264-98•••-••-6590+1 743 692 6251··joe.woods1@gmail.com560 BROADWAYMiamiFL33149GRP-0563NAVIGATE-HMO
ENRENR-1302302026-01-29T19:40:50Z ArthurYJimenezFeb 1, 2001UHC-75581-43•••-••-5083704-430-3301UNKNOWN4586 Lake View RdEden PrairieMN55342GRP-6662navigate-hmo
ENRENR-1101992026-05-04T07:53:33ZJames··Wong·1993-06-23UHC-53109-44•••-••-1668—james.wong32@proton.me1693 Sunset BoulevardGilbertAZ85223GRP-3837·CORE-HMO
ENRENR-1405092026-09-12T10:12:50Z VictoriaO·Santos1943-12-21UHC-03713-87•••-••-4663906-337-8592VICTORIA.SANTOS89@GMAIL.COM2394 BASELINE RDSan DiegoCA92171GRP-9442·MEDICARE-ADV-A
ENRENR-1013652026-10-15T16:02:50ZTyler··—Clark2006-09-12·UHC-35174-96•••-••-10137254736113tyler.clark94@icloud.com2446 Indian School RdSacramento··California95895GRP-7360CHOICE-PLUS-PPO
ENRENR-1314642026-05-03T06:34:31ZGEORGE··—SCHMIDT1938-02-14UHC-87968-01•••-••-8803N/A—4919 Washington StreetLas VegasNevada89112GRP-0295CORE-HMO
ENRENR-1399012026-05-17T18:46:45Z Hall, RoyF—·1943-01-05·UHC3178208•••-••-2768407.733.5360roy.hall81@gmail.com4144 Mesa DrDALLAS·tx75215GRP-3303MEDICARE-ADV-A
ENRENR-1268242026-01-05T00:22:32Z·Mary—WheelerSep 27, 1975UHC-61948-57•••-••-8351·7075309mary.wheeler12@hotmail.com4043 PINE DRSeattleWA98133GRP-0299NAVIGATE-HMO
ENRENR-1126772026-10-06T23:33:12Zana··Fmartin1951-02-28UHC-21746-27•••-••-6512(688) 622-8454ana.martin@aol.com4551 LAKE VIEW ROADColumbusOH43213GRP-0773NAVIGATE-HMO
ENRENR-1173812026-06-09T22:11:18ZISABELLAISANCHEZ1958-11-22UHC2975136•••-••-4503·935-592-0361ISABELLA.SANCHEZ75@OUTLOOK.COM7658 CANYON RDTempeAZ85271GRP-9911CHOICE-PLUS-PPO
ENRENR-1037092026-04-17T07:57:38ZCATHERINEZ.COOK1990-06-20UHC-04400-74—6793246419CATHERINE.COOK44@PROTON.ME9282 CHURCH STREETATLANTA·GA30369··GRP-6333CHOICE-PLUS-PPO
ENRENR-1377532026-04-14T10:12:06ZLARRYVRYAN··5/24/1963UHC-46753-11•••-••-1413522-343-5497LARRY.RYAN@OUTLOOK.COM7997 Pine DrFresnoCA··93742GRP-4278·MEDICARE-ADV-B
ENRENR-1233982026-08-16T14:21:27ZahmedH.ortega1983-12-07UHC-43271-96•••-••-704315942012160ahmed.ortega79@outlook.com134 Ocean AvenueJacksonvilleFL32235GRP-1998OPTIONS-PPO
ENRENR-1007942026-09-01T13:59:01ZBryant, Brandon··R—12/13/80UHC-78047-95UNKNOWN953-340-0231BRANDON.BRYANT2@PROTON.ME2086 Maple AvenueAtlantaGA30342·GRP-5831MEDICARE-ADV-B··
ENRENR-1145902026-10-02T16:11:48ZthomasDcarol1955-07-27UHC-25221-32•••-••-1105+1 518 470 9440carol.thomas34@proton.me621 APACHE BLVD··San DiegoCA92113GRP-2235SELECT-EPO
ENRENR-1271862026-06-28T21:30:16ZSTEPHANIEX·WASHINGTON1945-01-03UHC-46595-95•••-••-62797472558896stephanie.washington78@aol.com1804 Mountain View DrDallasTX75230-6443GRP-8792MEDICARE-ADV-A
ENRENR-1196962026-04-07T05:29:18ZBARBARARPLMER10/15/74UHC-58152-86•••-••-49293049451940-6471 BroadwayPlanoTX75082GRP-6056·OPTIONS-PPO
ENRENR-1098062026-07-11T13:37:56ZEllisGSteven1944-12-28UHC9767376•••-••-5079491-803-0432-6255 PARK PLACEJacksonvilleFL32272GRP-2183OPTIONS-PPO
ENRENR-1133622026-05-18T18:53:56ZkaylaSjenkins1914-11-12UHC-09446-13•••-••-1837966-358-5153kayla.jenkins84@gmail.com8645 HILLCREST RD·FresnoCA·93750GRP-6001CHOICE-PLUS-PPO
ENRENR-1422702026-04-28T18:16:56ZHELENKDELGADO02/22/73UHC-47049-67•••-••-777914605708794HELEN.DELGADO45@PROTON.ME6734 Grand Ave·JacksonvilleFL32219GRP-0974CORE-HMO
ENRENR-1338952026-10-04T23:18:39ZJonathanBRivera04/10/1953UHC-42719-76··•••-••-2858586.972.4641JONATHAN.RIVERA1@GMAIL.COM8587 RIVER ROADPhoenixAZ85070GRP-8308NAVIGATE-HMO
ENRENR-1320412026-09-18T05:52:01Z·weiHsanders5/27/1961UHC-34725-21•••-••-5878834-511-3721wei.sanders@proton.me·1824 BroadwayJacksonvilleFL32288GRP-7017SELECT-EPO
ENRENR-1161172026-05-17T00:49:15ZVazquez, SophiaY—24-09-1992UHC-24298-39—930-843-8446sophia.vazquez49@proton.me4625 Indian School RoadScottsdale··AZ85205GRP-2858CHOICE-PLUS-PPO
ENRENR-1073142026-10-01T07:37:18Z SHIRLEYVBURKE05/25/98UHC-99524-15•••-••-5160785.777.1577··—4375 WASHINGTON STSan DiegoCA92123GRP-8588OPTIONS-PPO
ENRENR-102607 2026-03-30T03:03:44ZJUDYKKELLY1959-11-11UHC-32707-85•••-••-8653+1 721 465 4318JUDY.KELLY9@AOL.COM6312 Indian School RdFresnoCalifornia93781-3063GRP-7969NAVIGATE-HMO
ENRENR-1140922026-03-18T18:32:54ZVALENTINAR.JAMES11/14/58UHC-20196-87•••-••-37004406538484—384 Market StreetMesaAZ·85296GRP-1287MEDICARE-ADV-B
ENRENR-1235322026-04-16T07:22:12ZWallace, Jeremy·X—1941-09-20UHC-20150-52—(504) 517-7695—7102 Union StPhoenixAZ85021·GRP-6165OPTIONS-PPO··
ENRENR-1352522026-08-19T15:50:14ZAndrea—Mendosa·05/07/1939UHC-86485-66•••-••-2302·4854877644ANDREA.MENDOZA@AOL.COM3886 Sunset Boulevard Apt 23ScottsdaleAZ85234GRP-8751SELECT-EPO
ENRENR-106313 2026-10-13T11:49:52ZSchmidt, Bradley——·4/16/1954UHC-91040-77N/A957-353-5031bradley.schmidt33@aol.com7492 CAMELBACK RDEden Prairiemn55395-6099GRP-1574OPTIONS-PPO
ENRENR-1295572026-04-01T08:35:54ZLarry—Foster1965-06-28UHC-28714-88•••-••-6038574-422-2649larry.foster@gmail.comnull····--GRP-6175MEDICARE-ADV-A··
ENRENR-113517 2026-06-25T01:20:46Zgabriel—flres1973-09-03UHC-37300-95•••-••-98669026225925gabriel.flores@proton.me583 HIGHLAND AVENUEMinneapolis··MN55460GRP-7634MEDICARE-ADV-A
ENRENR-1002132026-07-26T07:19:44ZCARLOS—·MCCOY06/19/1998UHC-38970-15•••-••-4525(262) 693-4926null4147 Palm DrFresnoCA93736GRP-0784··NAVIGATE-HMO
ENRENR-1004002026-02-06T04:35:18ZScoott··—·FosterSep 3, 1956uhc-91525-62•••-••-8900(345) 557-1609SCOTT.FOSTER37@PROTON.ME·4415 BASELINE ROAD·Scottsdaleaz85273GRP-4583MEDICARE-ADV-B
ENRENR-1144442026-05-30T23:46:23ZDebra—Fernandez··1977-09-23UHC-61165-26•••-••-7737604-317-8586-3489 RIDGE ROADJACKSONVILLE·FL32236GRP-2374MEDICARE-ADV-B
ENRENR-1006282026-08-19T10:26:03ZJULIA—OBRIEN03-01-1941UHC-51219-30•••-••-4277(665) 776-0070julia.obrien@gmail.com497 Oak StGILBERTAZ·85280GRP-6484CHOICE-PLUS-PPO
ENRENR-1214112026-02-15T15:28:02ZHEATHER—BURTON2002-06-15UHC-68676-39•••-••-577318534239768N/A308 CENTRAL AVENUEMIAMIFL33113GRP-7653CORE-HMO
ENRENR-1129662026-03-23T01:03:18ZAustin··T.Franklin2003-07-11UHC-49819-90•••-••-8066(610) 982-2477austin.franklin51@aol.com5393 Maple AvenueGlendaleAZ85343GRP-6362CHOICE-PLUS-PPO
ENRENR-1069072026-05-01T11:54:22ZLee, Emily··——1999-02-06UHC-24000-15•••-••-5729791.303.0562-8641 Meadow LaneAustintx78706·GRP-2951CHOICE-PLUS-PPO
ENRENR-1109992026-02-17T08:18:43ZBrandon—Johnston1994-03-05UHC-18239-79N/A18106611108BRANDON.JOHNSTON@AOL.COM5819 JEFFERSON AVEMINNEAPOLISMinnesota55479GRP-5207SELECT-EPO
ENRENR-1343012026-04-04T07:08:08Z·KevinL.Tucker1951-06-90UHC-01358-75•••-••-2796NULLkevin.tucker@proton.me1128 Harbor BoulevardColumbus·OH43242GRP-5491CORE-HMO
ENRENR-1349742026-06-05T05:07:29ZStephns, Cynthia——Apr 6, 1957UHC-44022-07•••-••-6665(217) 389-3906cynthia.stephens@gmail.com8209 Bayshore DriveAtlantaGA30364GRP-1614CHOICE-PLUS-PPO
ENRENR-1066192026-02-20T04:11:27ZCAMILAV.COOK1965-08-06·UHC-69807-18•••-••-84116505218551—5067 Indian School RdSAN DIEGOCA92114··GRP-5563MEDICARE-ADV-B
ENRENR-1328262026-06-29T06:34:42ZTimothyDStephens12/22/1964UHC-43932-39•••-••-36995273593640—7303 Forest AvenuePLANOTX75095GRP-5045CHOICE-PLUS-PPO
ENRENR-141721 2026-03-31T16:36:26ZAnn—Alvarado1984-07-11UHC-68365-96•••-••-5950507-881-6988ann.alvarado@hotmail.com4414 HARBOR BOULEVARDSan DiegoCA92123GRP-8856CORE-HMO··
ENRENR-1012982026-01-12T17:23:14ZBobby·OGarcia1940-10-09uhc-75717-45•••-••-7774376-793-3181BOBBY.GARCIA81@AOL.COM3222 Valley View DrMinneapolisMN55428GRP-5970SELECT-EPO
ENRENR-1414662026-07-27T16:39:45Z Michelle—Gonzales03-12-1973UHC-28818-28•••-••-8526619-934-2340michelle.gonzales55@gmail.com6915 Church St #533SACRAMENTOca95887GRP-2913CORE-HMO
ENRENR-1321952026-08-26T12:06:36ZdonnaJ.black·1968-08-19·UHC-71648-50•••-••-4487(944) 802-9616······7639 MAPLE AVEChandler·AZ85224GRP-5600SELECT-EPO
ENRENR-1022322026-01-04T04:47:55ZDianeFRojas2004-08-05UHC-02332-24•••-••-2775-·-3240 Hillcrest Rd·COLUMBUSOH43291GRP-7291OPTIONS-PPO
ENRENR-1251262026-09-12T21:56:17Zmateo—cooper1999-09-15UHC-44800-44•••-••-2586766-682-9596mateo.cooper43@yahoo.com3576 Central AvenuePHOENIXAZ85051·GRP-6280CORE-HMO
43,101 rows, page 327 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.622Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty