musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_names contains "Ska" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- acoustic guitar · 2 ✖
- bass guitar 2
- acoustic sounding drums 1
- ambient synth 1
- country music 1
- cozy 1
- easygoing 1
- electric guitar 1
- electronic drums 1
- experimental pop 1
- female vocal 1
- groovy 1
- indie rock 1
- joyful 1
- live performance 1
- male vocal 1
- male vocals 1
- psychedelic 1
- simple tune 1
- sound effects 1
- trippy 1
- upbeat 1
musiccaps_names (array) 7 ✖
youtube_published (date) 2 ✖
- 2009-12-15 1
- 2014-04-08 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mandolin Bridge Part 1 | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | 2014-04-08T18:01:39Z | janrohan | This video is about the Mandolin Bridge band Ohio -- rocking country, dance and oldies! Visit us at www.mandolinbridge.com ! | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | 9 | QSaX7QfeWog | 2620 | |
Sonar Promo | This is an indie rock piece. There is a male vocalist in the lead with heavy effects. There is an ambient synth in the background playing the melody with the accompaniment of an acoustic guitar. A mellow bass guitar plays a groovy bass line. The rhythmic background consists of an electronic drum beat full of percussion samples. The piece has a trippy aura. It could be played at nightclubs. It could also be used in the soundtracks of drama films with a modern, urban setting. | 2009-12-15T04:16:49Z | swoop hamilton | Sonar is a park based video being filmed in ladslide skatepark in the winter of 2009 each skater wll have an individual part an there is a section for friends the skaters are Jesse Dagle Mike Baldwin Mike Molahan Will Dandalides Alex Podladowsi Michael Demeter Don Bolter and Lincoln Okaji not everyone was in the promo bu everyone has and is in the process of geting footage | ["Singing", "Music", "Skateboard", "Ska", "Song"] | ["indie rock", "experimental pop", "male vocal", "acoustic guitar", "bass guitar", "ambient synth", "electronic drums", "sound effects", "trippy", "groovy", "psychedelic"] | 9 | YrGQKTbiG1g | 3316 |
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;