Open Government Spending Records
This dataset provides granular records of government spending across departments, including transaction details, vendor information, spending categories, and approval statuses. It enables transparency, accountability, and in-depth analysis of public sector expenditures for policy makers, researchers, and citizens.
Sample rows
preview · 8 of 200 rows · all 18 columns| spending_idstring | spending_categorystring | amountfloat | address_countrystring | department_idstring | department_namestring | spending_datedate | currencystring | vendor_idstring | vendor_namestring | project_codestring | fiscal_yearinteger | approval_statusstring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPD-000001 | infrastructure | 4560000.5 | US | FIN101 | Ministry of Finance | 2023-03-15 | USD | VEN-4521A | Global InfraWorks Ltd | PRJ-INF2023-001 | 2023 | approved | 1543 Main Blvd | Chicago | IL | 60616 | Payment for expansion of highway network |
| SPD-000002 | grants | 31500 | blank | HEA202 | Department of Health | 2021-06-30 | GBP | blank | blank | PRJ-GR2021-011 | 2021 | approved | blank | blank | blank | blank | Community health initiative grant |
| SPD-000003 | equipment | 1200500.75 | JP | DEF303 | Ministry of Defense | 2024-01-18 | JPY | VEN-8830C | NipponTech Defense | PRJ-EQ2024-006 | 2024 | approved | 2-15 Sakura St | Tokyo | TYO | 100-0001 | Purchase of surveillance drones |
| SPD-000004 | procurement | 850000 | AU | AGR404 | Ministry of Agriculture | 2023-08-22 | AUD | VEN-2120B | GreenFields Supplies | PRJ-PR2023-004 | 2023 | approved | 21 King St | Sydney | NSW | 2000 | Bulk procurement of farm machinery |
| SPD-000005 | grants | 42000 | blank | EDU505 | Department of Education | 2022-09-05 | USD | blank | blank | PRJ-ED2022-019 | 2022 | pending | blank | blank | blank | blank | Grant for educational technology pilot |
| SPD-000006 | infrastructure | 20500000 | DE | TRA606 | Department of Transport | 2024-04-07 | EUR | VEN-6239F | EuroConstruct GmbH | PRJ-INF2024-002 | 2024 | approved | Bahnstr 55 | Berlin | BE | 10115 | Railway construction phase II |
| SPD-000007 | services | 1200 | US | SCI707 | Ministry of Science and Technology | 2023-11-29 | USD | VEN-9923D | TechPro Analytics | blank | 2023 | approved | 88 Innovation Ave | San Francisco | CA | 94107 | Data analysis for lab research |
| SPD-000008 | equipment | 980000 | CA | ENV808 | Department of Environment | 2022-05-10 | CAD | VEN-3160E | Northern EcoMachinery Inc | PRJ-EQ2022-009 | 2022 | approved | 544 Maple Rd | Toronto | ON | M5V 2T6 | Acquisition of air quality monitoring stations |
| SPD-000009 | other | 99.99 | blank | FIN101 | Ministry of Finance | 2021-02-20 | USD | blank | blank | blank | 2021 | approved | blank | blank | blank | blank | Miscellaneous administrative expense |
| SPD-000010 | salaries | 0 | US | DEF303 | Ministry of Defense | 2023-07-13 | USD | VEN-9001Z | James R. Smith | blank | 2023 | rejected | 401 Patriot Rd | Arlington | VA | 22201 | Voided payroll transaction (system test) |
| SPD-000011 | infrastructure | 115000000 | CN | TRA606 | Department of Transport | 2024-06-01 | CNY | VEN-4802Q | Shanghai Urban Works | PRJ-INF2024-005 | 2024 | approved | 66 Renmin Rd | Shanghai | SH | 200000 | Metro expansion project final payout |
| SPD-000012 | grants | 62000 | blank | HEA202 | Department of Health | 2024-03-17 | USD | blank | blank | PRJ-GR2024-003 | 2024 | approved | blank | blank | blank | blank | Grant for rural clinic development |
| SPD-000013 | other | 850 | blank | SOC909 | Ministry of Social Welfare | 2021-12-29 | USD | blank | blank | blank | 2021 | approved | blank | blank | blank | blank | Emergency relief program incidentals |
| SPD-000014 | services | 22500 | BE | EDU505 | Department of Education | 2023-09-15 | EUR | VEN-7210A | EduConsult Europe | blank | 2023 | pending | Rue Albert 12 | Brussels | BRU | 1000 | Teacher training workshop series |
| SPD-000015 | infrastructure | 2900000 | US | SCI707 | Ministry of Science and Technology | 2022-04-20 | USD | VEN-5512L | LabSpace Construction | PRJ-INF2022-008 | 2022 | approved | 17 Research Pkwy | Boston | MA | 02115 | New laboratory building phase I |
| SPD-000016 | other | 124.99 | blank | ENV808 | Department of Environment | 2021-03-27 | USD | blank | blank | blank | 2021 | pending | blank | blank | blank | blank | Recycling awareness campaign expense |
| SPD-000017 | infrastructure | 7550000 | US | TRA606 | Department of Transport | 2022-11-18 | USD | VEN-6013M | Pacific Construction Group | PRJ-INF2022-014 | 2022 | approved | 705 Ocean Ave | Los Angeles | CA | 90024 | Bridge renovation contract phase I |
| SPD-000018 | equipment | 183600 | CA | AGR404 | Ministry of Agriculture | 2023-05-03 | CAD | VEN-8402W | AgriTech Canada | PRJ-EQ2023-004 | 2023 | approved | 301 Harvest Rd | Winnipeg | MB | R3C 1N4 | Purchase of soil testing equipment |
| SPD-000019 | grants | 97000 | blank | SOC909 | Ministry of Social Welfare | 2024-02-28 | INR | blank | blank | PRJ-GR2024-007 | 2024 | approved | blank | blank | blank | blank | Grant for women's self-help group |
| SPD-000020 | equipment | 1358000 | US | EDU505 | Department of Education | 2023-12-31 | USD | VEN-3011V | SmartBoards Unlimited | PRJ-EQ2023-010 | 2023 | approved | 1921 Elm St | Dallas | TX | 75201 | Acquisition of interactive whiteboards |
What the 200 rows show
from the 200-row sampleInfrastructure (spending category) stands out: mean amount is 36,539,878, against 1,787,356 for the rest.
- 89,000median amount
- 3approval statuses
- 11currencies
- 16department names
- 35departments
Median 89,000, from 0.0 to 234,534,568.
- string 15
- integer 1
- float 1
- date 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
spending_id | string | Unique identifier for each spending recordunique | SPD-000001 |
department_id | string | Unique identifier for the government department responsible for the spending | FIN101 |
department_name | string | Full name of the government department | Ministry of Finance |
currency | string | ISO 4217 currency code for the transaction (e.g., USD, EUR, GBP)11 currencies | USD |
spending_category | string | Category of spending (e.g., procurement, salaries, infrastructure, grants)7 values | infrastructure |
vendor_id | string | Unique identifier for the vendor or recipient of the payment (if applicable)optional | VEN-4521A |
vendor_name | string | Name of the vendor or recipient of the payment (if applicable)optional | Global InfraWorks Ltd |
description | string | Detailed description of the spending transaction | Payroll for field nurse |
project_code | string | Code or identifier for the project or initiative associated with the spending (if applicable)optional | PRJ-INF2023-001 |
approval_status | string | Status of the spending approval (e.g., approved, pending, rejected)approved · pending · rejected | approved |
address_street | string | Street address of the vendor or recipient (if applicable)optional | 1543 Main Blvd |
address_city | string | City of the vendor or recipient (if applicable)optional | Chicago |
address_state | string | State or region of the vendor or recipient (if applicable)optional | IL |
address_postal_code | string | Postal code of the vendor or recipient (if applicable)optional | 60616 |
address_country | string | Country of the vendor or recipient (if applicable)optional | US |
| Numbers 2 columns | |||
amount | float | Total amount spent in the transaction, in local currency0 or more | 4560000.5 |
fiscal_year | integer | Fiscal year in which the spending occurred1,900 or more | 2023 |
| Dates and times 1 column | |||
spending_date | date | Date when the spending occurred or was recorded | 2023-03-15 |
Use it for
A government dashboard
Amount by spending_
category and a breakdown of address_ country. Excel, Power BI or Tableau. Why do the 30 infrastructure rows have a mean amount of 36,539,878?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Spendings200SPD-0000014560000.5infrastr…SPD-00000231500grantsSPD-0000031200500.75equipment
A software demo
Believable spendings with department_
id, department_ name and spending_ date to fill a screen in front of a buyer.
blueprint · open-government-spending-records
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 18 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Transactions classified by department
- Include only finalized expenditures
- Exclude confidential payments
- Standardize currency formats
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- open-government-spending-records