musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "guitar" and musiccaps_aspects contains "piano" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- guitar · 6 ✖
- piano · 6 ✖
- moderate tempo 5
- bass 4
- instrumental 2
- no voices 2
- romantic mood 2
- simple percussion 2
- acoustic drums 1
- backing voice 1
- big band jazz 1
- bollywood song 1
- double bass 1
- e-bass 1
- easy listening 1
- falsetto voice 1
- female voice 1
- happy mood 1
- high register voice 1
- male voice 1
- male voices 1
- medium to uptempo 1
- mood elevating 1
- motown feel 1
- percussion 1
- pop rock song 1
- pop song 1
- r&b song 1
- reed instrument 1
- relaxing song 1
- ride cymbal 1
- slow rock song 1
- tabla 1
- upbeat song 1
- vocal harmony 1
- yodel/folkmusic 1
- yodeling 1
musiccaps_names (array) 13 ✖
- Music 4
- Bass drum 2
- Drum 2
- Drum kit 2
- Drum roll 2
- Percussion 2
- Rimshot 2
- Snare drum 2
- Country 1
- Happy music 1
- Music of Asia 1
- Soul music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Temptations "The Girl's Alright With Me" My Extended Version! | This R&B song features a male voice singing the main melody in falsetto. There are other male voices singing backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords without any flourishes or embellishments. A piano plays an arpeggiated pattern that changes with the chords of the song. A guitar strums chords using upstrokes. The mood of this song is romantic. The melody has a motown feel. This song can be played at the end credits of a romantic movie. | 2012-04-20T20:56:50Z | mosogotam | No copyright infringement intended. One of my favorite Tempts tunes....extended just a smidge. | ["Music", "Soul music"] | ["r&b song", "male voices", "vocal harmony", "falsetto voice", "guitar", "simple percussion", "bass", "piano", "motown feel", "moderate tempo", "romantic mood"] | 0 | LGi38MqlPFA | 2170 | |
TechnoNeotorand - He taught me to yodel with lyrics (Full version) | The e-bass is playing an almost walking line along with a guitar playing a melody on top. The acoustic drums are playing a constant rhythm along with a piano playing one chord on the offbeat. The yodeling voice sings in a higher pitch and sounds amused. This song may be playing at a local folk festival. | 2009-09-11T13:35:43Z | TechnoNeotorand | full version with the fast part ! | ["Country", "Yodeling", "Music"] | ["yodel/folkmusic", "e-bass", "piano", "acoustic drums", "yodeling", "high register voice", "guitar", "mood elevating", "medium to uptempo"] | 6 | L_fWnna7Np0 | 2199 | |
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 | |
The Best Of Bollywood At The Royal Stag Mirchi Music Awards | Radio Mirchi | This bollywood song features a female voice singing the main melody. This is accompanied by a tabla and other percussion playing a staccato beat. A guitar strums chords in staccato following the percussion in the breaks. Another guitar plays arpeggiated chords. A piano plays in the background. The bass walks down playing a descending bassline. The mood of this song is romantic. This song can be played in a romantic movie. | 2016-03-13T15:25:38Z | Mirchi Plus | Watch the rockstars sing the super duper hits at The Royal Stag Mirchi Music Awards. Just wow! Drop in your feedback in the comment box below. For more details, 'Like' us on Facebook: https://www.facebook.com/mirchi983fm 'Follow' us on Twitter: http://twitter.com/mirchi983fm 'Subscribe' to the New Exclusive Murga Channel: http://bit.ly/148F8xe Add us to your circle on Google+: https://plus.google.com/+Mirchi983Fm | ["Music of Asia", "Music"] | ["bollywood song", "female voice", "guitar", "tabla", "bass", "piano", "romantic mood", "moderate tempo"] | 0 | n_boIyhZqWc | 4557 | |
Hanson Returns! | This pop rock song features a male voice singing the main melody. A backing male voice sings the last part of the line in harmony. This is accompanied by a piano playing staccato chords. There is a momentary silence of instruments except the percussion after the chords are struck. An acoustic guitar plays chords in the background. A bass guitar plays the root notes of the chords. The percussion plays a simple beat in common time and finishes the bar with a roll. Then the drum plays with the beat with an open hi-hat. The mood of this song is happy. This song can be played in a coming of age movie. | 2008-09-06T22:44:23Z | CBS | It may be hard to believe that all three of these brothers are now married and have children, but the hit 90's pop group Hanson still knows how to rock. The trio perform live on the Second Cup Café. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["pop rock song", "male voice", "simple percussion", "guitar", "piano", "bass", "backing voice", "upbeat song", "happy mood", "moderate tempo"] | 0 | pwX5SArqGKU | 4743 |
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;