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-4136032026-01-13T16:20:49ZJason—Phillips11-08-1986UHC-16875-64null+1 513 762 9575jason.phillips5@icloud.com6367 Maple AveHOUSTONTX77051-CHOICE-PLUS-PPO
CLMCLM-4101852026-04-02T22:42:15ZsaarhDcrawford1960-94-22UNKNOWN•••-••-4374(743) 885-0092null1934 River Rd·Eden PrairieMN·UNKNOWNGRP-7526·SELECT-EPO
CLMCLM-4262722026-07-13T14:30:45ZRUTHIDIXON07/22/38UHC-79049-36•••-••-1558(931) 927-0788—4358 Park PlGLENDALEAZ85349GRP-7417N/A
CLMCLM-4054802026-09-02T23:39:41ZSandra····Owens··1978-11-16UHC-89246-62•••-••-8296(885) 385-6982—6957 BAYSHORE DRIVESEATTLEWA·98175GRP-3971—
CLMCLM-4314232026-09-14T13:41:16ZPeter—Roberts2008-09-12UHC-81497-96•••-••-2756N/AUNKNOWN1031 Grand AvePLANOTX75042··-··
CLMCLM-4070822026-04-25T18:36:31ZBryanG.Cater1973-11-26UHC-77574-52•••-••-7548385-954-1310UNKNOWNN/A—UNKNOWN—GRP-0892N/A
CLMCLM-4292562026-03-31T01:42:22Z·Jeffrey··Stewart1951-09-14··—null809.667.9938—9574 Maple AvenueOrlandoFL—GRP-1277SELECT-EPO
CLMCLM-4084032026-08-12T16:02:49ZCastillo, Patricia——1997-02-10UHC-69535-07•••-••-2968646-602-2448UNKNOWN—-··UNKNOWNnullGRP-6321NAVIGATE-HMO
CLMCLM-426846 2026-02-09T21:00:00Z·brenda—austinSep 21, 1952UHC5465753•••-••-16034455042178—4937 Lake View Road·GilbertAZ85206—OPTIONS-PPO
CLMCLM-4290402026-10-10T17:51:38ZMEI—THOMPSON1980-10-20N/A•••-••-47137002522355-———N/AGRP-5871—
CLMCLM-4268122026-02-25T16:24:28ZSara—Baker1979-12-05UHC-35017-70•••-••-38835226618224—·9270 VALLEY VIEW DRIVEHoustonTX77071UNKNOWNNULL
CLMCLM-4154082026-09-14T14:41:28ZAngela—Willis1984-11-27UHC-64489-28•••-••-8493——NULLUNKNOWNN/AUNKNOWNGRP-5679·NAVIGATE-HMO
CLMCLM-4314922026-01-31T13:44:48ZValentina—Castilo1/19/1975UHC-20623-84•••-••-7950null—2097 Sunset BlvdSan AntonioTX78268-····
CLMCLM-4133282026-03-18T18:36:16Z DiegoQ.Guerrero1943-03-05UHC-87787-76•••-••-5033N/Anull———NULLN/AMEDICARE-ADV-A
CLMCLM-424119 2026-09-02T13:18:01Z·JUDY—WAKTINS1973-04-08null——NULL5633 Market StColumbusOH43270GRP-8024MEDICARE-ADV-A
CLMCLM-4189442026-05-20T01:52:34ZEmma—Mitchell1962-01-22UHC-83138-42-NULL—857 Cedar LaneJacksonvilleFL32235-8047GRP-0288MEDICARE-ADV-A
CLMCLM-4142702026-07-05T12:51:12ZALBERTR.WATSON01/26/84UHC-54144-28N/A292-405-4334N/A8403 Sage CtLas VegasNV—·-—
CLMCLM-4244732026-08-27T12:31:58ZJUDITH—RAMIREZ1983-10-07UHC-46061-12•••-••-9909+1 609 539 6518JUDITH.RAMIREZ65@AOL.COM1586 Bayshore Drive·San AntonioTX78206GRP-1503medicare-adv-a
CLMCLM-4032662026-07-30T09:10:35ZKENNETH—COOPER19990406UHC-97521-32—447.477.4516—6394 BASELINE RDMesaAZ85234GRP-8790N/A
CLMCLM-4026852026-07-17T11:17:18ZDEBORAH—JOHNSON1978-06-01UHC-64630-40N/A533-956-4622NULL·2676 GRAND AVENUETAMPAFL33681—OPTIONS-PPO
CLMCLM-4033202026-04-29T16:47:49ZSteven····Fox19960810—•••-••-4531····—-N/AN/A—GRP-2326MEDICARE-ADV-A
CLMCLM-4009232026-06-02T09:13:37Z Betty—Howard28-08-1954-null——--—nullGRP-9120-
CLMCLM-4161052026-10-10T17:49:12ZJonathanH.Oliver1972-10-17null•••-••-0481+1 376 918 5738UNKNOWN708 FOREST AVESan AntonioTX78224GRP-5628—
CLMCLM-4078732026-06-23T22:49:27ZRussell—Jenkins··Jan 19, 1981UHC-53169-39UNKNOWN13286834487N/A·3948 CHURCH STSacramentoCA95868GRP-5295—
CLMCLM-4049532026-07-15T03:12:51ZStephenTPeterson1980-01-06UHC-33520-06•••-••-3662·NULLUNKNOWN9687 Central AveDALLASTX75221··GRP-1313null
CLMCLM-4276352026-01-10T08:54:16ZMoore, Hiroshi——09/08/1950UHC-19734-64•••-••-31139456011null952 Union Street··GLENDALEAZ85388NULL—
CLM CLM-4230832026-03-14T08:56:17Zmark—·day0607-91-89UHC4088326—+1 869 476 2010-9298 BAYSHORE DRIVECHARLOTTENC28276GRP-2776null
CLMCLM-4307082026-08-27T14:47:42ZFATIMAMDELGADO1985-05-02—N/A16523384502··UNKNOWN4355 BroadwayPlanoTX75006GRP-3668CHOICE-PLUS-PPO
CLMCLM-4153002026-03-24T19:31:36ZLAWRENCE—NICHOLS19410326UHC-23434-16•••-••-3265(598) 597-0939NULL2895 Canyon RoadLAS VEGAS··NV89183nullSELECT-EPO
CLMCLM-4217532026-05-25T21:23:11ZLinda—Johnson1994-09-18····nullUNKNOWNLINDA.JOHNSON@YAHOO.COM3980 Baseline RoadColumbus··OH43215GRP-6065MEDICARE-ADV-A
CLMCLM-4243812026-04-03T13:02:47ZHEATHER—BROOKS07/08/78UHC6222754NULL·822.587.8741—8233 INDIAN SCHOOL ROADPlanoTX-nullNULL
CLMCLM-4321842026-02-03T22:54:30Zmadson—allen10/23/1995—•••-••-3610249-643-9303—N/A———NULL—
CLMCLM-4021602026-07-06T14:36:30ZSOHPIA—PENA··1952-07-16UHC-35707-30•••-••-3201+1 236 434 3588—--—N/AGRP-6759—
CLMCLM-4209672026-01-04T06:50:03ZMelissa—Marshall·1998-06-13UHC-73960-39UNKNOWN··-UNKNOWN4529 GRAND AVEMinneapolisMN55492GRP-0971CORE-HMO
CLMCLM-4075032026-04-23T12:52:04ZCamila—·Sandoval·1972-06-25UHC-86804-48—NULL-—NULLnull-UNKNOWNMEDICARE-ADV-A
CLMCLM-4151212026-04-30T13:46:56Z·Timothy—·Brooks·3/15/1978UHC-96249-54—6567818224UNKNOWN9727 MAPLE AVETEMPEAZ85257NULL—
CLMCLM-4047852026-01-18T00:29:25ZChristian—Salasar··1994-10-08—•••-••-2976····—nullnullN/ANULLGRP-4032NAVIGATE-HMO
CLMCLM-4199332026-01-19T06:12:15ZKATHRYN—HARVEY1939-06-06UHC-96992-41•••-••-1378····KATHRYN.HARVEY35@ICLOUD.COM—-null—GRP-1806null
CLMCLM-4173132026-08-31T08:55:14ZWheeler, JasonA.··1954-08-10UHC-04921-58N/A17058205106NULL--··—-UNKNOWN—
CLMCLM-4093862026-05-14T08:56:48ZEvelyn··—Andrews1946-01-27UHC-11362-59UNKNOWN··-NULLNULLN/AN/ANULL··UNKNOWNSELECT-EPO
CLMCLM-4022722026-09-24T17:59:47ZDENNYCSANDERS1982-03-12—N/ANULL-4095 MEADOW LNNashvilleTN37259—N/A
CLMCLM-429301 2026-03-04T07:05:44ZRonald—Jimenez19421025UHC-03548-71UNKNOWN(612) 779-7056-N/A—N/AN/AGRP-4268null
CLMCLM-4244432026-10-14T16:31:38ZRiz, RalphA··—14-05-1950UHC-42464-05•••-••-749918179605979—5738 Valley View Drive··MESAaz85298GRP-6814N/A
CLMCLM-4297122026-08-21T18:50:11ZRobert··Walker1988-05-09UHC-76321-65•••-••-8157NULL·N/A-——N/AnullCORE-HMO
CLMCLM-4300492026-02-08T07:41:04ZWilliam—Russell1965-03-03UHC-23538-66•••-••-1065N/Awilliam.russell@aol.com4366 Cedar LnLos AngelesCA90084GRP-5009NULL
CLMCLM-4076692026-10-15T01:47:10Zkevin—scott1977-09-05UHC-95333-52•••-••-2664NULL·NULL6262 Apache BoulevardCOLUMBUSOH··43216GRP-2002—
CLMCLM-4250512026-03-14T20:30:37ZOrtiz, Charles N——04/02/38UNKNOWN•••-••-9223951-924-6952-6243 HILLCREST ROADGLENDALEAZ85395··GRP-8629·NULL
CLMCLM-4323042026-01-20T06:14:42ZKAYLA—VALDEZ1938-05-23nullNULL—null8475 LINCOLN WAYChandlerAZ85247GRP-9072NULL
CLMCLM-4050842026-06-04T21:19:10ZJudith—Lopez2002-05-16—•••-••-0967——9047 BroadwayGlendaleAZ85316GRP-1165N/A
CLMCLM-4235602026-09-25T01:27:26ZGary—Owens1976-10-19UHC-31774-69—407.517.9620gary.owens76@outlook.com·3992 Park PlGilbertaz85205GRP-4578—
32,829 rows, page 41 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:36.688Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty