musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 4, musiccaps_names contains "Bluegrass" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- mono 2
- noisy 2
- accordion melody 1
- acoustic guitar melody 1
- acoustic rhythm guitar chords 1
- country blues 1
- elegant 1
- flat male vocal 1
- jazz 1
- manically arpeggiated steel guitar 1
- nostalgic 1
- passionate solo acoustic guitar melody 1
- sentimental 1
- simple double bass 1
- smooth 1
- sustained brass section 1
- vintage 1
musiccaps_names (array) 8 ✖
- Bluegrass · 3 ✖
- Mandolin · 3 ✖
- Music 3
- Banjo 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maxwell Swing by Texas Gypsies | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | 2012-07-31T05:33:50Z | maxwellswing | Original Gypsy Jazz tune by Texas Gypsies from the Cafe du Swing CD! www.texasgypsies.com Photos by John Heiman, Bruce Buhrow, Chad Windham,David Meadows | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | 4 | AmAThmRphk0 | 1168 | |
Best banjo player ever (Foggy Mountain Breakdown) | The low quality recording features a manically arpeggiated steel guitar. The recording is noisy and in mono, as it sounds like the player is practicing to execute the melody properly -probably recorded with a phone. | 2013-04-01T00:16:15Z | JesusLovesYou | 25 Worst Parents of All Time - https://www.youtube.com/watch?v=hBPSllGLYDw | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "manically arpeggiated steel guitar", "noisy", "mono"] | 4 | EZi80fUpBfE | 1570 | |
Walter Rhodes - The Crowing Rooster (1927) | The Country Blues song features a flat male vocal singing over acoustic guitar melody, accordion and a sustained brass section melody. It sounds very noisy, vintage and therefore nostalgic and sentimental - like something you would hear in an old movie. | 2012-02-16T00:09:11Z | RadioWeevil | The Crowing Rooster Walter Rhodes, voice and accordion Pet and Can (Maylon and Richard Harney), guitars Columbia 14289-D (W 145358-2) Memphis, 10 December 1927 | ["Music", "Mandolin", "Bluegrass"] | ["country blues", "noisy", "vintage", "low quality", "nostalgic", "mono", "flat male vocal", "acoustic guitar melody", "accordion melody", "sustained brass section", "nostalgic", "sentimental"] | 4 | V5xL8hLFY58 | 2974 |
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;