musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "pop song", musiccaps_aspects contains "relaxing song" and musiccaps_author = 0
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bell’s Harmonic | This instrumental pop song features an acoustic guitar being played fingerstyle. The notes are being plucked. Guitar harmonics are played in between the plucked notes. This song is played at a moderate tempo. There is no percussion in this song. There are no other instruments in this song. The mood of this song is relaxing. This song can be played in a coffee shop. | 2015-12-10T22:08:52Z | Alan Gogoll | Become a Supporter: https://www.youtube.com/channel/UC8NhGqX78q_bsuYtP-K9Oig/join Bell's Harmonic by Alan Gogoll 💿 Stream/Support → https://open.spotify.com/playlist/37i9dQZF1DZ06evO4C2uGb 🌅 Website → https://www.alangogoll.com Seahorse Bells is the fifth studio album from Australian Solo Acoustic Guitarist Alan Gogoll. Each of the five original compositions showcases Alan's original 'Bell Harmonics' technique and guitar tunings that have become his signature sound and featuring for the first time his signature Paul Mineur guitar. | ["Guitar", "Acoustic guitar", "Music", "Strum", "Harmonic", "Plucked string instrument"] | ["pop song", "acoustic guitar", "fingerstyle", "harmonics", "moderate tempo", "no percussion", "no other instruments", "no voices", "easy listening", "relaxing song"] | 0 | 9xV0nmojVeg | 1051 | |
Hlub Teev Kua Muag Fan MV | This instrumental slow rock song features a guitar playing arpeggiated chords. This is accompanied by a piano playing passing chords. The percussion consists of only the ride cymbal being struck in a set of two strokes followed by a set of four strokes. This pattern continues throughout the song. The bass plays the root notes and filler notes at the start of each bar. There are no voices in this song. This song can be played in a coffee shop. | 2009-04-12T01:49:39Z | leemyis | Fan MV of Wu Chun & Aff Taksaorn... Song: Koj nyob rawv hauv siab by Nkauj Hli Vwj | ["Music", "Happy music"] | ["slow rock song", "pop song", "guitar", "piano", "ride cymbal", "bass", "no voices", "instrumental", "moderate tempo", "relaxing song"] | 0 | TFLt7mn57ZI | 2824 |
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;