Monday, March 24, 2014

Big Data at the Nigerian Movies

Using Big Data and Natural Language Processing techniques to query the Global Graph for Nigerian Movies and Actors.

Using Virtuoso SPARQL editor, I sent the following queries to the LinkedMDB SPARQL Endpoint using Federated SPARQL.

Nigerian Movies on LinkedMDB

The following query lists all the Nigerian movies in the RDF store of LinkedMDB or in SPARQL terms, "show me movies whose 'movie:country' is 'country:NG' which may have a 'dc:title' or a 'dc:date'" :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>

 select ?s ?Title ?Date

 where {
 SERVICE <http://data.linkedmdb.org/sparql> {
 ?s movie:country   country:NG .
 optional { ?s dc:title ?Title. }
 optional { ?s dc:date ?Date. }
  }

 } 
 
[View query in Virtuoso SPARQL Editor]

The answer looks like this.

 ---------------------------------------------------------------------------------------------------
 | S                                               | Title                          | Date         |
 ===================================================================================================
 | <http://data.linkedmdb.org/resource/film/10659> | "Rise and Fall of Idi Amin"    | "1980"       |
 | <http://data.linkedmdb.org/resource/film/16051> | "Osuofia in London"            |              |
 | <http://data.linkedmdb.org/resource/film/16118> | "Ezra"                         | "2007-01-23" |
 | <http://data.linkedmdb.org/resource/film/16130> | "Aki na Ukwa"                  |              |
 | <http://data.linkedmdb.org/resource/film/16131> | "2 Rats"                       | "2003"       |
 | <http://data.linkedmdb.org/resource/film/16463> | "Above Death: In God We Trust" | "2003"       |
 | <http://data.linkedmdb.org/resource/film/17663> | "Abuja Connection"             |              |
 | <http://data.linkedmdb.org/resource/film/24122> | "Missing Angel"                |              |
 ---------------------------------------------------------------------------------------------------

 
[Run the query using URIburner Endpoint].

Wow! they have only 8 Nigerian movies in their dataset.

Who acted in the movie "2 Rats"

Let us find out who acted in the movie "2 Rats" by using the following query. In SPARQL terms "show me the 'movie:actor' of '.../film/16131' and also tell me his '?Name'" :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>

 select ?Name

 where {
 SERVICE <http://data.linkedmdb.org/sparql> {
 <http://data.linkedmdb.org/resource/film/16131>  movie:actor ?actor .
 ?actor movie:actor_name ?Name .

  }

 } 
 
[View query in Virtuoso SPARQL Editor].

The answer .

 --------
 | Name |
 ========
 --------
 
[Run the query using URIburner Endpoint].

Wow! LinkedMDB does not have that information. Let me see what else they have on the movie using the following query or in SPARQL terms "show me all you have on the subject of '.../film/16131'" :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>
 PREFIX dbowl: <http://dbpedia.org/ontology/>

 select *

 where {
 SERVICE <http://data.linkedmdb.org/sparql> {
 <http://data.linkedmdb.org/resource/film/16131> ?PropertyName ?Value
  

  }

 } 


 
[View query in Virtuoso SPARQL Editor]

The answer.

 ----------------------------------------------------------------------------------------------------------------------------
 | property                                          | object                                                               |
 ============================================================================================================================
 | <http://xmlns.com/foaf/0.1/based_near>            | <http://sws.geonames.org/2328926/>                                   |
 | <http://xmlns.com/foaf/0.1/page>                  | <http://www.freebase.com/view/guid/9202a8c04000641f8000000005674af3> |
 | movie:initial_release_date                        | "2003"                                                               |
 | dc:date                                           | "2003"                                                               |
 | movie:country                                     | country:NG                                                           |
 | movie:language                                    | <http://www.lingvoj.org/lingvo/en>                                   |
 | movie:filmid                                      | "16131"^^<http://www.w3.org/2001/XMLSchema#int>                      |
 | dc:title                                          | "2 Rats"                                                             |
 | rdfs:label                                        | "2 Rats"                                                             |
 | <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> | movie:film                                                           |
 ----------------------------------------------------------------------------------------------------------------------------

 
[Run the query using URIburner Endpoint]

This just shows the release date, country, lanaguage, title of the movie. This is not much. Let us check from the very nucleus of the Linked Open Data web, DBpedia (http://dbpedia.org), if they have some more data than LinkedMDB.

"2 Rats" at DBpedia

Let us see if we can catch "2 Rats" in DBpedia by using the following query or in SPARQL terms "show us the ?moviename and ?actor of any dbpedia:Film that has '2 Rats' in its name and dbprop:country is 'nigeria' " :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>

 select ?s as ?Movie ?moviename as ?Name ?actor as ?Actor

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbprop:country ?country.

 ?s dbpedia:starring ?dbname .
 ?s rdfs:label ?moviename.
 ?dbname dbprop:name ?actor.
 filter regex(?moviename,"^2 Rats") .
 filter regex(?country,"^nigeria","i") .


  }

 } 
 
[View query in Virtuoso SPARQL Editor]

The answer .

 -------------------------------------------------------------------------------
 | s                                    | moviename   | actor                  |
 ===============================================================================
 | <http://dbpedia.org/resource/2_Rats> | "2 Rats"@en | "Osita Iheme"@en       |
 | <http://dbpedia.org/resource/2_Rats> | "2 Rats"@en | "Iheme, Osita"@en      |
 | <http://dbpedia.org/resource/2_Rats> | "2 Rats"@en | "Chinedu Ikedieze"@en  |
 | <http://dbpedia.org/resource/2_Rats> | "2 Rats"@en | "Ikedieze, Chinedu"@en |
 -------------------------------------------------------------------------------
 
[Run the query using URIburner Endpoint]

Now we can see that DBpedia has the actors name.

What else do they have on the movie

Let us check for the movie description, director, distributor with the following query. In SPARQL terms "show me the ?director and ?distributor of any dbpedia:Film that has '2 Rats' in its name and dbprop:country is 'nigeria'" :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>

 select distinct ?s as ?Movie ?director ?distributor

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbprop:country ?country.

 ?s dbpedia:starring ?dbname .
 ?s rdfs:label ?moviename.
 ?s rdfs:comment ?description .
 ?s dbprop:director ?director.
 ?s dbprop:distributor ?distributor.
 ?dbname dbprop:name ?actor.
 filter regex(?moviename,"^2 Rats") .
 filter regex(?country,"^nigeria","i") .


  }

 } 
 
[View query in Virtuoso SPARQL Editor]

and the result shows

 -----------------------------------------------------------------------------------------------
 | s                                    | director         | distributor                       |
 ===============================================================================================
 | <http://dbpedia.org/resource/2_Rats> | "Andy Chukwu"@en | "OJ Productions International"@en |
 -----------------------------------------------------------------------------------------------
 
[Run the query using URIburner Endpoint]

so we can now see that DBpedia has much more information on this movie. We can get more information like the movie description with the following query.

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>

 select distinct ?description as ?Summary

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbprop:country ?country.

 ?s dbpedia:starring ?dbname .
 ?s rdfs:label ?moviename.
 ?s rdfs:comment ?description .
 ?s dbprop:director ?director.
 ?s dbprop:distributor ?distributor.
 ?dbname dbprop:name ?actor.
 filter regex(?moviename,"^2 Rats") .
 filter regex(?country,"^nigeria","i") .


  }

 } 
 
[View query in Virtuoso SPARQL Editor]

and it showed....


 | "2 Rats is a 2003 Nigeria film. Nollywood's highest paid actors, Osita Iheme (A-boy) and Chinedu Ikedieze (Bobo) are two young boys whose father has been murdered by their uncle. In a selfish move, Amaechi Muonagor wants them to work as house boys in their father's own house. A-boy and Bobo have other plans. The film features performances by Aki na Pawpaw and can be dubbed as Nollywood's Home Alone."@en |
 
[Run the query using URIburner Endpoint]

Chinedu Ikedieze's filmography

Which other movie did Chinedu Ikedieze star in? Let us ask DBpedia the following query or in SPARQL terms "Show us any 'dbpedia:Film' 'dbpedia:starring' 'dbr:Chinedu_Ikedieze', giving us the '?director' and '?distributor' if available " :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>
 PREFIX dbr: <http://dbpedia.org/resource/>

 select distinct ?s as ?Movie ?director ?distributor

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbpedia:starring dbr:Chinedu_Ikedieze .
 optional {?s dbprop:director ?director. }
 optional {?s dbprop:distributor ?distributor. }

  }

 } 

 
[View query in Virtuoso SPARQL Editor]

and the result showed ...

 ---------------------------------------------------------------------------------------
 | s                  | director                   | distributor                       |
 =======================================================================================
 | dbr:2_Rats         | "Andy Chukwu"@en           | "OJ Productions International"@en |
 | dbr:Aki_na_Ukwa    | "Amayo Uzo Philips"@en     | "Kas-Vid International"@en        |
 | dbr:Games_Men_Play | dbr:Lancelot_Oduwa_Imasuen |                                   |
 ---------------------------------------------------------------------------------------
 
[Run the query using URIburner Endpoint]

Hmm! only 3 films.

Chinedu Ikedieze and Osita Iheme

Which films in DBpedia have starred both Chinedu and Osita together? Let us ask with the following query :

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>
 PREFIX dbr: <http://dbpedia.org/resource/>

 select distinct ?s as ?Movie ?director ?distributor

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbpedia:starring dbr:Chinedu_Ikedieze .
 ?s dbpedia:starring dbr:Osita_Iheme .
 optional {?s dbprop:director ?director. }
 optional {?s dbprop:distributor ?distributor. }

  }

 } 
 
[View query in Virtuoso SPARQL Editor]

The answer.

 --------------------------------------------------------------------------------
 | s               | director               | distributor                       |
 ================================================================================
 | dbr:2_Rats      | "Andy Chukwu"@en       | "OJ Productions International"@en |
 | dbr:Aki_na_Ukwa | "Amayo Uzo Philips"@en | "Kas-Vid International"@en        |
 --------------------------------------------------------------------------------
 
[Run the query using URIburner Endpoint]

Just only 2 movies.

Nollywood in DBpedia

Let us ask DBpedia which Nigerian movies does it have, using the following query or in SPARQL terms "show us all the dbpedia:Film you have that dbprop:country is 'nigeria' and give it to me in english language".

 ## SPARQL Query
 PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 PREFIX movie: <http://data.linkedmdb.org/resource/movie/>
 PREFIX dc: <http://purl.org/dc/terms/>
 PREFIX country: <http://data.linkedmdb.org/resource/country/>
 PREFIX dbpedia: <http://dbpedia.org/ontology/>
 PREFIX dbprop: <http://dbpedia.org/property/>
 PREFIX dbr: <http://dbpedia.org/resource/>

 select distinct ?s as ?Movie ?moviename as ?Name ?country as ?Country

 where {
 SERVICE <http://dbpedia.org/sparql> {
 ?s a dbpedia:Film .
 ?s dbprop:country ?country.
 optional {?s rdfs:label ?moviename. }

 filter regex(?country,"^nigeria","i") .
 filter (lang(?moviename) ='en') .
  }

 } 

 
[View query in Virtuoso SPARQL Editor]

The answer.

 -----------------------------------------------------------------------------------------------------------------------
 | s                                                             | country      | moviename                            |
 =======================================================================================================================
 | <http://dbpedia.org/resource/Area_Boys_(film)>                | "Nigeria"@en | "Area Boys (film)"@en                |
 | dbr:Lilies_of_the_Ghetto                                      | "Nigeria"@en | "Lilies of the Ghetto"@en            |
 | dbr:Living_in_Bondage                                         | "Nigeria"@en | "Living in Bondage"@en               |
 | dbr:Mirror_Boy                                                | "Nigeria"@en | "Mirror Boy"@en                      |
 | dbr:Oni_Ise_Owo                                               | "Nigeria"@en | "Oni Ise Owo"@en                     |
 | <http://dbpedia.org/resource/Rag_Tag_(film)>                  | "Nigeria"@en | "Rag Tag (film)"@en                  |
 | dbr:Rising_Moon                                               | "Nigeria"@en | "Rising Moon"@en                     |
 | dbr:Tango_with_Me                                             | "Nigeria"@en | "Tango with Me"@en                   |
 | dbr:The_Mayors                                                | "Nigeria"@en | "The Mayors"@en                      |
 | dbr:2_Rats                                                    | "Nigeria"@en | "2 Rats"@en                          |
 | <http://dbpedia.org/resource/30_Days_(2006_film)>             | "Nigeria"@en | "30 Days (2006 film)"@en             |
 | dbr:Games_Men_Play                                            | "Nigeria"@en | "Games Men Play"@en                  |
 | dbr:The_Figurine                                              | "Nigeria"@en | "The Figurine"@en                    |
 | dbr:Jenifa                                                    | "Nigeria"@en | "Jenifa"@en                          |
 | <http://dbpedia.org/resource/Above_Death:_In_God_We_Trust>    | "Nigeria"@en | "Above Death: In God We Trust"@en    |
 | dbr:Abuja_Connection                                          | "Nigeria"@en | "Abuja Connection"@en                |
 | dbr:Aki_na_Ukwa                                               | "Nigeria"@en | "Aki na Ukwa"@en                     |
 | <http://dbpedia.org/resource/Anchor_Baby_(film)>              | "Nigeria"@en | "Anchor Baby (film)"@en              |
 | <http://dbpedia.org/resource/Black_Gold_(2011_Nigerian_film)> | "Nigeria"@en | "Black Gold (2011 Nigerian film)"@en |
 | <http://dbpedia.org/resource/Ezra_(film)>                     | "Nigeria"@en | "Ezra (film)"@en                     |
 | dbr:Missing_Angel                                             | "Nigeria"@en | "Missing Angel"@en                   |
 | dbr:Osuofia_in_London                                         | "Nigeria"@en | "Osuofia in London"@en               |
 -----------------------------------------------------------------------------------------------------------------------
 
[Run the query using URIburner Endpoint]

Wow! just only 21 movies.

Conclusion

The web of linked data or Semantic Web is a global information space consisting of inter-linked data. SPARQL enables applications to query this global graph or database for information about resources or entities.
.
I have shown how easy to query these graphs for information on Nollywood. We have also seen that not enough information on Nollywood exist in the global graph so there is need to publish more.

Why? Applications can consume the results of these kind of queries to create a rich experience for users in interacting with these resources e.g. movie recommendation app, an actor app, etc.

  Emeka Okoye

Keywords: linkedopendatang, linkedopendata, opendatang, linkeddata, lod, nigeria, sparql, films, movies, nollywood

References

http://www.linkedmdb.org/ - LinkedMDB.

http://dbpedia.org - DBpedia.

http://en.wikipedia.org/wiki/SPARQL - About SPARQL.

http://www.w3.org/TR/rdf-sparql-query/ - SPARQL Query Language for RDF.

http://semanticweb.org/wiki/SPARQL_endpoint - SPARQL Endpoint.

http://www.w3.org/TR/sparql11-federated-query/ - Federated SPARQL.

http://linkeddata.uriburner.com/sparql/ - URIBurner SPARQL Endpoint.

http://virtuoso.openlinksw.com/ - Openlink Virtuoso.

Tuesday, March 18, 2014

Edo State Food Centers Search App

Introduction
As we are have converted some of Edo State Open Data datasets to Linked Data, you are probably thinking what applications we can develop from the data. We decided to use the Food Centers list to create a cool app.

About The App
The app, "Food Centers", let's you search for eatries, restaurants, bukas (local restaurants), etc in Edo State by street or business names. You can find the application here.

How Does It Work
It's simple and straightforward.

  • Start the application
  • Enter a street name (without the 'street') or business name in the 'Find' box.
  • Click the 'Search' button
  • A SPARQL query based on your search is generated and sent to a SPARQL Endpoint using PHP CURL lib.
  • The search result is retrieved in JSON format and displayed with JQuery Mobile
  • Each business name is anchored with a URI so that It can be exploited via Linked Data follow-your-nose

Further Work
We will geocode each of the addresses and display them on Google map.

Under The Hood
The app was developed with PHP, JQuery mobile, SPARQL, HTML5. The data was converted to RDF format.

Data
RDF/Turtle, RDF/XML.

SPARQL query


   prefix foaf: <http://xmlns.com/foaf/0.1/> 
   prefix edo: <http://www.vikanttimobile.com/opendatang/data/edo-food-centers.ttl#> 
   select distinct ?biz ?Name? Address 
   from <http://www.vikanttimobile.com/opendatang/data/edo-food-centers.ttl> 
   where { 
   ?biz a foaf:Organization. 
   ?biz edo:IsLocated ?Address . 
   ?biz foaf:name ?Name.
   FILTER ( regex(?Name,'" + nameValue + "','i')  || regex(?Address,'" + nameValue + "','i')    ) 
       }
  

  Emeka Okoye

Keywords: linkedopendatang, linkedopendata, opendatanigeria, opendatang, opendata, linkeddata, buka, nigeria, restaurant, hotel, naija30, food, edo

Edo State Food Centers Search App.

Edo State Open Data

Edo State Food Centers in RDF/Turtle

Thursday, March 6, 2014

Dataset: State of Nigerian Universities 2012

Description State of Nigerian Universities 2012 .

         

Country: Nigeria

RDF/XML.

Keywords: linkedopendatang, linkedopendata, opendatanigeria, opendatang, opendata, linkeddata, graduate, school, dataset, nigeria, universities, education, naija30, africa30, undergraduate

Information: About the Linked Data document.

Predicates/Properties [via URIBurner Endpoint], [via SPARQLer Endpoint]

Linked Data Follow Your Nose (hosted on rww.io)

Sample Visualization: Pie Chart on the Population of Nigerian Undergraduates by their Courses

Sample SPARQL Queries:

  Emeka Okoye

State of Nigerian Universities 2012.

Tuesday, March 4, 2014

Dataset: Edo State Food Centers

Description Edo State Food Centers .

     

Country: Nigeria

RDF/XML.

Keywords: linkedopendatang, linkedopendata, opendatanigeria, opendatang, opendata, linkeddata, dataset, nigeria, edo, food, naija30, africa30, restaurant

Information: About the Linked Data document.

Predicates/Properties [via URIBurner Endpoint], [via SPARQLer Endpoint]

Linked Data Follow Your Nose (hosted on rww.io)

Sample Visualization:

Sample SPARQL Queries:

  Emeka Okoye

List of food centers in Edo State Nigeria.

Dataset: Nigerian Government Budgets for Education

Description Nigeria Government Budgets For Education .

Country: Nigeria

RDF/XML.

Keywords: linkedopendatang, linkedopendata, opendatanigeria, opendatang, opendata, linkeddata, dataset, nigeria, budget, examination, naija30, africa30, education

Information: About the Linked Data document.

Predicates/Properties [via URIBurner Endpoint], [via SPARQLer Endpoint]

Linked Data Follow Your Nose (hosted on rww.io)

Sample Visualization:

Sample SPARQL Queries:

 The top Education Budgets in recent time based on percentage of allocation to Education [via URIBurner Endpoint], [via SPARQLer Endpoint] .

prefix odng: <http://www.vikanttimobile.com/opendatang/data/odng-education-budget.ttl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select str(?year) as ?Year, str(?alloc) as ?Education, str(?budget) as ?TotalBudget, str(?percent) as ?Percent from <http://www.vikanttimobile.com/opendatang/data/odng-education-budget.ttl> where { ?s odng:year ?year . ?s odng:educationAllocation ?alloc. ?s odng:totalBudget ?budget. optional { ?s odng:percentage ?percent. } } order by desc(xsd:double(?percent))

Edit the above query

  Emeka Okoye

Nigeria Government Budgets For Education.

Dataset: West African Examination Council (WAEC) Examination Results

Description Results of the West African Examination Council Examination in Nigeria .

Country: Nigeria

RDF/XML, CSV.

Keywords: linkedopendatang, linkedopendata, opendatanigeria, opendatang, opendata, linkeddata, dataset, nigeria, waec, examination, naija30, africa30, education

Information: About the Linked Data document.

Predicates/Properties [via URIBurner Endpoint], [via SPARQLer Endpoint]

Linked Data Follow Your Nose (hosted on rww.io)

Sample Visualization:

Sample SPARQL Queries:

 The top 5 WAEC Examinations with the best performance in 5 subjects including English and Maths [via URIBurner Endpoint], [via SPARQLer Endpoint] .

prefix odng: <http://www.vikanttimobile.com/opendatang/data/odng-education-waec-results.ttl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select  ?examName as ?Examination, str(?totalCandidates) as ?TotalCandidates, str(?scored5creditsengmaths) as ?Scored5CreditsEngMaths, str(?pctScored5creditsengmaths) as ?PercentScored5creditsEngMaths from <http://www.vikanttimobile.com/opendatang/data/odng-education-waec-results.ttl> where { ?s rdfs:label ?examName. ?s odng:totalCandidates  ?totalCandidates . ?s odng:have5CreditsWithEnglishMaths  ?scored5creditsengmaths . ?s odng:pct5CreditsEnglishMaths ?pctScored5creditsengmaths . optional {?s odng:have6Credits ?scored6credits .} optional {?s odng:have5Credits ?scored5credits .} optional {?s odng:have4Credits ?scored4credits .} optional {?s odng:have3Credits ?scored3credits .} optional {?s odng:have2Credits ?scored2credits .}

} order by desc(xsd:integer(?pctScored5creditsengmaths)) limit 5

Edit the above query

 The top 5 WAEC Examinations with the worst performance in 5 subjects including English and Maths [via URIBurner Endpoint], [via SPARQLer Endpoint] .

prefix odng: <http://www.vikanttimobile.com/opendatang/data/odng-education-waec-results.ttl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select  ?examName as ?Examination, str(?totalCandidates) as ?TotalCandidates, str(?scored5creditsengmaths) as ?Scored5CreditsEngMaths, str(?pctScored5creditsengmaths) as ?PercentScored5creditsEngMaths from <http://www.vikanttimobile.com/opendatang/data/odng-education-waec-results.ttl> where { ?s rdfs:label ?examName. ?s odng:totalCandidates  ?totalCandidates . ?s odng:have5CreditsWithEnglishMaths  ?scored5creditsengmaths . ?s odng:pct5CreditsEnglishMaths ?pctScored5creditsengmaths . optional {?s odng:have6Credits ?scored6credits .} optional {?s odng:have5Credits ?scored5credits .} optional {?s odng:have4Credits ?scored4credits .} optional {?s odng:have3Credits ?scored3credits .} optional {?s odng:have2Credits ?scored2credits .}

} order by asc(xsd:integer(?pctScored5creditsengmaths)) limit 5

Edit the above query

  Emeka Okoye

Results of the West African Examination Council Examination in Nigeria.

Dataset: Joint Admission Matriculation Board (JAMB) Examination Results

Description Results of the Joint Admission Matriculation Board Examinations in Nigeria .

Country: Nigeria

RDF/XML, CSV.

Keywords: opendatanigeria, opendatang, opendata, linkeddata, dataset, nigeria, jamb, examination, naija30, africa30, education

Information: About the Linked Data document.

Predicates/Properties [via URIBurner Endpoint], [via SPARQLer Endpoint]

Linked Data Follow Your Nose (hosted on rww.io)

Sample Visualization:

Sample SPARQL Queries:

 The best 5 performances in JAMB Exams based on the number of candidates that scored more than 50% [via URIBurner Endpoint], [via SPARQLer Endpoint] .

prefix odng: <http://www.vikanttimobile.com/opendatang/data/odng-education-jexams-results.ttl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?description, ?year, str(?totalCandidate) as ?totalCandidates , str(?scoredAbove200) as ?scoredMoreThan200 , xsd:double(?scoredAbove200) / xsd:double(?totalCandidate) * 100 as ?percent from <http://www.vikanttimobile.com/opendatang/data/odng-education-jexams-results.ttl> where { ?s odng:examOrganization ?exambody . ?s rdfs:label ?description . ?s odng:year ?year . ?s odng:totalAbove200 ?scoredAbove200 . optional {?s odng:totalCandidate ?totalCandidate .} optional {?s odng:above300 ?scoredAbove300 .} optional {?s odng:between270to299 ?scoredAbove270 .} optional {?s odng:between200to249 ?scoredAbove200 .} optional {?s odng:below170 ?scoredBelow170 .} optional {?s odng:between250to270 ?scoredAbove250 .} optional {?s odng:totalBelow200 ?scoredBelow200 .} } order by desc(xsd:integer(?percent ))

Edit the above query

 The top JAMB Examinations that had candidates that scored more than 300 points [via URIBurner Endpoint], [via SPARQLer Endpoint].

prefix odng: <http://www.vikanttimobile.com/opendatang/data/odng-education-jexams-results.ttl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select ?description, ?year, str(?totalCandidate) as ?totalCandidates , str(?scoredAbove300) as ?scoredAbove300 from <http://www.vikanttimobile.com/opendatang/data/odng-education-jexams-results.ttl> where { ?s odng:examOrganization ?exambody . ?s rdfs:label ?description . ?s odng:year ?year . ?s odng:above300 ?scoredAbove300 . optional {?s odng:totalCandidate ?totalCandidate .} optional {?s odng:above300 ?scoredAbove300 .} optional {?s odng:between270to299 ?scoredAbove270 .} optional {?s odng:between200to249 ?scoredAbove200 .} optional {?s odng:below170 ?scoredBelow170 .} optional {?s odng:between250to270 ?scoredAbove250 .} optional {?s odng:totalBelow200 ?scoredBelow200 .} } order by desc(xsd:integer(?scoredAbove300 ))

Edit the above query

  Emeka Okoye

Results of the Joint Admission Matriculation Board Examinations in Nigeria.