ewg118’s gists

ewg118 / singleton_monograms.sparql

Created August 10, 2022 15:57

Monograms that appear only on a single type, with some optional authority/mint context

	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX org: <http://www.w3.org/ns/org#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

ewg118 / seleucus_ii_monograms.sparql

Created August 10, 2022 14:43

Monograms of Seleucus II with associated mint and ordered chronologically

	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX org: <http://www.w3.org/ns/org#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

ewg118 / odessus_monograms.sparql

Created August 10, 2022 14:35

Monograms of Odessus (Thrace) chronologically ordered

	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX org: <http://www.w3.org/ns/org#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

ewg118 / linked-pasts.sparql

Created July 14, 2022 19:08

SPARQL query of nomisma places to generate Linked Pasts GeoJSON-LD

	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX org: <http://www.w3.org/ns/org#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

ewg118 / esty_frequency.sparql

Created June 30, 2022 15:49

Esty: count number of dies by their frequency for RRC 336/1c

	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

	SELECT ?frequency (count(?die) as ?dieCount) WHERE {
	{
	SELECT DISTINCT ?die (count(?object) as ?frequency) WHERE {

ewg118 / esty_d1.sparql

Created June 30, 2022 14:27

Esty: Get dies with only one occurrence d1 for coin type

	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

	SELECT (count(?die) as ?dieCount) WHERE {
	{
	SELECT DISTINCT ?die (count(?object) as ?count) WHERE {

ewg118 / esty_d.sparql

Created June 30, 2022 14:22

Esty: Get unique obverse dies d for coin type

	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

	SELECT (count(DISTINCT ?die) as ?count) WHERE {
	?object nmo:hasTypeSeriesItem <http://numismatics.org/crro/id/rrc-336.1c> .
	GRAPH <http://nomisma.org/editor/rschaefer> {

ewg118 / esty_n.sparql

Last active August 15, 2022 14:03

Esty: Get sample size n of coins for type

	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

	SELECT (count(?object) as ?count) WHERE {
	?object nmo:hasTypeSeriesItem <http://numismatics.org/crro/id/rrc-380.1> .
	GRAPH <http://nomisma.org/editor/rschaefer> {

ewg118 / silver-gold.sparql

Created April 13, 2022 14:47

Silver and gold coin coins after 337 CE

	PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
	PREFIX dcmitype: <http://purl.org/dc/dcmitype/>
	PREFIX dcterms: <http://purl.org/dc/terms/>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
	PREFIX nm: <http://nomisma.org/id/>
	PREFIX nmo: <http://nomisma.org/ontology#>
	PREFIX org: <http://www.w3.org/ns/org#>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

ewg118 / kbr.rdf

Created November 30, 2021 14:42

Royal Library of Belgium OpenRefine template for Nomisma

	<nmo:NumismaticObject rdf:about="{{cells['Permalink'].value}}">
	<dcterms:title xml:lang="en">{{cells["Title"].value}}</dcterms:title>
	<dcterms:identifier>{{cells["IDN"].value}}</dcterms:identifier>
	<nmo:hasCollection rdf:resource="http://nomisma.org/id/kbr"/>
	<nmo:hasTypeSeriesItem rdf:resource="{{cells["RRC"].value}}"/>
	{{forNonBlank(cells["Weight"], c, '<nmo:hasWeight rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</nmo:hasWeight>', "")}}
	{{forNonBlank(cells["Diameter"], c, '<nmo:hasDiameter rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</nmo:hasDiameter>', "")}}
	{{forNonBlank(cells["Orientation"], c, '<nmo:hasAxis rdf:datatype="http://www.w3.org/2001/XMLSchema#integer">' + c.value + '</nmo:hasAxis>', "")}}
	<nmo:hasObverse>
	<rdf:Description>

Ethan Gruber ewg118