musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "rhythmic beat" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- medium tempo · 2 ✖
- rhythmic beat · 2 ✖
- alap 1
- ambient nature sounds 1
- background sounds 1
- carnatic music 1
- catchy 1
- chanting 1
- cheerful 1
- cheering 1
- chirpy 1
- controlled singing 1
- energetic drumming 1
- engaging 1
- happy 1
- indian classical 1
- instrumental 1
- keyboard harmony 1
- lively beat 1
- low quality sound 1
- lucid 1
- male singer 1
- merry 1
- mridangam rhythm 1
- muffled audio 1
- no lyrics 1
- people talking 1
- perfection 1
- pop song 1
- popular 1
- raga 1
- ragas 1
- rhythmic acoustic guitar 1
- simple 1
- sound of chatter 1
- sound of laughter 1
- south india 1
- south indian music 1
- tapping 1
- vocalisation 1
- voice control 1
- xylophone harmony 1
- ’ enjoyable 1
musiccaps_names (array) 4 ✖
- Music 2
- Carnatic music 1
- Folk music 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carnatic music at Sri kothandaramar temple, India | A male vocalist sings this alap or raga. The tempo is medium with a rhythmic mridangam accompaniment. The song is vocalised with the vocalist singing a melody using notes not lyrics. It is engaging, energetic and controlled. This song is a Carnatic Classical. | 2007-03-25T03:49:47Z | Anush Narayanan | Sriramanavmi Celebartions | ["Carnatic music", "Folk music", "Music"] | ["male singer", "medium tempo", "vocalisation", "alap", "raga", "controlled singing", "engaging", "no lyrics", "ragas", "carnatic music", "mridangam rhythm", "chanting", "indian classical", "south india", "south indian music", "sound of chatter", "lucid", "perfection", "voice control", "low quality sound", "rhythmic beat"] | 7 | e7WPFeDPFB4 | 3845 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;