About this Dataset

Louisville Metro KY - Expenditures Data For Fiscal Year 2008

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 2008 to the present. A Fiscal Year starts July 1 and runs through June 30 of the given fiscal year. For example, Fiscal Year 2012 would include July 1, 2011 through June 30, 2012.

Data Dictionary:

Fiscal_Year - The fiscal year represents the timeframe in which goods are received or services are performed. Note: A fiscal year starts July 1 and runs through June 30 of the given year. For example, Fiscal Year 2012 would include July 1, 2011 through June 30, 2012.

Budget_Type - Whether the expenditures were due to capital or operational expenses.

Agency_Name - The agency group for which the expenditures belongs.

Sub_Agency_Name - The sub group of the agency group for which the expenditures belongs.

DepartmentName - The department group for which the expenditures belongs.

Sub_DepartmentName - The sub group of the department group for which the expenditures belongs.

Category - A breakdown of what the expenditures were for.

Sub_Category - A further more detailed breakdown of what the expenditures were for.

Stimulus_Type -

Funding_Source - The group which provided the funding.

Vendor_Name - The name of the vendor being paid.

InvoiceID - The invoice ID from the vendor.

InvoiceDt - The date of service as provided on the invoice from the vendor.

InvoiceAmt - The amount invoiced for payment by the vendor.

DistributionAmt - A breakdown of the accounting strings used to pay an invoice. Note: A single invoice amount could be split between more than one distribution.

CheckID - The ID number for the check distributed to the vendor which paid all or part of the invoice.

CheckDt - The date the check was issued to the vendor.

CheckAmt - The amount issued on the check to the vendor. Note: Sometimes a single check can be issued for multiple invoices. The check amount may then be larger than the invoice amount but the invoice amounts from all included invoices will add up to the total check amount.

CheckVoidDt - If applicable, the date a check was voided. Note: 1/1/1900 is the default value. If this is the value the check has not been voided.
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:17:04.150578
Tags: expenditure, expenses, fiscal-year, historical, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, office-of-management-and-budget, omb

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_expend_54f7e96a.table_1

3.46 MB
129,647 rows
20 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "budget_type" VARCHAR,
  "agency_name" VARCHAR,
  "sub_agency_name" VARCHAR,
  "departmentname" VARCHAR,
  "sub_departmentname" VARCHAR,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "stimulus_type" VARCHAR,
  "funding_source" VARCHAR,
  "vendor_name" VARCHAR,
  "invoiceid" BIGINT,
  "invoicedt" VARCHAR,
  "invoiceamt" DOUBLE,
  "distributionamt" DOUBLE,
  "checkid" BIGINT,
  "checkdt" VARCHAR,
  "checkamt" DOUBLE,
  "checkvoiddt" VARCHAR,
  "objectid" BIGINT
);