76
edits
Changes
Jump to navigation
Jump to search
Database is '''cities'''
SQL script is: COMPUSTAT.sql
→COMPUSTAT Data
==COMPUSTAT Data==
The data set includes information on publicly traded firms in the US. It was obtained from the Wharton Research Data Services (https://wrds-web.wharton.upenn.edu/wrds/index.cfm?).
Raw Data is in:
E:\McNair\Projects\Hubs\Summer 2017
Z:\Hubs\2017
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)
**Revenue of firms
Database is '''cities'''
SQL script is: COMPUSTAT.sql
Output file is COMPUSTATSummary.txt. It contains:
