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-4169522026-01-16T17:02:28ZElijah—Richardson02-04-1951··null8383667294··UNKNOWN3875 Park PlaceOrlandoFL32864nullselect-epo
CLMCLM-425700 2026-02-20T11:09:10ZWilliam—BanksSep 7, 1997UHC-17248-72—892.598.2915UNKNOWN7392 River Road··Orlando··FL32852—·SELECT-EPO
CLMCLM-4277862026-05-23T04:57:48ZSantiago—Alexander1958-02-15UHC-36340-34•••-••-1281980-695-9107SANTIAGO.ALEXANDER@HOTMAIL.COM48 Union StreetSan Antonio·TX78262GRP-1203CORE-HMO
CLMCLM-4305312026-06-30T22:32:22ZThomas, Christian——Oct 19, 2005—•••-••-4908····UNKNOWN4914 Market StreetGilbertAZ85274N/AN/A
CLM CLM-4171022026-01-25T13:32:23Z Susan—MCoy1988-11-09UHC-28356-24null478-289-9345NULL9660 Sage CtLas Vegas·NVN/A—null
CLM CLM-4099582026-02-25T20:25:54ZALICE—ARMSTRONG·11/04/99·-•••-••-2624—NULL5394 River RoadCHARLOTTENC28228····MEDICARE-ADV-B
CLM CLM-4307312026-06-16T09:37:47ZFrank—Allen2008-06-15UHC-12886-83-nullnull770 Sage CourtLas VegasNV89139N/ANULL
CLMCLM-4319202026-04-14T02:43:40ZBRYAN—GRANT1971-00-37——5397706608—7460 Mountain View DriveCHANDLERAZ·85254GRP-0969NULL
CLMCLM-4162382026-03-29T20:40:40Zjack··—hall1999-09-13UHC-00511-45•••-••-6310-—5459 Canyon RdSan DiegoCA·92191-5166·GRP-4756—
CLMCLM-4245752026-02-27T10:56:24ZWhite, Ann—··06/19/1957··N/A—UNKNOWN159 Hillcrest RdNASHVILLETN37295-3045GRP-1580null
CLMCLM-4101072026-09-10T19:25:28ZSaraFPadilla·1982-02-02—NULL·(518) 358-4426—7342 Spring StreetGLENDALEArizona85369N/A—
CLMCLM-4219282026-07-05T20:02:30ZNANCY—HOWARD02/07/94UNKNOWN•••-••-0692380-642-2553·-1720 Willow CourtLAS VEGASNV89112UNKNOWN··SELECT-EPO
CLMCLM-4213192026-07-07T15:38:11Z·Clark, Michelle——28-06-1987uhc-76779-12··•••-••-8538718-627-5243—4196 Union StreetMiamiFL33116GRP-9549NULL
CLMCLM-4106522026-06-25T15:54:05Z KATHRYN—PORTER1976-03-17·UHC-28907-23•••-••-35986793382184—·1943 BroadwayTUCSONAZ85774GRP-5731MEDICARE-ADV-B
CLMCLM-4250012026-07-11T17:12:56ZVictoria—Graham1950-09-24UHC-99148-14•••-••-00916796257726—1392 FOREST AVENUESan AntonioTX78284GRP-0617NAVIGATE-HMO
CLMCLM-4070132026-05-26T13:12:51ZJacob—Kim9158-07-15UHC-18672-96—487-748-9624N/A8072 Elm StreetJACKSONVILLEFL··32291GRP-6972UNKNOWN
CLMCLM-4047862026-02-16T11:18:52ZTHOMASDMATTHEWS1986-10-08UHC-26458-46··—UNKNOWNnull·5233 Camelback Rd Apt 24NashvilleTN37299—N/A
CLMCLM-4282602026-10-15T12:38:08ZRyan—WalkerJul 19, 1979·UHC-79552-94N/A——9299 HILLCREST RDLas VegasNV—GRP-6462navigate-hmo
CLMCLM-4150492026-09-08T23:21:38ZBradley····Vasquez2002-07-21UHC-93444-31—nullNULL8359 Market StreetTampaFL33607GRP-7603CHOICE-PLUS-PPO
CLMCLM-4087952026-05-30T06:37:56Zdenise—parker··11/17/1947uhc-17727-44•••-••-2383—null1449 Central AvenueTempeAZ85219GRP-3471SELECT-EPO
CLMCLM-4134572026-03-19T11:40:33ZBarbara··—Edwards1951-10-01UNKNOWNNULLN/A-4467 OCEAN AVENUESeattleWA98174GRP-7778NAVIGATE-HMO
CLMCLM-4225652026-07-25T12:06:21ZRaid, Dylan——1943-12-05UHC-30535-48—(645) 547-4498—2056 Mesa DrPlanoTX75058GRP-6197MEDICARE-ADV-B
CLMCLM-4127242026-02-06T17:57:31ZCheryl—Carr1953-08-27UHC-96712-99--N/AN/ANULL——GRP-8312NULL
CLMCLM-4051732026-01-23T01:09:39ZBarbaraRSilva04/05/65—null3364136039N/A7394 Valley View DriveAustinTexas78781-6132GRP-7906NAVIGATE-HMO
CLMCLM-4277122026-08-28T12:30:52ZCEROL··—BROOKS1953-08-03UHC-66153-39—·2105415131N/ANULLN/AnullN/AGRP-8676NAVIGATE-HMO
CLMCLM-4065872026-05-14T18:32:28ZGordon, Kelly——1941-07-19null•••-••-4790—KELLY.GORDON@HOTMAIL.COM8001 RIVER RDLos AngelesCA90020GRP-0774OPTIONS-PPO
CLMCLM-4001762026-07-12T12:29:18ZTONY—·MALDONADO17-06-1958UHC-57454-98·NULL881-629-8459·-7136 Sage CtDALLASTX75246GRP-6337OPTIONS-PPO
CLMCLM-4282072026-04-15T05:52:58ZAbigail—Murray02/02/72··UHC-11771-53•••-••-0826NULLabigail.murray@gmail.comNULL—UNKNOWNN/AGRP-2268OPTIONS-PPO
CLMCLM-4056122026-06-21T23:25:18ZMARIANA—LANE19720910—·N/A451-279-9408NULL··—UNKNOWN·NULLGRP-8659···null
CLMCLM-427889 2026-06-05T21:05:08ZAARONRWEST—·UHC-59920-60UNKNOWN·373-676-0892—8485 Hillcrest RdCharlotteNC28223null-··
CLMCLM-4063632026-10-10T02:16:13Z·JordanKRichards·Apr 15, 1964UHC-99630-40NULL(891) 529-0762NULLN/AUNKNOWNNULLNULL—OPTIONS-PPO
CLMCLM-4307002026-08-14T13:50:37ZFATIMA—SCHMIDT·10/17/1955UHC-46411-87•••-••-0358(552) 794-0361UNKNOWN·6559 Highland AvenueLos AngelesCA90068GRP-8031NAVIGATE-HMO
CLMCLM-4181982026-01-16T17:39:26ZLarry—Burke1976-07-03··N/ANULL—N/ANULL—-—GRP-1616—
CLMCLM-4250622026-09-30T10:53:24ZKyle—Miller17-10-1972··UNKNOWNNULL·2157418181kyle.miller@yahoo.comUNKNOWNnullUNKNOWNN/AN/AOPTIONS-PPO
CLMCLM-4306952026-07-13T11:07:46ZLinda—Banks1959-12-08——(871) 463-6087—9484 River RdSan AntonioTX—GRP-2859—
CLMCLM-4226252026-05-04T11:20:26ZIsabellaR.Hanson1969-02-15UHC-86221-59N/A900.289.7182null-NULLUNKNOWNNULLGRP-2224null
CLMCLM-4244402026-06-04T01:52:36Z Andrea—Howell1951-10-20UHC-41300-78—350.796.5589—7160 OCEAN AVEColumbusOH·43227-7677N/A—
CLMCLM-4171212026-06-14T06:16:33ZRalph—Rogers1978-11-01-UNKNOWN884-816-3211···8175 Central AveSan AntonioTX78211GRP-8964—
CLMCLM-4116612026-02-20T00:26:22ZValentina····Burke1940-09-27UHC-83580-65•••-••-5315263-414-7041UNKNOWN5368 ELM STREETGilbert·AZ85217GRP-0230—
CLMCLM-4296842026-02-23T04:39:23Zdonald—carr2007-07-24··UHC-61234-06NULL—UNKNOWN3247 Valley View DriveAtlantaGA30313GRP-3433N/A
CLMCLM-4093792026-05-03T05:13:44ZCYNTHIA—MORGAN··01/11/85null•••-••-9487-UNKNOWN1084 CANYON ROAD #260CharlotteNC28271——
CLMCLM-4120742026-08-26T00:42:42ZRussell—WilliamsonNov 6, 1947UHC-57475-82•••-••-4500(894) 745-1321-1151 MAPLE AVENUEMiamiFL33120GRP-4789MEDICARE-ADV-A
CLMCLM-4128882026-08-27T20:52:02ZJoyce—Morrison1976-09-09UHC-80236-49—980-206-9359—4704 LINCOLN WAYCOLUMBUSOH43278—CORE-HMO
CLMCLM-4310652026-03-12T18:38:43ZMADISON—JOHNSON3/26/1985N/A•••-••-6456NULLUNKNOWN1279 BroadwayTucsonAZ85702·GRP-2168MEDICARE-ADV-B
CLM CLM-4090082026-06-23T22:32:29ZJacqueline—Williams1947-08-08nullnullNULLUNKNOWN7124 CAMELBACK RDTucsonAZ85756—MEDICARE-ADV-B··
CLMCLM-4121152026-02-07T13:31:51ZJean—Hamilton9165-02-08UHC-77149-18•••-••-8382-N/A———-—CHOICE-PLUS-PPO
CLMCLM-4001372026-04-13T01:03:38Zdoris—mendoza1986-11-26UHC2992087•••-••-4666—-5813 Willow CtCHARLOTTENorth CarolinanullGRP-8235—
CLMCLM-4240642026-03-29T08:33:11ZJessica··—Dean1966-03-14N/Anull·NULLjessica.dean20@icloud.com—null—nullGRP-2244CORE-HMO
CLMCLM-4311352026-05-26T07:01:25ZAHMED—CASTRO25-09-1947—null——7417 Park PlaceTUCSONAZ85763GRP-6698N/A
CLMCLM-4062972026-01-05T23:03:23ZSarah T—·Sctot·05/16/1944UHC-34036-57NULL··NULLSARAH.SCOTT34@PROTON.ME--UNKNOWNNULLN/ASELECT-EPO
32,829 rows, page 151 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.338Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty