musiccaps_details (view)
3 rows where musiccaps_names contains "Bluegrass" and musiccaps_names contains "Steel guitar, slide guitar" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic guitar 2
- amateur recording 2
- male voice 2
- acoustic drums 1
- acoustic guitars 1
- calm 1
- country music 1
- e-bass 1
- easygoing 1
- folk song 1
- instrumental 1
- mellow tune 1
- mid range singing 1
- moderate tempo 1
- no singer 1
- psychedelic 1
- relaxing 1
- romantic feel 1
- shaker 1
- singer-songwriter 1
- soft percussion 1
- steel guitar 1
- trippy 1
- uptempo 1
- violin 1
musiccaps_names (array) 7 ✖
- Bluegrass · 3 ✖
- Music 3
- Steel guitar, slide guitar · 3 ✖
- Acoustic guitar 1
- Country 1
- Musical instrument 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chords'n'Coffee - Never Ringing Doorbell | Acoustic guitars are strumming chords while a male voice is singing with his full voice but not loud. A bass is supported along with some very soft percussion that are barely noticeable. This song may be playing with friends at a bonfire. | 2013-12-08T21:30:41Z | ChordsnCoffee Wien | Band: Chords'n'Coffee . Acoustic Band from Vienna/Austria Song: Never Ringing Doorbell - live on a rooftop terrace Camera: Peter Paulhart, Felix Huber - Black Coffee Sound: Torge Karstens | ["Country", "Music", "Steel guitar, slide guitar", "Bluegrass"] | ["singer-songwriter", "acoustic guitars", "e-bass", "male voice", "mid range singing", "soft percussion", "amateur recording", "uptempo"] | 6 | eBF0zRHCbZE | 3850 | |
Derick Mar09 Irish Heartbeat | This folk song features a male voice singing the main melody. This is accompanied by an acoustic guitar. A shaker plays in place of the percussion. Violins play a melody in the background. The mood of this song is romantic. This song can be played in a flashback scene of a movie. | 2009-04-10T22:33:44Z | Ken Persson | Copyright music and lyrics reproduced by kind permission of Exile for original, exclusive performances by Van Morison, check-out the official channel at www.youtube.com/officialexilefilms. Recorded at a practice of Irish Street for a St Patrick's Day performance at Muldoon's. From L to R, Eileen, bodhran, Derick, vocals & guitar, Margaret, accordion, Brendan, fiddle, and Ken, whistle. | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Bluegrass"] | ["amateur recording", "acoustic guitar", "male voice", "shaker", "violin", "folk song", "romantic feel", "moderate tempo"] | 0 | etmmUjsRNRs | 3903 | |
How to play steel guitar lesson 19 | This is a country music piece that is played in an instrument lesson recording. The steel guitar is playing a mellow tune while at the forefront while there is a backing composed of the acoustic guitar and the acoustic drums. There is a relaxing and psychedelic feel to the piece. This music could suit well in the soundtrack of a feelgood/comedy movie. It could also be playing in the background at a shopping mall. | 2008-07-24T15:02:22Z | bobbeseymour | Bobbe Seymour shows more stuff at Steel Guitar Nashville | ["Music", "Musical instrument", "Steel guitar, slide guitar", "Bluegrass"] | ["country music", "no singer", "instrumental", "steel guitar", "mellow tune", "acoustic guitar", "acoustic drums", "easygoing", "calm", "relaxing", "psychedelic", "trippy"] | 9 | SvsCM0fLM5g | 2795 |
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;