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-1012502026-09-09T00:04:18Z·JUSTIN—SHAW1971-02-13UHC-36800-97•••-••-8621·723-252-2359justin.shaw88@icloud.com9091 Baseline RoadEden PrairieMN55301GRP-6561CORE-HMO
ENRENR-1011532026-07-11T03:40:40Ztimothy—kelly1989-07-01uhc-36460-96•••-••-098414893100129-2193 Mountain View Drive·SeattleWashington-GRP-0924MEDICARE-ADV-B
ENRENR-1046832026-08-12T17:58:15ZPeterIRose04/16/1939UHC-46761-66····(749) 400-0201peter.rose48@yahoo.com7632 MAPLE AVESacramento··CA·95884GRP-3193MEDICARE-ADV-B
CLMCLM-4088312026-07-10T19:33:33ZGREGORY—·PARKER05-05-1961UHC-82884-11NULLUNKNOWNUNKNOWN2142 Mountain View DrGLENDALEAZNULLGRP-0568—
TPATPA-508032026-09-10T23:23:21ZHIROSHII.REYNOLDS21-06-1965UHC-14204-71•••-••-3799NULL··2054 Sunset BlvdSacramentoCA95897-3490GRP-3130CORE-HMO
ENRENR-1390482026-03-30T12:56:03ZElizabeth—GrantAug 9, 1975·UHC-55669-57•••-••-6487·19776231497—7355 Palm DriveSACRAMENTOCalifornia95882GRP-3548MEDICARE-ADV-A
ENRENR-1287102026-02-16T04:17:10ZRYANWJORDAN1998-05-21UHC-77314-38•••-••-0569(858) 825-7642—3112 BroadwayORLANDOFlorida·32821GRP-1195MEDICARE-ADV-A
ENRENR-1014972026-03-30T20:35:36Z Jackson, Dorothy——11/10/2008UHC-09214-53•••-••-6988975-936-9494N/A6142 Lake View RdDenverCO80268-8216GRP-0969CORE-HMO
TPATPA-504532026-02-05T11:02:51ZMaria—Harrison1998-01-02UNKNOWN•••-••-5727—null-UNKNOWNN/A-····UNKNOWN
ENRENR-1403442026-04-23T07:01:15ZJUDITH··—MORGAN17-12-1942UHC8522749•••-••-5486449-367-4179—112 MEADOW LN··CHANDLERAZ—GRP-2808CORE-HMO
ENRENR-1307822026-02-11T08:38:33ZJERRYQMOORE1963-04-12UHC-01331-32•••-••-8834·8214662649-5838 Lincoln WayCOLUMBUSOhio····GRP-3651OPTIONS-PPO
TPATPA-572882026-08-18T04:45:26ZHELEN—MEJIA19870120-•••-••-3061——9445 DESERT SKY BLVDEden PrairieMN55352NULL··-
CLMCLM-4005132026-10-04T09:53:00Zamy—hanson·Oct 8, 1987UHC-09703-59—nullNULL62 Lake View RdTucsonAZ85782GRP-7367······
CLMCLM-4249802026-05-13T19:21:41ZBarbara—Ruiz1976-06-24·UHC-02604-46-787-474-7712UNKNOWN695 Willow CtTempeAZ85228GRP-2555··
ENRENR-1388592026-01-23T19:58:51ZRobertWJacobs19710114UHC6674829•••-••-3523·(593) 840-8570ROBERT.JACOBS69@AOL.COM7254 Central AvenueAtlantaGA30335-1343GRP-3719SELECT-EPO
CLMCLM-4070442026-06-04T15:32:30ZWayne—Herrera20011126UHC-59812-10UNKNOWN—N/A2047 Central AvenueGILBERTAZ85232··GRP-0262—
ENRENR-1366452026-08-27T08:19:04ZBRUCEJ.COOK2008-02-14UHC-04730-06•••-••-90024388445588bruce.cook@gmail.com5720 Mesa DrSan DiegoCA92199GRP-2870MEDICARE-ADV-A
PRVPRV-220272026-02-08T18:03:33ZLAURA—KELLY1956-02-22UHC-41118-16•••-••-2039+1 572 881 5057—9767 BroadwayMinneapolisMN55477—·NULL
ENRENR-1320442026-05-14T19:20:19Z·KennethTDiaz2000-11-09UHC-01133-38•••-••-6498—kenneth.diaz@icloud.com5393 MOUNTAIN VIEW DROrlando·FLUNKNOWNGRP-6679OPTIONS-PPO
PRVPRV-294782026-06-29T23:25:54ZKeith—Jensen2004-11-19—UNKNOWN··(261) 762-2851keith.jensen@icloud.comN/ANULL····-—null
ENRENR-137130 2026-04-15T02:47:29Zheather—thomas06/10/1966··UHC-81325-84—(258) 316-4560HEATHER.THOMAS@GMAIL.COM1556 UNION STREETSCOTTSDALE·AZ85292·GRP-5394MEDICARE-ADV-B
CLMCLM-425802 2026-07-09T01:08:48ZROB—GUERRERO1947-06-24·UHC-60022-45•••-••-092714619474350N/A8843 OCEAN AVENUESeattleWA98184-SELECT-EPO
ENRENR-1260532026-01-21T07:51:49ZMargaretIGutierrez6/5/1990UHC-61468-65•••-••-7216726-358-6525margaret.gutierrez@outlook.com6810 Ridge RoadFRESNOCA93792-8287GRP-9162·OPTIONS-PPO
TPATPA-628052026-04-06T03:47:12ZPamela—Gibsson08/17/1956UHC-70252-36———5051 Willow CourtPhoenix·AZ85076-6276GRP-3248CHOICE-PLUS-PPO
ENRENR-1221682026-07-23T14:21:39ZKevin N—Reid1941-06-13··UHC-59417-37•••-••-5045273-434-0725kevin.reid@gmail.com7948 Meadow LaneScottsdaleAZ85232-2754GRP-6335MEDICARE-ADV-B
CLMCLM-4116192026-03-13T18:59:07ZOliviaG.Espinoza06/06/1998UHC-99981-18•••-••-157916729738163NULL4233 APACHE BLVD #461FresnoCA93730N/AUNKNOWN
CLMCLM-4130982026-03-31T19:23:48ZStewart, Wayne—····11/25/58UHC-01428-01NULL—UNKNOWN·6154 Indian School RdScottsdaleAZ85288GRP-9469NAVIGATE-HMO
TPATPA-586682026-08-03T01:42:07ZCox, DanielleX.—1943-04-12————5635 Spring StreetSacramentocaUNKNOWN—····
CLMCLM-4212822026-05-28T18:59:54Zterry—hall··1988-07-22UHC-83199-44•••-••-2830(761) 479-6806UNKNOWN9208 MESA DR··SAN ANTONIOTX78288——
TPATPA-502342026-08-26T22:41:50Z·Fatima—Perkins08/13/2002—null··563-341-5264UNKNOWN2090 Park PlLas VegasNV89140——
CLMCLM-4208742026-06-15T08:28:52ZMarilynLGuerrero1961-03-04UHC-39266-24•••-••-954714427188502marilyn.guerrero@icloud.com————·N/AMEDICARE-ADV-B
CLMCLM-4082602026-05-01T11:57:30ZPamela—Hicks1951-06-04UHC-52905-09-NULLUNKNOWN5492 HIGHLAND AVESeattleWA98198-1869GRP-1938N/A
CLMCLM-4288042026-05-06T18:52:19ZBilly—Bailey4/17/1981-NULLNULL-··———N/AGRP-3723··CHOICE-PLUS-PPO
ENRENR-1354782026-04-08T18:28:03ZEDWARDN.RAY1980-01-04UHC-25720-33•••-••-7203(982) 447-3753EDWARD.RAY14@HOTMAIL.COM5698 Palm DrTEMPE··AZ85252GRP-6138··MEDICARE-ADV-B
ENRENR-1283652026-02-19T17:04:20ZEric······Dixon1991-11-09UHC-22960-96•••-••-76729947845UNKNOWN4973 Maple AveCHANDLERAZ85287-7615GRP-0242CORE-HMO
PRVPRV-211222026-10-08T00:46:19Zjeremy····wagner··1995-05-10UHC-69263-65null394.828.8733—5862 Oak StreetEDEN PRAIRIE··MN55305——
ENRENR-1110932026-02-24T20:49:33ZMARILYN—GRAHAM··1953-04-24UHC-90242-40•••-••-5611+1 842 366 9957MARILYN.GRAHAM@YAHOO.COM1606 Palm DrEden Prairie·Minnesota55342-3745·GRP-1635OPTIONS-PPO
ENRENR-1150992026-08-19T05:31:39ZMICHELLE··—RILEY1939-03-18uhc-95909-02•••-••-6859325-641-3894N/A888 Cedar LaneTucsonAZ··85741-3402GRP-7446select-epo
CLMCLM-4086002026-01-25T03:12:52ZWayneVFerguson1969-06-12UHC-81497-60NULL(739) 778-1136UNKNOWN8019 BroadwayMesaAZ—GRP-6852OPTIONS-PPO
ENRENR-1011602026-06-16T15:56:59ZJessica F—·Webb02-12-1991UHC-33021-16··•••-••-99902382538105—6576 Market StreetLos AngelesCA90041GRP-0739CHOICE-PLUS-PPO
ENRENR-1072292026-02-03T06:53:26ZLnda—·Stevens05/21/49UHC-29670-57•••-••-3189693-302-2129linda.stevens33@outlook.com5554 Forest AveDALLASTexas·75220GRP-1824CHOICE-PLUS-PPO
ENRENR-1259652026-04-11T14:14:17ZRussell, Aisha——08/03/1961UHC-64455-52•••-••-0104+1 255 667 9446AISHA.RUSSELL69@AOL.COM824 INDIAN SCHOOL RDNASHVILLETN37239GRP-2467··MEDICARE-ADV-A
CLMCLM-4214872026-02-27T16:29:48Zvictoria····vasquez1951-10-26UHC8992968-N/AUNKNOWN6241 MARKET STREETOrlandoFlorida32879GRP-5256NULL
ENRENR-1077682026-03-07T05:06:57ZJOSEJELLIOTT11/26/2004UHC-09518-38—NULL·JOSE.ELLIOTT@ICLOUD.COM1677 Oak StSan DiegoCA92172GRP-0388CHOICE-PLUS-PPO
ENRENR-1068302026-08-27T14:22:30ZANADCONTRERAS2003-01-57UHC-79284-72—(618) 762-4848ana.contreras37@yahoo.com9416 Ridge RdAtlantaGA·30359GRP-5584MEDICARE-ADV-B
ENRENR-1272542026-06-09T03:44:12Z SANTIAGO—PARK1941-08-20UHC-48055-29•••-••-0697730-746-5276SANTIAGO.PARK@HOTMAIL.COM8358 RIVER ROADSAN ANTONIOTX78278GRP-0541MEDICARE-ADV-B
CLMCLM-4084092026-03-05T11:43:58ZLuis····Peterson1981-09-10UHC-91715-29N/A·(636) 537-4820-807 CANYON ROAD Apt 18LOS ANGELESCA90047—OPTIONS-PPO
ENRENR-1092082026-01-01T12:42:12ZWayneYHerrera11/26/01UHC-59812-10•••-••-9629673-817-7492wayne.herrera32@aol.com2047 Central Ave··GilbertAZNULLGRP-0262OPTIONS-PPO
TPATPA-557112026-02-28T22:39:32Z Jeremy····Castillo19810928NULLUNKNOWNN/A-3847 Grand AvenueTempeAZ85235N/Anull
ENRENR-1066702026-06-11T18:24:20ZSARAH·EPARK06/27/64··UHC-57297-32•••-••-0364224-853-8438sarah.park@hotmail.com1654 Church StreetAtlantaGA··30343GRP-2618MEDICARE-ADV-A
100,000 rows, page 67 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.789Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty