PEOPLES’ CLIMATE VOTE
SURVEY DATA TO WEBSITE
FIG. 02
SCALE · N.T.S.
SOURCE FILES
PCV 2021 ESTIMATES
1,901 ROWS × 16 COLUMNS
1.2M PEOPLE · 50 COUNTRIES
PCV 2021 WORKBOOK
THE SAME, PLUS GLOBAL AVERAGES
UNDP’S OWN WORLD FIGURES
CROSS-TABS
AGE · GENDER · EDUCATION
ONE AXIS AT A TIME
CLEANING AND MAPPING
AS IT ARRIVED
RULE
AS THE SITE READS IT
AR
ISO CODE TO COUNTRY
Argentina · 032
q1_option1
QUESTION CODE
Transport · policy 1
male
GENDER
Men · gender axis
agelessthan18
AGE BAND
Under 18 · age axis
NeverAttended
EDUCATION BAND
Never attended school · education axis
""
MISSING ANSWER
Not polled
ONE PASS OVER EVERY FILE · CODES, BANDS AND THE GLOBAL ROW MATCHED · GAPS LEFT AS GAPS
ONE TABLE · COUNTRY × QUESTION × GROUP
COUNTRY
× 50
QUESTION × 8 · 18 POLICIES
GROUP × 11
values[country][question][group] · one shape, ready for the next edition · static files, no server
THE MAP
QUESTION PAGES
DATA CENTRE
SHARE CARDS
50 COUNTRIES · HOVER FOR THE NUMBER
8 QUESTIONS · TOP AND BOTTOM TEN
CSV
XLSX
PNG
EVERY EXPORT CARRIES A SOURCE LINE
64%
SQUARE OR LANDSCAPE · READY TO POST
SOURCE · UNDP AND THE UNIVERSITY OF OXFORD · PEOPLES’ CLIMATE VOTE 2021
BUILT 2022 · REBUILT 2026