musiccaps_details (view)
4 rows where musiccaps_aspects contains "sentimental", musiccaps_aspects contains "vibrant" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- sentimental · 4 ✖
- vibrant · 4 ✖
- female vocal 3
- bass guitar 2
- keyboard 2
- melodic singing 2
- acoustic drums 1
- afro percussion 1
- afropop 1
- amp 1
- carnatic classical 1
- choir 1
- dreamy 1
- eastern sounding 1
- electric guitar 1
- electronic drums 1
- male vocal 1
- medium tempo 1
- melancholic 1
- orchestra 1
- oud 1
- pop music 1
- reverb 1
- simple tune 1
- sitar 1
- slightly slow tempo 1
- strings section 1
- tabla 1
- tunisian folk music 1
- veena-like singing 1
musiccaps_names (array) 10 ✖
- Music 4
- Carnatic music 1
- Folk music 1
- Jazz 1
- Music of Africa 1
- Music of Asia 1
- Pop music 1
- Radio 1
- Reverberation 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jagadodharana | Sudha Raghunathan Songs | Carnatic Classical Music | Idea Jalsa | Art and Artistes | This is a Carnatic classical music piece. There is a female vocalist singing melodically while shifting her voice in a veena-like manner. The sitar is playing the melody and the tabla is playing the rhythm. There is a sentimental and dreamy atmosphere to this piece. | 2014-04-30T12:47:18Z | Art And Artistes | --- Click on SUBSCRIBE to get updates, and stay tuned for the richest collection of the Traditional Music of India. Concept: Durga Jasraj, follow her at: Facebook.com/DurgaJasraj Instagram.com/DurgaJasraj Twitter.com/DurgaJasraj Producers - Durga Jasraj & Neeraj Jaitly Label: Art and Artistes, follow us at: Facebook.com/ArtAndArtistes Instagram.com/ArtAndArtistes Twitter.com/ArtAndArtistes LinkedIn.com/ArtAndArtistes YouTube.com/ArtAndArtistes | ["Carnatic music", "Folk music", "Music"] | ["carnatic classical", "female vocal", "veena-like singing", "sitar", "tabla", "sentimental", "dreamy", "vibrant"] | 9 | 1JqNiV03kog | 258 | |
Bab Darek / Mohamed-Ali Kammoun feat. Eya Daghnouj | This is a Tunisian folk music piece. There is an orchestra playing the main tune with the dominant sound of the strings section and the oud. There is a choir singing in the background. The atmosphere is vibrant and sentimental. This piece could be in the soundtrack of a Middle Eastern/North African soap opera. | 2013-08-28T19:45:37Z | Mohamed-Ali KAMMOUN | EYA DAGHNOUJ - LEAD VOICE HAMDI MAKHLOUF - LUTH & CHORUS VOICE FEAT. ENSEMBLE ORCHESTRAL DE TUNISIE MOHAMED-ALI KAMMOUN ARRANGEMENT & ELECTRONIC LIVE RECORDING : july 12, room 12, Institut Supérieur de Musique - Tunis, By YACINE AZAIEZ HOME STUDIO MIX : MOHAMED-ALI KAMMOUN | ["Jazz", "Music"] | ["tunisian folk music", "orchestra", "choir", "strings section", "oud", "vibrant", "sentimental", "melancholic", "eastern sounding"] | 9 | 5J6CjNc8Njo | 649 | |
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 | |
BRENDA FASSIE - Mama | This is an Afropop music piece. There is a female vocalist singing melodically. The main tune is being played by the keyboard while the bass guitar is playing in the background. The rhythmic background consists of a slightly slow tempo acoustic drum beat and afro percussive elements. The atmosphere is vibrant and sentimental. This piece can be used as the soundtrack of a drama movie that takes place in Africa. | 2010-06-28T02:31:30Z | Kegnaste | Tribute to the QUEEN, you'll always be in our hearts | ["Music of Africa", "Music"] | ["afropop", "female vocal", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "afro percussion", "slightly slow tempo", "vibrant", "sentimental"] | 9 | W_zgEkvp4xU | 3108 |
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;