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-4048092026-08-23T19:12:44ZMICHELLE—FOWLER·1981-09-08NULL—500-364-6441-2988 Central AvenuePHOENIXAZ85015GRP-9447CHOICE-PLUS-PPO
CLMCLM-4117432026-03-28T19:28:48ZALBERT—GUZMAN1/8/1968—null-albert.guzman73@yahoo.com2821 Highland AveGlendale·AZ85372··N/ANULL··
CLMCLM-4213242026-05-26T15:23:33ZBobby—Chapman2004-02-20UHC-80403-78-UNKNOWN—2613 Cedar LaneAUSTINTXnullGRP-7770OPTIONS-PPO
CLMCLM-419359 2026-04-28T03:09:42ZBurns, Samantha——1993-07-27UNKNOWN··•••-••-2846493-670-7621samantha.burns30@yahoo.com9661 MAIN STREETNashvilleTN37248-6362GRP-5750····
CLM CLM-4321092026-05-03T22:07:26Z·Joan—Kelly20000205·UHC8305216UNKNOWNNULL····3036 Washington StGilbertAZ85208NULLCORE-HMO··
CLMCLM-4241662026-04-28T10:50:44Z·Mark—Reyes19850911null•••-••-5868NULLN/A5171 SAGE COURTGilbertAZ85204··UNKNOWN—
CLMCLM-4071212026-02-11T14:01:19ZSAMANTHA—FREEMAN1977-05-08UHC-78622-78•••-••-5424755-511-5205··—1512 CAMELBACK ROADScottsdaleAZ85243nullCORE-HMO
CLMCLM-4206002026-07-01T03:23:11Znicholas··—·clark11/09/1963UHC-59054-98•••-••-4791-—7847 Highland AvenueSan DiegoCA92198——
CLMCLM-4262082026-04-12T03:14:04ZKYLE—LAWRENCE··1997-10-11—N/A+1 614 222 1488UNKNOWN6147 Lincoln WayFresnoCA93707-2335nullNULL
CLMCLM-4024442026-03-02T23:53:28ZNATLIE—HOWELL3/28/1950UHC-74422-60•••-••-3714691-524-6600null—null—·null——
CLMCLM-4286322026-04-21T11:33:22ZSTEPHANIE—MARTINEZ19430507UHC-86165-98—703.857.6417NULL—····—UNKNOWNN/AOPTIONS-PPO
CLMCLM-4039842026-07-20T17:11:38ZMariana—Johnson2003-10-16UHC-15319-31-12489736384··MARIANA.JOHNSON@YAHOO.COM9680 Park Place··Plano··Texas75040GRP-5228OPTIONS-PPO
CLMCLM-4057422026-02-17T03:11:25ZVicky····Knight1988-03-18UHC-33507-96-+1 652 735 1959NULL3173 Bayshore Drive·ChandlerAZ85264GRP-6162null
CLMCLM-4321772026-08-30T01:57:36ZKeith—Rice1991-07-18UHC-84777-32•••-••-5550509-205-7851—1580 Lake View RoadTampa··FL33675—N/A
CLMCLM-4224562026-04-11T00:39:08ZLarry—Cole19860909UHC-55286-40N/A7605663804N/A7823 Bayshore DriveSeattleWashington98167GRP-4727NAVIGATE-HMO··
CLMCLM-4324432026-10-16T07:40:22ZMei—HowellApr 12, 1961UHC-44146-28•••-••-4093-—3682 Spring St··Las VegasNV89135·GRP-8279·CORE-HMO
CLMCLM-4039082026-08-31T04:18:09ZThompson, Cheryl——1959-10-20UHC-88060-98•••-••-56676019512107cheryl.thompson@hotmail.comnullUNKNOWN—·UNKNOWNGRP-6486—
CLMCLM-4176962026-05-20T08:07:47ZDeniseXWatkins1947-11-14UHC-96328-99NULL(900) 488-2018--NULLN/A—GRP-3519—
CLMCLM-4325382026-01-22T21:18:08ZChristianTPrice08/02/44UHC-56714-75··•••-••-9523468-950-0780———-—··—
CLM CLM-4047622026-06-20T21:17:26ZRobertBPerkins11/24/1968·UHC-38217-24•••-••-7949——·7520 Ocean AvenueJacksonvilleFL32240GRP-3467SELECT-EPO
CLMCLM-4148422026-09-24T10:43:24ZJimenez, Sara—··19680807—NULL————-NULLGRP-8343NAVIGATE-HMO
CLMCLM-4284502026-06-25T02:52:14ZHeather—Jackzon1992-04-01—•••-••-0443UNKNOWNUNKNOWN-··UNKNOWN—UNKNOWNGRP-7275—
CLMCLM-4016682026-09-05T06:16:26Z·FRANK··LIOct 4, 1974UHC-11541-03null··NULLN/A7401 Indian School Rd·JacksonvilleFL32263GRP-5441MEDICARE-ADV-A
CLMCLM-4113372026-08-25T06:37:01ZMargaret··Roberts0520-91-62··NULL•••-••-8564N/A—nullUNKNOWNNULLnullGRP-8307NAVIGATE-HMO
CLMCLM-4051472026-06-28T01:38:01ZEMMAO··REED1991-06-07UHC-91196-41UNKNOWNNULLN/A161 Desert Sky BoulevardCharlotteNC28294GRP-2510MEDICARE-ADV-B
CLMCLM-4187832026-09-11T14:01:08ZKathryn—Collins1973-12-27UHC5620039NULLUNKNOWN—1909 CANYON RDDENVERCO80250GRP-9651NAVIGATE-HMO
CLMCLM-4022262026-01-30T03:42:11ZALICE—SINGH1983-02-16--—-4384 MAIN STREET··San AntonioTexas—GRP-8884··UNKNOWN··
CLM CLM-4187182026-01-20T02:45:24ZRandy—Woods1976-04-09··UHC-63392-57—3947042040—1919 Market StPHOENIXAZ85057NULLUNKNOWN
CLMCLM-4017602026-03-04T20:12:35ZRussell, KatherineT—11/01/1954UHC-43937-93——KATHERINE.RUSSELL73@HOTMAIL.COM1701 Washington StreetLas VegasNV89176—NAVIGATE-HMO
CLMCLM-4187652026-07-29T05:07:59ZTyler—VargasJan 13, 1980null-434-631-5874UNKNOWN6278 HIGHLAND AVENUEAtlantaGAN/AGRP-2525MEDICARE-ADV-A
CLMCLM-4169272026-10-13T08:43:00ZJEREMYL.REED·19480321UHC-59517-34··(346) 480-0666UNKNOWN·8795 VALLEY VIEW DR #754Nashville··TN37237—····
CLM CLM-4324862026-06-11T07:13:17ZStevenMWalsh1954-03-24UHC-25671-25•••-••-4834N/AN/AN/A——NULLGRP-9467NULL
CLMCLM-4067502026-06-19T20:26:53ZJerryOGreene1998-10-19UHC-64557-68NULL—NULL8041 Highland AvenueSan DiegoCAN/A-—
CLMCLM-4039302026-01-10T06:45:52Zdanielle—·white07/17/99UHC-49036-24··NULL··9699190327UNKNOWN5573 Bayshore DrMinneapolisMN·55470-6380GRP-4104·SELECT-EPO
CLMCLM-4010792026-01-10T23:15:35ZElizabeth—West·1964-07-01UHC-23324-07•••-••-52923665091188—null··———GRP-4578OPTIONS-PPO
CLM CLM-4044212026-04-29T00:42:53ZRoger—Tucker2005-07-26UHC-54789-43N/AUNKNOWN—·nullnull-—·GRP-8625N/A
CLMCLM-4248472026-06-17T12:35:43ZMichelle—Gutierrez1998-01-28··UHC-25707-51N/A638-768-0342MICHELLE.GUTIERREZ58@GMAIL.COMnullnull—·-—MEDICARE-ADV-B
CLMCLM-4299802026-05-01T08:13:54ZArthur—Rogers2003-03-03UHC-28699-01-9158521458—nullN/A——NULL—
CLMCLM-4086852026-09-08T11:22:00ZEVELYN—RAMOS12/2/1970UHC-77500-44··•••-••-1472null-330 Baseline RdOrlandoFL·32832GRP-7522MEDICARE-ADV-B
CLMCLM-4296462026-01-11T17:40:48ZGarrett, Megan··—02/14/44UHC-79469-26•••-••-8520—NULL3207 Cedar LnLos AngelesCA90037GRP-8387—
CLMCLM-4122082026-07-18T20:25:07ZJason—Holmes1944-04-09UHC8698257•••-••-2226——N/AUNKNOWN———NULL
CLMCLM-4005992026-07-09T05:52:38ZkaylaI.mcdonald09/02/2002N/A•••-••-1533-—256 Jefferson AvenueLas VegasNV··89134—SELECT-EPO
CLMCLM-4308922026-05-30T04:38:34ZElijah—Greene02/21/1999UHC-47987-55UNKNOWN—··8743 Willow CourtSan AntonioTX78291UNKNOWNnull
CLMCLM-4255722026-07-10T23:27:11ZJANET—TUCKER06/26/72UHC-36190-80NULL18512605489-NULLUNKNOWNUNKNOWN—N/AMEDICARE-ADV-A
CLMCLM-4318492026-07-25T18:19:51ZDorothy—Henyr1948-05-26UHC-42030-56null-NULL-—-—GRP-5820·N/A
CLMCLM-4236892026-09-13T23:12:12ZAaron—JohnsonNov 4, 1978uhc-30422-67•••-••-8407N/ANULL9581 INDIAN SCHOOL RDSan Antoniotx78283UNKNOWNNAVIGATE-HMO
CLMCLM-4095052026-04-04T08:30:39ZDAVID—MARTIN2007-09-12UHC-21370-34•••-••-6987+1 322 876 9904··DAVID.MARTIN55@GMAIL.COMNULLUNKNOWNUNKNOWN—GRP-5441NAVIGATE-HMO
CLMCLM-4052662026-01-26T03:41:25ZEmma—Willis08/24/54UHC-58209-41—394-672-6890N/A2532 Grand Avenue·Austin·tx78758GRP-6373navigate-hmo
CLMCLM-4045632026-02-08T04:28:40ZKATHRYN—BURNS2002-02-02UHC-66794-95—·249-856-8696-933 Palm DriveGlendaleAZ85340-2773-·MEDICARE-ADV-A
CLMCLM-4278612026-06-08T16:30:53ZMARIANA—PEREZ1994-09-22NULL•••-••-2464(674) 705-5863—4020 Meadow LnSAN DIEGOCA-UNKNOWNNULL
32,829 rows, page 99 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.454Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty