musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic drums", musiccaps_aspects contains "harmonizing female vocals" and musiccaps_aspects contains "skateboarding sound effects"
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 |
---|---|---|---|---|---|---|---|---|---|---|
micro ramp skateboard session | The low quality recording features an Alternative/Indie song playing in the background while there are some skateboarding sound effects and foley in front. It is obviously a skateboarding compilation video. The song consists of groovy bass, energetic drums, wide synth key chords and wide synth pad chords, while the harmonizing female vocals are singing on top of it. It sounds fun and happy. | 2007-05-20T16:16:22Z | Øyvind Nilsen | Micro ramp session in Trikkestallen, Trondheim 19.05.2007 | ["Music", "Skateboard"] | ["alternative/indie", "low quality", "skateboarding sound effects", "harmonizing female vocals", "energetic drums", "groovy bass", "wide synth keys chords", "wide synth pad chords", "fun", "happy"] | 4 | y_lfY0uzmr0 | 5421 |
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;