musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "exciting", musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 58 ✖
- exciting · 3 ✖
- percussive bass line · 3 ✖
- youthful · 3 ✖
- enthusiastic 2
- male singer 2
- adventurous 1
- aisi an pop 1
- ambient crowd noises 1
- asian pop hits 1
- backup singers 1
- bad audio quality 1
- bleeding crowd noise 1
- break the tension 1
- building anticipation 1
- buzz 1
- distorted amplified guitar 1
- diva 1
- drum roll 1
- electric rhythm guitar playing 1
- electrostatic sounds 1
- energetic 1
- enthusiastic drumming 1
- female guitarist 1
- get tones 1
- groovy drumming rhythm 1
- guitar rhythm 1
- guitar solo 1
- guitar strumming 1
- hard rock 1
- heart beat melody 1
- home video 1
- instrumental music 1
- k-pop 1
- korean rock band 1
- live concert video 1
- live performance 1
- medium fast tempo 1
- medium fats tempo 1
- passionate 1
- people cheering 1
- people screaming 1
- people talking ambient sounds 1
- piano accompaniment 1
- poor audio recording 1
- pop 1
- pop dance rhythm 1
- pop dance song 1
- pop hits 1
- rapping vocals 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- signal tempo 1
- spirited 1
- storm cloud noises 1
- teen spirit 1
- testosterone driven 1
- vocal harmony 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jones Cup 2012 - Smart Gilas Sige Lang Music Video HD | A male singer sings this cool melody with backup singers in vocal harmony. The tempo is medium with a groovy drumming rhythm, guitar accompaniment, piano accompaniment, percussive bass line and ambient crowd noises. The song is a modern Asian pop song. | 2012-08-30T00:39:31Z | Sound Check Music | Induk Videography Music: Sige lang By Quest | ["Blues", "Disco", "Music", "Speech"] | ["male singer", "backup singers", "asian pop hits", "bleeding crowd noise", "rapping vocals", "vocal harmony", "exciting", "enthusiastic", "groovy drumming rhythm", "percussive bass line", "piano accompaniment", "guitar rhythm", "people talking ambient sounds", "energetic", "youthful", "pop hits", "aisi an pop"] | 1 | AtJ2RXQ98kY | 1179 | |
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 |
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;