FPDS Query Library
About Us
Contact Us

Principal NAICS Code

A coded field that stores the principal North American Industry Classification System (NAICS) code associated with the IDV. It identifies the primary industry category for the procurement action, typically as a numeric code such as 332991.

Family: IDV
Category: Product Or Service Information
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__productOrServiceInformation__principalNAICSCode
Title
Principal NAICS Code
FPDS Path
IDV/productOrServiceInformation/principalNAICSCode
Description
A coded field that stores the principal North American Industry Classification System (NAICS) code associated with the IDV. It identifies the primary industry category for the procurement action, typically as a numeric code such as 332991.
Business Meaning
This field is used to classify obligations and award activity by industry, support market research, and analyze spending concentrations across sectors. It is especially useful for identifying which industries receive vehicles or awards under a given IDV and for comparing procurement patterns by NAICS.
Example Value
332991
Observed Non-Null Count
4,417,802

FPDS Compare

FPDS Query Variable
content__IDV__productOrServiceInformation__principalNAICSCode
FPDS XML Path
IDV/productOrServiceInformation/principalNAICSCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/productOrServiceInformation/principalNAICSCode' into the SQL-ready variable 'content__IDV__productOrServiceInformation__principalNAICSCode'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Market segmentation by industry or PSC

Common Usage

  • Industry classification of IDVs
  • Spend and award concentration analysis by NAICS
  • Filtering vehicles or actions for a specific sector

Common Mistakes

  • Assuming it is a text description rather than a coded identifier
  • Grouping without normalizing formatting or checking for null/blank values

Query Guidance

Use this field in WHERE and GROUP BY clauses as a categorical code, e.g. WHERE principalNAICSCode = '332991'. If the source is numeric in some extracts and text in others, cast consistently and trim whitespace before comparison.

SQL Examples

Preview values

SELECT
    content__IDV__productOrServiceInformation__principalNAICSCode AS principal_n_a_i_c_s_code
FROM fpds.data
WHERE content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__productOrServiceInformation__principalNAICSCode AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.