musiccaps_details (view)
2 rows where search matches "guitar" and musiccaps_names contains "Sonar" sorted by youtube_description descending
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic piano 1
- aggressive 1
- amateur recording 1
- atmospheric sound 1
- autotune 1
- dreamy 1
- e-guitar 1
- electric guitar sample 1
- electronic percussion 1
- heavy effects 1
- high-pitched singing 1
- male vocal 1
- punkrock 1
- r&b 1
- remix 1
- soul 1
- trippy 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Music 2
- Sonar · 2 ✖
- Cymbal 1
- Drum 1
- Drum kit 1
- Heavy metal 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▲ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Decapitated - The Blasphemous Psalm to The Dummy God Creation - Drum Cover | A drum is playing a lot of crash hits with fast and accurate snare rolls along to a backing track that contains an e-guitar playing a riff in a lower key. This song may be playing at a studio practicing. | 2014-08-07T17:49:41Z | Kevin Paradis | I proudly endorsed TRICK DRUMS USA double pedals and trigger. Hi there ! I've opened a soundcloud profile, and you will find on it some Drums Only mp3 files. You will be able to download them ! I just ask you to put a link to my youtube channel/facebook artist page if you use my drums on a video. Hope it will will be useful ! Drums only : https://soundcloud.com/kevinparadisdrummer/decapitated-the-blasphemous-psalm-to-the-dummy-god-drums-only-cover https://www.facebook.com/kevinparadisdrumming | ["Cymbal", "Drum", "Drum kit", "Heavy metal", "Music", "Musical instrument", "Sonar"] | ["punkrock", "acoustic piano", "atmospheric sound", "e-guitar", "uptempo", "aggressive", "amateur recording"] | 6 | w5EbmsPfGSo | 5238 | |
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 |
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;