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. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. Sebnem Kalemli-Ozcan & Bent Sørensen & Carolina Villegas-Sanchez & Vadym Volosovych & Sevcan Yesiltas, 2015. "How to Construct Nationally Representative Firm Level Data from the Orbis Global Database: New Facts on SMEs and Aggregate Implications for Industry Concentration," Tinbergen Institute Discussion Papers 15-110/IV, Tinbergen Institute, revised 25 Jan 2022.
    12. François Gourio & Nicolas Roys, 2014. "Size‐dependent regulations, firm size distribution, and reallocation," Quantitative Economics, Econometric Society, vol. 5, pages 377-416, July.
    13. 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.
    14. Ş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.
    15. 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.
    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. 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.
    2. 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.
    3. 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.
    4. Beatriz González & Galo Nuño & Dominik Thaler & Silvia Albrizio, 2021. "Firm Heterogeneity, Capital Misallocation and Optimal Monetary Policy," CESifo Working Paper Series 9465, CESifo.
    5. 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.
    6. Pijoan-Mas, Josep & di Giovanni, Julian & García-Santana, Manuel & Moral-Benito, Enrique, 2022. "Government Procurement and Access to Credit: Firm Dynamics and Aggregate Implications," CEPR Discussion Papers 17023, C.E.P.R. Discussion Papers.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. 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.
    12. 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).
    13. 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. Criscuolo, Chiara & Andrews, Dan & Gal, Peter N., 2019. "The best versus the rest: divergence across firms during the global productivity slowdown," LSE Research Online Documents on Economics 103405, London School of Economics and Political Science, LSE Library.
    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. Florian Gerth, 2017. "Allocative efficiency of UK firms during the Great Recession," Studies in Economics 1714, School of Economics, University of Kent.
    5. 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.
    6. Gareth Anderson & Rebecca Riley & Garry Young, 2019. "Distressed Banks, Distorted Decisions?," National Institute of Economic and Social Research (NIESR) Discussion Papers 503, National Institute of Economic and Social Research.
    7. Viral V. Acharya & Matteo Crosignani & Tim Eisert & Christian Eufinger, 2020. "Zombie Credit and (Dis-)Inflation: Evidence from Europe," NBER Working Papers 27158, National Bureau of Economic Research, Inc.
    8. 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.
    9. 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.
    10. 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.
    11. 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.
    12. David Autor & David Dorn & Lawrence F Katz & Christina Patterson & John Van Reenen, 2020. "The Fall of the Labor Share and the Rise of Superstar Firms [“Automation and New Tasks: How Technology Displaces and Reinstates Labor”]," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 135(2), pages 645-709.
    13. Neira, Julian, 2019. "Bankruptcy and cross-country differences in productivity," Journal of Economic Behavior & Organization, Elsevier, vol. 157(C), pages 359-381.
    14. 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.
    15. 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.
    16. Lafond, François & Farmer, J. Doyne & Koutroumpis, Pantelis & Winkler, Julian & Heinrich, Torsten & Yang, Jangho, 2019. "Measuring productivity dispersion: a parametric approach using the Lévy alpha-stable distribution," INET Oxford Working Papers 2019-14, Institute for New Economic Thinking at the Oxford Martin School, University of Oxford.
    17. 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.
    18. Goldin, Ian & Koutroumpis, Pantelis & Lafond, François & Winkler, Julian, 2020. "Why is productivity slowing down?," MPRA Paper 99172, University Library of Munich, Germany.
    19. 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.
    20. 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.

    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.