musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar melody" and musiccaps_aspects contains "blues" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic guitar melody · 2 ✖
- blues · 2 ✖
- low quality 2
- cars passing 1
- emotional 1
- groovy bass 1
- mellow snare 1
- muted acoustic guitar melody 1
- noisy 1
- passionate 1
- passionate male vocal 1
- poor quality mix 1
- roomy 1
- shimmering cymbals 1
musiccaps_names (array) 8 ✖
- Country 2
- Music 2
- Acoustic guitar 1
- Blues 1
- Guitar 1
- Mandolin 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Salty Dog Blues: Piedmont Blues Fingerstyle | The low quality recording features an acoustic guitar blues melody. The recording is very noisy, roomy and you can hear cars passing by in the background. | 2008-12-17T22:33:33Z | bostonteabagger71739 | My version of the old blues song. A little sloppy I know haha | ["Country", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "blues", "acoustic guitar melody", "noisy", "roomy", "cars passing"] | 4 | g_bgmnJ1b_g | 4039 | |
Ryszard Riedel i Nocna Zmiana Bluesa - Hotelowy Blues | The low quality recording features a blues song that consists of a passionate male vocal singing over acoustic guitar melody in the left channel, muted acoustic guitar melody in the right channel of the stereo image, groovy bass, mellow snare and shimmering cymbals. It sounds passionate and emotional. | 2008-01-12T15:37:19Z | paweuek92 | Fajny kawałek :) | ["Blues", "Country", "Music"] | ["low quality", "poor quality mix", "blues", "passionate male vocal", "acoustic guitar melody", "muted acoustic guitar melody", "groovy bass", "mellow snare", "shimmering cymbals", "passionate", "emotional"] | 4 | 9Rx57dlJtIA | 1008 |
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;