posts_gdocs: 1pU8nVBchpI_LYZmNOo4Dag9lHvQkzG-r8JD_57_-1rw

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
1pU8nVBchpI_LYZmNOo4Dag9lHvQkzG-r8JD_57_-1rw esteban-ortiz-ospina author 
{
    "bio": [
        {
            "type": "text",
            "value": [
                {
                    "text": "Esteban is the Executive Co-Director of Our World in Data alongside Max Roser. In tandem, they lead ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://global-change-data-lab.org/",
                    "children": [
                        {
                            "text": "Global Change Data Lab",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ", the non-profit organization responsible for publishing Our World in Data.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Esteban is also an Honorary Researcher at the ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://www.oxfordmartin.ox.ac.uk/people/dr-esteban-ortiz-ospina/",
                    "children": [
                        {
                            "text": "Oxford Martin Programme on Global Development",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ", where his research and writing cover topics including economic development, public sector analysis, education, and a wide range of related issues.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Prior to joining the team at Our World in Data, Esteban was a Departmental Lecturer in Economics at the University of Oxford\u2019s ",
                    "spanType": "span-simple-text"
                },
                {
                    "url": "https://www.bsg.ox.ac.uk/people/esteban-ortiz-ospina",
                    "children": [
                        {
                            "text": "Blavatnik School of Government",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": ", from 2013 to January 2016.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Esteban completed his doctoral studies at the University of Oxford (DPhil Economics).",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "body": [
        {
            "rows": [],
            "type": "research-and-writing",
            "heading": "All work",
            "primary": [],
            "secondary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1UjJLoGF5VMfn8U4C3ZSJQrPhc_jFRkeEhrhz5Ksfq7M/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1XBMGw4j4jdlh4qt4Z2y2F_4cNFm-U5yrWFY2fRvMt3M/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/19AlSstYCtGglhNNt9mbKGAEf_oZcQTKNjYJ-5BlXSts/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1gVSV2gqzPSTMI80gmHEgbaKeWalj6daqe519RtZaJ7I/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1MifBwpobE_3seoJcvCq2EPamQaSDPdmS96yD7_6PsTo/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1yzOrFd6uWvrAl2oFB3S67oOSbhgL1ffPHxjAqS7i-4w/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/195wtinOB2zsiGevmvUfAGPZv4NrG4jY_vpib49e5gt4/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1Zfn2vEgY3YQKdL07rHvK6V0bA_ooCls_EPukf2umHMM/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1VfZnfnJWL-t3XTwwvVogsYJTHKp-6GXoFji0UOkNmsc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1Ts7cAiBzxpv9AYH2uwmMzMt88wVHQcl100nlabkxXyo/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1AVyhvfuPmtXXXHivtpZdrR0kLwOLDelDYq6tEtebshc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://ourworldindata.org/migration",
                        "title": "Migration",
                        "authors": [
                            "Esteban Ortiz-Ospina",
                            "Max Roser",
                            "Hannah Ritchie",
                            "Fiona Spooner",
                            "Marcel Gerber"
                        ],
                        "filename": "Migration.png",
                        "subtitle": "Migration has been an important source of economic development and poverty reduction. Explore data on global migration."
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1H0uMTbbF9NlaX2vyHdKHRxEBwJbQpeuoQcF6Fhue7dE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://ourworldindata.org/internet",
                        "title": "Internet",
                        "authors": [
                            "Hannah Ritchie",
                            "Edouard Mathieu",
                            "Max Roser",
                            "Esteban Ortiz-Ospina"
                        ],
                        "filename": "Internet.png",
                        "subtitle": "More than half of the world is online. But the internet is still young."
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1xXL0L0uu5fYOQKjLNbvSrFcORvHPVNV1CX8_RYUd2wg/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1qXuRnsozpmvOQymlHztn2-KPcGUJFPPd5J7jOamzQ7A/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1tqoeu-Qe0qvQi2FwhI5xWhxQbR1hzgxJ-ZjzetJFj_s/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1lxxDxbccgq8wSQyrkO8EnI9iSFayaGrWvTkfSFJ0z-c/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1IA3diUIJRzOBGfguZAHMfNdNVg9SjeLXRBBj_WQlYVA/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1fZviDn01DnCXZo2Hw_FkfyZo4S5UZMzey_zof3s-iPE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1f8O9RyfmDHVv6FEtBWv8J6UiqfPKBt2QFW-dHHYdgr4/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1o4VRXc0grrTvoZ4IfJ6i9Cne93E_-81w9KcPnErDr7I/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1-moDkA6s2Yv4liptTqlc8ZWjzXlohGfNJWJxaKK4jiI/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1CNrov0Q43SDQtCm6htHd3LCZ2HrT-3seB3D-tALACVo/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1fXtrUrI2tiXjDRV9fqiOtTGLs4HngLR6jcS-yNymW0s/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1WhiTO50prdWiM2XfjlMr0qoiS05_BZModcFaQxOONZ0/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1f9Zm822hXzvlZzVwEDL2JBHRLd6eurEA67b_O4AmWCs/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1whkiE8G_Ja1VdRvjyU1L0ptYksxSLnkBajQ5Q_KlNpE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1oUt6cIxmOGlbZcCbY0846sGXc60AQBO-0LMDJZSUcF8/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/15TD9DyPmgOUFC8pMzMczLJmNTIw_j-gBM32JpInPJIU/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1eddseVmCjQro8bIwMVRtSO3oJ6oghA6Ur3If98HWg1c/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1EKZTAn746pHTC0TONTwxnqRun6g4RZh9RC6RTVjr7Dc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1scFKpuRQ13hmruDYgL3f-nMKNVbjW8YtM-u6mxqLa9k/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1Hz0E15ltNEcTdf_M6tqSmHyhWrN_11DujuCA-WttU6w/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1ebjvW_lFJxhKtF3qQtlspaCY_jayKoPJqw-Hd7xnYz4/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1FbKVWqPddBZy0NcHzDG-BSoCsN5tJnok3RXcLo6R9ls/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/14PxOpHswe28nQkeIBo_0pHqXkGdiAwsGnMcGn82Ub-U/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1049NVx1QWUKDro4Ztuu3L8hGMw7GyHtv5EZFpPp2uzg/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1BbZmBMYfJaRFMYUPMSY_57G5dm1mqEmXgUZI2O5pGX4/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1YN5wV6Lb2A48s0OoiWA0iZD0Ix2k8xrPpCXrs0iNCWo/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1L8nagAAvZK7RroV2w2450wv9vb0sFOlfyz4HcotNahw/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1dodSvwCAfNjlnBydujqd3i3ryAuZnAn1LIV66fk8OvY/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1ZuTKWW6RWe52EeiSTupKXca-hc1hSebfb3adzD8oj8c/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1hGeaS1CwJ38IMcf0_5rfLYvO6PmK3BYE3aAysTEeD0k/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1J3kg9dC5XDXtBCyuaPRwrtpx-6yf7n73kN9xXm7KEL8/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1WU7Tqz9GcHLD3xXhap1c9SmTdQGr0K-0CFo_R5FJrjQ/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1wF6Z7SG8ZSaiB0Mhy1vuE4UZRTrYe_QK5mD9KTv1MfU/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1BpaEB2vIhPGVQyR9VFNG99255l9nDUDfO8ponS51nsE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1FkhpTDl-8EEQBUACLg16EMDdllsxbdx06KPzEAIcJOE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1RAaw1RsSaADyk3luEK1OisubvmIAPYE2YxSzDx_N8uw/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1mceBB_ZtHGw0qzdROjJi8pWnwZVA_cJ8kOsGLQQhOd8/edit"
                    }
                }
            ],
            "parseErrors": [],
            "hide-authors": true
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "role": "Executive Co-Director",
    "type": "author",
    "title": "Esteban Ortiz-Ospina",
    "authors": [
        "Our World in Data team"
    ],
    "socials": {
        "type": "socials",
        "links": [
            {
                "url": "https://twitter.com/EOrtizOspina",
                "text": "@eortizospina",
                "type": "x"
            },
            {
                "url": "https://twitter.com/EOrtizOspina",
                "text": "@eortizospina",
                "type": "threads"
            }
        ],
        "parseErrors": []
    },
    "featured-image": "Este.jpg"
}
 1 2024-05-23 12:56:02 2024-05-28 12:20:31 1970-01-01 00:00:00 unlisted ALBJ4LsNSIEV8a2cd1ySeojFyplkvhW8jA0ez3bcVALtTGDfUaqoaxpqyTUzvyO6XFF-8h97IoxF50-oerF3Cg     Esteban Ortiz-Ospina

Links from other tables