musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "percussion", musiccaps_author = 0 and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- instrumental 2
- no voices 2
- percussion · 2 ✖
- big band jazz 1
- double bass 1
- easy listening 1
- fast tempo 1
- guitar 1
- lead guitar 1
- low quality audio 1
- moderate tempo 1
- piano 1
- reed instrument 1
- rock and roll 1
musiccaps_names (array) 11 ✖
youtube_published (date) 2 ✖
- 2006-12-12 1
- 2011-01-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Lunch an Animated Parable in HD (VeggieTales) | This jazz song features the main melody played on a reed instrument and a guitar in unison. The melody is an ascending pattern of three notes per beat. This is accompanied by percussion playing a simple beat ending on an extended drum roll. The bass plays a descending run followed by an ascending run. The piano plays jazz chords in the background. There are no voices in this instrumental song. This song can be played in a luxury bar. | 2011-01-19T20:35:07Z | Carlos Gonzalez | This Video is NOT made by me it was made by BigIdea Productions. Copyright BigIdea Productions. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["big band jazz", "percussion", "no voices", "instrumental", "piano", "reed instrument", "guitar", "double bass", "moderate tempo", "easy listening"] | 0 | _miAGxDX5FM | 3489 |
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;