musiccaps_details (view)

5 rows where musiccaps_aspects contains "harp" and musiccaps_author = 2

✎ 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
Проект "Дыхание" Trailer The instrumental music features a string section playing an ascending long-note melody while at the same time providing harmonic support. A harp is playing arpeggios. Although it feels as if time passes slowly, the tempo is medium. Listening to this music I get a sense of profoundness that's moving me. This music could work well as the soundtrack for a movie. 2013-12-09T09:54:15Z Лазолван Рино   ["Background music", "Music", "Sad music"] ["strings", "harp", "medium tempo", "profound atmosphere", "instrumental", "no voice", "movie music"] 2 6vRBp8jo40Q 797
Home on the Range "Yodle Adle Eedle Idle Oo" Russian The music features for the most part an instrumental but almost at the end of the excerpt a male voice starts to yodel. Up to that point the melody is being played by a marimba, then trumpets and horns, possibly trombones too. A tuba is holding the beat pulsation in the low register. At the end of the excerpt a harp can be heard. 2008-07-01T06:11:14Z Titania1989 =) ["Yodeling", "Music", "Song", "Steelpan"] ["trumpets", "marimba", "horns", "tuba", "drums", "yodeling", "male voice", "harp"] 2 F5e-SEICJP4 1612
Relaxing Harp Instrumental Christian Music The instrumental music features a harp playing a combination of melody and accompaniment. In the background one can hear a synth pad providing harmony throughout the music excerpt. The message of the song seems romantic and the atmosphere is calming. 2014-04-11T20:46:55Z okcSDRmedia   ["Christmas music", "Gospel music", "Music"] ["harp", "synth pad", "romantic", "calming", "instrumental", "no voice"] 2 FKChZXXhufE 1636
Witcher 3 - 'Lullaby of Woe' The music features a female voice quietly singing a melody. A harp is accompanying the singer. Violins can be heard fading out from the beginning of the music excerpt. In the background one can hear the wind blowing softly. Towards the ending of the music excerpt a low pitch percussive sound can be heard. 2015-08-27T02:28:40Z BastianRP By Marcin Przybyłowicz. Not owned by me. Copyright CD Projekt RED. ["New-age music", "Music", "Lullaby"] ["quiet female voice", "harp", "strings", "wind sound", "still atmosphere", "low pitch percussive sound"] 2 OLy3C8YpMsY 2429
Send In The Clowns with Lyrics by tiny mouse The music features a female voice singing a melody while being accompanied by a harp and strings synth played on a keyboard. The music has a ternary feel which is being emphasized by the harp that plays 3 equal notes every beat. The keyboard strings synth plays harmony as well as a melody that towards the end of the music excerpt is played in unison with the singer's melody. 2011-01-23T01:39:36Z Starchicky12000 I in no way own this song, only the interpretation. This is one of my favorite show tunes! My heart goes out to Desiree :( I hope you enjoy! ~~Tiny Mouse ["New-age music", "Music"] ["female voice", "strings synth", "harp", "ternary feel", "slow-medium tempo"] 2 fgCTFyzKQtk 3968

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;