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-1316492026-04-30T05:55:17ZanthonyC.harper11/23/06··UHC-93669-60•••-••-17417815273432UNKNOWN2237 Harbor BlvdORLANDOFL32845GRP-2027MEDICARE-ADV-B
ENRENR-1142612026-07-20T05:37:49ZPriya—Jimenez1962-12-10UHC-55791-82•••-••-6130—PRIYA.JIMENEZ16@HOTMAIL.COM1209 Central AvenueDallasTX75242··GRP-2144MEDICARE-ADV-A
ENRENR-1181352026-03-10T06:21:23ZBettyPMyersMay 22, 1966UHC-98128-03•••-••-8303(270) 300-0583BETTY.MYERS@GMAIL.COM1206 Grand AvenueSacramentoCA95813GRP-7850MEDICARE-ADV-A
ENRENR-1386662026-07-18T06:32:51ZluciaH.leSep 8, 1959UHC-53838-39NULL5104709211lucia.le@yahoo.com7725 Pine Drive·Las VegasNevada89168GRP-1132CHOICE-PLUS-PPO
ENRENR-1115912026-09-18T17:58:25ZHoffman, JacobD—1997-03-25UHC-51039-01•••-••-6653684-764-9540JACOB.HOFFMAN20@ICLOUD.COM6402 WILLOW CTChandlerAZ85236-7923GRP-0837SELECT-EPO
ENRENR-1390642026-08-23T23:44:10ZDNEISEPEDWARDS1978-08-20UHC-19277-26•••-••-1563+1 918 562 4750denise.edwards@icloud.com6836 PINE DRMinneapolis··MN55480GRP-6736CORE-HMO
ENRENR-1393472026-08-29T16:08:46Z·diegoWchavez12/14/1982UHC-14045-39•••-••-7936(490) 714-3270diego.chavez@hotmail.com5581 Desert Sky Boulevard··Las VegasNV89163GRP-1886MEDICARE-ADV-B
ENRENR-1152372026-04-25T22:21:46ZLUISU·BURTONMar 23, 1967UHC-35481-18•••-••-2163N/Aluis.burton@gmail.com5724 Central AvenueMinneapolisMN55403GRP-7615CHOICE-PLUS-PPO
ENRENR-1151582026-08-02T17:04:20ZAARON—WBEB1964-02-02UHC-01857-64•••-••-05053242847345aaron.webb95@yahoo.com8555 Apache BlvdSan AntonioTX78290GRP-4835MEDICARE-ADV-B
ENRENR-1262572026-07-02T16:47:11ZSofiaQMitchell1977-09-28UHC-13416-69•••-••-7348(807) 493-4978—4159 Baseline RoadMesaAZ85289GRP-9936CORE-HMO
ENRENR-1405842026-03-15T13:22:40Z Valentina—ReidApr 6, 1965UHC-92970-85•••-••-6233(677) 909-6548valentina.reid8@aol.com4462 Lake View RdPHOENIX··AZ85029-1086GRP-8788OPTIONS-PPO
ENRENR-1085912026-07-01T06:41:00ZMichael—Jordan2000-11-24UHC-94325-83N/A212-512-5878michael.jordan@aol.com1678 Oak Street Apt 21·SAN ANTONIOTX78293GRP-1936NAVIGATE-HMO
ENRENR-1062652026-03-13T19:10:50ZMATEO—MORENO1978-11-16·UHC-39345-31•••-••-2226880-302-1053mateo.moreno22@proton.me2119 Jefferson Avenue Apt 27OrlandoFL32884GRP-4159OPTIONS-PPO
ENRENR-1188752026-03-23T01:00:08ZMARKABUTLER26-09-1981UHC-68693-91··•••-••-7298474.493.4354mark.butler9@outlook.com1096 Camelback RoadGILBERTAZ85206·GRP-5487CORE-HMO
ENRENR-1353452026-08-14T19:20:53ZStephanieT.Bradley19880212UHC-07574-71•••-••-11639696899450UNKNOWN8890 Willow CtMinneapolisMN55479GRP-0158OPTIONS-PPO
ENRENR-1334782026-03-14T01:32:31ZHAROLDJPETERSON1963-10-29UHC-37208-63•••-••-5583NULLHAROLD.PETERSON26@YAHOO.COM··5963 Lake View RoadMesaAZ85239GRP-5438SELECT-EPO
ENRENR-1354042026-02-08T18:12:51ZmariaHlucas19940324UHC-40744-44•••-••-57854903087052maria.lucas@aol.com2408 Jefferson AvenueColumbusOH43265GRP-4279MEDICARE-ADV-B
ENRENR-1310572026-06-17T11:28:26ZMarianaQGardner24-01-2001UHC-13906-61•••-••-60423017992114—7580 WILLOW COURTMIAMIFL33169GRP-7401OPTIONS-PPO
ENRENR-1391832026-07-18T12:54:05ZVALENTINA—PERY1958-07-19UHC-68447-74•••-••-97836945792409—4222 Maple AvenueNASHVILLETN—GRP-3759MEDICARE-ADV-A
ENRENR-1127072026-02-13T19:25:39ZBISHOP—KATHLEEN1956-12-25UHC-56849-46•••-••-4511·453.299.3828—9143 Grand AvenueSAN ANTONIOTX78206··GRP-0976OPTIONS-PPO
ENRENR-1224812026-01-15T19:58:59ZLogan—Delgado1956-09-17UHC-87471-01•••-••-7800902-367-9360NULL5217 Indian School RdAtlantaGA·30342GRP-7610MEDICARE-ADV-B
ENRENR-1029912026-01-23T11:08:24ZAISHA—SIMMONS1944-04-21UHC-46654-44•••-••-8175·(229) 351-5885NULL774 Lincoln WayPhoenixAZ85014GRP-9597NAVIGATE-HMO··
ENRENR-1312622026-09-11T07:17:03ZPaul····Castillo1991-03-22·UHC-57719-17•••-••-3709·4906569580paul.castillo@outlook.com7965 CAMELBACK ROADCharlotte··NC28228GRP-5712MEDICARE-ADV-B
ENRENR-1190462026-10-03T08:45:23ZEugene····Shaw·2004-11-24UHC-47201-99•••-••-69312788236660eugene.shaw48@proton.me——·UNKNOWNNULLGRP-9897SELECT-EPO
ENRENR-1240262026-02-04T02:47:07ZLuciaRJensen1961-09-25UHC-79734-63•••-••-3783581.887.0999lucia.jensen11@proton.me217 Park PlaceSan DiegoCA92124GRP-8229SELECT-EPO
ENRENR-1283452026-06-19T11:24:31ZKATHRYN—FORD1995-01-12·UHC6610947•••-••-6488310-638-3894—779 Valley View DrSeattleWA··98108·GRP-4652MEDICARE-ADV-B
ENRENR-1410092026-07-01T04:20:57ZNiocleBMorales15-02-2002UHC-15042-40•••-••-6208527.756.3759—9553 BroadwayFRESNO··California93763GRP-0138NAVIGATE-HMO
ENRENR-1368422026-08-24T14:56:21ZDEBORAH—FOX·0604-18-92UHC-40257-90•••-••-4983NULLnull3808 Highland AvenueHoustonTX77059GRP-3223··MEDICARE-ADV-A
ENRENR-1257262026-08-18T03:22:43Z ABBY····STEWART11/04/50·UHC2323380•••-••-6530246-560-1392abigail.stewart@hotmail.com3674 Harbor BoulevardOrlandoFL32894GRP-3546CORE-HMO
ENRENR-1001442026-09-03T13:49:48ZJosephUSimpson··1997-04-14··UHC-40911-71•••-••-817117684184471joseph.simpson@yahoo.com··9890 Canyon RdNASHVILLETennessee37266GRP-6606MEDICARE-ADV-B
ENRENR-1193612026-04-24T03:31:50ZSofia—Stone1957-07-25UHC-26887-79•••-••-3990UNKNOWNsofia.stone18@hotmail.com9671 HIGHLAND AVENUETUCSONAZ-GRP-6316··options-ppo··
ENRENR-1398232026-01-08T07:06:15ZAbigailDPerez25-10-1996UHC-81326-41—662.964.4810abigail.perez47@proton.me3454 Bayshore DriveLas Vegas··NV89114GRP-0863CORE-HMO
ENRENR-1172412026-08-24T06:43:53ZHELENKMORALES23-10-1959uhc-42089-79•••-••-6087325-291-7069helen.morales9@hotmail.com··3155 APACHE BOULEVARDLos Angeles·CA90026-6313GRP-1276OPTIONS-PPO
ENRENR-1297242026-09-22T01:45:34ZRobertQTorres9/5/1954UHC0483405•••-••-3243502.346.9011ROBERT.TORRES85@GMAIL.COM··5873 Lake View Rd #793ChandlerAZ85254-1092GRP-4916MEDICARE-ADV-B
ENRENR-130975 2026-06-24T15:04:56ZOlivia·F.Dominguez1949-04-07UHC-41435-77•••-••-2042·+1 423 374 8544olivia.dominguez78@icloud.com1500 Palm DrPhoenixAZ85001·GRP-8168CHOICE-PLUS-PPO
ENRENR-1308042026-07-24T03:34:14ZSarah—Fuller02/01/1955UHC-33174-34•••-••-5930276-363-3844—9462 LINCOLN WAYDenverCO·80276GRP-6619CHOICE-PLUS-PPO
ENRENR-1188342026-03-05T11:57:40ZDean, AndrewK.··03/23/43UHC-47206-76•••-••-2586(358) 581-7310ANDREW.DEAN52@HOTMAIL.COM5529 Church StHoustonTX77018GRP-9536CHOICE-PLUS-PPO
ENRENR-1056762026-07-22T09:16:36ZMarcus··—Porter28-01-2006UHC-50158-19•••-••-7815NULL—5998 Mountain View DrHOUSTONTX77036GRP-3242CORE-HMO
ENRENR-1109612026-04-25T16:32:12ZFRANCES O—BURNS07-06-1977UHC-13404-99—3435486143frances.burns@icloud.com·9458 Pine Drive Apt 23GlendaleAZ85305GRP-5425CORE-HMO
ENRENR-1145992026-02-01T03:30:59ZKimberlyE··Duncan1999-07-10UHC-38947-74—6392871607kimberly.duncan@gmail.com5867 Forest AvenueColumbusOH43229GRP-8153CHOICE-PLUS-PPO
ENRENR-1429272026-08-01T02:37:47ZAustinO··Lopez·1977-09-24UHC-10967-15•••-••-888316377194829AUSTIN.LOPEZ@HOTMAIL.COM5139 Ocean Avenue Apt 30CharlotteNorth Carolina28215GRP-8238NAVIGATE-HMO··
ENR ENR-1252062026-05-11T12:55:20Z DorisDMunoz1997-04-16UHC-02192-57•••-••-74526333091902DORIS.MUNOZ@PROTON.ME·7162 Pine Drive·PhoenixAZ85059-6566GRP-5192MEDICARE-ADV-A··
ENRENR-1055082026-01-31T22:08:56ZJoseph—Gray1954-08-06UHC4256449•••-••-1355(344) 425-9461—907 Cedar LanePhoenix·AZ85044GRP-4566MEDICARE-ADV-A
ENRENR-1423052026-06-04T20:31:06ZCarolyn—Peters05/22/74UHC-78937-82nullN/Acarolyn.peters@yahoo.com8643 Harbor BoulevardOrlandoFL32808GRP-0569MEDICARE-ADV-B
ENRENR-1215512026-06-20T04:27:16ZJeremy·OBishop21-03-1971·UHC-33995-12•••-••-3552396-804-2203··jeremy.bishop41@yahoo.com7906 LAKE VIEW RDMinneapolisMN55450GRP-3837CHOICE-PLUS-PPO
ENRENR-1133522026-03-31T15:46:38Z·Little, AndrewP··1972-07-06UHC-11547-97—(390) 353-1535andrew.little67@outlook.com3646 Sunset BoulevardTempeAZ85217GRP-8461MEDICARE-ADV-A
ENRENR-1380782026-01-09T18:22:35ZMarcXWalsh1997-07-05··UHC-37839-21•••-••-3687987-841-5044marcus.walsh4@yahoo.comUNKNOWN··NULL——GRP-8411medicare-adv-a
ENRENR-1281192026-02-22T10:31:59ZJACK—PETERSON1948-07-06UHC-88562-34··•••-••-2769811.439.4732··JACK.PETERSON@HOTMAIL.COM1460 Elm Street #339GilbertAZ85208GRP-1242MEDICARE-ADV-A··
ENRENR-1413842026-07-25T02:42:30Zedward—ryan1992-04-10UHC-83967-47•••-••-740417876292718—5825 Bayshore DrJacksonvilleFL-·GRP-9745OPTIONS-PPO
ENRENR-1255452026-05-12T00:59:54ZJerryFLane1949-10-23UHC-21466-99•••-••-7653276-581-6804jerry.lane@yahoo.com2060 Ocean AveOrlando·FL·32820GRP-7532NAVIGATE-HMO
43,101 rows, page 98 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.733Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty