musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "wide electric guitar melody" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- passionate male vocal · 3 ✖
- wide electric guitar melody · 3 ✖
- energetic 2
- low quality 2
- punchy kick 2
- punchy snare 2
- rock 2
- shimmering hi hats 2
- addictive 1
- exciting 1
- fun 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- harmonizing male vocals 1
- joyful 1
- live performance 1
- mellow kick hits 1
- pop 1
- shimmering cymbals 1
- syncopated snare 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Music · 3 ✖
- Blues 1
- Exciting music 1
- Rhythm and blues 1
- Rock and roll 1
- Rock music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sayang Kinabalu Music Video by Nikki and Jimmy Palikat | The low quality recording features a pop song that consists of a passionate male vocal singing over mellow kick hits, shimmering hi hats, wide electric guitar melody, syncopated snare and wooden percussion. The first half of the loop does not consist of the vocal, snare and hi hats. It sounds happy, fun and joyful. | 2014-07-23T10:21:33Z | Hotlink | Kepada saudara-saudari dari Sabah, terima kasih atas sokongan anda. Kami harap anda seronok mendengar lagu SAYANG KINABALU dinyanyikan oleh Jimmy & Nikki Palikat. Dapatkan muat turun lagu penuh PERCUMA dengan hantar GET SYGKINABALUFS ke 29000 atau dapatkan Caller Ringtone PERCUMA dengan hantar GET SYGKINABALUCRT ke 29000. Untuk maklumat lanjut #Hotlink, sila dapatkan di www.hotlink.com.my/sabah | ["Blues", "Music"] | ["low quality", "pop", "passionate male vocal", "happy", "fun", "joyful", "mellow kick hits", "shimmering hi hats", "wide electric guitar melody", "wooden percussions", "syncopated snare"] | 4 | -rAhS48FkYw | 92 | |
Billy Talent - Fallen Leaves Music Video (HQ) | The Rock song features a passionate male vocal, alongside harmonizing male vocals, singing over wide electric guitar melody, groovy bass guitar, punchy kick and snare hits and some shimmering cymbals. It sounds energetic and kind of addictive thanks to those harmonizing vocals - like something you would hear on a radio during the 00s. | 2010-04-27T14:20:24Z | Jimmy Karlsson | The official music video of the song with the same name enjoy... Update 2012-12-01 Thanks for 100 000 views | ["Music", "Rhythm and blues", "Exciting music"] | ["rock", "passionate male vocal", "harmonizing male vocals", "wide electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "addictive"] | 4 | 0LE6Ll1rVlg | 150 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 |
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;