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-224292026-02-05T13:53:07ZJUILA—ESTRADA1999-12-16UNKNOWN··—841-942-8442·JULIA.ESTRADA@YAHOO.COM9472 Bayshore DriveSAN DIEGOCA92173-6106null—
PRVPRV-294512026-08-31T11:46:18Z Washington, Daniel——1997-03-02N/A—(702) 662-3300··DANIEL.WASHINGTON@AOL.COM9153 Jefferson AvenueDenverCO80226UNKNOWN··NULL
PRVPRV-214752026-06-11T09:29:27ZWill—Dominguez05/26/1971UHC-78896-13•••-••-7031(458) 356-7555null·7833 Baseline RdColumbusOH·43213null—
PRVPRV-286062026-08-21T02:11:15ZBruce····Fox09/06/1979UNKNOWN—7739939925—N/AUNKNOWNNULLnullUNKNOWNNULL
PRVPRV-290532026-01-30T14:09:49ZWILLE—ROGERS··19400717UHC-19353-05•••-••-37793196414899null3843 MESA DRIVELAS VEGASNV89176—UNKNOWN
PRVPRV-262162026-06-24T06:58:29ZDAVID—RAY2006-09-26—•••-••-2521(537) 977-7346—8279 Mountain View DrivePHOENIXAZ85014—null
PRVPRV-279382026-09-22T01:37:20ZHenry—·Alvarado1960-08-24UHC-71930-79N/A-null569 HIGHLAND AVEAustinTexas·78726N/A—
PRVPRV-290552026-03-17T18:05:56ZDIANE····OLSON1981-07-11NULLNULL638-569-0935UNKNOWN4637 Lake View RoadJacksonvilleFL32257-9532-CHOICE-PLUS-PPO
PRVPRV-244292026-03-18T03:57:49ZDYLAN—HAWKINS1970-03-25UHC-26068-29—472-517-5080dylan.hawkins@hotmail.com6252 Valley View DriveMinneapolisMN55448-7923nullNULL
PRVPRV-278532026-07-06T13:55:13ZNANCY····RICHARDS1948-06-12-NULL8129566702UNKNOWN8910 MOUNTAIN VIEW DRDALLASTX75234—-
PRVPRV-252142026-06-18T09:42:24ZJASON—GARRETT9178-04-08—null6574036234UNKNOWN7286 BASELINE RDPhoenixAZ85081NULLUNKNOWN··
PRVPRV-270382026-05-21T17:03:39ZDiana—Agiular2003-11-20UHC-20499-18N/A521.615.5886—2189 Jefferson AvenueEden Prairie·MN55348—NAVIGATE-HMO
PRVPRV-216962026-07-06T20:40:17ZLAUREN—RIVERA1962-11-07NULLN/Anullnull···nullN/AUNKNOWNNULL—UNKNOWN
PRVPRV-232792026-03-11T04:40:44ZCHARLESCBRYANT2/6/1969UHC-01319-03-··+1 421 614 0249··-··—N/A—nullNULL··MEDICARE-ADV-B
PRVPRV-231432026-03-12T01:16:11ZTomXLuna1986-04-10—•••-••-7200890-254-3970thomas.luna93@icloud.com3916 Bayshore DriveHoustonTexas77025NULLnull
PRVPRV-261632026-03-27T07:27:27ZVICTORIA··HFLORES1944-02-20UHC-25370-92NULL3267985159N/A7285 Apache Boulevard #886TempeAZ85261-2770—····
PRVPRV-280912026-04-03T16:31:53ZJENNIFER—PRICE—UHC-20738-60-3973788524jennifer.price42@icloud.com5802 Washington StPHOENIX·AZ85030nullOPTIONS-PPO
PRV PRV-281262026-05-05T14:00:58ZSHARON—MALDONADO1982-05-72··UHC-48917-93-478-699-3618-7013 Meadow Ln··TucsonAZ85755—NULL
PRV PRV-259662026-04-29T11:48:33ZZachary—Mershall2001-11-21N/A—(352) 905-3357—7657 Lake View RoadAtlantaGA····UNKNOWNNULL
PRVPRV-208982026-04-22T15:29:53ZDIEGONWILLIAMS··1978-12-01··UHC-21645-18UNKNOWN(682) 765-9100—1963 Willow CtChandlerAZ85252—·null
PRVPRV-204242026-03-31T19:09:06ZARJUN—GARDNER1987-08-28NULL—487-830-3467·UNKNOWN7270 Bayshore DrDenverCO80286UNKNOWN··
PRVPRV-234742026-07-31T18:29:22ZALEXANDERJWATKINS1951-01-04UHC-16468-60NULL17905065866··alexander.watkins1@outlook.com4141 Meadow LaneColumbusOH43214—-
PRVPRV-239612026-05-07T11:17:59Z·Frances—Jacobs1974-02-01··null—7953078474NULL3130 DESERT SKY BLVDDenver··CO80223··N/Anull
PRVPRV-218932026-01-24T10:43:08ZSTEPHENNHOLMES·1940-01-28UHC-84368-17—211.415.4493··-2998 Cedar LaneOrlandoFL32851-—
PRVPRV-276452026-08-02T18:46:16ZBryan—Lee1953-03-06UHC-60783-66•••-••-21789773112122null2721 Indian School RoadScottsdaleArizona85285UNKNOWN—
PRVPRV-288942026-04-30T11:31:26ZFrances—Rice1939-04-09UHC5656277NULL—frances.rice@aol.com817 Washington StLas VegasNV89154—-
PRVPRV-293382026-06-02T12:27:58Z·Ann—Perez1993-08-11NULL•••-••-3807(437) 749-6926ann.perez@aol.com2559 BASELINE RDPHOENIX··AZ85046····-
PRVPRV-223112026-09-29T19:27:07ZStevens, Elizabeth——·1993-01-09UHC-16032-76—N/ANULL5198 Union Street··JacksonvilleFLnull·nullNAVIGATE-HMO
PRVPRV-27855 2026-05-09T06:47:59Zsandra··—martin1162-20-03··nullUNKNOWN977-853-8341sandra.martin71@aol.com5929 INDIAN SCHOOL RDCOLUMBUSOH43227N/ACORE-HMO
PRVPRV-224422026-03-19T20:30:13Z Nathan—Olson1977-08-18NULL—·18935064456—7553 Central AvenueHOUSTONTX77034—null
PRVPRV-241482026-08-07T15:31:19ZPhilip—·Valdez02-03-1996UHC-84631-45•••-••-2145null··—713 CAMELBACK RD Apt 24DENVERColorado80234-NULL··
PRVPRV-253972026-03-06T19:56:05ZTerryA.Medina19650208——4330047TERRY.MEDINA99@OUTLOOK.COM9633 SAGE CTEden Prairie·MN55316····N/A
PRVPRV-201922026-05-03T13:23:14ZAmandaD.Wheeler19380707—null729-708-7633null9600 Maple AvenuePhoenix··AZ·85055NULL—
PRVPRV-222882026-05-02T22:11:21ZRAYMOND—BANKS2004-07-09UHC5368051•••-••-47793434683NULL2102 Central AvenueDenverCO80236N/A—
PRVPRV-237212026-06-13T23:29:02ZNatalieH.Fowler1939-10-01UNKNOWN··•••-••-9874(602) 829-7759natalie.fowler@gmail.com1112 Willow CourtDallas··Texas·75214nullN/A
PRVPRV-221662026-07-06T09:53:19Zkiimberly—white—UHC-64583-03····NULLKIMBERLY.WHITE95@AOL.COM6560 CAMELBACK ROADSan Antoniotx78255—MEDICARE-ADV-B
PRV PRV-24178 2026-02-15T07:07:13Z·PaulDCollins19580425———paul.collins58@hotmail.com2464 Central AveSAN DIEGO·CA92124——
PRVPRV-270542026-09-27T03:18:53ZVasquez—Sandra1987-08-10N/A—8475877055N/A1056 Mesa DriveNashvilleTN37296nullN/A
PRVPRV-229032026-03-10T16:18:08Z Dylan—Foster1970-07-22N/AN/A——2855 Washington StMINNEAPOLISMN55491··NAVIGATE-HMO
PRVPRV-292112026-09-09T05:21:15ZEmilyFDean1938-09-11UHC-59103-27—8095753906··N/A45 Oak StreetDenverCO80259—MEDICARE-ADV-A··
PRVPRV-272212026-10-03T23:32:11ZJesse—Fernandez1954-03-09UHC-88309-60UNKNOWN807.592.2637—4226 JEFFERSON AVEPlanoTX75088··—MEDICARE-ADV-B
PRVPRV-202582026-03-27T23:11:38ZSTEPHENCMORALES1961-03-24UHC-68494-83—9183796476stephen.morales@hotmail.com5118 Grand AvenueLOS ANGELESCA90075··-N/A
PRVPRV-276942026-07-16T19:30:59ZAnna—Vega1982-11-17——+1 443 945 2931ANNA.VEGA37@HOTMAIL.COM3495 MOUNTAIN VIEW DRIVEPhoenixAZ85097NULLchoice-plus-ppo
PRVPRV-291612026-07-13T01:36:55ZKayla—Brooks05/18/94··UHC-31508-89—(277) 981-8387—4646 CAMELBACK RDSeattleWA98138null—
PRVPRV-278992026-07-20T16:52:18Zeugene—crawford1954-05-05UHC-66706-90NULL—NULL··4182 Highland AveNashvilleTN37248-MEDICARE-ADV-B
PRVPRV-208302026-08-09T07:25:05ZCrawford, Tyler··U—1968-08-07UHC-49693-64NULL17255015011N/A··9252 RIDGE RDPLANOTX75095-0127UNKNOWNMEDICARE-ADV-B
PRVPRV-207432026-07-06T04:10:55ZJASON··GARZA2003-03-24—UNKNOWN937.879.9145-N/Anull-—-··NULL
PRVPRV-266982026-07-12T12:41:55ZHiroshi··GRiveranullUHC-30776-85N/A888-500-5013NULL5321 River RoadORLANDOFL32859null-
PRVPRV-217862026-01-28T18:11:42ZLUISI··PORTER2006-06-17—•••-••-0154(665) 857-8571NULL2013 Lake View RoadJacksonvilleFL32286N/A-
PRVPRV-227592026-02-17T15:01:50ZGEORGE—LAWSON1998-11-03UHC-33442-55N/A3777743624UNKNOWN-·null—UNKNOWN—UNKNOWN
9,596 rows, page 51 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:40.603Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty