speech_collection

`speech_collection`

SQL table: MASTER.SPEECH_COLLECTION One row per curated collection of speeches in the Factbase system. A collection groups speeches into a named, labelled set for presentation and navigation in the UI. Each collection carries a stable SPEECH_COLLECTION_ID primary key, a human-readable NAME and DESCRIPTION, and an EMOJI code for UI display. CATEGORY provides a broad classification of the collection type. Future placeholder FK columns NATION_ID, NATION_GROUP_ID, and ORGANISATION_ID are present for eventual linkage but are not joined in this version of the data model.

Joins

Name	Relationship
`speech_collection_speech`	one_to_many

Dimensions

Name	Type	Key	Description
`speech_collection_id`	string	✓	Master unique identifier.
`name`	string		Human-readable name.
`description`	string		Longer descriptive text.
`emoji`	string		Unicode emoji for the collection.
`category`	string		Broad classification (“national”, “thematic”).
`nation_id`	string		Placeholder FK to nation. Not yet joined.
`nation_group_id`	string		Placeholder FK to nation group. Not yet joined.
`organisation_id`	string		Placeholder FK to organisation. Not yet joined.

Measures

Name	Type	Description
`count`	count	Total number of speech collections.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

speech_collection