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-519232026-05-19T05:17:41ZGREGORY—JENSEN·20050816-—(608) 858-6740null3096 Pine DrSCOTTSDALE·AZ85285····null
TPATPA-511962026-04-29T06:16:43ZTIMOTHY—VARGAS09/02/1956N/A··—-—3151 PALM DRIVEGlendaleAZUNKNOWN-select-epo··
TPATPA-61840 2026-02-12T22:17:05Z—U—9/19/1963UHC-41493-30•••-••-8168+1 442 933 8171—832 CANYON ROADJacksonvilleFL··32255GRP-2153—
TPATPA-556482026-05-16T21:23:53ZRyan—Grant1989-09-27UHC-15044-36NULL740-436-3040—6174 Valley View DriveTucsonAZ85708-5407GRP-4283-
TPATPA-610522026-01-08T11:49:05ZRios, David——1995-08-18··UHC-78651-32—UNKNOWNNULL·1708 CAMELBACK ROADSan AntonioTX78266GRP-6460—
TPATPA-504212026-05-05T17:54:47Z SantiagoJReid1991-05-21NULL—UNKNOWN—8160 Willow CourtSACRAMENTOCA95874—SELECT-EPO
TPATPA-584162026-09-22T19:59:49ZHoffman, Mark··——19931018UNKNOWN—NULLMARK.HOFFMAN@OUTLOOK.COM7240 Union StreetNashville·TN37228N/ACORE-HMO
TPATPA-64093 2026-06-25T18:17:55ZPatrick—Jenkins4/22/1987N/A—····N/A975 Valley View DrJacksonvilleFlorida32234GRP-8889OPTIONS-PPO
TPATPA-627382026-08-15T22:40:32ZFRANCES—RILEY··1976-07-17UHC-22768-51•••-••-719112866262654null2157 MAPLE AVENUENashvilleTN37251UNKNOWNN/A
TPATPA-516912026-03-05T16:32:58ZGeorge··Reid19950128null—(351) 523-1738GEORGE.REID62@AOL.COM3403 Indian School RdAtlantaGA30365GRP-0719null
TPATPA-593372026-04-22T22:10:25ZSTEPHEN—PENA1993-04-03null•••-••-82706589992950stephen.pena31@proton.meN/AUNKNOWN··NULL··—GRP-5030····
TPATPA-524022026-10-11T05:59:05ZJessica··Alexander06/17/1973N/A-UNKNOWNN/A5403 JEFFERSON AVEPHOENIXAZ—GRP-3858—
TPATPA-528092026-07-02T14:32:47ZHawkins, Brian——1978-08-10NULL•••-••-2922(657) 361-2030brian.hawkins@aol.com1350 Sage CtTUCSONAZ85783-N/A
TPATPA-626512026-08-18T04:20:14ZVALENTINA—·SCOTT19831026null—nullN/A6070 Elm StGilbertAZ85220N/AUNKNOWN
TPATPA-528282026-06-16T16:17:13ZAbigail—VazquezJul 1, 1966—-—·N/A—NULL—nullnullUNKNOWN
TPATPA-615752026-02-09T00:25:48ZKyle—Lawrence1997-10-11UNKNOWNN/A—UNKNOWN6147 LINCOLN WAYFRESNOCAN/AGRP-2082NULL
TPATPA-505752026-09-03T23:06:54ZANDREW—FIELDS1995-03-23UHC-34165-43nullNULLUNKNOWNnull—-—-null
TPATPA-627632026-02-16T06:50:04ZALEXANDER—REID1796-07-20UHC-22695-59NULLNULL····5107 Lake View Rd #452Plano·TX75027GRP-1677UNKNOWN
TPATPA-509782026-09-23T15:07:44ZERIC—BARNES1962-01-02—•••-••-33384925171926··N/Anull—UNKNOWN——
TPATPA-568652026-06-15T22:30:38Z sharon—hanson1981-04-25-•••-••-7974640-879-6522UNKNOWN5577 Canyon RdJacksonvilleFL32204—N/A
TPATPA-525242026-07-26T09:39:33ZLUIS—RICHARDSON6/10/1990NULL•••-••-99837752384—7253 Elm StreetLos AngelesCA90080GRP-3579-
TPATPA-502602026-05-23T15:58:10ZKatherine—Sanders··1987-01-25uhc-96221-61N/A-null7744 Sage CtLos AngelesCA90044N/ACORE-HMO
TPATPA-610142026-07-14T17:56:04ZAARON—MEDYNA07/02/1965——761-809-7513—2075 Baseline RdORLANDOFlorida32824GRP-1909—
TPATPA-510192026-07-28T08:20:08Zmei······robinson19850121··—•••-••-70609764485448—197 Hillcrest RoadGILBERTAZ85216—NULL
TPATPA-632162026-07-29T13:55:41Z Danielle—Young09/22/2004-NULL(979) 819-8386UNKNOWN5918 Baseline RoadSacramentoCA95811nullUNKNOWN
TPATPA-527022026-04-28T17:19:01ZSTEPHEN—MALDONADO16-06-1941nullN/ANULLN/A5247 Hillcrest Road··SACRAMENTOCA95839GRP-1871—
TPATPA-618422026-06-18T15:30:35Zrebecca—stevens08/09/40UNKNOWN•••-••-5287(234) 365-6742N/A—-null——UNKNOWN
TPATPA-630942026-07-12T06:08:12Zjanice—willis1943-09-05N/A—-—UNKNOWN··N/A··NULLnullGRP-8664SELECT-EPO
TPATPA-584042026-09-07T22:18:40ZSANDRAGWHITE·1941-03-24UNKNOWNUNKNOWN—sandra.white9@icloud.comN/A··N/A-—GRP-5611NULL
TPATPA-585452026-02-19T10:26:20ZKEVIN—NICHOLS1968-11-21UHC-94153-38——N/A4859 UNION STREETAustin···TXNULL——
TPATPA-600392026-05-22T05:49:55ZLogan····Richards19750513—•••-••-5338NULLLOGAN.RICHARDS@YAHOO.COM-——nullN/A-
TPATPA-556722026-08-17T00:11:37ZAmy·····Dominguez3/19/1976UHC-21901-22-2472935550-NULLUNKNOWN——-N/A
TPATPA-569582026-02-04T00:11:13ZSimpson, Aaron——·2005-05-22UNKNOWN·N/A6439817281—659 Washington StreetMiami··FL33175NULL·-
TPATPA-629732026-03-07T14:38:55ZDOUGLAS—RODRIGUEZOct 5, 1981NULL•••-••-0481NULL—9676 BROADWAYCHANDLERAZ85298GRP-1088CHOICE-PLUS-PPO
TPATPA-568452026-08-17T00:14:11ZLGOAN··LAWSONnullUHC-11101-95•••-••-14232836807393—9216 Mesa DriveAtlantaga30313GRP-9081N/A
TPATPA-530692026-09-18T23:04:42ZDONNA—PADILLA10/28/1951NULL—7322627317null6322 Bayshore DriveSacramentoCA95875NULLCORE-HMO
TPATPA-641642026-09-09T14:32:36ZNICK—MENDOZA5/4/1994UHC-42778-02··-532.277.8630NULL3558 Washington StreetEDEN PRAIRIEMN··55317nullMEDICARE-ADV-A··
TPATPA-641132026-08-17T18:48:27ZGABRIEL—HILL1971-05-22NULLNULL——5941 PINE DRIVENashvilleTN37221··—····
TPATPA-584732026-01-31T13:32:56ZLisa——1791-02-11-NULLNULLlisa.guerrero@icloud.com8703 Sunset Boulevard·PhoenixAZ85067-4599UNKNOWNMEDICARE-ADV-A
TPATPA-509702026-09-08T22:21:08ZBRUCE····FISHER1991-10-14—N/ANULLbruce.fisher@hotmail.com1939 Pine Dr··CharlotteNorth Carolina28268—MEDICARE-ADV-B··
TPATPA-511882026-06-27T09:31:43ZLinda····Oliver1983-11-25·-N/AUNKNOWN—1038 SUNSET BLVDEden Prairiemn55375-SELECT-EPO
TPATPA-574132026-02-04T17:34:13ZMatthew—Watkins2008-03-02NULL•••-••-9102976-473-4077matthew.watkins45@aol.com8347 River RdPlanoTX··75008GRP-5868NAVIGATE-HMO
TPATPA-577982026-10-18T15:24:06ZDanielle—·Fergusno1946-04-19—•••-••-0759467-483-3827danielle.ferguson@yahoo.com3567 Elm StSan AntonioTX78209N/A-
TPATPA-618602026-08-29T06:05:15ZJanet····Le1964-08-14UHC-70945-49-(964) 700-8385N/A1029 Oak St Apt 22TucsonAZ85713GRP-4968—
TPATPA-50397 2026-07-30T00:13:35Zjuile··webb1951-02-14——-julie.webb31@outlook.com3557 Palm DriveEden PrairieMN··55331GRP-8922—
TPATPA-538802026-07-27T08:53:09ZLAWRENCE—GUTIERREZ19431213nullNULL··lawrence.gutierrez@aol.com3482 Jefferson AveColumbusOH43268GRP-6656··
TPATPA-601192026-10-06T02:27:43ZChristineNGraham19550524—N/A(659) 803-0812christine.graham39@proton.me1820 Mesa DriveDENVERCO80298—NULL
TPATPA-583162026-02-25T11:33:10ZElizabethJTucker1979-09-08nullNULL——7486 Palm DrSacramentoCA95869UNKNOWN—
TPATPA-556902026-07-27T20:23:20ZHarper, John——2004-01-19··null•••-••-6699NULL—7402 Ocean AvenueAtlantaGA30389-3961—-
TPATPA-514722026-07-21T00:05:29ZBrian—Castillo1966-06-21——350-782-4371UNKNOWN5969 Willow CourtAustinTX78750——
14,474 rows, page 135 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:46.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty