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-615272026-10-12T03:01:43ZNatalie—OBrienJul 27, 1969null—null··--—N/A—GRP-9566NAVIGATE-HMO
TPATPA-566442026-04-18T02:21:07ZMariana—Robertson08/20/2004null•••-••-0050nullNULL5340 DESERT SKY BOULEVARDDenver··Colorado80211-··-
TPATPA-593662026-07-15T16:38:34ZAmanda—Hall2005-05-01—UNKNOWNN/Anull9017 CHURCH STMesaAZ85215null—
TPATPA-593142026-05-18T10:57:20ZAmy—Romero1975-11-21null•••-••-2124-N/A4627 Baseline RdPlanoTX75062-MEDICARE-ADV-B
TPATPA-635242026-08-08T19:01:26ZMark—SimpsnMar 2, 1942null··—N/A—3103 Park PlaceFresnoca93717GRP-6032UNKNOWN
TPATPA-633972026-08-06T00:12:24ZNATALIE—MYERS1963-07-27N/A—NULLN/A3976 Forest AvenueLos AngelesCalifornia90030··GRP-4970MEDICARE-ADV-B
TPATPA-555572026-03-23T13:52:22ZWilliam—·Hansen1981-06-28NULLnull(541) 678-3114·william.hansen83@gmail.com2079 Jefferson AveAustinTexas·UNKNOWN—SELECT-EPO
TPATPA-538492026-02-06T18:13:31ZBell, Andrea—··2007-01-24—•••-••-5393——4106 BASELINE ROADAustinTX78713NULLnull
TPATPA-550582026-04-03T08:13:52ZMADISON—WHITE·1993-09-10-··—MADISON.WHITE56@HOTMAIL.COM6260 Church StAtlantaGA30360nullCORE-HMO
TPATPA-601812026-07-23T16:27:50Z KATHERINE—ROSE01-04-1973UNKNOWNN/A——2876 Oak StreetDenverCO80221GRP-0259N/A
TPATPA-564042026-03-07T21:18:40ZJOSE—OWENS1987-02-07—UNKNOWN(898) 694-6609-··—N/A——nullMEDICARE-ADV-A
TPATPA-588892026-06-20T23:15:03ZMaria—GonzalesMay 5, 1966UNKNOWN•••-••-0947UNKNOWNUNKNOWN—nullN/AN/A·GRP-5290null
TPATPA-565392026-07-15T21:33:31ZGrace—Coleman1953-12-14····•••-••-3676-null3475 UNION STREETAustinTX78707UNKNOWNN/A
TPATPA-51510 2026-02-05T05:32:07ZSharon—Boyd1957-07-20—•••-••-5720UNKNOWNsharon.boyd@outlook.com4822 Camelback RdMinneapolisMN55471—SELECT-EPO
TPA TPA-509862026-08-26T09:18:02ZJoshua—Hernandez·02-01-2006·null———8353 Sage CourtScottsdaleAZ85285GRP-8420—
TPATPA-527072026-06-16T12:08:43ZCatherine—Diaz2002-04-23null—UNKNOWNCATHERINE.DIAZ@YAHOO.COM8471 Union StreetGlendaleAZ85377nullN/A··
TPATPA-504552026-04-10T02:07:53ZRalph—Vargas·06/27/1969N/A—UNKNOWNUNKNOWN5769 CEDAR LNTEMPEAZ85279UNKNOWNNAVIGATE-HMO
TPATPA-574312026-02-02T09:29:16ZTerrry—RichardsonJul 4, 1984NULL—UNKNOWNnull·921 Main St #693ChandlerAZ85220null··SELECT-EPO
TPATPA-602482026-05-27T00:58:34ZROBERTP.MOOORE1975-11-08UNKNOWNN/A+1 235 472 9736—3363 Meadow Ln··TUCSONArizona85725-6899—UNKNOWN
TPATPA-611742026-07-26T12:45:36Zcharles—mccoy1959-02-27N/A-—N/A7434 Maple AveDenverCO80271GRP-3675-
TPA TPA-594032026-07-08T08:16:27ZPaul—Stone11/3/1957——(247) 392-7138—··—-··GRP-0378choice-plus-ppo
TPATPA-584252026-09-03T12:25:15Zkatherine—perry1973-08-28—-—katherine.perry64@hotmail.com9316 SAGE CTTampaFL33668-7709NULLNULL
TPATPA-635762026-08-13T07:05:04ZHiroshi··G.Wright12-12-1959····——-2169 Main Street Apt 32CHANDLER·AZ85272NULLCORE-HMO
TPATPA-622852026-08-06T07:55:36ZJACK—MOOREJul 22, 1967—NULL(263) 949-0973jack.moore41@proton.meUNKNOWNN/Anull—nullN/A
TPATPA-508662026-03-05T14:13:24ZANNA··—SHAW1956-08-26null—(507) 441-5820-··8585 Desert Sky BlvdSan AntonioTX-GRP-1713·OPTIONS-PPO
TPATPA-537462026-03-10T18:12:47ZMateoPHill07/15/1970——18406903357—2581 ELM ST··EDEN PRAIRIEMinnesota55315GRP-6607UNKNOWN
TPATPA-545232026-01-14T18:41:29ZGEORGE—KING04/06/43N/A··—-N/A3734 GRAND AVENUE Apt 30DenverCO80218nullMEDICARE-ADV-A
TPA TPA-574392026-07-30T23:43:04ZRalph—Vega5/4/1993——-UNKNOWN·627 Ridge RoadPHOENIXAZ85094-8887——
TPATPA-583192026-07-30T03:04:50ZRichard—Hicks02/15/1987—-—·N/A6440 River RdEDEN PRAIRIEMinnesota55321-0681N/ANULL
TPATPA-578352026-08-09T02:21:33ZBryan—Simmons11/10/1947UNKNOWN—(552) 793-8839NULL67 BAYSHORE DRAtlantaGeorgia30364GRP-6405MEDICARE-ADV-A
TPATPA-616552026-01-16T04:41:01ZShirley—Soto9/15/1948UHC-96595-31•••-••-7381(327) 421-1075·shirley.soto@icloud.com6577 Baseline Rd Apt 20NashvilleTN37217N/AMEDICARE-ADV-B
TPATPA-553212026-08-01T23:51:39ZKYLE—HARVEY1976-10-27nullUNKNOWN--4135 SAGE CTSan DiegoCA92196GRP-2967·MEDICARE-ADV-A
TPATPA-583792026-07-17T15:21:24ZBanes, Arjun——11/01/00UNKNOWNnull2452113NULL8922 MOUNTAIN VIEW DRScottsdaleAZ85218GRP-7852NAVIGATE-HMO
TPATPA-610572026-06-11T07:01:19ZROGERS—RUSZELL10/26/89NULL•••-••-0997(422) 761-1220—2184 Grand Avenue #413NashvilleTN37248GRP-2995··
TPATPA-507322026-08-22T13:53:44Zsamantha—edwards2001-03-22null——N/A1248 Market StreetCharlotteNC28230-OPTIONS-PPO
TPATPA-601842026-05-15T06:42:16ZKelly—Lucas12/15/1947UHC-15635-05•••-••-46176199014927—6413 Meadow LnSeattle··WA98118GRP-0972NULL··
TPATPA-550752026-01-16T00:09:35Z·Lawrence—Mills1946-01-24—•••-••-9583N/Alawrence.mills@hotmail.com··1067 JEFFERSON AVESeattleWA98195N/A—
TPATPA-569062026-07-16T19:05:56Zlogan—chen1944-07-27UHC-52351-70-(940) 776-9360LOGAN.CHEN@ICLOUD.COM3272 Forest AvenueDallasTX75288——
TPATPA-617112026-08-31T12:54:33ZAmandaUMcDonald09/28/1961-•••-••-8659—NULL6337 Apache BlvdMIAMIFlorida33178··GRP-3919—
TPATPA-543692026-08-07T16:19:53ZNicoole—Hayse04/16/39uhc-32516-68—717-872-0107··695 Apache BoulevardPlanotx75090-—
TPATPA-548152026-04-29T13:49:34ZKeith—Palmer1984-02-21null—6806927523—7266 Meadow LaneCOLUMBUSOH43211N/A—
TPATPA-586122026-01-06T01:34:19Zzachary··evans9/27/1988nullNULL14344142493UNKNOWN724 Forest AvenueScottsdaleAZ85265GRP-7811null
TPATPA-634152026-04-01T10:36:05ZGREGORY—·BOWMAN16-04-1982NULLN/A(207) 686-8116gregory.bowman61@outlook.com-—····null··GRP-2057-
TPATPA-620722026-03-14T07:44:54ZBRIAN··JACOBS2001-11-04NULL•••-••-1828+1 424 574 5244null——··-UNKNOWNMEDICARE-ADV-A
TPATPA-507572026-07-21T01:57:03ZCatherine—Graham08-02-1947N/ANULLUNKNOWN—3532 Lincoln WaySAN DIEGOCalifornia92104··GRP-7269OPTIONS-PPO
TPATPA-626722026-05-30T18:22:10Z Lawrence—Little04-09-1939UHC-25242-06•••-••-4325—-8794 Harbor BlvdPhoenixAZ··85094N/A·UNKNOWN
TPATPA-602452026-04-14T01:42:00ZRICHARD—HANSEN··1959-10-08NULLNULL···3505892402··—nullUNKNOWNNULLUNKNOWN—
TPATPA-627202026-06-17T17:44:21ZFox, Rebecca——·12/04/00UHC-05601-41•••-••-81694408713521——N/A—NULL-NULL
TPATPA-629862026-07-22T08:32:00ZMadison—GrahamFeb 25, 1948N/A•••-••-5512N/A——NULL—NULLGRP-2699CORE-HMO
TPATPA-512162026-08-02T03:37:53Z·Egene—Espinoza1945-12-11N/AUNKNOWNN/A—4711 Mountain View DriveHOUSTONTX77081—NULL
14,474 rows, page 108 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:43.612Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty