posts_gdocs: 1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE

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
1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE colonialism-meant-that-for-centuries-many-territories-and-people-were-ruled-from-elsewhere data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "number-of-european-overseas-colonies-by-region-desktop.png",
            "parseErrors": [],
            "smallFilename": "number-of-european-overseas-colonies-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Two hundred years ago, large parts of the world were ruled by a few European colonial powers, as the chart shows.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Since then, people in many countries have fought against colonial rule.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "A first wave of countries gained independence in the 19th century, particularly in the Americas.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "However, most countries did not gain independence until the middle of the 20th century.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/state-capacity?insight=for-centuries-many-territories-and-people-were-ruled-from-elsewhere#key-insights",
                    "children": [
                        {
                            "text": "Read more \u2192",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Colonialism meant that for centuries, many territories and people were ruled from elsewhere",
    "authors": [
        "Bastian Herre"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/number-of-european-overseas-colonies-by-region"
}
 1 2024-02-07 13:43:11 2024-03-22 08:05:19 2024-03-26 09:36:41 unlisted ALBJ4LvAllsevDfzI7NWA35S_EqvFILqFbwTlOlC8NOeGrPKxPBBxORLP26FrS5LqFOdzcXTgSWZQ75RMlhSyA   <Image filename="number-of-european-overseas-colonies-by-region-desktop.png"/> Two hundred years ago, large parts of the world were ruled by a few European colonial powers, as the chart shows. Since then, people in many countries have fought against colonial rule. A first wave of countries gained independence in the 19th century, particularly in the Americas. However, most countries did not gain independence until the middle of the 20th century. [Read more →](https://ourworldindata.org/state-capacity?insight=for-centuries-many-territories-and-people-were-ruled-from-elsewhere#key-insights) Colonialism meant that for centuries, many territories and people were ruled from elsewhere

Links from other tables