musiccaps_details (view)

3 rows where musiccaps_aspects contains "congas" and musiccaps_author = 2

✎ 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
Hengameh - Khalkoobi The music features a female voice singing an ascending melody. The rhythm section consists of a bass guitar, a pair of congas and a ride cymbal. An electric piano accompanies the singer with chords. In the background an electric guitar plays an accompaniment that combines melody and chords. Right at the end of the music excerpt a China cymbal can be heard. 2011-06-01T21:33:00Z shan5400 ["Music", "Happy music"] ["female voice", "electric guitar", "congas", "ride cymbal", "china cymbal", "bass guitar", "electric piano"] 2 6N1LWG4aztA 748
CARBOROBOT Steam distill.mp4 The music excerpt features a synth sound playing a melody. In the background, accompanying this melody is another synth sound that plays long chords and thus provides harmonic structure. A bass guitar can be heard alternating between regular playing and string slapping. A light rhythm is being played by a pair of congas. A metallic percussive sound can be heard from time to time. 2011-12-04T21:23:18Z CARBOROBOTbio CARBOROBOT Steam 80Bio info@carborobot.com Biomass steam boiler heated distillery at Nyírtass Hungary Biomassza gőzkazán a nyirtassi pálinkafőzőben Schnapsbrennerei: Dampfkessel, Brennerei Автоматический паровой Био котел для дистиллятора Винокуренные заводы ["Background music", "New-age music", "Music"] ["congas", "synth", "bass guitar", "metallic percussive sound"] 2 QtfIj5cJzYw 2646
Jerry rivera Para ti The instrumental latin music features a big band. The trumpets, saxophones and trombones play the same melody but on different pitches. The percussion section includes a drum kit played in the latin style and a pair of congas. A piano accompanies the brass section and blends in with the rest of the band. An electronic sound can be heard playing the same note throughout the music excerpt. 2007-09-10T07:54:12Z Donabboy para ti ["Music", "Salsa music"] ["latin music", "trumpets", "trombones", "saxophones", "congas", "piano", "upright bass", "electronic sound", "instrumental", "no voice", "drums"] 2 nH_lVl3a3Uw 4529

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;