musiccaps_details (view)
2 rows where musiccaps_aspects contains "minimalist", musiccaps_aspects contains "youthful" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- electric guitar 2
- fast tempo 2
- minimalist · 2 ✖
- youthful · 2 ✖
- acoustic guitar 1
- amplified guitar 1
- bollywood 1
- bollywood retro 1
- bongos 1
- duet 1
- emotional 1
- external amplification 1
- hard rock 1
- heavy metal 1
- hindi song 1
- instrumental 1
- keyboard accompaniment 1
- lead 1
- lively 1
- loud 1
- love song 1
- metal 1
- passionate 1
- playful 1
- powerful 1
- rock 1
- speech like singing 1
- sprechstimme 1
- stringed instrument 1
- young love 1
musiccaps_names (array) 7 ✖
- Music 2
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Music of Bollywood 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Boss DN-2 Dyna Drive Demo: Gear Up | This music is instrumental. The tempo is medium fast with an energetic electric guitar lead. The music is minimalist with no accompaniment. It is youthful, powerful, enthusiastic, controlled, engaging and intense. This music is Hard Rock/Heavy Metal. | 2012-05-03T16:21:42Z | gearuptmntv | Let your pick set the gain. The Dyna Drive by Boss is very responsive to pick attack. This allows you to lighten up your touch and the drive will clean up. This technology was borrowed from the Roland Cube-60. So if you want a responsive distortion pedal this might be the one for you. Gear Up Be Sure You Go To The Gear Up Channel For Past Episodes http://www.youtube.com/gearuptmntv If you want to request a piece of gear you want on the show just send me a message!!! Also Go Stop By The Musician Network Channel for Other Great Content. http://www.youtube.com/tmntv | ["Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["instrumental", "fast tempo", "electric guitar", "metal", "heavy metal", "hard rock", "amplified guitar", "external amplification", "minimalist", "youthful", "loud", "powerful", "lead", "stringed instrument", "rock", "heavy metal"] | 7 | 9QEm6u4bowQ | 1003 | |
Are Kahe Ko Kahe Ko - Shashi Kapoor - Zeenat Aman - Chori Mera Kaam - Bollywood Songs - Asha Bhosle | This song is a Retro Hindi movie song. The tempo is fast with rhythmic guitar, vigorous guitar, keyboard harmony, congas and bongos. The music is minimalistic and simple with speech like singing. The song is playful, cheerful, upbeat, youthful and energetic. | 2012-06-04T11:06:50Z | Shemaroo Filmi Gaane | Movie : Chori Mera Kaam (1975) Music Director: Kalyanji Anandji Singers: Kishore Kumar and Asha Bhosle Director: Brij Lyrics: Verma Malik Enjoy this Hit song from the 1975 movie Chori Mera Kaam starring Ashok Kumar, Shashi Kapoor, Zeenat Aman and Pran. From the latest Bollywood songs to the oldest, SUBSCRIBE now to http://www.YouTube.com/FilmiGaane To see all the latest music playlists that we've created just for you, click here - http://www.youtube.com/user/filmigaane/videos?sort=dd&flow=list&view=1 Connect with us on :- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle and follow us on Google+ - https://plus.google.com/+shemaroo . Download Filmi Gaane App - http://twd.bz/fg Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at : connect@shemaroo.com | ["Singing", "Music", "Music of Bollywood"] | ["duet", "fast tempo", "hindi song", "bollywood", "bongos", "keyboard accompaniment", "lively", "youthful", "love song", "playful", "young love", "passionate", "minimalist", "emotional", "bollywood retro", "speech like singing", "acoustic guitar", "electric guitar", "sprechstimme"] | 7 | iEQwupwwp0s | 4171 |
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;