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
PRVPRV-213952026-05-12T05:32:18ZMichelleI.Fowler··1981-09-08—UNKNOWN(500) 364-6441—2988 Central AvenuePHOENIXAZ85015—N/A
ENRENR-1021282026-09-02T16:04:32ZAronldGCheryl07/17/1939UHC-49778-27•••-••-8986(947) 447-1899CHERYL.ARNOLD1@PROTON.ME1883 Canyon RoadChandlerAZ85280-1775GRP-5564OPTIONS-PPO
ENRENR-1362082026-10-12T22:12:29ZHelenQGordon1958-03-25·UHC-34084-79•••-••-6605(736) 274-5924·helen.gordon@outlook.com2260 Main StDallastx··75268GRP-1338NAVIGATE-HMO
ENRENR-1365602026-03-10T19:45:15ZRUTH····REYES4/27/1954UHC-60020-37•••-••-9262(945) 594-8533ruth.reyes75@icloud.com485 Spring StNASHVILLETennessee·37224GRP-7900MEDICARE-ADV-A
TPATPA-511892026-06-30T04:08:46ZJacob—Evans07/14/1971UNKNOWNNULL—NULL2290 SPRING STJacksonville·fl——UNKNOWN
PRVPRV-273232026-06-11T02:12:57ZDeborah—Luna12/05/53UHC-71000-23NULL932-791-2460UNKNOWN——NULL——SELECT-EPO
ENRENR-1051012026-07-10T04:30:24Z Arthur·L.Guzman1971-05-06UHC-34464-25•••-••-3743630-962-8444—3255 Market StreetMESAAZ—GRP-8206CHOICE-PLUS-PPO
ENRENR-1301812026-03-26T02:06:33ZKenQHarvey1943-05-16UHC-16434-80•••-••-167814087407028··—7548 Ridge Rd Apt 2Phoenix·AZ85041·GRP-5436NAVIGATE-HMO
ENRENR-1325632026-08-28T16:16:25ZDIANA··—CHAVEZ1956-04-26UHC-17528-84•••-••-0242—diana.chavez26@outlook.com2540 SUNSET BOULEVARD #806AtlantaGA30325GRP-8142OPTIONS-PPO
TPATPA-600882026-05-05T14:19:54ZLoggan—Simmons1959-06-11—NULL924.795.1154null8239 Forest AvenueFRESNOCA93786—-
ENRENR-106724 2026-04-05T08:20:08ZHANNAHUBURKE1957-05-28UHC-89677-50•••-••-5352(613) 813-2791hannah.burke@gmail.com··3542 Bayshore DriveTucsonAZUNKNOWN·GRP-9866MEDICARE-ADV-A··
TPATPA-602552026-04-07T22:14:49ZDixon, Janet——10/4/2007-··—UNKNOWNUNKNOWN·2945 Lincoln WayHouston·TX77078GRP-9287CHOICE-PLUS-PPO
TPATPA-545262026-02-16T08:06:05ZCAROLYN—RIVERA1984-02-17·UHC-07452-06•••-••-0053NULLnull·932 Church Street Apt 22DenverCO—NULLUNKNOWN
ENRENR-1367092026-03-12T06:56:38ZMaia—Chapman·6/24/2006UHC-44612-64•••-••-36386096887691—8540 Elm St Apt 10San DiegoCA92173GRP-4210SELECT-EPO
PRVPRV-265212026-05-13T09:54:04Z Williams, James——22-08-1985NULLN/A946.885.0124james.williams@proton.me1733 Canyon RdMinneapolisMN55431-2456—N/A
ENRENR-1410342026-03-02T09:16:43ZVincent—SchultzApr 22, 1981UHC-81777-37•••-••-3046(633) 496-5617vincent.schultz@hotmail.com1802 OCEAN AVENUESEATTLEWA98180GRP-6444MEDICARE-ADV-B
ENRENR-1387492026-08-04T11:53:53ZDay——07/11/1938UHC-20701-07•••-••-769118129109749··null6160 Church StDenverColorado80250·GRP-0212choice-plus-ppo
ENRENR-1088092026-10-14T01:38:11ZKellyMEllisSep 14, 1950UHC3524111•••-••-95748513932723kelly.ellis@proton.me1454 Sage CtEden PrairieMN55378GRP-1379SELECT-EPO
ENRENR-1362142026-04-11T03:08:36ZPerkins, Sandra——6/25/1942UHC-36123-82•••-••-058515134181620sandra.perkins89@icloud.com1706 Apache BlvdMiamiFL··33137GRP-9748CORE-HMO
ENRENR-1366482026-09-22T22:23:55Z·Christine·I.Young1978-10-04UHC-29927-75•••-••-5071+1 696 390 5112christine.young@aol.com··6594 Sunset BlvdOrlandoFL32870··GRP-6504CHOICE-PLUS-PPO
ENRENR-1369822026-05-31T11:01:11ZTaylor—Russell5/10/2004UHC-00465-69•••-••-1747·9764622402—5030 Camelback Rd·AtlantaGeorgia30333GRP-4834OPTIONS-PPO
CLMCLM-4137032026-03-12T14:55:28ZParker—·Carol1961-12-22-UNKNOWN+1 444 748 8275—8789 Market StMesaAZ85216GRP-8539—
TPATPA-536812026-04-26T17:35:36ZARJUN—CHAVEZ1958-07-21N/A•••-••-8248(775) 277-7863··-3309 Elm Street #945CharlotteNorth Carolina28276UNKNOWN·MEDICARE-ADV-B
PRVPRV-221742026-02-22T13:39:42ZFowler, Jason——8/26/1941UHC-57273-87—(943) 724-5381jason.fowler@gmail.com7152 WILLOW CTDallasTX··75239·····OPTIONS-PPO
ENRENR-1071542026-05-25T07:20:27ZCARLOSDLOPEZ1973-03-06UHC-56805-86•••-••-68132628602683N/A-··UNKNOWN··—··GRP-4788CHOICE-PLUS-PPO
ENR ENR-1299532026-06-11T17:15:31ZSamGGarza1948-03-03UHC-66841-45•••-••-3030582-860-4931samantha.garza@proton.me2856 Bayshore Drive Apt 24Eden PrairieMN55388·GRP-0782OPTIONS-PPO
ENRENR-1324082026-06-25T09:19:16ZAmy—Mendoza1961-09-18UHC-78961-66null7684464749N/A4346 HILLCREST ROADOrlandoFL32861GRP-9806CORE-HMO
PRVPRV-279142026-10-04T19:39:07ZCampbell, Elijah——22-10-1959null—3409678447··elijah.campbell90@gmail.com6580 CENTRAL AVESacramento··CA·95886-1616UNKNOWNUNKNOWN
ENRENR-1297322026-07-15T12:42:19ZSpencer, Russell··——1983-09-17UHC-70361-34•••-••-6731(242) 972-5257russell.spencer86@aol.com7801 Bayshore DrAUSTINTX78766GRP-5229OPTIONS-PPO
CLMCLM-4037562026-01-10T17:03:18ZAmyKAlvarado1976-08-13—N/A622.493.9984null4689 SPRING STLas VegasNV·89132—-
CLMCLM-4229622026-10-11T21:56:22ZDebra—Hoffman20-03-1983N/A•••-••-8723577-267-0292-7106 Apache BoulevardTAMPAFL33631GRP-5315·null
CLMCLM-4137892026-07-03T04:01:15ZAlice··—Baker·1952-04-16UHC-01066-48•••-••-0987—ALICE.BAKER@HOTMAIL.COM2666 CHURCH STREETGilbert·AZ—·GRP-5877SELECT-EPO
ENRENR-1391332026-05-27T12:50:01ZAlexysMLewis1957-09-08UHC-96321-26•••-••-0679(923) 240-7930ALEXIS.LEWIS@OUTLOOK.COM6090 Oak Street #550OrlandoFL·32839GRP-7527SELECT-EPO
ENRENR-1003792026-07-23T16:06:51ZRalphZ.·Barnes19890410UHC-25693-03•••-••-84893719487057·RALPH.BARNES@AOL.COM1252 Palm DrDENVERCO80224GRP-5629CHOICE-PLUS-PPO
CLMCLM-4287942026-08-22T08:56:02Z Ralph—Bradley27-07-1980UHC-94420-89N/A—RALPH.BRADLEY@PROTON.MEUNKNOWN····null—GRP-1796NULL
TPA TPA-599432026-02-03T14:01:42ZSofia—Mitchell1943-10-23—•••-••-0921nullN/A—N/ANULL-··—N/A
CLMCLM-4005452026-08-02T23:10:18ZTYLER—MORENO11/12/1994UHC-79913-58—NULLNULL1312 Ridge RoadSEATTLEWA··98120GRP-7084—
ENRENR-1184012026-03-22T23:33:59ZHudson, ElijahK.—19670717UHC-28101-71—353-208-0370ELIJAH.HUDSON97@ICLOUD.COM4748 Apache BoulevardNashvilleTN37226GRP-4547MEDICARE-ADV-A··
CLMCLM-4240442026-10-18T16:16:25ZRobertson, Alexander——01-05-1986UHC2083208UNKNOWN(556) 686-5045—-nullnull·NULLGRP-1960N/A
ENRENR-1105292026-05-20T02:01:17ZDianeN.Perez1968-05-22UHC-33040-39•••-••-40748738954054-4520 Spring Street #384PlanoTX75097GRP-3226SELECT-EPO
CLMCLM-4052202026-01-02T20:20:41ZDixon, NathanX—2/20/1966UHC-50338-25•••-••-1232697-213-8335-··———null—CORE-HMO
PRVPRV-272512026-06-16T14:07:23Zmei—alexander1941-04-04UHC-21643-14—2715819mei.alexander@icloud.com968 RIDGE ROADSacramentoCA95820NULLSELECT-EPO
PRVPRV-249752026-05-27T07:11:46Z Elliott, Isabella——1942-04-03UNKNOWN—(947) 830-0276—·-——nullUNKNOWNCORE-HMO
TPATPA-527482026-08-10T16:08:21ZLuis—Murphy··1965-07-18—•••-••-4444+1 948 894 2399UNKNOWN—UNKNOWNNULL—NULL—
TPATPA-570452026-07-16T00:34:04ZJOAN Q—PADILLA09/01/68UNKNOWN-··UNKNOWNjoan.padilla58@hotmail.comUNKNOWNUNKNOWN-N/AGRP-9441MEDICARE-ADV-B
CLM CLM-4099912026-01-02T19:28:21ZWashington, Mark——1964-09-02UNKNOWN-(912) 251-5141·UNKNOWN4833 Grand AvePhoenix··AZ85062NULLSELECT-EPO
CLMCLM-4001932026-01-21T00:37:44Z sharonC.patelSep 8, 1955UHC-61755-29·-NULLnull400 WASHINGTON STREETChandlerAZ85207NULLNAVIGATE-HMO
ENRENR-1336432026-04-11T20:19:24ZAbigailCWebb1980-06-12UHC-45361-04•••-••-6761837-604-1824abigail.webb25@outlook.com3783 Union StreetEDEN PRAIRIEMN55371GRP-0353·SELECT-EPO
ENRENR-111003 2026-01-13T21:11:43ZHeatherD.Cooper06/07/70UHC-68190-18-7862097832HEATHER.COOPER91@PROTON.ME3206 SPRING STMiamiFL33141GRP-7814CORE-HMO··
CLMCLM-4007082026-03-14T00:31:50Z KarenTRojas··1996-05-21UHC-95344-65•••-••-0393+1 903 838 4737—6039 SAGE CTMiamiFL33184-0200GRP-2673UNKNOWN
100,000 rows, page 73 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.792Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty