posts_gdocs: 1oe_-FKOkoR8-QWg_6WuxZBZ4sxitO1j8m3g5-m8rXeI

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
1oe_-FKOkoR8-QWg_6WuxZBZ4sxitO1j8m3g5-m8rXeI clean-water-sanitation topic-page 
{
    "toc": [],
    "body": [
        {
            "type": "topic-page-intro",
            "content": [
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "Having access to and using safe drinking water, sanitation, and handwashing is a basic human need.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "Individuals not using these facilities increases the risk of disease and malnutrition and is attributed to millions of deaths each year.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "The world has made significant progress in increasing their availability. In the past, infectious diseases were the leading ",
                            "spanType": "span-simple-text"
                        },
                        {
                            "url": "http://ourworldindata.org/causes-of-death",
                            "children": [
                                {
                                    "text": "cause of death",
                                    "spanType": "span-simple-text"
                                }
                            ],
                            "spanType": "span-link"
                        },
                        {
                            "text": " in most countries. They\u2019ve ",
                            "spanType": "span-simple-text"
                        },
                        {
                            "url": "https://ourworldindata.org/grapher/twentieth-century-of-deaths-us?stackMode=relative",
                            "children": [
                                {
                                    "text": "fallen dramatically",
                                    "spanType": "span-simple-text"
                                }
                            ],
                            "spanType": "span-link"
                        },
                        {
                            "text": " in high and middle-income countries \u2013 partly due to increased usage of clean water and sanitation.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "But there is still more work to do. It is still a major problem in low-income countries.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "On this page, you can find all of our data on water, sanitation, and handwashing.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                }
            ],
            "parseErrors": [],
            "relatedTopics": [
                {
                    "url": "https://ourworldindata.org/diarrheal-diseases",
                    "text": "Diarrheal Diseases",
                    "type": "topic-page-intro-related-topic"
                },
                {
                    "url": "https://ourworldindata.org/causes-of-death",
                    "text": "Causes of Death",
                    "type": "topic-page-intro-related-topic"
                },
                {
                    "url": "https://ourworldindata.org/water-use-stress",
                    "text": "Water Use and Stress",
                    "type": "topic-page-intro-related-topic"
                }
            ]
        },
        {
            "type": "gray-section",
            "items": [
                {
                    "text": [
                        {
                            "text": "Explore our data on Clean Water and Sanitation",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "type": "heading",
                    "level": 1,
                    "parseErrors": []
                },
                {
                    "url": "https://ourworldindata.org/explorers/water-and-sanitation",
                    "type": "chart",
                    "parseErrors": []
                }
            ],
            "parseErrors": []
        },
        {
            "more": {
                "heading": "More articles on Clean Water and Sanitation",
                "articles": [
                    {
                        "value": {
                            "url": "https://docs.google.com/document/d/123VZrjdAkaWKdoBzLUGfTuqha_Hnan_SwM8RMbuq-vE/edit"
                        }
                    }
                ]
            },
            "rows": [],
            "type": "research-and-writing",
            "primary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1dx9w3r4Wor4TDGAt4_Oggwuj-SVOzF7eT86CaO5efw8/edit"
                    }
                }
            ],
            "secondary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E/edit"
                    }
                }
            ],
            "parseErrors": [],
            "hide-authors": false
        },
        {
            "top": [
                {
                    "url": "https://ourworldindata.org/grapher/proportion-using-safely-managed-drinking-water"
                },
                {
                    "url": "https://ourworldindata.org/grapher/share-using-safely-managed-sanitation"
                },
                {
                    "url": "https://ourworldindata.org/grapher/proportion-of-population-with-basic-handwashing-facilities-on-premises"
                }
            ],
            "type": "all-charts",
            "heading": "Interactive Charts on Clean Water, Sanitation and Hygiene",
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "topic-page",
    "title": "Clean Water and Sanitation",
    "authors": [
        "Hannah Ritchie",
        "Fiona Spooner",
        "Max Roser"
    ],
    "excerpt": "Explore global usage of clean water and sanitation.",
    "dateline": "July 1, 2021",
    "sticky-nav": [
        {
            "text": "Introduction",
            "target": "#introduction"
        },
        {
            "text": "Data Explorer",
            "target": "#explore-our-data-on-clean-water-and-sanitation"
        },
        {
            "text": "Research & Writing",
            "target": "#research-writing"
        },
        {
            "text": "Charts",
            "target": "#all-charts"
        },
        {
            "text": "Cite This Work",
            "target": "#article-citation"
        },
        {
            "text": "Reuse This Work",
            "target": "#article-licence"
        }
    ],
    "featured-image": "clean-water-sanitation-and-hygiene-thumbnail.png"
}
 1 2023-09-29 10:30:21 2021-07-01 11:30:00 2024-03-08 16:30:03 unlisted ALBJ4LuTlWPn1zyKa6yh-sX-xkXuz8Re81_ZcI4tHZtY7QpUjmE2V0fDqG58sbrNz6DB9Q_6crgV_Kc29YcJ2g   Having access to and using safe drinking water, sanitation, and handwashing is a basic human need. Individuals not using these facilities increases the risk of disease and malnutrition and is attributed to millions of deaths each year. The world has made significant progress in increasing their availability. In the past, infectious diseases were the leading [cause of death](http://ourworldindata.org/causes-of-death) in most countries. They’ve [fallen dramatically](https://ourworldindata.org/grapher/twentieth-century-of-deaths-us?stackMode=relative) in high and middle-income countries – partly due to increased usage of clean water and sanitation. But there is still more work to do. It is still a major problem in low-income countries. On this page, you can find all of our data on water, sanitation, and handwashing. # Explore our data on Clean Water and Sanitation <Chart url="https://ourworldindata.org/explorers/water-and-sanitation"/> ## Related research and writing * https://docs.google.com/document/d/1dx9w3r4Wor4TDGAt4_Oggwuj-SVOzF7eT86CaO5efw8/edit ,* https://docs.google.com/document/d/1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c/edit ,* https://docs.google.com/document/d/16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E/edit ,* https://docs.google.com/document/d/123VZrjdAkaWKdoBzLUGfTuqha_Hnan_SwM8RMbuq-vE/edit <AllCharts heading="Interactive Charts on Clean Water, Sanitation and Hygiene"/> Clean Water and Sanitation

Links from other tables