musiccaps_details (view)
2 rows where musiccaps_aspects contains "banjo", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- banjo · 2 ✖
- moderate tempo · 2 ✖
- amateur recording 1
- announcement 1
- bluegrass 1
- double bass 1
- guitar 1
- happy mood 1
- instrumental 1
- male voice 1
- mandolin 1
- no percussion 1
- no vocal melody 1
- no voices 1
- rock song 1
- romantic mood 1
- simple percussion 1
- tambourine 1
- violins 1
musiccaps_names (array) 6 ✖
- Banjo 2
- Bowed string instrument · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 |
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;