Name: Google Search Audit
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Google Search Audit

Dataset from "Google’s Top Search Result? Surprise! It’s Google"

Original source
Original Author: The Markup

About this dataset

Do you ever feel like you're stuck in a never-ending cycle of Googling things and getting lost in a sea of results? Wouldn't it be great if there was a way to see which results were the most useful before you even started clicking?

Research Ideas

Study SEO strategies used by different companies

Understand how people use Google search to find information

Analyze the results of Google search queries

Acknowledgements

License

> License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
> No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: adrianne-pixel-errors.csv

Column name	Description
****
google
ads
non-google
amp

File: leon-pixel-errors.csv

Column name	Description
****
amp
google
ads
non-google

File: 2-normalized-bar.csv

Column name	Description
****
Non-Google	The domain where the result was found. (String)

File: 3-distance_normalized.csv

Column name	Description
category	The category of the video. (String)
dist	The distribution of the video. (Float)
dist_median	The median of the distribution of the video. (Float)
min	The minimum value of the distribution of the video. (Float)
25	The 25th percentile of the distribution of the video. (Float)
50	The 50th percentile of the distribution of the video. (Float)
75	The 75th percentile of the distribution of the video. (Float)
max	The maximum value of the distribution of the video. (Float)
std	The standard deviation of the distribution of the video. (Float)
sem_error	The standard error of the mean of the distribution of the video. (Float)
descriptive_name	The name of the video. (String)

File: 4-soup.csv

Column name	Description
quantile	The quantile of the search result. (Numeric)
Organic	The organic search results. (Text)
AMP	The AMP search results. (Text)
Google Answer	The Google Answer search results. (Text)
Google Product	The Google Product search results. (Text)
Ads	The Ads search results. (Text)

File: 5-area-range.csv

Column name	Description
****
First Screen	The text of the result. (String)
Full Page	The domain where the result was found. (String)

File: T1_area_freq_by_category.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First page	The first result on the page. (String)

File: Business.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Entertainment.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Health.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Multiple Categories.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Science and Tech.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Sports.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: Top Stories.csv

Column name	Description
****
Top of page	The top result on the page. (String)
First full page	The first full page of results. (String)

File: ads_aria_parser_results.csv

Column name	Description
category	The category of the video. (String)
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ads_general_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ads_gws_refinement_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ads_local_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ads_product_refinements_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: amp_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: answer_dropdown_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: button_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: category_bar_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: date_answer_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: dict_def_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ebook_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: expand_answer_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: expanded_answer_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: featured_snippet_answer_short_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: filter_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: food_nutrition_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: fullpage_popup_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: img_reverse_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: knowledge_panel_answer_2_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: knowledge_panel_answer_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: knowledge_panel_factoids_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: knowledge_panel_title_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: link_3d_ar_model_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: link_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: links_alt_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: load_more_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_details_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_hours_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_map_result_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_menu_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_popular_times_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: local_qa_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: lyric_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: map_img_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: med_answer_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: movie_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: movie_showtimes_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: post_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: product_refinement_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: quote_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: rating_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: related_local_biz_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: reviews_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: rich_text_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: search_review_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: site_search_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: sport_stats_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: tab_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: tv_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: tweet_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: ugc_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: video_top_answers_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

File: watchlist_parser_results.csv

Column name	Description
text	The text of the search result. (String)
link	The link to the search result. (String)
domain	The domain where the search result was found. (String)
xpath	The xpath to the search result. (String)
element_class	The element class of the search result. (String)
category	The category of the video. (String)
tag	The tag of the search result. (String)
attrs	The attributes of the search result. (String)
filename	The filename of the search result. (String)

Tables

Knowledge Panel Factoids Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.knowledge_panel_factoids_parser_results

53.66 KB
807 rows
10 columns


CREATE TABLE knowledge_panel_factoids_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Knowledge Panel Title Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.knowledge_panel_title_parser_results

28.24 KB
17 rows
10 columns


CREATE TABLE knowledge_panel_title_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Leon Pixel Errors

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.leon_pixel_errors

5.26 KB
30 rows
5 columns


CREATE TABLE leon_pixel_errors (
  "unnamed_0" VARCHAR,
  "amp" DOUBLE,
  "google" DOUBLE,
  "ads" DOUBLE,
  "non_google" DOUBLE
);

Link 3d Ar Model Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.link_3d_ar_model_parser_results

23.65 KB
1 row
10 columns


CREATE TABLE link_3d_ar_model_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Link Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.link_parser_results

2.24 MB
3813 rows
10 columns


CREATE TABLE link_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Links Alt Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.links_alt_parser_results

20.63 KB
5 rows
10 columns


CREATE TABLE links_alt_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Load More Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.load_more_parser_results

43.24 KB
99 rows
10 columns


CREATE TABLE load_more_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Details Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_details_parser_results

16.34 KB
1 row
10 columns


CREATE TABLE local_details_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Hours Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_hours_parser_results

15.18 KB
2 rows
10 columns


CREATE TABLE local_hours_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Map Result Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_map_result_parser_results

21.23 KB
9 rows
10 columns


CREATE TABLE local_map_result_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Menu Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_menu_parser_results

12.19 KB
1 row
10 columns


CREATE TABLE local_menu_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Popular Times Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_popular_times_parser_results

37.38 KB
13 rows
10 columns


CREATE TABLE local_popular_times_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Local Qa Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.local_qa_parser_results

22.48 KB
3 rows
10 columns


CREATE TABLE local_qa_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Lyric Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.lyric_parser_results

18.08 KB
1 row
10 columns


CREATE TABLE lyric_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Map Img Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.map_img_parser_results

26.92 KB
4 rows
10 columns


CREATE TABLE map_img_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Med Answer Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.med_answer_parser_results

64.85 KB
19 rows
10 columns


CREATE TABLE med_answer_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Movie Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.movie_parser_results

69.44 KB
1 row
10 columns


CREATE TABLE movie_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Movie Showtimes Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.movie_showtimes_parser_results

12.57 KB
7 rows
10 columns


CREATE TABLE movie_showtimes_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Multiple Categories

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.multiple_categories

4.45 KB
6 rows
5 columns


CREATE TABLE multiple_categories (
  "unnamed_0" VARCHAR,
  "top_of_page" VARCHAR,
  "top_of_page_1" VARCHAR,
  "first_full_page" VARCHAR,
  "first_full_page_1" VARCHAR
);

N 2 Normalized Bar

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.n_2_normalized_bar

2.85 KB
4 rows
3 columns


CREATE TABLE n_2_normalized_bar (
  "unnamed_0" VARCHAR,
  "googe" DOUBLE,
  "non_google" DOUBLE
);

N 3 Distance Normalized

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.n_3_distance_normalized

9.3 KB
10 rows
12 columns


CREATE TABLE n_3_distance_normalized (
  "category" VARCHAR,
  "dist" DOUBLE,
  "dist_median" DOUBLE,
  "min" DOUBLE,
  "n_25" DOUBLE,
  "n_50" DOUBLE,
  "n_75" DOUBLE,
  "max" DOUBLE,
  "std" DOUBLE,
  "sem_error" DOUBLE,
  "n" BIGINT,
  "descriptive_name" VARCHAR
);

N 4 Soup

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.n_4_soup

6.92 KB
50 rows
6 columns


CREATE TABLE n_4_soup (
  "quantile" VARCHAR,
  "organic" DOUBLE,
  "amp" DOUBLE,
  "google_answer" DOUBLE,
  "google_product" DOUBLE,
  "ads" DOUBLE
);

N 5 Area Range

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.n_5_area_range

4.56 KB
8 rows
5 columns


CREATE TABLE n_5_area_range (
  "unnamed_0" VARCHAR,
  "first_screen" VARCHAR,
  "first_screen_1" VARCHAR,
  "full_page" VARCHAR,
  "full_page_1" VARCHAR
);

Post Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.post_parser_results

50.14 KB
6 rows
10 columns


CREATE TABLE post_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);

Product Refinement Parser Results

@kaggle.thedevastator_a_large_scale_analysis_of_google_search.product_refinement_parser_results

40.22 KB
9 rows
10 columns


CREATE TABLE product_refinement_parser_results (
  "text" VARCHAR,
  "link" VARCHAR,
  "domain" VARCHAR,
  "xpath" VARCHAR,
  "element_class" VARCHAR,
  "category" VARCHAR,
  "element" VARCHAR,
  "tag" VARCHAR,
  "attrs" VARCHAR,
  "filename" VARCHAR
);