musiccaps_details (view)
2 rows where musiccaps_aspects contains "banjo" and musiccaps_aspects contains "poor audio quality" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- banjo · 2 ✖
- poor audio quality · 2 ✖
- acoustic guitar 1
- banjo lead 1
- bluegrass 1
- country 1
- country music 1
- fast tempo 1
- folk 1
- folk song 1
- high pitched sounds 1
- home recording 1
- instrumental 1
- live recording 1
- lively 1
- melodious 1
- no accompaniment 1
- regional music 1
- southern country gospel music 1
- spirited 1
- stringed instrument 1
- twangy female vocalist 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 2
- Banjo 1
- Bluegrass 1
- Mandolin 1
- Steel guitar, slide guitar 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 | |
Molly Kennedy Beyond the Rain | This recording was done live, and the audio quality is poor. The style is country gospel or country worship music. There's a banjo being used to play arpeggios, and acoustic guitar strumming. The singer has a twangy and full-bodied female country voice. | 2014-06-04T09:49:19Z | Wellington Lloyd | Molly Kennedy at a birthday party in Bay Roberts N L.. | ["Music", "Mandolin", "Steel guitar, slide guitar", "Vocal music"] | ["live recording", "banjo", "acoustic guitar", "poor audio quality", "southern country gospel music", "twangy female vocalist"] | 3 | qW4kBJsudLI | 4794 |
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;