'What changed in the SPARQL code for this parliamentary term?
I have been successfully retrieving data from the following Open-Link Dataset: http://linkedpolitics.ops.few.vu.nl/web/html/home.html for the 5th, 6th and 7th parliamentary term of the EP which I am then cleaning in STATA.
However, the coding seems to differ for the 8th term because I get a lot less speeches when I use the lpv:translatedText function that I have used before. I can't help but think that a LOT more should come up in the timeframe I am specifying than what the SPARQL endpoint returns. Can anyone help me figure out what I am doing wrong?
Here is the code I used for National parties (here with the dates for anything after the 7th term):
SELECT DISTINCT ?name ?countryname ?birth ?gender ?partyname ?start ?end ?date ?speechnr ?parlterm ?dictionary
WHERE {
?speech lpv:translatedText ?text.
?speech dcterms:date ?date.
?speech lpv:docno ?speechnr.
?speech lpv:speaker ?speaker.
?speaker lpv:name ?name.
?speaker lpv:dateOfBirth ?birth.
?speaker lpv:gender ?gender.
?speaker lpv:politicalFunction ?function.
?function lpv:institution ?party.
?party rdf:type lpv:NationalParty.
?party rdfs:label ?partyname.
?function lpv:beginning ?start.
?function lpv:end ?end.
?speaker lpv:countryOfRepresentation ?country.
?country rdfs:label ?countryname.
BIND("8" as ?parlterm)
BIND("representation" as ?dictionary)
FILTER ( ?date > "2014-07-01"^^xsd:date )
FILTER(langMatches(lang(?text), "en"))
FILTER(CONTAINS(?text, 'female representation') || CONTAINS(?text, 'women’s representation') || CONTAINS(?text, 'equal representation') || CONTAINS(?text, 'gender representation') || CONTAINS(?text, 'women in science') || CONTAINS(?text, 'women in business') || CONTAINS(?text, 'women’s leadership'))
} ORDER BY ?date ?speechnr
and here is the code I used for the FEMM committee (again anything after 7th parliamentary term):
SELECT DISTINCT ?name ?countryname ?birth ?gender ?start_com ?end_com ?date ?speechnr ?parlterm ?dictionary ?FEMM
WHERE {
?speech lpv:translatedText ?text.
?speech dcterms:date ?date.
?speech lpv:docno ?speechnr.
?speech lpv:speaker ?speaker.
?speaker lpv:name ?name.
?speaker lpv:dateOfBirth ?birth.
?speaker lpv:gender ?gender.
?speaker lpv:politicalFunction ?function.
?function lpv:institution ?institution.
?institution rdfs:label ?committee.
FILTER CONTAINS (?committee, "Committee on Women's Rights and Gender Equality")
BIND("Yes" as ?FEMM).
?function lpv:beginning ?start_com.
?function lpv:end ?end_com.
?speaker lpv:countryOfRepresentation ?country.
?country rdfs:label ?countryname.
BIND("8" as ?parlterm)
BIND("representation" as ?dictionary)
FILTER ( ?date > "2014-07-01"^^xsd:date )
FILTER(langMatches(lang(?text), "en"))
FILTER(CONTAINS(?text, 'female representation') || CONTAINS(?text, 'women’s representation') || CONTAINS(?text, 'equal representation') || CONTAINS(?text, 'gender representation') || CONTAINS(?text, 'women in science') || CONTAINS(?text, 'women in business') || CONTAINS(?text, 'women’s leadership'))
} ORDER BY ?date ?speechnr
Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
