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-255182026-05-22T18:27:12ZRuth—Weber19400524—N/A243.606.6165··RUTH.WEBER@HOTMAIL.COM9877 MARKET STGlendaleAZ·85334——
PRVPRV-246772026-07-26T09:01:04ZAan—Ramos04/02/1999UHC-76630-85·-17625368976··—3586 Bayshore DriveChandlerArizona85255—-
PRVPRV-290962026-01-27T08:26:24ZBishop, TonyR—Mar 26, 1984UHC-85028-39N/A3844579410UNKNOWN2606 VALLEY VIEW DRIVESeattleWA98134—UNKNOWN
PRV PRV-263612026-01-08T23:55:53ZDoris—Guzman1956-10-23·UHC-56787-59•••-••-5512(364) 272-2355—3126 Indian School RoadMinneapolisMN55466—null
PRVPRV-243742026-06-02T12:58:27ZPHILIP····JIMENEZ·03/04/1996UHC-42235-01-(213) 907-4021N/A2148 JEFFERSON AVENUESeattleWA98156—UNKNOWN
PRVPRV-229122026-05-06T22:48:43ZCHARLOTTEG.LARSON02/27/1991NULL—null··UNKNOWN7747 Pine DrCharlotteNC28266——
PRVPRV-289092026-06-07T20:40:45ZJerry—Cole11-03-2005UNKNOWNN/A2524167JERRY.COLE@YAHOO.COM8103 MAIN STREETTampaFL33600-5392UNKNOWNCHOICE-PLUS-PPO
PRVPRV-276652026-04-03T10:00:40ZJASSON—RAMIREZ2005-12-13UHC-29490-85-774-718-6762jason.ramirez@outlook.com6091 Cedar LanePlanoTexas75029—-
PRVPRV-232632026-02-21T06:12:40ZJones, Patrick——09-05-2003NULLNULL3567096013—3171 CEDAR LANEPlanoTX75021——
PRV PRV-248182026-02-27T18:43:38ZTERESA···MEDINA1959-09-08—•••-••-7026821-293-4749TERESA.MEDINA73@YAHOO.COM6674 CENTRAL AVENUE #648··DenverCO80272NULLNULL
PRVPRV-248392026-10-02T10:21:26ZSamantha—GrahamFeb 18, 1950nullnull(384) 280-4243samantha.graham@hotmail.com6339 MOUNTAIN VIEW DRGlendaleAZnullNULL-
PRVPRV-285022026-05-25T06:41:24ZNunez, Vicky——9191-02-24null•••-••-0959791-237-9308—5348 Central AvenueHoustontx77087null—
PRVPRV-285142026-03-30T15:09:05ZJUSTIN··RICE1948-06-02UHC-64295-91—-UNKNOWN2262 Union Street #107JacksonvilleFL32254UNKNOWN—
PRVPRV-226952026-04-01T14:42:20ZJACKW.DELGADO1978-12-01—•••-••-9408NULLNULL928 HARBOR BOULEVARDTucsonAZN/A··-UNKNOWN
PRVPRV-250202026-09-23T06:04:56Z DianeGRogers··2004-10-08UHC-26032-76N/A944.818.0415UNKNOWN7771 MAPLE AVEGilbertAZ··85215-0195·nullN/A
PRVPRV-286392026-01-19T22:35:18Z Yang, Jose——1996-12-24··UHC-79343-17—16139254564null·6764 Ridge RoadTampaFlorida33657-—
PRVPRV-252882026-08-31T08:14:59ZAnthony—Bradley1982-07-03NULL··9296947919anthony.bradley22@proton.me6735 Union StPlanoTexas75084UNKNOWN····
PRVPRV-231952026-03-09T20:40:14ZNicholas—Little3/25/1996NULL—13814392435—2786 Bayshore DrScottsdaleAZ85279UNKNOWN—
PRVPRV-225282026-01-08T05:47:49ZWilliam·AHayes1986-09-28UHC-40174-16N/A··+1 217 270 9195WILLIAM.HAYES2@OUTLOOK.COM5354 MAPLE AVENUETampaFL33690UNKNOWN—
PRVPRV-233902026-09-03T10:08:40ZOrtega, Alice····—1948-01-20null•••-••-4555756.766.5648··4708 CAMELBACK ROADMiamiFlorida33194——
PRVPRV-243602026-04-05T02:07:28ZRandy—Meyer1984-07-26——(707) 261-9905randy.meyer86@yahoo.com—null·UNKNOWNUNKNOWNNULL—
PRVPRV-295922026-01-19T22:23:14ZRyan—George2005-10-22··•••-••-8512-—7634 Hillcrest Rd·COLUMBUSOH43289NULLnull
PRVPRV-252202026-03-29T03:33:01ZAustin··K.Matthews1990-10-24uhc-02623-23—9675973970—7181 River RoadSan DiegoCA92180N/A·NULL
PRVPRV-285232026-03-01T18:58:49ZMarcus—Walsh1997-07-05NULL—9878415044—9217 Church St·TampaFL33645UNKNOWNN/A··
PRVPRV-283482026-09-22T22:54:50ZBrandonEPeters2000-03-27NULL—(491) 399-8978NULL1442 HARBOR BLVDEDEN PRAIRIEMN·55392-NAVIGATE-HMO
PRVPRV-202492026-04-18T13:52:17ZCamila····Tran1973-11-02null—+1 863 731 1081-5949 Park PlaceMesaAZ··85228-··N/A
PRVPRV-261622026-04-13T19:14:09ZKenneth····Gonzales1994-09-09UHC-22366-98UNKNOWN····—2617 Cedar LnChandlerArizona85216N/ANAVIGATE-HMO
PRVPRV-236142026-04-16T11:33:56ZWayne—Sanchez1962-10-15UHC-45559-54•••-••-10812393987526-3186 Harbor BoulevardLos AngelesCA90080—CORE-HMO
PRV PRV-292982026-09-17T22:41:41Z—W.—03/17/1989UHC-21985-17-(881) 469-2770CHARLES.CLARK8@PROTON.ME8197 Mesa DriveTEMPEAZ85263nullnull
PRVPRV-223762026-07-22T12:27:56ZSamuel—Wheeler1959-09-23UHC-12175-52UNKNOWN554-461-6356—9508 Ridge RoadFRESNO··California93758NULLUNKNOWN
PRVPRV-267652026-04-30T03:08:52ZHANNAHPRAMOS18-05-1989NULL———6381 Desert Sky BlvdDallasTX75207-9542——
PRVPRV-236402026-01-18T09:48:09ZKARENV.PIERCE·1989-09-28UHC-84649-94N/A3976905635KAREN.PIERCE72@OUTLOOK.COM6535 Grand Avenue Apt 10San AntonioTX78223—null
PRVPRV-232152026-09-25T22:24:34ZAliceJVasquez2002-04-17N/A—6905211382·null3626 Canyon RoadFresnoCA93742—NULL
PRVPRV-209342026-07-10T05:38:36ZJack—Fisher07/20/98UNKNOWNN/A(695) 766-1770NULL2171 Mountain View DriveCharlotteNC28288N/Anull
PRV PRV-277062026-04-23T02:39:52ZRichard—Espinoza05/16/57null•••-••-2977NULL—2683 Mesa DriveSEATTLEWashington98161-1988—NULL
PRVPRV-246892026-04-02T05:16:36ZJACOB—GEORGE06/02/57—-nulljacob.george@hotmail.com1133 LINCOLN WAYEden PrairieMN55383UNKNOWNSELECT-EPO
PRVPRV-259782026-04-06T05:40:42ZScott—Hughes1958-01-10UHC-53716-26null+1 821 748 5157NULL5069 LINCOLN WAY·OrlandoFL—·-N/A
PRVPRV-281622026-08-27T16:12:14ZCarol····Baker1956-10-28UHC-48163-52null(853) 824-9552NULL3917 Maple AvenueHoustonTX77006N/AN/A
PRVPRV-251932026-05-04T12:38:09ZJACOBMCOOPER06/10/1976N/A•••-••-85479829574303jacob.cooper@hotmail.com··—N/AUNKNOWN—CORE-HMO
PRVPRV-213782026-01-22T06:17:55ZPeteer—Clark··08-06-1947UNKNOWNN/A·6056117774PETER.CLARK46@PROTON.ME275 Cedar LaneDenverco80294——
PRVPRV-249762026-09-29T23:17:27Z Jessica—Campbell1970-05-04N/A··•••-••-8460(414) 267-0478null··343 PALM DRIVETucsonAZ85763——
PRVPRV-21871 2026-09-30T21:38:38ZMARCUS—TURNER1974-12-07UNKNOWNUNKNOWN(664) 617-9546null5655 BAYSHORE DRColumbus··OH43262-NULL
PRVPRV-20103 2026-08-11T04:42:41ZGLORIAUWOODS1998-09-16UHC-12398-94—692-972-8201—UNKNOWN··nullNULLUNKNOWNnullSELECT-EPO
PRVPRV-227062026-06-29T08:56:47ZTerryERivera19930410··—N/A(233) 945-5683··N/A4242 Hillcrest RoadMiamiFL33159—N/A
PRVPRV-204992026-09-05T08:18:03ZLoriECarlson1945-09-28—N/A861.380.4519UNKNOWN2001 ELM STScottsdaleaz85270—NULL
PRVPRV-279982026-09-30T23:25:52ZKimberly—Larson2003-08-24——811-758-7713null2152 Desert Sky Boulevard·GlendaleAZ85361-2661·nullN/A
PRV PRV-213582026-07-03T02:10:36ZRONELD—BROOKS1990-04-28-—463.294.0381ronald.brooks@gmail.com7486 UNION STGlendaleAZ85382——
PRVPRV-230652026-01-30T14:02:01Z·MEI—WEBER2005-05-07N/A•••-••-1616+1 526 349 1293NULL7138 Indian School RdEDEN PRAIRIEMinnesota55310nullUNKNOWN
PRVPRV-215442026-01-03T17:42:37ZBRANODN—HANSEN1979-03-20—N/A795-948-0557N/A4589 Mesa DriveChandlerAZ—··—
PRVPRV-287362026-05-02T12:11:06ZRonald—MejiaJun 28, 1977UHC-84706-98UNKNOWN+1 863 927 2452—2775 Desert Sky BlvdNashville··TN37235null—
9,596 rows, page 176 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:03.410Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty