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-4222232026-09-30T12:00:10Z·william—morales1997-12-10UNKNOWNN/A963-281-8563—342 Grand AveMiamiFL33126—UNKNOWN
CLMCLM-4000312026-09-01T10:55:46ZMatthews, Jennifer——8/1/1957--····NULL1779 Harbor BlvdCHARLOTTENC28281GRP-6194—
CLMCLM-431061 2026-03-27T21:11:23ZJonathan—Hunt1991-05-28null—nullUNKNOWN7735 VALLEY VIEW DR·PlanoTX75023nullNAVIGATE-HMO
CLMCLM-4055522026-08-14T14:25:36ZSara—Carr14-07-2001—N/AUNKNOWNsara.carr24@outlook.com1350 Market StScottsdaleAZ85238··N/A
CLMCLM-4298722026-04-13T16:41:42ZAmber—James19420227UHC-46412-55•••-••-4350—UNKNOWN3347 Forest AvenueSacramentoCA95892GRP-4899NAVIGATE-HMO
CLMCLM-4166152026-02-21T04:08:04ZNOAH—TURNER1949-03-28····•••-••-09629412898050NULL441 Palm Drive Apt 37ChandlerArizona85287··GRP-7891··CORE-HMO
CLMCLM-4322452026-05-15T08:10:17ZFRAK—·ALEN1974-11-07UHC-03524-51-613.882.9522frank.allen@yahoo.com3277 Baseline Rd··SeattleWAN/Anullnull
CLMCLM-4313192026-04-18T21:07:26ZJOE—THOMAS03/01/07UHC-54570-05N/AUNKNOWNJOE.THOMAS@ICLOUD.COM····NULLUNKNOWN—null—
CLMCLM-4195372026-04-15T10:03:49ZBrooks, Henry——1980-08-28UHC-09209-87-(208) 698-1397henry.brooks@hotmail.com9799 PINE DRIVEDENVERCO·80217GRP-5513OPTIONS-PPO
CLMCLM-4015732026-03-19T12:46:29ZStephanie—Miller05/27/1992UHC-50204-08··UNKNOWN16092039771-339 Central Ave··JacksonvilleFL32212GRP-2979—
CLMCLM-4098122026-10-10T22:14:59Z Katherine—Richardson3/12/1946UHC-45309-24•••-••-7663—UNKNOWN8488 Ridge RdOrlando·FL32854GRP-1967NULL
CLMCLM-4038162026-02-04T13:38:04Zjesse—alvarez04/07/1939UHC-20741-25—16416446781N/A8496 Harbor BoulevardScottsdaleAZ85271N/A—
CLMCLM-4078092026-05-10T15:03:05ZJean—Burns1980-05-17—UNKNOWN··UNKNOWN——UNKNOWNnullnull·GRP-2272·CORE-HMO
CLMCLM-4078512026-04-20T17:25:03Z·alexander··perry08/25/1975UHC-24848-99•••-••-1442nullalexander.perry85@yahoo.comN/A—····—NULLnull
CLMCLM-4128582026-09-21T03:14:48ZMichaelVHarrison··7/9/1963UHC-04868-24N/A—NULL7551 Lake View RoadLOS ANGELESCA90095—NAVIGATE-HMO
CLM CLM-409101 2026-07-15T00:26:47Zgloria··hoffman·Dec 18, 1978UHC2551891•••-••-170319555756475null9333 HILLCREST RDMinneapolisMN55493GRP-2452-
CLMCLM-4031912026-05-09T06:37:36ZDaniels, Mary——1969-09-15··UHC-02753-64null(326) 242-6146mary.daniels@proton.me—UNKNOWNN/AnullGRP-2080OPTIONS-PPO
CLMCLM-4186942026-03-27T12:41:22Zdaniel—chavez·1944-07-20··nullNULLdaniel.chavez@yahoo.com629 MAPLE AVENUELos AngelesCA90080GRP-3092null
CLMCLM-4261672026-06-25T16:14:28ZKaylaC.Yang19520607UHC-08889-57—(529) 509-5466-7845 Palm DriveFresnoCAUNKNOWN·GRP-6014OPTIONS-PPO
CLMCLM-4301642026-05-28T22:32:31ZRAYMONDT.CASTILLO19-12-1944N/A•••-••-5821+1 373 942 2137NULL3054 Central AveNashvilleTN37289GRP-4783N/A
CLMCLM-4297722026-05-11T22:19:29Z·Mateo—Guerrero2001-04-08UHC-46112-25-UNKNOWNUNKNOWN955 Elm StSan AntonioTX78240GRP-0156—
CLMCLM-4263962026-07-05T13:23:36ZJan—Santos1966-06-17UHC-52788-39null2023610825—N/A——UNKNOWNGRP-6069SELECT-EPO
CLMCLM-4314992026-06-09T03:18:32ZKyle—Gonzalez1939-12-07UHC-63081-75nullUNKNOWN—UNKNOWNN/A-—GRP-3133··MEDICARE-ADV-B··
CLM CLM-4233142026-07-03T13:34:58ZElliott, Mark——Aug 23, 1981UHC-53509-99N/A(272) 855-6363UNKNOWN7325 HARBOR BLVDMinneapolismn55470NULLSELECT-EPO
CLMCLM-4102592026-08-23T12:49:12ZSandoval, Fatima——1987-09-14UHC-28392-80•••-••-3415·+1 895 661 5193—1902 MOUNTAIN VIEW DRIVEDenver··CO80295-4077-—
CLMCLM-4236792026-01-24T04:01:55ZLAWRENCE—GOMEZ14-08-1999UHC-68241-40—794-987-6641—6422 Harbor BoulevardDenver·CO80277-5188GRP-5390····
CLMCLM-4270792026-06-02T11:01:43Z Anndrews, SofiaU—1996-02-17uhc-65628-97—(690) 561-3448—N/A··-N/A····-
CLMCLM-4175672026-06-16T04:04:52ZRichardsonJDonald2000-06-11UHC-97967-62——nullN/A--N/ANULLCHOICE-PLUS-PPO
CLMCLM-4208862026-07-19T13:49:17ZBrittanyP.Guerrero1991-10-24UHC-24257-81NULL(944) 293-7989NULLNULLNULLUNKNOWNUNKNOWNGRP-0928OPTIONS-PPO
CLMCLM-4015492026-09-26T11:16:39ZNicolle—Maldonado1960-07-08UHC-16949-67•••-••-3271(792) 661-8076—88 MEADOW LNTucsonAZ85788N/ASELECT-EPO
CLMCLM-426183 2026-03-23T20:30:01Zjessica—pierce1960-03-20—•••-••-35105266419132NULL··1226 Jefferson AveLos AngelesCA90020····CHOICE-PLUS-PPO
CLMCLM-4277972026-09-10T07:51:21ZMark—Loepz09/19/1954UHC-01657-31N/A—NULL810 Mesa DriveSacramentoCA95812-CORE-HMO
CLMCLM-4223882026-03-07T20:46:29ZAngela—Burton7/8/1988UHC-28844-31—603.611.9592NULL6571 River RdOrlandoFlorida32886GRP-2316NAVIGATE-HMO
CLMCLM-4203952026-06-06T03:54:41Z·Christian—Simmons08/17/42———CHRISTIAN.SIMMONS72@HOTMAIL.COM2759 Main StreetAtlantaGAnullGRP-9523CORE-HMO
CLMCLM-4088152026-06-19T20:12:57ZvictoriaS.·franklin1941-05-14-•••-••-6932-—5345 VALLEY VIEW DRDenverCO80259NULLNULL
CLM CLM-4067042026-07-29T09:42:18ZlauraXmurray5/2/1945—·N/AUNKNOWN····5256 CEDAR LNAustinTX78723GRP-6600CHOICE-PLUS-PPO
CLMCLM-4073132026-08-12T14:59:24Ztommy—espinoza2002-10-08··NULL18288912604·-1690 Willow CourtNashvilletn37229··GRP-7392—
CLMCLM-4162252026-05-23T09:06:59Zdorothy—aguilar1941-10-14UHC-31767-90·····null—9809 Palm DrSan AntonioTX78200·GRP-2028UNKNOWN
CLMCLM-4025412026-05-07T20:15:48Zjames—delgado·12/2/1977—•••-••-6020(220) 839-8187UNKNOWN7763 BROADWAY #784TampaFL33649UNKNOWN··OPTIONS-PPO
CLMCLM-4114552026-10-07T02:58:44ZETHAN—VASQUEZ1973-06-11UHC-61918-98—UNKNOWNN/A·9113 Washington StLAS VEGAS·NV89122GRP-9264MEDICARE-ADV-A
CLMCLM-4064202026-02-11T12:00:52Zsamuel—ford08/17/1993UHC-57373-99N/A13986976535N/ANULLUNKNOWN—UNKNOWNGRP-3106MEDICARE-ADV-A
CLMCLM-4110052026-07-07T02:54:30ZDIANAV.MALDONADO·2003-11-10—UNKNOWN—UNKNOWNUNKNOWNUNKNOWN———null
CLMCLM-4139512026-05-01T02:13:17ZAbigail—Romero03-01-1978N/ANULLUNKNOWN·UNKNOWN4879 Desert Sky BlvdSAN ANTONIOTX—GRP-0251CHOICE-PLUS-PPO
CLMCLM-4282982026-05-30T20:27:19ZMike—Carpenter1995-07-11UHC-99707-65—7864243532UNKNOWN-—·null—GRP-8775MEDICARE-ADV-B
CLMCLM-4085942026-01-11T14:42:04ZSTEVEN—HOLMES1938-02-13··•••-••-84236089863242NULL6670 Washington StTempeAZ85245-6025GRP-9477N/A
CLMCLM-4211822026-04-20T20:41:47ZBetty····Daniels2/16/1994···UHC-73612-80N/A9647127372betty.daniels@icloud.com6649 Palm DrNashvilleTN37242—-
CLMCLM-4151052026-10-12T03:02:57Z FatimaIFord1992-05-16UHC-30941-57NULLnullnull——UNKNOWN-GRP-2926NULL
CLMCLM-4145052026-04-16T08:08:54ZWei—Willis11/23/98UHC-55764-27N/A····—·107 Meadow LnDallasTX75249-—
CLMCLM-4042792026-03-01T04:55:46ZETHANB.DEAN1976-05-04UHC-25740-72—N/A—3661 Lincoln Way Apt 25SAN ANTONIO·TX78224··GRP-6650·NAVIGATE-HMO
CLMCLM-4234232026-05-15T00:35:04ZCarolyn—PorterApr 2, 1960UHC-22051-92•••-••-48759604520210-··4594 River RoadSacramento·CA95815-7611nullNAVIGATE-HMO
32,829 rows, page 191 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.637Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty