musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "synthesiser harmony" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- instrumental · 2 ✖
- synthesiser harmony · 2 ✖
- ambient auditorium sounds 1
- asian music 1
- bengali 1
- bengali pujo 1
- chanting 1
- chinese music 1
- conch shell 1
- cymbal riff 1
- dramatic music playing 1
- echo 1
- energetic drumming 1
- fast tempo 1
- flute 1
- hindu puja 1
- hindu rituals 1
- incoherent music 1
- indian language 1
- inferior audio quality 1
- intense music 1
- live performance 1
- male voice speaking 1
- om chant 1
- people talking 1
- reverb 1
- shell trumpet 1
- tambourine beats 1
- upbeat music 1
- vocalisation 1
- women chanting 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bibi Chowdhurani | Bangla Serial | Full Episode - 23 | Nibedita Biswas | Zee Bangla | This music is instrumental. The tempo is medium with a dramatic, intense and suspenseful synthesiser arrangement, cymbal riff and conch shell sound. The music is a background score for a Bengali movie / TV series with a male voice giving instructions, a Hindu priest chanting Om with women joining in with the chant and vocalisations and the sound of the conch shell. | 2014-05-23T17:43:06Z | Zee Bangla | Paid Subscription Zee5 click here: https://bit.ly/32gxIJ4 বিবি চৌধুরানী - Bibi Chowdhurani | Bangla TV Serial | Full Epi - 23 | Zee বাংলা To Free Download ZEE5 Mobile app click the link below Playstore: http://bit.ly/Zee5PlayStore iTunes: http://bit.ly/Zee5ITune | ["Wind instrument, woodwind instrument", "Shofar"] | ["instrumental", "vocalisation", "male voice speaking", "shell trumpet", "hindu rituals", "hindu puja", "bengali pujo", "chanting", "conch shell", "shell trumpet", "dramatic music playing", "intense music", "cymbal riff", "synthesiser harmony", "indian language", "bengali", "om chant", "women chanting"] | 7 | I6eU2qRjJ7Y | 1875 | |
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 |
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;