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-244382026-02-05T09:01:36Zrlph—oliver1995-03-26UHC-98397-43UNKNOWN988.202.9621NULL1949 Spring StreetLos AngelesCAnullUNKNOWN-
PRV PRV-276552026-03-20T10:08:30ZSTEVEN—EDWARDS1943-10-14UHC-25642-74•••-••-8307(673) 983-5407UNKNOWN1488 Hillcrest RoadSAN DIEGOCA92172N/AMEDICARE-ADV-A
PRVPRV-205372026-04-20T12:15:59ZJeremy—Bailey1956-06-22······467.594.4062null2491 Cedar LaneFRESNOCA93755NULLMEDICARE-ADV-A
PRVPRV-245682026-05-09T03:04:56ZJACOBRGERENE···10/02/1984UHC-35926-22NULL·314-965-7945-9893 MEADOW LANEJACKSONVILLEFL32211·-—
PRVPRV-266922026-02-21T08:27:35Z David P.—Jenkins··May 5, 2003··UHC-89133-69··null333-548-5373david.jenkins@outlook.com4240 Jefferson AveMinneapolis··MN55496-1504NULL—
PRVPRV-200672026-02-16T06:41:10Z roy····wood9146-05-11null··N/A16067236102·roy.wood94@aol.com2733 Sunset BoulevardGilbertAZ85212—N/A
PRVPRV-289562026-02-09T05:30:57ZHelen—Ryan··1998-10-21··—UNKNOWN630.583.0091null3533 Pine DriveATLANTAGA30366UNKNOWNUNKNOWN
PRVPRV-214582026-08-20T06:37:59ZSantiago·····Torres06/15/1961N/AN/A+1 259 624 4074null5968 PARK PLACETUCSONAZ··85756NULLN/A
PRVPRV-292592026-03-29T09:20:29ZAMBERG.WALKERSep 21, 1987-•••-••-8324NULL·UNKNOWN6375 River RoadMiamiFL33158UNKNOWNnull
PRVPRV-267472026-07-18T06:44:18ZTERRY—·OLSON01/20/1945UHC-32163-31•••-••-3113311-513-0681··null423 Elm StreetLOS ANGELESCA90058nullNAVIGATE-HMO
PRVPRV-281672026-03-19T20:09:21ZWALTER—FLORES19-01-1991UHC-34847-72—449-348-5271NULL1997 LAKE VIEW ROADSeattleWA··98102—NULL··
PRVPRV-221282026-08-17T00:46:40ZSara··—Fields·2004-02-19UHC-44926-42•••-••-1350(417) 452-9509··sara.fields@proton.me1134 Union StAustinTX78707-9862UNKNOWN-
PRVPRV-255892026-08-07T01:54:54ZMelissaZ.Moreno1988-04-02UHC1603264—·(219) 445-2758null5025 Oak StreetChandlerAZ·85295—··
PRVPRV-286432026-02-03T22:45:39Z·DEBORAH—HALL·1983-01-08·UHC-03263-45•••-••-4687(336) 712-4151-3592 Maple AvenueSACRAMENTOCalifornia95844null····
PRVPRV-263132026-01-22T08:35:51ZLINDA—HOWARDMay 15, 1950UHC-68897-62··—314-396-1765LINDA.HOWARD@YAHOO.COM6346 Market Street #936TampaFL33614——
PRVPRV-275372026-08-14T11:15:40ZELIJAH—WILSONMar 7, 1945··NULLUNKNOWN3272767470elijah.wilson99@gmail.com8213 RIVER RDDENVERCO80231N/AUNKNOWN
PRVPRV-279542026-04-27T06:36:19ZFernanndez, Janet——1989-04-14——-JANET.FERNANDEZ@PROTON.ME8060 Ridge RdSAN DIEGOCA92189—null
PRVPRV-204262026-09-28T11:38:32ZWillieFValdez1943-12-12N/ANULL5905463036UNKNOWN4034 River Rd #223MinneapolisMN55475nullUNKNOWN
PRVPRV-20642 2026-09-07T12:24:18Zbradley—anderson··1976-07-24UHC-50591-26—4063021271bradley.anderson@outlook.com5819 FOREST AVENUELAS VEGASNV89120—-
PRVPRV-258932026-03-23T11:40:19Zeric—snyder1971-01-27UHC-51431-79null—eric.snyder@aol.com4671 Union StScottsdaleAZ85283·N/Achoice-plus-ppo
PRVPRV-215462026-07-08T13:55:42ZRONALD—JAMES09/11/2006UHC-93023-09—3062271480——N/A———-
PRVPRV-277902026-02-16T07:48:36ZjoanO.brooks1964-05-03UHC-26997-72—6432077408UNKNOWN··2198 FOREST AVENUE Apt 40·PHOENIXAZ85096··N/A
PRVPRV-259382026-03-28T17:59:19ZAshley—Garrett19751005—-6482839997ASHLEY.GARRETT36@AOL.COM5074 Sage Court··PHOENIX·AZ85000—-
PRVPRV-210122026-07-05T18:30:43Z Frank—Thompson1992-04-06nullnull··14469309182FRANK.THOMPSON57@PROTON.ME7457 Spring St #719TUCSONArizona85710-2063—UNKNOWN
PRVPRV-22489 2026-01-15T04:09:58ZSarah—Vega1972-11-12UHC-79841-48-8229827800N/A9321 MEADOW LNPlanoTX75074N/AOPTIONS-PPO
PRVPRV-288292026-10-06T21:12:15ZJoe—Rojas1982-01-06·-—8514202582··—7841 SAGE COURTPhoenixAZ85047NULL—
PRVPRV-227422026-04-03T12:54:28ZDanielle—Anderson·1985-00-89··•••-••-9812427.727.2430—8155 CHURCH STREETCHARLOTTENorth Carolina28284N/AUNKNOWN
PRVPRV-292392026-01-27T03:13:05ZKim, Ethan——1972-01-09—null436-757-9202—3734 Grand AveGilbertAZ85213—MEDICARE-ADV-B
PRVPRV-278902026-05-13T10:30:23Zjoe—harvey1970-03-07··—·-6054023698JOE.HARVEY80@AOL.COM7400 SPRING STOrlando··FL32890—OPTIONS-PPO
PRVPRV-246502026-01-11T07:24:37ZJOHN—PORTER1993-06-22UNKNOWNNULL17939670501-2936 Camelback RoadSan DiegoCA92107NULLMEDICARE-ADV-A
PRVPRV-201492026-02-02T05:47:44ZWILLIAMMFERGUSON1965-09-19UNKNOWNNULL4812110400NULL29 Market StreetAustinTX78774null····
PRVPRV-261142026-01-18T00:42:38ZMADISON—DANIELS·1946-07-06UHC-22765-24—·9375241910—5065 Desert Sky BoulevardMesaAZ85275nullMEDICARE-ADV-A
PRVPRV-230882026-02-05T17:55:24Zrichard—brown1955-05-11UHC-07594-55•••-••-20919155620804—304 Oak StreetColumbusOH43280--··
PRVPRV-257412026-07-25T18:31:28ZREBECCA··N.MUNOZFeb 1, 2001UHC-92686-75N/A766-283-8843NULL7527 Maple AveSCOTTSDALEAZ85219—NAVIGATE-HMO
PRVPRV-291862026-02-08T10:00:10ZAlan—Nichols1975-03-06UHC-14705-81•••-••-11685605844566NULL7434 Cedar LaneGILBERTAZ85224—·NULL
PRVPRV-254562026-05-18T08:19:42ZNOAH—MUNOZ1973-01-26—·-4842166noah.munoz@icloud.com5381 Pine DriveHoustonTexas77095-—
PRVPRV-241112026-04-12T12:26:50ZPaul—Gilbert1952-08-21UHC-18539-67N/A6952328172··NULL6577 RIDGE RDHoustonTX77048-2100nullnull
PRVPRV-219722026-08-02T10:40:10ZSantiago, Christian——1987-03-15-null(394) 770-3248··christian.santiago@proton.me3993 Jefferson AveSan AntonioTX78202-—
PRVPRV-291192026-08-27T01:08:58ZKnight, Susan····—1999-02-05·-•••-••-78906093148800-1461 MESA DRGILBERTAZ85299-1763-UNKNOWN
PRVPRV-237022026-03-20T09:27:41ZMadison—Richards1946-11-09—UNKNOWN420-947-3320null4785 Cedar LnGilbertArizona85276—NULL
PRVPRV-245672026-04-14T15:30:26ZJacob—Medina11/12/1940UHC-52242-33•••-••-29502084056695··N/A898 Jefferson AvenueGlendaleAZ85382-9283N/ANULL
PRVPRV-257862026-05-12T14:07:19ZJose—Yang··0043-19-39—NULL969-570-8235N/A·3298 RIVER RDTucsonAZ·85737—MEDICARE-ADV-A
PRVPRV-223222026-01-21T03:52:13Z·GLORIA—KIM19530403UHC-38778-99UNKNOWN14409054905UNKNOWN··4694 SUNSET BLVDTempeAZ85237··UNKNOWNUNKNOWN
PRVPRV-251152026-01-19T10:35:38ZAndraw—Jimenez28-02-1966UHC-47325-45•••-••-51925798790779-3408 SPRING STREETDallasTX··——MEDICARE-ADV-B
PRVPRV-219432026-05-11T05:21:42Z PriyaN.Adams20080526N/AUNKNOWNnullNULL··8489 Washington StOrlandoFL—····—
PRVPRV-240962026-01-08T18:59:46ZKyle—·Young11/24/57UHC-38709-51-·2117034491kyle.young41@gmail.com5907 Harbor Blvd Apt 6San AntonioTX78231—null
PRVPRV-228682026-02-06T17:30:26ZAmy—Kennedy6/19/1947—N/A(665) 538-2478N/A2061 Canyon RoadAtlantaGA——N/A
PRVPRV-234982026-04-16T14:06:11ZROY—BOWMAN1952-07-07UHC-76053-45N/A—roy.bowman58@outlook.com··1638 Pine DrEden PrairieMN55364—UNKNOWN
PRVPRV-224682026-07-20T04:25:18ZANAQALLEN1938-05-27UHC-40301-04—921.650.8923····94 SPRING STMiamiFL33168NULLCORE-HMO
PRV PRV-28370 2026-01-23T07:05:55ZWillis, NicoleK—02/08/97UHC-86882-04null+1 740 801 8267nicole.willis@hotmail.com1520 Highland AveGilbertAZ85299-7346-NULL
9,596 rows, page 76 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:43.634Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty