musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_author = 0 and musiccaps_names contains "Pop music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- amateur recording 2
- male voice 2
- moderate tempo 2
- percussion 2
- acoustic guitar 1
- bass 1
- breakup song 1
- celebration song 1
- crowd cheering 1
- crowd whistles 1
- disco song 1
- distortion guitar 1
- falsetto voice 1
- fast paced percussion 1
- fast tempo 1
- female voice 1
- foreign language 1
- funk bass 1
- guitar lead 1
- guitar sounds 1
- guitar strums 1
- hand claps 1
- happy mood 1
- instrumental 1
- lead guitar 1
- low quality audio 1
- no voices 1
- pop rock 1
- reverb guitar 1
- rock and roll 1
- …
musiccaps_names (array) 11 ✖
- Music 5
- Pop music · 5 ✖
- Jingle (music) 1
- Musical instrument 1
- Percussion 1
- Pulse 1
- Singing 1
- Song 1
- Soul music 1
- Thump, thud 1
- Yell 1
youtube_published (date) 5 ✖
- 2006-12-12 1
- 2007-05-13 1
- 2008-01-23 1
- 2013-01-20 1
- 2014-08-21 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 | |
Idiot Wind - Find The Rhythm In The Noise | This pop rock song features a male voice. This is accompanied by percussion playing a simple beat in common time. A lead guitar with heavy reverb plays a fill in between lines. An acoustic guitar strums chords in the background. A bass plays the root notes of the chords. The mood of this song is romantic. This song is played at a slow tempo. This song can be played in a retro romantic movie. | 2013-01-20T19:47:00Z | Paul Martin | http://www.idiotwind.se/se Amanda Bergman is a Swedish singer-songwriter. She performs under the stage name Idiot Wind and has also performed as Hajen and Jaw Lesson Bergman co-wrote the score for the Swedish movie En Gång Om Året (Once A Year). | ["Music", "Pop music", "Song", "Soul music"] | ["slow rock", "pop rock", "male voice", "guitar lead", "simple percussion", "slow tempo", "simple bass", "acoustic guitar", "reverb guitar"] | 0 | BjAL68IMlp0 | 1281 | |
Joan Jett----I Hate Myself For Loving You | This song is an amateur recording of a live performance. This features a female voice singing the main melody. This is accompanied by a distortion guitar playing power chords. The percussion plays a simple rock beat. The sound of crowd whistles are heard in this clip. Other instruments are not audible as the quality of the audio is low. This song can be played in a romantic comedy movie. | 2007-05-13T16:08:35Z | rro003 | Joan Jett concert May 2007 | ["Singing", "Music", "Pop music", "Yell"] | ["amateur recording", "female voice", "crowd whistles", "distortion guitar", "percussion", "rock song", "breakup song", "upbeat melody"] | 0 | naZE-MvNpaI | 4558 | |
Masonics - Outside Looking In | This low quality audio features an electric guitar playing a solo. The sounds of the instruments are not clear due to the low audio quality. The percussion plays a fast beat in the background. There are no voices in this song. This song can be played in a car chase sequence in a movie. | 2006-12-12T13:44:19Z | beatsvillerecords | The Masonics perform "I'm on the Outside Looking In" at "The Cluny" in Newcastle-Upon-Tyne. | ["Music", "Musical instrument", "Pop music", "Pulse", "Percussion"] | ["rock and roll", "low quality audio", "percussion", "lead guitar", "no voices", "instrumental", "fast tempo"] | 0 | YqAsph_ouRM | 3314 | |
Matt Hetherington's "Michael Jackson & Luciano Pavarotti" Act | This amateur recording starts off with the sound of the crowd at a live show. This is followed by a male voice mouthing four blasting sounds over the mic. This is followed by a guitar playing a funk riff and another guitar playing a lower register melody. The percussion plays a fast beat. The bass plays only one note in a continuous pattern following the percussion. The mood of this song is upbeat. This song can be played in a retro club. | 2008-01-23T08:34:42Z | Matty Heth | Matt Hetherington devised this as part of his live act. It's being performed at Melbourne's Forum Theatre. | ["Music", "Pop music", "Thump, thud"] | ["amateur recording", "crowd cheering", "falsetto voice", "vocables", "guitar sounds", "fast paced percussion", "bass", "moderate tempo", "upbeat song"] | 0 | MMGAKKhqxKg | 2259 |
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;