home / fivethirtyeight

Comic Characters: marvel-wikia-data.csv

This table contains data behind the story Comic Books Are Still Made By Men, For Men And About Men.

The data comes from Marvel Wikia and DC Wikia. Characters were scraped on August 24. Appearance counts were scraped on September 2. The month and year of the first issue each character appeared in was pulled on October 6.

The data is split into two files, for DC and Marvel, respectively: dc-wikia-data.csv and marvel-wikia-data.csv. Each file has the following variables:

Variable Definition
page_id The unique identifier for that characters page within the wikia
name The name of the character
urlslug The unique url within the wikia that takes you to the character
ID The identity status of the character (Secret Identity, Public identity, [on marvel only: No Dual Identity])
ALIGN If the character is Good, Bad or Neutral
EYE Eye color of the character
HAIR Hair color of the character
SEX Sex of the character (e.g. Male, Female, etc.)
GSM If the character is a gender or sexual minority (e.g. Homosexual characters, bisexual characters)
ALIVE If the character is alive or deceased
APPEARANCES The number of appareances of the character in comic books (as of Sep. 2, 2014. Number will become increasingly out of date as time goes on.)
FIRST APPEARANCE The month and year of the character's first appearance in a comic book, if available
YEAR The year of the character's first appearance in a comic book, if available

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

20 rows where ALIGN = "Bad Characters", EYE = "Yellow Eyes" and ID = "Public Identity"

View and edit SQL

Suggested facets: HAIR, ALIVE, APPEARANCES, FIRST APPEARANCE, Year

SEX

ID

EYE

ALIGN

Link rowid page_id name urlslug ID ALIGN EYE HAIR SEX GSM ALIVE APPEARANCES FIRST APPEARANCE Year
518 1747 John Horton (Earth-616) \/John_Horton_(Earth-616) Public Identity Bad Characters Yellow Eyes Yellow Hair Male Characters   Living Characters 74 Nov-72 1972
2537 120939 Kyknos (Earth-616) \/Kyknos_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Deceased Characters 14 Jun-08 2008
5038 594213 Uthana Thoth (Earth-616) \/Uthana_Thoth_(Earth-616) Public Identity Bad Characters Yellow Eyes White Hair Male Characters   Living Characters 6 Nov-10 2010
5116 21171 Gargantus (Aquatic Monster) (Earth-616) \/Gargantus_(Aquatic_Monster)_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Living Characters 5 Jan-61 1961
5158 15956 Andro (Earth-616) \/Andro_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Living Characters 5 Aug-70 1970
5600 243064 Una-Rogg (Earth-616) \/Una-Rogg_(Earth-616) Public Identity Bad Characters Yellow Eyes Black Hair Female Characters   Living Characters 5 Jan-01 2001
5813 513813 Gari Oyle (Earth-616) \/Gari_Oyle_(Earth-616) Public Identity Bad Characters Yellow Eyes Brown Hair Female Characters   Living Characters 5 Apr-12 2012
6212 93609 Dyvyne (Earth-616) \/Dyvyne_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Living Characters 4 May-85 1985
6469 249107 Kyle Barker (Earth-616) \/Kyle_Barker_(Earth-616) Public Identity Bad Characters Yellow Eyes Brown Hair Male Characters   Living Characters 4 Jan-96 1996
6839 594217 Phanto (Earth-616) \/Phanto_(Earth-616) Public Identity Bad Characters Yellow Eyes Red Hair Male Characters   Living Characters 4 Nov-10 2010
8236 594211 Thane (Ano-Athox) (Earth-616) \/Thane_(Ano-Athox)_(Earth-616) Public Identity Bad Characters Yellow Eyes Red Hair Male Characters   Deceased Characters 3 Nov-10 2010
10120 509835 Mung (Earth-616) \/Mung_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Living Characters 2 Apr-06 2006
10213 316410 Skee (Earth-616) \/Skee_(Earth-616) Public Identity Bad Characters Yellow Eyes   Male Characters   Living Characters 2 Oct-08 2008
10265 594215 Fex (Earth-616) \/Fex_(Earth-616) Public Identity Bad Characters Yellow Eyes Red Hair Male Characters   Living Characters 2 Nov-10 2010
10330 440187 Xirdal (Earth-616) \/Xirdal_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Female Characters   Deceased Characters 2 Jan-11 2011
10414 744912 Adomox (Earth-616) \/Adomox_(Earth-616) Public Identity Bad Characters Yellow Eyes Blond Hair Male Characters   Living Characters 2    
12857 413916 Gormagga Kraal (Earth-616) \/Gormagga_Kraal_(Earth-616) Public Identity Bad Characters Yellow Eyes   Male Characters   Living Characters 1 Jan-89 1989
13934 507755 Kronaster Sintariis (Earth-616) \/Kronaster_Sintariis_(Earth-616) Public Identity Bad Characters Yellow Eyes No Hair Male Characters   Living Characters 1 Oct-00 2000
14757 474740 Cronk (Earth-616) \/Cronk_(Earth-616) Public Identity Bad Characters Yellow Eyes Bald Male Characters   Deceased Characters 1 Dec-10 2010
14833 594216 Thela (Earth-616) \/Thela_(Earth-616) Public Identity Bad Characters Yellow Eyes Red Hair Female Characters   Living Characters 1 Nov-10 2010

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "comic-characters/marvel-wikia-data" (
"page_id" INTEGER,
  "name" TEXT,
  "urlslug" TEXT,
  "ID" TEXT,
  "ALIGN" TEXT,
  "EYE" TEXT,
  "HAIR" TEXT,
  "SEX" TEXT,
  "GSM" REAL,
  "ALIVE" TEXT,
  "APPEARANCES" INTEGER,
  "FIRST APPEARANCE" TEXT,
  "Year" INTEGER
)
Powered by Datasette · Query took 138.104ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub