musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drum" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drum · 3 ✖
- e-bass 3
- uptempo · 3 ✖
- amateur recording 2
- brass sounds 1
- digital string sound 1
- e-guitar 1
- funk/jazz 1
- keyboard brass sound 1
- keyboard lead sound 1
- male voice singing 1
- male voices singing 1
- organ 1
- oriental instruments 1
- percussion 1
- piano 1
- positive vibes 1
- rock&roll 1
musiccaps_names (array) 4 ✖
- Music 3
- Folk music 1
- Independent music 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Strawberry Alarm Clock - California Day | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | 2010-06-27T08:13:10Z | Optinon | Genre: Pop/Psychedelic Pop Released: 1970 Release: California Day / Three | ["Music", "Independent music"] | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | 6 | BHu95Y_kVQA | 1225 | |
Cheb Hasni Ayli Ayli | This song contains acoustic drums and percussion playing a complex rhythm along with a bassline. Some brass sounds come here and there to set accents. In the background you can hear a string sound playing a high note. A keyboard lead sound is playing the main melody along with a male voice singing with a melody on his own. This song may be playing at a celebration. | 2010-06-17T15:38:14Z | Raï Sentimental Fans | Écouter plus de chansons rares de Cheb Hasni et le meilleur du rai sentimental http://www.facebook.com/pages/cheb-hasni/115468801815224?ref=sgm | ["Folk music", "Music"] | ["male voices singing", "digital string sound", "keyboard lead sound", "percussion", "acoustic drum", "oriental instruments", "e-bass", "brass sounds", "uptempo", "amateur recording"] | 6 | Czbi1u-gwUU | 1425 | |
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 |
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;