musiccaps_details (view)
3 rows where musiccaps_aspects contains "intense", musiccaps_author = 4 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- intense · 3 ✖
- low quality 3
- suspenseful 3
- aggressive male vocal 1
- alarm sound 1
- classical 1
- dramatic 1
- dynamic low percussion roll 1
- flat female vocal 1
- mellow sustained female vocals 1
- mono 1
- noisy 1
- phone message sound effect 1
- reverberant percussions 1
- reversed crash riser 1
- suspenseful brass melody 1
- suspenseful strings chords 1
- sustained strings 1
- synth pad chords 1
musiccaps_names (array) 4 ✖
- Music 3
- Scary music 3
- Speech · 3 ✖
- Inside, small room 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Little White Lie Episode 8 | The low quality recording features suspenseful strings chords layered with a reversed crash riser, after which there is a flat female vocal talking. It sounds suspenseful and intense. | 2009-07-06T23:11:14Z | Team StarKid | Sami and Duder Reese are in a band. They are brother and sister. And they suck. They steal all their music and try to become famous in this new webseries.Get the Soundtrack here: http://www.amazon.com/gp/product/B002G6B4H4/ref=sr_f2_album_18_rd?ie=UTF8&child=B002G6F7QS&qid=1247062948&sr=102-18 Now available on iTunes: http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewAlbum?id=322514773&s=143441 | ["Music", "Speech", "Scary music", "Inside, small room"] | ["low quality", "suspenseful strings chords", "phone message sound effect", "flat female vocal", "suspenseful", "intense", "reversed crash riser"] | 4 | AJROvxlmo40 | 1101 | |
Functional Aliens M41-A Pulse Rifle (HD) - Redwolf Airsoft - RWTV | The low quality recording features a classical song that consists of a suspenseful brass melody, sustained strings and dynamic low percussion roll, after which there is an alarm sound. It sounds suspenseful, dramatic and intense. | 2010-09-28T04:04:35Z | RedWolf Airsoft | www.RedWolfairsoft.com One of the most exciting weapons from the classic movie series Aliens, this Redwolf Custom gun combines a Tokyo Marui M1A1 with the ASC kit for a complete custom gun and includes a weathered process which makes it look more realistically used. The weapon includes a functioning shot counter (counting down from 95, like the movie), runs on an AK stick type battery and feeds from a Thompson hicap magazine. | ["Music", "Speech", "Scary music"] | ["low quality", "classical", "alarm sound", "suspenseful brass melody", "sustained strings", "dynamic low percussion roll", "suspenseful", "dramatic", "intense"] | 4 | QT1SjY9mQxc | 2621 | |
Brad gets mad then does Math | The low quality recording features an aggressive male vocal talking over synth pad chords, sustained, mellow female vocals and reverberant percussion. It sounds suspenseful and intense. The recording is noisy and in mono. | 2008-12-12T10:47:35Z | 4Player Network | Watch live video and more clips from 4PlayerPodcast on http://www.justin.tv/fourplayerpodcast | ["Music", "Speech", "Scary music"] | ["low quality", "aggressive male vocal", "synth pad chords", "mellow sustained female vocals", "suspenseful", "intense", "noisy", "mono", "reverberant percussions"] | 4 | S9-i_pqoUCw | 2745 |
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;