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-291432026-07-10T00:10:32ZMurray, Christine——1955-07-07UHC-07405-48-361-399-8351CHRISTINE.MURRAY24@YAHOO.COM··894 ELM STORLANDOFL32823UNKNOWN··—
PRVPRV-23216 2026-04-13T02:14:38ZBRITTANY—STEPHENS14-01-1945UHC-39290-82•••-••-9801(979) 577-7865NULL3384 Oak St··Columbus·OH43201UNKNOWN····
PRV PRV-280682026-07-02T02:59:38ZJanet—Dixon02/25/1983N/ANULL3052815865janet.dixon@gmail.com6872 PALM DRSEATTLEwa98184UNKNOWNnull
PRVPRV-292842026-04-27T17:44:24ZloganWclark08/06/96UHC-45189-88-(341) 568-7063N/A3642 Meadow Ln·Las VegasNevadaUNKNOWNUNKNOWNCORE-HMO
PRVPRV-279012026-04-22T22:35:51Zandrea—mendoza1939-05-07UHC-86485-66UNKNOWN4854877644N/A···3886 Sunset BoulevardScottsdaleAZ85234nullnull
PRVPRV-242392026-10-06T06:41:54ZMcDonald, Emma······12/11/04——3473094169—2008 Central AveJACKSONVILLEFL32217null··UNKNOWN
PRVPRV-254962026-06-16T23:43:50ZHIROSHI—POWELL··1951-07-05UHC-87923-96•••-••-076614258524904null7769 Camelback Road··TucsonAZ85759UNKNOWN—
PRVPRV-288002026-01-01T15:13:06ZHarold—Lewis1983-03-15····•••-••-8212·(427) 266-2732HAROLD.LEWIS@GMAIL.COM—-—N/AUNKNOWN—
PRVPRV-247352026-03-11T15:21:07ZRyanJHill09/13/66N/Anull359-397-3007-2450 RIDGE ROADTempeAZ85286N/AN/A
PRVPRV-212282026-02-14T20:09:08ZRANDY—TUCKER03/15/1982UHC-72020-56····12363621547randy.tucker@yahoo.com9264 Mesa DrOrlandoFL32840—UNKNOWN
PRVPRV-211732026-08-20T23:10:50Z·Pter—Li·1990-06-04UNKNOWN-NULL··-4194 Washington StreetMinneapolisMN55440null—
PRVPRV-291732026-03-03T08:47:22ZWILLIE—·WALKER1944-02-16UHC-63045-56null515.573.6492—3616 Oak StLOS ANGELESCA90057—-··
PRVPRV-260202026-09-20T06:46:59ZElijah—James1988-12-02UHC-32708-38NULL3893487416··—7563 Elm StSCOTTSDALE··AZ85284—N/A
PRVPRV-274432026-10-10T19:16:55Z·Moris, Lawrence——20010201·NULLUNKNOWN—UNKNOWN3862 Meadow Ln·DenverCO—NULL—
PRVPRV-293672026-07-21T06:23:12Z·Santiago—Burton1998-05-26NULL•••-••-3845442-830-2308—3029 Willow CtOrlandoFL·32897-8821NULLMEDICARE-ADV-B
PRV PRV-269522026-04-01T09:25:21ZBruce—·Hart1971-61-26-—8842144282··UNKNOWN2479 Mesa DrTUCSONAZ85786-6635—N/A
PRVPRV-262122026-02-14T04:06:45ZMason—Ortiz02/08/2008N/AN/A827-243-2942mason.ortiz@icloud.com9428 LAKE VIEW ROADTempeAZ85262—CHOICE-PLUS-PPO
PRVPRV-25418 2026-02-04T20:16:49ZEdward······AllenOct 20, 1940UHC-76827-89··-3517431183—1379 Canyon Road··Eden PrairieMN55372—OPTIONS-PPO
PRVPRV-280162026-09-24T19:06:41ZSharon—Rodriguez19520106UHC-10806-16•••-••-5046(793) 611-9435NULL5998 Elm StSeattleWA98103nullUNKNOWN
PRVPRV-257502026-10-10T20:45:35ZGomez, JeremyH.··—1792-08-09UHC-62554-77-null—5315 Mesa DrMinneapolisMN55462····OPTIONS-PPO
PRVPRV-246962026-01-09T10:35:51ZTYLERXSNYDER1964-08-19···UHC-00613-40··7393587845NULL6743 Lake View RoadEden PrairieMN55316-—
PRVPRV-233432026-10-13T14:22:33ZKEITH—WELLS1992-08-05—•••-••-6982(240) 660-8858N/A8900 Pine Drive·DallasTX75220-4890··-N/A
PRVPRV-236472026-06-22T09:00:47ZGeorge—Garrett1995-05-14UHC-05067-11null550-856-8354UNKNOWN·7844 Indian School RdSacramentoCA95845—UNKNOWN··
PRVPRV-251392026-02-09T12:23:06ZRamos, Jerry——1974-10-07·UHC-14545-99•••-••-6141·13894092273-5136 ELM STREETSacramentoCA95880nullnull
PRVPRV-229372026-08-18T23:27:16ZBrandon—West·1996-07-03—·nullnullbrandon.west@hotmail.com5984 Valley View DriveHOUSTONTX77070NULLN/A
PRVPRV-242632026-03-29T23:34:12ZJOYCEATRAN19390424··UHC-45030-13N/A5446290568N/A3124 GRAND AVEMiamiFL33162nullSELECT-EPO
PRVPRV-269392026-07-18T04:08:06ZHoward, Ryan——12/22/1976null··•••-••-4495(448) 420-2585UNKNOWN6625 Market StDALLASTexas75230NULLN/A
PRVPRV-256212026-05-21T19:11:56ZETHAN—MITCHELL1954-08-17UHC-64818-21—UNKNOWN—4533 Valley View Drive #649·AtlantaGA——CORE-HMO
PRVPRV-244732026-01-11T11:21:35ZBradley—Oliver1951-09-07UHC-67161-27-8386186289—5188 Union StreetTampaFL33656-N/A
PRVPRV-210352026-02-14T17:45:10Z—Q.—10/19/1949—N/A(446) 309-2832NULL729 BroadwayPlano·TX75070—NAVIGATE-HMO
PRVPRV-227632026-01-03T07:02:24ZJustin—Shaw19850727NULLNULLUNKNOWN—861 Ridge RdDallas··TX75283nullN/A
PRVPRV-242252026-05-17T07:17:54ZMeiBBradley19990309UHC-98883-33—969-653-6131mei.bradley6@icloud.com3322 Palm DriveDenverCO·80277—N/A
PRVPRV-235092026-01-15T19:21:10ZBen—Shaw1993-05-24UHC-42535-60UNKNOWN——2003 Central AvenueJACKSONVILLEFL32216N/Anull
PRV PRV-242622026-08-01T22:59:18ZPatricia—WangAug 14, 1950UHC-99901-23—9345370419N/A4280 Lincoln WayAustinTX78748--
PRVPRV-213262026-05-05T09:24:26ZBruce—Mattthews10/15/1948—•••-••-1491—N/A·null——NULL—UNKNOWN
PRVPRV-270002026-10-12T03:19:07ZKellyHHarris1961-03-22·uhc-15595-64NULL6919397031kelly.harris71@outlook.com--N/A—-NAVIGATE-HMO
PRVPRV-26351 2026-07-29T19:03:17ZMARCUSO··NICHOLS3/17/2005UHC-25674-18··N/A(367) 214-2096-3722 CAMELBACK ROADEden PrairieMN55322N/AN/A
PRVPRV-241902026-03-28T15:58:09ZSTEVEBHAYES09-03-1945··—null·871-275-2032stephen.hayes31@proton.me5994 Willow CtScottsdaleAZ85264nullN/A
PRVPRV-206182026-03-19T20:47:12ZVALENTINAHCUNNINGHAM12/2/1949UNKNOWN····(674) 877-3395UNKNOWN5317 Mesa DrAtlantaGAnull—N/A
PRVPRV-272262026-02-04T19:41:55Zsantiago—franklin10/10/54UHC-35421-78N/A+1 959 917 9021UNKNOWN8938 Union StreetGilbertAZ··85212-····
PRVPRV-283752026-04-21T10:05:53ZVirginia—Kim08/11/1945·UHC4719423——virginia.kim@outlook.com4941 MESA DRLas Vegas··Nevada89132—OPTIONS-PPO
PRVPRV-270672026-03-04T08:21:49ZAnthony—Carpenter1959-08-27UHC4696133··—8475944106NULL··6235 MOUNTAIN VIEW DROrlandoFL32828N/Anull
PRVPRV-203542026-07-29T10:12:30Zkyle····thomas19710410UHC-54913-13N/A399-538-2279kyle.thomas92@aol.com5913 Grand AvenueSan DiegoCA92146—SELECT-EPO
PRVPRV-238672026-02-27T16:12:23ZNANCY—SANTIAGO03/03/1974NULLnull764-718-9716UNKNOWN3929 CAMELBACK ROADEden PrairieMN·55346UNKNOWNCHOICE-PLUS-PPO
PRVPRV-279362026-09-25T08:19:34ZSARAH—CARROLL···19690506—•••-••-32604593740828NULL2788 Ridge RdColumbusOhio··43236·-NULL
PRVPRV-293152026-05-11T23:32:09Z doris—espinoza1810-19-65UNKNOWNnull—doris.espinoza@icloud.com5805 Meadow LaneScottsdaleArizona85244UNKNOWNMEDICARE-ADV-A
PRVPRV-272052026-07-07T08:58:58Zbobby—dixon11/06/1984—NULL9475334176bobby.dixon@hotmail.com9367 Grand Avenue···Las VegasNV89112··UNKNOWN
PRVPRV-226132026-10-17T01:11:37ZCarlos—Jenkins8/7/1959—•••-••-3252—carlos.jenkins@hotmail.com1581 Valley View DrCHANDLERAZ85291·UNKNOWN—
PRVPRV-252682026-05-13T16:55:10ZJOSEISCOTT1979-05-02··——791.545.2789jose.scott14@hotmail.com1716 RIDGE ROADNashvilleTN37283N/AN/A
PRVPRV-292652026-07-29T08:07:44ZCatherineI.Sanchez1993-07-05UHC-57995-64—734-228-6549catherine.sanchez85@gmail.com3195 Valley View DrCharlotteNC28257null-
9,596 rows, page 170 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:00.530Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty