musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur quality recording" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- amateur quality recording · 3 ✖
- medium tempo · 3 ✖
- aboriginal music 1
- ambient noise 1
- ancient art form 1
- carnatic music 1
- didgeridoo 1
- double reed instruments 1
- double tonguing 1
- drone harmony tones 1
- emotional 1
- emotional music 1
- ethnic instruments 1
- flute playing 1
- groovy dance rhythm 1
- heavy breathing sounds 1
- indian classical music 1
- indian dhol percussion 1
- indian traditional music 1
- indian wind instrument 1
- instrumental music 1
- live performance 1
- love song 1
- lyrical melody 1
- male music video 1
- nadaswaram playing 1
- no other instrumentation 1
- nostalgia 1
- passionate 1
- percussive rhythm 1
- percussive tones 1
- poignant music 1
- romantic 1
- solo instrumentalist 1
- song introduction 1
- spirited 1
- stringed harmony 1
- stringed instrumental melody 1
- tambourine percussions 1
- techno drum rhythm 1
- wind instrument 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Natheswaram Thavil Kachcheri SMT 2015 | The song is an instrumental Indian classical tune. The song is medium tempo with two Indian double reed instruments called nadaswaram playing in a duet. The song is emotional and highly lyrical . The song is amateur quality recording and a classic Carnatic music tune. | 2015-02-11T08:27:22Z | Rasiah Sriravindrarajah | Srilankan Natheswaram and Thavil vidwans played famous songs at an Inisai Kachcheri at the Sydney Murugan Cultural Hall on 10th Feb. 2015. Listed to three songs at the end of the Kachceri. | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["carnatic music", "live performance", "nadaswaram playing", "medium tempo", "indian wind instrument", "double reed instruments", "emotional music", "lyrical melody", "ambient noise", "amateur quality recording", "indian classical music", "spirited", "passionate", "drone harmony tones"] | 1 | AjLX_1rBDPM | 1159 | |
Full Karaoke ( music track ) - Nepali folk duet song America green card ko khel of Ram Prasad Khanal | The song is an instrumental. The tempo is medium with a techno drumming rhythm, various string instruments playing melodies, flute playing, Indian dhol percussion and a tambourine playing percussively. The song is romantic and has Indian classical music influences. The song has poor audio quality. | 2015-10-26T01:14:41Z | Ram Prasad Khanal | Full Karaoke ( music track ) - Nepali folk duet song America green card ko khel of Ram Prasad Khanal | ["Folk music", "Music"] | ["instrumental music", "indian traditional music", "tambourine percussions", "indian dhol percussion", "stringed instrumental melody", "flute playing", "techno drum rhythm", "groovy dance rhythm", "nostalgia", "stringed harmony", "romantic", "love song", "song introduction", "amateur quality recording", "medium tempo"] | 1 | PTLOLz9YzmM | 2540 | |
EXPERIMENTAL BEATBOX: ethnic instruments. Didgeridoo. | The song is an instrumental. The song is medium tempo with a didgeridoo playing percussively with double tonguing motion and no other instrumentation. The song is emotional and meditative. The song is an aboriginal instrument played in a home studio. | 2012-09-24T17:51:19Z | Vladislav Ramanovsky | Vladislav Ramanovsky "Offbeat" http://vk.com/ramasails. More interesting videos here - http://www.youtube.com/Offbeatboxing - Experimental beatboxing SUBSCRIBE!!! https://plus.google.com/u/1/114037025738537505056/posts | ["Didgeridoo", "Music"] | ["didgeridoo", "solo instrumentalist", "percussive tones", "amateur quality recording", "ethnic instruments", "wind instrument", "double tonguing", "aboriginal music", "medium tempo", "emotional", "poignant music", "no other instrumentation", "percussive rhythm", "ancient art form", "male music video", "heavy breathing sounds"] | 1 | R4jlQEweREY | 2664 |
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;