Skip to content

Instantly share code, notes, and snippets.

View ewg118's full-sized avatar

Ethan Gruber ewg118

62 followers · 4 following
  • American Numismatic Society
  • Charlottesville, Virginia
View GitHub Profile
@ewg118
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
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
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
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
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
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>
@ewg118
ewg118 / odessus_monograms.sparql
Created October 25, 2021 17:16
Monograms associated with Odessus
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
ewg118 / members.sparql
Created October 22, 2021 17:20
Get a list of member people and organization associated with a foaf:Organization in Nomisma
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
ewg118 / bm-coins.rdf
Last active September 24, 2021 15:19
British Museum coins OpenRefine template
<nmo:NumismaticObject rdf:about="{{cells['URI'].value}}">
<dcterms:title xml:lang="en">British Museum: {{cells["Registration no"].value}}</dcterms:title>
<dcterms:identifier>{{cells["Registration no"].value}}</dcterms:identifier>
<nmo:hasCollection rdf:resource="http://nomisma.org/id/bm"/>
{{forNonBlank(cells["Type URI"], c, '<nmo:hasTypeSeriesItem rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Hoard URI"], c, '<dcterms:isPartOf rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Material"], c, '<nmo:hasMaterial rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Mint"], c, '<nmo:hasMint rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Denomination"], c, '<nmo:hasDenomination rdf:resource="' + c.value + '"/>', "")}}
{{forNonBlank(cells["Weight"], c, '<nmo:hasWeight rdf:datatype="http://www.w3.org/2001/XMLSchema#decimal">' + c.value + '</nmo:hasWeight>', "")}}
@ewg118
ewg118 / rrc-99-74.sparql
Created September 1, 2021 14:58
RRC types and coin count from 99-74 BCE
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#>