musiccaps_details (view)

2 rows where musiccaps_aspects contains "ambient sounds", musiccaps_aspects contains "people talking", musiccaps_aspects contains "spirited" and musiccaps_author = 7

✎ 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
Rashid Jahangir (zamanai poak na hum dum) This music is an instrumental.the tempo is fast with a harmonium melody and tabla accompaniment. The performance is live with ambient sounds of people talking, sound of glass bangles and a woman’s voice. This music is Indian Classical. 2008-10-30T22:02:58Z u297777 Rashid Jahangir from doda city (J&K) ["Tabla", "Drum", "Percussion"] ["instrumental", "fast tempo", "harmonium melody", "indian classical", "raga", "sruti", "classical", "indian percussion instrument", "lively tabla rhythm", "live performance", "live audience", "ambient sounds", "people talking", "ghungaroos sound", "people talking", "lively", "spirited", "song interlude", "sing introduction"] 7 EnewI6fNhVA 1590
Chicas Roland's - Cumbia - El Hijo De Tuta A female vocalist sings this Spanish melody. The tempo is medium with keyboard harmony, tambourine beats, rhythmic congas and acoustic guitar. The song is upbeat, buoyant, groovy, lively, spirited,youthful and engaging. This is an outdoor live performance as there are ambient sounds like gentle wind, people talking, clapping and cheering. This song is a lively Spanish Pop song. 2008-06-13T21:36:48Z Palmeras Disco Video "del Baul De Los Recuerdos" de Las Chicas Roland's interpretando la cumbia "El Hijo De Tuta" en Junio del 2002. Espero les guste... ["Singing", "Music", "Rattle (instrument)"] ["female singer", "medium tempo", "pop", "spirited", "lively", "buoyant", "engaging", "vivacious", "spanish", "amateur recording", "muffled audio", "acordion harmony", "congas beat", "keyboard accompaniment", "rhythmic acoustic guitar", "live performance", "outdoors", "ambient sounds", "people talking", "cheering", "clapping", "inferior audio quality", "groovy dance beat", "buoyant", "youthful", "tambourine beats"] 7 Py8Vd0-qxYU 2583

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;