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-4313382026-01-04T23:12:27ZBrian—·Fox19690120UHC-56910-92-(301) 430-8839··null4879 Spring StreetGlendaleAZ85378nullnull
CLMCLM-4102452026-05-11T21:56:51ZBradley··—Hall1978-05-24uhc-81797-93•••-••-3022--1877 Lincoln WayPhoenixAZ85054GRP-8829NAVIGATE-HMO
CLMCLM-4203402026-09-15T03:23:02ZHANNAH—ROBERTS1971-11-23UHC-68689-28-908-758-7519-·nullnullN/Anull—CORE-HMO
CLMCLM-4326922026-03-25T07:51:43ZWayne··Watkins1940-04-26UHC-07200-64—6297601417—UNKNOWNNULLNULLNULLnullSELECT-EPO
CLMCLM-4256992026-09-02T18:07:55ZWILLIAM—BANKS1997-09-07UHC-17248-72NULL——N/A·NULL····UNKNOWN—UNKNOWN
CLMCLM-403405 2026-04-27T14:33:50Zvictoria—hughes1949-09-21NULLnull+1 980 737 6597——-NULLnullGRP-1185—
CLMCLM-4226102026-09-08T21:53:03ZWilliiamson, Carlos—··Jul 1, 1977UHC-61358-72NULL707.510.7974null5335 Highland AveTempeArizona85242NULLSELECT-EPO
CLMCLM-4074402026-06-11T05:58:16ZElizabethIAlexandr2005-04-28UHC-66996-44•••-••-8914NULL··—null—nullGRP-9548MEDICARE-ADV-B
CLMCLM-4265952026-03-10T22:30:07Z JudyLRobinson1984-04-18UHC-50698-88•••-••-90572125819328NULL1766 MAPLE AVENUE·JacksonvilleFL—nullMEDICARE-ADV-A
CLMCLM-423595 2026-02-19T21:44:20ZCHRISTINE—HOFFMANMay 9, 2003·UHC-38010-16null—NULL5855 SPRING STREETPHOENIXArizona85022-7025—OPTIONS-PPO
CLMCLM-4309222026-07-11T01:01:36ZBetty—Perez07-03-1997UHC-12785-63•••-••-9272—·UNKNOWN136 MESA DRIVEMinneapolisMN55470-2203GRP-6166-
CLMCLM-4310022026-10-01T00:25:02ZJean·R.Brouks1971-01-27UHC7949629•••-••-4151NULLUNKNOWN7920 Camelback RdLos Angelesca90012-—
CLMCLM-4109252026-07-27T05:06:46ZValentinaUEstrada1994-07-25UHC-11269-95•••-••-0843--2900 Baseline RoadCharlotteNC28228-7996—SELECT-EPO
CLMCLM-4233802026-04-20T22:33:51Zlaura—alvarado1967-03-02—N/A——·N/ANULL—UNKNOWN—··
CLM CLM-4016822026-05-14T18:10:28ZAbigail····Coleman1951-01-12null•••-••-6692NULL—6206 Ridge RdDENVERCO80291-7655—SELECT-EPO
CLMCLM-4271892026-06-14T09:03:03ZPRIYA—RODRIGUEZ1963-11-16UHC0078693NULL672-380-6149—7200 Indian School Road #773Las VegasNV89154GRP-6164·null
CLMCLM-4149702026-09-07T16:36:20ZBARBARA—PALMER10/15/74N/A•••-••-4929304-945-1940N/AnullN/A—N/AGRP-6056null
CLMCLM-4003532026-06-09T21:31:22ZMunooz, Elizabeth——1982-02-13UNKNOWN•••-••-8954-UNKNOWN4165 Willow CtColumbusOH43235-MEDICARE-ADV-B
CLMCLM-4316162026-09-23T23:24:55ZDANIEL—HLOMES11/18/1953·UHC-72010-71——NULLN/A—N/AUNKNOWNGRP-4520options-ppo
CLMCLM-4289352026-03-23T08:07:37ZGloria—Espinoza19770417UHC-19393-67•••-••-6655———-—·N/AGRP-9658CHOICE-PLUS-PPO
CLMCLM-4191612026-06-08T23:29:45ZBENJAMIN—GMEZ2002-07-21UNKNOWN—653-799-8516··null—N/AN/AN/AGRP-9555MEDICARE-ADV-B
CLMCLM-4202662026-05-14T20:40:37ZARJUN—STONE1987-03-17UHC-35646-80•••-••-448416575655180—5322 MAPLE AVEColumbusOH43203GRP-5930CHOICE-PLUS-PPO
CLMCLM-4254402026-07-01T16:42:57ZDonaldY.Lane··01/25/74—-·922-367-5811donald.lane@outlook.com4221 CEDAR LN #242DenverCO80291-9558GRP-9120CHOICE-PLUS-PPO
CLMCLM-4290522026-04-26T09:48:01Zwilliam··hall16-07-1975—•••-••-0270UNKNOWNNULL1847 PINE DRScottsdaleAZ85272GRP-1968··CORE-HMO
CLMCLM-4088672026-05-08T22:03:37ZWallace—George1966-06-24UNKNOWNNULL7299008365—106 Grand AveNASHVILLETN-GRP-9434MEDICARE-ADV-B
CLMCLM-4192742026-10-10T07:57:26ZKelly—Espinoza·05/10/1989NULL—8586021424·-9183 Central AvenueJacksonvilleFL·32286-3130GRP-5006-
CLMCLM-4098792026-08-04T07:22:05ZRUTH—OWNES··19880127UHC3828221•••-••-5615NULLUNKNOWN8039 Washington StreetHoustonTX77015GRP-4372OPTIONS-PPO
CLMCLM-4289782026-06-15T05:04:52ZJulia—·Ramos1/19/1978NULL—-N/A4618 Washington StLas VegasNV89175··GRP-2617NULL
CLMCLM-4273482026-05-05T01:11:41ZChavez, Willie··——2007-02-03UHC-34974-99-5147086363—4782 PINE DRIVEDenverCO80289null·NAVIGATE-HMO
CLMCLM-4029522026-07-14T23:58:00ZLinda—Garrett01-03-1947-•••-••-3740+1 372 499 3067N/Anull-UNKNOWNN/ANULL-
CLMCLM-4206032026-08-17T04:39:26ZBRYAN—RYAN3/5/2005N/Anull868-427-9761-···N/A—N/AnullNULL·NAVIGATE-HMO
CLMCLM-4241012026-01-10T03:59:16ZBrendaK.·Loepz1990-02-18UHC-93886-29····—N/A8704 Lincoln WayMesaArizona85233-3321—N/A
CLM CLM-4216012026-09-13T02:33:06ZSHIRLEY—GILBERT1982-10-02—-N/A·UNKNOWN8549 Lake View RdMinneapolisMN55408nullSELECT-EPO
CLMCLM-4070192026-07-13T11:09:10ZDavid—Henry1964-01-25-•••-••-5281(459) 308-3073UNKNOWN4431 Harbor BoulevardCharlotteNC28202GRP-4908—
CLMCLM-4254312026-01-24T05:19:17ZLarry—MendozaSep 8, 1992N/Anull9434462190null2548 Willow Court·OrlandoFL32809GRP-2801····
CLMCLM-402948 2026-04-12T04:32:09ZChris—Weaver05-04-1986UHC-97085-20N/A-christine.weaver@hotmail.com9496 LINCOLN WAYChandlerArizona85269GRP-5625null
CLMCLM-4239982026-05-28T14:32:47ZFrank·LRichards1983-06-28UHC-92254-86•••-••-8026·(383) 485-0609N/A7748 Meadow LaneJacksonvilleFlorida——CORE-HMO
CLMCLM-4214842026-07-24T15:30:21ZNoahS.Torres1979-09-16null•••-••-5855NULL—2460 GRAND AVENUEEDEN PRAIRIEMN—GRP-7319MEDICARE-ADV-B
CLMCLM-4052702026-05-29T08:58:49ZRussell—Gibson·1954-06-21UHC-03948-12•••-••-7651——8245 Ocean AveSan AntonioTX78208GRP-0461—
CLMCLM-4309602026-05-15T08:32:20ZAmberCDiaz··1955-11-26UHC-29467-25•••-••-9845+1 948 926 4444N/A5873 Central Ave Apt 16Dallas··TX··75273-4126-—
CLMCLM-4303072026-05-08T16:21:55ZNATALIEZSILVA1982-06-24UHC-19727-28-—NATALIE.SILVA2@PROTON.ME—···null—······
CLMCLM-4086932026-09-21T09:58:27ZJohn—Lee1980-12-10UHC-76890-70—278-519-2062·null7726 Mesa DrNashvilleTN37298nullN/A
CLMCLM-4227832026-04-12T13:54:32ZEriic—Rojas2005-01-24—•••-••-6418NULL·eric.rojas78@proton.me7821 Central Avenue·MIAMIFL33123GRP-5950SELECT-EPO
CLMCLM-4232782026-09-19T15:03:30ZMARIABCLARK1949-12-07UHC-75430-55——null8006 Apache BoulevardColumbusOH43289-CORE-HMO
CLMCLM-4241022026-01-16T04:17:51ZEdward—George19830617-•••-••-0123+1 925 654 9706——UNKNOWN·-null—··
CLMCLM-4268702026-09-14T09:49:21ZWei—Garza1973-05-16UHC-65237-74—··—4564 OCEAN AVENUEAtlantaGA30306GRP-9260NAVIGATE-HMO
CLMCLM-4181202026-10-06T08:25:15ZDONNA—BELL23-10-1944UHC-52060-01•••-••-9795965-916-6127donna.bell@gmail.com2480 Canyon RdJacksonville··FL32238GRP-6112-
CLMCLM-4151522026-08-21T15:08:53ZCYNTHIIA··—HUGHES19520322null—-UNKNOWN2167 Union St··TempeAZ··85230GRP-5155—
CLMCLM-4231232026-06-23T19:33:27Zwliliam—webb19650927UHC-32485-80·-—UNKNOWN3487 Broadway·Las VegasNV89127GRP-4774-
CLMCLM-4125752026-04-06T20:34:48ZFord, Joe——1099-19-78····nullnullnull1902 Highland AvenueChandlerAZ85201GRP-8913—
32,829 rows, page 103 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.460Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty