Google Search Audit
Dataset from "Google’s Top Search Result? Surprise! It’s Google"
@kaggle.thedevastator_a_large_scale_analysis_of_google_search
Dataset from "Google’s Top Search Result? Surprise! It’s Google"
@kaggle.thedevastator_a_large_scale_analysis_of_google_search
CREATE TABLE n_2_normalized_bar (
"unnamed_0" VARCHAR,
"googe" DOUBLE,
"non_google" DOUBLE
);
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
);
CREATE TABLE n_4_soup (
"quantile" VARCHAR,
"organic" DOUBLE,
"amp" DOUBLE,
"google_answer" DOUBLE,
"google_product" DOUBLE,
"ads" DOUBLE
);
CREATE TABLE n_5_area_range (
"unnamed_0" VARCHAR,
"first_screen" VARCHAR,
"first_screen_1" VARCHAR,
"full_page" VARCHAR,
"full_page_1" VARCHAR
);
CREATE TABLE adrianne_pixel_errors (
"unnamed_0" VARCHAR,
"google" DOUBLE,
"ads" DOUBLE,
"non_google" DOUBLE,
"amp" DOUBLE
);
CREATE TABLE ads_aria_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ads_general_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ads_gws_refinement_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ads_local_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ads_product_refinements_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE amp_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE answer_dropdown_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE business (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE button_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE category_bar_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE date_answer_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE dict_def_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ebook_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE entertainment (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE expanded_answer_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE expand_answer_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE featured_snippet_answer_short_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE filter_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE food_nutrition_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE fullpage_popup_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE health (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE img_reverse_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE knowledge_panel_answer_2_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE knowledge_panel_answer_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
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
);
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
);
CREATE TABLE leon_pixel_errors (
"unnamed_0" VARCHAR,
"amp" DOUBLE,
"google" DOUBLE,
"ads" DOUBLE,
"non_google" DOUBLE
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
CREATE TABLE quote_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE rating_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE related_local_biz_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE reviews_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE rich_text_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE science_and_tech (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE search_review_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE site_search_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE sports (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE sport_stats_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE t1_area_freq_by_category (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_page" VARCHAR,
"first_page_1" VARCHAR
);
CREATE TABLE tab_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE top_stories (
"unnamed_0" VARCHAR,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" VARCHAR
);
CREATE TABLE tv_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE tweet_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE ugc_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE video_top_answers_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
CREATE TABLE watchlist_parser_results (
"text" VARCHAR,
"link" VARCHAR,
"domain" VARCHAR,
"xpath" VARCHAR,
"element_class" VARCHAR,
"category" VARCHAR,
"element" VARCHAR,
"tag" VARCHAR,
"attrs" VARCHAR,
"filename" VARCHAR
);
Anyone who has the link will be able to view this.