musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_author = 4 and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- passionate male vocal · 2 ✖
- emotional 1
- heartfelt 1
- mellow 1
- mellow piano chords 1
- mellow woodwind melody 1
- passionate 1
- punchy kick 1
- sad 1
- shimmering bells 1
- shimmering hi hats 1
- snappy rimshots 1
- soft 1
- soft bass 1
- sustained strings melody 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 |
---|---|---|---|---|---|---|---|---|---|---|
Googoosh Music Academy من همینم | The low quality recording features a passionate male vocal singing over mellow piano chords, shimmering hi hats, snappy rimshots, punchy kick and soft bass. It sounds emotional, passionate and heartfelt. | 2010-11-04T20:15:13Z | manototv | آکادمی موسیقی گوگوش 2010 اجرای گروهی «من همینم» آهنگساز : بابک سعیدی ترانه سرا : رها اعتمادی کارگردانان و خوانندگان به ترتیب حروف الفبا ارسلان ارغوان امیر سارا سروش فروغ کسرا هاله http://www.manoto1.com manoto1 Hotbird Frequency: 11317 Vertical Symbole Rate: 27500 | ["Music", "Sad music"] | ["low quality", "snappy rimshots", "shimmering hi hats", "mellow piano chords", "soft bass", "punchy kick", "passionate male vocal", "emotional", "passionate", "heartfelt"] | 4 | 1YPYQP6yupA | 286 | |
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 |
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;