musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "street noises" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- medium tempo 2
- passionate · 2 ✖
- street noises · 2 ✖
- aggressive tones 1
- amateur video quality 1
- ambient noise 1
- ambient tones 1
- anger 1
- backup singers 1
- beeping tones 1
- bird chirping tones 1
- booming bass line 1
- coffee cups rattle 1
- damage rap music 1
- duel 1
- emotional 1
- energetic 1
- groovy 1
- growling noises 1
- gym talk 1
- home rap video 1
- instrumental music 1
- male rapper 1
- movie scene music 1
- movie soundtrack 1
- piano accompaniment 1
- piano bass note plays percussively 1
- pizzicato strings 1
- pizzicato violins 1
- poor quality audio 1
- screenplay music 1
- showdown music 1
- singer self introduction 1
- story telling 1
- tense atmosphere 1
- typing sounds 1
- violins playing 1
- vocal commentary 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sniff | The song is instrumental music. The tempo is medium tempo with a piano bass note playing rhythmically, along with piano accompaniment, a violin playing a high pitched drone along with pizzicato violins. The song is tense and includes ambient Street noises like birds chirping and cups rattling. The song is a movie soundtrack for a specific scene. | 2009-07-22T16:39:44Z | Beat24Productions | The rhythmic clock echoes throughout the room. A man sits enjoying his favorite snack. The text alert rings out and he knows he is late. Armed only with a chicken drumstick he is about to have a very strange journey. | ["Music", "Sniff"] | ["piano accompaniment", "pizzicato strings", "movie scene music", "pizzicato violins", "piano bass note plays percussively", "growling noises", "instrumental music", "anger", "violins playing", "medium tempo", "aggressive tones", "ambient tones", "street noises", "tense atmosphere", "screenplay music", "movie soundtrack", "emotional", "passionate", "showdown music", "duel", "bird chirping tones", "coffee cups rattle"] | 1 | AZsupJ68Hp0 | 1134 | |
Street Workout Featuring Mysonne "All Around The World" | A male singer sings this rap vocals with backup singers in harmony. The song is medium tempo with typing and beeping tones, followed by steady drumming rhythm, groovy bass and keyboard harmony. The song is energetic and exciting. The song has a home video intro followed by a rap song. | 2009-11-16T19:20:34Z | djvlad | - http://VladTV.com - A gym membership is not necessary to be brolic. You are now training with Mysonne. Dir: Vernon Baines | ["Music", "Single-lens reflex camera"] | ["typing sounds", "male rapper", "backup singers", "singer self introduction", "groovy", "damage rap music", "beeping tones", "booming bass line", "amateur video quality", "home rap video", "vocal commentary", "medium tempo", "ambient noise", "street noises", "energetic", "passionate", "story telling", "amateur video quality", "gym talk", "poor quality audio"] | 1 | JI26wmUPcrM | 1988 |
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;