musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2011-09-06
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- aggressive synth bass 1
- crowd cough 1
- dubstep 1
- energetic 1
- flat male vocal 1
- funny 1
- funny synth lead 1
- groovy hi hats 1
- harmonized mixed vocal 1
- haunting 1
- low quality 1
- male cough 1
- mellow bells melody 1
- metallic detuned percussion 1
- parody 1
- punchy kick 1
- punchy snare 1
- weird 1
- wide sustained strings melody 1
- wooden percussion hits 1
musiccaps_names (array) 7 ✖
- Music 2
- Carnatic music 1
- Dubstep 1
- Electronic music 1
- Mantra 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 |
---|---|---|---|---|---|---|---|---|---|---|
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;