Page values for "Perfect"

"songs" values

1 row is stored for this page
FieldField typeAllowed valuesValue
nameStringPerfect
typeList of String, delimiter: ,song · single · promo · cover · instrumentalsingle
artistPageThe Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artistsThe Smashing Pumpkins
original_artistString
main_albumPageAdore
song_release_dateDate1998-09-07
writerList of Page, delimiter: ,Billy Corgan
videoBooleanYes
spotifyString5DuaMIvmPyT3oEvuccx6JO
discogsInteger48,751
musicbrainzString83e28214-980b-32a6-bec5-3d227de3ff6d
coverFile
SmashingPumpkins-Perfect.jpg

"music_videos" values

1 row is stored for this page
FieldField typeValue
youtubeStringVKYY8DxVZHE
release_dateDate1998-09-16
songStringPerfect
artistPageThe Smashing Pumpkins
albumStringAdore
directorList of Page, delimiter: ,Jonathan Dayton Valerie Faris
vma_awardsList of String, delimiter: ,
vma_nominationsList of String, delimiter: ,
vma_dateDate
muchmusic_no1_dateDate
notesWikitext

extension to the "1979" music video

"track_listings" values

15 rows are stored for this page
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK CD1 / Cassette
listing_idInteger1
main_listingBooleanNo
trackInteger1
sourcePage
lengthString3:27
FieldField typeValue
songStringSummer
song_page_titleStringSummer
workStringPerfect
headlineStringUK CD1 / Cassette
listing_idInteger1
main_listingBooleanNo
trackInteger2
sourcePage
lengthString3:14
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK CD1 / Cassette
listing_idInteger1
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:14
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK CD2
listing_idInteger2
main_listingBooleanNo
trackInteger1
sourcePage
lengthString3:23
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK CD2
listing_idInteger2
main_listingBooleanNo
trackInteger2
sourcePage
lengthString7:00
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringPerfect
headlineStringUK CD2
listing_idInteger2
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:53
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger1
sourcePage
lengthString3:23
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:14
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:12
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger4
sourcePage
lengthString7:00
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger5
sourcePage
lengthString6:02
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUK and US Maxi-CDs
listing_idInteger3
main_listingBooleanNo
trackInteger6
sourcePage
lengthString7:04
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringPerfect
headlineStringUS CD single
listing_idInteger4
main_listingBooleanNo
trackInteger1
sourcePage
lengthString3:23
FieldField typeValue
songStringSummer
song_page_titleStringSummer
workStringPerfect
headlineStringUS CD single
listing_idInteger4
main_listingBooleanNo
trackInteger2
sourcePage
lengthString3:14
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringPerfect
headlineStringUS CD single
listing_idInteger4
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:53

"releases" values

6 rows are stored for this page
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,1
release_dateDate1998-09-07
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 95358 2 2 HUTCD 106
formatList of String, delimiter: ,CD
countryStringUK
discogsInteger1,120,786
musicbrainzString7d8dc1a0-1d0b-4ded-a1f6-27e3b4790755
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,1
release_dateDate1998-09-07
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 95358 4 6 HUTC 106
formatList of String, delimiter: ,Cassette
countryStringUK
discogsInteger7,271,577
musicbrainzString
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,1
release_dateDateOctober 1998
labelList of String, delimiter: ,Virgin EMI
catalog_idList of String, delimiter: ,7243 8 95358 2 2 8953582
formatList of String, delimiter: ,CD
countryStringAustralia
discogsInteger2,353,755
musicbrainzString45d5002b-3a03-34dc-9c3e-39af607ec4ae
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,2
release_dateDate1998-09-07
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 95361 2 6 HUTDX 106
formatList of String, delimiter: ,CD
countryStringUK
discogsInteger1,089,992
musicbrainzString05d16737-fbd2-4eab-8be3-aef6a7305ba8
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,3
release_dateDate1998-09-07
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 95360 2 7 HUTCDF 106
formatList of String, delimiter: ,CD
countryStringEurope
discogsInteger51,545
musicbrainzStringedc571be-b28d-471d-8b6d-bb90e468f302
FieldField typeValue
workPagePerfect
listing_idList of Integer, delimiter: ,4
release_dateDate1998-10-06
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,V25F-38650 7243 8 38650 2 4
formatList of String, delimiter: ,CD
countryStringUS
discogsInteger538,836
musicbrainzString69fc2fb9-aaa9-431c-bc98-957c235f2445

"song_charts" values

15 rows are stored for this page
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Australia

positionInteger56
dateDate1998
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Canadatopsingles

positionInteger11
dateDate1998-11-02
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Canadadance

positionInteger19
dateDate1998-11-30
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Canadarock

positionInteger2
dateDate1998-09-21
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardcanadiandigital

positionInteger13
dateDate1998-10-31
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Iceland

positionInteger17
dateDate
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

New Zealand

positionInteger18
dateDate1998-09-27
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Scotland

positionInteger21
dateDate1998-09-19
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

UKsinglesbyname

positionInteger24
dateDate1998-09-19
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardhot100

positionInteger54
dateDate1998-10-24
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardadultalternativesongs

positionInteger8
dateDate1998-09-12
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardadultpopsongs

positionInteger31
dateDate1998-09-12
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardalternativesongs

positionInteger3
dateDate1998-09-05
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardmainstreamrock

positionInteger33
dateDate1998-09-19
FieldField typeValue
songPagePerfect
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardactiverock

positionInteger27
dateDate1998-10-03

"personnel_credits" values

8 rows are stored for this page
FieldField typeValue
personPageJoey Waronker
rolesList of String, delimiter: ,drums
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageBilly Corgan
rolesList of String, delimiter: ,production
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageHoward Willing
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageFlood
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageBjorn Thorsrud
rolesList of String, delimiter: ,editing
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageRobbie Adams
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageBon Harris
rolesList of String, delimiter: ,programming
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJay Nicholas
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger