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-4167832026-04-16T11:19:42ZCheryl—Butler1997-02-05UHC-37634-84-NULL—5797 Cedar LnOrlandoFL··32848GRP-4327··MEDICARE-ADV-B
CLMCLM-4165812026-10-06T08:46:37ZRaamirez, Mason——1988-07-17N/A•••-••-6041969.981.8355N/A7429 Bayshore DrJacksonvilleFL32296GRP-1158NULL··
CLMCLM-4105092026-04-08T21:23:20Zpatrick—gutierrez1972-12-13UHC-95777-12•••-••-2264nullpatrick.gutierrez@hotmail.com8668 Mesa DriveLos AngelesCA-·NULLNULL··
CLMCLM-4155642026-10-11T02:00:09ZLORI··—ROBERTS—UHC-78605-17··NULL—-9741 Canyon RoadHOUSTONTX77071-3904GRP-8037MEDICARE-ADV-B
CLMCLM-4075772026-08-12T07:15:00ZMateo—Salazar1960-07-25N/A-12698371994—·1316 BroadwaySan AntonioTX78252····SELECT-EPO
CLMCLM-4264592026-10-15T09:11:47ZMATTHEW—JONES1999-10-07·NULL•••-••-0531—--UNKNOWNnullUNKNOWNGRP-4085UNKNOWN
CLMCLM-4159882026-08-22T04:39:55Z Teresa—Reyes1999-06-10-UNKNOWNnull—·1268 Hillcrest RoadLAS VEGASNV89101GRP-3491CORE-HMO
CLMCLM-4235612026-02-23T11:55:44ZMary—Reed19620505UHC-27530-28-——1552 JEFFERSON AVENUESan DiegoCA92185GRP-1782NAVIGATE-HMO
CLMCLM-4154042026-06-01T16:43:12ZJean—Young1940-05-22UHC-88826-06•••-••-4783(378) 437-4877null8587 Hillcrest Road··Las VegasNV89110null—
CLMCLM-4086402026-08-31T02:11:39ZEmma—Kennedy08/12/2004UHC-01628-56······+1 855 577 3381emma.kennedy@icloud.com····-—·-····—
CLM CLM-4207482026-08-08T17:51:42Z Walter—Hernandez11/13/2001—•••-••-9997—UNKNOWN2225 RIDGE RDNashvilleTN-—N/A
CLMCLM-4167432026-08-17T22:31:45Z·LISA—REID03/14/75N/AUNKNOWN455-244-8359-··4559 Apache BlvdLas VegasNV89120GRP-1736N/A
CLMCLM-4114812026-06-28T03:35:18ZSARAHWOLSON06/19/00UHC-48451-84nullNULLsarah.olson39@outlook.com5496 River RoadSeattleWA-GRP-2182null
CLMCLM-4089902026-01-02T20:45:42ZAshley—Hansen2005-06-15··—(917) 211-0365ashley.hansen42@gmail.comN/A—··—GRP-8783UNKNOWN
CLMCLM-4113902026-09-12T22:50:10ZDavid··—Wheeler06/07/2001··UHC-39132-78NULL356-912-3248—2668 Spring StHoustonTX77017··GRP-8785NAVIGATE-HMO
CLMCLM-4163122026-02-02T10:32:59Zkathleen—johnston1964-01-05—•••-••-6516659.606.9361—1204 Highland AvenueLos AngelesCA—GRP-4008MEDICARE-ADV-B
CLMCLM-4052332026-04-26T21:07:55ZVicturia—Hawkins05/10/73—•••-••-6185—N/A————NULLN/A
CLMCLM-4025062026-06-19T07:21:22ZWilliam—Simmons1972-06-17UHC-76744-15-NULLNULL-———GRP-7932CORE-HMO
CLMCLM-4135132026-01-23T13:10:45ZSARAN.··MATTHEWSNov 11, 1971UHC-28353-44•••-••-4228N/A-UNKNOWN—·UNKNOWN—GRP-0893-
CLMCLM-4165422026-08-29T04:58:14ZJANET—HENDERSON1976-07-16UHC2922829—NULLjanet.henderson@hotmail.com7039 Mountain View Dr #867HoustonTexas77055GRP-5611CORE-HMO··
CLMCLM-4123162026-03-13T02:10:12ZJOHNCBURKE··07/17/77—•••-••-5021+1 453 667 1365—UNKNOWN—N/A··GRP-5417OPTIONS-PPO
CLMCLM-4270262026-02-12T06:34:51ZMEGAN—GRANT1953-01-22——658-357-5003N/A9586 Forest AveGlendaleAZ85306GRP-0729N/A
CLMCLM-4257452026-09-23T07:57:26ZJAMEES—·LI·03-12-2003NULLNULL——823 Bayshore DriveHoustonTX77063GRP-7745—
CLM CLM-4073182026-01-03T11:25:12ZJASONH.FOWLER19400826··UHC-57273-87——-—NULLUNKNOWN—GRP-9059NULL
CLMCLM-4011372026-01-10T07:38:51ZNATALIEHWILLIAMS1960-03-13—•••-••-70744678449886null-—UNKNOWN—N/A—
CLMCLM-4136902026-10-17T11:44:19ZVIRGINIA—ROBERTS··1992-01-18UHC2329208nullUNKNOWNnull1146 Sunset BoulevardLOS ANGELESCA90079—CORE-HMO
CLM CLM-4174302026-03-27T20:34:03ZMariaRJenkins1941-07-28N/A—3763851298-771 Ridge RdDenverCO····GRP-5840—
CLMCLM-4176552026-01-05T12:06:00ZROY—POWELL1957-05-17UHC-89409-50null··(536) 241-3046—5845 Main StDALLASTXN/AGRP-0937NAVIGATE-HMO
CLMCLM-4250962026-07-29T21:26:20ZWhite, ValentinaT—10/18/1946UHC-42715-20—+1 598 915 3520-5207 Jefferson AvenueGilbertAZ85222GRP-0450CHOICE-PLUS-PPO
CLMCLM-4061262026-05-08T01:21:10ZmichelleWnelson08/08/1947UHC-68864-27nullN/AUNKNOWNUNKNOWNUNKNOWNNULL—GRP-2787N/A
CLMCLM-410618 2026-10-11T23:40:09ZSanders, Ronald—····08/24/78UHC3163229———7520 Church StMinneapolisMN55414GRP-6303—
CLMCLM-4281232026-02-17T18:55:18ZDylan—Day11/15/46UHC-32420-88nullN/A·null8287 Central AvenueGilbertAZ85275·GRP-9281CORE-HMO
CLMCLM-4217792026-07-17T00:56:03ZAnderson, RachelU—1940-09-13··—•••-••-39456015173508NULL8708 Union StLas VegasNevada89130N/A···NAVIGATE-HMO
CLMCLM-4136452026-04-23T17:45:52Z DianaYWeaver2001-11-18UHC4728885NULL——7705 PARK PLACEMiamiFL33157GRP-7396····
CLMCLM-4034822026-06-21T03:00:17Z nicole—lucas1989-08-13NULL•••-••-621115065642684—1029 Elm StreetEden PrairieMN55345GRP-3868N/A
CLMCLM-4182002026-09-21T18:40:58ZLaura··Guzman1971-04-20N/A-+1 884 768 3138N/A3197 Ridge Road Apt 3PlanoTX75022-8131N/AMEDICARE-ADV-A
CLMCLM-4003522026-05-28T06:30:33ZMASON—KYLE2008-01-36··UHC-92667-29•••-••-7598941-380-4832-9092 PARK PLOrlandoFL32888GRP-3399··—
CLMCLM-4245472026-01-07T08:57:20ZWilliam—Allen2006-07-18UHC-31377-42NULL(803) 311-7613—····-UNKNOWNnullN/Anull··
CLMCLM-4198902026-01-13T16:19:57ZelijahO.adams1968-01-13N/A•••-••-6532——4148 Highland AvenueDenverCO·80274UNKNOWNOPTIONS-PPO
CLMCLM-4198752026-01-30T00:23:39ZMary—Williams·06/08/1960UHC-91552-92•••-••-8278nullUNKNOWN975 MESA DRDenverCO··80254GRP-6155··SELECT-EPO
CLMCLM-4039812026-07-04T17:06:07ZVincent—Martinez2006-09-23UHC5744792—(930) 759-9104--UNKNOWN-null-—
CLMCLM-4109902026-03-29T07:39:28ZRICHARD—CHAVEZ1966-09-25UHC-51485-87•••-••-6497NULL··-·NULLN/A····UNKNOWNGRP-8772CORE-HMO
CLMCLM-4174692026-07-07T03:36:49ZAMBER····HICKS12/4/2002NULL-(878) 581-5836null737 SUNSET BLVDHoustonTX77001GRP-4104CORE-HMO
CLMCLM-4285642026-01-14T22:06:15ZcamilaW.roberts1962-10-08UHC-00540-94•••-••-9760N/ANULL-nullNULLNULLN/Anull
CLMCLM-4098192026-01-19T02:53:14ZSOFIADWRD1961-04-16··UHC-55808-79-12366515297sofia.ward69@proton.me6963 Desert Sky BoulevardTUCSONAZ85786-1157GRP-0156OPTIONS-PPO
CLMCLM-4054422026-02-21T12:37:57ZJASON—MILLSDec 8, 1948UHC-87174-74•••-••-4154281-247-5291—1493 Sage Court Apt 29Columbusoh43203GRP-5129NAVIGATE-HMO··
CLMCLM-4023832026-04-29T14:37:00ZBoyd, Heather——10/26/1954UHC-21223-18null—null4167 Ridge RdMINNEAPOLISMN·55492null—
CLMCLM-4166702026-07-02T01:08:58ZNoahW.Hall5/18/1946UHC-25198-97—(548) 835-4315-7972 Forest AveSEATTLEWA98119·GRP-8248—
CLMCLM-4143342026-04-24T18:41:53ZMariana—Parker14-11-2008·UHC-18863-52•••-••-79138676421234—9046 Church StreetGILBERTAZ85224GRP-8629—
CLMCLM-4007732026-07-01T10:24:53Z MarkYFreeman2006-04-11UHC-14472-19-648-326-3859UNKNOWN———null—null
32,829 rows, page 19 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:34.784Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty