musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "popular song" and musiccaps_author = 7 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- popular song · 2 ✖
- acoustic guitar accompaniment 1
- amateur home recording 1
- amplified guitar 1
- cheerful 1
- clapping 1
- electric guitar lead and harmony 1
- emphatic vocals 1
- entertaining 1
- enthusiastic 1
- fast tempo 1
- happy 1
- instrumental 1
- joyful 1
- lively 1
- male vocalist 1
- minimalist 1
- nostalgic 1
- party song 1
- people talking 1
- pleasant 1
- powerful music 1
- singing along 1
- slow tempo 1
- soft 1
- sonic power 1
- spanish guitar 1
- spanish song 1
- stringed instrument 1
- youthful 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hotel California - the Eagles Full Guitar with backing track www.Farhatguitar.com | This music is an electric guitar instrumental. The tempo is slow with an electric guitar lead and harmony of a popular song. No other instrument is used. It is mellow, pleasant, nostalgic, soft , mellifluous and soothing. | 2011-01-11T16:31:38Z | Farhat Guitar | TAB http://farhatguitar.com/lessons/the-eagles-hotel-california/ My Music http://elgranojorojo.com/Siento_Y_Presiento_EGOR_2015.zip FB: http://www.facebook.com/FarhatGuitarOfficial Twitter:http://twitter.com/FarHatGuitar FB my Band: https://www.facebook.com/ElGranOjoRojo Spotify : https://open.spotify.com/artist/3nc5PxwNs1zAYVnxahfjoX Old Music: http://goo.gl/2T3YfX See you Marcos Farhat | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead and harmony", "popular song", "minimalist", "pleasant", "nostalgic", "amplified guitar", "powerful music", "sonic power", "stringed instrument", "soft", "pleasant"] | 7 | uQTCfT5XDzQ | 5112 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 |
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;