musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy bass line · 3 ✖
- male singer · 3 ✖
- story telling · 3 ✖
- medium tempo 2
- poor audio quality 2
- romantic 2
- adventurous 1
- ambient room nosiness 1
- animated singing 1
- bass rhythm 1
- distorted guitar lead 1
- emotional 1
- emphatic vocals 1
- energetic 1
- energetic acoustic guitar 1
- exciting 1
- folk music 1
- guitar accompaniment 1
- guitar rhythm 1
- guitarist 1
- head bangers 1
- jealous 1
- live performance 1
- lively piano accompaniment 1
- love song 1
- medium fast tempo 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- passionate 1
- …
musiccaps_names (array) 12 ✖
- Music 3
- Singing 2
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Rattle (instrument) 1
- Rock music 1
- Song 1
- Ukulele 1
youtube_published (date) 3 ✖
- 2009-04-21 1
- 2010-01-22 1
- 2010-01-26 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 | |
Devendra Banhart - Chin Chin & Muck Muck | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | 2009-04-21T19:14:32Z | eachnotesecure | Devendra Banhart performs Chin Chin & Muck Muck live at The Independent in San Francisco in April 2009 | ["Singing", "Music", "Rattle (instrument)"] | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | 1 | jFek2xLbEww | 4243 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;