Louisville Metro KY - Expenditures Data For Fiscal Year 2025
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_expend_ab169025
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_expend_ab169025
This dataset includes all expenditures by agency, with additional data including funding source, vendor name, and amount invoiced. The dates for this dataset run from Fiscal Year 2025 to the present. A Fiscal Year starts July st1 and runs through June 30 of the given fiscal year. For example, Fiscal Year 2015 would include July 1, 2024 through June 30, 2025. This data is updated weekly
Note: An issue with the display of data was identified and has been corrected. Data viewed or extracted before September 30th, 2024 may contain inaccuracies.
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:48.121811 | |
| 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" TIMESTAMP,
"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.