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-214832026-03-22T06:20:41ZKATHY—PADILLA1969-03-14—NULL19738738383KATHLEEN.PADILLA@PROTON.ME8881 Pine Dr·FresnoCA93762N/A—
PRVPRV-227792026-05-02T05:45:57ZERIC—FREEMAN5/9/1962UHC-17531-99null356-690-4311-8096 Spring StreetMINNEAPOLISMN·55421NULLNULL
PRVPRV-273452026-01-25T01:16:33ZHenry, MariaP—Feb 4, 1981UHC-39990-48—UNKNOWNmaria.henry20@proton.me4187 Central AvePLANOTX75053NULLN/A
PRVPRV-268472026-04-16T07:43:08ZCampbell, Karen——1942-01-82null•••-••-07019706413040karen.campbell@gmail.com4437 River RoadColumbusOH43264—NULL
PRV PRV-25334 2026-03-29T00:07:36Z·JACK—DUNN·08/10/1975N/A—N/A—4632 MESA DRIVELos AngelesCA90029——
PRVPRV-201952026-03-30T23:00:16ZHenry—Ramos19581028NULL—+1 795 798 3532henry.ramos82@gmail.com2976 Camelback RoadHoustonTXnullUNKNOWN··N/A··
PRVPRV-243982026-05-11T00:21:34ZALEX··—WELCH1986-01-05UHC-67317-69N/A766.630.0088NULL2046 Palm DriveFresnoCA93727·-N/A··
PRVPRV-294742026-03-12T02:36:53ZMichael—RamirezFeb 19, 2007UHC-59993-39N/A8239850779—7881 Maple Ave Apt 1Dallastx75205-7704··NULL
PRVPRV-260672026-03-15T21:49:47ZJerry—Martin1939-03-08UHC-90262-15··•••-••-2226+1 351 560 3725UNKNOWN8116 Ridge RdNashvilleTN37256-NAVIGATE-HMO
PRV PRV-224612026-01-22T21:46:14Z·STEPHEN—REYES19600703N/A-16667724835stephen.reyes@proton.me6423 HARBOR BOULEVARDMesaaz85269—N/A
PRVPRV-257182026-07-06T07:24:53ZChristina—Morgan2007-03-17N/A··null(600) 792-3722christina.morgan@icloud.com5927 Cedar LanePhoenix··AZ85021—NULL
PRVPRV-224822026-03-02T11:51:41Z·ahmedHwagner1981-01-01·NULL—+1 314 220 4944ahmed.wagner23@hotmail.com212 Bayshore DriveSeattlewa98121UNKNOWNUNKNOWN
PRVPRV-264802026-07-02T22:19:40Zalbert—diaz1944-07-06--790-699-2008albert.diaz@hotmail.com3720 Church StNashvilleTN··37298N/AN/A
PRVPRV-263382026-05-25T09:43:35ZANNAYGREENE14-02-1986·UHC-19124-93•••-••-84199875217391anna.greene20@yahoo.com9359 Lake View RdDenverCO80222——
PRVPRV-244762026-04-12T23:50:52ZSteven—Banks1955-12-09N/A—6083247STEVEN.BANKS@YAHOO.COM3943 Market StreetMinneapolisMN55440null—
PRVPRV-281572026-01-04T01:32:09ZROGER—ROBERTSON5/6/2002null•••-••-99427649410369··ROGER.ROBERTSON@ICLOUD.COMnull——NULLNULL—
PRVPRV-224282026-06-16T07:08:34ZNICHOLAS··WILLIAMSON1986-07-06null•••-••-8379(268) 413-3515nicholas.williamson@proton.me4949 Canyon RoadMinneapolisMN·55472NULL-
PRVPRV-242522026-02-09T13:05:46ZDorothy—Taylor04/01/89-····277-366-7436-3562 Meadow LaneGilbertAZ85248——
PRVPRV-269222026-01-09T17:00:26Z·AMBERL.ROBERTS1973-04-15UHC-83489-16UNKNOWN—amber.roberts@icloud.com9583 BROADWAY··TEMPEaz85295——
PRVPRV-218432026-03-10T05:43:19ZALEXIS—WHEELER05/26/57null-363.972.4297—6355 HIGHLAND AVENUEOrlandoFL32890-8220—N/A
PRVPRV-20339 2026-01-05T09:44:03ZAngela—MillsOct 9, 1973UHC-64081-98··-(714) 275-6815··3753 HARBOR BLVDTucsonAZ—N/A—
PRVPRV-291472026-10-14T11:18:19ZLUCIA··LAWON1953-07-15····NULL18128731682UNKNOWN4690 HIGHLAND AVELas VegasNevada89178N/AN/A
PRVPRV-287132026-03-06T00:52:21Z ·OMAR—GONZALEZ1968-04-12—null5024267981··—7931 Forest AvePlanoTX75052—NULL
PRVPRV-290902026-05-25T13:21:51Zalexis··——1990-12-15—NULL15808016873—5747 Camelback RoadSan DiegoCA92131NULL··N/A
PRVPRV-247642026-04-13T19:48:52Zeugene··—baileyFeb 11, 1968UHC-60178-10··—(526) 447-2913—5402 Church StTempeAZ—UNKNOWN—
PRVPRV-273802026-02-12T16:35:51ZKAEN—OLIVER19610125UHC-08596-95—(831) 625-3695NULL532 Lincoln WayHOUSTONTX77049-1491—NULL
PRVPRV-206372026-03-07T20:19:00Z Gutierrez, Ahmed——12-05-1938NULL—NULLNULL6178 FOREST AVENUEColumbusOhio43204—UNKNOWN
PRVPRV-258342026-10-15T05:07:12ZSHARON—WEBER2006-09-08UHC-02965-50•••-••-6630(440) 338-7593—6745 APACHE BOULEVARDSAN DIEGOCA92173-6686—UNKNOWN
PRVPRV-232112026-05-04T18:27:29ZSandra—Morgan1939-05-20UHC-28897-69N/A3191559SANDRA.MORGAN17@HOTMAIL.COM1706 PALM DRIVEDenverCO80287-7134—NAVIGATE-HMO
PRVPRV-241952026-08-22T13:37:51Z·Stephanie·ZMejia1984-11-12——+1 564 847 6984null3840 Highland Ave··GlendaleArizona85383-2132——
PRVPRV-256942026-05-01T17:50:56ZMorris, LauraZ—1955-05-12UHC-18122-11N/AN/Alaura.morris@proton.me6637 Washington StreetSan AntonioTX78233UNKNOWN—
PRVPRV-226762026-01-26T03:04:56ZJuan—Mason1991-06-04-·UNKNOWN·UNKNOWNJUAN.MASON85@GMAIL.COM415 Ocean AveEden PrairieMN55352-—
PRVPRV-294962026-02-01T06:06:52ZPAUL—MORRIS··08/17/1987UHC-21357-84•••-••-8682(397) 445-6187paul.morris35@yahoo.com9224 Sunset BlvdLas VegasNV89157null—
PRV PRV-210542026-02-08T19:39:10ZJenniferU.Perez1948-07-18UHC-64712-08—+1 359 618 8177jennifer.perez@outlook.com·9158 Highland Ave·MesaAZ-·UNKNOWN—
PRVPRV-29046 2026-07-06T11:21:08ZJose—Alexander01/13/74UHC-74261-41-+1 509 658 3189jose.alexander1@aol.com3114 Highland AvenueNashvilleTN37277-6891—N/A
PRVPRV-223502026-10-06T04:30:30ZVALENTINA—ADAMS1955-01-24·-·UNKNOWN·5356165261valentina.adams@proton.me··3261 Mesa DriveSeattleWA98130··-SELECT-EPO
PRVPRV-294522026-05-19T21:39:00ZKelly··Valdez··Aug 9, 2000-•••-••-0345-UNKNOWN3063 Indian School RoadFresno·CA—N/A··—
PRVPRV-289542026-10-15T16:59:03Z———08/11/68UHC-98509-15-257-651-9807··2551 Willow CtSeattleWA··98154nullCORE-HMO
PRVPRV-206442026-10-09T05:17:40ZBRADLEY—·ANDERSON1976-07-24UNKNOWN•••-••-83044063021271BRADLEY.ANDERSON@OUTLOOK.COM5819 Forest Avenue··Las VegasNV-NULLCORE-HMO
PRVPRV-292232026-08-06T20:31:08ZKennethY.Jacobs07/26/1972UHC-31074-32•••-••-0274—kenneth.jacobs44@outlook.com9236 RIVER RDSan AntonioTX78234··—CHOICE-PLUS-PPO
PRVPRV-267622026-06-20T00:23:04ZStephanie—Payne1974-07-04UHC-82530-78—241-515-4803—640 INDIAN SCHOOL ROADFresnoCANULL—-
PRVPRV-228842026-03-27T23:25:05ZMateo··SSimpsonOct 27, 1938··UHC-06246-32—7148458844UNKNOWN2852 CAMELBACK RDColumbusOH43292——
PRVPRV-201902026-03-28T19:05:51ZMATT··VEGA··1998-08-17UHC-91944-19—4834304551—4884 Desert Sky BlvdTUCSONAZ85722null-
PRVPRV-245902026-06-02T04:58:28ZBRIANSLARSON1/1/1984UNKNOWNUNKNOWN787-549-1229BRIAN.LARSON84@HOTMAIL.COMnull··-······NULL—
PRVPRV-207642026-04-02T08:48:49Z gregory—richardson1960-04-11—NULL2909667947-1687 Palm DriveDALLASTX75271NULLnull
PRVPRV-210982026-09-06T00:43:59ZKevni—Rios1971-10-18UHC-45153-34—nullkevin.rios3@icloud.com3291 BroadwayTEMPEAZ85204UNKNOWNNULL
PRVPRV-254292026-05-12T21:30:29ZJOAN—ANDERSON·1968-07-17·UNKNOWNN/Anull·null——-UNKNOWN—choice-plus-ppo
PRVPRV-221392026-08-31T19:41:51ZLAUREN—HOWARD2002-10-01-—(918) 679-6560null5084 River RdGILBERTAZ85251NULL-
PRVPRV-258482026-05-31T02:28:16ZRoy—Marshall1942-10-15UHC-12603-94—746-886-2063null266 Cedar Ln·PhoenixAZ85008—-
PRVPRV-236372026-04-16T13:41:27ZHiroshiSMason1963-11-06—NULL854-235-6009N/A·410 Cedar LnEden PrairieMNnull-—
9,596 rows, page 120 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:53.121Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty