Dataset: Attention To Each Country In The Guardian's Articles

About this Dataset

Attention To Each Country In The Guardian's Articles

Aggregate estimates on the number of entries that talk about each country and year.

The data was obtained by querying The Guardian's Open Platform.

An entry or page in The Guardian is considered to be about a certain country if that particular country is mentioned in the text. To this end, we have used a set of country name variations to ensure that we capture all the entries. Nonetheless, this is not a perfect method and some entries might be missed.

Tables

Avg 10y

@owid.guardian_mentions.owid_avg_10y

22.01 KB
287 rows
10 columns


CREATE TABLE owid_avg_10y (
  "country" VARCHAR,
  "year" INTEGER,
  "num_pages_tags_10y_avg" FLOAT,
  "num_pages_mentions_10y_avg" FLOAT,
  "relative_pages_tags_10y_avg" FLOAT,
  "relative_pages_tags_excluded_10y_avg" FLOAT,
  "relative_pages_mentions_10y_avg" FLOAT,
  "relative_pages_mentions_excluded_10y_avg" FLOAT,
  "num_pages_tags_per_million_10y_avg" FLOAT,
  "num_pages_mentions_per_million_10y_avg" FLOAT
);

Guardian Mentions

@owid.guardian_mentions.owid_guardian_mentions

96.93 KB
2875 rows
10 columns


CREATE TABLE owid_guardian_mentions (
  "country" VARCHAR,
  "year" INTEGER,
  "num_pages_tags" UINTEGER,
  "num_pages_mentions" UINTEGER,
  "relative_pages_tags" FLOAT,
  "relative_pages_tags_excluded" FLOAT,
  "relative_pages_mentions" FLOAT,
  "relative_pages_mentions_excluded" FLOAT,
  "num_pages_tags_per_million" FLOAT,
  "num_pages_mentions_per_million" FLOAT
);