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-579382026-03-27T16:00:33Z·Kevin—Cole1961-02-14—•••-••-95744152227207kevin.cole@outlook.com2813 Market StEden PrairieMN55329—UNKNOWN
TPATPA-640312026-06-22T03:19:11ZMunoz, Linda——1982-00-17null•••-••-43842278087960····5984 Harbor Boulevard Apt 19COLUMBUSOH43261N/A-
TPATPA-517562026-06-20T22:48:14Zharold—west04/02/94—•••-••-7232405.579.5979—4445 Sage CourtSeattleWA··98162NULLMEDICARE-ADV-A
TPATPA-528762026-01-05T11:14:13ZEvelyn—·Kenndy2008-02-27———N/A2565 WILLOW COURTChandlerAZ85287—NULL
TPATPA-62932 2026-07-06T19:34:25Zgrace—perryOct 5, 1939·-—4417174547··5055 Washington StDallasTX··75215-—
TPATPA-559502026-03-16T19:20:41ZRichard—BoydAug 7, 2001··UNKNOWN•••-••-6752——1939 Willow CourtAustinTX··78742N/A—
TPATPA-59762 2026-07-21T18:00:03ZJacob—Wallace19690504N/A•••-••-4236NULL—-··—N/AN/AUNKNOWNnull
TPATPA-585912026-01-29T02:27:32ZSTEVEN—HOLMES1944-09-14UHC-82541-14•••-••-8071-··554 Bayshore DriveSan Diego···CA92185GRP-8046UNKNOWN
TPATPA-583122026-08-28T08:38:35ZMedina, Jacob——1968-08-23NULLN/A695.461.5616jacob.medina@hotmail.com8514 Park PlTempeAZ85243GRP-5090null
TPATPA-537812026-01-04T10:05:09ZAnn—Murphy17-11-1974—•••-••-5440—null4819 Church StCharlotteNC28266·-··
TPATPA-526752026-10-14T01:18:16ZDon—Luna1955-01-09——(268) 557-2026—8713 Main StreetScottsdaleAZ85205GRP-3194MEDICARE-ADV-B
TPATPA-617362026-09-29T06:39:31ZCarlosC.Sanchez2001-09-06UNKNOWN——-1565 JEFFERSON AVENUEEDEN PRAIRIEMN55301N/ACHOICE-PLUS-PPO
TPATPA-53316 2026-06-19T02:02:19ZThomas··—Mendoza1965-11-16··——N/AN/A-null·NULLnull—-
TPATPA-613852026-03-27T13:29:47ZBRADLEY—COX1951-01-18UHC-86083-56UNKNOWN—UNKNOWN4643 Harbor Blvd··DallasTexas75247-—
TPATPA-580532026-01-23T20:54:14Z·CAROLYN—ARNOLD19481011—•••-••-1738444-678-0495—9558 Union StreetHOUSTONTX77098—NAVIGATE-HMO
TPATPA-627272026-05-11T06:20:40ZRyan—Washington1986-04-02UHC-71334-44•••-••-86514432045515NULL7264 LINCOLN WAY Apt 7GlendaleAZ85361-MEDICARE-ADV-A
TPATPA-546562026-02-27T05:57:05Z McDonald, Fatima····—06/09/1941N/AnullN/Afatima.mcdonald96@icloud.com4487 WASHINGTON STLos AngelesCA90056—null
TPATPA-563932026-08-24T14:45:59ZDIEGO—BOYD2001-09-23——-—6612 Washington St··Columbusoh43294N/AN/A
TPATPA-625342026-08-21T00:40:01ZMeyer, Shirley——9/12/1976NULL•••-••-5366(266) 337-3260shirley.meyer73@gmail.com413 CEDAR LANESeattleWashington98187UNKNOWN—
TPATPA-589862026-05-11T03:35:14ZAmyE··Lynch2007-07-28—NULLNULL—6954 Highland AveChandlerAZ··85273N/Anull
TPATPA-608682026-02-25T17:14:24ZFox, DorothhyC—1960-10-15null——null6342 Willow CourtMinneapolisMN55430—UNKNOWN
TPATPA-526852026-05-25T06:49:53Zgregory—boyd1959-04-06N/A··-—9511 HARBOR BOULEVARDScottsdaleAZ85203UNKNOWNCORE-HMO
TPATPA-549672026-04-23T00:41:14Z·Amber—Young1990-08-06--2334042AMBER.YOUNG@HOTMAIL.COM5945 River RdNashvilleTN37218—-
TPATPA-551722026-07-16T23:32:51ZTYLER—WELCH19650301UHC-94529-67—3354203089-2593 Spring Street Apt 26GilbertArizona85256UNKNOWNNULL··
TPATPA-636932026-03-04T00:40:29ZMICHELE··PHILLIPSOct 1, 1946N/AUNKNOWN-UNKNOWN4100 Lake View RdMiamiFL33148GRP-6668NAVIGATE-HMO
TPATPA-515792026-04-17T23:26:05ZWells, Tony—····1940-09-03—····882-784-2929··UNKNOWN6559 Mesa DrGilbertAZ85272nullCHOICE-PLUS-PPO
TPATPA-62934 2026-10-02T19:54:40ZGibson, Allice——1952-08-03NULL•••-••-3581·(956) 956-5704UNKNOWN3399 PALM DRIVELos AngelesCA90062--
TPATPA-527532026-06-17T02:37:02ZGLORIA—CARRLL1962-06-15NULLN/A374-442-5197GLORIA.CARROLL@GMAIL.COM731 WASHINGTON STDenverCO80227-2131—CHOICE-PLUS-PPO
TPATPA-606632026-06-14T05:48:33ZAlexysA·Washington1988-02-18nullN/A—-null——NULLNULLnull
TPATPA-600252026-02-18T01:22:36ZWilliamOKelly2007-10-22UHC-90416-44··•••-••-3207UNKNOWN·-1416 Jefferson AvenueGILBERTAZ85216··—NULL
TPATPA-505722026-04-02T10:47:12ZHayes, Amy——1953-06-10NULL-UNKNOWN—8700 MAPLE AVEAtlantaGA30392GRP-7825UNKNOWN··
TPATPA-593202026-02-01T17:58:04ZROY—FOWLER2002-09-28—null(459) 921-7744··NULL6743 Apache BoulevardAUSTINTX78779UNKNOWN··—
TPATPA-580952026-05-05T12:01:35ZLarson, Philip——1953-11-19—NULLN/AN/A5533 Market StreetTucsonAZ85703-NULL
TPATPA-506872026-09-03T09:17:17ZRichard—Stewart1997-01-27·N/AUNKNOWN--524 MOUNTAIN VIEW DRMIAMIFL33106NULLnull
TPATPA-517502026-09-23T06:54:51Z DIEGO—WASHINGTON19451112UNKNOWNN/A——7030 Willow CourtSan DiegoCA92111GRP-7981··null
TPATPA-520682026-08-01T17:52:43ZANN—COOK1/18/2002UHC9667977—4052881246UNKNOWN6761 PARK PLACEFresnoCA93746-MEDICARE-ADV-A
TPATPA-527452026-09-29T05:18:39ZArjun—Wang11/17/1953N/A•••-••-9060N/AN/A8871 Lincoln WayLas VegasNevada·89161·GRP-9435CORE-HMO
TPATPA-620292026-10-02T07:29:23ZCARLOS—LANE05/06/2005UNKNOWN··--N/A8291 Desert Sky BoulevardNashvilleTN37244—-··
TPATPA-594392026-07-27T02:33:24ZStewart, GloriaM—28-03-1979·NULL·null····—7869 Indian School RoadJacksonvilleFL32200GRP-3680—
TPATPA-543282026-07-05T20:00:52ZScott—Hart1962-04-02UHC-39979-07•••-••-9045N/ANULL7942 Oak StMiamiFL-UNKNOWNMEDICARE-ADV-B
TPATPA-531332026-09-29T12:40:24ZNicholas—·Gibson—UNKNOWN•••-••-1300NULLnull6030 Camelback RdMinneapolisMN55489——
TPA TPA-544252026-08-06T21:22:54Zrebecca—schultz1952-02-20UHC-71809-10null+1 342 879 9932—765 Sunset Boulevard Apt 26Planotx75033N/ACHOICE-PLUS-PPO··
TPATPA-628472026-10-16T12:23:58ZLauren····Silav1946-07-01NULLNULL——7322 Ocean AvenuePhoenix·AZ85099GRP-3565NULL
TPATPA-501282026-01-21T03:11:33ZDennis—Moore1951-10-02UHC-79281-29N/A··—NULL75 MAIN STREETTempeAZ85276·GRP-2668NULL
TPATPA-619512026-01-09T17:22:48ZDEBBIE—OBRIEN1991-02-05NULL··•••-••-1467494-847-7432DEBORAH.OBRIEN@YAHOO.COM6867 MAIN STREETLos AngelesCA-nullN/A
TPATPA-577912026-02-01T00:00:57ZWILLIE—REYNOLDSnull··—•••-••-21282803612670NULL5688 Ridge RdCharlotteNorth Carolina28293GRP-3993null
TPATPA-616862026-02-01T03:56:20ZPadilla, KaylaD.—1955-05-11-——KAYLA.PADILLA81@AOL.COM8441 Church StreetDALLASTX75258—OPTIONS-PPO
TPATPA-616532026-07-04T06:49:13Z John—Padilla1991-03-22·UNKNOWN•••-••-9802——6058 Ocean AveTUCSON··AZ85798—CHOICE-PLUS-PPO
TPATPA-602872026-02-11T07:24:57ZBRANDON—HALL1997-08-11null—UNKNOWNN/A1192 Union StreetChandlerAZ85280—UNKNOWN
TPATPA-546652026-04-26T15:59:16ZSandra—Murphy09/11/1964UNKNOWN•••-••-6561null-6365 Highland AveSAN ANTONIOTX78229—N/A
14,474 rows, page 74 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:40.359Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty