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-1143462026-08-21T21:01:58Znathan—white19520527UHC-15054-99•••-••-614817538198105—·4457 River RdTUCSONAZ85786GRP-6382·NAVIGATE-HMO
ENRENR-1155372026-01-12T11:06:19ZSTEPHANIE—FLORES11/05/90UHC-94918-95•••-••-9381+1 937 605 8985stephanie.flores35@outlook.com·1443 Elm StLos AngelesCA90020··GRP-2647OPTIONS-PPO
ENRENR-1409652026-07-16T21:25:04Z MARIANA—DELGADO2006-09-17UHC-25441-90-(411) 981-9189mariana.delgado72@aol.com5979 BROADWAYMiamiFL33118GRP-7854CORE-HMO
ENRENR-1150782026-04-09T07:53:23ZBUTLER—ANDREA1941-12-05UHC-91603-61—16377994482UNKNOWN6968 Highland AvenueOrlandoFL32840-1169GRP-2248·MEDICARE-ADV-B
ENRENR-1002422026-04-10T02:19:55ZRuth—Ferguson1945-10-09UHC-17845-36•••-••-7559874-449-7748—9177 Jefferson AvenueMesaArizona85248GRP-4741·CORE-HMO
ENRENR-1063612026-05-05T16:19:16Zrobert·Sdunnn07/20/51UHC-95326-41•••-••-50313987553995—6341 Baseline Rd·HOUSTONTexas77003··GRP-1360MEDICARE-ADV-A
ENRENR-1374222026-08-02T23:19:23ZAbigayl—Morris06/04/70UHC-59571-90—3705812352ABIGAIL.MORRIS@YAHOO.COM4579 CENTRAL AVEMiamiFL33161-4076GRP-2340SELECT-EPO
ENRENR-1287272026-04-04T21:34:30ZJONWFOX1/3/1981UHC-29441-10•••-••-106813845455975————UNKNOWNGRP-5595NAVIGATE-HMO
ENRENR-1378802026-05-29T00:49:17ZDaniel—Silvva1985-06-21UHC-59936-40•••-••-1836(412) 836-2970··daniel.silva96@gmail.com8847 Valley View Drive·PhoenixAZ85042-0026GRP-5709MEDICARE-ADV-A
ENRENR-1147672026-05-20T02:30:38ZAustin—Mdina01/04/1941·UHC-98951-27•••-••-7972590-792-2213austin.medina@gmail.com5370 BASELINE RDLos AngelesCAUNKNOWNGRP-0705MEDICARE-ADV-B
ENRENR-103931 2026-06-16T15:05:35ZMorales, NoahM.—1958-04-26UHC-68816-49•••-••-6628NULL··noah.morales@icloud.com8322 MAPLE AVENUESAN ANTONIOTX78212GRP-7476MEDICARE-ADV-B
ENRENR-1405782026-06-23T19:46:45ZethanSgarza2002-06-26UHC-91432-94•••-••-9765(349) 681-5937ETHAN.GARZA@PROTON.ME9873 Market StreetAtlantaGA30335GRP-5429CORE-HMO
ENRENR-1424682026-07-27T05:09:46ZFrances—Mason1978-05-08·UHC-26895-73•••-••-4377280-483-8551UNKNOWN6031 Mountain View Dr··GilbertAZ85262GRP-1203CORE-HMO
ENRENR-1388532026-04-15T01:22:31ZKEVIN—PATEL1986-11-19UHC-81454-64•••-••-8138nullKEVIN.PATEL@PROTON.ME6854 Park PlSeattleWA98140GRP-4128MEDICARE-ADV-B
ENRENR-1290972026-07-04T14:00:40ZMaryM.Holmes12/03/41··UHC-44325-59•••-••-4254274-243-6759mary.holmes67@hotmail.com2184 Lincoln WayLos AngelesCA90071·GRP-9979NAVIGATE-HMO
ENRENR-100752 2026-07-17T19:33:34ZFower, JoseL—Oct 17, 1999UHC-49377-67··•••-••-958213032304023jose.fowler54@icloud.com6354 FOREST AVENUEMinneapolisMN—GRP-3052CORE-HMO··
ENRENR-1153352026-04-06T02:56:02ZMasonBMurphy1956-11-11UHC-40374-19UNKNOWN·(211) 879-9022mason.murphy@icloud.com3805 Pine Drive··Eden PrairieMN55300GRP-6241CHOICE-PLUS-PPO
ENRENR-140361 2026-04-12T18:34:10Z·paulA.·henderson1981-12-19UHC-23572-02•••-••-2587·5588342227·UNKNOWN666 Highland AveAustinTX78739GRP-8849MEDICARE-ADV-A
ENRENR-1067212026-01-28T04:59:13ZSantiago··Kelly2003-06-14UHC4643607•••-••-95793477558957—1154 Desert Sky BlvdMIAMIFL33145GRP-6231CHOICE-PLUS-PPO
ENR ENR-1209492026-03-31T20:26:53Zcharles··Jray1951-09-17·UHC-94243-94•••-••-5853+1 393 265 7271·charles.ray8@icloud.com8897 Ridge RdNashvilleTN—GRP-7957NAVIGATE-HMO
ENRENR-1178362026-01-01T00:09:36ZLAURENDFOWLER1952-04-22UHC-70815-91•••-••-1733·(931) 757-5965—4464 Apache BoulevardGlendaleAZ85398GRP-8954MEDICARE-ADV-B
ENRENR-1180812026-09-21T19:33:02ZKAREN—GIBSON1976-02-21UHC-49708-56··•••-••-18325348288152··—6786 GRAND AVEDenverco80299··GRP-1099SELECT-EPO
ENRENR-1164392026-04-06T01:49:02ZEVANS—ARJUN19650915UHC-31210-72•••-••-2412(748) 828-7483arjun.evans@hotmail.com5950 Baseline RoadGilbert·AZ85252GRP-4923OPTIONS-PPO
ENRENR-1108002026-06-13T15:06:41ZBRENDA—LUNA01/24/1985UHC-89078-96•••-••-3274UNKNOWNbrenda.luna14@yahoo.com1396 Palm DriveTampaFL··33693GRP-9527··CORE-HMO
ENRENR-1062452026-03-05T23:02:04Z·brandonM··wong1952-10-19UHC-76439-97•••-••-76502742305183brandon.wong55@outlook.com4460 PARK PL··JacksonvilleFL32254GRP-2432OPTIONS-PPO
ENRENR-1351222026-03-24T03:07:15ZVIRGINIA—GREEN1963-10-26UHC-24354-61•••-••-22892292047499virginia.green@icloud.com8700 Sunset BoulevardSan DiegoCA92126GRP-7689NAVIGATE-HMO
ENRENR-108073 2026-09-16T23:03:28ZLopez, Emily——2004-08-12UHC-26356-08•••-••-341114127016275UNKNOWN3277 Forest AvenueSeattleWA98153-0153GRP-3779CORE-HMO
ENRENR-1229222026-07-14T18:11:25ZCamila··—Dixon1963-06-04UHC-89921-33··•••-••-136316434881332N/A5403 Mesa DriveHoustonTX77093GRP-2174NAVIGATE-HMO··
ENRENR-1413042026-03-29T07:14:21ZCharles—Jimenez19460217UHC-25702-22•••-••-7869(981) 556-5596N/A5023 River RoadAustinTX78767GRP-2039NAVIGATE-HMO
ENRENR-1297922026-07-31T15:33:33Z MarthaU.Welch1997-03-13UHC-19046-90•••-••-2134904-754-0160N/A5024 MARKET STScottsdale··AZ85204GRP-0826MEDICARE-ADV-A
ENRENR-1125222026-05-30T11:13:56Z Montgomery, Abigail······—Jun 27, 1945UHC-74702-59•••-••-1520(739) 499-7841UNKNOWN3460 FOREST AVEMinneapolisMinnesota55448GRP-3310NAVIGATE-HMO
ENRENR-1098452026-02-15T11:22:40ZbillyM.ward1993-02-28UHC-64088-45•••-••-2381-BILLY.WARD59@YAHOO.COM··4109 SPRING STSACRAMENTOCA95854GRP-7157OPTIONS-PPO
ENRENR-1025262026-04-14T20:36:40ZBRADLEYFRICHARDSON1961-03-15UHC-31604-51UNKNOWN(654) 277-5957bradley.richardson@hotmail.com9129 Grand AvenueEden PrairieMinnesota55353GRP-0994NAVIGATE-HMO
ENRENR-1282162026-03-11T07:08:08ZThomas, Jean——19630414UHC3578390•••-••-4188(583) 818-1077·N/A2055 Lincoln WayNashvilleTN37270GRP-6280CORE-HMO
ENRENR-1374072026-09-04T18:20:15ZARTHUR—DUNN1994-02-12UHC-59490-98•••-••-8257·2355678859arthur.dunn@proton.me6403 BroadwaySAN DIEGOCA92182GRP-8892CORE-HMO
ENRENR-1383492026-02-12T02:29:40Zamber··—1967-08-17UHC-90032-57•••-••-83154436973155N/A4942 Pine DrPhoenixArizona··85084GRP-1577CORE-HMO
ENRENR-1193232026-09-02T02:06:46ZSHIRLEYWADAMS19720720UHC9128840··•••-••-9971(915) 951-1274SHIRLEY.ADAMS@PROTON.ME8927 Ridge RoadHoustonTX··77070GRP-5862core-hmo
ENRENR-1338662026-08-05T00:41:34ZBILLY—HUDSON7/6/1996N/A•••-••-4277(277) 305-1095billy.hudson@gmail.com7901 MARKET STREET··CHANDLERAZ85249GRP-8871SELECT-EPO
ENRENR-1212822026-05-28T15:48:32Z PatrickMSchmidt1979-01-23UHC-38127-44•••-••-0580607-384-4243patrick.schmidt35@icloud.com3334 Mesa DrJACKSONVILLE·FL32248GRP-0934SELECT-EPO
ENRENR-1153862026-07-31T00:38:08Z·LuciaR.Bennett10/05/1995UHC-16443-41•••-••-00573702992124·lucia.bennett16@hotmail.com5797 River RoadPlanoTX75064GRP-4796CORE-HMO
ENRENR-1272592026-08-25T04:02:00Zjack—·ray1955-10-24UHC-59604-32•••-••-7742NULLjack.ray7@yahoo.com7181 CEDAR LANEPlanoTX75096GRP-9941NAVIGATE-HMO
ENRENR-1318432026-04-12T01:24:24ZJoshuaVPerry1990-06-24UHC-65921-80•••-••-3056856-570-3786····7612 Valley View DriveJACKSONVILLEFL-GRP-1147SELECT-EPO
ENRENR-1089292026-09-15T01:03:18ZBrian—Gordon19650113UHC-81204-88•••-••-6978(856) 674-0511·UNKNOWN2269 WILLOW CTAustinTX78791GRP-0319CHOICE-PLUS-PPO
ENRENR-1331602026-09-18T02:52:29Z Virginia—Burns··1953-06-27UHC-00106-32•••-••-8043+1 939 684 1951VIRGINIA.BURNS6@YAHOO.COM6890 Hillcrest RoadChandlerAZ85241GRP-2147CHOICE-PLUS-PPO
ENRENR-1310432026-07-31T07:47:10ZCatherineI.AndersonMay 22, 1987UHC-65258-87null3514003490—1321 BroadwayColumbus·OH43251GRP-6402NAVIGATE-HMO
ENRENR-1369562026-01-21T02:43:49ZPorter, BruceC.—1986-12-02UHC-09068-81•••-••-01189046416625bruce.porter@outlook.com2128 Sunset Boulevard··LAS VEGASNV··89191-9962GRP-8939MEDICARE-ADV-A
ENRENR-1210462026-07-01T19:34:58ZAlbert—Reed1972-02-19UHC-80011-40•••-••-11368053194501albert.reed@yahoo.com2018 Desert Sky BoulevardTampa·FL33650GRP-0727MEDICARE-ADV-A
ENRENR-1354412026-08-28T07:17:40ZbruceP.castro09-08-2004UHC7706242•••-••-8138512-595-0631N/A··3158 River RdFresno·CA93731GRP-6353CHOICE-PLUS-PPO
ENRENR-1055992026-06-08T09:36:48Z·GABRIEL—RUSSELLDec 23, 1955UHC-05189-61•••-••-3013(617) 588-4034GABRIEL.RUSSELL84@YAHOO.COM4477 Washington StColumbus·Ohio43258GRP-5373CORE-HMO
ENRENR-1255432026-10-04T11:19:17Z·CHARLOTTE—VASQUEZ1989-12-02UHC-33932-81•••-••-954916935629723NULL6142 Cedar LnJacksonville··FL32226GRP-0154CORE-HMO
43,101 rows, page 181 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.316Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty