<commit_before>@prefix graph: <https://hub2.linkeddata.center/sd1lodmap/graph/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix kees: <http://linkeddata.center/kees/v1#> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix resource: <https://bitbucket.org/linkeddatacenter/sd2ec1/raw/master/data/kees/local_business_answers.ttl#> .


resource:table_local_business_unknow_location a kees:Table ;
	dct:identifier "local_business:unknow_location" ;
	rdfs:label "Business entities without a recognized city."@en ;
	rdfs:comment "Business entities with an address that does'nt match ISTAT classification"@en ;
	kees:queryText """# Business entities with an address that does'nt match ISTAT classification
PREFIX schema: <http://schema.org/> 

SELECT ?dataset ?azienda ?comune ?provincia
WHERE { 
	GRAPH ?dataset { ?azienda schema:address  ?address }
	
	OPTIONAL { ?address schema:addressLocality ?comune }
	OPTIONAL { ?address schema:addressRegion ?provincia }
    OPTIONAL { 
      ?azienda schema:containedInPlace ?city.
      ?city a schema:City;
    }
  
  	FILTER( !BOUND(?city) )
}
""" 
.


resource:table_local_business_id a kees:Table ;
	dct:identifier "local_business:id" ;
	rdfs:label "Info about a specific id (in %ID% parameter)."@en ;
	rdfs:comment "Display name, address and identities for a company whose id contains the string specified in %ID% parameter. Just firts 50 entries displayed."@en ;<commit_msg>refined<commit_after>@prefix graph: <https://hub2.linkeddata.center/sd1lodmap/graph/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix kees: <http://linkeddata.center/kees/v1#> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix resource: <https://bitbucket.org/linkeddatacenter/sd2ec1/raw/master/data/kees/local_business_answers.ttl#> .


resource:table_local_business_unknow_location a kees:Table ;
	dct:identifier "local_business:unknow_location" ;
	rdfs:label "Business entities without a recognized city by dataset (parameter DATASET)."@en ;
	rdfs:comment "Business entities with an address that does'nt match ISTAT classification. Acceps parameter DATASET (defaut all) "@en ;
	kees:queryText """# Business entities with an address that does'nt match ISTAT classification
PREFIX schema: <http://schema.org/> 
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX sd: <http://www.w3.org/ns/sparql-service-description#>

SELECT DISTINCT ?dataset ?azienda ?comune ?provincia
WHERE { 
	GRAPH ?g { ?lb a schema:LocalBusiness; schema:address  ?address }
	
	OPTIONAL { ?address schema:addressLocality ?comune }
	OPTIONAL { ?address schema:addressRegion ?provincia }
    OPTIONAL { 
      ?lb schema:containedInPlace ?city.
      ?city a schema:City;
    }
          
  	[] sd:name ?g; dct:source ?source.
    [] dcat:distribution [ dcat:accessURL ?source ]; dct:title ?dataset.
  
    ?lb dct:identifier ?azienda.
  
  	FILTER( !BOUND(?city) )
  	FILTER REGEX (?dataset, "%DATASET=%", "i")
} ORDER BY ?g ?provincia ?comune 
""" 
.


resource:table_local_business_id a kees:Table ;
	dct:identifier "local_business:id" ;
	rdfs:label "Info about a specific id (in %ID% parameter)."@en ;
	rdfs:comment "Display name, address and identities for a company whose id contains the string specified in %ID% parameter. Just firts 50 entries displayed."@en ;
{'fraction_non_alphanumeric': 0.1293517406962785, 'fraction_numerical': 0.00900360144057623, 'mean_word_length': 4.668367346938775, 'pattern_counts': {'":': 0, '<': 18, '<?xml version=': 0, '>': 18, 'https://': 4, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1541145', 'n_tokens_mistral': 1157, 'n_tokens_neox': 1104, 'n_words': 278}