musiccaps_details (view)
3 rows where musiccaps_aspects contains "poor quality recording"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- poor quality recording · 3 ✖
- accordion 1
- acoustic drums 1
- ambient noises 1
- american 1
- background singing 1
- bass guitar 1
- cheerful 1
- clapping randomly 1
- distant music 1
- emotional 1
- exciting 1
- fun 1
- instrumental music 1
- lifetime experience 1
- live concert 1
- male vocal 1
- noise 1
- pastoral 1
- people cheering 1
- piano accompaniment 1
- poor audio quality 1
- private video 1
- rapid singing 1
- slow tempo 1
- song introduction 1
- strong bass line 1
- tambourine rhythm 1
- tribal/traditional feeling 1
- upbeat 1
- whistling tones 1
- yodeling 1
musiccaps_names (array) 5 ✖
- Music 3
- Applause 1
- Music of Latin America 1
- Tambourine 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Аплодисменты Легенде №17 | The song is an instrumental. The tempo is slow with a piano accompaniment and a strong bass line, with people clapping , whistling, and cheering. The song is being played at a live arena with people getting excited to the song introduction. | 2013-04-19T06:39:31Z | Central Partnership | По окончании фильма "Легенда №17" переполненный зал кинотеатра "Октябрь" взорвался аплодисментами. | ["Applause", "Music"] | ["people cheering", "poor audio quality", "private video", "poor quality recording", "fun", "exciting", "emotional", "lifetime experience", "song introduction", "whistling tones", "instrumental music", "slow tempo", "clapping randomly", "noise", "ambient noises", "piano accompaniment", "strong bass line", "distant music", "live concert"] | 1 | XE4NRSDLYG8 | 3168 | |
AS DVID DID - Tambourine INTERMEDIATE Patterns | A lot of tambourines are playing in synchronicity. In between the rhythm a choir is singing a short phrase. This song may be played as a tutorial to follow along. | 2014-09-11T11:58:55Z | Rosita AP | Conducting Tambourine Workshop at Kg.Piasau Church, Kota Belud, Sabah in May 16-18 May 2014. | ["Music", "Tambourine"] | ["tambourine rhythm", "poor quality recording", "background singing", "tribal/traditional feeling"] | 6 | gDnJoHpSL4M | 4016 | |
Chicken Yodel - Kerry Christensen | This is a poor quality recording of a yodeling music piece. There is a male vocalist singing rapidly with the yodeling technique. The melody is being played by an accordion. There is a bass guitar playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is cheerful. Despite the quality issue of the recording, it would suit well as a rural radio station music playing inside the car in a movie. | 2007-06-23T22:30:16Z | UnitedFan4Eva1 | Using RuneScape. Thanks To Madcrazykid1 ( Me ) MollyMoo22 ( My Sis ) --They are the main people-- If you wanna contact me, my MSN is josh.dude-@hotmail.co.uk Thanks! | ["Yodeling", "Music", "Music of Latin America"] | ["poor quality recording", "yodeling", "american", "male vocal", "rapid singing", "accordion", "bass guitar", "acoustic drums", "cheerful", "pastoral", "upbeat"] | 9 | s25X6KwBpxw | 4916 |
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;