musiccaps_details (view)
3 rows where musiccaps_aspects contains "hand claps", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- hand claps · 3 ✖
- low quality audio · 3 ✖
- moderate tempo · 3 ✖
- percussion 2
- trumpets 2
- amateur audio 1
- bass drum 1
- bass guitar 1
- celebration song 1
- choir 1
- contemporary gospel song 1
- crowd noise 1
- happy mood 1
- holiday song 1
- male voice 1
- orchestra song 1
- piano 1
- string section 1
- tambourine 1
musiccaps_names (array) 4 ✖
- Orchestra 2
- Music 1
- Singing 1
- Tambourine 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 | |
Jingle Bells - Auckland Symphony Orchestra | This song features the main melody sung by a choir. This is accompanied by the string section and brass section featuring violins and trumpets. Hand claps are heard on every count. Orchestral percussion plays in the background. As the quality of audio is low, many instruments cannot be heard. This song can be played in a celebration. | 2008-12-09T09:20:44Z | Calum Anderson | The Auckland Symphony Orchestra along with a combined choir perform Jingle Bells at their annual Christmas concert in the Auckland Town Hall in 2008. | ["Orchestra"] | ["celebration song", "holiday song", "string section", "low quality audio", "hand claps", "choir", "trumpets", "percussion", "moderate tempo", "happy mood"] | 0 | bQ9vpp_yXvk | 3624 | |
Saturday Night Revival Service ,Singing,Shouting, and Praising | This is a low audio clip. This song is a contemporary gospel song. This song features a male voice. This is accompanied by a tambourine and hand claps. The bass plays the root notes of the chords. The piano plays chords and fills. The sounds of the crowd are heard in this clip. The tempo of this song is moderate. | 2011-04-17T06:35:32Z | Joe Estep | sharts rd road good church video people from kentucky such as wayne Gifford and his people from his church for A 3 day revival service.praising the Lord Jesus Christ 4-15-2011 holiness joe estep | ["Singing", "Music", "Tambourine"] | ["low quality audio", "percussion", "contemporary gospel song", "hand claps", "crowd noise", "tambourine", "bass guitar", "male voice", "piano", "moderate tempo"] | 0 | kAE7Ceg4VgQ | 4303 |
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;