musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass drum" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- bass drum · 2 ✖
- moderate tempo · 2 ✖
- accordion 1
- amateur audio 1
- bagpipes 1
- folk song 1
- hand claps 1
- instrumental 1
- low quality audio 1
- no voices 1
- orchestra song 1
- scottish tenor drum 1
- tambourine 1
- trumpets 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hard Rock Blues | This amateur recording features trumpets playing the main melody. This is accompanied by the bass drum playing one beat on alternate counts and two beats on the remaining alternate counts. Hand claps are played on alternate counts. Other instruments are not audible due to the low audio quality. | 2009-01-21T02:15:23Z | imamousecp | This is a school concert I had in my beginning year of Band. I am the Trombone player that you can clearly see when all of the trombone players stand up. I am sorry if you are offended at how bad we are. I know... we suck. | ["Orchestra"] | ["amateur audio", "low quality audio", "hand claps", "trumpets", "bass drum", "moderate tempo", "orchestra song"] | 0 | X1KJfb5xhr4 | 3157 | |
Emigrantes Gallegos - Música tradicional - Gaitas | This Scottish folk song features bagpipes playing the main melody. This is accompanied by an accordion playing the same melody in harmony. A Scottish tenor drum plays a marching beat. A bass drum plays strokes on the count. A tambourine plays a beat in the background. This song can be played in a Scottish folk programme. | 2009-06-14T18:31:52Z | Consuelo María Luján Rodríguez | Grupo de Música Emigrantes Gallegos, más información en http://www.emigrantesgallegos.com.ar - contrataciones disponibles. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["folk song", "bagpipes", "scottish tenor drum", "bass drum", "tambourine", "accordion", "no voices", "instrumental", "moderate tempo"] | 0 | yfaxqwNHe7w | 5429 |
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;