Skip to Main Content

Header

PROCESSED PRODUCTS QUICK START GUIDE

How to Run Processed Products Query

How to Download, Format, and Calculate Totals

Additional Information

How to Run Processed Products Query

Steps

1. To run a report select parameters. Select the year that you would like to query. To select multiple years, hold down the ctrl key while clicking on the desired years or click-and-drag for subsequent years.

image

2. Click the single arrow pointing right to add it to your query. If you accidentally select a year that you do not want to query, simply select it and click the arrow pointing to the left.

You can also select all years by clicking the double arrow pointing right.

image

3. Select the product type that you would like to query. Hold down the ctrl key or click-and-drag to select product types simultaneously.

image

4. Click the single arrow pointing right to add it to your query. If you accidentally select a product type that you do not want to query, simply select it and click the arrow pointing to the left.

You can also select all product types by clicking the double arrow pointing to the right.

image

5. Select the species you would like to query. Hold down the ctrl key to select multiple species simultaneously.

To find the species type more quickly, you can use the "Search in Species" option to quickly narrow down the options. For example, by typing "tuna" and hitting "search," you can see the species field is narrowed to just tuna species.

image

6. Click the single arrow pointing to the right to add it to your query.

You can also select all product types by clicking the double arrow pointing right

image

7. Click the RUN REPORT button.

image

8. The results will appear on the right side of the page, by Year, Product name, Species, Pounds, and Dollars processed.

image

9. To start over or create a new query, use the left arrows to clear all previous selections.

image


How to Download, Format, and Calculate Totals

Report Download

To download a Processed Products report:

  1. Click on the Format & Download dropdown button.
  2. Click Download
  3. Choose a format to download the report.
image

Chart

To create a chart or graph of the Processed Products data:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Chart
  4. Select a Chart Type.
  5. Select a column in the Label dropdown.
  6. Select a column in the Value dropdown.
  7. Select a mathematical function in the Function dropdown.
  8. Enter a title name in the Axis Title for Label field.
  9. Enter a title name in the Axis Title for Value field.
  10. Click the Apply button.

image

Highlight

To highlight specific information in the Processed Products report:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Highlight
  4. Select a Highlight Type. You can choose to highlight an entire row or a single cell where the condition is applicable.
  5. In the Highlight box, select a background color. This will be the color of the highlight.
  6. Choose which information to highlight in the Highlight Condition section by selecting an option from the Column, Operator, and Expression dropdowns.
  7. Click the Apply button.
image

Calculate

To calculate specific information in the Processed Products report:

  1. Click on the Format & Download dropdown button.
  2. Click Format
  3. Click Group By
  4. Select a column in the Select Group By Column dropdown.
  5. Select a function in the Functions dropdown.
  6. Select a column in the Column dropdown.
  7. Click the Apply button.
image



Additional Information

Processed Products Data Restrictions

Some caveats with the Processed Products data:

Every year NOAA Fisheries conducts a survey of seafood processors across the United States gathering information on product quantity and value as well as plant employment. This data collection spans all regions within NOAA Fisheries and generates important information for use in publications and management decisions. The Annual Survey of Seafood Processors is one of the only data collection efforts that includes all companies, regardless of plant size, and includes quantity and value information at the species level (when possible).

The data collection is a collaborative effort between headquarters and the NOAA Fisheries Regions. Regional port agents distribute the survey to the processors in their area and stay in contact throughout the process to assist in filling out the form and answer any questions. Regional port agents play a vital role in keeping the survey current and reach out to local processors to improve return rates. The completed surveys are forwarded to NOAA Fisheries Headquarters, where Office of Science and Technology Fisheries Statistics Division staff enter all data, follow up with processors and port agents, tabulate annual figures and maintain historical databases.

User Feedback

Let us know what you think.

We are looking for user feedback on this query tool as we continue to fine-tune it and add new features.

Please navigate to the comments tab to submit a brief comment.