musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer" and musiccaps_aspects contains "uptempo" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- female singer · 3 ✖
- uptempo · 3 ✖
- e-bass 2
- 2000s pop 1
- acoustic drums 1
- acoustic piano 1
- amateur recording 1
- background cheering 1
- ballad/pop 1
- digital drums 1
- drums 1
- e-guitars 1
- male backing voice 1
- poprock 1
- sad 1
- synthesizer 1
musiccaps_names (array) 5 ✖
- Music 3
- Exciting music 1
- Inside, public space 1
- Singing 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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;