musiccaps
2 rows where aspect_list contains "madly in love" and audioset_ids contains "/m/05r5c"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1OIfQHKnAcw | A male singer sings this emotional melody. The song is medium tempo with a piano accompaniment and a strong bass drum kick . The song is emotional and romantic. The song is a home music video . | ["male singer", "piano accompaniment", "soloist", "modern love", "loneliness", "breakup song", "mameluke in love", "music covers", "youtube music videos", "youtube music artist", "modern pop hits", "courtship song", "desperate for you", "madly in love", "original song", "acoustic pop", "emotional", "love song", "sentimental", "strong bass line", "keyboard accompaniment"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 1 | 20 | 30 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] | |
LKVSEQCLCLo | The song is an instrumental. The song is medium tempo with various Latin percussion playing groovily to the sounds of a Rhodes organ melody. The song is romantic and passionate. The soundtrack is a demonstration for a keyboard model. | ["latin dance groove", "bossa nova", "giro", "madly in love", "passioante affair", "old school romance", "passionate affair", "medium tempo", "latin percussion instruments", "memdium tenpo", "rhodes organ", "various percussion hits", "latin jazz music", "latin dancers", "romantic", "party time", "fiesta", "romantic", "spirited", "passionate", "keyboard styles", "instrumental music", "music keyboard demo"] | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | 1 | 10 | 20 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c", "/m/0l14qv"] |
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 );