musiccaps_details (view)

3 rows where musiccaps_aspects contains "female voices" 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
James Delleck Pigeon teaser. The music features for the most part an instrumental that makes use of synth sounds and a drum beat using sampled drums and claps. Towards the end of the music excerpt a female voice starts singing a simple melody and another female voice can be heard singing brief interventions in the background. The music is highly accentuated. 2015-10-02T09:42:21Z XXII 360 « Pigeon » by James Delleck pigeon-paris.com horam\vr : www.horamvr.com More about James Delleck : https://fr.wikipedia.org/wiki/James_Delleck Music by TheRabbots "Someday" Description : Horam \ vr and French rapper James Delleck have worked together to produce one of the very first French music videos in virtual reality. We used no fewer than 10 wide-angle cameras and all our artistic know how to achieve our goal. The result is a clip that reaches the highest standards of technique and artistic quality. See for yourself : 48 frames per second for perfect fluidity and 4K resolution for accurate image sharpness as well as a perfect restitution of textures ! ["Disco", "Music"] ["synth sounds", "drum beat", "female voices", "sampled claps", "accents"] 2 7-mNJ4IUY5Q 801
Sunlight liquid The music features a group of female voices singing a melody in unison. The instrumental consists of only percussion drums, African percussion drums to be precise. A shaker can also be heard sounding on every beat. In the background one can hear water sounds. The overall atmosphere is cheerful and uplifting. 2013-09-11T13:16:26Z B&S Studios ["Music of Africa", "Liquid", "Music", "Drip", "A capella"] ["female voices", "unison", "african percussion", "shaker", "water sounds", "cheerful", "uplifting"] 2 Zz1Bz1a7yPE 3432
少女時代 (SNSD) Girls' Generation HOOT PV The music features a group of female voices singing the same melody in unison. The drums and bass guitar blend together and drive the pulse of the music. In the first half of the music excerpt strings play the same melody as the singers. 2010-11-19T22:58:32Z randomlife2004 ["Echo", "Music", "Pop music"] ["female voices", "unison", "drums", "bass guitar", "strings"] 2 pWms_9wpRB4 4717

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;