musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "trumpet" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drums 2
- bass guitar 2
- electric guitar · 2 ✖
- trumpet · 2 ✖
- chewing 1
- chill 1
- explosions 1
- instrumental 1
- jazz 1
- jazz music 1
- jovial 1
- piano 1
- playful 1
- saxophone 1
- slow tempo 1
- sound effects 1
- squeaking 1
- xylophone 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 | |
SkylanderDude VS the big green fat pig angry birds space | This is a jazz piece played in the background of a video game. A trumpet plays the main melody while a xylophone and a bass guitar is supporting the tune in the background. A playful jazz drum beat carries the rhythmic background. Occasional electric guitar fills in the form a strum can be heard. There are a lot of sound effects related to the game such as squeaking, chewing and explosions. | 2012-07-30T19:33:03Z | SkylanderDudeFilms | ewww. over cooked popcorn | ["Music", "Oink"] | ["jazz", "trumpet", "acoustic drums", "xylophone", "electric guitar", "bass guitar", "sound effects", "squeaking", "chewing", "explosions", "playful", "jovial"] | 9 | BkOfrw3c3EE | 1284 |
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;