Louisville Metro KY - Expenditures Data For Fiscal Year 2020
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 NameDescriptionFiscal_Yearfiscal year of the date of paymentInvoice_dateDate listed on the invoice receivedInvoice_NumberUnique identifier used on the invoice Invoice_AmountAmount invoiced by the supplierPayeeRecipient of payment amountPayment_DateDate of transaction or date check printedPayment_NumberTransaction ID or check numberExtended_Amountdollar amount paid to payeeExpenditure_Typebudget type (Operating or Capital)Fundfunding source for the expenseFinancing_Sourceidentifies the funding source (ex. debt funded, forfeiture funds, agency receipts, etc.); a subset of capital expensesAgencyagency or department who purchased product or serviceCost Centerunit within a department the expenses are charged; a subset of the agencyExpenditure_Categorybroad grouping of expendituresSpend_Categorysubcategory of the broad grouping of expendituresProjectoptional tag used to identify related expensesProgramoptional tag used to identify related expensesGrantoptional tag used to identify funding from external resourcesRegioncouncil district
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"010:04",
"010:86"
]
|
| contactPoint |
{
"fn": "LouisvilleMetro",
"@type": "vcard:Contact",
"hasEmail": "mailto:opendata@louisvilleky.gov"
}
|
| culture | en-us |
| description | <span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>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.</span><div><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'><br /></span></div><div><span style='color:rgb(0, 0, 128); font-family:Lato; font-size:16px;'>Data Dictionary:</span> </div><div><table border='0' cellpadding='0' cellspacing='0' style='width:665pt; border-collapse:collapse;' width='887'><tbody><tr style='height:15pt;'><td style='width:110pt; background:rgb(255, 192, 0); padding:0in 5.4pt; height:15pt;' valign='bottom' width='147'><p><b><span style='color:black;'>Field Name</span></b></p></td><td style='width:555pt; background:rgb(255, 192, 0); padding:0in 5.4pt; height:15pt;' valign='bottom' width='740'><p><b><span style='color:black;'>Description</span></b></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Fiscal_Year</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>fiscal year of the date of payment</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Invoice_date</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Date listed on the invoice received</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Invoice_Number</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Unique identifier used on the invoice </font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Invoice_Amount</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Amount invoiced by the supplier</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Payee</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Recipient of payment amount</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Payment_Date</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Date of transaction or date check printed</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Payment_Number</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>Transaction ID or check number</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Extended_Amount</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>dollar amount paid to payee</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Expenditure_Type</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>budget type (Operating or Capital)</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Fund</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>funding source for the expense</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Financing_Source</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>identifies the funding source (ex. debt funded, forfeiture funds, agency receipts, etc.); a subset of capital expenses</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Agency</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>agency or department who purchased product or service</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Cost Center</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>unit within a department the expenses are charged; a subset of the agency</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Expenditure_Category</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>broad grouping of expenditures</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Spend_Category</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>subcategory of the broad grouping of expenditures</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Project</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>optional tag used to identify related expenses</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Program</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>optional tag used to identify related expenses</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Grant</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>optional tag used to identify funding from external resources</font></span></p></td></tr><tr style='height:15.75pt;'><td style='width:110pt; border-top:none; border-left:none; border-bottom:1pt solid rgb(201, 201, 201); border-right:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='147'><p><b><span style='color:black;'>Region</span></b></p></td><td style='width:555pt; border-top:none; border-right:none; border-left:none; border-image:initial; border-bottom:1pt solid rgb(201, 201, 201); background:rgb(237, 237, 237); padding:0in 5.4pt; height:15.75pt;' width='740'><p><span style='color:black;'><font size='4'>council district</font></span></p></td></tr></tbody></table><p><br /></p></div> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "CSV",
"format": "CSV",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/csv?layers=0",
"mediaType": "text/csv"
},
{
"@type": "dcat:Distribution",
"title": "Excel",
"format": "XLSX",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/excel?layers=0",
"mediaType": "application/vnd.ms-excel"
},
{
"@type": "dcat:Distribution",
"title": "Feature Collection",
"format": "TXT",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/featureCollection?layers=0",
"mediaType": "text/plain"
},
{
"@type": "dcat:Distribution",
"title": "File Geodatabase",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/filegdb?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "GeoPackage",
"format": "GPKG",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/geoPackage?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "GeoJSON",
"format": "GeoJSON",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/geojson?layers=0",
"mediaType": "application/vnd.geo+json"
},
{
"@type": "dcat:Distribution",
"title": "KML",
"format": "KML",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/kml?layers=0",
"mediaType": "application/vnd.google-earth.kml+xml"
},
{
"@type": "dcat:Distribution",
"title": "Shapefile",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/shapefile?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "SQLite Geodatabase",
"format": "GDB",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/4d13ea7e6b394fa2b39dbc518176e3d9/sqlite?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS Hub Dataset",
"format": "Web Page",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-expenditures-data-for-fiscal-year-2020-1",
"mediaType": "text/html"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS GeoService",
"format": "ArcGIS GeoServices REST API",
"accessURL": "https://services1.arcgis.com/79kfd2K6fskCAkyg/arcgis/rest/services/eExpenditures_2020/FeatureServer/0",
"mediaType": "application/json"
}
]
|
| identifier | https://www.arcgis.com/home/item.html?id=4d13ea7e6b394fa2b39dbc518176e3d9&sublayer=0 |
| issued | 2023-03-22T15:51:59.000Z |
| keyword |
[
"Expenditure",
"Expenses",
"Fiscal Year",
"Jefferson County",
"Kentucky",
"Louisville",
"Louisville Metro",
"Louisville Metro KY",
"OMB",
"Office of Management and Budget",
"historical"
]
|
| landingPage | https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-expenditures-data-for-fiscal-year-2020-1 |
| license | https://louisville-metro-opendata-lojic.hub.arcgis.com/pages/terms-of-use-and-license |
| modified | 2023-03-24T16:31:12.511Z |
| platform | ArcGIS Hub |
| programCode |
[
"015:001",
"015:002"
]
|
| publisher |
{
"name": "Louisville/Jefferson County Information Consortium"
}
|
| spatial | {{extent:computeSpatialProperty}} |
| summary | Management and Budget ensures financial integrity by directing, coordinating and monitoring all financial functions of Louisville Metro Government. |
| theme |
[
"geospatial"
]
|
| title | Louisville Metro KY - Expenditures Data For Fiscal Year 2020 |
