Public Procurement Transparency Logs
This dataset provides detailed, transaction-level logs of government agency procurement events, including contract values, supplier diversity indicators, compliance status, and financial transaction details. Designed to support transparency, anti-corruption efforts, and operational efficiency, it enables robust analysis of public sector spending patterns and supplier engagement for oversight agencies and nonprofit watchdogs.
Sample rows
preview · 8 of 120 rows · all 27 columns| procurement_idstring | compliance_statusstring | contract_valuefloat | currencystring | agency_idstring | agency_namestring | procurement_titlestring | procurement_typestring | procurement_methodstring | procurement_statusstring | publication_datedate | closing_datedate | award_datedate | supplier_idstring | supplier_namestring | supplier_diversity_indicatorstring | supplier_countrystring | transaction_idstring | transaction_datedate | transaction_amountfloat | transaction_currencystring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | procurement_descriptionstring | compliance_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRC-00001 | compliant | 480000 | USD | AGY-001 | Department of Health Services | Medical Equipment Acquisition | goods | open_tender | awarded | 2023-02-15 | 2023-03-10 | 2023-03-25 | SUP-1011 | Baxter Healthcare Corp | none | USA | TXN-00001 | 2023-03-27 | 480000 | USD | 1452 Elm Drive | Chicago | IL | 60610 | Procurement of ventilators and related medical devices for state hospitals. | All regulatory checks complete. No issues found. |
| PRC-00002 | compliant | 310000.5 | USD | AGY-002 | National Transportation Board | Railway Track Maintenance Contract | services | limited_tender | awarded | 2023-01-20 | 2023-02-05 | 2023-02-28 | SUP-1051 | Norfolk Maintenance Group | minority_owned | USA | TXN-00002 | 2023-03-02 | 310000.5 | USD | 425 Oak Avenue | Norfolk | VA | 23510 | Annual maintenance of urban rail tracks in metropolitan region. | Supplier diversity compliance confirmed. |
| PRC-00003 | compliant | 75430 | GBP | AGY-003 | Ministry of Science & Technology | Cloud Computing Services | services | direct_award | awarded | 2023-03-18 | blank | 2023-03-25 | SUP-2021 | Azure Solutions Ltd | none | UK | TXN-00003 | 2023-03-27 | 75430 | GBP | 32 Queen's Street | London | LND | SW1A 1AA | Cloud infrastructure setup for research data and analytics. | Data protection compliance verified. |
| PRC-00004 | compliant | 120000 | USD | AGY-004 | City Council of Dallas | Community Park Construction | works | open_tender | awarded | 2022-11-01 | 2022-11-20 | 2022-12-05 | SUP-3011 | GreenScape Builders Inc | women_owned | USA | TXN-00004 | 2022-12-10 | 120000 | USD | 2109 Main Street | Dallas | TX | 75201 | Construction of new community park in the Oak Cliff district. | blank |
| PRC-00005 | compliant | 15000 | USD | AGY-003 | Ministry of Science & Technology | Laboratory Equipment Purchase | goods | open_tender | awarded | 2023-02-05 | 2023-02-19 | 2023-03-07 | SUP-3081 | LabTech Scientific LLC | small_business | USA | TXN-00005 | 2023-03-11 | 15000 | USD | 847 Innovation Dr | San Diego | CA | 92121 | Procurement of advanced microscopes and lab supplies for research centers. | Small business certification provided. |
| PRC-00006 | compliant | 48000 | CAD | AGY-005 | Education Board of Ontario | Textbook Supply for Schools | goods | request_for_quotation | awarded | 2023-01-11 | 2023-01-25 | 2023-02-04 | SUP-4011 | Canadian Education Supply | none | CAN | TXN-00006 | 2023-02-06 | 48000 | CAD | 51 Queen St E | Toronto | ON | M5C 1S2 | Procurement of mathematics and science textbooks for high school students. | blank |
| PRC-00007 | pending_review | blank | blank | AGY-002 | National Transportation Board | Traffic Signal Upgrade | goods | open_tender | open | 2024-03-10 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | Upgrade of city-wide traffic signals with smart technology. | blank |
| PRC-00008 | pending_review | blank | blank | AGY-001 | Department of Health Services | COVID-19 Testing Kits | goods | request_for_quotation | planned | 2024-04-05 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | Purchase of rapid COVID-19 testing kits for emergency response. | blank |
| PRC-00009 | compliant | 270000 | USD | AGY-006 | National Security Administration | Advanced Surveillance Systems | goods | limited_tender | awarded | 2023-04-10 | 2023-04-25 | 2023-05-10 | SUP-5011 | OmniVision Security | none | USA | TXN-00007 | 2023-05-15 | 270000 | USD | 9957 Security Blvd | Baltimore | MD | 21244 | Procurement of surveillance cameras and monitoring software. | blank |
| PRC-00010 | compliant | 100000 | USD | AGY-004 | City Council of Dallas | Road Paving Project | works | open_tender | awarded | 2022-09-10 | 2022-09-30 | 2022-10-20 | SUP-3021 | Urban Paving Solutions | veteran_owned | USA | TXN-00008 | 2022-10-25 | 100000 | USD | 875 Pioneer Rd | Dallas | TX | 75208 | Paving and resurfacing of main city roads for urban development. | Veteran-owned business certification provided. |
| PRC-00011 | compliant | 999.99 | CAD | AGY-005 | Education Board of Ontario | Digital Learning Platform Subscription | services | direct_award | awarded | 2023-05-12 | blank | 2023-06-01 | SUP-4021 | EduTech Canada | none | CAN | TXN-00009 | 2023-06-03 | 999.99 | CAD | 104 King St W | Toronto | ON | M5H 1P1 | Annual subscription to digital learning platforms for Ontario schools. | Small value contract for pilot program. |
| PRC-00012 | non_compliant | blank | blank | AGY-001 | Department of Health Services | Hospital Sanitation Services | services | limited_tender | closed | 2023-01-22 | 2023-02-05 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | Contract for hospital sanitation and janitorial services. | Bid closed due to insufficient submissions. |
| PRC-00013 | pending_review | blank | blank | AGY-006 | National Security Administration | IT Security Audit | services | request_for_quotation | planned | 2024-05-18 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | Comprehensive cybersecurity audit for government IT assets. | blank |
| PRC-00014 | compliant | 500000 | USD | AGY-002 | National Transportation Board | Bus Fleet Expansion | goods | open_tender | awarded | 2023-06-01 | 2023-06-20 | 2023-07-10 | SUP-1052 | EV Motors Inc | none | USA | TXN-00010 | 2023-07-12 | 500000 | USD | 2137 Electric Ave | Detroit | MI | 48226 | Purchase of electric buses for public transportation expansion. | Technical specifications met. |
| PRC-00015 | compliant | 99999999.99 | USD | AGY-001 | Department of Health Services | Ambulance Procurement | goods | limited_tender | awarded | 2023-08-12 | 2023-09-01 | 2023-09-21 | SUP-1071 | US Ambulance Works | none | USA | TXN-00011 | 2023-09-23 | 99999999.99 | USD | 1001 Rescue Rd | Houston | TX | 77001 | Acquisition of ambulances for emergency medical services. | Outlier contract value for state-wide fleet. |
| PRC-00016 | compliant | 1 | EUR | AGY-003 | Ministry of Science & Technology | Genomic Sequencing Services | services | direct_award | awarded | 2023-08-03 | blank | 2023-08-20 | SUP-2051 | BioGene Europe | minority_owned | FRA | TXN-00012 | 2023-08-22 | 1 | EUR | 56 Rue Lafayette | Paris | IDF | 75009 | Sequencing of samples for national health research program. | Pilot contract for research startup. |
| PRC-00017 | pending_review | blank | blank | AGY-004 | City Council of Dallas | Waste Management Service Contract | services | open_tender | closed | 2023-02-15 | 2023-03-05 | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | Outsourcing waste collection and disposal for city districts. | Awaiting final review from council. |
| PRC-00018 | compliant | 1 | JPY | AGY-006 | National Security Administration | Secure Communication Devices | goods | limited_tender | awarded | 2023-05-05 | 2023-05-21 | 2023-06-05 | SUP-5031 | Nippon Electronics Inc | none | JPN | TXN-00013 | 2023-06-07 | 1 | JPY | 8-17 Akasaka | Tokyo | TKY | 107-0052 | Procurement of encrypted communication devices for field agents. | Pilot project for device testing. |
| PRC-00019 | compliant | 31000.5 | CAD | AGY-005 | Education Board of Ontario | School Bus Maintenance | services | request_for_quotation | awarded | 2023-04-01 | 2023-04-15 | 2023-05-02 | SUP-4031 | FleetCare Ontario | small_business | CAN | TXN-00014 | 2023-05-04 | 31000.5 | CAD | 620 Fleet St | Ottawa | ON | K1Y 3B7 | Annual maintenance contract for school bus fleet. | blank |
| PRC-00020 | compliant | 3000000 | USD | AGY-002 | National Transportation Board | Railcar Refurbishment | works | limited_tender | awarded | 2023-10-01 | 2023-10-21 | 2023-11-05 | SUP-1061 | Refurb Rail Systems | none | USA | TXN-00015 | 2023-11-08 | 3000000 | USD | 882 Industrial Way | Pittsburgh | PA | 15222 | Refurbishment of aging railcars for improved safety standards. | blank |
What the 120 rows show
from the 120-row sample- 135,000median contract_
value - 4procurement types
- 4procurement methods
- 5procurement statuses
- 5transaction currencies
- 6supplier diversity indicators
Median 135,000, from 1.0 to 100,000,000.
- string 21
- float 2
- date 4
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
procurement_id | string | Unique identifier for each procurement eventunique | PRC-00001 |
agency_id | string | Unique identifier for the government agency conducting the procurement | AGY-001 |
agency_name | string | Name of the government agency | City Council of Dallas |
procurement_title | string | Short descriptive title of the procurement event | Cloud Computing Services |
procurement_description | string | Detailed description of the procurement eventoptional | Procurement of ventilator… |
procurement_type | string | Type of procurement (e.g., goods, services, works)goods · services · works · other | goods |
procurement_method | string | Method used for procurement (e.g., open tender, direct award, request for quotation)5 values | open_tender |
procurement_status | string | Current status of the procurement eventplanned · open · closed · awarded · cancelled | awarded |
currency | string | Currency code for contract value (e.g., USD, EUR)5 currencies · optional | USD |
supplier_id | string | Unique identifier for the awarded supplieroptional | SUP-1011 |
supplier_name | string | Name of the awarded supplieroptional | Baxter Healthcare Corp |
supplier_diversity_indicator | string | Indicator of supplier diversity status (e.g., minority-owned, women-owned, veteran-owned, none)6 values · optional | none |
supplier_country | string | Country where the supplier is registered6 countries · optional | USA |
compliance_status | string | Status indicating whether the procurement event met all compliance requirementscompliant · non_compliant · pending_review | compliant |
compliance_notes | string | Additional notes or findings from compliance reviewoptional | Small business pilot. |
transaction_id | string | Unique identifier for the financial transaction related to the procurement eventunique · optional | TXN-00001 |
transaction_currency | string | Currency code for transaction amount5 currencies · optional | USD |
address_street | string | Street address of the awarded supplieroptional | 1452 Elm Drive |
address_city | string | City of the awarded supplieroptional | Chicago |
address_state | string | State or province of the awarded supplieroptional | IL |
address_postal_code | string | Postal code of the awarded supplieroptional | 60610 |
| Numbers 2 columns | |||
contract_value | float | Total value of the awarded contract in local currency0 or more · optional | 480000 |
transaction_amount | float | Amount of the financial transaction in local currency0 or more · optional | 480000 |
| Dates and times 4 columns | |||
publication_date | date | Date when the procurement event was published | 2023-02-15 |
closing_date | date | Date when the procurement event closed for submissionsoptional | 2023-03-10 |
award_date | date | Date when the contract was awardedoptional | 2023-03-25 |
transaction_date | date | Date when the financial transaction occurredoptional | 2023-03-27 |
Use it for
A government dashboard
Contract_
value by compliance_ status and a breakdown of currency. Excel, Power BI or Tableau. What pattern can you find in 120 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 120 rows.
- Procurements120PRC-00001480000compliantPRC-00002310000.5compliantPRC-0000375430compliant
A software demo
Believable procurements with agency_
id, agency_ name and procurement_ title to fill a screen in front of a buyer.
blueprint · public-procurement-transparency-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 27 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.
- Each row represents a unique procurement transaction.
- Includes agency, supplier name, contract value, compliance flag, and purpose.
- Flag transactions lacking competitive bidding for review.
- Tag supplier diversity status (minority-owned, local, etc).
- Track date and procurement method (RFQ, RFP, direct award).
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
- public-procurement-transparency-logs