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-4115602026-01-16T11:40:22Zsamantha—simmons02/10/97UHC-59590-89•••-••-9641N/A····N/A—null·NULLGRP-1429—
CLMCLM-4300282026-02-20T00:14:52ZJanetMMendoza11/23/1989null•••-••-9076N/ANULL8416 Park PlLas VegasNV89156GRP-3722—
CLMCLM-4134152026-09-05T06:41:52Z·Bobby—MillerJan 10, 1995—UNKNOWN··371-314-3240-··3637 HARBOR BOULEVARDTUCSONAZ85759GRP-0578—
CLMCLM-4041892026-08-22T00:18:31ZMendez, Ryan——1969-06-26null·--UNKNOWN2216 Lake View RdFresnoCA93714GRP-6086NULL
CLMCLM-4120592026-04-19T01:40:08ZSoto, Lisa——19800816UHC-28518-82null+1 875 544 4993-264 ELM STREETSACRAMENTOCA95876—NULL
CLMCLM-4210642026-05-26T11:31:00Z SARA—POWELL2005-02-03UHC-53835-44null——4148 OCEAN AVENUEHOUSTON··TX77044NULLCHOICE-PLUS-PPO
CLMCLM-4174962026-04-18T09:56:51ZDANIL—MENDEZ11/04/58UHC-21332-78•••-••-6857(978) 756-4344UNKNOWN1144 Main StColumbusoh43225GRP-5926CORE-HMO
CLMCLM-4060922026-02-15T10:38:59ZKayla··—Myers11/25/1980-—439.380.3860kayla.myers29@gmail.com3718 CHURCH STREETTampaFL33686GRP-1965CHOICE-PLUS-PPO
CLMCLM-4139722026-01-29T11:44:29ZWillie····King·1963-06-12UHC-42174-16—3193806185null2183 Cedar LaneMiamifl33177GRP-0544CORE-HMO
CLMCLM-4018502026-03-23T13:01:51ZJacob—Holmes1993-04-12null•••-••-1501UNKNOWNnull·9299 Apache BoulevardAustinTX78764GRP-0237null
CLMCLM-4212232026-01-12T08:28:48Z christian—butler1982-04-27UHC4594622-(271) 631-7792—9899 River RoadGlendaleAZ85372GRP-7922MEDICARE-ADV-B··
CLM CLM-4272722026-09-18T06:20:51ZAndrea··—Valdez2000-11-17—•••-••-9049·6814723903UNKNOWN3560 Camelback RoadAtlantaGA30355UNKNOWNnull
CLMCLM-4111602026-02-12T09:21:13ZDaniel—Owens1958-10-04UHC-79405-15•••-••-04575598693732—1513 CEDAR LNAtlantaGA··30313GRP-3940null
CLMCLM-4014232026-03-10T08:54:46ZMARIA—SINGGH1983-05-20UHC-69979-70-(596) 358-2387UNKNOWN8998 Jefferson AvenueLAS VEGASNVN/AN/AOPTIONS-PPO
CLMCLM-4008282026-07-14T20:51:54ZAlbert—Henderson03-10-2008UHC-24876-65—(755) 796-9806—NULL—nullnullnull—
CLMCLM-4249572026-10-09T16:49:22ZVICTORIA··—HERRERA1985-11-07UHC-13803-78•••-••-7174N/AnullNULLnullN/AnullGRP-0615null
CLMCLM-4033492026-07-28T01:54:09Z·ANAO.SANTOS10/17/1940UHC-93279-73·UNKNOWN5909973736UNKNOWN7064 Indian School RoadTucsonArizona85779GRP-7915SELECT-EPO
CLMCLM-4220012026-07-18T15:57:19ZValentina—Howard1987-04-16UHC-34313-98··•••-••-78576372100298··null9834 Valley View DriveSan DiegoCA92155GRP-9596—
CLM CLM-4321932026-07-04T04:44:03Zjoe—herrera·Nov 14, 1993UHC-92339-35··N/AnullNULL······N/AN/A—null-··
CLMCLM-4101242026-09-10T20:15:58ZAbigail—Hicks1970-08-17UHC-60211-80•••-••-8219-null5753 Union StMiami··Florida33105GRP-1170MEDICARE-ADV-A
CLMCLM-4274432026-09-17T17:12:54ZPHILIP—VALDEZ2002-07-04UHC-98601-37•••-••-7328N/Aphilip.valdez@proton.me2007 Mountain View DriveEDEN PRAIRIEMinnesota55320GRP-5936···SELECT-EPO
CLMCLM-4010272026-07-25T02:30:32ZMaria····Long19271104·-—9763378811—5897 Central AveGlendaleAZ85322-6978nullMEDICARE-ADV-A
CLMCLM-4056412026-07-15T17:08:07Z andrew··davis19800319UHC-87127-13—(940) 465-9477null1983 Oak StreetTucsonaz85725GRP-5239SELECT-EPO··
CLMCLM-4286882026-07-19T05:16:39ZWang, Isabella——1990-00-86—UNKNOWNnullisabella.wang@icloud.com600 Church StMinneapolisMN·55433-2794GRP-6254··navigate-hmo
CLMCLM-4272232026-07-25T05:40:39ZTeresaV·Sims1981-01-25UNKNOWNUNKNOWN7185091UNKNOWN-N/Anull——N/A
CLMCLM-4124912026-05-30T03:12:50Z Nguyen, Henry——1975-07-18UHC-89598-34-—HENRY.NGUYEN@ICLOUD.COMUNKNOWN—N/Anull—MEDICARE-ADV-A
CLMCLM-4296192026-01-30T14:08:23ZPatrcia—Murray05/27/50UHC-35124-01•••-••-8753+1 806 611 4608null9786 Ridge RdSan Diegoca92152GRP-1876MEDICARE-ADV-A··
CLMCLM-4015722026-03-17T10:11:38ZJeffreyQ··Myers19500919UHC-03305-03NULLnullUNKNOWN7510 Hillcrest RoadAustinTX·78777-7216GRP-3421—
CLMCLM-4046322026-07-30T07:43:37ZVICTORIA—HOWELL3/19/1975UHC-24098-48•••-••-1956——6828 Spring Street··LAS VEGASNV89112GRP-2528-
CLMCLM-4085812026-03-31T23:43:03Zburns—stevn8/12/1978UHC5233952NULL7487036743null6845 Elm StreetCharlotteNC28272-0473GRP-1305-
CLMCLM-430739 2026-06-30T04:59:27Zroy—daniels1973-02-08UHC-47531-25UNKNOWN957.424.4534—7052 Sunset BlvdMinneapolisMN55454GRP-2074MEDICARE-ADV-A
CLMCLM-4060422026-06-04T03:44:51ZBarbaraPBlack04/19/1963—•••-••-3578(605) 658-2920—1069 Valley View DriveChandlerAZ··85280—SELECT-EPO
CLMCLM-4116872026-02-16T22:31:12ZGARY—PATTERSON2003-02-21··UHC-44843-27•••-••-1813(230) 854-0243UNKNOWN1153 RIVER RDGilbertAZ85286··GRP-3433NAVIGATE-HMO
CLMCLM-4258912026-02-16T11:10:45Zrandy—edwardsApr 7, 1967-··-N/A··-1054 WASHINGTON STREETMiami··Florida33128GRP-3470—
CLM CLM-4117602026-06-10T07:24:39ZJACKIE—SOTO1959-08-05UHC-59864-67•••-••-0725—--—-—UNKNOWNMEDICARE-ADV-B
CLMCLM-4123282026-01-17T01:56:44ZHarris, Juan——11/17/1964UHC-78189-72—7794991234··UNKNOWNUNKNOWN····—null·NAVIGATE-HMO
CLMCLM-4237262026-09-25T04:01:59ZColilns, BubbyT—1940-50-15UHC-46738-01•••-••-0915243-348-5637null8599 LAKE VIEW RD··TempeAZ85265—CORE-HMO
CLMCLM-4250662026-08-07T10:31:07Zdanielle—·henry1950-11-16—·NULLUNKNOWN—863 OCEAN AVENUETempeAZnullGRP-8982MEDICARE-ADV-A
CLMCLM-4146892026-02-13T18:28:55ZOlivia—Franklin1955-09-28NULL•••-••-01002213349739-··6531 Hillcrest RoadSAN DIEGOCalifornia92125UNKNOWN··-
CLMCLM-4230802026-05-26T23:15:15Zscott—sanchez2004-01-20uhc-28082-14—812-934-0977—2598 Ocean AvenueScottsdaleArizona85278——
CLMCLM-4031022026-03-14T06:04:56ZBrandon····WagnerDec 16, 1960UHC-41934-48—282-857-7953-1788 HIGHLAND AVECharlotte··NC28202-·-
CLMCLM-4153822026-10-13T11:40:09ZGERADLNJMIENEZ1970-12-07UHC-02738-67null16312204467NULL109 Lincoln WayEden PrairieMinnesota55331·GRP-5310·CHOICE-PLUS-PPO
CLMCLM-4205152026-04-12T21:53:10ZJim··Wright1993-08-27UHC-88515-11NULLN/A—8840 CEDAR LN Apt 33COLUMBUS··OH43225GRP-0788—
CLMCLM-4115512026-09-29T22:15:56ZMari····Dixon1965-03-20UHC-59100-04•••-••-6961514.332.5206maria.dixon12@aol.com——N/ANULLGRP-0150-
CLMCLM-4070382026-06-27T10:37:32ZISABELLA—GOMEZ1977-02-04UHC-25379-25•••-••-55638992453642—2400 WILLOW CT #239AustinTX78722—NAVIGATE-HMO
CLMCLM-4254912026-02-12T15:31:26ZKathleen··Jordan1993-05-20nullN/A··(456) 265-3540null·NULL····N/AUNKNOWNGRP-4054··—
CLM CLM-4231922026-06-05T20:14:54ZNICHOLASTJENKINS19530718NULL•••-••-4197—NULL6227 Spring StreetTucsonAZ85788GRP-8268MEDICARE-ADV-B
CLMCLM-4112652026-03-17T19:08:45ZOmar—Wheeler05/05/60UHC-30732-71null2125578510-239 Camelback Road·ChandlerAZ85210GRP-5208—
CLMCLM-4123762026-07-09T09:11:00ZMeiWLee04/03/96·null•••-••-832317883654205—-—UNKNOWN—GRP-8079MEDICARE-ADV-B··
CLMCLM-4285732026-07-15T12:10:18ZGabriel R—Barnes12/06/90UHC-60346-86N/Anull-3179 Sage CtSan Diego··CA92114GRP-5041NAVIGATE-HMO
32,829 rows, page 134 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.312Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty