musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast paced percussion" and musiccaps_aspects contains "low quality audio"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- fast paced percussion · 2 ✖
- low quality audio · 2 ✖
- distortion guitar 1
- electric guitar 1
- fast tempo 1
- fast tempo song 1
- folk rock 1
- instrumental 1
- male voice 1
- no voices 1
- staccato violin 1
- trumpet song 1
- uptempo 1
- workout song 1
musiccaps_names (array) 7 ✖
- Maraca 1
- Music 1
- Music of Latin America 1
- Roll 1
- Salsa music 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arcade Fire (live) - "Poupee de Cire, Poupe de son" | This folk rock song features an electric guitar playing the main melody in the form of a solo. This is accompanied by fast paced percussion. Another guitar plays a galloping rhythm. A violin plays staccato notes at a fast tempo and the notes follow the root notes of the chords but at higher octaves. This is an instrumental song with no voices. This song has a hippie feel. This song can be played in a retro movie with a hippie theme. | 2007-10-04T15:11:40Z | Ismael Fernandez | A "new" song from Arcade Fire performed at the Olympia Theater in Paris. It's a cover of an old song. http://www.youtube.com/watch?v=8OHJEm2IwLw | ["Singing", "Music", "Roll"] | ["folk rock", "no voices", "instrumental", "fast tempo", "low quality audio", "electric guitar", "distortion guitar", "fast paced percussion", "staccato violin", "uptempo"] | 0 | 752bW5cjXzw | 808 | |
Zumba Michelle Marco Island (Da La Vuelta) | This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple but fast paced beat. Trumpets are featured in this song playing fills at high pitch. This song can be played in an aerobics workout session where fast movements are required. | 2010-09-18T04:28:34Z | Michelle Jordan | Choreography by Michelle Jordan | ["Song", "Music of Latin America", "Salsa music", "Maraca"] | ["low quality audio", "fast tempo song", "male voice", "trumpet song", "fast paced percussion", "workout song"] | 0 | jIoDR_eskaU | 4245 |
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;