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-295812026-07-13T14:05:23ZMorales, Juan——06/09/95UHC-08643-27N/A868-833-4727-8572 Valley View DrGilbertAZ85253——
PRVPRV-267062026-09-26T12:09:05ZCHRISTINA—GRAHAM1948-09-14UHC-81316-40•••-••-2227(295) 371-4632——UNKNOWNUNKNOWNNULLN/A··NULL
PRVPRV-203612026-07-17T21:40:24Z markCjohnson1982-02-03-•••-••-5297(576) 560-6988MARK.JOHNSON6@PROTON.ME4650 Market StLas VegasNV89145—-
PRVPRV-203532026-07-15T21:56:44Z·john····hart1995-04-13N/AN/A211.402.4386UNKNOWN3453 Apache BlvdNashvilleTN37292··—NULL
PRVPRV-219882026-01-01T09:33:40ZMaria—·Robinson12/03/62—UNKNOWNUNKNOWN—717 Grand AvenueColumbusOH43281—NULL
PRVPRV-244772026-04-23T07:42:45Z ETHAN—ORTIZ·07/09/68N/A—(693) 920-2181null3946 PARK PLACENashvilleTN37215nullCORE-HMO
PRVPRV-234402026-08-02T05:10:30ZSAMANTHA—·WELCH·Aug 20, 1970NULLNULL·(430) 886-5183NULL3081 JEFFERSON AVESAN ANTONIOtx78234—··
PRVPRV-288742026-05-31T22:48:30Z ·Terry—Payne2007-04-07UHC9573130N/A(730) 329-4495·TERRY.PAYNE@GMAIL.COM1535 Apache BlvdAtlanta··GA30323NULLNAVIGATE-HMO
PRVPRV-220532026-10-13T14:24:09ZDebra—Ortiz·1998-11-25NULL—(242) 787-3300debra.ortiz12@aol.com··4384 PINE DRIVETempeAZ·85240——
PRVPRV-223592026-03-25T00:53:22ZSara—Sanders·1970-11-07NULLN/A2133545·SARA.SANDERS15@GMAIL.COM2403 Spring StDenverColorado80296null-
PRVPRV-277232026-05-10T13:26:29ZJackieFStewart1963-11-10—•••-••-11832274808705UNKNOWN——····NULL··NULL—
PRVPRV-213422026-03-01T14:30:14ZTorres, Jordan——05/15/74UHC-00744-80•••-••-0817·(830) 502-1135····5082 Bayshore DrPHOENIXAZ··85046·UNKNOWNUNKNOWN
PRVPRV-209822026-07-23T01:11:31ZRoy—Miller20060117null··NULL8807547N/A7067 Church St Apt 40SacramentoCA95841—N/A
PRVPRV-219052026-04-19T11:03:35Z aaron—obrien1967-10-21N/A•••-••-5834244.908.8405—2467 Central AvenueChandlerAZ85277—N/A
PRVPRV-233732026-07-15T22:36:21ZRONALDHCHAPMAN2004-08-27nullUNKNOWN211-759-3716N/A9311 Harbor BlvdGilbertAZ85275—-
PRVPRV-276202026-03-30T01:06:09ZMATTHEW—BOWMAN1992-11-25—-3075231472—··nullNULL—N/Anull
PRVPRV-250942026-05-08T22:52:15ZHANAH—LUCAS12/09/86UHC-54951-70null17145655361—9358 MOUNTAIN VIEW DRIVEPlanoTX75067-··
PRVPRV-271612026-06-22T12:50:13ZFrank—Mendoza1981-10-06UHC4619014-NULLFRANK.MENDOZA38@OUTLOOK.COM9694 Oak StreetCharlotteNC28225-N/A
PRVPRV-217522026-07-17T20:53:50ZHeather—Taylor23-07-1945——5308836062NULL753 Camelback Road·MesaAZ85209—SELECT-EPO
PRVPRV-279042026-03-05T02:38:25ZJason··VMurray·1991-08-18N/A-+1 579 557 2501··6816 Willow CourtCharlotteNC28277N/A—
PRVPRV-249612026-05-27T02:18:37ZJUAN—RICHARDS19680712——272-286-1777null5895 Church StreetGlendaleArizona85384—N/A
PRVPRV-216072026-01-21T05:17:01ZBRIAN—MARTIN12/12/55——2929755523-8828 CEDAR LNSeattle··WA·98113-3279nullN/A
PRV PRV-223432026-08-02T00:15:36ZdebraZprice1948-07-26——4333085023··null7061 Willow CourtHoustonTX77082nullSELECT-EPO
PRVPRV-205172026-03-08T17:59:29ZDot—Perez1984-06-20UHC-96748-73-+1 209 868 9013N/A2167 Mesa DrSeattleWA98109—-
PRVPRV-218192026-01-04T01:02:28ZTimothy—Flores19801014UHC-53330-02—577.299.7854··6476 Washington StreetEden Prairie··MN55389-UNKNOWN
PRVPRV-248602026-09-01T17:32:43ZAishaZChapmanUNKNOWN—NULL·225-469-7944N/A4462 Cedar LnMIAMIFL33191—null
PRVPRV-213492026-06-12T04:25:19ZNatalie—Adams12-11-1980UHC-15911-63———6511 Pine DriveSan Diego·CA92159UNKNOWNnull
PRVPRV-246582026-02-16T17:33:16ZOrtega, Kathryn——20020727UHC-85581-79NULL—null1848 MAIN STAtlanta··GAN/A-—
PRVPRV-240622026-06-05T09:28:50ZMariana—Dixon1975-06-01N/AUNKNOWN-—9177 Main St·ScottsdaleAZ85289UNKNOWN—
PRVPRV-274382026-09-24T18:21:00ZSandovalVDeborah1948-06-07—UNKNOWN(317) 632-2535—7276 Willow CtMinneapolisMinnesota55467—OPTIONS-PPO
PRVPRV-232602026-05-06T19:32:51ZBruceRMorgan2006-11-24UHC-19389-24NULL3497162438bruce.morgan55@outlook.com···5416 Camelback RdGilbert··AZ85252-2539——
PRV PRV-280452026-04-07T09:51:06ZDaavid—Henry1938-09-08UHC-00305-08—--7188 BROADWAYSan DiegoCalifornia···92109-2043--
PRVPRV-279172026-05-04T13:23:10Z·katherine—butler1938-10-05null—7905444668N/A7504 DESERT SKY BOULEVARDHoustonTexas77099—CORE-HMO
PRVPRV-251512026-09-11T19:09:22ZGARY—HUNT05/19/1959UHC-01749-02N/A(315) 386-2451—9561 Lincoln Way #196MiamiFL33112—-
PRVPRV-29088 2026-01-17T16:22:10ZJose—Chapman·Apr 28, 1986UHC8357902•••-••-0731+1 667 887 6082N/A4506 Park PlSan DiegoCAnullUNKNOWNNAVIGATE-HMO
PRVPRV-285372026-01-29T00:42:26ZMERIANA—WILLIAMSON··19670401UHC-94555-31—485-885-7683mariana.williamson@proton.me2955 Church StreetFresnoCA93708——
PRVPRV-215412026-01-05T15:40:37ZSophia—Hughes2006-11-23UHC-77760-37·-17506300514··null·2143 Bayshore DriveTempeaz85230——
PRVPRV-272842026-04-25T05:01:58Z ISABELLA—COLLINS1984-04-07NULL—(909) 395-6781ISABELLA.COLLINS45@PROTON.ME—UNKNOWN—N/A—UNKNOWN
PRVPRV-255122026-03-20T22:09:06ZCHRISTIAN—CHAVEZ1996-01-20··NULL··+1 503 792 0366N/A7834 OAK STSeattleWA—NULL—
PRVPRV-249602026-07-18T09:26:35ZJoyceNCole1985-05-25—•••-••-19124583720955joyce.cole14@gmail.com-NULL——-choice-plus-ppo
PRVPRV-211792026-04-14T10:46:53ZRYAN—RIVERA19740214N/A•••-••-0243(663) 231-8902—6236 Desert Sky BoulevardMesaAZ85258nullNULL
PRVPRV-230362026-10-06T11:20:50ZFrankOStephens04/08/1983—•••-••-2515362-809-8196N/A8890 Lincoln WayChandlerAZ85223—-
PRVPRV-21670 2026-03-18T18:58:26Zanthony—fox07/09/58N/AUNKNOWN+1 979 204 9229null3622 Desert Sky BoulevardEden PrairieMN··55305nullNULL
PRVPRV-234562026-03-10T16:28:38Zchristian—fuller19930718UHC-09907-73•••-••-55156809133970N/A1377 Desert Sky Boulevard Apt 14Eden PrairieMinnesota55305UNKNOWNMEDICARE-ADV-A··
PRVPRV-211342026-09-15T10:16:25ZSTEVEN—GUZMAN·2001-11-20UHC-15163-18NULL676-225-8210N/A6461 MESA DR·LAS VEGASnv89120NULLN/A
PRVPRV-200422026-07-22T15:50:40ZJacquelinePWatson··5/28/1974N/A····(893) 327-1096jacqueline.watson@hotmail.com2412 Valley View DrFRESNOCA93727-3131——
PRVPRV-222982026-05-24T18:32:43Zalbert—ortiz1211-19-73UHC-43635-68-9023927ALBERT.ORTIZ37@OUTLOOK.COM5853 Union StPhoenixAZ85051UNKNOWN—
PRVPRV-292122026-04-22T00:41:01ZRUSSELL—MUNOZ··1963-01-27UHC-30448-14—5286990617russell.munoz44@yahoo.com5968 SPRING STREETSeattleWA98171NULL—
PRVPRV-259092026-05-07T18:48:45Z Linda—Hill1999-06-21UHC-06589-71•••-••-1170665.755.2053linda.hill65@proton.me1446 Bayshore DriveDenverCO80222——
PRVPRV-217182026-06-13T15:40:31ZAlexisQYang1997-12-20UHC-98520-52NULL698-763-0604UNKNOWN6129 Sunset BoulevardSan AntonioTX78200—MEDICARE-ADV-B
9,596 rows, page 101 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:49.111Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty