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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLM CLM-4155842026-09-05T03:59:29ZRalph—Knight1949-10-18UHC-81725-26N/A··NULL-5725 Pine DrSan DiegoCA92142-4500N/ACHOICE-PLUS-PPO
ENRENR-1313242026-01-02T16:43:25Z·Jason—Burns1975-12-26UHC-85963-06•••-••-0594—UNKNOWN5434 Camelback RdEden PrairieMN55310GRP-9744CORE-HMO
PRVPRV-288352026-01-25T21:46:34ZPriyaJOewns12/19/1979··—•••-••-6330—priya.owens@outlook.comnullnull—UNKNOWN-NULL··
CLMCLM-4145522026-07-30T05:37:47Zgloria—bailey1959-02-20UHC-58214-02•••-••-8064——N/A—NULL—GRP-4656CHOICE-PLUS-PPO
TPATPA-612752026-04-14T11:39:00Z Denise—Adams1990-18-09-UNKNOWN863-857-1973UNKNOWN—-—--··NULL··
ENRENR-1113622026-03-20T00:02:08Z·Jacqueline—BakerNov 8, 1945·UHC-92956-55•••-••-77844757607876jacqueline.baker@icloud.com6071 Palm DrATLANTA·GA·30360GRP-1677MEDICARE-ADV-A
CLMCLM-4025442026-01-31T07:15:52ZPatricia—Bryant03/10/59UHC-41750-16NULL14314758174—1618 Central Avenue··HoustonTX77076—CHOICE-PLUS-PPO
ENRENR-1350112026-08-31T10:37:26ZBRANDON··MGRANTMar 23, 1939UHC-80242-34•••-••-60964002817290brandon.grant64@gmail.com5840 LINCOLN WAY·ChandlerAZ85295GRP-0631OPTIONS-PPO··
TPATPA-534322026-09-08T09:37:17ZCarol—Garrett2/27/1971—UNKNOWN··—carol.garrett@proton.me5161 VALLEY VIEW DRFresnoCA93785GRP-5939NAVIGATE-HMO
ENRENR-1236232026-06-24T18:41:07ZWayneQSilva2005-02-18··UHC-07518-90•••-••-988612374504670WAYNE.SILVA30@AOL.COM3386 Union StreetOrlandoFL32817GRP-4231CHOICE-PLUS-PPO
CLMCLM-4121172026-04-24T15:35:26Zaaron··daniels·1/7/2004UHC-38053-93•••-••-9249-—1963 CANYON RDEden PrairieMN55327-CORE-HMO
ENRENR-1340412026-05-20T03:24:23ZJasonL.··PirceJan 17, 2004UHC-96758-59•••-••-6531(719) 587-3258—9259 JEFFERSON AVENUEDenver·CO80245GRP-4687MEDICARE-ADV-A
TPATPA-564142026-06-23T15:34:16ZAnderson, Sofia——1984-01-21NULL—(316) 577-8943—UNKNOWNUNKNOWN—NULLnullN/A
ENRENR-1099332026-06-07T08:23:11ZBENJAMINW.WRIGHT1951-07-02UHC-27704-99•••-••-8830(726) 483-2451benjamin.wright@icloud.com6627 Meadow Ln Apt 31Los AngelesCA90055GRP-8945medicare-adv-b
TPATPA-531132026-07-04T04:28:53ZFrankKBowman1976-05-12UHC-05898-40N/A(840) 341-2160FRANK.BOWMAN@ICLOUD.COM····nullNULL——OPTIONS-PPO
CLM CLM-4260232026-03-22T11:32:10ZDorothy··Fisher1990-08-05UNKNOWN•••-••-2241816-739-7449—9204 Apache BlvdLos Angeles··California90036-—
CLMCLM-4120492026-04-05T18:05:34ZKevin—Joohnston1959-08-24N/A•••-••-9925—null6104 CAMELBACK RD·MINNEAPOLISMN55492GRP-5931MEDICARE-ADV-B
TPA TPA-565922026-08-28T05:37:30ZWallace, Eugene——Jun 16, 1942UHC-99190-14-2207335096··-8878 Baseline RdJacksonvilleFlorida32219-MEDICARE-ADV-A
ENRENR-1423022026-08-27T14:58:21ZDorisSSalazar1956-03-05UHC-06432-67•••-••-80658562577470doris.salazar22@yahoo.com8951 Baseline RdSan Antonio·TX78222··GRP-5981NAVIGATE-HMO
ENRENR-1315572026-07-04T15:29:29ZBlack, JeanD—1959-10-05UHC-94600-18—18908104685null1446 Ocean AvenueDALLASTX75218GRP-5268MEDICARE-ADV-B
TPATPA-615082026-08-02T07:00:38ZDEBORAH—WEBB14-01-1980—•••-••-3911N/A·N/A305 Desert Sky BlvdEden PrairieMN55336null—
CLMCLM-4077262026-05-14T16:23:10Z·Billy—Hart·Jan 16, 1986—•••-••-3944UNKNOWNUNKNOWNnullnullUNKNOWN--N/A
ENRENR-1211412026-10-07T18:35:31ZJeffreyKCooper1969-05-25UHC-64534-54•••-••-3245null—4452 Elm StreetSan Antonio··TX78210GRP-3557CHOICE-PLUS-PPO
ENRENR-1043422026-10-01T03:45:06Z LawrenceG··WheelerNov 5, 2008UHC-35018-15-nullnull2329 INDIAN SCHOOL ROADGilbertAZ85266GRP-9176NAVIGATE-HMO
ENRENR-1221672026-10-15T00:11:48ZAmyL.Holmes10/24/1953··UHC-75186-65•••-••-1485815-553-7559—5068 MEADOW LANE··MinneapolisMN55479GRP-2069CORE-HMO
ENRENR-1335192026-05-22T14:16:20ZCheryl·XSanchez18-06-1989UHC-32116-40•••-••-4422835.234.3837cheryl.sanchez@hotmail.com5280 Desert Sky BoulevardSan Diegoca92179GRP-3481SELECT-EPO
ENRENR-1013192026-04-18T05:47:52ZJustinU.··Weber1948-06-28UHC-21843-63•••-••-2785N/A··justin.weber@hotmail.com9726 Palm DriveMIAMIfl33131GRP-7972core-hmo
ENRENR-1128432026-08-30T19:53:45ZJessica—Hughes1965-08-15UHC-84870-33•••-••-37888316385944JESSICA.HUGHES@OUTLOOK.COM4753 Mountain View DrChandler·AZ85254GRP-4582MEDICARE-ADV-A
CLMCLM-4145242026-06-02T17:12:21ZRogerSThompson1983-07-07UHC-89725-83··—(950) 989-0021-··—NULL—-OPTIONS-PPO
CLMCLM-4150982026-06-15T05:43:10ZCAROLN··—GREENE1943-06-09·UHC-92702-38•••-••-3839280-701-8511—-NULLN/AnullGRP-3856N/A
PRVPRV-204382026-04-08T16:41:45ZGabriel—Bursn27-07-1972UHC-16198-58•••-••-56199367987575-9184 Spring StATLANTAGA30326——
ENRENR-1158992026-07-08T08:31:31ZARTHURG·WARREN1957-09-17UHC-86622-12•••-••-71315265263860arthur.warren@icloud.com952 BroadwayChandlerAZ85296GRP-9775NAVIGATE-HMO
ENRENR-1085232026-09-07T07:46:10ZAlice··—Burke1962-07-04UHC-35007-83—UNKNOWNalice.burke@proton.me9144 Forest AveFresnoCA93701GRP-1158MEDICARE-ADV-A
ENRENR-100196 2026-08-19T22:35:26ZGloriaT.Walsh11-06-1941UHC-92335-10•••-••-5720848-798-2440—·7387 Elm StChandlerArizona85204··GRP-9171CHOICE-PLUS-PPO
CLMCLM-4215622026-06-20T02:58:59ZDIANA—TORRES10/12/1944UHC-25888-68UNKNOWN·N/A—7172 Desert Sky BlvdTampaFL33668--
ENRENR-1023582026-07-09T06:09:50ZnatalieWharrison1962-12-17UHC-82848-19-5344398162··3976 BROADWAYLas VegasNevada89161GRP-6126OPTIONS-PPO
CLMCLM-4185592026-03-31T14:23:30Zlauen—graham··06/03/1979··UHC-12369-48-434-708-7361—7492 Jefferson Avenue Apt 18Scottsdale·AZ85207-3579GRP-2897CHOICE-PLUS-PPO
CLMCLM-4113912026-07-16T18:11:23Z·Jordan—Lori—UHC-12979-70NULL--3367 Ocean AveMesaAZ··85209··-OPTIONS-PPO
CLMCLM-4087332026-02-15T03:39:50ZJimenez, Brenda——1946-09-24UHC-35314-08N/AnullUNKNOWN3317 Mountain View Drive #635Atlanta·GA-GRP-2091N/A
ENRENR-1245282026-10-02T04:22:06ZMEI···E.GARZA1980-11-28UHC-69301-69•••-••-8760361-848-0401mei.garza37@hotmail.com2796 INDIAN SCHOOL ROADPhoenixAZ·85094GRP-0753MEDICARE-ADV-B
ENRENR-1163932026-06-28T20:40:52ZAngela—Marquez20010712UHC9128659•••-••-03982716583170angela.marquez46@yahoo.com6514 Harbor BoulevardAustinTX—GRP-3283select-epo
CLMCLM-4177182026-08-28T19:47:26ZJoseph—Wheeler1991-05-12·UHC-73218-61N/A——3173 WILLOW CT #168SacramentoCA95892GRP-3811UNKNOWN
CLM CLM-4278532026-09-04T13:10:40ZCATHERINEAHOWARD·3/21/1971UHC-63375-90—UNKNOWNCATHERINE.HOWARD@HOTMAIL.COM8486 WASHINGTON STREET··GlendaleAZ85325GRP-9412MEDICARE-ADV-A
TPATPA-542732026-09-04T23:32:30Z Hiroshi—Rice9004-19-47null—nullnull5783 OAK STJacksonvilleFlorida32271N/A—
ENRENR-1319192026-09-25T17:45:02ZJose··NSingh1976-11-13UHC-64453-09•••-••-5839(321) 574-0294N/A1411 Sage CtFresnoCA··93722GRP-5363OPTIONS-PPO··
PRVPRV-279732026-02-10T04:40:15ZAmy—Hicks19600321UHC-14831-12N/A··——6886 PALM DRIVE··GILBERTAZ85277NULL·NULL
CLMCLM-4046052026-06-16T08:44:16ZRoyK.·Williams1973-08-26UHC-46275-41•••-••-7595NULLNULL3301 Willow CourtColumbusOH43257GRP-8286—
ENRENR-101804 2026-02-28T23:28:29ZJOSHUAGSALAZAR1993-03-23UHC-92713-85•••-••-9510(213) 498-3184JOSHUA.SALAZAR43@PROTON.ME559 Park PlCHARLOTTENC·28248GRP-3851NAVIGATE-HMO
TPATPA-503532026-07-26T00:43:15ZPriya—Collins1938-07-18nullnull217-371-3753-2440 Sage CtHOUSTONTX77014N/ACORE-HMO
CLMCLM-4194362026-08-17T22:54:33ZWashington, Arthur——1978-04-20UHC-16202-78—nullN/ANULL-null—nullNULL
100,000 rows, page 25 of 2,000PreviousNext

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.764Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty