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
CLMCLM-4204962026-03-20T18:05:41ZALBERT—SANDERS02/17/86UHC-40942-62•••-••-1525—N/A3148 Lincoln WayColumbusOH43258-null
CLMCLM-4051862026-04-07T20:06:20ZYUKIHHUNT1957-05-23——731-671-7973NULL··1761 Baseline RdTucsonAZ85774·NULLN/A
TPA TPA-63016 2026-01-21T22:31:01ZJACK··SMITH1974-06-11··—-8054337199UNKNOWN-—UNKNOWNUNKNOWNGRP-2568null
CLMCLM-4013902026-01-14T22:18:10ZSCOTT—EVANS19390808UHC-99603-38•••-••-91677517417209UNKNOWNNULLUNKNOWNNULL—-—
CLMCLM-4274682026-09-13T12:36:01ZPriya—Bowman19850627UHC-20261-11··-—NULL8188 Willow CourtNASHVILLETN37260GRP-9749N/A
ENR ENR-1385772026-03-19T21:48:40ZERIC—HARPER2002-10-26UHC-18855-16····729-390-8233—8687 Ocean AvenueSan DiegoCA92145GRP-0781··OPTIONS-PPO
CLMCLM-4136602026-07-26T00:34:40ZDannyL··Sanchez2004-03-03NULLN/A·nullNULL6681 Lake View RoadAustin·TX78782—UNKNOWN
ENRENR-1079092026-07-10T21:39:51ZHawkins, George——·1952-08-07UHC4520779•••-••-2512781.262.4340george.hawkins@hotmail.com6268 Ridge RdChandler·AZ85274GRP-2637CHOICE-PLUS-PPO
ENR ENR-1268462026-05-17T11:26:35ZPamela—Vsaquez1965-10-16UHC-67139-15•••-••-985218414621454N/A7641 PALM DRHoustonTX77027GRP-6291·CHOICE-PLUS-PPO
PRVPRV-228972026-09-12T15:28:32ZMARCUS—BRYANT1970-06-24UHC-24560-06··3754172797NULL··7423 Spring St #682··FresnoCA93766-—
CLMCLM-429227 2026-10-12T13:32:48ZPAMELA··—RUSSELL8/22/1939UHC-06760-29•••-••-0501——9042 Sunset BlvdChandlerAZ85291GRP-2085-
CLMCLM-4307902026-10-06T20:08:11ZCamila—Russell11/10/08UNKNOWN—(941) 774-3586null4980 Valley View Dr·MesaAZ·85240-0921GRP-5697—
CLMCLM-4196552026-07-23T09:15:42ZSaamuel—Fields1973-02-01nullnull690-822-9153UNKNOWN2094 Desert Sky BoulevardFRESNOCA··93725GRP-0117NULL
PRV PRV-204342026-05-31T22:56:28ZBryan—Cruz·1941-08-23N/A•••-••-2816541.283.3470UNKNOWN2664 Park Place Apt 16Eden Prairie··MN55330null·NAVIGATE-HMO
ENRENR-1168382026-09-16T00:45:44ZLisa—Hayes·1985-07-09UHC-46841-84•••-••-8277459-444-9792lisa.hayes60@icloud.com33 Grand AvenueGilbertAZN/AGRP-7998MEDICARE-ADV-B
CLMCLM-4131452026-09-13T05:32:44ZMichael—Chapman9/1/1960UHC7896031--······3528 Bayshore DriveTampaFL33698GRP-2570MEDICARE-ADV-B
CLMCLM-4099242026-05-22T18:12:27ZRussell····Marquez1962-03-11UHC-20668-29-——2146 Mesa DrScottsdale··AZ85285-9079GRP-6898MEDICARE-ADV-A
TPATPA-600542026-01-26T15:20:15ZDorothyC.·Price2007-01-05null•••-••-2914N/A—1418 SUNSET BOULEVARDSan DiegoCalifornia92153-8953—UNKNOWN
CLMCLM-4197642026-06-28T22:21:35ZOlivia—Fulleer2000-11-15UHC-49543-71··•••-••-2808(593) 726-4366—3435 Ridge RdPlanoTX75079GRP-4942-
TPATPA-515362026-07-02T20:47:24Zjakc—gibson09/24/1939UHC-51781-73UNKNOWNNULLnull·8712 Apache BlvdScottsdaleAZ85235GRP-6325UNKNOWN
ENRENR-110508 2026-01-12T22:09:55ZBobby—Lawson1953-01-27UHC-74523-98··UNKNOWN437-255-9452BOBBY.LAWSON@YAHOO.COM3931 Pine DrEden PrairieMinnesota55303·GRP-5007CHOICE-PLUS-PPO
CLMCLM-4185852026-06-25T23:22:05ZChristian—Chavez1996-01-20UHC-18389-73NULL503-792-0366—7834 Oak Street #917SeattleWashington98113GRP-1911OPTIONS-PPO
CLMCLM-4090652026-09-07T07:47:30ZkennethXcarroll1972-07-18··—(277) 667-4397—5265 Maple AvenueDallas·Texas75298GRP-8390—
TPATPA-618782026-08-11T10:59:11Z·ALEX—ESTRADA2004-12-02-—-null2506 Indian School RdHoustonTX77036UNKNOWNMEDICARE-ADV-A
ENRENR-1032912026-01-26T18:34:26ZPATRICK—TRAN1957-08-01UHC-41533-04•••-••-576112934753347patrick.tran54@aol.com1003 Willow CourtGLENDALEAZ85395GRP-6431CHOICE-PLUS-PPO
CLMCLM-4308602026-01-17T03:04:56ZBenjamin·K.Vasquez4/10/2006UHC-82637-55N/A(304) 209-5884NULL·5631 Mountain View Dr Apt 34OrlandoFL32879N/A—
ENRENR-1362432026-02-26T05:07:46ZZACHARY—FULLER1969-07-13UHC-64893-75•••-••-5284391-989-1906·zachary.fuller53@proton.me3951 Market StreetEden Prairie··MN55323GRP-8337OPTIONS-PPO
ENRENR-1019752026-10-02T20:01:17ZAmyRHawkins1994-05-13UHC-63576-09•••-••-13918703173142··amy.hawkins@yahoo.com6772 Hillcrest Road Apt 11CharlotteNC··28267-3088·GRP-4622OPTIONS-PPO
PRVPRV-214002026-08-21T11:31:12ZHeather—Myers1958-01-04UHC-23811-98NULL14379955558N/A5967 Ridge Road #439PhoenixAZ85039nullN/A
ENRENR-1340892026-08-13T08:29:12ZwillieHbradley19800614UHC-89089-22•••-••-67412973561219willie.bradley@outlook.com4401 Forest AvenueScottsdaleaz··85201GRP-3709MEDICARE-ADV-A
ENRENR-1145482026-09-12T08:38:44ZSANDRAY.LUNA19640312UHC-78857-62NULL··3123348sandra.luna79@hotmail.com9505 OAK STREETEden PrairieMN55386GRP-3298OPTIONS-PPO
TPATPA-519592026-09-14T20:06:27ZJonathan—·Cunningham15-01-1988NULL•••-••-8456null-8972 Union StreetMinneapolisMN··55470—null
ENRENR-1305262026-05-14T18:53:19ZStepphenWFernandez8/17/1944UHC-00238-90•••-••-3420948-345-4267stephen.fernandez17@proton.me5103 Lake View RdPhoenixAZ85072GRP-9693MEDICARE-ADV-B
ENRENR-136217 2026-04-21T03:32:35ZShirley—Mason·1965-12-11UHC-48536-78•••-••-2686(952) 705-9176shirley.mason4@hotmail.com2929 Harbor Boulevard··GlendaleAZ85323GRP-5535MEDICARE-ADV-A
ENRENR-1298072026-06-21T15:08:37ZJOAN—CUNNINGHAM2006-11-14UHC-78634-64•••-••-0922·3887130492joan.cunningham14@proton.me4473 UNION ST #203TAMPAfl33627GRP-2375select-epo
CLMCLM-419702 2026-02-16T04:57:03ZJesseVPenaJul 12, 1982uhc-77062-43NULLnullN/A9522 OAK STREETLAS VEGASNV89171·NULLSELECT-EPO
CLMCLM-4063152026-07-21T17:03:02ZSantiago—Olivar2001-09-27··—-752-363-3157—2408 CHURCH STREETOrlandoFL32861null··UNKNOWN··
CLMCLM-4207042026-06-08T22:34:18ZJuan—Hunter02/24/2000—•••-••-6515N/A—7276 Lake View Rd·MesaAZ85266GRP-0963-
TPATPA-643012026-07-26T18:36:28ZJass—Butler··1961-06-06nullNULL——1637 SAGE COURTPLANO··Texas75050GRP-0838-
TPATPA-633022026-02-09T08:21:50ZAdam—VegaDec 27, 1974·N/A•••-••-7820(537) 246-7498—3130 Cedar LaneSAN DIEGOCA92181-4218NULLN/A··
CLMCLM-4037402026-01-07T13:03:55ZCunningham, Gerald····—06/15/83——539-215-4718—7237 CAMELBACK RD Apt 4NASHVILLETN37295UNKNOWNUNKNOWN
PRVPRV-220812026-09-21T17:31:44Zcharlotte···coleman5/5/1994··—•••-••-5676703-576-1622CHARLOTTE.COLEMAN@AOL.COM4598 BASELINE ROADNashvilleTN37221UNKNOWNSELECT-EPO
TPATPA-61078 2026-04-30T01:48:11Zmadison—black19950309N/AUNKNOWN5917094—5866 Sunset BlvdTucsonAZ85747—null
CLMCLM-4248922026-05-19T00:44:00ZCheryl—Thomas2004-07-05UHC-65987-55•••-••-8344345.854.2994··-8717 RIDGE RDHoustonTX77047GRP-3490MEDICARE-ADV-B
ENRENR-1217222026-01-18T09:18:17ZVirginia—Watkins19480601UHC-85208-07•••-••-6920975-471-4819virginia.watkins@outlook.com1208 FOREST AVEScottsdale··AZ85294GRP-2499MEDICARE-ADV-B
TPATPA-614542026-03-31T02:20:59ZJULIE—MOORE2003-01-20UHC-75274-21•••-••-0174·206.724.1656julie.moore@proton.meNULL··—····-nullNULL
ENRENR-1020632026-03-31T13:08:10Zarjun—·brown12/18/98UHC-10496-36•••-••-90085637054767arjun.brown44@proton.me1914 UNION STREETPlanoTX75036GRP-4458MEDICARE-ADV-B
CLMCLM-4186272026-02-20T04:19:06ZJohnT.Ramos··1994-07-07—null2086278814··null——UNKNOWNGRP-4294NAVIGATE-HMO
ENRENR-1136462026-03-07T05:01:15ZDixon, AlbertE—1101-79-51··UHC-57246-87N/A+1 204 381 5694ALBERT.DIXON@ICLOUD.COM5441 MARKET STMesaAZ85233GRP-8675SELECT-EPO
ENRENR-1318602026-05-22T01:46:46ZALBERTGHAWKINS06/17/93UHC-46163-75—644-567-9790albert.hawkins@aol.com1744 Highland AveLos AngelesCA90071GRP-3099·options-ppo
100,000 rows, page 252 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:37.751Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty