musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur quality recording" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- amateur quality recording · 4 ✖
- medium tempo 3
- instrumental music 2
- aboriginal music 1
- amateur band 1
- ambient noise 1
- ancient art form 1
- carnatic music 1
- deteriorated audio quality 1
- didgeridoo 1
- distorted guitar rhythm 1
- distortion 1
- double reed instruments 1
- double tonguing 1
- drone harmony tones 1
- emotional 1
- emotional music 1
- ethnic instruments 1
- fast 1
- flute playing 1
- groovy dance rhythm 1
- heavy breathing sounds 1
- hissing tones 1
- indian classical music 1
- indian dhol percussion 1
- indian traditional music 1
- indian wind instrument 1
- live performance 1
- love song 1
- lyrical melody 1
- male music video 1
- metal band 1
- nadaswaram playing 1
- no other instrumentation 1
- noise 1
- noisy ambience 1
- nostalgia 1
- passionate 1
- percussive rhythm 1
- percussive tones 1
- poignant music 1
- poor audio quality 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) 7 ✖
- Music 4
- Buzz 1
- Carnatic music 1
- Classical music 1
- Didgeridoo 1
- Folk music 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breed Sheep(Nirvana cover)territorial pissings and love buzz | The song is an instrumental. The song is fast tempo with distorted guitars playing in rhythm. The song is energetic and an amateurish performance. The song is of very poor quality with audio noise and hissing sound. | 2007-11-25T17:53:33Z | Kurt (Breed Sheep) | Breed Sheep playing territorial pissings and love buzz | ["Music", "Buzz"] | ["poor audio quality", "noise", "distortion", "hissing tones", "noisy ambience", "instrumental music", "distorted guitar rhythm", "fast", "amateur quality recording", "deteriorated audio quality", "metal band", "amateur band"] | 1 | 2ZB7DUGOdZw | 377 | |
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;