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-294712026-01-22T03:36:26ZJacobK.Rojas12/24/88—null(753) 900-3351NULL4083 Elm StPLANOTX75028-N/A
PRVPRV-262002026-04-30T18:01:59ZAMBERB.FIELDS19770114UHC-04870-75—787-661-3893—2847 Palm Drive Apt 40·San AntonioTexas78277UNKNOWN—
PRVPRV-286112026-04-17T04:33:56ZHAROLD—GREEN--—nullUNKNOWN·5450 Spring Street·SeattleWA-NULL-
PRVPRV-27129 2026-03-03T18:02:08ZLUIS—LARSON1979-08-22NULL•••-••-55052644571080··luis.larson11@yahoo.com362 Ocean AvenuePlanoTX75067UNKNOWN··MEDICARE-ADV-A
PRVPRV-215092026-04-22T22:57:09ZFrances—Jenkins1987-09-19·UHC-08557-87—+1 496 238 0041—5036 BROADWAYMiamiFL33149-—
PRVPRV-262212026-09-22T09:07:20Z·jeremy—garcia1967-05-14UHC8372654N/A(666) 316-3964UNKNOWN5842 Forest AvenueSacramentoCalifornia95862N/AN/A
PRVPRV-229342026-08-29T01:04:40Zaguilar—eric19740726—null606-246-1955UNKNOWN3345 Lincoln WayAustinTX78754nullNULL
PRVPRV-253812026-10-12T04:08:19ZHAROLDKMEJIA1969-10-17UHC-63645-91—5163320294—1262 WILLOW COURTNASHVILLE··TN37270-NULL
PRVPRV-236352026-02-16T11:59:00ZDenise—Price1939-12-27UHC2772107nullN/AN/A8071 Desert Sky BoulevardSeattleWashington98119—SELECT-EPO
PRVPRV-247652026-09-20T04:32:32ZAguilar, JordanA.—19451104-··—(831) 928-1593UNKNOWN—nullUNKNOWN-——
PRVPRV-238992026-09-27T12:56:25ZDebra—AndrewsJun 12, 1954UHC-65044-44•••-••-6109907-449-0704NULL6835 JEFFERSON AVENUETempeAZ85246-CORE-HMO
PRVPRV-236432026-02-09T21:11:31ZJean—Chen·19890910UNKNOWN—(780) 396-1369-9310 CAMELBACK RDPlanoTX75025N/ACORE-HMO
PRVPRV-209182026-08-17T20:28:06ZNancyNBrooks20020320N/A—(855) 309-9739nancy.brooks8@gmail.com4433 Ocean AveSan Diegoca92148-8112-null
PRVPRV-246692026-05-03T00:10:34ZRussell—Harrison1950-08-14UHC-05513-68—987-550-0866-460 PALM DRIVEDallasTX75239—N/A
PRVPRV-229002026-06-10T03:16:26Zahmed—santiago1975-11-24UHC-80195-11—-null·4213 Willow CourtTampaFL33675—MEDICARE-ADV-B
PRVPRV-286812026-04-12T19:03:13ZCox, Kenneth——1953-06-17null—321-638-7904—3484 MAPLE AVEGlendaleAZ85331N/ANULL
PRVPRV-267782026-05-16T12:00:38ZSantiago··—Rojas1994-12-27UHC-47732-45N/A384-733-3885—3935 CANYON ROAD Apt 31GILBERTAZ85264-NULL
PRVPRV-229982026-06-01T08:15:25ZmasonHchen1982-09-21UHC-68233-59•••-••-9371+1 710 400 3271MASON.CHEN@GMAIL.COM9569 CANYON RD Apt 30San AntonioTX78240·-N/A
PRV PRV-282752026-08-02T09:31:07ZBobby—Morgan12/26/2005UHC-41056-16··UNKNOWN(899) 329-3453—5906 Maple Avenue··FresnoCA93738··—····
PRVPRV-27945 2026-07-29T06:30:08ZBryan—Castro12/01/47UNKNOWN•••-••-7227(685) 599-1484UNKNOWN3934 Central AveDallasTexas75200—UNKNOWN
PRVPRV-263372026-08-08T07:11:57ZMeganABerry1943-10-26UHC-79894-32—NULLmegan.berry11@yahoo.com··6422 Highland Avenue·SacramentoCalifornia95888null-
PRVPRV-227622026-06-12T07:42:19ZAishaHPrice1939-08-27UHC-23862-75null(406) 228-3541null2027 Ocean AvenueMiamiFlorida33124-N/A··
PRV PRV-275022026-09-10T05:10:33ZSuullivan, Willie—··02/28/05UHC0308690—4336975706willie.sullivan@aol.com·6475 ELM STREETTampaFL33636null—
PRVPRV-210782026-04-11T03:00:00Z·OMARBKNIGHT03/18/54UHC7699654null··7195293740—·6084 Grand AvePhoenixAZ85090-5078UNKNOWNNULL
PRVPRV-22389 2026-08-10T06:20:06ZShirleyHWelch11/10/44null—15096102614—5380 WASHINGTON STREETMiamiFL33147——
PRVPRV-222572026-09-05T16:49:50ZBettyK.Butler1956-11-26UHC-72899-24—578.632.9064UNKNOWN1390 JEFFERSON AVEDALLASTX75228····—
PRVPRV-269442026-09-13T18:01:23ZPhillips, Ethan······—1996-03-07UHC-99113-47—+1 553 998 1186··-8497 OAK STGilbert·AZ85282—NULL
PRVPRV-269642026-05-26T16:08:52Z·SHIRLEY—HARRISON4/24/1940—N/A(747) 521-2037—3720 Camelback RdATLANTAGA—N/ASELECT-EPO
PRVPRV-235472026-09-18T06:29:03ZVINCENT—JENSEN1986-09-16UNKNOWNUNKNOWN+1 606 548 7112-——·N/AN/A·null—
PRVPRV-273382026-01-01T13:37:33Z Brenda—Garrett1979-12-19UHC-41748-23-··null-5080 Mountain View DrCHANDLERAZ85279-9290——
PRVPRV-242862026-02-27T17:51:13ZADAM—WILLIAMSONNov 25, 1963UHC-76610-04-+1 769 293 2674-4862 WASHINGTON STScottsdaleAZ85244—NULL
PRVPRV-263352026-01-24T00:11:46ZFrank—Thompson1982-09-06--15313184719frank.thompson21@yahoo.com5660 Valley View DrFRESNOCA93730——
PRVPRV-219402026-08-20T14:46:29ZSean—Bradley28-10-1941——+1 421 312 9259—8159 Ridge Rd #853San DiegoCA92168——
PRVPRV-218072026-01-07T19:58:44ZGLORIA—BENNETT1958-01-19N/AUNKNOWN··3613735871-8792 Grand AvenueMinneapolisMN55419NULLUNKNOWN
PRVPRV-273542026-05-09T12:13:50Zfrances—weaver12/23/1999N/AN/A(816) 918-4825null9050 Camelback RoadSeattleWA98143-UNKNOWN
PRVPRV-260102026-02-11T15:06:00ZSAMUEL—BAILEY19790620UHC7945580•••-••-73143525582651samuel.bailey5@yahoo.com·1831 SPRING STREETMesaAZ··85284UNKNOWNN/A
PRVPRV-271352026-08-17T10:25:45ZStephanieBPorter01/20/1974UHC-82341-82NULL18525836360N/A3850 Jefferson AvenueLos AngelesCalifornia90086—MEDICARE-ADV-B
PRVPRV-254712026-01-27T19:38:18ZScott—Alvarado09/21/73—•••-••-6519964-929-7388scott.alvarado9@aol.com5896 HILLCREST ROADGlendaleAZ85399UNKNOWN···-
PRVPRV-264862026-03-16T11:41:15ZGEORGEI·SCHULTZ2002-11-11··——2096549594UNKNOWNUNKNOWN-··NULLNULLCHOICE-PLUS-PPO
PRVPRV-204842026-09-27T22:27:14ZTerry—Hansen·1956-10-09UHC-59896-66UNKNOWN(479) 889-8424····—nullUNKNOWNN/A—-
PRVPRV-239172026-07-06T09:10:29ZEDWARD—COOK1976-03-25UHC-04537-80•••-••-6867(504) 735-0885—39 Mesa DrEden PrairieMN55302-1024null·CORE-HMO
PRVPRV-259882026-03-11T00:14:12Z·ALEXIS—ARMSTRONG08/18/1996——16015868888—1658 Canyon RoadAUSTINTX78733—N/A
PRVPRV-204962026-05-09T19:54:19ZsandraK.boyd1973-03-18UHC-29823-55·UNKNOWN(729) 789-8421sandra.boyd96@aol.com1044 Spring StreetTUCSONaz85737——
PRV PRV-253602026-05-15T18:03:50Z Harrison, Richard——1987-09-11N/A•••-••-0279(795) 711-8011—1852 MAIN STREETSan AntonioTX78288—NAVIGATE-HMO
PRVPRV-247712026-05-02T23:30:39ZRACHEL—·COLMEAN1981-12-28——UNKNOWN-93 Ocean AveJACKSONVILLEFlorida·32262N/AN/A
PRVPRV-214032026-09-21T14:43:51ZDONNA—CRAWFORD1976-04-07nullnull(595) 231-7804donna.crawford@gmail.com··N/AUNKNOWNNULLUNKNOWNNULLNULL
PRVPRV-212852026-03-29T21:59:23ZWillie—Boyd2004-10-16UHC-34280-19-7626248254willie.boyd14@proton.me2977 RIVER RDGilbertAZ85261—·-
PRVPRV-264472026-09-22T05:33:01ZNATALIE—TAYLOR1990-05-01UHC-81929-18·UNKNOWN4462800579natalie.taylor@proton.me3265 Main StreetATLANTAGA30372N/AUNKNOWN
PRVPRV-267322026-08-22T11:33:13ZBRENDAW.SIMMONS19691010UHC-69449-60UNKNOWN(960) 458-1012-2504 Hillcrest RoadSan DiegoCA92181—null
PRVPRV-285852026-02-20T06:46:27Z·PIHLIP T—WHEELER9145-06-14UHC3969240•••-••-41944937138697philip.wheeler@outlook.com··4805 Union StreetEden PrairieMN·55318-MEDICARE-ADV-A
9,596 rows, page 186 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.736Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty