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-1395942026-06-20T23:28:33ZMELISSA··—SIMS02/17/1975UHC-56605-33•••-••-2372—N/A5162 WILLOW COURT·COLUMBUSOH43277GRP-7171medicare-adv-a
ENRENR-1010642026-04-15T23:29:56ZGRACED.RODRIGUEZ1994-03-14UHC-74123-45··•••-••-34167595967642grace.rodriguez@hotmail.com4481 Sage Court Apt 10SAN ANTONIOTX78217GRP-9084OPTIONS-PPO··
ENRENR-1101232026-08-16T12:40:51ZNOAHMGUZMAN1963-12-02UHC-32384-07•••-••-6110+1 354 354 8161—·4878 OAK STLos AngelesCA90071GRP-4083CORE-HMO
ENRENR-1206072026-05-04T22:51:22ZDEBORAH—HAMILTON1963-03-05UHC-46390-26—18349894965deborah.hamilton11@hotmail.com4385 Highland AveAustintx78721GRP-8570core-hmo
ENRENR-1338872026-01-13T04:20:54ZDiane··—Howard1966-04-12UHC-00743-76•••-••-8633-NULL7592 Cedar LnSan DiegoCA92166GRP-5497OPTIONS-PPO
ENRENR-1190782026-01-20T08:32:36Zraymond—harrison19810101UHC-40374-90•••-••-6772·15546340159null5028 ELM STREETDenverCO80298GRP-8251OPTIONS-PPO
ENRENR-1330252026-09-21T19:18:17Z Greene, Arthur——19421116··UHC-13551-49•••-••-89424914654923arthur.greene@icloud.com·4951 Canyon Rd·Los AngelesCA90085GRP-9039CHOICE-PLUS-PPO
ENRENR-1276342026-07-01T23:50:14Z·SHARONYBURTON1955-02-57UHC-21748-50•••-••-98376674613291sharon.burton@gmail.com5056 PINE DR #333Planotx··75054-6926GRP-1729CHOICE-PLUS-PPO
ENRENR-1349132026-08-22T03:45:26Z JessicaBLarson1977-03-28UHC-49110-84•••-••-9121745-665-1374—8086 MAIN ST··SacramentoCA95887GRP-6837OPTIONS-PPO
ENRENR-1382672026-04-29T03:19:25Zcarlos—webb1949-12-20UHC-82977-74•••-••-4832(878) 304-0123···CARLOS.WEBB@ICLOUD.COM7922 Canyon RoadTempeAZ85242GRP-3634SELECT-EPO··
ENRENR-1420202026-07-27T19:58:32ZFerguson, Bradley——19571213UHC-58249-92•••-••-60482046318258bradley.ferguson@aol.com329 River RoadHoustonTX77007GRP-5554NAVIGATE-HMO
ENR ENR-1352922026-09-30T11:04:10ZAaronKVazquez2004-03-06UHC-28889-32•••-••-0670(689) 310-0538NULL1357 MAPLE AVECOLUMBUSOH43230·GRP-8387SELECT-EPO
ENRENR-1094392026-02-20T13:11:24Znathan—flores··19590618UHC-24961-43··UNKNOWN379-343-5006nathan.flores1@gmail.com8353 Valley View DrLas VegasNV89101GRP-1744CHOICE-PLUS-PPO
ENRENR-1325802026-06-09T01:10:31ZBradleyPMartinezJul 23, 1970UHC-09904-12•••-••-35349366148NULL6301 Park PlMinneapolisMN55404GRP-9813CORE-HMO
ENRENR-1252872026-03-05T14:37:19Zvalentina—thomas1947-05-25UHC-79702-25•••-••-1617324-697-9666valentina.thomas@gmail.com5538 Cedar LaneGilbertAZ85210-5176GRP-7830core-hmo
ENRENR-1059042026-04-06T18:15:58ZALAN—STOO1994-10-12UHC-84799-55•••-••-25417157709265ALAN.SOTO@HOTMAIL.COM887 River RoadGlendaleAZ··85348GRP-6080SELECT-EPO
ENRENR-1099962026-05-25T04:17:41Z LauraIChen2005-07-06UHC-72517-68··•••-••-0085546-339-1224LAURA.CHEN95@YAHOO.COM9250 VALLEY VIEW DRHouston·Texas77068GRP-4209·SELECT-EPO
ENRENR-1035192026-10-11T21:35:30ZbenjaminTwebb2003-01-07UHC-05050-82•••-••-6520828-686-0774benjamin.webb@outlook.com6081 CAMELBACK ROADJACKSONVILLEFL32277·GRP-7344OPTIONS-PPO
ENRENR-1331672026-03-20T05:25:50ZCampbellXJuan··19881221UHC-18810-99—(283) 841-5140JUAN.CAMPBELL@ICLOUD.COM7855 Main Street··HOUSTONTX77045GRP-5364·CHOICE-PLUS-PPO
ENRENR-1320762026-08-11T01:38:24ZBradley·QBanes01/18/86UHC-02728-80-6305500274-1932 Spring St··GlendaleAZ85338-6697GRP-7501OPTIONS-PPO
ENRENR-1202302026-08-10T16:44:48ZPriya—Berry19580707null··•••-••-7384-priya.berry@gmail.com6745 Elm StreetCHANDLER··AZ85274GRP-1129OPTIONS-PPO
ENRENR-1192072026-01-07T20:35:35ZDenise—Roberts1972-02-15UHC-19669-31•••-••-2149(807) 573-6788-5846 Indian School RdHoustonTX77037GRP-7357navigate-hmo
ENRENR-1024922026-03-08T11:26:44ZgloraQmeyer1988-01-23UHC2546017•••-••-90045222390186—8279 Willow CtDALLAS··Texas75212-0319GRP-2859MEDICARE-ADV-B
ENRENR-1390722026-05-19T11:04:17ZGRACE—GARZA11/10/02UHC-70601-88•••-••-2744(900) 658-2811—7828 Maple AvenueCHANDLERAZ85281GRP-7839CHOICE-PLUS-PPO
ENRENR-1339192026-02-17T11:54:03ZMegan—Allen1946-09-15UHC-94421-04•••-••-28264885583995megan.allen@yahoo.com3172 Central AveSan DiegoCA··92182GRP-9282MEDICARE-ADV-A
ENRENR-1165002026-05-21T14:40:55ZSOFIA·A.RIOS2005-02-03UHC-29478-20•••-••-0389+1 493 244 4921·SOFIA.RIOS61@AOL.COM9897 UNION ST·SeattleWA98134·GRP-4887navigate-hmo
ENRENR-1293622026-08-15T06:53:41Z ABIGAILESANDERS1975-03-11UHC-08668-77•••-••-07734526986abigail.sanders@yahoo.com9314 Baseline RoadTucsonaz85746GRP-2097SELECT-EPO
ENRENR-1175552026-03-20T04:33:35ZLuisOPeters12/1/2000UHC-99143-52•••-••-46276960258LUIS.PETERS35@GMAIL.COM4568 Cedar LnAustinTX78737GRP-6989CHOICE-PLUS-PPO
ENRENR-105172 2026-01-03T11:47:34ZShirleyWHerrera26-02-1993UHC-42017-70—(571) 972-8607shirley.herrera57@outlook.com8706 Baseline RoadFRESNOCA··93701GRP-9507MEDICARE-ADV-A
ENRENR-1281232026-03-27T17:52:28ZMarcusBHowell1/1/1997UHC-94996-60•••-••-7839(841) 991-5857MARCUS.HOWELL78@PROTON.ME337 Mesa DrSan AntonioTX·78216GRP-4529·MEDICARE-ADV-A
ENRENR-1031272026-09-05T17:42:12ZMATEO··X·CRUZ1997-11-02UHC-97388-23•••-••-1235918-918-3062—1694 Sage CtSeattleWA98103GRP-4155OPTIONS-PPO
ENRENR-1184472026-07-22T07:30:44ZChristina—Larson1995-09-26UHC-33882-58•••-••-5344311.217.0105CHRISTINA.LARSON@OUTLOOK.COM7029 Market StreetLas VegasNevada89190GRP-0557CORE-HMO
ENRENR-1166622026-04-12T02:44:18Z SamuelJRogers1947-01-25UHC-45434-25•••-••-6542·5555703216null9453 Sage CtTAMPAFL33692GRP-6249·MEDICARE-ADV-B
ENRENR-101399 2026-04-18T12:16:12ZJamesMBryant2000-12-16UHC-67105-34•••-••-1455793-541-8540JAMES.BRYANT23@YAHOO.COM8331 MESA DRGLENDALEAZ85377GRP-1274CHOICE-PLUS-PPO
ENRENR-1415612026-09-12T23:48:49ZBarbara—Kennedy1941-02-15UHC-78704-95•••-••-3257+1 473 894 6831barbara.kennedy@aol.com1436 Indian School RdSacramentoCA95889GRP-4619MEDICARE-ADV-B
ENRENR-1427182026-01-26T16:14:44ZCHRISTIANTPRICE1944-08-02UHC-56714-75··•••-••-9523UNKNOWN—1279 CHURCH STTucsonAZ85725-3147GRP-4528CORE-HMO
ENRENR-1135322026-04-17T00:18:06ZMeganTGarcia1979-11-28··UHC-85835-94•••-••-9446(829) 650-6587N/A9530 Forest AvenueAustinTX78723-1577GRP-4579CHOICE-PLUS-PPO
ENRENR-1151342026-04-24T12:29:21ZHeatherQFranklin3/14/2002UHC-57300-58•••-••-8538(213) 823-2750··UNKNOWN8801 BASELINE ROAD Apt 30DenverCO80240GRP-0512·NAVIGATE-HMO
ENRENR-1105842026-02-23T12:24:03ZCarlos—Stone1982-01-01·UHC-21036-35•••-••-2447791-604-9053CARLOS.STONE@YAHOO.COM3927 Lincoln WayAtlanta·GA30345GRP-5865NAVIGATE-HMO
ENRENR-1216552026-09-14T13:27:27ZANDREWWCOOPER1983-06-12—•••-••-4834(832) 993-5777andrew.cooper@icloud.com805 Desert Sky BoulevardCharlotteNC28211GRP-3110CORE-HMO
ENRENR-1276082026-07-18T15:36:12ZVirginiaCSantiago25-01-1972UHC-93186-39•••-••-7226·8053130390virginia.santiago@icloud.com9491 Highland AvenueSAN ANTONIOTX78220GRP-0339SELECT-EPO
ENRENR-1256392026-03-30T10:27:24ZNathan—Day19730811UHC-96207-66•••-••-91979135715049nathan.day12@hotmail.com3247 Maple AveChandlerArizona85245GRP-6556SELECT-EPO
ENRENR-1028272026-06-14T11:16:55ZSTEVENF.JACKSON1970-04-26UHC-10598-74•••-••-74864329754276STEVEN.JACKSON45@ICLOUD.COM··6686 Oak StTampaFL···33619GRP-1698MEDICARE-ADV-B
ENRENR-1287562026-08-28T22:48:53Zwong—jennifer12-05-1982UHC-71421-79•••-••-0180+1 606 684 9565—4080 Valley View DriveTucsonAZ·85790GRP-5317CHOICE-PLUS-PPO
ENRENR-1005342026-08-14T21:25:43ZDANIEL·DHOWELL20-09-2008UHC-61033-62•••-••-7759574.391.8569DANIEL.HOWELL45@AOL.COM8402 CHURCH STMesaAZ85222GRP-9506CHOICE-PLUS-PPO
ENRENR-1005502026-05-18T20:35:47ZARONUHARPER2008-11-02UHC-06862-81•••-••-1174(289) 634-1496N/A3658 Market StScottsdaleAZ··85237-1815GRP-7940NAVIGATE-HMO
ENRENR-1083322026-10-13T11:18:42ZLawrenceRLi1998-10-05UHC-16606-42•••-••-7459+1 948 978 2199—2792 SAGE CTSacramentoCA95831GRP-4736CHOICE-PLUS-PPO
ENRENR-1062052026-01-20T19:03:35ZRice, Charlse——1968-08-21UHC-28560-68-—charles.rice@proton.me7601 Spring StTampaFL33662-3865GRP-7732·CHOICE-PLUS-PPO
ENRENR-1287372026-07-18T02:30:29ZWeiP.Feilds·Dec 24, 1959UHC-62961-20UNKNOWN(218) 678-4775WEI.FIELDS44@AOL.COM5344 Church StreetLOS ANGELESCA90051GRP-4190MEDICARE-ADV-B
ENRENR-1033692026-01-14T15:03:27Zruht—vargas20010409UHC-73294-75··•••-••-94618469270847ruth.vargas57@proton.me7794 Union StreetGLENDALEAZ·85336GRP-5891SELECT-EPO
43,101 rows, page 41 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:34.802Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty