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-512202026-03-17T08:56:32ZLAWRENCEJMORGAN1970-05-27NULL•••-••-6694null-—N/AUNKNOWNNULLGRP-4682··null
TPATPA-613162026-03-25T06:16:12ZCHRISTINE—BROOOKS12/25/53N/A•••-••-3340743.238.6989··—3231 Cedar LaneSeattle···Washington98191—NULL
TPATPA-528152026-10-03T18:05:52ZWelch, Alexis——May 21, 1950-····8957778417N/A2207 Meadow LnFresnoCA93725NULLNULL··
TPATPA-503792026-01-03T15:45:59Z·Grace—Little2/6/1972NULL•••-••-8216NULLUNKNOWN4309 Spring StScottsdale··AZ85229NULLNULL
TPATPA-633882026-03-07T03:58:14ZEmily—Garcia1950-12-25UHC-67435-44•••-••-5428NULLemily.garcia@hotmail.com9327 Union StChandler·AZ85283N/AMEDICARE-ADV-A
TPATPA-537732026-06-19T06:21:01ZAhmed—PetersJan 14, 1946NULL•••-••-5993·(731) 956-7631AHMED.PETERS@OUTLOOK.COM·9559 SPRING ST #849Seattle··WA98172—NAVIGATE-HMO
TPATPA-636002026-03-30T18:11:16ZMARILYNUSPENCER1979-04-01·UNKNOWN•••-••-6931—UNKNOWN··1867 Market StMiamiFL·33155GRP-3419—
TPATPA-564932026-07-02T16:34:38ZCARL—WATSON06/14/47·NULL•••-••-2307UNKNOWNN/A7251 Washington Street··SeattleWA98189—-
TPATPA-584822026-02-24T15:04:23ZBRENDA—HARRIS1986-05-16NULLN/A—-5419 Jefferson Avenue··PlanoTX75043··NULLNAVIGATE-HMO
TPATPA-617212026-09-06T17:37:35ZKEVIN—FREEMAN1952-09-01-——KEVIN.FREEMAN@HOTMAIL.COM7508 Oak StreetMesaAZ———
TPATPA-608662026-07-15T00:31:37ZJack—Austin1950-04-20N/A•••-••-2909+1 344 954 7624jack.austin@aol.com6937 UNION STOrlandoFL32834NULLN/A
TPATPA-538332026-06-17T23:48:47ZRandy—Thompson11/20/94·N/AN/AN/A—4277 Elm StreetHoustonTexas··77081N/AMEDICARE-ADV-B
TPATPA-590652026-07-16T18:09:24ZRalph—Nichols1961-06-14UHC-69144-34UNKNOWN+1 430 598 9682-5689 Lincoln WayChandler·AZ85269-0243NULLUNKNOWN
TPATPA-59789 2026-08-25T06:30:09ZJeremy—Richards··19521011-•••-••-6437NULLUNKNOWN2676 Highland AveTempeAZ85293NULLMEDICARE-ADV-A
TPATPA-613072026-07-05T12:50:40ZMASON—MCDONAALD1974-03-23UHC-56620-79—(868) 951-9816mason.mcdonald24@aol.com2651 MOUNTAIN VIEW DRGlendaleAZ—GRP-9807NAVIGATE-HMO··
TPATPA-507632026-04-05T08:24:36ZJulia····Hudson04/10/73NULLnull(510) 375-4706N/AnullUNKNOWN—-—CORE-HMO
TPATPA-616542026-02-08T23:48:37Z Shirley—·Soto1948-09-15-•••-••-73813274211075shirley.soto@icloud.com6577 Baseline Rd Apt 20NashvilleTN37217nullN/A
TPATPA-521322026-07-16T23:10:36ZJULIE—BROOKS2000-01-15--8504289209—2139 Park PlaceScottsdaleAZ85269—null
TPATPA-611492026-08-16T15:55:33ZCampbell, Mariana······—2008-05-15—null——2470 Palm DrMinneapolis·MN55400····null
TPATPA-546672026-06-06T12:38:46ZMei, Martin——1966-04-22—null——9829 HILLCREST RDSan AntonioTX78228——
TPATPA-612102026-07-15T10:58:11Z·Isabella—Reed1960-09-07-NULL689.903.2360—7712 Jefferson AveTempeAZ85212-MEDICARE-ADV-B
TPATPA-574582026-02-21T22:22:21ZCamila—Daniels··1945-06-13····—5426017294camila.daniels95@proton.me2438 Sage CtPhoenix·AZ—null-
TPATPA-525952026-04-16T03:00:25ZBENJAMINW.BROWN1951-08-19——-NULLUNKNOWN—UNKNOWN—-N/A
TPATPA-534312026-02-11T20:48:00ZBowman, Suphia——1983-01-26UHC-12484-24-NULL·sophia.bowman33@hotmail.com1910 FOREST AVENUESan DiegoCA92167GRP-7328SELECT-EPO
TPATPA-616742026-02-05T19:15:11ZHiroshi—Greene1997-09-26—•••-••-7038716-296-6600—7106 Market StreetSacramentoCA95896—-
TPATPA-572452026-05-17T08:18:21Z Griffin, AndrewT—Sep 7, 1956——····N/A644 Palm DrAtlantaGeorgia30388GRP-9689MEDICARE-ADV-B
TPATPA-515452026-03-12T09:12:30Zsharon—welch1939-01-15N/A•••-••-8134—NULLnullnull-··——UNKNOWN
TPA TPA-598732026-06-19T22:47:19ZZACHARY····GEORGE1982-02-19—··nullN/A8626 RIDGE ROADSeattleWA98123N/A—
TPATPA-574732026-08-20T02:22:09ZDiane—Rogers2003-10-08UHC-26032-76•••-••-9020N/ANULLN/A-··UNKNOWN··—GRP-7474CHOICE-PLUS-PPO
TPATPA-624032026-01-16T02:11:29Z Beverly—Romero21-10-1974—UNKNOWN—NULL6971 JEFFERSON AVELas VegasNV89115——
TPATPA-619992026-07-28T20:04:39Z———21-03-1960—•••-••-3007(959) 654-2063amy.hicks30@gmail.com··null—UNKNOWNGRP-0591SELECT-EPO
TPATPA-511692026-01-20T07:11:16ZJANET—·ALVARADOJan 1, 1977NULL·-—·NULL4558 Cedar LnNASHVILLETN37284——
TPATPA-547722026-01-01T23:26:10ZCharlotte—Valdez05/01/91nullNULL(830) 221-7698—1375 Canyon Rd Apt 26Columbusoh43288—CORE-HMO
TPATPA-539072026-04-15T15:53:09Z·BETTY—LEWIS1993-08-28··-——BETTY.LEWIS34@HOTMAIL.COM3459 River Road·San AntonioTXNULLUNKNOWN—
TPATPA-603012026-10-05T15:52:20ZBryan—Hayes07/05/50UNKNOWNNULLnull—994 PARK PLACETempeAZ85225GRP-2264N/A
TPATPA-573702026-05-15T21:07:23ZMICHAEL—SIMMOONS02/27/94——394.837.8915NULL··3978 BROADWAYHOUSTONTX77078GRP-4135N/A
TPATPA-614622026-05-08T19:57:36ZSANTIAGO—SHAW19500504—nullNULLUNKNOWN6613 Harbor BoulevardPHOENIXAZ85084NULL—
TPATPA-575422026-04-03T04:04:22ZOwens, Nicole——9/15/1974N/Anull··—N/ANULL—null-null-
TPATPA-634432026-09-30T16:46:39Z Brittany··Ferguson05/18/44UHC-92938-61•••-••-7837——6556 Ocean Avenue #772San DiegoCA92127UNKNOWN-
TPATPA-618652026-06-07T22:25:00ZAaron—Scott1982-12-27null·NULL—·UNKNOWN·4438 LINCOLN WAYSeattleWA98129—UNKNOWN
TPATPA-635022026-06-23T15:41:07ZTERESA—NGUYENApr 4, 2006——981-512-7715UNKNOWN—NULL·-UNKNOWN——
TPATPA-528022026-05-26T10:02:11ZRALPHJGUTIERREZ1950-11-24UHC-07884-13NULLUNKNOWN-1974 Meadow LaneLas VegasNVNULLGRP-5142null
TPATPA-585092026-02-20T09:56:27ZCamila—·Peterson1947-10-05—-····—8381 RIVER ROAD··Phoenix·AZ85030GRP-2659N/A
TPATPA-526362026-03-09T20:53:32ZOliver, Amber····—19490823———UNKNOWNN/A—NULLNULLGRP-5053null
TPATPA-613562026-04-01T12:18:54ZAlbert··—Freeman1967-11-21—-·595-397-6960—587 WILLOW CTNASHVILLETN—N/AN/A
TPATPA-531352026-06-28T15:04:13Z Yang, Brandon——16-08-2002-N/A5734770055—6100 MAIN STREETNashvilleTN·37233N/A-
TPATPA-62637 2026-07-07T06:47:36ZDYLAN—JENSEN11/24/1967NULL—-null9643 Mountain View DrGlendale··AZ85311-—
TPATPA-617032026-08-24T08:46:48ZTERESAG.ELLIOTT··1938-11-27··—UNKNOWNN/A621 GRAND AVENUEGilbertAZ85259nullnull
TPATPA-598992026-08-22T05:35:14ZWillie—Myers13-07-1941-····NULLnull283 Lake View RdLas VegasNV89189GRP-5033CORE-HMO
TPATPA-545992026-03-04T20:58:07ZVincent—West1939-07-15UNKNOWN•••-••-3450—VINCENT.WEST87@GMAIL.COM5605 Desert Sky Blvd·AustinTX78735nullCHOICE-PLUS-PPO
14,474 rows, page 177 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:52.256Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty