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-4008612026-04-20T07:43:15ZMunoozJBrandon·1965-08-06UHC-24440-97null419.903.4858null466 DESERT SKY BOULEVARD·JacksonvilleFL32253GRP-2664MEDICARE-ADV-B
CLMCLM-4250772026-02-14T13:00:31ZELIJAH··WILLIAMS··19591023UHC-93427-23•••-••-0416nullN/A1960 Apache BoulevardHoustonTX77066-9411GRP-1912N/A
CLMCLM-4214552026-02-21T03:53:18Z ·Bruce—·Jenesn1965-06-05—-UNKNOWN—9140 Oak StreetSAN DIEGOca·92120—NAVIGATE-HMO
CLMCLM-4211572026-04-20T20:15:05ZAlbert—Le2008-12-24UHC-06229-79UNKNOWN——NULLN/A——····CORE-HMO
CLMCLM-4015772026-01-06T21:29:29ZNOAH—LE1974-11-02UHC-07883-92•••-••-7018+1 514 531 2747··-—N/AN/A·nullMEDICARE-ADV-A
CLMCLM-4050982026-07-27T17:12:01ZMARILYN—ROMERO·1954-08-02uhc-22595-40—N/A··—2973 Main Street #195Eden PrairieMN55338GRP-8296null
CLMCLM-4124862026-09-14T03:09:04ZRick··KTucker1991-10-05UHC-83126-16NULLUNKNOWN-N/AnullUNKNOWN-——
CLMCLM-4120042026-09-15T00:56:31ZJoshua—Sanders19520607UHC-21780-50··—(473) 825-8178·NULL9202 Hillcrest Rd Apt 25TempeAZ85217UNKNOWNCORE-HMO
CLMCLM-4188172026-02-02T21:12:46ZJordan, HenryR—05/02/68—•••-••-4131361.243.1772HENRY.JORDAN93@OUTLOOK.COM3607 Ridge RdTampaFL33646-8631nullCHOICE-PLUS-PPO
CLMCLM-4308682026-06-07T23:01:57ZDennis·····Brown1944-05-22··N/A•••-••-2007-—5143 CEDAR LANEMinneapolismn55447UNKNOWNMEDICARE-ADV-A
CLMCLM-4184102026-10-18T01:22:31ZMELISSA—TRAN8/11/1978UHC-46772-18——null2670 Bayshore DriveATLANTAga30348GRP-5088CORE-HMO
CLMCLM-4264552026-05-20T21:23:51ZScoott—Nguyen1957-04-16UHC-55213-44··N/A9104852404N/A3549 FOREST AVENUENashvilleTN37216GRP-5736null
CLMCLM-4050802026-07-17T23:00:45ZNATHAN—JACOBS1946-07-40UHC3486004UNKNOWN-—2410 River RdMesaArizona85227··GRP-4570UNKNOWN
CLMCLM-4207522026-02-23T04:20:15ZArnold, MarianaI—07/07/1967·UNKNOWN—N/A—495 MEADOW LANE··Austintx78761GRP-9404··OPTIONS-PPO
CLMCLM-4293902026-03-26T23:25:17Zchristina—robinson1983-12-26UHC-12497-27NULL(947) 481-8366-—N/Anull-GRP-1829null
CLMCLM-423344 2026-03-15T15:06:43ZAmyICastro26-03-1989UHC-54680-35•••-••-9941(208) 462-1583-··—UNKNOWNnull—GRP-3831—
CLM CLM-426271 2026-01-30T01:50:23Zkelly—mitchell7/13/1991UHC-46965-75NULLNULL-256 SUNSET BLVDSeattleWA98147-0580GRP-4092CHOICE-PLUS-PPO
CLMCLM-401705 2026-07-07T16:36:04ZSEAN—NUNEZ10/03/1997UHC-98948-59··NULLN/A····4431 Forest Avenue #376FresnoCA93704GRP-3779OPTIONS-PPO
CLMCLM-4049202026-07-19T21:20:23ZwayneCyoung2003-07-25UHC3232681•••-••-28499753249945-··N/AnullNULL—GRP-9327OPTIONS-PPO
CLMCLM-4312042026-02-26T07:23:27ZJones, Bradley——1962-03-17-NULL(747) 572-1260—6499 Bayshore DriveHOUSTONTX··77064NULLOPTIONS-PPO
CLMCLM-4207632026-07-02T03:17:48ZRoy—Andrews9142-06-18UHC-51669-56———6594 RIVER RDCOLUMBUSOhio······GRP-0308NULL
CLMCLM-4187622026-02-26T03:38:57Z·CHERYL—SILVA·1960-05-07UHC-61430-78UNKNOWN+1 307 975 2556UNKNOWNUNKNOWNUNKNOWNNULLNULL—choice-plus-ppo
CLMCLM-4236632026-01-04T04:09:37ZEUGENE—FRANKLIN1999-06-01··NULL19537519462··NULL·4137 Mountain View DrMiamiFL33145GRP-0855··—
CLMCLM-4112512026-02-05T02:35:11ZWebb, HeatherB—1970-16-17NULL•••-••-6880UNKNOWN—4296 HARBOR BLVD··DallasTexas75252GRP-4791··UNKNOWN
CLMCLM-4112552026-07-09T21:56:11ZGABRIEL—GRAY20010825UHC-14318-72—3388153032N/A·8384 LINCOLN WAYGilbertAZ85257UNKNOWNOPTIONS-PPO
CLMCLM-4116262026-08-21T22:52:37ZHenry, SantiagoF—1995-11-06—N/A+1 315 705 8390—226 Canyon RoadMESA··AZ85255-OPTIONS-PPO
CLMCLM-4036962026-09-07T22:15:52ZChristina··Burke13-06-1976UNKNOWNN/AUNKNOWNNULL5791 Cedar LaneGlendale·AZ····——
CLMCLM-4028762026-08-28T17:08:08Z HeatherO.Lawrence·06-05-1964UHC-82881-79··—-UNKNOWN1794 ELM STREETGlendaleAZ85376GRP-3993select-epo
CLMCLM-4127072026-03-27T09:56:28ZRANDY—DIXON1991-08-06UHC1767969-null—6924 Willow CourtAtlanta·GA30381-4547GRP-6791NAVIGATE-HMO
CLMCLM-4205182026-10-18T14:20:53ZWONGK.ABIGAIL04/22/1955null——abigail.wong20@proton.meNULL—UNKNOWN—GRP-8260UNKNOWN
CLMCLM-4327462026-07-26T12:17:11ZPHILIP—RIOS1974-06-24—NULL730-488-0125—7523 Bayshore DrSan DiegoCA92191GRP-4153SELECT-EPO··
CLMCLM-4119152026-06-13T22:58:39ZNathan····Robertson1995-01-26UHC-43232-11•••-••-6198N/Anathan.robertson@yahoo.com1798 Desert Sky BlvdFresnoCA93744GRP-9571CHOICE-PLUS-PPO
CLMCLM-4003882026-07-31T12:09:03ZMaria—Dominguez19970823UHC-24070-78•••-••-5830·851-542-8995—5877 Lake View RoadMesaAZ85266GRP-3756··
CLMCLM-4297742026-05-05T11:28:56ZKATHRYN··IWALLACE1991-04-10NULL•••-••-4136nullKATHRYN.WALLACE84@HOTMAIL.COM8278 Canyon Road Apt 19JacksonvilleFL32271GRP-9014—
CLMCLM-4303842026-05-07T22:13:36ZKarenNMitchell09/02/1949UHC-80730-37UNKNOWN+1 789 635 6262··5453 Spring StreetLos AngelesCA90075nullnull
CLMCLM-4198662026-04-20T22:02:24ZBeenjamin—Cruz12/13/1995——7045882662null-····UNKNOWN·null——
CLMCLM-4026482026-03-06T07:51:23ZGEORGE—BROWN1982-06-15NULL•••-••-52726792577583NULL8083 Ridge RoadPlanoTX75028·GRP-9468·CORE-HMO
CLMCLM-4289382026-08-05T10:41:15ZVictoria—Nunez1991-02-24nullnullNULLUNKNOWN5348 Central AvenueHoustonTX77087NULLSELECT-EPO
CLMCLM-4084332026-06-08T12:05:52ZRyan—Diaz1991-04-01—•••-••-88743212105174NULL1621 Willow Court #290Columbus··OH43295GRP-1969-
CLMCLM-4029902026-01-01T14:25:53ZCook, Gary—····1970-06-01UHC-97450-56—5615335122UNKNOWN6769 Central AveLas VegasNevada89148GRP-2375NULL
CLMCLM-4306782026-09-17T15:15:57ZNICHOLAS—SCHULTZ1952-09-10UHC-04878-11UNKNOWN450-907-4005—·441 Ocean AveDenverco80216·-UNKNOWN
CLMCLM-4088362026-09-24T17:39:38ZCharlesF.Edwards·11/15/1939UHC5078907NULL6846964615NULL7460 Bayshore Drive Apt 26San Antonio··tx78220-8885GRP-8208NAVIGATE-HMO
CLMCLM-4270122026-06-11T04:16:20Z·Christian—ClarkSep 17, 1953UNKNOWN•••-••-5313-N/A2938 Maple AvenueChandlerAZ85239——
CLMCLM-4138182026-07-26T18:09:22ZAnn—Salazar1991-01-03NULLUNKNOWN751.677.6064NULL4627 Union StreetPhoenix··Arizona85089GRP-3233MEDICARE-ADV-B
CLMCLM-4292962026-04-06T00:22:53ZMurray, Adam——1965-11-04UHC-44804-05—17455147526UNKNOWN474 Pine DrColumbusOH43242GRP-9925NAVIGATE-HMO
CLMCLM-4248292026-01-24T12:31:59Zjose—patterson1982-09-22N/AUNKNOWN8496550950null9395 SUNSET BLVD #277··HOUSTON·TX77066GRP-5037MEDICARE-ADV-A
CLMCLM-4299092026-09-30T03:42:56ZCarroll, Barb——23-01-1966—•••-••-923315239637570—7998 Harbor BoulevardSan DiegoCA92116nullnull
CLMCLM-4125132026-05-20T01:42:03ZSteven—Bradley19521119UHC-17904-26UNKNOWN——4367 Desert Sky BlvdHoustonTexas77010GRP-0202MEDICARE-ADV-A
CLMCLM-4041482026-08-22T20:57:38Zlua—zachary1949-03-04UHC-56365-90null·499.382.5921UNKNOWNNULL·N/Anull·N/AGRP-7241null
CLMCLM-4103902026-07-14T22:29:24ZElijeh—·Washington·09/07/1979NULL—9886230862nullnull——UNKNOWNGRP-1253OPTIONS-PPO
32,829 rows, page 189 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.634Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty