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-223772026-09-23T12:23:14ZBruceHWrd1939-10-03UHC-99058-30N/A·(751) 370-6054NULLUNKNOWN————MEDICARE-ADV-B
PRVPRV-245812026-06-12T04:47:14Z GABRIELW··HUNT19740723--+1 491 526 9389—6315 Harbor BoulevardMinneapolisMN55421-SELECT-EPO··
PRVPRV-204552026-02-22T14:24:33Z·Olivia·S·Carroll07/19/79UHC-59310-82UNKNOWN·(913) 883-8310N/A···3195 HARBOR BOULEVARD #923NashvilleTNnull—N/A
PRVPRV-208362026-10-10T03:07:06Zbenjamin··Y.castillo2007-09-15-•••-••-2711+1 855 308 7264NULL374 Canyon RoadLos AngelesCA90012——
PRVPRV-223152026-01-08T23:12:10Zdavid—adams1980-12-14UHC-48978-80-nullnullnull--—N/A—
PRVPRV-243052026-05-24T02:02:52ZMegan····Burke1908-12-16UNKNOWN•••-••-4836UNKNOWNN/A7111 OCEAN AVE #193SeattleWA98128UNKNOWNCORE-HMO
PRVPRV-200412026-05-17T03:56:23ZGloriaTWalsh11-06-1941null—(848) 798-2440—7387 Elm StreetChandlerAZ85204UNKNOWNNULL
PRVPRV-257492026-09-30T03:15:25ZGregory··James1971-03-22nullNULL2062741907gregory.james@gmail.com669 Desert Sky BlvdSan Antoniotx78294—MEDICARE-ADV-B
PRVPRV-227542026-08-08T23:05:38ZJudy······Rius10/21/56·null•••-••-5905(698) 938-8866··NULL7327 Meadow Lane·PlanoTX····—NULL
PRVPRV-256192026-02-17T06:19:04ZkevinF.··stevens19931006UHC-84647-19-572-320-1256—3605 Ridge RoadChandler··AZ85233UNKNOWN—
PRVPRV-230272026-02-06T18:35:14ZAmber—SalazarDec 17, 1962NULL-··(349) 881-5048amber.salazar@gmail.com1069 Sunset Boulevard Apt 15Las VegasNV·89103—CORE-HMO
PRVPRV-265192026-10-17T21:22:18ZSchmidt, Matthew——04/09/1990N/A·N/A+1 787 696 0213··NULLnull-N/A-——
PRVPRV-243212026-07-14T12:14:52Z yuki—foter1987-04-23UHC-89406-61N/A(987) 333-2156UNKNOWNN/A——null—SELECT-EPO
PRVPRV-220012026-03-23T15:34:12ZBenjaminBDavis12/09/71·UNKNOWN—963-788-1778··-4361 Cedar LaneLas VegasNV89151-8246—OPTIONS-PPO
PRVPRV-257142026-03-09T07:21:52ZAlice—Gordon1961-02-17——220-672-1411alice.gordon@aol.com9363 LINCOLN WAYSeattleWashington98122NULL·UNKNOWN
PRVPRV-231252026-06-28T06:15:22ZChristian, Rojas··D—15-05-1958-—5299698703null4017 Main StreetLas VegasNV89161UNKNOWN—
PRVPRV-274412026-02-22T00:29:00ZROGER—MYERS2003-10-14NULL—N/AUNKNOWN4575 Cedar LaneCharlotte··NC·28281—OPTIONS-PPO
PRVPRV-273282026-07-08T21:15:35ZLuis—Cole1976-05-18-NULL(512) 742-9601N/A1216 Grand AveCharlotteNC··28279—-
PRVPRV-287692026-05-18T21:10:38ZRachelMFowler1983-05-20-·null(243) 883-2716RACHEL.FOWLER@YAHOO.COM8542 Forest AvenueMinneapolisMN55405··—UNKNOWN
PRVPRV-263692026-10-08T22:04:55ZPeter—Furd10/23/1991UNKNOWN———9835 Pine DriveDallasTX75263——
PRVPRV-218982026-09-19T07:44:35ZVirginia·N.Greene2005-06-22—•••-••-3329(265) 552-4091···4747 Willow CourtSan Diego··California92152—-
PRVPRV-234802026-06-14T23:17:18ZVICTORIA—WANG10/15/40UNKNOWNUNKNOWN7836307201N/A3793 Canyon RoadNashvilleTN37207UNKNOWNnull
PRVPRV-290282026-08-05T09:25:38ZHannah··Butler19870626N/A•••-••-0777896.388.4504NULL5044 Union StSan AntonioTX78212N/ANULL
PRVPRV-218682026-04-06T18:09:55ZLoganHWelch1964-09-19·N/A•••-••-1702948.395.6037null5903 GRAND AVEMinneapolisMN·55407-7398UNKNOWNUNKNOWN
PRVPRV-212162026-07-06T16:43:30ZAmy—Marshall1994-10-07UHC-80245-87··——amy.marshall44@icloud.com555 MAIN STEden PrairieMN55344UNKNOWNMEDICARE-ADV-A··
PRVPRV-217262026-07-05T23:32:24Znoah—pena1977-02-21-—(703) 440-8565noah.pena@yahoo.com3855 Harbor BlvdGlendaleAZ85350-2934—UNKNOWN
PRVPRV-246422026-08-15T06:38:25ZGeorge—Bryant1965-11-15UHC-88695-40•••-••-1798null····2407 Bayshore DrSAN DIEGOCA·92181-8778UNKNOWNN/A
PRVPRV-21261 2026-07-02T09:46:35ZAlice—Moris09-06-1995UHC-55977-01•••-••-4439680-960-2952··N/A·9349 OCEAN AVENUEChandlerAZ85264——
PRVPRV-257482026-06-13T05:00:24ZANN—HUDSON1947-09-06——2866764888—2748 Palm DriveEDEN PRAIRIEMN55320—CHOICE-PLUS-PPO
PRVPRV-204582026-05-07T12:43:49ZAdam—Nunez··1950-10-11NULLUNKNOWN358-457-9168—5131 Apache BlvdPhoenixAZ85044—-
PRVPRV-247202026-05-17T13:42:54ZHiroshi—Hendersn1954-09-17——5593648863hiroshi.henderson48@aol.com3888 Church StPhoenixAZ85049—MEDICARE-ADV-B
PRVPRV-213292026-08-13T09:02:49Zrebecca—·munoz19580921—•••-••-9541348-573-6847—8264 HILLCREST ROAD #969CHARLOTTENC28260··N/A
PRVPRV-249862026-02-28T08:06:18ZNOAH—MORGAN1976-03-20UHC-82203-05•••-••-4716N/Anull5058 PALM DRNashvilleTN37274UNKNOWNCORE-HMO··
PRVPRV-277412026-06-24T13:58:42Z·CHRISTOPHERH.ROBINSON19900422—NULL314-211-3859··christopher.robinson@yahoo.com2661 Valley View DrLos AngelesCA90006··NULLnull
PRVPRV-222212026-04-13T14:16:00Z·Jeff—Jensen1695-08-17null··null(276) 462-1789JEFFREY.JENSEN85@AOL.COM6869 Willow Court·TempeArizona85287N/ANAVIGATE-HMO
PRVPRV-251412026-05-19T19:23:53ZShirley—Young1940-06-06nullUNKNOWN··SHIRLEY.YOUNG50@PROTON.ME1087 Camelback RdPlanoTX75054NULL··null
PRVPRV-233542026-04-25T16:49:51ZBrenda··Y.Montgomery·Jan 10, 1990UHC-06242-21null215.999.6590··—8095 Grand Ave··Los AngelesCalifornia90071UNKNOWN—
PRVPRV-252182026-05-21T18:49:59ZGibson, ArthurT—1982-09-25—•••-••-76262933056159arthur.gibson98@aol.com6998 Cedar LaneAustinTX78736NULLNAVIGATE-HMO
PRVPRV-295112026-03-12T20:02:14ZMariana—Henderson1986-11-02-—(390) 404-7929mariana.henderson@gmail.com8672 HIGHLAND AVENUEOrlandoFL32884UNKNOWNnull
PRVPRV-273212026-06-09T06:59:25ZWILLIE—RIVERA1997-04-28UHC-34561-90—6753114765null3895 Meadow Ln·Los AngelesCA90067——
PRVPRV-200772026-04-28T10:05:40ZHarper—AdamJun 26, 1994null—+1 460 483 0028··adam.harper55@icloud.com3915 Maple AvenueJacksonvilleFL32279——
PRVPRV-203382026-03-19T08:52:14ZBarnes, Carolyn··——1978-04-07NULL—693-385-2923—·6013 Church StreetLas VegasNV89151-0734UNKNOWNMEDICARE-ADV-B
PRVPRV-211842026-07-13T03:26:10ZJeremyD.Campbell1971-01-02N/A··UNKNOWN+1 725 776 4765JEREMY.CAMPBELL@PROTON.ME5454 MARKET STFresnoCalifornia93733······—
PRVPRV-263362026-04-22T14:45:44ZMarshall, Wayne——1983-10-09N/A•••-••-9501UNKNOWN-6085 Church Street·San AntonioTX78295UNKNOWN—
PRVPRV-214782026-02-27T03:36:25ZJUSTIN—WONG10-01-1960-null15583050718—4253 Forest AvenueTucsonArizona85741——
PRVPRV-20319 2026-06-21T16:40:45ZGarrett, JasonI—2002-09-09N/A—2837872669-4930 Lincoln WayTUCSONAZ··85777-MEDICARE-ADV-B
PRVPRV-234282026-05-09T22:42:19ZKeith—MillsDec 7, 1969·N/AUNKNOWN8646607825NULL278 Hillcrest Rd #759SeattleWA98106-9997null—
PRV PRV-234152026-07-15T14:08:46ZJudy—·Gibson07/16/1959UHC3436453—5864063625null8631 Oak StGilbertAZ85275nullOPTIONS-PPO
PRVPRV-205322026-04-30T00:31:57ZWalter—Weng1947-09-13-•••-••-6814(771) 958-3882walter.wang@outlook.com·5093 Grand AvenuePlanoTX75090UNKNOWNN/A
PRVPRV-274992026-07-15T18:31:33ZBetsy—WeaverJul 9, 1985—null592-501-6577UNKNOWN2357 Ocean AveSan AntonioTX78239-8169NULLnull
9,596 rows, page 57 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:40.635Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty