musiccaps_details (view)
2 rows where musiccaps_aspects contains "romantic" and musiccaps_aspects contains "tambourine percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- medium tempo 2
- passionate 2
- romantic · 2 ✖
- tambourine percussion · 2 ✖
- adventurous 1
- arabic dance music sultry vocals 1
- arabic music 1
- arabic percussion 1
- backing track 1
- bad audio quality 1
- church organ 1
- country music 1
- cymbals crashing 1
- dance tunes 1
- dholak percussions 1
- exciting 1
- female singer 1
- gain issues 1
- great adventure 1
- groovy music 1
- guitar rhythm 1
- instrumental music 1
- keyboard accompaniment 1
- love songs 1
- movie themes 1
- organ accompaniment 1
- poor audio quality 1
- retro classics 1
- steady drumming rhythm 1
- vintage hits 1
- vintage pop 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Folk music 1
- Hammond organ 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 |
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;