musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "dreamy" and musiccaps_aspects contains "male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- dreamy · 2 ✖
- male vocal · 2 ✖
- acoustic jazz drums 1
- autotune 1
- cheerful 1
- complex 1
- electric guitar sample 1
- electronic percussion 1
- gibberish singing 1
- heavy effects 1
- high-pitched singing 1
- jazz 1
- piano 1
- r&b 1
- remix 1
- soul 1
- trippy 1
- upright bass 1
- vibraphone 1
- video game theme 1
musiccaps_names (array) 4 ✖
- Music 2
- Roll 1
- Sonar 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Weeknd - Loft Music - Crew Love Mixtape | This is a remix of an R&B music piece. An auto-tuned male vocal is singing melodically in a minor scale at a high pitch. A fading electric guitar sample can be heard in the distance. Repeated hits of low-frequency percussion add a deepening effect to the piece. The atmosphere is very dreamy and very trippy. This piece could be used in a dream sequence at a movie or a TV show. | 2013-05-12T13:39:15Z | Faonxy8532 | Click here to start download : http://is.gd/H3ajve 01. Drake Ft. Aaliyah -- Enough Said 02. Drake Ft. The Weeknd -- Trust Issues 03. Drake Ft. Riz -- Waiting up 04. The Weeknd -- Loft Music 05. Drake -- Dreams money cant buy 06. The Weeknd Ft. Drake -- The Zone 07. Feddi Twinz Ft. Young Zoe -- Loud 08. The Weeknd -- The Party & The After Party 09. The Weeknd -- Same Old Song 10. Feddi Twinz Ft. Esty -- Im Good The Weeknd - Loft Music The Weeknd - Loft Music The Weeknd - Loft Music The Weeknd - Loft Music The Weeknd Loft Music Crew Love Drake, The Weeknd, Enough Said, The Zone, Dreams money cant buy, Mixtape, Hip Hop, R&B, Music, YouTube , song, new, 2013 | ["Music", "Sonar"] | ["r&b", "soul", "remix", "male vocal", "high-pitched singing", "autotune", "electric guitar sample", "electronic percussion", "heavy effects", "dreamy", "trippy"] | 9 | MipnqUXgpOA | 2291 | |
Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 |
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;