musiccaps_details (view)
3 rows where musiccaps_aspects contains "suspenseful" and musiccaps_names contains "Inside, small room" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- suspenseful · 3 ✖
- instrumental 2
- intense 2
- amateur recording 1
- angry voice 1
- child’s voice 1
- classical music 1
- collapsing 1
- dangerous 1
- electronic music 1
- falling 1
- flat female vocal 1
- foreign language 1
- german 1
- low quality 1
- medium tempo 1
- melancholic 1
- movie music 1
- phone message sound effect 1
- reversed crash riser 1
- sinister 1
- slightly poor quality 1
- suspenseful strings chords 1
- synthesiser arrangements 1
- video game music 1
- violin 1
- xbox 1
musiccaps_names (array) 8 ✖
- Inside, small room · 3 ✖
- Music 3
- Scary music 2
- Speech 2
- Bowed string instrument 1
- Classical music 1
- Musical instrument 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Red Violin Caprices, Theme, Written for Joshua Bell | This is a classical music piece. It is an instrumental piece. There is a violin playing a melancholic tune. The atmosphere is suspenseful. The quality of the recording is slightly poor. This piece could suit well during a mysterious sequence in a thriller movie. | 2008-03-31T16:01:05Z | eboyinc | Sound Sample of fine Italian Violin. Piece is an excerpt from "The Red Violin Caprices" - Theme, written John Corigliano. Joshua Bell performed this for the soundtrack of the movie, "The Red Violin" which starred Samuel L. Jackson. | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "Inside, small room"] | ["classical music", "amateur recording", "instrumental", "violin", "melancholic", "suspenseful", "movie music", "slightly poor quality"] | 9 | WCiS9IDILQg | 3073 | |
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 | |
Angry German Kid Halo 3 | This music is an electronic instrumental. The tempo is medium with an intense electronic boom and sound of something collapsing or tumbling. The clip starts with the angry voice of a child talking in a foreign language. | 2006-12-13T06:58:03Z | hitlerhimmler88 | The angry german kid wants to find out more about Halo 3, Without success, and since people keep commenting i should point out that hes not really looking for Halo 3, He's trying to play unreal tournament, so STOP TELLING ME THAT. I KNOW, AS DOES THE REST OF THE WORLD!!! Ok well i guess i have to also post that the halo 3 trailer vid and the geiko vid are both fake as well. Anyone with half a brain would know this. So if you post a smartass comment about it being fake your comment will be removed and you will be blocked. | ["Music", "Speech", "Scary music", "Inside, small room"] | ["instrumental", "medium tempo", "child’s voice", "german", "collapsing", "falling", "intense", "dangerous", "suspenseful", "xbox", "video game music", "foreign language", "electronic music", "sinister", "intense", "dangerous", "synthesiser arrangements", "angry voice"] | 7 | iaRDUksPv50 | 4204 |
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;