musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "techno music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- instrumental music · 2 ✖
- techno music · 2 ✖
- ad jingle 1
- advertisement soundtrack 1
- animated 1
- beep tones 1
- building tension 1
- creating awareness 1
- crescendo sounds 1
- different sound tracks 1
- drum banging loud 1
- electronic music 1
- energetic 1
- enthusiastic 1
- excited 1
- futuristic 1
- hard rock 1
- informative 1
- intense 1
- intense drumming 1
- keyboard beeps 1
- last tempo heavy metal 1
- male voice speaking 1
- medium tempo 1
- poor audio quality 1
- retro ad spots 1
- review 1
- song ending 1
- spirited 1
- timpani 1
- video game music 1
- vigorous 1
musiccaps_names (array) 4 ✖
- Music 2
- Ambient music 1
- Angry music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Top 10 Robots | This music is an electronic instrumental. The tempo is fast with heavily synthesised arrangements and intense drumming with a male voice speaking over the music. The music is intense, vigorous,animated, futuristic and vital. It sounds like video game music and the male voice seems to be reviewing Video Games. | 2015-05-16T05:12:56Z | GameTrailers | Sometimes, when you need a friend, you have to build one. We assemble all the greatest creations in video games and determine who is the most loyal and effective. | ["Music", "Speech", "Angry music"] | ["instrumental music", "vigorous", "animated", "spirited", "enthusiastic", "intense drumming", "last tempo heavy metal", "hard rock", "electronic music", "video game music", "male voice speaking", "intense", "electronic music", "techno music", "futuristic", "review", "informative"] | 7 | Xn0wIqnt_44 | 3223 | |
Chris Brown-damage | The song is an instrumental. The tempo is variable, with a timpani crash, various beeping tones and a crescendo grungy keyboard harmony tone. The song is a soundtrack for an advertisement. The audio quality is very poor. | 2007-12-26T09:31:57Z | puddin713 | This song is a very good songand makes me cry everytime! | ["Music", "Ambient music"] | ["song ending", "keyboard beeps", "drum banging loud", "ad jingle", "techno music", "building tension", "excited", "energetic", "creating awareness", "retro ad spots", "advertisement soundtrack", "timpani", "beep tones", "crescendo sounds", "instrumental music", "medium tempo", "poor audio quality", "different sound tracks"] | 1 | DEnayQZiPGc | 1455 |
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;