musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "tuning"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental · 2 ✖
- tuning · 2 ✖
- 12-string acoustic guitar 1
- alto 1
- amateur video 1
- crackling sound 1
- electric disturbance 1
- friction 1
- grim 1
- guitar tuning 1
- home recording 1
- monotone 1
- no accompaniments 1
- no accompanying instruments 1
- no voice 1
- sinister sounds 1
- slow tempo 1
- spooky 1
- static sound 1
- tenor 1
- tense 1
- vibration 1
musiccaps_names (array) 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afinador de violão | This clip is an instrumental. The tempo is slow with a stringed instrument playing a single monotone note. There is the sound of static in the background. This sound is of a stringed instrument getting tuned but it has a spooky, eerie, sinister and scary vibe when combined with the static in the background. | 2011-05-19T22:38:47Z | thiagovinicius100 | Afinador de violão | ["Music", "Electronic tuner"] | ["instrumental", "static sound", "vibration", "home recording", "amateur video", "slow tempo", "monotone", "tense", "grim", "spooky", "no accompanying instruments", "guitar tuning", "alto", "tenor", "tuning", "sinister sounds", "instrumental", "no accompaniments", "electric disturbance", "friction", "crackling sound"] | 7 | N4tTZn8WlDM | 2320 | |
Afinador de Cuatro Puertorriqueño - Puertorican Cuatro Tuner | The music is purely instrumental and it features a 12-string acoustic guitar playing the same note over and over. Since it's a 12-string guitar the note can be heard played twice really fast. I guess a better name would be tuning instead of melody, because it sounds as if the guitarist is trying to tune the 2 strings to play the same note together. | 2014-09-09T10:57:45Z | Help For Musicians! | ----------------------------------------------------------------------------------------------- Audio trining Playlists: Notes: https://www.youtube.com/playlist?list=PLzxlkSbLSD3Mjtcjl5RUGxTpmoGbXjQJj Chords: https://www.youtube.com/playlist?list=PLzxlkSbLSD3MugZRsd25rUd_uv64pLK-s Audio training - single notes: https://www.youtube.com/playlist?list=PLzxlkSbLSD3Mjtcjl5RUGxTpmoGbXjQJj Access all of our contents here: http://toolsformusicians.blogspot.com ----------------------------------------------------------------------------------------------- If you like the type of content I produce and want to help me continue creating it, you can do it with a donation, there is no amount too small! PAYPAL: aguirre414@hotmail.com ----------------------------------------------------------------------------------------------- Si te gusta el tipo de contenido que produzco y quieres ayudarme a seguir creándolo, lo puedes hacer con una donación, no hay cantidad demasiado pequeña! PAYPAL : aguirre414@hotmail.com Access all of our contents here: http://toolsformusicians.blogspot.com ----------------------------------------------------------------------------------------------- | ["Music", "Electronic tuner"] | ["instrumental", "no voice", "12-string acoustic guitar", "tuning"] | 2 | ql7aH8wF6JM | 4813 |
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;