posts_gdocs: 1oiiJ1mUXrkXXGcbtTlcJcw1LxBzJ-tc2YDRBmbSnP4g

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
1oiiJ1mUXrkXXGcbtTlcJcw1LxBzJ-tc2YDRBmbSnP4g differences-in-life-expectancy-across-the-world-are-extremely-large data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "life-expectancy-desktop2.png",
            "parseErrors": [],
            "smallFilename": "life-expectancy-mobile2.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "People in richer countries tend to live much longer than those in poorer countries.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "We can see this in the cross-country life expectancy statistics shown on the chart. In Japan, life expectancy at birth is about 85 years, while in Chad and Nigeria, life expectancy is about 52 years \u2014 a gap of over three decades.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/grapher/life-expectancy?time=latest&country=JPN~CHN~USA~OWID_WRL~IND~ETH~NGA~TCD",
                    "children": [
                        {
                            "text": "Explore this data",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Differences in life expectancy across the world are extremely large",
    "authors": [
        "Esteban Ortiz-Ospina"
    ],
    "approved-by": "Ed",
    "grapher-url": "<a href=\"https://ourworldindata.org/grapher/life-expectancy?tab=map\">https://ourworldindata.org/grapher/life-expectancy?tab=map</a>"
}
 1 2023-12-28 18:04:29 2024-03-04 07:55:33 2024-03-06 09:09:16 unlisted ALBJ4Lsf08gsBDU3Z47Ph937LPhJd3L4vMSFqjQX-NEoMJDHihfBSXoKIfw5eaMDKBXSbW3dGKI6RxwlKKPByA   <Image filename="life-expectancy-desktop2.png"/> People in richer countries tend to live much longer than those in poorer countries. We can see this in the cross-country life expectancy statistics shown on the chart. In Japan, life expectancy at birth is about 85 years, while in Chad and Nigeria, life expectancy is about 52 years — a gap of over three decades. [Explore this data](https://ourworldindata.org/grapher/life-expectancy?time=latest&country=JPN~CHN~USA~OWID_WRL~IND~ETH~NGA~TCD) → Differences in life expectancy across the world are extremely large

Links from other tables