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-237012026-10-12T13:25:55ZSANTIAGOA.WONG1969-10-19—UNKNOWN(685) 524-2033santiago.wong@yahoo.com4049 WASHINGTON STREETHoustonTX·77081——
PRVPRV-232702026-04-12T20:27:08ZROYFWATKINS04/27/55UHC-25431-61UNKNOWN-··—NULL--N/AUNKNOWNMEDICARE-ADV-B
PRVPRV-236012026-10-03T06:43:03ZPeters, Mariana——2002-11-02nullNULL6002226952mariana.peters78@yahoo.com5763 BAYSHORE DRLos AngelesCA90074nullNULL
PRVPRV-234872026-04-05T02:20:12ZRALPH·····COX2006-05-21UHC-01981-81NULL(983) 564-4071ralph.cox@proton.me7355 Cedar LnPHOENIXAZ85038N/A—
PRVPRV-266932026-10-16T13:52:26ZBETTY—COX01/01/1944null—2833629998NULL3527 Central AvenueJACKSONVILLE··FL32275UNKNOWNN/A
PRVPRV-279992026-04-08T09:30:44Z ALEXANDER W.—KING19740201UHC-17995-02NULL274-945-2516—2968 Main Street·PhoenixAZ85071NULLNAVIGATE-HMO
PRVPRV-253662026-06-24T13:55:49ZBRIAN—PRICE19581020UHC-78316-88null17703849318BRIAN.PRICE32@HOTMAIL.COM2834 Broadway··LAS VEGASNevada89171-UNKNOWN
PRVPRV-243652026-08-18T00:27:56Z Logan—Lawson1941-11-21UHC2515841•••-••-6952·(608) 877-4393logan.lawson23@aol.com3174 Lincoln WayJACKSONVILLE···FL32204···null
PRVPRV-253502026-08-24T23:57:29ZKaren—Morris19530108UNKNOWN—(659) 790-3673N/A5232 Valley View DrDallasTX··75233UNKNOWN-
PRVPRV-224392026-06-09T18:07:56ZGLORIA—WEBB12/28/1941UHC-39563-01-(421) 890-0395gloria.webb@aol.com7915 MOUNTAIN VIEW DRIVEAustinTX78757·UNKNOWN—
PRVPRV-295252026-01-21T16:39:30ZEUGENEB··MARTINEZ1992-01-17NULL———5914 Canyon Rd·AustinTX78740UNKNOWNnull
PRVPRV-261972026-06-01T17:07:11ZjustinGgriffin09/20/66UHC-52595-90null4024591325UNKNOWN5035 Mesa DriveJacksonville··FL32285——
PRVPRV-260532026-05-23T08:46:27ZVASQUEZ—PAMELA1965-10-16UNKNOWN—841.462.1454·pamela.vasquez83@yahoo.com7641 PALM DRHoustonTX77027-8554-N/A
PRVPRV-247762026-06-21T23:09:05ZGeorge, LoriS—8/5/1947UHC3748727UNKNOWN··5437123950—6812 BroadwayTempeAZ85239··CHOICE-PLUS-PPO
PRVPRV-276832026-09-15T18:00:12ZSaamntha—WangSep 10, 1995UHC-95692-76•••-••-9843+1 295 913 0008—2962 Grand AveJacksonvilleFL32204-NAVIGATE-HMO
PRVPRV-255832026-10-06T18:54:23ZALICE—JACKSON··1/20/1968UHC-04889-09N/A4414694338UNKNOWN3218 Elm StreetDenverColorado80247N/AN/A
PRVPRV-228362026-03-28T04:23:19ZEthan—Jordan03/04/55N/A-8715906335—NULL-————
PRVPRV-253062026-07-03T01:06:04ZDOROTHYE.GRIFFIN2006-12-03—-+1 275 847 5394NULL3762 Market St··GlendaleAZ85321-9082—OPTIONS-PPO
PRVPRV-273012026-05-02T09:32:58ZJOHN—SANDERS09/06/38——362-847-9163—1497 BroadwayTempeAZ85230-4261UNKNOWNN/A
PRVPRV-262082026-01-15T22:23:41ZAna··Hamilton····UHC-11133-36····2183834671—176 Baseline RdLas VegasNevada89121—-
PRVPRV-216762026-09-26T13:24:26ZJulie—Nelson06/26/2006—•••-••-1353715-779-3011··julie.nelson49@gmail.com2858 Hillcrest RoadDenverCO80238——
PRVPRV-235752026-03-16T13:07:19ZBOBBY—SCHULTZ7/18/1958UHC-06876-95•••-••-3109(256) 307-3168-1371 Maple AveSeattleWA98198N/A—
PRVPRV-273022026-03-19T18:47:49ZLori····Sanders1943-10-16UHC-95561-38—(882) 330-2559lori.sanders26@gmail.com1021 Maple AveMesaaz85277—MEDICARE-ADV-A
PRVPRV-291332026-05-05T04:49:53ZDIGO—MORENO09/05/1957·-UNKNOWN586.911.9057—8878 Central AvenueChandlerAZ———
PRVPRV-283572026-01-07T14:41:23ZMarrtha—Black25-07-1979UHC-60855-59null17275741569MARTHA.BLACK59@OUTLOOK.COM9603 Baseline Road··SeattleWA98174N/A··UNKNOWN
PRVPRV-286462026-04-08T09:30:12ZRyan—·Price09-08-1972—UNKNOWN5782591-6961 MARKET STMesaAZ85290——
PRVPRV-215362026-04-25T17:03:12ZJOSEPH—KENNEDY6/9/1946UHC-44031-72—8449281342joseph.kennedy@outlook.com522 Valley View DrFresnoCA93708-—
PRVPRV-256452026-04-09T06:02:13ZMarha—Brooks1966-10-23UNKNOWNNULL438.515.6124MARTHA.BROOKS@HOTMAIL.COM-·N/AUNKNOWN——MEDICARE-ADV-B
PRVPRV-275112026-05-10T03:34:47ZNathan R.—Clark1941-01-15UHC-81651-12—2929846918——N/A-——null
PRVPRV-279512026-06-20T18:57:18Z johnZbryant1951-11-03nullN/A6278474946NULL9217 Elm Street··OrlandoFL—UNKNOWN-
PRVPRV-236832026-03-12T23:36:13ZOMARK··ORTEGA8/2/1966·null—13453747533··N/A··724 Washington StSAN ANTONIOTX78224nullCORE-HMO
PRVPRV-221912026-08-18T02:38:33ZStephanie—Bishop··Dec 17, 1982null—7277018029stephanie.bishop15@gmail.com5282 RIVER RDLAS VEGASNevada89163—NULL
PRVPRV-201172026-10-08T12:12:35ZBennett, Christine··—··8/23/1991UHC-46148-59•••-••-67296425155425—1835 Sunset BoulevardGlendale··AZ85304N/A—
PRVPRV-282732026-09-05T04:47:06ZALEXANDER—PATEL09/23/1985—•••-••-5404+1 443 556 3349—5375 Sunset Boulevard Apt 40PlanoTX—nullUNKNOWN
PRVPRV-217252026-07-10T22:56:01ZNOAH—PENA21-02-1977N/AUNKNOWN+1 703 440 8565null9475 Canyon RoadFresno·CA—····choice-plus-ppo
PRV PRV-260372026-09-21T05:17:59ZGilbert, Ann····—Jun 3, 1953UHC-82848-70NULL8313202868ann.gilbert@hotmail.com·UNKNOWNnullnullNULL——
PRVPRV-252082026-01-28T14:54:07ZFatima—Daniels20070608N/A·NULL659-938-2100—500 DESERT SKY BOULEVARDPlano·TXUNKNOWNnull—
PRVPRV-210092026-01-10T09:03:14ZTimotyh—Reynolds01-07-1961··NULL·455.802.7913—8333 Forest AvenueMiamiFL33125—N/A
PRV PRV-280462026-04-07T09:51:06ZDaavid—Henry1938-09-08UHC-00305-08—--7188 BROADWAYSan DiegoCalifornia···92109-2043--
PRVPRV-215762026-08-23T19:07:54Z·Williams, DanielT.—1993-11-01UHC-57654-55—341.259.0056daniel.williams@outlook.com8390 PARK PLMinneapolisMN··55408·-NULL
PRVPRV-22664 2026-03-23T16:44:57ZDoris—Ford·1985-08-03UHC-09446-73··N/A+1 274 493 8096—4869 Meadow LaneMesaAZN/Anull··UNKNOWN
PRVPRV-277502026-07-01T06:31:02ZAaron—Davis·1968-09-21UHC-45592-84•••-••-5271772-783-8164aaron.davis@proton.me1381 HIGHLAND AVESan AntonioTX··78234·-UNKNOWN
PRVPRV-228172026-01-23T17:38:27ZDANIELLE—TORRES2003-09-16—N/A(855) 832-4572danielle.torres70@outlook.com··3202 CENTRAL AVEORLANDOFL32859—N/A
PRVPRV-284442026-09-17T05:34:19ZDainaM··Maldonado1979-10-19N/A-(601) 829-4529UNKNOWN5458 Jefferson AvenueColumbusOH—NULL··—
PRVPRV-285692026-03-22T23:16:41ZTimothy—Andrews2004-10-24UHC-21607-37-629-586-6091—·8479 Market StGilbertAZ85293-··-
PRVPRV-251592026-07-09T04:29:13ZBetty—MasonJul 19, 1987—N/A·NULL-4776 Hillcrest RdTempeAZ85262N/ACORE-HMO
PRVPRV-211662026-05-30T20:21:02Z willieVschmidt05/12/42UHC-28576-15null251-607-4968-446 Maple Avenue Apt 5HoustonTX77030UNKNOWNMEDICARE-ADV-B
PRVPRV-249322026-10-08T13:21:00ZCHARLOTTE—WHITE—·UHC5637607—····CHARLOTTE.WHITE36@YAHOO.COM4157 MOUNTAIN VIEW DRIVEMiamiFL··33198—UNKNOWN
PRVPRV-211592026-06-21T23:57:26ZCarol—Stevens1942-40-05UHC3422383N/A·7206056203·carol.stevens@aol.com8254 SPRING STREETNashville·TN37250——
PRVPRV-268872026-09-10T21:29:23Z Aaron—Aguilar1987-05-12UHC-55513-50null4258706848—8520 Meadow Lane #185AustinTX78798·NULLNULL
9,596 rows, page 161 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:43:00.234Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty