musiccaps_details (view)
3 rows where musiccaps_aspects contains "mellow", musiccaps_author = 4 and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- mellow · 3 ✖
- low quality 2
- soft 2
- easygoing 1
- echoing female vocal 1
- electric guitar melody 1
- emotional 1
- filtered sustained synth bass 1
- mellow piano chord progression 1
- mellow piano chords 1
- mellow woodwind melody 1
- passionate 1
- passionate male vocal 1
- pop 1
- sad 1
- shimmering bells 1
- smooth bass 1
- sustained strings melody 1
- synth pad chords 1
- walking on concrete sound 1
- wide arpeggiated piano melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fawn Rescue | The low quality recording features a wide arpeggiated piano melody, sustained strings melody, mellow woodwind melody and shimmering bells over which the passionate male vocalist is singing at the very end of the loop. There is also the sound of walking on concrete. It sounds mellow, soft and sad. There is also the sound of walking on concrete. | 2011-06-21T06:56:26Z | Darren Jesse | Fawn rescued from pool on its last breath and reunited with its mother. Song: "Abba Father" by Christ Our Life - www.christourlife.ca. Song: "I Will Never Leave You" by Jay Stocker - www.scripture-lullabies.com | ["Music", "Sad music"] | ["walking on concrete sound", "low quality", "wide arpeggiated piano melody", "sustained strings melody", "mellow woodwind melody", "shimmering bells", "mellow", "soft", "passionate male vocal", "sad"] | 4 | 6CaZAITdAsk | 735 | |
Rosie Delmah - Tangi ia Koe (Cultural Music Video) | The Pop song features an echoing female vocal singing over mellow piano chord progression and filtered sustained synth bass. It sounds emotional, mellow and passionate. | 2016-05-27T07:31:08Z | Rosie Delmah | Rosie Delmah https://www.facebook.com/rosie.delmah Prod. by Baka Solomon https://www.facebook.com/BakaSolomonMusic Filmed by Torn Parachute https://www.facebook.com/tornparachute | ["Music", "Sad music"] | ["pop", "mellow piano chord progression", "filtered sustained synth bass", "echoing female vocal", "passionate", "emotional", "mellow"] | 4 | UiiYMspxfhU | 2936 | |
دورة المياه في الطبيعة | The low quality recording features a smooth bass, electric guitar melody, synth pad chords and mellow piano chords playing. It sounds soft, mellow and easygoing. | 2013-01-13T18:52:46Z | Malak Msarwa | ["Music", "Sad music"] | ["low quality", "smooth bass", "electric guitar melody", "synth pad chords", "mellow piano chords", "soft", "mellow", "easygoing"] | 4 | Vwekk3EOa-U | 3043 |
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;