musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "Independent music" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate · 3 ✖
- emotional 2
- acoustic rhythm guitar 1
- average audio quality 1
- backup singers 1
- bright electric guitar 1
- buoyant 1
- clapping percussions 1
- dance rhythm 1
- energetic drumming 1
- enthusiastic vocals 1
- female singers 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- hissing vocals 1
- home studio 1
- indie folk 1
- inspiring 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- lead female vocal 1
- life lessons 1
- love song 1
- low quality 1
- male singer 1
- male vocalist 1
- medium tempo 1
- melodious acoustic guitar rhythm 1
- motivational 1
- …
musiccaps_names (array) 10 ✖
- Independent music · 3 ✖
- Music 3
- Song · 3 ✖
- Acoustic guitar 1
- Folk music 1
- Plucked string instrument 1
- Pop music 1
- Punk rock 1
- Singing 1
- Strum 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 | |
Top 30 Indie Folk and Acoustic (Playlist #5) | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | 2014-02-28T23:48:23Z | Indie & Folky Me | Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * Copyright Disclaimer * Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | 4 | hTlIqICkbW8 | 4110 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 |
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;