FPDS Query Library
About Us
Contact Us

Is1890 Land Grant College

Numeric indicator showing whether the vendor site is an 1890 Land Grant College. In FPDS this is a site-level educational entity attribute stored under Vendor Site Details, with 0 typically indicating no and a positive value indicating yes or another coded representation depending on the extract.

Family: Other Transaction Award
Category: Vendor Site Details
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege
Title
Is1890 Land Grant College
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege
Description
Numeric indicator showing whether the vendor site is an 1890 Land Grant College. In FPDS this is a site-level educational entity attribute stored under Vendor Site Details, with 0 typically indicating no and a positive value indicating yes or another coded representation depending on the extract.
Business Meaning
This field helps analysts identify awards involving 1890 Land Grant Colleges, which can be relevant for socioeconomic, educational, and institutional participation analyses. It supports set-aside, vendor segmentation, institutional reporting, and reviews of federal procurement relationships with historically significant higher-education entities.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • identify awards to 1890 Land Grant Colleges
  • segment vendor populations by educational entity type
  • support compliance and institutional participation reporting

Common Mistakes

  • assuming 0 always means false without checking the data extract conventions
  • using the field as a vendor-wide attribute when it is stored at the site level

Query Guidance

Filter on the coded value set observed in your dataset, for example WHERE is1890LandGrantCollege = 1 for affirmative records if the extract uses 1/0 coding. If the source includes a companion description field or nonstandard codes, coalesce or map values explicitly before grouping or counting.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege AS is1890_land_grant_college
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege) AS total_value
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege IS NOT NULL

Distribution overview

SELECT
    min(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege) AS min_value,
    avg(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege) AS avg_value,
    max(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege 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.