speech_collection_speech

`speech_collection_speech`

SQL table: MASTER.SPEECH_COLLECTION_SPEECH Junction table linking speeches to the speech collections they belong to. Each row represents a single membership — one speech in one collection. Used as the bridge in the many-to-many relationship between speech and speech_collection (a speech may appear in multiple collections, and a collection contains many speeches).

Joins

Name	Relationship
`speech`	many_to_one
`speech_collection`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Surrogate primary key — speech_collection_id + speech_id.
`speech_id`	string		Foreign key to the speech.
`speech_collection_id`	string		Foreign key to the speech collection.

Measures

Name	Type	Description
`count`	count	Number of membership records.
`count_distinct_speeches`	count_distinct	Number of distinct speeches across the selected collections.
`count_distinct_collections`	count_distinct	Number of distinct collections a speech belongs to.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

speech_collection_speech

`speech_collection_speech`

Joins

Dimensions

Measures

​speech_collection_speech

​Joins

​Dimensions

​Measures

`speech_collection_speech`

Joins

Dimensions

Measures