musiccaps
2 rows where aspect_list contains "medium tempo" and audioset_ids contains "/m/07qlf79"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4sD0Bvt3FKk | A blues rock song is being played. Containing drums that are playing a simple groove along with a blues bassline that is supported by an e-guitar playing the same melody. So does a piano just in a higher pitch adding harmony. The female voices are singing together. Then an e-guitar starts playing a little solo-melody. There are some airy background noises that seem not to belong to the recording. This song may be playing at a local car workshop. | ["country/blues/rock", "female voices singing", "e-guitar", "acoustic drums", "piano", "b ackground noises", "e-bass", "medium tempo"] | ["Music", "Spray"] | 6 | 280 | 290 | 0 | 1 | ["/m/04rlf", "/m/07qlf79"] | |
AU1l1i0H0j0 | The song is an instrumental. The song is medium tempo with a groovy bass line, techno drumming rhythm, keyboard synth string accompaniment and other percussive hits. The song is energetic and passionate. The song is a techno dance tune and has poor audio quality, | ["techno dance music", "poor audio quality", "medium tempo", "poor audio quality", "groovy rhythm", "ad jingle", "hissing tones", "instrumental music", "keyboard synth harmony", "strong bass line", "techno drum rhythm", "hissing tones", "energetic", "emotional", "passionate", "dance groove", "tv advertisement sound track"] | ["Music", "Spray"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qlf79"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );