variables: 935650

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

This data as json

id name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
935650 Number of pages in the Guardian that mention a country (per million people) (10-year average) pages per million people   2024-06-20 15:38:03 2024-07-25 23:08:48     2023-2023 6533     
{
    "unit": "pages per million people"
}
 0     num_pages_mentions_per_million_10y_avg grapher/news/2024-05-08/guardian_mentions/avg_10y#num_pages_mentions_per_million_10y_avg   2 major           Number of pages in the Guardian that mention a particular country, normalised by the population of the country.. It reflects a 10-year average (2014 - 2023).   
[]
 Getting the number of articles/entries talking about a certain country has no straightforward answer, since there can be different strategies. The strategy for this indicator is based on first defining a set of country name variations for each country, and then look for content on The Guardian with an explicit mention to these names. 1. Get all country name variations: - Obtain all the country name variations using our standard name list. - Our list may not cover all cases, and may contain some names that are not valid on The Guardian API (e.g. names with symbols like ';' are not supported). Therefore, we clean this list. 2. For each country, obtain the number of pages using each set of name variations. Steps: - For each country and year we get all content metadata: a query like "https://content.guardianapis.com/search?q=...&from-date=2020-01-01&to-date=2020-12-31" for year 2020. The count of pages is in the property `response.total`. For mor details, please refer to the snapshot script. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
     float 
[]
 0d43beb5c01caee21e7728b490043b52 3be964ac21c531ef6b74979f26e32655

Links from other tables