musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "jazz music" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- instrumental · 2 ✖
- jazz music · 2 ✖
- acoustic drums 1
- acoustic jazz drums 1
- avant-garde 1
- bass guitar 1
- chill 1
- electric guitar 1
- keyboard 1
- movie music 1
- outer space 1
- piano 1
- saxophone 1
- slow tempo 1
- swing 1
- theremin 1
- trumpet 1
- unique 1
- upright bass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HOW TO FIBERGLASS * The Real Deal * Simple Mold * Part 5 * The Series | This is a jazz music piece. It is an instrumental piece. The saxophone and the trumpet are playing the melody. The piano, the electric guitar and the bass guitar are accompanying them in the background. The tempo is slow. The atmosphere is chill. This piece could be playing in the background at a coffee shop. | 2011-10-13T00:12:26Z | GasserGlass | Part FIVE (5) of the Original YOUTUBE - HOW TO FIBERGLASS Series...... | ["Brass instrument", "Saxophone", "Trombone"] | ["jazz music", "instrumental", "saxophone", "trumpet", "electric guitar", "piano", "bass guitar", "acoustic drums", "slow tempo", "chill"] | 9 | IGyDtKAU1u8 | 1888 | |
Trekkie plays Star Trek theme on Theremin | This is an instrumental jazz music piece. The main theme is being played on a theremin while there is a keyboard and an upright bass in the melodic background. For the rhythm, there is an acoustic swing jazz drum beat. There is an avant-garde feel to this piece. It could be used in the soundtrack of a sci-fi movie or a TV show. It could also be played in the soundtracks of video games with an outer space setting. | 2009-04-27T19:53:42Z | diggsharrington | A super Star Trek fan plays the theme song on a Theremin. Yes, he's doing it live! The Theremin became popular when the Beach Boys used it in the song Good Vibrations. A little fun fact for ya! | ["Music", "Theremin"] | ["jazz music", "instrumental", "theremin", "keyboard", "upright bass", "acoustic jazz drums", "swing", "avant-garde", "unique", "outer space", "movie music"] | 9 | V0zQHNmz0gU | 2967 |
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;