17 years of government contracts on BigQuery

Also check out http://government-contracts.insidegov.com/ and http://government-contractors.insidegov.com/. Data is slightly outdated, but is being updated as we speak to account for the recent changes USASpending.gov made to their file schema. We did work to tie in all subsidiaries and branches into summary profiles through Duns numbers to give a true estimate for the obligated contract amount won by large corporations. Thanks for posting the other sites with this data, always great to check out how others handle these problems!

Full disclosure, I work for Graphiq which owns InsideGov.

Do you have an email you can share? I'm at manigandham @ gmail.

We're looking to move to GCP and love what's there so far but need some help from the startup side.

Probably because of the way government contracting works with (value added) resellers. One such is "Carahsoft" (see http://openbeta-contracts-explorer.usaspending.gov/#!/year/A...). If you dig into the details of the transactions you'll see that many are for technology companies' software and services. One example link that includes Salesforce, HP, VMWare, Symantec, etc.: http://openbeta-contracts-explorer.usaspending.gov/#!/year/A...

I don't know much about this new explorer tool, but it's based off of USASpending.gov which is a bit fickle...which is to be expected given the messiness of the data involved (companies have varied names, subsidiaries etc., among other real-life complexities).

But you can do an "advanced search" by registered company name, and this is what comes up for "Microsoft" -- probably doesn't include all of its subsidiaries that don't have "Microsoft" in the name: ~$1.4 billion in awarded contracts

https://www.usaspending.gov/Pages/AdvancedSearch.aspx?sub=y&...

edit: Oh I know the reason for the discrepancy...the homepage of the beta app says it's only partial data:

> Added more years of contract data to now include 2011 - 2015

Two reasons:

1. Agencies often buy from distributors and integrators, not publishers. In this case, original manufacturers may appear in the variable `descriptionofcontractrequirement`.

2. Spelling may differ. Variable `dunsnumber` is be a better indicator for uniqueness.

Government requires competition for purchases. So vendors like Dell, SHI, CDW, Carahsoft, etc are all wholesalers who compete over the pennies for fulfillment to sell Microsoft (and most other) software.