IPCC AR6 Gender Distribution

IPCC AR6 Gender Distribution

A simple visualization showing the gender distribution of all authors in the IPCC AR6 Assessment Report.

Instructions: 1. Update the SPARQL_ENDPOINT variable below with your production endpoint 2. Run all cells in this notebook to generate the chart 3. The output will be saved in the notebook 4. Quarto will render the stored output without re-executing

Data Source: SPARQL endpoint (Wikibase)
Visualization: Single Plotly bar chart

Configuration

Update WIKI_BASE_URL and SPARQL_ENDPOINT to match your environment:

Environment Wiki Base URL Query UI SPARQL Endpoint
LOCAL http://localhost:8080 http://localhost:8081 http://localhost:9999/bigdata/namespace/wdq/sparql
DEV https://dev-climatekg.semanticclimate.org https://dev-climatekg.semanticclimate.org/query/ https://dev-climatekg.semanticclimate.org/query/proxy/sparql
TEST https://test-climatekg.semanticclimate.org https://test-climatekg.semanticclimate.org/query/ https://test-climatekg.semanticclimate.org/query/proxy/sparql
PROD https://prod-climatekg.semanticclimate.org https://prod-climatekg.semanticclimate.org/query/ https://prod-climatekg.semanticclimate.org/query/proxy/sparql

Note: The SPARQL query prefixes (wdt:, wd:) are built from WIKI_BASE_URL automatically.

Check SPARQL Endpoint Availability

Troubleshooting if connection fails:

  1. Is the WDQS container running?
    • docker compose ps — all 5 containers should show healthy or running
    • docker compose up -d to start the stack
  2. Correct LOCAL URLs:
    • Wiki: http://localhost:8080
    • Query UI (web interface): http://localhost:8081
    • SPARQL endpoint (direct access): http://localhost:9999/bigdata/namespace/wdq/sparql
  3. Test the endpoint in your browser:
    • Open http://localhost:9999/bigdata/namespace/wdq/sparql

Query Author Data from Wikibase

Querying Wikibase for author data...
Using Wiki base: http://localhost:8080
Using SPARQL endpoint: http://localhost:9999/bigdata/namespace/wdq/sparql
Properties: P1 (instance of), P23 (gender), P20 (ClimateKG Author ID)

Raw SPARQL results:            1,864
  — with ClimateKG UID:        1,864
  — without ClimateKG UID:     0
After dedup by UID:            932 unique authors
  — duplicates removed:        932
  — with gender set:           932

Raw gender values (pre-dedup):
gender
M    1270
F     594

Gender values (unique authors):
gender
M    635
F    297

Process Gender Data

Gender Distribution (unique authors by ClimateKG Author ID):
=============================================
Gender  Count  Percentage
Female    297        31.9
  Male    635        68.1

Total unique authors: 932