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-4109992026-05-27T04:27:20Z·James—Watkins08/25/1957·UNKNOWN•••-••-3653895-632-1862null3160 UNION STREET··AustinTX78716··—NAVIGATE-HMO
CLM CLM-4015092026-07-26T11:13:03ZMary—Murray11/5/1979NULLUNKNOWNnullNULL4644 Indian School RoadAtlanta·GA30358-3970—CHOICE-PLUS-PPO
CLMCLM-4224142026-08-14T13:08:20ZGary—Espinoza1942-02-25UHC-09582-44—14234665072NULL8150 Mesa DriveMesaAZnullGRP-3386choice-plus-ppo
CLMCLM-4307722026-08-03T21:03:45ZSandraCYoung09/22/1938UHC-48035-60UNKNOWN2247165422nullN/A··NULL··NULLUNKNOWN-OPTIONS-PPO
CLMCLM-4303172026-03-02T14:34:47ZEthan—PeersJun 14, 1971UHC-28291-35null-—4909 Meadow LaneSEATTLEWA98152GRP-4425CHOICE-PLUS-PPO
CLMCLM-4183552026-04-06T05:22:24ZStevenVWets02-04-1968—N/AnullN/A·16 Mesa DrGilbert·Arizona85268NULLUNKNOWN
CLMCLM-4027582026-06-12T05:54:09ZJames—Ortiz19650102N/AN/ANULL—78 Willow CourtHOUSTONTX77043GRP-7065UNKNOWN
CLMCLM-4126392026-04-26T14:24:23ZOlivia··Sanchez1947-09-04UHC-66069-07•••-••-4357NULL—94 Cedar LnAtlantaGA·30374NULLMEDICARE-ADV-B
CLMCLM-4194472026-04-22T10:08:49ZSchultz, JoseL—1998-12-25UHC-22544-02··•••-••-7371——NULL—··NULL—-
CLMCLM-4302802026-01-26T20:33:01ZRuth—Baker·12/9/1971nullUNKNOWN—-·UNKNOWNnullNULLNULLGRP-4783—
CLMCLM-4107972026-03-05T07:45:46ZthomasGberyr2008-05-13UHC-53888-98———5287 Jefferson AvenueSacramentoca95821GRP-3951OPTIONS-PPO
CLMCLM-4166302026-08-09T21:04:33ZDenise—Schmidt19690502UHC-99733-49•••-••-0645(850) 762-6288—3988 Mesa DriveMESAAZ·85273GRP-0334SELECT-EPO
CLMCLM-4020192026-05-14T21:26:44Z·JaniceT.Adams20-10-1960UHC-49605-18—259-893-3633-6917 FOREST AVENUEGILBERTAZ85242-2195GRP-5613N/A
CLM CLM-4006302026-06-12T09:03:41ZAlex—Thompson1999-03-02UHC-81966-47-——8452 CENTRAL AVENUEEden PrairieMN55317·GRP-5349SELECT-EPO
CLMCLM-4325602026-09-16T00:27:59ZAmanda—Bennett1/8/2004nullUNKNOWN·482-762-9839N/A6065 Union StColumbusOhio43251GRP-7664NAVIGATE-HMO
CLMCLM-4098032026-10-01T18:52:28ZBETTY—MARTINEZ1996-03-10UHC1662119UNKNOWN732.493.0602N/A5975 Lake View RdJacksonvilleFL32274N/AOPTIONS-PPO
CLMCLM-4324192026-04-20T18:35:25ZBarbara—Nichols1953-03-05-·NULL(907) 730-0078UNKNOWN8658 Mountain View DrMiamiFL33174GRP-0914-
CLMCLM-4141552026-04-18T03:44:11ZBennett, DanielG—08/12/08null——·null—NULL··—UNKNOWNGRP-0753··-
CLMCLM-4244692026-07-02T23:32:49ZWagner, Tyler—··1977-08-17UHC-29723-33•••-••-9390N/AN/A8116 Willow Ct··San AntonioTX78239·GRP-4611-
CLMCLM-4272932026-04-02T05:14:57ZChristineRValdez1960-02-08UHC9561179null··8623587484———N/AUNKNOWNGRP-8401MEDICARE-ADV-A
CLMCLM-4257502026-09-08T07:39:02ZSara—Robertson·04/12/1962UHC-65179-24•••-••-6258——·910 Forest AvePhoenixAZ85005GRP-3237NAVIGATE-HMO
CLMCLM-4028282026-08-25T07:06:06ZStephanie—MurrraySep 14, 1990UHC-72107-30—-N/A3576 Central AvenueEden PrairieMN55316N/AUNKNOWN
CLMCLM-4294182026-10-14T00:18:12ZDIANAJCLARK·1992-05-04UHC-38721-43•••-••-5754+1 919 569 7883-8490 Lincoln WayLAS VEGASNV89114-6463—·CORE-HMO
CLMCLM-4177062026-01-24T15:40:50ZBETTY—KNIGHT··1943-04-12—•••-••-8926-null408 River RdChandlerAZ85205GRP-8490UNKNOWN
CLMCLM-4181672026-10-08T14:30:40ZAna—Jackson1977-02-23N/A—-UNKNOWN347 Lincoln Way Apt 13·DallasTX75221··NULLCHOICE-PLUS-PPO
CLM CLM-4073712026-06-16T00:08:59ZJEREMY—HARVEY1965-06-25UHC5654603-—NULL3677 Pine DriveHOUSTONTX77046—NULL
CLMCLM-4006412026-10-10T06:43:26ZBILLY—·JACOBS19590628UHC-33970-88•••-••-02173229878billy.jacobs@yahoo.com——nullNULL—CHOICE-PLUS-PPO
CLMCLM-4119812026-08-29T04:28:50ZGonzales, Douglas··—1954-12-17UHC-31335-66··—(377) 877-8088NULL—nullNULLN/AUNKNOWNMEDICARE-ADV-A
CLMCLM-4298232026-01-01T19:03:29ZHannah—Larson06/11/01·NULL—null—8916 Jefferson AveMiamiFL33161·GRP-5644OPTIONS-PPO
CLMCLM-4116912026-02-06T17:36:19ZEMILY··GUZMANN/AUHC-12345-16NULLNULLNULL—-·N/A—GRP-9555-··
CLMCLM-4120872026-02-08T19:06:10ZwalterLalvarez06/02/1941UHC-32233-17•••-••-7106(375) 379-0045··null7531 Forest Ave #512GilbertAZ85232GRP-7948-
CLMCLM-4095952026-05-04T02:30:16ZISABELLA—PARKER02/11/1955UHC-22975-41•••-••-8799——3506 Grand AvenueGlendaleArizona··85339·GRP-2034NAVIGATE-HMO
CLMCLM-4011612026-05-11T02:55:50ZBryan—HansenNov 13, 1945NULLnull327-698-8031null8525 Highland AveSAN ANTONIOTX78231GRP-1638—
CLMCLM-4034762026-01-04T06:50:13ZDavid—Hall6/4/1949··UHC-32874-59•••-••-9377(585) 606-0670—766 Central AvenueDenverCO80252GRP-8437choice-plus-ppo
CLMCLM-4202612026-05-12T05:17:53ZRaymond—Austin07-11-1980UHC-70748-51—2546782802-————GRP-7251SELECT-EPO
CLMCLM-4186252026-07-29T23:35:27ZEdwadr—Russell1991-02-21UHC-31057-94UNKNOWN14029966099·-7133 MEADOW LANE #832TucsonAZ··85795N/A—
CLMCLM-4025982026-05-19T18:36:29ZMICHELLENMEDINA·2006-03-15UHC-20779-23•••-••-7670—UNKNOWN2223 Spring StreetAustinTX78785-CORE-HMO
CLMCLM-4209842026-05-15T02:39:21ZemilyBowens2002-03-03N/A•••-••-3728(326) 256-4018·-8088 Lake View RoadTampaFlorida33657UNKNOWNUNKNOWN
CLM CLM-4078352026-10-17T04:19:30ZBenjamin—Ross02-12-1980UHC-35042-30-16157931347—7719 Market StMinneapolisMN55421GRP-9464MEDICARE-ADV-B
CLMCLM-4029212026-05-08T02:39:54ZGerald—Hudson12/20/50—•••-••-83232025100902-··1693 Market StreetTampaFL33674GRP-4900MEDICARE-ADV-A
CLM CLM-4175632026-03-28T04:05:58ZBobby—Harris09/21/1947UHC-29409-54NULL—null6344 Cedar LaneHouston··TX77078——
CLM CLM-4075372026-02-24T19:36:39ZVirginia—Yang1988-08-28UHC-41415-62UNKNOWN+1 685 603 9563—200 Jefferson Ave Apt 37Mesaaz85287-8587GRP-7669····
CLMCLM-4209022026-04-10T15:35:58ZNICHOLAS··—ALEXANDER19550223UHC-81486-07•••-••-5247+1 546 695 0028··—6174 CENTRAL AVE #438San DiegoCA92154GRP-0147NAVIGATE-HMO
CLM CLM-4272302026-01-13T21:20:46ZKEVIN—NGUYEN19771218UHC9741697•••-••-8785—null3474 Palm DrTempeAZ85282GRP-5340NULL
CLMCLM-4238112026-03-16T09:36:42ZCynthia······Castro··1951-10-08N/ANULL-cynthia.castro45@icloud.com4822 BASELINE RDDenverCO80248GRP-8130null
CLMCLM-4165492026-02-23T10:14:06ZHenryKWlker1949-05-17UHC-07090-42—796.716.8117—9002 Oak StreetSACRAMENTOCA95823-4437nullNULL
CLMCLM-4268452026-04-15T00:43:10ZPorter—Olivia1947-09-16NULL•••-••-5073——5621 PARK PLHOUSTONTX77017N/ASELECT-EPO
CLMCLM-4214902026-07-07T07:12:44ZEUGENE—DIAZ2001-07-02UHC-33392-38-8381627··—6968 MAIN STREETAtlantaGA··30367—-
CLMCLM-4233562026-09-19T09:49:38ZAaron W—Aguilar19870512—•••-••-4087425-870-6848—·8520 Meadow LnAustinTX78798GRP-3595··NULL
CLMCLM-419738 2026-03-23T01:35:58ZKATHRYN—DAY1982-11-24NULL•••-••-6687(494) 884-5985kathryn.day@proton.me9600 Ridge RoadPhoenixAZ85081nullMEDICARE-ADV-B··
32,829 rows, page 40 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.686Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty