[OpenSpending] Portuguese database of contracts
rufus.pollock at okfn.org
Thu Jan 23 11:29:22 UTC 2014
You've come to the right place and this is very exciting.
Some immediate things:
- Here is some info on existing
OpenSpending community member scraping contracts from
base.gov.pt with results live at
https://openspending.org/pt_ajustes-diretos - would you be interested in
- We're also interested in collecting contract data more broadly across
countries - see the list of "Contract" issues in the data to load
We've also been thinking about how to automate analysis - e.g. pushing
datasets automatically into Google BigQuery or Amazon Redshift (more info
- The OpenSpending platform is built in python :-) Given your python
expertise you may be interested in this! Code is at
https://github.com/openspending/openspending and hacking instructions are
On 23 January 2014 10:08, Jorge Cardoso Leitão <jorgecarleitao at gmail.com>wrote:
> This is a cross-post from the mailing list of open-government, as it was
> there that this update would make more sense here.
> Sorry for that.
> I'm a portuguese doing my PhD in Dresden (on physics) and on my free time
> I do some analysis to the portuguese public procurements. I recently found
> the open knowledge foundation.
> In concrete, I have a website and API using Django ORM (github<https://github.com/jorgecarleitao/public-contracts>)
> that daily crawls* the official portuguese database<https://index.okfn.org/country/Portugal/spending> of
> public procurements and I provide open sql access to a remote mysql
> database I designed and populated (see readme<http://public-contracts.readthedocs.org/en/latest/tools/database.html>).
> I'm now asking questions to the data like "When do portuguese
> municipalities contract most?<http://contratos.publicos.pt/quando-e-que-os-municipios-mais-contratam>
> It seems that you are already doing this kind of stuff for some time, and,
> in particular, I'm doing what the international transparency in Slovakia
> is doing <http://tender.sme.sk/en/reports?cut=contract_date:2014,01>.
> What I've done so far is of a very limited scope: only now I'm finding
> that there is an actual community very interested in this kind of stuff,
> which I'm thrilled to find!
> So, with this e-mail I'm trying to introduce myself and this little
> project to this community, in the hope of receiving some feedback. I'm a
> little overwhelmed by the amount of information the foundation has on the
> website, and some guidance would be great. E.g., does this database and/or
> project fits in the foundation in any way?
> In the meanwhile, how can I help you?
> I like this subject a lot and I agree with the vision of the foundation.
> I'm not an expert in database or web development, thus I'm more into posing
> scientific questions. Nevertheless, I'm also capable of designing and
> querying a database, git, etc.
> *The crawling was made posterior to confirmation with the official
> database provider that I'm allowed to do so ;-)
> openspending mailing list
> openspending at lists.okfn.org
> Unsubscribe: https://lists.okfn.org/mailman/options/openspending
*Rufus PollockFounder and Executive Director | skype: rufuspollock |
@rufuspollock <https://twitter.com/rufuspollock>The Open Knowledge
Foundation <http://okfn.org/>Empowering through Open
Knowledgehttp://okfn.org/ <http://okfn.org/> | @okfn
<http://twitter.com/OKFN> | OKF on Facebook
<https://www.facebook.com/OKFNetwork> | Blog <http://blog.okfn.org/> |
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the openspending