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-4101232026-03-20T05:16:34ZAbigail·NHicks1970-08-17UHC-60211-80nullN/A—5753 Union StMiamiFL33105GRP-1170NULL
CLMCLM-4277652026-09-29T11:05:28ZAnthony—Harris2002-11-20—-—anthony.harris28@gmail.com·6767 PALM DRORLANDOFL32833GRP-4078SELECT-EPO
CLMCLM-4078862026-06-27T19:40:20Zalice—hayes2000-06-23UHC-80765-96•••-••-8753N/A··8618 Washington StreetSan DiegoCA92129-2547GRP-8233OPTIONS-PPO
CLMCLM-4314322026-07-09T23:31:50Z·BILLYGROMERO1952-20-05UHC-55739-85UNKNOWN-N/A4647 Sunset BoulevardGilbertAZ85247GRP-7846—
CLMCLM-4107652026-07-26T06:34:10ZBrittany—Fowler11-04-1948NULL··•••-••-32387738311115N/A4303 LAKE VIEW ROAD Apt 28San AntonioTX78274-1564·GRP-7539MEDICARE-ADV-B
CLMCLM-4097132026-03-29T04:58:27ZBOB—GARZA1963-11-10UHC-33869-29•••-••-9370NULLnull9800 OAK STREETAtlantaGA30356GRP-0502MEDICARE-ADV-B
CLMCLM-4284612026-05-01T06:07:21ZPeters, Kyle——1955-11-12——9627644449nullnullN/A-UNKNOWNGRP-2505null
CLM CLM-4165342026-10-13T22:44:17ZWard, Yuki——1948-12-23UHC4969258•••-••-3360····UNKNOWN4400 Central Ave·MIAMIFL33132GRP-7209NULL
CLMCLM-4148822026-09-19T01:58:04ZJanZ.Mathews02/15/06··UHC-97785-65-NULL-·2720 Bayshore DrFresnoCA··93774GRP-8137CHOICE-PLUS-PPO
CLMCLM-4201832026-02-14T08:35:29ZAdamTPhillips14-10-1981UHC-19294-10—2954501523N/A4287 WASHINGTON STREET Apt 39San AntonioTX78273GRP-0822NULL
CLMCLM-4230822026-03-23T07:30:20ZKenneth—Nguyen1989-12-14UHC-88779-51UNKNOWN··UNKNOWNN/A8140 Palm DrLas VegasNV89149GRP-0918·null
CLMCLM-4088482026-07-06T19:43:34ZMorrison, Lauren····—1978-08-20UHC-90176-41•••-••-4290—-null····N/A-GRP-4416SELECT-EPO
CLMCLM-4040422026-04-21T16:58:21ZBruce—Meyer··1964-03-22UHC-94064-25NULL——1979 Jefferson AveHoustonTX77031—MEDICARE-ADV-A
CLMCLM-4258172026-08-28T04:39:59ZChristine—Wagner1989-02-28nullUNKNOWN7466806351UNKNOWN8466 Jefferson AvenueTucsonAZ85789GRP-7795—
CLMCLM-4063082026-04-05T05:15:46ZMICHHAEL··—PETERS7/1/1951UHC-46427-71•••-••-2776(784) 675-9366UNKNOWN··5547 Mountain View DriveScottsdale·AZ85228GRP-5133··—
CLMCLM-4184242026-01-11T20:58:05ZBNEJAMIN—BUTLER1954-07-24UHC-13351-83—763-458-3309·null1068 Willow CtCOLUMBUSOH43297GRP-6336NULL··
CLMCLM-4165192026-06-20T08:06:20ZBilly—·Jackson1951-06-13—•••-••-72498286326178UNKNOWNUNKNOWN··N/A···null——MEDICARE-ADV-A
CLMCLM-4251392026-09-04T16:44:11ZLoganDDavis··1975-12-05·UNKNOWN•••-••-0739—-··2947 PALM DRTampaFL33616GRP-9985CORE-HMO
CLMCLM-4174632026-05-24T17:06:56ZELIJAH—·HAYES1968-02-07UHC-25480-96null(546) 370-9394—5485 Broadway··HoustonTX77068N/ANULL
CLMCLM-4315812026-09-04T03:33:17ZSarah····Cook2000-11-01—•••-••-2563(564) 398-1115——-——GRP-0540MEDICARE-ADV-B
CLMCLM-4152682026-07-31T11:21:30ZKatherine—Reynolds1943-04-06UHC-99813-94—226-445-1946N/A9140 Elm StreetSeattle··WA98115GRP-8665·MEDICARE-ADV-A
CLMCLM-4030072026-02-23T05:16:37ZAndrews, Joshua——1958-05-24UHC-80667-74N/A886.686.2802—2045 MARKET STREETLos AngelesCA90098GRP-3773UNKNOWN
CLMCLM-4212582026-01-06T19:17:15ZBradley, DotM—19520912-——-634 Canyon Rd #238SEATTLEWA98100GRP-3375CHOICE-PLUS-PPO
CLMCLM-4065832026-06-16T16:57:46ZNANCYG.WRIGHT··1957-08-22nullUNKNOWN-—9675 Bayshore DrivePhoenixAZ85065NULLSELECT-EPO
CLMCLM-4139312026-07-12T15:39:04ZNATHANY.·RYAN1996-09-17UHC-40820-53null·N/AUNKNOWN8757 Desert Sky Boulevard··DenverCO80273GRP-8563OPTIONS-PPO··
CLMCLM-420204 2026-03-29T14:15:29ZArmstrong, AlexisA—08/18/1996UHC-63561-95NULL—-1658 CANYON RDAustinTX78733GRP-7476OPTIONS-PPO
CLMCLM-4056242026-08-25T12:01:45ZTIMOTHYY.HOWELL1953-09-28-•••-••-1531(552) 691-5775UNKNOWN7581 Meadow Ln Apt 7DallasTX75233—-
CLMCLM-4239992026-01-13T19:29:57ZFRANK—RICHARDS28-06-1983··—•••-••-80263834850609UNKNOWN7748 MEADOW LANE··Jacksonville·Florida32201GRP-2957CORE-HMO
CLM CLM-4000672026-08-21T21:00:09ZlawrenceHkelly2008-02-22UNKNOWNN/A19817852571lawrence.kelly33@aol.com7196 Oak StreetColumbusOH43276GRP-6603CORE-HMO
CLMCLM-4077892026-02-08T07:26:05Z Kenneth··Palmer··10/25/1949-•••-••-6690null—5068 Lake View RdOrlandoFL··32810GRP-6975UNKNOWN
CLMCLM-4205782026-08-07T21:36:33Zjuan—lewis-N/AUNKNOWN··UNKNOWN—4772 Jefferson AvenueScottsdaleAZ85207UNKNOWNCORE-HMO
CLMCLM-4054032026-06-16T11:01:36ZJerryXFranklin1963-04-23-•••-••-1168+1 397 533 9901—2202 APACHE BOULEVARDHoustonTX77032GRP-5248OPTIONS-PPO··
CLMCLM-4037962026-09-28T19:39:05ZCatherine—Henry1998-06-20UHC-75352-66——UNKNOWN4226 Washington StreetAustinTX78727GRP-7684·MEDICARE-ADV-A
CLMCLM-4141562026-03-17T13:19:17Zdanny····benett08/12/08uhc-66829-88—·N/A-9592 Market StreetGlendaleAZ85308GRP-0753··OPTIONS-PPO
CLMCLM-4205042026-02-21T21:47:06ZMurphy—CharlotteJun 28, 1944—NULL·4147956146UNKNOWN5478 Main StPhoenixAZ85035N/AMEDICARE-ADV-B
CLMCLM-4082252026-07-21T06:03:51ZSandra—Ryan1995-12-02-•••-••-9011——3076 SPRING STChandlerAZ85250-—
CLMCLM-4272612026-10-05T04:51:26ZJohn—Freeman1946-07-23UHC2672461NULL·7047446923-2736 Lake View RoadSan AntonioTX78294··GRP-4953—
CLMCLM-4131732026-09-11T16:36:01Z MasonXRice10/07/1993UHC-17524-08nullNULLnull—N/A—UNKNOWNnullNAVIGATE-HMO
CLMCLM-4162212026-03-05T01:12:22Z·Arthur—Ryan11/16/63UHC-21613-25—7099349751-3760 SPRING STREETLos AngelesCalifornia90056GRP-9356MEDICARE-ADV-B
CLMCLM-4255542026-04-22T14:34:18ZEIMLY—·WHITE1942-09-14UHC-52127-72—8232470038NULL208 APACHE BOULEVARDTempeAZ··N/A—NULL
CLMCLM-4221422026-05-13T20:47:15ZJoan—Edwards1956-07-06—NULL(491) 761-6897null4205 Union StDallasTX75293·GRP-2620·NULL
CLMCLM-412402 2026-07-16T07:17:49ZJACK—DUNCAN2002-09-20UHC9856409NULLNULLNULL9199 DESERT SKY BOULEVARDFresnoCA93746GRP-2304CORE-HMO
CLMCLM-4178292026-07-02T02:29:01ZASHLEYSBRADLEY1956-04-18····•••-••-48179799207989-N/Anull····———
CLMCLM-4325132026-02-27T09:20:27ZHarold—Pierce09/17/1958UHC-59853-76•••-••-8668—N/A5371 Park PlaceGlendaleArizona85370GRP-4266CORE-HMO
CLMCLM-4228802026-06-16T01:33:12ZJONETHAN—KELLY1985-10-27····-(584) 599-7566UNKNOWN··N/A-nullN/AGRP-8879N/A
CLMCLM-4055922026-01-10T20:31:54ZRACHEL—HANSEN1985-08-15—•••-••-76964718557··—2713 SUNSET BLVDGilbertAZ85244nullNAVIGATE-HMO
CLMCLM-4065752026-07-17T08:53:48ZJUSTINGCOOPER1991-11-81NULL•••-••-30382288619677UNKNOWN··7406 SPRING STMiamiFL33143null····
CLMCLM-4316262026-04-10T22:28:04ZGabriel—Rios07/09/1960UHC-91956-10··—(488) 634-7198NULL4839 OCEAN AVENUESAN ANTONIOTX78264GRP-3967—
CLMCLM-4262542026-07-27T23:47:58Z Gregory—Bennett1968-11-27UHC-81428-56null628-409-7765—4944 BroadwayChandlerAZ85250GRP-6916··MEDICARE-ADV-A
CLMCLM-4301862026-04-27T10:03:42ZRUNALD—THOMAS1999-03-07··UHC-18112-04N/A6868544321UNKNOWN700 Grand Ave··Los AngelesCA-GRP-4407MEDICARE-ADV-A
32,829 rows, page 156 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.346Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty