musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy piano chords", musiccaps_aspects contains "mono" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- groovy piano chords · 2 ✖
- low quality 2
- mono · 2 ✖
- noisy 2
- addictive 1
- blues 1
- brass melody 1
- energetic 1
- flat male vocal 1
- nostalgic 1
- passionate male vocal 1
- punchy 808 bass 1
- punchy snare 1
- reggae/dub 1
- sentimental 1
- shimmering hi hats 1
- smooth bass 1
- vintage 1
- whistling 1
musiccaps_names (array) 6 ✖
- Music 2
- /t/dd00003 1
- Blues 1
- Keys jangling 1
- Reggae 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Admiral Bailey-Jamaica 80`s Reggae Dancehall- AfricanSymbol Sound | The low quality recording features a reggae/dub song that consists of a flat male vocal singing over punchy 808 bass, punchy snare, shimmering hi hats and groovy piano chords. It sounds energetic, groovy and the recording is noisy and in mono - due to the fact that the sound is coming from the right channel only. | 2010-03-14T21:23:50Z | JAPAMAICAN | African Symbol Soundsystem @Damali Beach Montego Bay,Jamaica,31/Aug/1986 featuring Admiral Bailey and More.ジャマイカ80sサウンドのアフリカンシンボル秘蔵の映像。 http://africansymboljamaica.info http://www.myspace.com/africansymbolja ジャマイカ、モンテゴベイのダマリビーチで催されたフレンド・クラッシュUNIFICATIONⅡのラバダブのステージショー。 1986年8月31日収録。 Admiral Bailey,Echo Minott,Lt.Stichie,Lady G, Wolf Man,White Mice,General Leon...etc | ["Keys jangling", "Music", "Reggae", "Ska"] | ["low quality", "reggae/dub", "mono", "noisy", "flat male vocal", "punchy 808 bass", "punchy snare", "shimmering hi hats", "groovy piano chords", "energetic", "addictive"] | 4 | 03z0rpIkm5g | 115 | |
Guy Mitchell - Singing The Blues (Live!) | The low quality recording features a blues song that consists of passionate male vocal singing over groovy piano chords, brass melody, whistling melody and smooth bass. It sounds vintage and thus nostalgic and sentimental. The recording is very noisy. | 2008-12-13T21:28:30Z | animalz1969 | "Singing the Blues" is a popular song. It was written by Melvin Endsley and was published in 1956. The best-known recording of the song, released in October 1956 by Guy Mitchell, spent 9 weeks at #1 on the Billboard chart from December 8, 1956 - February 2, 1957, despite competition from rival versions by Tommy Steele and Marty Robbins. Tommy Steele's version also made no. 1 in the UK Singles Chart for one week on 11 January 1957. | ["Blues", "Music", "/t/dd00003"] | ["low quality", "blues", "mono", "noisy", "passionate male vocal", "groovy piano chords", "whistling", "brass melody", "smooth bass", "vintage", "nostalgic", "sentimental"] | 4 | AEwkS57P4eE | 1089 |
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;