musiccaps_details (view)

4 rows where musiccaps_aspects contains "double bass" 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
幾可亂真的超強手繪 ! 神人 The instrumental music features an ensemble that resembles the orchestra. The melody is being played by a brass section while strings provide harmonic accompaniment. At the end of the music excerpt one can hear a double bass playing a long note and then a percussive noise. 2016-04-10T21:25:56Z AbNoRmALiTy 他只是在手掌上 畫了個圓後再上一些色彩， 就讓人驚呆了好幾秒， 太錯亂了！ 一起來看看超強的手繪立體作品吧! ["Music", "Thunk"] ["brass", "double bass", "strings", "instrumental", "no voice", "percussion"] 2 -5FoeegAgvU 11
Stray Cat Strut by The Nosey Joe Band The music features a male voice singing a descending melody that repeats. The instrumental consists of a drum kit that's playing a light rhythm, a double bass that's playing a repeating descending melody and an electric guitar that's strumming chords once per beat. The quality of the audio recording is not so good which leads me to believe this is an amateur recording and not something professional. 2008-05-28T02:57:13Z pookyfmr This is our version of the song made famous by the Stray Cats. ["Blues", "Singing", "Music", "Rock and roll"] ["male voice", "reverb effect", "electric guitar", "double bass", "drums", "low audio recording quality"] 2 FvQgVl5IBHw 1676
Game of Thrones Season 4 Soundtrack - 03 Breaker Of The Chains The instrumental music features a sort of calm before the storm. In the low register one can barely hear a double bass playing a long note softly. Another stringed instrument plays a short melody that fades out. A bigger group of strings then play a short long-note melody. The music is playing softly, almost quiet. This could work well as music for a movie scene. 2014-06-09T19:37:56Z TheGringoMedia Game of Thrones Original Sountrack. Music by Ramin Djawadi/ Sadzid Husic ["Music", "Scary music"] ["movie music", "low pitch sound", "strings", "calm before the storm", "instrumental", "no voice", "double bass"] 2 hoPnrbKOEl8 4142
W. Marsalis Quintet & R. Galliano - Sailboat In The Moonlight The jazz music features a piano improvising with somewhat thick textures. A double bass plays a laid-back melody in the low register, for the most time with one note every two beats. The drummer plays a light rhythm employing a brush technique, rather than using sticks. The music has a swing feel to it. 2013-03-30T16:50:40Z swamawi Wynton Marsalis Quintet & Richard Galliano - Sailboat In The Moonlight Jazz in Marciac Festival 2008 From the album: "From Billie Holiday To Edith Piaf :Live In Marciac CD+DVD" ["Jazz", "Music"] ["jazz genre", "improvisation", "piano", "double bass", "drums", "brush technique", "swing feel"] 2 qrP_H87vFpo 4826

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;