musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "crowd noises" and musiccaps_aspects contains "passionate male vocal" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- crowd noises · 2 ✖
- emotional 2
- low quality 2
- passionate male vocal · 2 ✖
- acoustic guitar arpeggiated melody 1
- addictive 1
- electric guitar solo melody 1
- energetic 1
- energetic cymbals 1
- groovy bass guitar 1
- heartfelt 1
- live performance 1
- mellow piano melody 1
- muffled kick hits 1
- muffled snare hits 1
- noisy 1
- pop 1
- rock 1
musiccaps_names (array) 8 ✖
- Music 2
- /t/dd00003 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Roll 1
- Singing 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
EXO Chanyeol 2014 special stage live guitar and singing parts compilation | The low quality recording features a pop song performed by passionate male vocalists, followed by acoustic guitar arpeggiated melody and mellow piano melody. It sounds heartfelt and emotional. There are some crowd noises in the background. | 2015-01-12T14:42:18Z | geniechan | List of songs: 141231 MBC Gayo Daejun 2014 https://www.youtube.com/watch?v=-bGjK1ErIZ8 141226 KBS Gayo Daejun 2014 Don't Be Sad (슬픈 표정 하지 말아요) https://www.youtube.com/watch?v=NvRyjwIvxKU 141112 KBS MUSIC BANK in MEXICO Sabor a mi https://www.youtube.com/watch?v=Gk1iZ8na42I love love love acoustic version (this one is not live but I include it as it sounds so beautiful XD) https://www.youtube.com/watch?v=yO9C-4wFx_4 I do not own ANY of the soundtrack and images. full credits go to exo and the aforementioned tv programs. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "/t/dd00003"] | ["low quality", "pop", "acoustic guitar arpeggiated melody", "passionate male vocal", "crowd noises", "mellow piano melody", "heartfelt", "emotional"] | 4 | 0_QcatLmg7c | 182 |
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;