musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "rock" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- low quality · 4 ✖
- rock · 4 ✖
- groovy 2
- groovy bass 2
- noisy 2
- punchy kick 2
- punchy snare 2
- shimmering hi hats 2
- addictive 1
- dissonant female vocal 1
- easygoing 1
- electric guitar melody 1
- energetic 1
- flat male vocal 1
- funky 1
- groovy keys chords 1
- harmonizing background vocals 1
- hollow snare 1
- live performance 1
- muffled passionate male vocal 1
- passionate 1
- passionate male vocal 1
- saxophone melody 1
- shimmering cymbals 1
- shimmering open hats 1
- simple hi hats 1
- sloppy 1
- smooth bass 1
- smooth bass guitar 1
- soft kick hits 1
- thin kick 1
- unbalanced stereo 1
- uplifting 1
- vintage 1
- wide acoustic rhythm guitars 1
- wide electric guitar melody 1
musiccaps_names (array) 8 ✖
- Ska · 4 ✖
- Music 3
- Country 1
- Music of Africa 1
- Rhythm and blues 1
- Rock and roll 1
- Singing 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
grace slick & the great society-white rabbit | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | 2008-01-07T17:16:48Z | Francesco Giuliobello | An early live version of this song. White rabbit(1965). The images are taken from the movie:Woodstock 3 days of peace & music | ["Singing", "Ska"] | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | 4 | YddV91xnUz4 | 3302 | |
Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 | |
Edsels - Rama Lama Ding Dong - Youngstown Ohio Doo Wop Sound | The low quality recording features a rock song that consists of harmonizing background vocals, alongside passionate male vocals, singing over, at least, punchy snare, simple hi hats, smooth bass, thin kick and punchy snare hits. The recording is so noisy that the actual song can barely be heard, but regardless it sounds vintage, energetic and uplifting. | 2010-04-13T01:59:16Z | PJDooWop | This is a true doo wop classic, coming to you from the very rare original "Lama Rama Ding Dong" pressing on Dub records. | ["Swing music", "Music of Africa", "Music", "Ska"] | ["low quality", "noisy", "vintage", "harmonizing background vocals", "passionate male vocal", "punchy snare", "saxophone melody", "rock", "simple hi hats", "thin kick", "smooth bass", "uplifting", "energetic"] | 4 | s6U8DtBK3Us | 4925 |
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;