musiccaps_details (view)
2 rows where musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "passionate" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- nostalgic · 2 ✖
- passionate · 2 ✖
- bach 1
- bad audio quality 1
- bow 1
- cellist 1
- cello 1
- cello suite 1
- disco 1
- easygoing 1
- emotional 1
- exciting 1
- fingering technique 1
- great composers 1
- groovy bass 1
- groovy church organ melody 1
- groovy piano chords progression 1
- home video 1
- instrumental music 1
- live recording 1
- low pitched notes 1
- low quality 1
- medium tempo 1
- muddy kick 1
- northern soul 1
- passionate female vocal 1
- practice session 1
- punchy snare 1
- romantic 1
- sentimental 1
- shimmering tambourine 1
- soloist 1
- soundboard 1
- strings 1
- studio session 1
- thin 1
- western classical music 1
musiccaps_names (array) 6 ✖
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Funk 1
- Music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
linda jones-cant stop lovin my baby-northern soul | The low quality recording features a Northern Soul song that consists of passionate female vocal singing over groovy piano chords, groovy bass, shimmering tambourine layered with punchy snare hits, muddy kick hits and groovy church organ melody. It sounds thin, but also easygoing, nostalgic, sentimental and passionate - like something you would hear in clubs during 60s and 70s. | 2011-08-15T19:00:47Z | oldsoulgit1 | everything this women does is the best! | ["Funk", "Music", "Soul music"] | ["low quality", "northern soul", "passionate female vocal", "groovy piano chords progression", "groovy bass", "shimmering tambourine", "muddy kick", "punchy snare", "groovy church organ melody", "passionate", "easygoing", "disco", "thin", "sentimental", "nostalgic"] | 4 | fhWzjWZqzvs | 3969 |
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;