FPDS Query Library
About Us
Contact Us

Type

Specifies the MIME type or format of the linked resource recorded in the FPDS Links section, such as text/html. It identifies what kind of content the link points to rather than the content itself.

Family: General
Category: Links
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
link__type
Title
Type
FPDS Path
link/type
Description
Specifies the MIME type or format of the linked resource recorded in the FPDS Links section, such as text/html. It identifies what kind of content the link points to rather than the content itself.
Business Meaning
This field helps analysts understand how FPDS-linked resources are represented and whether links are pointing to web pages, documents, or other retrievable formats. It supports filtering and grouping link records when building reusable procurement reporting and data quality checks.
Example Value
text/html
Observed Non-Null Count
117,423,893

FPDS Compare

FPDS Query Variable
link__type
FPDS XML Path
link/type
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'link/type' into the SQL-ready variable 'link__type'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • classifying linked resource formats
  • filtering FPDS link records by MIME type
  • supporting data quality checks on link metadata

Common Mistakes

  • assuming it describes contract content instead of link format
  • grouping without normalizing observed MIME values

Query Guidance

Use exact-match or pattern filters on the string value, for example WHERE link__type = 'text/html'. For broader analysis, normalize case and group by the observed MIME type to avoid splitting equivalent values.

SQL Examples

Preview values

SELECT
    link__type AS type
FROM fpds.data
WHERE link__type IS NOT NULL
LIMIT 25

Top values

SELECT
    link__type AS value,
    count() AS record_count
FROM fpds.data
WHERE link__type 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.