musiccaps_details (view)
7 rows where musiccaps_aspects contains "live concert"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| real nice beatbox clip | Low fidelity recording of a live concert. The crowd noise is very loud and the audience is screaming. The audio is distorting. Amidst the crowd noise, beat boxing can be heard performing a house music style beat. | 2007-07-13T18:12:24Z | Junior Defossez | this is a real nice beatbox clip | ["Beatboxing", "Music", "Bellow", "Hip hop music"] | ["live concert", "beatboxing", "house music", "loud crowd", "audience screaming", "low fidelity recording", "audio distorting"] | 8 | 07-vpXo91XM | 122 | |
| 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 | |
| Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 | |
| Andy McKee explains fanned frets (Multi-scale Geometry) - Piermont, NY 3/3/09 (7/10) | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | 2009-04-11T05:55:32Z | Rael0505 | While preparing for Shanghai (as requested by someone in the audience), Andy McKee broke a string and began talking about his tour in Asia while restringing. Towards the end of the video he explains why the frets on his guitar are crooked, a question a lot of people are wondering. Basically, the fanned frets on his new Greenfield guitar are both comfortable ergonomically and provide more accurate intonation. And although he doesn't mention it in this video, fan frets handle dropped tunings much better than regular frets do (and since Andy plays in so many different alternate tunings, fanned frets must be a dream come true). Thicker strings are naturally designed for a wider scale length - I would say all guitars should be built this way, and for a lot of handmade instruments with more than 6 strings, they are mandatory. You can see him play Shanghai in the next video, linked below: http://www.youtube.com/watch?v=uuUeAwnTYzA&fmt=18 | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | 1 | cQX-WgT0ACQ | 3705 | |
| Adele crying at Royal Albert Hall - Someone like you live HD | A female pop star sings this lilting melody. The song is medium tempo with a piano playing accompaniment with a subtle bass line. The song is emotional and inspiring. The song is a modern pop hit played to a live audience. The song audio quality is poor and deteriorated. | 2012-09-29T19:17:31Z | Nil Iys | XL Records C. http://tinyurl.com/97zvsko Adele crying at Royal Albert Hall after singing someone like you! :) | ["Singing", "Christian music", "Music", "Song"] | ["female singer", "poor audio quality", "pop hit", "live concert", "emotional", "love song", "classic pop hits", "story telling", "live audience", "pop diva", "soulful singing", "piano accompaniment", "deteriorated audio quality", "hissing tones", "acoustic pop hits", "inspiring", "emotional", "love song", "motivational", "subtle bass line", "pop super hits", "modern pop", "hall reverb"] | 1 | nSinUcyFFqg | 4539 | |
| Young Afghan Traditional Ensemble: Naghmadokhana; Kabul 2013 | The song is instrumental. The tempo is medium with sitars and other stringed instruments playing in unison, tabla percussions and a harmonium playing the lead. The song is a classic hindustaani instrumental. | 2015-03-11T17:09:41Z | Safar Hochschule | Comp: Ustad Mohammad Omar, Rag Bahari, Tal Dadra FazilaZamir, Rohullah Baqizada, Samihullah Sarwari, Ahmadullah Nabizada, Ahmad Samim Zafar, Mostafa Darwishi, Eraj Khorasani | ["Tabla", "Music of Asia", "Music", "Musical instrument", "Sitar", "Bowed string instrument"] | ["instrumental music", "harmonium solo", "traditional indian instruments", "indian classical music", "tabla playing percussively", "sitar accompaniment", "y traditional indian instruments", "groovy rhythm", "exciting", "instruments in unison", "dance rhythm", "ancient traditional music", "passionate", "live concert", "live audience", "medium tempo", "hindustaani music"] | 1 | qsFfUzErXqw | 4829 |
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;