musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur piano playing", musiccaps_aspects contains "cartoon violence" and musiccaps_names contains "Inside, large room or hall"
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 |
---|---|---|---|---|---|---|---|---|---|---|
[SFM FNAF] #Mangle & Foxy Plushie | The song is an instrumental piece. The song is medium tempo with a casual piano accompaniment which is cheerful and jittery in style, along with violent sounds of a crash, crushing tones, metal clanging and rubber twisting sounds. The song is cheerful and at the same time has violent tones of injury and accident superimposed in it. The song is a background effect for an animated show which is violent in nature. | 2016-03-26T23:32:20Z | FiveNight | ►Happy Easter :) ►Facebook: https://www.facebook.com/SFMFiveNight ►NCS the best music channel: https://www.youtube.com/user/NoCopyrightSounds | ["Music", "Breaking", "Inside, large room or hall"] | ["piano accompaniment", "crashing sounds", "animated show music", "violent tv show", "tv show tune", "jittery piano playing", "amateur piano player", "western classical music", "metal clanging tones", "crunching sounds", "injury", "hurt", "violence", "carefree music", "movie soundtrack", "cartoon violence", "emotional", "cheerful piano play", "medium tempo", "amateur piano playing", "violent background music", "mangled noises"] | 1 | Lq0LMMZfHCU | 2224 |
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;