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-260492026-09-10T23:51:57ZEthan—Richardson1951-02-27UHC-74350-59—UNKNOWN··null1264 PALM DRIVESACRAMENTO··CA··95885-3947NULLnull
PRVPRV-219332026-08-16T21:21:02ZRACHELRRIVERA1971-02-24UHC-18995-25·····nullnull5236 OAK STCharlottenc28272——
PRVPRV-216522026-08-02T12:46:19ZAMANDA—WRIGHT1972-08-09····—(405) 644-9641null1297 Willow CourtCHARLOTTENC28241null—
PRVPRV-273742026-01-16T08:32:01ZJUDY—ESPINOZA07/03/1940—N/A(610) 854-1427judy.espinoza@proton.me4889 CEDAR LANELOS ANGELESCA90056-MEDICARE-ADV-A
PRVPRV-272622026-09-06T12:17:38ZMorales—Kevin2005-06-13UHC-41017-23-(906) 953-9933null8345 Park Place·SACRAMENTOCA95808—null
PRVPRV-28061 2026-04-13T09:29:40ZDouglas··—Hawkins1949-10-14—null409-694-8184douglas.hawkins@hotmail.com9435 HARBOR BOULEVARDNashvilleTN37274——
PRVPRV-286382026-07-13T17:28:56Zwayne—lucas1983-03-12—-19708229486wayne.lucas@icloud.com7615 INDIAN SCHOOL RDFresnoCA93770N/A-··
PRVPRV-271432026-07-09T02:53:26ZMariaa—Hart1940-09-21——6139619—4802 Union StreetGilbertAZ85265··—UNKNOWN
PRVPRV-228482026-08-13T16:08:05ZMei—Johnson2/23/1978—UNKNOWN··3637610823··UNKNOWN4634 River RoadPLANOTX75089-8448-OPTIONS-PPO
PRVPRV-211752026-08-13T15:54:27ZRichard··Matthews27-07-1958null—894-579-4523—276 RIDGE RDORLANDOFL32857nullOPTIONS-PPO
PRVPRV-251442026-01-14T02:39:31ZPAULIWOODS2007-09-24—null-—8824 SPRING STScottsdaleArizona85296null—
PRV PRV-260192026-03-31T00:33:13ZDaniel··Q.Soto08/17/1985—NULL574-815-2457daniel.soto2@icloud.com1606 BroadwaySeattleWA98175-4701—NULL
PRVPRV-253042026-02-19T10:39:11ZDorothyE.Griffin03-12-2006UHC-72937-08—(275) 847-5394·N/A3762 Market StGlendaleAZ85321——
PRVPRV-273262026-03-03T06:34:51ZjesseJ.weaver1958-11-12UHC-76848-80•••-••-5843749.492.7515NULL4153 VALLEY VIEW DRIVEFresnoCA93784—null
PRVPRV-258232026-03-31T15:48:28ZJACOB—HERRERA3/22/1962UNKNOWN——N/A8167 HIGHLAND AVENashvilleTN37298—OPTIONS-PPO
PRVPRV-251322026-06-07T17:58:17ZJudithR·CastroJun 18, 1946-—+1 338 924 9418—9281 Baseline RoadSan Diegoca92180—UNKNOWN
PRVPRV-260742026-04-09T03:28:50ZJennifer—Watkins21-04-1993UHC-27706-65N/A13146720042—-null—N/ANULLnull
PRVPRV-288342026-01-11T10:57:28Zisabella····crawford1950-05-23UHC-64929-99NULL(473) 461-8525—4169 WILLOW COURTSan DiegoCA92146-—
PRVPRV-271542026-01-14T04:46:12ZCox, Katherine——7/13/2008—-14399238866NULL4094 Washington StDenverCO·80226UNKNOWN—
PRVPRV-267962026-05-16T00:07:50ZGarrett, Mark——11/07/1994UHC-56857-90-5054549837mark.garrett@proton.me7693 CENTRAL AVEMIAMIFL33196····null
PRVPRV-278522026-01-27T04:36:39ZJulie—HartAug 25, 1940UNKNOWN•••-••-61049969126—3705 Harbor BoulevardMESAAZ85245··—-
PRVPRV-234622026-07-22T18:38:54ZEugeneTRyan·10/12/1938UHC-31719-62-656.853.3992——UNKNOWN—null—NULL
PRVPRV-259422026-04-27T23:40:32ZSims, DorisO.—1942-11-10uhc-56700-59null876-834-5172-5650 Valley View DrPlanoTX75097-N/A
PRVPRV-242712026-05-01T17:38:41Zbilly—wells19790719UHC-39302-23UNKNOWNnullbilly.wells@icloud.com1325 Church StPhoenixAZ85091-N/A
PRVPRV-241002026-03-29T18:51:29ZEugene····Rios·2006-04-25UNKNOWNUNKNOWN—NULL9216 Canyon Rd···Las VegasNV89193—UNKNOWN
PRVPRV-226252026-07-09T18:47:57ZMARIANA—MASON12/17/65UHC-25369-28-457-246-7847mariana.mason8@proton.me7478 Mountain View Drive·JacksonvilleFL32270N/A—
PRVPRV-268942026-03-29T02:46:41ZMriaLStephens1986-09-24UHC-32216-39N/A(861) 763-3911maria.stephens@outlook.com1827 Canyon Rd··San DiegoCA92119-N/A
PRVPRV-244012026-09-30T21:09:48ZWeiNFoster1994-11-03--6534728447wei.foster67@icloud.comUNKNOWNNULL··-—NULLOPTIONS-PPO
PRV PRV-275692026-04-09T18:03:52ZDayO.Kathleen11/21/1966NULL—414.675.3098kathleen.day28@aol.com3932 Meadow Lane Apt 31TAMPAfl33660nullUNKNOWN
PRVPRV-277052026-09-12T04:00:41ZAMANDA—LASON05/26/1970UHC-41813-77N/A569-589-2242null2019 HIGHLAND AVENUEMesaAZ85281nullN/A
PRVPRV-279022026-04-11T07:43:27ZHenry—Watson1964-01-03uhc-95535-50NULL··925.676.7420UNKNOWN2496 VALLEY VIEW DR·Charlottenc28279null-
PRVPRV-226602026-02-18T16:26:07ZAaronJBell···1940-03-15UHC-97382-48•••-••-3867(515) 885-7553N/A6456 Baseline Road··HOUSTONtx77085NULLNULL
PRVPRV-242872026-05-16T09:40:08ZDennis—Moreno1958-04-11UHC-72206-74N/A(410) 707-4996dennis.moreno@aol.comN/A--··-—null
PRVPRV-263572026-09-09T19:08:59ZGEORGE—ROBINSON1/11/1999——(958) 913-8536··NULL··4700 HIGHLAND AVEMiamiFL··33160-UNKNOWN
PRV PRV-282822026-01-20T11:24:05ZCharles—Scott2006-03-13UHC-81562-74-837.624.3308CHARLES.SCOTT@ICLOUD.COM5859 PALM DRSan AntonioTX78275UNKNOWNMEDICARE-ADV-A
PRVPRV-256002026-03-11T22:31:42Z Young—Carlos1958-03-14UHC-22068-37•••-••-8434756-471-0943N/A···8579 Spring StreetTampaFL33678······CORE-HMO
PRVPRV-232872026-04-08T07:49:38ZSHIRLEY—·LE1982-02-01N/A•••-••-0392831-400-9761—6940 Camelback RdJacksonville··FL32258-null
PRVPRV-278332026-02-13T21:56:11ZjaanetAjimenez12-03-1962UHC-69017-81NULLN/Ajanet.jimenez16@gmail.com·4320 Ocean AveLas VegasNV89175NULLNULL
PRV PRV-273002026-08-01T10:13:15ZJohn—Sanders09/06/38——3628479163NULL·-UNKNOWNN/ANULL—-
PRVPRV-274812026-08-30T00:44:21ZVICTORIA—WALLACE19841210nullN/A—victoria.wallace62@icloud.com2975 Cedar LaneDenverCO80204-5315··UNKNOWNNULL
PRVPRV-288642026-01-25T09:17:16ZjenniferMwebb··3/7/2007UHC-32803-28NULL··13437145056jennifer.webb@icloud.com2087 Mesa Drive #893FRESNO·CA93716··—
PRVPRV-279262026-05-22T06:16:22ZBerry, CarolT—1986-08-25—-(245) 908-8555NULL2971 Indian School RoadSeattleWA98131—·SELECT-EPO
PRV PRV-292832026-09-22T03:45:06ZWilliamI.Vargas12/28/1981UHC-52456-25•••-••-7669(527) 442-1061NULL5990 APACHE BOULEVARDNASHVILLETN37247—-
PRVPRV-28771 2026-05-06T09:18:46ZJAMES—CARR1972-06-13·NULL—(479) 839-0086-6601 WASHINGTON STAtlantaga30369UNKNOWNCHOICE-PLUS-PPO
PRVPRV-245072026-05-01T03:53:42ZKathryn—Contreras19520419UHC-21639-91null5387115kathryn.contreras@gmail.com6059 Ridge RoadColumbusOH43252-4294——
PRVPRV-274622026-08-25T00:51:00ZThomas—Gonzalez··1975-09-24UHC-73038-56NULL(892) 392-1982—1811 Indian School RdPhoenixArizona85024UNKNOWN-
PRVPRV-267202026-06-15T16:18:00ZBEN—FULLER1964-03-15UHC-11971-67•••-••-9885N/A··null4702 Spring StreetNashvilletn37237-MEDICARE-ADV-A
PRVPRV-231502026-04-29T12:30:25ZAMANDA—ORTIZ2003-09-19UHC-69544-44nullNULLamanda.ortiz72@yahoo.com7344 BASELINE ROADSeattleWashington98125—UNKNOWN
PRVPRV-289432026-08-27T08:08:26ZNANCY—CARPENTER1980-06-07··null—659-664-3853··N/A7629 OCEAN AVE #426DallasTX75246—null
PRV PRV-220282026-08-11T14:02:32ZLaura, Kelly—··1957-02-22NULL—5728815057—9767 Broadway··MinneapolisMN55477-4734··N/A
9,596 rows, page 154 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:56.332Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty