musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion", musiccaps_author = 7 and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- instrumental 2
- percussion · 2 ✖
- animated 1
- bow stringed 1
- bright 1
- cajun music 1
- calming engaging 1
- country music 1
- drum beat 1
- fast tempo 1
- fiddle 1
- folk music 1
- four stringed instrument 1
- gamelan 1
- hand pan 1
- high pitched 1
- lively 1
- medium tempo 1
- melodious 1
- metal bowls 1
- metal plates 1
- metallophones 1
- percussion instrument 1
- pleasant 1
- regional music 1
- sharp 1
- simple melody 1
- soothing 1
- spirited 1
- string instrument 1
- violin 1
- western classical 1
- xylophone 1
musiccaps_names (array) 6 ✖
- Music 2
- Traditional music · 2 ✖
- Bowed string instrument 1
- Country 1
- Musical instrument 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dewey Balfa - Jai Ete Au Bal - Awesome Fiddlesticks | This music is a lively fiddle instrumental. The tempo is fast with a percussion accompaniment. The music is spirited, vibrant, enthusiastic,cheerful, happy , merry and sunny. This music is Country Folk. | 2008-02-03T02:16:58Z | Paul | Clip is taken from Yasha Aginsky's documentary "Les Blues de Balfa". It is an AWESOME film I would HIGHLY recommend. Dewey Balfa and his nephew Tony Balfa preforming Jai Ete Au Bal (I Went To The Dance). | ["Country", "Traditional music", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "fast tempo", "fiddle", "string instrument", "cajun music", "spirited", "bright", "melodious", "violin", "western classical", "four stringed instrument", "high pitched", "bow stringed", "country music", "lively", "animated", "percussion", "spirited"] | 7 | UFyOGqmITjM | 2901 | |
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;