musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2013-05-12
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- autotune 1
- calm 1
- classic pop 1
- dreamy 1
- electric guitar harmony 1
- electric guitar sample 1
- electronic percussion 1
- emotional 1
- heavy effects 1
- high-pitched singing 1
- insistent rhythm 1
- keyboard harmony 1
- male vocal 1
- male vocalist 1
- medium tempo 1
- pleasant melody 1
- pop 1
- r&b 1
- recurring 1
- remix 1
- sentimental 1
- soul 1
- steady bass lines 1
- steady drumming 1
- trippy 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Rattle 1
- Rock music 1
- Sonar 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 | |
My Love is Sweeter - Hyper Sound | A male vocalist sings this simple melody. The tempo is medium with a pleasant keyboard harmony, slick drumming, steady bass lines and an melodic electric guitar harmony. The song is a simple, insistent rhythm,recurring beat, youthful , emotional, sentimental and passionate classic Pop. | 2013-05-12T12:08:57Z | HypersoundVevo | Rock Music from the african Hollywood "Ouarzazate" https://www.facebook.com/HypersoundBand | ["Music", "Rock music", "Rattle"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "pop", "classic pop", "recurring", "insistent rhythm", "steady drumming", "electric guitar harmony", "steady bass lines", "pleasant melody", "calm", "emotional", "sentimental", "youthful"] | 7 | evscfdO-oSY | 3907 |
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;