posts_gdocs: 1t5b9foM14E-4ib1jCz3ZozaidP7KAgnawPKuJYX1oKo

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
1t5b9foM14E-4ib1jCz3ZozaidP7KAgnawPKuJYX1oKo the-share-of-democracies-has-recently-stagnated-but-remains-near-its-historical-high data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "countries-democracies-autocracies-row-desktop.png",
            "parseErrors": [],
            "smallFilename": "countries-democracies-autocracies-row-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Over the last twenty years, the share of countries that are democracies has remained relatively stable.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Relying on ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://ourworldindata.org/regimes-of-the-world-data",
                    "children": [
                        {
                            "text": "data from Varieties of Democracy",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ",\u00a0which we just updated, the chart shows that around half of all countries are democracies.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The world remains close to the historical high in the early 2000s and is much more democratic than 50 years ago; only 20% of countries were democracies in the early 1970s.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "However, the chart shows smaller changes within democratic regimes: the share of ",
                    "spanType": "span-simple-text"
                },
                {
                    "children": [
                        {
                            "text": "liberal",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-italic"
                },
                {
                    "text": " democracies, which grant additional individual and minority rights and constrain their governments, has decreased over the last decade.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "While democracy has remained fairly resilient over the last few decades, this recent stagnation and limited rollback stresses that progress on increasing political rights is neither linear nor guaranteed.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/less-democratic",
                    "children": [
                        {
                            "text": "Read more about the recent changes in democracy",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "The share of democracies has recently stagnated but remains near its historical high",
    "authors": [
        "Bastian Herre"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/countries-democracies-autocracies-row?time=1973..latest"
}
 1 2024-05-02 09:09:35 2024-05-14 05:45:46 2024-05-13 07:57:58 unlisted ALBJ4LvPF0UXrE-Fze4oW7-nyunZfBb6xyr-g4lhdd__aONHdbSL4pQ7jXitmGfNf7WlP6ZpfN28gYTf1hqKXw   <Image filename="countries-democracies-autocracies-row-desktop.png"/> Over the last twenty years, the share of countries that are democracies has remained relatively stable. Relying on [data from Varieties of Democracy](https://ourworldindata.org/regimes-of-the-world-data), which we just updated, the chart shows that around half of all countries are democracies. The world remains close to the historical high in the early 2000s and is much more democratic than 50 years ago; only 20% of countries were democracies in the early 1970s. However, the chart shows smaller changes within democratic regimes: the share of _liberal_ democracies, which grant additional individual and minority rights and constrain their governments, has decreased over the last decade. While democracy has remained fairly resilient over the last few decades, this recent stagnation and limited rollback stresses that progress on increasing political rights is neither linear nor guaranteed. [Read more about the recent changes in democracy](https://ourworldindata.org/less-democratic) → The share of democracies has recently stagnated but remains near its historical high

Links from other tables