Format of Datafiles
The BCI datafiles follow a conventional spreadsheet format. There are separate "columns" for each series and "rows" for each month.
The descriptions for each series (a column) is on the List of Monthly Data Series in the BCI Database page.
Example:
G0M910 Composite index of 11 leading indicators (1992=100)
PCM910 Leading index, change from previous month (pct.)
P6M910 Leading index, change over 6-month span (AR, pct.)
A0M001 Average weekly hours, mfg. (hours)
The CSV (Comma Separated Value text file) files can be read directly into Lotus-123, Excel, and Quattro Pro.
Files are also available in HTML.
A view of how the data will appear:
BCI-01a starts with a "Date G0M910 ..." row and ends with "Dec-97" row
12345678 |
|2345678 |
|2345678 |
|2345678 |
|2345678 |
|2345678 |
...additional columns not shown |
||
Date |
G0M910 |
PCM910 |
P6M910 |
A0M001 |
A0M005 |
A0M008 |
A0M032 |
A0M027 |
Jan-45 |
45.3 |
16 |
||||||
Feb-45 |
45.4 |
26 |
||||||
Mar-45 |
45.2 |
28.3 |
||||||
... rows with April 45 to October 96 data not shown ... |
||||||||
Nov-96 |
102.7 |
0.2 |
2.2 |
41.7 |
338.1 |
143738 |
51.6 |
41291 |
Dec-96 |
102.7 |
0 |
42 |
353.5 |
140552 |
51.6 |
41264 |
|
Jan-97 |
103 |
0.3 |
41.7 |
329.5 |
146446 |
48.5 |
43058 |
|
Feb-97 |
103.5 |
0.5 |
41.9 |
310.5 |
148764 |
51.3 |
44890 |
|
Mar-97 |
||||||||
Apr-97 |
||||||||
May-97 |
||||||||
Jun-97 |
||||||||
Jul-97 |
||||||||
Aug-97 |
||||||||
Sep-97 |
||||||||
Oct-97 |
||||||||
Nov-97 |
||||||||
Dec-97 |
||||||||