musiccaps
2 rows where aspect_list contains "groovy" and audioset_ids = "["/m/04rlf", "/m/07qcpgn"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3fqWosszpnE | A male vocalist sings this upbeat pop song. The tempo is medium fast with thumping drum beats, percussion instruments, ukulele melody, keyboard accompaniment and rhythmic guitar. The audio is muddled making it difficult to hear the finer elements of the song. The song is energetic, enthusiastic, happy, fresh, peppy, perky , groovy. There is background chatter, clapping, cheering and rustling. The song is a Pop Rock/Alternative Indie. | ["male singer", "fast tempo", "happy song", "groovy", "ukele melody", "acoustic guitar", "keyboard accompaniment", "emphatic vocals", "vocal backup", "energetic", "peppy", "buoyant", "dance grove", "party song", "club music", "muffled sounds", "boomy drumming", "strong drum beats", "clapping", "cheering", "happy", "peppy", "cheerful", "muddled audio", "synthesiser", "percussion grooves", "african percussion", "thumping music", "indie pop", "ukele"] | ["Music", "Tap"] | 7 | 50 | 60 | 0 | 1 | ["/m/04rlf", "/m/07qcpgn"] | |
AeDNy6Ff7VE | This is a groovy R&B piece that is used as a soundtrack for a short film. A saxophone plays the main tune while the synth provides the backing theme. Playful electronic drums are in the rhythmic background giving it a 90 feeling. The music piece could be used as a soundtrack theme for a city-themed movie. | ["r&b", "saxophone", "synth", "electronic drums", "groovy", "playful", "energetic", "90s"] | ["Music", "Tap"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qcpgn"] |
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 );