musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "no voices" and musiccaps_aspects contains "piano" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- instrumental 3
- no voices · 3 ✖
- piano · 3 ✖
- bass 2
- guitar 2
- moderate tempo 2
- 12 bar blues 1
- big band jazz 1
- double bass 1
- easy listening 1
- guitar solo 1
- percussion 1
- pop song 1
- reed instrument 1
- relaxing song 1
- ride cymbal 1
- simple percussion 1
- slow blues song 1
- slow rock song 1
- slow tempo 1
musiccaps_names (array) 13 ✖
- Music 2
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Guitar 1
- Happy music 1
- Jazz 1
- Musical instrument 1
- Percussion 1
- Plucked string instrument 1
- Rimshot 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Lunch an Animated Parable in HD (VeggieTales) | This jazz song features the main melody played on a reed instrument and a guitar in unison. The melody is an ascending pattern of three notes per beat. This is accompanied by percussion playing a simple beat ending on an extended drum roll. The bass plays a descending run followed by an ascending run. The piano plays jazz chords in the background. There are no voices in this instrumental song. This song can be played in a luxury bar. | 2011-01-19T20:35:07Z | Carlos Gonzalez | This Video is NOT made by me it was made by BigIdea Productions. Copyright BigIdea Productions. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["big band jazz", "percussion", "no voices", "instrumental", "piano", "reed instrument", "guitar", "double bass", "moderate tempo", "easy listening"] | 0 | _miAGxDX5FM | 3489 | |
Jazzed Blues Solo | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | 2006-07-17T14:30:15Z | looptruefire | My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | 0 | qAgZ__fk9LY | 4760 |
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;