Skip to main content

Instructions for Using the Clearinghouse Query Builder

In the Clearinghouse Query Builder, you may customize your query by selecting options for one or more of the variables listed below. If you do not select Received Year, the default is the most recent ten calendar years of data available. If you do not select any of the other options, the default is to include all cases.

  • Received Year 
  • Product
  • Age
  • Gender
  • State
  • Hazard
  • Report Source
  • Primary Injury
  • Severity
  • ICD External Cause (accessible only when Report Source is equal to Death Certificates)

Product Codes and Date Range

The Clearinghouse Query Builder includes a limited product code search. Therefore, you should always consult the NEISS Coding Manual and the Product Code Comparability Table when choosing product codes for your query. 

The NEISS Coding Manual (PDF) is the instruction manual used by CPSC Clerical Coding team to code CPSC cases. It contains a description of the reporting criteria, definitions, and an alphabetical listing of products with current product codes. The alphabetical listing may include various synonyms used to describe the product you are interested in, so try searching for different terms.

The Product Code Comparability Table (PDF) is a numerical listing of all current and historical product codes used by CPSC. The CPSC occasionally adds, deletes, or changes product codes to reflect the introduction of new products. This can result in one product having different product codes over different calendar years. If your query includes more than one calendar year, the Product Code Comparability Table will help you determine which product codes to include in your query. 

You should consider the impact of product code changes when examining cases over time. For example, baby slings are currently coded using product code 1560 (Baby slings and wraps). If one were to query for CPSC cases with product code 1560 between the years 2010 and 2019, there would appear to be no CPSC cases associated with baby slings prior to 2019. However, a check of the Product Code Comparability Table reveals that prior to 2019, the product code for baby slings was 1527 (Baby carriers or slings). In 2019, product code 1527 was discontinued and replaced by three new product codes (1560, 1561, and 1562). Therefore, a query for CPSC cases associated with baby slings between received years 2011 and 2019 should include both product codes 1560 and 1527.

Output Options

View First 30 Records: Select this option for an online preview of the first 30 cases that meet the query criteria. 

View Chart: Select this option to access a set chart tools to output a chart based on the selected query criteria.

View Heat Map: Select this option to access a set chart tools to output a heat map based on the selected query criteria.

Download Data Set: Select one or more of these options to download the Clearinghouse cases that meet the query criteria in MS-Excel or tab-delimited text. For fastest download results, only select the option for Tab Delimited Text File. The downloaded data will include all of the variables available for public use, such as victim gender and age, the location of the incident, product description, and a narrative describing the incident. To learn more about the variables available, please consult the NEISS Coding Manual. 

Report Title: Enter a custom title for your report.

Variable Dictionary (PDF)

Clearinghouse Query Examples

Query Example 1:

Date: 2012 – 2016

Products: Stepladders (excl. step stools) (product code 0618)

Extension or straight ladders (product code 4077)

Ladders, other or not specified (product code 4078)

Gender: Males

Age: 50 years and older

The result for Query Example 1 would be a spreadsheet of cases of males aged 50 and older with incidents associated with the above types of ladders reported to CPSC from 2012 through 2016.

 

Query Example 2:

Date: 2016 – 2019

Products: Sports and Recreation Equipment

Report Source: Death Certificates

ICD External Cause: W68, Drowning and submersion following fall into pool

The result for Query Example 2 would be a spreadsheet of cases of death certificates associated with Sports and Recreation Equipment where the victim drowned following a fall into a pool between 2016 and 2019.

Access Clearinghouse Query Builder

SaferProducts.gov