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 1

@owid.guardian_mentions.owid_avg_10y_1

22.55 kB
287 rows
10 columns

CREATE TABLE owid_avg_10y_1 (
  "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
);

Country Mentions In The Guardian Articles

@owid.guardian_mentions.owid_avg_10y_2

13.57 kB
259 rows
6 columns

CREATE TABLE owid_avg_10y_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "num_pages_10y_avg" FLOAT,
  "relative_pages_10y_avg" FLOAT,
  "relative_pages_excluded_10y_avg" FLOAT,
  "num_pages_per_million_10y_avg" FLOAT
);

Guardian Mentions 1

@owid.guardian_mentions.owid_guardian_mentions_1

99.25 kB
2,875 rows
10 columns

CREATE TABLE owid_guardian_mentions_1 (
  "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
);

Country Mentions In The Guardian Articles

@owid.guardian_mentions.owid_guardian_mentions_2

62.87 kB
3,086 rows
6 columns

CREATE TABLE owid_guardian_mentions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "num_pages" UINTEGER,
  "relative_pages" FLOAT,
  "relative_pages_excluded" FLOAT,
  "num_pages_per_million" FLOAT
);