musiccaps_details (view)

2 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "keyboard", musiccaps_aspects contains "rapping" and musiccaps_names contains "Rapping"

✎ 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
Fredrik Andersson | Razors AM This is a rap music piece played behind a rollerskating video. The sound of the skaters can be heard faintly throughout the recording. There is a male voice rapping at the forefront while other voices can be heard singing melodically in the background and ad-libbing occasionally. There is a mild keyboard playing the tune while a loud electronic drum beat is playing the rhythm. The atmosphere of this piece is groovy and urban. 2014-08-23T21:55:37Z Razors Skate Co. Presenting Razors AM, Fredrik Andersson. The world traveler comes through with this banger filmed throughout the year in Texas (USA), Amsterdam (Netherlands), Calgary (Canada), and Malaga (Spain). Edit: Anthony Medina Film: Anthony Medina, Josh Glowicki, Nils Jansons & Richie Eisler ["Music", "Skateboard", "Rapping", "Hip hop music"] ["rap music", "hip-hop", "male vocals", "rapping", "ad-lib", "keyboard", "electronic drums", "aggressive", "loud", "groovy", "urban sounds", "skating", "medium tempo"] 9 _43OOP6UEw0 3441
"Rap Chop" featuring Vince (OmegaOwnage's Slap Chop remix) This is a comedic electronic remix. It is a commercial that was transformed into a hip-hop beat. The male voice narrating in the original video was put through an autotune effect to give the impression that he is rapping the words. There is a keyboard and a synth bass in the melodic background while an electronic drum beat provides the rhythmic background. The atmosphere in this piece is amusing. The tempo of the piece is slightly fast-paced. 2009-06-01T02:38:20Z TheOmegaPowerOwnage Some credit goes to: Steve Porter for the download pack of the commercial. Vince Offer for being in the commercial. Me for remixing. Youtube for hosting. Sony Vegas Pro for Editing. ["Scratching (performance technique)", "Music", "Rapping", "Dubstep", "Hip hop music"] ["comedic", "electronic", "hip-hop beat", "remix", "commercial", "male voice", "autotune", "rapping", "synth bass", "keyboard", "electronic drums", "funny", "parody", "amusing"] 9 iS8YQGp2_ng 4186

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;