Dataset: Scorecard data (all)
Processed and raw data for the 2022 Council Climate ScorecardsContributors
Sources
Licences
Individual tables
- Authority scores - For each authority, percentage score for each section and the overall weighted total.
- Individual answers - The scored value for each question for each authority. If a Council had no plan publicly available then all boxes are blank.
- Questions list - List of questions used, and the allowed values and scores
- Section labels and weights - Mapping of short section IDs to long labels, and the weighting used in the overall score
- Section Scores - By authority, the scores received for each section and the total possible for that authority type.
Table: Authority scores
Description: For each authority, percentage score for each section and the overall weighted total.
Data description
| Column name | Data type | Description | Unique | Required values |
|---|---|---|---|---|
| official-name | string | Long form name of local authority | Yes | |
| local-authority-code | string | Three letter code of local authority | Yes | |
| s1_gov | integer | Rounded percentage score for 'Governance, development and funding' | No | |
| s2_m&a | integer | Rounded percentage score for 'Mitigation and adaptation' | No | |
| s3_c&a | integer | Rounded percentage score for 'Commitment and intergration' | No | |
| s4_coms | integer | Rounded percentage score for 'Community, engagement and communications' | No | |
| s5_mset | integer | Rounded percentage score for 'Measuring and setting emissions targets' | No | |
| s6_cb | integer | Rounded percentage score for 'Co-benefits' | No | |
| s7_dsi | integer | Rounded percentage score for 'Diversity and inclusion' | No | |
| s8_est | integer | Rounded percentage score for 'Education, skills and training' | No | |
| s9_ee | integer | Rounded percentage score for 'Ecological emergency' | No | |
| weighted_total | integer | Rounded percentage overall score for authority (with weighting applied by section) | No | |
| local-authority-type-name | string | The type of local authority | No | |
| council-quintile | number | Local authorities average IMD deprivation grouped into five deciles (1 is most deprived, 5 is least deprived) | No | |
| pop_bucket | string | Local authorities grouped into different population sizes | No | |
| region | string | Nation or region of UK the local authority is in | No | |
| ruc_cluster | string | Urban/Rural nature of the local authority | No | |
| political_control | string | Political control at the time the plans were scored | No | |
| group | string | Scorecard group (used for comparison purposes) | No |
Table: Individual answers
Description: The scored value for each question for each authority. If a Council had no plan publicly available then all boxes are blank.
Data description
| Column name | Data type | Description | Unique | Required values |
|---|---|---|---|---|
| answer_id | string | Unique ID for an answer to a question by an authority | Yes | |
| local-authority-code | string | 3 letter code for local authority | No | |
| question_id | string | ID for question | No | |
| audited_answer | string | The result assigned to the question by the marker | No | |
| score | number | The score the answer translate to | No | |
| max_score | integer | The maximum score avaliable for the question. | No |
Table: Questions list
Description: List of questions used, and the allowed values and scores
Data description
| Column name | Data type | Description | Unique | Required values |
|---|---|---|---|---|
| question_id | string | Unique ID for a question | Yes | |
| Question description | string | Full text description of the question | Yes | |
| Options | string | The kind of response allowed to the question (generally checkbox). HEADER is used for grouping purposes. | No | |
| Scores | string | Map of scores to different answers | No |
Table: Section labels and weights
Description: Mapping of short section IDs to long labels, and the weighting used in the overall score
Data description
| Column name | Data type | Description | Unique | Required values |
|---|---|---|---|---|
| section_id | string | ID for section (group of questions) | Yes | |
| section_name | string | Description of questions in sections. | Yes | |
| section_weight | number | Weighting applied to the section percentage in the final result. | No |
Table: Section Scores
Description: By authority, the scores received for each section and the total possible for that authority type.
Data description
| Column name | Data type | Description | Unique | Required values |
|---|---|---|---|---|
| local-authority-code | string | 3 letter code for authority | No | |
| section | string | Section short ID (a section is a group of questions) | No | s1_gov, s2_m&a, s3_c&a, s4_coms, s5_mset, s6_cb, s7_dsi, s8_est, s9_ee |
| max_score | integer | Maximum score avaliable for section | No | |
| score | number | Score this authority received for this section | No | |
| section_name | string | Descriptive name for section (group of questions) | No |