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-4207022026-08-23T04:36:24ZLauren—Gutierrez·10/10/1942NULL—440.908.3769—5474 Indian School RoadChandlerAZ85220-5524N/AMEDICARE-ADV-A
CLMCLM-4122912026-03-18T16:52:23ZVirginiaF··Ross07/13/1999UHC-44106-88nullN/A—6241 Main StreetOrlandoFloridanullGRP-7113—
CLMCLM-432670 2026-02-22T16:35:48ZTERESA—HOWELL1959-10-07--5502159435NULL6315 Oak StAustinTX·78713GRP-6736-
CLMCLM-4102362026-06-10T14:48:45Z·Sarah—Wright07/09/2007N/A——NULL3671 Sunset BoulevardNashvilleTN37271GRP-0854-
CLMCLM-4048792026-04-23T21:20:26ZGaryP.Burton01/22/1988UHC4126481-—NULL4869 Church Street·GilbertArizona—GRP-4384-
CLMCLM-4092802026-03-16T15:38:35Zgloria—·dominguez06/11/1951—NULL3779975546UNKNOWN426 Willow CourtGlendaleAZ85320N/ACORE-HMO
CLMCLM-4046522026-04-09T22:50:59Z·HANNAH—WOOD1982-10-02—•••-••-0747—N/A8882 HARBOR BOULEVARDHoustonTX77005—····
CLMCLM-4026532026-08-30T13:40:48ZBRANDONYRICE3/14/1986UHC-75050-61•••-••-2512509-866-6317—NULL—nullUNKNOWNGRP-5894·N/A
CLM CLM-4318672026-02-10T13:59:49ZronaldG·meyer·2000-05-27NULL—5777411106RONALD.MEYER@GMAIL.COM8153 BROADWAYMESAAZ85274—OPTIONS-PPO
CLMCLM-4049152026-05-07T20:07:09ZMartha—Henderson1966-01-09UHC-35020-04-··—·N/A2056 Highland AveTampaFL33619—MEDICARE-ADV-A
CLMCLM-4117992026-10-06T18:13:38ZCamila—Harrison19950912UHC-38431-26—-camila.harrison@aol.com—nullNULLUNKNOWN·GRP-1243CHOICE-PLUS-PPO
CLMCLM-4191652026-01-30T07:05:37ZAnthony—Wells1955-06-12UHC-46535-81—8936221346··N/A8883 Central AvenueGlendaleAZ··—GRP-8928CHOICE-PLUS-PPO
CLMCLM-4251772026-09-30T22:53:51ZRichardson, JamesY—1943-05-17UHC-80635-16N/A—null4127 HIGHLAND AVEGILBERT··AZ85229GRP-1931SELECT-EPO
CLMCLM-4261482026-08-21T20:14:36ZAAROND.BAKER01/13/02·UHC-67046-98—8577507295null3501 Indian School RoadGILBERTAZ85251—CORE-HMO
CLMCLM-4018122026-08-19T07:23:11ZJacqueline—Willsi09/05/2003UHC-69078-97-871-603-6630UNKNOWN5661 SAGE COURTSAN DIEGO·CANULLGRP-0166-
CLMCLM-4133332026-06-10T04:04:25ZHenderson, Douglas——1997-01-10—-NULLnullN/A—N/AUNKNOWN——
CLMCLM-4071182026-05-12T09:15:39ZAllen, Gloria——1992-09-12N/A··UNKNOWNNULLN/A6590 Lake View RdAustinTX78719-2888—CHOICE-PLUS-PPO
CLMCLM-4070222026-07-08T13:49:03ZDavid—Heenry1964-01-25UHC-48679-36•••-••-5281——4431 Harbor Blvd··CharlotteNC28202-3106GRP-4908UNKNOWN
CLMCLM-4084222026-03-11T03:53:13ZLauren—Roberts1985-08-02UHC-80177-29•••-••-5850—lauren.roberts@yahoo.com2732 Palm Drive·DenverColoradoUNKNOWNUNKNOWNOPTIONS-PPO
CLMCLM-4162012026-04-24T10:02:35ZBETTYTGREEN1957-02-08UHC3246884-6344023599N/A7997 Lake View RoadJacksonville·FL32235··GRP-8572CORE-HMO
CLMCLM-4277672026-04-18T16:09:11ZANTHONY—·HARRIS2002-11-20UHC-93261-88•••-••-6072(836) 439-0145····6767 Palm DriveORLANDOFL32833NULLSELECT-EPO
CLM CLM-4255592026-09-12T02:05:09ZDonan—Cole1963-10-15UHC-91826-55——-5655 Apache BoulevardCHANDLERArizona85231GRP-5507—
CLMCLM-4097982026-04-11T05:10:47ZJustinO.Vargas2004-09-15NULLnull(580) 888-0906—3263 HILLCREST ROADLos Angeles·CA90035GRP-2589—
CLMCLM-4153832026-03-22T11:22:57ZTayllor, Santiago——2007-08-18NULLNULL6325400——UNKNOWN-·-null—
CLMCLM-4271942026-07-24T17:59:32ZALBERT··WATKINS2008-09-26··UHC-76579-96UNKNOWN·16938904629NULL6358 RIDGE ROADTucsonAZ85780····OPTIONS-PPO
CLMCLM-4171412026-09-27T08:05:37ZDeborah—JonesJul 11, 1987UHC-84110-46null12157087940NULL145 RIVER ROADSeattleWA98135GRP-7183CORE-HMO
CLMCLM-4317512026-02-28T01:39:37ZAlan—Gilbert··1966-08-18UHC-57392-18NULLUNKNOWNUNKNOWN5697 Camelback RoadCharlotte·NC28248-8592GRP-5262null
CLMCLM-4043612026-04-11T01:52:42Z·Burns, Isabella——1948-08-20UHC-10907-04NULL—UNKNOWN709 MOUNTAIN VIEW DRAtlantaGeorgia··30397GRP-4275—
CLMCLM-4241972026-02-15T11:11:37ZValentinaMHarvey28-03-1943UHC-49991-78—N/A—7433 BroadwayScottsdaleAZ85261GRP-9644null
CLMCLM-4225452026-02-07T22:48:34ZDunn, Edward———UHC-83791-65•••-••-2763—-4734 Cedar LnLos AngelesCA90061NULLNAVIGATE-HMO
CLMCLM-4147092026-08-18T01:57:34ZTYLER—JONES1946-04-21—•••-••-173814602508316—4500 INDIAN SCHOOL RDPhoenixAZ85069—OPTIONS-PPO
CLMCLM-4080932026-05-23T12:28:55ZJonathan—Ferguson19891014··UHC-53355-99•••-••-7380(439) 209-8209—7819 Cedar LaneSeattleWA98120GRP-6804CORE-HMO
CLMCLM-4140772026-09-10T21:13:02ZMarilynJ.Maldonado1964-05-17UHC-86096-01•••-••-8108——3646 Canyon RdOrlandoFL—GRP-2639NULL··
CLMCLM-4131932026-03-02T11:59:46ZJackie—Wattson2005-05-22UHC-06280-11-(520) 492-3549—1973 Cedar LnTucsonArizona85733—MEDICARE-ADV-B
CLMCLM-4287312026-09-20T03:17:14ZJulie··—Henry09/22/2003NULLN/A(731) 268-0113N/A4006 VALLEY VIEW DRIVEATLANTAGA30310GRP-8124MEDICARE-ADV-A
CLMCLM-4240652026-01-07T18:58:26ZPATRICIA—ROSS05/22/49UHC-68744-18•••-••-2117-NULL52 Desert Sky BoulevardGlendaleAZ85394GRP-6642null
CLM CLM-4019932026-03-18T23:52:15ZAlexis—Henderson03/27/68-•••-••-4831·2472407417—5737 Lake View RoadPhoenixAZ85033GRP-3199—
CLMCLM-4224932026-05-23T09:24:42ZPeterson, Christian——1969-06-14UHC-46520-71•••-••-7049——2683 INDIAN SCHOOL ROADEden Prairie··MN55358GRP-4386UNKNOWN
CLMCLM-4279272026-04-07T12:56:22ZKevin T··—Guerrero1956-03-23UHC5529665—379-589-1436-4927 River RdFRESNOCA93783N/A—
CLMCLM-4045682026-05-25T21:45:03ZLisa—Thompson1980-03-13·N/AN/A18929076595····——-—null····
CLMCLM-4064272026-01-09T13:57:14ZJean—·Peters14-07-1980UHC-92982-01UNKNOWN(444) 491-5682—5944 Apache BlvdMiamiFloridaN/AUNKNOWNNULL
CLMCLM-4197192026-07-27T13:12:10ZHIROSHI—FOWLER1947-09-07UHC-09603-43null272-454-8137--N/A—N/AGRP-1294CORE-HMO
CLMCLM-4198832026-08-31T02:57:17ZCHRIS—BISHOP19810928UHC-37211-39•••-••-3602N/Anull··nullnull—UNKNOWNGRP-0633··NULL
CLMCLM-4102792026-07-17T01:06:13ZANGELA—FOSTER1989-05-22——(613) 685-5579UNKNOWN5359 BASELINE ROADSan AntonioTX··78284GRP-5178MEDICARE-ADV-B
CLMCLM-4100992026-07-01T04:09:55ZRachelCHughesApr 7, 1963····•••-••-7429—null6194 WILLOW CTAUSTIN·TX78713GRP-2576—
CLMCLM-4134642026-03-18T23:25:19ZCAROL—HAMILTON11/17/2006UHC-47996-65—N/A-9822 Apache BoulevardFresnoCA93733—MEDICARE-ADV-A
CLMCLM-4326172026-01-09T05:35:08ZAisha—Burke19601203UHC-42201-91—NULL—8632 Oak StreetPLANOTX·75013GRP-2369—
CLMCLM-4138122026-05-28T00:38:59ZRyan—Johnson1997-09-28·UHC-89836-17null857-636-1853····3038 DESERT SKY BOULEVARDTEMPEAZ85210-0658N/A·CORE-HMO
CLMCLM-4272412026-09-05T15:36:14ZJUAN—RICHARDSON1953-06-28null—UNKNOWNjuan.richardson32@icloud.comnullNULL—NULLnull—
CLMCLM-4128592026-08-27T15:49:57ZMichael—Harrison07/09/63uhc-04868-24UNKNOWN——7551 Lake View RoadLos AngelesCA90095GRP-5271null
32,829 rows, page 13 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:34.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty