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-289972026-09-29T09:00:28ZBrenda—·GrantJul 20, 1974UHC-59470-91UNKNOWN(335) 392-2803brenda.grant@outlook.com6156 Washington StChandleraz·85211·NULLnull
PRVPRV-247842026-10-14T15:30:09ZVictoria—Mitchell··08/11/98null—N/A—2965 FOREST AVENUEChandler··AZ85264nullN/A
PRVPRV-247222026-04-14T23:44:24ZAmy—Moore1986-01-20—·null(909) 559-9000amy.moore@hotmail.com9505 WILLOW COURTPlanoTX75017—N/A
PRVPRV-232222026-08-21T04:10:02ZSandra—Snyder1952-02-28UHC-06644-60UNKNOWN5683109468sandra.snyder6@yahoo.com3716 Washington StreetLAS VEGASNevada89140——
PRV PRV-216032026-06-04T12:08:17ZWayne—Gutierrez19821113--(428) 713-1616·wayne.gutierrez@yahoo.com7979 Park PlaceMiamiFL—·N/AN/A
PRVPRV-223922026-05-12T13:48:48ZSARAH··—MARSHALL1941-06-20NULL-(541) 789-1031SARAH.MARSHALL@GMAIL.COM4580 River RoadTUCSONAZ85708—MEDICARE-ADV-B
PRVPRV-258992026-09-27T20:16:26ZSAMUEL—MAQUEZ1995-12-04UHC-23159-56•••-••-63852459718161null927 Church StPHOENIXAZ85093NULL·MEDICARE-ADV-A
PRV PRV-269762026-05-23T10:36:27ZNATALIE H.—DUNCANMar 22, 1972UHC-88287-19-6413717461natalie.duncan@aol.com·930 Meadow LnLas VegasNV89125nullUNKNOWN
PRVPRV-211472026-02-28T03:20:56ZLAUREN—WONG19551013——561-244-2592lauren.wong80@gmail.com7046 Lincoln Way·EDEN PRAIRIEMN55329NULL····
PRVPRV-240082026-01-22T21:33:14ZKathryn—Hart12/28/50UHC-87384-34··-7066007087UNKNOWN1571 MAIN ST Apt 13ScottsdaleAZ··85287—null
PRVPRV-204482026-07-31T16:08:32ZJacobs, Becky——1993-02-24··•••-••-9686(966) 848-6900N/A7259 Highland Ave·JacksonvilleFL32237-1814—·-
PRVPRV-257642026-07-19T13:08:10ZJamesYLongAug 16, 1972—····289-783-8844—6078 Mountain View Dr··Nashville··TN··37251—-
PRVPRV-237452026-06-03T09:04:50ZBILLYX.·HERRERA1962-09-18-····8506769542—4332 Grand AveSan DiegoCA92140UNKNOWNnull
PRVPRV-245372026-02-24T16:52:18ZBishop, Joshua——1944-01-16UHC-15066-21null(793) 405-8502—9490 DESERT SKY BLVDChandlerAZ85202——
PRVPRV-223692026-09-24T16:52:18ZAna—OrtegaJun 23, 1951null-17299707135NULL2539 Palm DrScottsdaleAZ85230—N/A
PRVPRV-277912026-02-16T07:48:36ZjoanO.brooks1964-05-03UHC-26997-72—6432077408UNKNOWN··2198 FOREST AVENUE Apt 40·PHOENIXAZ85096··N/A
PRVPRV-240862026-09-08T11:39:00ZJORDAN—JENKINS1957-12-17UHC-11742-65null5063164513N/A4464 Meadow LnNashvilleTN37294UNKNOWN·CORE-HMO
PRVPRV-288372026-02-09T18:50:20ZMunoz, Judy——19391227—•••-••-9929(227) 831-9737-1477 LINCOLN WAYFresnoCA93767-2217N/A-
PRVPRV-247462026-01-29T03:35:41ZPATRICK—FISHER········•••-••-43577773295953NULLN/A—N/A—N/AUNKNOWN
PRVPRV-245872026-08-21T03:44:36ZOlivia—Parker1982-07-27UHC-73080-77-(607) 977-7656olivia.parker98@icloud.com4826 Cedar LaneGlendaleAZ·85360-UNKNOWN
PRVPRV-26609 2026-10-12T07:06:22ZCarlosQ.Rios1975-03-10UHC9910783N/A——··——null——
PRVPRV-225202026-09-12T04:51:05Zjudith—dean1998-06-17-—19897444303judith.dean@proton.me·7492 Market Street·MesaAZ··85270—N/A
PRVPRV-239352026-03-16T22:21:54Z luis····gray11/21/2007UHC-12522-66-—NULL8034 Park PlFresnoCA93719NULL—
PRVPRV-294462026-05-24T21:14:03ZRichardXHal1968-05-21UHC-80730-48•••-••-3247(365) 379-3998null1642 Mountain View Dr··DallasTX75294-6815nullCHOICE-PLUS-PPO
PRVPRV-294832026-01-12T22:05:07ZLuis—Jones05/16/48·UHC-28777-79null+1 977 804 7251UNKNOWN2298 SAGE COURTPhoenixAZ85096UNKNOWNUNKNOWN··
PRVPRV-281202026-10-01T11:58:45ZBarnes, BarbaraZ—09/12/06-NULL488-365-6405nullUNKNOWN-··——·N/ANULL
PRVPRV-224042026-03-23T05:36:22ZRoger U—Hawkins10/01/04UHC-20801-61UNKNOWN276-874-4343null3171 HARBOR BLVDPlanoTX75012····OPTIONS-PPO
PRVPRV-224942026-09-01T10:15:16ZBRANDON—KIM2005-03-05··UHC-49210-04·UNKNOWN··-9353 Church St··San DiegoCA92173·N/A—
PRVPRV-260332026-03-18T23:07:15ZMason··PFoster03/14/75··nullUNKNOWN··4662759937-8369 BAYSHORE DREden Prairiemn55344··NULL
PRVPRV-213882026-05-08T11:59:31ZARTHUR—ALEXANDER··19560820UHC-11557-51•••-••-14244968151NULL4818 MARKET STREETNashvilleTN37273NULL-
PRV PRV-270702026-06-05T06:41:34ZDAVID—WEBER1980-04-08N/A-7556844058N/A··7188 Jefferson AvenueDenverCO80211——
PRVPRV-210552026-02-16T09:28:54ZChristopher—BurnsDec 12, 1996nullnull354.942.2013N/A7466 UNION STREET··CharlotteNC··28296—UNKNOWN
PRVPRV-280122026-10-11T07:44:11ZCHRISTINE—VALDEZ1960-02-08UHC-95611-79•••-••-14778623587484christine.valdez@icloud.com—NULL-NULL-—
PRVPRV-266942026-01-31T04:33:14ZMelissa—DeanJun 22, 1947UHC-69799-61—17139706252NULL3888 Harbor BoulevardPHOENIXAZ··85065—MEDICARE-ADV-A
PRVPRV-272692026-06-11T20:34:02ZDiane—Stephens4/1/1971UHC-27084-18—·13586056108NULL2642 HIGHLAND AVENUEChandlerAZ85222-4393-—
PRVPRV-271012026-05-04T16:18:43ZDoris—Thomas1984-12-15UHC-73006-67··•••-••-5694594-451-1673DORIS.THOMAS26@YAHOO.COM·1951 UNION STREETSan DiegoCalifornia92188-OPTIONS-PPO
PRVPRV-265982026-01-29T17:04:26ZLarry—Marshall07/04/71UHC-53367-57N/A5284209087larry.marshall@yahoo.com1466 Grand AvenueMINNEAPOLISMN··55410-—
PRVPRV-256352026-07-09T21:29:33ZJoe—Sullivan19760810UHC2182312N/A+1 559 594 9883joe.sullivan66@aol.com6632 BASELINE RDMiamiFL33142-7081—SELECT-EPO
PRVPRV-252892026-09-01T15:29:56ZadamO.rodriguez6/16/1997—N/A448-537-9656—7818 Oak StreetSAN DIEGOCA92131—MEDICARE-ADV-A
PRVPRV-252772026-04-01T11:18:46ZWAYNE—SIMPSON12/17/96UHC-80007-46•••-••-0156+1 575 949 5120WAYNE.SIMPSON25@YAHOO.COM1873 Ridge RoadChandlerAZ85208N/AN/A
PRVPRV-245782026-09-15T04:32:50ZCHARLOTTE····OBRIEN1944-12-04——8398329182charlotte.obrien@gmail.com··2619 CENTRAL AVESan DiegoCA—-—
PRVPRV-263412026-05-28T18:50:39ZRogerJPatterson1985-04-25·UHC-93623-42N/A+1 502 735 8264UNKNOWN6366 Washington St #330ATLANTAGA30326-7050N/A-
PRVPRV-219032026-04-10T19:33:34ZRalph··—Schultz1980-08-17-—9157722627—8278 ELM STREETMIAMIFL33140—N/A
PRVPRV-282872026-01-19T04:33:05ZLaura—ThomasApr 21, 1940UHC-63477-40····810.480.4448UNKNOWN2534 Central AveColumbusOhio43227—-
PRVPRV-223542026-04-18T05:39:13ZChavez, WayneI.····1995-08-11·UHC-99718-58UNKNOWN288.610.7037—586 OCEAN AVE··Fresno·California93725-····
PRVPRV-292482026-04-15T21:55:22ZFRANKLIN—ISABELLA07-04-1973UHC-14942-32N/ANULL—7906 Indian School RoadSan DiegoCA92154nullN/A
PRVPRV-268792026-01-03T17:14:57Z EVANS—VINCENT2007-02-09UHC-91535-79—3006985vincent.evans@proton.meNULL··—UNKNOWNN/A··—
PRVPRV-255342026-03-02T09:57:57ZMARILYN—REYESOct 22, 1975—null3649536284—6140 Baseline RoadEDEN PRAIRIEMN55365-2558——
PRVPRV-249032026-04-03T02:31:53ZALEXANDER—PERKINS1959-03-62UHC-60662-97•••-••-237717164336395UNKNOWN26 Camelback RdPlano··TX75058nullN/A
PRVPRV-218262026-01-30T09:55:29ZSOPHIAZLYNHC1697-10-21UHC0198086····736-964-4069—2211 Harbor BlvdMESAAZ85279UNKNOWN—
9,596 rows, page 132 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:53.732Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty