musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "ride cymbal" and musiccaps_names contains "Music" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 21 ✖
- ride cymbal · 3 ✖
- instrumental 2
- bass 1
- bass guitar 1
- china cymbal 1
- congas 1
- electric guitar 1
- electric piano 1
- female voice 1
- guitar 1
- lead electric guitar melody 1
- moderate tempo 1
- no voices 1
- piano 1
- pop song 1
- relaxing song 1
- rhythm electric guitar strumming 1
- slow rock song 1
- spring reverb 1
- surf rock 1
- walking bassline 1
musiccaps_names (array) 3 ✖
- Music · 3 ✖
- Happy music 2
- Blues 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sounds - Emma | Instrumental surf rock with a lead electric guitar playing the melody and a rhythm electric guitar strumming chords. Ride cymbals are loud in the mix and spring reverb is used as an effect. The electric bass is playing a walking pattern. | 2008-03-07T19:41:01Z | MadeInFinland76 | The Sounds - Emma (1963) Henrik Granö, kitara Bobi Söderblom, kitara Peter Ekman, basso Johnny Liebkind, rummut | ["Blues", "Music"] | ["instrumental", "surf rock", "ride cymbal", "spring reverb", "rhythm electric guitar strumming", "lead electric guitar melody", "walking bassline"] | 8 | 4Y5VcH7iK3Q | 583 | |
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 | |
Hengameh - Khalkoobi | The music features a female voice singing an ascending melody. The rhythm section consists of a bass guitar, a pair of congas and a ride cymbal. An electric piano accompanies the singer with chords. In the background an electric guitar plays an accompaniment that combines melody and chords. Right at the end of the music excerpt a China cymbal can be heard. | 2011-06-01T21:33:00Z | shan5400 | ["Music", "Happy music"] | ["female voice", "electric guitar", "congas", "ride cymbal", "china cymbal", "bass guitar", "electric piano"] | 2 | 6N1LWG4aztA | 748 |
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;