rows {
  options {
    stream_name: ""
    physical_type: PHYSICAL_STREAM_TYPE_QUADS
    generalized_statements: false
    rdf_star: false
    max_name_table_size: 128
    max_prefix_table_size: 16
    max_datatype_table_size: 16
    logical_type: LOGICAL_STREAM_TYPE_DATASETS
    version: 2
  }
}
rows {
  prefix {
    id: 0
    value: "https://w3id.org/np/"
  }
}
rows {
  name {
    id: 0
    value: "RADVP6aiUj4NuMLlhhZNmfr71Z6IMY6kVZ6YW5jIi5u2o"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
      name_id: 0
    }
  }
}
rows {
  prefix {
    id: 0
    value: "https://w3id.org/np/RADVP6aiUj4NuMLlhhZNmfr71Z6IMY6kVZ6YW5jIi5u2o/"
  }
}
rows {
  name {
    id: 0
    value: ""
  }
}
rows {
  namespace {
    name: "sub"
    value {
      prefix_id: 2
      name_id: 0
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.nanopub.org/nschema#"
  }
}
rows {
  namespace {
    name: "np"
    value {
      prefix_id: 3
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://purl.org/dc/terms/"
  }
}
rows {
  namespace {
    name: "dct"
    value {
      prefix_id: 4
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  namespace {
    name: "nt"
    value {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://purl.org/nanopub/x/"
  }
}
rows {
  namespace {
    name: "npx"
    value {
      prefix_id: 6
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.w3.org/2001/XMLSchema#"
  }
}
rows {
  namespace {
    name: "xsd"
    value {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.w3.org/2000/01/rdf-schema#"
  }
}
rows {
  namespace {
    name: "rdfs"
    value {
      prefix_id: 8
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "https://orcid.org/"
  }
}
rows {
  namespace {
    name: "orcid"
    value {
      prefix_id: 9
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://purl.org/np/"
  }
}
rows {
  namespace {
    name: "ns1"
    value {
      prefix_id: 10
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.w3.org/ns/prov#"
  }
}
rows {
  namespace {
    name: "prov"
    value {
      prefix_id: 11
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://xmlns.com/foaf/0.1/"
  }
}
rows {
  namespace {
    name: "foaf"
    value {
      prefix_id: 12
      name_id: 2
    }
  }
}
rows {
  name {
    id: 0
    value: "hasAssertion"
  }
}
rows {
  name {
    id: 0
    value: "assertion"
  }
}
rows {
  name {
    id: 0
    value: "Head"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 3
      name_id: 3
    }
    o_iri {
      prefix_id: 2
      name_id: 0
    }
    g_iri {
      prefix_id: 0
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "hasProvenance"
  }
}
rows {
  name {
    id: 0
    value: "provenance"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
      name_id: 0
    }
    o_iri {
      prefix_id: 2
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "hasPublicationInfo"
  }
}
rows {
  name {
    id: 0
    value: "pubinfo"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
      name_id: 0
    }
    o_iri {
      prefix_id: 2
      name_id: 0
    }
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  }
}
rows {
  name {
    id: 0
    value: "type"
  }
}
rows {
  name {
    id: 0
    value: "Nanopublication"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 13
      name_id: 0
    }
    o_iri {
      prefix_id: 3
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "get-quarterly-active-organic-user-count"
  }
}
rows {
  name {
    id: 0
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
      name_id: 0
    }
    p_iri {
      prefix_id: 4
      name_id: 0
    }
    o_literal {
      lex: "Returns the number of active users per quarter since 2022. Two sequences of non-organic acquisition (as part of university course) are filtered out."
    }
    g_iri {
      prefix_id: 2
      name_id: 4
    }
  }
}
rows {
  name {
    id: 0
    value: "license"
  }
}
rows {
  prefix {
    id: 0
    value: "http://www.apache.org/licenses/"
  }
}
rows {
  name {
    id: 0
    value: "LICENSE-2.0"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 14
      name_id: 0
    }
  }
}
rows {
  prefix {
    id: 0
    value: "https://w3id.org/kpxl/grlc/"
  }
}
rows {
  name {
    id: 0
    value: "grlc-query"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 13
      name_id: 10
    }
    o_iri {
      prefix_id: 15
      name_id: 16
    }
  }
}
rows {
  name {
    id: 0
    value: "label"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 8
      name_id: 0
    }
    o_literal {
      lex: "Get quarterly active organic user count"
    }
  }
}
rows {
  name {
    id: 0
    value: "endpoint"
  }
}
rows {
  prefix {
    id: 0
    value: "https://w3id.org/np/l/nanopub-query-1.1/repo/"
  }
}
rows {
  name {
    id: 0
    value: "full"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 15
      name_id: 0
    }
    o_iri {
      prefix_id: 16
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "sparql"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 15
      name_id: 0
    }
    o_literal {
      lex: "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
\nprefix np: <http://www.nanopub.org/nschema#>
\nprefix npa: <http://purl.org/nanopub/admin/>
\nprefix npx: <http://purl.org/nanopub/x/>
\nprefix xsd: <http://www.w3.org/2001/XMLSchema#>
\nprefix dct: <http://purl.org/dc/terms/>
\nprefix prov: <http://www.w3.org/ns/prov#>
\nprefix foaf: <http://xmlns.com/foaf/0.1/>
\n
\nselect ?quarter (count(distinct ?userid) as ?usercount) where {
\n  { graph npa:graph {
\n    ?np npa:hasValidSignatureForPublicKey ?pubkey .
\n    ?np dct:creator ?userid .
\n    ?np dct:created ?date .
\n  } }
\n  union
\n  {
\n    graph npa:graph {
\n      ?np npa:hasValidSignatureForPublicKey ?pubkey .
\n      ?np np:hasAssertion ?assertion .
\n      ?np np:hasProvenance ?prov .
\n      ?np dct:created ?date .
\n    }
\n    graph ?prov {
\n      ?assertion prov:wasAttributedTo ?userid .
\n    }
\n  }
\n  filter not exists {
\n    graph npa:graph { ?np npa:hasSubIri ?userid . }
\n  }
\n  filter(str(?date) > \"2022\")
\n  filter(str(?date) < \"2023-10-03\" || str(?date) > \"2023-10-12\")
\n  filter(str(?date) < \"2024-09-27\" || str(?date) > \"2024-10-07\")
\n  bind(substr(str(?date), 0, 8) as ?month)
\n  bind(replace(?month, \"-0[1-3]$\", \"-Q1\") as ?quarter_temp1)
\n  bind(replace(?quarter_temp1, \"-0[4-6]$\", \"-Q2\") as ?quarter_temp2)
\n  bind(replace(?quarter_temp2, \"-0[7-9]$\", \"-Q3\") as ?quarter_temp3)
\n  bind(replace(?quarter_temp3, \"-1[0-9]$\", \"-Q4\") as ?quarter)
\n}
\ngroup by ?quarter
\norder by desc(?quarter)"
    }
  }
}
rows {
  name {
    id: 0
    value: "wasAttributedTo"
  }
}
rows {
  name {
    id: 0
    value: "0000-0002-1267-0234"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
      name_id: 4
    }
    p_iri {
      prefix_id: 11
      name_id: 21
    }
    o_iri {
      prefix_id: 9
      name_id: 0
    }
    g_iri {
      prefix_id: 2
      name_id: 7
    }
  }
}
rows {
  name {
    id: 0
    value: "name"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 9
      name_id: 22
    }
    p_iri {
      prefix_id: 12
      name_id: 0
    }
    o_literal {
      lex: "Tobias Kuhn"
    }
    g_iri {
      prefix_id: 2
      name_id: 9
    }
  }
}
rows {
  name {
    id: 0
    value: "created"
  }
}
rows {
  datatype {
    id: 0
    value: "http://www.w3.org/2001/XMLSchema#dateTime"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 4
      name_id: 24
    }
    o_literal {
      lex: "2025-07-27T09:29:37.147Z"
      datatype: 1
    }
  }
}
rows {
  name {
    id: 0
    value: "creator"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 0
      name_id: 0
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}
rows {
  prefix {
    id: 5
    value: "https://creativecommons.org/licenses/by/4.0/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  name {
    id: 0
    value: "embeds"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 26
    }
    o_iri {
      prefix_id: 2
      name_id: 12
    }
  }
}
rows {
  name {
    id: 0
    value: "supersedes"
  }
}
rows {
  name {
    id: 0
    value: "RAxbzOjj7pF5ltM_Khyf4ZgGmmi_oszSLlCbeabDWe50o"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 27
    }
    o_iri {
      prefix_id: 1
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "wasCreatedAt"
  }
}
rows {
  prefix {
    id: 7
    value: "https://nanodash.knowledgepixels.com/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 0
    }
    o_iri {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 10
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  name {
    id: 0
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  prefix {
    id: 3
    value: "http://purl.org/np/"
  }
}
rows {
  name {
    id: 0
    value: "RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
      name_id: 30
    }
    o_iri {
      prefix_id: 3
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    id: 0
    value: "RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
      name_id: 0
    }
    o_iri {
      prefix_id: 1
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw"
  }
}
rows {
  quad {
    o_iri {
      prefix_id: 0
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI"
  }
}
rows {
  quad {
    o_iri {
      prefix_id: 0
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "wasCreatedFromTemplate"
  }
}
rows {
  name {
    id: 0
    value: "RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
      name_id: 0
    }
    o_iri {
      prefix_id: 1
      name_id: 0
    }
  }
}
rows {
  name {
    id: 0
    value: "sig"
  }
}
rows {
  name {
    id: 0
    value: "hasAlgorithm"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
      name_id: 0
    }
    p_iri {
      prefix_id: 6
      name_id: 0
    }
    o_literal {
      lex: "RSA"
    }
  }
}
rows {
  name {
    id: 0
    value: "hasPublicKey"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 0
      name_id: 0
    }
    o_literal {
      lex: "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB"
    }
  }
}
rows {
  name {
    id: 0
    value: "hasSignature"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 0
      name_id: 0
    }
    o_literal {
      lex: "N36DMG2zcI4/kOy66yC0PlwWyZKDmAFHE9ej9jo2aqrQbUWqjbzQ2rhnToq4uGOo3d7lfE+75312HYHKQmAr5opx4YmkJZ4JefPpqE/NwLYWAuaKlceUlscULy+axNOrwiRLuccRl6NvW+o0a7W500KGbajMEjSW9IjLkj9Ex68="
    }
  }
}
rows {
  name {
    id: 0
    value: "hasSignatureTarget"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 0
      name_id: 0
    }
    o_iri {
      prefix_id: 1
      name_id: 1
    }
  }
}
rows {
  name {
    id: 0
    value: "signedBy"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 43
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}