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-4311122026-08-16T23:56:05ZPatricia—Burns·1954-03-14UHC-97556-39·-(814) 253-4914—8332 Washington Street·San DiegoCA·92177GRP-9022N/A
CLMCLM-4061872026-04-16T00:53:33ZEugene—Sanchez20000706UHC-18080-63—+1 885 814 8913N/A·2820 Palm DriveFresnoCA93729GRP-0824—
CLMCLM-4128282026-04-30T22:55:31ZCHARLOTTE··—WASHINGTON2007-01-27UHC-47321-13•••-••-2153-—7562 Union StreetSeattleWA98172—-
CLMCLM-4259052026-01-16T13:03:54ZJanet—Padilla1974-06-13UHC-27801-36NULL940-498-1769null5221 Washington StScottsdaleAZ··UNKNOWNUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4251562026-05-03T02:44:47ZMryPOlson1959-05-05UHC-41659-11····UNKNOWNNULL·853 FOREST AVENUEOrlandoFL32830GRP-2325NAVIGATE-HMO··
CLMCLM-4186892026-07-16T06:18:51ZBilly—AndersonMay 10, 1984N/AUNKNOWN··786-747-3559·UNKNOWN6050 PARK PLACESacramentoCA95881···GRP-1554—
CLMCLM-4203062026-10-15T01:16:09ZSANDRA—JACSKON01/25/64UHC-78773-38NULL(628) 832-6945———null—·GRP-5599N/A
CLMCLM-4045582026-09-21T06:47:41ZBeverly—Nunez11/16/1983-•••-••-5271NULL·UNKNOWN·3434 SPRING STREETNASHVILLETN37226GRP-3380—
CLMCLM-4206222026-02-17T06:15:21ZWillie—Yang·1983-02-18NULLUNKNOWN—NULL3924 JEFFERSON AVENUEMiamiFL33137··GRP-2768····
CLMCLM-4260492026-02-21T06:29:24ZSARAH—LI24-03-1946UHC-49550-89——··4849 Mesa DrChandlerAZ85232··GRP-6458CORE-HMO
CLMCLM-4312222026-07-30T09:37:15ZDonna····Morris2003-07-27····——NULL7992 ELM STREETNashvilleTN37284GRP-5225·-
CLMCLM-4007352026-10-07T02:24:18ZEmma—Henry1980-04-13UHC-50050-99—N/AEMMA.HENRY@AOL.COM9496 Cedar LnPLANOTX—GRP-7668CORE-HMO
CLMCLM-412923 2026-03-11T05:31:09ZRice, Timothy—·····1947-03-03UHC-83864-45-—timothy.rice19@aol.com4346 River RdPlanoTX75095GRP-4315MEDICARE-ADV-A
CLMCLM-4082382026-05-17T22:10:18Z JULIA—ESTRADA12/16/1999null·N/A841-942-8442julia.estrada@yahoo.com9472 Bayshore Dr #137San DiegoCalifornia-GRP-9803MEDICARE-ADV-A
CLMCLM-4115862026-10-09T09:48:37ZLaura—Ramirez09-01-1953UHC-52343-50•••-••-3508null-2889 PINE DRMiami·FL33194GRP-6339NULL
CLMCLM-4039692026-02-09T21:45:46ZHIROSHIMDEAN01/21/1990UHC-65896-87UNKNOWNnullnull4880 Mountain View DrAustin··Texas78737GRP-1483—
CLMCLM-4229192026-04-27T18:50:38ZAlexisWParker26-11-1988—N/A4048602689—2479 Harbor BlvdAUSTINtx···78796-7684GRP-9974·-
CLMCLM-4286082026-04-21T18:54:27ZLawson, Madison——1995-11-02-N/A··—NULL·8044 Elm StTEMPEArizona85283GRP-4595MEDICARE-ADV-B
CLMCLM-4027112026-08-17T03:54:36ZGardner, Kayla——1963-11-25-NULL(955) 296-0036-7259 Sunset BlvdPhoenixArizona85005GRP-2418SELECT-EPO
CLMCLM-4133892026-10-15T20:02:40Z KaylaSRichards1963-04-10N/A•••-••-1030(737) 903-5610kayla.richards@gmail.com6710 Mountain View DrSan AntonioTX78273GRP-7307NULL
CLMCLM-4045712026-02-17T15:00:57ZSUSAN—PEREZ·7/28/1949UHC-63932-33N/A—-4019 SAGE CTNashvilleTN·37255GRP-3588UNKNOWN
CLMCLM-4275392026-05-06T06:37:13ZMEI··LANE03/21/1968N/A—N/ANULLUNKNOWNUNKNOWNNULL—GRP-4847null
CLMCLM-4143192026-09-24T08:38:39ZJulie—Marshall9/2/2006-—613-242-9319—·9072 Pine DrDallasTX75264GRP-4517MEDICARE-ADV-A
CLMCLM-4158242026-08-15T22:35:33ZARJUNXROBINSON··2004-09-19UHC-13026-76··•••-••-1356UNKNOWN-7011 Forest AveTucsonAZ85718——
CLMCLM-4176372026-07-01T13:43:42Zanthony—elliott1957-04-07UHC-53370-86··•••-••-6538—ANTHONY.ELLIOTT@ICLOUD.COM9767 Willow CourtGLENDALEArizona85381NULLCORE-HMO
CLMCLM-4248542026-10-11T21:38:35ZButler, Thomas——1894-05-27UHC-27322-96•••-••-7294234.278.4349-7572 Central AvenueScottsdaleAZ·85242GRP-6157··
CLMCLM-4038402026-09-25T22:35:31ZBrittany—Alvarez1975-01-10··UHC-71038-53null603.656.0106—2635 RIDGE ROADOrlandoFL32870-NAVIGATE-HMO
CLMCLM-430261 2026-09-17T07:59:52ZJennyfer··—Webb··03/07/2007UHC-32803-28•••-••-4873UNKNOWNnull2087 Mesa DriveFresnoCA93716GRP-9584CORE-HMO
CLMCLM-4097002026-10-05T05:44:27ZWalsh, William——03/25/1983UHC-07070-34··•••-••-0631-—8684 Spring StMesa·AZ85296GRP-3424-
CLMCLM-4115752026-10-08T04:22:02ZSHIRLEY······JENSEN··1957-03-15UHC-92914-52NULL(448) 926-8805—3189 PINE DRGlendaleAZ85375GRP-1115NULL··
CLMCLM-4006582026-02-22T02:13:57ZGarret, Lawrence——1982-07-27UHC-83755-59•••-••-7133860-677-4695—6007 Broadway··TampaFL33687·GRP-9782-
CLMCLM-4034672026-07-07T10:14:35ZDOROTHY—MURPHY2/8/2007—UNKNOWN9012272654UNKNOWNN/A--·-GRP-6743—
CLMCLM-4217392026-08-23T01:16:00ZHelenFSaantiago19590606UHC-09958-06•••-••-649613743528975NULLNULL··—UNKNOWNUNKNOWNnull-
CLMCLM-4067092026-05-02T07:23:21ZDOUGLAS··SCHULTZ1954-10-05UHC-05331-95•••-••-9675UNKNOWN—3506 BASELINE ROADMIAMIFL33103GRP-6516UNKNOWN
CLMCLM-4133902026-08-09T04:36:42ZJANICE—BUTLERJun 26, 1973UHC-65173-31·NULLUNKNOWN—nullnull-nullGRP-9772MEDICARE-ADV-A
CLMCLM-4207972026-05-04T02:02:29ZJack······Kelley··5/5/1960—•••-••-2973—JACK.KELLEY@HOTMAIL.COM6336 SPRING STREETAustinTX78736GRP-5499SELECT-EPO
CLMCLM-4265092026-05-19T11:47:24Z·Lisa—Bishop2005-12-28UHC-04368-24··—19787156629NULL9579 Oak StPlanoTX75011GRP-0189null
CLMCLM-4133112026-02-07T20:54:46ZPRIYA—ROGERS19730422UHC-59829-72•••-••-4242UNKNOWN··N/A—nullNULL-GRP-0889—
CLMCLM-4197862026-07-20T22:43:09Z VALENTINA··—ESTRAADA1981-09-40UHC-41804-64•••-••-8159NULLN/A—null—UNKNOWNGRP-1515MEDICARE-ADV-A
CLMCLM-4147182026-10-05T14:32:01ZBrandon—Fernandez06-09-1986UNKNOWN•••-••-9957NULLN/A·4574 Canyon RoadSEATTLEWA98186GRP-1655NULL
CLMCLM-4218342026-09-08T16:47:36ZOLIVIAVHOWARD1976-06-04UHC-51459-51null··4017921329-··3919 Ocean AvenueMESAAZ85223GRP-3894MEDICARE-ADV-A··
CLMCLM-4130412026-05-22T08:54:37ZJeremy—Snyder1988-04-05——4686701391··null··106 WASHINGTON STREETDENVER··CO80272-CORE-HMO
CLMCLM-4177652026-02-19T18:06:05ZMASON—ROSE1948-06-12—-—N/A—NULL·NULL—GRP-9070CORE-HMO
CLMCLM-4327232026-03-20T03:13:11ZLinda—Bishop1943-05-16UHC-76949-11•••-••-9066(454) 700-7895N/A1478 Maple AvenueJacksonville··FL32238GRP-2063N/A··
CLMCLM-432212 2026-09-21T14:44:03ZPAULDALVARADO1972-12-07UHC-77051-61—N/A·UNKNOWN1241 CHURCH STREETTucsonAZ85754GRP-0317UNKNOWN
CLMCLM-4097062026-07-04T10:17:46Z BRIANVREID·19720413UHC-22030-18——N/A··7920 Valley View Drive·OrlandoFL··32843GRP-6281··N/A
CLMCLM-4188852026-07-22T13:58:25ZAmanda····Campbell1968-08-28UHC-76091-62•••-••-5992——5649 Camelback RoadMesaAZ85295GRP-6262NAVIGATE-HMO
CLMCLM-4275692026-01-18T05:43:21ZJoshuaIGibson1987-11-05UHC-80149-44•••-••-1597—UNKNOWN4752 Washington StTEMPEAZ·85232null—
CLMCLM-4117512026-09-08T05:32:07ZEMILY—THOMPSON2/27/1964UHC-60492-22—858-356-0260N/A7291 Mesa Drive Apt 35CharlotteNC28216GRP-0562—
CLMCLM-4204472026-01-06T13:19:43ZPATRICK··BOYD05/24/1977NULL•••-••-3975N/A—7545 Mesa DrMesaAZ-GRP-2893MEDICARE-ADV-A
32,829 rows, page 184 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.624Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty