musiccaps_details (view)
33 rows where musiccaps_author = 5
This data as json
musiccaps_aspects (array) 189 ✖
- no vocals 10
- positive 8
- happy 6
- mid tempo 6
- kids music 5
- bright 4
- cinematic 4
- dreamy 4
- fast tempo 4
- scary 4
- slow tempo 4
- upbeat 4
- danceable 3
- dark 3
- nostalgic 3
- r&b 3
- romantic 3
- ambience 2
- bass guitar 2
- bright male vocals 2
- bright piano 2
- carnatic music 2
- cello 2
- easygoing 2
- emotional 2
- energetic 2
- female singer 2
- fun 2
- indian folk 2
- instrumental 2
- kick 2
- live music 2
- low quality sound 2
- lullaby 2
- nasal male vocals 2
- rock&roll 2
- sitar 2
- smooth 2
- sound effects 2
- subtle strings 2
- traditional music 2
- upbeat drum kit 2
- afrobeat 1
- aggressive drum kit 1
- ambience synth 1
- ambience vocal choir 1
- appealing female vocals 1
- appealing male vocals 1
- atmosphere 1
- background sfx 1
- ballad 1
- bass 1
- bells 1
- birds 1
- blues 1
- blues drum kit 1
- bouncy bass 1
- bouncy melody 1
- bright acoustic guitar solo 1
- bright female vocals 1
- bright xylophone 1
- burning flame 1
- chill 1
- choir ambience synth 1
- chorus electric guitar 1
- christmas music 1
- clarinets 1
- classical music 1
- clean electric guitar strumms 1
- clipping sound 1
- confusion 1
- country 1
- danger 1
- dark ambience background 1
- dark synth 1
- darl 1
- distorted 1
- distorted electric guitar 1
- doom 1
- drum machine 1
- duck sounds 1
- earthquake effects 1
- eastern drums 1
- electric guitar solo 1
- electronic bass 1
- electronic drum kit 1
- falsetto male vocals 1
- funk 1
- fusion 1
- fuzzy synth 1
- grating female vocals 1
- guitar 1
- guitar arpeggio 1
- guitar effects pedal 1
- gurtural vocals 1
- hard rock 1
- hawaiian 1
- heartfelt female vocals 1
- heavily distorted aggressive electric guitar 1
- heavy metal 1
- hi-hats 1
- hip-hop 1
- holidays 1
- horror 1
- indie rock 1
- inspirational string section 1
- inspiring piano melody 1
- jazz fusion 1
- jazzy drum kit 1
- jazzy drums 1
- jingles 1
- kurdish folk 1
- laid back 1
- latin music 1
- latin percussion 1
- low tempo 1
- male vocal 1
- mediterranean folk 1
- mellow female vocals 1
- mellow male vocals 1
- mellow mellody 1
- mid-pitched male vocals 1
- mid-tempo 1
- muffled 1
- mystic 1
- ocean sound effects 1
- old tv show 1
- orchestral 1
- out of key vocals 1
- outro 1
- passionate 1
- percussion synth 1
- piano chords 1
- piano melody 1
- pop 1
- powerfull 1
- psychedelic 1
- quirky 1
- r&b/soul 1
- rain 1
- raspy male vocals 1
- relaxed 1
- reverb delay electric guitar 1
- reverb electric guitar solo 1
- reverb vocal sample 1
- sad male vocals 1
- sad mood 1
- salsa 1
- schoenhut piano 1
- scratchy male vocals 1
- screaming vocals 1
- seductive saxophone 1
- sfx 1
- sharp male vocals 1
- sharp violins 1
- simple 1
- sleepy 1
- snare 1
- soft 1
- soft drum kit 1
- soft piano synth 1
- soft rock ballad 1
- soul 1
- special effects 1
- spiritual 1
- steel pedal guitar 1
- steelpan 1
- storytelling mood 1
- string section 1
- strings 1
- strummed acoustic guitar 1
- strummed electric guitar 1
- subtle trumpets 1
- sustained piano synth 1
- synth 1
- synth electric guitar solo 1
- synth string section 1
- theremin 1
- thunder 1
- tight drum kit 1
- tv show music 1
- upbeat drums 1
- upbeat electronic drums 1
- video game 1
- vintage 1
- violins 1
- waves 1
- wobbly 1
- xylophone 1
0 records
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;