1 row is stored for this page
| Field | Field type | Allowed values | Value |
|---|
| name | String | | Crestfallen |
| type | List of String, delimiter: , | song · single · promo · cover · instrumental | promo |
| artist | Page | The Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artists | The Smashing Pumpkins |
| original_artist | String | | |
| main_album | Page | | Adore |
| song_release_date | Date | | |
| writer | List of Page, delimiter: , | | Billy Corgan |
| video | Boolean | | |
| spotify | String | | 17hfEGORUQIWnsaSadvmr6 |
| discogs | Integer | | |
| musicbrainz | String | | |
| cover | File | |  Crestfallen.jpeg |
2 rows are stored for this page
| Field | Field type | Value |
|---|
| song | String | Crestfallen |
| song_page_title | String | Crestfallen |
| work | String | Crestfallen |
| headline | String | US Promo CD single |
| listing_id | Integer | 1 |
| main_listing | Boolean | No |
| track | Integer | 1 |
| source | Page | |
| length | String | 4:09 |
| Field | Field type | Value |
|---|
| song | String | Crestfallen |
| song_page_title | String | Crestfallen |
| work | String | Crestfallen |
| headline | String | US Promo CD single |
| listing_id | Integer | 1 |
| main_listing | Boolean | No |
| track | Integer | 2 |
| source | Page | |
| length | String | 0:10 |
1 row is stored for this page
| Field | Field type | Value |
|---|
| work | Page | Crestfallen |
| listing_id | List of Integer, delimiter: , | 1 |
| release_date | Date | November 1998 |
| label | List of String, delimiter: , | Virgin |
| catalog_id | List of String, delimiter: , | 7087 6 13629 2 3 • DPRO-13629 |
| format | List of String, delimiter: , | CD |
| country | String | US |
| discogs | Integer | 1,714,611 |
| musicbrainz | String | 766351a6-e576-4663-bb72-616faf583e0b |
10 rows are stored for this page
| Field | Field type | Value |
|---|
| person | Page | Billy Corgan |
| roles | List of String, delimiter: , | piano • vocals |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | James Iha |
| roles | List of String, delimiter: , | guitar |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | D'arcy Wretzky |
| roles | List of String, delimiter: , | bass |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Billy Corgan |
| roles | List of String, delimiter: , | production |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Howard Willing |
| roles | List of String, delimiter: , | engineering |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Bjorn Thorsrud |
| roles | List of String, delimiter: , | editing |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Neil Perry |
| roles | List of String, delimiter: , | engineering |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Robbie Adams |
| roles | List of String, delimiter: , | engineering |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Bon Harris |
| roles | List of String, delimiter: , | programming |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
| Field | Field type | Value |
|---|
| person | Page | Jay Nicholas |
| roles | List of String, delimiter: , | |
| tracks | List of Integer, delimiter: , | |
| listing_id | Integer | |
