musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_names contains "Inside, large room or hall" and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
[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 | |
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 |
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;