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-4220462026-04-10T16:23:15ZCAMPBELL—CARLOS18-06-1961UHC-89227-34•••-••-4604NULL·NULL1159 BAYSHORE DRIVE Apt 18AustinTX78762GRP-9054N/A
CLMCLM-4234092026-01-05T15:34:25Znicole—arnold05/10/79UHC-18919-15•••-••-3744(562) 333-6184UNKNOWN3165 Mesa DriveChandlerAZ85231GRP-6222null
CLMCLM-4066422026-08-14T11:58:09Z·Roger—Patel1944-11-04UHC-80721-12•••-••-58986635326181—1629 Union StreetLas VegasNV89176GRP-4850medicare-adv-b
CLMCLM-4069852026-03-16T14:33:31ZDEBRA—ORTIZ1998-11-25UHC-91264-58—UNKNOWNnull4384 PINE DRIVE··TempeAZ85240GRP-6609UNKNOWN
CLMCLM-4058402026-08-31T05:02:49ZStephens, Ruth——26-11-1956UHC-49733-39•••-••-1177N/A—nullnullN/A—GRP-1630SELECT-EPO
CLMCLM-4284052026-08-23T07:12:51ZJulie—Evans03/18/1989UHC-83800-79··UNKNOWN—N/Anull—UNKNOWN—SELECT-EPO
CLMCLM-4077732026-05-27T12:39:54ZCharlesOEllis1972-11-13UHC-01634-67N/AUNKNOWN··NULL9432 Church StreetSan DiegoCA92152-1692—NULL
CLMCLM-4240532026-07-27T09:04:44Zkimberly··—gisbon2004-07-23UHC-59029-58NULLN/Anull3019 Mesa DriveHOUSTONTX—NULLCORE-HMO
CLM CLM-4279912026-05-23T17:04:18ZKennedy, Janice——14-03-1948UNKNOWN-···5265523510N/A7102 Union StDenverCO80248-0961GRP-9117SELECT-EPO
CLMCLM-4227282026-07-04T22:57:46Z BENJAMIN··—FULLERMar 15, 1964·UNKNOWNnullN/ABENJAMIN.FULLER81@GMAIL.COMUNKNOWNnullNULL-GRP-7658··UNKNOWN
CLMCLM-4116112026-09-15T22:59:30Z ALEXIS—HUNT1978-10-09·UHC-21311-85null··N/A—6601 MAPLE AVE··Tempeaz85245GRP-0759null
CLMCLM-4148712026-01-05T12:11:07ZDIANE—LEIWS2004-11-22UHC-04826-30—nullN/A··69 Cedar LnSacramentoCA95872N/ACHOICE-PLUS-PPO··
CLMCLM-4141662026-05-19T08:33:55ZJessica—Wang2003-01-20NULL•••-••-0473NULLUNKNOWN5652 Meadow LnSacramentoCA95839—NULL
CLMCLM-4254512026-02-23T18:52:20ZRay····Grant1957-06-21UNKNOWN•••-••-4303525.409.5899—9859 Elm StreetMiamiFL33170-4850··GRP-7139—
CLMCLM-4057412026-05-14T20:05:08ZBOBBY—MASON·20030520—•••-••-98847065716092UNKNOWN2306 MESA DRIVE #785CharlotteNC28203—SELECT-EPO
CLMCLM-4119192026-01-22T12:01:34ZJulia—Adams1962-04-13—•••-••-6311····NULL4202 Cedar LaneAtlantaGA30386GRP-4819medicare-adv-a
CLMCLM-4205302026-01-29T02:18:45ZJOSEMSTEWART1985-06-11UHC-32916-70•••-••-4421-JOSE.STEWART@YAHOO.COM··NULLUNKNOWN··nullN/A·GRP-6560OPTIONS-PPO
CLMCLM-4041432026-07-04T06:19:52ZCAMILA—ALVARADO19-07-1977uhc-49908-53-—NULL2575 PARK PLACECharlotteNC28201GRP-0380CORE-HMO
CLMCLM-4253382026-07-08T14:39:11ZThomas Q.—Matthews2002-08-28UHC-58466-91•••-••-5888-—-····—·UNKNOWNnullOPTIONS-PPO
CLMCLM-4088802026-09-21T17:44:59ZJuna—Powell01/22/75UHC-99289-88····451-771-2270··-1179 Bayshore DriveLos AngelesCA90058GRP-7466N/A
CLMCLM-4105292026-08-17T05:48:57Zbradley··perkins8/26/2003—•••-••-3823··null616 Lincoln WaySacramentoCA95898GRP-2294N/A
CLMCLM-4255322026-04-05T19:41:06ZWebb, Stephen··Y.··1950-06-21UHC-02013-78•••-••-1139702-864-1262—7464 CANYON RDMinneapolisMN55473GRP-0960UNKNOWN
CLMCLM-4088942026-07-06T09:18:00ZGERALD—MUNOZDec 16, 1949UHC6921394—NULL—-——nullGRP-5895—
CLMCLM-4041302026-08-10T01:35:13Z Cheryl—Simmons2002-12-17··UHC-92867-01•••-••-6886N/AUNKNOWN3156 BASELINE ROADSacramentoCA95896GRP-7521CHOICE-PLUS-PPO
CLMCLM-4018582026-03-12T04:32:05ZSamuel—Myers1979-04-02UHC-50709-05N/A(584) 954-5491-2560 Baseline RoadFresnoCA93772N/A-
CLMCLM-4281652026-07-15T04:37:41ZDylanUKig1938-09-20··nullUNKNOWN+1 427 649 8907·-2534 Market StreetCOLUMBUSOH43275GRP-7417CORE-HMO··
CLMCLM-4237352026-09-17T20:04:48ZEmily—Hill21-10-2004UHC-56455-83•••-••-9743NULL——null—·-—-
CLMCLM-4090382026-02-24T07:29:12ZHicks, Albert—····2008-09-12UNKNOWN·-+1 807 267 7151—6396 Sage CourtSacramentoCA95898·NULL·null
CLMCLM-4078432026-01-16T07:11:00Z———19680913UHC-72065-17•••-••-3338——3206 MEADOW LANEScottsdaleaz85205··GRP-1525··MEDICARE-ADV-A
CLMCLM-4095472026-06-03T10:46:03ZStephanie····HendersonApr 19, 1999—NULL4776563789stephanie.henderson@icloud.com2267 Sage Court·SacramentoCA95811GRP-9686MEDICARE-ADV-A
CLMCLM-4315322026-02-08T08:09:05ZZachary—Scott12/24/1949null———·8108 Canyon Road·PLANOtx75085-·CORE-HMO
CLMCLM-4234342026-07-19T20:08:23ZBetty—Gonzalez5/12/1961UHC-67685-44-(766) 316-1014—8432 Canyon RoadPlanoTX75027··GRP-4426··—
CLMCLM-4144842026-04-25T04:07:50Z·TIM—SIS2008-09-12UNKNOWN····NULL-N/A—-N/AN/ASELECT-EPO
CLMCLM-4083832026-01-11T06:10:46ZNicholas—OrBien1958-09-02UHC7732914N/A··511.529.7318—4628 Sunset BoulevardLas VegasNV89125GRP-7011null
CLMCLM-4054512026-07-29T18:20:23ZMcDonald, JacobU—1938-03-26··N/A•••-••-6660+1 716 750 1791null—N/ANULLNULL·GRP-0606MEDICARE-ADV-B
CLMCLM-4319832026-02-28T16:22:10Zalexander—wells1960-08-11UHC-85686-20NULLnull—NULLNULLNULL··GRP-6090MEDICARE-ADV-B
CLMCLM-4269132026-04-25T08:05:05ZSUSAN—MORRISON1959-02-28UHC-92801-47UNKNOWN—SUSAN.MORRISON@OUTLOOK.COM2746 APACHE BOULEVARDDenverColorado80252GRP-5352NULL
CLMCLM-4086302026-03-07T22:03:43ZMunoz, Theresa——6/25/1941UHC-11208-80•••-••-52129573749—5154 Harbor BoulevardTAMPAFL33671··GRP-4811SELECT-EPO
CLMCLM-4303632026-06-10T01:19:33ZJanetNReedMay 16, 1958—N/A7635444301-N/AUNKNOWN——UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4275822026-07-27T02:45:16ZRalph—Peterson1995-08-04null•••-••-3133(458) 857-1984UNKNOWN1958 Market StSacramentoCA··95883-8052GRP-0505N/A
CLMCLM-4297052026-03-26T21:24:15Zjoshua··park6/3/1943NULL—836-959-2846null5944 Church StAustinTexas78727GRP-8938··CHOICE-PLUS-PPO
CLMCLM-4229272026-08-22T14:11:24Z—····—1997-02-09—•••-••-3246982-697-2447——NULL—-—SELECT-EPO
CLMCLM-4149062026-06-28T03:20:41ZJOSE—EDWARDS1994-08-22N/A•••-••-0897931.494.1398NULL6240 Elm StreetMESAAZ·85249-9453GRP-4980MEDICARE-ADV-B
CLMCLM-4071722026-06-11T19:40:11Zbeverly··bennett1977-03-21UHC-04971-47•••-••-528315639347126N/A·8135 Mountain View DrNashvilletn37243GRP-5616CORE-HMO
CLMCLM-4187812026-03-10T19:38:16ZDoris····Powell1996-12-12·UHC-43897-58-343-511-2823N/A2154 MAIN STREETSacramentoCA95825-8539··-—
CLMCLM-4057512026-09-10T17:38:26Zkeeith—long1947-10-25··—··6159738489UNKNOWN7989 Maple AveMiamiFL33196-2136GRP-9336MEDICARE-ADV-A
CLM CLM-4004192026-03-08T11:10:19ZAmanda—Jensen1965-12-05UHC-53230-53N/Anull—4743 PARK PLACEColumbusOH43220-1071GRP-1940CORE-HMO
CLMCLM-4222472026-06-05T02:09:16ZJaniceRWong·1966-03-21N/A•••-••-1244599.739.7705N/A3914 Sunset BlvdFresnoCA93741UNKNOWN··CHOICE-PLUS-PPO
CLMCLM-4199422026-01-09T23:27:32ZROBQPRICE04/12/1967—•••-••-4191—-null—null———
CLMCLM-4126712026-07-17T06:38:42ZRoger—Olson1989-08-11UHC-20745-75•••-••-6976611.287.5139N/A5700 Market StreetPlanoTX75023-SELECT-EPO
32,829 rows, page 132 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.306Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty