Changes

Hubs (view source)

479 bytes added , 16:36, 23 June 2017

== Data by MSA ==

==COMPUSTAT Data==

Data is in:

E:\McNair\Projects\Hubs\Summer 2017

Z:\Hubs\2017

Database is '''cities'''

SQL script is: COMPUSTAT.sql

The source file is RandDExpenditures.txt. It contains:

*Date from 1980-2017 (July). All COMPUSTAT.

*427799 records

*Fields include:

**R&D Expenditure

**Address (inc. city, zip, state)

Output file is COMPUSTATSummary.txt. It contains:

*Variables: City, year, No.public firms, sum R&D, sum Sales, sum total assets

*1979-2016

*4440 cities

135

edits