text:
<!DOCTYPE html>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="author" content="Open Knowledge">
    <meta name="description" content="The state of government open data in Brazil
">
    <meta name="keywords" content="Brazil, Open Government, Open Data, Government Transparency, Open Knowledge
">
    <meta property="og:type" content="website"/>
    <meta property="og:title" content="Open Data Index - Open Knowledge"/>
    <meta property="og:site_name" content="Open Data Index"/>
    <meta property="og:description"
          content="The state of government open data in Brazil"/>
    <meta property="og:image" content="/static/images/favicon.ico"/>
    <title>Brazil | Global Open Data Index by Open Knowledge</title>
    <base href="/">

    <link rel="stylesheet" href="/static/css/site.css">
    <link rel="icon" href="/static/images/favicon.ico">

                    <button type="button" class="navbar-toggle collapsed" data-toggle="collapse"
                            data-target="#navbar-collapse">
                        Toggle navigation

                    </button>

                            Global
Open Data Index

                                Places

                                Datasets

                                Download

                                Insights

                                Methodology

                                About

                                Press

                        Home

Places

Brazil

                Brazil / 2014                54% open

                Brazil is ranked #26 in the 2014 Index

                    Brazil's overall Index ranking is down from #24 in 2013

See other years

        Current

        2013

Share or embed this page

     Embed

     Twitter

     Facebook

     Google+

        <button type="button" class="close" data-dismiss="modal">×Close</button>

Map embed code

            Use the following code to embed the map visualisation into your own website.

        <xmp contenteditable="true"></xmp>

        If you are a developer, you can read more about the embed options here: Embed options

        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

        <col style="width:6%">
        <col style="width:20%">
        <col style="width:23%">
        <col style="width:20%">
        <col style="width:10%">
        <col style="width:5%">
        <col style="width:10%">
        <col style="width:6%">

                Rank
                Dataset
                Breakdown
                Location (URL)
                Format
                Info
                Prev.
                Score

                  1

                  Government Budget
                  <span class="dataset-context" data-toggle="popover" title="Government Budget" data-content="
National government budget at a high level. This category is looking at budgets, or the planned government expenditure for the upcoming year, and not the actual expenditure. To satisfy this category, the following minimum criteria must be met:

Planned budget divided by government department and sub-department

Updated once a year.

The budget should include descriptions regarding the different budget sections.

">

                      <li class="yes" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://dados.gov.br/dataset/or...

.rdf

                  #36  45%

                100%

                1

Government Budget

URL: http://dados.gov.br/dataset/orcamento-federal

Format: .rdf

Data is also published on the website of the Brazilian planning Ministry: http://www.planejamento.gov.br/ministerio.asp?index=8&ler=t297 But links are broken. In June 2014 the Brazilian government published all budget data as .rdf data on the Open Data Catalogue http://dados.gov.br

                  3

                  Government Spending
                  <span class="dataset-context" data-toggle="popover" title="Government Spending" data-content="
Records of actual (past) national government spending at a detailed transactional level; A database of contracts awarded or similar will not considered sufficient. This data category refers to detailed ongoing data on actual expenditure. Data submitted in this category should meet the following minimum criteria:

Individual record of transactions.

Date of the transactions

Government office which had the transaction

Name of vendor

amount of the transaction

Update on a monthly basis

">

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.transparencia.gov.b...

CSV

                  #5  80%

                70%

                3

Government Spending

URL: http://www.transparencia.gov.br

Format: CSV

Data till 2011 is published on the open data catalogue http://dados.gov.br

More recent data can be downloaded also from the Transparency Portal: http://www.transparencia.gov.br/downloads/ as bulk download per month (the size of each file is so big that this can be regarded as bulk download)

Neither the Transparency Portal nor the Open Data Catalogue specify the license of the data, Example: http://dados.gov.br/dataset/despesas-diretas-do-poder-executivo-federal-publicados-no-portal-da-transparencia/resource/a8eac0a2-7c69-42fe-95fb-4d1819beece1

                  20

                  National Map

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.ibge.gov.br/english...

shape ...

                  #14  70%

                70%

                20

National Map

URL: http://www.ibge.gov.br/english/geociencias/default_prod.shtm

Format: shape files, .prf, .mdb

There is a machine-readable 1:250.000-scale vectorial map data suitable for ingestion in digital map-making systems (GIS), which includes administrative boundaries, water bodies, transportation infrastructure, energy and communication, etc. There are several other map products, at scales both greater and smaller that the above one. The licensing is unclear on the website of IBGE. As no clear license is available it has been evaluated as "not openly licensed". Also, proprietary formats are used to publish data. However, data is claimed to be public domain on Open Street Map, see http://lists.openstreetmap.org/pipermail/talk-br/2009-January/000029.html.

                  22

                  Election Results

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.tse.jus.br/eleicoes..., http://dados.gov.br/dataset/re...

txt, ...

                  #19  70%

                70%

                22

Election Results

URL: http://www.tse.jus.br/eleicoes/repositorio-de-dados-eleitorais, http://dados.gov.br/dataset/resultado-das-eleicoes

Format: txt, csv (on Open Data Catalogue)

The repository of election data is available since 1945. There is no license available on the website. An introductory text explains that data can be freely used by researchers and citizens but no reference is made to open data. Also on the Open Data Catalogue (http://dados.gov.br/dataset/resultado-das-eleicoes/resource/bfd28046-7236-4a4a-82ef-3e0fcd92771c) no license is specified. Data is not timely on the Open Data Catalogue but on the primary source (website of Tribunal Superior Eleitoral).

                  41

                  National Statistics

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.sidra.ibge.gov.br/

.csv/.tsv

                  #27  60%

                60%

                41

National Statistics

URL: http://www.sidra.ibge.gov.br/

Format: .csv/.tsv

Since 2009 the Brazilian Federal Institute for Geography and Statistics realizes regular research about economic activity on a monthly base. Data is available for different economic activities and per state. Every ten years the institute realizes a demographic census. Data can be accessed via online services: http://www.sidra.ibge.gov.br/, is presented in time series: http://seriesestatisticas.ibge.gov.br/lista_tema.aspx?op=0&no=8 or can be downloaded: http://downloads.ibge.gov.br/downloads_estatisticas.htm

                  24

                  Transport Timetables
                  <span class="dataset-context" data-toggle="popover" title="Transport Timetables" data-content="
Timetables of major government operated (or commissioned) national-level public transport services (specifically bus and train). The focus here is on national level services (not those which operate only at a municipal or city level and which are not controlled or regulated by the national government). A 'yes' in any question will refer to both types of transport. However, if there is no national level service operated or regulated by the government for a given type of transport (for instance busses), then this type is ignored in this data category. Data submitted in this category should meet the following minimum criteria:

Time of operating

Time of leaving first station and arriving to the last station

Updated at least once a year

">

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

https://appweb.antt.gov.br/sgp...

.asp ...

                  #13  45%

                45%

                24

Transport Timetables

URL: https://appweb.antt.gov.br/sgp/src.br.gov.antt/apresentacao/consultas/Transp.aspx

Format: .asp database

ANTT theoretically offers timetable data for interstatual bus lines. In order to access the data, users have to fill out a form and can only consult one connection at a time. In Brazil there is no significant public transport on a national level by train. The answers are related to bus transport.

                  33

                  Legislation
                  <span class="dataset-context" data-toggle="popover" title="Legislation" data-content="
This data category requires all national laws and statutes available to be available online, although it is not a requirement that information on legislative behaviour e.g. voting records is available. To satisfy this category, the following minimum criteria must be met:

Content of the law / status

If applicable, all relevant amendments to the law

Date of last amendments

Data should be updated at least on quarterly

">

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.lexml.gov.br

html

                  #26  45%

                45%

                33

Legislation

URL: http://www.lexml.gov.br

Format: html

Has metadata about legislation (federal, state and municipal level - even though levels other than federal depend on agreements being made and few are present yet) and also court decision. Users can browse and filter content according to this metadata. Links to the full text are provided, when available, often with multiple sources (eg. the same law on the Presidency's and both Parliament's websites).

                  26

                  Company Register

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.receita.fazenda.gov..., https://www.jucesponline.sp.go...

html ...

                  #55  10%

                45%

                26

Company Register

URL: http://www.receita.fazenda.gov.br/pessoajuridica/cnpj/cnpjreva/cnpjreva_solicitacao.asp, https://www.jucesponline.sp.gov.br/Default.aspx

Format: html with embedded frames that only can be accessed submitting the identification number and filling out a captcha

Access to company data in Brazil - on a federal level - is very limited. In order to access data, one needs to know the identification number of the company. There is no service where people can search for the identification number if they only know the name.
On a state level every state has a company registration agency that maintains company data. Data for the state of São Paulo is available here: https://www.jucesponline.sp.gov.br/Default.aspx

                  51

                  Pollutant Emissions
                  <span class="dataset-context" data-toggle="popover" title="Pollutant Emissions" data-content="
Aggregate data about the emission of air pollutants especially those potentially harmful to human health (although it is not a requirement to include information on greenhouse gas emissions). Aggregate means national-level or available for at least three major cities. In order to satisfy the minimum requirements for this category, data must be available for the following pollutants and meet the following minimum criteria:

Particulate matter (PM) Levels

Sulphur oxides (SOx)

Nitrogen oxides (NOx)

Volatile organic compounds (VOCs)

Carbon monoxide (CO)

Updated on at least once a week.

Measured either at a national level by regions or at leasts in 3 big cities.

">

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="yes" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.cetesb.sp.gov.br/ar...

.xls

                  #53  0%

                35%

                51

Pollutant Emissions

URL: http://www.cetesb.sp.gov.br/ar/qualidade-do-ar/31-publicacoes-e-relatorios

Format: .xls

The Brazilian Federal Institute for Geography and Statistics - IBGE produced time series between 1992 and 2009/2010 referring to the air pollution in metropolitan areas. However, these data is not being updated anymore. The data does only cover some Brazilian cities. Additionally to this the Instituto Nacional de Pesquisas Espaciais publishes green house effects based on changes to land coverage in Amazon region: http://inpe-em.ccst.inpe.br/downloads.html. Apart from this data on air quality falls under the authority of the state government. It is provided for the state of São Paulo here: http://www.cetesb.sp.gov.br/ar/qualidade-do-ar/31-publicacoes-e-relatorios
The evaluation was made for the air quality data of São Paulo. No (daily) microdata is provided but the report shows a lot of details on the data collection and data for each point of measurement although aggregated over the year.

                  57

                  Location datasets
                  <span class="dataset-context" data-toggle="popover" title="Location datasets" data-content="
A database of postcodes/zipcodes and the corresponding spatial locations in terms of a latitude and a longitude (or similar coordinates in an openly published national coordinate system). If a postcode/zipcode system does not exist in the country, please submit a dataset of administrative borders. Data submitted in this category must satisfy the following minimum conditions

Zipcodes

Address

Coordinate (latitude longitude)

national level

updated once a year

Administrative boundaries

Boarders poligone

name of poligone (city, neighborhood)

national level

updated once a year

">

                      <li class="no" data-toggle="popover" title="<h4><p>Openly licensed? </p></h4>" data-content="<p>The licence must comply with the Open Definition which allows data to be freely used, reused and redistributed. The Open Definition provides a list of conformant licences. If the data uses one of these licences, it is openly licensed.</p>

<p>Licences are commonly found in:</p>

<ul>
<li>the web page footer</li>
<li>a link to Terms &amp; Conditions</li>
<li>the About section</li>
</ul>

<p>Some licences may allow re-use and redistribution but have not been assessed as conformant with the Open Definition. In this case, seek feedback on the Open Data Index discussion forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data machine readable? </p></h4>" data-content="<p>All files are digital, but not all can be processed or parsed easily by a computer. In order to answer this question, you would need to look at the file type of the dataset. As a rule of thumb the following file types are machine readable:</p>

<ul>
<li>XLS</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>

<p>The following formats are NOT machine readable:</p>

<ul>
<li>HTML</li>
<li>PDF</li>
<li>DOC</li>
<li>JIF</li>
<li>JPEG</li>
<li>PPT</li>
</ul>

<p>If you have a different file type and you don't know if it's machine readable or not, ask in the Open Data Census forum</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is the data provided on a timely and up to date basis? </p></h4>" data-content="<p>Is the data current for the census year? You can determine or estimate when the data was last updated and its update frequency by reviewing:</p>

<ul>
<li>the metadata displayed for the data in an open data portal or web page</li>
<li>the dataset title or filename e.g. Budget 2013-14 or Election_4July2015.csv</li>
<li>metadata tags embedded in the web page that contains the data</li>
<li>date values within the data to find the most recent date value</li>
<li>the timestamp on the data file (although this may not be accurate)</li>
<li>Some data is not updated on a regular basis. e.g. Pollutant emissions may be updated daily - while postal codes may not change for many years. </li>
</ul>

<p>You may need to use your judgement to determine if the data is timely and up to date. Document your rationale in the comments section.</p>

<p>If you cannot determine a date, answer, &quot;NO&quot; i.e. the data is not timely or up-to-date.</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Publicly available? </p></h4>" data-content="<p>Can the data be accessed by the public without restrictions? Data is considered publicly available when:</p>

<ul>
<li>It can be accessed online without the need for a password or permissions.</li>
<li>If the data is in paper form, can be accessed by the public, and there is no restrictions on the number of photocopies that can be made.</li>
</ul>

<p>Data is <strong>NOT</strong> publicly available when:</p>

<ul>
<li>It is only made available after making a request.</li>
<li>It was availiable because of FOIA. </li>
<li>It can only be accessed by government officials.</li>
</ul>">

                      <li class="no" data-toggle="popover" title="<h4><p>Is data in digital form? </p></h4>" data-content="<p>Data can be in a digital format, but not accessible online. For example: A country budget can be stored on a spreadsheet or otherwise on a private government network, but not on the Internet. This means that the data is digital, but not publicly available. If you know that the data is digital somewhere inside the government (e.g. a government official tells you so), then you should answer "YES" to this question and note in the comment section how you discovered the data is in digital form.</p>">

                      <li class="no" data-toggle="popover" title="<h4><p>Does the data exist? </p></h4>" data-content="<p>Data must come from an official resource either issued directly by the government or by a third party officially representing the government. Data offered by companies, citizen initiatives or any non-governmental organisation do not count for the Index.</p>

<p>If the government has given the right to publish the data to third parties, a submission with a link a to third party site is allowed. The third-party site must explicitly state that the data has been commissioned by the government. Check if the organization has an agreement with the government to be the official source and make a note in the comment section.</p>">

http://www.correios.com.br/pro...

.mdb, .txt

                  #14  55%

                0%

                57

Location datasets

URL: http://www.correios.com.br/produtosaz/produto.cfm?id=C33CF3D4-5056-9163-89DFF3F2A0E8DA5F

Format: .mdb, .txt

Zipcodes are sold by the public company "Correios" (Brazilian mail service). But on the website the Brazilian mail service specifies that geocodes are not contained in the dataset: http://www.correios.com.br/para-voce/correios-de-a-a-z/dne

Contributors

Reviewers

Georg Neumann

Daniela Mattern

Gil Zaretzer

Neal Bastek

Mor Rubinstein

Zach Christensen

anonymous

Nisha Thompson

yar michl

Rebecca Sentance

Tryggvi Björgvinsson

Codrina Maria Ilie

Submitters

Daniela Mattern

Rodrigo Brito

Augusto  Herrmann

Peter Krauss

anonymous

Everton Zanella Alvarenga

Felipe G. Nievinski

Tryggvi Björgvinsson

                        –

                        Data License (Public
                            Domain)

    This service is run by Open Knowledge

Open Knowledge

What is
                    Open Data?

Run your
                    own Index

Source Code

Home

Download

Methodology

FAQ

About

Contact

Press


text:
namespace PropertyManager.Web.Areas.HelpPage.ModelDescriptions
{
    public class DictionaryModelDescription : KeyValuePairModelDescription
    {
    }
}

redpajama_set_name: RedPajamaGithub


text:
namespace JsonApiDotNetCore.Queries.Internal.Parsing;

internal enum ResourceFieldCategory
{
    Field,
    Attribute,
    Relationship
}


text:
package fr.paris.lutece.portal.business.user;

import java.security.SecureRandom;
import java.util.List;
import java.util.Locale;

import org.springframework.beans.factory.config.AutowireCapableBeanFactory;
import org.springframework.context.ApplicationContext;

import fr.paris.lutece.portal.business.user.authentication.LuteceDefaultAdminAuthentication;
import fr.paris.lutece.portal.business.user.authentication.LuteceDefaultAdminUser;
import fr.paris.lutece.portal.service.spring.SpringContextService;
import fr.paris.lutece.test.LuteceTestCase;
import fr.paris.lutece.util.password.IPassword;
import fr.paris.lutece.util.password.IPasswordFactory;

public class AdminUserDAOTest extends LuteceTestCase
{

    private AdminUserDAO getAdminUserDAO( )
    {
        AdminUserDAO adminUserDAO = new AdminUserDAO( );
        ApplicationContext context = SpringContextService.getContext( );
        AutowireCapableBeanFactory beanFactory = context.getAutowireCapableBeanFactory( );
        beanFactory.autowireBean( adminUserDAO );
        return adminUserDAO;
    }

    public void testInsertLuteceDefaultAdminUser( )
    {
        AdminUserDAO adminUserDAO = getAdminUserDAO( );
        String randomUsername = "user" + new SecureRandom( ).nextLong( );
        IPasswordFactory passwordFactory = SpringContextService.getBean( IPasswordFactory.BEAN_NAME );

        LuteceDefaultAdminUser user = new LuteceDefaultAdminUser( randomUsername, new LuteceDefaultAdminAuthentication( ) );
        user.setPassword( passwordFactory.getPasswordFromCleartext( randomUsername ) );
        user.setFirstName( randomUsername );
        user.setLastName( randomUsername );
        user.setEmail( randomUsername + "@lutece.fr" );
        adminUserDAO.insert( user );

        try
        {
            LuteceDefaultAdminUser storedUser = adminUserDAO.loadDefaultAdminUser( user.getUserId( ) );
            assertEquals( randomUsername, storedUser.getAccessCode( ) );
            assertEquals( randomUsername, storedUser.getFirstName( ) );
            assertEquals( randomUsername, storedUser.getLastName( ) );
            assertEquals( randomUsername + "@lutece.fr", storedUser.getEmail( ) );
            assertTrue( storedUser.getPassword( ).check( randomUsername ) );
        }
        finally
        {
            adminUserDAO.delete( user.getUserId( ) );
        }
    }

    public void testLoadDefaultAdminUser( )
    {
        AdminUserDAO adminUserDAO = getAdminUserDAO( );
        LuteceDefaultAdminUser storedUser = adminUserDAO.loadDefaultAdminUser( 1 );
        assertEquals( "admin", storedUser.getAccessCode( ) );
        assertEquals( "admin", storedUser.getFirstName( ) );
        assertEquals( "Admin", storedUser.getLastName( ) );
        assertEquals( "admin@lutece.fr", storedUser.getEmail( ) );
        assertEquals( AdminUser.ACTIVE_CODE, storedUser.getStatus( ) );
        assertTrue( storedUser.getPassword( ).check( "adminadmin" ) );
        assertEquals( Locale.FRENCH, storedUser.getLocale( ) );
        assertEquals( 0, storedUser.getUserLevel( ) );
        assertFalse( storedUser.getAccessibilityMode( ) );
        assertNull( storedUser.getAccountMaxValidDate( ) );
        assertEquals( "all", storedUser.getWorkgroupKey( ) );
    }

    public void testStoreLuteceDefaultAdminUser( )
    {
        AdminUserDAO adminUserDAO = getAdminUserDAO( );
        String randomUsername = "user" + new SecureRandom( ).nextLong( );
        IPasswordFactory passwordFactory = SpringContextService.getBean( IPasswordFactory.BEAN_NAME );

        LuteceDefaultAdminUser user = new LuteceDefaultAdminUser( randomUsername, new LuteceDefaultAdminAuthentication( ) );
        user.setPassword( passwordFactory.getPasswordFromCleartext( randomUsername ) );
        user.setFirstName( randomUsername );
        user.setLastName( randomUsername );
        user.setEmail( randomUsername + "@lutece.fr" );
        adminUserDAO.insert( user );

        try
        {
            LuteceDefaultAdminUser storedUser = adminUserDAO.loadDefaultAdminUser( user.getUserId( ) );
            String changedRandomUsername = randomUsername + "_2";
            storedUser.setAccessCode( changedRandomUsername );
            storedUser.setFirstName( changedRandomUsername );
            storedUser.setLastName( changedRandomUsername );
            storedUser.setEmail( changedRandomUsername + "@lutece.fr" );
            storedUser.setPassword( passwordFactory.getPasswordFromCleartext( changedRandomUsername ) );

            adminUserDAO.store( storedUser, PasswordUpdateMode.UPDATE );

            storedUser = adminUserDAO.loadDefaultAdminUser( user.getUserId( ) );

            assertEquals( changedRandomUsername, storedUser.getAccessCode( ) );
            assertEquals( changedRandomUsername, storedUser.getFirstName( ) );
            assertEquals( changedRandomUsername, storedUser.getLastName( ) );
            assertEquals( changedRandomUsername + "@lutece.fr", storedUser.getEmail( ) );
            assertTrue( storedUser.getPassword( ).check( changedRandomUsername ) );
        }
        finally
        {
            adminUserDAO.delete( user.getUserId( ) );
        }
    }

    public void testStoreLuteceDefaultAdminUserIgnorePassword( )
    {
        AdminUserDAO adminUserDAO = getAdminUserDAO( );
        String randomUsername = "user" + new SecureRandom( ).nextLong( );
        IPasswordFactory passwordFactory = SpringContextService.getBean( IPasswordFactory.BEAN_NAME );

        LuteceDefaultAdminUser user = new LuteceDefaultAdminUser( randomUsername, new LuteceDefaultAdminAuthentication( ) );
        user.setPassword( passwordFactory.getPasswordFromCleartext( randomUsername ) );
        user.setFirstName( randomUsername );
        user.setLastName( randomUsername );
        user.setEmail( randomUsername + "@lutece.fr" );
        adminUserDAO.insert( user );

        try
        {
            LuteceDefaultAdminUser storedUser = adminUserDAO.loadDefaultAdminUser( user.getUserId( ) );
            String changedRandomUsername = randomUsername + "_2";
            storedUser.setAccessCode( changedRandomUsername );
            storedUser.setFirstName( changedRandomUsername );
            storedUser.setLastName( changedRandomUsername );
            storedUser.setEmail( changedRandomUsername + "@lutece.fr" );
            storedUser.setPassword( passwordFactory.getPasswordFromCleartext( changedRandomUsername ) );

            adminUserDAO.store( storedUser, PasswordUpdateMode.IGNORE );

            storedUser = adminUserDAO.loadDefaultAdminUser( user.getUserId( ) );

            assertEquals( changedRandomUsername, storedUser.getAccessCode( ) );
            assertEquals( changedRandomUsername, storedUser.getFirstName( ) );
            assertEquals( changedRandomUsername, storedUser.getLastName( ) );
            assertEquals( changedRandomUsername + "@lutece.fr", storedUser.getEmail( ) );
            assertTrue( storedUser.getPassword( ).check( randomUsername ) );
        }
        finally
        {
            adminUserDAO.delete( user.getUserId( ) );
        }
    }

    public void testPasswordHistory( )
    {
        AdminUserDAO adminUserDAO = getAdminUserDAO( );
        String randomUsername = "user" + new SecureRandom( ).nextLong( );
        IPasswordFactory passwordFactory = SpringContextService.getBean( IPasswordFactory.BEAN_NAME );

        LuteceDefaultAdminUser user = new LuteceDefaultAdminUser( randomUsername, new LuteceDefaultAdminAuthentication( ) );
        user.setPassword( passwordFactory.getPasswordFromCleartext( randomUsername ) );
        user.setFirstName( randomUsername );
        user.setLastName( randomUsername );
        user.setEmail( randomUsername + "@lutece.fr" );
        adminUserDAO.insert( user );

        try
        {
            adminUserDAO.insertNewPasswordInHistory( passwordFactory.getPasswordFromCleartext( "1" ), user.getUserId( ) );
            Thread.sleep( 1000 ); // Need this because the PRIMARY KEY uses the timestamp
            adminUserDAO.insertNewPasswordInHistory( passwordFactory.getPasswordFromCleartext( "2" ), user.getUserId( ) );
            Thread.sleep( 1000 ); // Need this because the PRIMARY KEY uses the timestamp
            adminUserDAO.insertNewPasswordInHistory( passwordFactory.getPasswordFromCleartext( "3" ), user.getUserId( ) );

            List<IPassword> passwords = adminUserDAO.selectUserPasswordHistory( user.getUserId( ) );
            assertNotNull( passwords );
            assertEquals( 3, passwords.size( ) );
            assertTrue( passwords.get( 0 ).check( "3" ) );
            assertTrue( passwords.get( 1 ).check( "2" ) );
            assertTrue( passwords.get( 2 ).check( "1" ) );
        }
        catch( InterruptedException e )
        {
            throw new RuntimeException( e ); // Should not happen
        }
        finally
        {
            try
            {
                adminUserDAO.removeAllPasswordHistoryForUser( user.getUserId( ) );
            }
            finally
            {
            }
            adminUserDAO.delete( user.getUserId( ) );
        }
    }
}


text:
This is a plugin for Craft CMS that enables the site to recieve webmentions. Some config will be needed.

Use composer:
curl -sS https://getcomposer.org/installer | php
php composer.phar install

You must change the type and section ids within the controller to match your own site.

Tested with Quill https://quill.p3k.io/
Learn more at https://indiewebcamp.com/Micropub

Thanks to Jeremy Keith https://adactio.com/ for the authentication script.


text:
<!doctype html>

  Outbound
  Local


text:
<?php

class Controller {

    protected $_model;
    protected $_controller;
    protected $_action;
    protected $_view;

    function __construct($model, $controller, $action) {
        $this->_controller = $controller;
        $this->_action = $action;
        $this->_model = $model;
        //echo '
'.$controller.'
';
        //echo '
'.$action.'
';
        $this->$model = new $model;
        $this->_view = new View($controller,$action);
    }

    function set($name,$value) {
        $this->_view->set($name,$value);
    }

    function buildMenus($pageCategory, $urlPrefix, $file, $uriQuery) {
        $this->buildMenu($pageCategory, $urlPrefix, $file, $uriQuery);
        //$this->buildFooterLinks($pageCategory, $urlPrefix, $file, $uriQuery);
    }

    function buildMenu($pageCategory, $urlPrefix, $file, $uriQuery) {
        $menuId['main']        = '';
        $menuId['si']          = '';
        $menuId[$pageCategory] = ' id="current"';

        $menuItems;

        $menu = '

';

        $menuItems['main']   = $urlPrefix.'main/display/'.$file.$uriQuery;
        $menuItems['si']     = $urlPrefix.'si/display/'.$file.$uriQuery;

        $menuItems[$pageCategory] = '.';

        $menu .= '
Home
';
        $menu .= ' |
Space Invaders
';

        $menu .= "

";
        $this->set('menu', $menu);
        $this->set('menuItems', $menuItems);
    }
    /*
    function buildFooterLinks($pageCategory, $urlPrefix, $file, $uriQuery) {

    $footerId['about']        = '';
        $footerId['credits']      = '';
        $footerId[$pageCategory]  = ' id="current"';

        $footerItems;
        $footerLinks = '';

    $footerItems['about']     = $urlPrefix.'about/display/'.$file.$uriQuery;
        $footerItems['credits']   = $urlPrefix.'credits/display/'.$file.$uriQuery;
        $menuItems[$pageCategory] = '#';

    // reuse for the slogan or vp link
        //$footerLinks .= 'About';
        //$this->set('footerLinks', $footerLinks);
    }
    */
    function __destruct() {
        // The View is rendered after all the initialization done by the Controller
        $this->_view->render();
    }
}

?>


text:
from django.contrib import admin

# Internal
from .models import Mapping

class MappingAdmin(admin.ModelAdmin):
    fields = ('label', 'data_map',)
    list_display = ('label', 'data_map',)
    search_fields = ('label',)

admin.site.register(Mapping, MappingAdmin)


text:
require 'yard_tii_extensions/active_record_attribute'
require 'yard_tii_extensions/handlers/legacy/validator_handler_helper'

module YardTiiExtensions
  module Legacy
    class ValidateConfirmationOfHandler < YARD::Handlers::Ruby::Legacy::Base
      include ValidatorHandlerHelper
      include ActiveRecordAttributesHelper

      VALIDATION_STMNT = /^validates_confirmation_of\s+(.*)/
      handles VALIDATION_STMNT

      def process
        conditions = pull_conditions do |key, condition|
          %w(:if :unless :on).include?(key) || (key == ":allow_nil" && condition == "true")
        end
        conditions = conditions.collect{|k, v| "#{k} => #{v}"} if conditions

        attributes.each do |param|
          new_param_name = param.to_s + "_confirmation"
          ar_attr = ar_attribute(new_param_name)
          ar_attr.required(conditions.try(:join, ' and '))
        end
      end
    end
  end
end


text:
*This uses SoftDelete*
# Laradrop

[![Software License][ico-license]](LICENSE.md)

This is a file manager using Dropzone.js for Laravel 5.  It provides basic functionality for managing, uploading,
and deleting files.

## Demo
A demo of the system can be found at http://laradrop.elegrit.com.

## Quick Start
Here's an 4 step process to get a fully functional demo, similar to http://laradrop.elegrit.com.

1)  Follow the **Installation**  instructions below.

        Getting errors?  Make sure you have a database set up (http://laravel.com/docs/5.0/database).

2) In a view (welcome.blade.php, for example), add:
```html
<html>
    <head>
        <title>Laradrop Demo</title>
        <link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" type="text/css">
        <link href="/vendor/jasekz/laradrop/css/styles.css" rel="stylesheet" type="text/css">
        <link href="https://fonts.googleapis.com/css?family=Lato:300" rel="stylesheet" type="text/css">
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
        <script src="//code.jquery.com/ui/1.11.4/jquery-ui.min.js" ></script>
        <script src="/vendor/jasekz/laradrop/js/enyo.dropzone.js"></script>
        <script src="/vendor/jasekz/laradrop/js/laradrop.js"></script>
    </head>
    <body>
        <div class="laradrop" laradrop-csrf-token="{{ csrf_token() }}"> </div>
    </body>
    <script>
    jQuery(document).ready(function(){
        jQuery('.laradrop').laradrop();
    });
    </script>
</html>
```

3) In your **.env** file, add:

```
LARADROP_DISK_PUBLIC_URL=/uploads
LARADROP_DISK=laradrop
```
4) In your **config/filesystems.php**, add to your `disks` array:
```
'laradrop' => [
            'driver' => 'local',
            'root' => public_path('uploads'), // will put files in 'public/upload' directory
        ],
```
That's it.  If you have any issues or question, please feel free to open an issue.

## Installation

NOTE: If you haven't set up a database yet for your app, please do that first as per Laravel docs -  http://laravel.com/docs/5.0/database.

Via composer
```
composer require jasekz/laradrop
```

Then in your `config/app.php` add
```php
    'Jasekz\Laradrop\LaradropServiceProvider'
```
to the `providers` array.

Then run

    artisan vendor:publish

followed by

    artisan migrate

## Configuration (.env)

Laradrop uses Laravel's Filesystem mechanism (https://laravel.com/docs/5.2/filesystem) and by default will store your
files in the `storage/app` directory.  If you would like to modify this behavior, along with other default settings, you can set your `.env` file variables:
```php

# s3, local, or Rackspace.  See 'Other Driver Prerequisites' at https://laravel.com/docs/5.2/filesystem.  Defaults to 'local'
LARADROP_DISK=local

# If your files need to be web accessible, set this param.  S3, for example, would be 'https://s3.amazonaws.com/my-bucket'.  Defaults to the web root (public).
LARADROP_DISK_PUBLIC_URL=/img

# If a thumbnail can not be generated due to incompatible file or any other reason, what image do you want to use? Defaults to 'vendor/jasekz/laradrop/img/genericThumbs/no-thumb.png'
LARADROP_DEFAULT_THUMB=/img/no-thumb.png

# Max file upload size in MB.  Defaults to 10.
LARADROP_MAX_UPLOAD_SIZE=20

# Max file size (in MB) for which thumbnail generation will be attempted.  If your server has an issue processing thumbs, you can lower this value.  Defaults to 10.
LARADROP_MAX_THUMBNAIL_SIZE=10

# Defaults to 150px.
LARADROP_THUMB_WIDTH=150

# Defaults to 150px.
LARADROP_THUMB_HEIGHT=150

# Run laradrop routes through middlware.  Defaults to none.
LARADROP_MIDDLEWARE=web
```
## Usage
This package requires Dropzone.js, jQuery, and jQuery UI.  Include these somewhere in your template:
``` php
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.min.js" ></script>
<script src="/vendor/jasekz/laradrop/js/enyo.dropzone.js"></script>
<script src="/vendor/jasekz/laradrop/js/laradrop.js"></script>
```

By default, Laradrop is designed for Bootstrap, but it's not a requirement.  Include Bootstrap and the Laradrop styles if you'd like to use it:
``` php
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="/vendor/jasekz/laradrop/css/styles.css" rel="stylesheet" type="text/css">
```

Add the html code where you'd like to implement the file manager.  Note, that by default, there is no middleware assigned to the Laradrop controller, however, it you assign middleware which contains csrf protection, you must include the `laradrop-csrf-token="{{ csrf_token() }}"` attribute.
``` html
<div class="laradrop" laradrop-csrf-token="{{ csrf_token() }}"> </div>
```

Finally, bind it using jQuery:
```javascript
<script>
jQuery(document).ready(function(){
    // Simplest:
    jQuery('.laradrop').laradrop();

    // With custom params:
    jQuery('.laradrop-custom').laradrop({
        breadCrumbRootText: 'My Root', // optional
        actionConfirmationText: 'Sure about that?', // optional
        onInsertCallback: function (obj){ // optional
            // if you need to bind the select button, implement here
             alert('Thumb src: '+obj.src+'. File ID: '+obj.id+'.  Please implement onInsertCallback().');
        },
        onErrorCallback: function(msg){ // optional
            // if you need an error status indicator, implement here
            alert('An error occured: '+msg);
        },
         onSuccessCallback: function(serverRes){ // optional
            // if you need a success status indicator, implement here
        }
    });
});
</script>
```

## Events
Laradrop currently fires two events:

1. **Jasekz\Laradrop\Events\FileWasUploaded** - this is fired after a file has been uploaded and saved.
2. **Jasekz\Laradrop\Events\FileWasDeleted** - this is fired after a file is deleted.

## Handlers (upload, delete, list, etc)
If you'd like to implement your own hanldlers (or extend the existing ones with your own controllers), you can do so.  All you need to do, is to defined the routes to the appropriate handlers in the button attributes.  This also allows you to easily have multiple handlers for different use cases, if so desired.
``` html
<div class="laradrop"
    laradrop-file-source="{{ route('yourRoute.index') }}"
    laradrop-upload-handler="{{ route('yourRoute.store') }}"
    laradrop-file-delete-handler="{{ route('yourRoute.destroy', 0) }}"
    laradrop-file-move-handler="{{ route('yourRoute.move') }}"
    laradrop-file-create-handler="{{ route('yourRoute.create') }}"
    laradrop-containers="{{ route('yourRoute.containers') }}"
    laradrop-csrf-token="{{ csrf_token() }}"
    laradrop-allow=".pdf">
</div>
```
## File type validations
The default implementation of accept checks the file's mime type or extension against this list. This is a comma separated list of mime types or file extensions.

Eg.: image/*,application/pdf,.psd

If the Dropzone is clickable this option will also be used as accept parameter on the hidden file input as well.

## License

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

[ico-license]: https://img.shields.io/badge/license-MIT-brightgreen.svg?style=flat-square


text:
module Dashtag
	class NumSetting

		def initialize num
			@number = num
		end

    def dehydrate
      @number.to_s
    end

    def self.parse(num)
      num.blank? ? nil : new(Integer(num))
    end

    def self.hydrate(num)
      new(Integer(num))
    end

    def ==(arg)
    	@number == arg
    end

    def to_ui_format
      @number
    end

    def as_int
      @number
    end
	end
end


text:
package org.bridje.sql;

import java.io.IOException;
import java.net.URISyntaxException;
import java.sql.SQLException;
import org.bridje.ioc.Ioc;
import org.bridje.vfs.CpSource;
import org.bridje.vfs.VFile;
import org.junit.*;

public class SQLTest
{
    public SQLTest()
    {
    }

    @BeforeClass
    public static void setUpClass()
    {
    }

    @AfterClass
    public static void tearDownClass()
    {
    }

    @Before
    public void setUp() throws IOException, URISyntaxException
    {
        VFile etc = new VFile("/etc");
        etc.mount(new CpSource("BRIDJE-INF/etc"));
    }

    @After
    public void tearDown()
    {
    }

    @Test
    public void test1CreateTables() throws SQLException
    {
        SQLService sqlServ = Ioc.context().find(SQLService.class);
        SQLEnvironment sqlEnv = sqlServ.createEnvironment("H2-DB");
        sqlEnv.fixSchema(TestDB.SCHEMA);

        sqlEnv.update(SQL.delete().from(User.TABLE).toQuery());
        sqlEnv.update(SQL.delete().from(Group.TABLE).toQuery());
        sqlEnv.update(SQL.delete().from(UserGroup.TABLE).toQuery());

        Query insertUsers = SQL.insertInto(User.TABLE)
                .columns(User.EMAIL, User.PASSWORD, User.ACTIVE)
                .values(User.EMAIL.asParam(), User.PASSWORD.asParam(), User.ACTIVE.asParam())
                .toQuery();
        sqlEnv.update(insertUsers, "email1@domain.com", "pass1", true);
        sqlEnv.update(insertUsers, "email2@domain.com", "pass2", true);
        sqlEnv.update(insertUsers, "email3@domain.com", "pass3", true);
        sqlEnv.update(insertUsers, "email4@domain.com", "pass4", false);
        sqlEnv.update(insertUsers, "email5@domain.com", "pass5", false);

        Query countUsers = SQL.select(SQL.count())
                                    .from(User.TABLE)
                                    .toQuery();

        Integer ctn = sqlEnv.fetchOne(countUsers, (rs) -> rs.get(SQL.count()));
        Assert.assertNotNull(ctn);
        Assert.assertEquals(5l, ctn.longValue());

        Query insertGroups = SQL.insertInto(Group.TABLE)
                .columns(Group.TITLE)
                .values(Group.TITLE.asParam())
                .toQuery();
        sqlEnv.update(insertGroups, "Group 1");
        sqlEnv.update(insertGroups, "Group 2");
        sqlEnv.update(insertGroups, "Group 3");

        Query countGroups = SQL.select(SQL.count())
                                    .from(Group.TABLE)
                                    .toQuery();

        ctn = sqlEnv.fetchOne(countGroups, (rs) -> rs.get(SQL.count()));
        Assert.assertNotNull(ctn);
        Assert.assertEquals(3l, ctn.longValue());
    }
}


text:
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/* This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */

#ifndef __nsDialogParamBlock_h
#define __nsDialogParamBlock_h

#include "nsIDialogParamBlock.h"
#include "nsIMutableArray.h"
#include "nsCOMPtr.h"

// {4E4AAE11-8901-46cc-8217-DAD7C5415873}
#define NS_DIALOGPARAMBLOCK_CID \
 {0x4e4aae11, 0x8901, 0x46cc, {0x82, 0x17, 0xda, 0xd7, 0xc5, 0x41, 0x58, 0x73}}

class nsString;

class nsDialogParamBlock: public nsIDialogParamBlock
{
public:
  nsDialogParamBlock();
  virtual ~nsDialogParamBlock();

  NS_DECL_NSIDIALOGPARAMBLOCK
  NS_DECL_ISUPPORTS

private:

  enum {kNumInts = 8, kNumStrings = 16};

  nsresult InBounds(int32_t inIndex, int32_t inMax) {
    return inIndex >= 0 && inIndex < inMax ? NS_OK : NS_ERROR_ILLEGAL_VALUE;
  }

  int32_t mInt[kNumInts];
  int32_t mNumStrings;
  nsString* mString;
  nsCOMPtr<nsIMutableArray> mObjects;
};

#endif


text:
#ifndef LOGAREA_H
#include "Logic.h"
#define LOGAREA_H

#include <QTextEdit>
#include <QLineEdit>
class LogArea : public QTextEdit
{
public:
    explicit LogArea(QWidget *parent = 0);
    void append(QString text);

};
class ChatArea : public QTextEdit
{
public:
    ChatArea(QWidget *parent=0);
    void append(int id, QString text);
};
class ChatLine : public QLineEdit
{
    Q_OBJECT
public:
    ChatLine(QWidget*parent=0);
public slots:
    void onReturnPressed();
signals:
    void toChat(unsigned short proto_type, google::protobuf::Message*);
};

#endif // LOGAREA_H


text:
<?php

// No direct access
defined('_HZEXEC_') or die();

$this->css();

Toolbar::title($this->group->get('description').': '.$this->module->get('title').' - ' . Lang::txt('COM_GROUPS_MODULES_ERRORS'), 'groups.png');
Toolbar::custom('errorscheckagain', 'check', 'check', 'COM_GROUPS_MODULES_CHECK_AGAIN', false);
Toolbar::cancel();

// page version content
$content = $this->module->get('content');
?>

<form action="i<?php echo Route::url('index.php?option=' . $this->option . '&controller=' . $this->controller . '&gid=' . $this->group->cn); ?>" method="post" name="adminForm" id="item-form">

		<?php echo Lang::txt('COM_GROUPS_MODULES_ERROR_LIST', $this->module->get('title'), $this->error); ?>

<?php echo Lang::txt('COM_GROUPS_MODULES_RAW_CODE'); ?>

		<?php
			$lines = explode("\n", $content);
			$lineCode = '';
			for ($i=1; $i <= count($lines); $i++)
			{
				$lineCode .= " ".$i."
";
			}
		?>

				<?php echo $lineCode; ?>

					<?php echo highlight_string($content); ?>

<?php echo Lang::txt('COM_GROUPS_MODULES_UPDATE_CONTENT'); ?>

	<textarea name="module[content]" rows="40"><?php echo $content; ?></textarea>

	<input type="hidden" name="module[id]" value="<?php echo $this->module->get('id'); ?>">
	<input type="hidden" name="option" value="<?php echo $this->option; ?>" />
	<input type="hidden" name="controller" value="<?php echo $this->controller; ?>" />
	<input type="hidden" name="gid" value="<?php echo $this->group->get('cn'); ?>" />
	<input type="hidden" name="task" value="save" />
	<?php echo Html::input('token'); ?>
</form>


text:
(function(w) {

  "use strict";

  var MyAnalyser = function(canvas, source, context) {
    this.canvas = canvas;
    this.canvasCtx = canvas.getContext('2d');
    this.HEIGHT = canvas.height;
    this.WIDTH = canvas.width;
    this.source = source;
    this.context = context;
    this.analyser = this.context.createAnalyser();
    this.source.connect(this.analyser);
    this.bufferLength = this.analyser.fftSize = 2048 * 2;
    this.dataArray = new Uint8Array(this.bufferLength);
    this.analyser.minDecibels = -100;
    this.analyser.maxDecibels = -10;
    this.analyser.smoothingTimeConstant = 0.55;
    this.draw();
  };

  MyAnalyser.prototype.draw = function() {
    var sliceWidth, x, v, y;
    this.HEIGHT = this.canvas.height;
    this.WIDTH = this.canvas.width;
    x = 0;
    sliceWidth = this.WIDTH / this.bufferLength;
    this.canvasCtx.clearRect(0, 0, this.WIDTH, this.HEIGHT);
    this.drawVisual = w.requestAnimationFrame(this.draw.bind(this));
    this.analyser.getByteTimeDomainData(this.dataArray);

    this.canvasCtx.lineWidth = 2;
    this.canvasCtx.strokeStyle = 'rgb(0, 0, 0)';

    this.canvasCtx.beginPath();

    for (var i = 0; i < this.bufferLength; i++) {
      v = this.dataArray[i] / 128;
      y = v * this.HEIGHT / 2;

      if (i === 0) {
        this.canvasCtx.moveTo(x, y);
      }
      else {
        this.canvasCtx.lineTo(x, y);
      }

      x += sliceWidth;
    }

    this.canvasCtx.stroke();
  };

  w.MyAnalyser = MyAnalyser;
})(this);


text:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace WebsitePanel.Providers.Virtualization
{
    public class VMInfo : ServiceProviderItem
    {
        [Persistent]
        public  int VmId {get; set; }

        [Persistent]
        public Guid VmGuid { get; set; }

        [Persistent]
        public Guid TemplateId { get; set; }
        [Persistent]
        public string TemplateName { get; set; }
        [Persistent]
        public string CurrentTaskId { get; set; }
        [Persistent]
        public string VmPath { get; set; }
        [Persistent]
        public string ProductKey { get; set; }
        [Persistent]
        public string HostName { get; set; }
        [Persistent]
        public string ComputerName { get; set; }
        [Persistent]
        public string Owner { get; set; }
        [Persistent]
        public string AdminUserName { get; set; }
        [Persistent]
        public string AdminPassword { get; set; }
        public string JoinDomain { get; set; }
        public string JoinDomainUserName { get; set; }
        public string JoinDomainPassword { get; set; }
        public bool MergeAnswerFile { get; set; }
        [Persistent]
        public int CPUCount { get; set; }
        [Persistent]
        public int CPUUtilization { get; set; }
        public int PerfCPUUtilization { get; set; }

        [Persistent]
        public int Memory { get; set; }

        public int ProcessMemory { get; set; }

        [Persistent]
        public bool NumLockEnabled { get; set; }
        [Persistent]
        public bool DvdDriver { get; set; }
        [Persistent]
        public int HddSize { get; set; }
        [Persistent]
        public int IOPSmin { get; set; }
        [Persistent]
        public int IOPSmax { get; set; }
        [Persistent]
        public int SnapshotsNumber { get; set; }
        [Persistent]
        public bool BootFromCD { get; set; }

        public LogicalDisk[] HddLogicalDisks { get; set; }

        [Persistent]
        public bool ExternalNetworkEnabled { get; set; }
        [Persistent]
        public string ExternalNicMacAddress { get; set; }
        [Persistent]
        public string ExternalVirtualNetwork { get; set; }
        [Persistent]
        public string ExternalNetworkLocation { get; set; }

        [Persistent]
        public bool PrivateNetworkEnabled { get; set; }
        [Persistent]
        public string PrivateNicMacAddress { get; set; }
        [Persistent]
        public string PrivateVirtualNetwork { get; set; }
        [Persistent]
        public ushort PrivateVLanID { get; set; }
        [Persistent]
        public string PrivateNetworkLocation { get; set; }

        [Persistent]
        public bool ManagementNetworkEnabled { get; set; }
        [Persistent]
        public string ManagementNicMacAddress { get; set; }

        [Persistent]
        public VirtualMachineProvisioningStatus ProvisioningStatus { get; set; }
        [Persistent]
        public VMComputerSystemStateInfo State { get; set; }

        public string ModifiedTime { get; set; }

        // User configuration
        [Persistent]
        public bool StartTurnOffAllowed { get; set; }
        [Persistent]
        public bool PauseResumeAllowed { get; set; }
        [Persistent]
        public bool RebootAllowed { get; set; }
        [Persistent]
        public bool ResetAllowed { get; set; }
        [Persistent]
        public bool ReinstallAllowed { get; set; }

        [Persistent]
        public ConcreteJob CurrentJob { get; set; }

        public string exMessage { get; set; }

        public string logMessage { get; set; }
    }
}