musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic crash cymbals", musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "simple hi hats" and musiccaps_names contains "Angry music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Nightwish Amaranth lyrics | The Metal song features wide aggressive distorted electric guitars, punchy kick and snare hits, energetic crash cymbals, simple hi hats, groovy bass guitar, sustained synth pad melody and passionate female vocals singing over it. It sounds energetic, powerful, manic and aggressive - especially in the first part of the loop where there is a drum break. | 2010-09-11T09:47:05Z | Ruben Tomas | This is my second video, its a bit slow at the begginning but i hope you enjoy XD | ["Music", "Angry music"] | ["low quality", "metal", "wide aggressive distorted electric guitars", "punchy kick", "punchy snare", "energetic crash cymbals", "simple hi hats", "passionate female vocal", "crushed", "groovy bass guitar", "sustained synth pad melody", "energetic", "powerful", "manic", "aggressive"] | 4 | dSs4xfvATjc | 3787 |
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;