musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "lively"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic guitar · 4 ✖
- bass guitar · 4 ✖
- lively · 4 ✖
- acoustic drums 3
- easygoing 2
- melodic singing 2
- vibrant 2
- accordion 1
- albanian pop music 1
- clarinet 1
- croatian pop 1
- electric guitat 1
- electronic drums 1
- glockenspiel 1
- harmonica 1
- heart-touching 1
- hindi film music 1
- instrumental 1
- live performance 1
- male vocal 1
- male vocals 1
- male voice 1
- mexican folk music 1
- no singer 1
- shouting 1
musiccaps_names (array) 9 ✖
youtube_published (date) 4 ✖
- 2009-10-14 1
- 2010-07-12 1
- 2012-03-18 1
- 2015-11-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Yeh hai bombay meri jan-Milon Gupta | This is a Hindi film music piece. This is an instrumental piece. The harmonica is playing a cheerful melody in the lead. The glockenspiel is playing a secondary melody while the acoustic guitar and the bass guitar are supporting them in the background. The acoustic drums are playing a jazz swing beat with the brushes. The atmosphere is lively. This piece could be used in a feelgood movie during scenes where everything is going well for the main character. | 2010-07-12T16:07:06Z | ramanaraaga | Yeh hai bombay meri jan from the movie "CID" played on harmonica by Shri Milon Gupta | ["Harmonica", "Jingle, tinkle", "Wind instrument, woodwind instrument"] | ["hindi film music", "no singer", "instrumental", "harmonica", "glockenspiel", "acoustic guitar", "bass guitar", "acoustic drums", "vibrant", "lively", "heart-touching"] | 9 | 8dE1x--TuF8 | 932 | |
EL ORIGINAL DE LA SIERRA "LA DESVELADA" | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | 2009-10-14T02:38:05Z | FRONTERAVISUAL09 | MUSICAL EN BILLBOARD | ["Accordion"] | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | 9 | XOsHEjo-RSg | 3181 | |
Oliver Dragojevic - Serenada (mix) | This is a Croatian pop music piece. There is a male vocalist singing melodically in the lead. The acoustic guitar is playing a simple tune with the bass guitar playing in the background. The rhythm is played by a basic electronic drum beat with an acoustic sound. There is a lively atmosphere to this piece. This piece could fit well in the soundtrack of a romantic comedy movie that takes place in Croatia. | 2012-03-18T23:49:52Z | Life is Good | ["Music", "Soul music"] | ["croatian pop", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "electronic drums", "lively", "easygoing"] | 9 | Zy_YSROQmlE | 3431 | ||
Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;