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-256282026-06-06T23:44:55ZSophiaOTurner1947-01-18UNKNOWNNULL(943) 563-3376·UNKNOWN4569 HARBOR BLVDCOLUMBUSOH43266UNKNOWN-
PRVPRV-251342026-07-10T18:46:05ZAndy—Johnson02/15/88NULLNULL··5129442andrew.johnson@aol.com845 PINE DRIVEPlanoTX75013UNKNOWNnull
PRVPRV-250142026-08-21T04:35:15ZNAATLIE—SHAW1966-08-15UHC-04451-66•••-••-0843239-601-4239-491 PALM DRSACRAMENTOCA··95819——
PRVPRV-226362026-08-04T06:32:20ZmiikeS·murphy10/03/85UHC-63081-80—251-216-6136michael.murphy@aol.com4930 CENTRAL AVENUEPlano··TX75039-N/A
PRVPRV-217982026-08-18T06:24:59Z·RandyXMcCoy1974-02-12UNKNOWN•••-••-89832436270035RANDY.MCCOY@AOL.COMnullNULL—N/AUNKNOWN—
PRVPRV-276572026-04-11T01:44:01ZBEVERLY—WHEELER1947-10-05nullNULL9437954809··null··7151 Central AvenueSan DiegoCA92180N/AUNKNOWN
PRVPRV-204432026-04-26T08:07:53ZBrian··—Cox··1980-04-19·UHC-39816-02N/A····—4972 Washington StEDEN PRAIRIEMN55352—UNKNOWN
PRVPRV-288532026-03-20T17:05:25ZAustin—Miller20011116NULL-742-683-8444NULL1627 Church StreetMinneapolisMN55476-5719—UNKNOWN
PRVPRV-291322026-02-26T23:00:25Z·ROGER—RICE4/7/1952-•••-••-5230783-509-9873······N/A—UNKNOWN——N/A
PRVPRV-261292026-09-28T12:18:03Zandrew—bradley1951-04-22UNKNOWN—890.260.5677null9405 WASHINGTON STREETTempeAZ85205N/ANULL
PRVPRV-208172026-05-07T09:10:04ZLuis—Payne12/14/1986N/A··N/A—5466 Mesa DriveGilbert·AZ85234··——
PRVPRV-27235 2026-08-07T20:54:06ZHANNAH—BURTON2003-10-26UHC-36951-77-(557) 846-9076··-7667 Desert Sky BlvdDenverCO··80245nullNULL
PRVPRV-250302026-09-28T09:33:19ZETHHAN····GREEN1966-09-18-—328-747-4285null6482 Lake View RdLas VegasNV89100··UNKNOWNUNKNOWN
PRVPRV-292932026-08-29T09:31:34ZDiaz, Brittany——2/18/1969NULL··—403-605-2054N/A242 Harbor BoulevardTempeAZ85247nullSELECT-EPO
PRVPRV-220752026-07-17T05:49:56ZJOHN—PALMER19470826—UNKNOWN··6617058209····9519 Oak StreetNashvilleTN37229—UNKNOWN
PRVPRV-212602026-05-09T12:41:18ZGregory—·Jensen8/16/2005UHC-11923-03null608-858-6740N/A3096 Pine DrSCOTTSDALEAZ85285—CHOICE-PLUS-PPO··
PRVPRV-294342026-08-13T00:44:27ZamberDruiz1947-11-07N/A—828-841-8858··amber.ruiz@hotmail.com—·nullNULLNULLUNKNOWNNULL
PRVPRV-235322026-10-04T01:38:08ZJASON—HOLEMS19440409N/AUNKNOWN(393) 828-7444JASON.HOLMES66@YAHOO.COM7300 Elm Street #132COLUMBUSOH43290N/Anull··
PRVPRV-243632026-09-10T00:09:01ZElizabeth—·GeorgeMay 24, 1960UHC-90127-83UNKNOWN16874665661—2879 SUNSET BOULEVARDChandlerAZ85210-5968null—
PRV PRV-220052026-08-01T02:59:13ZLARRY··SGIBSON1958-21-28UHC7489855•••-••-1389+1 937 554 9069——N/A————
PRVPRV-230022026-09-10T23:04:24ZRonald—Espinzoa1938-04-26N/A—·5643840310ronald.espinoza44@icloud.com4348 River RdNashvilleTN37289—-
PRVPRV-223702026-01-10T07:18:40ZAna—Ortega·1951-06-23UHC-19282-90-729-970-7135NULL2539 PALM DRScottsdale··AZ85230—MEDICARE-ADV-A
PRVPRV-225382026-08-23T08:23:31ZCharlotte—Owens2/25/1940UHC-49048-55—274.778.2087N/A1858 JEFFERSON AVENUEOrlandoFL32867UNKNOWN—
PRVPRV-241452026-09-16T00:39:24ZPATRICIA—SILVA·1953-01-22UHC-60266-54-2823677128N/A9668 Harbor BlvdSAN ANTONIOTX78218UNKNOWN—
PRVPRV-247912026-05-22T03:57:13ZOmar—Williamson08/11/1954—N/A375-334-2692·OMAR.WILLIAMSON68@GMAIL.COM3803 Willow CtScottsdaleaz85267-UNKNOWN
PRVPRV-269502026-09-24T10:08:25Z·PAULTMORGAN1948-09-10-nullUNKNOWN-4504 LAKE VIEW ROADPhoenixAZ85044-7583-null
PRVPRV-287672026-02-07T21:37:01ZBETTY—HICKS12/13/74UHC-35810-71•••-••-623016556029001BETTY.HICKS@PROTON.MEnull—-—-··—
PRVPRV-275412026-04-19T09:28:50ZOMAR—VALDEZ1961-04-21UHC-08703-94•••-••-7265739-547-5822N/A6802 HIGHLAND AVEScottsdaleAZ85215—CORE-HMO
PRVPRV-232462026-09-04T18:36:02ZJimenez, Isabella——04-02-1993UHC-62078-40NULL3736267813-6914 Mesa DrMinneapolisMN55470—UNKNOWN
PRVPRV-220142026-10-01T21:48:17ZArjun—Martinez1971-11-27—N/A807-510-8929null1250 UNION STScottsdaleAZ85272NULL—
PRVPRV-24739 2026-05-29T14:25:21ZRivera—Logan19760501UHC2781095null7747795587-8658 Elm St Apt 11PhoenixAZ—-N/A
PRVPRV-214912026-10-15T07:09:42Z RaymmondH.Schmidt19540701··UHC-32279-47—6626210257null8835 Valley View DrJacksonville·FL32261——
PRVPRV-259942026-09-11T00:33:18ZRAYMOND—ELLIOTT1956-04-25UHC-34636-62—(840) 375-9083—8816 Forest AveDenverCO-··-NULL
PRVPRV-262742026-09-12T06:26:38ZLOGAN··BELL10/16/1975N/A•••-••-3195(560) 916-8744—7325 Baseline RdJacksonvilleFL32235UNKNOWNnull
PRVPRV-241512026-02-24T18:24:11ZJESSICAKMORGAN1957-05-01UHC-15395-10—305.430.4965NULL4019 MEADOW LANEGlendaleAZN/A—-
PRVPRV-278432026-09-09T07:24:50ZElizabethGReed19500308UHC-55922-83N/A+1 932 566 0609—8057 Palm DriveTEMPEAZ85266—NULL
PRVPRV-222292026-04-10T09:54:17Z Abigail—Kelley1981-70-27—•••-••-2341+1 232 577 8514ABIGAIL.KELLEY5@YAHOO.COM3540 Harbor BlvdSeattle·WA98172—NULL
PRVPRV-290312026-02-18T22:44:57ZRussell—Brooks··1971-11-18—UNKNOWN··(600) 555-4046—2424 Central AvenueLas Vegasnv89132null—
PRVPRV-256992026-08-24T02:04:49Z Laura·B.Hunt12/01/54UHC-31779-73•••-••-7199(505) 874-1492—2200 Canyon RdTucsonAZ85759-null
PRVPRV-270292026-10-09T07:55:05ZbradleyTdaniels1938-07-26UHC-73036-62null·(510) 466-5254null—-—nullNULLUNKNOWN
PRVPRV-207422026-03-13T20:40:10ZRussell—Walker1991-03-18UHC-74532-97—437-286-5571—3949 Main StOrlandoFL32835—NULL
PRVPRV-240042026-01-30T04:40:52ZpamelaA.tucker08-08-1974NULL—218.907.5748pamela.tucker62@yahoo.com7360 Jefferson AveAtlantaGeorgia30385-0400—UNKNOWN
PRVPRV-284272026-10-12T23:08:41ZVirginia··—Bowman1957-09-20····null318-766-9881—5826 Hillcrest RdAtlanta··GA30346—NULL
PRVPRV-281602026-04-10T20:04:32ZMei—WatkinsApr 13, 2004null—+1 391 485 3162N/A7539 Elm StSan Diegoca92183·-NULL
PRVPRV-264552026-04-19T10:06:50ZEthan—Jackson1954-04-10··NULLnull558.301.3069ethan.jackson@hotmail.com801 Main St Apt 28San AntonioTX78269—UNKNOWN
PRVPRV-275792026-05-08T11:51:13ZJACOB—BRYANT1961-03-25null—·265.787.4396jacob.bryant81@gmail.com7699 Canyon RoadLAS VEGASNV89177-MEDICARE-ADV-A
PRVPRV-293432026-09-25T21:06:24ZEvelyn—Young09/15/2006UNKNOWN•••-••-5455(374) 784-7570—6805 Mesa DrGilbertAZ85221—NULL
PRVPRV-285732026-09-23T06:50:42ZCHRISTINE··—VEGA1995-04-02UHC-51289-46··—9273422christine.vega@icloud.com3340 Willow CourtAtlantaGA30342—NULL··
PRVPRV-295322026-02-26T04:38:58ZAlice—Gibson1966-05-04UHC-30304-46•••-••-4122881.764.8012alice.gibson@yahoo.com4012 ELM STEden PrairieMN55318····MEDICARE-ADV-A
PRVPRV-282582026-03-01T22:06:47ZSHIRLEY—VASQUEZ1954-09-09··UNKNOWNUNKNOWN(697) 703-8047—4637 Mesa Dr··PlanoTX75041null··SELECT-EPO
9,596 rows, page 62 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.429Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty