"citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest"."city_expenditures"

SELECT
    ":id", -- Socrata column ID
    "calendar_year", -- The calendar year portion of the current fiscal year derived from the document creation date. Ex: 2017
    "fiscal_year", -- The span of the accounting fiscal year the document was created. Ex: FY 16/17
    "row_id", -- Unique record identifier that is being used for sorting and grouping purposes.
    "expense_category_name", -- The grouping of expense types into categories on the chart of accounts. Category examples include Personal Services, Other Services, or Commodities.
    "accounting_fiscal_year", -- The accounting fiscal year the document was created. The accounting fiscal year is determined by rules of recognition of liability or revenue and can differ from the budget fiscal year.  The City's fiscal year is from July 1 to June 30.
    "commodity_code", -- The number assigned to a tangible product purchase.
    "payroll_expense_code", -- The number assigned to the type of payroll expense being paid.
    "appropriation_name", -- The type of appropriation of the transaction. These will either be the base operating budget or a capital improvement project.
    "fiscal_month_name", -- The month and period name of the fiscal year in the format of month-period.
    "expense_category_code", -- The number assigned to the category of expense on the chart of accounts.
    "date_12", -- The Date field adjusted so that period 13 information is included as period 12
    "major_program_name", -- A project the City is working on. Generally, a major program is created to capture all of the costs of creating a new or improving an existing asset before the asset is placed in service. Major programs may also track costs related to a grant awarded to the City.
    "sub_activity_name", -- Activities are broken down into sub-activities for reporting and analysis purposes.
    "amount", -- The amount of the transaction.
    "document_id", -- The number assigned to the transaction by the accounting system.
    "document_type_code", -- The number assigned to the type of document the transaction was recorded in the accounting system.
    "fund_name", -- The governmental segment that benefited from the transaction. Examples include Cemetery, Transit and Arts and Culture.
    "vendor_name", -- Name of vendor paid if different than legal name.
    "accounting_period_12", -- The Accounting Period field adjusted so that period 13 information is included as period 12.
    "commodity_name", -- A category of tangible product purchased. Commodity categories are used by the purchasing department for analysis of major expenditures and contract opportunities.
    "accounting_period", -- The accounting period the transaction was recorded. The City's accounting year runs from July 1 to June 30, where July is accounting period 1.
    "date", -- The date of the transaction or when the document was created.
    "core_business_proces_name", -- A collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes.  These include Patrol, Metro, and Criminal Investigations.
    "activity_code", -- The number assigned to the activity the department was engaged in that led to the transaction.
    "major_program_code", -- The number assigned to a project.
    "reporting_code_name", -- A reporting mechanism used to track the expenditures related to a specific event or item.  Examples are shows at the Mesa Arts Center and Park expenses.
    "fiscal_month_name_12", -- The Fiscal Month Name field adjusted so that period 13 information is included as period 12.
    "fund_code", -- The number assigned to the governmental segment that benefited from the transaction.
    "sub_fund_name", -- The breakdown of a fund based on purpose, classification, and other specific characteristics.
    "department_code", -- The number assigned to the department that benefited from the transaction.
    "department_name", -- The department that benefited from the transaction.
    "business_objective_code", -- The number assigned to a major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources.
    "business_objective_name", -- A major line of business that aligns with one or more of the Council's strategic initiatives; denotes a primary public purpose; and defines where the City allocates its resources.  Examples include Fleet Services and Economic Development.
    "service_level_code", -- The number assigned to a group of core business processes related by a common purpose (mission, outcomes, and expected performance).  This level of structure is optional depending on departmental needs.
    "service_level_name", -- A group of core business processes related by a common purpose (mission, outcomes, and expected performance).  This level of structure is optional depending on departmental needs.  Examples include Operations Bureau and Investigations Bureau.
    "core_business_process_code", -- The number assigned to a collection of related programs and services that are designed and managed to achieve a common outcome or set of outcomes.
    "activity_name", -- The activity that the department was engaged in that led to the transaction. Activities are generally recurring activities such as accounting, inspections or planning.
    "sub_activity_code", -- The number assigned to a sub-activity.
    "expense_type_code", -- The number assigned to the expense type on the chart of accounts.
    "expense_type_name", -- A grouping of expenses into types on the chart of accounts. Types are then grouped into categories. Expense type examples include Machinery and Equipment, Infrastructure, and Contractual Services.
    "expense_code", -- The number assigned to the type of expense being paid. In the private sector, this would be called a general ledger account number, however in the government sector, these are most often referred to as object codes.
    "expense_name", -- The type of expense being paid. In the private sector, this would be called a general ledger account, however in the government sector, these are most often referred to as objects. Examples include Payroll, Professional Services or Travel.
    "payroll_expense_name", -- The type of payroll expense being paid. Examples include Salaries, Vacation, or Taxes.
    "legal_name", -- Legal name of the vendor.
    "program_code", -- The number assigned to a program.
    "program_name", -- A program represents a smaller segment of a project the City is working on. For example, renovating a Park would be a major program, installing the bathroom would be a program.
    "phase_name", -- A project is split into phases which generally represent pre-design/design/construction or may be split into purchases (where no construction is involved in the acquisition of the asset).
    "unit_code", -- The number assigned to the organizational unit within the department that benefited from the transaction.
    "unit_name", -- The organizational unit within the department that benefited from the transaction. Examples include Planning, Development Services, Energy Resources, Electric Utility and Gas Utility.
    "reporting_code", -- The number assigned to a reporting mechanism used to track the expenditures related to a specific event or item.  Examples are shows at the Mesa Arts Center and Park expenses.
    "document_type_name", -- The type of document the transaction was recorded in the accounting system.
    "fiscal_month_and_year", -- The Fiscal Year and Fiscal Month formatted as as a date
    "appropriation_code", -- The number assigned to the type of appropriation of the transaction.
    "phase_code", -- The number assigned to a phase of a project.
    "sub_fund_code" -- The numbers assigned for the breakdown of a fund based on purpose, classification, and other specific characteristics.
FROM
    "citydata-mesaaz-gov/city-expenditures-vdg8-dx96:latest"."city_expenditures"
LIMIT 100;

sgr mount socrata \
  "citydata-mesaaz-gov/city-expenditures-vdg8-dx96" \
  --handler-options '{
    "domain": "citydata.mesaaz.gov",
    "tables": {
        "city_expenditures": "vdg8-dx96"
    }
}'