Baselight
Sign In

Search Engine Results - Flights & Tickets Keywords

Rankings for world top destinations on Google

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords

Loading...
Loading...

About this Dataset

Search Engine Results - Flights & Tickets Keywords

Context

One of the important tasks in SEO analysis, is to check rankings on search engines.
This dataset contains Google rankings for flights and tickets keywords.

It is basically en example dataset that can be generated with the serp_goog function from
advertools.

Content

100 Destinations
2 Keyword variations (flights to destination and tickets to destination)
2 Countries
10 Results each
= 4,000 rows
The same data set is produced every 15 days, in order to track the changes in ranks over time. Each file represents a point in time (either the 1st or the 15th of the month)

Acknowledgements

Python, requests, Google CSE, advertools, pandas

Inspiration

How competitive is the flights/tickets space?
Are there any dominant players?
Here is an article on SEMrush showing a few ways to analyze SERP data with Python

Tables

Flights Tickets Serp2018–12–16

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2018_12_16
  • 1.97 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–01–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_01_01
  • 2 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–01–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_01_15
  • 2 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–02–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_02_01
  • 2 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–02–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_02_15
  • 1.99 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–03–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_03_01
  • 1.99 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–03–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_03_15
  • 2.06 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–04–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_04_01
  • 2.06 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–04–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_04_15
  • 2.27 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–05–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_05_01
  • 2.25 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–05–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_05_15
  • 2.21 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–06–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_06_01
  • 2.19 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–06–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_06_15
  • 2.19 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–07–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_07_01
  • 2.14 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–07–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_07_15
  • 2.21 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–08–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_08_01
  • 2.21 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–08–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_08_15
  • 2.26 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–09–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_09_01
  • 2.26 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–09–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_09_15
  • 2.34 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2019–10–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2019_10_01
  • 2.37 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2020–02–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2020_02_15
  • 2.31 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2020–03–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2020_03_01
  • 2.31 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2020–03–15

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2020_03_15
  • 2.32 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Flights Tickets Serp2020–04–01

@kaggle.eliasdabbas_search_engine_results_flights_tickets_keywords.flights_tickets_serp2020_04_01
  • 2.39 MB
  • 4000 rows
  • 26 columns
Loading... 

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

Share link

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