FPDS Query Library
About Us
Contact Us

Is1890 Land Grant College

Numeric indicator showing whether the vendor site is identified as an 1890 Land Grant College. It is a coded yes/no attribute within Vendor Site Details rather than a free-text description. A value of 1 typically indicates true and 0 indicates false; inspect observed values if the feed includes other codes or nulls.

Family: 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__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege
Title
Is1890 Land Grant College
FPDS Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege
Description
Numeric indicator showing whether the vendor site is identified as an 1890 Land Grant College. It is a coded yes/no attribute within Vendor Site Details rather than a free-text description. A value of 1 typically indicates true and 0 indicates false; inspect observed values if the feed includes other codes or nulls.
Business Meaning
This field helps analysts identify awards associated with a specific category of educational institution that may be relevant for socioeconomic, institutional, or policy-related reporting. It can support segmentation of obligations to historically important agricultural and technical colleges and help validate vendor eligibility or participation patterns in targeted procurement analyses.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege
FPDS XML Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1890LandGrantCollege' into the SQL-ready variable 'content__award__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

  • Flag awards to 1890 Land Grant College vendors
  • Group obligations by educational institution status
  • Support compliance or socioeconomic reporting checks

Common Mistakes

  • Assuming 0 means the vendor is definitively not an 1890 Land Grant College when the record may actually be missing or incomplete
  • Using the field as a text label instead of a numeric indicator

Query Guidance

Filter with `WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1890LandGrantCollege = 1` for affirmative cases. Use `COUNT(*)`, `SUM(CASE WHEN ... = 1 THEN 1 ELSE 0 END)`, or `GROUP BY` to measure frequency, and include `IS NULL` checks when distinguishing unknown from false.

SQL Examples

Preview values

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

Aggregate total

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

Distribution overview

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