posts_gdocs: 1rxlMh5sfPnyj_cPFxR8OSUSOfzGaARbn81ge1M1rRJI

This table contains the GDocs posts. A lot of interesting data is the content column which is a json blob containing, among other things, the archieml as parsed json. For easy searching etc, a markdown copy of the content is available in the markdown column. If you want to query all posts (both wordpress and gdocs), use the posts_unified table or the posts_unified_with_content view.

Data license: CC-BY

This data as json

id slug type content published createdAt publishedAt updatedAt publicationContext revisionId breadcrumbs markdown title
1rxlMh5sfPnyj_cPFxR8OSUSOfzGaARbn81ge1M1rRJI coal-power-is-dying-in-western-europe data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "coal-europe-desktop.png",
            "hasOutline": false,
            "parseErrors": [],
            "smallFilename": "coal-europe-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Coal dominated Europe's electricity mix over the 20th century, but it is quickly dying in many countries in the 21st.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The chart shows the share of electricity that comes from coal for a range of countries in Western Europe. The data comes from ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ember-climate.org/",
                    "children": [
                        {
                            "text": "Ember",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ".",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Transitioning away from coal has helped ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ourworldindata.org/explorers/co2?stackMode=relative&time=2000..latest&facet=none&country=GBR~IRL~ESP~PRT~GRC~DNK~NLD~DEU&Gas+or+Warming=CO%E2%82%82&Accounting=Territorial&Fuel+or+Land+Use+Change=All+fossil+emissions&Count=Per+country",
                    "children": [
                        {
                            "text": "reduce carbon emissions",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " and ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ourworldindata.org/explorers/air-pollution?time=1990..latest&facet=entity&uniformYAxis=0&country=GBR~IRL~ESP~DNK~DEU~GRC~NLD~PRT~ITA&Pollutant=Nitrogen+oxides+%28NOx%29&Sector=From+all+sectors+%28Total%29&Per+capita=false",
                    "children": [
                        {
                            "text": "local air pollutants",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ".",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/grapher/share-electricity-coal",
                    "children": [
                        {
                            "text": "Explore the data",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Coal power is dying in Western Europe",
    "authors": [
        "Hannah Ritchie"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/share-electricity-coal"
}
 1 2024-06-06 10:16:41 2024-06-18 07:00:16 2024-06-10 10:13:20 unlisted ALBJ4LuDsghb3t7vOkPo2zJSRKcZ-8QO-y594qlKaYp7ODnQQHfSun55BTeeqAoNYENUEucWE8FWWKAKWOw1jA   <Image filename="coal-europe-desktop.png"/> Coal dominated Europe's electricity mix over the 20th century, but it is quickly dying in many countries in the 21st. The chart shows the share of electricity that comes from coal for a range of countries in Western Europe. The data comes from [Ember](https://ember-climate.org/). Transitioning away from coal has helped [reduce carbon emissions](https://ourworldindata.org/explorers/co2?stackMode=relative&time=2000..latest&facet=none&country=GBR~IRL~ESP~PRT~GRC~DNK~NLD~DEU&Gas+or+Warming=CO%E2%82%82&Accounting=Territorial&Fuel+or+Land+Use+Change=All+fossil+emissions&Count=Per+country) and [local air pollutants](https://ourworldindata.org/explorers/air-pollution?time=1990..latest&facet=entity&uniformYAxis=0&country=GBR~IRL~ESP~DNK~DEU~GRC~NLD~PRT~ITA&Pollutant=Nitrogen+oxides+%28NOx%29&Sector=From+all+sectors+%28Total%29&Per+capita=false). [Explore the data](https://ourworldindata.org/grapher/share-electricity-coal) → Coal power is dying in Western Europe

Links from other tables