All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 56 rows in 0.002 seconds.
The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.
PREFIX tableFile: <http://semantic.eea.europa.eu/project/faostat/2014/foodsupply_livestockfish_e.txt#>
PREFIX poptableFile: <http://semantic.eea.europa.eu/project/faostat/2014/population_e.txt#>
SELECT
?year
'Fish and seafood' as ?item
(round(sum(?foodvalue)/sum(?popvalue)*10))/10.0 as ?capita
#hard coded values for indexing taken from the results of the query
(round(( sum(?foodvalue)/sum(?popvalue) ) / (9804000.0/484619.0 ) *1000))/10.0 as ?index
sum(?foodvalue) as ?foodvalue
sum(?popvalue) as ?popvalue
WHERE {
{
GRAPH <http://semantic.eea.europa.eu/project/faostat/2014/foodsupply_livestockfish_e.txt> {
{
_:foodsupply_livestockfish_e tableFile:CountryCode ?CountryCode .
_:foodsupply_livestockfish_e tableFile:ItemCode 2960 .
_:foodsupply_livestockfish_e tableFile:ElementGroup 641 .
_:foodsupply_livestockfish_e tableFile:ElementCode 641 .
_:foodsupply_livestockfish_e tableFile:Year ?year . FILTER (?year >1994)
_:foodsupply_livestockfish_e tableFile:Unit 'tonnes' .
_:foodsupply_livestockfish_e tableFile:Value ?foodvalue .
}}
} UNION {
GRAPH <http://semantic.eea.europa.eu/project/faostat/2014/population_e.txt> {
_:population_e poptableFile:CountryCode ?CountryCode .
_:population_e poptableFile:ElementGroup 511 .
_:population_e poptableFile:ElementCode 511 .
_:population_e poptableFile:Year ?year . FILTER (?year >1994)
_:population_e poptableFile:Value ?popvalue .
}
}
FILTER (?CountryCode in (11, 15, 255, 27, 98, 50, 167, 54, 63, 67, 68, 79, 84, 97, 104, 106, 119, 126, 256, 134, 150, 173, 174, 183, 199, 198, 203, 210, 229))
}
GROUP BY ?year
ORDER BY ?year
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/fish-seafood-total-livestock-and or scan the QR code.
PDF generated on 17 Aug 2024, 05:32 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others