musiccaps_details (view)
2 rows where musiccaps_aspects contains "live audience" and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- female singer 2
- live audience · 2 ✖
- live performance 2
- ambient crowd noise 1
- bad audio quality 1
- big band plays 1
- big show 1
- big stage 1
- blues music 1
- blues turnaround 1
- brass band 1
- crowds sing along 1
- diva 1
- fret noise 1
- guitar notes playing 1
- guitar playing 1
- hissing ambient sound 1
- horn section 1
- huge arena 1
- jazz music show 1
- lilting vocals 1
- love song 1
- madly in love 1
- medium tempo 1
- memdium tempo 1
- orchestra plays 1
- passionate 1
- percussion hits 1
- poor audio quality 1
- pop diva 1
- pop music 1
- pop song 1
- pop super hits 1
- romantic 1
- singer talking 1
- song introduction 1
- soul music 1
- soul singer 1
- syncopated rhythms 1
- violin solo 1
musiccaps_names (array) 6 ✖
- Inside, large room or hall · 2 ✖
- Music 2
- Singing 2
- /t/dd00004 1
- Inside, public space 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
JENNY RIVERA EN MONTERREY 2012 DICIEMBRE | A female singer sings in a huge arena live along with crowds singing along with her in vocals. The song is medium tempo with steady drumming rhyme and giant drum rolls, violin playing solo, a brass band section and orchestra playing along. The song is energetic, cheerful and highly popular. The audio quality is very poor with heavy ambient crowd noises. | 2012-12-12T14:11:53Z | A CH | Jenni Rivera En La Arena Monterrey 8 de Diciembre 2012, ULTIMA PRESENTACION EN CONCIERTO, aqui un resumen.... https://www.youtube.com/watch?v=L7oF9oG3LIM ---- No Copyright infringement intended. I do not own this music. "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Singing", "Music", "Pop music", "Inside, large room or hall", "Inside, public space"] | ["live performance", "female singer", "bad audio quality", "syncopated rhythms", "medium tempo", "pop music", "huge arena", "crowds sing along", "live audience", "diva", "memdium tempo", "orchestra plays", "violin solo", "horn section", "brass band", "percussion hits", "big show", "jazz music show", "pop music", "big stage", "big band plays"] | 1 | dHDosntsNho | 3772 |
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;