musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "harmonizing male vocals" and musiccaps_aspects contains "soft kick hits" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- electric guitar melody 2
- groovy bass 2
- harmonizing male vocals · 2 ✖
- low quality 2
- punchy snare 2
- soft kick hits · 2 ✖
- addictive 1
- emotional 1
- groovy 1
- groovy piano melody 1
- hopeful 1
- joyful 1
- live performance 1
- mono 1
- noisy 1
- passionate male vocal 1
- playback instrumental 1
- rock 1
- shimmering hi hats 1
- shimmering tambourine 1
- snare roll 1
- soul 1
- soulful 1
- toms roll 1
musiccaps_names (array) 4 ✖
- /t/dd00003 1
- Country 1
- Music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Kansas - Point of Know Return (Official Video) | The low quality recording features a rock song that consists of harmonizing male vocals singing over groovy piano melody, groovy bass guitar, electric guitar melody, punchy snare, soft kick hits and shimmering hi-hats. There is a short snare roll that serves as a transition into a new section. It sounds groovy and addictive. | 2013-01-17T11:25:12Z | kansasVEVO | Official music video for “Point of Know Return” by Kansas Listen to Kansas: https://Kansas.lnk.to/listenYD Watch more videos by Kansas: https://Kansas.lnk.to/listenYD/youtube Subscribe to the official Kansas YouTube channel: https://Kansas.lnk.to/subscribeYD Follow Kansas Facebook: https://Kansas.lnk.to/followYD/facebook Instagram: https://Kansas.lnk.to/followYD/instagram Twitter: https://Kansas.lnk.to/followYD/twitter Website: https://Kansas.lnk.to/followYD/websitegeneral Spotify: https://Kansas.lnk.to/followYD/spotify Lyrics: Your father, he said he needs you Your mother, she says she loves you Your brothers, they echo your words: "How far to the point of know return?" "Well, how long?" #Kansas #PointofKnowReturn #Rock | ["Singing", "Country"] | ["low quality", "rock", "harmonizing male vocals", "groovy piano melody", "groovy bass", "electric guitar melody", "punchy snare", "snare roll", "soft kick hits", "shimmering hi hats", "groovy", "addictive"] | 4 | iFWtsT5zRKo | 4174 |
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;