musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "trumpet" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental · 3 ✖
- slow tempo 3
- trumpet · 3 ✖
- bass guitar 2
- accordion 1
- acoustic drums 1
- acoustic sounding drums 1
- calming 1
- chill 1
- clarinet 1
- electric guitar 1
- folk song 1
- guitar 1
- jazz music 1
- keyboard 1
- low quality audio 1
- no singer 1
- no voices 1
- piano 1
- saxophone 1
- soothing 1
- tuba 1
musiccaps_names (array) 4 ✖
- Brass instrument 2
- Saxophone 2
- Accordion 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 | |
HOW TO FIBERGLASS * The Real Deal * Simple Mold * Part 5 * The Series | This is a jazz music piece. It is an instrumental piece. The saxophone and the trumpet are playing the melody. The piano, the electric guitar and the bass guitar are accompanying them in the background. The tempo is slow. The atmosphere is chill. This piece could be playing in the background at a coffee shop. | 2011-10-13T00:12:26Z | GasserGlass | Part FIVE (5) of the Original YOUTUBE - HOW TO FIBERGLASS Series...... | ["Brass instrument", "Saxophone", "Trombone"] | ["jazz music", "instrumental", "saxophone", "trumpet", "electric guitar", "piano", "bass guitar", "acoustic drums", "slow tempo", "chill"] | 9 | IGyDtKAU1u8 | 1888 | |
Francis Dupont - Forever Love (Calming, Relaxing, Soothing Trumpet Music ) | This is an instrumental trumpet music piece. The trumpet is playing a calming main melody while the keyboard and the bass guitar are playing in the background. There is a slow tempo acoustic sounding drum beat playing the rhythm. The atmosphere is soothing.This piece could be used in the soundtrack of an art movie. It could also be playing in the background at a sauna. | 2012-05-24T08:36:32Z | Tatiana Blue | Always in love with nature ... Select the optimal resolution 720p Thank you all for viewing and comments! All the best! http://www.youtube.com/user/bluesensation75?feature=mhee http://www.youtube.com/user/TBluedream?feature=watch | ["Brass instrument", "Saxophone"] | ["no singer", "instrumental", "trumpet", "keyboard", "bass guitar", "acoustic sounding drums", "calming", "soothing", "slow tempo"] | 9 | VlwbDjggUKk | 3030 |
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;