musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "soul"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- live performance · 4 ✖
- soul · 4 ✖
- emotional 3
- low quality 2
- r&b 2
- acoustic guitar 1
- bass guitar 1
- crowd clapping 1
- crowd talking 1
- electric guitar 1
- electric guitar melody 1
- electric piano 1
- electronic drums 1
- female choir 1
- female vocal 1
- grandiose 1
- groovy 1
- groovy bass 1
- harmonizing male vocals 1
- harp melody 1
- hip-hop 1
- hopeful 1
- joyful 1
- keyboard 1
- male vocal 1
- melodic singing 1
- mixed harmonized vocals 1
- mono 1
- noisy 1
- passionate 1
- passionate female vocal 1
- passionate male vocal 1
- playback 1
- playback instrumental 1
- punchy snare 1
- shimmering tambourine 1
- simple bass 1
- soft kick hits 1
- soulful 1
- soulful female vocalist 1
- sustained strings melody 1
- toms roll 1
musiccaps_names (array) 8 ✖
- Music 4
- Music of Asia 2
- Singing 2
- /t/dd00003 1
- Acoustic guitar 1
- Buzz 1
- Crowd 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
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 | |
Avery Sunshine VH1 Big Morning Buzz | This is a live performance of a soulful R&B song with two main instruments being at the core. There is a guitarist playing percussively and the electric piano is being used to play some bright and airy chords. The singer has a soulful and full bodied voice. | 2014-11-04T01:52:27Z | michelle james | Call My Name | ["Acoustic guitar", "Music", "Rhythm and blues", "Buzz"] | ["live performance", "acoustic guitar", "electric piano", "keyboard", "soulful female vocalist", "r&b", "soul"] | 3 | o-ISARPUGlo | 4601 | |
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 |
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;