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-4235702026-02-08T01:04:47ZBenjamin—Duncan·1957-04-07UHC-06987-44UNKNOWN—benjamin.duncan@icloud.com1120 Sage Ct··GilbertArizona85299··CHOICE-PLUS-PPO
CLMCLM-4248952026-04-05T21:24:05ZFrank—Roberts··1982-06-11-·null355-523-1096null7429 Washington Street··PhoenixAZ85050GRP-8889CORE-HMO
CLMCLM-4054502026-06-25T09:25:36Z Jacob—McDonaldMar 26, 1938—•••-••-6660··JACOB.MCDONALD@GMAIL.COM2266 Washington StNashvilleTN··37213GRP-0606MEDICARE-ADV-B
CLMCLM-4003982026-04-15T09:33:30ZSIHRLEY—·WATSON1997-06-09N/A—7332586650null··UNKNOWN-UNKNOWNUNKNOWNGRP-5481··MEDICARE-ADV-B
CLMCLM-4064392026-08-26T10:46:39ZMason—Little1947-02-26UHC1534310-null—840 Market StGILBERTAZ85204GRP-6250·MEDICARE-ADV-A
CLMCLM-4309192026-09-25T11:37:02ZDoris—Carlson1955-11-08·UHC-77177-25—4104881839N/A2317 BroadwaySan DiegoCA92148GRP-7320N/A
CLMCLM-4265562026-09-12T20:47:44ZJANET····CHAPMAN·1957-05-01UHC-92930-87-910-740-2785N/A41 Apache BoulevardMiamiFL33138·null—
CLMCLM-4111782026-02-09T23:51:52ZVICTORIA—PADILLA1952-10-26·uhc-84331-08-15064162948—5959 CANYON RDLas VegasNV89122N/ANULL
CLMCLM-4129382026-02-16T01:10:33ZEMMA—DUNN6/10/1942—•••-••-7546—null9660 Meadow Ln Apt 33San DiegoCA92122—CORE-HMO
CLMCLM-4243822026-04-04T10:23:17Z·Richard—Chapman1999-11-01-•••-••-7598+1 831 458 1341—5513 Desert Sky Blvd··PlanoTX—GRP-1016NULL
CLMCLM-4186492026-09-18T00:52:55ZBILLY—WEAVER19530524UHC-92169-35UNKNOWN(653) 802-2577NULL1760 Pine Drive Apt 6SacramentoCA95874GRP-6055—
CLMCLM-4102372026-02-26T20:12:42ZWright, Sarah··—Jul 9, 2007UHC-88130-96··-+1 537 421 3025—·3671 Sunset BlvdNASHVILLETN37271GRP-0854-
CLMCLM-4323092026-10-14T18:40:21Z George··MillerDec 18, 1950UHC-23025-90-N/A————-GRP-3360SELECT-EPO
CLMCLM-4152732026-02-20T06:07:36ZKimberly—Marquez1942-05-15-•••-••-03889042302544·KIMBERLY.MARQUEZ@AOL.COM1432 Valley View Dr #146Las VegasNV89170GRP-3132··OPTIONS-PPO
CLMCLM-4032942026-01-03T12:24:20ZBILLY—ROBINSON10/12/1984··UHC-48999-54•••-••-9859UNKNOWNNULL8106 Main StTucsonArizona85787—null
CLMCLM-4169012026-06-01T00:30:05Z·Michelle—Andrews24-08-1993UHC-95441-15null237-787-1199··MICHELLE.ANDREWS@ICLOUD.COM6315 Highland AvenueOrlandoFL32874GRP-0188—
CLMCLM-4314672026-01-21T06:09:03ZHEATHER—KIM01/04/2006·uhc-33481-45—(631) 858-7406-4203 Harbor BoulevardTempeAZ85255GRP-3229CORE-HMO
CLMCLM-4025642026-09-19T19:56:22ZJacobAWilson··1965-02-09UHC-87096-71—4539048478NULL1598 Lincoln WayAtlantaga30322GRP-9167navigate-hmo
CLM CLM-4306512026-07-22T12:03:32ZGeorge—Hughes1957-09-12UHC-74485-63NULL(583) 720-5436··—2144 Hillcrest RdSan DiegoCA·92144GRP-8549OPTIONS-PPO
CLMCLM-4205712026-02-14T11:11:37ZLINDA—MCDONALD1980-04-09UNKNOWN··•••-••-778316556550558—6056 Highland AvenueAtlantaGA30385GRP-7982·UNKNOWN
CLMCLM-4077592026-09-02T13:27:23ZDaniel··—Wang01-08-1963UHC3061560N/A+1 212 371 8667—1901 Valley View Dr·DENVER·CO80235GRP-8194SELECT-EPO
CLMCLM-4214352026-05-06T16:52:27ZBetty—Nguyen1970-04-07null·UNKNOWN(516) 607-3683NULL———nullGRP-5685-
CLMCLM-4023812026-06-23T21:02:46ZalanOgarza1955-01-28UHC-67562-83•••-••-7355(473) 915-9766-8771 Canyon RoadPhoenixaz85074GRP-6668MEDICARE-ADV-A
CLMCLM-4113042026-06-02T08:29:29ZLAWRENCE—WASHINGTON1995-11-21UHC-83979-63———3579 Lincoln WayGlendaleAZ85317··GRP-3193·SELECT-EPO
CLMCLM-4238642026-04-19T21:29:04ZHeather—Fuller09/04/38UHC-97671-82•••-••-6795—heather.fuller80@hotmail.com5849 Mesa DrMINNEAPOLISMN55478GRP-1643OPTIONS-PPO
CLMCLM-4088022026-07-12T04:50:33ZElijah—Peters1980-03-01UHC-48945-36•••-••-6010·NULLN/A—-N/AUNKNOWNUNKNOWNMEDICARE-ADV-B
CLMCLM-4191512026-08-14T02:10:26ZKaren—Kim1/13/1993UHC-31368-19·····nullUNKNOWN8068 Mountain View Dr·DallasTX75206GRP-2189—
CLMCLM-4043122026-03-18T03:16:10Zmeegan··—fox·06/23/71UHC-06501-28-3982561019nullUNKNOWN-—··GRP-3314—
CLMCLM-4310992026-04-20T05:15:01ZJose—Chapman04/28/86UHC-83579-02•••-••-0731(667) 887-6082—4506 Park PlaceSAN DIEGOCA92114··UNKNOWN—
CLMCLM-428232 2026-05-17T06:27:54ZJerry—Dunn2/22/1993nullUNKNOWN(678) 992-1657UNKNOWN5397 RIVER RDCharlotteNC·28296—CHOICE-PLUS-PPO
CLMCLM-407330 2026-08-21T23:35:54Z·Willie—HarrisonFeb 21, 2004—•••-••-7078N/AUNKNOWN8401 Indian School Rd·MesaAZ85208N/AOPTIONS-PPO
CLMCLM-4275202026-05-19T16:04:37ZAlbert—Flores··1988-06-26UNKNOWN•••-••-7162——7327 Palm DriveDenverCO80275—UNKNOWN
CLMCLM-4111822026-05-28T17:40:39ZbeverlyLwilson1994-07-13··UHC-95133-67•••-••-3431642-439-5390UNKNOWN554 PINE DRIVEATLANTAGA30349GRP-0931MEDICARE-ADV-B
CLM CLM-4198222026-09-01T22:39:06ZCastro, Ryan——08/28/1963UHC-23084-63—648-595-5250—4342 Apache BoulevardMinneapolisMN··55481··UNKNOWN—
CLMCLM-4156402026-06-11T23:03:59ZRonald—Fuller1939-02-12·UNKNOWNnullN/ARONALD.FULLER@GMAIL.COM7629 Hillcrest RoadPlano·TX75086·GRP-6030SELECT-EPO
CLMCLM-4017442026-04-26T21:55:08ZBRADLEY—RICE3/12/1983UNKNOWN•••-••-0054280-738-1003UNKNOWN4855 Bayshore DriveAtlantaGA·30350GRP-8433NAVIGATE-HMO
CLMCLM-4224982026-07-19T22:38:11ZLORI—PORTER1946-02-14UHC-02218-88NULLN/Alori.porter72@hotmail.com8225 Grand AvePlanoTX75062GRP-4329SELECT-EPO
CLMCLM-4088912026-05-01T00:26:40ZKATHRYN—BAILEY1952-03-04UHC-55375-25—388.662.0737UNKNOWN4062 Baseline RdTAMPAFL33627GRP-1663—
CLMCLM-4177712026-01-22T07:07:28ZAmyNLarson2005-06-02NULL—NULL—1811 CANYON ROADScottsdaleAZ85207GRP-5135—
CLMCLM-4037462026-08-06T15:05:25Z·Cynthia—Castro10/16/88UHC-17557-30—·855-699-0149CYNTHIA.CASTRO@AOL.COMnullN/A—NULL-NULL
CLMCLM-4060332026-03-10T21:20:39ZWei··RJimneez1995-10-22UHC-80888-58•••-••-2096—null—·nullUNKNOWNnull·GRP-0876·NAVIGATE-HMO
CLMCLM-414422 2026-10-07T10:59:38ZNicole, Banks——Dec 26, 1996UHC-03903-87•••-••-3194551-404-5899UNKNOWN2517 Mountain View DriveMesaAZ85200··GRP-5995NAVIGATE-HMO
CLMCLM-4241262026-02-01T13:43:31ZPhilip—Guzman1/5/1996UHC-22868-86N/A·UNKNOWNnull8571 Main StOrlandoFL··32886GRP-8180OPTIONS-PPO
CLMCLM-4134072026-08-17T11:15:32ZLinda—Martinez11/21/1949UHC-20270-48•••-••-4727—null9175 Elm StSEATTLEWA·98172UNKNOWNCORE-HMO
CLMCLM-4073262026-01-31T22:46:53ZAnaZ.Burns1/27/1979UHC-41549-61UNKNOWN(825) 596-9663UNKNOWN226 Ocean Ave·OrlandoFL32861GRP-2544—
CLMCLM-4056052026-05-30T23:45:17ZADAM—VASQUEZ1978-12-15UHC-91157-09•••-••-4951(397) 428-7745UNKNOWN9625 Hillcrest RdCHARLOTTENC28263·GRP-0117-··
CLMCLM-4002412026-05-03T10:36:07ZRyan—Morris1952-04-13UHC-89195-88-(807) 882-1678—2497 Church StAtlantaGA30350—SELECT-EPO
CLMCLM-4229682026-08-23T12:55:31ZBrooks, Barbara——1996-11-13UHC-35893-48•••-••-0481UNKNOWNNULLN/A——··—NAVIGATE-HMO··
CLMCLM-4020552026-02-10T21:31:31ZWalter—Oretga11/18/60UHC-32319-15•••-••-7402—walter.ortega@icloud.com·3191 Elm StSAN ANTONIOTX78296nullNULL
CLMCLM-4239522026-01-17T13:53:13ZReed, Ann——1969-04-14UHC-75559-79NULL····NULL—N/A····GRP-8125-
32,829 rows, page 70 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:37.727Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty