2 rows are stored for this page
Field | Field type | Allowed values | Value |
---|
name | String | | Rotten Apples |
cover | File | | |
type | List of String, delimiter: , | ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotional | compilation |
artist | Page | The Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artists | The Smashing Pumpkins |
studio | List of String, delimiter: , | | |
producer | List of Page, delimiter: , | | Billy Corgan • Ted de Bono • Flood • James Iha • Alan Moulder • Bjorn Thorsrud • Butch Vig • Howard Willing • Brad Wood |
engineer | List of Page, delimiter: , | | |
released | Date | | 2001-11-20 |
discogs | Integer | | 48,790 |
musicbrainz | String | | 629f866b-c8d1-3985-9da7-a648e8a3aaab |
Field | Field type | Allowed values | Value |
---|
name | String | | Judas O |
cover | File | | |
type | List of String, delimiter: , | ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotional | compilation |
artist | Page | The Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artists | The Smashing Pumpkins |
studio | List of String, delimiter: , | | |
producer | List of Page, delimiter: , | | Kerry Brown • Billy Corgan • Ted de Bono • Flood • James Iha • Alan Moulder • Bjorn Thorsrud • Butch Vig • Howard Willing • Brad Wood |
engineer | List of Page, delimiter: , | | |
released | Date | | 2001-11-20 |
discogs | Integer | | |
musicbrainz | String | | |
52 rows are stored for this page
Field | Field type | Value |
---|
song | String | Siva |
song_page_title | String | Siva |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 1 |
source | Page | |
length | String | 4:21 |
Field | Field type | Value |
---|
song | String | Rhinoceros |
song_page_title | String | Rhinoceros |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 2 |
source | Page | |
length | String | 5:53 |
Field | Field type | Value |
---|
song | String | Drown |
song_page_title | String | Drown |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 3 |
source | Page | |
length | String | 4:30 |
Field | Field type | Value |
---|
song | String | Cherub Rock |
song_page_title | String | Cherub Rock |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 4 |
source | Page | |
length | String | 4:59 |
Field | Field type | Value |
---|
song | String | Today |
song_page_title | String | Today |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 5 |
source | Page | |
length | String | 3:22 |
Field | Field type | Value |
---|
song | String | Disarm |
song_page_title | String | Disarm |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 6 |
source | Page | |
length | String | 3:18 |
Field | Field type | Value |
---|
song | String | Landslide |
song_page_title | String | Landslide |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 7 |
source | Page | |
length | String | 3:06 |
Field | Field type | Value |
---|
song | String | Bullet with Butterfly Wings |
song_page_title | String | Bullet with Butterfly Wings |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 8 |
source | Page | |
length | String | 4:18 |
Field | Field type | Value |
---|
song | String | 1979 |
song_page_title | String | 1979 |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 9 |
source | Page | |
length | String | 4:23 |
Field | Field type | Value |
---|
song | String | Zero |
song_page_title | String | Zero |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 10 |
source | Page | |
length | String | 2:41 |
Field | Field type | Value |
---|
song | String | Tonight, Tonight |
song_page_title | String | Tonight, Tonight |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 11 |
source | Page | |
length | String | 4:15 |
Field | Field type | Value |
---|
song | String | Eye |
song_page_title | String | Eye |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 12 |
source | Page | |
length | String | 4:54 |
Field | Field type | Value |
---|
song | String | Ava Adore |
song_page_title | String | Ava Adore |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 13 |
source | Page | |
length | String | 4:21 |
Field | Field type | Value |
---|
song | String | Perfect |
song_page_title | String | Perfect |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 14 |
source | Page | |
length | String | 3:22 |
Field | Field type | Value |
---|
song | String | The Everlasting Gaze |
song_page_title | String | The Everlasting Gaze |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 15 |
source | Page | |
length | String | 4:02 |
Field | Field type | Value |
---|
song | String | Stand Inside Your Love |
song_page_title | String | Stand Inside Your Love |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 16 |
source | Page | |
length | String | 4:13 |
Field | Field type | Value |
---|
song | String | Real Love |
song_page_title | String | Real Love |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 17 |
source | Page | |
length | String | 4:10 |
Field | Field type | Value |
---|
song | String | Untitled |
song_page_title | String | Untitled |
work | String | Rotten Apples |
headline | String | North American version |
listing_id | Integer | 1 |
main_listing | Boolean | No |
track | Integer | 18 |
source | Page | |
length | String | 3:51 |
Field | Field type | Value |
---|
song | String | Siva |
song_page_title | String | Siva |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 1 |
source | Page | |
length | String | 4:21 |
Field | Field type | Value |
---|
song | String | Rhinoceros |
song_page_title | String | Rhinoceros |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 2 |
source | Page | |
length | String | 5:54 |
Field | Field type | Value |
---|
song | String | Drown |
song_page_title | String | Drown |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 3 |
source | Page | |
length | String | 4:30 |
Field | Field type | Value |
---|
song | String | Cherub Rock |
song_page_title | String | Cherub Rock |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 4 |
source | Page | |
length | String | 4:58 |
Field | Field type | Value |
---|
song | String | Today |
song_page_title | String | Today |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 5 |
source | Page | |
length | String | 3:22 |
Field | Field type | Value |
---|
song | String | Disarm |
song_page_title | String | Disarm |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 6 |
source | Page | |
length | String | 3:17 |
Field | Field type | Value |
---|
song | String | Bullet with Butterfly Wings |
song_page_title | String | Bullet with Butterfly Wings |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 7 |
source | Page | |
length | String | 4:17 |
Field | Field type | Value |
---|
song | String | 1979 |
song_page_title | String | 1979 |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 8 |
source | Page | |
length | String | 4:24 |
Field | Field type | Value |
---|
song | String | Zero |
song_page_title | String | Zero |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 9 |
source | Page | |
length | String | 2:40 |
Field | Field type | Value |
---|
song | String | Tonight, Tonight |
song_page_title | String | Tonight, Tonight |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 10 |
source | Page | |
length | String | 4:16 |
Field | Field type | Value |
---|
song | String | Eye |
song_page_title | String | Eye |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 11 |
source | Page | |
length | String | 4:54 |
Field | Field type | Value |
---|
song | String | Ava Adore |
song_page_title | String | Ava Adore |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 12 |
source | Page | |
length | String | 4:20 |
Field | Field type | Value |
---|
song | String | Perfect |
song_page_title | String | Perfect |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 13 |
source | Page | |
length | String | 3:23 |
Field | Field type | Value |
---|
song | String | The Everlasting Gaze |
song_page_title | String | The Everlasting Gaze |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 14 |
source | Page | |
length | String | 4:02 |
Field | Field type | Value |
---|
song | String | Stand Inside Your Love |
song_page_title | String | Stand Inside Your Love |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 15 |
source | Page | |
length | String | 4:13 |
Field | Field type | Value |
---|
song | String | Try, Try, Try |
song_page_title | String | Try, Try, Try |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 16 |
source | Page | |
length | String | 5:09 |
Field | Field type | Value |
---|
song | String | Real Love |
song_page_title | String | Real Love |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 17 |
source | Page | |
length | String | 4:10 |
Field | Field type | Value |
---|
song | String | Untitled |
song_page_title | String | Untitled |
work | String | Rotten Apples |
headline | String | International version |
listing_id | Integer | 2 |
main_listing | Boolean | No |
track | Integer | 18 |
source | Page | |
length | String | 3:53 |
Field | Field type | Value |
---|
song | String | Lucky 13 |
song_page_title | String | Lucky 13 |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 1 |
source | Page | |
length | String | 3:09 |
Field | Field type | Value |
---|
song | String | The Aeroplane Flies High (Turns Left, Looks Right) |
song_page_title | String | The Aeroplane Flies High (Turns Left, Looks Right) |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 2 |
source | Page | |
length | String | 7:53 |
Field | Field type | Value |
---|
song | String | Because You Are |
song_page_title | String | Because You Are |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 3 |
source | Page | |
length | String | 3:46 |
Field | Field type | Value |
---|
song | String | Slow Dawn |
song_page_title | String | Slow Dawn |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 4 |
source | Page | |
length | String | 3:12 |
Field | Field type | Value |
---|
song | String | Believe |
song_page_title | String | Believe |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 5 |
source | Page | |
length | String | 3:12 |
Field | Field type | Value |
---|
song | String | My Mistake |
song_page_title | String | My Mistake |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 6 |
source | Page | |
length | String | 4:00 |
Field | Field type | Value |
---|
song | String | Marquis in Spades |
song_page_title | String | Marquis in Spades |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 7 |
source | Page | |
length | String | 3:12 |
Field | Field type | Value |
---|
song | String | Here's to the Atom Bomb |
song_page_title | String | Here's to the Atom Bomb |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 8 |
source | Page | |
length | String | 4:26 |
Field | Field type | Value |
---|
song | String | Sparrow |
song_page_title | String | Sparrow |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 9 |
source | Page | |
length | String | 2:56 |
Field | Field type | Value |
---|
song | String | Waiting |
song_page_title | String | Waiting |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 10 |
source | Page | |
length | String | 3:48 |
Field | Field type | Value |
---|
song | String | Saturnine |
song_page_title | String | Saturnine |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 11 |
source | Page | |
length | String | 3:49 |
Field | Field type | Value |
---|
song | String | Rock On |
song_page_title | String | Rock On |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 12 |
source | Page | |
length | String | 6:06 |
Field | Field type | Value |
---|
song | String | Set the Ray to Jerry |
song_page_title | String | Set the Ray to Jerry |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 13 |
source | Page | |
length | String | 4:09 |
Field | Field type | Value |
---|
song | String | Winterlong |
song_page_title | String | Winterlong |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 14 |
source | Page | |
length | String | 4:59 |
Field | Field type | Value |
---|
song | String | Soot and Stars |
song_page_title | String | Soot and Stars |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 15 |
source | Page | |
length | String | 6:39 |
Field | Field type | Value |
---|
song | String | Blissed and Gone |
song_page_title | String | Blissed and Gone |
work | String | Rotten Apples |
headline | String | |
listing_id | Integer | 3 |
main_listing | Boolean | No |
track | Integer | 16 |
source | Page | |
length | String | 4:46 |
16 rows are stored for this page
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Australia
|
position | Integer | 4 |
date | Date | 2001-12-02 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Austria
|
position | Integer | 22 |
date | Date | 2001-12-02 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Flanders
|
position | Integer | 15 |
date | Date | 2001-12-08 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Wallonia
|
position | Integer | 37 |
date | Date | 2001-12-08 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | BillboardCanada
|
position | Integer | 5 |
date | Date | 2001-12-15 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Finland
|
position | Integer | 25 |
date | Date | 2001-11-25 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Germany4
|
position | Integer | 28 |
date | Date | 2001-12-03 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Italy
|
position | Integer | 15 |
date | Date | 2001-11-22 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | New Zealand
|
position | Integer | 5 |
date | Date | 2001-12-02 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Norway
|
position | Integer | 11 |
date | Date | 2001-11-26 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Scotland
|
position | Integer | 24 |
date | Date | 2001-11-25 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Sweden
|
position | Integer | 31 |
date | Date | 2001-11-30 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Switzerland
|
position | Integer | 40 |
date | Date | 2001-12-02 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | UK
|
position | Integer | 28 |
date | Date | 2001-11-25 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | Billboard200
|
position | Integer | 31 |
date | Date | 2001-12-08 |
Field | Field type | Value |
---|
album | Page | Rotten Apples |
artist | String | The Smashing Pumpkins |
chart | Wikitext string | BillboardAlbumSales
|
position | Integer | 31 |
date | Date | 2001-12-08 |
5 rows are stored for this page
Field | Field type | Allowed values | Value |
---|
artist | String | | The Smashing Pumpkins |
work | String | | Rotten Apples |
type | String | album · single · video | album |
award | String | | Gold |
number | Integer | | |
region | String | | Australia |
date | Date | | 2001-11-16 |
Field | Field type | Allowed values | Value |
---|
artist | String | | The Smashing Pumpkins |
work | String | | Greatest Hits |
type | String | album · single · video | album |
award | String | | Platinum |
number | Integer | | |
region | String | | Canada |
date | Date | | 2002-03-28 |
Field | Field type | Allowed values | Value |
---|
artist | String | | The Smashing Pumpkins |
work | String | | Rotten Apples |
type | String | album · single · video | album |
award | String | | Platinum |
number | Integer | | |
region | String | | New Zealand |
date | Date | | |
Field | Field type | Allowed values | Value |
---|
artist | String | | The Smashing Pumpkins |
work | String | | Rotten Apples |
type | String | album · single · video | album |
award | String | | Gold |
number | Integer | | |
region | String | | Spain |
date | Date | | 2001 |
Field | Field type | Allowed values | Value |
---|
artist | String | | The Smashing Pumpkins |
work | String | | Rotten Apples – The Greatest Hits |
type | String | album · single · video | album |
award | String | | Gold |
number | Integer | | |
region | String | | United Kingdom |
date | Date | | 2013-07-22 |
3 rows are stored for this page
Field | Field type | Value |
---|
work | Page | Rotten Apples |
listing_id | List of Integer, delimiter: , | 2 • 3 |
release_date | Date | 2001-11-16 |
label | List of String, delimiter: , | Virgin |
catalog_id | List of String, delimiter: , | VJCP-68343-44 |
format | List of String, delimiter: , | 2×CD |
country | String | Japan |
discogs | Integer | 3,454,328 |
musicbrainz | String | c56d6e94-e1ac-4afb-8ff6-9dd5dcd30c11 |
Field | Field type | Value |
---|
work | Page | Rotten Apples |
listing_id | List of Integer, delimiter: , | 2 • 3 |
release_date | Date | 2001-11-19 |
label | List of String, delimiter: , | Virgin • Hut Recordings |
catalog_id | List of String, delimiter: , | 7243 8 11557 2 1 • CDHUTD70 |
format | List of String, delimiter: , | 2×CD |
country | String | Europe |
discogs | Integer | 4,672,798 |
musicbrainz | String | 45c57051-d92f-310c-b0db-2a7ad464343f |
Field | Field type | Value |
---|
work | Page | Rotten Apples |
listing_id | List of Integer, delimiter: , | 1 • 3 |
release_date | Date | 2001-11-20 |
label | List of String, delimiter: , | Virgin |
catalog_id | List of String, delimiter: , | 7243 8 11318 2 4 |
format | List of String, delimiter: , | 2×CD |
country | String | US |
discogs | Integer | 574,503 |
musicbrainz | String | a31fdfae-e2fd-4c4e-b1ed-db8018c9a859 |