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
ENRENR-1255392026-03-20T15:21:13Zjames—garrett1971-04-16UHC-44979-65-6762977356N/A5819 Main StMiamiFL33185GRP-4794CHOICE-PLUS-PPO
ENRENR-1057492026-09-23T01:13:39ZisabellaA.burns1948-08-20UHC-10907-04—4113601184null709 MOUNTAIN VIEW DRIVEAtlantaGA30397GRP-4275NAVIGATE-HMO··
CLMCLM-426846 2026-02-09T21:00:00Z·brenda—austinSep 21, 1952UHC5465753•••-••-16034455042178—4937 Lake View Road·GilbertAZ85206—OPTIONS-PPO
ENRENR-1393942026-08-03T05:38:26Z RUTHNCHEN1955-09-20UHC-79105-63··•••-••-2666552-258-3699ruth.chen@aol.com3335 Camelback RoadSacramento··CA95874GRP-2942MEDICARE-ADV-B
TPATPA-608122026-09-13T02:34:37Z·Santiago—Silva··12/21/55—•••-••-1090——2852 Valley View DriveTampaFL33615—·NULL
CLMCLM-4290402026-10-10T17:51:38ZMEI—THOMPSON1980-10-20N/A•••-••-47137002522355-———N/AGRP-5871—
ENRENR-1070582026-08-04T08:49:28ZLisa·RCollins1955-09-23UHC-60542-90•••-••-14503898484433LISA.COLLINS78@GMAIL.COM3341 Park PlaceOrlandoFL32880GRP-3293···OPTIONS-PPO
CLMCLM-4268122026-02-25T16:24:28ZSara—Baker1979-12-05UHC-35017-70•••-••-38835226618224—·9270 VALLEY VIEW DRIVEHoustonTX77071UNKNOWNNULL
ENR ENR-1016042026-03-27T06:14:23ZRobert—Flores19710713UHC-85084-18•••-••-314316962836228robert.flores46@gmail.com·2343 Pine DrSan DiegoCA92168GRP-9509SELECT-EPO
TPATPA-507592026-10-10T14:57:06ZJOE····RIVERA1952-07-18UHC0584687——nullNULLN/AnullN/A····N/A
ENRENR-1308962026-02-01T09:38:51ZBUTLER··JKATHRIN1961-10-11UHC-94470-29•••-••-8058692-432-5907N/A1625 FOREST AVEMesaAZ85243GRP-7268·MEDICARE-ADV-B
ENRENR-1135222026-06-08T07:51:58Z JasnoN.Wagner2006-07-13UHC-81077-69•••-••-8021(250) 492-5722JASON.WAGNER16@YAHOO.COM··245 ELM STSan AntonioTX78217GRP-2955options-ppo
ENRENR-1354942026-10-08T18:21:36ZJesseR.Wright··1964-05-28UHC-52441-48•••-••-9175274-650-8253···JESSE.WRIGHT46@AOL.COM8687 Central Ave #584ScottsdaleArizona··85277GRP-6287MEDICARE-ADV-B
CLMCLM-4154082026-09-14T14:41:28ZAngela—Willis1984-11-27UHC-64489-28•••-••-8493——NULLUNKNOWNN/AUNKNOWNGRP-5679·NAVIGATE-HMO
ENRENR-1418112026-09-25T17:32:19ZSimpson, Arthur··I.—3/6/1989··UHC4293964•••-••-3202910.401.7402·arthur.simpson@aol.com7971 INDIAN SCHOOL ROADDallasTX75222GRP-6723MEDICARE-ADV-A
ENRENR-1292472026-05-06T13:51:26ZBenjamin—Nguyen·Oct 21, 1973UHC-26778-43•••-••-0206280-875-3042benjamin.nguyen@hotmail.com845 Bayshore Drive·Los AngelesCA90014GRP-4302MEDICARE-ADV-A
ENRENR-1262682026-05-25T14:30:14Z—X.—1994-02-07UHC7210405•••-••-4588860-351-9447roy.ruiz@icloud.com8276 Spring StreetLas VegasNVNULLGRP-8359NAVIGATE-HMO
ENRENR-1127792026-04-05T12:49:33ZAlan—Ramso·1971-09-24UHC-81866-57•••-••-31699793426863ALAN.RAMOS88@HOTMAIL.COM34 WASHINGTON STREETSeattleWA98132·GRP-4465SELECT-EPO
ENRENR-1195512026-02-04T10:47:29ZGregoryURamos19840811UHC-69287-98•••-••-9069(337) 700-4135···GREGORY.RAMOS85@AOL.COM843 Harbor BlvdNASHVILLETennessee37202GRP-6428···MEDICARE-ADV-A
CLMCLM-4314922026-01-31T13:44:48ZValentina—Castilo1/19/1975UHC-20623-84•••-••-7950null—2097 Sunset BlvdSan AntonioTX78268-····
ENRENR-1420312026-01-05T16:01:42Z Beverly—Tran1961-08-17UHC-27198-30•••-••-6065+1 271 957 6487BEVERLY.TRAN18@PROTON.ME112 CANYON ROAD Apt 31ChandlerAZnullGRP-2621CORE-HMO
PRVPRV-275632026-07-05T22:29:55ZMei—Maldonado1945-11-02UHC-86595-66—4522021—7457 Park PlaceHoustonTX77082N/A—
TPATPA-620862026-10-11T21:31:36ZKimberly—Baker·1987-10-13UNKNOWN•••-••-9804(482) 771-4425NULL6304 Camelback RdSeattleWA98101-null
ENRENR-1184762026-06-05T03:34:25ZMarilynM.Welch1939-07-14UHC-00229-54—2214537MARILYN.WELCH67@YAHOO.COM1926 Harbor BlvdGlendaleAZ85334GRP-9876NAVIGATE-HMO
TPATPA-568842026-05-17T15:07:19ZJose—Green1998-10-12-•••-••-5002-—6617 Ocean AvenueLos Angeles··CA90002N/A—
ENRENR-1075432026-06-19T20:46:44Z Victoria··Knight1988-03-18··UHC-33507-96•••-••-0269652-735-1959victoria.knight92@hotmail.com3173 Bayshore DrChandler·az85264GRP-6162CORE-HMO
CLMCLM-4133282026-03-18T18:36:16Z DiegoQ.Guerrero1943-03-05UHC-87787-76•••-••-5033N/Anull———NULLN/AMEDICARE-ADV-A
TPATPA-587052026-07-28T01:36:49ZDonna—Wong1967-09-15UNKNOWN•••-••-5419·N/ANULL7147 Mountain View DrGlendaleArizona85396—null
CLMCLM-424119 2026-09-02T13:18:01Z·JUDY—WAKTINS1973-04-08null——NULL5633 Market StColumbusOH43270GRP-8024MEDICARE-ADV-A
TPATPA-506362026-08-09T20:26:09ZKeithM.Payne13-02-1997NULL•••-••-4223(837) 468-7938—5572 BroadwayPhoenixaz85038GRP-9970—
ENRENR-1221932026-06-27T17:22:34ZDianeYWarren1998-05-18UHC-87485-79•••-••-46258842966471UNKNOWN·1178 CANYON RD·San AntonioTX··78270GRP-9313MEDICARE-ADV-B
PRVPRV-238712026-05-30T06:00:26ZMarthaB·Campbell1939-01-15UHC3028220NULL4762731071—·4725 Highland AvePlanotx75075—NULL
CLMCLM-4189442026-05-20T01:52:34ZEmma—Mitchell1962-01-22UHC-83138-42-NULL—857 Cedar LaneJacksonvilleFL32235-8047GRP-0288MEDICARE-ADV-A
CLMCLM-4142702026-07-05T12:51:12ZALBERTR.WATSON01/26/84UHC-54144-28N/A292-405-4334N/A8403 Sage CtLas VegasNV—·-—
ENRENR-1055642026-04-12T06:59:07Z Santiago, AshleyY.—1950-11-03UHC-34372-01··•••-••-4838305.697.2614NULL6602 Elm Street Apt 30MinneapolisMinnesota55456GRP-7824CHOICE-PLUS-PPO
CLMCLM-4244732026-08-27T12:31:58ZJUDITH—RAMIREZ1983-10-07UHC-46061-12•••-••-9909+1 609 539 6518JUDITH.RAMIREZ65@AOL.COM1586 Bayshore Drive·San AntonioTX78206GRP-1503medicare-adv-a
ENRENR-1200812026-01-13T03:01:07Zbetty—walsh1988-09-04UHC-06757-59•••-••-2068(912) 828-8778BETTY.WALSH36@AOL.COM3850 MAPLE AVENUESacramentoca95804GRP-3123CORE-HMO
ENRENR-1407562026-10-07T00:49:15ZEDWARD—COLEMAN1938-04-08UHC-02650-81•••-••-8434212-669-4821-8603 Bayshore DrHOUSTON··TX77084GRP-6592SELECT-EPO
CLMCLM-4032662026-07-30T09:10:35ZKENNETH—COOPER19990406UHC-97521-32—447.477.4516—6394 BASELINE RDMesaAZ85234GRP-8790N/A
ENRENR-122870 2026-06-04T11:16:40ZMegen—Hoffman·17-11-1961UHC-02359-58•••-••-95072076511megan.hoffman15@outlook.com···7890 MAPLE AVENUEDenverCO80229GRP-8420··SELECT-EPO
ENRENR-1183772026-05-10T08:46:05Z Gerald··UTaylor19910307UHC-39604-78•••-••-2362370.668.8652—4919 Park PlaceOrlandoFL32810GRP-0906CHOICE-PLUS-PPO··
PRVPRV-233072026-01-25T04:04:48ZSARAH····OLSON2000-06-19N/A-N/ANULL5496 River Road··SeattleWA··98181UNKNOWNnull
ENRENR-1429072026-07-08T17:00:54ZThomas—HarperAug 3, 1974··UHC4328339•••-••-2969+1 952 890 3409thomas.harper@icloud.com973 MARKET STTUCSONAZ85766GRP-6743select-epo
ENRENR-1270062026-07-03T20:26:21ZtheresaY.mendoza1997-10-15UHC-04834-10•••-••-026217454617319null6953 Market StreetCharlotte··North Carolina-GRP-6765MEDICARE-ADV-B
CLMCLM-4026852026-07-17T11:17:18ZDEBORAH—JOHNSON1978-06-01UHC-64630-40N/A533-956-4622NULL·2676 GRAND AVENUETAMPAFL33681—OPTIONS-PPO
CLMCLM-4033202026-04-29T16:47:49ZSteven····Fox19960810—•••-••-4531····—-N/AN/A—GRP-2326MEDICARE-ADV-A
ENRENR-1350672026-01-23T03:06:29ZGabriel—Rivera1977-10-15UHC-48429-98•••-••-30938159075901gabriel.rivera98@gmail.com4890 Camelback RdLos AngelesCA90015GRP-9473OPTIONS-PPO
ENRENR-1147782026-05-13T23:21:24ZPatriciaC.Walsh20010721UHC7761841•••-••-50496828270150PATRICIA.WALSH69@AOL.COM4463 Central AveLos AngelesCA90061-4570GRP-4928NAVIGATE-HMO
CLMCLM-4009232026-06-02T09:13:37Z Betty—Howard28-08-1954-null——--—nullGRP-9120-
ENRENR-1040702026-02-21T16:52:13ZSAMANTHA—VAZQUEZ··19720108UHC-23134-85N/A··—samantha.vazquez@yahoo.com9424 Highland AveGLENDALE·AZ85312GRP-9749CORE-HMO
100,000 rows, page 126 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:36.688Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty