musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- electric guitar melody · 3 ✖
- emotional · 3 ✖
- groovy bass · 3 ✖
- low quality 3
- passionate 2
- shimmering hi hats 2
- soft kick hits 2
- acoustic rhythm guitar 1
- background music 1
- ballad 1
- cinematic 1
- echoing synth bell melody 1
- flat male vocal 1
- harmonizing male vocals 1
- heartfelt 1
- hopeful 1
- joyful 1
- live performance 1
- mellow 1
- mellow harmonizing reverberant female vocals 1
- mellow keys melody 1
- mono 1
- noisy 1
- passionate male vocal 1
- playback instrumental 1
- pop 1
- pulsating synth melody 1
- punchy kick 1
- punchy snare 1
- shimmering tambourine 1
- soft rimshots 1
- soul 1
- soulful 1
- sustained strings melody 1
- toms roll 1
musiccaps_names (array) 4 ✖
- Music 2
- /t/dd00003 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Dassin - Et si tu n ' existais pas | The low quality recording features a ballad that contains a flat male vocal, alongside mellow harmonizing, reverberant female vocals, singing over acoustic rhythm guitar located in the left channel, electric guitar melody in the right channel of the stereo image, groovy bass, shimmering hi hats, soft rimshots, soft kick hits and mellow keys melody. It sounds mellow, emotional, passionate and heartfelt. | 2008-12-02T21:40:48Z | melenia1 | Tu es mon amour... | ["Soul music"] | ["low quality", "ballad", "flat male vocal", "mellow harmonizing reverberant female vocals", "groovy bass", "acoustic rhythm guitar", "electric guitar melody", "shimmering hi hats", "soft rimshots", "soft kick hits", "mellow keys melody", "mellow", "emotional", "passionate", "heartfelt"] | 4 | 4kZ0EZg5JRU | 600 | |
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;