New Technology or Patent Rights Clause
Indicates whether NASA included the New Technology or Patent Rights Clause on the award. This is a coded boolean attribute where 0 means no and 1 means yes.
FPDS Compare
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
Common Usage
- Filter NASA awards that include the clause
- Count awards with NASA-specific IP requirements
- Group awards by clause presence for compliance analysis
Common Mistakes
- Confusing 0 with missing or unknown
- Using the field outside NASA-specific award analysis without confirming relevance
Query Guidance
Use equality tests on the numeric code, such as WHERE newTechnologyOrPatentRightsClause = 1 to find awards with the clause and WHERE newTechnologyOrPatentRightsClause = 0 to find awards without it. Include NULL handling explicitly if you need to separate unknown from false, and avoid string comparisons because the field is numeric.
SQL Examples
Preview values
SELECT
content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause AS new_technology_or_patent_rights_clause
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause IS NOT NULL
LIMIT 25
Aggregate total
SELECT
sum(content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause) AS total_value
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause IS NOT NULL
Distribution overview
SELECT
min(content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause) AS min_value,
avg(content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause) AS avg_value,
max(content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause) AS max_value,
count() AS record_count
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__newTechnologyOrPatentRightsClause IS NOT NULL
Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.