musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "rock drumming" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- instrumental music · 2 ✖
- percussive bass line 2
- rock drumming · 2 ✖
- adrenaline rush 1
- adventurous 1
- ambient crowd noises 1
- bad audio quality 1
- cymbals crashing 1
- death metal music 1
- diva 1
- electric rhythm guitar playing 1
- energetic 1
- exciting 1
- fast tempo 1
- female guitarist 1
- groovy rhythm 1
- guitar playing rhythm 1
- guitar solo 1
- hard rock 1
- head banging 1
- home video 1
- live concert video 1
- live performance 1
- medium fast tempo 1
- medium fats tempo 1
- mosh pit 1
- passionate 1
- people cheering 1
- people screaming 1
- poor audio quality 1
- poor audio recording 1
- retro death metal hits 1
- rock band 1
- rock guitar solo 1
- spirited 1
- testosterone driven 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 2
- Angry music 1
- Guitar 1
- Inside, large room or hall 1
- Pop music 1
- Rock music 1
- Whoop 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Crematory - Tick Tack | The song is an instrumental. The tempo is medium fast with strong metal drumming, groovy bass line, distorted guitar playing rhythm and cymbals crashing. The song is high on adrenaline and exciting. The audio quality is poor. | 2009-05-09T13:45:07Z | pavenpaul | Artist: Crematory Song: Tick Tack Album: Revolution Genre: Gothic metal Track # 6 | ["Music", "Rock music", "Angry music"] | ["instrumental music", "death metal music", "retro death metal hits", "poor audio quality", "cymbals crashing", "fast tempo", "groovy rhythm", "guitar playing rhythm", "rock drumming", "energetic", "adrenaline rush", "passionate", "head banging", "mosh pit", "spirited", "percussive bass line"] | 1 | gCSShNsw-_A | 4013 |
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;