Louisville Metro KY - Expenditures Data For Fiscal Year 2024
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_expend_37d198ed
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_expend_37d198ed
This dataset includes all expenditures by agency, with additional data including funding source, vendor name, and amount invoiced. The dates for this dataset are for Fiscal Year 2024. A Fiscal Year starts July 1 and runs through June 30 of the given fiscal year. For example, Fiscal Year 2024 would include July 1, 2023 through June 30, 2024.
**Data Dictionary: **
| Field Name | Description |
|---|---|
| Fiscal_Year | fiscal year of the date of payment |
| Invoice_date | Date listed on the invoice received |
| Invoice_Number | Unique identifier used on the invoice |
| Invoice_Amount | Amount invoiced by the supplier |
| Payee | Recipient of payment amount |
| Payment_Date | Date of transaction or date check printed |
| Payment_Number | Transaction ID or check number |
| Extended_Amount | dollar amount paid to payee |
| Expenditure_Type | budget type (Operating or Capital) |
| Fund | funding source for the expense |
| Financing_Source | identifies the funding source (ex. debt funded, forfeiture funds, agency receipts, etc.); a subset of capital expenses |
| Agency | agency or department who purchased product or service |
| Cost Center | unit within a department the expenses are charged; a subset of the agency |
| Expenditure_Category | broad grouping of expenditures |
| Spend_Category | subcategory of the broad grouping of expenditures |
| Project | optional tag used to identify related expenses |
| Program | optional tag used to identify related expenses |
| Grant | optional tag used to identify funding from external resources |
| Region | council district |
| Organization: Louisville Metro Government | |
| Last updated: 2025-07-30T14:10:54.737476 | |
| Tags: expenditure, expenses, fiscal-year, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, office-of-management-and-budget, omb, updated-weekly |
CREATE TABLE table_1 (
"fiscal_year" BIGINT,
"invoice_date" VARCHAR,
"invoice_number" VARCHAR,
"invoice_amount" DOUBLE,
"payee" VARCHAR,
"payment_date" TIMESTAMP,
"payment_number" VARCHAR,
"agency" VARCHAR,
"expenditure_type" VARCHAR,
"expenditure_category" VARCHAR,
"spend_category" VARCHAR,
"cost_center" VARCHAR,
"project" VARCHAR,
"program" VARCHAR,
"grant" VARCHAR,
"fund" VARCHAR,
"financing_source" VARCHAR,
"region" VARCHAR,
"extended_amount" DOUBLE,
"objectid" BIGINT
);Anyone who has the link will be able to view this.