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
ENR ENR-1217732026-02-08T22:23:23Z·Omra—Castro1938-12-18UHC-52606-73•••-••-6972542-906-7973N/A6204 Forest Avenue Apt 22GilbertArizona85286GRP-3026NAVIGATE-HMO
ENRENR-1387792026-08-18T12:24:41ZOlivia—Shaw1957-04-28UHC-50891-73•••-••-9231(216) 956-4424··olivia.shaw21@proton.me6872 Jefferson AveDallasTX75259GRP-4241··MEDICARE-ADV-B
ENRENR-1048162026-08-28T18:29:28ZAbigail—Freeman1940-01-20UHC-60056-86•••-••-60343975775670NULL7577 Baseline RdMinneapolisMN55477GRP-8477MEDICARE-ADV-A
ENRENR-1014742026-09-03T04:07:01ZLOGANBSIMS1982-02-26UHC-95454-32•••-••-5010253-818-0435—·539 MEADOW LNHoustontx·77006GRP-1881NAVIGATE-HMO
ENRENR-1199112026-06-13T03:20:26ZADAM K.—ESPINOZA·NULLUHC-06637-93UNKNOWN468-852-1356ADAM.ESPINOZA@PROTON.ME7933 Sunset BoulevardPhoenixAZ85026-6770GRP-9579SELECT-EPO
ENRENR-1303982026-01-25T05:43:00ZJorddan—Harrizon07/07/55UHC-94211-97•••-••-8049696.703.2824jordan.harrison@outlook.com··9049 Grand AveMinneapolisMN55416·GRP-3409OPTIONS-PPO··
ENRENR-1067422026-09-22T06:46:14Zjames··hendersonDec 19, 1975UHC-00613-90•••-••-45454786508381JAMES.HENDERSON@GMAIL.COM6458 Meadow Lane #469Glendale··AZ85305GRP-0670OPTIONS-PPO
ENRENR-1267472026-02-01T04:34:03ZArjun—Woods··15-05-2005UHC-68559-43•••-••-6650799.557.2816arjun.woods@aol.com··1573 Ocean Avenue #899PhoenixAZ85021GRP-6493OPTIONS-PPO··
ENRENR-1385982026-02-09T13:56:55ZTeresa—Aguilar1981-02-28UHC-46788-51•••-••-4387UNKNOWNteresa.aguilar45@gmail.com1690 WILLOW CTAustinTX78758GRP-7770··MEDICARE-ADV-B
ENRENR-1329002026-09-01T21:27:13Z AHMED—ROSE1972-11-01UHC-11855-20•••-••-9374·(900) 768-4149ahmed.rose@hotmail.com4535 Camelback Rd #907SeattleWashingtonN/AGRP-8270OPTIONS-PPO
ENRENR-1060842026-10-11T19:22:56ZDIEGOUNUNEZ5/19/1939UHC-84881-76•••-••-7063(498) 517-9327N/A5397 Washington StGilbertaz85261GRP-9908·SELECT-EPO
ENRENR-1409832026-02-14T02:49:21ZSAMANTHAW.···BURTON1966-06-09··UHC-13043-98··•••-••-9199(967) 692-6398samantha.burton27@icloud.com3599 Church StGilbertAZ85286··GRP-3028MEDICARE-ADV-B
ENRENR-1170702026-05-09T00:11:09ZJESSE—DIAZ10/26/59UHC-17665-61•••-••-6091+1 507 961 5018jesse.diaz@gmail.com5728 Lincoln WayDallasTX75298GRP-6143CORE-HMO
ENRENR-1118512026-05-28T19:12:43ZJuan—Carroll11/20/1960UHC-88791-78•••-••-85822164361800··juan.carroll@hotmail.com6460 CHURCH ST #925San AntonioTX—GRP-1536OPTIONS-PPO
ENRENR-1276422026-01-02T21:47:37ZFRANKK.HOWARDSep 13, 1984UHC-75968-98•••-••-82212514628449FRANK.HOWARD37@GMAIL.COM4846 Elm StreetGLENDALEAZ85353GRP-6467NAVIGATE-HMO
ENRENR-1078422026-07-11T06:51:34Z·DONALDKMARTIN19800117··UHC-71366-28•••-••-4445756-466-8641donald.martin@aol.com··4944 SAGE COURTGilbert·AZ85249··GRP-7914NAVIGATE-HMO
ENRENR-1074912026-01-31T19:02:56ZGloria—Murpphy2004-08-19UHC-23710-22•••-••-8653(623) 629-6008····2342 Willow CourtFresnoCAUNKNOWNGRP-5443CHOICE-PLUS-PPO
ENRENR-1059772026-09-23T20:52:38ZAhmedR.Hill14-10-1939UHC-13347-11•••-••-2029N/AAHMED.HILL@HOTMAIL.COM6465 SPRING STREETTempeAZ85249-3824GRP-7843MEDICARE-ADV-B
ENR ENR-137804 2026-04-09T19:42:22ZCARLOS··VBRYANT1954-09-18··UHC-52690-27•••-••-5672291-994-9150carlos.bryant71@aol.com6753 Hillcrest RoadTampaFL33609GRP-6589MEDICARE-ADV-B
ENRENR-1402512026-03-01T18:47:53Z·KarenIBisohp6/5/1996UHC-78276-89•••-••-276719389182720karen.bishop@yahoo.com4628 River RoadMiamiFlorida33156GRP-5410MEDICARE-ADV-A
ENRENR-1155052026-04-23T07:15:18ZCarlCWatson19470609UHC-46114-22•••-••-9898635-614-1072—4297 Palm DrMIAMIFL·33100GRP-0630··MEDICARE-ADV-B
ENRENR-1074832026-03-03T11:03:59ZRUTHZ·HANSON1985-06-06UHC-73022-03•••-••-889818265345553RUTH.HANSON83@OUTLOOK.COM3317 Church Street #997··TempeAZ85236GRP-1728MEDICARE-ADV-B
ENRENR-1054642026-06-21T10:09:19ZNicholas—Crawford2005-03-02UHC-87530-99··•••-••-8352(949) 681-4784null··8939 PALM DRHoustonTX77065GRP-2630MEDICARE-ADV-B
ENRENR-1265342026-06-17T20:42:21ZWAYNEP.MENDEZ19720722UHC9996274•••-••-8832513.369.9948wayne.mendez@outlook.com1804 Ridge RdTempeAZ··85293GRP-4479MEDICARE-ADV-A
ENRENR-1347922026-01-19T22:12:11ZMasonLRay1998-01-13UHC-72538-25•••-••-09467658124951NULL4708 BAYSHORE DRIVETempeAZ85228GRP-3556OPTIONS-PPO
ENRENR-1161352026-05-17T14:07:52ZCastro, Wayne——·2004-05-01UHC-11215-95··•••-••-48936238380356—7173 Baseline RoadLos AngelesCA90026-1118GRP-7458CHOICE-PLUS-PPO
ENRENR-1313242026-01-02T16:43:25Z·Jason—Burns1975-12-26UHC-85963-06•••-••-0594—UNKNOWN5434 Camelback RdEden PrairieMN55310GRP-9744CORE-HMO
ENRENR-1113622026-03-20T00:02:08Z·Jacqueline—BakerNov 8, 1945·UHC-92956-55•••-••-77844757607876jacqueline.baker@icloud.com6071 Palm DrATLANTA·GA·30360GRP-1677MEDICARE-ADV-A
ENRENR-1350112026-08-31T10:37:26ZBRANDON··MGRANTMar 23, 1939UHC-80242-34•••-••-60964002817290brandon.grant64@gmail.com5840 LINCOLN WAY·ChandlerAZ85295GRP-0631OPTIONS-PPO··
ENRENR-1236232026-06-24T18:41:07ZWayneQSilva2005-02-18··UHC-07518-90•••-••-988612374504670WAYNE.SILVA30@AOL.COM3386 Union StreetOrlandoFL32817GRP-4231CHOICE-PLUS-PPO
ENRENR-1340412026-05-20T03:24:23ZJasonL.··PirceJan 17, 2004UHC-96758-59•••-••-6531(719) 587-3258—9259 JEFFERSON AVENUEDenver·CO80245GRP-4687MEDICARE-ADV-A
ENRENR-1099332026-06-07T08:23:11ZBENJAMINW.WRIGHT1951-07-02UHC-27704-99•••-••-8830(726) 483-2451benjamin.wright@icloud.com6627 Meadow Ln Apt 31Los AngelesCA90055GRP-8945medicare-adv-b
ENRENR-1423022026-08-27T14:58:21ZDorisSSalazar1956-03-05UHC-06432-67•••-••-80658562577470doris.salazar22@yahoo.com8951 Baseline RdSan Antonio·TX78222··GRP-5981NAVIGATE-HMO
ENRENR-1315572026-07-04T15:29:29ZBlack, JeanD—1959-10-05UHC-94600-18—18908104685null1446 Ocean AvenueDALLASTX75218GRP-5268MEDICARE-ADV-B
ENRENR-1211412026-10-07T18:35:31ZJeffreyKCooper1969-05-25UHC-64534-54•••-••-3245null—4452 Elm StreetSan Antonio··TX78210GRP-3557CHOICE-PLUS-PPO
ENRENR-1043422026-10-01T03:45:06Z LawrenceG··WheelerNov 5, 2008UHC-35018-15-nullnull2329 INDIAN SCHOOL ROADGilbertAZ85266GRP-9176NAVIGATE-HMO
ENRENR-1221672026-10-15T00:11:48ZAmyL.Holmes10/24/1953··UHC-75186-65•••-••-1485815-553-7559—5068 MEADOW LANE··MinneapolisMN55479GRP-2069CORE-HMO
ENRENR-1335192026-05-22T14:16:20ZCheryl·XSanchez18-06-1989UHC-32116-40•••-••-4422835.234.3837cheryl.sanchez@hotmail.com5280 Desert Sky BoulevardSan Diegoca92179GRP-3481SELECT-EPO
ENRENR-1013192026-04-18T05:47:52ZJustinU.··Weber1948-06-28UHC-21843-63•••-••-2785N/A··justin.weber@hotmail.com9726 Palm DriveMIAMIfl33131GRP-7972core-hmo
ENRENR-1128432026-08-30T19:53:45ZJessica—Hughes1965-08-15UHC-84870-33•••-••-37888316385944JESSICA.HUGHES@OUTLOOK.COM4753 Mountain View DrChandler·AZ85254GRP-4582MEDICARE-ADV-A
ENRENR-1158992026-07-08T08:31:31ZARTHURG·WARREN1957-09-17UHC-86622-12•••-••-71315265263860arthur.warren@icloud.com952 BroadwayChandlerAZ85296GRP-9775NAVIGATE-HMO
ENRENR-1085232026-09-07T07:46:10ZAlice··—Burke1962-07-04UHC-35007-83—UNKNOWNalice.burke@proton.me9144 Forest AveFresnoCA93701GRP-1158MEDICARE-ADV-A
ENRENR-100196 2026-08-19T22:35:26ZGloriaT.Walsh11-06-1941UHC-92335-10•••-••-5720848-798-2440—·7387 Elm StChandlerArizona85204··GRP-9171CHOICE-PLUS-PPO
ENRENR-1023582026-07-09T06:09:50ZnatalieWharrison1962-12-17UHC-82848-19-5344398162··3976 BROADWAYLas VegasNevada89161GRP-6126OPTIONS-PPO
ENRENR-1245282026-10-02T04:22:06ZMEI···E.GARZA1980-11-28UHC-69301-69•••-••-8760361-848-0401mei.garza37@hotmail.com2796 INDIAN SCHOOL ROADPhoenixAZ·85094GRP-0753MEDICARE-ADV-B
ENRENR-1163932026-06-28T20:40:52ZAngela—Marquez20010712UHC9128659•••-••-03982716583170angela.marquez46@yahoo.com6514 Harbor BoulevardAustinTX—GRP-3283select-epo
ENRENR-1319192026-09-25T17:45:02ZJose··NSingh1976-11-13UHC-64453-09•••-••-5839(321) 574-0294N/A1411 Sage CtFresnoCA··93722GRP-5363OPTIONS-PPO··
ENRENR-101804 2026-02-28T23:28:29ZJOSHUAGSALAZAR1993-03-23UHC-92713-85•••-••-9510(213) 498-3184JOSHUA.SALAZAR43@PROTON.ME559 Park PlCHARLOTTENC·28248GRP-3851NAVIGATE-HMO
ENRENR-1302992026-01-22T01:44:21ZWillie··WashingtonMar 19, 1951UHC-96039-67•••-••-5319605-860-2454NULL893 Sunset BlvdSeattle··WA98147··GRP-2533OPTIONS-PPO
ENRENR-1075822026-04-01T07:23:53ZMarkDEspinozaDec 3, 1947UHC-46329-47•••-••-02246137008519MARK.ESPINOZA@HOTMAIL.COM8996 RIDGE ROADPlanoTX75018GRP-4792OPTIONS-PPO
43,101 rows, page 11 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