Baselight

DnD Characters

1.2 million full characters

@kaggle.maximebonnin_dnd_characters_test

Loading...
Loading...

About this Dataset

DnD Characters

I've tried to find a good dataset of D&D characters online but haven't really found much. There is a dataset on GitHub which includes about 8.000 entries. This is a nice start but I want more!

I am using python to get the data from dndbeyond characters. They include a lot of info and I don't think I can include all of it. The character IDs run up to at least 30 million, however since the free plan only includes limited characters the total amount will be lower. So far I have found about 70% of characters to be deleted. I expect less characters to be deleted in the higher numbers since they are newer. So I think around 10 million character sheets is a likely estimate.

However it takes a while to get all the data, so I want to be sure what I need before starting to collect it. So, what do you think should be included?

Tables

Over One Mil Chars

@kaggle.maximebonnin_dnd_characters_test.over_one_mil_chars
  • 82.31 MB
  • 1204252 rows
  • 23 columns
Loading...

CREATE TABLE over_one_mil_chars (
  "unnamed_0" BIGINT,
  "char_id" BIGINT,
  "name" VARCHAR,
  "base_hp" BIGINT,
  "stats_1" BIGINT,
  "stats_2" BIGINT,
  "stats_3" BIGINT,
  "stats_4" BIGINT,
  "stats_5" BIGINT,
  "stats_6" BIGINT,
  "background" VARCHAR,
  "race" VARCHAR,
  "class_starting" VARCHAR,
  "class_starting_level" BIGINT,
  "subclass_starting" VARCHAR,
  "class_other" VARCHAR,
  "subclass_other" VARCHAR,
  "total_level" BIGINT,
  "feats" VARCHAR,
  "inventory" VARCHAR,
  "date_modified" TIMESTAMP,
  "notes_len" BIGINT,
  "gold" DOUBLE
);

Share link

Anyone who has the link will be able to view this.