musiccaps_details (view)
4 rows where musiccaps_aspects contains "incoherent music" and musiccaps_aspects contains "live performance" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- incoherent music · 4 ✖
- live performance · 4 ✖
- amateur recording 2
- ambient auditorium sounds 2
- clapping 2
- fast tempo 2
- inferior audio quality 2
- people talking 2
- steady drumming 2
- vocal backup 2
- ambient sounds 1
- asian music 1
- boomy bass 1
- chant like 1
- chanting 1
- chinese music 1
- christmas concert 1
- christmas song 1
- christmas time 1
- classic pop 1
- classical music 1
- classical song 1
- concert 1
- droning 1
- echo 1
- electric guitar riff 1
- emphatic vocals 1
- energetic drumming 1
- engaging 1
- enthusiastic 1
- extemporaneous 1
- female singer 1
- female vocal backup 1
- flute 1
- folk song 1
- heavy reverb 1
- hynoptic 1
- insistent 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- lilting 1
- live audience 1
- male singer 1
- male vocalist 1
- meditative 1
- medium fast tempo 1
- medium tempo 1
- melodic 1
- muddled sounds 1
- poor audio quality 1
- recurring vocal riff 1
- reverb 1
- small hand cymbals 1
- soothing 1
- synthesiser harmony 1
- tambourine beats 1
- teen singer 1
- upbeat music 1
- xylophone like instrument 1
- youthful 1
musiccaps_names (array) 12 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 | |
Lao Traditional Music 2013 4 (ຂັບທຸ້ມຫຼວງພະບາງ) | A female vocalist sings this loud chant like folk song in a foreign language. The tempo is medium fast with vocal backup, rhythmic small hand cymbals and xylophone like instruments. The audio quality is inferior so the music is incoherent. This song is a live performance or concert with ambient sounds. The song is loud, lilting, chant-like, meditative, droning, hynoptic, melodious and classical. This song is a Classical Laos Folk song. | 2013-04-27T04:36:46Z | vkone kone | ຂັບທຸ້ມຫຼວງພະບາງສະບັບເກົ່າ ນຳສະແດງໂດຍຄະນະສິນລະປະວັນນະຄະດີເຮືອນວັດທະນທຳພວງຈຳປາ ເນຶ່່່ອງໃນໂອກາດໄປສະແດງທີ່ປະເທດຝຮັ່ງ. | ["Folk music", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["female singer", "medium fast tempo", "lilting", "chant like", "droning", "hynoptic", "folk song", "classical song", "laos classical song", "laos folk song", "melodic", "extemporaneous", "incoherent music", "live performance", "ambient auditorium sounds", "people talking", "clapping", "amateur recording", "lao folk music", "vocal backup", "small hand cymbals", "xylophone like instrument", "classical music", "laotian classical music", "chanting", "meditative", "soothing"] | 7 | 8MbxazeMw2E | 917 | |
Ly cay bong - bieu dien: nhom No.1 | This music is instrumental. The tempo is fast with a melodious harmony with synthesiser arrangements, drumming, tambourine beats and some unidentifiable instruments.The audio quality is inferior with an incoherent audio. The music style is Asian/ Chinese. | 2009-08-24T14:33:37Z | Phuong Hai | ["Music", "Tambourine"] | ["instrumental", "fast tempo", "asian music", "people talking", "energetic drumming", "tambourine beats", "flute", "chinese music", "live performance", "synthesiser harmony", "inferior audio quality", "upbeat music", "ambient auditorium sounds", "echo", "reverb", "incoherent music", "people talking"] | 7 | s2iIZ2WNuKY | 4919 | ||
Ziggy Marley - Positive Vibration ( thx guys! :] ) | A male vocalist sings this energetic song. The tempo is fast with boomy bass lines, steady drumming, keyboard harmony and enthusiastic electric guitar riff with vocal backup. The audio quality is very bad and the song is muffled and muddy. This song is a live performance with ambient sounds of people clapping and cheering. | 2007-06-01T05:36:28Z | FSUSeaAngel | Ziggy Marley in West Palm Beach, FL | ["Vibration", "Music", "Rock and roll", "Music of Latin America"] | ["male vocalist", "fast tempo", "boomy bass", "enthusiastic", "insistent", "recurring vocal riff", "youthful", "engaging", "enthusiastic", "classic pop", "electric guitar riff", "female vocal backup", "steady drumming", "incoherent music", "inferior audio quality", "muddled sounds", "live performance", "concert", "amateur recording", "keyboard accompaniment"] | 7 | kZBFQAQI7Pg | 4328 |
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;