musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass guitar", musiccaps_names contains "Music of Asia" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- bass guitar · 2 ✖
- electronic drums 2
- keyboard 2
- melodic singing 2
- amp 1
- dance-pop 1
- electric guitar 1
- female vocal 1
- female vocals 1
- hip 1
- male vocal 1
- medium tempo 1
- pop music 1
- rapping 1
- reverb 1
- sentimental 1
- simple tune 1
- urban 1
- vibrant 1
musiccaps_names (array) 7 ✖
- Music 2
- Music of Asia · 2 ✖
- Pop music · 2 ✖
- Music for children 1
- Radio 1
- Reverberation 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PlayDefo x30 Sound Party | This is a dance-pop music piece. There are two female vocalists singing melodically and rapping. The keyboard is playing the main tune while there is a bass guitar playing in the background. The rhythm consists of an electronic drum beat. There is a hip atmosphere. This piece could be used in the soundtrack of a teenage drama TV series as an opening theme. | 2013-12-25T12:38:16Z | iMiriaPWNZ | ["Music of Asia", "Music", "Music for children", "Pop music"] | ["dance-pop", "female vocals", "melodic singing", "rapping", "keyboard", "bass guitar", "electronic drums", "hip", "urban"] | 9 | 5JqTvKNXzOw | 653 | ||
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 |
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;