This expenditures dataset includes a listing and description of City-Parish department-level spending. Data is captured from January 1, 2018 to present as any data prior to this date resides in multiple disparate systems in various formats, which were subsequently streamlined through the implementation of the City-Parish's enterprise resource planning system financial module in late 2017. In an effort to protect certain information telephone numbers and account numbers are masked with X's. Also, the Check Number field only includes the last 4 digits of the check number.
This dataset has the following 55 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| YEAR | year | text | The year in which the expenditure was recorded. | 2018 2019 2023 2020 2021 view top 100 |
| FUND ID | fund_id | text | The numerical value of the fund utilized to pay the expenditure. | 7011 1000 5100 6000 2002 view top 100 |
| FUND | fund | text | The budgetary name of the fund utilized to pay the expenditure. | CITY COURT RECEIPTS SUSPENSE GENERAL FUND SEWERAGE-OPERATIONS & MAINT CENTRAL GARAGE-OPERATIONS LIBRARY BOARD OF CONTROL view top 100 |
| DEPARTMENT ID | department_id | text | The numerical value of the department under which the expenditure is authorized and recorded. | 0000 7700 7900 2600 1200 view top 100 |
| DEPARTMENT | department | text | The name of the department under which the expenditure is authorized and recorded. | OTHER ENVIRONMENTAL SERVICES FLEET MANAGEMENT CLERK OF COURT LIBRARY BOARD OF CONTROL view top 100 |
| FUNCTION ID | function_id | text | The numerical value of the function/purpose of the fund used to pay the expenditure. | 00 10 20 40 70 view top 100 |
| FUNCTION | function | text | The function/purpose of the fund used to pay the expenditure. | OTHER GENERAL GOVERNMENT EXPEND PUBLIC SAFETY EXPEND SANITATION EXPEND CONSERVATION & DEVELOPMENT EXP view top 100 |
| DIVISION ID | division_id | text | The numerical value of the division (within the department) under which the expenditure is authorized and recorded. | 0000 7710 7910 2600 1200 view top 100 |
| DIVISION | division | text | The name of the division (within the department) under which the expenditure is authorized and recorded. | OTHER ENV-SEWER DIVISION CENTRAL GARAGE OPER & MAINT CLERK-OPERATIONS LIBRARY-OPERATIONS view top 100 |
| PROGRAM ID | program_id | text | The numerical value of the program of the fund used to pay the expenditure. | 0000 2620 7742 7750 6021 view top 100 |
| PROGRAM | program | text | The program of the fund used to pay the expenditure. | OTHER CLK OF CT/JUROR & WITNESS FEES SEWER-PUMP STATION MAINTENANCE WASTEWATER TREATMENT REG HS OPERATIONS view top 100 |
| SUBPROGRAM ID | subprogram_id | text | The numerical value of the subprogram of the fund used to pay the expenditure. | 0000 YR21 YR20 YR18 YR19 view top 100 |
| SUBPROGRAM | subprogram | text | The subprogram of the fund used to pay the expenditure. | OTHER YEAR 2021 YEAR 2020 YEAR 2018 YEAR 2019 view top 100 |
| JOURNAL ENTRY PERIOD | journal_entry_period | text | The month in which the expenditure was recorded. | 12 3 4 6 5 view top 100 |
| INVOICE STATUS | invoice_status | text | Status of the invoice P = Paid or V = Voided | P V view top 100 |
| CHECK NUMBER | check_number | text | The numerical value of the check issued to pay the vendor for the expenditure. | 0 4807 2642 3298 6606 view top 100 |
| CHECK DATE | check_date | calendar_date | The date the check was issued to the vendor. | 2019-01-24T00:00:00.000 2020-06-23T00:00:00.000 2020-04-23T00:00:00.000 2018-07-31T00:00:00.000 2018-03-08T00:00:00.000 view top 100 |
| INVOICE NUMBER | invoice_number | text | The id associated with the vendor's invoice that itemizes justification for payment. | 1 072018CPERS 070618CPERS 070618FICA 042718CPERS view top 100 |
| LINE NUMBER | line_number | text | Line number of the specific expenditure for the corresponding invoice. | 1 2 3 4 5 view top 100 |
| INVOICE DATE | invoice_date | calendar_date | The date the invoice was issued to the City-Parish for processing and payment. | 2020-12-31T00:00:00.000 2019-12-31T00:00:00.000 2022-12-31T00:00:00.000 2021-12-31T00:00:00.000 2018-12-31T00:00:00.000 view top 100 |
| INVOICE LINE ITEM AMOUNT | invoice_line_item_amount | number | The total value requested for payment through the invoice. | 15 30 70 100 16 view top 100 |
| INVOICE LINE ITEM DESCRIPTION | invoice_line_item_description | text | A description of the specific expenditure for the corresponding invoice. | PAYROLL RUN 0 - WARRANT XXXXXX BOOKS AUTOMOTIVE AND TRAILER EQUIPME EQUIPMENT MAINTENANCE AND REPA BOOK view top 100 |
| SOURCE DOCUMENT NUMBER | source_document_number | text | The purchase order or contract number of the document used to procure the goods or services. | 800002307 800003093 800003410 800004983 800000047 view top 100 |
| SOURCE DOCUMENT TYPE | source_document_type | text | P = Purchase Order; C = Contract | P C view top 100 |
| SOURCE DOCUMENT DESCRIPTION | source_document_description | text | A description of the purchase order or contract. | A20-0401 FURNISHING AND CLEANING OF LINENS & MATS EQUIPMENT MAINTENANCE AND REPA AUTOMOTIVE AND TRAILER EQUIPME A20-0285 TIRE SERVICES FOR CITY OF BATON ROUGE OFFICE SUPPLIES GENERAL view top 100 |
| EXPENSE CATEGORY ID | expense_category_id | text | The numerical value of the expenditure type used to track and classify types of expenditures within the City-Parish financial system. | 250031 643500 642000 645125 642100 view top 100 |
| EXPENSE CATEGORY | expense_category | text | Description of the expenditure type. | CONSTABLE FEES & GARNISHMENTS OTHER CONTRACTUAL SERVICES ELECTRICITY & GAS JUROR COMPENSATION WATER/SEWER FEES view top 100 |
| PURCHASING DEPARTMENT ID | purchasing_department_id | text | ID indicating the department making the purchase | 7010 4120 1200 2010 0910 view top 100 |
| PURCHASING DEPARTMENT | purchasing_department | text | The department making the purchase | BUSINESS OPS-ADMINISTRATION FINANCE-ACCOUNTING LIBRARY CITY COURT AIRPORT-ADMINISTRATION view top 100 |
| COMMODITY CODE | commodity_code | text | Code classifying the type of good/service being purchased. | 060 928 910 985 615 view top 100 |
| COMMODITY DESCRIPTION | commodity_description | text | Description classifying the type of good/service being purchased. | EQUIPMENT MAINTENANCE AND REPA AUTOMOTIVE AND TRAILER EQUIPME BUILDING MAINTENANCE INSTALLA RENTAL OR LEASE SERVICES OF OF OFFICE SUPPLIES GENERAL view top 100 |
| PAYMENT TYPE | payment_type | text | Type of payment used to pay the vendor (Check, Wire or ACI (P-Cards)). | Check ACI Wire view top 100 |
| PAYMENT STATUS | payment_status | text | Status of payment (Cleared and Not Cleared). | Cleared Not Cleared view top 100 |
| VENDOR NAME 1 | vendor_name_1 | text | Vendor's primary business name | NEWMAN MATHIS BRADY & SPEDALE RICHARD D BANKSTON ENTERGY UTILITY PAYMENT PROCESSING EATON GROUP ATTORNEYS LLC view top 100 |
| VENDOR NAME 2 | vendor_name_2 | text | Vendor doing business as (DBA) name | NAPA AUTO PARTS REDS 24 HOUR TIRE SERVICE HOME DEPOT PRO NACO/SOUTH-PAYROLL PROCESSING LOUISIANA OFFICE SOLUTIONS CO view top 100 |
| VENDOR CITY | vendor_city | text | BATON ROUGE METAIRIE DENHAM SPRINGS DALLAS ATLANTA view top 100 | |
| VENDOR STATE | vendor_state | text | LA TX GA IL OK view top 100 | |
| VENDOR ZIP | vendor_zip | text | 70806 70806-3700 70821-2431 70802 70808 view top 100 | |
| VENDOR TYPE | vendor_type | text | Indicates the type of business the vendor is in | CONVERSION PROFESSION BENEFITS SUPPLIES CONTRACTSV view top 100 |
| GENDER | gender | text | NOT PROVIDED MALE FEMALE view top 100 | |
| ETHNICITY | ethnicity | text | ETHNICITY NOT SPECIFIED CAUCASIAN AMERICAN AFRICAN-AMERICAN ASIAN AMER/ASIAN PACIFIC AMER NATIVE AMERICAN INDIAN 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 S I B T view top 100 |
| CLASS | class | text | The vendor's classification (LLC, Corporation, Sole Proprietor, etc) | CORP LLC SOLE LLCS PSHP view top 100 |
| GEOGRAPHIC AREA | geographic_area | text | Geographic area of vendor (INP=In EBR Parish, INS=In State, USA=In Country, INTL=International | INP USA INS INTL view top 100 |
| INDEPENDENT CONTRACTOR | independent_contractor | text | N Y view top 100 | |
| MINORITY | minority | text | Is the vendor a minority business enterprise | N Y view top 100 |
| DISADVANTAGED | disadvantaged | text | Disadvantaged business enterprise | N Y view top 100 |
| DISABLED VETERAN | disabled_veteran | text | Disabled veteran business enterprise | N Y view top 100 |
| SB DISABLED VET | sb_disabled_vet | text | Small business disabled veteran | N Y view top 100 |
| SB MINORITY | sb_minority | text | Small business minority owned | N Y view top 100 |
| SB MINORITY WOMAN | sb_minority_woman | text | Small business minority woman owned | N Y view top 100 |
| SB NON-MINORITY | sb_non_minority | text | Small business non-minority owned | N Y view top 100 |
| SB DISADVANTAGED | sb_disadvantaged | text | Small business disadvantaged business enterprise | N Y view top 100 |
| SB VETERAN | sb_veteran | text | Small business veteran owned | N Y view top 100 |
| SB WOMAN | sb_woman | text | Small business woman owned | N Y view top 100 |