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
Original source
Original Author: The Markup
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?
- Study SEO strategies used by different companies
- Understand how people use Google search to find information
- Analyze the results of Google search queries
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.
File: adrianne-pixel-errors.csv
| Column name | Description |
|---|---|
| **** | |
| ads | |
| non-google | |
| amp |
File: leon-pixel-errors.csv
| Column name | Description |
|---|---|
| **** | |
| amp | |
| 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) |
CREATE TABLE adrianne_pixel_errors (
"unnamed_0" VARCHAR -- Unnamed: 0,
"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 -- Unnamed: 0,
"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 -- Unnamed: 0,
"top_of_page" VARCHAR,
"top_of_page_1" VARCHAR,
"first_full_page" VARCHAR,
"first_full_page_1" 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 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 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 -- Unnamed: 0,
"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
);Anyone who has the link will be able to view this.