musiccaps_details (view)
2 rows where musiccaps_aspects contains "building tension", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- building tension · 2 ✖
- medium tempo · 2 ✖
- poor audio quality · 2 ✖
- song ending 2
- ad jingle 1
- advertisement soundtrack 1
- bad audio quality 1
- beep tones 1
- climactic 1
- composer 1
- conductor 1
- creating awareness 1
- crescendo sounds 1
- different sound tracks 1
- dramatic finish 1
- drum banging loud 1
- energetic 1
- excited 1
- female singer 1
- high pitched vocals 1
- instrumental music 1
- keyboard beeps 1
- movie soundtrack 1
- opera hall 1
- opera singer 1
- operatic theme 1
- philharmonic orchestra 1
- retro ad spots 1
- rhythm section 1
- string section crescendo 1
- techno music 1
- timpani 1
musiccaps_names (array) 4 ✖
- Music 2
- Ambient music 1
- Classical music 1
- Opera 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chris Brown-damage | The song is an instrumental. The tempo is variable, with a timpani crash, various beeping tones and a crescendo grungy keyboard harmony tone. The song is a soundtrack for an advertisement. The audio quality is very poor. | 2007-12-26T09:31:57Z | puddin713 | This song is a very good songand makes me cry everytime! | ["Music", "Ambient music"] | ["song ending", "keyboard beeps", "drum banging loud", "ad jingle", "techno music", "building tension", "excited", "energetic", "creating awareness", "retro ad spots", "advertisement soundtrack", "timpani", "beep tones", "crescendo sounds", "instrumental music", "medium tempo", "poor audio quality", "different sound tracks"] | 1 | DEnayQZiPGc | 1455 | |
Diva Song (Blood Plus) | A female opera singer sings this climatic high pitched finish. The song is medium tempo with a string section accompaniment and a rhythm Section. The song is dramatic and high on adrenaline. The audio quality is very poor. | 2008-09-23T15:24:36Z | Lagaczaka | Divas Song -+-+- great anime with best story Queen of the Chiropteran and her Aria... | ["Music", "Opera", "Classical music"] | ["female singer", "opera singer", "opera hall", "rhythm section", "philharmonic orchestra", "poor audio quality", "composer", "conductor", "operatic theme", "high pitched vocals", "bad audio quality", "song ending", "dramatic finish", "building tension", "climactic", "string section crescendo", "movie soundtrack", "medium tempo"] | 1 | X2gHQb5ubco | 3160 |
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;