notebook.community

Edit and run

ISWC statistics





In [2]:



    


%run startup.ipy



    


















    






Last notebook update: 2018-07-03
Git repo: git@bitbucket.org:loujine/musicbrainz-dataviz.git
Importing libs










    
















    






Defining database parameters

Defining *sql* helper function
Last database update: 2018-06-02

Python packages versions:
numpy       1.14.3
pandas      0.23.0
sqlalchemy  1.2.8
CPython 3.7.0b5
IPython 6.4.0

ISWC: https://en.wikipedia.org/wiki/International_Standard_Musical_Work_Code

Number of ISWC in the database





In [21]:



    


sql("""
SELECT COUNT(DISTINCT(iswc)) 
  FROM iswc;
""")



    


















    
Out[21]:











  
    

      
      count
    

  
  
    

      0
      158718

ca. 160.000 ISWC

ISWC for classical music

Do we have ISWCs for Debussy compositions?





In [7]:



    


sql("""
SELECT iswc, work.name, artist.name
  FROM iswc
  JOIN work                 ON work.id = iswc.work
  JOIN l_artist_work AS law ON law.entity1 = iswc.work
  JOIN artist               ON law.entity0 = artist.id
 WHERE artist.name = 'Claude Debussy'
  ;
""")



    


















    
Out[7]:











  
    

      
      iswc
      name
      name
    

  
  
    

      0
      T-003.010.186-0
      Gymnopédies
      Claude Debussy
    

    

      1
      T-003.010.186-0
      Gymnopédies: I. Lent et grave
      Claude Debussy
    

    

      2
      T-004.032.978-9
      Rondel chinois, L. 17, CD 11 "Sur le lac bordé...
      Claude Debussy
    

    

      3
      T-004.032.977-8
      Aimons-nous et dormons, L. 16, CD 7
      Claude Debussy
    

    

      4
      T-004.061.510-8
      Caprice, L. 5, CD 6 "Quand je baise, pâle de f...
      Claude Debussy
    

    

      5
      T-003.022.042-8
      Symphonie en si mineur, L. 10, CD 8
      Claude Debussy
    

    

      6
      T-004.032.979-0
      Jane, L. 19, CD 13 "Je pâlis et tombe en langu...
      Claude Debussy
    

    

      7
      T-004.104.825-2
      Helène, L. 20 bis, CD 14 "Franchis les mers ic...
      Claude Debussy
    

    

      8
      T-004.104.845-6
      L’Archet, L. 46, CD 22 "Elle avait de beaux ch...
      Claude Debussy
    

    

      9
      T-004.104.830-9
      Fantoches, L. 21, CD 26 "Scaramouche et Pulcin...
      Claude Debussy
    

    

      10
      T-922.059.190-2
      My Reverie (Debussy's "Reverie")
      Claude Debussy
    

    

      11
      T-909.690.724-3
      美しい夕暮れ
      Claude Debussy

So we have 12 ISWCs. Note that probably some (like the last one) are for derived works and not the original ones.

For Philip Glass we find something similar:





In [18]:



    


sql("""
SELECT iswc, work.name, artist.name
  FROM iswc
  JOIN work                 ON work.id = iswc.work
  JOIN l_artist_work AS law ON law.entity1 = iswc.work
  JOIN artist               ON law.entity0 = artist.id
 WHERE artist.name = 'Philip Glass'
  ;
""")



    


















    
Out[18]:











  
    

      
      iswc
      name
      name
    

  
  
    

      0
      T-901.070.086-4
      Icct Hedral
      Philip Glass
    

    

      1
      T-901.070.086-4
      Icct Hedral
      Philip Glass
    

    

      2
      T-070.067.582-6
      Glassworks
      Philip Glass
    

    

      3
      T-901.690.749-6
      Platinum, Part IV: North Star / Platinum Finale
      Philip Glass
    

    

      4
      T-071.181.144-7
      Concerto Fantasy for Two Timpanists and Orchestra
      Philip Glass
    

    

      5
      T-070.276.314-1
      Serra Pellada
      Philip Glass
    

    

      6
      T-900.021.295-3
      The Title
      Philip Glass
    

    

      7
      T-011.011.609-0
      Anthem of the New World Part 1
      Philip Glass
    

    

      8
      T-070.005.983-1
      Anthem of the New World Part 2
      Philip Glass
    

    

      9
      T-010.486.009-4
      Anthem of the New World Part 3
      Philip Glass
    

    

      10
      T-010.486.007-2
      New Cities in Ancient Lands, China
      Philip Glass
    

    

      11
      T-010.486.014-1
      New Cities in Ancient Lands, Africa
      Philip Glass
    

    

      12
      T-010.486.013-0
      New Cities in Ancient Lands, India
      Philip Glass
    

    

      13
      T-904.881.691-7
      Mosque and Temple
      Philip Glass
    

    

      14
      T-070.187.169-3
      Train to São Paulo
      Philip Glass
    

    

      15
      T-010.486.008-3
      Video Dream
      Philip Glass
    

    

      16
      T-010.486.012-9
      The Unutterable
      Philip Glass
    

    

      17
      T-070.032.171-6
      Caught
      Philip Glass
    

    

      18
      T-011.126.808-6
      Mr. Suso #1
      Philip Glass
    

    

      19
      T-011.194.275-6
      Mr. Suso #2 With Reflection
      Philip Glass
    

    

      20
      T-900.021.294-2
      From Egypt
      Philip Glass
    

    

      21
      T-010.711.362-1
      Powaqqatsi
      Philip Glass
    

    

      22
      T-700.003.733-4
      Composition No. 26F
      Philip Glass

ISWC for works composed before 1900

Again, derived works probably are present in this list





In [23]:



    


sql("""
SELECT DISTINCT(iswc), work.name, link.begin_date_year, work.gid
  FROM iswc
  JOIN work                 ON work.id = iswc.work
  JOIN l_artist_work AS law ON law.entity1 = iswc.work
  JOIN link                 ON law.link = link.id
 WHERE link.begin_date_year > 1850
   AND link.begin_date_year < 1900
 ORDER BY link.begin_date_year
  ;
""")



    


















    
Out[23]:











  
    

      
      iswc
      name
      begin_date_year
      gid
    

  
  
    

      0
      T-700.050.033-6
      Old Black Joe
      1853
      b548549c-df44-4eec-a845-17929ae206b3
    

    

      1
      T-902.821.023-3
      Hard Times Come Again No More
      1854
      c5563993-5a7f-39b2-bd7d-bf00127c43ae
    

    

      2
      T-902.910.216-7
      Oh Happy Day
      1854
      e6a9ebc5-0332-3f69-9260-89630317de4f
    

    

      3
      T-914.285.596-7
      Silent Night
      1859
      590e5567-c188-31f0-b7a8-a94e7e51c7b3
    

    

      4
      T-004.061.510-8
      Caprice, L. 5, CD 6 "Quand je baise, pâle de f...
      1861
      9f223f1e-9841-46c4-b64f-731461a2ab11
    

    

      5
      T-101.573.948-5
      夢みる人
      1864
      5c9aca4f-d063-43ee-b914-751dce711cb0
    

    

      6
      T-900.320.006-4
      Whispering Hope
      1868
      38a49407-d688-4a08-8566-fd48bbe61629
    

    

      7
      T-902.828.288-4
      Little Brown Jug
      1868
      1df25567-2470-48d3-8cf5-9638dfd6c0a5
    

    

      8
      T-003.244.561-6
      Giroflé, Girofla
      1870
      23215b05-762d-4f59-99fa-96ca2da39a92
    

    

      9
      T-700.063.271-5
      Silver Threads Among the Gold
      1873
      1a10c334-0281-4183-8ece-037639a1a7d4
    

    

      10
      T-801.955.891-0
      Alle Jahre wieder
      1873
      70cc0378-a66e-49ee-842d-37fa24d74ebb
    

    

      11
      T-900.017.840-5
      Concerto for Trombone and Military Band
      1877
      3e7b25f6-42b6-4ab8-bff4-d8a7dd26df33
    

    

      12
      T-003.014.267-6
      Poème d’amour
      1878
      8a1aff49-5846-49d5-9963-06c51d88e155
    

    

      13
      T-003.022.042-8
      Symphonie en si mineur, L. 10, CD 8
      1880
      bbb113ce-6806-42b7-afbd-963254f8ebda
    

    

      14
      T-004.032.977-8
      Aimons-nous et dormons, L. 16, CD 7
      1880
      bd010e97-8739-495b-8ced-943ca8c22168
    

    

      15
      T-004.061.510-8
      Caprice, L. 5, CD 6 "Quand je baise, pâle de f...
      1880
      9f223f1e-9841-46c4-b64f-731461a2ab11
    

    

      16
      T-004.032.978-9
      Rondel chinois, L. 17, CD 11 "Sur le lac bordé...
      1881
      2077df2f-28ed-4816-b9c4-f401aa4ac6d2
    

    

      17
      T-004.032.979-0
      Jane, L. 19, CD 13 "Je pâlis et tombe en langu...
      1881
      bec74574-8453-4dfb-a78e-6a15f1f214e4
    

    

      18
      T-004.104.825-2
      Helène, L. 20 bis, CD 14 "Franchis les mers ic...
      1881
      cb54194f-ba75-424f-9ff3-73fbbff23237
    

    

      19
      T-004.104.845-6
      L’Archet, L. 46, CD 22 "Elle avait de beaux ch...
      1881
      e72625e6-576d-4ba8-916d-29762104225b
    

    

      20
      T-004.104.830-9
      Fantoches, L. 21, CD 26 "Scaramouche et Pulcin...
      1882
      929b960e-fec7-4222-85ef-40498b483dd1
    

    

      21
      T-071.432.089-4
      Symphony no. 1 in D major “Titan”
      1884
      5b8cb51a-6b4f-48b7-888d-c7f1e812dfba
    

    

      22
      T-900.953.062-5
      Symphony no. 1 in D major “Titan”: IV. Stürmis...
      1884
      0d4b5498-40c4-32a7-8a25-d2c2e29c9301
    

    

      23
      T-003.022.637-9
      Fantaisie-valse (à mon ami J.P. Contamine de L...
      1885
      192ce526-1baf-3656-8ad9-8cc7ed9eaff2
    

    

      24
      T-003.022.638-0
      Valse-ballet, op. 62
      1885
      10e2b732-5368-3a64-9094-f40b6b5ed136
    

    

      25
      T-010.118.145-6
      American Patrol
      1885
      2adf5e8b-449e-4733-9b12-a4a1e844dad8
    

    

      26
      T-011.707.388-7
      American Patrol
      1885
      2adf5e8b-449e-4733-9b12-a4a1e844dad8
    

    

      27
      T-050.039.327-0
      American Patrol
      1885
      2adf5e8b-449e-4733-9b12-a4a1e844dad8
    

    

      28
      T-050.296.426-2
      American Patrol
      1885
      2adf5e8b-449e-4733-9b12-a4a1e844dad8
    

    

      29
      T-050.321.769-3
      American Patrol
      1885
      2adf5e8b-449e-4733-9b12-a4a1e844dad8
    

    

      ...
      ...
      ...
      ...
      ...
    

    

      102
      T-003.006.061-7
      Morceaux de salon, op. 10: no. 3 Barcarolle in...
      1893
      0e218339-fab1-4a65-8d7d-fd1ae1719088
    

    

      103
      T-041.027.715-4
      Canción para un nuevo mundo
      1893
      b3a778bc-2017-4aa7-ab11-ef3a8cf5d0f0
    

    

      104
      T-800.297.436-0
      Unter dem Doppeladler, op. 159
      1893
      4d6b1cd0-697e-39d9-b806-5aa1901b7199
    

    

      105
      T-800.607.042-5
      Going Home (Largo "From the New World")
      1893
      e1257c85-c7d8-3b88-89c8-ebb6f23d9dcb
    

    

      106
      T-800.692.406-8
      Going Home (Largo "From the New World")
      1893
      e1257c85-c7d8-3b88-89c8-ebb6f23d9dcb
    

    

      107
      T-902.818.324-6
      The Liberty Bell
      1893
      26438b4c-2627-31ff-ab07-600167b1318b
    

    

      108
      T-905.029.737-5
      Symfonie č. 9 e moll, op. 95 „Z Nového světa“
      1893
      aacb1ab0-c740-436a-a782-ed60026cf82b
    

    

      109
      T-000.772.528-1
      Juhlamarssi, JS 105
      1894
      1bd6f042-9041-4aba-ac48-bb83d2b3e644
    

    

      110
      T-902.872.366-2
      Six Morceaux, op. 11
      1894
      fbfc280e-40b4-48b2-98b7-9ea608c7f665
    

    

      111
      T-004.033.878-0
      Sérénade du pavé
      1895
      f7e57318-18c0-43e1-9092-f30950c5cfbb
    

    

      112
      T-070.011.254-4
      Big Rock Candy Mountain
      1895
      a75d6157-3ed8-3220-bf1a-72c4e23bf12a
    

    

      113
      T-070.229.967-9
      Big Rock Candy Mountain
      1895
      a75d6157-3ed8-3220-bf1a-72c4e23bf12a
    

    

      114
      T-072.273.259-3
      Big Rock Candy Mountain
      1895
      a75d6157-3ed8-3220-bf1a-72c4e23bf12a
    

    

      115
      T-900.016.313-3
      Waltzing Matilda
      1895
      10644b94-d171-487c-a4a6-c762f068267a
    

    

      116
      T-900.084.448-4
      Big Rock Candy Mountain
      1895
      a75d6157-3ed8-3220-bf1a-72c4e23bf12a
    

    

      117
      T-902.755.223-4
      Symphony no. 1 in D minor, op. 13: IV. Allegro...
      1895
      f38fdd59-0ea6-330f-91ee-ab4c1514ac87
    

    

      118
      T-912.456.424-5
      10 Pieces for Piano, op. 24
      1895
      a31244c0-15b3-4a58-a60f-b067bd572b12
    

    

      119
      T-000.772.528-1
      Juhlamarssi, JS 105
      1896
      1bd6f042-9041-4aba-ac48-bb83d2b3e644
    

    

      120
      T-900.758.021-4
      12 Romances, op. 14: no. 7 "Believe Me Not, Fr...
      1896
      0ee421eb-6df6-4c32-b161-c044a4b1c141
    

    

      121
      T-902.512.965-1
      12 Romances, op. 14: no. 2 "The Isle"
      1896
      e028496e-046f-4d8f-bea8-d81d8ed736c1
    

    

      122
      T-902.751.444-9
      6 moments musicaux, op. 16: no. 1. Andantino i...
      1896
      7c0e55ba-ce26-43cb-b69e-615008b98228
    

    

      123
      T-003.010.186-0
      Gymnopédies
      1897
      c29c5a25-8859-3957-b0fa-3988a7dcaf75
    

    

      124
      T-003.010.186-0
      Gymnopédies: I. Lent et grave
      1897
      f684a145-0650-3acf-8761-c9ba2bdc7e30
    

    

      125
      T-003.138.275-8
      Je te veux
      1897
      9c6277dc-e1ae-31fa-aedb-db69491a0a45
    

    

      126
      T-050.056.026-8
      Pièces froides: no. 1, Airs à faire fuir
      1897
      ff8d52e0-060c-4f27-bbae-0dd1912f60e1
    

    

      127
      T-071.430.241-6
      Pièces froides
      1897
      5fbf5d13-40a4-45dd-b595-6f5ee5b3b450
    

    

      128
      T-010.992.636-4
      Sons of the Brave
      1898
      d8056762-c34c-4899-8f19-6a557f70d945
    

    

      129
      T-801.692.162-4
      Don Carlos
      1899
      4ec255d2-96b5-4697-b1eb-803ca421ed41
    

    

      130
      T-900.766.425-7
      Flight of the Bumblebee, TN iii/9
      1899
      78d4b19e-45df-4b7a-9c38-d0490edc7e3a
    

    

      131
      T-914.726.365-8
      Lift Every Voice and Sing
      1899
      3877db6e-f759-43fb-8942-a5799a971c28
    

  



132 rows × 4 columns

Content source: loujine/musicbrainz-dataviz

Similar notebooks:

notebook.community | gallery | about