musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "electronic drums" and musiccaps_aspects contains "emotional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bass guitar · 3 ✖
- electronic drums · 3 ✖
- emotional · 3 ✖
- electric guitar 2
- melodic singing 2
- r&b 2
- soul 2
- acoustic guitar 1
- chimes 1
- clarinet 1
- dreamy 1
- female choir 1
- female vocal 1
- female vocals 1
- grandiose 1
- groovy 1
- hip-hop 1
- keyboard 1
- live performance 1
- male vocal 1
- male vocals 1
- melodic pad 1
- remix 1
- sentimental 1
- slow tempo 1
- soap opera theme 1
musiccaps_names (array) 6 ✖
- Music 3
- Christian music 1
- Crowd 1
- Music of Asia 1
- Sad music 1
- Singing 1
youtube_published (date) 3 ✖
- 2006-10-28 1
- 2009-03-24 1
- 2010-09-16 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Be Strong ..xX | This is an R&B/soul music piece. There is a whole mix of male and female vocals singing melodically. The tune is being performed by the keyboard while the electric guitar and the bass guitar are playing in the background. There is a slow tempo electronic drum beat in the rhythmic background. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie, especially during the scenes of resolution. | 2006-10-28T13:51:06Z | xxnicholsonxx | a video made by me for heartbroken girls | ["Christian music", "Music"] | ["r&b", "soul", "remix", "male vocals", "female vocals", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "emotional", "dreamy", "slow tempo"] | 9 | MFxMPOAbUPA | 2250 | |
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 | |
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 |
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;