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-1070912026-01-03T06:38:53Z SantiagoP.Robinson1957-07-26UHC-06217-27•••-••-3065661-481-8431null1268 Desert Sky BoulevardColumbusOH43274GRP-9296NAVIGATE-HMO
ENRENR-1231002026-04-11T05:13:37ZJOSEPHXORTEGA1997-09-26UHC-18784-87•••-••-1425NULLJOSEPH.ORTEGA89@ICLOUD.COM4871 Maple AveSacramentoCA95879GRP-3490NAVIGATE-HMO
ENRENR-1229822026-09-29T03:47:12Z·ABIGAIL—ROBERTS1963-06-08UHC-14496-11•••-••-3005(333) 830-4448abigail.roberts93@proton.me3460 MARKET STREETNashvilleTN37298GRP-6275SELECT-EPO
ENR ENR-1281682026-07-03T07:41:57ZJoeG·Stewart·Feb 11, 1953-—5262346068··JOE.STEWART37@YAHOO.COM286 Sage CtLOS ANGELESCAUNKNOWNGRP-4592CORE-HMO
ENRENR-1189892026-04-17T11:13:02Z THERESAE.HUDSON24-01-1960UHC-74120-88•••-••-8027214.318.1438theresa.hudson@icloud.com8022 Lincoln WaySacramentoCA95852GRP-0280MEDICARE-ADV-B
ENRENR-122284 2026-06-20T11:15:24ZKARENW.NUNEZ1964-07-26UHC-53022-61•••-••-26393893833489—315 Indian School Rd #671Atlanta··ga··30324GRP-3050CHOICE-PLUS-PPO
ENRENR-1141482026-05-23T16:46:14ZWilliam—·Dominguez19440221UHC-29789-20··•••-••-15328795196575—716 MAPLE AVEFresnoCA93759GRP-7546choice-plus-ppo
ENRENR-1130032026-08-09T03:47:39ZNICOLE—WOODS2007-07-16UHC-32255-61•••-••-29959458684626-8309 Washington StreetPlanoTX75096GRP-1934CORE-HMO
ENRENR-107022 2026-07-12T12:35:03ZHansen··MBrandon03/20/79··UHC-59196-09•••-••-0999795-948-0557NULL4589 MESA DR Apt 31·ChandlerAZnullGRP-5104CHOICE-PLUS-PPO
ENRENR-1301882026-06-30T16:31:37ZBeverlyX.Valdez10/24/1989UHC-20571-96•••-••-7566(201) 703-3754beverly.valdez@aol.com9115 Canyon RoadCharlotteNC28227-8226GRP-1962CORE-HMO
ENRENR-1198772026-10-05T08:19:44ZCarolyn—Greene··6/9/1943UHC-92702-38•••-••-3839280-701-8511carolyn.greene97@icloud.com3861 Baseline RoadSeattleWashington98112GRP-3856MEDICARE-ADV-A
ENRENR-1189582026-06-24T07:25:31ZAMANDA—OLSON07/06/1996UHC-71463-79•••-••-8007692-543-4781amanda.olson14@proton.me4130 Hillcrest RdColumbusOH43220GRP-8009OPTIONS-PPO
ENRENR-1195162026-04-04T01:21:58ZDylanR.Estrada1978-05-03··UHC-11312-21•••-••-0619+1 303 500 9201dylan.estrada@proton.me692 Forest AvenueHoustonTX77027GRP-9610OPTIONS-PPO
ENRENR-1236992026-08-11T08:53:07ZReyd, MarianaM.—1962-08-21UHC7962960•••-••-9606617-287-8659mariana.reid@aol.com8707 MAIN ST··GLENDALEAZ85384GRP-4726MEDICARE-ADV-B
ENRENR-1205792026-01-29T17:28:37ZTerry—Singh1956-05-20uhc-09840-40•••-••-50414692871terry.singh59@yahoo.com-null——GRP-5929medicare-adv-b
ENRENR-1320912026-09-18T22:02:50Z———10-10-1954UHC-35421-78•••-••-3107·959-917-9021santiago.franklin72@icloud.com8938 Union StreetGILBERTAZ85212-9446GRP-8874MEDICARE-ADV-A
ENRENR-1050672026-06-05T01:01:45ZSTEPHENQ.SCOTT08/22/43UHC-90161-54•••-••-6836·792-348-2814—8180 Hillcrest RdSeattleWashington98104GRP-5932MEDICARE-ADV-A
ENRENR-1195222026-04-30T18:39:51ZOwens, LawrenceT—·9198-01-03UHC-66059-99•••-••-0377(524) 531-1349lawrence.owens@outlook.com2445 Grand Ave·ScottsdaleAZ85205GRP-9927CORE-HMO
ENRENR-1271552026-06-24T17:28:58ZMegan··C.Graam6/18/1962··UHC-96401-51•••-••-35952938348107megan.graham47@aol.com3627 Highland AvenuePlanoTX75060GRP-0951CORE-HMO
ENRENR-1147432026-04-06T11:13:56Z·NATALIE—POWELL1985-12-22UHC-10257-01-19074525869NULL9673 Jefferson AvenueTampaFL·33687GRP-8571OPTIONS-PPO
ENR ENR-1315192026-01-27T22:26:10ZLawrence, Frank····—1992-06-14UHC-54403-51•••-••-5200(234) 412-2544FRANK.LAWRENCE18@PROTON.ME4496 River RoadTUCSONAZ85735GRP-4511CORE-HMO
ENRENR-1411822026-07-29T17:18:40ZsharonAreid1959-02-26UHC-09861-29•••-••-0449553-256-4040UNKNOWN2290 Meadow Lane·OrlandoFLUNKNOWNGRP-9718MEDICARE-ADV-B
ENRENR-111152 2026-01-07T20:54:01ZmariTwang19760407UHC-01269-47NULL8197400242··maria.wang35@yahoo.com6033 Mesa DrPhoenixAZ85004··GRP-9674CHOICE-PLUS-PPO
ENRENR-1224372026-08-20T06:25:22ZMartha—Stewart1962-03-10UHC-88680-16•••-••-71127779902724martha.stewart@yahoo.com194 MARKET STCharlotte·NC28288-4218GRP-0645CHOICE-PLUS-PPO
ENRENR-1001412026-09-30T15:07:27ZDENNISVBERRY22-03-1965UHC-82134-43•••-••-2264—DENNIS.BERRY97@AOL.COM·384 BAYSHORE DREden PrairieMN··55352GRP-4273MEDICARE-ADV-B
ENRENR-1181322026-08-07T17:46:44ZLucia—·Fox2001-05-26UHC5407115•••-••-8922+1 652 293 8424N/A7938 RIDGE RDLos AngelesCA90052GRP-2011MEDICARE-ADV-A
ENRENR-1306422026-03-02T13:10:00ZMARIENATSNYDER1982-04-19UHC-99299-91•••-••-4144(465) 223-6941mariana.snyder@proton.me3949 FOREST AVEHoustonTX77098GRP-5870MEDICARE-ADV-A
ENR ENR-1307232026-06-30T14:09:15ZVICTORIAE.CLARK··1997-12-28··UHC-04405-72•••-••-91397023078648NULL7958 Indian School RoadSCOTTSDALEAZ85247GRP-6740MEDICARE-ADV-A
ENRENR-1083972026-10-12T08:10:33ZGloriaKElliott9/6/1962UHC-53305-41•••-••-8168580.266.1350GLORIA.ELLIOTT93@AOL.COM9566 HILLCREST RDHoustontx77008GRP-3799OPTIONS-PPO
ENR ENR-1157542026-04-28T21:21:31ZMeganS.Herrera····UHC-91109-19-(708) 717-2970null4453 Indian School Rd Apt 6DENVERCO80228GRP-7446SELECT-EPO
ENRENR-1367032026-07-04T03:01:35ZRobinson, Evelyn··—1941-09-14UHC-32766-97•••-••-3422233-424-5704—8735 Market StreetDallasTX75297GRP-3594CORE-HMO
ENRENR-1189452026-05-26T06:49:45ZLawrence····Edwards20030921UHC-37501-93•••-••-5889506-909-9306lawrence.edwards63@proton.me2632 Sunset BoulevardScottsdaleAZ85225GRP-9444··MEDICARE-ADV-B
ENRENR-1078352026-02-22T06:14:21ZdorisRsanders1979-10-14UHC-68041-75•••-••-60513421009—6462 Central Ave·GLENDALEAZ··85326GRP-5677··CORE-HMO
ENRENR-1220482026-02-20T16:17:41ZChuck—Fernendez·1968-06-02UHC-67743-02•••-••-0630557.567.9794charles.fernandez95@hotmail.com3419 Lake View Rd #668MESAAZ85280GRP-5437···CHOICE-PLUS-PPO
ENRENR-1047042026-06-19T07:35:08ZMiills, MaryB—1967-01-21nullN/AUNKNOWNmary.mills78@hotmail.com2271 CENTRAL AVETampaFL33666GRP-7910··CORE-HMO
ENRENR-1030162026-02-15T19:13:11ZKenneth—Wallace28-11-1958UHC0056350·-+1 258 824 3229kenneth.wallace38@icloud.com4932 INDIAN SCHOOL ROADMIAMIFL—GRP-5772NAVIGATE-HMO
ENRENR-1181252026-08-25T22:36:35ZsandraL.·cruz1939-07-06UHC-26778-24•••-••-0535(295) 845-2158—649 Elm StSAN DIEGOCA92101GRP-2161OPTIONS-PPO
ENRENR-1304392026-01-27T00:29:54ZHeatherNChavez1955-08-17UHC-89788-22•••-••-8832326.337.5755heather.chavez48@gmail.com1163 Ocean Avenue #209NASHVILLETN37224GRP-2602MEDICARE-ADV-A
ENRENR-1089282026-09-28T00:59:23ZSandoval, RandyL····11/13/51UHC-38306-80•••-••-4024944-351-5197randy.sandoval99@proton.me5598 Canyon Road··DenverCO80235GRP-3867OPTIONS-PPO
ENRENR-1377502026-07-15T17:39:26Z JacobWGrant1969-10-22UHC-57440-22•••-••-95533084346185··jacob.grant69@gmail.com3053 Harbor BlvdTUCSONAZ85724-9888GRP-5693NAVIGATE-HMO
ENRENR-1045262026-10-06T09:57:32ZJerryTFranklin1994-09-15UHC-31529-37•••-••-83674886563226null3181 RIDGE ROAD·ColumbusOH43237GRP-0693MEDICARE-ADV-A
ENRENR-113683 2026-05-05T11:22:19ZJudy··YMatthews1986-08-25UHC-80695-58•••-••-89565897106768judy.matthews52@yahoo.com3336 Mountain View Dr Apt 10San DiegoCA92198GRP-6170MEDICARE-ADV-B
ENRENR-1099542026-06-29T05:25:38Zjoe··G·cole07-08-1985··UHC4617266NULL(498) 912-4773joe.cole@icloud.com7865 Maple Avenue Apt 35GILBERTAZ85294GRP-5338OPTIONS-PPO
ENRENR-1384692026-02-24T00:24:14Zjoseph·Nhanson1999-12-05UHC-34231-96UNKNOWN+1 941 523 3664JOSEPH.HANSON80@PROTON.ME3879 Mountain View DrAtlantaGA··30389GRP-2903··MEDICARE-ADV-B
ENRENR-1087912026-04-03T15:27:00ZBarbaraUWarren1979-06-15UHC-54834-89—4519681684barbara.warren93@icloud.com·9804 OCEAN AVENUE #833AustinTX78763GRP-4001CORE-HMO
ENRENR-1012462026-09-09T01:32:45ZElliott, Santiago····—1978-11-02·UHC-15961-44•••-••-9853UNKNOWNsantiago.elliott76@aol.com3870 Willow Ct··MesaArizona85257GRP-0455CHOICE-PLUS-PPO
ENRENR-1404792026-08-21T10:23:18ZKeith—Li2003-11-15UHC-64482-19•••-••-2748+1 240 318 1848·N/A·513 Park PlaceDenverCO80286GRP-8478OPTIONS-PPO··
ENRENR-1135922026-05-05T11:48:48Z·Angela—Moreno1984-07-14·UHC-73326-27UNKNOWN5859151angela.moreno81@hotmail.com5944 Park PlHoustonTX··77001GRP-0327OPTIONS-PPO
ENRENR-1233062026-04-12T19:47:50Z·Martinez, SophiaB.—1950-04-27UHC-22861-85•••-••-9482—SOPHIA.MARTINEZ77@PROTON.ME9261 Lake View Road #553MesaAZ85258·GRP-4219MEDICARE-ADV-B
ENRENR-1134572026-08-03T23:11:26ZLUISFWARREN1947-05-20UHC-32432-18•••-••-2295(551) 620-0311UNKNOWN6684 Elm Street··HoustonTX77071GRP-2918NAVIGATE-HMO
43,101 rows, page 70 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:36.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty