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-4312522026-04-28T07:44:18ZBarbara—Cox1962-01-13UHC-93560-89•••-••-01384684654934barbara.cox12@outlook.com·1468 Hillcrest RoadCOLUMBUSOH43234··—null··
CLMCLM-4005592026-06-01T19:52:06ZMateo··—Espinoza03/21/1979—•••-••-65017177346822—2755 CENTRAL AVENUEAUSTIN·TXnullGRP-9574-
CLMCLM-4188562026-08-17T09:08:41ZKYLEO.BRYANT16-09-1976UHC-45658-55UNKNOWNN/A—3140 Ocean AvenueNASHVILLETN37281GRP-1755—
CLMCLM-4187142026-03-06T05:19:42ZSmmith, AustinS.—2007-09-13UHC-95971-84•••-••-1072NULL—8639 Lincoln WayJacksonvilleFL32272-2071NULLMEDICARE-ADV-B··
CLMCLM-4001282026-08-22T21:00:25Zwilliam—den1981-02-50UHC-57472-02NULL(220) 690-1779N/A8983 SPRING STREETAustinTXnullGRP-2294····
CLMCLM-4143842026-06-17T06:39:54ZDOUGLAS—MENDEZDec 11, 1947-··•••-••-5864NULL—5921 WASHINGTON STREET·MiamiFlorida·33188GRP-9992NAVIGATE-HMO
CLMCLM-4193512026-06-10T10:27:23ZMARILYN—RAY1980-11-13UNKNOWNNULLUNKNOWN-··6694 Sage CtCharlotteNC28294GRP-5388N/A
CLMCLM-4048272026-01-23T10:39:41ZROBERTS.DUNN20-07-1951UHC-95326-41··•••-••-5031398-755-3995——UNKNOWNN/A—UNKNOWNMEDICARE-ADV-A
CLMCLM-4079672026-08-19T06:56:47ZEvelyn—Perry1955-01-16·UNKNOWNNULL7919756841····4210 RIDGE ROADFresnoCA93734——
CLMCLM-4218072026-04-13T00:04:53ZWayneBLee·01/02/1949UHC-57483-83—N/AN/A—NULLN/A——N/A
CLMCLM-4130132026-05-11T21:23:06ZRoger—Holmes··1977-08-03--—NULL289 Grand Avenue·Los AngelesCA·90087GRP-5468NAVIGATE-HMO
CLMCLM-4104052026-01-10T11:46:24ZDEBORAH—SMITH·1955-02-11—•••-••-940514476415070null805 Market StreetPlanoTX75081N/A-
CLMCLM-4204962026-03-20T18:05:41ZALBERT—SANDERS02/17/86UHC-40942-62•••-••-1525—N/A3148 Lincoln WayColumbusOH43258-null
CLMCLM-4051862026-04-07T20:06:20ZYUKIHHUNT1957-05-23——731-671-7973NULL··1761 Baseline RdTucsonAZ85774·NULLN/A
CLMCLM-4013902026-01-14T22:18:10ZSCOTT—EVANS19390808UHC-99603-38•••-••-91677517417209UNKNOWNNULLUNKNOWNNULL—-—
CLMCLM-4274682026-09-13T12:36:01ZPriya—Bowman19850627UHC-20261-11··-—NULL8188 Willow CourtNASHVILLETN37260GRP-9749N/A
CLMCLM-4136602026-07-26T00:34:40ZDannyL··Sanchez2004-03-03NULLN/A·nullNULL6681 Lake View RoadAustin·TX78782—UNKNOWN
CLMCLM-429227 2026-10-12T13:32:48ZPAMELA··—RUSSELL8/22/1939UHC-06760-29•••-••-0501——9042 Sunset BlvdChandlerAZ85291GRP-2085-
CLMCLM-4307902026-10-06T20:08:11ZCamila—Russell11/10/08UNKNOWN—(941) 774-3586null4980 Valley View Dr·MesaAZ·85240-0921GRP-5697—
CLMCLM-4196552026-07-23T09:15:42ZSaamuel—Fields1973-02-01nullnull690-822-9153UNKNOWN2094 Desert Sky BoulevardFRESNOCA··93725GRP-0117NULL
CLMCLM-4131452026-09-13T05:32:44ZMichael—Chapman9/1/1960UHC7896031--······3528 Bayshore DriveTampaFL33698GRP-2570MEDICARE-ADV-B
CLMCLM-4099242026-05-22T18:12:27ZRussell····Marquez1962-03-11UHC-20668-29-——2146 Mesa DrScottsdale··AZ85285-9079GRP-6898MEDICARE-ADV-A
CLMCLM-4197642026-06-28T22:21:35ZOlivia—Fulleer2000-11-15UHC-49543-71··•••-••-2808(593) 726-4366—3435 Ridge RdPlanoTX75079GRP-4942-
CLMCLM-4185852026-06-25T23:22:05ZChristian—Chavez1996-01-20UHC-18389-73NULL503-792-0366—7834 Oak Street #917SeattleWashington98113GRP-1911OPTIONS-PPO
CLMCLM-4090652026-09-07T07:47:30ZkennethXcarroll1972-07-18··—(277) 667-4397—5265 Maple AvenueDallas·Texas75298GRP-8390—
CLMCLM-4308602026-01-17T03:04:56ZBenjamin·K.Vasquez4/10/2006UHC-82637-55N/A(304) 209-5884NULL·5631 Mountain View Dr Apt 34OrlandoFL32879N/A—
CLMCLM-419702 2026-02-16T04:57:03ZJesseVPenaJul 12, 1982uhc-77062-43NULLnullN/A9522 OAK STREETLAS VEGASNV89171·NULLSELECT-EPO
CLMCLM-4063152026-07-21T17:03:02ZSantiago—Olivar2001-09-27··—-752-363-3157—2408 CHURCH STREETOrlandoFL32861null··UNKNOWN··
CLMCLM-4207042026-06-08T22:34:18ZJuan—Hunter02/24/2000—•••-••-6515N/A—7276 Lake View Rd·MesaAZ85266GRP-0963-
CLMCLM-4037402026-01-07T13:03:55ZCunningham, Gerald····—06/15/83——539-215-4718—7237 CAMELBACK RD Apt 4NASHVILLETN37295UNKNOWNUNKNOWN
CLMCLM-4248922026-05-19T00:44:00ZCheryl—Thomas2004-07-05UHC-65987-55•••-••-8344345.854.2994··-8717 RIDGE RDHoustonTX77047GRP-3490MEDICARE-ADV-B
CLMCLM-4186272026-02-20T04:19:06ZJohnT.Ramos··1994-07-07—null2086278814··null——UNKNOWNGRP-4294NAVIGATE-HMO
CLMCLM-4299662026-05-25T08:42:25ZJulia L—Boyd1948-03-02UHC-64928-95•••-••-5479·19887337836—4048 Union StDallasTX75264GRP-0555CORE-HMO
CLMCLM-4157412026-08-28T15:35:19ZJNATHAN···LI1953-03-23-———5572 Mesa DriveCharlotteNC28206··GRP-5090OPTIONS-PPO
CLMCLM-4062252026-10-10T17:08:59ZArthurMThompson09/20/41·UHC-87768-94—7646388935UNKNOWN4865 Elm StreetAtlantaGA·30373-9670NULL····
CLMCLM-4192892026-03-29T18:16:42ZTheresa—Carroll2008-02-25UHC-53618-98•••-••-0228(630) 326-9239NULL-UNKNOWN—NULLGRP-6398null
CLMCLM-4096432026-04-25T22:24:13ZGERALD—NICHOLS·1956-12-02—•••-••-0336(225) 272-2408··N/A592 BroadwayLos AngelesCA90092-5227——
CLMCLM-4251912026-04-24T10:22:19ZWells, Bradley··——1980-12-02··UHC-44434-27··•••-••-9784N/A··UNKNOWN1813 Elm StJacksonvilleFL32280—·NAVIGATE-HMO
CLMCLM-4270842026-07-23T18:40:24ZSarah—Garcia1948-11-24null•••-••-3313NULL—4211 Market St·Eden PrairiemnNULLnullCHOICE-PLUS-PPO
CLMCLM-4250612026-10-02T04:30:23Z Ashley—Carr1959-05-18UHC-40523-42—911.871.7429—1946 Meadow LnJacksonvillefl32253GRP-7402SELECT-EPO
CLMCLM-4110602026-07-26T19:38:54ZFatima—Collins19991224··UHC-63611-25•••-••-4377——9073 Lincoln WayDenverCO—GRP-2026NAVIGATE-HMO
CLMCLM-4083032026-05-18T02:47:59ZWebb, KaylaG—1975-12-06-•••-••-1196NULLkayla.webb@icloud.com8894 BROADWAYGILBERTAZ85280—MEDICARE-ADV-B
CLMCLM-4295032026-04-24T11:15:26ZSue—Boyd1977-11-01UHC-70334-03UNKNOWN8508805075-————-—
CLMCLM-4107452026-07-18T18:07:00ZJoan, VegaP—1975-02-05—•••-••-8963745-997-1291NULL2744 Market StreetGlendale·AZ85331-8059-—
CLMCLM-4134812026-09-28T19:25:37ZDOROTHY—GUTIERREZ1962-06-12UHC-83717-49——N/A7334 Main StNashvilletn37234UNKNOWNSELECT-EPO
CLMCLM-4307892026-03-04T18:24:59ZCHRISTIAN—ANDERSON19390709N/A•••-••-1233··—2042 Washington StORLANDOFL-·UNKNOWNNAVIGATE-HMO
CLMCLM-4214252026-10-12T14:26:10ZKEITH··SSCHULTZ··01/23/1940—•••-••-1611NULL——————MEDICARE-ADV-A
CLMCLM-4203792026-06-02T20:59:32ZGeorge—Weaver03/13/61N/A•••-••-5675——6059 Bayshore DrSAN ANTONIOTX·78243-5769GRP-6787—
CLMCLM-4148042026-02-07T23:25:40ZBradley·KWeber06-10-1989NULL•••-••-5167——7366 River RdPhoenixAZ85010GRP-3822UNKNOWN··
CLMCLM-4256672026-09-26T13:58:23Zlisa—williamson1956-04-04·NULLnull885.553.7555—6819 PARK PLSan AntonioTX78253-8601GRP-6128null
32,829 rows, page 82 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.750Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty