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-1230372026-10-15T08:19:05ZWilliamCHenry1964-08-08UHC-07463-82•••-••-4547(973) 741-8757·WILLIAM.HENRY67@ICLOUD.COM912 Apache Boulevard·OrlandoFL32802GRP-1127CORE-HMO
ENRENR-1135552026-04-11T06:24:00ZCampbell, EmmaO—11/15/1971UHC-47039-85•••-••-8455416-311-8053—4875 Central AveMesa··AZ··UNKNOWNGRP-7923NAVIGATE-HMO
ENRENR-125421 2026-08-06T14:48:04ZJordanH.Watson1999-10-05UHC2272560•••-••-85898255465233—null—-—GRP-3078OPTIONS-PPO
ENRENR-1153172026-06-15T10:21:46ZTerryKColeman19390910UHC-28889-03··•••-••-3837755-353-3818terry.coleman88@proton.me9252 LAKE VIEW ROADGILBERTAZ85229GRP-8526MEDICARE-ADV-A
ENRENR-1369132026-07-03T01:10:56ZMoreno—Aisha1979-05-12UHC2238672•••-••-99518522992387UNKNOWN8472 MESA DRPhoenixAZ85040GRP-2894OPTIONS-PPO
ENRENR-1259412026-03-04T13:28:20Z TYLEROCOLE2004-09-07UHC-10594-20•••-••-6122(445) 301-3486—1535 JEFFERSON AVENUEPhoenixAZ85051GRP-5534navigate-hmo
ENRENR-1398822026-06-19T15:15:49ZDIEGOAYANG1939-12-09UHC-14396-91•••-••-5313(741) 519-6199DIEGO.YANG@YAHOO.COM1596 Canyon RoadMinneapolisMN55486GRP-2204··CHOICE-PLUS-PPO
ENRENR-1164122026-02-01T05:02:31ZJULIA—WALLACE1989-04-20UHC-67124-21•••-••-65404626087693null3655 Sage CourtSacramentoCA95819GRP-1060MEDICARE-ADV-B
ENRENR-1129192026-09-04T12:28:21ZwayneU.knight1980-34-27UHC-95604-13•••-••-9554(932) 806-7916wayne.knight80@aol.com6599 MARKET STREETChandler··AZ85227GRP-2513SELECT-EPO
ENRENR-1124822026-06-01T02:36:23ZOMARV.WASHINGTON1945-02-25UHC-08708-89•••-••-3754N/AUNKNOWN2801 Union StTempeaz85263GRP-3300MEDICARE-ADV-B
ENRENR-1355542026-03-29T06:31:09ZJustinY··Nichols··08/23/1978UHC-84031-32•••-••-5660+1 280 793 7863JUSTIN.NICHOLS@HOTMAIL.COM7207 Highland AvenuePLANOTX75083·GRP-9859MEDICARE-ADV-A··
ENRENR-1007342026-06-20T05:13:42ZSCOTT—STEPHENS1938-05-09-•••-••-531016525772506SCOTT.STEPHENS@GMAIL.COM9849 Sunset BlvdFresno··CA·93701-7436·GRP-5316MEDICARE-ADV-B
ENRENR-1177372026-05-17T23:24:50ZEugeneTHanson06/03/55UHC-51392-83•••-••-7016799.435.6982-·4699 Washington StreetAtlantaGA30324GRP-1358MEDICARE-ADV-B
ENRENR-1163802026-08-27T13:22:46ZMariana—Peters2002-11-02UHC-16391-22•••-••-58106002226952UNKNOWN5763 Bayshore DriveLos AngelesCA90074·GRP-9209CORE-HMO
ENRENR-1134142026-01-28T15:48:10ZEstrada, Nicholas····—1979-07-19UHC5774842•••-••-9127(732) 683-5696nicholas.estrada@icloud.com5564 Desert Sky BlvdSEATTLEwa98137GRP-7074CHOICE-PLUS-PPO
ENRENR-1147282026-05-29T18:43:38ZDorothyJSpencer6/17/1945UHC-83167-50•••-••-5800458-736-3297NULL8053 Meadow Ln·ATLANTAGAUNKNOWNGRP-7610·NAVIGATE-HMO
ENRENR-1285492026-02-08T22:37:09ZVINCENTWPADILLA1986-01-12UHC-44861-15•••-••-96268579745210—·1843 CENTRAL AVESan DiegoCA—GRP-9361CORE-HMO
ENR ENR-1044742026-01-17T12:19:51ZKATHLEEN—BAKER1943-04-12UHC-40436-49UNKNOWN7135346339kathleen.baker9@yahoo.com9748 Washington StreetAtlantaGA30329GRP-6455·MEDICARE-ADV-A
ENRENR-1172422026-01-26T23:14:34ZMORAESK.HELEN1959-10-23··UHC-42089-79•••-••-60873252917069·helen.morales9@hotmail.com3155 APACHE BOULEVARDLos AngelesCA90026GRP-1276OPTIONS-PPO
ENRENR-1232132026-03-22T16:42:58ZAUSTINQ.THOMPSON09/22/2004UHC-86839-81•••-••-5050(872) 385-6009austin.thompson@outlook.com9183 DESERT SKY BLVDGilbertaz85265GRP-4401MEDICARE-ADV-A
ENRENR-1280452026-04-30T23:53:11Z Tyler·F.Hudson1972-02-12UHC-96277-14•••-••-8138·699-638-2378tyler.hudson@yahoo.com7391 Elm StreetMinneapolisMN55417GRP-7730MEDICARE-ADV-A
ENRENR-1202382026-07-23T05:44:52ZJASON—NELSON1940-05-07UHC-92901-05•••-••-7815(223) 569-2840jason.nelson21@aol.com563 Church StreetSacramentoCA95840GRP-6771MEDICARE-ADV-B
ENRENR-1330912026-04-29T18:56:39ZParker, PatrickS—1986-09-01··UHC-14708-32··-—patrick.parker17@icloud.com5982 Bayshore DriveTempeAZ··nullGRP-9749···core-hmo
ENRENR-1379282026-07-16T22:29:43ZEspinoza, Gloria——04/17/77UHC1939367•••-••-6655(434) 535-3258gloria.espinoza@proton.me2480 Canyon RdDENVER··CO80237GRP-9658CHOICE-PLUS-PPO
ENRENR-1285882026-01-29T01:04:35ZEthanL.Turner4/18/1980UHC4161689•••-••-9806(722) 666-9340ethan.turner82@gmail.com2619 Highland AvenueSACRAMENTO··CA95874GRP-3938MEDICARE-ADV-B··
ENRENR-1220092026-04-30T08:32:32ZEmma—Turrner02/08/1944UHC7291116NULL·8713525971—6871 MOUNTAIN VIEW DRIVEGilbertaz85242GRP-1778·SELECT-EPO
ENRENR-1263242026-10-01T13:35:09ZDorotyhJ.Alvarado3/14/1954uhc-59713-55•••-••-0292891-723-4380DOROTHY.ALVARADO56@GMAIL.COM··6812 Park PlaceJacksonvilleFL32212GRP-4029MEDICARE-ADV-B
ENRENR-1134432026-01-01T19:39:40ZGaryRWest1940-04-16UHC-94532-50•••-••-5376N/ANULL5456 Cedar LaneEden PrairieMN55398GRP-9733·CHOICE-PLUS-PPO
ENRENR-1234772026-03-26T20:47:24ZJohnBHernandez2001-09-16UHC-50279-61•••-••-1588·9772230676john.hernandez@proton.me·5504 DESERT SKY BLVDDenverCO80203GRP-8983CORE-HMO
ENRENR-1276132026-01-01T11:36:32ZDot··—Green21-08-1985··UHC-13074-61•••-••-93623933189687dorothy.green@hotmail.com1200 HARBOR BOULEVARDMinneapolisMN55482GRP-2959CORE-HMO
ENRENR-1292422026-07-08T04:30:06ZFrankA.Payne··1995-07-16UHC-69731-21•••-••-5612722-411-1339frank.payne@icloud.com··1501 WASHINGTON STREET··GLENDALEAZ85300GRP-4923MEDICARE-ADV-A
ENRENR-1011742026-01-31T06:57:10ZAmy—Woong1998-07-28UHC-95146-52NULL(824) 365-5662amy.wong90@proton.me3591 BROADWAYSacramentoCA95820GRP-4765MEDICARE-ADV-B
ENRENR-1041402026-03-20T12:58:27ZSandoval, SamanthaV.—06/18/00UHC-17937-83N/A946-647-4914null7192 Highland AveMinneapolisMN·55419GRP-7446OPTIONS-PPO
ENRENR-1201372026-08-16T00:12:06ZNichols, OmarG—1974-12-28UHC-45484-87•••-••-5601+1 506 640 3452—1161 RIDGE RDDenverCO··80273GRP-0508medicare-adv-a
ENRENR-1365182026-10-03T19:03:13ZSARA—HAWKINS02/02/1986uhc-45242-14•••-••-47429262901022··null1415 Ocean AvenueAtlantaGA30337GRP-0717·MEDICARE-ADV-A
ENRENR-1386162026-08-31T20:07:35ZMARGARET—BANKS12/17/2003UHC-02221-08•••-••-2137·18087806638margaret.banks51@icloud.com6612 BASELINE ROADFresno·California93762GRP-4249NAVIGATE-HMO
ENRENR-1079232026-06-14T20:12:04ZGERALDWRICHARDSON1957-04-11UHC-52791-35•••-••-27982998825660··gerald.richardson@proton.me1747 SAGE COURT #988GilbertAZ85254GRP-3281CHOICE-PLUS-PPO
ENRENR-1214382026-05-19T11:47:51ZTeresa—Martinez02/26/1976UHC-30493-45•••-••-3718961.478.6866teresa.martinez@gmail.com332 Cedar LaneTucsonArizona85752GRP-8243MEDICARE-ADV-B
ENRENR-1183922026-03-18T00:13:42Zstephen··L.lawson1974-09-03UHC-40167-97•••-••-1754(894) 211-4802stephen.lawson34@outlook.com··5405 VALLEY VIEW DRDENVERColorado··nullGRP-3882·NAVIGATE-HMO
ENRENR-1105112026-01-29T12:51:34ZWAYNE··EGRAHAM12/25/1971··UHC6626017•••-••-2063(251) 872-2302WAYNE.GRAHAM@GMAIL.COM9446 Central AvenueOrlando··FL32802GRP-3832OPTIONS-PPO
ENRENR-1307732026-06-07T03:55:10ZDEBORAHA.HOFFMAN19551220UHC5807009•••-••-41176522655625DEBORAH.HOFFMAN1@HOTMAIL.COM551 Spring StreetChandlerAZ·85202-1745GRP-7925NAVIGATE-HMO
ENRENR-1000822026-07-31T03:47:11Z ·Mari—Ortiz1999-11-28UHC-72125-46•••-••-3542236.909.2219MARIA.ORTIZ@PROTON.ME5555 Harbor Blvd #443JACKSONVILLEFL32241GRP-3853MEDICARE-ADV-A
ENRENR-1289842026-02-12T19:17:18ZLisaU.Stewart1977-12-24UHC9035921N/A608-779-5089null8323 Harbor BoulevardHoustonTX77005GRP-5961CORE-HMO
ENRENR-1222962026-10-01T13:03:19ZGregory—Woods··UNKNOWNUHC-74086-93•••-••-9361854-416-2356gregory.woods@hotmail.com2736 OAK STREETSan DiegoCA-GRP-1416·SELECT-EPO
ENRENR-1150712026-05-09T22:48:01ZANNK.DAVIS1951-07-28UHC-65874-73•••-••-4750·918.986.8567ANN.DAVIS51@AOL.COM2840 Cedar LaneOrlandoFL32807GRP-8002MEDICARE-ADV-A
ENRENR-1056142026-01-24T05:35:21ZLOGAN—LEWIS19800119UHC-94631-76•••-••-8588418-272-0832logan.lewis92@gmail.com924 Indian School Rd #348JacksonvilleFL32236GRP-5109SELECT-EPO
ENRENR-1341222026-06-11T05:41:14ZValentina··H.Reed04/11/1942UHC-49323-16•••-••-50657309247309valentina.reed22@gmail.com5582 MAPLE AVENUESan DiegoCA92117GRP-6609CORE-HMO
ENRENR-1295622026-10-04T12:55:02ZTHERESAUHICKS02/09/1969UHC-01574-14•••-••-66525654780theresa.hicks71@aol.com1799 Highland AvenueJacksonvilleFL32208GRP-0590MEDICARE-ADV-A
ENRENR-1007272026-04-19T23:47:31ZCarlos—Rose1938-05-13·UHC-25199-96null2322482292—7906 SUNSET BLVDDenverCO80246··GRP-1464CORE-HMO
ENRENR-1011032026-07-02T10:31:47ZTeresa—Perry1930-82-25UHC-36932-17•••-••-3814981-985-5949THERESA.PERRY@ICLOUD.COM7782 Willow CourtHoustonTX77096GRP-9479OPTIONS-PPO
43,101 rows, page 10 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-19T19:54:25.419Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty