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
CLM CLM-4211122026-06-17T02:32:42ZWarren, Douglas——9144-09-25UHC-53814-57•••-••-19627724608··—9292 BroadwayOrlandoFL32808-4877GRP-3700—
CLMCLM-4094502026-08-13T10:00:57ZRachelQ·Walker06-02-1968UNKNOWNN/A——6585 Maple AveChandlerAZ··UNKNOWN—UNKNOWN
CLMCLM-4292972026-10-03T13:10:12Zroger—martin1998-05-15UHC-19292-65—UNKNOWNNULL··NULL—UNKNOWNnullUNKNOWN
CLMCLM-432794 2026-09-12T19:27:56ZStephen—Murray··1962-05-26UHC-92761-01•••-••-2349nullN/A4148 Main StSEATTLEWA—GRP-5620N/A
CLMCLM-4008962026-09-24T22:17:01ZLORIC.DIXON2309-19-93UHC-20645-16··—-—2347 SUNSET BOULEVARDPlano··TX—GRP-3238SELECT-EPO
CLMCLM-4178412026-02-26T17:35:32ZCHARLOTTEXPIERCE09/24/2005UHC-68485-08•••-••-3782581-669-4638CHARLOTTE.PIERCE6@PROTON.ME2069 Valley View Drive Apt 33Sacramento··CA95879——
CLMCLM-4325252026-03-13T12:11:17ZSANDRA—GUZMANAug 9, 1945uhc-12290-92-(518) 733-2117—3250 Indian School RdMiamiFL33177·GRP-6503NAVIGATE-HMO
CLMCLM-4032382026-01-22T05:15:19Z Richard—Luna1986-01-18UHC-69234-20•••-••-7373—N/A2149 Mesa DriveJacksonvilleFL32267NULLnull
CLMCLM-4128712026-08-17T20:19:19ZNancyLTran5/4/1967UHC-46507-42•••-••-3832NULLnull·3686 UNION STPhoenixAZ85010UNKNOWNNULL
CLMCLM-4017582026-09-13T22:30:59ZTIMTHILL11/08/2009UHC-07622-22•••-••-8758—UNKNOWN7501 Grand AveMinneapolisMN··55491-OPTIONS-PPO
CLMCLM-4071232026-01-29T16:38:29ZGERAD··KENNEDY·1977-03-10N/A-385-806-0050null—NULLnull—GRP-8665—
CLM CLM-4179952026-09-24T08:48:34ZAdam—Lewis5/17/1977UHC-06334-32•••-••-7772null—5302 Indian School Road·AustinTX78729GRP-1581MEDICARE-ADV-B
CLMCLM-4048682026-09-04T09:33:22Z·Jesse—Berry5/21/1963UHC-34766-81•••-••-2243796-420-0802NULL··823 Harbor BoulevardEden PrairieMN55337GRP-3869CHOICE-PLUS-PPO
CLMCLM-4102172026-07-05T09:26:48Z·DAVID—YANG2008-01-27NULL····UNKNOWNNULL7936 Park PlaceAtlantaGA30313—MEDICARE-ADV-B
CLMCLM-4223192026-08-23T10:32:10ZRYANDREED1595-01-18UHC-08268-31•••-••-7823··-··7022 Elm StCharlotteNC·28289N/AMEDICARE-ADV-B
CLMCLM-4301782026-05-20T16:39:33ZETHANE—01-03-1961UHC-07381-68—·758-381-1982null8361 INDIAN SCHOOL ROADNashvilleTN37248····—
CLMCLM-4083232026-09-30T17:26:37ZLARRY····JONES6/4/1950UHC-94064-39UNKNOWN-—6613 Jefferson AvenuePlanoTX75089GRP-9933MEDICARE-ADV-B
CLMCLM-4163072026-07-24T05:42:31ZVirginiaQ··Hunter1968-02-24UNKNOWN•••-••-63377402839156-3867 BroadwayTAMPAFL33638-UNKNOWN
CLMCLM-4200692026-03-31T02:18:21ZEMMAA·RAMOS1960-08-12UNKNOWNUNKNOWN+1 928 876 2075emma.ramos@icloud.com6476 SUNSET BOULEVARDCharlotteNC··28260GRP-1997-
CLMCLM-4209692026-01-09T14:15:34Z·MELISSA—MARSHALL1998-06-13UHC7396039———4529 GRAND AVE··MinneapolisMN55492-7983GRP-0971····
CLMCLM-4287142026-06-18T06:42:48ZOmar—Cruz1940-02-18UNKNOWN•••-••-76405687368832N/A4576 JEFFERSON AVENUEPhoenixAZ··85002·N/AUNKNOWN
CLMCLM-4171672026-04-09T06:52:56ZMatthew—Williamson1955-12-05UNKNOWN—UNKNOWN····4340 HARBOR BOULEVARDHOUSTONTX77052-7311—UNKNOWN
CLMCLM-4043182026-05-10T04:56:47ZAngelaTWagner1951-05-16··————·N/Anull—N/AGRP-9777OPTIONS-PPO
CLMCLM-4097202026-02-02T19:03:45ZDanielle—TorresSep 16, 2003UHC-36695-30null(855) 832-4572—4732 WILLOW CTCHANDLERAZ85293GRP-1270null
CLMCLM-4126822026-04-09T08:13:05ZLee, Luis—····1965-04-28-UNKNOWN·(264) 582-7180UNKNOWN—UNKNOWN··NULLNULLGRP-7019OPTIONS-PPO
CLMCLM-4168572026-03-23T06:12:10ZTERRYI.RICHARDSON1984-07-04UHC-96410-44N/ANULLNULL921 Main StCHANDLERAZ85220GRP-7595—
CLMCLM-4230182026-01-11T22:00:34ZBradley—Carlson6/21/1951UHC-48617-01NULLN/AnullN/A····—UNKNOWN——
CLMCLM-4225822026-04-04T10:12:00ZJohn—Hughes1947-09-08UHC-46207-33null328.335.2963null1769 Mesa DriveTempeAZ85216··GRP-6416··CORE-HMO
CLMCLM-4057892026-01-04T13:03:23ZSTEPHEN—LEWIS1958-03-04UHC-80754-67UNKNOWNUNKNOWN-··7899 Church StMiamiFlorida··33177GRP-5956—
CLMCLM-4287052026-05-18T04:23:58ZCarlson, Kathryn——12/07/1939—•••-••-08845548083216··—2320 Highland AvenueLas Vegas··NV89109··GRP-9965·CORE-HMO
CLMCLM-4070172026-09-08T04:51:23ZdavidG.henry01/25/1964UHC-48679-36—N/AN/A·4431 HARBOR BOULEVARDCharlotteNC28202-5659GRP-4908OPTIONS-PPO
CLMCLM-4134792026-02-26T03:08:42Z·Carol··Gonzalez12/08/89N/A—(549) 461-4146··carol.gonzalez@yahoo.com6677 Cedar LnPhoenixAZ85098GRP-6923NAVIGATE-HMO
CLMCLM-4310352026-02-04T16:23:38ZRobert—Patterson1982-10-18UHC-46621-18null·803-870-0883UNKNOWN··8502 Ridge RdPHOENIXAZ85004-6334GRP-0612CHOICE-PLUS-PPO
CLMCLM-4261712026-03-13T00:10:05ZRyan—·Nunez1992-02-02UHC-99721-27—-UNKNOWN—-null—UNKNOWN····
CLMCLM-4086892026-07-11T16:10:01ZEugene—Watkins17-10-1997UHC-86450-26-701.829.3443UNKNOWN9178 PARK PLACESCOTTSDALE·Arizona85294GRP-1587MEDICARE-ADV-A
CLMCLM-4212432026-04-16T21:06:19ZBarbara—Aguilar1997-08-24UHC-82036-55—-—4233 Ocean AvenueSeattleWA98179GRP-5733—
CLMCLM-4300862026-06-12T20:23:57ZButler, Amy——·Jun 20, 1959—•••-••-2753nullnull··1003 Harbor BoulevardTUCSONAZ85753UNKNOWNMEDICARE-ADV-A
CLMCLM-4109092026-09-07T16:42:08ZCarol—HughesFeb 28, 1979NULL···NULL—UNKNOWN2280 Bayshore DrSeattle·WA98128·NULLN/A
CLMCLM-4301622026-01-09T08:01:06Z·Matthesw—AlexisJul 24, 1973UNKNOWN•••-••-7720(425) 542-7194—676 Main StAtlantaGA30391GRP-8658NAVIGATE-HMO
CLMCLM-4126622026-06-29T23:25:25ZKATHLEEN—WRIGHT1949-05-25UHC-81490-13nullN/A—4168 Oak StreetFresnoCA93768GRP-9323MEDICARE-ADV-B
CLMCLM-4170422026-08-28T18:01:35Z Joe—Turrner01-12-1987UHC-14898-27•••-••-520713745157975joe.turner@hotmail.com··55 UNION STCharlotteNC28296GRP-7875····
CLMCLM-4178682026-06-23T00:04:16ZAndrea··—Hanson1971-11-09UHC8958764··533-746-5441andrea.hanson@hotmail.com8510 CAMELBACK ROADPLANOTX75012GRP-7933MEDICARE-ADV-A
CLMCLM-4207352026-07-04T02:35:33Zchristopher—lucas1946-01-07null——christopher.lucas@hotmail.com6316 Lincoln WayMinneapolisMN55429NULLUNKNOWN
CLMCLM-4123732026-06-24T00:27:22ZMateo—OBrien1969-03-09UHC-64674-51—UNKNOWNnull····—UNKNOWN··GRP-3392null
CLMCLM-4068322026-10-03T12:15:13ZPhilpi—WoodsFeb 24, 2001N/ANULL987.717.7326-8935 VALLEY VIEW DRIVEEden PrairieMN55320-2048GRP-9742CHOICE-PLUS-PPO
CLMCLM-4149722026-09-29T22:52:41ZAmanda—Parker02/27/1947UHC-47167-27N/A2938298489—2487 Apache BlvdDenverCO80204-3843UNKNOWNnull
CLMCLM-4222092026-08-11T18:31:15ZVINCENT—MORGAN·06-08-1986—•••-••-41676019759013NULL6852 Union StPhoenixAZ·85097GRP-1015N/A
CLMCLM-4321642026-02-24T05:41:01ZRachel··Holmes1982-08-28null····—null9194 Desert Sky Blvd Apt 19Los AngelesCA·90001-9992GRP-4346-
CLMCLM-4008142026-07-05T11:02:08ZJeffSDixon2007-02-12UHC-80198-85•••-••-4942—NULL3804 Hillcrest Rd··MesaAZ85223···N/AN/A
CLMCLM-4145142026-10-13T13:40:16ZLucia—Harrison1982-05-25UHC-97007-42—--··null—····GRP-8804CHOICE-PLUS-PPO
32,829 rows, page 39 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.685Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty