musiccaps_details (view)
2 rows where musiccaps_aspects contains "soft rock" and musiccaps_names contains "Punk rock" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- soft rock · 2 ✖
- bright electric guitar 1
- buoyant 1
- easygoing 1
- emotional 1
- energetic cash cymbal 1
- energetic drumming 1
- enthusiastic vocals 1
- keyboard accompaniment 1
- love song 1
- low quality 1
- male vocalist 1
- mellow female vocal 1
- melodious acoustic guitar rhythm 1
- mono solo electric guitar lead melody 1
- passionate 1
- pleasant 1
- pop hit 1
- shimmering open hat 1
- short snare roll 1
- simple bass guitar 1
- simple hi hats 1
- smooth 1
- stereo imbalance 1
- teen pop 1
- wide acoustic rhythm guitars 1
- youtube video 1
musiccaps_names (array) 7 ✖
- Music 2
- Punk rock · 2 ✖
- Grunge 1
- Independent music 1
- Rock and roll 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pig Rock - อ่าง (SD Version) | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | 2010-02-07T21:32:43Z | PigRockBand | PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt | ["Music", "Punk rock", "Independent music", "Song"] | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | 7 | QutCXtWmzIs | 2649 | |
TeknoAXE's Royalty Free Music - Royalty Free Music #130 (Sun -- by Qelric) Grunge/Rock/Hard Rock | The Soft rock song features a mellow female vocal singing the same melody as the lead electric guitar, followed by widely spread acoustic rhythm guitars, simple bass, soft kick hits, punchy snare, simple hi hats, shimmering open hats and energetic crash cymbals. There is a short snare roll at some point in the loop. The stereo bass guitar is what makes the stereo image imbalance and therefore the song sounds lower in quality. | 2012-07-01T12:33:07Z | TeknoAXE's Royalty Free Music | Download Music: http://teknoaxe.com/Link_Code_3.php?q=166 http://www.youtube.com/user/Qelric **This track is Royalty Free and is free for anyone to use in YouTube videos or other projects, whether monetized or not.** http://www.facebook.com/teknoaxe http://www.reverbnation.com/teknoaxe I'm very proud to present "Sun", by Qelric! Early last week, she came to me wanting to Collaborate on a song she had written, complete with a demo that she had done on her recording set up. She asked me to interpret her song, recording it to my computer and this is the result. I personally think it's awesome! Most, if not all, the writing credit goes to Qelric. The notes are hers, so I had it easy this time and just recorded the track how I felt it would sound best. This song from Qelric actually inspired me to restring my acoustic guitar, which has been sitting in the corner defunct for months now. But now it works and sounds fantastic! So Qelric had some reservations about putting less reverb on her voice because she feels that it sounds better. But I think you'll agree that it sounds really good with just a touch of reverb for the mix and her voice sounds great cutting through! *Legal notice: The publisher of this video and Qelric (http://www.youtube.com/user/Qelric) are the original sources for the music track being presented in this video, which is entitled "Sun -- by Qelric". No one entity, person or organization may take legal action against other entity, person or organization due to use or distribution of this track or modified portions of this music track. image used: http://commons.wikimedia.org/wiki/File:Sun_Clouds.JPG | ["Music", "Punk rock", "Rock music", "Rock and roll", "Grunge"] | ["soft rock", "mellow female vocal", "wide acoustic rhythm guitars", "mono solo electric guitar lead melody", "short snare roll", "energetic cash cymbal", "simple hi hats", "shimmering open hat", "easygoing", "smooth", "simple bass guitar", "low quality", "stereo imbalance"] | 4 | dbldb9tq8ng | 3803 |
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;