Sports Shoes Brands

CREATE TABLE brands (
  "name" VARCHAR,
  "site" VARCHAR,
  "wikipedia" VARCHAR,
  "wikipedia_languages_num" BIGINT,
  "twitter" VARCHAR,
  "twitter_following" BIGINT,
  "twitter_followers" BIGINT,
  "twitter_tweets" BIGINT,
  "twitter_verified" VARCHAR,
  "facebook" VARCHAR,
  "facebook_likes" VARCHAR,
  "facebook_followers" VARCHAR,
  "facebook_verified" VARCHAR,
  "instagram" VARCHAR,
  "instagram_posts" BIGINT,
  "instagram_followers" VARCHAR,
  "instagram_following" BIGINT,
  "instagram_verified" VARCHAR,
  "instagram_socialstates_engagement" DOUBLE,
  "youtube" VARCHAR,
  "youtube_subscribers" VARCHAR,
  "youtube_videos" BIGINT,
  "youtube_views" BIGINT,
  "youtube_verified" VARCHAR,
  "youtube_joined" TIMESTAMP,
  "tiktok" VARCHAR,
  "tiktok_following" VARCHAR,
  "tiktok_followers" VARCHAR,
  "tiktok_likes" VARCHAR,
  "tiktok_verified" VARCHAR,
  "snapchat" VARCHAR,
  "snapchat_verified" VARCHAR,
  "pinterest" VARCHAR,
  "pinterest_followers" VARCHAR,
  "pinterest_following" VARCHAR,
  "pinterest_verified" VARCHAR,
  "linkedin" VARCHAR,
  "site_social_links" VARCHAR,
  "corewebvitals_mobile" VARCHAR,
  "corewebvitals_desktop" VARCHAR,
  "pagespeedweb_performance_m" BIGINT,
  "pagespeedweb_accessibility_m" BIGINT,
  "pagespeedweb_best_m" BIGINT,
  "pagespeedweb_ceo_m" BIGINT,
  "pagespeedweb_performance_d" BIGINT,
  "pagespeedweb_accessibility_d" BIGINT,
  "pagespeedweb_best_d" BIGINT,
  "pagespeedweb_d_ceo" BIGINT,
  "pagespeedweb_speed_index_m" VARCHAR,
  "pagespeedweb_speed_index_d" VARCHAR,
  "wikipedia_revenue" VARCHAR,
  "market_cap" VARCHAR,
  "zippia_revenue" VARCHAR,
  "zippia_local" VARCHAR,
  "indeed" VARCHAR,
  "indeed_wellbeing" VARCHAR,
  "indeed_stars" DOUBLE,
  "indeed_reviews" VARCHAR,
  "indeed_revenue" VARCHAR,
  "mozcom_domain_authority" BIGINT,
  "mozcom_linking_root_domains" VARCHAR,
  "mozcom_ranking_keywords" VARCHAR,
  "mozcom_spam_score" BIGINT
);

CREATE TABLE similarweb (
  "name" VARCHAR,
  "site" VARCHAR,
  "global_rank" BIGINT,
  "country_rank" BIGINT,
  "category_rank" BIGINT,
  "total_visits" VARCHAR,
  "bounce_rate" DOUBLE,
  "pages_per_visit" DOUBLE,
  "avg_visit_duration" VARCHAR,
  "country1_name" VARCHAR,
  "country1_percent" DOUBLE,
  "country2_name" VARCHAR,
  "country2_percent" DOUBLE,
  "country3_name" VARCHAR,
  "country3_percent" DOUBLE,
  "country4_name" VARCHAR,
  "country4_percent" DOUBLE,
  "country5_name" VARCHAR,
  "country5_percent" DOUBLE,
  "female" DOUBLE,
  "male" DOUBLE,
  "age_18_24" DOUBLE,
  "age_25_34" DOUBLE,
  "age_35_44" DOUBLE,
  "age_45_54" DOUBLE,
  "age_55_64" DOUBLE,
  "age_65_plus" DOUBLE,
  "marketing_direct" DOUBLE,
  "marketing_referrals" DOUBLE,
  "marketing_organic_search" DOUBLE,
  "marketing_paid_search" DOUBLE,
  "marketing_social" DOUBLE,
  "marketing_mail" DOUBLE,
  "marketing_display" DOUBLE,
  "total_keywords" VARCHAR,
  "organic_traffic" DOUBLE,
  "paid_traffic" DOUBLE,
  "referring_websites" BIGINT,
  "publishers" BIGINT,
  "ad_networks" BIGINT,
  "social_networks_number" BIGINT,
  "social1_name" VARCHAR,
  "social1_percent" DOUBLE,
  "social2_name" VARCHAR,
  "social2_percent" DOUBLE,
  "social3_name" VARCHAR,
  "social3_percent" DOUBLE,
  "social4_name" VARCHAR,
  "social4_percent" DOUBLE,
  "social5_name" VARCHAR,
  "social5_percent" DOUBLE,
  "total_outgoing_links" BIGINT,
  "total_technologies" BIGINT
);

CREATE TABLE tiktok (
  "name" VARCHAR,
  "views" VARCHAR,
  "description" VARCHAR,
  "img_alt" VARCHAR,
  "video_link" VARCHAR,
  "warn_info" VARCHAR
);