Procurement Spend Analytics
This dataset provides detailed, transaction-level records of government procurement spend, including agency and supplier information, contract details, spend amounts, compliance status, and cost-saving indicators. It enables comprehensive spend analysis, compliance monitoring, and identification of cost-saving opportunities across government agencies. Ideal for transparency initiatives, audit support, and strategic sourcing analytics.
Sample rows
preview · 8 of 70 rows · all 28 columns| procurement_idstring | compliance_statusstring | unit_pricefloat | cost_saving_flagboolean | supplier_address_statestring | agency_idstring | agency_namestring | supplier_idstring | supplier_namestring | supplier_tax_idstring | contract_numberstring | procurement_categorystring | quantityfloat | total_amountfloat | currencystring | procurement_methodstring | award_datedate | contract_start_datedate | contract_end_datedate | compliance_notesstring | cost_saving_amountfloat | buyer_contact_namestring | buyer_contact_emailstring | supplier_address_streetstring | supplier_address_citystring | supplier_address_postal_codestring | supplier_address_countrystring | item_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-2024001 | compliant | 3500.75 | true | IL | A001 | Department of Health | S1001 | Mediline Supplies Ltd. | TX-45211322 | CT-2024-015 | medical equipment | 10 | 35007.5 | USD | open_tender | 2024-01-20 | 2024-02-01 | 2024-12-31 | blank | 2500 | Dr. Alice Morgan | alice.morgan@ | 1895 Wellness Ave | Chicago | 60610 | USA | Advanced ECG Machines with wireless capability |
| P-2024002 | compliant | 48000 | false | MA | A002 | Ministry of Education | S1002 | EduTech Consulting | TX-22114455 | EDU-CT-0047 | consulting | 1 | 48000 | USD | restricted_tender | 2024-02-14 | 2024-03-01 | 2024-08-31 | blank | 0 | Linda Tran | ltr@ | 1400 Innovation Blvd | Boston | 02118 | USA | Curriculum development advisory services |
| P-2024003 | pending_review | 150.5 | false | TX | A003 | Department of Transportation | S1003 | RoadWorks International | TX-99887766 | DOT-2024-088 | infrastructure | 500 | 75250 | USD | framework_agreement | 2024-03-05 | 2024-03-15 | 2024-10-31 | Awaiting environmental impact report | 0 | Jacob Lee | jlee@ | 302 Main Industrial Park | Dallas | 75201 | USA | Highway resurfacing materials and services |
| P-2024004 | compliant | 320 | true | CA | A004 | Ministry of Justice | S1004 | SecureIT Solutions | TX-55555111 | MJ-CT-2024-12 | IT | 50 | 16000 | USD | open_tender | 2024-01-17 | 2024-02-01 | 2024-06-30 | blank | 1200 | Michael R. Field | mfield@ | 12 Data Lane | San Jose | 95112 | USA | Firewall and endpoint security licenses |
| P-2024005 | compliant | 2250 | true | OR | A005 | Environmental Protection Agency | S1005 | EcoGreen Services | TX-33334444 | EPA-2024-022 | environmental services | 12 | 27000 | USD | direct_award | 2024-03-28 | 2024-04-01 | 2024-12-31 | Meets all ISO standards | 800 | Sara Goodwin | sgoodwin@ | 789 Green Blvd | Portland | 97209 | USA | Air quality monitoring and reporting |
| P-2024006 | compliant | 18000 | false | GA | A006 | Department of Finance | S1006 | FiscalPro Analytics | blank | blank | financial services | 1 | 18000 | USD | restricted_tender | 2024-02-08 | 2024-02-20 | 2024-06-30 | blank | 0 | Erin Stewart | estewart@ | 16 Ledger Way | Atlanta | 30303 | USA | Annual audit and risk assessment |
| P-2024007 | compliant | 42500 | true | IA | A007 | Ministry of Agriculture | S1007 | AgriSupply Depot | TX-77665543 | AG-CT-2024-33 | agricultural equipment | 5 | 212500 | USD | framework_agreement | 2024-01-31 | 2024-02-15 | 2024-07-15 | blank | 5000 | Javier Hernandez | jhernandez@ | 101 Harvest Road | Des Moines | 50309 | USA | Tractor units with GPS guidance |
| P-2024008 | pending_review | 185000 | false | CA | A008 | Public Works Authority | S1008 | UrbanBuild Corp. | TX-83838383 | PWA-2024-05 | construction | 1 | 185000 | USD | open_tender | 2024-04-01 | 2024-04-20 | 2024-11-30 | Pending final inspection | 0 | Nina Patel | nina.patel@ | 99 Concrete Circle | Los Angeles | 90012 | USA | Renovation of downtown city offices |
| P-2024009 | compliant | 2500 | true | CO | A009 | Ministry of Energy | S1009 | SolarGen Solutions | TX-29292929 | EN-2024-202 | renewable energy | 40 | 100000 | USD | open_tender | 2024-03-11 | 2024-03-25 | 2024-08-15 | blank | 8500 | Omar J. Davis | odavis@ | 555 Sun Avenue | Denver | 80203 | USA | Installation of rooftop solar panels |
| P-2024010 | compliant | 75000 | false | VA | A010 | Department of Defense | S1010 | Defense Tech Systems | TX-41414141 | DOD-2024-555 | IT | 1 | 75000 | USD | restricted_tender | 2024-02-02 | 2024-02-10 | 2025-02-09 | blank | 0 | Lt. Col. Rick Marshall | rmarshall@ | 101 Armory Drive | Arlington | 22202 | USA | Secure cloud storage subscription (annual) |
| P-2024011 | compliant | 35 | true | MD | A001 | Department of Health | S1011 | SterilSafe Supplies | blank | blank | medical supplies | 100 | 3500 | USD | direct_award | 2024-01-09 | 2024-01-20 | 2024-03-31 | blank | 300 | Dr. Alice Morgan | alice.morgan@ | 25 Cleanroom Ave | Baltimore | 21201 | USA | Disposable surgical masks (box of 50) |
| P-2024012 | compliant | 13500 | false | MA | A002 | Ministry of Education | S1002 | EduTech Consulting | TX-22114455 | EDU-CT-0050 | consulting | 1 | 13500 | USD | open_tender | 2024-03-01 | 2024-03-20 | 2024-03-24 | blank | 0 | Linda Tran | ltr@ | 1400 Innovation Blvd | Boston | 02118 | USA | Teacher professional development workshop |
| P-2024013 | non_compliant | 7000 | false | OR | A005 | Environmental Protection Agency | S1005 | EcoGreen Services | TX-33334444 | EPA-2024-024 | environmental services | 3 | 21000 | USD | restricted_tender | 2024-04-11 | 2024-04-20 | 2024-07-31 | Vendor failed to submit disposal certificates | 0 | Sara Goodwin | sgoodwin@ | 789 Green Blvd | Portland | 97209 | USA | Hazardous waste collection and disposal |
| P-2024014 | compliant | 540 | false | IA | A007 | Ministry of Agriculture | S1007 | AgriSupply Depot | TX-77665543 | blank | agricultural equipment | 8 | 4320 | USD | direct_award | 2024-02-21 | 2024-03-01 | 2024-03-30 | blank | 0 | Javier Hernandez | jhernandez@ | 101 Harvest Road | Des Moines | 50309 | USA | Portable grain moisture meters |
| P-2024015 | compliant | 1200 | false | MI | A003 | Department of Transportation | S1012 | AutoFleet Maintenance | TX-23123123 | DOT-2024-095 | vehicle maintenance | 15 | 18000 | USD | open_tender | 2024-02-18 | 2024-03-01 | 2024-03-10 | blank | 0 | Jacob Lee | jlee@ | 221 Service Lane | Detroit | 48226 | USA | Annual fleet vehicle servicing (batch of 15 vehicles) |
| P-2024016 | compliant | 6700 | true | OK | A009 | Ministry of Energy | S1013 | GreenTech Installers | TX-90909090 | blank | renewable energy | 6 | 40200 | USD | framework_agreement | 2024-03-24 | 2024-04-01 | 2024-09-30 | blank | 1100 | Omar J. Davis | odavis@ | 900 Windmill Park | Oklahoma City | 73102 | USA | Installation of wind turbine monitoring systems |
| P-2024017 | pending_review | 18000 | false | OH | A010 | Department of Defense | S1014 | ArmorSafe Logistics | TX-56565656 | DOD-2024-606 | logistics | 1 | 18000 | USD | other | 2024-04-04 | 2024-04-10 | 2024-04-18 | Final security clearance pending | 0 | Lt. Col. Rick Marshall | rmarshall@ | 33 Shield Blvd | Columbus | 43215 | USA | Secure transportation of classified materials |
| P-2024018 | compliant | 9500 | false | CA | A004 | Ministry of Justice | S1004 | SecureIT Solutions | TX-55555111 | MJ-CT-2024-14 | IT | 1 | 9500 | USD | open_tender | 2024-03-08 | 2024-03-20 | 2025-03-19 | blank | 0 | Michael R. Field | mfield@ | 12 Data Lane | San Jose | 95112 | USA | Annual maintenance for security software |
| P-2024019 | compliant | 9200 | false | NY | A006 | Department of Finance | S1015 | BlueBook Consulting | TX-22119988 | blank | consulting | 1 | 9200 | USD | direct_award | 2024-01-22 | 2024-01-31 | 2024-03-31 | blank | 0 | Erin Stewart | estewart@ | 800 Bluebook Plaza | New York | 10001 | USA | Tax compliance risk advisory |
| P-2024020 | pending_review | 242000 | false | CA | A008 | Public Works Authority | S1008 | UrbanBuild Corp. | TX-83838383 | PWA-2024-06 | construction | 1 | 242000 | USD | open_tender | 2024-02-04 | 2024-02-10 | 2024-10-15 | Contract review in progress | 0 | Nina Patel | nina.patel@ | 99 Concrete Circle | Los Angeles | 90012 | USA | Upgrade of municipal water systems |
What the 70 rows show
from the 70-row sampleCompliant (compliance status) stands out: 28 of its 60 rows have cost_
- 40%cost_
saving_ flag = true - 2,225median unit_
price - 4currencies
- 4supplier address countries
- 5procurement methods
- 10median quantity
Median 2,225, from 2.1 to 285,000.
- string 20
- float 4
- date 3
- boolean 1
Columns
28 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
procurement_id | string | Unique identifier for each procurement transaction or contract.unique | P-2024001 |
agency_id | string | Unique identifier for the government agency making the procurement. | A001 |
agency_name | string | Full name of the government agency. | Department of Health |
supplier_id | string | Unique identifier for the supplier/vendor. | S1001 |
supplier_name | string | Full legal name of the supplier/vendor. | Mediline Supplies Ltd. |
supplier_tax_id | string | Tax identification number of the supplier/vendor.optional | TX-45211322 |
contract_number | string | Official contract number or reference code.optional | CT-2024-015 |
procurement_category | string | Category of goods or services procured (e.g., IT, consulting, office supplies). | medical equipment |
item_description | string | Detailed description of the goods or services procured. | Irrigation pump sets |
currency | string | Currency code for the transaction (e.g., USD, EUR).4 currencies | USD |
procurement_method | string | Method used for procurement (e.g., open tender, direct award, framework agreement).5 values | open_tender |
compliance_status | string | Indicates if the procurement complies with relevant regulations.compliant · non_compliant · pending_review | compliant |
compliance_notes | string | Additional notes or comments on compliance issues.optional | Meets all ISO standards |
buyer_contact_name | string | Name of the primary contact person for the procurement at the agency.optional | Dr. Alice Morgan |
buyer_contact_email | string | Email address of the agency's procurement contact.optional | ltr@ |
supplier_address_street | string | Street address of the supplier.optional | 1895 Wellness Ave |
supplier_address_city | string | City of the supplier.optional | Chicago |
supplier_address_state | string | State or province of the supplier.optional | IL |
supplier_address_postal_code | string | Postal code of the supplier.optional | 60610 |
supplier_address_country | string | Country of the supplier.4 countries · optional | USA |
| Numbers 4 columns | |||
quantity | float | Quantity of items or services procured.0 or more · optional | 10 |
unit_price | float | Price per unit of the item or service.0 or more · optional | 3500.75 |
total_amount | float | Total amount spent for this procurement (quantity * unit_price).0 or more | 35007.5 |
cost_saving_amount | float | Amount saved in this procurement compared to previous or estimated costs.0 or more · optional | 2500 |
| Dates and times 3 columns | |||
award_date | date | Date when the contract or procurement was awarded. | 2024-01-20 |
contract_start_date | date | Start date of the contract or delivery period.optional | 2024-02-01 |
contract_end_date | date | End date of the contract or delivery period.optional | 2024-12-31 |
| True or false 1 column | |||
cost_saving_flag | boolean | Indicates if this procurement resulted in a cost saving compared to previous benchmarks.optional | true |
Use it for
A government dashboard
The cost_
saving_ flag rate, unit_ price by compliance_ status and a breakdown of supplier_ address_ state. Excel, Power BI or Tableau. Why do 28 of 70 rows have cost_
saving_ flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Procurements70P-20240013500.75compliantP-202400248000compliantP-2024004320compliant
A software demo
Believable procurements with agency_
id, agency_ name and supplier_ id to fill a screen in front of a buyer.
blueprint · procurement-spend-analytics
Behind this dataset
Same schema. As many rows as you need.
These 70 rows came out of a blueprint — 28 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.
- All vendor payments are itemized
- Expenditures over $50,000 require supervisory approval
- Duplicate vendor entries are merged
- Non-compliant purchases flagged for audit
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- procurement-spend-analytics