musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- amateur recording · 3 ✖
- instrumental · 3 ✖
- slow tempo · 3 ✖
- no voices 2
- bassline 1
- blues bassline 1
- blues melody 1
- chorus effect on guitar 1
- cymbals 1
- guitar arpeggios 1
- low quality recording 1
- no percussion 1
- no voice 1
- overdriven guitar 1
- piano notes 1
- plucked string instrument 1
- romantic theme 1
- simple percussion 1
- slow rock 1
- string section 1
- trumpet song 1
- vibrato 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender Deluxe Reverb '65 Reissue Cranked up a bit! | This amateur recording features an overdriven guitar playing the main melody. This is a low quality recording and the volumes of the instruments are not professionally mixed. The overdriven guitar is loud. A piano plays a couple of notes in the beginning. The guitar is accompanied by percussion playing a simple beat in the background. The bass plays a blues style bassline. The tempo of this song is slow. The song is based on blues style. | 2012-08-01T12:50:32Z | Sam Rhodes | Just using my Gibson 339 into a Fender Deluxe Reverb Reissue turned up to 7 with a Dr Z Brake Lite on 4. | ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "blues melody", "overdriven guitar", "vibrato", "blues bassline", "simple percussion", "slow tempo", "no voice", "instrumental", "piano notes"] | 0 | Qe71m678qEU | 2632 | |
LIQUID SKY PART 1 | This slow rock song features a guitar playing arpeggiated chords. The guitar has added effects of chorus and reverb. The bass plays a descending run in the scale of the chords. The percussion plays the different cymbals one after the other. The recording quality is low. There are no voices in this song. This song can be played in a dreamy sequence of a movie. | 2006-09-22T14:19:13Z | SGGURU | Gary Skopick on guitar, Victor Salazar on drums, and Trace Cronin on bass guitar. Another original song recorded in our studio, while practicing for the Synergy II gig July 27, 2006. | ["Music", "Squish"] | ["slow rock", "amateur recording", "low quality recording", "cymbals", "guitar arpeggios", "bassline", "instrumental", "no voices", "slow tempo", "chorus effect on guitar"] | 0 | wL4HaT8rEVU | 5256 | |
Trumpet Solo ~ My Heart Will Go On, theme from Titanic | This amateur recording features a trumpet playing the main melody. The song starts with a string section playing a chord and fading away. The trumpet starts to play the melody. This is backed by a stringed instrument plucking chords. This sounds like a harp or an acoustic guitar. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-01-18T09:26:46Z | TPBOY | Book from " Take the Lead " | ["Brass instrument", "Trumpet"] | ["amateur recording", "trumpet song", "romantic theme", "string section", "plucked string instrument", "no percussion", "slow tempo", "no voices", "instrumental"] | 0 | xZukWGb52BI | 5341 |
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;