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-1018502026-08-10T03:38:31ZSHARONKHALL27-12-1974UHC-18998-04•••-••-422512765653804sharon.hall@yahoo.com8610 CEDAR LANE Apt 17MiamiFL··33149GRP-5529CHOICE-PLUS-PPO
ENRENR-1223692026-04-09T13:43:14ZAbigail··—Gomez··1954-05-20UHC-76184-54•••-••-2746—ABIGAIL.GOMEZ33@GMAIL.COM9733 APACHE BLVDTEMPEAZ85256-0698GRP-7377SELECT-EPO
ENRENR-1126652026-04-12T08:42:45ZJosephVWilliams·19744011UHC-89119-13•••-••-7786(559) 940-3013null6312 Hillcrest RoadMesaArizona85220GRP-7676SELECT-EPO
ENRENR-1325472026-06-06T08:34:43ZDenise—Walsh2/2/1953UHC-12416-13•••-••-4658(263) 701-1908DENISE.WALSH67@PROTON.MEN/A—N/A-GRP-8218·NAVIGATE-HMO
ENRENR-1055972026-01-31T05:28:29ZBobbyBClark1979-12-08UHC-66211-76·null8968846·UNKNOWN3170 Indian School RdMesaAZ85245··GRP-2462MEDICARE-ADV-B
ENRENR-1341592026-06-24T04:42:53ZCAROL—·JORDAN1984-07-07UHC-99700-18—204-401-0024CAROL.JORDAN@GMAIL.COM8464 Baseline RoadMESAAZ··85275GRP-7672CHOICE-PLUS-PPO
ENRENR-1010712026-03-07T01:21:33ZDEBRA—SIMMONS2005-06-27UHC-13215-75•••-••-4833(244) 332-7255debra.simmons8@hotmail.com521 Market StLOS ANGELESCA90041GRP-4287SELECT-EPO
ENRENR-1171782026-04-13T01:02:39ZJeffreyJ.Bradley1970-04-05··UHC-70006-33··•••-••-1977(249) 370-3732jeffrey.bradley41@outlook.com2460 Pine DrSCOTTSDALEAZ85291GRP-9909MEDICARE-ADV-B
ENRENR-1154312026-03-27T00:43:30Zbruce—patterson2008-10-21UHC-71398-56•••-••-0757814-707-6133BRUCE.PATTERSON54@HOTMAIL.COM9051 Washington St··HoustonTX77015GRP-2184NAVIGATE-HMO
ENRENR-1021292026-08-15T19:21:54Z·Jimmy—Guzman2006-10-20··UHC-19610-84•••-••-1455—james.guzman7@aol.com3124 Cedar LaneColumbusOH·43261·GRP-0375select-epo
ENRENR-1204832026-08-14T13:40:14ZDOUGLASR.MARSHALL19700819UHC-48557-75•••-••-8231987-932-6371douglas.marshall97@icloud.com534 Market StreetColumbusOH43252-7187GRP-7561MEDICARE-ADV-A
ENRENR-1014282026-08-09T02:48:05ZPadilla, MarthaT··1940-01-26UHC-51567-53•••-••-50683902255298martha.padilla@icloud.com3228 River Road #710TempeAZ85202GRP-5041MEDICARE-ADV-B··
ENRENR-1215782026-03-11T09:04:51ZRogerI··Bishop1960-11-05UHC-13274-63•••-••-7740880-674-9782—2419 PARK PLACEAtlantaGA30379GRP-0678OPTIONS-PPO
ENRENR-1343092026-08-06T09:34:32Zstephen—meyer1960-04-21UHC-55817-74•••-••-10815296226259stephen.meyer75@proton.me9395 Sage CourtJacksonvilleflN/AGRP-4318··choice-plus-ppo
ENRENR-1240722026-04-09T10:49:27ZPamelaQLopez·1942-03-06UHC7039355•••-••-7832385-298-3272pamela.lopez9@hotmail.com1080 River RoadSacramentoCA95824GRP-5455CORE-HMO
ENRENR-1350692026-04-05T15:32:14Z—W—19980104UHC-89508-38•••-••-20282275170991jordan.moore36@hotmail.com45 Lake View RdScottsdaleArizona85282GRP-6990MEDICARE-ADV-B
ENRENR-1049712026-03-09T01:00:15ZMason—Marquez04-12-1998UHC-73096-61null—NULL2385 Elm StMESAAZ··85228GRP-0401CHOICE-PLUS-PPO
ENRENR-1049772026-02-26T06:17:42ZSUSAN—KIM04-02-1987UHC-90882-73null+1 938 572 3040NULL9058 Camelback RdMinneapolisMN55456·GRP-6264MEDICARE-ADV-A
ENRENR-1428502026-02-12T07:17:08ZANAPHOEWLL02/13/40UHC-61450-49•••-••-5378987-738-9290ana.howell@aol.com8360 Pine DrMinneapolisMN55497GRP-4760MEDICARE-ADV-B··
ENRENR-1370832026-10-03T15:32:30ZNancyBArnold1956-01-19UHC-27742-29•••-••-4666(924) 239-7837nancy.arnold21@proton.me1624 Camelback RdTUCSON·AZ85719GRP-8203MEDICARE-ADV-A
ENRENR-1366642026-03-21T00:34:03ZNancy··Jaes1956-09-17··UHC-08079-42N/A(314) 268-9346—6858 Sage CourtDENVERColorado80228··GRP-1249medicare-adv-a
ENRENR-1405012026-08-08T05:58:46ZJerryCStevens1997-06-17UHC-69450-06•••-••-20532444550441jerry.stevens19@icloud.com4239 Union StSan DiegoCA92162GRP-9250CHOICE-PLUS-PPO
ENRENR-1086882026-04-20T00:03:47ZPatel, WalterE—07/01/2005UHC-76743-89NULL4442800558WALTER.PATEL@OUTLOOK.COM6868 MAPLE AVEPhoenixaz85063GRP-6653SELECT-EPO
ENRENR-1159442026-02-14T10:28:44ZKennethD.Riley1956-05-05UHC-28168-17—9599201064kenneth.riley70@proton.me8254 CHURCH STMesa··AZ·85244-5388GRP-8911OPTIONS-PPO
ENRENR-1230502026-07-17T10:36:30ZMadisonAStevens1949-07-20UHC7266241•••-••-1395(564) 902-2914madison.stevens@hotmail.com302 Cedar LaneEden PrairieMN55335GRP-4608CORE-HMO
ENRENR-1219192026-01-18T15:30:31ZKELLY—REED1965-04-13UHC-18092-14•••-••-1936+1 653 752 1335NULL1750 Grand Avenue #324MinneapolisMN55475GRP-7553MEDICARE-ADV-B
ENRENR-1237212026-10-09T23:08:02Z———08-03-1951UHC-57959-42-(738) 664-9942—1939 Mountain View DrChandlerAZ85227··GRP-7890NAVIGATE-HMO
ENRENR-1186962026-08-13T18:33:10ZJEFFREY··BALVARADO·2006-01-24UHC-62249-83—275.851.9425jeffrey.alvarado96@hotmail.com374 Palm DrCharlotteNC··28268GRP-2552·CHOICE-PLUS-PPO
ENRENR-1413482026-09-30T03:56:40ZMatthew—Wagner·07/23/1969——N/Amatthew.wagner@hotmail.com9281 UNION STGlendaleAZ85305GRP-2308MEDICARE-ADV-B··
ENRENR-1102312026-03-08T15:42:53ZSophiaJBowman····UHC1248424•••-••-3089794.610.8740··sophia.bowman33@hotmail.com6351 Willow CtPhoenixAZ85015GRP-7328SELECT-EPO
ENRENR-1185592026-05-01T05:11:03ZDENISE··X.WARREN06-03-1952uhc-93992-96•••-••-02394016969677-747 Camelback Road·NashvilleTN37229GRP-6967SELECT-EPO
ENRENR-1415512026-09-02T01:38:42ZDuncan, KarenY—07/14/1956··UHC-54582-64•••-••-8344796-362-4652··karen.duncan@aol.com23 Lincoln WayGILBERTAZ85264GRP-5844NAVIGATE-HMO
ENRENR-1197942026-02-09T18:08:53ZCharlotte—Singh23-08-1972UHC-87275-87UNKNOWN——6918 JEFFERSON AVENUEMinneapolisMinnesota55424GRP-2869MEDICARE-ADV-B
ENRENR-1100362026-05-27T09:43:21ZAUSTINZSTONE1957-12-23UHC-48905-18•••-••-12128351880austin.stone@outlook.com5773 CEDAR LNMIAMIFL33104GRP-7147·CHOICE-PLUS-PPO
ENRENR-1014722026-09-15T18:21:07ZOmarI.Burton1964-04-13UHC-87703-12-·(902) 546-6595·omar.burton@aol.com7786 Palm DriveGilbertAZ85203GRP-8749··select-epo
ENRENR-1008872026-09-08T00:41:35ZpaulZjimenez·1977-10-17UHC-80721-02•••-••-0241752-555-8763paul.jimenez77@hotmail.com·1194 PINE DR Apt 28TEMPEAZ85257GRP-5898CHOICE-PLUS-PPO
ENRENR-1223752026-04-06T23:03:22ZDylan—Clark1998-10-11—•••-••-9427(655) 369-2711dylan.clark@yahoo.com3398 Apache BlvdEden PrairieMinnesota55367GRP-4430NAVIGATE-HMO
ENRENR-1297362026-08-04T19:13:55Z RAYX.MCCOY1957-06-12··UHC-38052-26•••-••-43946009033498raymond.mccoy@aol.com8238 River RoadEden PrairieMN55394GRP-4401NAVIGATE-HMO
ENR ENR-1322302026-09-06T10:25:23ZSANDRRAFOBRIEN1975-12-18UHC-04569-93··•••-••-9526445.808.9307SANDRA.OBRIEN@YAHOO.COM6992 Jefferson AveFresnoCA93777GRP-2411NAVIGATE-HMO
ENRENR-1309652026-03-28T08:43:09ZAdamB.Griffin1984-03-08uhc-38974-87•••-••-3218205.831.5730adam.griffin@icloud.com8564 VALLEY VIEW DRIVESeattleWashington·98145GRP-3872NAVIGATE-HMO
ENRENR-1089232026-09-17T12:36:18Z·HenryFKing··1961-07-22UHC-50029-83•••-••-76982553639314·HENRY.KING90@AOL.COM1284 BROADWAYTampaFL33686GRP-1815MEDICARE-ADV-B
ENRENR-1066732026-03-16T12:50:44ZHannahLAndrews—UHC-23068-61•••-••-6217(897) 589-5438—8163 Bayshore DriveOrlandoFL32869GRP-9204OPTIONS-PPO
ENRENR-1125102026-09-29T11:24:00ZKelly—Powell1946-01-09UHC-60953-25•••-••-9492nullKELLY.POWELL87@YAHOO.COM5281 Palm DriveSan Diego·ca92145GRP-5520CHOICE-PLUS-PPO
ENRENR-1376462026-06-23T12:46:20ZBobby··—·Thomas1951-10-17—•••-••-9715898-429-4022—8893 Baseline RdMinneapolismn55437GRP-6038MEDICARE-ADV-A
ENRENR-1304342026-01-11T15:58:31ZLAURAQSCHMIDT2005-07-10··UHC-96464-76•••-••-3248569-975-2119laura.schmidt93@outlook.com4315 Union St·MESAArizona85230GRP-3794OPTIONS-PPO
ENRENR-116386 2026-10-04T11:16:23Zbenjamin—robinson2006-11-02UHC-34560-42•••-••-89852866185207N/A5706 CHURCH STREETSCOTTSDALE·AZ·85295-4146GRP-3249CHOICE-PLUS-PPO
ENRENR-1205602026-02-18T03:20:01ZRuth—Hall1968-09-24·UHC-41853-46•••-••-584512722957547ruth.hall3@aol.com·470 APACHE BOULEVARDColumbusOH43290GRP-3148·CHOICE-PLUS-PPO
ENRENR-1203512026-05-13T20:06:58Z CHRIS·Q.VASQUEZ1988-07-26UHC-43910-86•••-••-44465603745—7335 CANYON RDSan DiegoCA92190··GRP-2645SELECT-EPO
ENRENR-1132392026-09-04T16:03:49ZJoanY·Clark1967-11-09UHC-92120-58-236-483-5610joan.clark6@proton.me3163 Grand AvenueATLANTA··Georgia30308GRP-5666OPTIONS-PPO
ENRENR-1059672026-07-27T02:35:01ZOwens—·Alice1976-01-06UHC-31723-72•••-••-4782(583) 328-1428··alice.owens@hotmail.comnull———GRP-0764CHOICE-PLUS-PPO
43,101 rows, page 139 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:38.463Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty