musiccaps_details (view)
5 rows where musiccaps_aspects contains "noisy" and musiccaps_names contains "/t/dd00003"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Garoto flagrado cantando sozinho | × Boy caught singing alone × | The low quality recording features a passionate male vocal singing over playback instrumental that consists of straight piano chord progression. It is noisy and reverberant, as the singer is singing in a larger room. It sounds emotional, passionate and powerful. | 2015-08-23T21:39:57Z | luan arantes | Canta muito!! Música: Sia - Chandelier | ["Music", "/t/dd00003"] | ["low quality", "passionate male vocal", "playback instrumental", "straight piano chords", "reverberant", "loud", "noisy", "live performance", "passionate", "powerful", "emotional"] | 4 | 73YTz8RC2Fo | 806 | |
| 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 | |
| Singing Santa Makes Baby Cry | The low quality recording features a filtered, throaty male vocal singing over mellow piano melody which can barely be heard due to clashing of frequencies. There are some crackling sounds occasionally. The recording is noisy and in mono, and it sounds vintage, nostalgic, euphoric, but also kind of creepy. | 2010-12-16T00:55:41Z | BlackWing Creative | Santa rocks Hodgson/Meyers House Well, if not that Hodgson/Meyers house, at least the H/M home page. S. Claus has made a guest appearance in the lobby of Hodgson/Meyers. His eyes, how they twinkle. His dimples, so merry. His cheeks are like roses, his nose like a cherry. His droll little mouth is drawn up like a bow. And the beard of his chin is as white as the snow. In short, Santa appears just as one might imagine him to be—until the man opens his mouth. At which time deep rumblings are heard, a basso profundo performance of holiday carols that inspire not cheer but fear. So disturbing is the man's melody that babies can be seen and heard crying on the agency home page. In real life, the company's security camera recorded the clean up crew approaching the diminutive performer with extreme caution, broom at the ready. An early morning eruption into holiday "song" caused a project manager to go into duck-and-cover mode, so frightened was she by the red-suited one's warped warbling. Despite his frightful renditions of seasonal songs, our Santa is quite harmless. The only question that remains is how does Tim Hodgson remain so motionless for hours while in the costume? | ["Music", "/t/dd00003", "Synthetic singing"] | ["low quality", "filtered throaty male vocal", "noisy", "mellow piano melody", "euphoric", "creepy", "mono", "crackles", "vintage", "nostalgic"] | 4 | UJAk1nNdo1I | 2906 | |
| Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 | |
| New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;