musiccaps_details (view)
5 rows where musiccaps_names contains "Pop music" and youtube_description = " "
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pussycat Dolls - Beep (Live) | The song is an upbeat pop song with a slight hip hop influence. It's a live performance and features a breathy, seductive female vocalist. The backup singers almost chant or laugh in a staccato way that creates a vocal riff. There are string instruments in the background. This is a live performance. | 2010-08-29T11:39:18Z | Suniuke | ["Music of Asia", "Music", "Pop music"] | ["live performance", "laughing vocals", "seductive female pop vocals", "strings motif", "pop dance music", "upbeat", "breathy female vocals", "hip hop"] | 3 | NsYVaRI6rXg | 2373 | ||
Ngar nay yar - Zay ye, Ye Yin aung | a pop hip hop track in a boy band style with harmonized male vocals, skittering hi-hat pattern, and an 808 style bass. Would appeal to international teens. | 2012-02-28T14:50:02Z | littleskyzks | ["Singing", "Music", "Pop music", "Zing"] | ["hip hop", "trap", "skittering hi-hat pattern", "boy band", "male harmonized singing", "teen", "pop", "808 bass", "international"] | 8 | Q789S_9JCio | 2596 | ||
Turkish Pop Dance Music | The drums is playing a beat that reminds of a slower version of reggaeton along with some shakers and other percussive elements that are slightly panned to the right side of the speakers. An e-bass is helping to create a mood for dancing. A plucked string instrument is playing an oriental melody accompanied by a string-section playing along and adding little melody-licks. You can hear some backing vocals shouting to the rhythm. This song may be playing at a cafe. | 2010-12-28T06:44:31Z | gagangahra1 | ["Music", "Pop music", "Music of Bollywood", "Dance music"] | ["turkish pop/dancemusic", "e-bass", "electronic drums", "plucked strings", "male sample shouting", "strings", "medium tempo"] | 6 | RcfaWoTywcA | 2714 | ||
yongseo arab fan- (عالبال (سميرة سعيد | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | 2011-09-20T18:50:38Z | yasmin ali | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | 1 | aOGNUGgTQ8k | 3534 | ||
少女時代 (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
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;