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-1243032026-04-27T02:14:35ZJustin—Schultz8/9/1985UHC-07089-67•••-••-4700+1 428 609 4867··justin.schultz@proton.me6556 Mountain View DrGlendaleAZ85309GRP-6488choice-plus-ppo
ENRENR-107164 2026-01-12T23:12:01ZJason··SMills1948-12-80UHC-87174-74•••-••-4154281-247-5291jason.mills65@gmail.com1493 Sage CtColumbusOH43203GRP-5129NAVIGATE-HMO
ENRENR-1249402026-01-11T01:04:18ZAERONN.COX1973-07-25UHC-64407-76•••-••-966317279877927UNKNOWN4580 Elm StreetMesaArizona85201GRP-1972CORE-HMO
ENRENR-1237912026-08-13T18:37:36ZDeniseVOrtega1956-02-19UHC-05763-13•••-••-2981(547) 658-4625denise.ortega62@gmail.com9540 BroadwayDallasTX75244-0542GRP-9086CORE-HMO
ENR ENR-1127662026-03-13T05:50:28ZDOUGLASP·GUERRERO·16-07-1950UHC-64405-71•••-••-4816—douglas.guerrero@hotmail.com2494 SPRING STREET··Fresnoca93782GRP-0931NAVIGATE-HMO
ENRENR-1425992026-07-19T04:20:50ZPamelaK··Webb·22-12-1994UHC-82507-79•••-••-0654620.477.0385—1105 Mountain View DriveATLANTAGA30302-7046GRP-0929CHOICE-PLUS-PPO
ENRENR-1400792026-03-02T02:36:55ZEthan—Ramos07/20/96UHC-82654-90•••-••-73955419892694ethan.ramos19@gmail.com6394 MAIN STREETEden PrairieMN55327·GRP-7720OPTIONS-PPO
ENRENR-1342342026-03-04T08:01:07ZJAMESN.ORIZ1940-60-28UHC-18976-70•••-••-975015575874242—7211 DESERT SKY BOULEVARD··PhoenixAZ85022GRP-9260SELECT-EPO
ENRENR-1162062026-05-22T04:17:47ZAdamL.Elliott01-10-2008—•••-••-79594994595403ADAM.ELLIOTT2@PROTON.ME4898 Church StreetGlendaleAZ85372GRP-4392CHOICE-PLUS-PPO
ENRENR-1359862026-06-07T14:42:35ZMADISON—CASTRO1947-09-03UHC-09358-13N/A7763270107-5733 OCEAN AVETempeAZ—GRP-7912MEDICARE-ADV-A
ENRENR-1184892026-06-03T18:47:30ZIsabellaNLynch—UHC-07898-24•••-••-2796nullISABELLA.LYNCH36@GMAIL.COM630 CHURCH STPhoenixArizona85099GRP-1014MEDICARE-ADV-B
ENR ENR-1018522026-07-21T00:53:53ZVictoria—Diaz1958-02-23UHC-29726-97•••-••-5491(283) 926-3671victoria.diaz45@icloud.com1519 OCEAN AVEFresnoCA93785GRP-2333SELECT-EPO
ENRENR-1099982026-04-30T07:28:16ZMAIRA F··KIM1984-10-06UHC-95297-64•••-••-48488703153953—7710 DESERT SKY BOULEVARDPlanoTX75065GRP-7472CORE-HMO
ENRENR-1079652026-06-15T15:52:37ZBecky··—Morris8/19/1987UHC-90474-32—+1 437 728 4574—9442 Maple AveJacksonvilleFL32265-7638GRP-9222CHOICE-PLUS-PPO
ENRENR-1123812026-01-25T07:59:24ZOliviaKGibson06/01/1956UHC-86207-11•••-••-8379+1 321 720 1855—8942 Harbor Blvd Apt 37CHANDLERArizona85206GRP-0673NAVIGATE-HMO
ENRENR-1255962026-08-04T23:42:41ZBEVERLYY·ELLIS19850111UHC-71874-73•••-••-1799(795) 321-1455·beverly.ellis@proton.me3110 Park Place·Tempe·az85219GRP-2786MEDICARE-ADV-B
ENRENR-1084562026-05-01T07:06:29ZAndrews, Jessica——1975-11-03UHC-57285-92•••-••-9911·8985645732N/A8940 Meadow LnLas VegasNV89107GRP-0172MEDICARE-ADV-B
ENRENR-1262732026-01-19T01:23:31ZGLORIASLEE·1988-09-05UHC-33495-99•••-••-4855·5609335158gloria.lee@aol.com2438 Sunset BoulevardLos AngelesCA90068GRP-9505CHOICE-PLUS-PPO
ENRENR-1252452026-09-10T06:58:23ZBeckyWWheeler1972-06-01UHC-99980-37•••-••-6567(659) 867-9495UNKNOWN627 Apache BoulevardNashvilleTN37245GRP-3278CHOICE-PLUS-PPO
ENRENR-1345972026-04-21T18:08:40ZAguilar, Harold——03/18/1944UHC-68897-39•••-••-12552407540376harold.aguilar@aol.com1195 Desert Sky BoulevardLas VegasNV89167GRP-4431CORE-HMO
ENRENR-1168152026-05-30T04:57:33ZJose—Perry1957-01-22UHC-96029-46•••-••-4194(868) 540-5986jose.perry77@hotmail.com332 OCEAN AVEMiamiFL33192·GRP-6700CORE-HMO
ENRENR-124783 2026-03-09T22:34:57ZHeather—Moarles1942-08-03UHC-30285-90•••-••-25627260394NULL6122 Baseline Road Apt 26··AustinTX78708GRP-3140SELECT-EPO
ENRENR-1243632026-07-12T12:09:27ZSophia—Alexander1973-02-01UHC-65817-15null+1 719 545 6296sophia.alexander@outlook.com7574 Canyon RoadJACKSONVILLEFL32239··GRP-8836OPTIONS-PPO
ENR ENR-1099302026-05-13T19:14:44ZRobertson, JackU—1970-12-17UHC-88651-91•••-••-6061613-960-5593—883 Ocean AveTucsonaz85755GRP-1685MEDICARE-ADV-B
ENR ENR-116999 2026-05-30T10:21:33ZMaria—McDonald1959-09-15UHC-99859-28•••-••-5345—maria.mcdonald48@yahoo.com8254 Cedar LaneGlendaleAZ85327GRP-3026medicare-adv-a
ENRENR-1202832026-09-01T05:34:21ZPhilip··EMarquez19961205·UHC-60620-95•••-••-4404499-387-2619philip.marquez@aol.com875 BroadwaySeattleWANULLGRP-2056MEDICARE-ADV-B
ENRENR-1313932026-07-15T23:44:10ZALAN—RIIVERA1963-06-13UHC-94559-44•••-••-9947—alan.rivera27@hotmail.com1865 Willow CtPhoenixAZ85048GRP-0938··OPTIONS-PPO
ENRENR-1063422026-03-07T09:24:19ZDebraVMills·1999-09-06UHC-81228-32•••-••-3132(568) 617-1947DEBRA.MILLS49@AOL.COM··5021 Oak St·SacramentoCA95823GRP-5785MEDICARE-ADV-A
ENRENR-1038972026-01-10T14:08:59ZRYAN—LITTLE1995-06-13UHC-91652-15•••-••-1323570-296-9473ryan.little@icloud.com8002 Mountain View DriveEDEN PRAIRIEMN55327GRP-6413SELECT-EPO
ENRENR-1092902026-04-06T13:49:37ZRonnald—Pierce1989-04-14UHC-95440-53•••-••-847613038921432-6679 Union StTEMPEAZ85249GRP-4685MEDICARE-ADV-B
ENRENR-1389402026-08-16T03:58:00ZLane, ArjunD.—1947-09-01UHC-48199-69•••-••-1505(350) 614-1099N/A·4271 Lake View RdJacksonvilleFL··32284GRP-3736CHOICE-PLUS-PPO
ENR ENR-1163282026-05-22T13:43:36ZVirginia··FSmith·1963-08-07UHC2184147•••-••-8007-VIRGINIA.SMITH11@OUTLOOK.COM4860 Canyon RoadLas Vegas··NVNULLGRP-9773SELECT-EPO
ENRENR-1344482026-06-15T16:08:57ZCamila—Chen1977-01-12UHC-66437-32•••-••-9082416.684.0302camila.chen38@aol.com··130 Harbor BoulevardGlendaleAZ85327-5903GRP-4766CHOICE-PLUS-PPO
ENRENR-1302422026-09-27T11:39:00ZMarianaHHenderson··03/27/2002UHC-04490-01•••-••-45158248401156—3267 BroadwayORLANDO·FL32884-0076GRP-4498NAVIGATE-HMO
ENRENR-1153482026-05-27T04:13:21ZMegan····Bishop1955-01-24UHC-44146-84•••-••-4511204.537.6570—9082 Spring Street #860Orlandofl32854GRP-8981··CHOICE-PLUS-PPO
ENRENR-1182982026-02-03T15:30:43ZloganS.ortiz09/01/79UHC-82763-27•••-••-8901(860) 805-6585LOGAN.ORTIZ94@GMAIL.COM3486 SUNSET BLVDTempeArizona85257·GRP-6039OPTIONS-PPO
ENRENR-1328462026-08-03T18:13:55Z ·Paul—Price2001-03-20UHC-42527-83•••-••-8217(803) 219-0290UNKNOWN6131 Jefferson Ave·GlendaleAZ85325GRP-6312CORE-HMO
ENRENR-1128492026-09-05T00:33:42ZJason—Rogers1939-03-12UHC-95536-74•••-••-9522944-377-8216jason.rogers@hotmail.com2823 Canyon RdDENVERCO80231GRP-7940OPTIONS-PPO
ENRENR-1152212026-05-23T13:04:46Z·Joseph—Prie2002-11-10UHC-20155-94•••-••-03655697032602UNKNOWN2777 HILLCREST RDDENVERCO80250GRP-7304MEDICARE-ADV-B··
ENRENR-1217422026-02-28T02:12:51ZDanny—Fields6/14/1944UHC-38023-03•••-••-991819289952086—5374 CHURCH STREETFresnoCA93777GRP-2893OPTIONS-PPO
ENRENR-1416312026-07-09T19:39:13ZEdwardWDelgado4/6/1986UHC-03441-65•••-••-3053205-621-3545··-7159 WASHINGTON STSan Diego·CAN/AGRP-7471MEDICARE-ADV-A
ENRENR-1291982026-03-09T16:17:52ZABIGAILFGILBERT04/04/89UHC-55949-97•••-••-8825·-ABIGAIL.GILBERT@YAHOO.COM937 CANYON ROADOrlando·fl32841GRP-2208SELECT-EPO
ENRENR-1190902026-06-07T15:51:51ZArthur—Pierce1950-01-16UHC-83937-90•••-••-81472867155N/A6768 Lincoln WayTampaFL33673GRP-9567CHOICE-PLUS-PPO
ENRENR-1375642026-01-25T03:08:34ZAmber—Wheeler03/05/2007UHC-82210-35•••-••-42414702961219AMBER.WHEELER58@OUTLOOK.COM··638 Forest AvenueMESAAZ85250GRP-1452MEDICARE-ADV-B
ENRENR-1410962026-03-08T18:38:27ZMeiPBishop09/12/82UHC-14148-92•••-••-87273023198981mei.bishop82@aol.com8239 PARK PL Apt 5PlanoTX75021GRP-8117MEDICARE-ADV-B
ENRENR-1200802026-04-24T19:56:20ZBetty—Walsh·1988-09-04UHC-06757-59•••-••-20689128288778-3850 Maple AvenueSacramentoCA95804GRP-3123NAVIGATE-HMO
ENR ENR-1354062026-03-23T10:35:20ZChristopherHGriffin07/14/1981UHC-12255-20•••-••-97765198451453christopher.griffin49@aol.com9796 ELM STREETSan DiegoCA92171GRP-5768MEDICARE-ADV-A
ENRENR-1080062026-02-08T06:53:38Zann—anderson0121-09-70UHC-38548-51•••-••-6070—N/A3585 Union StNashvilleTennessee—·GRP-5811MEDICARE-ADV-A
ENRENR-1099682026-06-24T03:24:11ZDanielTHicks19380716UHC-52172-92•••-••-7912(541) 831-0349daniel.hicks35@outlook.com··8578 Mesa DrGlendaleAZ85315GRP-4094NAVIGATE-HMO
ENR ENR-1002112026-01-15T02:06:16Z·JudyC.Alvarze02/13/1941UHC-22408-95•••-••-4230421-335-2596UNKNOWN2526 Washington StreetEden PrairieMN55370GRP-4420CHOICE-PLUS-PPO
43,101 rows, page 270 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:43.426Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty