musiccaps_details (view)
5 rows where musiccaps_aspects contains "ambient room noise" and musiccaps_aspects contains "passionate" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 74 ✖
- ambient room noise · 5 ✖
- passionate · 5 ✖
- medium tempo 4
- poor audio quality 3
- energetic 2
- groovy music 2
- instrumental music 2
- live performance 2
- spirited 2
- acoustic song 1
- adrenaline rush 1
- amplified guitar playing in rhythm 1
- antique guitar 1
- bad audio quality 1
- buzzing noise 1
- classic rock 1
- clickers 1
- clicking percussions 1
- country music 1
- dance music 1
- dance rhythm 1
- death metal 1
- deteriorated audio 1
- distorted guitar rhythm 1
- echo tones 1
- electric buzz 1
- electric hum 1
- emotional 1
- exercise class 1
- fats tempo 1
- female latin singer 1
- female singer 1
- footstep sounds 1
- guitar accompaniment 1
- guitar demo 1
- guitar playing rhythm 1
- gym music 1
- haunting 1
- increasing volume 1
- knob turns 1
- latin dance hits 1
- latin dance music 1
- latin percussion 1
- live audience 1
- male singer 1
- maracas playing percussively 1
- master class 1
- melancholic 1
- percussive bass line 1
- plugging into the guitar 1
- rebellion 1
- rebellious 1
- retro death metal hits 1
- rich country traditions 1
- rock guitar 1
- rock music 1
- screaming vocals 1
- soloist 1
- song intro 1
- steady drumming rhythm 1
- strings making noises 1
- strong bass line 1
- super tone unique tone 1
- tap dance rhythm 1
- teenage age angst 1
- traditional dancing 1
- trumpets 1
- vintage guitar tone 1
- women dancing 1
- workout playlist 1
- youthful 1
- youtube music class 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 17 ✖
- Music 5
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Electronic tuner 1
- Grunge 1
- Maraca 1
- Rock music 1
- Singing 1
- Song 1
- Steel guitar, slide guitar 1
- Strum 1
- Tambourine 1
- Tapping (guitar technique) 1
- Vocal music 1
- Yell 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SOLD! Vintage Supertone Guitar / bottleneck slide blues hawaiian slack key | The song is an instrumental. The song is medium tempo played by a solo guitarist on a vintage super tone with an exquisite tone. The song is emotional and passionate. The song has poor audio quality. | 2010-01-18T16:55:46Z | Keni Lee Burgess | Please visit www.ebay.com Search: Keni Lee | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["bad audio quality", "vintage guitar tone", "passionate", "spirited", "guitar demo", "soloist", "antique guitar", "youtube music class", "master class", "buzzing noise", "instrumental music", "ambient room noise", "bad audio quality", "super tone unique tone", "melancholic", "country music", "medium tempo", "rich country traditions"] | 1 | -lPXTBXa0tE | 80 | |
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
No Limit (metal cover by Leo Moracchioli) | The song is an instrumental. The song is medium tempo with ambient room noises, like a volume knob turned up, a guitar being plugged in and the rhythmic strumming of an amplified distortion guitar. The song is energetic and passionate. The song is an introduction to a rock song. | 2015-02-06T14:53:56Z | Frog Leap Studios | http://panamaguitars.com https://www.facebook.com/panama.guitars Original by 2 Unlimited You can buy my albums or singles here: LOUDR ► http://bit.ly/1YTc7Mk ITUNES ► http://apple.co/1Lni4PR AMAZON ► http://amzn.to/1U2rqUa GOOGLE PLAY ► http://bit.ly/1SOd6Nx Frog Leap Studios Merchandise here: US ► http://bit.ly/1qZ64KP EU ► http://bit.ly/1NXI3Zz Become a Patreon and get all the songs and support me doing more music covers: http://www.patreon.com/frogleapstudios Hi there, my name is Leo and I run a studio on the westside of Norway where I record and produce bands, do video work and play live shows. On my youtube channel there is lots of videos with covers, gear reviews , studio updates and other shenaningans. For my covers I play everything myself as well as record, mix, master, shoot and edit the music & videos. Please subscribe if you like what you see/hear and I am forever gratefull to everyone who buys songs so I can keep doing this as a living. I do not add people I dont know on my personal facebook page, so please follow these links which are my "fan" pages: Youtube ► http://youtube.com/leolego Facebook ► https://www.facebook.com/FrogLeapStudios Twitter ► https://twitter.com/FrogLeapStudios Instagram ► https://instagram.com/frogleapstudios Website ► http://frogleapstudios.com Leo uses: Chapman Guitars: http://www.chapmanguitars.co.uk Toontrack: https://www.toontrack.com Cleartone Strings: http://www.cleartonestrings.com Aalberg Audio: http://aalbergaudio.com TC Helicon: http://www.tc-helicon.com Ortega Guitars: http://ortegaguitars.com Contact: frogleapstudios@gmail.com | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["knob turns", "electric hum", "increasing volume", "strings making noises", "plugging into the guitar", "ambient room noise", "echo tones", "amplified guitar playing in rhythm", "medium tempo", "instrumental music", "song intro", "rock music", "groovy music", "youthful", "energetic", "passionate", "rebellion", "classic rock", "rock guitar", "electric buzz"] | 1 | HEk4fx_XNNE | 1783 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 | |
鈴木能律子フラメンコスタジオ*BELEN ご案内 | A female singer sings this traditional melody. The song is medium tempo with a clicking percussion rhythm, guitar strumming accompaniment and tap dancing tones. The song is energetic and passionate. The song has very poor audio quality. | 2012-05-27T11:47:36Z | STUDIO NORI | ["Music", "Tambourine", "Vocal music"] | ["dance music", "maracas playing percussively", "acoustic song", "live performance", "tap dance rhythm", "women dancing", "traditional dancing", "clicking percussions", "clickers", "poor audio quality", "guitar playing rhythm", "energetic", "passionate", "ambient room noise", "dance rhythm", "fats tempo", "female latin singer", "footstep sounds"] | 1 | jtRse-cDB18 | 4286 |
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;