musiccaps_details (view)

4 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "mono" and musiccaps_names contains "Strum"

✎ 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
DAVID ALLAN COE interview - part 1 The low quality recording features a flat male vocal singing over acoustic rhythm guitar chords, after which that same vocal is talking. The song sounds passionate, while the recording, overall, is noisy and in mono. 2008-07-26T19:53:24Z BubbaTheLawnJockey DAVID ALLAN COE interview - part 1 ["Singing", "Country", "Music", "Strum"] ["low quality", "noisy", "mono", "acoustic rhythm guitar", "flat male vocal", "passionate", "country"] 4 -UuEBhule84 52
Como tocar Yo Quisiera REIK en Guitarra FACIL Tutorial Guitarra Acordes y ritmo clase The low quality recording features an acoustic rhythm guitar playing over a pop song played on playback in the background. It sounds joyful and happy, while the recording is in mono and noisy. 2014-09-14T00:30:26Z guitarraviva2 Como tocar Yo Quisiera REIK en Guitarra facil Tutorial Guitarra tutorial y clase Acordes y ritmo suscríbete: http://goo.gl/Ldrmr5 vídeo de la Clase: http://youtu.be/QBujO3gJQmM cursos de guitarraviva : http://www.guitarraviva.com/cursos acústica o criolla eléctrica... en todas las guitarra se puede tocar ["Country", "Music", "Strum", "Bluegrass"] ["low quality", "playback", "pop", "passionate male vocal", "snappy snare", "synth pad", "acoustic rhythm guitar", "noisy", "mono", "joyful", "happy"] 4 Aro-HcWNsHI 1175
AQUALUNG JETHRO TULL : 70's Acoustic Guitar Cover : REFLECTIVE STYLE The low quality recording features a cover of a rock song and it consists of acoustic rhythm guitar and nasal, echoing male vocals. The recording is noisy and in mono and it sounds emotional. 2014-08-10T10:43:37Z STePH SANCiA My REFLECTIVE acoustic guitar cover of Aqualung by Jethro Tull released in 1971 with the 6 leading guitar notes that most folks only have to hear the once to know it "IS" Aqualung and 6 notes that would launch me into a musical hyper drive. But today I've opted for an off key reflective acoustic version and have NOT adhered to the original format regarding lyrics and verse and have done a Steph Style tribute to Jethro Tull. ["Country", "Music", "Strum"] ["rock", "cover", "low quality", "nasal echoing male vocal", "acoustic rhythm guitar", "noisy", "emotional", "mono"] 4 XvyaEbEpAMc 3237
vicente de montpellier The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. 2009-11-09T14:59:52Z bentana100 aqui el vicente de montpelier cantando en su barrio monteberou ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] 4 lI8aGjIb8Jg 4389

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;