musiccaps_details (view)
1 row where musiccaps_aspects contains "exciting", musiccaps_aspects contains "horn sounds" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;