posts_gdocs: 1PPxPnuvdOgLYdobjHQmc59wMD81gXsWkaNfMIqzzHKA

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
1PPxPnuvdOgLYdobjHQmc59wMD81gXsWkaNfMIqzzHKA no-clean-cooking-fuels article 
{
    "toc": [],
    "body": [
        {
            "type": "text",
            "value": [
                {
                    "text": "Almost 70% of the world had access to clean cooking fuels in 2020. The remaining 30% do not. This means around 2.4 billion people do not have access to clean cooking fuels.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The world map shows this data country-by-country. In many of the world's poorest countries, almost no one has access to clean cooking fuels.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Why is having access to clean fuels so important?",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "People who do not have access to clean cooking fuels have to rely on substitutes \u2013 these are solid fuels such as wood, dung, or charcoal.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Burning these fuels leads to millions of deaths. It emits harmful pollution into the home where it has significant health impacts for those who breathe it in. Millions ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ourworldindata.org/energy-poverty-air-pollution",
                    "children": [
                        {
                            "text": "die every year",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " from household air pollution. These deaths are preventable by ensuring everyone has access to clean fuels.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "url": "https://ourworldindata.org/grapher/access-to-clean-fuels-and-technologies-for-cooking",
            "type": "chart",
            "parseErrors": []
        },
        {
            "type": "horizontal-rule",
            "value": {},
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "article",
    "title": "How many people do not have access to clean fuels for cooking?",
    "authors": [
        "Hannah Ritchie"
    ],
    "excerpt": "Around 3-in-10 people do not have access to clean cooking fuels.",
    "dateline": "November 30, 2021",
    "subtitle": "Around 3-in-10 people do not have access to clean cooking fuels.",
    "featured-image": "clean-fuels-thumbnail.png"
}
 1 2023-10-09 19:07:27 2021-11-30 10:45:39 2023-12-28 16:31:10 unlisted ALBJ4Lui93KehrhDY4wt0K-MNNvMINFu-CvhgYJ8p7BMcG0hdzUxUulHVbkxKSL8zybSSJSVlXWMjrgxTm4AbA   Almost 70% of the world had access to clean cooking fuels in 2020. The remaining 30% do not. This means around 2.4 billion people do not have access to clean cooking fuels. The world map shows this data country-by-country. In many of the world's poorest countries, almost no one has access to clean cooking fuels. Why is having access to clean fuels so important? People who do not have access to clean cooking fuels have to rely on substitutes – these are solid fuels such as wood, dung, or charcoal. Burning these fuels leads to millions of deaths. It emits harmful pollution into the home where it has significant health impacts for those who breathe it in. Millions [die every year](https://ourworldindata.org/energy-poverty-air-pollution) from household air pollution. These deaths are preventable by ensuring everyone has access to clean fuels. <Chart url="https://ourworldindata.org/grapher/access-to-clean-fuels-and-technologies-for-cooking"/> --- How many people do not have access to clean fuels for cooking?

Links from other tables