View table: albums

Table structure:

1. name - String (mandatory)
2. cover - File
3. type - List of String, delimiter: , (mandatory; allowed values: ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotional)
4. artist - Page (mandatory; allowed values: The Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artists)
5. studio - List of String, delimiter: ,
6. producer - List of Page, delimiter: ,
7. engineer - List of Page, delimiter: ,
8. released - Date
9. discogs - Integer
10. musicbrainz - String

This table has 215 rows altogether.

Recreate data.

Page	name	cover	type	artist	studio	producer	engineer	released	discogs	musicbrainz
...This Would Be Paradise (edit)	This Would Be Paradise		ep	Melissa Auf der Maur		Chris Goss		2008-11-10	27,961	343bff42-bb46-36c1-8760-ea3214395b0b
20 Explosive Dynamic Super Smash Hit Explosions! (edit)	20 Explosive Dynamic Super Smash Hit Explosions!		compilation	Various artists				1991	83,634	21abc333-3be5-3307-9078-4aa8e28c586e
20 Explosive Dynamic Super Smash Hit Explosions! (edit)	20 Supersonic Mega Explosive Hits!		compilation	Various artists				1995
23 Minutes (edit)	23 Minutes		video • promotional	The Smashing Pumpkins				1993
3 Feet High (edit)	3 Feet High		bootleg • live	The Smashing Pumpkins				1994	620,738	b39ae361-ab3d-4286-8db0-c460302e737f
666 (edit)	666		bootleg • video	The Smashing Pumpkins	Pumpkinland			1996
A Gothic–Industrial Tribute to Smashing Pumpkins (edit)	A Gothic–Industrial Tribute to Smashing Pumpkins		tribute	Various artists				2001-01-23
A Very Special Christmas 3 (edit)	A Very Special Christmas 3		compilation	Various artists				1997-10-07	120,023	1f3eaa62-b1f0-3ec8-9281-97ab138ab89e
Acoustic Series (edit)	Acoustic Series		bootleg	The Smashing Pumpkins				1994
Adore (edit)	Adore		studio	The Smashing Pumpkins		Billy Corgan • Flood • Brad Wood		1998-06-02	48,743	359699b3-8118-369e-9591-c96dcd07a853
Adore Demos I (edit)	Adore Demos I		bootleg	The Smashing Pumpkins				February 1997
Adore Demos II (edit)	Adore Demos II		bootleg	The Smashing Pumpkins				1998
AEGEA (edit)	AEGEA		studio	Billy Corgan				2014-05-15	717,484	f7b2c202-3cd2-4488-b11a-2ee65d7885a7
American Gothic (edit)	American Gothic		ep	The Smashing Pumpkins		Billy Corgan • Jimmy Chamberlin • Roy Thomas Baker		2008-01-02	48,777	925b32b8-a090-37b5-aad9-d6d8c31040f1
Amotion (edit)	aMOTION		compilation	A Perfect Circle				2004-11-16	20,883	3980c669-1c77-4628-8dda-4bf391d84666
Any Given Sunday (edit)	Any Given Sunday		soundtrack	Various artists				2000-01-04	53,715	6edd9551-af5f-31e5-97bb-a18c0365369b
Apartment Life (edit)	Apartment Life		studio	Ivy		Andy Chase • Adam Schlesinger • Peter Nashel		1997-10-07	36,099	56a4b94f-9c72-3d20-9aea-37c3ad438354
As Featured on MTV (edit)	As Featured on MTV		video • promotional • live	The Smashing Pumpkins				1998-06-01
Attic Rehearsal (edit)	Attic Rehearsal		demo • bootleg	The Marked				1986
ATUM (edit)	ATUM		studio	The Smashing Pumpkins		Billy Corgan		2023-05-05	3,084,431	5a81e54a-2a4b-4cc7-b7b8-6f88fa4b4e21
Auf der Maur (edit)	Auf der Maur		studio	Melissa Auf der Maur		Chris Goss • Melissa Auf der Maur		2004-02-02	27,927	89ff7a2c-25ee-36c4-a454-354fb45f3cfa
Batman & Robin (edit)	Batman & Robin		soundtrack	Various artists		Nellee Hooper		1997-06-10	101,136
Billy and Greg's Home Demos: Vol. 1 (edit)	Billy and Greg's Home Demos: Vol. 1		demo	Coat of Eyes				1985
Billy's Gravity Demos I (edit)	Billy's Gravity Demos I		bootleg	The Smashing Pumpkins	Gravity Studios			April 2000		96cc44b6-f917-3b30-bb8a-1e748930bdeb
Blue-Sky Research (edit)	Blue-Sky Research		studio	Taproot		Toby Wright		2005-08-16	288,467	c116055e-03fa-3696-ad1e-df07fb0a79b2
Blvds of Splendor (edit)	Blvds of Splendor		studio	Cherie Currie				2019-04-13		46f82f04-8102-4fbc-a9dc-8a096479d7f2
Bodies (album) (edit)	Bodies		studio	AFI		Jade Puget		2021-06-11		6b82411a-4cf1-412f-b887-e80163ceb7d0
Bonus EP (edit)	Bonus EP		live • ep	The Smashing Pumpkins				2009-02-25
Boom! Boom! Boom! (edit)	Boom! Boom! Boom!		studio	The Kelley Deal 6000		Kelley Deal
Brat Pack (edit)	Brat Pack		compilation	Various artists				1994-01-29
Bye Bye Blackbird (edit)	Bye Bye Blackbird		studio	Frank Catalano and Jimmy Chamberlin		Frank Catalano		2016-05-27	1,226,983	3d047090-60d1-40cc-88a0-1dc234dd9032
Candide (edit)	Candide		live	Billy Corgan				2023-08-12
Celebrating *20* Years of Sadness (edit)	Celebrating *20* Years of Sadness		live	The Smashing Pumpkins				2009-01-15
Celebrity Skin (edit)	Celebrity Skin		studio	Hole	Conway Recording Studios (Los Angeles) Record Plant West (Los Angeles) Quad Studios (New York City) Olympic Studios (London)			1998-09-08	43,750	bdf37fad-7332-3efb-8e7e-073d1c756c7e
Ceremony (edit)	Ceremony		studio	Phantogram				2020-03-06	1,693,599	b8d6ec09-82f2-4f0b-8b63-ec190d3a70ac
Chicago Nights (edit)	Chicago Nights		studio	Frank Catalano and Jimmy Chamberlin				2023-08-29
Chicago Tapes and Unreleased Demos (edit)	Chicago Tapes and Unreleased Demos		bootleg	The Smashing Pumpkins		Billy Corgan			1,016,062
Coat of Eyes (demo) (edit)	Coat of Eyes		demo	Coat of Eyes				February 1985
Cotillions (edit)	Cotillions		studio	Billy Corgan		Billy Corgan		2019-11-22	1,677,853	1c83f460-7a9a-4bb8-906c-9ac077aac6dd
Coward EP (edit)	Coward EP		studio	Sierra Swan		Sierra Swan		2014-02-19
CYR (edit)	CYR		studio	The Smashing Pumpkins		Billy Corgan		2020-11-27	1,845,929	58f7d043-4599-47ef-9392-fa61770625e1
CYR Singles (edit)	CYR Singles		box set	The Smashing Pumpkins		Billy Corgan		2021-06-09
Daggers (edit)	Daggers		studio	Ex Cops		Justin Raisen		2014-11-10	799,821	848db848-fc5b-42e8-8bd4-e2738a3aeec8
Demo Recordings Mar 85 - Jan 87 (edit)	Demo Recordings Mar 85 - Jan 87		demo • bootleg	The Marked				January 1987		0c497e33-dbcb-46e8-92a1-9b0cc2c7d02e
Early 1989 Demos (edit)	Early 1989 Demos		bootleg	The Smashing Pumpkins				1995
Early 1989 Demos (edit)	Sounds Of Turnips		bootleg	The Smashing Pumpkins				1994
Earphoria (edit)	Earphoria		live	The Smashing Pumpkins		Butch Vig • Billy Corgan • James Iha		2002-11-26	485,217	503d32cd-a1eb-387d-9a39-f91f4541ee5e
Emotive (edit)	eMOTIVe		studio	A Perfect Circle		Billy Howerdel • Maynard James Keenan		2004-11-02	20,888	0f21095a-e629-389c-981a-d9569e9673c9
Fancy Space People (edit)	Fancy Space People		ep	Fancy Space People		D'on Bolles • Geoffrey Brandin		2011-01-18
First Love, Last Rites (edit)	First Love, Last Rites		soundtrack	Shudder to Think		Shudder to Think		1998-08-25	261,347	1a5f7ec3-4292-3ce2-bbcf-76c19dab1a33
For the Masses (edit)	For The Masses		tribute	Various artists				1998-08-04	61,299	71398d3a-44b0-3bd2-99d2-5170dd3de138
Forever Mod: A Tribute To Rod Stewart (edit)	Forever Mod: A Tribute To Rod Stewart.jpg		tribute	Various artists				1997-10-22	1,816,017	28bd2323-8f9d-343e-a407-8a06d461c8d9
Free Tibet (edit)	Free Tibet		video • compilation	Various artists				1998	1,114,413
Fresh Cuts: Volume 2 (edit)	Fresh Cuts: Volume 2		compilation	Various artists				2008-03-04
Get Ready (edit)	Get Ready		studio	New Order		Steve Osborne • New Order • Flood • Bernard Sumner		2001-08-27	39,848	03fce663-c450-34ab-afea-b8824796bb46
Ghost Children/Friends and Enemies (edit)	Ghost Children/Friends and Enemies		tribute	Various artists		Act IV		2006-11-17
Ghost Children: A Tribute To The Smashing Pumpkins (edit)	Ghost Children: A Tribute To The Smashing Pumpkins		tribute	Various artists		Neil Main		2001-07-07
Girl Who Cried Wolf (edit)	Girl Who Cried Wolf		studio	Sierra Swan	Kung Fu Gardens	Sierra Swan		2009-10-10		81aca678-9fa2-490a-ad95-dd7b48ff6b41
Gish (edit)	Gish		studio	The Smashing Pumpkins	Smart Studios	Butch Vig • Billy Corgan		1991-05-28	48,660	4ac82f0b-1532-3734-80d7-5c02265197aa
Glass and The Machines of God (Matt Walker Remixes) (edit)	Glass and the Machines of God (Matt Walker Remixes)		bootleg	The Smashing Pumpkins						7c46172a-d6cd-44f3-91a0-bca2f7fea67c
God's Gonna Cut You Down (edit)	God's Gonna Cut You Down		studio	Frank Catalano and Jimmy Chamberlin				2015-04-07	942,002	4dbe4de1-977f-491e-89ec-4c20fb3189db
Good Soldier (edit)	Good Soldier		studio	Sierra Swan		Billy Corgan		2014-02-25		057856ea-0ddd-490d-a97b-d888c630c2a6
Great Civilizations (edit)	Great Civilizations		studio	Skysaw				2011-06-21	655,703	a03d1f28-b2ee-4e75-8e33-f53a645989a2
Greatest Hits Video Collection (1991–2000) (edit)	Greatest Hits Video Collection (1991–2000)		video	The Smashing Pumpkins		Nicola Doring • Eric Ferris • June Guterman • Bart Lipton • Ali Newling • Line Postmyr		2001-11-20	48,765	e9d61b0f-8f7c-3f1d-8310-980439b56d3f
Guitar Hero World Tour (edit)	Guitar Hero World Tour		compilation	Various artists				2008-10-27
Guitars That Rule The World Vol. 2: Smell The Fuzz/The Superstar Guitar Album (edit)	Guitars That Rule The World Vol. 2: Smell The Fuzz/The Superstar Guitar Album		compilation	Various artists				1996
Honor (edit)	Honor		ep	Jimmy Chamberlin Complex		Billy Mohler		2020-09-25	2,025,592
Hot Saki & Bedtime Stories (edit)	Hot Saki & Bedtime Stories		studio	Catherine				1996-09-17	175,498	1d96e79b-5b06-3cca-8eb2-e6689e3dff9e
Humanity: Hour I (edit)	Humanity: Hour I		studio	Scorpions		Desmond Child • James Michael		2007-05-25	29,367	5c92dd07-3d1e-4e96-9b52-69c84de57286
If All Goes Wrong (edit)	If All Goes Wrong		video	The Smashing Pumpkins		Jack Gulick • Daniel Catullo		2008-11-11	451,005	f71c6d0c-3641-459d-8e64-dabd0e50141f
Inside the Dream Machine (edit)	Inside the Dream Machine		bootleg • live	The Smashing Pumpkins
Iommi (edit)	Iommi		studio	Tony Iommi				2000-10-17	17,189	cb89392e-a0dd-387a-afdf-f5e352698f87
Joliet Tape (edit)	Joliet Tape		demo • bootleg	The Marked				1986
Kissin Time (edit)	Kissin Time		studio	Marianne Faithfull		Billy Corgan • Beck • Jarvis Cocker • Étienne Daho • Ben Hillier • Tony Hoffer • Steve Mackey • Barry Reynolds • Dave Stewart • Les Valentins		2002-03-04	237,233	3e761708-0121-3929-b2cd-1e0f53e2e499
Ladyland (edit)	Ladyland		studio	Sierra Swan		Bill Bottrell • Linda Perry		2006-05-23	435,249	65822979-184a-3f54-9396-cc4254f0e9c0
Lay It All Down (edit)	Lay It All Down		studio	Katie Cole		Howard Willing		2014-03-03		b34193fb-90f0-4d3c-99c9-293c95b3dd03
Let It Come Down (edit)	Let It Come Down		studio	James Iha		Jim Scott • James Iha		1998-02-10	97,691	a62a1df6-39ac-3b10-8c3f-a618930ae888
Life Begins Again (edit)	Life Begins Again		studio	Jimmy Chamberlin Complex		Jimmy Chamberlin		2005-01-25	274,382	23a3d32c-7e5d-39fa-bd6a-81076850e57b
Light Into Dark (edit)	Light Into Dark		compilation	Various artists				1989-04-12
Lights Out (edit)	Lights Out		compilation	Lisa Marie Presley				2003
Linda Linda Linda (edit)	Linda Linda Linda		soundtrack	James Iha	Stratosphere Sound New York • NY • US			2005-07-20		5acbfd5a-7253-3a22-8b50-2efb07f91487
Live at Cabaret Metro 10-5-88 (edit)	Live at Cabaret Metro 10-5-88		live	The Smashing Pumpkins				2000-12-02
Live at Kawasaki 2.24.92 (edit)	Live at Kawasaki 2.24.92		live	The Smashing Pumpkins				March 2022
Live At The Riviera (edit)	Live At The Riviera		bootleg • live	The Smashing Pumpkins				1995	898,852	37a5ce03-0f74-3d70-8485-d90892e8d371
Live at the Viper Room 1.15.98 (edit)	Live at the Viper Room 1.15.98		live	The Smashing Pumpkins				December 2021	2,547,617	20c7064b-16c1-4fdc-b002-2f2b298a6a9a
Live Earth: The Concerts for a Climate in Crisis (edit)	Live Earth: The Concerts For A Climate In Crisis		video • compilation	Various artists				2007	60,185	3cd2ce22-4671-4267-9b06-3652c762edcd
Live In Chicago (edit)	Live In Chicago		live • promotional	The Smashing Pumpkins				1995
Live NYC 1997 (edit)	Live NYC 1997		bootleg • live • promotional	Billy Corgan and David Bowie				1997
London By Day (edit)	London By Day		live	The Smashing Pumpkins	Maida Vale Studios			2023-12-11
Long Distance (edit)	Long Distance		studio	Ivy		Andy Chase • Adam Schlesinger • Peter Nashel		2000-11-08	122,413	02e15771-25a8-3dc1-9756-3895a8ca0012
Look to the Sky (edit)	Look to the Sky		studio	James Iha		James Iha • Nathan Larson		2012-03-14	472,230	a9921a71-048c-47eb-918e-cdbf70466263
Lost Highway (edit)	Lost Highway		soundtrack	Various artists		Trent Reznor		1997-02-18	19,820	19c3f6fc-a3f9-3622-999c-e0579f00a4f6
Love Supreme Collective (edit)	Love Supreme Collective		ep	Frank Catalano and Jimmy Chamberlin				2014-07-29	7,748,573	2ce2a33f-6c49-4bf5-b06e-10aeee761a85
Lull (edit)	Lull		ep	The Smashing Pumpkins		Billy Corgan • Butch Vig		1991-11-05	48,668	20a8026d-1937-3ebe-b3d7-347b827a249a
Machina Acoustic Demos (edit)	Machina Acoustic Demos		demo • bootleg	The Smashing Pumpkins	Sadlands			1998
Machina II/The Friends & Enemies of Modern Music (edit)	Machina II/The Friends & Enemies of Modern Music		studio	The Smashing Pumpkins		Billy Corgan • Flood		2000-09-05	199,217	f6675c5f-549d-34d8-bf24-9e9a3c86b418
Machina/The Machines of God (edit)	Machina/The Machines of God		studio	The Smashing Pumpkins	Sadlands • Pumpkinland • Chicago Recording Company	Billy Corgan • Flood		2000-02-29	48,755	98cbc7a6-7229-3b64-b974-fc4cb2ff0505
Machina/The Machines of God (premaster) (edit)	Machina/The Machines of God (premaster)		promotional	The Smashing Pumpkins				November 1999
Mary Star of the Sea (edit)	Mary Star of the Sea		studio	Zwan	Chicago Recording Company • Electrical Audio	Billy Corgan • Bjorn Thorsrud		2003-01-28	36,390	845eb338-fe1f-3b87-a2fb-5f7dd8795554
Mashed Potatoes (edit)	Mashed Potatoes		bootleg	The Smashing Pumpkins				1994

More...