Louisville Metro KY - Expenditures Data For Fiscal Year 2023 by US Government | Finance and Economics

About this Dataset

Louisville Metro KY - Expenditures Data For Fiscal Year 2023

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:

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: 2023-04-13T13:28:43.097401
Tags: expenditure, expenses, fiscal-year, 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_275209f3.table_1

2.82 MB
109206 rows
20 columns


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
);