musiccaps_details (view)
2 rows where musiccaps_aspects contains "banjo" and musiccaps_aspects contains "electronic drums"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- banjo · 2 ✖
- electronic drums · 2 ✖
- background-noises 1
- changing songs 1
- comedic sound effects 1
- duet 1
- electric guitar 1
- emotional 1
- female vocal 1
- female voice 1
- male vocal 1
- pop music 1
- pop/country 1
- slightly melodic 1
- uptempo 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2014-04-14 1
- 2015-04-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Autumn Hill - Blame (Official Music Video) | This is a pop music piece. The words are being sung by two vocals: one male and one female which lead to a duet for the chorus. There is a banjo and an electric guitar playing the melody while a simple electronic drum beat provides the rhythmic background for the song. It is a slightly melodic and emotional song. This piece could be used in the soundtrack of a romantic drama during a flashback scene. | 2015-04-06T16:23:55Z | Autumn Hill | Autumn Hill performing their new single "Blame". Get the track on iTunes here! http://goo.gl/Jy3j1G Follow Autumn Hill: https://www.facebook.com/AutumnHillMusic https://twitter.com/autumnhillmusic http://autumnhillmusic.com ©2015 Wax Records | ["Music", "Happy music"] | ["pop music", "male vocal", "female vocal", "duet", "banjo", "electric guitar", "electronic drums", "slightly melodic", "emotional"] | 9 | 2U8Dvh7nwFI | 369 | |
Uncle Grandpa - Funny Face (Preview) Clip 1 | This piece of audio contains a modern pop song with drums, effects panned to left and right, a female voice singing with delay before changing into a totally different song that sounds more like a fast paced country song with a synthesizer- melody; acoustic drums and a banjo playing a fast melody along. This recording is also full of voice samples, a tiger or lion roaring, a telephone ringing. According to all these sounds and fast paced changes, it can be assumed that this recording is best played at a comedic television show for kids. | 2014-04-14T04:21:14Z | Cartoon Network Asia | When Uncle Grandpa accidentally unleashes a floating Funny Face that's so funny you laugh yourself to insanity, the guys realize that only Gus' seriousness can save them, but will he help them after they've hurt his feelings? Watch more of Uncle Grandpa on Cartoon Network! Watch more Uncle Grandpa videos: http://www.cartoonnetworkasia.com/video/uncle-grandpa Check out our Cartoon Network Facebook pages: http://www.facebook.com/asia.cartoonnetwork http://www.facebook.com/CartoonNetworkPhilippines | ["Music", "Telephone bell ringing", "Roaring cats (lions, tigers)", "Inside, large room or hall"] | ["pop/country", "changing songs", "electronic drums", "banjo", "female voice", "comedic sound effects", "background-noises", "uptempo"] | 6 | e57SBRbMXbI | 3842 |
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;