musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "positive" and musiccaps_aspects contains "youthful" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- positive · 2 ✖
- youthful · 2 ✖
- adventurous 1
- amateur pop music 1
- cheerful 1
- comically happy 1
- distorted guitar lead 1
- e erotic 1
- emotional 1
- energetic 1
- exciting 1
- fast tempo 1
- feeling loved 1
- free spirit 1
- fun 1
- groovy bass line 1
- guitar accompaniment 1
- guitar rhythm 1
- happy 1
- head bangers 1
- male singer 1
- medium tempo 1
- new experiences 1
- party time 1
- people screaming 1
- piano accompaniment 1
- poor audio quality 1
- pop music 1
- retro classic rock 1
- retro youtube pop 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- scream and shout 1
- screaming vocals 1
- song introduction 1
- spirited 1
- steady drumming rhythm 1
- story telling 1
- strong bass line 1
- the first time 1
- yodelling vocals 1
musiccaps_names (array) 10 ✖
- Music 2
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Song 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bayartsengel yodel | A male singer sings cheerful yodelling vocals. The song is fast tempo, with a steady drumming rhythm, groovy bass line, guitar accompaniment and piano playing enthusiastically. The song is cheerful and thoroughly entertaining. The song is a modern pop tune with yodelling to express happiness and free spirit. | 2011-06-09T11:54:50Z | ulzii bat | Bayartsengel yodel | ["Yodeling", "Music"] | ["fast tempo", "guitar accompaniment", "retro youtube pop", "song introduction", "scream and shout", "pop music", "amateur pop music", "free spirit", "energetic", "song introduction", "youthful", "e erotic", "new experiences", "feeling loved", "the first time", "comically happy", "piano accompaniment", "strong bass line", "steady drumming rhythm", "yodelling vocals", "cheerful", "happy", "positive", "emotional", "spirited", "fun", "party time"] | 1 | I-C14nCneBs | 1857 | |
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;