[open-government] Portuguese database of contracts

[Julia Keserű]

Welcome on board Jorge, great work! I`d be curious to know how you ended up
working with procurement data.

You should also check out the
OpenContracting<http://www.open-contracting.org/>initiative hosted by
the World Bank Institute.

The Sunlight Foundation has a lot going
on<http://sunlightfoundation.com/issues/procurement-government/>around
procurement data, too. It would be great to have you on our
international
mail list <https://groups.google.com/forum/#!forum/sunlight-international>and
you might also want to take a look at how other
countries<http://sunlightfoundation.com/blog/2013/05/01/open-procuring-how-do-other-countries-perform/>disclose
contracting data.

Here are some more examples of using procurement data beyond the
Slovak<http://sunlightfoundation.com/blog/2013/08/12/case-study-public-procurement-in-the-slovak-republic/>example:
Georgia:
http://sunlightfoundation.com/blog/2014/01/16/opengov-voices-how-georgia-is-handling-procurement-transparency/

Russia:
http://sunlightfoundation.com/blog/2013/08/06/crowdsourcing-to-fight-corruption-aleksei-navalny-and-the-rospil-experiment/

Best,
Julia




On Wed, Jan 22, 2014 at 5:56 AM, Ricardo Lafuente <
r at manufacturaindependente.org> wrote:

> Hi Jorge,
>
> Brilliant work! And rather massive! Thank you for this!
>
> There's a working group busy with open data work in Portugal,
> Transparência Hackday Portugal (www.transparenciahackday.org).
> Please join our (portuguese-speaking) mailing list over there, there's
> already a small but significant community talking and hacking around these
> subjects. I'm forwarding your e-mail over there, it's really exciting stuff.
>
> [Any portuguese lurkers on the list are more than free to join too!]
>
> Really excited with this. Hope we can discuss more and see where things
> can go from here.
>
> Cheers,
> :r
>
>
> On 01/21/2014 09:07 PM, Jorge Cardoso Leitão wrote:
>
>> Hi.
>>
>> 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.
>>
>> Cheers,
>> Jorge
>>
>>
>> *The crawling was made posterior to confirmation with the official
>> database provider that I'm allowed to do so ;-)
>>
>>
>> _______________________________________________
>> open-government mailing list
>> open-government at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/open-government
>> Unsubscribe: https://lists.okfn.org/mailman/options/open-government
>>
>
> _______________________________________________
> open-government mailing list
> open-government at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/open-government
> Unsubscribe: https://lists.okfn.org/mailman/options/open-government
>



-- 
Júlia Keserű
International Program Coordinator

1818 N Street NW, Suite 300
Washington, DC 20036
(1) 202-742-1520 *280

[image: Sunlight Foundation] <http://sunlightfoundation.com/> [image:
Sunlight Foundation on
Facebook]<http://www.facebook.com/sunlightfoundation>[image:
Sunlight Foundation on Twitter] <http://twitter.com/sunfoundation>[image:
OpenGov on Reddit] <http://www.reddit.com/r/sunlight> [image: Sunlight
Foundation on YouTube] <http://www.youtube.com/sunlightfoundation>
<http://sunlightfoundation.com/feeds/latest/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20140122/fb6f3bf1/attachment-0003.html>