musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_names contains "Cello" and musiccaps_names contains "Violin, fiddle" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- acoustic guitar strumming 1
- amateur recording 1
- cello 1
- cheerful 1
- composer 1
- dance music 1
- double bass 1
- enthusiastic 1
- exciting 1
- guitar 1
- instrumental 1
- instrumental music 1
- keyboard 1
- live performance 1
- medium tempo 1
- moderate tempo 1
- no percussion 1
- no voices 1
- party music 1
- passionate 1
- poor audio quality 1
- romantic feel 1
- string harmony 1
- string quartet 1
- string trio 1
- studio performance 1
- viola 1
- violin 1
- violin song 1
- wedding music 1
- western classical music 1
musiccaps_names (array) 5 ✖
- Bowed string instrument 2
- Cello · 2 ✖
- Double bass 2
- Violin, fiddle · 2 ✖
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Yellow (Coldplay) - Wedding Version Instrumental - Libante Strings - Tagaytay Highlands | This instrumental song features a violin playing the main melody. This is accompanied by a guitar playing chords. The piano plays backing chords. At the end of the song, the piano plays a fill. The bass is played on a double bass. There is no percussion in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2013-10-07T17:24:11Z | Libante Strings | Yellow (Coldplay) - Wedding Version Instrumental - Libante Strings Quartet - Tagaytay Highlands Libante Strings Quartet playing Yellow (Wedding Instrumental Version)@ "Tagaytay Highlands (Midlands Veranda)". Composed of a Keyboard, Violin, Guitar, and Double Bass. For Inquiries email us at libante_strings@yahoo.com Contact Numbers: 09179062273 / (02) 3530655 Website: http://www.libantestringsensemble.com | http://www.libantestringsensemble.com/flash Facebook: www.facebook.com/libantestrings Twitter: http://twitter.com/libantestrings Soundcloud: http://soundcloud.com/libantestrings NO COPYRIGHT INFRINGEMENT IS INTENDED | ["Cello", "Double bass", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["amateur recording", "violin song", "guitar", "double bass", "keyboard", "instrumental", "no voices", "no percussion", "moderate tempo", "romantic feel"] | 0 | HXG8DnTpyPc | 1811 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 |
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;