musiccaps_details (view)
4 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "no voices"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johnny Bagpipes Johnston | This amateur recording clip features the bagpipes playing a melody. This tune is played at a fast tempo and at a high pitch. There are no other instruments in this song. There are no voices in this song. This song is an instrumental. This song can be played in a village fair. The sound of the crowd cheering is heard throughout the song. | 2007-03-09T05:19:02Z | BleedingM4scar4 | comedian Johnny Bagpipes Johnston @ the Calgary Stampede (July 8, 2006) | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality audio", "bagpipes", "no voices", "no other instruments", "fast tempo", "sound of crowd", "instrumental"] | 0 | 0a6uLBmqZgA | 185 | |
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 | |
Redneck Jazz Explosion - Gatton & Emmons | This song features a guitar playing a solo. This is played in the style of a banjo in a bluegrass song. The guitar is playing fast licks. The bass plays the root note and lower fifth of the chords. A percussion plays a simple beat and ends with a crash. There are no voices in this song. This song is an instrumental song. Due to the low quality of the audio, other instruments cannot be identified. This song can be played in a bluegrass concert. | 2006-06-23T15:41:07Z | Brad Maestas | Rare footage of the Redneck Jazz Explosion band with Buddy Emmons www.dannygatton.com In this video you can see Danny playing his 1961 Gibson Les Paul Custom with the infamous hand-built Magic Dingus box | ["Jazz", "Music"] | ["bluegrass", "country style melody", "bass", "guitar song", "no voices", "instrumental", "guitar solo", "guitar played like a banjo", "fast tempo", "low quality audio"] | 0 | AD5Tc2TDCmM | 1084 | |
Masonics - Outside Looking In | This low quality audio features an electric guitar playing a solo. The sounds of the instruments are not clear due to the low audio quality. The percussion plays a fast beat in the background. There are no voices in this song. This song can be played in a car chase sequence in a movie. | 2006-12-12T13:44:19Z | beatsvillerecords | The Masonics perform "I'm on the Outside Looking In" at "The Cluny" in Newcastle-Upon-Tyne. | ["Music", "Musical instrument", "Pop music", "Pulse", "Percussion"] | ["rock and roll", "low quality audio", "percussion", "lead guitar", "no voices", "instrumental", "fast tempo"] | 0 | YqAsph_ouRM | 3314 |
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;