speech

`speech`

SQL table: MASTER.SPEECH One row per speech in the Factbase system. Speeches are transcribed or recorded public addresses delivered by a known person (linked via PERSON_ID). Each speech carries a stable SPEECH_ID primary key and a human-readable SPEECH_SLUG for public URLs. Core metadata covers the title (native language and English), event name, event location (nation ISO3, city, venue), the speaker’s title and organisational affiliation at the time of delivery, and the nation the speech represents. Temporal fields include an exact DATE, a numeric YEAR, and a century bucket (C18–C21). Full body is stored in SPEECH_BODY and SPEECH_BODY_EN. Quantitative fields include WORD_COUNT, SENTENCE_COUNT, DURATION_SECONDS, READABILITY_SCORE, GRADE_LEVEL_SCORE, SYNTAX_SCORE, and VOCABULARY_SCORE.

Joins

Name	Relationship
`person`	many_to_one
`speech_nation`	many_to_one
`event_location_nation`	many_to_one
`speech_collection_speech`	one_to_many

Dimensions

Name	Type	Key	Description
`speech_id`	string	✓	Master unique identifier. Always use speech_id (not speech_slug) as a key.
`speech_slug`	string		URL-friendly presentation string. Display only.
`person_id`	string		Master person identifier — FK to MASTER.PERSON. Use for joins/GROUP BY speaker.
`person_slug`	string		URL-friendly speaker string. Display only.
`person_title_at_speech`	string		Speaker’s formal title at time of delivery.
`person_affiliation_at_speech`	string		Speaker’s organisational affiliation at time of delivery.
`title`	string		Speech title in original language.
`title_en`	string		Speech title in English.
`event`	string		Event name in original language.
`event_en`	string		Event name in English.
`speech_nation_id`	string		ISO3 country code the speech represents.
`event_location_nation_id`	string		ISO3 country code where the speech was physically delivered.
`event_location_city`	string		City where the speech was delivered.
`event_location_venue`	string		Specific venue.
`date`	time		Exact date the speech was delivered.
`year`	number		Four-digit delivery year.
`century`	string		Century bucket (C18–C21).
`language`	string		ISO 639-1 language code of the speech body.
`is_translated`	boolean		Whether the speech was translated into English.
`translated_by`	string		Translation system/model identifier.
`speech_body`	string		Full text in original language.
`speech_body_en`	string		Full text in English.
`context`	string		Contextual summary.
`main_themes`	string		Extracted key themes.
`word_count`	number		Total number of words.
`sentence_count`	number		Total number of sentences.
`duration_seconds`	number		Estimated or actual spoken duration.
`readability_score`	number		Flesch–Kincaid readability score.
`grade_level_score`	number		Flesch–Kincaid grade level.
`syntax_score`	number		Syntactic complexity score.
`vocabulary_score`	number		Lexical richness / vocabulary diversity score.

Measures

Name	Type	Description
`count`	count	Total number of speech records.
`distinct_speeches`	count_distinct	Count of distinct speeches.
`distinct_speakers`	count_distinct	Count of distinct persons who have delivered at least one speech.
`total_word_count`	sum	Total words across all speeches.
`avg_word_count`	avg	Average number of words per speech.
`total_duration_seconds`	sum	Total spoken duration in seconds.
`avg_duration_seconds`	avg	Average spoken duration per speech.
`total_sentence_count`	sum	Total sentence count.
`avg_sentence_count`	avg	Average sentences per speech.
`avg_readability_score`	avg	Average Flesch–Kincaid readability.
`avg_grade_level_score`	avg	Average Flesch–Kincaid grade level.
`avg_syntax_score`	avg	Average syntactic complexity score.
`avg_vocabulary_score`	avg	Average vocabulary diversity score.
`count_c18`	count	Number of speeches from the 18th century.
`count_c19`	count	Number of speeches from the 19th century.
`count_c20`	count	Number of speeches from the 20th century.
`count_c21`	count	Number of speeches from the 21st century.
`min_readability_score`	min	Minimum readability.
`max_readability_score`	max	Maximum readability.
`min_grade_level_score`	min	Minimum grade level.
`max_grade_level_score`	max	Maximum grade level.
`min_syntax_score`	min	Minimum syntactic complexity.
`max_syntax_score`	max	Maximum syntactic complexity.
`min_vocabulary_score`	min	Minimum vocabulary diversity.
`max_vocabulary_score`	max	Maximum vocabulary diversity.

Pre-aggregations

count_by_person — speaker leaderboard.
scores_by_year — time-series score queries at year grain.
scores_by_year_nation — geographic score breakdowns.
scores_by_year_person — per-person score trends.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

`speech`

Joins

Dimensions

Measures

Pre-aggregations

​speech

​Joins

​Dimensions

​Measures

​Pre-aggregations

`speech`

Joins

Dimensions

Measures

Pre-aggregations