musiccaps_details (view)
3 rows where musiccaps_aspects contains "soft" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- soft · 3 ✖
- violin · 3 ✖
- emotional 2
- instrumental 2
- sentimental 2
- slow tempo 2
- acoustic guitar 1
- ambient 1
- amplified cello harmony 1
- banjo 1
- beseeching 1
- boomy bass 1
- bow stringed instrument 1
- captivating 1
- cello 1
- country music 1
- country pop 1
- country song 1
- country songs 1
- delicate 1
- digital drumming 1
- engaging 1
- fiddle 1
- four stringed instrument 1
- keyboard accompaniment 1
- male singer 1
- mandolin 1
- meditative 1
- medium fast tempo 1
- mellow 1
- melodic 1
- melodious 1
- mesmerising 1
- pensive 1
- piano accompaniment 1
- pleading 1
- poignant 1
- ponderous 1
- prayer 1
- reflective 1
- regional music 1
- request 1
- resonator 1
- rhythmic drumming 1
- sad 1
- soothing 1
- spirited string arrangement 1
- steady bass 1
- steady drumming 1
- string instrument 1
- ukelele accompaniment 1
musiccaps_names (array) 7 ✖
- Bowed string instrument 2
- Cello 2
- Double bass 2
- Music 1
- Pizzicato 1
- Roll 1
- Violin, fiddle 1
youtube_published (date) 2 ✖
- 2008-05-09 1
- 2009-12-31 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Beaux Arts Trio plays Dvorak "Dumky" Trio, ii | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | 2008-05-09T02:43:46Z | Scott Meek | Live from Herbst Theatre, San Francisco April 20, 2008 Menahem Pressler, piano Daniel Hope, violin Antonio Meneses, cello | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | 7 | EkmHGd0U8yE | 1585 | |
Missing from YouTube | This is a melodious instrumental. The tempo is slow with a cello harmony, ukulele accompaniment, boomy bass and steady drumming. The music is soft, mellow, ethereal, classic, soothing, captivating and mellifluous. | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "slow tempo", "amplified cello harmony", "bow stringed instrument", "four stringed instrument", "string instrument", "digital drumming", "ukelele accompaniment", "boomy bass", "violin", "steady drumming", "soft", "soothing", "engaging", "captivating", "mesmerising", "melodious"] | 7 | 2344 | |||||
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;