musiccaps_details (view)

3 rows where musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Christian 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
Be Strong ..xX This is an R&B/soul music piece. There is a whole mix of male and female vocals singing melodically. The tune is being performed by the keyboard while the electric guitar and the bass guitar are playing in the background. There is a slow tempo electronic drum beat in the rhythmic background. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie, especially during the scenes of resolution. 2006-10-28T13:51:06Z xxnicholsonxx a video made by me for heartbroken girls ["Christian music", "Music"] ["r&b", "soul", "remix", "male vocals", "female vocals", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "emotional", "dreamy", "slow tempo"] 9 MFxMPOAbUPA 2250
Jaar Project-dOar tu This is a Romanian pop music piece. There is a male vocalist singing with autotune. The melody is being played by a synth sound. There is a bass guitar playing a simple bass line while the rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a Romanian soap opera, especially during romantic scenes. 2009-08-25T17:51:29Z DyeNuZzA1 va place?... ["Christian music", "Music"] ["romanian pop music", "male vocal", "autotune singing", "synth sound", "bass guitar", "electronic drums", "slow tempo", "sentimental"] 9 b2-izZk5_BM 3598
opm christmas song (megamix) ft.dj klu - part 2 This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. 2009-09-11T06:15:35Z edwell143 wala lang trip lang to.ramdam ko kasi pasko na..advance merry christmas sa inyong lahat... ["Christmas music", "Music of Asia", "Christian music", "Music"] ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] 9 lZavPVn7O4Q 4409

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;