musiccaps_details (view)

1 row where musiccaps_aspects contains "amateur production", musiccaps_aspects contains "dance floor", musiccaps_aspects contains "hip hop music" and musiccaps_aspects contains "instrumental 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
Roland TR 808 vs Aira TR8 by INHALT (HiQ) The song is an instrumental piece. The song is medium tempo with a steady rhythm, groovy bass line, retro keyboard tones. The song is dance-like and entertaining. The song is a hip hop tune and an amateur production. 2014-03-21T23:25:01Z INHALTVIDEO If you like what you hear and would like to hear more please like our page on Facebook at: https://www.facebook.com/INHALT.US iTunes EP Available at: http://itunes.apple.com/us/artist/inhalt/id524892048 Vinyl Available at: http://www.darkentriesrecords.com/store/dark-entries/inhalt-vehicle-ep/#tab-description Here is a head to head comparison between our beloved Roland TR 808 and the brand new Roland Aira TR 8. I've used the TR 808 for close to 12 years on almost every production I've been involved with. I know the sound in and out. The AIRA is incredibly close to the original 808 but there are certain differences. Chiefly I cannot tune the AIRA to my 808 in terms of the cymbals and hi hats. The AIRA seems much higher in pitch. There are more minute differences that when stacked up definitely reveal what's a real analog workhorse and what is digital but all that aside, Roland have to be commended for this achievement. There are few digital instruments that sound as good as the Aira range and that have the kind of tactile user interface that's present here. We recorded the 808 and the TR8 into Pro Tools HD at 96k/24 bit via a Precision 8 mic pre. Each sound was tracked independently and then general levels worked out in Pro Tools. There is no compression or EQ present here at all ... these are the machines completely dry. The video starts with non accented versions of the instruments and then moves to accented versions. ["Sampler", "Music", "Musical instrument", "Drum machine", "Synthesizer"] ["hip hop music", "medium tempo", "amateur production", "home production", "instruments", "music", "steady drumming rhythm", "various percussion hits", "dj", "dance floor", "dance rhythm", "spirited", "entertaining", "instrumental music", "positive", "people dancing", "groovy bass line", "keyboard synth tones"] 1 6-XEA0zqo8M 713

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;