musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "higher pitch" and musiccaps_aspects contains "medium to uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitar 3
- higher pitch · 3 ✖
- medium to uptempo · 3 ✖
- male voice singing 2
- accordion 1
- acoustic drums 1
- amateur recording 1
- cheerful atmosphere 1
- clapping 1
- e-bass 1
- folkmusic 1
- hindi/pop 1
- male singer 1
- peaceful sounding 1
- percussion 1
- pop 1
- synth string sound 1
- tablas 1
- violin 1
musiccaps_names (array) 4 ✖
- Music 2
- Accordion 1
- Christian music 1
- Folk music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carrom - 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | This song contains a tabla rhythm spread across both sides of the speakers. An acoustic guitar melody panned to the right side of the speakers. Far in the background you can hear clapping as part of the song. A male voice is singing in a higher register than a violin takes over playing a melody in a higher register with reverb and a little delay. This song may be playing in a lovely movie-scene. | 2009-09-16T03:35:04Z | carrompassion | 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | ["Folk music", "Music"] | ["hindi/pop", "tablas", "violin", "acoustic guitar", "clapping", "male voice singing", "higher pitch", "medium to uptempo", "peaceful sounding"] | 6 | nFoktpUVeVw | 4528 | |
GETULIO VARGAS cavalo amarelo. | This song contains someone playing an accordion melody and chords along with an acoustic guitar strumming the same chords. Someone is playing an acoustic instrument while a male voice is singing in a higher key. This song may be playing in the countryside. | 2011-03-06T17:18:58Z | ALOCHECULTURAGAUCHA | CLIP gravado por NELSON OLIVEIRA para o programa Alô Chê do IVAN TABORDA. | ["Accordion"] | ["folkmusic", "accordion", "acoustic guitar", "male singer", "higher pitch", "percussion", "medium to uptempo", "amateur recording", "cheerful atmosphere"] | 6 | nJ3tuDmcdTs | 4531 | |
Shane & Shane - When I Think About The Lord | Someone is playing a kick on every beat along with little fill-ins on toms, cymbals and hihat. An e-bass is playing long notes along with an acoustic guitar finger picking chords while another guitar is playing higher pitched notes in a tremolo. A male voice is singing in a higher pitch sounding grateful. An atmospheric synth pad sound is rising in the background processed with a lot of reverb. This song may be playing with headphones enjoying a beautiful day. | 2008-05-08T21:47:53Z | monkeypop24 | another video, this time with the song when i think about the Lord by shane & shane... not ALL the pictures are repeated, like my other two vids, but some pics are the same as filled with Your glory and such... but thats cuz my movie maker thing or whatever kept freezing..piece of junk. anyway, if u see a pic that u saw in the other one, that's too bad for you~~!(jk) All pictures are found off Google Search. No copyright intended. LYRICS : When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! When I think about the Lord How He saved me, How He raised me How He filled me With the Holy Ghost How He healed me To the uttermost. When I think about the Lord How He picked me up, Turned me around, How He set my feet On solid ground And it makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! It makes me want to shout: Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! Hallelujah Thank You, Jesus Lord, You're worthy Of all the glory, And all the honor And all the praise... Yeahh Hallelujah! Thank You, Jesus! Lord, You're worthy Of all the glory, And all the honor And all the praise! And all the praise! And all the praise! Yeahh | ["Christian music", "Music"] | ["pop", "acoustic guitar", "e-bass", "acoustic drums", "synth string sound", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | tdTT6rmkk9M | 5054 |
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;