A collection of SQL queries that help
- Selling to the government
- Learning about competitors
- Monitoring government spending
The quickest way to find out what it means exactly:
The data is collected from government websites and loaded to Google BigQuery:
| Data | BigQuery dataset | Source |
|---|---|---|
| US Federal Government contracts (2000–2016) | gpqueries:contracts | USASpending.gov |
All queries are written for the BigQuery SQL dialect and stored in .sql files. Each file contains comments about its purpose and usage.
You can execute queries with:
- BigQuery Web GUI
- Google Datalab
- Google Cloud Platform SDK:
bqtool (seebq help queryfor details)
All methods require a Google Account and a Google Cloud Project. Both are free. The first-time setup takes a couple of minutes.
Web GUI is the easiest to start with.
See also: Accessing BigQuery
Extracts that highlight particular findings, usually from notebooks.
Jupyter (IPython) notebooks with replication code and comments:
Expect soon:
- Coverage beyond contracts: federal grands, loans, and other assistance
- Subnational coverage: states and large cities
- Separate notebooks on finding government clients and business intelligence
To receive updates, press "Watch" in the top right corner.
- Social Media Queries - A collection of SQL queries to social media datasets.
Anton Tarasenko