musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- groovy bass guitar 3
- passionate male vocal · 3 ✖
- punchy snare · 3 ✖
- shimmering hi hats 3
- energetic 2
- exciting 2
- live performance 2
- low quality 2
- punchy kick 2
- rock 2
- acoustic rhythm guitar 1
- addictive 1
- country 1
- crowd clapping 1
- electric guitar melodies 1
- joyful 1
- simple kick 1
- steel guitar repetitive guitar 1
- wide electric guitar melody 1
musiccaps_names (array) 9 ✖
- Singing · 3 ✖
- Music 2
- Blues 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Psychedelic rock 1
- Rock and roll 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
Foreigner, Feels like the first time with lyrics | The Rock song features a passionate male vocal singing over punchy kick and snare hits, shimmering hi hats, groovy bass guitar and electric guitar melodies. It sounds energetic and exciting. | 2010-03-11T05:56:00Z | JohnysMusicChannel | song: feels like the first time artist: foreigner lyrics: I would climb any mountain Sail across a stormy sea If that's what it takes me baby To show you how much you mean to me And I guess it's just the woman in you That brings out the man in me I know I can't help myself You're all in the world to me It feels like the first time Feels like the very first time It feels like the first time It feels like the very first time I have waited a lifetime Spent my time so foolishly But now that I've found you Together we'll make history And I know that it must be the woman in you That brings out the man in me I know I can't help myself You're all that my eyes can see And it feels like the first time Like it never did before Feels like the first time Like we've opened up the door Feels like the first time Like it never will again, never again Feels like the first time, it feels like the first time It feels like the very first time, very, very, it feels It feels like the first time, oh it feels like the first time It feels like the very first time Open up the door, won't you open up the door? yeah Feels like the first time And it feels like the very first time And it feels like the first time It feels like the very first time And it feels like the first time It feels like the very first time Oh it feels, it feels like the first time Yeah it feels like the first time | ["Singing", "Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | ["rock", "passionate male vocal", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass guitar", "electric guitar melodies", "energetic", "exciting"] | 4 | PfO7ZVdzfZ4 | 2556 |
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;