The Center for Advanced Studies in Applied Economics (Cepea) is a research group registered with the National Council for Scientific and Technological Development (CNPq), which is part of the Department of Economics, Administration and Sociology of the “Luiz Queiroz” College of Agriculture (Esalq), a unit of the University of São Paulo (USP) located in Piracicaba.
Cepea's main focus is on the rural sector, but it also has ties to other sectors that cooperate with agribusiness. Cepea's purpose is to carry out research applied to the economic and administrative side, publicizing the results it generates.
Information about the data source
Center for Advanced Studies in Applied Economics (Cepea): The group is made up of Esalq/USP professors and researchers (PhDs and master's degree holders) who have knowledge of agronomy, economics, administration and accounting; professionals in communication, information technology and administration; and it includes undergraduate interns from Esalq/USP and from other Brazilian and foreign universities/institutions.
Cepea is public in nature and carries out research on the dynamics of production chains, together with the integrated functioning of agribusiness, foreign trade policies and the influence of new technologies. Cepea continuously calculates the gross domestic product (GDP) of the national agribusiness production chains, and also collects export data for the sector.
Source name: Agricultural and Livestock Prices
Maintaining institution: Center for Advanced Studies in Applied Economics (Cepea)
Address to access the source: http://www.cepea.esalq.usp.br/br
To start the search, the user should type the word “Cepea” on a search page (of their choice). From the results, the user should find the link to the Cepea website. After opening the site's home page, right at the top of the page, click “Agricultural and Livestock Prices”; inside this item there will be product subsections. The search carried out selected the product "Coffee". Next, another window will open, and on its right side there will be the section "Price Series"; to run the query, click “Database Query,” after which you will be taken to the database query page.
On the left side of the page "Site Database Queries" there will be a table named “Product” (select the product of your choice), and on the right side of the page you must fill in the Frequency of the query, which can be: “daily,” “weekly,” “monthly” or “yearly.” Below that, indicate the Period; you need to enter the time interval for which you would like to obtain information. If the product has different types (as in the case of Conilon and Arabica coffee), choose the type of coffee, which will generate a chart; after that, click Generate Excel, and below it there will be the option to Download; by clicking the download option you will be able to open the file in “xls.”
Information about the data
The data files can be downloaded in the “(XLS)” format and opened with Microsoft Office Excel or LibreOffice Calc.
The Excel spreadsheet that will be made available will have a title describing the subject of the information, and explanatory notes detailing the weight of the bag in kilos, the type, etc.
The data table will have three columns: the first contains the dates, the second the spot value in R$ and the third relates to the spot value in dollars (US$); the records will have all the values corresponding to the respective dates.
Data visualization
To show possibilities for using and analyzing the data made available in the source described, visualizations were created that can give the researcher a better understanding of the information obtained.
Authors: AMANDA FRANÇA CASTELLI*; BRUNO POLACHINI VENTUROSO DE SOUZA*; LETÍCIA FLÁVIA RUELA PARRA*; NATALY ASSIS AMANTINO DA SILVA*; THAIS FERNANDES MODENEIS*; VIVIANE PERRONI*.
* Students in the Business Administration program at São Paulo State University - "Júlio de Mesquita Filho"
The accuracy of the information on this page, as well as of the images and photographs, is the sole responsibility of the cited sources and does not necessarily reflect the opinion or position of the Digital Skills for Family Farming (CoDAF) outreach project, its collaborators or the institutions linked to the project.