musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- bass guitar · 2 ✖
- electronic drums · 2 ✖
- acoustic guitar 1
- chimes 1
- clarinet 1
- electric guitar 1
- electronic percussion 1
- emotional 1
- keyboard 1
- live performance 1
- male vocal 1
- melodic pad 1
- melodic singing 1
- religious 1
- sentimental 1
- soap opera theme 1
youtube_published (date) 2 ✖
- 2010-09-16 1
- 2015-05-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ab Tere Bin Hum Bhi Jee Lenge from AURANGZEB | This is a soap opera theme music. There is a clarinet playing the main tune with the acoustic guitar and the bass guitar in the backing. There is a melodic pad that can be heard. An acoustic sounding electronic cymbal and wind chimes strokes are playing every now and then. There is a sentimental atmosphere to this piece. | 2010-09-16T12:47:18Z | AB Shah Ahmad | very nice song | ["Music", "Sad music"] | ["soap opera theme", "acoustic guitar", "clarinet", "bass guitar", "melodic pad", "electronic drums", "chimes", "sentimental", "emotional"] | 9 | sMNuJy4f4A0 | 4944 | |
hebron song ''gorepilla'' sung by brp.p.suresh, music by bro.stephen | This is a live performance of a religious song. There is a male vocalist singing melodically as the lead. The main melody is being played by the keyboard with the electric guitar and the bass guitar in the background. The rhythmic background is provided by the electronic drums and the electronic percussion. The piece has movements reminiscent of Jewish music. | 2015-05-01T09:06:39Z | Dr. Suresh David | ["Singing", "Music", "Sad music"] | ["live performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "electronic percussion", "keyboard", "religious"] | 9 | teyDfFbVMSY | 5056 |
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;