Name: European Football (soccer) Clubs On Google SERPs
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

European Football (soccer) Clubs On Google SERPs

Context

Which sites are ranking highest for the top European Football (Soccer) clubs?
How are they ranking in different (7) languages?

Content

79 clubs
x 7 languages
x 10 results each
= 5,530 rows

Acknowledgements

Python, pandas, requests, plotly

Inspiration

It's interesting to know which domains are the strongest on such popular keywords.

Tables

Clubs

@kaggle.eliasdabbas_european_football_soccer_clubs_on_google_serps.clubs

7.97 kB
79 rows
9 columns

CREATE TABLE clubs (
  "club" VARCHAR,
  "country" VARCHAR,
  "ucl" BIGINT,
  "uel" BIGINT,
  "cwc" BIGINT,
  "usc" BIGINT,
  "uic" BIGINT,
  "ic" BIGINT,
  "total" BIGINT
);

Column Key

@kaggle.eliasdabbas_european_football_soccer_clubs_on_google_serps.column_key

2.38 kB
6 rows
2 columns

CREATE TABLE column_key (
  "abbreviation" VARCHAR,
  "tournament" VARCHAR
);

Serp Clubs

@kaggle.eliasdabbas_european_football_soccer_clubs_on_google_serps.serp_clubs

4.29 MB
5,530 rows
28 columns

CREATE TABLE serp_clubs (
  "hl" VARCHAR,
  "searchterms" VARCHAR,
  "rank" BIGINT,
  "title" VARCHAR,
  "snippet" VARCHAR,
  "displaylink" VARCHAR,
  "link" VARCHAR,
  "querytime" VARCHAR,
  "totalresults" BIGINT,
  "cacheid" VARCHAR,
  "count" BIGINT,
  "csename" VARCHAR,
  "cx" VARCHAR,
  "formattedsearchtime" DOUBLE,
  "formattedtotalresults" VARCHAR,
  "formattedurl" VARCHAR,
  "htmlformattedurl" VARCHAR,
  "htmlsnippet" VARCHAR,
  "htmltitle" VARCHAR,
  "inputencoding" VARCHAR,
  "kind" VARCHAR,
  "outputencoding" VARCHAR,
  "pagemap" VARCHAR,
  "safe" VARCHAR,
  "searchtime" DOUBLE,
  "startindex" BIGINT,
  "fileformat" VARCHAR,
  "mime" VARCHAR
);