musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "cello" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- acoustic guitar · 3 ✖
- cello · 3 ✖
- instrumental · 3 ✖
- accordion 1
- aesthetic 1
- alpine folk music 1
- ambient 1
- busking 1
- captivating 1
- cheerful 1
- clarinet 1
- classical 1
- dulcet 1
- euphonious 1
- joyful 1
- lively violin 1
- medium fast tempo 1
- mellifluent 1
- mellow 1
- melodious viloin 1
- minimalist 1
- orchestra 1
- orchestral music 1
- people talking in background 1
- pleasant 1
- resonator guitar 1
- romantic piano accompaniment 1
- serene 1
- simple melody 1
- slow tempo 1
- soft 1
- sweet 1
- violin symphony 1
- whistling 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mitja kvintet - S klarineti na pot-Mit Klarinetten unterwegs | This is an Alpine folk music piece. The piece is instrumental. It is being performed by an orchestra composed of the clarinets, the accordion, the cello and the acoustic guitar. The atmosphere is cheerful. This piece could be used in the soundtrack of a movie that takes place in the Alps region. | 2008-01-16T21:07:21Z | horni110607 | Mit Klarinetten unterwegs Komp.: Damir Tkavc - Alpenoberkrainer / Alpski kvintet Mitja Mastnak Robi Marzel Sandi Jug Zmago Tkavc Matjaz Vodisek Mario Reumüller | ["Wind instrument, woodwind instrument", "Accordion"] | ["alpine folk music", "instrumental", "orchestra", "clarinet", "accordion", "cello", "acoustic guitar", "cheerful", "joyful"] | 9 | 9mqA4YdX444 | 1041 | |
Aston - Telephone (Violin-Piano Cover) | This music is a violin instrumental. The tempo is medium fast with the violins going from lively to soft with a romantic piano melody and acoustic guitar accompaniment. The music is orchestral with a dulcet violin symphony. It is pleasant, mellifluous, passionate, romantic; euphonious, emotional, sweet and engaging. This music is a contemporary orchestra . | 2011-01-08T08:49:04Z | Tarek Nour | Lady Gaga's Telephone Cover Enjoy !! =) | ["Background music", "Music", "Wedding music"] | ["instrumental", "medium fast tempo", "lively violin", "classical", "cello", "melodious viloin", "dulcet", "violin symphony", "pleasant", "aesthetic", "ambient", "orchestral music", "euphonious", "mellifluent", "sweet", "romantic piano accompaniment", "acoustic guitar"] | 7 | oqMlq2zWr0c | 4659 | |
AMAZING Whistling Solos! Buskers perform On A Slow Boat to China in NYC Subway | This music is a pleasant instrumental. The music is slow tempo with a soft cello and guitar duet with a whistle melody. The song is mellow, soothing, calming , dulcet, warm and relaxing in contrast to the background noises of people talking and walking. The musicians are buskers. | 2016-04-08T15:02:24Z | Benjamin Lamson | I've been living in NYC for nearly a decade and these are two of the best buskers I've ever seen. Not only is this guys voice butter but they're both amazing whistlers! My only regret is that I started filming halfway through the song. Filmed at the Metropolitan Lorimer stop on the G train. UPDATE: Vilray recorded and released his first album. Download it at http://vilray.bandcamp.com/ Band's Info: http://patreon.com/vilray http://soundcloud.com/vilray http://www.facebook.com/Vilray-75001313101/ http://www.vilraysings.com http://www.instagram.com/vilray/ http://twitter.com/theactualvilray Jukin Media Verified (Original) * For licensing / permission to use: Contact - licensing(at)jukinmediadotcom | ["Flamenco", "Music"] | ["instrumental", "slow tempo", "cello", "whistling", "resonator guitar", "acoustic guitar", "simple melody", "people talking in background", "busking", "minimalist", "soft", "mellow", "captivating", "serene"] | 7 | rfQ94EXIpTc | 4891 |
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;