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-1201692026-07-13T10:57:53ZBrenda—Harris1982-06-13UHC-10906-79•••-••-2999(852) 530-5311brenda.harris88@proton.me7288 Elm Street Apt 21PlanoTX75033GRP-4284SELECT-EPO
CLMCLM-4289702026-01-11T13:00:26ZDOROTHY··HICKS··25-08-1946··UHC-74134-54—N/A—7841 RIVER ROADTucson··AZ85755—-
CLMCLM-4071022026-09-10T18:50:56ZGabriel—BennettSep 13, 1968nullNULLN/A—1698 Elm StSan AntonioTX78268GRP-4099··—
ENRENR-1237772026-02-14T16:48:15ZLUCIA·NMONTGOMERY09-12-1947UHC-00748-41•••-••-3989(651) 739-0159lucia.montgomery@gmail.com2513 Harbor BoulevardHoustonTX77084GRP-1110CORE-HMO
CLMCLM-4019682026-10-18T11:01:26ZMatthew—Carpenter··1955-06-10UHC-33751-82UNKNOWNN/A-·8003 CEDAR LNMinneapolisMN55458GRP-1420··CHOICE-PLUS-PPO
ENRENR-111516 2026-08-07T18:37:36ZkathyXharris19960502UHC-29359-29•••-••-4917+1 533 252 6689·KATHLEEN.HARRIS@PROTON.ME7651 OCEAN AVENUECharlotte··NC—GRP-0292NAVIGATE-HMO
CLMCLM-4162242026-07-25T17:26:51ZMason, AmyD—1974-07-27UHC-63861-38NULLN/ANULL5602 Camelback RdLas VegasNevada89113—N/A
ENRENR-1182072026-02-18T20:49:26ZDianeR.Taylor5/21/1976·UHC-64723-69•••-••-9302206.249.4213N/A7365 PALM DRIVEPLANOTX75079GRP-6313CHOICE-PLUS-PPO
ENRENR-1394422026-05-14T12:56:37ZLindaGGibson19381219··UHC-03410-41•••-••-00117439262694linda.gibson@icloud.com1880 MOUNTAIN VIEW DRIVEFresnoCA93791GRP-9972core-hmo
ENRENR-1043482026-07-20T20:15:36ZVargas, Sofia——16-02-1954UHC-72868-40•••-••-78095342142508··2814 Central AveTucsonAZ85706GRP-0581select-epo
CLMCLM-4125412026-03-14T09:07:57ZDEBRA—POWELL··1945-02-07·uhc-90874-75•••-••-4365NULLdebra.powell13@aol.com4358 FOREST AVETAMPAFL33622UNKNOWNCORE-HMO
CLMCLM-4113272026-06-02T22:51:15ZMELISSAU··WOONG—UHC-05164-20—UNKNOWN—4112 Park PlaceLas VegasNV89145—N/A
CLMCLM-4278382026-09-01T10:16:56ZPatricia—Lawson1964-01-04··•••-••-6598(915) 526-6047UNKNOWN5663 Meadow Lane··CHARLOTTENC··28208——
ENR ENR-1268322026-07-18T12:05:01ZSARAZHARVEY··2/18/1984UHC-26372-60•••-••-36426245431462SARA.HARVEY@GMAIL.COM8811 Church StreetDenverCO80257···GRP-9521MEDICARE-ADV-B
PRVPRV-292912026-05-13T20:17:02Z DENNIS—HART1980-01-06-•••-••-78012576984525····8743 Maple AveMesaaz85254·N/AUNKNOWN
TPATPA-51878 2026-06-18T22:53:41ZCAMILA—DALGADO6/5/1975N/A-889-625-1986··CAMILA.DELGADO@PROTON.ME4527 Desert Sky BlvdGlendale··AZ·85301—··
PRVPRV-202712026-03-09T16:19:31ZKaylaCShaw1986-11-15UHC-04156-50N/A··-—7030 Washington StreetPlanoTX·75049UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4280652026-10-15T15:32:04ZJason····HuntDec 8, 1963—null—N/AUNKNOWNNULL—nullGRP-1989OPTIONS-PPO
TPA TPA-500562026-04-02T01:07:20ZLaura—Chapman1985-07-01UNKNOWNN/ANULL··2392 River RdFresnoCA··93701—MEDICARE-ADV-A
ENRENR-1315582026-05-20T06:07:51ZLAURA—MASONOct 26, 1977UHC-86903-57•••-••-19625113372559laura.mason36@proton.me4702 Highland AveSeattleWANULL·GRP-0316SELECT-EPO
CLMCLM-4308472026-07-25T22:32:51ZMaateoL.GrantOct 22, 1969UHC-05095-06•••-••-9878UNKNOWN—·2240 HILLCREST RDFresnoCalifornia93736GRP-8215UNKNOWN
ENRENR-1211452026-02-23T09:30:12ZAngela··R.Anderson1967-06-27UHC-43281-15•••-••-1696+1 609 596 2602angela.anderson@hotmail.com6290 Park PlacePhoenixAZ85065GRP-9068SELECT-EPO
ENRENR-1408592026-02-20T07:39:34ZJANICE—CARR1938-10-26uhc-20307-50•••-••-4481(766) 906-5071—7647 Park PlTEMPEAZ··85268GRP-3026OPTIONS-PPO
CLMCLM-4226362026-04-02T02:35:14ZJuan—Banks1967-11-12UHC-97584-08NULLNULLjuan.banks@icloud.com9425 Mesa DrFresnoCA93762GRP-6782CHOICE-PLUS-PPO
CLMCLM-4031732026-04-08T21:39:57ZOliver, Stephanie——19-02-1978—····831-559-1211null2679 Elm StJacksonvilleFL··GRP-9162UNKNOWN
TPATPA-585552026-01-04T04:26:20ZJULIA—LE1972-12-15null—(278) 940-4205·JULIA.LE70@PROTON.ME9364 Market St #125TucsonAZ85750—·UNKNOWN
CLMCLM-4149582026-06-09T05:47:02Zbilly—holmes12/26/1977null-—N/A·UNKNOWNUNKNOWN—N/A··GRP-8545UNKNOWN
ENRENR-1061282026-01-10T22:07:03ZRomero, CamilaK.—02-07-1996UHC-72971-80•••-••-43713838850653·camila.romero@outlook.com9641 Forest AveGlendale··AZ85326GRP-4564SELECT-EPO
TPATPA-582252026-02-11T13:04:49ZCYNTHIA—ALLEN1997-05-24—•••-••-3879(630) 211-1076N/A9695 SUNSET BOULEVARDEden PrairieMN··55397GRP-0972null
CLMCLM-4158292026-06-02T18:16:35ZHeather··—·Jones1988-04-22UHC-15154-41•••-••-7543UNKNOWNUNKNOWN7379 BroadwayDallastx75291-8970··null—
PRVPRV-272642026-05-01T15:00:59ZBraldey—Chen1993-05-27—N/A(571) 758-2303—285 RIDGE ROADTucsonAZ85777——
CLM CLM-4204352026-05-11T22:51:33ZBrenda··Adaams··1953-06-22··UHC-68921-36null-··2980 WASHINGTON STCHARLOTTE··North Carolina28273GRP-4089MEDICARE-ADV-B
ENRENR-1206732026-05-03T10:27:00ZBurns, Judy——12/9/1980UHC-13174-98•••-••-4435—JUDY.BURNS92@ICLOUD.COM3367 Maple AvenueSeattleWA98109··GRP-1473··CHOICE-PLUS-PPO
CLMCLM-4057332026-10-04T07:40:40ZBeverly····Hughes1988-06-28UHC-84048-28•••-••-1537—-3148 Cedar LnPlano··TX75003GRP-8923null
ENRENR-1230042026-03-14T00:07:16ZChristopherEGuerrero1990-08-04UHC-94197-05•••-••-4202586-383-9700christopher.guerrero61@proton.me7502 FOREST AVENUE··ScottsdaleAZ—GRP-5723CHOICE-PLUS-PPO
CLMCLM-4095332026-01-07T20:40:45Zsharno—morrison09/15/1990UHC-24318-58UNKNOWN··749.451.6232-2424 CEDAR LN Apt 26··SeattleWA98157····SELECT-EPO··
ENRENR-1316232026-04-08T01:29:16ZBryan—Welch1951-12-16UHC9049968··•••-••-8643(848) 455-0065bryan.welch@outlook.com9202 Palm DrSeattleWA—GRP-8115OPTIONS-PPO
TPATPA-504692026-02-11T18:15:16ZGEORGE—HUNTMay 18, 2004UNKNOWN•••-••-9436N/A-567 Central AveSan DiegoCA92168N/ACHOICE-PLUS-PPO
TPATPA-52829 2026-09-06T09:52:24ZJessica—Andraws1975-11-03——-—8940 MEADOW LN Apt 11Las VegasNV··89107nullMEDICARE-ADV-B
ENRENR-1285512026-08-29T03:07:06ZJEFFREYTMARTIN1952-12-20UHC1121495•••-••-8573—jeffrey.martin@yahoo.com4549 HARBOR BOULEVARDAustintx78766GRP-2507··OPTIONS-PPO
PRVPRV-266802026-03-11T04:24:42Zmegan—carter1953-09-14UHC-16129-53—(467) 407-1961megan.carter@yahoo.com2354 CANYON RDTUCSONAZ—UNKNOWN—
TPA TPA-542222026-06-20T23:32:23ZDenise—Clark1980-09-13NULLUNKNOWN—-1767 Pine DrColumbusOH43288-1919NULLnull
TPATPA-622142026-04-19T02:35:09ZHiroshiAMoore19500908UNKNOWNNULLN/A-952 Union Street #246GlendaleAZ85388N/AMEDICARE-ADV-B
CLMCLM-4158282026-09-16T07:09:13Zwilliam—scott04/20/38UHC-86572-89•••-••-5496—-2049 River RoadDALLASTX75207-·UNKNOWN
TPATPA-508312026-10-06T04:42:48ZSFOIAPJONS1996-10-20——12274115717UNKNOWN8631 SPRING STREETMiamiFL33139·GRP-6763—
TPATPA-631822026-09-24T11:02:35ZLauren—Sullivan08-07-1938N/AUNKNOWN—NULL1058 Spring St #265MiamiFL33158—MEDICARE-ADV-B
ENRENR-1314512026-10-08T10:46:42ZDebraEPatterson2001-04-19UHC-45467-76··•••-••-5648657-656-5795debra.patterson30@aol.com2991 Meadow LnTAMPAFL33648GRP-3753CHOICE-PLUS-PPO
ENRENR-1178832026-08-02T20:55:37ZAnaFMoore3/2/1962UHC-21546-91•••-••-48323243232ANA.MOORE@HOTMAIL.COM7032 Main StLos Angelesca90017GRP-1111MEDICARE-ADV-A
TPATPA-536752026-10-10T01:01:47ZRobnson, Joe——1941-10-27N/A•••-••-0419+1 263 410 6889NULL5475 Lake View RdJacksonvilleFL32290—-
ENRENR-1112712026-01-18T21:42:22ZLarryYPayne07/14/1969···UHC-85781-09•••-••-8832648.342.6301LARRY.PAYNE@AOL.COM2134 Pine DrSacramentoCAnullGRP-7825OPTIONS-PPO
100,000 rows, page 31 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.767Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty