musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "percussion instrument" and musiccaps_aspects contains "sharp"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- instrumental · 2 ✖
- percussion instrument · 2 ✖
- sharp · 2 ✖
- acerbic 1
- calming engaging 1
- catchy beat 1
- drum beat 1
- drum head 1
- folk music 1
- gamelan 1
- hand pan 1
- hand percussion 1
- jingles 1
- medium fast tempo 1
- medium tempo 1
- metal bowls 1
- metal plates 1
- metallic sounds 1
- metallophones 1
- minimal instrumentation 1
- percussion 1
- pleasant 1
- portable percussion instrument 1
- regional music 1
- rhythmic beat 1
- rhythmic beats 1
- simple melody 1
- small metal plates 1
- soft drum head beat 1
- soothing 1
- tambourine beats 1
- xylophone 1
musiccaps_names (array) 3 ✖
- Music 2
- Tambourine 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Conversation for Two Tambourines | This music is a percussion instrumental . The tempo is medium fast with a rhythmic tambourine beat. The music is minimal with the sound of the tambourine metal plates clanging and a dull drum head beat. The music is catchy, enthusiastic and has a rhythmic beat. | 2010-01-08T01:22:27Z | jmvdude | A tambourine duet written by my instructor, Bobby Lopez | ["Music", "Tambourine"] | ["instrumental", "medium fast tempo", "percussion instrument", "minimal instrumentation", "soft drum head beat", "catchy beat", "rhythmic beat", "small metal plates", "jingles", "portable percussion instrument", "sharp", "acerbic", "tambourine beats", "hand percussion", "rhythmic beats", "metallic sounds", "drum head"] | 7 | 7_80oVTLkGU | 861 | |
Traditional Music from Malaysia | This music clip is an instrumental with gamelan instrumental lead along with a hand percussion. The tempo is medium with melodic sounds and harmony from the striking of metal bowls or plates. The music is soft, melodious, calming, engaging and interesting and sounds a lot like a xylophone. | 2008-01-19T15:34:23Z | gosites | Meim Besuch der Kota Masuri, dem Grab einer auf Langkawi verehrten Prinzessin, wird man mit Musik empfangen. | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "drum beat", "metal plates", "metal bowls", "calming engaging", "folk music", "regional music", "percussion", "soothing", "gamelan", "metallophones", "percussion instrument", "xylophone", "hand pan", "sharp", "pleasant", "simple melody"] | 7 | mfZMcNmLxWM | 4485 |
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;