musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- groovy bass line · 4 ✖
- male singer · 4 ✖
- medium fast tempo · 4 ✖
- passionate 3
- energetic 2
- story telling 2
- animated movie soundtrack 1
- animated singing 1
- animated vocals 1
- annoying vocal sounds 1
- average audio quality 1
- backup singers 1
- building anticipation 1
- cheerful 1
- children’s show 1
- classic rock 1
- comedy 1
- dance rhythm 1
- death metal music 1
- discordant vocal tones 1
- distorted guitars 1
- eerie 1
- electric guitar lead 1
- emphatic vocals 1
- energetic acoustic guitar 1
- fast drumming rhythm 1
- fast metal drumming 1
- funny tv show 1
- game soundtrack 1
- inspiring 1
- jealous 1
- keybiard accompaniment 1
- keyboard harmony 1
- lively piano accompaniment 1
- love song 1
- multiple overlapping tracks 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- percussive guitar strumming 1
- poor audio quality 1
- retro pop song 1
- retro rock 1
- rock band 1
- rock music 1
- romantic 1
- scary 1
- sentimental 1
- slapstick comedy 1
- spirited spanish guitar 1
- string rock drumming 1
- string symphony 1
- studio recording 1
- tambourine percussions 1
- vibrant ukelele harmony 1
- video game soundtrack 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 4
- /t/dd00032 1
- Angry music 1
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Singing 1
- Speech 1
- Ukulele 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 | |
Squidward does sit-ups while I play unfitting music | A male singer sings this pop melody with animated vocals making annoying sounds. The song is medium tempo with backup vocals singing harmony, keyboard accompaniment, percussive a bass line and strong drumming rhythm. The song is a background track for an animated tv show. The audio quality is very poor. | 2010-08-14T01:46:22Z | TMNT39 | Squidward enjoying his trip to the future with music that makes no sense with it! WOW!! :P | ["Music", "/t/dd00032"] | ["animated vocals", "male singer", "medium fast tempo", "children’s show", "funny tv show", "comedy", "slapstick comedy", "backup singers", "multiple overlapping tracks", "groovy bass line", "discordant vocal tones", "keybiard accompaniment", "dance rhythm", "retro pop song", "animated movie soundtrack", "annoying vocal sounds", "poor audio quality"] | 1 | MSqQKf3O3vY | 2270 | |
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 |
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;