musiccaps_details (view)

4 rows where musiccaps_aspects contains "electric guitar melody" and musiccaps_names contains "Speech"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Samuel Rossi Orchestra Ringo Story Goleada polka The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. 2009-07-03T12:40:13Z Tuttofisa Samuel Rossi Orchestra Ringo Story Goleada polka ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] 4 ChqJYrmQIN4 1394
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. 2012-11-21T19:01:01Z TrueFire *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] 4 NZ2kFIaW05k 2345
How to make guitar sound like banjo and cool bell sound The low quality recording features a tutorial on how to make the electric guitar sound like a banjo. It consists of a flat male vocalist talking over the background instrumental music, after which he starts playing the electric guitar. The recording is noisy. 2007-11-04T00:51:59Z lpknocko guitar effects how to make a regular electric guitar sound like banjo and cool bell sound. ["Banjo", "Effects unit", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] ["flat male vocal", "background instrumental music", "electric guitar melody", "banjo", "tutorial", "low quality", "noisy"] 4 NnYfF7E12dk 2364
Thomas & Friends ep 18 A Bad Day for Freddie The low quality recording features a flat male vocal talking over electric guitar melody and sustained strings, with some metallic impact sound and stuttering vocal sound effect. It sounds funny and the recording is noisy and in mono. 2008-07-24T18:28:24Z Daniel Alsop Here's the 2nd narrow gauge episode this time featrueing Fearless Freddie. ["Bell", "Music", "Speech"] ["low quality", "noisy", "mono", "flat male vocal", "stuttering vocal sound effect", "sustained strings", "electric guitar melody", "metallic impact", "funny"] 4 q7sK_xrJz-k 4755

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;