musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "piano" and musiccaps_aspects contains "saxophone"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- acoustic drums · 2 ✖
- piano · 2 ✖
- saxophone · 2 ✖
- bass guitar 1
- chill 1
- e-bass 1
- e-guitar 1
- electric guitar 1
- electric organ 1
- instrumental 1
- jazz music 1
- male soul voice singing 1
- medium to uptempo 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 | |
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;