musiccaps_details (view)

2 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "synth music" and musiccaps_author = 0

✎ 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
Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. 2011-05-25T01:24:21Z T-Series Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series ["Singing", "Music of Asia", "Music"] ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] 0 ctJI7pCbxAo 3751
Dark Sad Emotional Ambient Electronic Cinematic Music This electronic music features no voices. All the parts of this song are programmed. The main melody is played by a simulated plucked instrument. This is accompanied by electronic sounds in the background sounding like an alien spaceship. There are ambient sounds in the background filling the musicscape. The song has an ambient feel. This song can be played in a movie where there is travel to outer space. 2012-12-31T08:23:36Z Digital Flashback Check out my new dark & mystical composition here: https://www.youtube.com/watch?v=Y50xrA6_GsQ ►TRACK: Phantom ►COMPOSER: Digital Flashback Buy Music | Albums | Untagged Beats (not for profit): http://digitalflashback.bandcamp.com/ Web | Beat Store | Blog | Music Libraries: http://www.digitalflashbackmusic.com/ Follow Me: ►Facebook: https://www.facebook.com/DigitalFlashback ►Soundcloud: https://soundcloud.com/digital-flashback ►Twitter: https://twitter.com/DomDigiFlash ►Google Plus: https://plus.google.com/+DigitalFlashbackBeats For all purchase inquiries including buying rights to beats please contact: info@digitalflashbackmusic.com Stay tuned and SUBSCRIBE If you like my channel! Thanks for all of your support! ["Effects unit", "Music", "Ambient music", "Electronica"] ["electronic music", "synth music", "instrumental", "no voices", "ambient sounds", "moderate tempo", "plucked instrument", "programmed song"] 0 yhS-6Y8ToR8 5430

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;