nation_capability_rating

`nation_capability_rating`

SQL table: MASTER.NATION_CAPABILITY_RATING Fact table of capability ratings for each nation, per period (year). Each row represents the assessed rating of a single capability for a single nation in a single year, combining a final human-reviewed score with the full distribution of underlying expert responses. Fields cover four assessment dimensions: the capability score (current performance), the outlook score (expected trajectory), the importance score (strategic relevance), and Pareto positioning (cross-capability dominance ranking).

Joins

Name	Relationship
`nation`	many_to_one
`capability`	many_to_one
`rubric_stem_capability_rating`	many_to_one
`rubric_stem_outlook_rating`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Surrogate primary key — nation_id + capability_id + period.
`nation_id`	string		Foreign key to the nation table.
`capability_id`	string		Foreign key to the capability table.
`period`	number		The year this capability assessment covers.
`capability_score`	number		Final human-reviewed capability score.
`capability_score_average`	number		Average of all individual expert scores before final human review.
`capability_score_stddev`	number		Standard deviation of expert scores.
`capability_score_consensus`	number		Consensus score in the range 0–1.
`capability_score_percentile`	number		Percentile relative to peer nations.
`capability_score_rank`	number		Olympic/equal rank among peers.
`capability_score_min`	number		Lowest individual score submitted.
`capability_score_max`	number		Highest individual score submitted.
`capability_score_top_quartile`	number		75th percentile of expert scores.
`capability_score_bottom_quartile`	number		25th percentile of expert scores.
`capability_rating`	string		Final categorical rating (AAA → F scale).
`capability_rating_rationale_short`	string		Short-form rationale (100–200 words).
`capability_rating_rationale_long`	string		Long-form rationale.
`capability_pareto_tier`	number		Pareto domination tier.
`capability_pareto_rank`	number		Equal rank within Pareto tier.
`capability_pareto_percentile`	number		Percentile version of the Pareto rank.
`capability_pareto_profile`	string		Qualitative label: Specialised, Balanced, or Asymmetric.
`capability_outlook_score`	number		Final outlook score: −1, 0, or +1.
`capability_outlook_score_average`	number		Average expert outlook score.
`capability_outlook_score_stddev`	number		Std dev of expert outlook scores.
`capability_outlook_score_consensus`	number		Consensus score for outlook (0–1).
`capability_outlook_score_average_rank`	number		Rank based on outlook score average.
`capability_outlook_score_average_percentile`	number		Percentile of outlook score average.
`capability_outlook_score_min`	number		Lowest individual outlook score.
`capability_outlook_score_max`	number		Highest individual outlook score.
`capability_outlook_score_top_quartile`	number		Q3 of expert outlook scores.
`capability_outlook_score_bottom_quartile`	number		Q1 of expert outlook scores.
`capability_outlook_rating`	string		Outlook: Positive, Stable, or Negative.
`capability_outlook_rationale_short`	string		Short outlook rationale.
`capability_outlook_rationale_long`	string		Long outlook rationale.
`capability_outlook_upwards_trigger_short`	string		Short upward-trigger summary.
`capability_outlook_upwards_trigger_long`	string		Long upward-trigger description.
`capability_outlook_downwards_trigger_short`	string		Short downward-trigger summary.
`capability_outlook_downwards_trigger_long`	string		Long downward-trigger description.
`capability_importance_score`	number		Final human-reviewed importance score.
`capability_importance_score_avg`	number		Average expert importance score.
`capability_importance_score_stddev`	number		Std dev of expert importance scores.
`capability_importance_score_consensus`	number		Importance consensus score.
`capability_importance_percentile`	number		Percentile of importance score.
`capability_importance_rank`	number		Rank based on importance score.
`capability_importance_score_min`	number		Lowest expert importance score.
`capability_importance_score_max`	number		Highest expert importance score.
`capability_importance_rating`	string		Final categorical importance rating.
`capability_importance_justification_short`	string		Short importance justification.
`capability_importance_justification_long`	string		Long importance justification.
`capability_rating_area`	string		Grouped rating area (Advanced, Developed, Intermediate, Foundation, Emerging, Planning).
`capability_rating_sort_order`	number		Numeric sort key for capability_rating.

Measures

Name	Type	Description
`count`	count	Number of nation capability rating records.
`total_response_count`	sum	Total number of individual expert responses.
`avg_response_count`	avg	Average number of expert responses per record.
`avg_capability_score`	avg	Average final capability score.
`avg_capability_score_average`	avg	Average of pre-review expert score averages.
`avg_capability_score_consensus`	avg	Average expert consensus (0–1).
`avg_capability_score_percentile`	avg	Average percentile rank.
`avg_capability_importance_score`	avg	Average importance score.
`avg_capability_importance_score_avg`	avg	Average of pre-review importance score averages.
`avg_capability_importance_score_consensus`	avg	Average importance consensus.
`avg_capability_outlook_score`	avg	Average outlook score.
`avg_capability_outlook_score_average`	avg	Average of pre-review outlook score averages.
`avg_capability_outlook_score_consensus`	avg	Average outlook consensus.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

nation_capability_rating