IDEAS home Printed from https://ideas.repec.org/p/bde/opaper/1802.html
   My bibliography  Save this paper

Evaluating the macro-representativeness of a firm-level database: an application for the Spanish economy

Author

Listed:
  • Miguel Almunia

    (University of Warwick)

  • David López-Rodríguez

    (Banco de España)

  • Enrique Moral-Benito

    (Banco de España)

Abstract

The availability of a firm-level database that represents the productive sector of an economy at the aggregate level is a necessary condition to undertake both reliable policy analysis and economic research in multiple areas. In this paper, we document the construction of a new representative firm-level dataset for Spain using detailed micro-level information provided by firms to the Spanish Commercial Registry and the Bank of Spain. A comparison with National Accounts figures serves to illustrate that the new micro-dataset is able to replicate the growth rates of output, employment and wage bill of the private sector. Using official statistics from the National Institute of Statistics (INE), we show that the resulting dataset covers more than 80% of firms registered in the census over the years 2000-2013 and, more importantly, the resulting dataset replicates the firm size distribution of the Spanish non-financial market economy. The same representativeness analysis is done for the manufacturing sector indicating that this sector is particularly well-represented in the dataset.

Suggested Citation

  • Miguel Almunia & David López-Rodríguez & Enrique Moral-Benito, 2018. "Evaluating the macro-representativeness of a firm-level database: an application for the Spanish economy," Occasional Papers 1802, Banco de España.
  • Handle: RePEc:bde:opaper:1802
    as

    Download full text from publisher

    File URL: https://www.bde.es/f/webbde/SES/Secciones/Publicaciones/PublicacionesSeriadas/DocumentosOcasionales/18/Files/do1802e.pdf
    File Function: First version, March 2018
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Luis Garicano & Claire Lelarge & John Van Reenen, 2016. "Firm Size Distortions and the Productivity Distribution: Evidence from France," American Economic Review, American Economic Association, vol. 106(11), pages 3439-3479, November.
    2. Gita Gopinath & Şebnem Kalemli-Özcan & Loukas Karabarbounis & Carolina Villegas-Sanchez, 2017. "Capital Allocation and Productivity in South Europe," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 132(4), pages 1915-1967.
    3. François Gourio & Nicolas Roys, 2014. "Size‐dependent regulations, firm size distribution, and reallocation," Quantitative Economics, Econometric Society, vol. 5, pages 377-416, July.
    4. John G. Fernald, 2015. "Productivity and Potential Output before, during, and after the Great Recession," NBER Macroeconomics Annual, University of Chicago Press, vol. 29(1), pages 1-51.
    5. Manuel García‐Santana & Enrique Moral‐Benito & Josep Pijoan‐Mas & Roberto Ramos, 2020. "Growing Like Spain: 1995–2007," International Economic Review, Department of Economics, University of Pennsylvania and Osaka University Institute of Social and Economic Research Association, vol. 61(1), pages 383-416, February.
    6. Atif Mian & Amir Sufi, 2010. "The Great Recession: Lessons from Microeconomic Data," American Economic Review, American Economic Association, vol. 100(2), pages 51-56, May.
    7. Chang-Tai Hsieh & Peter J. Klenow, 2009. "Misallocation and Manufacturing TFP in China and India," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 124(4), pages 1403-1448.
    8. Miguel Almunia & David Lopez-Rodriguez, 2018. "Under the Radar: The Effects of Monitoring Firms on Tax Compliance," American Economic Journal: Economic Policy, American Economic Association, vol. 10(1), pages 1-38, February.
    9. Şebnem Kalemli- Özcan & Bent E. Sørensen & Carolina Villegas-Sanchez & Vadym Volosovych & Sevcan Yeşiltaş, 2024. "How to Construct Nationally Representative Firm-Level Data from the Orbis Global Database: New Facts on SMEs and Aggregate Implications for Industry Concentration," American Economic Journal: Macroeconomics, American Economic Association, vol. 16(2), pages 353-374, April.
    10. Sebnem Kalemli-Ozcan & Bent Sorensen & Carolina Villegas-Sanchez & Vadym Volosovych & Sevcan Yesiltas, 2015. "How to Construct Nationally Representative Firm Level Data from the Orbis Global Database: New Facts and Aggregate Implications," NBER Working Papers 21558, National Bureau of Economic Research, Inc.
    11. Atif Mian & Amir Sufi, 2009. "The Consequences of Mortgage Credit Expansion: Evidence from the U.S. Mortgage Default Crisis," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 124(4), pages 1449-1496.
    12. Mark Doms & Eric J. Bartelsman, 2000. "Understanding Productivity: Lessons from Longitudinal Microdata," Journal of Economic Literature, American Economic Association, vol. 38(3), pages 569-594, September.
    13. Marc J. Melitz, 2003. "The Impact of Trade on Intra-Industry Reallocations and Aggregate Industry Productivity," Econometrica, Econometric Society, vol. 71(6), pages 1695-1725, November.
    14. Sørensen, Bent E & Kalemli-Özcan, Sebnem & Volosovych, Vadym & Villegas-Sanchez, Carolina & Yesiltas, Sevcan, 2015. "How to construct nationally representative firm level data from the ORBIS global database," CEPR Discussion Papers 10829, C.E.P.R. Discussion Papers.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Peña, Jennifer & Prades, Elvira, 2024. "International sourcing during COVID-19: How did Chilean firms fare?," Latin American Journal of Central Banking (previously Monetaria), Elsevier, vol. 5(1).
    2. Alejandro Fernández-Cerezo & Beatriz Gonzalez & Mario Izquierdo Peinado & Enrique Moral-Benito, 2023. "Firm-level heterogeneity in the impact of the COVID-19 pandemic," Applied Economics, Taylor & Francis Journals, vol. 55(42), pages 4946-4974, September.
    3. Ivashina, Victoria & Laeven, Luc & Moral-Benito, Enrique, 2022. "Loan types and the bank lending channel," Journal of Monetary Economics, Elsevier, vol. 126(C), pages 171-187.
    4. Dmitri Kirpichev & Enrique Moral-Benito, 2018. "The costs of trade protectionism: evidence from Spanish firms and non-tariff measures," Working Papers 1814, Banco de España.
    5. Beatriz González & Galo Nuño & Dominik Thaler & Silvia Albrizio, 2021. "Firm heterogeneity, capital misallocation and optimal monetary policy," Working Papers 2145, Banco de España.
    6. Alberto Martín & Enrique Moral-Benito & Tom Schmitz, 2021. "The Financial Transmission of Housing Booms: Evidence from Spain," American Economic Review, American Economic Association, vol. 111(3), pages 1013-1053, March.
    7. Julian di Giovanni & Manuel García-Santana & Priit Jeenas & Enrique Moral-Benitoz & Josep Pijoan-Mas, 2022. "Government Procurement and Access to Credit: Firm Dynamics and Aggregate Implications," Working Papers 2233, Banco de España.
    8. Chenxu Fu & Enrique Moral-Benito, 2018. "The evolution of spanish total factor productivity since the global financial crisis," Occasional Papers 1808, Banco de España.
    9. Alberto Martín & Enrique Moral-Benito & Tom Schmitz, 2018. "The Financial Transmission of Housing Bubbles: Evidence from Spain," Working Papers 625, IGIER (Innocenzo Gasparini Institute for Economic Research), Bocconi University.
    10. Alfaro, Laura & García-Santana, Manuel & Moral-Benito, Enrique, 2021. "On the direct and indirect real effects of credit supply shocks," Journal of Financial Economics, Elsevier, vol. 139(3), pages 895-921.
    11. Julian di Giovanni & Manuel García-Santana & Priit Jeenas & Enrique Moral-Benito & Josep Pijoan-Mas, 2022. "Buy Big or Buy Small? Procurement Policies, Firms' Financing, and the Macroeconomy," Staff Reports 1006, Federal Reserve Bank of New York.
    12. García-Perea, Pilar & Lacuesta, Aitor & Roldan-Blanco, Pau, 2021. "Markups and cost structure: Small Spanish firms during the Great Recession," Journal of Economic Behavior & Organization, Elsevier, vol. 192(C), pages 137-158.
    13. Albert, Christoph & Caggese, Andrea & González, Beatriz & Martin-Sanchez, Victor, 2023. "Income inequality and entrepreneurship: Lessons from the 2020 COVID-19 recession," Journal of Banking & Finance, Elsevier, vol. 149(C).
    14. Sergi Basco & David López-Rodríguez & Enrique Moral-Benito, 2021. "House prices and misallocation: The impact of the collateral channel on productivity," Working Papers 2135, Banco de España.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Simone Lenzu & Francesco Manaresi, 2019. "Sources and implications of resource misallocation: new evidence from firm-level marginal products and user costs," Questioni di Economia e Finanza (Occasional Papers) 485, Bank of Italy, Economic Research and International Relations Area.
    2. Dan Andrews & Chiara Criscuolo & Peter N. Gal, 2019. "The best versus the rest: divergence across firms during the global productivity slowdown," CEP Discussion Papers dp1645, Centre for Economic Performance, LSE.
    3. Loredana Fattorini & Mahdi Ghodsi & Armando Rungi, 2020. "Cohesion Policy Meets Heterogeneous Firms," Journal of Common Market Studies, Wiley Blackwell, vol. 58(4), pages 803-817, July.
    4. Lenzu, Simone & Manaresi, Francesco, 2018. "Do Marginal Products Differ from User Costs? Micro-Level Evidence from Italian Firms," Working Papers 276, The University of Chicago Booth School of Business, George J. Stigler Center for the Study of the Economy and the State.
    5. Florian Gerth, 2017. "Allocative efficiency of UK firms during the Great Recession," Studies in Economics 1714, School of Economics, University of Kent.
    6. Daniel A. Dias & Carlos Robalo Marques & Christine Richmond, 2020. "A Tale of Two Sectors: Why is Misallocation Higher in Services than in Manufacturing?," Review of Income and Wealth, International Association for Research in Income and Wealth, vol. 66(2), pages 361-393, June.
    7. Viral V. Acharya & Matteo Crosignani & Tim Eisert & Christian Eufinger, 2024. "Zombie Credit and (Dis‐)Inflation: Evidence from Europe," Journal of Finance, American Finance Association, vol. 79(3), pages 1883-1929, June.
    8. Sara Calligaris & Massimo Del Gatto & Fadi Hassan & Gianmarco I P Ottaviano & Fabiano Schivardi & Tommaso MonacelliManaging Editor, 2018. "The productivity puzzle and misallocation: an Italian perspective," Economic Policy, CEPR, CESifo, Sciences Po;CES;MSH, vol. 33(96), pages 635-684.
    9. Gita Gopinath & Şebnem Kalemli-Özcan & Loukas Karabarbounis & Carolina Villegas-Sanchez, 2017. "Capital Allocation and Productivity in South Europe," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 132(4), pages 1915-1967.
    10. Cette, Gilbert & Fernald, John & Mojon, Benoît, 2016. "The pre-Great Recession slowdown in productivity," European Economic Review, Elsevier, vol. 88(C), pages 3-20.
    11. Diego Restuccia & Richard Rogerson, 2017. "The Causes and Costs of Misallocation," Journal of Economic Perspectives, American Economic Association, vol. 31(3), pages 151-174, Summer.
    12. Fabiano Schivardi & Tom Schmitz, 2020. "The IT Revolution and Southern Europe’s Two Lost Decades [Lack of Selection and Limits to Delegation: Firm Dynamics in Developing Countries]," Journal of the European Economic Association, European Economic Association, vol. 18(5), pages 2441-2486.
    13. Dolores Añón Higón & Juan A. Máñez & María E. Rochina-Barrachina & Amparo Sanchis & Juan A. Sanchis, 2022. "Firms’ distance to the European productivity frontier," Eurasian Business Review, Springer;Eurasia Business and Economics Society, vol. 12(2), pages 197-228, June.
    14. Pellegrino, Bruno & Zheng, Geoffery, 2024. "Quantifying the impact of red tape on investment: A survey data approach," Journal of Financial Economics, Elsevier, vol. 152(C).
    15. Anderson, Gareth & Riley, Rebecca & Young, Garry, 2019. "Distressed banks, distorted decisions?," LSE Research Online Documents on Economics 100947, London School of Economics and Political Science, LSE Library.
    16. Ian Goldin & Pantelis Koutroumpis & François Lafond & Julian Winkler, 2024. "Why Is Productivity Slowing Down?," Journal of Economic Literature, American Economic Association, vol. 62(1), pages 196-268, March.
    17. Enrique Moral-Benito, 2018. "Growing by learning: firm-level evidence on the size-productivity nexus," SERIEs: Journal of the Spanish Economic Association, Springer;Spanish Economic Association, vol. 9(1), pages 65-90, March.
    18. Dolores An~o´n Higo´n & Juan A. Man~ez & Mari´a E. Rochina-Barrachina & Amparo Sanchis & Juan A. Sanchis, 2018. "Follow the leader: Evidence of the Productivity catch-up of European firms," Working Papers 1806, Department of Applied Economics II, Universidad de Valencia.
    19. Alam, M. Jahangir, 2020. "Capital misallocation: Cyclicality and sources," Journal of Economic Dynamics and Control, Elsevier, vol. 112(C).
    20. Liang, Yan, 2022. "Impact of financial development on outsourcing and aggregate productivity," Journal of Development Economics, Elsevier, vol. 154(C).

    More about this item

    Keywords

    firm data; firm size distributions; macroeconomic aggregates;
    All these keywords.

    JEL classification:

    • C81 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Methodology for Collecting, Estimating, and Organizing Microeconomic Data; Data Access
    • E01 - Macroeconomics and Monetary Economics - - General - - - Measurement and Data on National Income and Product Accounts and Wealth; Environmental Accounts
    • L11 - Industrial Organization - - Market Structure, Firm Strategy, and Market Performance - - - Production, Pricing, and Market Structure; Size Distribution of Firms

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:bde:opaper:1802. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Ángel Rodríguez. Electronic Dissemination of Information Unit. Research Department. Banco de España (email available below). General contact details of provider: https://edirc.repec.org/data/bdegves.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.