musiccaps_details (view)
2 rows where musiccaps_aspects contains "scary" and musiccaps_aspects contains "video game soundtrack"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- scary · 2 ✖
- video game soundtrack · 2 ✖
- ambient street noises 1
- arcade game 1
- building anticipation 1
- building tension 1
- bull fight 1
- bull goring a man 1
- cello playing 1
- dangerous 1
- death metal music 1
- eerie 1
- energetic 1
- exciting 1
- fast drumming rhythm 1
- fast metal drumming 1
- galloping sound 1
- game soundtrack 1
- gameplay 1
- groovy bass line 1
- horn sounds 1
- inspiring 1
- instrumental music 1
- instrumental sjic 1
- keyboard harmony 1
- male singer 1
- man screaming in pain 1
- medium fast tempo 1
- mysterious string synth tones 1
- passionate 1
- poor audio quality 1
- steady drumming rhythm 1
- story telling 1
- tense harmony 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Outside, urban or manmade 1
- Speech 1
- Thunk 1
youtube_published (date) 2 ✖
- 2014-04-19 1
- 2015-06-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ArcheAge - Archer 50 lvl pvp, DollVasta (19.04.14) | A male singer sings these whispering vocals. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is tense and full of suspense. The song is a game soundtrack. | 2014-04-19T14:38:05Z | b1shock | DollVasta(BIOSHOCK,BIOPWNZ) | ["Music", "Speech", "Angry music"] | ["death metal music", "male singer", "game soundtrack", "building anticipation", "fast drumming rhythm", "medium fast tempo", "video game soundtrack", "passionate", "energetic", "scary", "eerie", "fast metal drumming", "groovy bass line", "story telling", "inspiring", "keyboard harmony"] | 1 | LLDHkHHKYkI | 2179 | |
Angry Bull Revenge 3D - Android Gameplay HD | The song is an instrumental soundtrack for a video game. The song tempo is medium with a string section,aging, cello playing a tense lower harmony, steady drumming rhythm, and ambient sounds like a bull galloping, man screaming and hood steps. The music is a soundtrack for a video game and has poor audio quality. | 2015-06-09T02:15:19Z | AndroidGameplayNet | FOR MORE ANDROID GAMES -http://www.youtube.com/user/androidgameplaynet?sub_confirmation=1 Step into the shoes of a furious bull and smash down the whole town! The wild bull is looking for fun. Combine your aggression with bull's muscular form! It’s a recipe for disaster. Play as an angry bull and make the whole town run for its life! Release your inner beast and cause ultimate destruction in the most modern city in the world! Features of Bull Revenge 3D: - Thrilling hunting challenges - Realistic suburban city environment - Multiple bulls to choose from - Radar to locate preys - High quality 3D graphics with realistic props - Easy controls ------------------------------------------------------------------------------------------------ Download link - https://play.google.com/store/apps/details?id=com.tapinator.angry.bull.revenge | ["Music", "Thunk", "Outside, urban or manmade"] | ["video game soundtrack", "galloping sound", "arcade game", "poor audio quality", "instrumental music", "gameplay", "bull goring a man", "man screaming in pain", "tense harmony", "cello playing", "steady drumming rhythm", "mysterious string synth tones", "exciting", "scary", "instrumental sjic", "poor audio quality", "ambient street noises", "bull fight", "horn sounds", "dangerous", "building tension"] | 1 | ZhafwFYgltI | 3404 |
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;