# list datasets by their keyword/description/title

PREFIX rdfs:       <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf:       <http://xmlns.com/foaf/0.1/>
PREFIX dcterms:    <http://purl.org/dc/terms/>
PREFIX dc:    <http://purl.org/dc/elements/1.1/>
prefix conversion: <http://purl.org/twc/vocab/conversion/>
PREFIX e1:    <http://logd.tw.rpi.edu/source/data-gov/dataset/92/vocab/enhancement/1/>
SELECT distinct ?title ?description ?category ?agency ?url ?dataset ?Dataset_Identifier

WHERE {
 graph <http://purl.org/twc/vocab/conversion/MetaDataset> {
    ?dataset dcterms:subject ?keyword .
    ?dataset dcterms:title ?title .
    ?dataset e1:agency ?agency_uri .
    ?agency_uri rdfs:label ?agency .
    ?dataset e1:category ?category .
    ?dataset dcterms:description ?description.
    ?dataset foaf:homepage ?url .
    filter (   regex((?keyword) , "budget","i")
                || regex((?title ) , "budget","i")
                        || regex((?description) , "budget","i") )
 }

optional {
 graph <http://logd.tw.rpi.edu/vocab/Dataset> {
       ?dataset
            a conversion:Dataset;
            dcterms:identifier ?Dataset_Identifier ;
            void:subset ?version .
       ?version a conversion:VersionedDataset .
     filter (regex (?Dataset_Identifier, "data-gov","i"))
 }
}

}
ORDER BY DESC(?Dataset_Identifier)
limit 50