Experiments


Whose Birthday is Today?

chdl-0001-c

See performers and composers from Carnegie Hall’s performance history who were born on this day. Click on each name to view information on that person from our online Performance History Search, and view matching items in Wikidata.

read lab report return to experiments

Birth Year Name with PHS Link Birth Place Matching Wikidata Item
1637 Bernardo Pasquini born in Massa Wikidata Item
1813 Stephen Glover born in London Wikidata Item
1820 Karl Anton Florian Eckert born in Potsdam Wikidata Item
1827 Teodoro Cottrau born in Naples Wikidata Item
1827 Marc Monnier born in Florence Wikidata Item
1840 Hermann Goetz born in Königsberg Wikidata Item
1842 Jules Grison born in Château-Porcien Wikidata Item
1845 George A. Minor born in Richmond Wikidata Item
1849 Henry Somerset born in County Galway Wikidata Item
1860 Richard Burmeister born in Hamburg Wikidata Item
1863 John E. (John Ebenezer) West born in London Wikidata Item
1863 Pietro Mascagni born in Livorno Wikidata Item
1866 Edwin H. Hughes born in Moundsville Wikidata Item
1873 Willa Cather born in Gore Wikidata Item
1879 Rudolf Friml born in Prague Wikidata Item
1885 Paul van Katwijk born in Rotterdam Wikidata Item
1887 Ernst Toch born in Vienna Wikidata Item
1888 Heywood Broun born in Brooklyn Wikidata Item
1888 Hamilton Fish born in Garrison Wikidata Item
1895 Peretz Markish born in Polonne Wikidata Item
1899 Dmitry Pokrass born in Kyiv Wikidata Item
1901 Milton Douglas born in New York City No Wikidata Item
1902 Ted Mesang born in Eau Claire No Wikidata Item
1904 Clarence Nash born in Watonga Wikidata Item
1905 Charles Magnante born in New York City Wikidata Item
1907 Wanda Toscanini Horowitz born in Milan Wikidata Item
1910 Richard Franko Goldman born in New York City Wikidata Item
1911 Louis Prima born in New Orleans Wikidata Item
1916 Jean Carignan born in Lévis Wikidata Item
1921 Arne Dørumsgaard born in Fredrikstad Wikidata Item
1922 Maurice Edwards born in Amasa No Wikidata Item
1924 Ernest Fleischmann born in Frankfurt am Main Wikidata Item
1925 Elizabeth Benson-Guy born in Halifax No Wikidata Item
1927 Vlastimir Pericic born in Vršac Wikidata Item
1930 Richard Felciano born in Santa Rosa Wikidata Item
1935 Jean-Claude Casadesus born in Paris Wikidata Item
1935 Armando Manzanero born in Merida Wikidata Item
1936 Thlan Aldridge born in The Bronx No Wikidata Item
1942 Jonathan D. Kramer born in Hartford Wikidata Item
1942 Harry Chapin born in Brooklyn Wikidata Item
1946 Trent Kynaston born in Tucson Wikidata Item
1947 David Gordon born in Doylestown Wikidata Item
1949 Tom Waits born in Pomona Wikidata Item
1955 Chuck Loeb born in Nyack Wikidata Item
1955 Wladyslaw Klosiewicz born in Warsaw Wikidata Item
1957 Chaya Czernowin born in Haifa Wikidata Item
1957 Máximo Diego Pujol born in Buenos Aires Wikidata Item
1959 Paul Desenne born in Caracas Wikidata Item
1959 Ronald Caltabiano born in New York City Wikidata Item
1960 Matthew Shipp born in Wilmington Wikidata Item
1960 Robby Ameen born in New Haven Wikidata Item
1963 Alexander Kukelka born in Klement Wikidata Item
1963 Kuba Stankiewicz born in Wrocław Wikidata Item
1971 Stephanie D'Abruzzo born in Pittsburgh Wikidata Item
1974 Phil Cunningham born in Macclesfield Wikidata Item
1975 Pat Bianchi born in Rochester Wikidata Item
1977 Redi Hasa born in Tirana Wikidata Item
1979 Sara Bareilles born in Eureka Wikidata Item
1981 Andrea Tierra born in Medellín No Wikidata Item
1981 Era Hoxha born in North Macedonia No Wikidata Item
1987 Tigran Hamasyan born in Gyumri Wikidata Item
1988 Benjamin Clementine born in Crystal Palace Wikidata Item

lab report


EXPERIMENT LABEL/TITLE

List: Whose Birthday is Today?

TL;DR

See which composers and performers from Carnegie Hall’s performance history were born on this day, with their birth year, birthplace, and a link to their corresponding Wikidata item.


The scope is limited to those people for whom we have birthdate and birthplace information.

METHODS

We created a SPARQL query using data.carnegiehall.org, which finds people from Carnegie Hall's performance history (e.g. performers, and/or creators like composers, arrangers, lyricists, etc.) born on today's date. Since birthdates have been stored as ISO-8601 dates assigned datatypes like xsd:date (YYYY-MM-DD), xsd:gYearMonth (YYYY-MM), or xsd:gYear (YYYY), we can use SPARQL's FILTER to find only those people born on today's month and day. Birthplaces are identified using GeoNames URIs (when the birth city is not known, birth country will be used; people with no birthplace recorded will not appear in the query). The query will also return the Wikidata item ID for anyone whose Carnegie Hall ID has been aligned with Wikidata using the skos:exactMatch property.


              PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
              PREFIX dbo: <http://dbpedia.org/ontology/#>
              PREFIX schema: <http://schema.org/##>
              PREFIX foaf: <http://xmlns.com/foaf/0.1/##>
              PREFIX geo-pos: <http://www.w3.org/2003/01/geo/wgs84_pos##>
              PREFIX skos: <http://www.w3.org/2004/02/skos/core##>
              SELECT ?personName ?birthPlace ?birthPlaceLabel ?lat ?long ?opasID ?wikidataLink (YEAR(?date) as ?year)
              (IRI(CONCAT("https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&pf=",
                            (STR(ENCODE_FOR_URI(?personName))))) AS ?perfLink)
              (IRI(CONCAT("https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&cmp=",
                            (STR(ENCODE_FOR_URI(?personName))))) AS ?compLink)
              WHERE
              {
                  BIND(MONTH(NOW()) AS ?nowMonth)
                  BIND(DAY(NOW()) AS ?nowDay)

                  ?personID schema:birthDate ?date ;
                          foaf:name ?personName ;
                          dbo:birthPlace ?birthPlace .
                  ?birthPlace rdfs:label ?birthPlaceLabel ;
                              geo-pos:lat ?lat ;
                              geo-pos:long ?long .
                  OPTIONAL { ?personID skos:exactMatch ?wikidataLink .
                      filter contains(str(?wikidataLink), "wikidata")}
                  BIND(REPLACE(str(?personID), "http://data.carnegiehall.org/names/", "") as ?opasID)
                  FILTER (MONTH(?date) = ?nowMonth && DAY(?date) = ?nowDay)

              }
              ORDER BY ?year
              LIMIT 100
            

In order to provide an easily human-readable version of each person’s history at the hall, we also use SPARQL to create a link to Performance History Search, an HTML presentation of essentially the same dataset that we published first in 2013 (and predates our experiments with LOD). (In the query, this is found right after the SELECT statement, where you'll see (IRI(CONCAT( etc.)

CONCLUSIONS

what we learned

You might be asking why we need to formulate different versions of the PHS link. The HTML version launched in 2013, well prior to our release of the same data as RDF in 2017; although the source database is the same, the process that translates the data for display is a bit different and was developed separately. This creates a few challenges when attempting to create links to PHS search filters:

  • Our source database for CH’s performance history data, a proprietary SQL-based product designed for concert planning, stores performers and composers in separate tables. When the data is surfaced in the HTML Performance History Search (PHS), that separation between composers and performers remains. Query filters are constructed from a search index based on the name string of the composer or performer.
  • Our RDF version of the data solves this problem of (potential) dual IDs by creating a single ID for each named entity, with statements defining their role according to associations with creative works (as a composer, arranger, lyricist, etc.) and/or events (as a performer).
  • In order to construct the PHS link, a URL-safe version of the Wikidata item label (i.e. the name of the composer or performer, with URL-encoded characters replacing spaces and other reserved characters) must be concatenated with a base URL, e.g. https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&pf=Juan%20Tizol.

further investigation

Eventually our goal is to bring all online historical content — our performance history and digital collections — into a single, unified user experience using our LOD as the metadata "backbone". The Carnegie Hall Data Lab is a first step in that direction, where we can begin experimenting with user-friendly ways to surface our performance history data.


return to experiments