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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-621482026-04-02T02:50:50ZWayne····Williamson·05/16/1983—•••-••-6704—NULL4055 Apache Boulevard··SeattleWA98184GRP-7531NULL
TPATPA-598862026-02-21T07:36:26Zmarilyn—hlal1963-03-04UNKNOWNUNKNOWN+1 795 421 6511null1501 VALLEY VIEW DREDEN PRAIRIEmn55304GRP-3579null
TPATPA-536122026-08-23T13:10:59ZJACQUELINE—MOORE1995-03-14——null—9435 Broadway #231Houstontx77087GRP-6649—
TPATPA-576932026-03-28T04:09:22ZHlen—·Wallace2006-03-25N/A····—helen.wallace30@gmail.com8344 Mountain View DrPhoenix·AZ··GRP-9702NULL
TPATPA-573212026-07-08T08:31:51ZMarcus—Johnston1957-01-12uhc-13149-50N/A423.430.5655—7914 Meadow LaneLas VegasNV89167GRP-8869—
TPATPA-579042026-02-16T20:17:33Zamanda—fisher1970-08-21-—nullN/A5090 WILLOW CTPhoenixAZ85007N/A—
TPATPA-592372026-03-12T19:45:37ZTYLER—·REED15-11-1950——NULLN/A—NULLNULL-N/A—
TPATPA-614282026-07-28T05:41:07ZRobert—Nichols1989-09-18UHC-85627-10•••-••-89023325387382robert.nichols85@aol.com4382 Sunset BlvdMiamiFL33164GRP-5204—
TPATPA-584882026-03-19T14:37:11ZJenkins, Michelle——10/13/79UHC-18507-38-—-NULL——NULLGRP-4193NULL
TPATPA-612402026-06-24T06:04:58ZSean—Young1974-01-19UHC-33599-32•••-••-9361UNKNOWN-—null——nullNAVIGATE-HMO
TPATPA-530522026-02-19T09:22:38Zaustin—walsh2006-10-21—-691-485-5247—8506 BAYSHORE DRCharlotte··NC28227GRP-3910····
TPATPA-582872026-04-13T21:01:27ZHANNAHKOWENS1947-10-28—N/AUNKNOWNN/A6773 WILLOW COURTORLANDOFL32804—NULL··
TPATPA-532592026-05-25T05:43:51ZCarolyn—Jimenez··1947-10-28UNKNOWNnull—UNKNOWN3589 Pine DrColumbusOH43242GRP-8630—
TPATPA-503292026-03-12T23:46:24Zjonathan—bryant06-03-1980UNKNOWNnull2067526309N/A·6901 Baseline RoadPlanoTX75033NULLMEDICARE-ADV-A··
TPATPA-582102026-06-27T18:28:56Zethan—davis1973-12-20-•••-••-97886292019441··-6281 RIVER ROADEden PrairieMNnull--
TPATPA-514712026-04-18T03:02:13Z Joseph—Martin1948-01-18NULL——NULL4130 Washington StreetGilbertArizona·85285nullnull
TPATPA-579832026-07-02T05:17:10ZPerez, Kayla··—12/11/64UHC-80886-56UNKNOWN··—NULL··—UNKNOWN——-CORE-HMO
TPATPA-545452026-02-06T08:39:20ZFrankSGarrett11/11/84—--NULL9229 Sunset BoulevardTampaFlorida33618UNKNOWNN/A··
TPATPA-639772026-08-03T11:28:15Zandrew—hoffman28-01-2004··—N/A(552) 439-2270-··8112 Meadow LaneTAMPA··FL33690NULLCORE-HMO
TPATPA-514542026-05-26T11:22:53ZRogerLRyan8/28/1975UHC-35596-61null····NULL·5731 RIDGE ROAD #723Minneapolis··MN55463UNKNOWN—
TPATPA-519932026-09-27T19:34:53ZNancy—Castro20051027——N/A—340 Canyon RoadTucsonAZ85767····UNKNOWN
TPATPA-536982026-03-09T17:39:59ZJacqueline—Adams··06/09/1996NULLNULL—jacqueline.adams@hotmail.com5404 SPRING STREETHoustonTX··77067UNKNOWNN/A
TPATPA-554462026-09-01T17:41:20Zjaanice—hanson1966-12-14UHC-80875-48•••-••-1533850.714.3700janice.hanson@icloud.com5303 Willow Court·TempeAZ85271NULLUNKNOWN
TPATPA-598302026-08-28T12:31:43ZReynolds, Michael——2006-01-17-UNKNOWN(442) 721-6562michael.reynolds22@yahoo.com6996 Cedar LaneDALLASTexas75289GRP-5608N/A
TPATPA-579842026-04-25T05:28:38ZDENISE—PADILLA9/21/1970—•••-••-1590UNKNOWN—5052 Church St··PhoenixAZ85080GRP-8270UNKNOWN
TPATPA-538432026-01-14T18:49:45ZDennis··Lawrence19530910null•••-••-5087—N/AN/AUNKNOWNUNKNOWNnullUNKNOWNCHOICE-PLUS-PPO
TPATPA-614232026-03-01T06:55:43ZBowman, MatthewB—19921125UHC-93661-71··null··4383 Palm DriveMIAMIFL33143UNKNOWN···UNKNOWN
TPATPA-516752026-04-06T10:12:13ZEmma··—Coleman1992-05-06N/A··N/A·928.560.3134NULL8276 Oak StTempeArizona85215-··CORE-HMO
TPATPA-627262026-01-25T23:36:06ZRussell—Weaver1962-04-14—•••-••-5940null—-null·N/AN/A—CHOICE-PLUS-PPO
TPATPA-528902026-05-18T15:18:59ZJONATHAN—WEAVER1979-02-25nullN/A+1 732 853 5279N/A1511 Palm DrTucsonAZ85793null-
TPATPA-571622026-04-02T09:57:42ZSandra—Ortega1980-12-26null•••-••-2646N/A--UNKNOWN—-GRP-4532··MEDICARE-ADV-B
TPATPA-589752026-02-23T23:18:28ZCruz, Christian····—6/3/1992—UNKNOWN13976202117null—UNKNOWNUNKNOWNnull—NULL
TPATPA-618132026-06-13T13:17:36ZDonna—Delgado1939-08-03··—-—UNKNOWN··8190 Desert Sky BlvdSeattleWA98110GRP-9769·NAVIGATE-HMO
TPATPA-582642026-07-18T06:24:42ZMartha—Warren11/19/54····N/A—N/A3383 Lake View RoadScottsdaleAZ85239UNKNOWNMEDICARE-ADV-B
TPATPA-543202026-01-04T22:36:55ZElijah··—Hanson··2003-03-04——·2764045252—119 Indian School RoadJacksonville··fl32200——
TPATPA-505522026-09-06T16:55:43ZLOGAN—WEBERDec 10, 2004-nullnull—4097 Ridge RoadTucsonAZ85792GRP-6383SELECT-EPO
TPATPA-618222026-01-25T06:00:11Z·Andrew—·Johnson·02/19/1962·NULL-····N/A6062 Elm StreetSacramentoCaliforniaN/AGRP-1618null
TPATPA-589482026-08-09T04:31:47Zjessica····mccoy1952-01-10null—368.417.8956—2580 Hillcrest RdJacksonvilleFL32287NULL··N/A
TPATPA-584072026-05-18T18:12:55ZFields, Eugene——4/17/1946nullnull(232) 799-0491·eugene.fields55@gmail.com8134 Valley View DrColumbusOH43232-3746N/Anull
TPATPA-535832026-01-31T21:07:44Zkyle—jackson·1990-08-01null•••-••-7690UNKNOWNNULL1123 Willow CtAtlantaGA30325-6681—UNKNOWN
TPATPA-51809 2026-08-29T17:07:10ZSHARON—SANTOS1990-01-28UHC-46936-59··NULL9059848621··UNKNOWN6404 BAYSHORE DRDENVERCO80272-4812GRP-7557CHOICE-PLUS-PPO
TPATPA-53044 2026-01-13T21:41:19Z·Priya··Edwards19981212UHC-24743-58NULL··UNKNOWN9801 Willow CourtAtlantaGA30393UNKNOWNNULL
TPATPA-628222026-07-22T23:52:13ZBARBARA—HAYES26-03-1951NULL•••-••-7886976-635-8924NULL590 Meadow LaneFresnoCA93737——
TPATPA-552192026-09-27T07:46:23ZHiroshi—·Hughes—NULL•••-••-9426NULLNULL9836 Desert Sky BlvdAtlantaGA30362GRP-5341-
TPATPA-577602026-01-18T01:45:05ZANDREW—LAWSON1/10/1940NULL—340.742.8230UNKNOWN8968 WILLOW CTOrlandoFL32895NULLN/A
TPATPA-50460 2026-06-08T23:58:57ZJustin—Weber06/28/48null-null—9726 PALM DRMIAMIFL33131UNKNOWNNULL
TPATPA-567952026-03-24T03:19:25ZWei—Andrews1953-01-16—·NULL+1 827 937 1932wei.andrews@gmail.com9640 Baseline RoadGlendaleAZ85357null-
TPATPA-59102 2026-06-27T13:50:10Zashley—walker1952-12-07-•••-••-8085(306) 571-3948ashley.walker@hotmail.com524 INDIAN SCHOOL ROADAtlantaGA30310nullN/A··
TPATPA-643512026-08-19T20:58:36ZWagner, Steven——1975-01-28NULL··NULLnull4395 Central AveEDEN PRAIRIEMN55388GRP-6103CORE-HMO
TPATPA-565162026-06-01T04:51:08ZLittle, BillyL—2002-08-12UNKNOWN·nullnullBILLY.LITTLE27@GMAIL.COM5327 CANYON ROADColumbusOH43296-—
14,474 rows, page 218 of 290PreviousNext

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:56.165Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty