musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "instrumental" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- addictive · 3 ✖
- instrumental · 3 ✖
- shimmering hi hats 3
- energetic 2
- low quality 2
- punchy snare 2
- rock 2
- acoustic rhythm guitar 1
- addictive synth lead melody 1
- electric guitar chord progression 1
- electric guitar mellow feedback 1
- exciting 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- groovy piano melody 1
- groovy synth bass 1
- noisy snare hit 1
- passionate 1
- passionate electric guitar solo melody 1
- pop 1
- punchy "4 on the floor" kick pattern 1
- punchy kick 1
- riser 1
- tinny high pitched snaps 1
- wooden bouncy percussion 1
musiccaps_names (array) 5 ✖
- Music 3
- Electronic music 1
- Exciting music 1
- Grunge 1
- House music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Silversun Pickups - Kissing Families [Official Music Video] | The low quality recording features a rock song instrumental that consists of shimmering hi hats, punchy snare, groovy bass guitar, acoustic rhythm guitar in the left channel and electric guitar chord progression in the right channel of the stereo image. It sounds energetic and addictive. | 2009-03-20T17:08:17Z | Silversun Pickups | Directed by Suzie Vlcek Get PIKUL here: http://smarturl.it/sspupikulEP http://silversunpickups.com http://twitter.com/sspu http://instagram.com/sspu http://facebook.com/silversunpickups | ["Music", "Exciting music"] | ["low quality", "rock", "instrumental", "shimmering hi hats", "punchy snare", "groovy bass", "acoustic rhythm guitar", "electric guitar chord progression", "energetic", "addictive"] | 4 | -XN0NtrnfMY | 58 | |
Mais häckseln / Corn chopping | #landwirt100k | The Rock instrumental features a passionate electric guitar solo melody played over punchy kick and snare hits, shimmering hi hats, groovy bass guitar, wooden bouncy percussion and electric guitar, mellow feedback, located in the left channel of the stereo image. It sounds groovy, addictive and passionate, thanks to that solo melody. | 2015-10-06T20:27:24Z | Franz Gosch | Fendt 310 Vario Fendt 716 Vario TMS + Kemper Champion 3000 Fendt 309 Vario TMS Steyr 768A Valtra N103.4 H5 | ["Music", "Grunge"] | ["rock", "instrumental", "groovy bass guitar", "passionate electric guitar solo melody", "punchy kick", "punchy snare", "wooden bouncy percussion", "shimmering hi hats", "electric guitar mellow feedback", "groovy", "addictive", "passionate"] | 4 | I4Jp0kB2Ns0 | 1870 | |
I´m an albatraoz- Subtitulada Español | The low quality recording features an instrumental of a pop song that consists of an addictive synth lead melody, punchy "4 on the floor" kick pattern, shimmering hi hats, riser and groovy bass in the first half of the loop. In the second half of the loop there is a tinny, high pitched snaps and groovy piano melody playing. It sounds energetic, exciting and addictive. | 2015-03-15T21:04:41Z | Angel Valencia | La pista original fue removida por motivos derechos de autor, este remix se encuentra en este video https://www.youtube.com/watch?v=sKop9_eD5MU | ["Electronic music", "House music", "Music"] | ["low quality", "pop", "instrumental", "addictive synth lead melody", "groovy piano melody", "shimmering hi hats", "riser", "noisy snare hit", "groovy synth bass", "punchy \"4 on the floor\" kick pattern", "tinny high pitched snaps", "energetic", "addictive", "exciting"] | 4 | xxRnOYSjF64 | 5369 |
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;