Page values for "Siamese Dream"

"track_listings" values

51 rows are stored for this page
FieldField typeValue
songStringCherub Rock
song_page_titleStringCherub Rock
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger1
sourcePage
lengthString4:58
FieldField typeValue
songStringQuiet
song_page_titleStringQuiet
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger2
sourcePage
lengthString3:41
FieldField typeValue
songStringToday
song_page_titleStringToday
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger3
sourcePage
lengthString3:19
FieldField typeValue
songStringHummer
song_page_titleStringHummer
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger4
sourcePage
lengthString6:57
FieldField typeValue
songStringRocket
song_page_titleStringRocket
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger5
sourcePage
lengthString4:06
FieldField typeValue
songStringDisarm
song_page_titleStringDisarm
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger6
sourcePage
lengthString3:17
FieldField typeValue
songStringSoma
song_page_titleStringSoma
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger7
sourcePage
lengthString6:39
FieldField typeValue
songStringGeek U.S.A.
song_page_titleStringGeek U.S.A.
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger8
sourcePage
lengthString5:13
FieldField typeValue
songStringMayonaise
song_page_titleStringMayonaise
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger9
sourcePage
lengthString5:50
FieldField typeValue
songStringSpaceboy
song_page_titleStringSpaceboy
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger10
sourcePage
lengthString4:28
FieldField typeValue
songStringSilverfuck
song_page_titleStringSilverfuck
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger11
sourcePage
lengthString8:43
FieldField typeValue
songStringSweet Sweet
song_page_titleStringSweet Sweet
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger12
sourcePage
lengthString1:38
FieldField typeValue
songStringLuna
song_page_titleStringLuna
workStringSiamese Dream
headlineStringOriginal release
listing_idInteger1
main_listingBooleanYes
trackInteger13
sourcePage
lengthString3:20
FieldField typeValue
songStringPissant
song_page_titleStringPissant
workStringSiamese Dream
headlineStringJapanese edition bonus track
listing_idInteger2
main_listingBooleanNo
trackInteger14
sourcePage
lengthString2:31
FieldField typeValue
songStringPissant
song_page_titleStringPissant
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger1
sourcePage
lengthString2:32
FieldField typeValue
songStringSiamese Dream
song_page_titleStringSiamese Dream (song)
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger2
sourcePage
lengthString6:18
FieldField typeValue
songStringSTP
song_page_titleStringSTP
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:28
FieldField typeValue
songStringFrail and Bedazzled
song_page_titleStringFrail and Bedazzled
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger4
sourcePage
lengthString3:42
FieldField typeValue
songStringLuna
song_page_titleStringLuna
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger5
sourcePage
lengthString3:12
FieldField typeValue
songStringQuiet
song_page_titleStringQuiet
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger6
sourcePage
lengthString3:36
FieldField typeValue
songStringMoleasskiss
song_page_titleStringMoleasskiss
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:59
FieldField typeValue
songStringHello Kitty Kat
song_page_titleStringHello Kitty Kat
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger8
sourcePage
lengthString6:14
FieldField typeValue
songStringToday
song_page_titleStringToday
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger9
sourcePage
lengthString3:21
FieldField typeValue
songStringNever Let Me Down Again
song_page_titleStringNever Let Me Down Again
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:03
FieldField typeValue
songStringApathy's Last Kiss
song_page_titleStringApathy's Last Kiss
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger11
sourcePage
lengthString2:40
FieldField typeValue
songStringAche
song_page_titleStringAche
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger12
sourcePage
lengthString6:57
FieldField typeValue
songStringU.S.A.
song_page_titleStringU.S.A.
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger13
sourcePage
lengthString4:25
FieldField typeValue
songStringU.S.S.R.
song_page_titleStringU.S.S.R.
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger14
sourcePage
lengthString1:35
FieldField typeValue
songStringSpaceboy
song_page_titleStringSpaceboy
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger15
sourcePage
lengthString3:57
FieldField typeValue
songStringRocket
song_page_titleStringRocket
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger16
sourcePage
lengthString4:55
FieldField typeValue
songStringDisarm
song_page_titleStringDisarm
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger17
sourcePage
lengthString3:18
FieldField typeValue
songStringSoma
song_page_titleStringSoma
workStringSiamese Dream
headlineString2011 reissue bonus CD – ''Lollipop Fun Time''
listing_idInteger3
main_listingBooleanNo
trackInteger18
sourcePage
lengthString6:38
FieldField typeValue
songStringIntro by Joe Shanahan
song_page_titleStringIntro by Joe Shanahan
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger1
sourcePage
lengthString0:48
FieldField typeValue
songStringRocket
song_page_titleStringRocket
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:19
FieldField typeValue
songStringQuiet
song_page_titleStringQuiet
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:39
FieldField typeValue
songStringToday
song_page_titleStringToday
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger4
sourcePage
lengthString3:39
FieldField typeValue
songStringRhinoceros
song_page_titleStringRhinoceros
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger5
sourcePage
lengthString5:06
FieldField typeValue
songStringGeek U.S.A.
song_page_titleStringGeek U.S.A.
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger6
sourcePage
lengthString5:21
FieldField typeValue
songStringSoma
song_page_titleStringSoma
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger7
sourcePage
lengthString7:21
FieldField typeValue
songStringI Am One
song_page_titleStringI Am One
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger8
sourcePage
lengthString4:47
FieldField typeValue
songStringDisarm
song_page_titleStringDisarm
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger9
sourcePage
lengthString3:55
FieldField typeValue
songStringSpaceboy
song_page_titleStringSpaceboy
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:48
FieldField typeValue
songStringStarla
song_page_titleStringStarla
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger11
sourcePage
lengthString9:25
FieldField typeValue
songStringCherub Rock
song_page_titleStringCherub Rock
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger12
sourcePage
lengthString5:01
FieldField typeValue
songStringBury Me
song_page_titleStringBury Me
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger13
sourcePage
lengthString4:28
FieldField typeValue
songStringHummer
song_page_titleStringHummer
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger14
sourcePage
lengthString8:42
FieldField typeValue
songStringSiva
song_page_titleStringSiva
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger15
sourcePage
lengthString8:35
FieldField typeValue
songStringMayonaise
song_page_titleStringMayonaise
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger16
sourcePage
lengthString10:29
FieldField typeValue
songStringDrown
song_page_titleStringDrown
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger17
sourcePage
lengthString8:24
FieldField typeValue
songStringSilverfuck
song_page_titleStringSilverfuck
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger18
sourcePage
lengthString13:30
FieldField typeValue
songStringcredits
song_page_titleStringcredits
workStringSiamese Dream
headlineString2011 reissue bonus DVD – ''Live at the Metro'' (Live on August 14, 1993)
listing_idInteger4
main_listingBooleanNo
trackInteger19
sourcePage
lengthString1:12

"releases" values

8 rows are stored for this page
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-26
labelList of String, delimiter: ,Hut Recordings
catalog_idList of String, delimiter: ,HUTLP 11 0170 4 65010 1 9
formatList of String, delimiter: ,2 LP
countryStringUK
discogsInteger1,621,978
musicbrainzString33593826-03ef-3393-a905-ccde90824301
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-26
labelList of String, delimiter: ,Hut Recordings
catalog_idList of String, delimiter: ,CDHUT 11 0170 4 65010 2 6
formatList of String, delimiter: ,CD
countryStringUK
discogsInteger2,353,183
musicbrainzString0dcb4610-006e-35a3-8575-3fee0fa1bb83
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-26
labelList of String, delimiter: ,Hut Recordings
catalog_idList of String, delimiter: ,HUTCS 11
formatList of String, delimiter: ,Cassette
countryStringUK
discogsInteger
musicbrainzStringe260e38f-66e1-4da9-8b74-b5030ef62d58
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-27
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,0777 7 88267 2 9
formatList of String, delimiter: ,CD
countryStringUS
discogsInteger7,086,501
musicbrainzString8d967bcd-02e3-380f-8e0d-2f3cfb79561d
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-27
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,0777 7 88267 4 3
formatList of String, delimiter: ,Cassette
countryStringUS
discogsInteger1,298,302
musicbrainzString4e182adf-10a8-3f93-8b89-c42c58d75ec7
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1
release_dateDate1993-07-27
labelList of String, delimiter: ,Caroline Virgin
catalog_idList of String, delimiter: ,CAROL 1740 1 0170 4 61740 1 5
formatList of String, delimiter: ,2 LP
countryStringUS
discogsInteger667,822
musicbrainzString
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1 2
release_dateDate1993-08-25
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,VJCP-28179
formatList of String, delimiter: ,CD
countryStringJapan
discogsInteger783,465
musicbrainzString60c4b799-d564-47d5-a77f-9f95c03fdf8e
FieldField typeValue
workPageSiamese Dream
listing_idList of Integer, delimiter: ,1 3 4
release_dateDate2011-11-29
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,50999 67928 9 27
formatList of String, delimiter: ,2 CD DVD
countryStringUS
discogsInteger3,250,283
musicbrainzString90446fe3-ae53-4fe9-a4e0-a0f50259992e

"album_charts" values

12 rows are stored for this page
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Sweden

positionInteger19
dateDate1993-08-25
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

UK

positionInteger4
dateDate1993-07-31
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Billboard200

positionInteger10
dateDate1993-08-14
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Australia

positionInteger7
dateDate1994-07-31
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Canada

positionInteger3
dateDate1994-06-27
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Netherlands

positionInteger22
dateDate1994-06-25
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Germany4

positionInteger64
dateDate1994-10-24
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

New Zealand

positionInteger3
dateDate1994-10-02
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Norway

positionInteger25
dateDate2000-08-07
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Ireland

positionInteger50
dateDate2002-01-17
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

Billboard200

positionInteger110
dateDate2011-12-17
FieldField typeValue
albumPageSiamese Dream
artistStringThe Smashing Pumpkins
chartWikitext string

BillboardVinyl

positionInteger1
dateDate2011-12-17

"certifications" values

7 rows are stored for this page
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringAustralia
dateDate
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger4
regionStringCanada
dateDate1995-01-27
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringNetherlands
dateDate1997
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringNew Zealand
dateDate
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringSweden
dateDate1998-03-25
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringUnited Kingdom
dateDate1994-01-03
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringSiamese Dream
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger4
regionStringUnited States
dateDate1996-01-22

"albums" values

1 row is stored for this page
FieldField typeAllowed valuesValue
nameStringSiamese Dream
coverFile
SmashingPumpkins-SiameseDream.jpg
typeList of String, delimiter: ,ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotionalstudio
artistPageThe Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artistsThe Smashing Pumpkins
studioList of String, delimiter: ,Triclops Sound Studios
producerList of Page, delimiter: ,Butch Vig Billy Corgan
engineerList of Page, delimiter: ,
releasedDate1993-07-27
discogsInteger48,681
musicbrainzStringa159e102-18bb-42ca-a59e-5f96a7eff241