East Baton Rouge Contracts - Vendor Diversity & Line Items avatar

East Baton Rouge Contracts - Vendor Diversity & Line Items

Pricing

from $0.03 / 1,000 east baton rouge purchase order / contract records

Go to Apify Store
East Baton Rouge Contracts - Vendor Diversity & Line Items

East Baton Rouge Contracts - Vendor Diversity & Line Items

East Baton Rouge Parish purchase orders and contracts (~92,200 documents, $3.4bn): who won what, from which department, for how much, plus each vendor's diversity classification and the line items behind any document.

Pricing

from $0.03 / 1,000 east baton rouge purchase order / contract records

Rating

0.0

(0)

Developer

Wenhao Yang

Wenhao Yang

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

2 hours ago

Last modified

Categories

Share

East Baton Rouge Contracts - Purchase Orders, Vendors & Diversity

Every purchase order and contract the City of Baton Rouge and East Baton Rouge Parish have issued, straight from the City-Parish's own open data portal. ~92,200 documents totalling ~$3.39bn, with ~341,600 rows including the line items behind them (measured 2026-09-28), from 2002 to this week - and growing weekly, because this is a live feed.

Low cost

From $0.00005 per record, down to $0.00003 at Gold. Pay only for the records you actually receive - the whole register stays queryable, you are never billed for the scan behind it.

What you get

  • Which document - the document number, the type (Public Works, Professional Services, General, Blanket, Lease, RFP/Bid, ), the kind (purchase order or contract) and the status, plus the requisition it came from
  • Who - the vendor name, its address, and the vendor's class, type and status
  • How much - the document total, the amount actually vouched, and the item count
  • Which department - the buying department and the cost centre, both by name and by number
  • When - the document date, plus the contract's start, expiration and extension dates where it has them
  • The supplier's diversity classification - eleven clean Y/N flags: minority-owned, disadvantaged (DBE), disabled-veteran, small-disabled-veteran and independent-contractor, plus the small-business variants for minority, minority-woman, disadvantaged, veteran, woman and non-minority - and the vendor's gender and ethnicity where the Parish records them
  • The line items - for each document, the item description, quantity, unit of measure, unit cost and total cost, with the commodity code and description and the expense type

Modes

  • documents (default) - one row per purchase order or contract
  • lines - one row per line item behind those documents
  • aggregate - counts by department, document type, document status, vendor state or vendor class

Filters

Document number, requisition number, vendor name, department, cost centre, document type, status, vendor class / state / city, commodity code, item description, an amount range, a true document-date range, and all eleven vendor-diversity flags (each takes Y, N or blank).

Example inputs

Large public-works awards

{ "documentType": "Public Works", "minAmount": 1000000, "maxResults": 25 }

Minority-owned vendor awards this year

{ "minorityOwned": "Y", "inputFrom": "2026-01-01", "maxResults": 50 }

Woman-owned small business, in one department

{ "smallWomanOwned": "Y", "department": "TRAN" }

Everything one vendor has been awarded

{ "vendorName": "GRAINGER", "maxResults": 100 }

The line items behind one contract

{ "documentNumber": "800007099", "mode": "lines" }

Spend by department

{ "mode": "aggregate", "groupBy": "department" }

Example output

One contract header - documentNumber=800007099, mode=documents:

{
"platform": "ebr-contracts",
"source": "east-baton-rouge-parish-contracts",
"mode": "documents",
"recordType": "document",
"groupKey": "",
"groupCount": "",
"groupBy": "",
"recordKind": "H",
"documentNumber": "800007099",
"documentType": "Public Works",
"documentKind": "C",
"documentTypeCode": "13",
"documentStatus": "Posted",
"documentStatusCode": "8",
"description": "PLANK RD CORRIDOR SEG 2-DAWSON DR-HARDING)",
"requisitionNumber": "1943",
"inputDate": "2026-09-25",
"totalAmount": "2571147.43",
"vouchedAmount": "1389033.8",
"annualContractRef": "",
"totalItems": "3",
"estimatedStartDate": "2025-06-06",
"initialExpirationDate": "2026-04-14",
"extendedThroughDate": "2026-05-10",
"departmentNumber": "7120",
"department": "TRAN & DRAIN",
"costCenter": "7120",
"costCenterName": "ENGINEERING",
"vendorName": "COMMAND CONSTRUCTION INDUSTRIES LLC",
"vendorName2": "",
"vendorCity": "METAIRIE",
"vendorState": "LA",
"vendorZip": "70002",
"vendorType": "CONVERSION",
"vendorStatus": "A",
"vendorClass": "",
"vendorGender": "FEMALE",
"vendorEthnicity": "ETHNICITY NOT SPECIFIED",
"vendorGeographicCode": "INS",
"minorityOwned": "N",
"disadvantagedOwned": "Y",
"disabledVeteranOwned": "N",
"smallDisabledVeteran": "N",
"smallMinorityOwned": "N",
"smallMinorityWomanOwned": "N",
"smallDisadvantagedOwned": "N",
"smallVeteranOwned": "N",
"smallWomanOwned": "Y",
"smallNonMinorityOwned": "N",
"independentContractor": "N",
"itemNumber": "0",
"itemDescription": "",
"itemQuantity": "",
"itemUnitOfMeasure": "",
"itemUnitCost": "",
"itemTotalCost": "",
"commodityCode": "",
"commodityDescription": "",
"expenseType": "",
"expenseTypeDescription": "",
"sourceUpdatedAt": "2026-09-27"
}

A line item - the same document, mode=lines. The key set is identical to the row above; the header-only fields come back empty and the item fields are filled:

{
"mode": "lines",
"recordType": "line",
"recordKind": "D",
"documentNumber": "800007099",
"documentType": "Public Works",
"itemNumber": "1",
"itemDescription": "**PER RESOLUTION 58599 PLANK ROAD CORRIDOR ENHANCEMENT **",
"itemQuantity": "1",
"itemUnitOfMeasure": "JOB",
"itemUnitCost": "2257313.5",
"itemTotalCost": "2257313.5",
"commodityCode": "91327",
"commodityDescription": "CONSTRUCTION, HIGHWAY AND ROAD",
"totalAmount": "0",
"totalItems": "1",
"vouchedAmount": "",
"vendorName": "COMMAND CONSTRUCTION INDUSTRIES LLC",
"disadvantagedOwned": "Y",
"smallWomanOwned": "Y"
}

mode=aggregate, groupBy=department - one count row per department:

FLEET 32,324
ENV SERV 11,273
BLDG&GROUND 7,029
BUSINESS OPS 5,668
EMS 5,665
DHDS 4,532
POLICE 4,028

Notes on the data, from the source

  • This table is two grains in one, and the actor never mixes them. The rows marked H are the document headers; the ones marked D are the line items. Measured at ~92,200 headers against ~249,400 detail rows, the header count equals the distinct document count exactly - there is one header per document and never two - and the detail rows cover all but about 20 of those documents. mode=documents serves the headers (what you mean by "a contract") and mode=lines serves the items.
  • The money does not overlap between the two grains. totalAmount is the document total and carries a value on header rows only - on every detail row it is exactly 0, and a line's own money is in itemTotalCost. Reading the two together would double-count or zero out depending on the row, so minAmount / maxAmount filter the document total on the header grain.
  • About $3.39bn of documents, $1.75bn vouched (measured 2026-09-28). No header carries a negative amount; a few dozen are exactly zero.
  • A requisition is usually released as several documents. The documents hang off roughly 18,200 distinct requisitions.
  • The diversity flags count documents, not line items. A detail row repeats its document's flags, so the whole-table counts run 2-5x higher than the document counts - 2,405 woman-owned small-business documents against 8,540 flag-carrying rows. Every figure quoted here and in the input descriptions is the document (header) count, which is what this actor's default mode returns: 2,557 minority-owned, 1,009 disadvantaged, 24 disabled-veteran, 1,060 small-minority, 1,674 small-minority-woman, 440 small-disadvantaged, 574 small-veteran, 2,405 small-woman, 82 small-non-minority and 3,247 independent-contractor documents.
  • The vendor profile is not complete, and the gaps are normal. The vendor class is on about 48% of documents, gender on 29%, ethnicity on 34% and the geographic code on 57% - they exist only for vendors with a profile on file. Blank means "not recorded", not "not applicable".
  • annualContractRef is a document number, not a yes/no flag despite the source's column name ("ANNUAL CONTRACT"). Populated on roughly 12,870 documents, it names the annual contract the order draws against. It is carried but is not offered as a filter, because it is an opaque number a caller cannot know in advance.
  • The contract-term dates exist only for contracts proper, not for ordinary purchase orders: of the ~92,200 documents this actor returns, 3,961 carry a start date, 3,885 an initial-expiration date and 515 an extension date - about 4.3%, 4.2% and 0.6% of documents (1.16%, 1.14% and 0.15% of all 341,621 rows). The document date (inputDate, 2002-07-12 to today) is the one date on every row, and the only date range offered as a filter.
  • A handful of documents carry no vendor name and no diversity flag (6 rows measured 2026-09-28); one header has no department.
  • The source spreads the document type over three columns - a one-letter kind (P purchase order / C contract), a short code, and a readable label. The readable label is what documentType returns and what the filter matches, so the field and the filter mean the same thing; the letter and code are carried alongside as documentKind and documentTypeCode.
  • Invalid filter inputs (a % in a search, a non-numeric document number, a flag that is not Y or N, a malformed date) are rejected rather than passed to the source.

Coverage and freshness

East Baton Rouge Parish purchase orders and contracts, kept current by the City-Parish on a live feed - a new document lands within days, so counts quoted here are a dated snapshot rather than a fixed total. The newest document date at the time of writing was 2026-09-26. Every record carries sourceUpdatedAt; the actor also carries a count guard, a whole-corpus field-coverage guard and a grain guard that verifies the one-header-per-document assumption on every default run, so a source that collapses or changes shape fails loudly instead of returning an empty page as success.