Data table via SPARQL

Consumption of meat and dairy products and total seafood in EU28 for 2011

Data table via SPARQL Published 06 Oct 2014 Last modified 02 Feb 2016

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date	ItemCode	Item	category	foodvalue_per_capita	foodvalue	popvalue
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2948"^^<http://www.w3.org/2001/XMLSchema#int>	"Milk - Excluding Butter + (Total)"	"Diary"	"240.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"121839000"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2743"^^<http://www.w3.org/2001/XMLSchema#int>	"Cream"	"Diary"	"4"^^<http://www.w3.org/2001/XMLSchema#decimal>	"2031313"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2741"^^<http://www.w3.org/2001/XMLSchema#int>	"Cheese"	"Diary"	"17.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8672068"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2735"^^<http://www.w3.org/2001/XMLSchema#int>	"Meat, Other"	"Meat"	"2.6"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1329728"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2763"^^<http://www.w3.org/2001/XMLSchema#int>	"Pelagic Fish"	"Fish & seafood"	"5.3"^^<http://www.w3.org/2001/XMLSchema#decimal>	"2684105"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2781"^^<http://www.w3.org/2001/XMLSchema#int>	"Fish, Body Oil"	"Fish & seafood"	"0.1"^^<http://www.w3.org/2001/XMLSchema#decimal>	"35538"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	""	""	"Diary"	""	""	"507399"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2961"^^<http://www.w3.org/2001/XMLSchema#int>	"Aquatic Products, Other + (Total)"	"Fish & seafood"	"0.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"78000"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2732"^^<http://www.w3.org/2001/XMLSchema#int>	"Mutton & Goat Meat"	"Meat"	"2.2"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1118651"^^<http://www.w3.org/2001/XMLSchema#decimal>	""
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"2737"^^<http://www.w3.org/2001/XMLSchema#int>	"Fats, Animals, Raw"	"Meat"	"5"^^<http://www.w3.org/2001/XMLSchema#decimal>	"2562109"^^<http://www.w3.org/2001/XMLSchema#decimal>	""

Received 34 rows in 0.059 seconds.

JSON Url:
https://eea.europa.eu./data-and-maps/daviz/sds/consumption-of-meat-and-dairy/daviz.json

For system integrators

Linked Data query (SPARQL)

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.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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
2011 as ?date
?ItemCode
?Item
bif:either(?ItemCode in (2761, 2762, 2763, 2764, 2765, 2766, 2767, 2769, 2775, 2781, 2782, 2960, 2961), 'Fish & seafood', ?category) as ?category
#hardcoded value taken from computed population
round((?foodvalue/507399)*10)/10.0 as ?foodvalue_per_capita
?foodvalue
?popvalue
{{
	SELECT
	?Item
	?ItemCode
	bif:either(?ItemCode in (2731, 2732, 2733, 2734, 2735, 2736, 2737, 2943, 2945, 2946), 'Meat', 'Diary') as ?category
	
	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 ?ItemCode .
	     _:foodsupply_livestockfish_e tableFile:Item ?Item . 
	     _:foodsupply_livestockfish_e tableFile:ElementGroup 641 . 
	     _:foodsupply_livestockfish_e tableFile:ElementCode 641 .
	     _:foodsupply_livestockfish_e tableFile:Year ?year . FILTER (?year = 2011)
	     _: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 = 2011)
	     _: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))
        }
}}