Open Government Spending Dataset
This dataset provides comprehensive, flat records of government expenditures, detailing department, initiative, amount, vendor, and approval status for each transaction. Designed for transparency, budget analysis, and civic technology, it enables granular tracking and auditing of public spending across projects and fiscal years.
Sample rows
preview · 8 of 200 rows · all 20 columns| expenditure_idstring | expenditure_typestring | amountfloat | approvedboolean | address_countrystring | department_idstring | department_namestring | initiative_idstring | initiative_namestring | expenditure_datedate | currencystring | vendor_idstring | vendor_namestring | fiscal_yearinteger | budget_codestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EXP-00001 | procurement | 2540000.75 | true | US | DPT-01 | Ministry of Health | INIT-0001 | National Vaccination Program Expansion | 2021-05-18 | USD | VEND-001A | Global Pharma Supplies Inc | 2021 | HEALTH-7712 | 1200 5th Avenue | New York | NY | 10029 | Purchase of vaccines for the national immunization expansion project covering rural districts. |
| EXP-00002 | capital | 950000.1 | true | US | DPT-02 | Department of Education | INIT-0002 | Digital Classrooms Rollout | 2022-08-30 | USD | VEND-002B | EdTech Solutions LLC | 2022 | EDU-5438 | 223 Education Lane | Boston | MA | 02115 | Procurement and installation of interactive whiteboards and tablets in 150 public schools. |
| EXP-00003 | grant | 4200 | true | blank | DPT-03 | Ministry of Agriculture | INIT-0003 | Sustainable Farming Grants | 2020-11-12 | BRL | blank | blank | 2020 | blank | blank | blank | blank | blank | Micro-grant for smallholder farms adopting sustainable irrigation methods. |
| EXP-00004 | capital | 18500000 | true | US | DPT-04 | Ministry of Technology | INIT-0004 | AI Research Excellence Program | 2023-01-15 | USD | VEND-004C | Quantum Innovations Inc | 2023 | TECH-8831 | 777 Quantum Drive | San Francisco | CA | 94107 | Capital funding for national AI research centers and labs collaborating with universities. |
| EXP-00005 | procurement | 3290000 | true | GB | DPT-05 | Ministry of Defense | INIT-0005 | Border Security Upgrade | 2019-04-09 | GBP | VEND-005D | SecureTech UK Ltd | 2019 | DEF-4451 | 25 Thames Street | London | LND | SW1A2AA | Procurement of surveillance equipment for national border security modernization. |
| EXP-00006 | capital | 238500000 | true | CN | DPT-06 | Department of Transport | INIT-0006 | Urban Metro Expansion | 2024-02-10 | CNY | VEND-006E | Beijing Railway Group | 2024 | TRANS-8921 | 88 Metro Avenue | Beijing | BJ | 100006 | Construction and extension of metro lines in major urban centers. |
| EXP-00007 | grant | 3750.25 | false | blank | DPT-07 | Ministry of Social Services | INIT-0007 | Community Care Grants | 2018-07-23 | ZAR | blank | blank | 2018 | blank | blank | blank | blank | blank | Grant for community care organizations supporting vulnerable populations. |
| EXP-00008 | capital | 3400000 | true | SE | DPT-08 | Department of Innovation | INIT-0008 | Smart City Pilot Phase | 2022-10-05 | SEK | VEND-008F | Stockholm Tech Group | 2022 | INNOV-6512 | 12 Techgatan | Stockholm | AB | 11122 | Pilot phase for smart city infrastructure in Stockholm metropolitan areas. |
| EXP-00009 | operational | 120000 | true | AU | DPT-09 | Department of Foreign Affairs | INIT-0009 | International Cooperation Program | 2025-03-01 | AUD | VEND-009G | Sydney Global Partners | 2025 | FA-3122 | 45 Martin Place | Sydney | NSW | 2000 | Operational funding for international cooperation events and logistic support. |
| EXP-00010 | capital | 105000000 | true | US | DPT-10 | Ministry of Public Works | INIT-0010 | Urban Road Rehabilitation | 2023-07-19 | USD | VEND-010H | RoadWorks USA Inc | 2023 | PUBW-6842 | 200 Main Street | Houston | TX | 77002 | Major rehabilitation works for urban roads across US cities. |
| EXP-00011 | operational | 155000 | false | DE | DPT-11 | Department of Tourism | INIT-0011 | Promote National Heritage Sites | 2017-02-20 | EUR | VEND-011I | Berlin Events GmbH | 2017 | TOUR-2281 | 17 Museumsinsel | Berlin | BE | 10117 | Operational funding for events promoting national heritage sites in Germany. |
| EXP-00012 | grant | 750 | false | blank | DPT-12 | Department of Culture | INIT-0012 | Community Arts Microgrant | 1995-11-01 | CAD | blank | blank | 1995 | blank | blank | blank | blank | blank | Microgrant for local community arts programs and initiatives. |
| EXP-00013 | operational | 9600000 | true | US | DPT-13 | Ministry of Health | INIT-0013 | COVID-19 Emergency Response | 2020-04-15 | USD | VEND-013J | HealthLogistics Corp | 2020 | HEALTH-9051 | 300 Wellness Blvd | Dallas | TX | 75201 | Operational funding for emergency medical supplies and staff during COVID-19 pandemic. |
| EXP-00014 | grant | 22000 | true | blank | DPT-14 | Department of Education | INIT-0014 | Special Needs Education Funding | 2018-09-25 | INR | blank | blank | 2018 | blank | blank | blank | blank | blank | Grant for special needs education programs in northern states. |
| EXP-00015 | procurement | 3200000 | true | US | DPT-15 | Ministry of Agriculture | INIT-0015 | AgriTech Pilot Program | 2023-03-14 | USD | VEND-015K | AgriTech Farms Ltd | 2023 | AGRI-8922 | 500 Harvest Lane | Des Moines | IA | 50309 | Procurement of sensors and machinery for precision agriculture pilot in Midwest. |
| EXP-00016 | capital | 120000000 | true | JP | DPT-16 | Ministry of Space | INIT-0016 | Satellite Launch Program | 2026-06-20 | JPY | VEND-016L | Tokyo Aerospace Co. | 2026 | SPACE-9932 | 3-1-1 Roppongi | Tokyo | 13 | 1060032 | Funding for satellite launch and ground station upgrades. |
| EXP-00017 | grant | 2100 | false | blank | DPT-03 | Ministry of Agriculture | INIT-0017 | Rural Water Access | 2015-08-07 | NGN | blank | blank | 2015 | blank | blank | blank | blank | blank | Grant for rural communities to improve water access infrastructure. |
| EXP-00018 | operational | 87000 | true | CH | DPT-12 | Department of Culture | INIT-0018 | National Library Digitization | 2020-06-22 | CHF | VEND-018M | Swiss Digital Media | 2020 | CULT-4411 | 5 Bibliothekplatz | Zurich | ZH | 8001 | Operational funding for digitizing national library archives. |
| EXP-00019 | grant | 3750 | true | blank | DPT-07 | Ministry of Social Services | INIT-0019 | Elderly Home Support | 2010-11-28 | EUR | blank | blank | 2010 | blank | blank | blank | blank | blank | Grant for elderly care home support in rural regions. |
| EXP-00020 | operational | 650000 | true | US | DPT-08 | Department of Innovation | INIT-0020 | Open Data Portal Development | 2021-10-11 | USD | VEND-020N | DataCentric LLC | 2021 | INNOV-5532 | 130 Open Blvd | Seattle | WA | 98101 | Operational costs for public sector open data platform buildout. |
What the 200 rows show
from the 200-row sampleCapital (expenditure type) stands out: mean amount is 125,277,280, against 877,137 for the rest.
- 82%approved = true
- 156,500median amount
- 13currencies
- 32department names
- 45departments
Median 156,500, from 180.0 to 980,000,000.
- string 16
- integer 1
- float 1
- date 1
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
expenditure_id | string | Unique identifier for each government expenditure recordunique | EXP-00001 |
department_id | string | Unique identifier for the government department responsible for the expenditure | DPT-01 |
department_name | string | Full name of the government department | Ministry of Health |
initiative_id | string | Unique identifier for the specific government initiative or project | INIT-0001 |
initiative_name | string | Name of the government initiative or project | Border Security Upgrade |
currency | string | Currency code of the expenditure amount (ISO 4217 format) | USD |
expenditure_type | string | Type of expenditure (e.g., capital, operational, grant, procurement)capital · operational · grant · procurement · other | procurement |
vendor_id | string | Unique identifier for the vendor or recipient of the expenditureoptional | VEND-001A |
vendor_name | string | Name of the vendor or recipient organizationoptional | EdTech Solutions LLC |
description | string | Detailed description of the expenditure purpose | Purchase of vaccines for … |
budget_code | string | Official budget code or classification for the expenditureoptional | HEALTH-7712 |
address_street | string | Street address of the vendor or recipient (if applicable)optional | 1200 5th Avenue |
address_city | string | City of the vendor or recipient (if applicable)optional | New York |
address_state | string | State or region of the vendor or recipient (if applicable)optional | NY |
address_postal_code | string | Postal code of the vendor or recipient (if applicable)optional | 10029 |
address_country | string | Country of the vendor or recipient (if applicable, ISO 3166-1 alpha-2)optional | US |
| Numbers 2 columns | |||
amount | float | Amount spent in the expenditure, in local currency0 or more | 2540000.75 |
fiscal_year | integer | Fiscal year in which the expenditure occurred1,900 to 2,100 | 2021 |
| Dates and times 1 column | |||
expenditure_date | date | Date when the expenditure was made or recorded | 2021-05-18 |
| True or false 1 column | |||
approved | boolean | Indicates whether the expenditure was formally approved | true |
Use it for
A government dashboard
The approved rate, amount by expenditure_
type and a breakdown of address_ country. Excel, Power BI or Tableau. Why do the 60 capital rows have a mean amount of 125,277,280?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Expenditures200EXP-000012540000.75procurem…EXP-00002950000.1capitalEXP-000073750.25grant
A software demo
Believable expenditures with department_
id, department_ name and initiative_ id to fill a screen in front of a buyer.
blueprint · open-government-spending-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 20 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.
- Department, category, and expense type per record
- Spending amounts between $100 and $10,000,000
- Quarterly dates assigned over 4 years
- Randomized vendor names, ensured no repeats per quarter
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-dataset