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

Provider network only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-244822026-03-27T09:07:18ZDOUGLASQHUNT02/04/65UHC-18462-40—6002316071—7565 Canyon RdTucsonAZ85771-2027-—
PRVPRV-245842026-03-10T03:15:51ZCheryl—HoffmanNov 26, 1996UHC-27166-87-(562) 402-1989NULL7863 Forest AvenueLas VegasNV89173—MEDICARE-ADV-B
PRVPRV-266962026-02-28T04:54:11Zedward—duncan1961-06-25UHC5979784-—N/A619 Market StDenverCO80280-8205-SELECT-EPO
PRVPRV-269292026-05-07T05:12:24ZAARON—REYES04/11/96UHC-76516-13NULLUNKNOWN··null··593 Pine DrPHOENIXAZN/ANULLMEDICARE-ADV-B
PRVPRV-276012026-03-15T09:58:11ZaliceI.hunter2006-08-21——6005691813alice.hunter@outlook.com2357 INDIAN SCHOOL ROADPlanoTX75062UNKNOWN—
PRVPRV-250252026-08-09T03:38:15ZGregoryUWoods03/11/98UHC-74086-93-···NULLUNKNOWN2736 Oak StreetSan DiegoCA92136-4756——
PRVPRV-270452026-10-03T02:31:52ZBettyCRose1945-03-03UHC-74182-23··-600-356-2475—8135 Central AveColumbusOH43210—null
PRVPRV-202672026-01-02T18:29:39ZBARBARA—GREENE·17-11-2007NULL•••-••-07023764992139—6074 Washington StScottsdaleAZ85202UNKNOWN·NULL
PRVPRV-243492026-01-31T07:47:05ZBruce··Hansen04/06/1995UHC-49101-83•••-••-98347293716405UNKNOWN3759 WILLOW CTAustinTX78735—MEDICARE-ADV-A
PRVPRV-270552026-05-21T02:51:27ZJenice—Kelly1956-11-05-•••-••-8199616.758.0964UNKNOWN——-——N/A
PRVPRV-219672026-01-23T11:10:40ZLori—·Lewis9149-03-09—•••-••-0163—lori.lewis@hotmail.com6077 Highland AveAtlantaGA··30331nullUNKNOWN
PRVPRV-272902026-05-08T15:20:30ZLaurenKJames·08/05/78UHC-83197-90•••-••-9515445-346-8381lauren.james74@aol.com——·-NULL——
PRVPRV-21748 2026-02-16T13:46:21ZDavid—Padilla1992-07-28null·UNKNOWN6750684NULL4545 LINCOLN WAYLos AngelesCA90097··—NULL
PRVPRV-22340 2026-07-08T06:40:00ZALEXIS—BURTON1975-10-05UHC-80754-22•••-••-5601——6768 OAK STDallasTX···75278—N/A
PRVPRV-25618 2026-09-09T04:31:32Zmateo—wilson19800619nullN/A441-647-1125··UNKNOWN4537 HIGHLAND AVENUE·DallasTX75236UNKNOWNN/A
PRVPRV-276772026-03-22T14:49:24ZFrank—Robertson05/16/82UHC-20010-86·UNKNOWN8027583177·null2074 HILLCREST ROADTampaFLnull——
PRVPRV-278412026-04-07T21:05:50ZRUSSELL—TRAN10/1/1946UNKNOWN•••-••-62824179334279·null8161 Valley View DrMesaAZ85288—-
PRVPRV-213992026-04-28T00:05:09ZRamirez, Diego——1976-05-26UHC-23908-84—7058086643-8373 Ridge RoadFresnoCA93734····-
PRVPRV-239372026-01-06T21:05:20ZJACQUELINE—PADILLA1985-07-25·UHC-58059-62•••-••-4981691-746-5292····8450 Cedar Lane Apt 34FresnoCA··93782NULL-
PRVPRV-235622026-06-23T02:51:02ZSteve—Evans2005-02-27—•••-••-21773963716719stephen.evans31@gmail.com4867 Central Avenue·GlendaleAZ85377—choice-plus-ppo
PRV PRV-262462026-08-02T23:05:46ZALEXIS—PAYNESep 9, 1960UHC-05678-36··-843-212-1327N/A309 Indian School RoadPhoenixArizona85062UNKNOWNUNKNOWN
PRVPRV-245232026-01-22T07:11:49ZMelissa—Fisher·19880910N/A•••-••-4647670-826-4013·-7841 Willow CtMIAMIFL33114NULL-
PRVPRV-211542026-07-26T01:55:09ZGreg—Barnes2008-07-05null•••-••-5730410-232-8143—1753 Bayshore DriveDallasTX75241—MEDICARE-ADV-A
PRV PRV-257042026-08-26T17:32:02ZMarilyn—Barnes1957-12-23-····+1 625 382 1548marilyn.barnes48@icloud.com4785 APACHE BLVDSan DiegoCA——UNKNOWN··
PRVPRV-217942026-07-02T13:38:20ZJacqueline—Payne08/12/52——(766) 482-1145jacqueline.payne39@outlook.com8478 Sunset BlvdPlanoTX75091nullnull
PRVPRV-240322026-02-12T12:13:07Z·JessicaGPerezFeb 15, 1997NULLN/A891-713-3214—9284 Willow Court··DallasTX———
PRVPRV-251262026-02-24T06:26:32ZAlexanderBFernandez1965-08-05nullnull397.712.3312alexander.fernandez@icloud.com3851 Spring St··PlanoTX75031—N/A
PRVPRV-233002026-10-14T18:22:29ZGuerrero, Anthony——1972-11-10UHC-93685-60—2622920400-·6030 MAIN STAustin·Texas78733null-
PRVPRV-250662026-03-25T01:04:12Z Dick··—Jacobs12/03/1974UHC9264571•••-••-0922(294) 778-1536richard.jacobs@gmail.com6914 Lincoln WayTucsonAZ85780-2248—null
PRVPRV-221572026-04-12T09:47:24ZCarl—Taylor1939-12-17nullN/A··+1 611 927 8812carl.taylor81@aol.com8064 BroadwaySan Antoniotx78204·-NAVIGATE-HMO
PRVPRV-256362026-09-07T14:42:24ZMark—·Greene·Oct 25, 1991UHC-68929-38-(245) 480-1147-9173 Meadow LaneDallasTX75223—navigate-hmo
PRVPRV-283662026-01-29T02:19:13Zjulie—stephens1955-03-26UHC-55281-28N/A·6747149796—7634 WASHINGTON STREETAtlantaGA30391-CHOICE-PLUS-PPO
PRVPRV-221922026-02-07T18:51:12ZDiana—Freeman19841123N/AN/A(389) 967-4890UNKNOWN9230 Market StCharlotteNC28295UNKNOWN-
PRVPRV-290822026-01-01T11:39:02ZSharun—Lewis1982-06-20UHC-19056-83N/A(903) 526-6511—7383 CENTRAL AVENUE··HOUSTONTX77018nullNAVIGATE-HMO
PRVPRV-223232026-04-16T02:50:55ZBobby—Dixon1958-01-25—-16504333180-2777 Washington StreetDALLASTX75278N/ANAVIGATE-HMO
PRVPRV-263472026-03-07T05:59:58ZCHRISTIAN—MENDEZ19831211—•••-••-7405—UNKNOWN··9346 Market Street·TUCSONAZ85710——
PRVPRV-274222026-02-13T03:57:39ZGARY—·WEST1950-10-18——496-397-7857GARY.WEST34@PROTON.ME9832 Grand AvenueFresno··CA93796-1885--
PRVPRV-249492026-06-22T17:38:20Zluis—delgado··1999-05-08··—(503) 222-3372—6453 Grand AvenueLAS VEGASNV89193-—
PRVPRV-282012026-01-17T03:58:49ZPatricia—Gardner··2004-03-08UHC-34913-40NULL(684) 562-5659N/A5921 Union StreetCHANDLERAZ85203-NULL
PRVPRV-234122026-04-12T06:42:45ZTHERESAURICHARDS··1968-04-08-null+1 456 963 7577UNKNOWN·5657 RIDGE ROADLas VegasNV89140N/A····
PRVPRV-232882026-04-16T19:16:46ZWelch, Eugene····—12/05/72UHC-25678-60null415.958.7929null6531 Jefferson AvenueScottsdaleArizona85291N/A-
PRVPRV-214542026-10-10T05:03:22ZMurphy, Camila······1977-05-27—····7648076360CAMILA.MURPHY@OUTLOOK.COM7655 Forest AvenueSCOTTSDALEAZ85253—·N/A
PRVPRV-287342026-05-14T22:06:02ZAustin—Contreras1941-12-19UHC7212049UNKNOWN12887922714null7460 CANYON RDSan DiegoCAUNKNOWNnull·-
PRVPRV-219742026-04-30T11:52:53ZBEN—MONTGOMERY1993-08-16UHC-75056-83•••-••-0581404-869-3915—·4860 Union St·Los AngelesCA90081nullUNKNOWN
PRVPRV-206732026-05-17T12:27:31ZCastillo, George——2008-10-04···uhc-12374-30··2074700932NULL5752 Sage CourtPhoenixAZ85055··—CORE-HMO
PRVPRV-294882026-06-23T07:31:34ZHAROLD—FIELDS12/15/77UHC-15310-75UNKNOWN567.719.6437null3836 Indian School RoadTempeAZ85201-—
PRVPRV-283532026-07-05T04:19:10ZBetty—Weber07/23/1956—NULL·5507961997N/A9852 Spring StMiamiFlorida33118··—
PRVPRV-262442026-09-15T13:41:05ZRalph—Wang0306-91-52UHC-12292-28UNKNOWN·837.904.1449ralph.wang@yahoo.com—UNKNOWNN/A—nullSELECT-EPO
PRVPRV-258662026-07-01T20:24:42ZNoah—Greene1950-02-17—UNKNOWN+1 676 441 6981—1784 River RoadAtlantaGA30300-··
PRVPRV-284382026-04-27T09:55:24ZJoyceTJohnson08/04/1994N/A-12222822911··null1785 Ridge RoadScottsdaleAZ··85209—MEDICARE-ADV-B
9,596 rows, page 105 of 192PreviousNext

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:49.134Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty