musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and "youtube_published" is on date 2012-12-27
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- energetic · 2 ✖
- arpeggios 1
- boomy kick 1
- digital drums 1
- dubstep 1
- echoing energetic male vocal 1
- energetic crash cymbals 1
- exciting 1
- groovy bass guitar 1
- live performance 1
- low quality 1
- medium tempo 1
- punchy snare 1
- rock 1
- synth bass sound 1
- voice sample 1
- wide electric guitar chord progression 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
Vinyl Scratch - Think Again Loosa | This song contains digital, dubstep drums with a straight hi hat playing 8th notes. An aggressive bass sound full of modulation and other samples is playing a melody with a lot of pitch shifts and stutter effects. A voice sample is being used with a lot of reverb and delay as an atmospheric element. Some sounds are being arpeggiated playing a fast melody before leaving the scenario again. This song may be playing in an extreme sports advertisement. | 2012-12-27T23:30:08Z | YourDailyMusicz | ✖ Connect with the Artist YouTube: http://www.youtube.com/user/VinylScratchDjPony Facebook: http://www.facebook.com/VinylScratchOfficial Twitter: https://twitter.com/vinyl_scratchdj ✖ Connect with YDL Network Apply for Partnership & Directorship [No View Minimum] [Music only]: http://bit.ly/OYUZWp Apply for standard Partnership: http://www.yourdailylaughz.tv/apply * Notice: YDM Channel is Not a 'non-copyright' channel. Uploading such materiel from YDM or the Artist themselves will result in infringement upon the third party. --- | ["Scratching (performance technique)", "Drum and bass", "Music"] | ["dubstep", "digital drums", "synth bass sound", "voice sample", "arpeggios", "medium tempo", "energetic"] | 6 | dsf3agfkJDY | 3823 |
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;