View table: songs

Table structure:

1. name - String (mandatory)
2. type - List of String, delimiter: , (mandatory; allowed values: song · single · promo · cover · instrumental)
3. artist - Page (mandatory; allowed values: The Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artists)
4. original_artist - String
5. main_album - Page
6. song_release_date - Date
7. writer - List of Page, delimiter: ,
8. video - Boolean
9. spotify - String
10. discogs - Integer
11. musicbrainz - String
12. cover - File

This table has 1,316 rows altogether.

Recreate data.

Page	name	type	artist	original artist	main album	song release date	writer	video	spotify	discogs	musicbrainz	cover
(Come On) Let's Go! (edit)	(Come On) Let's Go!	song	The Smashing Pumpkins		Zeitgeist	2007-07-10	Billy Corgan	No
(They Long to Be) Close to You (edit)	(They Long to Be) Close to You	cover	The Smashing Pumpkins	The Carpenters			Burt Bacharach • Hal David	No
...Said Sadly (edit)	...Said Sadly	song	The Smashing Pumpkins		The Aeroplane Flies High	1995-10-23	James Iha	No	6srbZfavCrLbuU4BvGzo0L
1,000,000 Voices (edit)	1,000,000 Voices	song	Billy Corgan		Stigmata		Billy Corgan • Mike Garson	No
10,000,000 Voices (edit)	10,000,000 Voices	song	Billy Corgan		Stigmata	1999-08-24	Billy Corgan • Mike Garson	No
1000 Years (edit)	1000 Years	song	Melissa Auf der Maur		Out of Our Minds	2010-04-06	Melissa Auf der Maur • Steve Durand	No
17 (edit)	17	song	The Smashing Pumpkins		Adore		Billy Corgan	No	7kN7S8f4wKlJVKrA92KpMx
1979 (edit)	1979	single	The Smashing Pumpkins		Mellon Collie and the Infinite Sadness	1996-01-23	Billy Corgan	Yes	5QLHGv0DfpeXLNFo7SFEy1	48,713	62713bbc-69c4-38b1-a35d-ea24150523fe
22 Below (edit)	22 Below	song	Melissa Auf der Maur		Out of Our Minds		Melissa Auf der Maur • Chris Goss	No
365 (edit)	365	song	The Smashing Pumpkins				Billy Corgan	No
3:30p.m. (edit)	3:30p.m.	song	James Iha		Linda Linda Linda		James Iha	No
4th of July (edit)	4th of July	song	James Iha		Look to the Sky		James Iha	No	3QNGZImuQUz9Fw2unOvgkU
4人の風景 (edit)	4人の風景	song	James Iha		Linda Linda Linda		James Iha	No
6+7 (edit)	6+7	song	Billy Corgan		Cotillions		Billy Corgan	No	2pce5VuahcqOZ4PzJX8ktc
6234 (edit)	6234	song	The Smashing Pumpkins				Billy Corgan	No
7 Shades of Black (edit)	7 Shades of Black	song	The Smashing Pumpkins		Zeitgeist		Billy Corgan	No
77 (edit)	77	song	The Smashing Pumpkins				Billy Corgan	No
8 Miles High (edit)	8 Miles High	cover	The Marked	The Byrds	The Marked Aug '86	1986	Gene Clark • Jim McGuinn • David Crosby	No
99 Floors (edit)	99 Floors	song	The Smashing Pumpkins		If All Goes Wrong		Billy Corgan	No
? (edit)	?	song	The Smashing Pumpkins				Billy Corgan	No
A Certain Kind of Change (edit)	A Certain Kind of Change	song	Zwan				Billy Corgan	No
A Chance For The Day (edit)	A Chance For The Day	song	Coat of Eyes				Billy Corgan • Greg Bates	No
A Day at the Circus (edit)	A Day at the Circus	song	The Marked			1986		No
A Dog's Prayer (edit)	A Dog's Prayer	song	The Smashing Pumpkins				Billy Corgan	No
A Love Supreme (edit)	A Love Supreme	cover	Frank Catalano and Jimmy Chamberlin	John Coltrane	Tokyo Number 9		John Coltrane	No	7xx8P2vKwmeRIj9dC4Vdqx
A Million Times (edit)	A Million Times	song	Coat of Eyes				Billy Corgan • Greg Bates	No
A New Day Yesterday (edit)	A New Day Yesterday	cover	Spirits in the Sky	Jethro Tull			Ian Anderson	No
A New Poetry (edit)	A New Poetry	song	Zwan		Mary Star of the Sea		Billy Corgan	No
A Night Like This (edit)	A Night Like This	cover	The Smashing Pumpkins	The Cure	The Aeroplane Flies High		Robert Smith	No	4hWsqbNdTTorwCIWAcGkeL
A Song for a Son (edit)	A Song for a Son	promo	The Smashing Pumpkins		Teargarden by Kaleidyscope - Vol. 1: Songs for a Sailor	2009-12-08	Billy Corgan	No
A Stitch in Time (edit)	A Stitch in Time	song	The Smashing Pumpkins		Teargarden by Kaleidyscope - Vol. 1: Songs for a Sailor	2010-03-02	Billy Corgan	No		2,239,487	29bca928-101a-434e-829c-5839b762a453
A String of Words (edit)	A String of Words	song	James Iha		Look to the Sky		James Iha	No	6W7A9PDm3ajpETEewKoZbI
A/Ab/E/B/F sharp (edit)	A/Ab/E/B/F#	song	The Smashing Pumpkins		The Aeroplane Flies High		Billy Corgan	No	7H1fqJluZNGCZQWQbHmeJn
A/B/G Drop A (edit)	A/B/G Drop A	song	The Smashing Pumpkins				Billy Corgan	No
A100 (edit)	A100	song	Billy Corgan		TheFutureEmbrace		Billy Corgan • Bon Harris	No
Ache (edit)	Ache	song	The Smashing Pumpkins		Siamese Dream		Billy Corgan	No	0CyOHijQxOFg37PLumGqIq
Acknowledgement of Truth (edit)	Acknowledgement of Truth	song	Frank Catalano and Jimmy Chamberlin		Love Supreme Collective		Frank Catalano	No	5NDznfVAn3mZagLTAebAfX
Adrennalynne (edit)	Adrennalynne	song	The Smashing Pumpkins		CYR		Billy Corgan	No
Aeronaut (edit)	Aeronaut	single	Billy Corgan		Ogilala	2017-08-22	Billy Corgan	Yes	0V2kwiKfeCH9ZPGWmrFJMg
After the Gold Rush (edit)	After the Gold Rush	cover	Billy Corgan	Neil Young			Neil Young	No
Again, Again, Again (The Crux) (edit)	Again, Again, Again (The Crux)	song	The Smashing Pumpkins		American Gothic		Billy Corgan	No
Age of Innocence (edit)	Age of Innocence	song	The Smashing Pumpkins		Machina/The Machines of God		Billy Corgan	No	1eLiYAsPJSE2YIgUvjXJXy
Ah! the Moonlight (edit)	Ah! the Moonlight	song	Zwan				Billy Corgan	No
Ain't Got What It Takes (edit)	Ain't Got What It Takes	song	Coat of Eyes				Billy Corgan • Greg Bates	No
Ain't Talkin' 'bout Love (edit)	Ain't Talkin' 'bout Love	cover	The Smashing Pumpkins	Van Halen			Eddie Van Halen • Alex Van Halen • David Lee Roth • Michael Anthony	No
Air (edit)	Air	song	The Smashing Pumpkins				Billy Corgan	No
Alabaster (edit)	Alabaster	song	The Smashing Pumpkins				Billy Corgan	No
Alienation (edit)	Alienation	song	The Smashing Pumpkins		Shiny and Oh So Bright - Vol. 1 / LP: No Past. No Future. No Sun.		Billy Corgan	No	10EAxVTfkhNFmiUd1sy6rt
All Along the Watchtower (edit)	All Along the Watchtower	cover	Billy Corgan	Bob Dylan	Thirty Days		Bob Dylan	No
All Answers Revealed (edit)	All Answers Revealed	song	Billy Corgan		Stigmata		Billy Corgan • Mike Garson	No
All Ashore (edit)	All Ashore	cover	Billy Corgan	Billy Hill	Thirty Days		Gene Clark	No
All Blues (edit)	All Blues	cover	Frank Catalano and Jimmy Chamberlin	Miles Davis	Bye Bye Blackbird		Miles Davis	No	1LccQpkvPb0qPPfUcqFvvk
All Day and All of the Night (edit)	All Day and All of the Night	cover	Zwan	The Kinks			Ray Davies	No	56Ls0AaYYNcLYeni8k2DRW
All I Hear Is Snow (edit)	All I Hear Is Snow	song	Skysaw		Great Civilizations		Skysaw	No
All the Young Dudes (edit)	All the Young Dudes	song	David Bowie				David Bowie	No
All Things Change (edit)	All Things Change	song	Billy Corgan		TheFutureEmbrace		Billy Corgan	No
All We Know (edit)	All We Know	song	Coat of Eyes				Billy Corgan • Greg Bates	No
All You Need Is Love (edit)	All You Need Is Love	cover	Billy Corgan	The Beatles			Lennon–McCartney	No
All Your Love (edit)	All Your Love	single	Sir Sly			2020-04-30	Billy Corgan • Landon Jacobs • Jason Suwito • Hayden Coplen	Yes
Alone Inside (edit)	Alone Inside	song	The Marked		The Marked Aug '86			No
Along the Santa Fe Trail (edit)	Along the Santa Fe Trail	cover	Billy Corgan	Ray Noble			Hugh Williams • Al Dubin • Edwina Coolidge	No
Always (edit)	Always	cover	Zwan	Irving Berlin	Spun		Irving Berlin	No
Am I Second (edit)	Am I Second	song	Skysaw		Great Civilizations		Skysaw	No
Amarinthe (edit)	Amarinthe	song	Billy Corgan		Ogilala		Billy Corgan	No	0SPnxjuiHbwhgESMNJr4OR
America (edit)	America	song	The Smashing Pumpkins					No
Anaise! (edit)	Anaise!	song	The Smashing Pumpkins		Monuments to an Elegy		Billy Corgan	No	2jqgFcG8MKZIvJl8Bboy9H
Angie (edit)	Angie	cover	The Smashing Pumpkins	The Rolling Stones			Jagger–Richards	No
Anima Animus (edit)	Anima Animus	song	The Marked		The Marked Sept - Oct '86	1986	Dale Meiners • Billy Corgan	No
Annie-Dog (edit)	Annie-Dog	song	The Smashing Pumpkins		Adore		Billy Corgan	No	4SRtruLUUFLaby8WUeFIB5
Anno Satana (edit)	Anno Satana	single	The Smashing Pumpkins		CYR	2020-10-09	Billy Corgan	Yes	1iYkDXdNOzjbnOWuYPYHeO		986632e9-9d03-4153-91f3-8e063e6b96ed
Anon (edit)	Anon	song	Billy Corgan		Cotillions		Billy Corgan	No	6CpAW9m8Z4UPtDzadZxyuN
Another Bridge to Burn (edit)	Another Bridge to Burn	cover	Billy Corgan	Little Jimmy Dickens			H. Howard	No
Another Life (edit)	Another Life	single	Night Dreamer		Treasure	2019-09-19	Jeff Schroeder • Mindy Song • Rick Parker	Yes	5aWHK6vUQk1mLLzLz1LeDg
Anti-Hero (edit)	Anti-Hero	song	The Smashing Pumpkins		Monuments to an Elegy		Billy Corgan	No	4PyjlJA6NbLiSSjDAT0Yha
Antietam (edit)	Antietam	song	Billy Corgan		Ogilala		Billy Corgan	No	01dYgV6pAfSnNs7L6rQLOQ
Apathy's Last Kiss (edit)	Apathy's Last Kiss	song	The Smashing Pumpkins		Siamese Singles		Billy Corgan	No	5JDCGs2gxuXIVYgEdQ7om0
Apologia (edit)	Apologia	song	Billy Corgan		Cotillions		Billy Corgan	No	6qKDSDu8qZQhRanmDnjx9z
Appels + Oranjes (edit)	Appels + Oranjes	song	The Smashing Pumpkins		Adore		Billy Corgan	No	2xfP5cNoQXFPZUoRTjKtxq
Appetite (edit)	Appetite	song	James Iha		Look to the Sky		James Iha • Nathan Larson	No	3dPg410bksjrPI2xJfP0XZ
Archer (edit)	Archer	song	Billy Corgan		Ogilala		Billy Corgan	No	3O4hcI5oW5KSosdRIbjdXG
Armed to the Teeth (edit)	Armed to the Teeth	song	The Smashing Pumpkins				Billy Corgan	No
As Rome Burns (edit)	As Rome Burns	song	The Smashing Pumpkins				Billy Corgan	No
As Yet Untitled (edit)	As Yet Untitled	song	The Marked		The Marked Aug '86	1986		No
Ascending Guitars (edit)	Ascending Guitars	song	The Smashing Pumpkins				Billy Corgan	No	44gab1WjFHd9aNp6fqTCLa
Ascendo (edit)	Ascendo	song	Billy Corgan		Guitars That Rule The World Vol. 2: Smell The Fuzz/The Superstar Guitar Album		Billy Corgan	No
Asia Minor (edit)	Asia Minor	song	Ric Ocasek		Troublizing		Billy Corgan	No	5r0PSeY6DSECIYvilo7qRv
Astral Planes (edit)	Astral Planes	promo	The Smashing Pumpkins		Teargarden by Kaleidyscope - Vol. 1: Songs for a Sailor	2010-04-16	Billy Corgan	No		2,239,487	29bca928-101a-434e-829c-5839b762a453
At Last (edit)	At Last	cover	Frank Catalano and Jimmy Chamberlin	Mack Gordon and Harry Warren	Bye Bye Blackbird		Mack Gordon • Harry Warren	No	4qv2yg3OVFbeWvtw55OObJ
Atum (song) (edit)	Atum	song	The Smashing Pumpkins		ATUM		Billy Corgan	No	3JXSAtePmSa2sJGPAhe2nF
Automaton (edit)	Automaton	song	The Smashing Pumpkins		ATUM	2023-05-05	Billy Corgan	No
Autumn (edit)	Autumn	song	The Smashing Pumpkins		Machina Acoustic Demos		Billy Corgan	No
Autumn Leaves (edit)	Autumn Leaves	cover	Zwan				Johnny Mercer • Joseph Kosma • Jacques Prévert	No
Autumn Nocturne (edit)	Autumn Nocturne	song	The Smashing Pumpkins				Billy Corgan	No	2QFrQV9VuecdYbo8Hf3K4G
Ava Adore (edit)	Ava Adore	single	The Smashing Pumpkins		Adore	1998-05-18	Billy Corgan	Yes	6bVB2MGR7LcotAIB1vfpw6	48,747	abea81ea-5a98-3d02-a3c3-a198561cab07
Avalanche (edit)	Avalanche	song	The Smashing Pumpkins		ATUM		Billy Corgan	No	5pMjkjkDuxFuBmSNKw9u6B
Await (edit)	Await	song	Billy Corgan		Stigmata		Billy Corgan • Mike Garson	No
Baby Let's Rock! (edit)	Baby Let's Rock!	song	Zwan		Mary Star of the Sea		Billy Corgan	No
Baby Man (edit)	Baby Man	song	Snaketrain					No
Baby Mine (edit)	Baby Mine	cover	The Smashing Pumpkins	Betty Noyes			Frank Churchill • Ned Washington	No
Baby, I Love You (edit)	Baby, I Love You	cover	Billy Corgan	The Ronettes	Thirty Days		Phil Spector • Jeff Barry • Ellie Greenwich	No

More...