musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "piano" and musiccaps_aspects contains "saxophone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- piano · 3 ✖
- saxophone · 3 ✖
- acoustic drums 2
- bass guitar 2
- chill 1
- drums 1
- e-bass 1
- e-guitar 1
- electric guitar 1
- electric organ 1
- instrumental 1
- jazz music 1
- male backing vocal 1
- male soul voice singing 1
- male voice 1
- medium to uptempo 1
- medium-fast tempo 1
- ska genre 1
- slow tempo 1
- soul/blues/jazz 1
- soulful 1
- trumpet 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 | |
Ska music band Skalingrad United Skajana | The ska music features a male voice singing and being accompanied by another male backing vocal. The tempo is medium-fast, specific to the ska genre. The drums play a somewhat busy rhythm and the bass guitar plays a simple repeating bass line. In the background a piano accompanies the singer. Towards the end of the music excerpt a saxophone can be heard. | 2013-07-12T17:09:02Z | tunapavel | Skalingrad United - original ska music from The Czech republic. Moreover - www.skajana.cz | ["Music", "Ska"] | ["male voice", "male backing vocal", "piano", "bass guitar", "drums", "ska genre", "medium-fast tempo", "saxophone"] | 2 | WPguqXCBQCI | 3092 | |
Try a little tendernes_The Commitmens | A male voice is singing loud and soulfully. A saxophone is playing a slight variation of the singer's melody. A piano is playing bluesy/jazzy chord chops accompanied by an electric organ playing along with the melody. Panned to the left side of the speaker, a e-guitar is playing one single chord as a rhythmic element. The e-bass is playing a line along with a simple rimshot and shakers that are barely noticeable. This song may be playing at a live concert. | 2010-09-27T10:52:20Z | dimosk100 | ["Singing", "Music", "Ska"] | ["soul/blues/jazz", "male soul voice singing", "e-guitar", "saxophone", "piano", "electric organ", "e-bass", "acoustic drums", "soulful", "medium to uptempo"] | 6 | dTVkk4GSmNA | 3790 |
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;