I’ve recently been playing with the semantic web (for the uninitiated, the semantic web is a structuring of web content in terms of what it depicts instead of just a bunch of linked text files) and have come up with the following two queries — let me know if you find these useful!

For SPARQL (I.e., dbpedia), the following should return how many competitors each country is sending to the London 2012 Olympics:

SELECT ?country ?competitors WHERE { ?s foaf:page ?country . ?s rdf:type http://dbpedia.org/ontology/OlympicResult. ?s http://dbpedia.org/property/games “2012”^^http://www.w3.org/2001/XMLSchema#int . ?s dbpprop:competitors ?competitors } order by desc(?competitors)

See results by going here.

Meanwhile, if you want a MQL query (I.e., Freebase), use the following to give a comprehensive array of Golden Raspberry Award “winners”:


    query: {
          "id": "/en/golden_raspberry_awards",
          "type": "/award/award",
          "category": [{
            "name": null,
            "name!=" : "Razzie Award for Worst Actor of the Decade", 
            "AND:name!=" : "Razzie Award for Worst Actress of the Decade",
            "nominees": [{          
                  "year": null,
                  "award_nominee": [],
                  "nominated_for": [],
                 "sort": "-year"
                }], /* nominees */
            "winners": [{
              "s1:/type/reflect/any_master" : [{
                "type": "/award/award_winner",
                "name": null,
                "key" : [{
                  "namespace" : "/wikipedia/en",
                  "value": null,
                  "limit": 1
                    }] /* key */
                }], /* award_winner */
              "s2:/type/reflect/any_master" : [{
                "type": "/award/award_winning_work",
                "name": null,
                }] /* award_winning_work */
            }] /* winners */
        }] /* category */
    }  /* query */      


Output here.

I’ll be writing a fairly comprehensive blog tutorial on this sometime in the next few weeks; follow me on Twitter for updates.