musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Exciting music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- instrumental · 2 ✖
- acoustic guitar 1
- acoustic rhythm guitar 1
- addictive 1
- catchy 1
- clapping 1
- classic pop 1
- electric guitar chord progression 1
- energetic 1
- fingers snapping 1
- fresh 1
- funky bass lines 1
- groovy bass 1
- happy 1
- keyboard harmony 1
- low quality 1
- medium fast tempo 1
- melodic 1
- peppy 1
- pop music 1
- punchy snare 1
- retro music 1
- rhythmic drumming 1
- rock 1
- shimmering hi hats 1
- simple harmony 1
- sunny 1
- whistle harmony 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Silversun Pickups - Kissing Families [Official Music Video] | The low quality recording features a rock song instrumental that consists of shimmering hi hats, punchy snare, groovy bass guitar, acoustic rhythm guitar in the left channel and electric guitar chord progression in the right channel of the stereo image. It sounds energetic and addictive. | 2009-03-20T17:08:17Z | Silversun Pickups | Directed by Suzie Vlcek Get PIKUL here: http://smarturl.it/sspupikulEP http://silversunpickups.com http://twitter.com/sspu http://instagram.com/sspu http://facebook.com/silversunpickups | ["Music", "Exciting music"] | ["low quality", "rock", "instrumental", "shimmering hi hats", "punchy snare", "groovy bass", "acoustic rhythm guitar", "electric guitar chord progression", "energetic", "addictive"] | 4 | -XN0NtrnfMY | 58 | |
Tajomný ostrov (1984) series intro music | This music is instrumental. The tempo is medium fast with a melodic keyboard harmony, punchy drumming, funky bass lines, and rhythmic acoustic guitar, whistle harmony and clapping and fingers snapping.The melody is simple, sunny, warm, energetic and youthful with a retro vibe. This music is classic Pop. | 2009-09-01T20:07:10Z | dbacelic | ["Music", "Exciting music"] | ["instrumental", "pop music", "medium fast tempo", "acoustic guitar", "classic pop", "peppy", "retro music", "keyboard harmony", "rhythmic drumming", "funky bass lines", "whistle harmony", "clapping", "fingers snapping", "simple harmony", "melodic", "catchy", "fresh", "happy", "sunny"] | 7 | Pk5NZe-ah4U | 2560 |
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;