musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar" and musiccaps_aspects contains "no voice" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- guitar · 3 ✖
- no voice · 3 ✖
- bass 2
- instrumental 2
- percussion 2
- accordion song 1
- amateur recording 1
- latin rhythm song 1
- lingering bassline 1
- low quality audio 1
- meditation music 1
- melancholic mood 1
- moderate tempo 1
- no other instruments 1
- pads 1
- piano music 1
- relaxing music 1
- repetitive phrase 1
- rock 1
- slow tempo 1
- synth sounds 1
musiccaps_names (array) 9 ✖
- Music 2
- Accordion 1
- Background music 1
- Drum kit 1
- Guitar 1
- Musical instrument 1
- New-age music 1
- Pulse 1
- Rock music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jazz Spa Music: Soft Easy Jazz, Trumpet and Sax Music for Massage and Relax | This relaxing song features the sound of pads in the background. A guitar strums a chord first then plays arpeggiated chords. At the end of the song, a piano chord is played. A wave-like synth plays one continuous note in the background. The bass plays the root notes of the chords and the note lingers. The mood of this song is relaxing. This song can be played in a spa. | 2013-11-02T10:30:01Z | Chillout Lounge Relax - Ambient Music Mix | https://itunes.apple.com/us/album/soft-jazz-instrumental-songs/id731346719 Jazz Spa Music: Soft Easy Jazz, Piano and Guitar Music for Massage and Relax www.meditationrelaxclub.com https://www.facebook.com/pages/Meditation-Relax-Club/527310100623985 Jazz Music for Spa, Relaxing Music for Massage and Intimacy. Musique Zen, Musica Relajante. Easy Jazz for Romantic Dinner. Jazz Music for Spa, Relaxing Music for Massage and Intimacy. Easy Jazz for Romantic Dinner. | ["Background music", "New-age music", "Music"] | ["relaxing music", "no voice", "instrumental", "synth sounds", "meditation music", "guitar", "piano music", "lingering bassline", "pads", "moderate tempo"] | 0 | _kPmYc1nXuQ | 3485 | |
Los Paraguayos | This low quality audio features an accordion playing the main melody. This is accompanied by percussion playing a simple beat. A tambourine is played with the percussion. This is a Latin style song. The guitar plays groups of three ascending and one descending note per bar. The bass plays a Latin rhythm. There are no voices in this song. This song is an instrumental. This song can be played at a house party. | 2008-07-24T14:35:37Z | Spiciu | Performing their tune MANANTIAL - The Spring. | ["Accordion"] | ["latin rhythm song", "accordion song", "guitar", "percussion", "no voice", "instrumental", "bass", "low quality audio"] | 0 | QNQ3sAMxZPY | 2616 | |
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 |
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;