thiscodeWorks - Organizing the best of code online

List view

select *
from shortform.submitted s 
where user_input is not null and user_input != '{}' and "name" is not null and "name" != '{}'
order by random()
limit 10;

#sparql #wikidata #query

Rock Impact - count firm entries

select distinct count(*)
from auth."user"
inner join shortform.firm on shortform.firm.organization_id = auth."user".organization_id 
limit 10;

#sparql #wikidata #query

query all "higher education institutions"

select distinct ?school ?schoolLabel

where {
  ?school wdt:P31/wdt:P279* wd:Q38723. 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

limit 100

# non-empty shortform submits (funds)

Rock Impact - count firm entries

query all "higher education institutions"

Save snippets that work with our extensions