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
TPATPA-622052026-03-21T19:42:03ZLee, Amber——2004-04-08NULL•••-••-77715362651559amber.lee63@aol.com5091 Church StSACRAMENTOCA95883—select-epo
ENRENR-1379382026-06-23T17:59:22ZBradley—Kelley1979-09-06UHC-90063-13•••-••-96096623691927·BRADLEY.KELLEY66@AOL.COM3620 Willow Ct·San DiegoCA92172·GRP-3103OPTIONS-PPO
ENRENR-1052382026-03-01T22:07:23ZDianaJRussell01/05/1999UHC-52397-34•••-••-740818807150014DIANA.RUSSELL@OUTLOOK.COM3778 APACHE BOULEVARDTempeAZ85228-4713GRP-2052SELECT-EPO··
ENRENR-1061372026-04-22T11:13:34ZChristinaK·Edwards05/02/88UHC-48121-67—12938790886christina.edwards@proton.menull--····GRP-6260OPTIONS-PPO
CLMCLM-4248252026-02-05T20:10:31ZDENNIS··THOMPSON1955-10-11UNKNOWN··•••-••-7935(468) 758-6380—8585 GRAND AVENUEDenverCO80212GRP-6742core-hmo
TPATPA-563182026-01-30T05:21:13ZDeborrah—Yag08/28/1976NULL•••-••-6290N/Anull4152 Lincoln WayOrlandoFL32843null—
TPATPA-638442026-04-28T16:10:33Z Elizabeth—Matthews1994-08-26UHC8316359-——8220 BAYSHORE DROrlandoFL32855-9631UNKNOWNN/A
PRVPRV-260212026-02-20T06:52:41ZBeverly··Chen1946-04-03N/AUNKNOWN7112394905beverly.chen71@aol.comNULLUNKNOWNnullNULLnullUNKNOWN
TPATPA-626642026-07-22T11:36:53ZAllen, Austin——1939-03-24N/A··•••-••-3770—nullNULL—null·N/A——
CLM CLM-4299842026-04-04T09:31:05ZMcDonaldWTheresa1967-09-28UHC-35139-46•••-••-0479805-865-6923null—N/A·nullUNKNOWNGRP-2756—
ENRENR-1224762026-07-12T22:30:57ZAliceCMedina04-07-1974UHC-10694-52··UNKNOWN244-222-1165··—1726 Desert Sky BoulevardColumbusOH43209GRP-7142SELECT-EPO
TPATPA-578262026-07-29T23:47:53ZLogan—Yang·1967-09-12NULLUNKNOWN—logan.yang@aol.com219 Lincoln WaySan AntonioTX78217GRP-5911—
ENRENR-1354992026-03-11T20:22:00Z Santiago—Garcia1962-01-10UHC-07974-07•••-••-6373····—203 Park PlNashville·tn—GRP-5734MEDICARE-ADV-A
ENRENR-1074352026-05-21T09:27:50ZERIC—FULLER1975-09-21UHC2465587•••-••-0541N/Aeric.fuller35@aol.com8373 Market StreetSan DiegoCA92190GRP-7843CHOICE-PLUS-PPO
CLMCLM-4314522026-10-02T22:48:03ZJensen, JoseS.—1953-01-13UHC-42670-96N/A425-274-4181····2719 OCEAN AVENUENashvilleTN37260-4320GRP-6226UNKNOWN
CLM CLM-4224632026-09-08T21:57:23ZDiana—Cooper1993-02-21UHC-93659-24•••-••-3498(820) 616-7600····855 Pine DrivePhoenixAZ85047-2073GRP-9380CHOICE-PLUS-PPO
CLMCLM-4064732026-10-04T01:11:25ZLaura—Ryan1993-01-22UNKNOWN•••-••-787513507482025—9430 SUNSET BLVDCharlotteNC28259GRP-0997null
TPATPA-521272026-04-22T17:25:06ZDoirs—RuizDec 9, 1940—NULL-UNKNOWN8728 Church StLos AngelesCA90094UNKNOWNOPTIONS-PPO
CLMCLM-4183212026-08-13T00:52:13ZPamela—Bryant3/17/1960UHC-85849-44——-609 Lake View RdLos AngelesCA90019-5047GRP-2604N/A
PRVPRV-225442026-04-25T08:55:43Z·DORIS——1939-12-09UHC2434103—530-289-4016doris.west@aol.com9597 Camelback RdTempeaz85259—N/A
ENRENR-1413762026-06-14T23:37:22Z evelynM.moore1955-08-25UHC-06739-36··•••-••-2810—-7193 ELM STATLANTAGA30339GRP-8406MEDICARE-ADV-B
CLMCLM-4217272026-03-26T03:32:27ZMASONS.GARRETT2005-06-06N/A—8725199267NULL6530 Bayshore DriveNashvilleTN37281-7282NULL—
PRVPRV-259852026-01-18T12:23:35Zrebecca—foster1972-09-20··UHC-85099-24null3755638106REBECCA.FOSTER84@ICLOUD.COM2598 Oak StSan Diego·CA92198-NULL
CLMCLM-4129842026-08-26T20:58:44ZKathyGDixon1989-07-28———NULL9088 Union StreetSan DiegoCA92189-7297GRP-1423·SELECT-EPO
ENRENR-1104482026-05-24T20:44:46ZaishaD·wang2007-07-07UHC-84976-29•••-••-4291(320) 414-2896aisha.wang@proton.me3855 BroadwaySacramentoCA95878GRP-1740OPTIONS-PPO
ENRENR-1007562026-05-03T17:56:23ZOrtiz, TheresaX—1985-08-24UHC-35785-19•••-••-6322·3675086099THERESA.ORTIZ@PROTON.ME5028 Cedar LaneScottsdaleAZ-GRP-5255CORE-HMO
TPATPA-540632026-01-19T06:57:20ZELIZABETH·PDIAZ1942-03-04NULL•••-••-5517null··—NULL—N/ANULL——
ENRENR-1301942026-02-06T02:19:27ZMEI C··BURKE20-09-1978UHC-54989-41•••-••-2016(620) 238-6100·mei.burke36@gmail.com5002 MEADOW LNDallasTX75219GRP-2843·MEDICARE-ADV-B
TPATPA-56528 2026-05-07T14:59:34ZCHRISTINE····GARCIA03/06/1961—····—-2995 BroadwayMinneapolisMinnesota55477NULL-
CLMCLM-4050482026-04-27T20:10:33ZLopez, Tim——1946-01-15UHC-58975-81··—NULLUNKNOWN·9308 Meadow Ln #186NashvilleTennessee37271GRP-8535—
TPATPA-551392026-07-16T23:58:43ZPamela—Webb1961-07-11—•••-••-9606(641) 220-4459UNKNOWN5174 Lake View RdSAN DIEGOCA92163GRP-2278UNKNOWN
ENRENR-1022542026-03-07T03:56:28ZRALPHFHICKS1980-08-05UHC-56710-86•••-••-77387899787275UNKNOWN8976 Forest AveHOUSTONTX77015GRP-5458·SELECT-EPO
ENRENR-124944 2026-02-16T22:51:43ZChristine—Webb03/15/79··UHC-65802-97•••-••-77258396118541N/A8114 RIDGE ROAD #636Eden PrairieMN55376··GRP-8571OPTIONS-PPO
ENRENR-1012772026-03-19T15:12:12ZBeverly··Gonzales1995-09-04UHC-17854-92•••-••-2963972-542-9556beverly.gonzales@aol.com8059 Church StMinneapolisMN55492··GRP-8260select-epo
CLMCLM-4168072026-02-03T13:50:43ZJANET—CRUZ1955-06-17N/A-UNKNOWN———····N/Anull··—
CLMCLM-4205342026-04-02T09:09:07ZFRANCES—·HARRIS2008-05-17··UHC-24775-06N/A——1203 Church St Apt 36TAMPAFL·33691GRP-2003—
ENRENR-1103782026-07-03T08:35:17Z·Mason, KyleP—1952-03-09UHC-06799-94•••-••-5632854-559-3191—5448 Ocean AveDenverCOUNKNOWNGRP-9355NAVIGATE-HMO··
TPA TPA-642422026-10-09T18:27:32Z·Teresa—Reed19740613UHC-91743-86•••-••-5919····—2181 Main StreetLas VegasNV89144N/AMEDICARE-ADV-B
TPATPA-52501 2026-05-08T19:14:03ZTERRY—SNYDER1989-08-09—N/A·799-729-6005TERRY.SNYDER88@YAHOO.COM··———-·UNKNOWNMEDICARE-ADV-A
CLMCLM-428492 2026-01-19T13:02:50ZARTHUR—WONG07/15/75UHC-99527-30nullnull—nullnullNULL-····null
TPATPA-53271 2026-02-03T09:24:09Znicole—perez1957-11-16UHC-65117-46-·nullnull4434 INDIAN SCHOOL ROADSAN DIEGOCA92169·GRP-4595NAVIGATE-HMO
PRVPRV-257582026-02-18T00:38:06ZEthan—Simmons1947-08-08UHC-10103-53-927-379-2900NULL··922 Palm DriveTEMPEArizona85259-1290NULL—
ENRENR-1152632026-08-08T02:14:05ZMejia, LawreceE.—1964-12-23uhc-44229-83•••-••-5245960-331-9548—8170 Church StTucsonAZ·85727·GRP-4527OPTIONS-PPO
CLMCLM-4131412026-01-04T23:50:06ZSERAH—OLSON10/06/2002uhc-21778-67-(756) 401-9099NULL6116 Willow CourtFRESNOCalifornia93786··GRP-0721UNKNOWN
CLMCLM-4272162026-02-20T16:02:49Zashley—bowman1954-07-27UHC-55178-78•••-••-3065-—5161 MEADOW LNSan AntonioTX78219GRP-6238··NAVIGATE-HMO··
ENRENR-1392122026-05-20T22:02:17Zjordan··harrison12/6/1938UHC-50825-87•••-••-29713244495201JORDAN.HARRISON68@PROTON.ME2882 DESERT SKY BLVDPHOENIXAZ85013GRP-5974CHOICE-PLUS-PPO
CLMCLM-4314382026-02-05T16:29:23ZAnn—Hoffman2008-02-22UHC-86939-73——null1273 Ocean AvenueMINNEAPOLISMN55468NULLSELECT-EPO
TPATPA-575312026-09-21T15:23:23ZGary—Carr··05/06/57·UHC-25634-04—UNKNOWNnull9019 Washington StreetSCOTTSDALEAZ85209GRP-1009N/A
TPATPA-635822026-08-27T21:03:41ZJesse—Bryant1948-07-25-—5714282738N/A·9551 Sunset Blvd #549Los AngelesCA90089nullCORE-HMO
CLM CLM-4272082026-01-19T17:33:05ZJulie—Franklin09/25/1967N/A•••-••-4067NULLNULL6590 HILLCREST ROADHoustonTX77018UNKNOWN·MEDICARE-ADV-A
100,000 rows, page 141 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.695Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty