musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun" and musiccaps_aspects contains "people cheering" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- fun · 2 ✖
- instrumental music 2
- live concert 2
- people cheering · 2 ✖
- poor audio quality 2
- ambient noises 1
- bhangra music 1
- brass band 1
- brass instruments playing percussively 1
- cheerful 1
- cheering sounds 1
- clapping randomly 1
- dhol playing percussively 1
- distant music 1
- emotional 1
- exciting 1
- indian dance music 1
- indian folk music 1
- indian music 1
- indian percussions 1
- indian wedding band 1
- lifetime experience 1
- medium fast tempo 1
- noise 1
- piano accompaniment 1
- poor quality recording 1
- private video 1
- slow tempo 1
- song introduction 1
- strong bass line 1
- trimmings playing 1
- trumpets blaring 1
- wedding band 1
- whistling tones 1
musiccaps_names (array) 3 ✖
- Music 2
- Applause 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Red Baraat: NPR Music Tiny Desk Concert | The song is an instrumental with male vocalists cheering enthusiastically . The tempo is medium fast with a trombone and trumpet playing percussively and an Indian dhol playing percussively. The song is cheerful and energetic. The song is a traditional Indian folk style called Punjabi Bhangra music. The song has poor audio quality. | 2012-02-14T16:24:13Z | NPR Music | One of the best party bands around, Red Baarat plays rollicking funk music steeped in Northern India's wedding celebrations, with a dash of D.C. go-go beats and hip-hop. The dance-friendly group performs a loud, high-energy set at the NPR Music offices. Set List: "Chaal Baby" "Shruggy Ji" "Dhol 'n' Brass" For more videos and to subscribe to the Tiny Desk Concerts podcast, visit npr.org/tinydeskconcerts. | ["Music", "Wedding music"] | ["brass band", "instrumental music", "bhangra music", "dhol playing percussively", "indian percussions", "indian wedding band", "brass instruments playing percussively", "cheering sounds", "fun", "cheerful", "medium fast tempo", "indian dance music", "indian folk music", "wedding band", "live concert", "poor audio quality", "trumpets blaring", "people cheering", "trimmings playing", "bhangra music", "indian music"] | 1 | 0kQD1P0_KUs | 203 | |
Аплодисменты Легенде №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 |
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;