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-4107292026-04-25T22:22:01Zanthony—burton1956-11-09UHC-76511-82UNKNOWN(922) 634-0929NULLN/A—-N/AGRP-1863NULL
CLM CLM-4260572026-01-08T21:29:26ZEVELYN—·RUIZ·09/25/1969UHC6026323··N/AEVELYN.RUIZ@OUTLOOK.COMnullnull-—GRP-4565SELECT-EPO
CLMCLM-4147692026-09-29T05:01:58ZSusan—Armstrong·1992-10-11UHC-24801-37—null--UNKNOWNnullNULLGRP-2815·N/A
CLMCLM-4074582026-08-29T11:31:26ZAmy—Vasquez1951-04-14UHC-05827-31——null5795 Maple AveGlendaleArizona85335nullMEDICARE-ADV-B
CLMCLM-4052982026-04-17T06:57:52ZJonathanTHoward1953-12-05UHC-92491-49—(830) 848-2836N/A—·-—UNKNOWN··GRP-5851UNKNOWN
CLMCLM-4031062026-09-10T01:14:56Zethan—stevens1961-05-25UHC-83036-06NULL—-7486 RIVER RDDallasTX—GRP-8679-
CLMCLM-4221272026-08-16T06:15:27ZWalker, Mary——20-11-1979—•••-••-9138N/Amary.walker18@yahoo.comUNKNOWN-UNKNOWN—GRP-1112NULL
CLMCLM-4074692026-09-25T18:54:47ZChristian—Reynolds19690415UHC-02582-56•••-••-39645332542224—836 Bayshore DrPlanoTX75001·GRP-3610CHOICE-PLUS-PPO
CLMCLM-4072732026-09-06T23:17:51ZRyan··—Wagner11-12-1959UHC-27140-32•••-••-9261-—7438 Highland AveSan DiegoCA92172·GRP-6137—
CLMCLM-4084932026-05-21T06:31:51ZDonna—Allen1979-06-17UHC-09329-72—838-427-4365—nullN/A··-NULLUNKNOWNCORE-HMO
CLMCLM-4222642026-07-21T16:59:03Z Marilyn—Taylor1973-12-28N/A-959-680-7090—9388 Ridge RdMinneapolisMN55465-NAVIGATE-HMO
CLMCLM-4237272026-09-30T12:02:07ZGraceR.HicksOct 19, 1993UHC-28983-41UNKNOWNUNKNOWN-UNKNOWNNULL-N/AN/AOPTIONS-PPO
CLMCLM-4255272026-04-20T21:48:07Zscott—johnstonAug 10, 1965UHC-34433-48-13599750648UNKNOWNN/A———GRP-9142NULL
CLM CLM-4072062026-05-25T14:15:08ZSHIRLEY—CRUZ1978-01-23uhc-86255-78•••-••-3250NULLNULL7175 Ridge RoadGlendaleArizona85355UNKNOWNCORE-HMO
CLMCLM-4139032026-04-19T13:06:08ZSarah—Yang1986-04-09··UHC-33199-01N/A(391) 429-7130—6429 Jefferson Avenue·NashvilleTN37283N/AUNKNOWN
CLMCLM-4293912026-09-11T20:39:34ZRoberts, Emily——1955-07-11-··956-528-6935N/A··6341 Meadow LaneTucsonaz85745NULL—
CLMCLM-4046062026-07-12T08:58:07ZSusanZKennedy1955-06-28NULL•••-••-91049065409347UNKNOWN9397 Canyon RoadAtlantaGA30329—MEDICARE-ADV-A
CLMCLM-4208392026-06-10T05:00:03ZRaymondXMuunoz5/13/1976UHC-91631-69•••-••-6942NULLUNKNOWN8454 Apache BoulevardSCOTTSDALEAZ85248-5730null·MEDICARE-ADV-B
CLMCLM-4321332026-05-29T21:19:41ZMariaW··Welch1950-04-01uhc-40855-94•••-••-3123——5189 Camelback Rd #798JACKSONVILLE·FL32254GRP-0238·MEDICARE-ADV-A
CLMCLM-4281292026-07-15T22:32:59Z·Ruth—Meyer··2004-06-19UHC-88349-27•••-••-0378+1 864 735 8107N/A8704 Central AvenueGlendaleArizona85341N/ASELECT-EPO
CLMCLM-4263742026-08-17T19:17:32ZSharon—Salazar1/18/1961—-390.866.0416—1694 MESA DRATLANTAGA30393GRP-9091N/A
CLMCLM-4129872026-03-14T11:17:52ZOLIVIAT··WASHINGTON1982-05-10NULL—(404) 363-1150—4213 Lake View RoadGlendaleAZ85370GRP-2318null
CLMCLM-4301372026-04-20T18:12:48ZRonaldUButler··Jul 18, 1971UHC-23449-92—8394708174NULL·6971 Lake View RdLas VegasNVnull··GRP-2699··
CLMCLM-407441 2026-09-21T04:53:32Zevelyn—burke1951-03-08·NULL•••-••-3043nullevelyn.burke@aol.com9253 Valley View DriveAtlantaGeorgia30365GRP-7550MEDICARE-ADV-A
CLMCLM-4155612026-07-12T13:18:40ZOlivia—Perez1963-04-16—UNKNOWN—N/A2563 Park PlaceLAS VEGASNV89137··—-
CLMCLM-4268472026-09-10T15:46:48ZOLIVIAX.COLE2008-08-16UHC3802085•••-••-0379NULL-6381 Harbor Blvd··Eden PrairieMN55366GRP-9574null
CLMCLM-4166732026-09-26T02:19:27ZCATHERIINE—LEE03/15/67·UHC-31793-24-nullUNKNOWN1926 UNION STChandlerAZ85249GRP-0424—
CLMCLM-4221232026-05-27T04:31:56ZSARA····ESTRADA1946-01-01···null—7713627179UNKNOWN2636 Forest AvenueJacksonvilleFL32276GRP-3275··CORE-HMO
CLMCLM-4088762026-05-26T06:44:31ZBruce—Perkins19680402——3819597953NULL··N/A-nullNULL—medicare-adv-a
CLMCLM-4127512026-08-15T10:33:20ZRachelU.··Cruz1995-10-10UHC-28148-13•••-••-4537null—94 Palm DrEden PrairieMN·55379GRP-2584medicare-adv-a
CLMCLM-4168392026-04-09T05:06:06ZDiego—Bradley19380804UHC-84812-31•••-••-3132848.321.8084NULL—N/ANULL—-OPTIONS-PPO
CLMCLM-4137012026-07-05T06:05:22ZVincent—Ruiz1975-11-21-•••-••-3274214-857-9912—·4505 Indian School RoadPLANOTexas75029··GRP-0337MEDICARE-ADV-A
CLMCLM-4168862026-02-02T01:05:19Z gregory—young10/1/1988—-6574684359gregory.young@aol.com7653 Baseline Road·HOUSTONtx77022GRP-2647NULL
CLMCLM-4025992026-05-09T23:01:54ZMikhelle—Medina2006-03-15UHC-20779-23•••-••-7670NULLMICHELLE.MEDINA97@HOTMAIL.COM2223 Spring StreetAustinTX78785GRP-2931N/A
CLMCLM-4255292026-01-20T22:55:12ZSCOTTJJOHNSTON1965-08-10N/A•••-••-884513599750648scott.johnston18@icloud.com7864 Oak StreetNashvilleTN37209GRP-9142-
CLMCLM-4167752026-05-25T02:47:50ZBRYAN··STEVENS05/16/1997UHC-77358-20•••-••-5074(642) 398-9218-UNKNOWN—UNKNOWN—N/AMEDICARE-ADV-A
CLMCLM-4058582026-06-13T03:12:29ZLarry—Bradley1979-01-15UHC-38911-80null(432) 315-9224UNKNOWN1967 Meadow LaneTucson·AZ85756GRP-3778NAVIGATE-HMO
CLMCLM-4233042026-02-17T03:05:12ZArjun—Scott04-05-1999N/A•••-••-8501766.354.2743UNKNOWN2788 Sage CtPlanoTX75035GRP-9373—
CLMCLM-4216372026-04-14T01:29:03ZWillie—·Wang1997-12-05uhc-59116-79•••-••-0179nullUNKNOWNN/A—N/A-UNKNOWN-
CLMCLM-4150772026-10-13T02:26:02Zmariana—robertson2004-08-20NULL•••-••-005018417085404-———UNKNOWNGRP-9815NULL
CLMCLM-4099082026-05-03T12:17:48ZJordan—Fowler1993-07-25UHC8433287•••-••-6538+1 432 510 3303N/A-—UNKNOWNnullGRP-2959—
CLMCLM-4145902026-03-25T21:38:25Zlarry··—franklin1955-01-19null··•••-••-0659(894) 505-5515N/ANULL—UNKNOWN———
CLMCLM-4033802026-09-15T00:46:00ZDEBORAH—FOXJun 6, 1950——·NULL—1515 Hillcrest RoadOrlandoFL32891-3197GRP-7014UNKNOWN
CLMCLM-4031252026-06-26T09:27:43ZNICK—CARTER1938-12-23NULL•••-••-9425UNKNOWN—8213 APACHE BOULEVARDOrlandoFlorida32843GRP-9202UNKNOWN
CLMCLM-4172832026-09-24T14:57:44ZRobert—Jacobs3/14/1957—•••-••-70365642961872robert.jacobs32@icloud.com6001 CANYON RDJACKSONVILLEFL·32224nullCORE-HMO
CLMCLM-4180592026-03-30T14:54:04ZDorothy····Austin1949-11-11-nullnulldorothy.austin99@outlook.com8657 Oak StreetLos AngelesCA90068——
CLMCLM-4031782026-09-20T20:55:17ZJOE—STEPHENS1975-03-11—•••-••-8994+1 311 828 5793·NULL302 Church StColumbusOH43237GRP-5216—
CLM CLM-4027812026-05-16T11:40:17ZLi, AngelaO—1983-11-13UHC-73845-11•••-••-3945830.499.8351N/A210 Cedar Lane #584DenverColorado···80294GRP-9205UNKNOWN
CLMCLM-4181042026-06-20T18:22:45ZBILLY—VEGA·05/20/1941UNKNOWN•••-••-7322388-340-6916null6469 HILLCREST ROAD·ChandlerAZ··85210GRP-6268MEDICARE-ADV-B
CLMCLM-4049172026-04-22T13:53:39Z·Cheryl—Bryant1960-12-26··UHC-88136-88··•••-••-0643-N/A6111 Willow Ct·San AntonioTX78214·GRP-2642MEDICARE-ADV-A
32,829 rows, page 195 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.643Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty