musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar rhythm", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- guitar rhythm · 3 ✖
- male singer · 3 ✖
- youthful · 3 ✖
- energetic 2
- exciting 2
- medium tempo 2
- percussive bass line 2
- rock band 2
- romantic 2
- adventurous 1
- aisi an pop 1
- asian pop hits 1
- backup singers 1
- bleeding crowd noise 1
- classic rock band 1
- cymbals crashing 1
- distorted guitar lead 1
- emotional 1
- enthusiastic 1
- groovy bass line 1
- groovy drumming rhythm 1
- head bangers 1
- keyboard accompaniment 1
- love song 1
- passionate 1
- people screaming 1
- people talking ambient sounds 1
- piano accompaniment 1
- poor audio quality 1
- pop hits 1
- positive 1
- rapping vocals 1
- retro classic rock 1
- retro pop hits 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- screaming vocals 1
- steady drumming rhythm 1
- story telling 1
- vocal harmony 1
musiccaps_names (array) 13 ✖
- Music 3
- Blues 1
- Christian music 1
- Disco 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Independent music 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jones Cup 2012 - Smart Gilas Sige Lang Music Video HD | A male singer sings this cool melody with backup singers in vocal harmony. The tempo is medium with a groovy drumming rhythm, guitar accompaniment, piano accompaniment, percussive bass line and ambient crowd noises. The song is a modern Asian pop song. | 2012-08-30T00:39:31Z | Sound Check Music | Induk Videography Music: Sige lang By Quest | ["Blues", "Disco", "Music", "Speech"] | ["male singer", "backup singers", "asian pop hits", "bleeding crowd noise", "rapping vocals", "vocal harmony", "exciting", "enthusiastic", "groovy drumming rhythm", "percussive bass line", "piano accompaniment", "guitar rhythm", "people talking ambient sounds", "energetic", "youthful", "pop hits", "aisi an pop"] | 1 | AtJ2RXQ98kY | 1179 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
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;