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-218542026-07-07T12:18:22ZMATTHEW—NICHOLS1947-10-03····UNKNOWN(318) 563-9127-UNKNOWN—UNKNOWN——N/A
PRVPRV-293222026-08-19T08:01:17ZMATEO—SIMPSON1994-10-16··UHC-34741-79NULL2039855055null2939 BroadwayLas VegasNV89108-··—
PRVPRV-281322026-04-03T09:32:46ZBRANDON—BENNETT··08/21/39UHC2077628—8373045542UNKNOWN1280 Camelback RoadTucsonAZ85732null—
PRVPRV-226302026-03-08T17:18:18ZJUAN—POWELL1975-01-22UNKNOWN•••-••-1549451-771-2270juan.powell@icloud.com1179 Bayshore DrLOS ANGELESCA·90058-1145NULLCHOICE-PLUS-PPO
PRV PRV-281532026-05-15T06:10:48ZYang, Samuel——10/08/1982UNKNOWN•••-••-47992968404254N/A9388 Oak St Apt 2LOS ANGELESCA90061UNKNOWNUNKNOWN
PRVPRV-258802026-10-06T16:18:50ZNOEH—HUNT2004-06-14UHC-24276-37—4369389818N/A3532 Highland Avenue #266SeattleWA98117—N/A
PRVPRV-271052026-02-03T17:21:17Z Jack—Rose1954-02-02·UHC3795845-UNKNOWNnull·UNKNOWN——N/A-—
PRVPRV-227372026-04-19T18:54:10ZValentinaIAllen1986-02-20NULLnull7009958204valentina.allen91@outlook.com461 Baseline Rd·SAN DIEGOCA92148N/A—
PRVPRV-261252026-06-30T22:15:04ZGREGORY—PENA02-08-1998UHC-97760-95··—647-628-0949UNKNOWN8328 Bayshore DrDALLAS··TX75250UNKNOWNNULL
PRVPRV-224382026-02-19T19:35:50ZRalph··—Hayes12/23/56—UNKNOWNN/Aralph.hayes89@icloud.com6945 Valley View DrTampa··FL33624N/AN/A
PRVPRV-278172026-09-06T02:01:36Zjordan—walker··02/19/88·UHC-96381-04•••-••-1110252.450.9237JORDAN.WALKER@GMAIL.COM3465 UNION STREETColumbusOH·43291——
PRVPRV-229322026-08-25T12:46:08ZGARYURODRIGUEZ1952-11-10UHC-65603-12NULL666-744-2602gary.rodriguez44@icloud.com1707 Mesa DriveCHANDLERAZ85288UNKNOWNnull
PRVPRV-258352026-10-15T05:07:12ZSHARON—WEBER2006-09-08UHC-02965-50•••-••-6630(440) 338-7593—6745 APACHE BOULEVARDSAN DIEGOCA92173-6686—UNKNOWN
PRVPRV-287952026-08-22T01:53:35ZMEI—WALSH··1980-04-15UHC-98864-36-UNKNOWNmei.walsh@aol.com6193 CHURCH STREETOrlandoFL32806N/A-
PRVPRV-201072026-05-08T00:33:40ZCharles—Willis1954-04-17-•••-••-3829778-327-0021CHARLES.WILLIS@YAHOO.COM2631 Lincoln WayAustinTX·78745—MEDICARE-ADV-A
PRVPRV-202682026-03-19T23:12:53ZScott—AlexanderFeb 10, 1939NULLNULL4019916993scott.alexander31@proton.me6524 LINCOLN WAYGlendaleArizona··85392-··—
PRVPRV-206632026-01-03T09:03:59ZHIROSHIDBAKER1/19/1984UHC-28647-99UNKNOWN14398996615··6310 Indian School RoadGlendaleAZ··85357UNKNOWNnull
PRVPRV-207942026-09-12T15:21:54Z·MASON—MOORE1984-05-16·UHC-30212-79N/A325.675.4387UNKNOWN—-NULL··nullNULL
PRVPRV-261052026-03-15T08:57:00ZRoss, Stephanie——1998-02-27-—5058933stephanie.ross@yahoo.com504 SUNSET BOULEVARDAUSTINTX78795nullN/A
PRVPRV-251992026-09-28T05:51:14ZPowell, Christopher——1982-01-17UHC3169764-·8213956408UNKNOWN1288 PARK PLACEPlanoTX75035····MEDICARE-ADV-A
PRVPRV-268442026-06-29T20:10:26ZNATHAN—WATKINS8/6/1974··UNKNOWNUNKNOWN(798) 324-3819—2794 Market StMINNEAPOLISMinnesota55461nullUNKNOWN
PRVPRV-241762026-05-09T18:25:09ZRAYMOND—LAWRENCE8/8/1949··UHC-59874-28-17416800946N/AN/ANULLN/A—-NULL
PRVPRV-292992026-05-26T09:08:02ZCharlesW.Clark1989-03-17UNKNOWN—+1 881 469 2770—8197 MESA DRTempeArizona85263——
PRVPRV-282172026-01-27T16:06:24ZASHLEYDCOOK1970-12-27UHC-87838-91—3277536—857 Palm DriveTampaFlorida33628NULLNAVIGATE-HMO
PRVPRV-212802026-09-22T12:18:24ZLogan—Bell1970-08-22——(224) 759-8345logan.bell@icloud.com8447 River RoadMiamiFL33145····—
PRVPRV-210282026-10-03T13:13:50ZchristianEperez1978-01-11UHC-47113-40NULL7507598645—9660 Grand AveTempeAZ··85211—CHOICE-PLUS-PPO
PRVPRV-292512026-07-17T02:48:25ZASHLEY—·CASTILLOMar 10, 2007UHC-36019-06—5076674217ASHLEY.CASTILLO@OUTLOOK.COM9750 Desert Sky BlvdDENVERCO80289-1131··-N/A··
PRVPRV-208342026-02-20T21:04:28ZKnight, Gloria——1987-09-01UHC-56784-27NULL(500) 647-1272—·4703 Lake View RoadCharlotteNCNULL·NULLN/A
PRVPRV-292762026-01-16T23:39:30ZLinda—White1948-03-14N/AUNKNOWN632-818-3131-496 Ridge RdPlanoTX75093nullNAVIGATE-HMO
PRVPRV-200092026-08-05T17:26:06ZVINCENT—OLIVER1973-05-14·UHC-16577-40N/A7476422564vincent.oliver93@aol.com—NULLnullN/AnullMEDICARE-ADV-B
PRVPRV-217622026-01-01T07:12:55ZgeraldWrichardson1957-04-11UHC-52791-35UNKNOWN2998825660-1747 SAGE CTGilbert··Arizonanull—NULL
PRVPRV-282072026-07-12T10:37:26ZRACHEL—ALEXANDER24-03-2008NULL—(700) 275-3367RACHEL.ALEXANDER31@PROTON.ME7317 Apache Boulevard #596NashvilleTN37288—-
PRVPRV-278322026-08-29T22:18:20ZJesseF.Silva1992-11-10nullUNKNOWNN/Ajesse.silva96@icloud.com2776 RIDGE RDSan AntonioTX78286--
PRVPRV-212192026-10-06T13:30:45ZLawrence—Clark1996-12-10·UHC-09797-27NULL8802015475LAWRENCE.CLARK@GMAIL.COM6263 River RdChandleraz85265··-··—
PRVPRV-252702026-05-25T01:12:47ZAHMEDYDAVIS08/17/2007——6013043745UNKNOWN1495 Union St #517TucsonAZ···85700——
PRVPRV-272282026-06-13T20:02:10ZCARLOS—HOFFMAN··19630801-··-··NULL-·559 MESA DR Apt 27AustinTX78768—··
PRVPRV-266782026-02-24T18:08:37ZDYLANRRAMOS1961-07-22UHC-33618-37null8185998585··null1058 SUNSET BLVD #765AtlantaGA30336—SELECT-EPO
PRVPRV-261682026-09-05T04:51:18ZGraceN··Patterson1983-10-22··UHC6518374null·957-905-4803·grace.patterson@outlook.com2433 Forest AvenueJACKSONVILLEFL32214——
PRVPRV-226492026-03-18T04:45:43ZMEGAN—BRADLEY1967-01-09UHC-27109-52•••-••-5467310-467-9452-251 GRAND AVENUEFresnoCA93769null-
PRVPRV-242262026-01-15T01:34:39Zgloria—richardsoon1981-06-07UHC-97404-89—(816) 822-2234GLORIA.RICHARDSON87@ICLOUD.COM··—N/A—NULLN/Anull
PRVPRV-229402026-05-05T15:45:43ZZachary—Hansen2006-09-21·nullnull(946) 562-7067—8690 Indian School RoadCharlotteNC28224null··
PRVPRV-286162026-01-28T13:30:50ZANDREW··BROWN··Oct 17, 1975—•••-••-0053(619) 933-6966—7476 Apache Blvd #576San DiegoCalifornia92144UNKNOWNNULL
PRVPRV-280322026-09-21T10:20:34ZROGER—·DAVIS4/28/1994··UHC-30457-09•••-••-1182211-419-5514·roger.davis@outlook.com4491 Elm St #863MIAMIFL33168—MEDICARE-ADV-B
PRVPRV-270592026-03-15T17:25:01Zgeorge B.—gilbert19901221·UHC-16075-96UNKNOWN812-604-9356george.gilbert@gmail.com5038 Ocean AvenueSeattleWA98165nullN/A
PRVPRV-229792026-04-08T14:57:37ZMartha—Wood8/28/1995UHC-81219-28—7354552—UNKNOWNnullN/ANULL—UNKNOWN
PRVPRV-289672026-08-25T11:03:23ZJulie—Miller10/16/1955—NULL(392) 572-7898julie.miller@outlook.com52 HARBOR BOULEVARDATLANTAGA30385null—
PRVPRV-207602026-05-09T15:56:04ZNguyen, Julia——11/7/1941-NULL(861) 246-6417UNKNOWN4434 WASHINGTON STREETTucsonAZ85722-SELECT-EPO
PRV PRV-269982026-06-23T17:18:40ZWang, Jacqueline——06/12/1950NULLN/A408-775-0630-N/AN/A—null—null··
PRVPRV-252272026-04-18T12:58:03ZJake—Walker1999-02-27UNKNOWN-4869501794JACOB.WALKER29@GMAIL.COMnull—N/A-—null
PRVPRV-234452026-07-24T13:44:47ZRyan, JanetE····1951-06-25NULL··——1077 Sage CourtMinneapolisMN55435—CHOICE-PLUS-PPO
9,596 rows, page 119 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.115Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty