Compustat Industrial Quarterly

Back to Main Page.
Department of Finance and Graduate Statistical Assistant Program, FMRC

Documentation of the Compustat Industrial Quarterly


General Information:


Data Range: 1993 - 2004, quarterly
Number of Companies:  4,199
Update Schedule: Quarterly
Cut Date: 2004
 

Datasets of Earlier Years:

 
1) Data Range: 1982 - 1993, annually
2) Data Range: 1971 - 1982, annually
3) Data Range: 1962 - 1973, annually

Specific Variables Information:

       
Variable Name Type Stata Format Variable Label
 
 
dnum int %8.0g industry classification code
cnum str6 %6s cusip issuer code
cic str3 %3s cusip issue number and check digit
file byte %8.0g file identification code
dup byte %8.0g duplicate file code
ein str10 %10s employer identification number
stk byte %8.0g stock ownership code
smbl str7 %7s stock ticker symbol
zlist byte %8.0g exchange listing and sp major index code
xrel int %8.0g s&p industry index relative code
fic byte %8.0g foreign incorporation code
incorp byte %8.0g state incorporation code
state byte %8.0g company location code - state
county int %8.0g company location code - county
candxc byte %8.0g canadian index code - current
naics str6 %6s n. american industry classification sys.
date int %8.0g fiscal quarter
fyr byte %8.0g fiscal yearend month of data
spccqtr byte %8.0g s&p compustat calendar quarter
ucode byte %8.0g update code
source byte %8.0g source document code
spdrc byte %8.0g s&p lt domest. issuer credit rating- cur
spcprc int %8.0g s&p st domest. issuer credit rating- cur
spcsr byte %8.0g s&p common stock ranking
spmic byte %8.0g s&p major index code - historical
spiic int %8.0g s&p industry index code - historical
ffsfc byte %8.0g flow of funds statement format code
subdbt byte %8.0g s&p subordinated debt rating
candx byte %8.0g canadian index code
spccyr int %8.0g s&p compustat calendar year
cstatf str2 %2s period footnote - comparability status
cstataf str2 %2s period footnote - company status alert
spdrcf str2 %2s period ftnt- s&p lt dom ic rating(imp)
data1 float %9.0g selling,general,and admin expenses (mm$)
data2 float %9.0g sales (net) (mm$)
data3 float %9.0g minority interest (income account) (mm$)
data4 float %9.0g research and development expense (mm$)
data5 float %9.0g depreciation and amortization (mm$)
data6 float %9.0g income taxes - total (mm$)
data7 float %9.0g eps (diluted) - including ei ($&c)
data8 float %9.0g income before extraordinary items (mm$)
data9 float %9.0g eps (diluted) - excluding ei ($&c)
data10 float %9.0g income before ei- adjusted for cse (mm$)
data11 float %9.0g eps (basic) - including ei ($&c)
data12 float %9.0g price- close- 1st month of quarter ($&c)
data13 float %9.0g price- close- 2nd month of quarter ($&c)
data14 float %9.0g price- close- 3rd month of quarter ($&c)
data15 float %9.0g com shares used to calc eps (basic)(mm)
data16 float %9.0g dividends per share by ex-date ($&c)
data17 float %9.0g adjustment factor (cumulative) by exdate
data18 float %9.0g common shares traded (mm)
data19 float %9.0g eps (basic) - excluding ei ($&c)
data20 float %9.0g dividends- common- indicated annual($&c)
data21 float %9.0g operating income before depreciatio(mm$)
data22 float %9.0g interest expense (mm$)
data23 float %9.0g pretax income (mm$)
data24 float %9.0g dividends - preferred (mm$)
data25 float %9.0g income before ei- avail for common(mm$)
data26 float %9.0g ei and discontinued operations (mm$)
data27 float %9.0g eps(basic)- excl ei- 12mon moving($&c)
data28 float %9.0g com shares used to calc eps- 12mm (mm)
data29 float %9.0g interest income - total (fin serv) (mm$)
data30 float %9.0g cost of goods sold (mm$)
data31 float %9.0g nonoperating income (expense) (mm$)
data32 float %9.0g special items (mm$)
data33 float %9.0g discontinued operations (mm$)
data34 float %9.0g foreign currency adj. (income acct)(mm$)
data35 float %9.0g deferred taxes (income account) (mm$)
data36 float %9.0g cash and short-term investments (mm$)
data37 float %9.0g receivables - total (mm$)
data38 float %9.0g inventories - total (mm$)
data39 float %9.0g current assets - other (mm$)
data40 float %9.0g current assest - total (mm$)
data41 float %9.0g deprec,depletion,& amort(accum)(bs)(mm$)
data42 float %9.0g property,plant,& equip- total(net) (mm$)
data43 float %9.0g assets - other (mm$)
data44 float %9.0g assets - total (mm$)
data45 float %9.0g debt in current liabilities (mm$)
data46 float %9.0g accounts payable (mm$)
data47 float %9.0g income taxes payable (mm$)
data48 float %9.0g current liabilities - other (mm$)
data49 float %9.0g current liabilities - total (mm$)
data50 float %9.0g liabilites - other (mm$)
data51 float %9.0g long-term debt - total (mm$)
data52 float %9.0g deferred taxes & inv tax credit(bs)(mm$)
data53 float %9.0g minority interest (balance sheet) (mm$)
data54 float %9.0g liabilities - total (mm$)
data55 float %9.0g preferred stock - carrying value (mm$)
data56 float %9.0g common stock (mm$)
data57 float %9.0g capital surplus (mm$)
data58 float %9.0g retained earnings (mm$)
data59 float %9.0g common equity - total (mm$)
data60 float %9.0g stockholders' equity - total (mm$)
data61 float %9.0g common shares outstanding (mm)
data62 float %9.0g invested capital - total (mm$)
data63 float %9.0g price - high - 1st month of quarter($&c)
data64 float %9.0g price - high - 2nd month of quarter($&c)
data65 float %9.0g price - high - 3rd month of quarter($&c)
data66 float %9.0g price - low - 1st month of quarter ($&c)
data67 float %9.0g price - low - 2nd month of quarter ($&c)
data68 float %9.0g price - low - 3rd month of quarter ($&c)
data69 float %9.0g net income (loss) (mm$)
data70 float %9.0g interest expense - total (fin serv)(mm$)
data71 float %9.0g preferred stock - redeemable (mm$)
data72 float %9.0g dividends per share by payable date($&c)
data73 float %9.0g working capital change- other..(sc)(mm$)
data74 float %9.0g cash and cash equiv- inc(dec)(scf)(mm$)
data75 float %9.0g changes in current debt (scf) (mm$)
data76 float %9.0g income before ei (scf) (mm$)
data77 float %9.0g depreciation and amortization (scf)(mm$)
data78 float %9.0g ei and discontinued operations (scf)(mm)
data79 float %9.0g deferred taxes (scf) (mm$)
data80 float %9.0g equity in net loss (earnings)(scf)(mm$)
data81 float %9.0g funds from operations- other (scf)(mm$)
data82 float %9.0g funds from operations- total (sc) (mm$)
data83 float %9.0g sale of property,plant,&equip (scf)(mm$)
data84 float %9.0g sale of common & pref stock (scf)(mm$)
data85 float %9.0g sale of investments (scf)(mm$)
data86 float %9.0g long-term debt - issuance (scf)(mm$)
data87 float %9.0g sources of funds - other (sc) (mm$)
data88 float %9.0g sources of funds - total (sc) (mm$)
data89 float %9.0g cash dividends (scf)(mm$)
data90 float %9.0g capital expenditures (scf) (mm$)
data91 float %9.0g increase in investments (scf) (mm$)
data92 float %9.0g long-term debt - reduction (scf) (mm$)
data93 float %9.0g purchase of com & pref stock (scf)(mm$)
data94 float %9.0g acquisitions (scf) (mm$)
data95 float %9.0g uses to funds - other (sc) (mm)
data96 float %9.0g uses of funds - total (sc) (mm$)
data97 float %9.0g net interest income (tax equiv) (mm$)
data98 float %9.0g treasury stock - total dollar amt (mm$)
data99 float %9.0g nonperforming assets - total (mm$)
data100 float %9.0g adjustment factor (cum) by payable date
data101 float %9.0g working capital change- total (sc)(mm$)
data102 float %9.0g sale of pp&e & sale of inv...(scf)(mm$)
data103 float %9.0g accounts receivable- dec(inc) (scf)(mm$)
data104 float %9.0g inventory- decrease(increase)(scf)(mm$)
data105 float %9.0g acct payabl & accrued liab...(scf)(mm$)
data106 float %9.0g income tax- accrued- inc(dec) (scf)(mm$)
data107 float %9.0g assets and liab- other (nc) (scf)(mm$)
data108 float %9.0g operating activities- net cf (scf)(mm$)
data109 float %9.0g short-term investment- change (scf)(mm$)
data110 float %9.0g investing activities - other (scf)(mm$)
data111 float %9.0g investing activities- net cf (scf)(mm$)
data112 float %9.0g financing activities- other (scf)(mm$)
data113 float %9.0g financing activities- net cf (scf)(mm$)
data114 float %9.0g exchange rate effect- (scf)(mm$)
data115 float %9.0g interest paid - net (scf) (mm$)
data116 float %9.0g income taxes paid (scf) (mm$)
data117 float %9.0g accounting changes - cum. effect (mm$)
data118 float %9.0g property,plant,& equip- total(gros)(mm$)
data119 float %9.0g extraordinary items (mm$)
data120 float %9.0g common stock equiv- dollar savings (mm$)
data121 float %9.0g currency translation rate ($&c)
data122 float %9.0g accounts payable - expanded (mm$)
data124 float %9.0g common shares for diluted eps (mm)
data125 float %9.0g dilution adjustment
data126 float %9.0g diluted avail - excl
data171 float %9.0g provision for loan/asset losses (mm$)
data172 float %9.0g reserve for loan/asset loses (mm$)
data173 float %9.0g net interest margin
data174 float %9.0g risk-adjusted capital ratio - tier 1
data175 float %9.0g risk-adjusted capital ratio - total
data176 float %9.0g net charge-offs (mm$)
data177 float %9.0g earnings per share from operations ($&c)
data178 float %9.0g eps from operations- 12 mon moving ($&c)
data179 float %9.0g diluted eps exc e.i.- 12 mon moving($&c)
data180 float %9.0g diluted eps from ops- 12 mon moving($&c)
data181 float %9.0g diluted eps from ops ($&c)
qftnt1 str2 %2s sales (net) (data2)
qftnt2 str2 %2s depreciation and amortization (data5)
qftnt3 str2 %2s income taxes - total (data6)
qftnt4 str2 %2s income before ei/net income...(data8,69)
qftnt5 str2 %2s income before ei- adj for cse (data10)
qftnt6 str2 %2s eps (basic)- incl/excl ei (data11,19)
qftnt7 str2 %2s interest expense (data22)
qftnt8 str2 %2s cost of goods sold (data30)
qftnt9 str2 %2s assets - total (data44)
qftnt10 str2 %2s debt in current liabilities (data45)
qftnt11 str2 %2s accounts payable (data46)
qftnt12 str2 %2s income taxes payable (data47)
qftnt13 str2 %2s long-term debt - total (data51)
qftnt14 str2 %2s common stock (data56)
qftnt15 str2 %2s capital surplus (data57)
qftnt16 str2 %2s retained earnings (data58)
qftnt17 str2 %2s foreign currency adj (inc acct)(data34)
qftnt18 str2 %2s research and development expense (data4)
qftnt19 str2 %2s common shares outstanding (data61)
qftnt20 str2 %2s selling,general, & admin expense (data1)
qftnt21 str2 %2s capital expenditures (data90)
qftnt22 str2 %2s deprec,depletion, & amort...(data41)
qftnt23 str2 %2s account changes- cum. effect (data117)
qftnt24 str2 %2s eps from operations (data177)
coname str28 %28s company name
iname str28 %28s industry name
gvkey long %12.0g spc permanent number
rdqe long %dD_m_Y report date quarterly earnings
year int %8.0g fiscal year
qtr byte %8.0g fiscal quarter

Missing Codes

 
  FORTRAN   SAS   Meaning
 
  -0.001 = . = Not Available Figure - data is not available
  -0.002 = .S = Semi-Annual Figure - appears in 1st and 3rd quarters of the year to indicate that data in the 2nd and 4th quarters represents semi-annual figures rather than quarterly figures.
  -0.003 = .A = Annual Figure - appears in the 1st, 2nd, and 3rd quarters of the year to indicate that data in the 4th quarter represents an annual figure rather than quarterly figures.
  -0.004 = .C = Combined Figure - appears if data has been combined into another data item.
  -0.007 = .M = Not Meaningful
  -0.008 = .I = Insignificant Figure - appears if data has been reported by the company as insignificant.

Units


Most data items are represented in units of $ millions. Data is rounded to the nearest thousand. Earnings per share items are presented in actual dollars and cents.
  M Thousands
  MM Millions
  MM$ Millions of Dollars
  $&c Dollars and cents

Up to this page.


Back to Main Page.
Updated:  December 2004, GSA.