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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1037582026-09-19T05:53:24ZAndrea—Reid1974-08-23·UHC-58460-30•••-••-1473(859) 559-5392andrea.reid@icloud.com2859 Indian School Road Apt 37DenverCO80222GRP-3600SELECT-EPO
ENRENR-1109572026-08-27T21:27:37ZMichelle—Jensen2005-04-02UHC-60955-24•••-••-3961212-475-2348michelle.jensen@outlook.com311 Park PlaceNashvilleTN37217GRP-1901CHOICE-PLUS-PPO
ENRENR-1022222026-02-22T10:10:10ZBradleyIButler1982-01-16UHC-11771-50•••-••-54872023625265··BRADLEY.BUTLER@OUTLOOK.COM4624 BroadwayLAS VEGASNV89196GRP-1426MEDICARE-ADV-B
ENRENR-1035622026-02-27T13:53:36ZJudith—Ramirez91641102UHC-78656-78•••-••-0003-JUDITH.RAMIREZ@YAHOO.COM1023 Canyon RoadMesaAZ85283GRP-2962OPTIONS-PPO
CLMCLM-4015952026-02-23T16:17:26ZMelissa—Willis06/04/1939—UNKNOWN(496) 958-1419NULL8088 LINCOLN WAYCHANDLERArizona··85298GRP-7545—
CLMCLM-4015452026-02-23T13:39:33ZSAMUEL—MEJIA7/13/2003UHC-08695-80•••-••-7332null-8131 BROADWAYTucsonAZ85768GRP-8910—
ENRENR-1220882026-01-14T08:36:16ZCatherineU.Andrews19460608··UHC-95338-32•••-••-3288370-990-0809CATHERINE.ANDREWS@YAHOO.COM8340 LINCOLN WAY·ATLANTAGA30383GRP-2650NAVIGATE-HMO
ENRENR-1146302026-01-20T00:33:09ZMaryLRiley1961-03-13UHC-59201-69•••-••-55885058560537··mary.riley90@gmail.com8780 Lincoln WayGilbertAZ85238GRP-2214CHOICE-PLUS-PPO
CLMCLM-4325332026-01-17T12:04:32ZHanson, Arjun····—Jan 24, 1962UHC-47578-88•••-••-6035NULLNULL7609 Spring StreetSeattleWA98109——
ENRENR-1362372026-06-23T12:27:19ZArthur····Anderson18-05-1938UHC-15121-56•••-••-17727597974036arthur.anderson65@yahoo.com8155 RIDGE RDNashvilleTN37217-0489GRP-4117SELECT-EPO
CLMCLM-4016352026-07-24T14:24:33ZAustin··—Torres19700615UHC-05553-13•••-••-5611····N/A—-null—GRP-8389UNKNOWN
CLMCLM-4002692026-08-11T17:19:20Z ·ElijahT.WatsonApr 18, 1950UHC-72077-16—3868964396-9516 Church StreetTempeAZ85235NULLMEDICARE-ADV-B
ENRENR-1391432026-04-06T14:20:21ZSamuelLDaniels1977-11-16UHC-29400-17•••-••-048118727770271·SAMUEL.DANIELS48@OUTLOOK.COM·8484 Meadow LnTampaFL—GRP-7152SELECT-EPO··
PRVPRV-262352026-03-06T13:19:00ZJOYCE——1989-12-12—UNKNOWN(242) 247-0655joyce.johnson61@yahoo.com5954 Central AveSAN DIEGOCA92120null-
ENRENR-1204942026-06-29T15:50:58ZROGER—TAYLOR1969-05-02UHC-56496-62•••-••-4354(471) 372-4496·roger.taylor@yahoo.com586 Maple AveGilbertAZ85263··GRP-4302··MEDICARE-ADV-A
PRVPRV-207222026-08-22T13:41:02ZPriya—James1999-02-25UHC-14750-42N/A345.293.5800priya.james@aol.com9288 SPRING ST #422GilbertAZ85272-NULL
CLMCLM-4106232026-04-11T19:12:01ZCampbell, Keith——1962-05-19UHC-28637-30•••-••-4168——5441 MEADOW LANE #306·NashvilleTN37234UNKNOWNN/A
ENRENR-1093102026-07-14T19:35:24ZSARAH—BRYANT10/16/43UHC-10170-91•••-••-09357712815140sarah.bryant@icloud.com3900 Meadow LaneMesaAZ85253GRP-0680CHOICE-PLUS-PPO
ENRENR-1275382026-02-24T11:45:49Z keith···Bburke1994-12-20UHC-65252-24•••-••-0830484-661-9037keith.burke52@aol.com4190 SPRING ST·AUSTINTX··78711-2178GRP-8340MEDICARE-ADV-B
CLMCLM-4152772026-08-26T21:48:21ZCamial··—Brown1951-11-17UHC-87174-49NULL609.980.3556—N/A—--—OPTIONS-PPO
CLMCLM-4015902026-03-19T06:15:05Z·Chapman, Gloria——1945-07-20UHC0287023NULL634-315-3093—·9217 ELM STREETPHOENIXAZ—GRP-1798··MEDICARE-ADV-B
CLMCLM-4146192026-09-25T20:00:59ZETHAN—HARVEY27-03-2008UHC-94617-49··•••-••-27027688342068NULL8492 Harbor BoulevardPHOENIXAZ85098GRP-4817NULL
ENRENR-1149622026-10-02T23:56:11Z·Garza, Heather——1983-04-15UHC-85505-93•••-••-8505(627) 948-0819··heather.garza31@aol.com7382 BASELINE RDPhoenix·AZ85013GRP-9935··OPTIONS-PPO
CLMCLM-4278962026-10-11T11:52:35ZAaron—Knight07/13/83UHC-95721-09NULL·(524) 622-7655—8293 SPRING ST··NASHVILLETN37219GRP-2556MEDICARE-ADV-A
CLMCLM-4114112026-09-19T04:34:09Zkelly—wheeler1975-11-17N/A•••-••-28279579872902—4067 Washington StreetOrlandoFL32855GRP-5531null
TPATPA-516712026-02-07T06:31:47ZANNA—ARMSTRONG2002-07-05··—N/A4383975442NULLnullN/A——-null
TPATPA-590072026-02-24T18:30:32Zterry—ford1994-10-01····——··9719 Market St #759DallasTX75286nullNULL
TPATPA-533392026-01-15T09:41:28ZEdward—Jones1980-01-23-•••-••-6213-NULL2430 Canyon RoadGILBERTAZ85235-6763··NULL—
TPATPA-506342026-02-17T21:15:41ZCastro—Albert1982-05-10null•••-••-6153-ALBERT.CASTRO20@ICLOUD.COM··3576 Desert Sky BoulevardSacramentoCA—·UNKNOWN—
CLMCLM-4291772026-06-27T03:21:37Zkathleen—le·6/8/1987UHC-95340-31null(912) 458-4030-··8323 Bayshore DrTUCSON··AZ85782UNKNOWNUNKNOWN
TPATPA-627072026-10-18T22:38:28ZBobby—Ward10/1/1955null•••-••-0989·N/ANULL5410 Ocean AveNashvilleTN37255-5036GRP-3136null
ENRENR-1114312026-07-07T11:18:09Z·MARIANA··RUSSELL4/8/1975UHC-35952-60•••-••-68967172387587—9455 Ridge RdNashvilleTennessee··37277-6793GRP-6519OPTIONS-PPO
CLMCLM-4017152026-01-05T00:53:36ZAndrea—Holmes1965-05-05-———1113 River RdATLANTAGA30336GRP-9452·UNKNOWN
CLMCLM-4057942026-01-05T22:38:54Znathan—moore2000-08-01—•••-••-5828UNKNOWNN/A2651 CENTRAL AVENUEEden PrairieMNnullGRP-6645MEDICARE-ADV-A
ENRENR-1275732026-02-07T15:38:31ZDaivd—·Powell27-04-2004UHC-50609-62•••-••-64289259741002DAVID.POWELL62@AOL.COM1225 Canyon RoadAustinTX—GRP-2688MEDICARE-ADV-A
ENRENR-1175242026-01-11T03:35:43Zjeremy—romeroNov 14, 1954UHC-73018-04··•••-••-2072346-787-1225jeremy.romero@icloud.com4322 BAYSHORE DRIVESacramentoCalifornia95834GRP-6699CORE-HMO
ENR ENR-1425712026-07-06T09:28:07ZRONALD··H.HARRISON04/25/1984UHC-20068-10•••-••-8533UNKNOWNRONALD.HARRISON@HOTMAIL.COM8832 Mountain View DriveSan DiegoCA92193GRP-5992SELECT-EPO
TPATPA-599972026-07-12T01:19:34ZAndrea—Gomez10/27/87N/Anull734-586-9631ANDREA.GOMEZ72@AOL.COM9419 SUNSET BLVDTucsonAZ85762UNKNOWNMEDICARE-ADV-B
TPATPA-554762026-09-26T02:43:42ZMcDonald, Maria——20080624····null788-894-1751NULL8439 ELM STREETHoustonTX77044——
CLMCLM-4078642026-07-14T19:21:03ZANN—WILSON·1979-12-03UHC-99469-90•••-••-5748+1 725 566 6084-1701 Main StMiamiFL33144·GRP-7310CORE-HMO
ENRENR-1030472026-04-22T06:33:58ZralphJarmstronng1951-09-05UHC-84017-34•••-••-9429—RALPH.ARMSTRONG87@OUTLOOK.COM7925 BroadwayTampa·FL33612GRP-1809NAVIGATE-HMO
CLMCLM-4297862026-05-02T01:33:28ZHEATHER—RAMIREZ02/13/84——17002360098HEATHER.RAMIREZ65@HOTMAIL.COMN/A··N/A—NULL-NULL
TPATPA-575362026-06-02T09:32:38ZArjun—Ramos1999-09-18····•••-••-3824—null5493 APACHE BLVDDallasTexas75280UNKNOWNCHOICE-PLUS-PPO
CLMCLM-411122 2026-10-04T20:56:31ZArthur—Franklin05-08-1949UHC-82571-88·NULL633-715-3916-—N/A—-GRP-8392NAVIGATE-HMO
CLMCLM-4000232026-02-21T01:45:15ZDonaldR··Cole20020628UHC9032535··—null—NULL——N/AGRP-8912··NULL
ENRENR-1015472026-08-28T17:25:57Zlarry—nguyen20-11-1981UHC-47290-57•••-••-7097275-641-9448larry.nguyen@gmail.com7694 Jefferson AveOrlandoFL·32879GRP-4465MEDICARE-ADV-A
ENRENR-106905 2026-03-06T06:03:49ZKyle—Holmes2002-09-24—•••-••-5050369-868-5071kyle.holmes@yahoo.com8531 LAKE VIEW ROADLas VegasNV89171GRP-3893MEDICARE-ADV-A
ENRENR-1191832026-03-19T14:13:08ZChristianHBrown·19860921UHC-14944-66•••-••-24014298330214christian.brown79@outlook.com9487 Elm StPlanoTXnullGRP-2448MEDICARE-ADV-B
ENR ENR-1250042026-04-12T07:35:20ZVega····Christopher1941-07-27··UHC-23440-74N/AUNKNOWNchristopher.vega99@outlook.com··5400 Ocean AvenueColumbusOhio43205GRP-6451OPTIONS-PPO
TPATPA-534662026-04-13T21:26:54ZLARRY—WALKER0524-19-93-•••-••-1938·UNKNOWN—7933 INDIAN SCHOOL ROADScottsdaleAZ85201GRP-3308—
100,000 rows, page 37 of 2,000PreviousNext

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:34.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty