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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4134832026-03-05T03:07:37ZJOSHUA—WRIGHT03/19/1965··UHC-71174-31N/A3802215070N/A7265 Desert Sky BoulevardChandlerAZ85273GRP-4976····
CLMCLM-4306292026-08-30T15:24:04Zbarbara—stevens1977-08-17-null12502990466N/A720 Main St Apt 37LAS VEGASNV89150UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4265852026-03-23T18:09:31ZStephen—Alvarado04/08/1990UHC-69270-12··null7345033997—580 GRAND AVENUESCOTTSDALEAZ85217GRP-1715OPTIONS-PPO
CLMCLM-4046892026-02-24T04:20:38ZAshley—BowmanJun 17, 1978UNKNOWN-·UNKNOWNnull6982 MOUNTAIN VIEW DRGlendaleAZ85371GRP-9699··NAVIGATE-HMO
CLMCLM-4182122026-08-08T11:27:40Z Steven—Taylor2003-03-25UHC-20151-78•••-••-1364UNKNOWNNULL9165 PALM DRIVEGilbertAZ85258-—
CLMCLM-4217072026-01-31T10:03:44ZLAURENDMONTGOMERY1963-12-10UHC-09615-90•••-••-10027428355449—2528 DESERT SKY BLVD·MinneapolisMN55495GRP-6170NAVIGATE-HMO
CLMCLM-4132802026-03-28T09:26:55ZGabriel—Garcia1949-10-24UHC9514559null381-706-8853NULL6830 Jefferson AvenueGlendaleAZ85388GRP-1901null
CLMCLM-4155722026-03-14T05:02:44ZDennis—Dominguez19661228UHC-79255-89NULLnulldennis.dominguez@gmail.com·7029 UNION STSan DiegoCalifornia92171-0373··GRP-5305—
CLMCLM-4327322026-07-03T13:29:58ZRoy····Hansen04/13/1960UHC-87408-63NULLNULL—-NULL····NULLN/A—
CLMCLM-4159932026-08-16T22:04:41ZJoseph—Cole1986-04-16··UHC-31831-74•••-••-1832(203) 326-4395joseph.cole@outlook.com427 Pine DrSan Antonio··Texas78238UNKNOWN····
CLMCLM-4311542026-07-26T10:23:52ZPATRICKCRIOS01/19/1957··•••-••-27069317699026—·2799 WASHINGTON STREETPlanoTX—GRP-7691MEDICARE-ADV-A
CLMCLM-4302482026-08-21T08:26:41ZMatthews, Russell—··2002-06-26N/A•••-••-2087-—288 Desert Sky BlvdSan AntonioTX78282GRP-4464MEDICARE-ADV-A
CLMCLM-4172882026-08-02T14:58:50Z·Michelle—Walker20030805UHC-17580-14•••-••-49873015838848—7539 BAYSHORE DRIVEJacksonvilleFL32259——
CLMCLM-4214602026-07-09T19:45:13ZSamantha—Ray9/3/1990——-samantha.ray45@outlook.com-UNKNOWN—-GRP-7976null
CLMCLM-401303 2026-02-19T12:41:19ZSantiago—Howell1972-04-14UHC-67277-92NULL-—·8827 Grand AveAustin··TX78775GRP-9763CORE-HMO
CLMCLM-4325552026-04-12T08:07:36ZSANDRA—SCOTT1974-11-01UHC-00116-94UNKNOWN··411-580-8782sandra.scott@gmail.comNULLnull—-GRP-3178··
CLMCLM-4191262026-07-22T09:17:00ZJason—Garett1947-05-05UHC-10837-58-851.995.4500—3428 Highland AvenueAUSTINTX78767···GRP-6116—
CLMCLM-4305452026-06-02T12:29:58ZJimWRodriguez11/2/1966UHC-72572-86—nullUNKNOWN··7312 Harbor BoulevardTUCSONAZ85739·GRP-9973null
CLMCLM-4326132026-04-05T01:23:18ZSamantha—Martiin1812-18-96NULL•••-••-79908277122983—9290 Canyon Road Apt 28San AntonioTX78217GRP-4570NAVIGATE-HMO
CLMCLM-4052862026-08-19T18:29:43ZAna—White04/08/1980uhc-34268-88—473-705-3266NULL7235 Lake View RoadNASHVILLETN37290UNKNOWN·CORE-HMO
CLMCLM-4281382026-08-25T19:59:29ZKEITH—·GRAY18-11-1963UHC-41667-97•••-••-6454—UNKNOWN5446 Union St··PhoenixAZ···85020GRP-6702MEDICARE-ADV-B
CLMCLM-4104642026-07-02T12:49:29ZLUISFSMITH19401124UHC0987893•••-••-490216982923154luis.smith@gmail.com·4992 Park PlLos AngelesCA90054-—
CLMCLM-4110782026-03-03T03:23:54ZGloria·BFrod1953-03-27··UHC-93806-40null(283) 794-8216———NULL—GRP-2090MEDICARE-ADV-B
CLMCLM-4327212026-05-23T00:24:13ZAdam····Delgado9/5/1971UHC-51736-88•••-••-0225UNKNOWN—UNKNOWN—N/AN/A·N/A—
CLMCLM-4058132026-04-18T09:13:39ZJordanAMunoz19600281UHC-64719-86NULL(642) 477-7794-NULLUNKNOWNN/A—GRP-1642NAVIGATE-HMO
CLM CLM-4321822026-01-10T04:09:48ZMadison—Allen1995-10-23UHC4139561•••-••-3610UNKNOWN-8889 Ocean AveSacramentoCA95893-1578GRP-8114CORE-HMO
CLMCLM-4306332026-04-20T04:09:27ZAlexis—·Morrison1949-03-08UHC-65543-73•••-••-2671+1 317 579 5445null—NULLnull-—UNKNOWN
CLMCLM-4039862026-09-26T21:08:07Zjennifer—schmidt1/28/1952·null•••-••-4468535.709.1043UNKNOWNNULL-nullnullN/A··NULL
CLMCLM-4035542026-02-25T23:39:33ZMarilyn—Elliott2008-05-15UHC-08946-09··•••-••-0178(212) 878-3719—1704 Union StAtlantaGA30342—UNKNOWN
CLMCLM-4291822026-10-17T06:13:40ZRichardson, Megan—··19590513N/A•••-••-0447940.913.8587·-2569 Indian School RoadOrlandoFL32855··nullN/A
CLMCLM-4028782026-01-22T20:20:36Z·Amenda—·Auustin1998-09-20UHC-48897-92•••-••-4876NULLNULL—NULL—UNKNOWNGRP-1054—
CLMCLM-422322 2026-02-17T13:30:41ZHeather··—Cox9/25/1957UHC-48098-19N/A(634) 818-2128-613 RIDGE ROADLos Angeles·California90008-3842GRP-2435MEDICARE-ADV-A
CLMCLM-4004362026-03-20T02:03:12Zemma··cox1996-05-09UHC-99349-98•••-••-7586-—4137 CANYON ROADJacksonvilleFlorida32211·GRP-4191medicare-adv-b
CLMCLM-4185292026-02-14T12:16:23ZSusan—Wang2008-01-18——null—UNKNOWNN/AUNKNOWNN/AUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4303802026-05-28T14:12:51ZKYLE—RAY1993-80-17NULLN/A-NULL1541 BROADWAYSeattleWA98121GRP-5662NULL
CLMCLM-4147702026-08-12T11:51:05ZSusan—Armstrong1992-10-11—null··3367842425—-—-—·GRP-2815CHOICE-PLUS-PPO
CLMCLM-404973 2026-08-09T18:02:11ZAARON—MENDEZ2006-05-23·N/A-13994284583—4835 Main Street·ORLANDOFL32867GRP-9626MEDICARE-ADV-B
CLMCLM-4022412026-03-13T03:16:39ZJESSE—STEWART07/23/87··UHC-43749-60nullNULLN/A6125 Oak StreetGilbertAZ85258GRP-7542MEDICARE-ADV-A
CLMCLM-414187 2026-03-10T02:11:14ZBennett, Sarah——1976-11-09--UNKNOWN—9583 MARKET STSan Antonio·TX78239GRP-4250MEDICARE-ADV-B
CLMCLM-4134592026-04-04T10:06:29ZJason—JohnstonJul 21, 1987UNKNOWN—·5655802NULL5392 Highland Avenue Apt 30San DiegoCA92102GRP-0375null
CLMCLM-4139432026-08-16T05:29:07Zwilliam—tran12-06-1974UHC-33437-18N/A455-391-6789-2839 Grand AvenuePlanoTXN/AGRP-2547—
CLMCLM-4120532026-03-31T00:29:49ZStephen··—Espinoza1979-08-17UHC4787757•••-••-8648(598) 332-0920null3946 Pine DrTucsonAZ85748UNKNOWNMEDICARE-ADV-A
CLMCLM-4309632026-08-02T18:44:24ZLUIS····BUTELR1948-01-28—•••-••-3337+1 423 567 1000NULL7981 Harbor BlvdMinneapolisMN55440-CORE-HMO
CLMCLM-421590 2026-06-05T21:09:28ZBradley—Rogers1987-12-20UHC-01551-77—UNKNOWN—8042 PINE DRSEATTLEWA·98169GRP-8225N/A
CLMCLM-4010762026-06-27T13:17:10ZANGELA—MILLS19731009UHC-64081-98null714-275-6815angela.mills@proton.me··3753 Harbor BoulevardTucsonAZ··85789—OPTIONS-PPO
CLMCLM-4178012026-09-17T01:50:02ZGLORIA····CRAWFORD19971204UHC-50434-74—8296151569—69 Mesa DriveLos AngelesCA90061GRP-3466··NAVIGATE-HMO
CLM CLM-4268092026-05-16T04:10:30ZRyan—Hanry1997-02-08UHC-30848-72•••-••-9250NULL··——-NULL··—GRP-5062NAVIGATE-HMO
CLMCLM-4236562026-06-04T13:00:21ZCARLOS—ORTEGA1985-05-15UHC-86655-27•••-••-1640—UNKNOWN8554 Harbor BlvdSacramento··CA95837UNKNOWNMEDICARE-ADV-A
CLMCLM-4158812026-06-22T20:14:45ZMei—Luna1959-07-22UHC-88565-33•••-••-0429-NULL6214 Pine DriveDallasTX75285N/ANULL
CLMCLM-4302132026-04-23T17:41:00Zlarry—moreon1959-04-27UHC-74516-27——larry.moreno82@icloud.com6676 Oak Street··TempeAZ85271GRP-7637MEDICARE-ADV-B
32,829 rows, page 164 of 657PreviousNext

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