musiccaps_details (view)
4 rows where musiccaps_aspects contains "female singer" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- female singer · 4 ✖
- e-bass 3
- uptempo 3
- acoustic drums 2
- amateur recording 2
- 2000s pop 1
- acoustic piano 1
- background cheering 1
- ballad/pop 1
- bongos 1
- crowd cheering 1
- digital drums 1
- drums 1
- e-guitars 1
- latin 1
- male backing voice 1
- male backing voices 1
- medium tempo 1
- poprock 1
- positive vibes 1
- sad 1
- steel drum 1
- synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sonic Adventure DX Music: BELIEVE IN MYSELF | The female voice sings in the mid range. The drums is playing a fast rock/hiphop groove along with an acoustic bass breaking along with it into another part of the song. One of the e-guitars is playing some chords running through a strong tremolo effect. While the other guitar sounds distorted and takes the lead. One is panned to the left, the other to the right side of the speakers. This song may be playing at a birthday party. | 2007-02-09T02:50:55Z | sonicKAI | This is Miles "Tails" Prower's theme tune in Sonic Adventure DX. The song is "Believe In Myself" by Karen Brake. | ["Music", "Exciting music"] | ["poprock", "e-bass", "e-guitars", "acoustic drums", "female singer", "uptempo"] | 6 | 0DizopdPMBw | 134 | |
sandra in athens 2008 "maria magdalena" | a female voice is singing to a digital drum set along with a bass and old disco synthesizer sounds. The singer gets backed by a male singer and the crowd is singing along. There is clapping from the crowd. This song may be playing live at a concert. | 2008-07-24T10:51:08Z | stathiszzz | f a n t a s t i c ! ! ! i love her!!!1111111111111111111111111111111111111 | ["Singing", "Music", "Inside, public space"] | ["2000s pop", "female singer", "background cheering", "synthesizer", "drums", "e-bass", "male backing voice", "uptempo"] | 6 | 5n8I-br2n1U | 694 | |
Minsan ♥ ( ROSELL GiMO ) | An acoustic piano is playing a sad piece accompanied by a female singer. A simple digital drum with crash hits rounds up the composition. This song is an amateur recording but of decent quality. This song may be playing at a talent show. | 2013-10-28T07:32:08Z | Rosell Gimo | ["Music", "Zing"] | ["ballad/pop", "acoustic piano", "female singer", "digital drums", "amateur recording", "uptempo", "sad"] | 6 | BWKQXn5xDwo | 1248 | ||
Elida Reyna y Avante - "Me Gustas" | An acoustic drum is playing a latin groove with a cowbell sound and bongos playing along with a bassline underlining. Someone is playing a melody on a steeldrum. The female voice starts singing the same melody. Male voices are supporting her with shouting sounds. The crowd is cheering and clapping along. This song may be playing at a summer festival. | 2010-05-05T13:45:38Z | gcarmona66 | Elida Reyna y Avante "Me Gustas" April 22, 2010 Cattleman's Square - Tejano Explosion San Antonio, Texas | ["Singing", "Music", "Steelpan"] | ["latin", "bongos", "acoustic drums", "female singer", "male backing voices", "e-bass", "steel drum", "crowd cheering", "amateur recording", "medium tempo", "positive vibes"] | 6 | s4PN7iTLdVM | 4921 |
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;