musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "synth pad chords"
This data as json, CSV (advanced)
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 |
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;