musiccaps_details (view)
3 rows where musiccaps_aspects contains "vigorous" and musiccaps_author = 9 sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- vigorous · 3 ✖
- acoustic guitar 1
- aggressive 1
- alternative rock 1
- bass guitar 1
- distorted electric guitar 1
- electronic dance music 1
- electronic drums 1
- grunge rock 1
- instrumental 1
- latin 1
- latin dance 1
- loud 1
- loud acoustic drums 1
- medium tempo 1
- rebellious 1
- shuffle 1
- strong bass 1
- synth 1
- tango 1
- techno 1
- upbeat 1
musiccaps_names (array) 6 ✖
- Music 3
- Angry music 1
- Dubstep 1
- Electronic dance music 1
- Shuffle 1
- Ukulele 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tango "Nostalgias" - (1/2) Argentine original - Charlo ! | This is an instrumental latin music piece. There is a rapidly-played acoustic guitar intro acting as a dance accompaniment. It has a lively atmosphere. This piece could be helpful in a latin dance course setting. | 2007-10-21T20:01:54Z | jurek46pink | "Nostalgias" - great composition of Argentine musician Juan Carlos Cobian to the poem by Enrique Cadicamo, from the moment of creation (mid 30s) has been an unique expression of a tango - usually sung or played far behind the standard rhythm. It seams that this refined music as well as lyrics did not need any beat base. Here -- one of the earliest recordings made by Charlo; Argentine singer of the period. | ["Music", "Ukulele"] | ["instrumental", "acoustic guitar", "latin", "tango", "latin dance", "vigorous"] | 9 | SU9ZP2pbqyU | 2769 | |
CZ/SK Shuffle Tournament | Round 3 | Ubuntus vs Facer | This is an EDM/techno music piece with a loud synth lead. There is a strong bass and an upbeat electronic drum beat in the background creating an atmosphere of high energy which is essential to electronic dance music. This music could be used in nightclubs, techno DJ sets and EDM venues. | 2011-08-28T21:48:26Z | Ubuntus Shuffler | Enjoy :D | ["Music", "Shuffle", "Dubstep", "Electronic dance music"] | ["techno", "electronic dance music", "shuffle", "synth", "strong bass", "electronic drums", "loud", "upbeat", "vigorous"] | 9 | c2akbbdS7I4 | 3675 | |
Butterfingers Royal Jelly | This is an alternative rock piece. The main theme is played through power chords by a distorted electric guitar. In the background, a bass guitar is playing a groovy bass line. The rhythmic background is provided by loud acoustic drums playing a rock drum beat with frequent usage of rapid fills. The atmosphere of the song is aggressive and rebellious. It could be used in the soundtrack of a teenage drama or a crime series. | 2012-10-23T07:50:02Z | AltMzk | My favorite band | ["Music", "Angry music"] | ["alternative rock", "grunge rock", "distorted electric guitar", "bass guitar", "loud acoustic drums", "medium tempo", "aggressive", "rebellious", "vigorous"] | 9 | okAn7kjxmes | 4656 |
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;