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-4138272026-07-09T10:44:08ZBrian—GarrettMar 24, 1939UHC-67755-21—NULL—4576 Lake View RdHoustonTX77061GRP-3162UNKNOWN
CLMCLM-4012502026-08-16T09:29:29ZThomasJ.Griffin1986-12-03UHC-79604-64•••-••-8369824.942.0572····3794 MOUNTAIN VIEW DRIVECHARLOTTENC28247GRP-1063CORE-HMO
CLMCLM-4203442026-08-03T18:32:11ZDavidR.··Yang·05/10/1947UHC-30445-94•••-••-666913884721360··-1680 Jefferson AveNashvilleTennessee37270—SELECT-EPO
CLMCLM-4223592026-04-24T13:42:52ZNANCYG.WILLIAMSONApr 6, 1962N/AUNKNOWN-NULL1452 Cedar LaneGlendale··AZ··85379GRP-3061medicare-adv-b
CLMCLM-4261062026-06-20T10:59:38ZRachel—Wagner··1998-08-17nullnull3979171752··6652 Meadow LnEden PrairieMN55337··NULLSELECT-EPO
CLMCLM-4300452026-07-25T02:04:20ZSophia····Long02/07/1941uhc-32948-05•••-••-6169933.253.6532··—4154 Mesa DrEden PrairieMN55324··GRP-0650-
CLMCLM-4102782026-08-30T22:48:05ZAngelaJFoster05/22/1989—•••-••-0785··—5359 Baseline RoadSan AntonioTX78284··N/A··—
CLMCLM-4022812026-04-14T08:53:49ZKelley, HiroshiN····1977-12-16UHC-89921-68nullnull—1459 Jefferson AvenueMiamiFL-GRP-5940—
CLMCLM-4243462026-05-23T00:46:18Z·Camila—Harvey12-04-1982UHC-55326-27—9896133611NULL1247 MESA DREDEN PRAIRIE·MN55399GRP-5700MEDICARE-ADV-A
CLMCLM-4245362026-07-31T07:17:48ZBEN—THOMAS07/14/00UHC3848029NULL—-1402 Hillcrest RdTempeAZ85248······
CLMCLM-4133832026-05-04T00:00:53ZRobert—Jordan8/3/2006nullnullUNKNOWN—6592 HIGHLAND AVEMinneapolisMN55431GRP-8490—
CLMCLM-400157 2026-06-29T01:45:14ZMATEO—LAWSON·1960-10-05—•••-••-3105(832) 477-2521null9381 Elm StreetJacksonvilleFL32219··GRP-3524NULL
CLM CLM-4318122026-10-06T21:59:17Zlucia—robertson09/01/85UHC-90498-98··•••-••-0542599-314-5405N/A4263 Cedar Ln·TempeAZ85289-0667—SELECT-EPO
CLMCLM-4049022026-04-03T02:38:20Zgerald—cox1971-10-05·UHC-87483-13•••-••-4262NULLgerald.cox4@yahoo.com5111 Canyon RoadPlano···TX75044GRP-6143null
CLMCLM-4243912026-07-26T23:18:24ZDanielle·FPatterson1947-08-04UHC-68603-82•••-••-5891746.596.3510-··———nullNULLNULL
CLM CLM-4073922026-07-20T13:50:02ZAhmedRCastillo10/11/1958UHC-03288-31•••-••-4184-··N/A8556 Hillcrest RdLas Vegasnv89187GRP-8904MEDICARE-ADV-B
CLMCLM-4178422026-08-20T17:02:43ZANGELA—WAGNER1963-08-06UHC-33234-79——angela.wagner@hotmail.com7213 Highland AveMINNEAPOLISMNnullN/AMEDICARE-ADV-B
CLMCLM-4242962026-08-27T09:42:25ZJULIAHRYAN·1955-06-12UHC-35022-68•••-••-8038(769) 314-2904NULL5279 Canyon RoadMesaAZ85202GRP-2477NULL
CLMCLM-4042182026-01-29T07:05:57ZDANIEL—MATTHEWS··1942-11-06UHC-84431-15•••-••-5965—null6458 WASHINGTON STREETMiamiFL33190GRP-1133null
CLMCLM-4065372026-10-08T04:29:52ZASHLEY··—OWENS19461025UHC-03541-20•••-••-9944—-null—UNKNOWN··NULLGRP-2776CORE-HMO
CLMCLM-4302722026-02-20T16:22:54ZPaulGLynch2005-03-22N/A•••-••-1317N/A-6421 Park Place··Los Angeles·CA90054GRP-7983null
CLM CLM-4208222026-06-06T07:31:53ZLogan—Ruiz2006-12-13UHC-90013-58UNKNOWNNULLN/A··7672 Main StEden PrairieMN55339GRP-7205—
CLM CLM-413819 2026-05-28T11:56:48ZANN—SALAZAR1991-01-03UHC-52249-72•••-••-6369NULLUNKNOWN4627 Union StPhoenixArizona85089N/A··MEDICARE-ADV-B
CLMCLM-4205392026-04-12T00:40:10ZFrank—Burton1964-11-25UNKNOWNUNKNOWN··UNKNOWN—7178 Indian School RdMinneapolisMN55493GRP-3189··OPTIONS-PPO··
CLMCLM-4260282026-06-19T17:08:32Z·johnMhayes2002-11-20UHC-59901-87-(890) 877-7429-2300 BroadwayTampaFL33631GRP-3610-
CLMCLM-4015422026-07-19T05:40:26Z SANTIIAGO—FORDDec 11, 1994UHC1953120NULLnullN/A-—-—GRP-2607MEDICARE-ADV-A
CLMCLM-4165452026-04-26T13:40:47Z·Christopher—Adams1945-11-23UHC-52332-69·UNKNOWN·(937) 743-3810—301 CHURCH STDenverCO80272-1909GRP-9996SELECT-EPO
CLMCLM-4158382026-09-26T01:45:24ZAngela—Cook2008-11-05UHC-30513-36•••-••-3864UNKNOWN—8553 Valley View DriveLos AngelesCA90032—-
CLMCLM-4083212026-02-17T14:51:15ZGregoryLPierce19410414UNKNOWNNULL(756) 782-0684null—null-———
CLMCLM-4256562026-04-01T06:31:29ZJACK—KENNEDYMar 14, 1955N/A•••-••-5682UNKNOWN—1930 VALLEY VIEW DROrlandoFL32880—OPTIONS-PPO
CLMCLM-4319992026-09-09T19:56:52ZRALPH—MEJIA1955-01-02UHC-24782-47•••-••-6947·null——N/A——UNKNOWNMEDICARE-ADV-A
CLMCLM-4163232026-03-22T16:18:23ZJim—Myers1980-04-20UHC-80186-79•••-••-8514880-795-9639—493 MARKET STREETMiamiFL33185··GRP-9925··—
CLMCLM-4285982026-08-10T16:39:23ZDONALD··—GOMEZ1938-04-07null·-····UNKNOWN6300 OCEAN AVENUEPlanoTX75011GRP-1428—
CLMCLM-4140892026-01-31T20:03:09ZTyler—Adams1959-02-25UNKNOWN•••-••-9697——2455 Lake View RoadMesaAZ·85244-CHOICE-PLUS-PPO
CLMCLM-4162292026-08-27T15:35:01Zchristine····wells1940-04-05UHC-72085-61····—NULLUNKNOWNUNKNOWN——GRP-0709NULL
CLMCLM-4178922026-08-01T08:12:53ZJustin—Tran03/07/1941NULL-—N/A3195 MARKET STMesaaz85232NULLSELECT-EPO
CLMCLM-4273562026-03-13T22:58:40ZLogan—Henderson1973-03-24————7798 Meadow LnPHOENIXAZN/AGRP-3494·null
CLMCLM-4160692026-09-14T21:27:24ZColeman, Rachel—····1981-12-28UHC-96750-71•••-••-52656609535067UNKNOWN93 OCEAN AVEJacksonvilleFL32262GRP-1653N/A
CLMCLM-4145922026-03-24T06:38:32ZKEVIN—GEORGE17-01-1941-•••-••-5836——1143 Jefferson AveHoustonTXNULLGRP-8709null
CLMCLM-4285932026-08-31T10:37:23ZSara—Adams07/08/58NULL—N/Asara.adams69@aol.com7110 Central AvenuePHOENIXAZ85060GRP-3402MEDICARE-ADV-B
CLMCLM-4135812026-09-13T00:34:24ZStephen—·Hansen1985-08-18UHC9053196•••-••-2084(519) 445-7155UNKNOWN3118 Sunset BoulevardNashvilleTN——UNKNOWN
CLMCLM-4232182026-07-07T21:28:26ZERICMSPENCER21-07-1967—null(791) 640-2907—9811 OAK STREETMinneapolisMN55438··GRP-8130MEDICARE-ADV-A
CLMCLM-4258202026-08-27T02:21:32ZSantiago—Prce9/15/1955UHC-44765-45•••-••-5268·748-877-9778———--·GRP-4432SELECT-EPO
CLMCLM-4074532026-10-05T04:39:03ZReyes, Jose——09/22/82··nullN/A···-—3037 WILLOW COURTPhoenixAZ85074——
CLMCLM-4277432026-09-12T03:12:09Zbradley—crawford1960-03-11UHC-16738-82•••-••-043915214569303N/A4699 Union StreetGLENDALEAZ85393——
CLMCLM-4030802026-03-25T21:22:38ZRoy—Howell05-03-1951——4359597506null——N/Anull··GRP-3035OPTIONS-PPO
CLMCLM-4308142026-08-08T20:20:40ZPhillisp, Mark—··Nov 26, 1983——UNKNOWN··———NULL—GRP-3697··MEDICARE-ADV-A
CLMCLM-4014242026-07-03T21:10:30Zmaria—singhMay 20, 1983UHC-69979-70———8998 JEFFERSON AVELas VegasNV89195nullOPTIONS-PPO
CLMCLM-4122492026-06-17T20:55:27ZPamela—King1943-11-16UHC-00018-87•••-••-5731———N/A—N/A-N/A
CLMCLM-4206242026-04-12T03:31:25ZTheresa··Murray19740813UHC-57458-89—UNKNOWNnull——N/ANULLUNKNOWNOPTIONS-PPO
32,829 rows, page 106 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:38.464Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty