musiccaps_details (view)

3 rows where musiccaps_author = 2 and musiccaps_names contains "Drum and bass"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Electronica Music DJ Venom Straight Bangin Vol 4 (2008) Electronic dance music features a repeating melody played by an electronic sound. The beat of the music is being driven by a kick drum played on every beat, a hi-hat played four times every beat and some sampled claps played on beats two and four. In the background one can hear an altered female voice singing a short melody. Another electronic/synth sound can be heard in the background having sparse interventions. The music is meant to be danced to. 2008-10-15T05:46:51Z MariaGarcia281 DJ Venom rocks the house! Straight Bangin, Vol. 4 Electronica music ["Drum and bass", "Music of Asia", "Music", "Pop music", "Techno", "Trance music", "Electronica"] ["electronic sounds", "kick drum", "altered female voice", "hi-hat", "electronic dance music genre"] 2 IbaQjxGDT-o 1923
Tempo Giusto - Tick Tock (Original Mix) [HD] The techno music excerpt features only a beat, no other melodic or harmonic instruments. By the sound of it, the beat was made using sampled drums. Other percussive instruments can be heard in the background. This music would be played in a club. 2009-05-05T09:55:45Z sonicobeat Tempo Giusto - Tick Tock (Original Mix) Label: Black Hole Recordings Genre: Electronic Style: Trance buy http://www.beatport.com ["Drum and bass", "House music", "Music", "Techno", "Tick", "Dubstep", "Dance music"] ["club music", "techno music", "drum beat", "percussive instruments", "no melody", "no harmony", "sampled drums"] 2 UkZ76EFfLSg 2940
Christian Dubstep | Wavedude | Switchfoot - Afterlife ( Wavedude Remix ) The electronic instrumental music features a melody played by a synth sound and being accompanied by other electronic sounds. In the low-register a bass electronic sound can be heard playing at times twice every beat, driving the pulse of the music. In the second half of the music excerpt another electronic sound can be heard in the upper register playing chords. 2013-10-21T16:38:43Z Zephan The Warlock Artist: Wavdedude Track: Switchfoot - Afterlife ( Wavedude Remix ) Channel: http://www.youtube.com/user/WavedudeM... Site: http://www.facebook.com/WavedudeMusic More dubstep: http://www.youtube.com/playlist?list=PLCF23C1D83EF048BE More from Wavedude: http://www.youtube.com/playlist?list=PL865097AE01EA9214&feature=view_all --------------------------------------------------------------------------------­­­­­------------------------------------------------------ Going to try to do weekly uploads from now on, starting with this amazing remix. ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Electronica"] ["electronic music genre", "low-pitch bass electronic sound", "instrumental", "no voice"] 2 Vi2posMLsrg 3022

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;