Dataset: Clash Of Clans Clans Dataset 2023 (3.5M Clans)

About this Dataset

Clash Of Clans Clans Dataset 2023 (3.5M Clans)

Clash of Clans is a popular mobile game with millions of players worldwide. This dataset contains detailed information about clans in Clash of Clans, including their tags, names, descriptions, locations, points, war statistics, member details, and more.

With this dataset as a snapshot of the game eco-system as of 2023, you can analyze clan performance, identify trends, and gain insights into the game's community dynamics.

Interesting Task Ideas:

Visualize the distribution of clan points and member levels to identify high-performing clans.
Analyze war statistics to find the most successful clans in terms of win streaks, war wins, and ties.
Determine the most popular clan banners.
Investigate the correlation between clan location and clan popularity (or the countries where Clash of Clans is most popular).
Find the countries with the highest-ranked players.
Identify the most and least family-friendly clans based on the provided flag.
Determine the percentage of clans that focus on the Builder Base or Clan Capital.
Analyze the distribution of clans in terms of clan points, clan level, clan capital level, etc.

If you find this dataset valuable, don't forget to hit the upvote button! 😊💝

Check out my other dataset

Non-High School Wage Penalty

Productivity and Hourly Compensation

Wages by Education in the USA

13K Reddit Tips

Health Insurance Coverage in the USA

Photo by HR.Mavchi

Tables

Coc Clans Dataset

@kaggle.asaniczka_clash_of_clans_clans_dataset_2023_3_5m_clans.coc_clans_dataset

293.97 MB
3559743 rows
27 columns


CREATE TABLE coc_clans_dataset (
  "clan_tag" VARCHAR,
  "clan_name" VARCHAR,
  "clan_type" VARCHAR,
  "clan_description" VARCHAR,
  "clan_location" VARCHAR,
  "isfamilyfriendly" BOOLEAN,
  "clan_badge_url" VARCHAR,
  "clan_level" BIGINT,
  "clan_points" BIGINT,
  "clan_builder_base_points" BIGINT,
  "clan_versus_points" BIGINT,
  "required_trophies" BIGINT,
  "war_frequency" VARCHAR,
  "war_win_streak" BIGINT,
  "war_wins" BIGINT,
  "war_ties" BIGINT,
  "war_losses" BIGINT,
  "clan_war_league" VARCHAR,
  "num_members" BIGINT,
  "required_builder_base_trophies" BIGINT,
  "required_versus_trophies" BIGINT,
  "required_townhall_level" BIGINT,
  "clan_capital_hall_level" BIGINT,
  "clan_capital_points" BIGINT,
  "capital_league" VARCHAR,
  "mean_member_level" BIGINT,
  "mean_member_trophies" BIGINT
);