Data available on my website


Bronwyn H. Hall, University of California at Berkeley

This document describes the data available in the directory /pubdata on my website. Potential users of several of these files should be aware that the data are drawn primarily from the Compustat files of Standard and Poor, and as such are proprietary to S&P. Before using these files, you should ascertain that your home institution is a Compustat subscriber. For patent data other than that used in my papers, go here.

Some of the files are stored as zip format. The data files are either in ASCII text or stata format (version 13 and prior) and are readable by stata or tsp. If you wish another format, I suggest you acquire stat/transfer, an excellent program that converts data files to and from a large variety of formats.

List of files and associated papers:

Data

Paper(s)

data link

description

Eco-patents and controls, with legal status and patstat appln_id

Jorge Contreras, Bronwyn H. Hall, and Christian Helmers (2018), “Assessing the Effectiveness of the Eco-Patent Commons: A Post-mortem Analysis” (2018). Waterloo, Canada: CIGI Working Paper No. 16.
Bronwyn H. Hall and Christian Helmers (2013), “Innovation in clean/green technology: Can patent commons help?” Journal of Environmental Economics and Management 66(1): 33-51.

data

description

Eco-patents and controls, with all the patents that cite them (through April 2017)

Jorge Contreras, Bronwyn H. Hall, and Christian Helmers (2018), “Assessing the Effectiveness of the Eco-Patent Commons: A Post-mortem Analysis” (2018). Waterloo, Canada: CIGI Working Paper No. 16.
Bronwyn H. Hall and Christian Helmers (2013), “Innovation in clean/green technology: Can patent commons help?” Journal of Environmental Economics and Management 66(1): 33-51.

data

description

All Chilean pharmaceutical patents applied for before 2011. Data from the WIPO-INAPI Chilean pharmaceutical patent project.

Abud Sittler, María José, Bronwyn H. Hall, and Christian Helmers (2015), An Empirical Analysis of Primary and Secondary Pharmaceutical Patents in Chile, PLOS One and NBER Working Paper No. 20995. Appendix

data

description

A match of Chilean pharma patents to the ISP register. Data from the WIPO-INAPI Chilean pharmaceutical patent project.

Abud Sittler, María José, Bronwyn H. Hall, and Christian Helmers (2015), An Empirical Analysis of Primary and Secondary Pharmaceutical Patents in Chile, PLOS One and NBER Working Paper No. 20995. Appendix

data

description

Data on all the software patents used by Hall and Macgarvie (2010). 238,925 US patents granted 1975-2002.

Hall and MacGarvie (2010), "The private value of software patents," Research Policy 39: 994-1009.

allswpats2

description

Market value, R&D, patent and citation data for 1,982 Compustat firms, 1979-1988, unbalanced.

Hall, Jaffe, and Trajtenberg (2005), Rand Journal of Economics 36: 16-38.

hjtgood

description

Patents-R&D data. These files contain data on 346 and 642 manufacturing firms with patents
and R&D spending from 1970 to 1979 and 1972 to 1979 respectively. The longer file is a (firm) subset of the shorter.

Hall, Griliches, and Hausman, "Patents and R&D: Is There a Lag?", International Economic Review 27(1986): 265-283.

patrhgh

description

The patents data at the individual firm level, from the 1985 R&D master file. Total patent applications and grants for the firms, from  about 1965 to 1979 (1981 for grants). By CUSIP and YEAR, this can be matched to the other files.

 

patpan85

description

A dataset containing header information for all the firms in the 1991 manufacturing sector master file (the source of data in pstar, rvaluni3, and hmuspan2 below). This list contains the names and stock symbols of firms, and can be used to ascertain the presence of a particular firm.

 

pan91hdr

description

A list of firms that exited from the 1991 manufacturing sector master file, together with the reason for their exit, and the name (and CUSIP, where available) of the successor firm.

 

pubexit

description

Data  from Compustat on US firms for productivity estimation. Approximately 22,000 obs, 1960-1990. Cleaned; R&D-doing firms only.

Bronwyn H. Hall, "Industrial Research During the 1980s: Did the Rate of Return Fall?," BPEA Micro (1993,2): 289-344

hmuspan2

description

Cleaned and deflated data on US R&D-doing firms 1960-90. 10,957 obs, 1,180 firms with data for at least 4 years between 1977 and 1989.

Mairesse and Hall, "Estimating the Productivity of Research and Development: An Exploration of GMM Methods Using Data on French and United States Manufacturing Firms.” In Bart van Ark and Karin Wagner (eds.), International Productivity Differences, Measur

hmuscln8

description

Tobin's Q data on R&D and market value.  Approximately 44,000 obs, 1959-1991. All firms; not very clean.

Hall, "The Stock Market Value of Research and Development Investment During the 1980s," American Economic Review 83 (1993): 259-264.

rvaluni3

description

Compustat data on US corporations with CRSP data added

B. H. Hall and R. E. Hall, "The Value and Performance of US Corporations," Brookings Papers on Economic Activity 1993(1): 1-50.

pstar

description

These data files are made available to other researchers on an AS IS basis. Because of the volume of requests and time constraints, I am unable to answer inquiries about them; users and potential users are referred to the publications cited within the documentation files for further information. Copies of these publications are available on my website.


Last updated 26 July 2018 by Bronwyn H. Hall