Baselight
Sign In

European Football (soccer) Clubs On Google SERPs

79 Teams' Keywords Positions in 7 Languages

@kaggle.eliasdabbas_european_football_soccer_clubs_on_google_serps

Serp Clubs
@kaggle.eliasdabbas_european_football_soccer_clubs_on_google_serps.serp_clubs

  • 4.09 MB
  • 5530 rows
  • 28 columns
hl

Hl

searchterms

SearchTerms

rank

Rank

title

Title

snippet

Snippet

displaylink

DisplayLink

link

Link

querytime

QueryTime

totalresults

TotalResults

cacheid

CacheId

count

Count

csename

CseName

cx

Cx

formattedsearchtime

FormattedSearchTime

formattedtotalresults

FormattedTotalResults

formattedurl

FormattedUrl

htmlformattedurl

HtmlFormattedUrl

htmlsnippet

HtmlSnippet

htmltitle

HtmlTitle

inputencoding

InputEncoding

kind

Kind

outputencoding

OutputEncoding

pagemap

Pagemap

safe

Safe

searchtime

SearchTime

startindex

StartIndex

fileformat

FileFormat

mime

Mime

enreal madrid football1Real Madrid CF | Official WebsiteReal Madrid official website with news, photos, videos and sale of tickets for the ... welcome one of the great defenses in world football", said Florentino Pérez.www.realmadrid.comhttps://www.realmadrid.com/en2019-07-12 12:00:17.776752+00:00309000000ufkNert3UXcJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.realmadrid.com/enhttps://www.<b>realmadrid</b>.com/en<b>Real Madrid</b> official website with news, photos, videos and sale of tickets for the <br> ... welcome one of the great defenses in world <b>football</b>&quot;, said Florentino Pérez.<b>Real Madrid</b> CF | Official Websiteutf8customsearch#resultutf8{'cse_thumbnail': [{'width': '345', 'height': '146', 'src': 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRfJl6u8YgVF9qLhboZZxyEB78fDlciBohbQ4IHOc93qEHeoee-pCS8A14'}], 'metatags': [{'viewport': 'width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no', 'apple-mobile-web-a…off0.3656751nannan
enreal madrid football2Real Madrid CF - WikipediaReal Madrid Club de Fútbol commonly referred to as Real Madrid, is a Spanish professional football club based in Madrid. Founded on 6 March 1902 as the ...en.wikipedia.orghttps://en.wikipedia.org/wiki/Real_Madrid_CF2019-07-12 12:00:17.776752+00:003090000008h4sB2TyUxkJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://en.wikipedia.org/wiki/Real_Madrid_CFhttps://en.wikipedia.org/wiki/<b>Real</b>_<b>Madrid</b>_CF<b>Real Madrid</b> Club de Fútbol commonly referred to as <b>Real Madrid</b>, is a Spanish <br> professional <b>football</b> club based in Madrid. Founded on 6 March 1902 as the&nbsp;...<b>Real Madrid</b> CF - Wikipediautf8customsearch#resultutf8{'cse_thumbnail': [{'width': '130', 'height': '182', 'src': 'https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQUo9rBZ8F0tOAXgIzHNXMg-haabP0udrvJHH_Vf2cUvqOYHJm8UE8v6dI'}], 'metatags': [{'referrer': 'origin', 'og:image': 'https://upload.wikimedia.org/wikipedia/en/thumb/5/56/Real_Madrid_CF.svg/12…off0.3656751nannan
enreal madrid football3Real Madrid Football and News | Real Madrid CFNews. Militão's presentation at the Santiago Bernabéu. "We are happy because we welcome one of the great defenses in world football", said Florentino Pérez.www.realmadrid.comhttps://www.realmadrid.com/en/football2019-07-12 12:00:17.776752+00:00309000000U6M06aIEUXYJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.realmadrid.com/en/footballhttps://www.<b>realmadrid</b>.com/en/<b>football</b>News. Militão&#39;s presentation at the Santiago Bernabéu. &quot;We are happy because <br> we welcome one of the great defenses in world <b>football</b>&quot;, said Florentino Pérez.<b>Real Madrid Football</b> and News | Real Madrid CFutf8customsearch#resultutf8{'cse_thumbnail': [{'width': '150', 'height': '150', 'src': 'https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcSb23zdjWCIrZ_jWr3rCyCjJ5emSSA8IkIAH1V-p0ROvID7nPHWYruyznmp'}], 'sportsteam': [{'name': 'OUR TEAM'}], 'metatags': [{'viewport': 'width=device-width, initial-scale=1.0, maximum-scale=1.0,…off0.3656751nannan
enreal madrid football4Real MadridCompet. Partido, Resultado. Liga, R. Madrid-Betis, 0-2. Liga, R. Sociedad-R. Madrid, 3-1. Liga, R. Madrid-Villarreal, 3-2. Liga, Rayo-R. Madrid, 1-0.www.marca.comhttps://www.marca.com/en/football/real-madrid.html2019-07-12 12:00:17.776752+00:00309000000Is7S0CX_fmUJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.marca.com/en/football/real-madrid.htmlhttps://www.marca.com/en/<b>football</b>/<b>real</b>-<b>madrid</b>.htmlCompet. Partido, Resultado. Liga, <b>R</b>. <b>Madrid</b>-Betis, 0-2. Liga, R. Sociedad-<b>R</b>. <br> <b>Madrid</b>, 3-1. Liga, <b>R</b>. <b>Madrid</b>-Villarreal, 3-2. Liga, Rayo-<b>R</b>. <b>Madrid</b>, 1-0.<b>Real Madrid</b>utf8customsearch#resultutf8{'cse_thumbnail': [{'width': '298', 'height': '169', 'src': 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR_7qek33ykxWYy3TaWGxUgIHx5MMtRwKJW9bXK2OYzKVHtHCIQ7lGQI2Y'}], 'metatags': [{'theme-color': '#CC0000', 'organization': 'Unidad Editorial Información Deportiva S.L.', 'dc.date.issued': '2…off0.3656751nannan
enreal madrid football5Real Madrid News | Los Merengues News - NewsNowBreaking news headlines about Real Madrid, linking to 1000s of sources ... has been left out of Real Madrid tour squad amid Arsenal & Spurs links Football.www.newsnow.co.ukhttps://www.newsnow.co.uk/h/Sport/Football/La+Liga/Real+Madrid2019-07-12 12:00:17.776752+00:00309000000XWS-tFRPECoJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.newsnow.co.uk/h/Sport/Football/La.../Real+Madridhttps://www.newsnow.co.uk/h/Sport/<b>Football</b>/La.../<b>Real</b>+<b>Madrid</b>Breaking news headlines about <b>Real Madrid</b>, linking to 1000s of sources ... has <br> been left out of <b>Real Madrid</b> tour squad amid Arsenal &amp; Spurs links <b>Football</b>.Real Madrid News | Los Merengues News - NewsNowutf8customsearch#resultutf8{'cse_thumbnail': [{'width': '265', 'height': '190', 'src': 'https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcRb9vW1yFm6e2A0-xxt6l0iM0rN4lg-otHXZ8hAJE0U6A9-dEYZiop5eCk'}], 'metatags': [{'referrer': 'origin', 'viewport': 'initial-scale=1, width=device-width', 'apple-mobile-web-app-title': 'NewsN…off0.3656751nannan
enreal madrid football6Éder Militão falls ill during Real Madrid unveiling – video | Football ...1 day ago ... Real Madrid's new signing Éder Militão's introductory news conference was brought to a halt on Wednesday when the Brazilian complained of ...www.theguardian.comhttps://www.theguardian.com/football/video/2019/jul/10/eder-militao-falls-ill-during-real-madrid-unveiling-video2019-07-12 12:00:17.776752+00:00309000000Osp1Ejbj2ukJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.theguardian.com/football/.../eder-militao-falls-ill-during-real- madrid-unveiling-videohttps://www.theguardian.com/<b>football</b>/.../eder-militao-falls-ill-during-<b>real</b>- <b>madrid</b>-unveiling-video1 day ago <b>...</b> <b>Real Madrid&#39;s</b> new signing Éder Militão&#39;s introductory news conference was <br> brought to a halt on Wednesday when the Brazilian complained of&nbsp;...Éder Militão falls ill during <b>Real Madrid</b> unveiling – video | <b>Football</b> ...utf8customsearch#resultutf8{'thumbnail': [{'src': 'https://i.guim.co.uk/img/media/c8c04d59ac27c6d591a2c9f0a84bf99d494845d1/0_117_3500_2100/master/3500.jpg?width=620&quality=85&auto=format&fit=max&s=ec705072da6e09d6371b67d7d76335c9'}], 'metatags': [{'format-detection': 'telephone=no', 'handheldfriendly': 'True', 'viewport': 'w…off0.3656751nannan
enreal madrid football7Real Madrid - Football - BBC SportThe home of Real Madrid Football on BBC Sport online. Includes the latest news stories, results, fixtures, video and audio.www.bbc.comhttps://www.bbc.com/sport/football/teams/real-madrid2019-07-12 12:00:17.776752+00:00309000000lQ_1KU3V8_MJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.bbc.com/sport/football/teams/real-madridhttps://www.bbc.com/sport/<b>football</b>/teams/<b>real</b>-<b>madrid</b>The home of <b>Real Madrid Football</b> on BBC Sport online. Includes the latest news <br> stories, results, fixtures, video and audio.<b>Real Madrid</b> - <b>Football</b> - BBC Sportutf8customsearch#resultutf8{'cse_thumbnail': [{'width': '225', 'height': '225', 'src': 'https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQ0U7_AZuqc456BKk2BVArnK7AwcGlk_PkW0O4Pme0EI18EW4wZwX2djb4'}], 'metatags': [{'og:site_name': 'BBC Sport', 'apple-mobile-web-app-title': 'BBC Sport', 'apple-itunes-app': 'app-id=377388936…off0.3656751nannan
enreal madrid football8Real Madrid - Football Statistics | WhoScored.comReal Madrid (Spain) statistics – Check out detailed statistics, fixtures, player & team ratings, squad, top players, formation summary, goals, assists, charts, tables  ...www.whoscored.comhttps://www.whoscored.com/Teams/52/Show/Spain-Real-Madrid2019-07-12 12:00:17.776752+00:00309000000_tRI5GqrQq8J10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.whoscored.com/Teams/52/Show/Spain-Real-Madridhttps://www.whoscored.com/Teams/52/Show/Spain-<b>Real</b>-<b>Madrid</b><b>Real Madrid</b> (Spain) statistics – Check out detailed statistics, fixtures, player &amp; <br> team ratings, squad, top players, formation summary, goals, assists, charts, tables<br> &nbsp;...<b>Real Madrid</b> - <b>Football</b> Statistics | WhoScored.comutf8customsearch#resultutf8{'metatags': [{'apple-itunes-app': 'app-id=940048063', 'p:domain_verify': '353f79d2d02f885b1a54bBffe7ab9758f', 'title': 'Real Madrid'}]}off0.3656751nannan
enreal madrid football9Real Madrid - Sky Sports FootballReal Madrid Football Club - get the latest news, fixtures, results, match reports, videos, photos, squad and player stats on Sky Sports Football.www.skysports.comhttps://www.skysports.com/real-madrid2019-07-12 12:00:17.776752+00:00309000000mWhQnS1edVcJ10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.skysports.com/real-madridhttps://www.skysports.com/<b>real</b>-<b>madrid</b><b>Real Madrid Football</b> Club - get the latest news, fixtures, results, match reports, <br> videos, photos, squad and player stats on Sky Sports Football.<b>Real Madrid</b> - Sky Sports <b>Football</b>utf8customsearch#resultutf8{'cse_thumbnail': [{'width': '300', 'height': '168', 'src': 'https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcRtfDBKtaZWhVbcyvvcjdv8paHxVFBoPkPGiqOqhhyAIRJH38oxrhC2yHKB'}], 'metatags': [{'apple-mobile-web-app-capable': 'yes', 'apple-mobile-web-app-title': 'Sky Sports', 'application-name': 'SkyS…off0.3656751nannan
enreal madrid football10Real Madrid - Latest news, transfer gossip and insight - Mirror FootballThe most successful team in European Cup and Champions League history, Real Madrid are one of the biggest clubs in the world. Famed for their Galacticos in ...www.mirror.co.ukhttps://www.mirror.co.uk/all-about/real-madrid-cf2019-07-12 12:00:17.776752+00:00309000000nan10PySearch012859022920491477448:pubdbfjmmec0.37309,000,000https://www.mirror.co.uk/all-about/real-madrid-cfhttps://www.mirror.co.uk/all-about/<b>real</b>-<b>madrid</b>-cfThe most successful team in European Cup and Champions League history, <br> <b>Real Madrid</b> are one of the biggest clubs in the world. Famed for their Galacticos <br> in&nbsp;...<b>Real Madrid</b> - Latest news, transfer gossip and insight - Mirror <b>Football</b>utf8customsearch#resultutf8{'newsmediaorganization': [{'publishingprinciples': 'https://www.mirror.co.uk/about-us/', 'name': 'mirror', 'url': 'https://www.mirror.co.uk/'}], 'metatags': [{'viewport': 'width=device-width, minimum-scale=1, maximum-scale=1', 'referrer': 'unsafe-URL', 'advertisingconfig': '{"desktop":[{"injectionE…off0.3656751nannan

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
);

Share link

Anyone who has the link will be able to view this.