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-4231522026-07-07T06:49:16ZWong, Jeremy——9/8/1939-——jeremy.wong37@proton.me4708 Grand AvenueSeattleWA98141GRP-6861··null··
CLMCLM-4323572026-02-19T17:10:23ZBanks, Jose——05-11-1997UHC-92182-66··•••-••-6913··—·5571 Main StreetDallasTX75275GRP-3662NULL
CLMCLM-427773 2026-06-18T08:15:07ZValdez, Christine——·1969-03-12UHC2057211•••-••-5516N/ACHRISTINE.VALDEZ45@YAHOO.COM8031 Union StreetHOUSTONTX77012GRP-5567N/A
CLMCLM-4160682026-03-01T03:27:31ZRACHEL—COLEMAN·28-12-1982UHC-96750-71—6609535067null93 Ocean AveJacksonvilleFL32262GRP-1653N/A
CLMCLM-4048392026-06-04T23:40:15ZBARBARA—WAAVER2006-11-02UHC-82682-70nullNULLUNKNOWN9677 Lincoln WayFRESNOCA-N/ACHOICE-PLUS-PPO
CLMCLM-4022012026-09-13T11:24:11ZREBECCA—SANDOVAL04-06-1971UHC-77395-37—(300) 917-2124—·7321 PINE DREden PrairieMN55362——
CLMCLM-4119642026-07-31T20:50:18ZFrances—Porter20-08-1962UHC-44995-70•••-••-6710—NULL9881 Lincoln WayLas VegasNevada—UNKNOWNOPTIONS-PPO
CLMCLM-4051942026-01-11T19:49:32ZJEREMY··GARRETT11/08/96UHC-85404-26•••-••-44539353864371-2455 PINE DRIVENashvilleTN37279GRP-5769MEDICARE-ADV-A
CLMCLM-410567 2026-01-29T21:17:00ZCarol—Luna1974-03-25UHC1371434—2956266227-6623 HARBOR BOULEVARDAtlantaGA30320-7283GRP-6151null
CLMCLM-4088512026-06-09T16:08:38ZHIROSHIBWELCH06/24/1962-•••-••-9010—UNKNOWN5244 Forest AvenueTucsonArizona85776GRP-0245··
CLMCLM-4308372026-10-05T01:07:12ZJULIA—REYES1980-12-18——8485916382N/A4574 Harbor BlvdSan AntonioTexas78214-4564GRP-2309·UNKNOWN
CLMCLM-4010832026-07-02T06:37:21ZJIMMY—BRYANT2000-12-16UHC-67105-34UNKNOWN(793) 541-8540—8331 Mesa DrGLENDALEAZ85377-7896GRP-1274—
CLMCLM-4291342026-07-24T11:14:40ZJuan—MurrayN/AUHC-76789-10•••-••-5422N/Anull·9062 PARK PLACEGilbertaz85263··GRP-6391OPTIONS-PPO
CLMCLM-4274912026-08-02T16:42:13ZKyle—Salazar1/26/1941—•••-••-7234nullkyle.salazar@gmail.com4948 OCEAN AVENUETucsonArizona85726GRP-2626·MEDICARE-ADV-A
CLMCLM-4259542026-03-02T15:58:03Zisabella—ferguson·1995-12-16UNKNOWN—N/ANULL2535 PARK PLACEGilbertAZ85279GRP-7664—
CLMCLM-4016932026-06-30T11:31:31ZarthurNmason7/11/1975UNKNOWNNULL337.397.4367—5652 Jefferson AveSan AntonioTX78266GRP-4362—
CLMCLM-4098312026-05-20T22:38:31ZMEIA.TUURNER04-10-1965UHC0984626··-7789672297NULL7497 SPRING STREET Apt 22TempeAZ85225GRP-6209—
CLMCLM-4323592026-08-18T10:24:41Zjose—banks1997-11-05—•••-••-6913-—·5571 Main StreetDallasTX75275GRP-3662—
CLMCLM-4290842026-01-05T03:31:26Zmariena—williamson1967-04-01—•••-••-86104858857683—2955 Church StreetFresnoCalifornia—nullN/A
CLMCLM-414665 2026-07-17T02:29:04ZGARY—BRYATN2003-09-22UHC-95416-52•••-••-2333517.702.8284-8554 Meadow LnTucsonAZ85761-5344N/A-
CLMCLM-4302652026-09-24T08:58:41Z Mei—Reid04-09-1977UHC-17477-15NULL—mei.reid68@gmail.com——·NULLN/A-UNKNOWN··
CLMCLM-432688 2026-06-07T18:28:22ZSusan—Weber·12/3/1960UHC-37047-32UNKNOWN—UNKNOWN5025 Camelback RoadTEMPEAZ85298-4529——
CLMCLM-4079112026-07-19T09:34:03ZFrank····Franklin11-09-2003—•••-••-0812NULLNULL7574 BROADWAYPHOENIX··Arizona85020GRP-4175MEDICARE-ADV-A
CLMCLM-4049672026-09-09T21:48:18ZSam—Miller1940-11-09nullN/A··—·5308 GRAND AVENUETucsonAZ—GRP-8426NULL
CLMCLM-4054042026-08-28T02:29:16ZJosh—Hill1909-06-01UHC-62851-11—N/A—1228 CENTRAL AVENUESEATTLEWA98125··nullnull
CLM CLM-411047 2026-03-31T05:38:23ZMATTHEWGHARPER1987-11-08uhc-68492-17——null1568 CENTRAL AVEGilbertAZ85224N/AMEDICARE-ADV-A
CLMCLM-4087462026-04-10T22:07:31ZGerald—Rose1982-08-05-•••-••-7827——7637 Forest AvenueMesaAZ85283—OPTIONS-PPO
CLMCLM-4176172026-07-16T09:21:50ZBobbyQCampbell1954-09-06—•••-••-6884—UNKNOWN2686 Church StPhoenixAZ85054—null
CLMCLM-4195642026-09-20T04:41:52ZPHILIP··ORTTIZ1998-02-08UHC-37413-99•••-••-1008316-281-5095NULL9341 Hillcrest RdChandler··AZ85242GRP-0847N/A
CLMCLM-404950 2026-04-26T08:46:54ZLOGAN—TUCKER1958-03-25UHC-57723-01null(670) 931-3269N/A3731 BASELINE ROADScottsdale·AZ85204GRP-1873CHOICE-PLUS-PPO
CLMCLM-4012092026-01-10T22:59:38Zana—knight1991-03-25UHC-00824-54N/AUNKNOWN··UNKNOWN3627 LINCOLN WAYGILBERTAZ85236··—MEDICARE-ADV-A
CLMCLM-4117702026-01-30T19:54:18ZALEXANDER—·GIBSON1959-10-11··UHC7598261—NULL—5157 CEDAR LANEAtlantaGA30383GRP-9625—
CLMCLM-4304282026-04-16T20:43:43ZSophia—Welch1938-07-16UHC-08969-87•••-••-1777NULL-9297 Church St·San DiegoCalifornia92171-9782GRP-9830NAVIGATE-HMO
CLMCLM-4225372026-10-06T05:38:07ZGary—Garza19930308UNKNOWNN/ANULL·gary.garza@icloud.com5827 INDIAN SCHOOL ROADMiamiFL33184-CHOICE-PLUS-PPO
CLMCLM-4326862026-06-23T14:52:48Z MASON—WARD2/17/1993UHC-71648-92•••-••-2201N/Anull2679 Camelback RdJacksonvilleFL32212GRP-2200—
CLMCLM-4009072026-05-26T22:45:59ZMASON—REYNOLDS1978-09-19UHC-75443-65•••-••-5037—N/A4261 Ocean AvenueDallasTexas75209GRP-8389—
CLMCLM-404112 2026-05-06T19:07:42ZChristopherG.Williamson2/28/2002———N/A7615 Desert Sky Blvd·CharlotteNC·28279GRP-6165····
CLMCLM-4141122026-01-19T23:16:24ZWalter··Hunt1953-06-14UHC-10496-18-9716995800N/Anullnull-—UNKNOWN—
CLMCLM-4296902026-08-03T20:41:48ZSHARONDBURKE·2001-12-20—•••-••-631813514196066sharon.burke13@hotmail.com655 Harbor BoulevardGlendaleAZ85344GRP-2579NAVIGATE-HMO
CLMCLM-4049832026-10-17T01:24:32ZKAERN—WELLS06-03-1991·UHC-21724-15—3663926888NULL3117 Central AveMinneapolisMN55407-3848N/Anull
CLMCLM-4007112026-02-05T04:21:56ZLARRY··CONTRERAS··4/15/1982UHC-12711-13•••-••-5256(598) 830-9403—5780 Lincoln WayTempeAZ85211··GRP-0438—
CLMCLM-4240792026-03-16T08:01:49ZLUCIAEPADILLANULLNULL—7774201493·null1051 MAPLE AVENUE·COLUMBUSOH··43298GRP-6403CHOICE-PLUS-PPO
CLMCLM-4281252026-02-28T22:04:34ZMegan··—Marrquez1990-06-14UHC-86538-02•••-••-6515UNKNOWN—4790 Washington St #137MesaAZ··85238GRP-0899—
CLMCLM-4278232026-07-23T09:50:23ZDonna—Ramos1995-10-06··null-(782) 723-6431-N/A-··NULL-·GRP-9368·MEDICARE-ADV-A
CLMCLM-4119262026-10-07T16:41:07ZAustin—Byant12/17/06UHC-63037-48•••-••-54572946316629NULL6850 Spring StOrlandoFL32899GRP-3815CHOICE-PLUS-PPO
CLMCLM-4122332026-02-11T07:56:58ZCarlosX.Morris1952-07-18UHC-08521-03•••-••-4884N/AN/A7922 Union StFresno··ca93764NULLOPTIONS-PPO
CLMCLM-4082592026-07-14T09:04:17ZHicks··—Pamela1951-06-04·UHC-52905-09null15164572256-5492 HIGHLAND AVESeattleWA98198—UNKNOWN··
CLMCLM-4220002026-09-15T19:51:16ZDAVID—FORD1991-03-11UHC9276636-NULLN/A—N/A····UNKNOWN-MEDICARE-ADV-A
CLM CLM-4129042026-08-06T05:59:45ZAMBEREREYES03/24/97·UHC-63044-27—(352) 551-5883—UNKNOWN·UNKNOWNN/A—GRP-4380CHOICE-PLUS-PPO
CLMCLM-4327932026-02-12T21:43:01ZstephenC.murray1962-05-26UHC-92761-01NULL+1 811 384 8702N/A—-UNKNOWNUNKNOWNGRP-5620NAVIGATE-HMO
32,829 rows, page 170 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.602Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty