musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "rock music" and musiccaps_aspects contains "sound effects"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic drums 2
- electric guitar · 2 ✖
- rock music · 2 ✖
- sound effects · 2 ✖
- bass guitar 1
- common sounding 1
- energetic 1
- female vocal 1
- generic 1
- loud 1
- melodic singing 1
- normal tempo 1
- thai 1
- tutorial 1
- underwater 1
musiccaps_names (array) 7 ✖
- Music 2
- Gurgling 1
- Heavy metal 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Tick-tock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Water Wolf Camera Tutorial | This is a rock music piece playing in the background of a tutorial video. There is an electric guitar playing a simple tune as the lead while another provides a rhythmic backing by playing the same note repeatedly in rapid procession. There is an acoustic drum beat playing. There are water sound effects related to the video. The piece has a generic feeling. It does not evoke much excitement. It could be used as a jingle for an advertisement or in the background of an instructive video. | 2014-06-27T08:50:52Z | Savage Gear | ["Music", "Gurgling"] | ["rock music", "tutorial", "electric guitar", "acoustic drums", "sound effects", "underwater", "loud", "generic", "common sounding"] | 9 | -taO6N-rxv4 | 96 | ||
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 |
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;