musiccaps_details (view)
48 rows where musiccaps_aspects contains "classical" and musiccaps_author = 4
This data as json
musiccaps_aspects (array) 140 ✖
- classical · 48 ✖
- low quality 41
- emotional 25
- passionate 25
- noisy 20
- live performance 15
- suspenseful 10
- harpsichord melody 7
- intense 7
- mono 7
- orchestra 7
- wide strings melody 7
- epic 6
- woodwinds melody 6
- reverberant 5
- sustained strings 5
- cover 4
- easygoing 4
- sustained strings melody 4
- dramatic 3
- mellow 3
- soft 3
- vintage 3
- wide sustained strings melody 3
- arpeggiated strings melody 2
- background music 2
- cinematic 2
- dynamic 2
- dynamic low percussion roll 2
- fruity male vocal 2
- joyful 2
- low brass melody 2
- movies 2
- muffled 2
- powerful 2
- shimmering hi hats 2
- soulful 2
- spooky 2
- suspenseful brass melody 2
- sustained cello melody 2
- wide brass melody 2
- wooden percussion 2
- aggressive brass melody 1
- aggressive strings lick 1
- alarm sound 1
- applause 1
- arpeggiated brass section 1
- arpeggiated harp melody 1
- arpeggiated soft piano melody 1
- audio cutouts 1
- brass melody 1
- brass section melody 1
- brass solo melody 1
- breathy flute melody 1
- buzzy harpsichord melody 1
- calming 1
- camera shuttering sounds 1
- cello strings melody 1
- chair crackling sounds 1
- commercial 1
- concert hall 1
- coughing 1
- crowd clapping 1
- cymbal riser 1
- distorted 1
- double bass melody 1
- electric guitar melody 1
- energetic cymbals 1
- energetic orchestra drums 1
- fade in 1
- flat male vocal 1
- floor crackling sounds 1
- flute lick 1
- flute melody 1
- fun 1
- glissando harp melody 1
- groovy piano melody 1
- happy 1
- happy piano chord progression 1
- happy woodwind instrument 1
- harmonizing trombone melodies 1
- haunting 1
- heartbeat low tom hits 1
- hollow flute melody 1
- live perfomrance 1
- mellow brass melody 1
- mellow french horn melody 1
- mellow low percussions 1
- mellow piano chords 1
- mellow woodwind melody 1
- mellow woodwinds melody 1
- mixed harmonizing choir 1
- movie score 1
- muffled sustained strings melody 1
- mystical 1
- opera 1
- organ melody 1
- passionate dynamic classical piano melody 1
- passionate male opera vocal 1
- passionate piano melody 1
- piano melody 1
- plucked arpeggiated zheng melody 1
- plucked cello melody 1
- pulsating woodwind melody 1
- pumping drums 1
- punchy percussion hits 1
- relaxing 1
- repetitive violin melody 1
- rhythmic shoe tapping foley 1
- rock 1
- sad 1
- sad violin melody 1
- saxophone melody 1
- sentimental 1
- shimmering bells melody 1
- shimmering brass melody 1
- shimmering cymbals 1
- shimmering triangle 1
- soft plucked strings melody 1
- soft strings melody 1
- soft wide strings melody 1
- solo low tuba melody 1
- staccato brass section 1
- staccato strings melody 1
- strings melody 1
- subtle drums rhythm 1
- subtle female vocal 1
- sustained brass melody 1
- sustained strings section 1
- sustained violin melody 1
- telephone ring 1
- theremin solo 1
- tom hit 1
- trombone melody 1
- tuba melody 1
- uplifting 1
- wide french horn melody 1
- wide mellow strings melody 1
- woodwind melody 1
- woodwinds 1
musiccaps_names (array) 40 ✖
- Music 20
- Orchestra 10
- Bowed string instrument 9
- Brass instrument 8
- Cello 8
- Harpsichord 7
- Keyboard (musical) 7
- Classical music 6
- Double bass 6
- Background music 4
- French horn 4
- Violin, fiddle 4
- Musical instrument 3
- Opera 3
- Sad music 3
- Theme music 3
- Trombone 3
- Harp 2
- New-age music 2
- Pizzicato 2
- Saxophone 2
- Scary music 2
- Singing 2
- Speech 2
- Timpani 2
- Wedding music 2
- Wind instrument, woodwind instrument 2
- Country 1
- Echo 1
- Flute 1
- Guitar 1
- Harmonic 1
- Mantra 1
- Silence 1
- Soul music 1
- String section 1
- Tap 1
- Theremin 1
- Traditional music 1
- Trumpet 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;