musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and "youtube_published" is on date 2010-09-14
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- percussion · 2 ✖
- bass 1
- celebration song 1
- chalk writing on blackboard 1
- happy mood 1
- keyboard 1
- keyboard stringsound 1
- male voices 1
- moderate tempo 1
- oriental 1
- reggae 1
- string instrument/violin 1
- tabla 1
- uptempo 1
- very poor recording quality 1
musiccaps_names (array) 3 ✖
- Music 2
- Carnatic music 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carnatic Music - Instrument - Master sathyanarayana keyboard 1 - On 13th Sep 2010 | This music sounds oriental full of semitones and quarter-notes that are used in oriental music. A violin is playing a melody along with the keyboard player also playing a stringsound. Another string instrument is playing along while fast paced, pitched percussion is playing a rhythm with a lot of fill-ins. This song may be played at a live concert or an cultural event representing a country or area of this country. | 2010-09-14T01:33:09Z | kvnvasu | Most gifted child artist playing keybord right from the age of six. Now only studying tenth standard. All music lovers should encourage and help him stay on this music world. when people debate whether it is possible to play carnatic music in keyboard he is playing with so much of ease and that too for more than 10years. He should get the world class awards. just spend few minutes. he already gave more than 700 concerts | ["Carnatic music", "Music"] | ["oriental", "string instrument/violin", "keyboard stringsound", "tabla", "percussion", "uptempo", "very poor recording quality"] | 6 | 9jeEfi6nDak | 1037 | |
Reggae Birthday Song | This reggae song features male voices singing the main melody in harmony. The clip starts off with the sound of a chalk writing on a board. This is followed by a percussion roll. The voices start singing the main melody. This is accompanied by percussion playing a reggae beat. The bass plays a reggae style bassline. The keyboard plays staccato chords in a reggae rhythm. The mood of this song is happy. This song can be played in a birthday scene in a movie when a family is on a holiday on an island. | 2010-09-14T20:42:56Z | bluemountainecards | Listen as these animated island characters sing happy birthday the raggae way. Hey mon "Happy Birthday!" View more like this: http://www.bluemountain.com/ecards/birthday.pd?c=bmasc62324 | ["Music", "Reggae"] | ["chalk writing on blackboard", "bass", "male voices", "percussion", "reggae", "happy mood", "celebration song", "keyboard", "moderate tempo"] | 0 | _Ra1Y6K7nSs | 3469 |
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;