musiccaps_details (view)
9 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "piano", musiccaps_author = 6 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Galliano - r'n'b freestyle | The recording is of poor quality. A male voice is singing soulfully along to a backing instrumental sounding like coming out of some speakers. There is a piano playing and you can hear electric drums. This song may be playing at home practicing singing. | 2008-04-16T22:31:19Z | gstyleshop | Galliano on G-style street video tapes © | ["Singing", "Music", "Rhythm and blues", "Song", "Zing"] | ["hiphop/souls", "electronic beat", "piano", "male voice singing", "amateur recording", "sensual"] | 6 | 2GepmcbNlJY | 346 | |
Let go Let God | This audio contains someone playing a gospel/jazz melody when a very loud drum comes in with a fill-in on the toms. This is an amateur recording and of poor audio-quality. This song may be playing in a gospel church. | 2009-02-21T06:32:49Z | tonyhoustonl | the whole dance of let go let god hope you enjoy. | ["Music", "Keyboard (musical)", "Harmonic", "Inside, large room or hall"] | ["amateur recording", "gospel", "piano", "drums", "jazzy", "slower to medium tempo"] | 6 | ESbtW0CUmp4 | 1559 | |
Freddie McGregor and the Big Ship band 'intro' @ Reggae Geel festival,03-08-2013 | Someone is playing an acoustic drum groove with a snare that uses reverb. An e-bass is playing a sub bassline. An e-guitar is strumming short rhythmic chords on the backbeat giving this music its reggae vibe. A keyboard is playing a sound in the mid range and another keyboard responds with a countermelody playing a melody using a brass sound. In the background you can hear people talking. This song may be playing live at a festival. | 2013-08-04T13:37:08Z | Cultivizion | Freddie McGregor and the Big Ship band 'intro' @ Reggae Geel festival,03-08-2013,Belgium | ["Music", "Reggae"] | ["amateur recording", "reggae", "acoustic drums", "e-guitar", "e-bass", "piano", "medium tempo", "laid back energy"] | 6 | JFGNmPzPXeA | 1984 | |
king kong sound system - zagiyo (jgn gado-gado) | To male voices are singing a melody. Someone is playing acoustic drums together with a djembe. A ukulele is being strummed on the offbeat along with a piano playing the same chords. This is an amateur recording. This song may be playing live at a small festival. | 2011-09-20T04:58:55Z | Rahseed269 | live at babylon | ["Keys jangling", "Music"] | ["reggae", "piano", "djembe", "acoustic drums", "male voices singing", "ukulele", "medium to uptempo", "amateur recording"] | 6 | MdYXznF3Eac | 2283 | |
JVC "My Sound" Equalization | Someone is playing a track from speakers. This song contains a strong e-bass playing a funky bassline along with a funky drum groove. Then a piano comes in playing a jazzy melody in one scale accompanied by a synth brass sound swelling into existence and playing a short rise before leaving again. This is an amateur recording but of decent audio-quality. This song may be playing in a jazzbar. | 2011-06-27T23:43:09Z | jvcaustralia | My Sound EQ allows personal customisation of sound. Users can adjust the sound for their ears and the car environment by listening to test-tones in five frequencies, each represented by a different instrument. | ["Music", "Synthesizer"] | ["funk/jazz", "e-bass", "acoustic drum", "piano", "keyboard brass sound", "uptempo", "amateur recording"] | 6 | NlCfScKw_Mk | 2358 | |
Sallie Gets Grounded in 6 Days | This musical piece belongs to a cinematic scene. Strings are playing a creepy melody and fill in along with screeching sounds while there is the sound of someone knocking the door and then someone is screaming. | 2014-08-19T21:22:00Z | Jeremy Dragon-Shapeshifter | Credit to all who use grounded in number of days. Sallie would never stop being a trouble maker so she's grounded. XD Enjoy the episode, peeps. =) - created at http://goanimate.com/ | ["Music", "Thunk", "Inside, small room"] | ["cinematic/horror", "strings", "piano", "screeching sound", "high pitched screaming", "footsteps or door-knocking", "amateur recording"] | 6 | T5YZwhC7Br8 | 2808 | |
GTA IV - SWAT [Dubbing PL] [Subtitles EN] | A lot of gun firing can be heard in this recording. In the background strings are playing a melody along with a piano. A male voice is making a sound like being annoyed. This is an amateur recording and the song may be more suitable for a relaxing and sad movie-scene. | 2009-08-30T22:38:07Z | Gracjan Gornig | Facebook! http://facebook.com./gse.studio (Polska) Zapraszam do oglądania. (English) I invite to watch! | ["Music", "Boom"] | ["amateur recording", "string section", "piano", "synth pad", "shooting sounds", "male voice"] | 6 | WxgolzWTmO4 | 3152 | |
Alexei Ramos, Anderson Mendes e Paulo Burracha - Ave Maria Que Calor | Someone is playing a cowbell along with other percussion such as congas along to a pumping bassline. A piano and a brass section are playing a countermelody to the female and male voices singing. In the background you can hear people cheering and whistling. This is an amateur recording and of poor audio-quality. This song may be playing on a dancefloor. | 2011-10-01T15:30:51Z | Emília Pedra | Aniversario Dj Zé do Lago | ["Music", "Music of Latin America", "Salsa music"] | ["salsa", "amateur recording", "bass", "cowbell", "congas", "mixed voices singing", "piano", "trumpet/trombone", "crowd cheering/whistling"] | 6 | wsJ5ZLKiPzs | 5289 | |
Myanmar Gospel Song New: ဆာလံ ၂၃ | This song contains acoustic drums playing along with a bass creating a folksong atmosphere along with an accordion like sounding instrument. A piano and guitar are playing a melody along with an accordion -like instrument taking the main melody from the instruments. Female voices are singing at a higher pitch. This song is in poor audio-quality. This song may be playing live at a church. | 2013-09-19T14:11:27Z | Samuel Thio | Let's sing joyfully and praise our Lord. May the Lord bless you dear friend. ဒီသီခ်င္းကို ၾကည္ခဲ့ရင္ ၾကည့္ခဲ့တဲ့ အေၾကာင္းအသိေပးေပးပါ။ | ["Gospel music", "Christian music", "Music"] | ["gospel/folk", "amateur recording", "acoustic drums", "e-bass", "female voices singing", "piano", "e-guitar", "accordion", "medium to uptempo"] | 6 | yOVaak2hemM | 5405 |
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;