musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2011-09-06
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- aggressive synth bass 1
- crowd cough 1
- dubstep 1
- electronic drums 1
- energetic 1
- flat male vocal 1
- funny 1
- funny synth lead 1
- groovy hi hats 1
- harmonized mixed vocal 1
- haunting 1
- instrument samples 1
- keys 1
- low quality 1
- male cough 1
- male voice rapping 1
- mellow bells melody 1
- metallic detuned percussion 1
- moderate tempo 1
- parody 1
- punchy kick 1
- punchy snare 1
- rap/reggeaton 1
- sound-effects 1
- sub bass 1
- weird 1
- wide sustained strings melody 1
- wooden percussion hits 1
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- Carnatic music 1
- Dubstep 1
- Electronic music 1
- Hip hop music 1
- Mantra 1
- Music of Africa 1
- Ping 1
- Sonar 1
- Throat clearing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
E Weg'i Ping - BlackJoker ft JeWeet, Remyman, Uncle Jee & Lady Shanti | This song has a typical reggaeton drumbeat that just sounds a little softer and not so much in the foreground. A synthetic bass is supporting the drums with a simple bassline. A processed guitar-like sound is panned to the left side of the speakers. Some gameboy coinlike sound is popping up here and there. A male voice is rapping while getting backing voices from another male voice. This song may be playing at a latin barber shop. | 2011-09-06T21:05:39Z | BlackJoker Music | E Weg'i Ping, BlackJoker, RemyMan, Uncle Jee, Lady Shanti Dancehall, Bubbling, Reggaeton, Rub A Dub. | ["Music of Africa", "Music", "Ping", "Hip hop music"] | ["rap/reggeaton", "electronic drums", "sub bass", "sound-effects", "instrument samples", "keys", "male voice rapping", "moderate tempo"] | 6 | Pln4GLIMqKY | 2563 | |
funny video nivaaran cough syrup ad film | The low quality recording features a parody that contains metallic detuned percussion, funny synth lead, wide sustained string melody in the background, male and crow cough, wooden percussion hits layered with coughs and flat male vocals, alongside harmonized mixed vocals, singing over it. It sounds funny and weird - almost like a TV commercial. | 2011-09-06T16:05:17Z | cinebharathnews | its a funny creative ad | ["Carnatic music", "Mantra", "Music", "Throat clearing"] | ["low quality", "metallic detuned percussion", "funny synth lead", "wide sustained strings melody", "male cough", "crowd cough", "harmonized mixed vocal", "flat male vocal", "wooden percussion hits", "funny", "parody", "weird"] | 4 | Z7V7Curou7s | 3342 | |
Poseidon - Nuclear (HD) | The Dubstep song features a punchy kick and snare hits, groovy hi hats, aggressive synth bass and mellow bells melody played in the beginning. It sounds energetic and haunting. | 2011-09-06T17:01:19Z | paulvannimwegenmusic | Some tune. Soundcloud finally up! Help us out - http://soundcloud.com/ officialposeidondubstep Official Facebook: http://www.facebook.com/pages/PoseidonDubstep/152837891451175 Official Channel: www.youtube.com/poseidondubstep OFFICIAL POSEIDON BASS MUSIC Copyright © Paul van Nimwegen & Daniel Ovens 2011. All rights reserved. | ["Electronic music", "Music", "Sonar", "Dubstep"] | ["dubstep", "punchy kick", "punchy snare", "groovy hi hats", "aggressive synth bass", "mellow bells melody", "haunting", "energetic"] | 4 | tPVsTFGWU5Q | 5034 |
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;