posts_gdocs: 16uGVylqtS-Ipc3OCxqapJ3BEVGjWf648wvZpzio1QFE

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
16uGVylqtS-Ipc3OCxqapJ3BEVGjWf648wvZpzio1QFE daniels-example-faqs fragment 
{
    "toc": [],
    "body": [],
    "faqs": [
        {
            "id": "cherries",
            "content": [
                {
                    "type": "heading",
                    "value": {
                        "text": "What are cherries?",
                        "level": "2"
                    }
                },
                {
                    "type": "text",
                    "value": "A <b>cherry</b> is the <a href=\"https://en.wikipedia.org/wiki/Fruit\">fruit</a> of many plants of the genus <i><a href=\"https://en.wikipedia.org/wiki/Prunus\">Prunus</a></i>, and is a fleshy <a href=\"https://en.wikipedia.org/wiki/Drupe\">drupe</a> (stone fruit)."
                },
                {
                    "type": "text",
                    "value": "They are also Daniel's favourite <a href=\"#dod:incidence_prevalence\">fruit</a>"
                }
            ]
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "fragment",
    "title": "Daniel's Example FAQs",
    "byline": "Our World In Data",
    "authors": [
        "Our World In Data"
    ],
    "excerpt": "Source document for OWID\u2019s details on demand snippets",
    "dateline": "April 12, 2023"
}
 1 2023-08-04 08:24:28 2023-08-04 10:26:02 2023-08-04 08:26:02 unlisted AGEZuMETgtJGl5QVpHDPBbEVZTf_Fv1DxyaOGECAXTuqvyYu6uDVYyNmkUse3CQuTBf7_5zQgnot7KQ-NrBK6A     Daniel's Example FAQs

Links from other tables