musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_author = 6 and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic guitar · 2 ✖
- amateur recording 1
- clapping 1
- e-bass 1
- flutes 1
- higher pitch 1
- hindi/pop 1
- male voice singing 1
- mandolin 1
- medium tempo 1
- medium to uptempo 1
- peaceful sounding 1
- percussion 1
- tablas 1
- violin 1
- whistling 1
musiccaps_names (array) 5 ✖
- Folk music · 2 ✖
- Music 2
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kjarkas - Yo no he nacido para sufrir HD | This song contains someone strumming a melody on a mandolin while more people are whistling along. Then a mandolin, an e-bass and an acoustic guitar are playing a short melody in a lower key before breaking into the next part along with flutes and percussions. This song may be played outside by musicians performing. | 2016-07-07T01:47:40Z | calacas555 | Tema que será parte de la nueva producción cdgráfica del grupo Kjarkas denominado la Leyenda Viva | ["Folk music", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "e-bass", "mandolin", "flutes", "whistling", "percussion", "medium tempo"] | 6 | ZTVMsW1h3bI | 3379 | |
Carrom - 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | This song contains a tabla rhythm spread across both sides of the speakers. An acoustic guitar melody panned to the right side of the speakers. Far in the background you can hear clapping as part of the song. A male voice is singing in a higher register than a violin takes over playing a melody in a higher register with reverb and a little delay. This song may be playing in a lovely movie-scene. | 2009-09-16T03:35:04Z | carrompassion | 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | ["Folk music", "Music"] | ["hindi/pop", "tablas", "violin", "acoustic guitar", "clapping", "male voice singing", "higher pitch", "medium to uptempo", "peaceful sounding"] | 6 | nFoktpUVeVw | 4528 |
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;