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-122107 2026-09-25T17:59:24ZKate—Walsh1950-09-28UHC9190169NULL17788921266UNKNOWN356 RIVER ROADCharlottenc28254-6139GRP-9929medicare-adv-a
ENRENR-1263442026-03-07T09:15:46ZFrankT.GarrettFeb 8, 1996UHC-93563-45•••-••-7720-··frank.garrett@yahoo.com4817 Mountain View DriveDENVERCO80205GRP-0173SELECT-EPO
ENRENR-1136062026-01-06T00:01:59ZJAKEBCOLLINS07/06/1952UHC-09689-71··•••-••-9105·(726) 217-7422N/A2742 Oak StGilbert···AZ85230GRP-2157CHOICE-PLUS-PPO
ENRENR-1339412026-02-20T15:18:10Zkathryn··—simpson1970-04-22··UHC-23393-52NULL··686-652-7704UNKNOWN4921 BROADWAYEden PrairieMN55389GRP-5556OPTIONS-PPO··
ENRENR-1263862026-01-23T08:46:28ZGARYFMOORE19430808UHC-85363-02•••-••-5896667-962-8092GARY.MOORE72@GMAIL.COM6656 Church St #911San DiegoCA92197GRP-5644CHOICE-PLUS-PPO
ENRENR-1315622026-04-14T21:54:10ZArthur—Johnston1943-01-08UHC-65349-89··•••-••-73532209055667UNKNOWN9472 Cedar LnPlanoTX75067GRP-9824CHOICE-PLUS-PPO
ENRENR-1288162026-05-21T11:29:49ZGloriaRMurphy1993-02-22UHC-39582-92UNKNOWN(541) 497-3767gloria.murphy97@proton.me1268 Indian School RdFRESNOCA93776GRP-4344MEDICARE-ADV-B
ENRENR-1323532026-09-08T22:07:28Zdenise—woods12/11/1954UHC-11661-57•••-••-5288(243) 809-9201denise.woods78@gmail.com7491 Hillcrest RoadColumbusOH43248GRP-9885MEDICARE-ADV-B
ENRENR-1292772026-08-18T06:58:02Z SAMANTHA F.····PETERS1997-12-01UHC-59150-84-630-339-6349samantha.peters@hotmail.com··4730 MOUNTAIN VIEW DRMIAMIFlorida33142GRP-7288CORE-HMO
ENRENR-1279632026-01-14T22:19:47ZSpencer, MariaE—1977-03-27UHC-16004-64•••-••-8629+1 725 450 9368-973 Sage CtEden Prairiemn55349-1613GRP-4460OPTIONS-PPO
ENRENR-1222102026-06-18T21:06:49ZCHRISTINAPJOHNSTON·1963-07-26UHC-64381-56•••-••-9749(652) 243-0840christina.johnston43@proton.me1967 Central AvenueJacksonvilleFlorida32245GRP-6350CORE-HMO
ENRENR-1344302026-05-15T01:04:29ZOLIVIA G··—JOHNSON1971-01-09UHC-35132-04null7387829918olivia.johnson@icloud.com8638 WASHINGTON STREETSeattleWashington98181GRP-4482OPTIONS-PPO
ENRENR-1378892026-04-21T11:55:20Z·ChristopherEPatel1961-12-24·UHC-30214-42•••-••-1516393-252-5563CHRISTOPHER.PATEL@OUTLOOK.COM··6723 Elm StGlendaleAZ85383GRP-3914MEDICARE-ADV-B
ENRENR-128084 2026-03-09T01:20:07ZTIIMOTHY—HICKS1998-07-05UHC-30717-34•••-••-5749612-525-9951·null2891 Mountain View DriveGILBERT··AZ85247GRP-6452MEDICARE-ADV-A
ENRENR-1353512026-09-11T13:09:14ZRUTH—·LITTLE1959-01-03UHC-82691-02•••-••-95877763988605ruth.little@outlook.com9184 Pine Drive··MiamiFlorida33137GRP-8780CHOICE-PLUS-PPO
ENRENR-1197232026-07-10T03:28:25ZLORICELLIOTT1987-11-02·UHC-96876-11•••-••-7759426.413.0044·NULL6009 Jefferson AvenueDenverCO80248GRP-7199NAVIGATE-HMO
ENRENR-1197702026-05-07T00:50:32ZJudithUOwens—UHC-67070-87N/A210-590-6088judith.owens@outlook.com··——-GRP-6669OPTIONS-PPO
ENRENR-1100672026-07-16T02:09:53Z Little, JeanP—1955-10-07··—•••-••-3443(454) 717-1982-387 Market StreetTempeAZ85267GRP-4083··options-ppo
ENRENR-1351022026-08-14T06:55:37ZMendoza, RebeccaD—20060310UHC-41468-60•••-••-198018696390034REBECCA.MENDOZA@PROTON.ME9585 Baseline RdHoustonTexas—GRP-7174medicare-adv-b
ENRENR-1054582026-10-17T02:09:33ZSOFIAWCARR2004-07-11—•••-••-35776935724805·sofia.carr@proton.meNULL——N/AGRP-0721medicare-adv-a
ENRENR-1065552026-10-11T11:17:21ZMary··IBell1993-01-26UHC-19629-15•••-••-3434(987) 671-8608—9157 Apache BoulevardJacksonvilleFL—GRP-3254CORE-HMO
ENR ENR-1084622026-04-02T19:25:55Z—D—3/4/1950UHC-22102-23•••-••-5300—CATHERINE.ROSE@HOTMAIL.COM8121 CAMELBACK ROADJACKSONVILLEFL·32223GRP-4728navigate-hmo
ENRENR-1067702026-05-05T08:32:09ZGREGORY—HUNT1978-09-14UHC-84710-60•••-••-2832944-737-4573gregory.hunt39@aol.com·6266 Ocean AvenueSeattleWA98128GRP-5370MEDICARE-ADV-A
ENRENR-1059852026-02-02T23:15:19ZKevinA.George1986-09-20UNKNOWN—5388318··null7030 Palm DrChandler·AZ85288GRP-0197SELECT-EPO
ENRENR-142464 2026-06-18T22:36:51ZAmyMPowell1996-10-25NULL-··(777) 538-8336amy.powell81@yahoo.com4435 Apache Boulevard·HoustonTXN/AGRP-7629CORE-HMO
ENRENR-1348472026-02-22T20:48:07ZARJUNTWRIGHT1982-09-07UHC-27547-79—8177112189arjun.wright47@gmail.com8140 Washington StCharlotteNC28227GRP-1344CORE-HMO
ENRENR-1264112026-08-13T19:02:46ZSamuel—Alvarez·1939-10-18UHC-86926-43NULL567-541-1557samuel.alvarez@hotmail.com··7856 Highland AvenueColumbusOH43282GRP-2511MEDICARE-ADV-A
ENRENR-1163272026-01-22T05:22:13ZAustin—Robertson11/08/68UHC2108814—+1 640 795 5327null169 Valley View Drive·GILBERTAZ85284GRP-8811CHOICE-PLUS-PPO
ENRENR-1353442026-07-15T15:52:21ZGERALDVDAN1964-08-14UHC-07212-83•••-••-07242215409780GERALD.DEAN8@PROTON.ME6063 Ridge RdSan DiegoCA92196GRP-0689NAVIGATE-HMO
ENRENR-113771 2026-08-19T12:38:27ZKayla—Mers7/20/1975UHC-77983-67•••-••-0033346-467-3472kayla.myers@aol.com7767 Bayshore DrCharlotteNC28215GRP-3291NAVIGATE-HMO··
ENRENR-1246142026-02-06T09:59:58ZmarthaRbennett1948-03-18UHC-81390-49UNKNOWN·8059561170MARTHA.BENNETT@PROTON.ME9730 Highland Avenue·FresnoCA93784GRP-6956MEDICARE-ADV-B
ENRENR-1320002026-05-07T18:29:49ZBRYAN R.—ROMERO02/04/93UHC-78069-86•••-••-3993934-522-5271·BRYAN.ROMERO92@ICLOUD.COM·6621 Baseline Road Apt 25GilbertAZ·85256GRP-6245SELECT-EPO
ENRENR-1223102026-08-22T12:22:41Zdouglas—walker04-01-1964UHC-16172-18•••-••-1639(520) 209-2154-8186 Pine DriveTampaFL33681GRP-6288NAVIGATE-HMO
ENRENR-1001542026-08-17T06:31:48ZFATIMAP.STONE1988-08-09UHC-34812-21•••-••-5558315-814-9513fatima.stone@gmail.com7374 WASHINGTON STREETCharlotte·NC28297··GRP-2227CORE-HMO
ENRENR-1225922026-03-04T03:36:04ZRANDY··LAMSTRONG1959-01-07UHC-55703-24•••-••-6079—NULL5427 Harbor BlvdSan Antonio··TX78227GRP-2536·NAVIGATE-HMO
ENRENR-1229732026-05-07T10:28:49ZTim—FieldsMay 7, 1975—null8782679347timothy.fields@outlook.com6514 Bayshore DriveTampaFL33698GRP-1338CHOICE-PLUS-PPO
ENRENR-1325082026-03-17T20:16:49ZMason—Price09/26/1971UHC-45042-06•••-••-5884(712) 470-1790mason.price@proton.me2697 Hillcrest RdCharlotteNC28231GRP-5357CHOICE-PLUS-PPO
ENRENR-1028722026-06-19T07:30:06ZStephens, Cheryl——09/11/1971uhc-86703-51•••-••-103213308803275cheryl.stephens@gmail.com7369 RIDGE RDDallasTexas75256-4361GRP-5560CHOICE-PLUS-PPO
ENRENR-1256202026-08-17T16:58:45ZALICE—DELGADO1984-09-11UHC-45437-56•••-••-2859625-421-0445—6296 Washington Street Apt 18·MinneapolisMN55489-3996GRP-3890CORE-HMO
ENRENR-1276872026-01-31T12:48:00ZMLISSA—ANDREWS1963-00-44UHC-49025-89•••-••-6402(854) 545-2138melissa.andrews@yahoo.com516 SUNSET BOULEVARDDenverCO80248GRP-2460MEDICARE-ADV-B
ENRENR-1385262026-04-21T23:31:16ZCHRISTIANQ.LANE16-09-1977UHC8087708•••-••-8137(374) 201-1782christian.lane@proton.me4761 Ocean AvenueScottsdaleAZ85270GRP-5399MEDICARE-ADV-B
ENR ENR-137705 2026-05-17T18:11:36ZGregVLuna1966-07-21UHC-06652-38•••-••-16522491982gregory.luna@icloud.com1761 CANYON ROADPhoenixAZ85020-9926GRP-8036OPTIONS-PPO
ENRENR-1112562026-01-16T17:17:53Z·Lisa—Rose1979-12-07UHC-08980-34UNKNOWN14196439762lisa.rose78@icloud.com4673 Church StColumbusOH43243GRP-1181CHOICE-PLUS-PPO
ENRENR-1401242026-05-09T20:18:35ZValentina—Johnston1981-12-19uhc-79512-66•••-••-82174665431792—8285 Apache BlvdDALLASTX75245GRP-6440MEDICARE-ADV-A
ENRENR-1400612026-05-20T17:40:16ZStephanieEBailey··1989-06-25UHC-57013-20•••-••-1769nullstephanie.bailey@outlook.com366 Market StreetTucsonAZ85701GRP-2613CORE-HMO··
ENRENR-1084722026-04-04T05:52:21ZRay, Laura——·Aug 8, 1945UHC-44783-15•••-••-533118794298326NULL··6445 LAKE VIEW RDDenverCO80222GRP-1084NAVIGATE-HMO··
ENRENR-1058842026-10-04T05:22:25ZSandra—Porter1942-10-01UHC-18433-35—2972310843sandra.porter@outlook.com2639 Church StLos AngelesCA··90016GRP-2611MEDICARE-ADV-A
ENRENR-1292482026-01-09T15:27:43ZCAMILA—COX1938-02-19—•••-••-04763228283937null2807 Grand AveLas VegasNV89111GRP-8044SELECT-EPO··
ENRENR-1235302026-01-13T14:10:33ZryanUwright·1953-03-20UHC-72160-97—7902801373NULL2436 Maple AvenueSan DiegoCA92120GRP-6501CHOICE-PLUS-PPO
ENRENR-1137242026-07-12T12:35:58ZnathanS.sanchez··11/13/1949UHC-34921-74null(979) 624-3503NATHAN.SANCHEZ@PROTON.ME4029 Pine Dr Apt 11HoustonTexas77093-0107GRP-7865MEDICARE-ADV-A
43,101 rows, page 317 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.611Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty