posts_gdocs: 1NJZM4zSe0hgtvrBGSvx-jZHPjOE8YzhOA2smX4HtpGc

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.

This data as json

id slug type content published createdAt publishedAt updatedAt publicationContext revisionId breadcrumbs markdown title
1NJZM4zSe0hgtvrBGSvx-jZHPjOE8YzhOA2smX4HtpGc fourteen-countries-in-the-world-get-almost-all-of-their-electricity-from-renewables data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "share-electricity-renewables-desktop.png",
            "hasOutline": false,
            "parseErrors": [],
            "smallFilename": "share-electricity-renewables-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Since 2020, 14 countries have consistently generated over 95% renewable electricity, according to ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ember-climate.org/data-catalogue/yearly-electricity-data/",
                    "children": [
                        {
                            "text": "Ember\u2019s Yearly electricity data",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ". In eight of these countries, electricity has been almost entirely renewable-based for over 20 years.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Renewable sources include hydropower, solar, wind, geothermal, biomass, tidal, and wave power. In all these countries, the largest source of electricity was hydropower.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Sub-Saharan countries, however, use significantly less electricity in their energy mix compared to countries in Europe or North America.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/renewable-energy",
                    "children": [
                        {
                            "text": "Read more on renewable energy",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Fourteen countries in the world get almost all of their electricity from renewables",
    "authors": [
        "Pablo Rosado"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/share-electricity-renewables"
}
 1 2024-07-12 13:55:31 2024-07-24 05:00:00 2024-07-22 15:37:44 unlisted ALBJ4LsxkPDm7DgMQ2EhyH0QRq_lpnrPMrjNSS5it-QOcvCgVqSlNpje66bkf84to4ZPWgszaX24kg1i1JfXBg   <Image filename="share-electricity-renewables-desktop.png"/> Since 2020, 14 countries have consistently generated over 95% renewable electricity, according to [Ember’s Yearly electricity data](https://ember-climate.org/data-catalogue/yearly-electricity-data/). In eight of these countries, electricity has been almost entirely renewable-based for over 20 years. Renewable sources include hydropower, solar, wind, geothermal, biomass, tidal, and wave power. In all these countries, the largest source of electricity was hydropower. Sub-Saharan countries, however, use significantly less electricity in their energy mix compared to countries in Europe or North America. [Read more on renewable energy](https://ourworldindata.org/renewable-energy) → Fourteen countries in the world get almost all of their electricity from renewables

Links from other tables