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
CLMCLM-4154262026-03-26T05:56:32ZAHMED—HERNANDEZ15-04-1942UHC-21736-01UNKNOWNnull—3347 Jefferson AveSACRAMENTOCA-GRP-4600SELECT-EPO
TPATPA-562752026-02-04T02:06:07ZPATRICKREVANS1977-02-01UHC-91421-44—6859068697NULL————GRP-3794SELECT-EPO
ENRENR-1141332026-08-09T20:40:47ZedwardFscott1977-01-11UHC-52393-57•••-••-98978308687644·null6147 ELM STDallasTX75229GRP-9638OPTIONS-PPO
CLMCLM-4254292026-07-21T12:22:30ZDenise—Wilson11/14/1987uhc-05747-60N/A——420 Hillcrest RdSAN DIEGOCA——NULL
PRVPRV-289772026-02-09T14:27:31Z Dunn, MariaM—1994-05-25——(427) 666-8119nullNULL—N/A--N/A··
PRVPRV-290332026-05-25T06:00:14ZJosephILucas1963-11-28UHC-13804-58—630-268-9018—4555 LINCOLN WAYAtlanta·GA30345-3962····NAVIGATE-HMO
ENR ENR-1040332026-08-05T18:41:25ZGERALDCCUNNINGHAMJul 23, 1951UHC-47203-81•••-••-975017875677578GERALD.CUNNINGHAM8@PROTON.ME3051 WASHINGTON STREETScottsdaleArizona—GRP-8584NAVIGATE-HMO
ENRENR-1243462026-09-24T04:14:42ZWILLIE—GREENE3/23/2001UHC-80414-25•••-••-7052631-291-5495willie.greene@proton.me2632 INDIAN SCHOOL ROADJacksonvilleFLUNKNOWNGRP-9401MEDICARE-ADV-A··
CLMCLM-4196042026-01-12T17:50:13Z ·Amy····Flores1947-08-22UHC-82844-75N/A-··null-NULLNULL—GRP-8824MEDICARE-ADV-B
PRVPRV-238682026-03-12T17:47:00ZGloriaYBowman19930705UHC-30916-26-727.744.2396-224 Forest AveOrlandoFL32819··N/A
ENRENR-1000262026-03-08T03:36:19ZNANCYOCAMPBELL20-05-1991UHC-10392-04•••-••-46057332381159NANCY.CAMPBELL16@GMAIL.COM3517 BASELINE RD #391JACKSONVILLEFL··32266-0702GRP-5012MEDICARE-ADV-B
PRVPRV-253742026-04-01T22:43:49Z Kimberly—Burns1982-01-20UNKNOWNNULL+1 230 548 7241—3423 Camelback RdTEMPEAZ—nullUNKNOWN
ENRENR-1168932026-10-14T04:14:58Z MichaelV.Harrison19603709··UHC-04868-24•••-••-283319577426060·michael.harrison@aol.com7551 LAKE VIEW ROADLos Angeles··CA90095GRP-5271NAVIGATE-HMO
TPATPA-545462026-04-25T06:49:33ZALBERT··STEPHENS1967-02-04·N/A•••-••-817712968297461albert.stephens@outlook.com5794 RIDGE ROADColumbusOhio43213null·NAVIGATE-HMO
CLMCLM-4122012026-09-02T03:48:10ZSam—Santos3/4/2005UHC-42300-84····——7827 Church StSEATTLEWA98147UNKNOWNMEDICARE-ADV-B
ENR ENR-1372202026-07-02T18:01:40ZBeverly—Andrews0601-49-68UHC-46632-04•••-••-1776930-267-8660beverly.andrews@outlook.com3754 Market StLas VegasNV89190GRP-4371OPTIONS-PPO
CLMCLM-4177102026-05-12T11:10:40ZNoah—James··1957-09-12UHC-65636-63-——7565 Meadow LaneAustinTX——NULL
CLMCLM-4154692026-03-07T03:38:12ZNICHOLASTJOHNSON1950-06-24UHC-82744-56UNKNOWN279.731.3619··N/A2844 Cedar Lane··Las VegasNV89171··GRP-3855N/A
CLMCLM-4185212026-03-10T07:55:48ZMichellle··NCarroll··12/26/1980UHC-10245-69•••-••-4435+1 885 281 9163NULL·-——·nullNULL··-
CLM CLM-4099952026-07-28T02:39:33ZJean—Williamson·1954-07-12NULLNULL——5902 Apache BoulevardSEATTLE··WA—GRP-0298NAVIGATE-HMO
CLMCLM-4121562026-09-27T05:04:41Zarjun—cruzJan 12, 1941UHC-83745-64··NULL(280) 922-2156—2005 Indian School RoadDenverCO80240GRP-3790CHOICE-PLUS-PPO
TPATPA-613202026-03-04T01:57:19ZRose, Madison——11/16/66UHC-58752-22··•••-••-2912——3811 Bayshore DriveScottsdaleAZ85291GRP-2831-··
ENRENR-1238912026-02-03T10:35:06Z JULIAS···TRAN1973-07-16UHC-57015-51•••-••-01079165387193julia.tran52@icloud.com7521 MEADOW LANE Apt 5SacramentoCA—GRP-4934SELECT-EPO
TPATPA-612662026-08-06T05:56:53ZBILLY—GREEN1939-11-06——464-626-4015—1467 SAGE COURTLas VegasNV··89165UNKNOWNN/A
ENRENR-1330502026-06-08T17:16:22ZPhilip—HuntDec 3, 1940uhc-75677-47•••-••-2944985-371-6230N/A3806 Forest Ave·DenverCO80280GRP-1192MEDICARE-ADV-B
CLMCLM-4293562026-05-28T17:05:23ZWeaver, Janet—··1995-02-05nullnullUNKNOWNJANET.WEAVER16@PROTON.ME9551 LAKE VIEW ROADAtlantaGA30307GRP-4822CORE-HMO
ENR ENR-1238152026-05-12T09:51:34ZSTEVEN—HENRYApr 14, 2005UHC4973404•••-••-0520962-487-5932null2583 Elm StreetTEMPE··AZ85209GRP-6091CHOICE-PLUS-PPO
ENRENR-1121732026-08-10T06:50:31ZJoshuaT.·Roberts27-03-1963UHC-94013-86•••-••-58435431655JOSHUA.ROBERTS13@GMAIL.COM9038 Washington StreetColumbusOH43202GRP-1102MEDICARE-ADV-A
ENRENR-1303152026-09-14T07:48:57ZkatherineHrose1973-04-01UHC-31860-41··•••-••-4642734-537-3502katherine.rose@gmail.com2876 OAK STREETDenverco80221GRP-0259SELECT-EPO
ENRENR-1135642026-07-05T16:09:53ZCarlKPayne10/25/55UHC-04139-14•••-••-0025NULLcarl.payne10@icloud.com3575 WILLOW CT·Los Angelesca90052-7523GRP-3197NAVIGATE-HMO
CLMCLM-4255262026-05-29T00:47:24ZZACHARY—WHEELER14-08-1961-•••-••-8002——--N/A—N/A·CHOICE-PLUS-PPO
TPATPA-500252026-04-28T03:04:22ZValentina—Warren1959-11-17UHC-64240-81-17375366901—9049 MAPLE AVEDALLASTX··75225UNKNOWN·CORE-HMO
PRVPRV-278052026-06-19T19:42:48ZMichael—Schmidt28-10-2004UHC-23738-80UNKNOWN(579) 956-6239—7258 HARBOR BOULEVARDDallasTX·75268-·NAVIGATE-HMO
CLM CLM-4292592026-05-02T22:37:14Z·Frank—Evans1968-12-05null•••-••-9605—NULL1218 OCEAN AVENUEAustinTX78772GRP-8230—
CLMCLM-4031562026-08-07T23:45:02ZEdwaardX.Kinng11/13/1959UHC-04608-19•••-••-0029(648) 570-5403-183 GRAND AVENUESACRAMENTOCA95860··GRP-4758NAVIGATE-HMO
ENR ENR-1079852026-03-28T01:14:00ZZachary—Hudson12/12/1952UHC-64556-29•••-••-2862(676) 219-7000—3391 Jefferson AvenueGILBERTAZ85288GRP-1265options-ppo
ENRENR-1005102026-02-24T18:59:34ZMADISON····GRAY·1939-01-06UHC-63832-03•••-••-4325358-862-5805—8799 BROADWAY··TempeAZ85296GRP-0472MEDICARE-ADV-B
ENRENR-1402132026-05-25T18:31:53ZSnyder, Ruth·V—08/13/2002UHC-67308-56•••-••-775119714512261RUTH.SNYDER56@AOL.COM8202 Highland AvenueNashvilleTN-GRP-5738·NAVIGATE-HMO
ENRENR-1267962026-03-10T12:20:47ZJoyceVMorrison—UHC-12150-71•••-••-14158293765765·joyce.morrison92@gmail.com1476 Forest AveJACKSONVILLE··FLnullGRP-0901SELECT-EPO
CLMCLM-4251982026-08-04T12:30:24ZDavid—Cooper·1952-10-03UHC-31002-68—+1 212 764 7184N/AnullNULLnullUNKNOWNGRP-1238MEDICARE-ADV-A··
PRVPRV-229812026-02-07T04:29:42ZAlexander—Jordan1979-06-22N/A•••-••-6342+1 652 795 7318alexander.jordan@icloud.com8019 Church StCharlotteNC28263nullN/A
ENRENR-1008772026-01-16T20:08:50ZEUGENEJ.KIM20010802UHC-75568-78•••-••-444114325136961eugene.kim@yahoo.com8421 Mesa DriveLas VegasNV89139GRP-9699MEDICARE-ADV-B
ENRENR-1150252026-05-16T04:27:16ZANA I.—MENDOZA1996-01-08uhc-49984-10•••-••-9040918-820-6065NULL2269 Bayshore DrSeattleWashington·98162-1057GRP-9340NAVIGATE-HMO
PRVPRV-290232026-02-24T11:27:57ZMATTHEW—COX1952-01-15UHC-62478-86UNKNOWN850-983-4923··N/A·6971 Park PlaceAtlantaGA30377—UNKNOWN
ENRENR-1061532026-04-06T06:08:19ZAdamL··Freeman12/10/54UHC-15081-88—NULL—2392 Oak StSan AntonioTX78223GRP-5498CHOICE-PLUS-PPO
TPATPA-611862026-04-06T17:11:34ZShirley—Thomas01/03/50N/AUNKNOWN·891-494-2053NULL4157 Jefferson AveSan DiegoCA92155—N/A
CLMCLM-4037802026-03-08T07:32:36ZDylanD.Arnold3/17/1964UHC-34868-16•••-••-3189—dylan.arnold24@outlook.com·7544 Pine DrJacksonvilleFL32225GRP-5946SELECT-EPO
CLMCLM-402712 2026-06-30T12:42:59ZKAYLA—GARDNER··1964-11-25UHC-98906-09—NULLNULL7259 Sunset Boulevard·PhoenixAZ85005GRP-2418··—
ENRENR-1227642026-09-12T21:37:43ZBaker, LoriP—1968-03-05UHC-81821-18•••-••-4390(712) 237-8569LORI.BAKER@AOL.COMUNKNOWN-—NULL·GRP-2723CHOICE-PLUS-PPO
CLMCLM-4193302026-06-07T07:23:04ZSam··Washington1976-07-18UHC-41066-05NULLUNKNOWNUNKNOWN8443 Spring StreetAtlantaGA30357NULLnull
100,000 rows, page 65 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.788Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty