posts: 27120

This table contains the full text for all our old WORDPRESS content in html form. The format is a bit odd as it represents a direct copy from wordpress content that includes a lot of wordpress specific comments that carry some meaning in terms of layout instructions etc.. The html in the content column can thus be rendered as is but will not look identical to the way it looks on our website as several post processing steps are not applied yet. The content should work though as a readable approximation for every post. 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.

This data as json

id title slug type status content archieml archieml_update_statistics published_at updated_at gdocSuccessorId authors excerpt created_at_in_wordpress updated_at_in_wordpress featured_image formattingOptions markdown wpApiSnapshot
27120 Where are children dying from malaria untitled-reusable-block-127 wp_block publish <!-- wp:paragraph --> <p>In the map here you see the number of childhood deaths from malaria by country.</p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>Of the more than 350,000 deaths from malaria in children under-5 in 2019, almost half of them have occurred in just two countries — Nigeria and the Democratic Republic of Congo.{ref}95,636 in Nigeria and 44,078 in the DRC{/ref} </p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>The <a href="https://ourworldindata.org/grapher/child-deaths-from-malaria">highest mortality rates</a> from the disease are in Sierra Leone and Burkina Faso, where 524 and 405 children per 100,000 died of the disease in 2019. </p> <!-- /wp:paragraph --> <!-- wp:html --> <iframe src="https://ourworldindata.org/grapher/child-deaths-from-malaria-number" style="width: 100%; height: 600px; border: 0px none;"></iframe> <!-- /wp:html --> 
{
    "id": "wp-27120",
    "slug": "untitled-reusable-block-127",
    "content": {
        "toc": [],
        "body": [
            {
                "type": "text",
                "value": [
                    {
                        "text": "In the map here you see the number of childhood deaths from malaria by country.",
                        "spanType": "span-simple-text"
                    }
                ],
                "parseErrors": []
            },
            {
                "type": "text",
                "value": [
                    {
                        "text": "Of the more than 350,000 deaths from malaria in children under-5 in 2019, almost half of them have occurred in just two countries \u2014 Nigeria and the Democratic Republic of Congo.{ref}95,636 in Nigeria and 44,078 in the DRC{/ref} ",
                        "spanType": "span-simple-text"
                    }
                ],
                "parseErrors": []
            },
            {
                "type": "text",
                "value": [
                    {
                        "text": "The ",
                        "spanType": "span-simple-text"
                    },
                    {
                        "url": "https://ourworldindata.org/grapher/child-deaths-from-malaria",
                        "children": [
                            {
                                "text": "highest mortality rates",
                                "spanType": "span-simple-text"
                            }
                        ],
                        "spanType": "span-link"
                    },
                    {
                        "text": " from the disease are in Sierra Leone and Burkina Faso, where 524 and 405 children per 100,000 died of the disease in 2019.    ",
                        "spanType": "span-simple-text"
                    }
                ],
                "parseErrors": []
            },
            {
                "url": "https://ourworldindata.org/grapher/child-deaths-from-malaria-number",
                "type": "chart",
                "parseErrors": []
            }
        ],
        "type": "article",
        "title": "Where are children dying from malaria",
        "authors": [
            null
        ],
        "dateline": "November 5, 2019",
        "sidebar-toc": false,
        "featured-image": ""
    },
    "createdAt": "2019-11-05T12:24:04.000Z",
    "published": false,
    "updatedAt": "2022-01-14T17:14:35.000Z",
    "revisionId": null,
    "publishedAt": "2019-11-05T12:23:51.000Z",
    "relatedCharts": [],
    "publicationContext": "listed"
}
 
{
    "errors": [],
    "numBlocks": 4,
    "numErrors": 0,
    "wpTagCounts": {
        "html": 1,
        "paragraph": 3
    },
    "htmlTagCounts": {
        "p": 3,
        "iframe": 1
    }
}
 2019-11-05 12:23:51 2024-02-16 14:22:58   
[
    null
]
   2019-11-05 12:24:04 2022-01-14 17:14:35   
{}
 In the map here you see the number of childhood deaths from malaria by country. Of the more than 350,000 deaths from malaria in children under-5 in 2019, almost half of them have occurred in just two countries — Nigeria and the Democratic Republic of Congo.{ref}95,636 in Nigeria and 44,078 in the DRC{/ref} The [highest mortality rates](https://ourworldindata.org/grapher/child-deaths-from-malaria) from the disease are in Sierra Leone and Burkina Faso, where 524 and 405 children per 100,000 died of the disease in 2019. <Chart url="https://ourworldindata.org/grapher/child-deaths-from-malaria-number"/> 
{
    "data": {
        "wpBlock": {
            "content": "\n<p>In the map here you see the number of childhood deaths from malaria by country.</p>\n\n\n\n<p>Of the more than 350,000 deaths from malaria in children under-5 in 2019, almost half of them have occurred in just two countries \u2014 Nigeria and the Democratic Republic of Congo.{ref}95,636 in Nigeria and 44,078 in the DRC{/ref} </p>\n\n\n\n<p>The <a href=\"https://ourworldindata.org/grapher/child-deaths-from-malaria\">highest mortality rates</a> from the disease are in Sierra Leone and Burkina Faso, where 524 and 405 children per 100,000 died of the disease in 2019.    </p>\n\n\n\n<iframe src=\"https://ourworldindata.org/grapher/child-deaths-from-malaria-number\" style=\"width: 100%; height: 600px; border: 0px none;\"></iframe>\n"
        }
    },
    "extensions": {
        "debug": [
            {
                "type": "DEBUG_LOGS_INACTIVE",
                "message": "GraphQL Debug logging is not active. To see debug logs, GRAPHQL_DEBUG must be enabled."
            }
        ]
    }
}

Links from other tables