musiccaps_details (view)
2 rows where musiccaps_aspects contains "chill" and musiccaps_aspects contains "mono" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- chill · 2 ✖
- low quality 2
- mono · 2 ✖
- noisy 2
- relaxing 2
- distorted 1
- easygoing 1
- electric guitar solo melody 1
- funky electric guitar chords 1
- groovy bass 1
- harsh 1
- mellow 1
- reverberant electric guitar melody 1
musiccaps_names (array) 7 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1kw am dds pwm transmitter broadcast class d | The low quality recording features funky electric guitar chords, electric guitar solo melody and groovy bass playing in the background. The recording is very noisy, distorted and harsh, but it is still easygoing and chill - like something you would listen to when you are trying to relax. | 2014-04-26T14:11:17Z | amhercules | High quality broadcast transmitter 1kw ,class D ,PWM,DDS | ["Music", "Radio", "Rock and roll", "Plucked string instrument"] | ["low quality", "noisy", "mono", "funky electric guitar chords", "electric guitar solo melody", "groovy bass", "easygoing", "distorted", "harsh", "chill", "relaxing"] | 4 | AVuh8-CucrE | 1130 | |
Reverb Pedal Shootout (Strymon Blue Sky, Neunaber Wet, Dr. Scientist RRR) | The low quality recording features a reverberant electric guitar melody. It sounds mellow, chill, relaxing and like a player is trying out his reverb pedals. The recording is noisy and in mono. | 2011-04-28T09:52:04Z | Karl Verkade | More ambience with these pedals: http://karlverkade.bandcamp.com (Chapter Listing Below) Strymon Blue Sky, Morgan Shadow Verb, Neunebar Wet, Behringer RV600, and Dr. Scientist Reverberator. Full review here: http://guitarforworship.com/?p=3611 Chapter Listing: 0:00 Quick Comparison 0:57 Intro of Pedals 1:34 Clean Tone 2:05 Ambient Reverb Sound Comparison 4:13 Blue Sky Modulation Mode 4:49 Spring Reverb Sound Settings 5:35 Spring Reverb Sound Comparison 6:39 Shimmer Settings on Behringer and Strymon 7:00 Shimmer Comparison on Behringer and Strymon 8:25 Ambient Reverb Sound Settings 8:56 Adding to Delayed Swells Comparison 11:18 Arena Rock Reverb Comparison (oh ya) Thanks for watching! http://www.facebook.com/pages/Karl-Verkade/208801429149681 | ["Reverberation", "Effects unit", "Music", "Plucked string instrument", "Distortion"] | ["low quality", "mono", "noisy", "reverberant electric guitar melody", "mellow", "chill", "relaxing"] | 4 | KrmG43H1u70 | 2127 |
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;