Page values for "Ava Adore"

"songs" values

1 row is stored for this page
FieldField typeAllowed valuesValue
nameStringAva Adore
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-05-18
writerList of Page, delimiter: ,Billy Corgan
videoBooleanYes
spotifyString6bVB2MGR7LcotAIB1vfpw6
discogsInteger48,747
musicbrainzStringabea81ea-5a98-3d02-a3c3-a198561cab07
coverFile
SmashingPumpkins-AvaAdore.jpg

"music_videos" values

1 row is stored for this page
FieldField typeValue
youtubeString9uWwvQKGjLI
release_dateDate1998-06-01
songStringAva Adore
artistPageThe Smashing Pumpkins
albumStringAdore
directorList of Page, delimiter: ,Dom and Nic
vma_awardsList of String, delimiter: ,
vma_nominationsList of String, delimiter: ,
vma_dateDate
muchmusic_no1_dateDate1998-08-14
notesWikitext

won an award for "most stylish video" at the 1998 VH1 Fashion Awards

"track_listings" values

5 rows are stored for this page
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAva Adore
headlineStringMain release
listing_idInteger1
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:22
FieldField typeValue
songStringCzarina
song_page_titleStringCzarina
workStringAva Adore
headlineStringMain release
listing_idInteger1
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:43
FieldField typeValue
songStringOnce in a While
song_page_titleStringOnce in a While
workStringAva Adore
headlineStringMain release
listing_idInteger1
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:33
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAva Adore
headlineStringUK Limited Edition numbered 7" vinyl
listing_idInteger2
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:22
FieldField typeValue
songStringCzarina
song_page_titleStringCzarina
workStringAva Adore
headlineStringUK Limited Edition numbered 7" vinyl
listing_idInteger2
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:43

"releases" values

4 rows are stored for this page
FieldField typeValue
workPageAva Adore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-05-18
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,V25F-38647 7243 8 38647 2 0
formatList of String, delimiter: ,CD
countryStringUS
discogsInteger678,148
musicbrainzStringfe454979-494c-4b6b-a92d-0cdfc217438d
FieldField typeValue
workPageAva Adore
listing_idList of Integer, delimiter: ,1
release_dateDateMay 1998
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,7243 8 38647 4 4
formatList of String, delimiter: ,Cassette
countryStringUS
discogsInteger5,910,781
musicbrainzString
FieldField typeValue
workPageAva Adore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-05-18
labelList of String, delimiter: ,Hut Recordings Virgin
catalog_idList of String, delimiter: ,HUTCD 101 7243 8 95120 2 1
formatList of String, delimiter: ,CD
countryStringUK & Europe
discogsInteger380,196
musicbrainzStringd5c6a7f7-ee40-3048-91ca-8a8e93cba6c6
FieldField typeValue
workPageAva Adore
listing_idList of Integer, delimiter: ,2
release_dateDateMay 1998
labelList of String, delimiter: ,Hut Recordings Virgin
catalog_idList of String, delimiter: ,HUT 101 7243 8 95120 7 6
formatList of String, delimiter: ,7"
countryStringUK
discogsInteger1,605,144
musicbrainzString

"song_charts" values

20 rows are stored for this page
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Australia

positionInteger19
dateDate1998-05-31
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Canadatopsingles

positionInteger16
dateDate1998-08-10
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Canadarock

positionInteger2
dateDate1998-07-27
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardcanadiandigital

positionInteger9
dateDate1998-07-18
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Europe100

positionInteger42
dateDate1998-06-08
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Germany2

positionInteger91
dateDate1998-06-01
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Greece

positionInteger2
dateDate1998-06-27
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Iceland

positionInteger1
dateDate1998-06-19
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Ireland2

positionInteger15
dateDate1998-05-21
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Dutch100

positionInteger77
dateDate1998-05-30
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

New Zealand

positionInteger5
dateDate1998-06-07
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Norway

positionInteger11
dateDate1998-05-25
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Polandlp3

positionInteger10
dateDate1998-07-17
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Scotland

positionInteger11
dateDate1998-05-30
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Sweden

positionInteger19
dateDate1998-05-29
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

UK

positionInteger11
dateDate1998-05-30
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardhot100

positionInteger42
dateDate1998-07-04
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardmainstreamrock

positionInteger8
dateDate1998-07-11
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardalternativesongs

positionInteger3
dateDate1998-06-20
FieldField typeValue
songPageAva Adore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboardactiverock

positionInteger3
dateDate1998-06-20

"personnel_credits" values

8 rows are stored for this page
FieldField typeValue
personPageMatt Walker
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
personPageBrad Wood
rolesList of String, delimiter: ,production engineering
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: ,engineering editing
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageBon Harris
rolesList of String, delimiter: ,programming
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageEric Greedy
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger