musiccaps_details (view)

3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "rustling" and musiccaps_names contains "Music"

✎ 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
1991 Integra DA rattle can paintjob walkaround This music is an Electronic instrumental. The tempo is medium with synthesiser articulation and drum machine arrangement. The music is muffled as the audio is of poor quality and the recording is done outdoors. There are ambient nature sounds in the background like the wind and some rustling. 2012-04-16T20:15:08Z ecotectech 1991 Integra DA fresh rattle can paint job. ["Music", "Rattle"] ["instrumental", "medium fast tempo", "poor audio quality", "muffled sounds", "electronic music", "digital drum", "synthesiser arrangement", "outdoor", "ambient naturesounds", "windy", "breezy", "rustling"] 7 AuZNuyR2OJs 1182
nyadran sidoarjo - sound system DSS/BIMA & RENDY/EMPAD MUSIC cabean kedol- AREK KOPOK EN This music clip is an electronic instrumental. The audio quality is inferior, so the music is incoherent, but there are some elements that stand out like intense drumming; punchy bass lines, synthesiser arrangements, female vocalisation, a syncopated xylophone-like instrument. The music is being played outdoors as there is the sound of vehicles, honking,people talking and some rustling. The music is peppy, energetic , enthusiastic and has a trippy, trance like vibe.This song is an EDM. 2014-06-10T10:50:09Z udin sam pesta laut nelayan kupang candi- sidoarjo 09-06- 2014 ["Music", "Music of Latin America", "Maraca"] ["instrumental", "fast tempo", "boomy", "electronic music", "outdoor musc", "chaotic", "bustling", "catchy vocal riff", "trippy", "trance", "repetitive", "distorted audio", "static", "tambourine", "drums", "syncopated music", "street sounds", "people talking", "tapping", "rustling", "female vocalisation", "electronic music", "dance music"] 7 D4ccFYk3bhU 1435
Juki DDL 8700 - with servo motor, silent machine This clip is an instrumental with dissonant sounds like whirring, an engine starting, door bell or elevator bell , clattering and rustling. This is an amateur home recording. 2010-01-16T10:21:13Z www.jomaq.com Máquinas de costura Juki DDL- 8700 lockstitch machine, equipped with servo motor. Very silent machine and cheap machine. Ideal for home use and small business. ["Music", "Sewing machine"] ["instrumental", "whirring sounds", "engine sound", "amateur", "home recording", "dissonant", "door bell ringing", "elevator bell", "rustling", "clattering sound"] 7 heZw1TTrtTU 4123

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;