musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "energetic" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- amateur recording · 4 ✖
- energetic · 4 ✖
- electronic drums 2
- live performance 2
- loud 2
- poor quality 2
- upbeat 2
- zumba 2
- acoustic drums 1
- bass guitar 1
- dance music 1
- electric guitar 1
- electronic dance 1
- female vocal 1
- female voice 1
- keyboard 1
- latin dance music 1
- loud electronic drums 1
- male vocal 1
- melodic singing 1
- movie theme 1
- mysterious 1
- rebellious 1
- rising pattern 1
- rock music 1
- shouting 1
- strings 1
- strong bass 1
- synth 1
- vocal sample 1
musiccaps_names (array) 12 ✖
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 | |
Justice - Stress (live at sónar08) | This is a live performance of an electronic dance music piece. There is a vocal sample repeating the same line. A synth is playing the tune while the electronic drums are playing the rhythm. There is a rising pattern and an energetic atmosphere. If it were not for the poor quality of the recording, this piece would fit nicely at a nightclub. | 2008-06-23T11:12:06Z | djfmv | Justice live! @ Sónar 2008, Barcelona (20.6.08) by DJF | ["Electronic music", "House music", "Crowd", "Music", "Bang"] | ["electronic dance", "live performance", "amateur recording", "vocal sample", "synth", "rising pattern", "electronic drums", "loud", "energetic", "upbeat", "poor quality"] | 9 | G22YfD5xxMU | 1687 | |
Mas - Ruido Rosa en el Vive Latino 2011 | This is an amateur recording of a live rock music performance. There is a female vocalist singing in the lead. The electric guitar is playing the main melody with a bass guitar in the background. There is a fast-paced and loud acoustic drum beat in the rhythmic background. The atmosphere is loud and rebellious. | 2011-04-12T02:37:35Z | Ricardo Garcia | Ruido Rosa haciendo honor a su nombre, bien por la fuerza de su baterista!!! | ["Music", "Pink noise", "Distortion"] | ["rock music", "amateur recording", "live performance", "female vocal", "electric guitar", "acoustic drums", "bass guitar", "loud", "rebellious", "energetic"] | 9 | Lg1HG6D_0Qk | 2213 | |
Zumba Kids with Krisi - Ghostbusters | This is an amateur recording of a dance performance. There is a zumba dance music version of a movie theme playing in the background. The melody is being played by the strings and the keyboard while there is a loud electronic drum beat for the rhythm. There is a mysterious yet energetic feel to this piece. The recording quality is not that great. However, this piece could still be used to gather samples for beat-making. | 2013-07-07T20:18:05Z | Krisenci Petrova | festival RACycle 2013 | ["Music", "Theremin", "Inside, public space"] | ["zumba", "dance music", "movie theme", "amateur recording", "strings", "keyboard", "electronic drums", "mysterious", "upbeat", "energetic"] | 9 | OPX9ukYun3o | 2436 |
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;