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-284282026-04-17T18:07:35ZMichael—Rios1961-08-23-N/A+1 253 729 1705NULL9120 LAKE VIEW RDLOS ANGELES·CA90097—NULL
PRVPRV-232622026-03-15T08:05:16Z Kathryn—Parker1945-08-28null-281-210-1713NULL6159 BroadwayORLANDOFL32888NULL-
PRVPRV-253862026-02-08T11:20:20ZBoyd, Jessica·M.—1977-11-15UHC-79586-37UNKNOWN528-971-9406N/A602 Cedar LaneDenverco80297UNKNOWN·-
PRVPRV-289392026-07-19T05:33:36ZKathryn—Ray1974-06-13-—938.945.8983kathryn.ray@hotmail.com531 Union StreetEDEN PRAIRIEMN·55370—N/A
PRVPRV-285362026-02-27T21:43:20ZLawrence····Andrews1972-09-22-•••-••-2315425-377-7826null—null······UNKNOWNNULL—
PRVPRV-286442026-10-16T13:57:40ZHarold—Barnes1995-04-05UHC-11839-77•••-••-6998(872) 520-8417N/A683 Hillcrest RoadJacksonvilleFL32299—NAVIGATE-HMO
PRVPRV-214092026-02-22T00:47:43ZJessica—Murray2001-05-24-—501-658-0692——UNKNOWN····N/Anull—
PRVPRV-229102026-09-18T21:01:13Z Gutierrez, Gary——2008-08-03UNKNOWN•••-••-8602+1 741 578 7953GARY.GUTIERREZ69@GMAIL.COM5455 Bayshore DrHoustonTX77077—NULL
PRVPRV-271552026-02-12T10:35:39ZJacob—Jackson1949-03-05NULL•••-••-8161·13796739736jacob.jackson@aol.com·1810 PALM DRCharlotteNC28221nullNAVIGATE-HMO
PRVPRV-255092026-09-07T23:04:09ZKellyGBishop1958-01-12UHC-23217-24—·9615919930—3102 Highland AvenueChandlerAZnullUNKNOWNUNKNOWN
PRVPRV-22470 2026-10-04T15:14:50ZCATHERINEM.GOMEZ··1998-10-01——4822010233—2035 Lake View RoadATLANTAGA30395-—
PRVPRV-272292026-08-05T20:23:26Zbarbara·S.bell·1978-10-25UHC-53380-72•••-••-1684+1 557 908 0129N/A9869 Lincoln WayMiamiFL33119NULL—
PRVPRV-219182026-02-26T04:28:33Zkevvin···Arice1953-10-12—•••-••-7173740-812-7885kevin.rice@hotmail.com·7401 Pine Drive·FresnoCA93756NULL—
PRVPRV-287212026-08-20T21:51:19ZHarrison, AngelaO—1950-06-12——266-898-1906null2120 SUNSET BOULEVARDJacksonvilleFL··32239UNKNOWNN/A
PRVPRV-257322026-02-16T13:06:34ZWLTER—LUCAS··6/22/1938null—958-490-5029null6999 Indian School RdDenverCO80270—OPTIONS-PPO
PRVPRV-293922026-02-16T17:04:56ZJULIE—MILLER01/20/2007UHC-50358-46—(627) 840-6030—7356 Camelback RoadTucsonAZ·85710UNKNOWN—
PRVPRV-265312026-05-13T23:44:59Z·Santiago—James9/7/1945UHC-43373-39N/A729.250.9542UNKNOWN6714 Church StreetDenverCO—UNKNOWNNULL
PRVPRV-213052026-01-05T09:39:14ZdianaP.patterson2002-09-09—•••-••-40284526461996diana.patterson14@proton.me·8120 MAPLE AVEScottsdaleAZ85215-NULL
PRVPRV-263152026-02-03T08:28:35ZNicholasF.Dunn1959-08-22N/AN/A977-444-3061NULL5990 PINE DRIVEMesaAZ85242—N/A
PRVPRV-270892026-06-17T15:09:42ZWilliamRDiaz1966-03-12UHC-98786-04N/A(665) 219-2817william.diaz@proton.me5805 Meadow Ln··ORLANDOFL32846nullMEDICARE-ADV-A··
PRVPRV-288042026-05-28T03:27:28ZDon··—Freeman··02/17/47-N/A+1 600 434 2609NULL1080 PALM DRTucsonAZ·85769N/A—
PRVPRV-230282026-02-14T02:50:31Z Amber··Salazar1962-12-17N/Anull3498815048null1069 Sunset BlvdLas VegasNV89103nullN/A··
PRVPRV-217932026-09-30T03:40:05ZJacquelineUPayne12-08-1952——766-482-1145JACQUELINE.PAYNE39@OUTLOOK.COM·8478 Sunset BlvdPLANOTXNULLUNKNOWNN/A
PRVPRV-278972026-05-15T08:40:57ZCharlotteYKennedy11/8/1945NULL··+1 246 454 3506—6137 Maple AveChandlerArizona85214—null
PRVPRV-266542026-02-20T10:19:53ZDiegoT··Richards02/06/1963—N/A2263570196N/A··254 GRAND AVEAUSTINTX78704—UNKNOWN··
PRVPRV-284002026-06-06T09:34:29ZMariaYJackson1958-12-04UHC-58867-15UNKNOWN(233) 472-0836maria.jackson@outlook.com6174 APACHE BLVDTUCSONArizona85770—-
PRVPRV-281422026-05-31T07:59:22ZShirley—Vasquez08/15/1997UHC-77814-68—701-286-2573shirley.vasquez83@icloud.com9094 APACHE BLVDAtlantaGA30320——
PRVPRV-257682026-08-08T15:35:12ZchristineWstevens1983-06-13UHC-87437-98N/A··—NULL·9540 BROADWAYSan AntonioTX78215nullN/A
PRVPRV-285962026-04-02T17:54:05ZWilson, Bobby——19940112—-2094822436NULLUNKNOWN-·-·NULLUNKNOWNUNKNOWN
PRVPRV-227102026-02-12T07:32:43Zjustin—morgan1956-06-21·UNKNOWN—676-753-9937justin.morgan@proton.me4401 Desert Sky BlvdTEMPEAZ85233N/Anull
PRVPRV-228102026-03-20T09:00:42ZAguilar, ShirleyP—10/16/00UHC-87167-45—UNKNOWNN/AN/ANULL——·UNKNOWNNULL
PRVPRV-223712026-04-25T19:00:24ZALANNDANIELS02/25/07··—-279-916-2449—8140 Willow CtGILBERTaz85259NULL-
PRVPRV-269962026-10-03T12:16:05ZWEIKPOWELL1941-11-23N/A··N/A715-428-7219UNKNOWN4263 Cedar LaneGlendaleAZ85343—null
PRVPRV-254222026-08-07T01:48:51Zlaura—chavez02/02/2006-··—null-1179 Lake View Road·DENVER·co80251nullOPTIONS-PPO
PRVPRV-205982026-08-05T04:30:36ZDavidFKelley1970-06-19-null412-703-7771null979 MOUNTAIN VIEW DR Apt 35DallasTXUNKNOWN—N/A
PRVPRV-267922026-09-27T09:02:32ZMELISSA··—OWENS1972-03-18UHC-20322-63•••-••-42887324086024-7251 SUNSET BLVDSan AntonioTX78222—NULL
PRVPRV-207502026-04-18T19:45:07ZMEGAN—WELLS1981-11-20UHC-49630-57N/A449-583-7635UNKNOWN3063 DESERT SKY BOULEVARDTAMPAFL33660—N/A
PRVPRV-249442026-01-30T04:06:33ZKELLY—REED1965-04-13··UHC-18092-14—6537521335—1750 Grand AvenueMinneapolisMN55475—NULL
PRVPRV-203412026-01-13T02:28:15ZElizebethGWest19640701—•••-••-52923665091188elizabeth.west@gmail.com·9763 Apache Boulevard·San AntonioTX78294—·UNKNOWN
PRVPRV-203672026-06-18T01:09:19ZEMMA—VASQUEZ1986-08-05UHC-95934-32NULL19193075499null1098 Market StDallasTX75249N/A··UNKNOWN
PRVPRV-258282026-01-29T08:41:25ZStephanie—Ross·1990-12-11UHC-04168-70—-—1376 Ridge RdJacksonville·FL32239—UNKNOWN
PRVPRV-213622026-05-11T06:28:28ZSeanOTurner1965-02-11UHC-59643-97•••-••-9021670.486.5899UNKNOWN2219 Bayshore Drive··TampaFlorida33618NULLN/A
PRVPRV-292402026-07-25T12:01:43Zmary··—hudzon1995-01-14··UHC-28041-40—·775-479-7193MARY.HUDSON51@PROTON.ME9385 MESA DRSan DiegoCA92171·-NULL
PRVPRV-287542026-10-04T01:56:40ZLaura—Washington1987-02-21UHC9126439UNKNOWNUNKNOWN··—6061 Camelback Road·MiamiFL33108—UNKNOWN
PRVPRV-206502026-09-26T21:18:57ZALEXISWSHAW2006-03-21·UHC-99178-38•••-••-9173(286) 403-1843NULL7789 UNION STLos AngelesCA90090nullN/A
PRVPRV-270882026-06-15T10:56:40ZCharles—Perry1954-09-03uhc-24528-85·NULL·(881) 961-0904—NULL—UNKNOWN-NULLN/A
PRVPRV-216202026-06-11T21:09:08ZHiroshi—Espinoza1970-07-02UHC-80972-01·N/A(569) 258-3125hiroshi.espinoza@yahoo.comnullNULL—null—NAVIGATE-HMO
PRVPRV-215402026-06-07T06:50:25ZlawrenceMhamilton01/17/1949N/Anull366-226-8827null8701 SUNSET BLVDSACRAMENTOCA95881——
PRVPRV-220452026-06-11T02:59:41Zkevin··—jacobs8/14/1973UHC-12897-50—656-565-3025—9820 HARBOR BLVD #728Jacksonvillefl32202NULL··
PRVPRV-294212026-05-27T16:08:13ZHarold—Delgado1989-07-19··—(711) 313-2644——N/A—UNKNOWN····null
9,596 rows, page 181 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.444Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty