musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "soft kick hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- emotional 2
- low quality 2
- passionate male vocal · 2 ✖
- punchy snare · 2 ✖
- soft kick hits · 2 ✖
- acoustic rhythm guitar 1
- electric guitar melody 1
- groovy bass 1
- groovy piano melody 1
- harmonizing female vocal 1
- harmonizing male vocals 1
- hopeful 1
- joyful 1
- live performance 1
- mono 1
- noisy 1
- playback instrumental 1
- shimmering hi hats 1
- shimmering tambourine 1
- simple bass guitar 1
- soul 1
- soulful 1
- toms roll 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00003 1
- Independent music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chester See - That girl [lyrics] | The low quality recording features a passionate male vocal, alongside harmonizing female vocals, singing over simple bass guitar, punchy snare, soft kick hits, acoustic rhythm guitar, groovy piano melody and shimmering hi-hats. It sounds emotional. | 2010-03-10T17:37:51Z | jerrestorms | Oh tonight I'm feeling fine I'm alone just wasting time No friday movie nights, or romantic candlelight I'm just having conversations With the thoughts in my head All I hear are angels crying Oh won't they just sing instead It would be wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life Honestly, this won't do How is she doing? I tell myself that I'm feeling swell But I know I'm such a fool I can take it as a new beginning But you know I don't feel that way Who will take all this pain away? I know it's wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life... Talk about a sin Was the day I walked Into the other side I would run back in I wouldn't waste no time I know it's wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life | ["Music", "Independent music"] | ["low quality", "groovy piano melody", "acoustic rhythm guitar", "passionate male vocal", "simple bass guitar", "punchy snare", "soft kick hits", "shimmering hi hats", "emotional", "harmonizing female vocal"] | 4 | J8lCxfaiHeo | 1972 | |
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;