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.

  • opened 11 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing government procurement spend patterns to identify cost-saving opportunities

Sample rows

preview · 8 of 70 rows · all 28 columns
procurement_idstringcompliance_statusstringunit_pricefloatcost_saving_flagbooleansupplier_address_statestringagency_idstringagency_namestringsupplier_idstringsupplier_namestringsupplier_tax_idstringcontract_numberstringprocurement_categorystringquantityfloattotal_amountfloatcurrencystringprocurement_methodstringaward_datedatecontract_start_datedatecontract_end_datedatecompliance_notesstringcost_saving_amountfloatbuyer_contact_namestringbuyer_contact_emailstringsupplier_address_streetstringsupplier_address_citystringsupplier_address_postal_codestringsupplier_address_countrystringitem_descriptionstring
P-2024001compliant3500.75trueILA001Department of HealthS1001Mediline Supplies Ltd.TX-45211322CT-2024-015medical equipment1035007.5USDopen_tender2024-01-202024-02-012024-12-31blank2500Dr. Alice Morganalice.morgan@health.gov.us1895 Wellness AveChicago60610USAAdvanced ECG Machines with wireless capability
P-2024002compliant48000falseMAA002Ministry of EducationS1002EduTech ConsultingTX-22114455EDU-CT-0047consulting148000USDrestricted_tender2024-02-142024-03-012024-08-31blank0Linda Tranltr@education.gov.us1400 Innovation BlvdBoston02118USACurriculum development advisory services
P-2024003pending_review150.5falseTXA003Department of TransportationS1003RoadWorks InternationalTX-99887766DOT-2024-088infrastructure50075250USDframework_agreement2024-03-052024-03-152024-10-31Awaiting environmental impact report0Jacob Leejlee@transport.gov.us302 Main Industrial ParkDallas75201USAHighway resurfacing materials and services
P-2024004compliant320trueCAA004Ministry of JusticeS1004SecureIT SolutionsTX-55555111MJ-CT-2024-12IT5016000USDopen_tender2024-01-172024-02-012024-06-30blank1200Michael R. Fieldmfield@justice.gov.us12 Data LaneSan Jose95112USAFirewall and endpoint security licenses
P-2024005compliant2250trueORA005Environmental Protection AgencyS1005EcoGreen ServicesTX-33334444EPA-2024-022environmental services1227000USDdirect_award2024-03-282024-04-012024-12-31Meets all ISO standards800Sara Goodwinsgoodwin@epa.gov.us789 Green BlvdPortland97209USAAir quality monitoring and reporting
P-2024006compliant18000falseGAA006Department of FinanceS1006FiscalPro Analyticsblankblankfinancial services118000USDrestricted_tender2024-02-082024-02-202024-06-30blank0Erin Stewartestewart@finance.gov.us16 Ledger WayAtlanta30303USAAnnual audit and risk assessment
P-2024007compliant42500trueIAA007Ministry of AgricultureS1007AgriSupply DepotTX-77665543AG-CT-2024-33agricultural equipment5212500USDframework_agreement2024-01-312024-02-152024-07-15blank5000Javier Hernandezjhernandez@agriculture.gov.us101 Harvest RoadDes Moines50309USATractor units with GPS guidance
P-2024008pending_review185000falseCAA008Public Works AuthorityS1008UrbanBuild Corp.TX-83838383PWA-2024-05construction1185000USDopen_tender2024-04-012024-04-202024-11-30Pending final inspection0Nina Patelnina.patel@pwa.gov.us99 Concrete CircleLos Angeles90012USARenovation of downtown city offices

What the 70 rows show

from the 70-row sample

Compliant (compliance status) stands out: 28 of its 60 rows have cost_saving_flag = true, against 0 of 10 for the rest.

  • 40%cost_saving_flag = true
  • 2,225median unit_price
  • 4currencies
  • 4supplier address countries
  • 5procurement methods
  • 10median quantity
Cost saving flag rate by compliance_statuscost_saving_flag = true
0%50%100%47%compliant28 of 600%non_compliant0 of 10%pending_revi…0 of 9
unit_price70 rows, in bands of 50k
0357063102220150k300kunit_price →

Median 2,225, from 2.1 to 285,000.

supplier_address_state68 rows with a value · 2 left blank
  1. CA10
  2. TX4
  3. IL3
  4. OR3
  5. GA3
  6. IA3
  7. CO3
  8. MD3
  9. MI3
  10. OK3
28 columns by typefrom the column list below
  • string 20
  • float 4
  • date 3
  • boolean 1

Columns

28 columns in four groups
blueprint · 28 columns
columntypedescriptionexample
Text 20 columns
procurement_idstringUnique identifier for each procurement transaction or contract.uniqueP-2024001
agency_idstringUnique identifier for the government agency making the procurement.A001
agency_namestringFull name of the government agency.Department of Health
supplier_idstringUnique identifier for the supplier/vendor.S1001
supplier_namestringFull legal name of the supplier/vendor.Mediline Supplies Ltd.
supplier_tax_idstringTax identification number of the supplier/vendor.optionalTX-45211322
contract_numberstringOfficial contract number or reference code.optionalCT-2024-015
procurement_categorystringCategory of goods or services procured (e.g., IT, consulting, office supplies).medical equipment
item_descriptionstringDetailed description of the goods or services procured.Irrigation pump sets
currencystringCurrency code for the transaction (e.g., USD, EUR).4 currenciesUSD
procurement_methodstringMethod used for procurement (e.g., open tender, direct award, framework agreement).5 valuesopen_tender
compliance_statusstringIndicates if the procurement complies with relevant regulations.compliant · non_compliant · pending_reviewcompliant
compliance_notesstringAdditional notes or comments on compliance issues.optionalMeets all ISO standards
buyer_contact_namestringName of the primary contact person for the procurement at the agency.optionalDr. Alice Morgan
buyer_contact_emailstringEmail address of the agency's procurement contact.optionalltr@education.gov.us
supplier_address_streetstringStreet address of the supplier.optional1895 Wellness Ave
supplier_address_citystringCity of the supplier.optionalChicago
supplier_address_statestringState or province of the supplier.optionalIL
supplier_address_postal_codestringPostal code of the supplier.optional60610
supplier_address_countrystringCountry of the supplier.4 countries · optionalUSA
Numbers 4 columns
quantityfloatQuantity of items or services procured.0 or more · optional10
unit_pricefloatPrice per unit of the item or service.0 or more · optional3500.75
total_amountfloatTotal amount spent for this procurement (quantity * unit_price).0 or more35007.5
cost_saving_amountfloatAmount saved in this procurement compared to previous or estimated costs.0 or more · optional2500
Dates and times 3 columns
award_datedateDate when the contract or procurement was awarded.2024-01-20
contract_start_datedateStart date of the contract or delivery period.optional2024-02-01
contract_end_datedateEnd date of the contract or delivery period.optional2024-12-31
True or false 1 column
cost_saving_flagbooleanIndicates if this procurement resulted in a cost saving compared to previous benchmarks.optionaltrue

Use it for

  • cost saving fl…40%28 of 70 rowsmean unit price by co…24.3kcompli…7knon_co…51.5kpendin…

    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.

  • A software demo

    Believable procurements with agency_id, agency_name and supplier_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset70 rows28 columns
Yours10,000 rows28 columnssupplier_address_street: UK only

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.

Rules it was built with
  • All vendor payments are itemized
  • Expenditures over $50,000 require supervisory approval
  • Duplicate vendor entries are merged
  • Non-compliant purchases flagged for audit
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.