Section 3
U.S. MERCHANDISE TRADE: Special Reports and Services

   In addition to the sources of data described herein, the Census
Bureau provides a special service whereby data users may obtain
information in greater detail or different arrangement than that
available in the statistics which are regularly released. The cost of
the special work required to compile or duplicate the information from
the basic data is charged to the subscriber. There is a wide range in
the costs for Census Bureau data made available to users, depending on
the methods used and other factors.

  Foreign Trade Division (FTD) has implemented a number of improvements
which provide quicker and better access to summary and detail trade
data. These advancements include monthly data issued on compact discs
(CD-ROM's) and various databases available on the local area network
within FTD. These data sources have provided the means to create
customized responses and special reports for data users and customers
for nominal fees. A brief description of the services available
follows:

NETWORK ACCESS TO COMPACT DISCS (CD-ROM'S)--

HTSUSA and Schedule B Data

Special computer programs have been written to access the monthly CD-ROM's and are available on the FTD network for division staff to produce hard copy reports, computer files and electronic fax files. These reports emulate the discontinued microfiche products (IM145, IM146, and EM545). At any given time, the latest four statistical months' and year-to-date data are accessible. Since the CD-ROM's contain cumulative data, the December discs for the previous two years are also available. The following programs which provide "standardized" reports are provided:
IM145
U.S. General Imports (see figure 1). Presents harmonized TSUSA commodity by country of origin by customs district of entry. Quantity, customs, and c.i.f. values are provided. Vessel and air data are available. Current month and cumulative January to date.

IM146
U.S. Imports for Consumption. Presents harmonized TSUSA commodity by country of origin. Customs value and calculated duty are provided. Vessel and air data are available. Current month and cumulative January to date.

EM545
U.S. Exports of Domestic and Foreign Merchandise. Presents harmonized Schedule B commodity by country of destination by customs district of exportation. Quantity, and f.a.s. value are provided. Vessel and air data are available. Current month and cumulative January to date.
Figure 1. Report IM145 
 Page No. 1
 07/08/91


REPORT IM145 U.S. GENERAL IMPORTS BY ALL METHODS OF
 TRANSPORTATION, CUMULATIVE TO DATE DATA



COUNTRY C DIST     QUANTITY 1         QUANTITY 2        CUSTOM VAL
             S
             C
 
**COMMODITY: 2709001000 CRUDE PETROLEUM TESTING UNDER 25
 DEGREES
 * COUNTRY: 1220

CANADA0 NY CITY      498729 BBL                0         9,807,459
CANADA - CHICAGO     230853 BBL                0         2,938,131
CANADA - HOUSTON    1271585 BBL                0        16,417,773
CANADA X MOBILE      225114 BBL                0         2,723,878
CANADA X NEW ORL     372999 BBL                0         6,281,303
CANADA X PORT AR     221126 BBL                0         2,171,977
CANADA X SEATTLE    1522171 BBL                0        25,686,803
CANADA X GTFALLS    3078597 BBL                0        54,781,980
CANADA X DULUTH    44118353 BBL                0       801,262,966
CANADA X CHICAGO   35145888 BBL                0       653,460,321
CANADA X CLEVLND      44540 BBL                0           863,162
CANADA X HOUSTON    1192251 BBL                0        17,349,658
* Subsubtotal *

                   87922206                    -        1593745411
 
  Almost any other "customized" reports can be created using the
data users requirements and specifications, and are also available
on an individual fee basis from Trade Data Services Branch. Requests
for reports from earlier discs (back to September 1989) will be handled
by Branch staff upon request.



Standard International Trade Classification (SITC) Databases


  SITC databases and access computer programs have been developed and
are available on the FTD network for division staff to produce hard
copy reports, and computer files (See figure 2). The first SITC
database provides all months of the current statistical year and
year-to-date trade data. The second is the SITCYR database which
provides annual original and revised data for several years.

  The database access programs are written for the user to access
immediately on a display screen or to generate printed listings or
computer files. The programs allow the user to create "custom"
reports by selecting variable column headings. Reports can be generated
using the following fields for any selected months or year-to-date:


U.S. Exports                           U.S. General Imports
    Domestic f.a.s. value                 Customs value
    Foreign f.a.s. value                  C.i.f. value
    Vessel value                          Vessel value
    Air value                             Air value
    Vessel shipping weight                Vessel shipping weight
    Air shipping weight                   Air shipping weight

  The user may create a report for a specific country or countries, or
for all countries for any of the one to five digits of the SITC. The
reverse is also available. The user may create reports selecting any
level of the SITC and then for any or all countries. This variable
field and stub selection option in the program allows for many
"custom" reports.



Figure 2. SITC Report


07/08/91
PAGE
1

                                            EXPORT     General
                                             VALUE     Imports
                                           FOR 90R     Customs
                                                         Value
                                                       For 90R
5880 JAPAN

0   FOOD AND LIVE ANIMALS                7,353,188     268,398

1   BEVERAGES AND TOBACCO                1,850,678      34,362

2   CRUDE MATERIALS, INEDIBLE,           6,923,611     157,486
     EXCEPT FUELS                         
3   MINERAL FUELS, LUBRICANTS            1,482,960      89,392
     AND RELATED MATERIALS              
4   ANIMAL AND VEGETABLE OILS,              68,302      19,309  
     FATS AND WAXES  
5   CHEMICALS AND RELATED PROD-          4,627,350   2,388,739 
     UCTS, N.E.S.  
6   MANUFACTURED GOODSCLASSI-            4,004,058   6,842,066
     FIED CHIEFLY BY MATERIAL  
7   MACHINERY AND TRANSPORT             15,298,094  69,113,091
     EQUIPMENT  
8   MISCELLANEOUS MANUFAC-               6,183,944   9,414,716
     TURED ARTICLES  
9   COMMODITIES & TRANSACT NOT
     CLASS ELSEWHERE IN SITC                787,400   1,356,562

    TOTAL                                48,579,585  89,684,122
IN THOUSANDS OF DOLLARS

  Reports are available to data users on a fee basis from the Trade
Data Services Branch. Data is available as hard copy printed reports or
as computer files. Fax service is also an option for the data user.


End-Use Commodity Category Classification Databases


  End-use commodity category classification databases and access
computer programs have been developed and are available on the FTD
network for division staff to produce hard copy reports, and computer
files. The first End-use database provides all months of the current
and previous statistical years and year-to-date trade data (See figure
3). The second adds an option to generate a report for a specific
country.

  The database presents data for each month for the current statistical
year and all months of the previous year. Year-to-date data is
available for both years. The database access programs are written for
the user to access immediately on a display screen or to generate
printed listings or computer files. The programs allow the user to
create "custom" reports by selecting variable column headings.
Reports can be generated using the following fields for any selected
months or year-to-date:


General imports customs or c.i.f. value
Exports f.a.s. value
Current dollars
Constant dollars
Actual month
Statistical
month
Revised month
Seasonally adjusted data
Not seasonally
adjusted data
Seasonal adjustment factors
Constant dollar
deflators
End-use codes and descriptions




Figure 3. END-USE REPORT

 PAGE 1
07/08/91


CODE      DESCRIPTION                      DOLLAR     SEASONAL
                                            VALUE       DOLLAR
                                      REVISED MON        VALUE
                                         91-  APR      FOR MON
                                                      91-  APR


00000     Wheat                         1,017,845    1,017,845
00010     Rice and other food grains      244,523      244,523
00100     Soybeans                      1,452,123    1,091,191
00110     Other oilseeds and food oils    244,367      244,367
0200      Corn                          1,953,742    1,953,742

  Reports are available to data users on a fee basis from the Trade
Data Services Branch. Data is available as hard copy printed reports or
as computer files. Fax service is also an option for the data user.


U.S. Exports by State Database


  A U.S. exports by state database and access computer program have
been developed and are available to the Trade Data Services Branch
staff to produce hard copy reports, and computer files. The program
provides options to produce various "standardized" reports for
annual data for years 1988 through 1990. The user may produce reports
for exports from any or all states to any or all countries by two-digit
SIC (See Figure 4). Various world area groupings are also available.



Figure 4. Exports by State Report


Page No. 1
 06/25/91




 U.S. Total Export From Vermont By Two--Digit SIC Code



Sic      Description                                 Total Value
Code                                                   (Dollars)
  

* Year: 1988

09  FISH, FRESH OR CHILLED, AND OTHER MARINE               7,921
    PRODUCTS  

08  FORESTRY PRODUCTS, NSPF                               15,372

01  AGRICULTURAL PRODUCTS                                 49,610

29  PETROLEUM REFINING AND RELATED PRODUCTS               75,798

25  FURNITURE AND FIXTURES                               176,180

91  SCRAP AND WASTE                                      733,722



  In addition to the standardized reports, the Trade Data Services
Branch staff can prepare any customized report for data users by using
any combination of the State, country, or two-digit SIC variables.

  Reports are available to data users on a fee basis from the Trade Data
Services Branch. Data is available as hard copy printed reports or as
computer files. Fax service is also an option for the data user.


U.S. Imports Databank Database (HTSUSA)


  A computer program has been written to access the current and
previous months imports databank database and is available on the FTD
network for division staff to produce hard copy reports, computer files
and electronic fax files. These reports are similar to the discontinued
microfiche products (IM145, and IM146) (See Figure 5). The database
also includes cumulative data. The following programs which provide
"standardized" reports are provided:



IM145 
 U.S. General Imports Presents
harmonized TSUSA commodity by country of origin by customs district of
entry. Quantity, customs, and c.i.f. values are provided. Current and
prior months and cumulative January to date.



IM146 
 U.S. Imports for Consumption Presents
harmonized TSUSA commodity by country of origin. Customs value and
calculated duty are provided. Current and prior months and cumulative
January to date.






Figure 5. U.S. Imports Report


Page No. 1
 07/09/91


U.S. CONSUMPTION IMPORTS: ALL METHODS OF TRANSPORTATION
CURRENT MONTH AND CUMULATIVE YEAR TO DATE
INDEXED BY HS, COUNTRY, DISTRICT, AND COUNTRYSUB-CODE


SM DISTRICT   C RP     CON. IMP. Q1    CON. IMP. Q2     CON. IMP.
   OF         S          QUANITIY 1      QUANTITY 2  CUSTOMS VAL.
   ENTRY      C             CURRENT         CURRENT       CURRENT

** 4814200000 WALLPPR/SIMLR WALLCVRNG OF PPR COATED ETC
PLASTICS
* 1,220 CANADA

04 01 MAINE     10             - KG               0            -
                     
04 02 ST ALBN   10        205771 KG               0    1,574,433

04 07 OGDENSB   10         52672 KG               0      348,803

04 09 BUFFALO   10        503128 KG               0    3,787,316

04 34 PEMBINA   10           569 KG               0       10,407

04 38 DETROIT   10        648384 KG               0    4,204,837
* Subsubtotal *


                       1,410,524                  0    9,925,796

  Reports are available to data users on a fee basis from the Trade
Data Services Branch. Data is available as hard copy printed reports or
as computer files. Fax service is also an option for the data user.


International Trade Administration COMPRO System


  In order to prepare historical and time series reports, the
Trade Data Services Branch staff has been given access to the
International Trade Administration's COMPRO mainframe computer system.
Reports can be prepared for numerous series back to 1978, including HS,
SITC, End-use, and SIC-based classification systems. Country and
district level data are available, but method of transportation data
are not.

  Depending upon the data user's requirements for special reports,
generating these reports can be very expensive. Reports are available
to data users on a fee basis from the Trade Data Services Branch. Data
is available as hard copy printed reports, or computer files. Fax
service is also an option for the data user (See Figure 6).


Figure 6. Historical Reports


Page 1
06/05/91




Table 1--Leading U.S. Total exports, F.a.s. value
SITC rev 3 commodity: Total Manufactured Goods
(Thousands of dollars)



Partner   Time period     1986       1987        1988       1989        1990
                                                                   
Egypt................  800,465    774,172   1,217,959  1,522,234   1,429,738

Jordan...............  186,937    199,531     196,465    197,403     121,429

Kuwait...............  557,551    404,461     589,177    746,044     341,619

Saudi Arabia.........2,732,349  2,396,033   3,038,455  2,912,855   3,266,793

United Arab Emirates.  402,789    444,974     574,127    983,668     734,829
                                            
Yemen................   69,202     73,656      35,922     34,186      52,486

Selected Partner
 countries...........4,749,292  4,292,826   5,652,106  6,396,389   5,946,893


HOW TO OBTAIN SPECIAL REPORTS


  For information concerning fees, and availability please
contact:



  Trade Data Services Branch
 Foreign Trade Division
 Bureau of the
Census
 Washington, D.C. 20233


301-457-2311
 FAX 301-457-2647