Amazon Brands And Exclusives

CREATE TABLE amazon_trademarked_brands (
  "word_mark" VARCHAR,
  "goods_and_services" VARCHAR,
  "filing_date" VARCHAR,
  "owner" VARCHAR
);

CREATE TABLE appendix_rf_ablation_feature_permutations (
  "cols" VARCHAR,
  "accuracy" DOUBLE
);

CREATE TABLE appendix_rf_singlefeature (
  "feature" VARCHAR,
  "accuracy" DOUBLE
);

CREATE TABLE combined_queries_with_source (
  "search_term" VARCHAR,
  "source" VARCHAR
);

CREATE TABLE fig2_scatter (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "category" VARCHAR,
  "perc_products" DOUBLE,
  "perc_1_spot" DOUBLE  -- Perc #1 Spot,
  "perc_first_row" DOUBLE
);

CREATE TABLE fig3a_heatmap_amzn (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "product_order" DOUBLE
);

CREATE TABLE fig3b_heatmap_unaffilated (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "product_order" DOUBLE
);

CREATE TABLE fig3c_heatmap_sponsored (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "product_order" DOUBLE
);

CREATE TABLE fig4_panel_brands (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "brand" VARCHAR,
  "is_an_amazon_product" BIGINT,
  "is_not_an_amazon_product" BIGINT,
  "not_sure" BIGINT
);

CREATE TABLE fig5_panel_ranking (
  "trait" VARCHAR,
  "n__of_panelists" BIGINT  -- % Of Panelists
);

CREATE TABLE fig6_rf_feature_importance (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "n_0" DOUBLE  -- 0
);

CREATE TABLE fig7_1vn (
  "all_features" DOUBLE,
  "without_stars_delta" DOUBLE,
  "without_reviews_delta" DOUBLE,
  "without_is_amazon" DOUBLE,
  "without_is_shipped_by_amazon" DOUBLE,
  "without_is_sold_by_amazon" DOUBLE,
  "without_is_top_clicked" DOUBLE,
  "without_random_noise" DOUBLE,
  "up_to_product" BIGINT
);

CREATE TABLE quality_and_sales_comparisons (
  "search_term" VARCHAR,
  "position_first_amazon" DOUBLE,
  "position_first_non_amazon" BIGINT,
  "position_first_wholly_non_amazon" DOUBLE,
  "amazon_stars" DOUBLE,
  "amazon_reviews" DOUBLE,
  "non_amazon_stars" DOUBLE,
  "non_amazon_reviews" DOUBLE,
  "wnon_amazon_stars" DOUBLE,
  "wnon_amazon_reviews" DOUBLE
);

CREATE TABLE table1_not_always_labelled (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "percentage" DOUBLE
);

CREATE TABLE table2_panel_ranking (
  "trait" VARCHAR,
  "n__of_panelists" BIGINT  -- % Of Panelists
);

CREATE TABLE table2_rf_ablationstudy (
  "feature" VARCHAR,
  "accuracy" DOUBLE,
  "change_of_accuracy" DOUBLE
);

CREATE TABLE table3_appendix_generic (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "top_searches" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "generic_searches" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);