musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "vintage" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- low quality 3
- noisy 3
- passionate male vocal · 3 ✖
- vintage · 3 ✖
- mono 2
- rock 2
- smooth bass 2
- blues 1
- brass melody 1
- camera shuttering sound effects 1
- crowd yelling crowd effect 1
- crushed 1
- distorted 1
- energetic 1
- groovy piano chords 1
- harmonizing background vocals 1
- nostalgic 1
- punchy snare 1
- saxophone melody 1
- sentimental 1
- simple hi hats 1
- thin kick 1
- uplifting 1
- whistling 1
musiccaps_names (array) 7 ✖
- Music 3
- /t/dd00003 1
- Blues 1
- Music of Africa 1
- Radio 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Radio Syd | The low quality recording features a rock song sung by passionate male vocalists, after which there are camera shuttering and crowd yelling sound effects. The recording is in mono and overall it sounds distorted, crushed, noisy and vintage. | 2007-03-29T18:15:40Z | completeoutdoors | Offshore Swedish Pirate Radio Syd from 1962/64.The ship Cheeta 11 became home of Radio Caroline after their Mi Amigo ship was grounded in storm.Radio Syd broadcast on the VHF/FM band. | ["Music", "Radio"] | ["low quality", "mono", "noisy", "camera shuttering sound effects", "crowd yelling crowd effect", "rock", "passionate male vocal", "distorted", "crushed", "vintage"] | 4 | VpikuLP_9qQ | 3034 | |
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;