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-4314172026-03-05T00:38:19ZZACHARY—JENKINS1986-03-05UHC-48075-09N/A(716) 363-8531N/A3374 River RdAustinTX78722GRP-9815-
CLMCLM-4054562026-03-21T19:04:20Zphilip—lawrence1991-10-02UHC2765589—+1 802 322 2072philip.lawrence@outlook.com1594 River RdChandlerArizona85200-5949·GRP-3638CHOICE-PLUS-PPO
CLMCLM-4015672026-06-09T09:19:04ZMEI··—SULLIVAN19491219-—(716) 424-4082—5720 Spring StJacksonvilleFL32217-0589NULL—
CLMCLM-4164552026-02-12T07:25:58Z·Henry—Duncan1948-07-01UHC-37120-86—N/Ahenry.duncan67@gmail.com7478 OAK STPhoenixAZ85025UNKNOWNNULL
CLMCLM-4071172026-05-23T21:42:46ZSHARON—ROGERS1971-03-15—•••-••-4191N/A··null··——··null··—
CLMCLM-4271052026-02-06T21:57:38ZLORI—BURKE1960-03-14UHC-84726-80UNKNOWN··958-298-6080NULL-N/ANULLN/AGRP-7980CORE-HMO
CLMCLM-4082232026-09-15T11:35:14ZSARAH—SPENCER2010-06-11UHC-56619-38•••-••-0834729.682.2004sarah.spencer7@outlook.com1763 Ridge RdEden PrairieMN55316nullMEDICARE-ADV-A
CLMCLM-4185042026-08-14T16:36:05ZRALPH—MONTGOMERY03/03/1968UNKNOWNN/AN/A—8841 Central AvenueJacksonvilleFL32223GRP-9074core-hmo
CLMCLM-4134912026-01-10T21:02:16Z JEREMY—ARMSTRONG··21-04-1989UHC-07659-04NULL718-807-0514·UNKNOWN·UNKNOWNN/A··—NULLGRP-9004N/A
CLMCLM-4111482026-04-27T11:35:16ZNOAH—BURNS20000303UHC-28541-33N/A503.580.0367UNKNOWN7504 BROADWAYTampaFL33687GRP-7351·N/A
CLMCLM-4088282026-04-11T16:54:03Zgrace—·jacksson1997-02-25UHC-37567-28··nullnull-··6072 Meadow LaneHOUSTONtxUNKNOWNGRP-0183—
CLMCLM-409447 2026-09-08T12:44:01ZRamos, Sara——1998-09-02UHC-90845-02•••-••-9265656-815-1176UNKNOWN4731 Sage CtSan DiegoCA92168NULL··null
CLMCLM-4101652026-07-07T03:11:30ZBevely—Austin2004-02-07NULLNULLnull—7677 BroadwayEden PrairieMN55370GRP-0834—
CLMCLM-4048202026-10-18T12:02:21ZStevenP.Estrada1940-10-15-nullN/A—6415 Baseline RoadHOUSTON·tx77090-··SELECT-EPO
CLMCLM-4032462026-05-08T23:00:51ZKenneth—Martinez11/26/1966NULL-(413) 645-4750-6621 SAGE CTFRESNOCA93735GRP-5749UNKNOWN
CLM CLM-4018322026-01-23T07:31:24ZRyan—Brooks12/27/08NULL—NULLNULL·3718 Main StFresnoCalifornia93773GRP-9393UNKNOWN
CLMCLM-4088652026-02-20T14:46:03ZMichelle····Bowman1947-11-06——·N/Anull·8737 Ridge Road #410AustinTX·78747—N/A
CLMCLM-4251462026-07-29T08:04:13ZCarlos—Jordan9/2/2006UHC-81783-75NULLNULLcarlos.jordan7@proton.me86 Oak StreetSacramentoCA95886N/A—
CLMCLM-429324 2026-05-29T01:12:40Zjordan—robertson19790913—NULL···NULL—1875 Ocean AveTempeAZ·85216——
CLMCLM-4060362026-05-14T16:43:14ZLrry—Barnes1958-04-09·N/A•••-••-4030N/AN/A2481 MESA DRSan AntonioTX··78207GRP-3520medicare-adv-a
CLMCLM-4303342026-01-03T11:07:28ZDiegoHContrerasFeb 23, 1948UHC-46032-06•••-••-1424—DIEGO.CONTRERAS@PROTON.ME2310 FOREST AVENUEEden PrairieMN55360GRP-3409navigate-hmo
CLM CLM-4005462026-07-22T11:23:36ZLNDA—PAYNE6/17/1958UHC-36742-54—····—3257 DESERT SKY BLVDSan AntonioTX78272——
CLMCLM-4108132026-09-09T19:18:24ZARJUN—RUSSELL1978-03-14UHC-27441-79NULLN/A—3080 Palm DriveSacramentoCA95858GRP-4869UNKNOWN
CLMCLM-4035832026-02-04T10:11:07ZFRANK—THOMPSON06-04-1992UHC-37893-53•••-••-3833NULL—-null—NULLGRP-0825NAVIGATE-HMO
CLMCLM-4317922026-01-09T18:18:50ZDiego—Porter1963-11-14N/AUNKNOWN676-438-2224—5795 Oak StNashvilleTN·37247—CHOICE-PLUS-PPO
CLMCLM-4117892026-09-03T05:20:02ZsamanthaVromero··1976-08-07UHC-70881-28··•••-••-75296645502381··NULL··909 Lincoln WayMinneapolisMN55447——
CLMCLM-4049072026-03-28T09:52:59Z·NANCY—KENNEDY1980-04-22UHC-57453-80•••-••-8074UNKNOWN———-NULL—CHOICE-PLUS-PPO
CLMCLM-4083322026-02-27T16:34:08ZJESSICA—VEGA09/05/1967—nullN/A—8510 RIDGE RDDallasTX—GRP-1473NAVIGATE-HMO
CLMCLM-4121372026-03-03T21:17:37Z·CatherineS.Wyllis1999-05-16N/Anull(947) 487-5647N/A9189 Ridge RoadNashvilleTN37282NULLSELECT-EPO
CLMCLM-4279182026-03-16T15:47:32Z DIEGOM.RAY19790724NULL—·UNKNOWN—203 Union StPhoenixAZ85011GRP-6108SELECT-EPO
CLMCLM-4099092026-06-14T22:30:07ZJORDANOFOWLER1992-07-25—UNKNOWNnullN/A8318 MESA DRIVEColumbusOH43277GRP-2959SELECT-EPO
CLMCLM-4255252026-06-06T23:33:33Z Scott—Estrada1963-12-10UHC-21355-47•••-••-0149-—2065 Bayshore DriveAustinTX78770GRP-2676SELECT-EPO
CLMCLM-4039322026-06-07T16:56:38ZLogan—HolmesApr 27, 1957·UHC-80073-60—(724) 400-5798nullnullnull—UNKNOWN—-··
CLMCLM-4023892026-06-04T04:20:59ZRyan, Linda——11-06-1952UHC-16663-51•••-••-8154(665) 557-2730UNKNOWN3595 ELM STScottsdaleAZ85297—MEDICARE-ADV-A
CLMCLM-4257752026-04-25T22:36:23ZKaren—Collins1993-03-04UHC-19163-11N/A···212-555-8617-—NULLN/A—·NULLSELECT-EPO
CLMCLM-4156352026-08-27T19:08:39ZDylan—Hudson·2005-07-01UHC-06408-75UNKNOWN14528069089··NULL3085 Camelback RdFresno·CA93777UNKNOWNnull
CLMCLM-413503 2026-05-07T13:23:25ZMarianaRLee1972-01-02UHC-21542-39NULL——6393 Main StreetAustinTX78706GRP-2412MEDICARE-ADV-B
CLMCLM-4248852026-01-19T00:31:47ZKelly—Carpenter2004-07-26NULL•••-••-4358—null9304 Mountain View DriveORLANDOFL32878GRP-0812UNKNOWN
CLM CLM-4208312026-10-12T00:57:07Z Sean··—ChapmanFeb 14, 2002UHC3556140•••-••-8504599-899-8129NULL6702 Church StMinneapolisMN55483GRP-0949NULL
CLMCLM-4203762026-09-15T05:42:13ZLORIVNICHOLS·03-10-1941UHC-19429-29nullN/Anull8962 UNION STREET·GilbertAZ85264-4833GRP-5429·SELECT-EPO
CLMCLM-4145962026-03-29T16:49:34ZSEANN.SANDOVAL1955-05-28·uhc-11554-69•••-••-1024——8736 Harbor BoulevardGilbertAZ85203-3228—SELECT-EPO
CLMCLM-4096942026-03-18T20:01:00ZCarlosRChavez1943-08-28—•••-••-1468NULLCARLOS.CHAVEZ@GMAIL.COM—NULLNULL·N/AGRP-3354-
CLMCLM-4069602026-04-08T07:30:42Znicole·SdanielsApr 24, 2008—•••-••-5090null—1019 Bayshore DrNashvilleTN37258—CORE-HMO··
CLMCLM-4110062026-04-04T11:18:23ZEric—Pierce1955-08-25UHC-11251-11null18286588563N/A-N/AN/A-GRP-8330NULL
CLMCLM-4213212026-08-30T15:04:53Z Maria—Fisher01/17/1979UHC-18891-77--··5536 Washington StCharlotteNC28228GRP-8670null
CLMCLM-4028252026-05-05T11:21:38ZChaarles—Ford··19500501UHC7104942·NULL(665) 629-9130N/A·5204 Washington StMESAAZ85230GRP-0445CHOICE-PLUS-PPO
CLMCLM-4315762026-08-12T01:51:13ZANA—SOTO1940-01-25UHC-71245-43···7794951800N/A234 Spring Street··TempeAZ——UNKNOWN
CLMCLM-4141682026-03-16T03:03:45ZJESSICA—WANG2003-01-20UHC-04085-61UNKNOWN-UNKNOWN5652 Meadow LnSacramentoCalifornia—GRP-8313MEDICARE-ADV-A
CLMCLM-4323752026-07-05T23:39:38Zdebra—aguilar··1995-07-07UHC-12963-51··UNKNOWN··--6008 Sage Court Apt 24GilbertAZ85294··NULLCORE-HMO
CLMCLM-4050222026-05-18T13:20:38ZWILLIE—COLE1958-09-21·UHC-94020-81——N/A1476 SUNSET BLVDNashvilletn37296nullCORE-HMO
32,829 rows, page 92 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:37.765Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty