FPDS Query Library
About Us
Contact Us

Is1862 Land Grant College

Numeric indicator showing whether the vendor site is identified as an 1862 Land Grant College. In FPDS, this is a coded attribute within Vendor Site Details, typically represented as 1 for yes and 0 for no, rather than a text description.

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__is1862LandGrantCollege
Title
Is1862 Land Grant College
FPDS Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1862LandGrantCollege
Description
Numeric indicator showing whether the vendor site is identified as an 1862 Land Grant College. In FPDS, this is a coded attribute within Vendor Site Details, typically represented as 1 for yes and 0 for no, rather than a text description.
Business Meaning
This field helps analysts identify awards flowing to a specific type of educational institution that may be relevant for socioeconomic, institutional, or public-interest reporting. It can support segmentation of obligations to colleges and universities, validation of vendor classifications, and analysis of procurement patterns involving federally recognized land-grant institutions.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1862LandGrantCollege
FPDS XML Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1862LandGrantCollege
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/typeOfEducationalEntity/is1862LandGrantCollege' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1862LandGrantCollege'.

Use Cases

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

Common Usage

  • Filter awards to 1862 land-grant colleges
  • Group obligations by institution type
  • Validate vendor site educational classification

Common Mistakes

  • Assuming 0 always means a confirmed no instead of possibly missing or unreported
  • Using the field as a text label instead of a numeric code

Query Guidance

Use explicit value tests in SQL, such as WHERE is1862LandGrantCollege = 1 for positive cases, and handle nulls separately if you need to distinguish missing from false. If reporting by institution type, combine this flag with other vendor site educational entity indicators to avoid misclassification.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1862LandGrantCollege AS is1862_land_grant_college
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__is1862LandGrantCollege IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

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