fivethirtyeight

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

Custom SQL query returning 3 rows (hide)

select * from "avengers/avengers" where "URL" like '%' || :search || '%' or "Name/Alias" like '%' || :search || '%' or "Appearances" like '%' || :search || '%' or "Current?" like '%' || :search || '%' or "Gender" like '%' || :search || '%' or "Probationary Introl" like '%' || :search || '%' or "Full/Reserve Avengers Intro" like '%' || :search || '%' or "Year" like '%' || :search || '%' or "Years since joining" like '%' || :search || '%' or "Honorary" like '%' || :search || '%' or "Death1" like '%' || :search || '%' or "Return1" like '%' || :search || '%' or "Death2" like '%' || :search || '%' or "Return2" like '%' || :search || '%' or "Death3" like '%' || :search || '%' or "Return3" like '%' || :search || '%' or "Death4" like '%' || :search || '%' or "Return4" like '%' || :search || '%' or "Death5" like '%' || :search || '%' or "Return5" like '%' || :search || '%' or "Notes" like '%' || :search || '%'

Query parameters

This data as json, copyable, CSV

URL	Name/Alias	Appearances	Current?	Gender	Probationary Introl	Full/Reserve Avengers Intro	Year	Years since joining	Honorary	Death1	Return1	Death2	Return2	Notes
http://marvel.wikia.com/Patricia_Walker_(Earth-616)#	Patsy Walker	557	NO	FEMALE	Nov-75	Sep-76	1976	39	Full	YES	YES			Died during time on Defenders. Eventually ressurected by villian Grim Reaper along with Mockingbird to fight the Avengers.
http://marvel.wikia.com/Anthony_Druid_(Earth-616)#	Anthony Ludgate Druid	158	NO	MALE		Apr-87	1987	28	Honorary	YES	YES	YES	YES	Shot with a Breathing gun and corpse dumped in trash. Revived by the Grim Reaper. Helped Avengers defeat the Reaper so his spirit could remain at peace. Later completely revived by the Chaos King.
http://marvel.wikia.com/Eric_Masterson_(Earth-616)#	Eric Kevin Masterson	202	NO	MALE		Jan-92	1992	23	Full	YES	YES	YES	NO	Became posessed died to purge self of corruption. Revived as undead Avenger minion of the Grim Reaper. Returned to the spirit world by the Scarlet Witch. Has since stayed dead.