musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording", musiccaps_author = 9 and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- amateur recording · 4 ✖
- live performance 3
- melodic singing 3
- acoustic drums 2
- crowd cheering 2
- applause 1
- bass guitar 1
- electric guitar 1
- emotional 1
- energetic 1
- female choir 1
- female vocal 1
- female voice 1
- keyboard 1
- latin dance music 1
- loud electronic drums 1
- male vocal 1
- male vocals 1
- poor quality 1
- pop music 1
- reggae 1
- shouting 1
- slow tempo 1
- strong bass 1
- zumba 1
musiccaps_names (array) 11 ✖
- Music 4
- Singing · 4 ✖
- Ambient music 1
- Applause 1
- Bang 1
- Choir 1
- Crowd 1
- Inside, large room or hall 1
- Music of Latin America 1
- Pop music 1
- Reggae 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 | |
Goldfinger - Spice *LIVE* performance at Reggae Sumfest 2009 | This is the live performance of a reggae piece. There is a female vocalist in the lead singing melodically. The keyboard can be heard playing the main melody. The bass guitar is playing a simple but groovy bass line. In the rhythmic background, there is a slow tempo acoustic drum beat. The atmosphere is emotional. This is an amateur recording and a bit dated, so the audio quality is quite poor. | 2009-07-31T17:41:45Z | Chris Goldfinger | Spice it up! Spice live on stage at Reggae Sumfest 2009 | ["Singing", "Music", "Reggae", "Ambient music"] | ["reggae", "live performance", "amateur recording", "female vocal", "melodic singing", "keyboard", "bass guitar", "acoustic drums", "emotional", "slow tempo"] | 9 | Cn3xoxvbkF0 | 1401 | |
Lied der Abschlussklasse 2010 (Nena 99 Luftballons ) | This is the ending of a female choir performing on stage. It appears to be in a graduation ceremony setting. The crowd starts cheering and applauding the choir after the show is over. | 2010-06-27T17:02:11Z | tanjanicole123 | Lied der Abschlussklassen 2010 | ["Singing", "Applause", "Music", "Choir"] | ["amateur recording", "live performance", "female choir", "crowd cheering", "applause"] | 9 | PJUffXn-LIk | 2526 | |
Burning Up - Jonas Brothers - Jingle Ball 2012 | This is the live performance of a pop music piece. It is an amateur recording. There are male vocals singing melodically. An electric guitar strums a chord for the ending of a song while the sounds of the cymbals can be heard from the acoustic drums. The cheers of the crowd can be heard even more than the music itself. This recording could be sampled for use in beat-making. | 2012-12-03T00:47:17Z | Marielle Bravo-Saltzman | Last song performed by Jonas Brothers at Jingle Ball 2012 | ["Singing", "Crowd", "Music", "Pop music", "Bang"] | ["pop music", "live performance", "amateur recording", "male vocals", "melodic singing", "electric guitar", "acoustic drums", "crowd cheering"] | 9 | qxWVr67g6yY | 4839 |
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;