Data
Download the data
Every figure on the site, as CSV, with the definitions we use and the date each source was read.
Files
| File | What it holds | Rows |
|---|---|---|
| companies.csv | One row per company: latest reported share, dollars, obligations and ratio. | 40 |
| share_history.csv | Every reviewed share by company and fiscal year, with the quoted sentence. | 103 |
| obligations_by_year.csv | Matched contract obligations by company and federal fiscal year. | 212 |
| matched_recipients.csv | Every USAspending recipient we rolled into each company, with UEI and method. | 403 |
Data dictionary: companies.csv
| Column | Meaning |
|---|---|
ticker | Stock ticker. |
name | Company name. |
sector | Our sector grouping. |
fiscal_year | Company fiscal year of the latest reviewed 10-K (company's own label). |
fiscal_year_end | Last day of that fiscal year. |
revenue_usd | Total revenue, dollars (10-K / XBRL). |
reported_share_pct | Share of revenue from the U.S. government, as the company reports it. Blank = not disclosed. |
reported_us_gov_rev_usd | U.S. government revenue in dollars: disclosed, or share × revenue when is_calculated is true. |
is_calculated | True when the dollar figure is our calculation, not the company's. |
adjusted_share_pct | Share excluding foreign military sales (FMS) where computable; otherwise equal to reported. |
adjusted | True only when FMS was actually removed using disclosed FMS dollars. |
fms_treatment | incl / excl / not_stated / n/a: how the company's figure treats FMS. |
basis | What the company counts, in brief. |
obligations_ffy | Federal fiscal year (Oct 1 to Sep 30) matched to the company's fiscal year. |
obligations_usd | Prime contract obligations (USAspending award types A-D) to recipients we matched to the company. |
obligation_ratio | obligations_usd ÷ reported_us_gov_rev_usd. Blank when withheld for review. |
share_change_pts | Change in reported share from the prior reviewed fiscal year, in percentage points. |
source_url | The filing the share comes from. |
as_of | Date the figure was read from its source. |
License and citation
Federal data is in the public domain. Our compilations are © Federal Exposure and licensed under Creative Commons Attribution 4.0 (CC BY 4.0). Please credit “Federal Exposure, federalexposure.com” and link to the page you used.
Definitions, sources and known limitations are on the methodology page. Found an error? Write to contact@federalexposure.com.