musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy bass line · 5 ✖
- medium fast tempo · 5 ✖
- passionate · 5 ✖
- energetic 3
- male singer 3
- emotional 2
- keyboard harmony 2
- love song 2
- romantic 2
- sentimental 2
- story telling 2
- youthful 2
- animated singing 1
- average audio quality 1
- bells percussion tones 1
- building anticipation 1
- cheerful 1
- classic pop 1
- classic rock 1
- death metal music 1
- distorted guitars 1
- drum rolls 1
- eerie 1
- electric guitar 1
- electric guitar lead 1
- electric guitar solo 1
- emphatic cries 1
- emphatic vocals 1
- energetic acoustic guitar 1
- exciting 1
- …
musiccaps_names (array) 13 ✖
- Music 5
- Angry music 1
- Christmas music 1
- Grunge 1
- Happy music 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Singing 1
- Ska 1
- Speech 1
- Ukulele 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
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 | |
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov | A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. | 2012-02-10T11:45:21Z | gian maria emendatori | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] | 1 | fXhN3_gGpQw | 3957 | ||
Gong - Esnuria | The song is an instrumental improvisation. The song is medium fast tempo with a groovy bass line, electric guitar playing, saxophone playing, jazz drumming with percussive hits and a xylophone playing. The song is highly improvisational and energetic. The song is a modern jazz fusion or improvisation jam. | 2009-07-23T20:02:28Z | funkdigger91 | LP: Gong - Gazeuse! (1976) Bass, Piano, Gong - Francis Moze Congas, Percussion - Mino Cinelu Drums, Vibraphone, Marimba, Glockenspiel - Pierre Moerlen Guitar - Allan Holdsworth Producer - Dennis MacKay Saxophone, Flute - Didier Malherbe Vibraphone - Benoit Moerlen Vibraphone, Marimba, Glockenspiel - Mireille Bauer Maybe heard on: DJ Pogo - Block Party Breaks Vol. 2 (2002) | ["Music", "Ska", "Vibraphone"] | ["funk jazz", "medium fast tempo", "instrumental music", "saxophone playing", "electric guitar solo", "funky jazz drumming", "groovy bass line", "drum rolls", "various percussion hits", "live improvisation", "bells percussion tones", "xylophone playing", "jazz improvisation", "energetic", "exciting", "jazz band", "modern jazz hits", "groovy rhythm", "jazz festival", "emphatic cries", "emotional", "passionate"] | 1 | ylKvglDzBU4 | 5436 | |
Ten2Five - My World Is Full With You | A female vocalist sings this beautiful pop melody. The tempo is medium fast with rhythmic acoustic guitar, keyboard harmony, electric guitar melody, straight drumming;steady bass and tambourine beats. The song is mellow, sweet, passionate,emotional, youthful, romantic, simple and tender. This song is a hit Indonesian Pop. | 2012-10-13T23:03:56Z | Xily Gina | Indonesian indie band | ["Christmas music", "Music", "Happy music"] | ["female vocalist", "medium fast tempo", "pop", "straight drumming", "classic pop", "passionate", "emotional", "romantic", "first love", "indonesian pop", "melodious", "rhythmic acoustic guitar", "electric guitar", "groovy bass line", "keyboard harmony", "tambourine beats", "synthesiser", "vivid", "vivacious", "youthful", "love song", "emotional", "sentimental"] | 7 | zTtZH-Q61Ik | 5480 |
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;