musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "synth pad chords"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass · 3 ✖
- punchy kick · 3 ✖
- synth pad chords · 3 ✖
- low quality 2
- punchy snare 2
- addictive 1
- dissonant brass stabs 1
- electro 1
- energetic 1
- funky electric guitar melody 1
- groovy 1
- latin urban 1
- liquid 1
- passionate 1
- passionate female vocal 1
- passionate male vocal 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft shakers 1
- stuttering hi hats 1
- synth keys melody 1
- wide harmonizing vocals 1
- wide intimate percussive elements 1
- wooden snare hits 1
musiccaps_names (array) 7 ✖
- Music 3
- Electronic music 1
- Folk music 1
- Opera 1
- Rhythm and blues 1
- Squish 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Upgrade Music vs. Jeon - Ataniro & Ritmo - Amor Cruel | The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. | 2014-05-19T23:20:11Z | Javier' Abreu | Upgrade Music Aruba - Amor Cruel | ["Folk music", "Music", "Rhythm and blues"] | ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] | 4 | 8OsmFmhNjoA | 920 | |
Fifth Element - Techno opera | The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. | 2010-05-17T19:22:17Z | 1kRaFt (KRAFTWIN) | Fifth Element - Techno opera. Original: Performed by Inva Mula. Composed and Produced by Eric Serra. More: http://www.imdb.com/title/tt0119116/soundtrack | ["Electronic music", "Music", "Opera", "Techno"] | ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] | 4 | WE0JqjuhaQI | 3076 | |
Kalya Scintilla - Liquid | The Electro song features a widely spread intimate percussive elements, stuttering hi hats, soft shakers, synth pad chords, groovy bass and punchy snare and kick hits. It sounds relaxing, calming and kind of satisfying, as it literally sounds like liquid dripping through the stereo image. | 2010-12-31T05:52:43Z | Matt Haney | Upload mp3s @ http://www.mp32tube.com | ["Music", "Squish"] | ["electro", "wide intimate percussive elements", "stuttering hi hats", "soft shakers", "synth pad chords", "groovy bass", "punchy kick", "punchy snare", "liquid"] | 4 | fYk2U9yJvps | 3958 |
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;