musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- amateur recording · 5 ✖
- medium to uptempo 2
- acoustic piano 1
- beatbox 1
- cheerful atmosphere 1
- clarinet 1
- classical 1
- crowd cheering 1
- drums 1
- energetic 1
- female voice 1
- gospel 1
- horn 1
- jazzy 1
- kazoo 1
- latin dance music 1
- loud electronic drums 1
- male vocal 1
- male voice singing 1
- melodic singing 1
- piano 1
- poor quality 1
- shouting 1
- slower to medium tempo 1
- strong bass 1
- trumpet 1
- zumba 1
musiccaps_names (array) 13 ✖
- Inside, large room or hall · 5 ✖
- Music 5
- Harmonic 2
- Keyboard (musical) 2
- Accordion 1
- Beatboxing 1
- Foghorn 1
- Music of Latin America 1
- Musical instrument 1
- Piano 1
- Singing 1
- Speech 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zumba Drop it | This is an amateur recording of a dance performance over a latin dance music piece in the style of zumba. There is a female dance instructor shouting directions to the dancers. There is a male vocalist singing melodically in the background piece. A strong bass and a loud electronic drum beat can be heard very distinctly. The atmosphere is energetic. The quality of the recording is quite poor. | 2008-04-02T01:02:49Z | skyemi | Drop it by Ricky Martin Visit www.zumbakids.com Zumbawithcathya@qx.net | ["Singing", "Music", "Music of Latin America", "Inside, large room or hall"] | ["latin dance music", "zumba", "amateur recording", "poor quality", "female voice", "shouting", "male vocal", "melodic singing", "strong bass", "loud electronic drums", "energetic"] | 9 | -_6RxZyi30Q | 63 | |
Joel Turner Live. Coke Live 2006 | This audio contains someone beatboxing. Then a male voice starts singing loud and at a higher pitch. The crowd is cheering in the background. This song may be playing live during a beatbox performance. | 2006-04-15T06:32:50Z | lynxplayuh | Joel Turner Live. Coke Live 2006 | ["Beatboxing", "Music", "Speech", "Vocal music", "Inside, large room or hall"] | ["amateur recording", "beatbox", "male voice singing", "crowd cheering", "medium to uptempo", "cheerful atmosphere"] | 6 | ByF0pp-dVEo | 1309 | |
Let go Let God | This audio contains someone playing a gospel/jazz melody when a very loud drum comes in with a fill-in on the toms. This is an amateur recording and of poor audio-quality. This song may be playing in a gospel church. | 2009-02-21T06:32:49Z | tonyhoustonl | the whole dance of let go let god hope you enjoy. | ["Music", "Keyboard (musical)", "Harmonic", "Inside, large room or hall"] | ["amateur recording", "gospel", "piano", "drums", "jazzy", "slower to medium tempo"] | 6 | ESbtW0CUmp4 | 1559 | |
A Hawk and a Hacksaw - Serbian Cocek | This piece contains someone playing a trumpet, a clarinet and a horn all playing the same note in different octaves. The horn is playing a bassnote. This song may be playing live as a school concert. | 2009-07-16T08:11:54Z | videochemist | Duke of York's, Brighton 16/06/09 (3 of 11) From their 2007 album A Hawk and A Hacksaw and the Hun Hangár Ensemble. | ["Foghorn", "Music", "Accordion", "Inside, large room or hall"] | ["amateur recording", "trumpet", "horn", "clarinet"] | 6 | Q8QXzYpl6Tw | 2598 | |
Kazoo Solo - The Ode to Joy by Beethoven | Someone is playing a classical piece on the acoustic piano while someone is playing/singing along with a kazoo. This song may be playing in a live concert. | 2008-02-13T14:50:31Z | Kazoo | A student from Emmanuel College, University of Cambridge, performs Beethoven's Ode to Joy from his 9th Symphony, Opus 125. | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Harmonic", "Inside, large room or hall"] | ["classical", "acoustic piano", "kazoo", "amateur recording", "medium to uptempo"] | 6 | ikJKSqnTylI | 4217 |
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;