-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.html
145 lines (138 loc) · 10.9 KB
/
data.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>CEDAR - Dutch historical census dataset</title>
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- YASQE/YASR -->
<link href="css/yasqe.min.css" rel="stylesheet" type="text/css" />
<link href="css/yasr.min.css" rel="stylesheet" type="text/css" />
<!-- Custom overwrites -->
<link href="css/vt.css" rel="stylesheet">
</head>
<body>
<div id="nav" class="navbar navbar-default navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.html" style="max-width: 100%;">
<img class="img-responsive pull-left" src="img/cedar_150x50.png" style="margin-top: -12px;">
</a>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav navbar-right">
<li class="active"><a href="data.html"><span class="glyphicon glyphicon-hdd"></span> Data</a></li>
<li><a href="stats.html"><span class="glyphicon glyphicon-stats"></span> Statistics</a></li>
<li><a href="info.html"><span class="glyphicon glyphicon-info-sign"></span> Information</a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</div>
<div class="container">
<div class="page-header">
<h2><span class="glyphicon glyphicon-hdd"></span> Data</h2>
</div>
<h3>API</h3>
<p class="text-justify">As an addition to the SPARQL queries below, CEDAR data is available through an experimental Linked Data API.</p>
<ul>
<li>Access the swagger API docs <a href="http://grlc.clariah-sdh.eculture.labs.vu.nl/CEDAR-project/Queries/api-docs" target="_blank">here</a></li>
<li>Get the swagger spec <a href="http://grlc.clariah-sdh.eculture.labs.vu.nl/CEDAR-project/Queries/spec" target="_blank">here</a></li>
<li>Explore the source <a href="https://github.com/CEDAR-project/Queries" target="_blank">SPARQL queries</a></li>
<li><a href="https://github.com/CLARIAH/grlc" target="_blank">Know more</a> about the automated API generation process</li>
</ul>
<h3>SPARQL endpoint</h3>
<p class="text-justify">The end point is located at <code>http://lod.cedar-project.nl/cedar-mini/sparql</code> and can be queried using SPARQL 1.1. Use the editor below to enter you own query, the results are displayed just under it. If you don't know what to query for, try one of these sample queries by clicking on it. Default query values can be customized (for example, other valid reference periods are 1859, 1869, 1879, 1889, 1899, 1909 and 1920).</p>
<p class="text-justify">The three named graphs <code><urn:graph:cedar:raw-data></code>, <code><urn:graph:cedar:rules></code> and
<code><urn:graph:cedar:release></code> contain a full conversion of the 2,288 census tables of the dataset. This collection is harmonized with a set of generic
mapping rules, enabling the dataset to be queried under the RDF Data Cube schema. This collection is available at its own SPARQL endpoint at <code>http://lod.cedar-project.nl/cedar/sparql</code>. Additionally, we release a highly curated subset of this collection, called <code>cedar-mini</code> and contained in the named graphs <code><urn:graph:cedar-mini:raw-data></code>, <code><urn:graph:cedar-mini:rules></code> and
<code><urn:graph:cedar-mini:release></code>. This subset is a high-quality curated harmonized version of the 59 most consulted and relevant tables of the
collection. The <code>cedar-mini</code> subset is available at its own SPARQL endpoint at <code>http://lod.cedar-project.nl/cedar-mini/sparql</code>.
<p class="text-justify">General queries (over <code>/cedar-mini/sparql</code>):</p>
<ul>
<li><a onclick="javascript:loadQuery('observation');">Observation describing other inhabited houses in district A of the urban area of Zuid-Scharwoude (North Holland) in 1889</a>
<li><a onclick="javascript:loadQuery('occupied-houses');">Occupied houses per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('occupied-ships');">Occupied living ships per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('juridisch-aanwezig-m');">Legally registered and present male inhabitants per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('juridisch-aanwezig-f');">Legally registered and present female inhabitants per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('under-construction');">Houses under construction per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('empty-houses');">Empty houses per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('ships-absent');">Temporarily present inhabitants in ships per municipality, 1899</a>
<li><a onclick="javascript:loadQuery('temp-present-males');">Number of temporarily present males per municipality, from 1869 until 1920</a>
<li><a onclick="javascript:loadQuery('temp-present-females');">Number of temporarily present females per municipality, from 1869 until 1920</a>
<li><a onclick="javascript:loadQuery('temp-absent-males');">Temporarily absent males per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('temp-absent-females');">Temporarily absent females per municipality, 1879</a>
<li><a onclick="javascript:loadQuery('wagons');">Temporarily present inhabitants in wagons per municipality, 1899</a>
<li><a onclick="javascript:loadQuery('house-types');">Number of houses according to their type per municipality, from 1859 until 1920</a>
</ul>
<p class="text-justify">Technical queries (over <code>/cedar-mini/sparql</code>):</p>
<ul>
<li><a onclick="javascript:loadQuery('count');">Count the number of triples per graph</a>
<li><a onclick="javascript:loadQuery('datasets');">Source of the raw datasets</a>
<li><a onclick="javascript:loadQuery('find_column_headers');">Find column headers according to their label</a>
<li><a onclick="javascript:loadQuery('get-dimensions');">Get a list of the dimensions used by the harmonized dataset</a>
<li><a onclick="javascript:loadQuery('get-headers');">Get a list of the headers used by the harmonized dataset</a>
<li><a onclick="javascript:loadQuery('parsed_sheets');">Get the number of sheets parsed as raw-data</a>
<li><a onclick="javascript:loadQuery('raw-data');">Get a list of raw datasets and their location</a>
<li><a onclick="javascript:loadQuery('top-headers');">List of top 100 most occurring header in all the raw dataset</a>
</ul>
<p class="text-justify">Mini-project queries (over <code>/cedar-mini/sparql</code>):</p>
<ul>
<li><a onclick="javascript:loadQuery('original-parent-headers');">Reconstructing hierarchical headers (max depth 3)</a>
<li><a onclick="javascript:loadQuery('original-parent-headers-4');">Reconstructing hierarchical headers (max depth 4)</a>
<li><a onclick="javascript:loadQuery('temporarily-present-males-muni');">Temporarily present males in a certain municipality</a>
<li><a onclick="javascript:loadQuery('working-totals');">Working totals</a>
<li><a onclick="javascript:loadQuery('municipality-totals');">Totals per municipality</a>
<li><a onclick="javascript:loadQuery('cross-year-totals');">Totals per municipality in several years, ordered by municipality</a>
<li><a onclick="javascript:loadQuery('check_non-annotated-cells');">Headers which still have no standardization mapping rule</a>
</ul>
<p class="text-justify">Error-detecting queries (over <code>/cedar/sparql</code>):</p>
<ul>
<li><a onclick="javascript:loadQuery('double_occupation_position');">Observations with more than one occupation position</a>
<li><a onclick="javascript:loadQuery('negative_population');">Observations with negative population counts</a>
<li><a onclick="javascript:loadQuery('non-integer_population');">Observations with non-integer population counts</a>
</ul>
<p class="text-justify">Other queries (over <code>/cedar/sparql</code>):</p>
<ul>
<li><a onclick="javascript:loadQuery('married');">Evolution of the number of married women over the years</a>
<li><a onclick="javascript:loadQuery('shoemakers-province');">Number of shoemakers for each censsus year for each province grouped by age</a>
<li><a onclick="javascript:loadQuery('2-72-houses');">House count of type 2-72 over the years</a>
<li><a onclick="javascript:loadQuery('2-72-houses-obs');">Observations of the house 2-72 by years count</a>
</ul>
<div class="row">
<div class="col-md-12">
<div id="yasqe"></div>
</div>
</div>
<br/>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">Query results</div>
<div id="yasr"></div>
</div>
</div>
</div>
<!--
<h3>Example of visualisations</h3>
<p>The following visualisations are used both as examples of what can be achieved with the SPARQL queries and also as a way for us to control the quality of the data produceed using the integration pipeline. Some numbers may be totally wrong at the time of your visit but if this is the case be sure we are busy working on fixing them ;-)</p>
-->
<hr/>
<footer>
<p>© Data Archiving and Networked Services (DANS) 2016</p>
</footer>
</div> <!-- /container -->
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/JavaScript" src="js/bootstrap.min.js"></script>
<script type="text/JavaScript" src="js/yasqe.min.js"></script>
<script type="text/JavaScript" src="js/yasr.min.js"></script>
<script type="text/JavaScript" src="js/data.js"></script>
</body>
</html>