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
PRV PRV-255172026-01-27T18:49:28ZHenry·CSalazar12/11/1988UNKNOWN··null—henry.salazar86@proton.meNULLNULLnullN/A—MEDICARE-ADV-B
PRVPRV-291882026-02-04T10:16:17ZWeiSCooperOct 25, 1953—UNKNOWN+1 705 608 8883—5751 River RoadChandlerAZ85261-N/A
PRVPRV-248572026-01-08T06:19:13ZJanice··LCarlson1973-10-08N/A—250-669-7187JANICE.CARLSON52@GMAIL.COM6435 Highland AvenueFRESNOCA··93784—null
PRVPRV-206802026-04-29T05:53:35ZDanielR.Brooks1984-10-20NULL—614-659-2557NULL5113 Cedar LnPhoenixAZ85009-NULL
PRV PRV-228272026-07-25T12:12:23ZCharles··Taylor19460122nullNULL(949) 439-1473charles.taylor86@gmail.com3261 Jefferson AveAustinTX78763·UNKNOWNMEDICARE-ADV-A
PRVPRV-223162026-10-09T08:55:25ZSantos, Christopher····—05/06/1995UHC-66123-93NULLnull·null609 Spring StreetEDEN PRAIRIEmn55332-SELECT-EPO
PRVPRV-233082026-08-09T13:39:18ZJoeOAdams05/04/08UHC-31330-62N/A(566) 636-1327—2370 Canyon RoadAtlantaGA30326N/A—
PRVPRV-291172026-05-16T05:59:29ZARTHUR—TORRES1997-05-08UHC-42335-48N/A6096874487—9054 Highland AvePHOENIXAZ85018—UNKNOWN
PRVPRV-295582026-10-09T00:41:20Z JOSEPH—FIELDS1938-04-04UHC-07821-43—4577211227joseph.fields2@proton.me3975 SUNSET BLVDMesa·AZ85235—·-
PRVPRV-204192026-01-30T06:27:06ZJustin—Rodriguez·1953-06-15UHC-92157-55null·18384529521NULL8205 BASELINE RDChandlerAZ85267-4683——
PRVPRV-226942026-09-24T03:08:40ZDICK··MENDEZDec 3, 1960····NULL17587854571··richard.mendez@outlook.com2643 DESERT SKY BOULEVARD Apt 33GilbertAZ85235··N/ANULL
PRVPRV-202432026-05-25T00:06:02Z·MelissaJAlexander1944-12-03NULLNULL·333.250.5168melissa.alexander@aol.com8745 Ocean AveCharlotte·NC28210-0987··UNKNOWN
PRVPRV-22635 2026-09-17T21:36:22ZJEANWCARR1969-06-27-null·(902) 407-5205—901 Central AveLos AngelesCA90095UNKNOWNCORE-HMO
PRVPRV-227232026-04-10T21:45:24ZKlelyCWest1954-10-06UNKNOWN-919-200-4346·UNKNOWN7793 MAIN STSAN DIEGOCANULL—UNKNOWN··
PRVPRV-234112026-04-26T12:17:55ZDEBRA—LEWIS19491224-UNKNOWN4348089398DEBRA.LEWIS74@HOTMAIL.COM9547 Meadow Lane #330Austin··TX··N/AUNKNOWNnull
PRVPRV-231692026-05-04T16:00:02ZSOFIAPLI2003-01-08·NULL•••-••-5613444-533-3176nullNULLUNKNOWN———OPTIONS-PPO
PRVPRV-23854 2026-03-15T02:29:31ZsusanLking07-11-1980···uhc-87239-11—521-626-2677susan.king@aol.com7530 Apache BlvdScottsdaleAZ85212··—N/A
PRVPRV-244032026-08-24T21:29:19ZARJUNXROJAS19960822UNKNOWN··—arjun.rojas76@icloud.com1443 LAKE VIEW RDSacramentoCA95853——
PRVPRV-294022026-06-20T04:09:49ZNicholas—Kennedy1974-04-10nullNULL493-683-5902NULL6881 Palm DriveJACKSONVILLEFL32276—MEDICARE-ADV-B
PRVPRV-272772026-06-08T20:28:23ZSusan—Hunter1999-07-24UHC-70915-70-··15355554838-7346 Elm StCharlotteNC28215nullOPTIONS-PPO
PRVPRV-289992026-06-22T15:56:23Z Brandon·JEdwards1948-04-23·NULL·null(554) 917-5741brandon.edwards54@gmail.com3531 CHURCH STSacramentoCA95850—null
PRVPRV-268002026-10-17T10:40:00Zluis····gonzales1939-08-26UHC0087825null2941179null4733 Canyon RoadAtlantaGA30339-2020N/Anull
PRVPRV-264032026-09-01T12:13:18ZMARIANA—·AUSTIN1967-10-15-—7875392929-··null—-·UNKNOWN—
PRVPRV-279122026-05-03T12:26:56ZAlan—Vega1974-07-23UHC-86604-43—+1 987 227 6908alan.vega@gmail.com7471 Ocean AveMesa··AZnull—null
PRVPRV-234412026-08-04T22:18:08ZSAMANTHAT.WELCH1970-08-20UHC-81164-04··430-886-5183UNKNOWN3081 Jefferson AvenueSan AntonioTX——N/A
PRVPRV-254702026-06-10T15:43:15Z SCOTTGALVARADO1973-09-21UNKNOWN··—964-929-7388UNKNOWN5896 Hillcrest RoadGlendaleAZ85399—NULL
PRV PRV-255362026-06-19T08:27:26ZChristian—James1977-10-08NULLnull442-916-7211··9378 OAK STREETTempeAZ85242null·-
PRVPRV-200472026-04-14T12:35:19ZNELSOND.LORI19900317··NULL-765-372-6039UNKNOWN164 Bayshore DriveSeattleWA98146N/AMEDICARE-ADV-A
PRVPRV-245122026-09-12T11:57:04ZPeter··Vasquez19721216null•••-••-5085—peter.vasquez4@hotmail.com9389 MAIN STREETNashvilleTN37200—null
PRVPRV-24546 2026-05-05T23:41:03ZHAROLDVVASQUEZ··2001-04-18UHC-05206-24N/A(521) 529-5672—4231 LAKE VIEW ROADMesaAZ85252N/AMEDICARE-ADV-A
PRV PRV-283472026-02-26T03:31:18ZCheryl—Armstrong1967-04-06UHC-23457-56—-NULL1762 Lake View RoadSan DiegoCA——-
PRVPRV-277602026-06-20T07:48:47ZMariana—Hamilton1960-35-16NULL•••-••-4189+1 858 335 8665MARIANA.HAMILTON@GMAIL.COM—UNKNOWN-——SELECT-EPO
PRVPRV-280582026-03-11T07:35:16ZShirley—Lopez1944-02-01UHC-32327-74-·+1 615 209 6793—3855 Palm DrivePlanoTX75085-4092-—
PRVPRV-283052026-09-10T15:05:19ZBryan··—Wheeler14-07-1958nullNULL·17467854283-6051 BroadwayATLANTAGA30338-8937··nullN/A
PRVPRV-254922026-03-19T19:09:30ZARTHUR—CHAVEZ1973-02-02UHC-10907-02•••-••-9222368-601-4273—3230 PINE DRMiamiFlorida33179NULL-
PRVPRV-253282026-03-19T07:58:01ZJohn—Herrison1981-08-09N/A·NULL15978210577··5170 CHURCH STTempeAZ85260N/AUNKNOWN
PRVPRV-279562026-08-21T01:42:34ZGeorgeIWest1993-12-28UNKNOWNnull·+1 448 756 2851null1635 Mountain View DrMesaAZ85219NULLNAVIGATE-HMO
PRVPRV-280382026-07-18T05:33:15ZMadison—Reyes1946-04-18-•••-••-8736383-929-4814MADISON.REYES7@AOL.COM6130 Elm StOrlando··FL32897UNKNOWNMEDICARE-ADV-A
PRVPRV-208672026-04-19T19:11:27ZFields, LarryZ—1965-01-26UHC-33543-82N/Anull—9784 Forest AveHOUSTONTX77060—NULL
PRVPRV-260712026-09-03T06:34:51Z Wei··AlvarzOct 15, 1986N/A-(864) 330-0786null--·NULLN/A··N/AN/A
PRVPRV-259252026-10-03T07:36:42ZStephen····Richardson05/28/2001UHC-35712-05—435.206.5878—9587 Meadow LaneCharlotteNC28232··—
PRVPRV-209112026-03-24T00:35:32ZMARIANA·CCOLLINS1966-09-24nullnull735-949-8191N/A9011 Pine Dr··JACKSONVILLE·FL32277——
PRVPRV-252632026-04-12T05:33:04Zwayne—castro06-09-1950N/AUNKNOWN—N/A2524 BASELINE ROAD Apt 22SacramentoCA95862·--
PRVPRV-215612026-04-27T05:08:04Z·JUDITH—COOPER1957-01-28·-null—JUDITH.COOPER@PROTON.ME6211 Palm DriveEden PrairieMinnesota55331-—
PRVPRV-224732026-07-21T00:57:34Zaisha····scott1950-09-05—•••-••-6786978-908-1586AISHA.SCOTT@OUTLOOK.COM·N/AUNKNOWN··null——
PRVPRV-244622026-08-14T16:29:06ZDiego W—Lawson··1966-10-07UHC-46964-36N/A··4479788753-8363 Cedar LaneMESAAZ85237null—
PRVPRV-278612026-08-03T06:28:00ZCynthia—Stephens04/06/57UHC-44022-07•••-••-66652173893906N/A··N/AUNKNOWNnull··—nullCHOICE-PLUS-PPO
PRVPRV-21082 2026-10-09T02:32:55ZCatherine······Richardson2005-08-26UHC-15592-78•••-••-48158617857017—2274 CHURCH STREETSCOTTSDALEaz85238-3302null-
PRVPRV-278792026-03-13T00:24:33ZMegan—Sandoval2004-12-05UHC-35590-27•••-••-4825897-807-6545megan.sandoval84@yahoo.com8968 HIGHLAND AVEAtlantaGA30327N/Anull
PRVPRV-280042026-05-07T21:59:47Z randy—burton03/02/38N/A•••-••-7804301-563-0417N/A-NULLNULL··NULL—UNKNOWN
9,596 rows, page 96 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:46.463Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty