musiccaps_details (view)
4 rows where musiccaps_aspects contains "male voice singing", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- male voice singing · 4 ✖
- uptempo · 4 ✖
- acoustic drums 3
- e-bass 3
- e-guitar 3
- rock 2
- acoustic/digital drums 1
- amateur recording 1
- background-noises/voices 1
- bass 1
- e-guitars 1
- female backing voice 1
- hands clapping 1
- higher register 1
- motor racing sound 1
- piano 1
- pop/rock 1
- rock&roll/blues 1
musiccaps_names (array) 11 ✖
- Music 4
- Rock music · 4 ✖
- Christian music 1
- Duck 1
- Exciting music 1
- Progressive rock 1
- Punk rock 1
- Quack 1
- Rock and roll 1
- Ska 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
THE SIMS 4 BLUES OFFICIAL SOUNDTRACK - ALL BLUES MUSIC + DOWNLOAD LINK | This song contains acoustic drums holding a steady groove with a complex fill in at the end of the phrase. An e-bass and e-guitar are playing the same notes, just the e-guitar is strumming a chord. The male voice is singing loud and in a higher register. This song may be playing in a garage workshop. | 2015-02-03T00:36:16Z | MrZillaBR | DOWNLOAD MUSIC: https://onedrive.live.com/redir?resid=1DDADEE1D681434%21110 List: Nooboo Neeb - Amber Revival 00:07 Cell Hafta no Hast - Ben Ward 04:42 Gee Manray - Blind Snorty Warhouse 07:18 High Headed Woman - Captive 10:48 That Evil - Cys Matters 14:12 I'm Gone - Luther LeCriox 17:54 Main Theme: https://www.youtube.com/watch?v=wlxOygk8Beo&feature=youtu.be Electronic: https://www.youtube.com/watch?v=gbMaV6eJxe4&feature=youtu.be Pop: https://www.youtube.com/watch?v=KyURzKwzkiY&feature=youtu.be Romance: https://www.youtube.com/watch?v=mAY8QQKDTYI&feature=youtu.be Alternative: https://www.youtube.com/watch?v=niAvySwjk3g&feature=youtu.be Blues: https://www.youtube.com/watch?v=C7WAx3n57Hk&feature=youtu.be Classic: Spooky: | ["Swing music", "Music", "Rock music", "Ska", "Rock and roll"] | ["rock&roll/blues", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "higher register", "uptempo"] | 6 | C7WAx3n57Hk | 1334 | |
vroom vroom i värmlandsskogen | This song contains acoustic drums holding the rhythm together with a bass and almost clean e-guitar strumming chords. A piano is adding single notes on top while a male voice is singing a melody getting backed up by a female voice singing along. In the background motor race sounds can be heard. This song may be playing in a car with windows open on a road trip. | 2013-01-14T20:08:43Z | robert bengtsson | ["Christian music", "Music", "Rock music"] | ["pop/rock", "e-bass", "piano", "e-guitar", "acoustic drums", "motor racing sound", "male voice singing", "female backing voice", "uptempo"] | 6 | WyGJdstaxK4 | 3153 | ||
Friends - Dragon Sound from Miami Connection - Live Music at Fantastic Fest 2012 | This song contains a digital/acoustic drum holding a simple groove with an e-bass while two distorted e-guitars are playing a melody with one being the lead. A male voice is singing in a higher register while you can hear hand clapping to the rhythm. This is an amateur recording and in poor audio-quality. This song may be playing at a live concert. | 2012-09-25T22:59:59Z | Angus Swantee | Dragon Sound, from the movie "Miami Connection" blew the roof off at the Highball bar during Fantastic Fest 2012. Enjoy getting your mind blown! Friends forever! Band members: Y.K. Kim as Mark - rhythm guitarist of Dragon Sound Joseph Diamond as Jack - drummer of Dragon Sound Maurice Smith as Jim - keyboardist of Dragon Sound Angelo Janotti as Tom - lead guitarist/vocalist of Dragon Sound Vincent Hirsch as John - bass guitarist of Dragon Sound | ["Music", "Rock music", "Progressive rock", "Exciting music"] | ["rock", "amateur recording", "e-guitars", "e-bass", "acoustic/digital drums", "hands clapping", "male voice singing", "uptempo"] | 6 | XjrVSk0_4vc | 3218 | |
Quack Pack Episode 34 | This song contains an acoustic drum set playing a fast groove along with a bassline. A e-guitar is playing a distorted solo melody while a male voice gets backed by harmony singers before singing on alone to duck-like sounds. In the background you can hear a lot of duck-like sounds and a hammering that does not belong to the musical composition. This song may be playing as an intro for a kids TV-show. | 2014-11-13T16:59:41Z | Attims Waters | Quack Pack Full Seasons and Episodes Channel: http://www.youtube.com/channel/UCTfoL922xlPmFoSdPwg8MwA Quack Pack Seasons and Episodes Quack Pack Seasons and Episodes Quack Pack Seasons and Episodes Quack Pack Full Episodes Quack Pack Full Episodes Quack Pack Full Episodes Quack Pack Full Episodes Fallow Quack Pack Full Episodes Fallow Quack Pack Full Episodes Fallow Quack Pack Full Seasons Quack Pack Full Seasons Quack Pack Full Seasons Quack Pack watch Quack Pack watch Quack Pack watch Full cartoon episodes Full cartoon episodes Full cartoon episodes Cartoon Fallow Cartoon Fallow Cartoon Fallow Cartoon watch Cartoon watch Cartoon watch watch, watch, watch, watch, cartoon, cartoon, cartoon, cartoon, cartoon | ["Music", "Punk rock", "Rock music", "Quack", "Duck"] | ["rock", "background-noises/voices", "e-guitar", "bass", "acoustic drums", "male voice singing", "uptempo"] | 6 | ZHzhdhKEjMc | 3358 |
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;