musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "tambourine percussions" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- emotional 3
- tambourine percussions · 3 ✖
- romantic 2
- average audio quality 1
- backup singers 1
- bad audio quality 1
- bass guitar solo 1
- big band 1
- booming bass line 1
- chaotic harmony 1
- classic pop hits 1
- classic pop song 1
- cymbals crashing 1
- distorted guitar rhythm 1
- dreamscapes 1
- electric guitar tremolo tones 1
- fast tempo 1
- female singer 1
- groovy 1
- groovy rhythm 1
- grunge keyboard tones 1
- guitar lead 1
- guitar playing lead 1
- high in adrenaline 1
- inspiring 1
- love song 1
- make singer 1
- male singer 1
- medium tempo 1
- melancholic 1
- missing you 1
- noir style 1
- passionate 1
- percussion hits 1
- percussions 1
- piano accompaniment 1
- poor audio quality 1
- pop song 1
- retro pop hits 1
- retro rock hits 1
- rhythm guitar 1
- rock band 1
- sadness 1
- slow tempo 1
- spirited 1
- steady drumming rhythm 1
- story telling 1
- strong bass guitar 1
- strong rock drumming 1
- together forever 1
- traditional percussion rhythm 1
- trudging drum rhythm 1
- vocal harmony 1
musiccaps_names (array) 11 ✖
- Singing · 3 ✖
- Music 2
- Blues 1
- Grunge 1
- Heavy metal 1
- Humming 1
- Independent music 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 | ||
The Scissors - You Can Make It Dangerous - Out 3.20.10 | A male singer sings this rock melody with backup singers in vocal harmony. The song is fast tempo with a strong drumming rhythm , percussive bass line, amplified guitar playing lead. The song is energetic and romantic. The song is a retro rock song with average audio quality. | 2010-01-21T00:22:10Z | TheScissors | http://www.thescissors.com - http://facebook.com/thescissors Scissors - You Can Make It Dangerous - Out 3.20.10 | ["Singing", "Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock", "Grunge"] | ["make singer", "fast tempo", "rock band", "backup singers", "vocal harmony", "strong rock drumming", "distorted guitar rhythm", "guitar playing lead", "tambourine percussions", "cymbals crashing", "emotional", "romantic", "groovy rhythm", "high in adrenaline", "passionate", "spirited", "retro rock hits", "average audio quality"] | 1 | Ztlcnd14Kn4 | 3426 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 |
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;