Listing of all annual contracts issued to procure goods and/or services within City-Parish.
This dataset has the following 46 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
RECORD TYPE | record_type | text | H or D. H indicates record is a header record. D indicates a detail record. An annual contract will have 1 header record and at least 1 detail item | D H view top 100 |
DOCUMENT NUMBER | document_number | text | Numeric ID of the annual contract | 800004756 800004547 800004623 800005170 800004350 view top 100 |
DOCUMENT DESCRIPTION | document_description | text | Description of the annual contract | A22-0415 Pest Control Services A22-0502 BLUE PRINT SERVICES & SUPPLIES A22-0617 Aluminum Sign Blanks GROUPS 1 - 11 & 14 A23-0606 for FIREFIGHTING HELMETS and BOOTS A21-0799 LS Maint/Litter Pick Up - Groups 9-10 view top 100 |
REQUISITION NUMBER | requisition_number | text | Requisition number used for purchase | 15085 15072 15053 15064 view top 100 |
PURCHASE ORDERS | purchase_orders | text | The purchase orders used against this contract | view top 100 |
INPUT DATE | input_date | calendar_date | Date annual contract was entered into the system | 2024-05-14T00:00:00.000 2024-05-13T00:00:00.000 2024-05-09T00:00:00.000 2024-05-10T00:00:00.000 view top 100 |
DEPARTMENT NUMBER | department_number | text | Number of the department which the annual contract is for | 4500 view top 100 |
DEPARTMENT NAME | department_name | text | Department name which the annual contract is for | PURCHASING view top 100 |
COST CENTER | cost_center | text | Cost Center of the Department which the annual contract is for. This will often show which of the Department's Divisions issued the annual contract | 4500 view top 100 |
COST CENTER NAME | cost_center_name | text | Description of Cost Center of the Department which the annual contract is for. This will often show which of the Department's Divisions issued the annual contract | PURCHASING view top 100 |
DOCUMENT STATUS CODE | document_status_code | text | Code indicating the status of the annual contract. | 8 view top 100 |
DOCUMENT STATUS DESCRIPTION | document_status_description | text | Description of the status of the annual contract. | Posted view top 100 |
VOUCHED AMOUNT | vouched_amount | number | Actual amount invoiced against annual contract. This amount may be less than the original annual contract amount. | 5714.91 60423.94 68794 85146.8 466500.1 view top 100 |
START DATE | start_date | calendar_date | Estimated date for work to begin | 2022-06-01T00:00:00.000 2022-03-01T00:00:00.000 2022-11-01T00:00:00.000 2023-04-01T00:00:00.000 view top 100 |
EXPIRATION DATE | expiration_date | calendar_date | Expected date for work to end | 2023-05-31T00:00:00.000 2023-02-28T00:00:00.000 2023-10-31T00:00:00.000 2024-03-31T00:00:00.000 view top 100 |
EXTENSION DATE | extension_date | calendar_date | Date contract has been extended | 2025-05-31T00:00:00.000 2024-10-31T00:00:00.000 2025-02-28T00:00:00.000 2025-03-31T00:00:00.000 view top 100 |
TOTAL ITEMS | total_items | number | Total number of detail items on annual contract. Each annual contract will have at least 1 detail item. Not applicable for D records, as there is only one item for each D record. | 1 47 89 162 80 view top 100 |
ITEM NUMBER | item_number | number | Sequential number of the detail annual contract line item. | 1 2 0 36 14 view top 100 |
ITEM DESCRIPTION | item_description | text | Description of good or service being ordered on this annual contract line item. | ITEM 0010 TSA BLDG 9191 PLANK RD BATON ROUGE LA 70811 ITEM 0051 EM11 8140 YMCA PLAZA DRIVE BATON ROUGE LA 70810 BLANKS SIGN METAL 42 X 18 BLANKS SIGN METAL 24 X 24 SQUARE ITEM 0019 JONES CREEK BRANCH 6222 JONES CREEK ROAD BATON ROUGE LA 70817 view top 100 |
ITEM QUANTITY | item_quantity_ordered | text | Maximum item quantity that can be procured on this contract | 1.00 25.00 200.00 10.00 5.00 view top 100 |
ITEM UNIT COST | item_unit_cost | number | Code classifying the type of good/service being purchased. | 0.006 0.00205 398 220 57 view top 100 |
ITEM UNIT OF MEASURE | item_unit_of_measure | text | Code indicating Unit of Measure for this annual contract line item. | EACH SQUA ROLL BOOK MEG view top 100 |
COMMODITY CODE | commodity_code | text | Code classifying the type of good/service being purchased. | 91059 80109 20372 34034 96214 view top 100 |
COMMODITY DESCRIPTION | commodity_description | text | Description classifying the type of good/service being purchased. | PEST CONTROL SERVICES: TERMITE BLANKS, SIGN, METAL (SEE 801-7 FIRE PROTECTION CLOTHING: TURN PRINTER ACCESSORIES AND SUPPLI BLUE PRINTING SERVICES: BLUE P view top 100 |
VENDOR NAME 1 | vendor_name_1 | text | Vendor's primary business name | BAY PEST CONTROL COMPANY INC ARC DOCUMENT SOLUTIONS LLC VULCAN INC BGS LLC H & O INVESTMENTS LLC view top 100 |
VENDOR NAME 2 | vendor_name_2 | text | VULCAN ALUMINUM, VULCAN SIGNS view top 100 | |
VENDOR CITY | vendor_city | text | OCEAN SPRINGS CINCINNATI FOLEY GONZALES BATON ROUGE view top 100 | |
VENDOR STATE | vendor_state | text | MS OH AL LA view top 100 | |
VENDOR ZIP | vendor_zip | text | 39564 45264-5913 36536-1850 70737 70817 view top 100 | |
VENDOR TYPE | vendor_type | text | Indicates the type of business the vendor is in | PROFESSION PRINTING CONVERSION view top 100 |
GENDER | gender | text | MALE NOT PROVIDED view top 100 | |
ETHNICITY | ethnicity | text | CAUCASIAN AMERICAN ETHNICITY NOT SPECIFIED view top 100 | |
STATUS | status | text | Vendor's status A=Active, B=Bidder, I=Inactive, O=One Time Pay, S=Stop, T=Temporary, S=Self Service | A view top 100 |
CLASS | class | text | The vendor's classification (LLC, Corporation, Sole Proprietor, etc) | CORP LLCC LLCS view top 100 |
GEOGRAPHIC AREA | geographic_area | text | Geographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International | USA INS view top 100 |
INDEPENDENT CONTRACTOR | independent_contractor | text | Whether or not the vendor is an independent contractor | N view top 100 |
MINORITY | minority | text | Is the vendor a minority business enterprise | N view top 100 |
DISADVANTAGED | disadvantaged | text | Disadvantaged business enterprise | N view top 100 |
DISABLED VETERAN | disabled_veteran | text | Disabled veteran business enterprise | N view top 100 |
SB DISABLED VET | sb_disabled_vet | text | Small business disabled veteran | N view top 100 |
SB MINORITY | sb_minority | text | Small business minority owned | N view top 100 |
SB MINORITY WOMAN | sb_minority_woman | text | Small business minority woman owned | N view top 100 |
SB NON-MINORITY | sb_non_minority | text | Small business non-minority owned | N view top 100 |
SB DISADVANTAGED | sb_disadvantaged | text | Small business disadvantaged business enterprise | N view top 100 |
SB VETERAN | sb_veteran | text | Small business veteran owned | N view top 100 |
SB WOMAN | sb_woman | text | Small business woman owned | N view top 100 |