musiccaps_details (view)
2 rows where musiccaps_aspects contains "sustained strings" and musiccaps_names contains "Speech" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- low quality 2
- sustained strings · 2 ✖
- alarm sound 1
- classical 1
- dramatic 1
- dynamic low percussion roll 1
- electric guitar melody 1
- flat male vocal 1
- funny 1
- intense 1
- metallic impact 1
- mono 1
- noisy 1
- stuttering vocal sound effect 1
- suspenseful 1
- suspenseful brass melody 1
musiccaps_names (array) 4 ✖
- Music 2
- Speech · 2 ✖
- Bell 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thomas & Friends ep 18 A Bad Day for Freddie | The low quality recording features a flat male vocal talking over electric guitar melody and sustained strings, with some metallic impact sound and stuttering vocal sound effect. It sounds funny and the recording is noisy and in mono. | 2008-07-24T18:28:24Z | Daniel Alsop | Here's the 2nd narrow gauge episode this time featrueing Fearless Freddie. | ["Bell", "Music", "Speech"] | ["low quality", "noisy", "mono", "flat male vocal", "stuttering vocal sound effect", "sustained strings", "electric guitar melody", "metallic impact", "funny"] | 4 | q7sK_xrJz-k | 4755 | |
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 |
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;