Skip to content
Andrey Utkin edited this page Oct 31, 2020 · 2 revisions

Mission: Make data accessible. Make analysis easy.

Q: What do we do?
A: Provide instant and convenient access to valuable datasets.

Q: How do we do that?
A: By serving SQL queries.

Q: Whom do we do it for?
A: For curious people, scientists, service developers.

Q: What value are we bringing?
A: We spare our users...

  • downloading the datasets and ensuring they are up to date;
  • designing and implementing the data schema.

Datasets

uk-tier-2-5-sponsors

UK Tiers 2 and 5 register of sponsors.
(List of UK organisations licensed to sponsor workers under Tiers 2 and 5.)

Example:

 $ psql -q postgresql://guest@sqlhub.net/uk-tier-2-5-sponsors
uk-tier-2-5-sponsors=> select upper(city) as city_, count(*) as count_per_city from sponsors group by city_ order by count_per_city desc limit 5;
   city_    | count_per_city
------------+----------------
 LONDON     |          13071
 MANCHESTER |            469
 BIRMINGHAM |            411
 CAMBRIDGE  |            361
 EDINBURGH  |            321
(5 rows)


Clone this wiki locally